costar_key_leases


Columns

Column Type Size Nulls Auto Default Children Parents Comments
crem_id VARCHAR 50
t_dma.ID Implied Constraint R
t_builder_site_id VARCHAR 30
sap_hr_number VARCHAR 80
center_name VARCHAR 90
lease_rentable_area_in_sf DECIMAL 9,2 0.00
current_lease_expiration_date DATETIME 19 0000-00-00 00:00:00
ach_electronic_payment VARCHAR 40
go_dark VARCHAR 40
go_dark_ll_right_to_terminate VARCHAR 40
surrendercondition VARCHAR 40
surrenderclause TEXT 65535 √ null
spacesubtype VARCHAR 30
costar_region VARCHAR 40
ca_amount_owed DECIMAL 11,4 0.0000
ca_total_paid_to_date DECIMAL 21,14 0.00000000000000
ca_reimb_payment_date DATETIME 19 0000-00-00 00:00:00
ca_remaining_balance DECIMAL 21,14 0.00000000000000
ca_sunset_date DATETIME 19 0000-00-00 00:00:00
ca_first_invoice_date DATETIME 19 0000-00-00 00:00:00
current_lease_commencement_date DATETIME 19 0000-00-00 00:00:00
rent_commencement_date DATETIME 19 0000-00-00 00:00:00
ca_tia_type VARCHAR 50
ca_latest_follow_up_date DATETIME 19 0000-00-00 00:00:00
ca_status VARCHAR 40
ca_tia_type_other TEXT 65535 √ null
ca_construction_allowance_clause TEXT 65535 √ null
forced_relocation VARCHAR 40
assignment_rights TEXT 65535 √ null
external_assignement VARCHAR 50
permitted_use_clause TEXT 65535 √ null
right_of_first_offer_or_refusal VARCHAR 40
ongoing_co_tenancy VARCHAR 40
exclusivity VARCHAR 40
holdover_rate VARCHAR 40

Indexes

Constraint Name Type Sort Column(s)
ix_costar_key_leases_crem_id Performance Asc crem_id
ix_costar_key_leases_t_builder_site_id Performance Asc t_builder_site_id

Relationships

Close relationships within degrees of separation