granite_master_tracker


Columns

Column Type Size Nulls Auto Default Children Parents Comments
InventoryID VARCHAR 50 √ null
SITEID VARCHAR 50 √ null
LOCATIONNAME VARCHAR 100 √ null
SAP VARCHAR 50 √ null
PARENTACCOUNT INT 10 √ null
BAN INT 10 √ null
SERVICETYPE VARCHAR 50 √ null
ACCESSTYPE VARCHAR 50 √ null
PURPOSE VARCHAR 60 √ null
PRIMARYSECONDARY VARCHAR 50 √ null
UNDERLYINGCARRIER VARCHAR 50 √ null
DOWNLOADSPEED VARCHAR 50 √ null
UPLOADSPEED VARCHAR 50 √ null
CIRCUITID VARCHAR 50 √ null
bandwave.CIRCUITID Implied Constraint R
DID VARCHAR 20 √ null
BILLINGSTARTDATE DATETIME 19 √ null
TERMSTARTDATE DATETIME 19 √ null
TERMENDDATE DATETIME 19 √ null
TERM INT 10 √ null
MRC DECIMAL 28,10 √ null
CIRCUITSTATUS VARCHAR 50 √ null
DEACTIVATEDDATE DATETIME 19 √ null
SCALABLEBANDWIDTH VARCHAR 50 √ null
ADDRESS VARCHAR 67 √ null
CITY VARCHAR 50 √ null
STATE VARCHAR 50 √ null
ZIP VARCHAR 20 √ null

Relationships

Close relationships within degrees of separation