project_subcontractor


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
project_subcontractor_contact.project_subcontractor_id FK_d2g16sj4i2bqkr3kl8y1q639w R
create_date DATETIME 19 null
expiration_date DATE 10 null
expiration_warning_date DATETIME 19 √ null
project_company_id INT 10 null
project_company.id FK_ne7lm0y71ua6buwgwgq6w63ri R
subcontractor_id INT 10 null
subcontractor.id FK_sghyvbgyv130yk9mlmvqcnmaw R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_sghyvbgyv130yk9mlmvqcnmaw Performance Asc subcontractor_id
unique_subcontractor_id Must be unique Asc/Asc project_company_id + subcontractor_id

Relationships

Close relationships within degrees of separation