kalenderuger


Columns

Column Type Size Nulls Auto Default Children Parents Comments
visningsformat_uge varchar 11 null
fraver_uger.vfu_uge fu_kauge_fk R
fraversprotokoller.vfu_uge fvproto_kauge_fk R
kalenderdage.vfu_visningsformat_uge kaldag_kauge_fk R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
indtastningsformat_uge varchar 4 √ null
ugenr int2 5 √ null

Indexes

Constraint Name Type Sort Column(s)
kauge_pk Primary key Asc visningsformat_uge
kauge_dato_i Must be unique Asc/Asc startdato + slutdato
kauge_dato_i2 Performance Asc/Asc startdato + slutdato
kauge_indtastningsformat_i Must be unique Asc indtastningsformat_uge
kauge_slutdato_i Must be unique Asc slutdato
kauge_startdato_i Must be unique Asc startdato

Check Constraints

Constraint Name Constraint
kalenderuger_check2 (('STARTDATO' IS NOT NULL))
kalenderuger_ugenr_check (((ugenr >= 1) AND (ugenr <= 53)))
kalenderuger_check (('INDTASTNINGSFORMAT_UGE' IS NOT NULL))
kalenderuger_check3 (('UGENR' IS NOT NULL))
kalenderuger_check1 (('SLUTDATO' IS NOT NULL))
kalenderuger_check4 (('VISNINGSFORMAT_UGE' IS NOT NULL))

Relationships

Close relationships within degrees of separation