Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| site_id | INT | 10 | 0 |
|
|
|||
| project_iteration | VARCHAR | 255 |
|
|
||||
| sprint_store_ | VARCHAR | 255 |
|
|
||||
| original_sprint_id | VARCHAR | 255 |
|
|
||||
| sprint_id | VARCHAR | 255 |
|
|
||||
| sprint_location_id | VARCHAR | 255 |
|
|
||||
| sprint_legacy_store_ | VARCHAR | 255 |
|
|
||||
| vendor_name | VARCHAR | 255 |
|
|
||||
| sap | VARCHAR | 255 |
|
|
||||
| site_name | VARCHAR | 255 |
|
|
||||
| channel_group | VARCHAR | 255 |
|
|
||||
| project_status | VARCHAR | 255 |
|
|
||||
| on_hold | VARCHAR | 255 |
|
|
||||
| location_type | VARCHAR | 255 |
|
|
||||
| pm | VARCHAR | 255 |
|
|
||||
| address | VARCHAR | 255 |
|
|
||||
| space_ | VARCHAR | 255 |
|
|
||||
| city | VARCHAR | 255 |
|
|
||||
| state | VARCHAR | 255 |
|
|
||||
| zip | VARCHAR | 255 |
|
|
||||
| sign_vendor_pm | VARCHAR | 255 |
|
|
||||
| sign_vendor_notes | VARCHAR | 2000 | √ | null |
|
|
||
| supplementary_signage_installed_scheduled | VARCHAR | 255 |
|
|
||||
| supplementary_signage_installed_complete | VARCHAR | 255 |
|
|
||||
| sign_rendering_sent_to_landlord_scheduled | VARCHAR | 255 |
|
|
||||
| sign_rendering_sent_to_landlord_complete | VARCHAR | 255 |
|
|
||||
| sign_rendering_approved_by_landlord_scheduled | VARCHAR | 255 |
|
|
||||
| sign_rendering_approved_by_landlord_complete | VARCHAR | 255 |
|
|
||||
| sign_permit_submitted_scheduled | VARCHAR | 255 |
|
|
||||
| sign_permit_submitted_complete | VARCHAR | 255 |
|
|
||||
| sign_permit_received_scheduled | VARCHAR | 255 |
|
|
||||
| sign_permit_received_complete | VARCHAR | 255 |
|
|
||||
| signage_installed_scheduled | VARCHAR | 255 |
|
|
||||
| signage_installed_complete | VARCHAR | 255 |
|
|
||||
| awning_install_scheduled | VARCHAR | 255 |
|
|
||||
| awning_install_complete | VARCHAR | 255 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_sign_vendor_reporting_site | Performance | Asc | site_id |
| site_id | Performance | Asc/Asc/Asc | site_id + project_iteration + sprint_id |
Relationships
Close relationships within degrees of separation
