Contact

contact_record

Each row of contact_record identifies a specific contact record.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

code

varchar

false

A unique identifier for the contact.

is_suppressed

boolean

false

Specifies whether the record is suppressed from public display.

contact_record_address_type

Each row of contact_record_address_type identifies a contact record address type.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

code

char

false

Code that disambiguates the field group tag.

contact_view

Each row of contact_view includes metadata and data for one contact record for electronic resources.

Column

Data Type

Not NULL?

Comment

id

bigint

false

System-generated sequential ID.

record_id

bigint

false

Foreign key to record.

record_type_code

char

false

Record type code, i.e., 't'.

record_num

int

false

Record number.

code

varchar

false

A unique identifier for the contact.

record_creation_date_gmt

timestamptz

false

Record creation date.

is_suppressed

boolean

false

Specifies whether the record is suppressed from public display.