Project Table

Overview

Table for managing project information

Table Definition

Logical Name	Physical Name	Column Name	Data Type	Primary Key	Relation	Unique	Nullable	Default Value	Remarks
Project Information	project	id	serial	◯
		name	string
		organization_id	number		organization:id
		created_at	datetime
		updated_at	datetime
		deleted_at	datetime				◯
		created_by	string		user:cognito_sub
		updated_by	string		user:cognito_sub
		deleted_by	string		user:cognito_sub		◯
		component_count	number					0
		design_count	number					0

Relations

• organization_id → organization.id
• created_by → user.cognito_sub
• updated_by → user.cognito_sub
• deleted_by → user.cognito_sub
• codebase_index.project_id → project.id
• codebase_rule.project_id → project.id
• code.project_id → project.id

Indexes

• PRIMARY KEY (id)
• INDEX project_organization_id_deleted_at_idx (organization_id, deleted_at)

Notes

• Logical deletion support (deleted_at column)
• Audit log support (created_by, updated_by, deleted_by)
• component_count and design_count default to 0
• Feature-specific state is not stored on project. Des2Code codebase state is stored in the one-to-one codebase_index table, and user-authored codebase context is stored in codebase_rule.