Asset Table

Overview

Table for managing asset (media file) information

Table Definition

Logical Name	Physical Name	Column Name	Data Type	Primary Key	Relation	Unique	Nullable	Default Value	Remarks
Asset Information	asset	id	serial	◯
		project_id	number		project:id
		hash	string
		type	string
		mime_type	string
		media_url	string
		file_size	number
		width	number				◯
		height	number				◯
		original_url	string				◯
		created_at	datetime
		updated_at	datetime
		deleted_at	datetime				◯

Relations

• project_id → project.id

Indexes

• PRIMARY KEY (id)
• INDEX asset_project_id_deleted_at_idx (project_id, deleted_at)

Notes

• Audit fields are timestamps only (created_at / updated_at / deleted_at), not created_by style, per asset.ts