internal_contact


Columns

Column Type Size Nulls Auto Default Children Parents Comments
__id int8 19 √ null
__cf bool 1 true
__start timestamptz 35,6 null
__source varchar 63 null
__origin varchar 63 ''::character varying
ic_id uuid 2147483647 √ null
ic_version int8 19 √ null
ic_role varchar 32 √ null
ic_user_fk uuid 2147483647 √ null
users__t.id internal_contact_ic_user_fk_fkeyR
ic_owner_fk uuid 2147483647 √ null
subscription_agreement.sa_id internal_contact_ic_owner_fk_fkey1R
erm_title_list.id internal_contact_ic_owner_fk_fkeyR

Indexes

Constraint Name Type Sort Column(s)
internal_contact_pkey Primary key Asc __id
internal_contact___origin_idx Performance Asc __origin
internal_contact___source_idx Performance Asc __source
internal_contact___start_idx Performance Asc __start
internal_contact_ic_id_idx Performance Asc ic_id
internal_contact_ic_owner_fk_idx Performance Asc ic_owner_fk
internal_contact_ic_role_idx Performance Asc ic_role
internal_contact_ic_user_fk_idx Performance Asc ic_user_fk
internal_contact_ic_version_idx Performance Asc ic_version

Relationships

Close relationships within degrees of separation