Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| skemabeg_id | int8 | 19 | null |
|
|
|||||||||
| begivenhed_id | int8 | 19 | √ | null |
|
|
||||||||
| dato | timestamp | 22 | √ | null |
|
|
||||||||
| eksadag_id | int8 | 19 | √ | null |
|
|
||||||||
| starttid | varchar | 5 | √ | null |
|
|
||||||||
| sluttid | varchar | 5 | √ | null |
|
|
||||||||
| opdtid | timestamp | 22 | √ | null |
|
|
||||||||
| opdinit | varchar | 30 | √ | null |
|
|
||||||||
| risy_id | int8 | 19 | √ | null |
|
|
||||||||
| skfa_id | int8 | 19 | √ | null |
|
|
||||||||
| lektionsnr | int2 | 5 | √ | null |
|
|
||||||||
| planlegger | varchar | 5 | √ | null |
|
|
||||||||
| antal_standard_lektioner | numeric | 6,2 | √ | null |
|
|
||||||||
| bemerkning | varchar | 200 | √ | null |
|
|
||||||||
| bundt_nummer | int8 | 19 | √ | null |
|
|
||||||||
| opdmod | varchar | 4 | √ | null |
|
|
||||||||
| fodesystem | varchar | 4 | √ | null |
|
|
||||||||
| fraver_registreret | varchar | 1 | √ | null |
|
|
||||||||
| andret_af | varchar | 30 | √ | null |
|
|
||||||||
| andret_den | timestamp | 22 | √ | null |
|
|
||||||||
| opg_udlevering | int2 | 5 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| skemabeg_pk | Primary key | Asc | skemabeg_id |
| skemabeg_dato_i | Performance | Asc | dato |
| skemabeg_dato_i2 | Performance | Asc | dato |
| skemabeg_eksadag_fk_i | Performance | Asc | eksadag_id |
| skemabeg_risy_fk_i | Performance | Asc | risy_id |
| skemabeg_skemabeg1_uk | Must be unique | Asc | begivenhed_id |
| skemabeg_skfa_fk_i | Performance | Asc | skfa_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| skemabegivenheder_check7 | (('SLUTTID' IS NOT NULL)) |
| skemabegivenheder_check2 | (('FRAVER_REGISTRERET' IS NOT NULL)) |
| skemabegivenheder_fraver_registreret_check | (((fraver_registreret)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| skemabegivenheder_check1 | (('DATO' IS NOT NULL)) |
| skemabegivenheder_check3 | (('OPDINIT' IS NOT NULL)) |
| skemabegivenheder_check4 | (('OPDMOD' IS NOT NULL)) |
| skemabegivenheder_check6 | (('SKEMABEG_ID' IS NOT NULL)) |
| skemabegivenheder_fodesystem_check | (((fodesystem)::text = 'W023'::text)) |
| skemabegivenheder_check5 | (('OPDTID' IS NOT NULL)) |
| skemabegivenheder_check8 | (('STARTTID' IS NOT NULL)) |
| skemabegivenheder_check | (('BEGIVENHED_ID' IS NOT NULL)) |