subscription_agreement


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
sa_id uuid 2147483647 null
agreement_relationship.ar_inward_fk agreement_relationship_ar_inward_fk_fkey1R
agreement_relationship.ar_outward_fk agreement_relationship_ar_outward_fk_fkey1R
entitlement.ent_owner_fk entitlement_ent_owner_fk_fkey1R
internal_contact.ic_owner_fk internal_contact_ic_owner_fk_fkey1R
period.per_owner period_per_owner_fkey1R
remote_license_link.rll_owner remote_license_link_rll_owner_fkey1R
subscription_agreement_org.sao_owner_fk subscription_agreement_org_sao_owner_fk_fkey1R
sa_renewal_date date 13 √ null
sa_licence_fk varchar 1 √ null
sa_vendor_fk varchar 1 √ null
sa_agreement_type varchar 1 √ null
sa_renewal_priority varchar 32 √ null
sa_content_review_needed varchar 1 √ null
sa_vendor_reference varchar 1 √ null
sa_is_perpetual varchar 32 √ null
sa_next_review_date date 13 √ null
sa_name varchar 81 √ null
sa_local_reference varchar 1 √ null
sa_agreement_status varchar 32 √ null
sa_enabled bool 1 √ null
sa_description varchar 538 √ null
sa_license_note varchar 1 √ null
sa_reason_for_closure varchar 1 √ null
custom_properties_id int8 19 √ null
sa_start_date timestamp 29,6 √ null
sa_end_date timestamp 29,6 √ null
sa_cancellation_deadline timestamp 29,6 √ null
sa_date_created timestamp 29,6 √ null
sa_last_updated timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
subscription_agreement_pkey Primary key Asc sa_id
subscription_agreement___origin_idx Performance Asc __origin
subscription_agreement___source_idx Performance Asc __source
subscription_agreement___start_idx Performance Asc __start
subscription_agreement_custom_properties_id_idx Performance Asc custom_properties_id
subscription_agreement_sa_agreement_status_idx Performance Asc sa_agreement_status
subscription_agreement_sa_agreement_type_idx Performance Asc sa_agreement_type
subscription_agreement_sa_cancellation_deadline_idx Performance Asc sa_cancellation_deadline
subscription_agreement_sa_content_review_needed_idx Performance Asc sa_content_review_needed
subscription_agreement_sa_date_created_idx Performance Asc sa_date_created
subscription_agreement_sa_description_idx Performance Asc sa_description
subscription_agreement_sa_enabled_idx Performance Asc sa_enabled
subscription_agreement_sa_end_date_idx Performance Asc sa_end_date
subscription_agreement_sa_id_idx Performance Asc sa_id
subscription_agreement_sa_is_perpetual_idx Performance Asc sa_is_perpetual
subscription_agreement_sa_last_updated_idx Performance Asc sa_last_updated
subscription_agreement_sa_licence_fk_idx Performance Asc sa_licence_fk
subscription_agreement_sa_license_note_idx Performance Asc sa_license_note
subscription_agreement_sa_local_reference_idx Performance Asc sa_local_reference
subscription_agreement_sa_name_idx Performance Asc sa_name
subscription_agreement_sa_next_review_date_idx Performance Asc sa_next_review_date
subscription_agreement_sa_reason_for_closure_idx Performance Asc sa_reason_for_closure
subscription_agreement_sa_renewal_date_idx Performance Asc sa_renewal_date
subscription_agreement_sa_renewal_priority_idx Performance Asc sa_renewal_priority
subscription_agreement_sa_start_date_idx Performance Asc sa_start_date
subscription_agreement_sa_vendor_fk_idx Performance Asc sa_vendor_fk
subscription_agreement_sa_vendor_reference_idx Performance Asc sa_vendor_reference

Relationships

Close relationships within degrees of separation