Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| turnover_condition | INT | 10 | 0 |
|
|
|||
| space_status | INT | 10 | 0 |
|
|
|||
| loi_signed_green | INT | 10 | 0 |
|
|
|||
| loi_signed_yellow_range_low_ | INT | 10 | 0 |
|
|
|||
| loi_signed_yellow_range_high_ | INT | 10 | 0 |
|
|
|||
| loi_signed_red | INT | 10 | 0 |
|
|
|||
| design_start_requested_green | INT | 10 | 0 |
|
|
|||
| design_start_requested_yellow_range_low_ | INT | 10 | 0 |
|
|
|||
| design_start_requested_yellow_range_high_ | INT | 10 | 0 |
|
|
|||
| design_start_requested_red | INT | 10 | 0 |
|
|
|||
| site_approved_green | INT | 10 | 0 |
|
|
|||
| site_approved_yellow_range_low_ | INT | 10 | 0 |
|
|
|||
| site_approved_yellow_range_high_ | INT | 10 | 0 |
|
|
|||
| site_approved_red | INT | 10 | 0 |
|
|
|||
| fully_executed_legal_doc_green | INT | 10 | 0 |
|
|
|||
| fully_executed_legal_doc_yellow_range_low_ | INT | 10 | 0 |
|
|
|||
| fully_executed_legal_doc_yellow_range_high_ | INT | 10 | 0 |
|
|
|||
| fully_executed_legal_doc_red | INT | 10 | 0 |
|
|
|||
| cds_uploaded_green | INT | 10 | 0 |
|
|
|||
| cds_uploaded_yellow_range_low_ | INT | 10 | 0 |
|
|
|||
| cds_uploaded_yellow_range_high_ | INT | 10 | 0 |
|
|
|||
| cds_uploaded_red | INT | 10 | 0 |
|
|
|||
| construction_permit_submitted_green | INT | 10 | 0 |
|
|
|||
| construction_permit_submitted_yellow_range_low_ | INT | 10 | 0 |
|
|
|||
| construction_permit_submitted_yellow_range_high_ | INT | 10 | 0 |
|
|
|||
| construction_permit_submitted_red | INT | 10 | 0 |
|
|
|||
| construction_permit_approved_green | INT | 10 | 0 |
|
|
|||
| construction_permit_approved_yellow_range_low_ | INT | 10 | 0 |
|
|
|||
| construction_permit_approved_yellow_range_high_ | INT | 10 | 0 |
|
|
|||
| construction_permit_approved | INT | 10 | 0 |
|
|
|||
| dates_locked_green | INT | 10 | 0 |
|
|
|||
| dates_locked_yellow_range_low_ | INT | 10 | 0 |
|
|
|||
| dates_locked_yellow_range_high_ | INT | 10 | 0 |
|
|
|||
| dates_locked_red | INT | 10 | 0 |
|
|
|||
| construction_start_green | INT | 10 | 0 |
|
|
|||
| construction_start_yellow_range_low_ | INT | 10 | 0 |
|
|
|||
| construction_start_yellow_range_high_ | INT | 10 | 0 |
|
|
|||
| construction_start_red | INT | 10 | 0 |
|
|
|||
| construction_end_turnover_green | INT | 10 | 0 |
|
|
|||
| construction_end_turnover_yellow_range_low_ | INT | 10 | 0 |
|
|
|||
| construction_end_turnover_yellow_range_high_ | INT | 10 | 0 |
|
|
|||
| construction_end_turnover_red | INT | 10 | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ix_store_risk_space_status | Performance | Asc | space_status |
| ix_store_risk_turnover_condition | Performance | Asc | turnover_condition |
Relationships
Close relationships within degrees of separation
