virkailija


Description

Virkailijoiden tiedot ja asetukset

Columns

Column Type Size Nulls Auto Default Children Parents Comments
oid varchar 50 null
application_events.virkailija_oid application_events_virkailija_oid_fkey R
application_review_notes.virkailija_oid application_review_notes_virkailija_oid_fkey R
email_templates.virkailija_oid email_templates_virkailija_oid_fkey R
forms.organization_oid Implied Constraint R
information_requests.virkailija_oid information_requests_virkailija_oid_fkey R
kk_application_payment_permit_checks.virkailija_oid kk_application_payment_permit_checks_virkailija_oid_fkey R
latest_forms.organization_oid Implied Constraint R
virkailija_create_secrets.virkailija_oid virkailija_create_secrets_virkailija_oid_fkey R
virkailija_credentials.oid virkailija_credentials_oid_fkey R
virkailija_rewrite_secrets.virkailija_oid virkailija_rewrite_secrets_virkailija_oid_fkey R
virkailija_update_secrets.virkailija_oid virkailija_update_secrets_virkailija_oid_fkey R

Virkailijan OID.
first_name varchar 255 null

Virkailijan etunimi.
last_name varchar 255 null

Virkailijan sukunimi.
settings jsonb 2147483647 √ null

Virkailijan asetukset.

Indexes

Constraint Name Type Sort Column(s)
virkailija_pkey Primary key Asc oid

Relationships

Close relationships within degrees of separation