Wireframe Table

Overview

Table for managing wireframe information

Table Definition

Logical Name	Physical Name	Column Name	Data Type	Primary Key	Relation	Unique	Nullable	Default Value	Remarks
Wireframe	wireframe	id	string	◯					varchar(255)
		project_id	number		project:id
		name	string
		type	enum						content_type (same as design)
		based_on	enum						same enum as design.based_on; here the column is named based_on
		image_url	string
		json_schema_url	string
		status	enum					'0'	design_status
		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 reference user.cognito_sub

Indexes

• PRIMARY KEY (id)
• INDEX wireframe_project_id_deleted_at_idx (project_id, deleted_at)
• INDEX wireframe_project_created_idx (project_id, created_at)

Notes

• Enums and defaults match wireframe / design in packages/models/postgresql/