project_contact

0 rows

Description

Linking project(s) to contact(s)

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

project_contact_id

serial

10

√

nextval('project_contact_project_contact_id_seq'::regclass)

project_id

int4

10

null

project.project_id

project_contact_project_id_fkey

C

contact_id

int4

10

null

contact.contact_id

project_contact_contact_id_fkey

C

Indexes

Constraint Name	Type	Sort	Column(s)
project_contact_pkey	Primary key	Asc	project_contact_id
project_contact_c1	Must be unique	Asc/Asc	project_id + contact_id
project_contact_idx1	Performance	Asc	project_id
project_contact_idx2	Performance	Asc	contact_id

Relationships

Close relationships within degrees of separation