legal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
legal_approver.legal_id FK416A358B3494DAE3 R
legal_note.legal_id FK228AD1B83494DAE3 R
version BIGINT 19 null
attorney_id INT 10 √ null
sys_users.user_id FK62162B9D72362B0 R
law_firm_id INT 10 √ null
sys_companies.company_id FK62162B9EF708433 R
lease_end DATE 10 √ null
managing_attorney_id INT 10 √ null
sys_users.user_id FK62162B9E74672D3 R
old_doc_id INT 10 √ null
paralegal_id INT 10 √ null
sys_users.user_id FK62162B957AFE0D5 R
project_id INT 10 null
project.id FK62162B9FE2B983 R
signer_id INT 10 √ null
sys_users.user_id FK62162B971C12EE4 R
status_id BIGINT 19 null
legal_status.id FK62162B944EE899C R
status_timestamp DATETIME 19 √ null
type_id BIGINT 19 null
legal_type.id FK62162B92A1C51C R
landlord_instructions LONGTEXT 2147483647 √ null
trim VARCHAR 100 √ null
Trans_Type_ID INT 10 √ null
iteration INT 10 null
top BIT 1 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK62162B92A1C51C Performance Asc type_id
FK62162B944EE899C Performance Asc status_id
FK62162B957AFE0D5 Performance Asc paralegal_id
FK62162B971C12EE4 Performance Asc signer_id
FK62162B9D72362B0 Performance Asc attorney_id
FK62162B9E74672D3 Performance Asc managing_attorney_id
FK62162B9EF708433 Performance Asc law_firm_id
FK62162B9FE2B983 Performance Asc project_id
unique_iteration Must be unique Asc/Asc project_id + iteration

Relationships

Close relationships within degrees of separation