gci_all


Columns

Column Type Size Nulls Auto Default Children Parents Comments
record_id INT 10 null
File VARCHAR 50 √ null
t_builder_site_id INT 10 √ null
address VARCHAR 64 √ null
sap VARCHAR 50 √ null
siteid VARCHAR 50 √ null
ban INT 10 √ null
servicetype VARCHAR 50 √ null
purpose VARCHAR 50 √ null
underlyingcarrier VARCHAR 50 √ null
downloadspeed VARCHAR 50 √ null
uploadspeed VARCHAR 50 √ null
circuitid VARCHAR 53 √ null
termstartdate VARCHAR 50 √ null
mac_address VARCHAR 50 √ null
router_modem_model_type VARCHAR 60 √ null
provider_support_phone_number VARCHAR 50 √ null
granite_extract_date VARCHAR 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc record_id

Relationships

Close relationships within degrees of separation