subscription_agreement_org


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
sao_id uuid 2147483647 null
subscription_agreement_org_role.saor_owner_fk subscription_agreement_org_role_saor_owner_fk_fkeyR
sao_version int8 19 √ null
sao_org_fk uuid 2147483647 √ null
org.org_id subscription_agreement_org_sao_org_fk_fkeyR
sao_owner_fk uuid 2147483647 √ null
subscription_agreement.sa_id subscription_agreement_org_sao_owner_fk_fkey1R
erm_title_list.id subscription_agreement_org_sao_owner_fk_fkeyR
sao_note varchar 1 √ null
sao_primary_org bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
subscription_agreement_org_pkey Primary key Asc sao_id
subscription_agreement_org___origin_idx Performance Asc __origin
subscription_agreement_org___source_idx Performance Asc __source
subscription_agreement_org___start_idx Performance Asc __start
subscription_agreement_org_sao_id_idx Performance Asc sao_id
subscription_agreement_org_sao_note_idx Performance Asc sao_note
subscription_agreement_org_sao_org_fk_idx Performance Asc sao_org_fk
subscription_agreement_org_sao_owner_fk_idx Performance Asc sao_owner_fk
subscription_agreement_org_sao_primary_org_idx Performance Asc sao_primary_org
subscription_agreement_org_sao_version_idx Performance Asc sao_version

Relationships

Close relationships within degrees of separation