ae_bidrag


Columns

Column Type Size Nulls Auto Default Children Parents Comments
aebi_id int8 19 null
elis_id int8 19 √ null
elev_i_skoleforlob.elis_id aebi_elis_fk R
bipe_id int8 19 √ null
bidragsperiode.bipe_id aebi_bipe_fk R
bidrag numeric 9,5 √ null
restbidrag numeric 9,5 √ null
reguleret_varighed numeric 4,1 √ null
brobyggervarighed numeric 4,1 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
uvma_id int8 19 √ null
uvm_afdelinger.uvma_id aebi_uvma_fk R

Indexes

Constraint Name Type Sort Column(s)
aebi_pk Primary key Asc aebi_id
aebi_aebi1_uk Must be unique Asc/Asc elis_id + bipe_id
aebi_bipe_fk_i Performance Asc bipe_id
aebi_elis_fk_i Performance Asc elis_id
aebi_elis_id_idx Performance Asc elis_id
aebi_uvma_fk_i Performance Asc uvma_id

Check Constraints

Constraint Name Constraint
ae_bidrag_check4 (('OPDINIT' IS NOT NULL))
ae_bidrag_check7 (('RESTBIDRAG' IS NOT NULL))
ae_bidrag_check3 (('ELIS_ID' IS NOT NULL))
ae_bidrag_check5 (('OPDMOD' IS NOT NULL))
ae_bidrag_check1 (('BIDRAG' IS NOT NULL))
ae_bidrag_check6 (('OPDTID' IS NOT NULL))
ae_bidrag_check (('AEBI_ID' IS NOT NULL))
ae_bidrag_check2 (('BIPE_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation