company_email


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
program_company_contact.company_email_id FK_fi96eoba65e36aq7qrmdf882w R
program_workflow_participant.company_email_id FK_jll0h8k70vvyma7wkjsoo7ubj R
project_company_contact.company_email_id FKFDAE8938692FF708 R
punch_list_item_recipients_company_email.email_id FKEA9683D152324586 R
workflow_participant.company_email_id FKB87D7EB3692FF708 R
version BIGINT 19 null
company_id INT 10 null
sys_companies.company_id FK5193D95A16D99B31 R
email_address VARCHAR 100 null
notes VARCHAR 300 √ null
label VARCHAR 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK5193D95A16D99B31 Performance Asc company_id

Relationships

Close relationships within degrees of separation