targetarea


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 0
siteid VARCHAR 10
sap VARCHAR 10
targetareaname VARCHAR 60
lte_ibr_thresholds VARCHAR 10
statusname VARCHAR 30
statusrename VARCHAR 30
previousstatusrename VARCHAR 30
statusrechange VARCHAR 10
networktimingmonth VARCHAR 10
networktimingyear VARCHAR 10
channelgroupname VARCHAR 30
adddate VARCHAR 20 0000-00-00 00:00:00
cityname VARCHAR 70
state VARCHAR 10
sremname VARCHAR 20
engineeringregion VARCHAR 20
Org0 VARCHAR 35 √ null
Org1 VARCHAR 35 √ null
Org2 VARCHAR 70 √ null
dmaid INT 10 0
dma.ID Implied Constraint R
dmaname VARCHAR 40
msaid INT 10 0
msa_demographic.msaid Implied Constraint R
msaname VARCHAR 60
tradeareadensity VARCHAR 255
citycode INT 10 0
citystatustmobile VARCHAR 25 0
incpopscurrent DECIMAL 8,1 0.0
newbaninc DECIMAL 4,2 0.00
traffic INT 10 0
kits INT 10 0
newbanactivations INT 10 0
addaline INT 10 0
postpaid INT 10 0
prepaid INT 10 0
upgrade INT 10 0
fivey_npv INT 10 0
inc_5y_npv INT 10 0
subscriberpostpaidpenetration DECIMAL 4,2 0.00
shareofstores DECIMAL 4,2 0.00
pop_prim INT 10 0
pop_sec INT 10 0
pop_tert INT 10 0
medhhinc_prim DECIMAL 18,12 0.000000000000
medhhinc_sec DECIMAL 18,12 0.000000000000
medhhinc_tert DECIMAL 18,12 0.000000000000
ibr_prim VARCHAR 30
ibr_tert VARCHAR 30
ibr_msa VARCHAR 30
closestattcorpdistanceinmiles VARCHAR 30
closestattdealdistanceinmiles VARCHAR 30
closestusccorpdistanceinmiles VARCHAR 30
closestuscdealdistanceinmiles VARCHAR 30
closestvzcorpdistanceinmiles VARCHAR 30
closestvzdealdistanceinmiles VARCHAR 30
closestboostdistanceinmiles VARCHAR 30
closestcricketdistanceinmiles VARCHAR 30
sremcomments LONGTEXT 2147483647 √ null
weektoweekstatusrechange VARCHAR 50
transactiontype VARCHAR 150 √ null
projectedopendate VARCHAR 20
latitude DECIMAL 9,6 0.000000
longitude DECIMAL 11,6 0.000000
stmname VARCHAR 20 null
malltype VARCHAR 30
brandname VARCHAR 20
statusrelastchange VARCHAR 30
statusreageindays VARCHAR 10
ntm_version_date VARCHAR 20
icsne_currcov VARCHAR 20
icsne_desktopgo VARCHAR 10
icsne_ibr1_prim VARCHAR 10
icsne_ibr1_ter VARCHAR 10
icsne_msaibr1pct VARCHAR 100 null
blockgroupid VARCHAR 20 0
contractholdername VARCHAR 40
countyname VARCHAR 30
engineeringmarket VARCHAR 140 √ null
networknotere VARCHAR 80
previousstatusname VARCHAR 30
statuschange VARCHAR 10
statusid INT 10 0
attcorpprim INT 10 0
attdealprim INT 10 0
vzcorpprim INT 10 0
vzdealprim INT 10 0
usccorpprim INT 10 0
uscdealprim INT 10 0
cricketprim INT 10 0
boostprim INT 10 0
weektoweekstatuschange VARCHAR 60
markettype VARCHAR 60 √ null
targetareatype VARCHAR 250 null
firstfilledtmobilesiteincity INT 10 0
regionalapproval VARCHAR 20 null
regionalapprovaldate VARCHAR 20 null
ntmcoveredpop_tertiary INT 10 null
recommendeddistrict VARCHAR 50 √ null
densityclass VARCHAR 20 √ null
markettypename VARCHAR 60 √ null
closestbestbuydistanceinmiles DECIMAL 20,18 √ null
closestcostcodistanceinmiles DECIMAL 20,18 √ null
closesttargetdistanceinmiles DECIMAL 20,18 √ null
closestwalmartdistanceinmiles VARCHAR 30 √ null
bestbuyprim INT 10 √ null
costcoprim INT 10 √ null
targetprim INT 10 √ null
walmartprim INT 10 √ null
channelgrouplastchange VARCHAR 30 √ null
previouschannelgroupname VARCHAR 30 √ null
reasonfordead VARCHAR 30 √ null
percentbluecollar DECIMAL 13,11 √ null
percenthispanic VARCHAR 20 √ null
dateavailable DATE 10 0000-00-00
datesitesubmitted DATE 10 0000-00-00
dayssinceavailable INT 10 0
citystatusmbtm VARCHAR 20 √ null
firstfilledmbtmsiteincity VARCHAR 20 √ null
lastsiteride DATE 10 √ null

Indexes

Constraint Name Type Sort Column(s)
id Performance Asc/Asc/Asc/Asc id + siteid + sap + targetareaname
idx_channelgroupname Performance Asc channelgroupname

Relationships

Close relationships within degrees of separation