versiot


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tunniste uuid 2147483647 null
opiskeluoikeudet.versio_tunniste opiskeluoikeudet_versio_tunniste_fkey R
versiot.use_versio_tunniste versiot_use_versio_tunniste_fkey R
use_versio_tunniste uuid 2147483647 √ null
versiot.tunniste versiot_use_versio_tunniste_fkey R
oppijanumero varchar 2147483647 null
oppijat.oppijanumero versiot_oppijanumero_fkey R
voimassaolo tstzrange 2147483647 null
suoritusjoukko varchar 2147483647 null
data_json _jsonb 2147483647 √ null
data_xml _xml 2147483647 √ null
metadata _varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
versiot_pkey Primary key Asc tunniste
idx_versiot_metadata Performance Asc metadata
versiot_oppijanumero_suoritusjoukko_voimassaolo_excl Performance Asc/Asc/Asc oppijanumero + suoritusjoukko + voimassaolo

Check Constraints

Constraint Name Constraint
versiot_check (((((suoritusjoukko)::text = 'VIRTA'::text) AND (data_json IS NULL) AND (data_xml IS NOT NULL)) OR ((data_json IS NOT NULL) AND (data_xml IS NULL))))

Relationships

Close relationships within degrees of separation