subcontractor


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
company_subcontractor.subcontractor_id FK_ssskysfqo2289kpj82xtm2eot R
project_subcontractor.subcontractor_id FK_sghyvbgyv130yk9mlmvqcnmaw R
subcontractor_user.subcontractor_id FK_iy0fupbnl0mt5brhiee8fltxl R
active BIT 1 null
address VARCHAR 50 √ null
address2 VARCHAR 50 √ null
city VARCHAR 30 √ null
email VARCHAR 128 √ null
name VARCHAR 100 null
phone VARCHAR 10 √ null
state VARCHAR 2 √ null
zip VARCHAR 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UK_ifwdj9wdns5q65jdtuslo57ky Must be unique Asc name

Relationships

Close relationships within degrees of separation