dealer_request_lease


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
dealer_request_id INT 10 null
dealer_request.id fk_dealer_request_lease_dealer_request R
created_by_id INT 10 null
sys_users.user_id fk_dealer_request_lease_created_by R
created_at DATETIME 19 null
end_date DATETIME 19 √ null
last_updated_at DATETIME 19 √ null
last_update_by_id INT 10 √ null
lease_expiration_date DATETIME 19 √ null
lease_type TEXT 65535 √ null
leasable_sq_ft DOUBLE 22 √ null
rent_end DOUBLE 22 √ null
rent_start DOUBLE 22 √ null
lease_term_in_years DOUBLE 22 √ null
lease_version TEXT 65535 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fk_dealer_request_lease_created_by_idx Performance Asc created_by_id
fk_dealer_request_lease_dealer_request_idx Performance Asc dealer_request_id

Relationships

Close relationships within degrees of separation