Scraped Code Asset Table

Overview

Junction table linking scraped code to assets

Table Definition

Logical Name	Physical Name	Column Name	Data Type	Primary Key	Relation	Unique	Nullable	Default Value	Remarks
Scraped Code Asset	scraped_code_asset	id	serial	◯
		scraped_code_id	number		scraped_code:id
		asset_id	number		asset:id
		role	string
		node_id	string				◯
		usage_count	number					1
		created_at	datetime
		updated_at	datetime
		deleted_at	datetime				◯

Relations

• scraped_code_id → scraped_code.id
• asset_id → asset.id

Indexes

• PRIMARY KEY (id)
• INDEX scraped_code_asset_scraped_code_id_idx (scraped_code_id)
• INDEX scraped_code_asset_asset_id_idx (asset_id)

Notes

• Timestamp-only audit (no created_by / updated_by / deleted_by columns) per scraped_code_asset.ts