demographic


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 √ null
type VARCHAR 255 √ null
daytime_population INT 10 √ 0
households INT 10 √ 0
household_size_average DECIMAL 19,6 √ 0.000000
median_household_income INT 10 √ 0
percent_asian INT 10 √ 0
percent_bachelor INT 10 √ 0
percent_black INT 10 √ 0
percent_blue_collar INT 10 √ 0
percent_hispanic INT 10 √ 0
percent_white INT 10 √ 0
population INT 10 √ null
population_median_age INT 10 √ 0
percent_subscriber_penetration INT 10 √ null
att_corporate INT 10 √ null
att_dealer INT 10 √ null
tmobile_corporate INT 10 √ null
tmobile_dealer INT 10 √ null
verizon_corporate INT 10 √ null
verizon_dealer INT 10 √ null
uscellular_corporate INT 10 √ null
uscellular_dealer INT 10 √ null
five_year_population INT 10 √ null
postpaid_subscriber INT 10 √ null
lteibr_percent INT 10 √ null
mbtm_corporate INT 10 √ null
mbtm_dealer INT 10 √ null
boost_dealer INT 10 √ null
cricket_dealer INT 10 √ null
mbtm_segmentation_high_index INT 10 √ null
mbtm_segmentation_high_med_index INT 10 √ null
total_wireless INT 10 √ null
site_id INT 10 null
site.id demographic_ibfk_1 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
demographic_uindex Must be unique Asc/Asc site_id + type

Relationships

Close relationships within degrees of separation