oats_person_org_addresses

-1 rows


Description

A PERSON ORGANIZATION ADDRESS is the intersection of a PERSON_ORGANIZATION and an ADDRESS.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
person_organization_id int8 19 null
oats_person_organizations.person_organization_id oats_pad_pog_fk R

PERSON ORGANIZATION ID is the system generated unique identifier for PERSON ORGANIZATION.
address_id int8 19 null
oats_addresses.address_id oats_pad_adr_fk R

ADDRESS ID is the system generated unique identifier for ADDRESS
address_type_cd varchar 10 null
oats_address_types.address_type_cd oats_pad_atp_fk R

ADDRESS TYPE CD is the unique identifier for ADDRESS TYPE
who_created varchar 32 null

WHO CREATED is the IDIR or Oracle userid of the person who created the record.
when_created timestamp 29,6 null

WHEN CREATED is the date/time that the record was created.
who_updated varchar 32 √ null

WHO UPDATED is the IDIR or Oracle userid of the person who updated the record.
when_updated timestamp 29,6 √ null

WHEN UPDATED is the date/time that the record was updated.
revision_count int8 19 0

REVISION COUNT is used by Hibernate to control optimistic locking

Indexes

Constraint Name Type Sort Column(s)
oats_person_org_addresses_pkey Primary key Asc/Asc person_organization_id + address_id
oats_pad_adr_fk_i Performance Asc address_id
oats_pad_atp_fk_i Performance Asc address_type_cd
oats_pad_pog_fk_i Performance Asc person_organization_id
oats_pad_sk1_i Performance Asc/Asc person_organization_id + address_type_cd

Relationships

Close relationships within degrees of separation