project_file


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
project_file_meta.file_id FK_kop0j7hihho12j38m42gylmul R
project_plg_round.pdf_file_id FK_project_plg_round_pdf R
project_plg_signature.image_id FK_project_plg_signature_image R
srs_rent_analysis.project_file_id fk_srs_rent_analysis_project_file_id R
srs_report.hero_image_id FK_g4l61gdmbq4tf9oq9r9c9igo0 R
workflow.published_file_id FK21BD7BF4C7747A7 R
version BIGINT 19 null
date_created DATETIME 19 √ null
description VARCHAR 255 √ null
file_version INT 10 null
flags INT 10 null
folder_id BIGINT 19 null
project_folder.id FK37FA6AE28DB3D838 R
last_updated DATETIME 19 √ null
name VARCHAR 255 null
type VARCHAR 255 √ null
active_set BIT 1 √ null
file_size BIGINT 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK37FA6AE28DB3D838 Performance Asc folder_id
folder_id Must be unique Asc/Asc folder_id + name
unique_name Must be unique Asc/Asc folder_id + name

Relationships

Close relationships within degrees of separation