Table Design
CREATE TABLE Entities ( entity_id SERIAL PRIMARY KEY, name VARCHAR(255) NOT NULL, type VARCHAR(50) CHECK (type IN (‘business’, ‘non-profit’, ‘individual’)) NOT NULL, description TEXT, owner_user_id INT REFERENCES Users(user_id), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, is_active BOOLEAN DEFAULT TRUE );