Design Rule Table

Overview

Table for managing design rule information

Table Definition

Logical Name	Physical Name	Column Name	Data Type	Primary Key	Relation	Unique	Nullable	Default Value	Remarks
Design rule	design_rule	id	string	◯					varchar(255)
		project_id	number		project:id
		name	string						UNIQUE with project_id (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 design_rule_unique_name_per_project (project_id, name)
• INDEX design_rule_project_id_deleted_at_idx (project_id, deleted_at)
• INDEX design_rule_project_created_idx (project_id, created_at)

Notes

• name is unique per project_id, not globally unique