v_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
citystatus VARCHAR 3
incpopscurrent DECIMAL 8,1 0.0
IPGroup VARCHAR 9
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
countofattcorp BINARY 0 √ null
countofattdeal BINARY 0 √ null
countofusccorp BINARY 0 √ null
countofuscdeal BINARY 0 √ null
countofvzcorp BINARY 0 √ null
countofvzdeal BINARY 0 √ null
countofmetrocorp BINARY 0 √ null
countofmetrodeal BINARY 0 √ null
countofboost BINARY 0 √ null
countofcricket BINARY 0 √ null
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 TEXT 65535 √ 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
dateavailable DATE 10 0000-00-00
datesitesubmitted DATE 10 0000-00-00
dayssinceavailable INT 10 0
Projected Network Approval VARCHAR 16 √ null
broker VARCHAR 80 √ null
Last Site Ride VARCHAR 10 √ null
Market Kick Off Meeting Complete VARCHAR 10 √ null
Notes TEXT 65535 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views