Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| cremid | VARCHAR | 20 |
|
|
||||
| spacetype | VARCHAR | 30 |
|
|
||||
| lease_vpleaseid | INT | 10 | 0 |
|
|
|||
| lease_radiusrestrictionyn | VARCHAR | 20 |
|
|
||||
| lease_alterations | TEXT | 65535 | √ | null |
|
|
||
| lease_llconsentrequired | VARCHAR | 20 |
|
|
||||
| lease_interiornonsllconsentrequired | VARCHAR | 20 |
|
|
||||
| lease_interiornonstructuralspendlimit | TEXT | 65535 | √ | null |
|
|
||
| lease_interiornonstructuralaltok | VARCHAR | 20 |
|
|
||||
| lease_externalassignment | VARCHAR | 30 |
|
|
||||
| lease_externalassignmentnote | TEXT | 65535 | √ | null |
|
|
||
| lease_sublease | VARCHAR | 30 |
|
|
||||
| lease_subleasenote | TEXT | 65535 | √ | null |
|
|
||
| lease_assigneesublessee | TEXT | 65535 | √ | null |
|
|
||
| lease_internalassignment | VARCHAR | 30 |
|
|
||||
| lease_internalassignmentnote | TEXT | 65535 | √ | null |
|
|
||
| lease_ongoingcotenancy | VARCHAR | 20 |
|
|
||||
| orginalleasecommencement | DATE | 10 | 0000-00-00 |
|
|
|||
| currentterm | VARCHAR | 40 |
|
|
||||
| originalterm | VARCHAR | 40 |
|
|
||||
| lease_default | TEXT | 65535 | √ | null |
|
|
||
| lease_ttnonmonetarycureperiod | VARCHAR | 20 |
|
|
||||
| lease_exclusivity | VARCHAR | 20 |
|
|
||||
| lease_holdoverprovision | TEXT | 65535 | √ | null |
|
|
||
| holdoverrate | VARCHAR | 20 |
|
|
||||
| lease_percentrentclause | TEXT | 65535 | √ | null |
|
|
||
| excludedfromsalesupload | VARCHAR | 10 |
|
|
||||
| lease_percentrent | VARCHAR | 20 |
|
|
||||
| lease_rightoffirstoffer | VARCHAR | 20 |
|
|
||||
| lease_selfhelp | TEXT | 65535 | √ | null |
|
|
||
| lease_signage | TEXT | 65535 | √ | null |
|
|
||
| lease_signagerights | VARCHAR | 20 |
|
|
||||
| lease_ttmonetarycureperiod | VARCHAR | 20 |
|
|
||||
| lease_antennarights | TEXT | 65535 | √ | null |
|
|
||
| lease_exteriorinstallallowed | VARCHAR | 20 |
|
|
||||
| leaseagreementdate | DATE | 10 | 0000-00-00 |
|
|
|||
| rentcommencementdate | DATE | 10 | 0000-00-00 |
|
|
|||
| lease_canllrequirerelocation | VARCHAR | 20 |
|
|
||||
| lease_surrendercondition | VARCHAR | 20 |
|
|
||||
| righttooffsetrent | VARCHAR | 20 |
|
|
||||
| lease_permitteduse | TEXT | 65535 | √ | null |
|
|
||
| lease_continuousoperationgodark | TEXT | 65535 | √ | null |
|
|
||
| lease_status | VARCHAR | 30 |
|
|
||||
| tenant_legal_name | VARCHAR | 120 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ix_costar_leases_cremid | Performance | Asc | cremid |
| ix_costar_leases_lease_vpleaseid | Performance | Asc | lease_vpleaseid |
Relationships
Close relationships within degrees of separation
