program_company_contact


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
program_milestone.responsible_company_contact_id FK_6d8hsnvuchj474hq71cu5gj2w R
company_id INT 10 null
sys_companies.company_id FK_55e0cju3q0li25we2oigckine R
company_email_id BIGINT 19 √ null
company_email.id FK_fi96eoba65e36aq7qrmdf882w R
create_date DATETIME 19 null
program_id BIGINT 19 null
program.id FK_cgrc9je8uifh5ge9u15pkv45q R
user_id INT 10 √ null
sys_users.user_id FK_fkdl5pmtlwknr5ndyd7vhtvy0 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_55e0cju3q0li25we2oigckine Performance Asc company_id
FK_cgrc9je8uifh5ge9u15pkv45q Performance Asc program_id
FK_fi96eoba65e36aq7qrmdf882w Performance Asc company_email_id
FK_fkdl5pmtlwknr5ndyd7vhtvy0 Performance Asc user_id

Relationships

Close relationships within degrees of separation