Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| modulecontentid | BIGINT | 19 | 0 |
|
|
|||
| site_id | BIGINT | 19 | 0 |
|
|
|||
| site | VARCHAR | 20 |
|
|
||||
| site_status | VARCHAR | 10 |
|
|
||||
| zone | VARCHAR | 50 |
|
|
||||
| district | VARCHAR | 60 |
|
|
||||
| market | VARCHAR | 50 |
|
|
||||
| region | VARCHAR | 30 |
|
|
||||
| store_number | VARCHAR | 10 |
|
|
||||
| building_id | VARCHAR | 20 |
|
|
||||
| fact_id | INT | 10 | 0 |
|
|
|||
| merger_legacy | VARCHAR | 20 |
|
|
||||
| site_channel | VARCHAR | 30 |
|
|
||||
| store_channel | VARCHAR | 20 |
|
|
||||
| site_open_date | VARCHAR | 20 |
|
|
||||
| retail_store_name | VARCHAR | 60 |
|
|
||||
| t_builder_site_id | INT | 10 | 0 |
|
|
|||
| sap | VARCHAR | 10 |
|
|
||||
| type | VARCHAR | 20 |
|
|
||||
| vendor_id | INT | 10 | 0 |
|
|
|||
| yellow_legacy_association | VARCHAR | 20 |
|
|
||||
| site_sq_feet_leasable | INT | 10 | 0 |
|
|
|||
| date_closed | VARCHAR | 20 |
|
|
||||
| dealer_name | VARCHAR | 40 |
|
|
||||
| location_id | BIGINT | 19 | 0 |
|
|
|||
| location_name | VARCHAR | 90 |
|
|
||||
| crem_id | VARCHAR | 20 |
|
|
||||
| address | VARCHAR | 40 |
|
|
||||
| address_2 | VARCHAR | 50 |
|
|
||||
| city | VARCHAR | 30 |
|
|
||||
| state | VARCHAR | 30 |
|
|
||||
| zip | INT | 10 | 0 |
|
|
|||
| latitude | DECIMAL | 9,6 | 0.000000 |
|
|
|||
| longitude | DECIMAL | 11,6 | 0.000000 |
|
|
|||
| center_type | VARCHAR | 30 |
|
|
||||
| density_class | VARCHAR | 20 |
|
|
||||
| user_owner | VARCHAR | 50 |
|
|
||||
| group_owner | VARCHAR | 40 |
|
|
||||
| location_type | VARCHAR | 30 |
|
|
||||
| location_status | VARCHAR | 20 |
|
|
||||
| position_type | VARCHAR | 20 |
|
|
||||
| yellow_position_type | VARCHAR | 60 |
|
|
||||
| contract_id | BIGINT | 19 | 0 |
|
|
|||
| contract_record_status | VARCHAR | 20 |
|
|
||||
| contract_type | VARCHAR | 20 |
|
|
||||
| contract_subtype | VARCHAR | 30 |
|
|
||||
| user_owner2 | VARCHAR | 50 |
|
|
||||
| expires_date | VARCHAR | 20 |
|
|
||||
| expiration_date_type | VARCHAR | 30 |
|
|
||||
| base_rent | DECIMAL | 9,2 | 0.00 |
|
|
|||
| base_rent_opex | DECIMAL | 9,2 | 0.00 |
|
|
|||
| createddate | VARCHAR | 20 |
|
|
||||
| createdby | VARCHAR | 30 |
|
|
||||
| modifieddate | VARCHAR | 20 |
|
|
||||
| lastmodifiedby | VARCHAR | 30 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ix_ri_lease_expiration_dashboard_sap | Performance | Asc | sap |
| ix_ri_lease_expiration_dashboard_site_id | Performance | Asc | site_id |
| ix_ri_lease_expiration_dashboard_t_builder_site_id | Performance | Asc | t_builder_site_id |
