su_handelser


Columns

Column Type Size Nulls Auto Default Children Parents Comments
handelses_id int8 19 null
su_indskrivning.handelselses_ref_id su_indskrivning_fk2 R
su_indskrivning.handelses_id su_indskrivning_fk1 R
su_kontrol.handelses_id su_kontrol_fk R
su_ophor.handelses_id su_ophor_fk1 R
su_ophor.ind_hand_ref_id su_ophor_fk2 R
su_orlov.handelses_id su_orlov_fk1 R
su_orlov.ind_hand_ref_id su_orlov_fk2 R
su_orlov.orlov_hand_ref_id su_orlov_fk3 R
su_transaktioner.handelses_id su_transaktioner_fk1 R
elev_id int8 19 √ null
elever.elev_id su_handelser_fk1 R
ds_nr numeric 0 √ null
cosa_formal varchar 4 √ null
aktivitetsgruppe numeric 0 √ null
type varchar 12 √ null
operation varchar 10 √ null
opdtid timestamp 22 √ null
opdinit varchar 30 √ null
opdmod varchar 4 √ null
datainit varchar 1 √ null
indper_id int8 19 √ null
indskrivnings_perioder.indper_id su_handelser_fk2 R
fiktivt_cosa_formal varchar 4 √ null
afsendelses_mark varchar 1 √ null
bemarkning varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
su_handelser_pk Primary key Asc handelses_id
su_handelser_fk1_i Performance Asc elev_id
su_handelser_fk2_i Performance Asc indper_id
suhan_elev_id_idx Performance Asc elev_id

Check Constraints

Constraint Name Constraint
su_handelser_check5 (('TYPE' IS NOT NULL))
su_handelser_check1 (('DS_NR' IS NOT NULL))
su_handelser_datainit_check (((datainit)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
su_handelser_check4 (('OPERATION' IS NOT NULL))
su_handelser_type_check (((type)::text = ANY ((ARRAY['INDSKRIVNING'::character varying, 'ORLOV'::character varying, 'PRAKTIK'::character varying, 'OPHØR'::character varying, 'KONTROL'::character varying])::text[])))
su_handelser_check (('DATAINIT' IS NOT NULL))
su_handelser_check2 (('ELEV_ID' IS NOT NULL))
su_handelser_check3 (('INDPER_ID' IS NOT NULL))
su_handelser_operation_check (((operation)::text = ANY ((ARRAY['OPRET'::character varying, 'OPDATER'::character varying, 'SLET'::character varying])::text[])))

Relationships

Close relationships within degrees of separation