submission_location_contact_xref

-1 rows


Description

Identifies the multiple addresses for a given client, as well as the many contacts that may belong to a given address.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
submission_location_id int4 10 null
submission_location.submission_location_id submission_location_id_fk R

Incremental id generated for a location of a client.
submission_contact_id int4 10 null
submission_contact.submission_contact_id submission_contact_id_fk R

Incremental id generated for the contact details of a client.

Indexes

Constraint Name Type Sort Column(s)
submission_location_contact_xref_id_pk Primary key Asc/Asc submission_location_id + submission_contact_id

Relationships

Close relationships within degrees of separation