Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| site_id | INT | 10 | 0 |
|
|
|||
| traffic | VARCHAR | 10 | √ | null |
|
|
||
| yoy_traffic | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_traffic_1 | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_traffic_2 | VARCHAR | 10 | √ | null |
|
|
||
| new_ban_acts | VARCHAR | 10 | √ | null |
|
|
||
| yoy_new_ban_acts | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_new_ban_acts_1 | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_new_ban_acts_2 | VARCHAR | 10 | √ | null |
|
|
||
| postpaid_acts | VARCHAR | 10 | √ | null |
|
|
||
| yoy_postpaid_acts | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_postpaid_acts_1 | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_postpaid_acts_2 | VARCHAR | 10 | √ | null |
|
|
||
| aals | VARCHAR | 10 | √ | null |
|
|
||
| yoy_aals | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_aals_1 | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_aals_2 | VARCHAR | 10 | √ | null |
|
|
||
| prepaid_acts | VARCHAR | 10 | √ | null |
|
|
||
| yoy_prepaid_acts | VARCHAR | 20 | √ | null |
|
|
||
| forecasted_prepaid_acts_1 | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_prepaid_acts_2 | VARCHAR | 10 | √ | null |
|
|
||
| upgrades | VARCHAR | 10 | √ | null |
|
|
||
| yoy_upgrades | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_upgrades_1 | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_upgrades_2 | VARCHAR | 10 | √ | null |
|
|
||
| kits | VARCHAR | 10 | √ | null |
|
|
||
| yoy_kits | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_kits_1 | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_kits_2 | VARCHAR | 10 | √ | null |
|
|
||
| precann_5yr_npv | VARCHAR | 20 | √ | null |
|
|
||
| forecasted_precann_5yr_npv_1 | VARCHAR | 20 | √ | null |
|
|
||
| forecasted_precann_5yr_npv_2 | VARCHAR | 20 | √ | null |
|
|
||
| postcann_5yr_npv | VARCHAR | 20 | √ | null |
|
|
||
| forecasted_postcann_5yr_npv_1 | VARCHAR | 20 | √ | null |
|
|
||
| forecasted_postcann_5yr_npv_2 | VARCHAR | 20 | √ | null |
|
|
||
| 5_year_roi | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_5_year_roi_1 | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_5_year_roi_2 | VARCHAR | 10 | √ | null |
|
|
||
| incr_5_year_roi | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_incr_5_year_roi_1 | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_incr_5_year_roi_2 | VARCHAR | 10 | √ | null |
|
|
||
| substitution_coefficient | VARCHAR | 10 | √ | null |
|
|
||
| new_ban_incrementality | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_substitution_coefficient_1 | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_substitution_coefficient_2 | VARCHAR | 10 | √ | null |
|
|
||
| substitution_corp | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_substitution_corp_1 | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_substitution_corp_2 | VARCHAR | 10 | √ | null |
|
|
||
| dma_sopi | VARCHAR | 10 | √ | null |
|
|
||
| dma_sopo | VARCHAR | 10 | √ | null |
|
|
||
| trade_area_sod | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_trade_area_sod_1 | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_trade_area_sod_2 | VARCHAR | 10 | √ | null |
|
|
||
| trade_area_penetration | VARCHAR | 10 | √ | null |
|
|
||
| msa_sod | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_msa_sod_1 | VARCHAR | 10 | √ | null |
|
|
||
| forecasted_msa_sod_2 | VARCHAR | 10 | √ | null |
|
|
||
| new_city_state | VARCHAR | 10 | √ | null |
|
|
||
| ibr_ta_ | VARCHAR | 10 | √ | null |
|
|
||
| ibr_msa_ | VARCHAR | 10 | √ | null |
|
|
||
| incr_pops | VARCHAR | 10 | √ | null |
|
|
||
| psa | VARCHAR | 10 | √ | null |
|
|
||
| newbanperc | VARCHAR | 10 | √ | null |
|
|
||
| primemix | VARCHAR | 10 | √ | null |
|
|
||
| postpremix | VARCHAR | 10 | √ | null |
|
|
||
| avg_post_120_days_deact | VARCHAR | 10 | √ | null |
|
|
||
| customer_base | VARCHAR | 10 | √ | null |
|
|
||
| yoy_conv | VARCHAR | 10 | √ | null |
|
|
||
| yoy_totalacts | VARCHAR | 10 | √ | null |
|
|
||
| yoy_postmix | VARCHAR | 10 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
