srs_snapshot


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
create_date DATETIME 19 null
created_by_id INT 10 null
sys_users.user_id FK_bu8x0jcb9h5wm6fplt8o4jnk7 R
drive_time MEDIUMTEXT 16777215 √ null
file_data MEDIUMTEXT 16777215 √ null
header MEDIUMTEXT 16777215 √ null
meta_data MEDIUMTEXT 16777215 √ null
overview MEDIUMTEXT 16777215 √ null
proximity MEDIUMTEXT 16777215 √ null
srs_report_id BIGINT 19 null
srs_report.id FK_qwfkkw1k7b0vwd4kyunwd13nx R
target_area MEDIUMTEXT 16777215 √ null
executive_summary MEDIUMTEXT 16777215 √ null
store_overview MEDIUMTEXT 16777215 √ null
relocation_store MEDIUMTEXT 16777215 √ null
market_overview MEDIUMTEXT 16777215 √ null
market_details MEDIUMTEXT 16777215 √ null
cor_proximity MEDIUMTEXT 16777215 √ null
comps MEDIUMTEXT 16777215 √ null
existing_store MEDIUMTEXT 16777215 √ null
lease_details MEDIUMTEXT 16777215 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_bu8x0jcb9h5wm6fplt8o4jnk7 Performance Asc created_by_id
FK_qwfkkw1k7b0vwd4kyunwd13nx Performance Asc srs_report_id

Relationships

Close relationships within degrees of separation