subcontractor_user


Columns

Column Type Size Nulls Auto Default Children Parents Comments
subcontractor_id INT 10 null
subcontractor.id FK_iy0fupbnl0mt5brhiee8fltxl R
user_id INT 10 null
sys_users.user_id FK_id3pxl21lxnbwmtuq3odt5uii R
create_date DATETIME 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc subcontractor_id + user_id
FK_id3pxl21lxnbwmtuq3odt5uii Performance Asc user_id

Relationships

Close relationships within degrees of separation