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