srs_report


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
sitepack.srs_report_id FK_gqe01ubtu5ix467ackmb37nwb R
srs_lease_renewal.srs_report_id fk_srs_lease_renewal_srs_report_id R
srs_rent_analysis.srs_report_id fk_srs_rent_analysis_srs_report_id R
srs_snapshot.srs_report_id FK_qwfkkw1k7b0vwd4kyunwd13nx R
create_date DATETIME 19 null
created_by_id INT 10 null
sys_users.user_id FK_m1xwes4got6cocoo4v4v1iti9 R
hero_image_id BIGINT 19 √ null
project_file.id FK_g4l61gdmbq4tf9oq9r9c9igo0 R
last_update_by_id INT 10 √ null
sys_users.user_id FK_q3hm3gvudyaxr6tslxnpomsfx R
last_update_date DATETIME 19 null
project_id INT 10 null
project.id FK_qg9vau940gidw6u0fpa7qywgj R
status_id INT 10 null
srs_status.id FK_ij5s9og3ifhk5n8tuh7o1bqic R
executive_summary_id BIGINT 19 √ null
srs_executive_summary.id fk_executive_summary R
market_details_note MEDIUMTEXT 16777215 √ null
net_construction_budget DECIMAL 15,2 √ null
existing_store_note MEDIUMTEXT 16777215 √ null
lease_details_note MEDIUMTEXT 16777215 √ null
renewal_attributes MEDIUMTEXT 16777215 √ null
pdf_request_date DATETIME 23 √ null
pdf_complete_date DATETIME 23 √ null
pdf_generation_status INT 10 √ null
lease_term VARCHAR 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
executive_summary_id Must be unique Asc executive_summary_id
FK_g4l61gdmbq4tf9oq9r9c9igo0 Performance Asc hero_image_id
FK_ij5s9og3ifhk5n8tuh7o1bqic Performance Asc status_id
FK_m1xwes4got6cocoo4v4v1iti9 Performance Asc created_by_id
FK_q3hm3gvudyaxr6tslxnpomsfx Performance Asc last_update_by_id
FK_qg9vau940gidw6u0fpa7qywgj Performance Asc project_id

Relationships

Close relationships within degrees of separation