jonosija


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 uuid_generate_v4()
created_at timestamptz 35,6 √ now()
hakemus_oid varchar 127 √ null
hakija_oid varchar 127 √ null
hakutoiveprioriteetti int4 10 √ null
harkinnanvarainen bool 1 √ null
hylatty_valisijoittelussa bool 1 √ null
valintatapajono uuid 2147483647 √ null
valintatapajono.id fk_valintatapajono R
hakijaryhma uuid 2147483647 √ null
hakijaryhma.id fk_hakijaryhma R
funktio_tulokset jsonb 2147483647 √ null
syotetyt_arvot jsonb 2147483647 √ null
jarjestyskriteeritulokset jsonb 2147483647 √ null
transaction_id int8 19 txid_current()
last_modified timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
jonosija_pkey Primary key Asc id
jonosija_hakemus Performance Asc hakemus_oid
jonosija_hakijaryhma Performance Asc hakijaryhma
jonosija_last_modified_idx Performance Asc last_modified
jonosija_valintatapajono Performance Asc valintatapajono
temp_transaction_id_idx Performance Asc transaction_id

Relationships

Close relationships within degrees of separation