Structure Table

Overview

Table for managing structure information

Table Definition

Logical Name	Physical Name	Column Name	Data Type	Primary Key	Relation	Unique	Nullable	Default Value	Remarks
Structure	structure	id	string	◯					varchar(255)
		project_id	number		project:id
		name	string						unique per project (see below)
		file_url	string
		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		◯

Relations

• project_id → project.id
• Audit fields use user.cognito_sub

Indexes

• PRIMARY KEY (id)
• UNIQUE structure_unique_name_per_project (project_id, name)
• INDEX structure_project_id_deleted_at_idx (project_id, deleted_at)
• INDEX structure_project_created_idx (project_id, created_at)

Notes

• name is unique per project_id