blockgroup_model_forecast


Columns

Column Type Size Nulls Auto Default Children Parents Comments
forecast_scenario VARCHAR 50
block_group_id VARCHAR 50
t_dma.ID Implied Constraint R
accessories_sale_cnt DECIMAL 14,11 0.00000000000
exit_traffic DECIMAL 17,9 0.000000000
post_mint_aal DECIMAL 13,10 0.0000000000
post_mint_newban DECIMAL 15,12 0.000000000000
post_voice_aal_prime DECIMAL 16,13 0.0000000000000
post_voice_aal_subprime DECIMAL 16,13 0.0000000000000
post_voice_aal_tfb VARCHAR 50
post_voice_newban_prime DECIMAL 15,12 0.000000000000
post_voice_newban_subprime DECIMAL 15,13 0.0000000000000
post_voice_newban_tfb DECIMAL 14,11 0.00000000000
pre_act VARCHAR 50
pre_refill VARCHAR 50
upgrades DECIMAL 16,13 0.0000000000000
substitution_coefficient VARCHAR 50
npv DECIMAL 17,9 0.000000000
inc_npv DECIMAL 27,11 0.00000000000
roi VARCHAR 50
inc_roi VARCHAR 50
primary_covered_pop INT 10 0
secondary_covered_pop BIGINT 19 0
tertiary_covered_pop BIGINT 19 0
incremental_pop_tertiary INT 10 0
pipedatetimerun VARCHAR 50
add_a_line DECIMAL 8,4 √ null
new_ban_acts DECIMAL 8,4 √ null
postpaid DECIMAL 8,4 √ null
activations DECIMAL 8,4 √ null
kits DECIMAL 8,4 √ null

Indexes

Constraint Name Type Sort Column(s)
ix_blockgroup_model_forecast_block_group_id Performance Asc block_group_id

Relationships

Close relationships within degrees of separation