Scraped Code Table

Overview

Table for managing scraped code information

Table Definition

Logical Name	Physical Name	Column Name	Data Type	Primary Key	Relation	Unique	Nullable	Default Value	Remarks
Scraped Code Information	scraped_code	id	serial	◯
		project_id	number		project:id
		source_code	string
		css_code	string				◯		CSS may not exist
		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
• created_by → user.cognito_sub
• updated_by → user.cognito_sub
• deleted_by → user.cognito_sub

Indexes

• PRIMARY KEY (id)
• INDEX scraped_code_project_id_deleted_at_idx (project_id, deleted_at)
• INDEX scraped_code_project_created_idx (project_id, created_at)

Notes

• source_code is text in the schema
• css_code is optional (nullable)