site_temp_closure


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
archived BIT 1 null
archived_date DATETIME 19 √ null
comment TEXT 65535 √ null
create_date DATETIME 19 null
end_date DATE 10 null
last_update_date DATETIME 19 null
reason_id BIGINT 19 null
temp_closure_reason.id FK_gsp6th0enpejy9kkjwm7b56us R
replenishment VARCHAR 64 √ null
request_id VARCHAR 20 √ null
reroute_to_stores TEXT 65535 √ null
site_id INT 10 null
site.id FK_rah6hfp1ceaq9two3soq6rqgl R
start_date DATE 10 null
status_id INT 10 null
temp_closure_status.id FK_pfgcbp0rthgrvshw0xkbr3mil R
store_id VARCHAR 20 √ null
transit_inventory VARCHAR 64 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_gsp6th0enpejy9kkjwm7b56us Performance Asc reason_id
FK_pfgcbp0rthgrvshw0xkbr3mil Performance Asc status_id
ix_stc_request_id Performance Asc request_id
ix_stc_site Performance Asc site_id

Relationships

Close relationships within degrees of separation