versiot


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tunniste uuid 2147483647 null
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
lahde lahde 2147483647 null
data_json jsonb 2147483647 √ null
data_xml xml 2147483647 √ null
data_parseroitu jsonb 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
versiot_pkey Primary key Asc tunniste
idx_versiot_data_parseroitu Performance Asc data_parseroitu

Check Constraints

Constraint Name Constraint
versiot_check ((((lahde = 'KOSKI'::lahde) AND (data_json IS NOT NULL) AND (data_xml IS NULL)) OR ((lahde = 'YTR'::lahde) AND (data_json IS NOT NULL) AND (data_xml IS NULL)) OR ((lahde = 'VIRTA'::lahde) AND (data_json IS NULL) AND (data_xml IS NOT NULL)) OR ((lahde = 'VIRKAILIJA'::lahde) AND (data_json IS NOT NULL) AND (data_xml IS NULL))))
versiot_check1 ((((use_versio_tunniste IS NOT NULL) AND (data_parseroitu IS NULL)) OR ((use_versio_tunniste IS NULL) AND (data_parseroitu IS NOT NULL))))

Relationships

Close relationships within degrees of separation