Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| lease_abstract_id | INT | 10 | 0 |
|
|
|||
| rem_id | VARCHAR | 40 |
|
|
||||
| lease_status | VARCHAR | 30 |
|
|
||||
| sales_region | VARCHAR | 150 | √ | null |
|
|
||
| retail_area | VARCHAR | 50 | √ | null |
|
|
||
| retail_location_type | VARCHAR | 20 |
|
|
||||
| spacetype | VARCHAR | 20 |
|
|
||||
| commonteamid | INT | 10 | 0 |
|
|
|||
| companyname | VARCHAR | 160 |
|
|
||||
| commonrole | VARCHAR | 30 |
|
|
||||
| attentionto | VARCHAR | 100 |
|
|
||||
| commonteamemail | VARCHAR | 250 | null |
|
|
|||
| commonaddressaddress_1 | VARCHAR | 60 |
|
|
||||
| commonaddressaddress_2 | VARCHAR | 60 |
|
|
||||
| commonaddresscity | VARCHAR | 50 | null |
|
|
|||
| commonaddressstateprov | VARCHAR | 30 | null |
|
|
|||
| commonaddresspostal | VARCHAR | 20 |
|
|
||||
| contactphone1 | VARCHAR | 40 |
|
|
||||
| phone1type | VARCHAR | 20 |
|
|
||||
| contactphone2 | VARCHAR | 100 | √ | null |
|
|
||
| phone2type | VARCHAR | 20 |
|
|
Relationships
Close relationships within degrees of separation
