kk_application_payment_permit_checks


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('kk_application_payment_permit_checks_id_seq'::regclass)
application_key text 2147483647 null
application_reviews.application_key kk_application_payment_permit_checks_application_key_fkey R
attachment_key text 2147483647 null
found_in_migri bool 1 √ null
permit_valid_until date 13 √ null
payment_obligation_basis text 2147483647 √ null
payment_obligation_other_reason text 2147483647 √ null
virkailija_oid text 2147483647 null
virkailija.oid kk_application_payment_permit_checks_virkailija_oid_fkey R
organization_oid text 2147483647 √ null
checked_time timestamptz 35,6 null
inherited_from_application_key text 2147483647 √ null
inherited_time timestamptz 35,6 √ null
modified_time timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
kk_application_payment_permit_checks_pkey Primary key Asc id
kk_application_payment_permit_application_key_attachment_ke_key Must be unique Asc/Asc application_key + attachment_key

Check Constraints

Constraint Name Constraint
kk_application_payment_permit_ch_payment_obligation_basis_check (payment_obligation_basis = ANY (ARRAY['not-obligated'::text, 'obligated-own-studies'::text, 'obligated-family-member-studies'::text, 'obligated-other'::text]))

Relationships

Close relationships within degrees of separation