Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| location_id | INT | 10 | 0 |
|
|
|||
| expires_date | VARCHAR | 30 |
|
|
||||
| base_rent | DECIMAL | 7,2 | 0.00 |
|
|
|||
| base_rent_opex | DECIMAL | 7,2 | 0.00 |
|
|
|||
| next_renewal_option_notice_date | VARCHAR | 30 |
|
|
||||
| base_rent_psf_current_ | VARCHAR | 30 |
|
|
||||
| nnn_psf_current | VARCHAR | 30 |
|
|
||||
| site_sq_feet_leasable | VARCHAR | 20 |
|
|
||||
| _of_renewals | INT | 10 | 0 |
|
|
|||
| renewal_option_term_years | VARCHAR | 20 |
|
|
||||
| electronic_signature_language | VARCHAR | 30 |
|
|
||||
| go_dark | VARCHAR | 20 |
|
|
||||
| option_base_rent_psf | VARCHAR | 30 |
|
|
||||
| option_base_rent_monthly | VARCHAR | 30 |
|
|
||||
| option_base_rent_annual | VARCHAR | 30 |
|
|
||||
| non_base_rent_saving | VARCHAR | 30 |
|
|
||||
| exercise_option | VARCHAR | 20 |
|
|
||||
| skip_legal_ | VARCHAR | 20 |
|
|
||||
| base_lease_term | VARCHAR | 30 |
|
|
||||
| lease_start | VARCHAR | 30 |
|
|
||||
| new_lease_end | VARCHAR | 30 |
|
|
||||
| base_rent_psf_new_ | VARCHAR | 20 |
|
|
||||
| base_rent_annual_new_ | VARCHAR | 30 |
|
|
||||
| base_rent_monthly_new_ | VARCHAR | 30 |
|
|
||||
| additional_base_rent_details_new_ | VARCHAR | 150 | √ | null |
|
|
||
| nnn_psf_new | VARCHAR | 30 |
|
|
||||
| lease_value | VARCHAR | 30 |
|
|
||||
| options | VARCHAR | 100 |
|
|
||||
| option_rent | VARCHAR | 100 |
|
|
||||
| termination_right | VARCHAR | 120 | √ | null |
|
|
||
| vacany_rate | VARCHAR | 30 |
|
|
||||
| mva_range | VARCHAR | 50 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_sprint_lease_end_locationId | Performance | Asc | location_id |
Relationships
Close relationships within degrees of separation
