forlobsgrupper


Columns

Column Type Size Nulls Auto Default Children Parents Comments
fogr_id int8 19 null
gebyrer_pr_rate.fogr_id gbra_fogr_fk R
skoleforlob.fogr_id skof_fogr_fk R
skka_id int8 19 √ null
skoledagskalendere.skka_id fogr_skka_fk R
saet_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
gruppe varchar 12 √ null
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
skolehjem varchar 1 √ null
betegnelse varchar 50 √ null
kort_betegnelse varchar 15 √ null
max_antal int2 5 √ null
lerertimer int2 5 √ null
lererlektioner int2 5 √ null
elevlektioner int2 5 √ null
opdtid timestamp 22 √ null
opdinit varchar 30 √ null
opdmod varchar 4 √ null
antal_skoledage int2 5 √ null

Indexes

Constraint Name Type Sort Column(s)
fogr_pk Primary key Asc fogr_id
fogr_dato_i Performance Asc/Asc startdato + slutdato
fogr_fogr1_uk Must be unique Asc gruppe
fogr_saet_fk_i Performance Asc saet_id
fogr_skka_fk_i Performance Asc skka_id

Check Constraints

Constraint Name Constraint
forlobsgrupper_check9 (('STARTDATO' IS NOT NULL))
forlobsgrupper_check8 (('SLUTDATO' IS NOT NULL))
forlobsgrupper_skolehjem_check1 (((skolehjem)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
forlobsgrupper_check3 (('OPDINIT' IS NOT NULL))
forlobsgrupper_check (('ANTAL_SKOLEDAGE' IS NOT NULL))
forlobsgrupper_check2 (('GRUPPE' IS NOT NULL))
forlobsgrupper_check4 (('OPDMOD' IS NOT NULL))
forlobsgrupper_check7 (('SKOLEHJEM' IS NOT NULL))
forlobsgrupper_check1 (('FOGR_ID' IS NOT NULL))
forlobsgrupper_check6 (('SKKA_ID' IS NOT NULL))
forlobsgrupper_check5 (('OPDTID' IS NOT NULL))
forlobsgrupper_skolehjem_check (((skolehjem)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))

Relationships

Close relationships within degrees of separation