User Table

Overview

Table for managing user information

Table Definition

Logical Name	Physical Name	Column Name	Data Type	Primary Key	Relation	Unique	Nullable	Default Value	Remarks
User Information	user	id	serial	◯
		cognito_sub	string						Use Cognito sub as is
		organization_id	number		organization:id
		name	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

• organization_id → organization.id
• created_by → user.cognito_sub
• updated_by → user.cognito_sub
• deleted_by → user.cognito_sub

Indexes

• PRIMARY KEY (id)
• UNIQUE INDEX user_cognito_sub_active_idx on (cognito_sub) WHERE deleted_at IS NULL
• INDEX user_organization_id_deleted_at_idx (organization_id, deleted_at)

Notes

• cognito_sub uses Cognito sub as is
• Logical deletion support (deleted_at column)
• Audit log support (created_by, updated_by, deleted_by)