Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| store | VARCHAR | 50 |
|
|
||||
| start_date | VARCHAR | 20 |
|
|
||||
| end_date | VARCHAR | 20 |
|
|
||||
| reason | VARCHAR | 30 |
|
|
||||
| reason_sub_reason | VARCHAR | 90 |
|
|
||||
| days_impacted | DECIMAL | 6,2 | 0.00 |
|
|
|||
| store_request_detail_created_date | VARCHAR | 20 |
|
|
||||
| store_request_detail_created_by | VARCHAR | 30 |
|
|
||||
| comment | VARCHAR | 110 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ix_tmp_closure_comments_store | Performance | Asc | store |
Relationships
Close relationships within degrees of separation
