Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Area | VARCHAR | 60 | √ | null |
|
|
||
| Region | VARCHAR | 60 | √ | null |
|
|
||
| VPGM | VARCHAR | 41 | √ | null |
|
|
||
| District | VARCHAR | 60 | √ | null |
|
|
||
| name | VARCHAR | 50 | √ | null |
|
|
||
| transaction_type | VARCHAR | 50 | √ | null |
|
|
||
| received_cap_index | INT | 10 | √ | null |
|
|
||
| address | VARCHAR | 70 | √ | null |
|
|
||
| address2 | VARCHAR | 35 | √ | null |
|
|
||
| city | VARCHAR | 30 | √ | null |
|
|
||
| state | CHAR | 2 | √ | null |
|
|
||
| zip | VARCHAR | 10 | √ | null |
|
|
||
| sap | VARCHAR | 4 | √ | null |
|
|
||
| company_code | VARCHAR | 7 | √ | null |
|
|
||
| sqft | INT | 10 | √ | null |
|
|
||
| Site Approved | DATE | 10 | √ | null |
|
|
||
| Site Survey | DATE | 10 | √ | null |
|
|
||
| Design Complete | DATE | 10 | √ | null |
|
|
||
| Drawings/MEPs/CDs Complete | DATE | 10 | √ | null |
|
|
||
| Permit Subd | DATE | 10 | √ | null |
|
|
||
| Permit Recd | DATE | 10 | √ | null |
|
|
||
| Recd Possession | DATE | 10 | √ | null |
|
|
||
| DRE | VARCHAR | 41 | √ | null |
|
|
||
| Counsel | VARCHAR | 41 | √ | null |
|
|
||
| PM | VARCHAR | 41 | √ | null |
|
|
||
| location_type | VARCHAR | 50 | √ | null |
|
|
||
| Turnover Condition | VARCHAR | 50 | √ | null |
|
|
||
| Status of Space Delivered | VARCHAR | 50 | √ | null |
|
|
||
| Rent Commencement | VARCHAR | 50 | √ | null |
|
|
||
| Construction Start | DATE | 10 | √ | null |
|
|
||
| Construction Complete | DATE | 10 | √ | null |
|
|
||
| Proj Open | DATE | 10 | null |
|
|
|||
| REM ID | VARCHAR | 50 | √ | null |
|
|
||
| channel_code | VARCHAR | 5 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
