Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| site_id | INT | 10 | 0 |
|
|
|||
| sap | VARCHAR | 10 |
|
|
||||
| channel | VARCHAR | 20 |
|
|
||||
| status | VARCHAR | 20 |
|
|
||||
| open_date | VARCHAR | 20 |
|
|
||||
| density_class | VARCHAR | 20 |
|
|
||||
| region | VARCHAR | 20 |
|
|
||||
| market | VARCHAR | 40 |
|
|
||||
| district | VARCHAR | 150 | √ | null |
|
|
||
| master_dealer | VARCHAR | 50 |
|
|
||||
| name | VARCHAR | 60 |
|
|
||||
| address | VARCHAR | 40 |
|
|
||||
| city | VARCHAR | 30 |
|
|
||||
| state | VARCHAR | 30 |
|
|
||||
| location_type | VARCHAR | 20 |
|
|
||||
| site_design | VARCHAR | 30 |
|
|
||||
| capex_budget | VARCHAR | 20 |
|
|
||||
| tia | VARCHAR | 20 |
|
|
||||
| sq_feet_total_space_ | INT | 10 | 0 |
|
|
|||
| sq_feet_retail_space_ | INT | 10 | 0 |
|
|
|||
| new_city_state | VARCHAR | 10 |
|
|
||||
| msa_id | INT | 10 | 0 |
|
|
|||
| msa | VARCHAR | 60 |
|
|
||||
| dma_id | INT | 10 | 0 |
|
|
|||
| dma | VARCHAR | 40 |
|
|
||||
| msa_penetration | VARCHAR | 20 | null |
|
|
|||
| VARCHAR | 20 | null |
|
|
||||
| sopi | VARCHAR | 20 | null |
|
|
|||
| ibr_ta_ | VARCHAR | 20 | null |
|
|
|||
| ibr_msa_ | VARCHAR | 20 | null |
|
|
|||
| incr_pops | VARCHAR | 20 |
|
|
||||
| new_ban_incrementality | VARCHAR | 20 | null |
|
|
|||
| new_ban_absorption | VARCHAR | 20 | null |
|
|
|||
| pre_cann_5yr_npv | VARCHAR | 20 |
|
|
||||
| post_cann_5yr_npv | VARCHAR | 20 |
|
|
||||
| kits | VARCHAR | 20 | null |
|
|
|||
| new_ban_activations | VARCHAR | 20 | null |
|
|
|||
| traffic | VARCHAR | 20 | null |
|
|
|||
| upgrade | VARCHAR | 20 | null |
|
|
|||
| psa | VARCHAR | 20 | null |
|
|
|||
| prepaid | VARCHAR | 20 | null |
|
|
|||
| postact | VARCHAR | 20 | null |
|
|
|||
| aal | VARCHAR | 20 | null |
|
|
|||
| newbanperc | VARCHAR | 20 | null |
|
|
|||
| primemix | VARCHAR | 20 | null |
|
|
|||
| postpremix | VARCHAR | 20 | null |
|
|
|||
| avg_post_120_days_deact | VARCHAR | 20 | null |
|
|
|||
| customer_base | VARCHAR | 10 |
|
|
||||
| yoy_kits | VARCHAR | 20 |
|
|
||||
| yoy_conv | VARCHAR | 20 | null |
|
|
|||
| yoy_traf | VARCHAR | 20 |
|
|
||||
| yoy_totalacts | VARCHAR | 20 |
|
|
||||
| yoy_postmix | VARCHAR | 20 | null |
|
|
|||
| yoy_postact | VARCHAR | 20 |
|
|
||||
| yoy_preact | VARCHAR | 20 |
|
|
||||
| yoy_newbanpostacts | VARCHAR | 20 |
|
|
||||
| post_cann_5yr_npv_corp_only | VARCHAR | 20 | √ | null |
|
|
||
| site_id2 | INT | 10 | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | site_id |
Relationships
Close relationships within degrees of separation
