program_contact


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
program_milestone.responsible_contact_id FK_abprjpuypqei0is6se1r1aax7 R
contact_id INT 10 null
contact.contact_id FK_2vwx63nnxwnp3ssltp4oe1yux R
program_id BIGINT 19 null
program.id FK_26ighsholsf7srl5snt2iai69 R
role_id INT 10 √ null
sys_roles.role_id FK_hddn1f92odeu2yyka6rdjdscg R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_26ighsholsf7srl5snt2iai69 Performance Asc program_id
FK_2vwx63nnxwnp3ssltp4oe1yux Performance Asc contact_id
FK_hddn1f92odeu2yyka6rdjdscg Performance Asc role_id

Relationships

Close relationships within degrees of separation