project_company_contact


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
company_id INT 10 null
sys_companies.company_id FKFDAE893816D99B31 R
company_email_id BIGINT 19 √ null
company_email.id FKFDAE8938692FF708 R
create_date DATETIME 19 null
notifications_enabled BIT 1 null
project_id INT 10 null
project.id FKFDAE8938FE2B983 R
user_id INT 10 √ null
sys_users.user_id FKFDAE893828C762A3 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FKFDAE893816D99B31 Performance Asc company_id
FKFDAE893828C762A3 Performance Asc user_id
FKFDAE8938692FF708 Performance Asc company_email_id
FKFDAE8938FE2B983 Performance Asc project_id

Relationships

Close relationships within degrees of separation