costar_key_leases_unfiltered


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 40
sap_hr_number VARCHAR 160 √ null
center_name VARCHAR 160
lease_rentable_area_in_sf DECIMAL 10,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 50
costar_region VARCHAR 40
ca_amount_owed DECIMAL 13,4 0.0000
ca_total_paid_to_date DECIMAL 23,14 0.00000000000000
ca_reimb_payment_date DATETIME 19 0000-00-00 00:00:00
ca_remaining_balance DECIMAL 22,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
lease_status VARCHAR 40
final_renewal_option_notice_date DATETIME 19 √ 0000-00-00 00:00:00

Indexes

Constraint Name Type Sort Column(s)
ix_costar_key_leases_unfiltered_crem_id Performance Asc crem_id
ix_costar_key_leases_unfiltered_t_builder_site_id Performance Asc t_builder_site_id

Relationships

Close relationships within degrees of separation