Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| skemarol_id | int8 | 19 | null |
|
|
||||||
| skemrtyp_id | int8 | 19 | √ | null |
|
|
|||||
| rolle | varchar | 5 | √ | null |
|
|
|||||
| kort_betegnelse | varchar | 15 | √ | null |
|
|
|||||
| timetype | varchar | 1 | √ | null |
|
|
|||||
| check_skemasammenfald | varchar | 1 | √ | null |
|
|
|||||
| genererer_timeposter | varchar | 1 | √ | null |
|
|
|||||
| afspadsering | varchar | 1 | √ | null |
|
|
|||||
| vis_pa_lererskema | varchar | 1 | √ | null |
|
|
|||||
| loty_id | int8 | 19 | √ | null |
|
|
|||||
| betegnelse | varchar | 50 | √ | null |
|
|
|||||
| opdmod | varchar | 4 | √ | null |
|
|
|||||
| opdinit | varchar | 30 | √ | null |
|
|
|||||
| opdtid | timestamp | 22 | √ | null |
|
|
|||||
| omsorgsdag | varchar | 1 | √ | null |
|
|
|||||
| frty_id | int8 | 19 | √ | null |
|
|
|||||
| hontity_id | int8 | 19 | √ | null |
|
|
|||||
| lererstyret_undervisning | varchar | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| skemarol_pk | Primary key | Asc | skemarol_id |
| skemarol_frty_fk_i | Performance | Asc | frty_id |
| skemarol_hontity_fk_i | Performance | Asc | hontity_id |
| skemarol_loty_fk_i | Performance | Asc | loty_id |
| skemarol_skemarol1_uk | Must be unique | Asc | rolle |
| skemarol_skemrtyp_fk_i | Performance | Asc | skemrtyp_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| skemaroller_check | (('AFSPADSERING' IS NOT NULL)) |
| skemaroller_check12 | (('VIS_PA_LERERSKEMA' IS NOT NULL)) |
| skemaroller_check4 | (('LERERSTYRET_UNDERVISNING' IS NOT NULL)) |
| skemaroller_check1 | (('CHECK_SKEMASAMMENFALD' IS NOT NULL)) |
| skemaroller_check5 | (('OPDINIT' IS NOT NULL)) |
| skemaroller_genererer_timeposter_check | (((genererer_timeposter)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| skemaroller_check8 | (('ROLLE' IS NOT NULL)) |
| skemaroller_check3 | (('KORT_BETEGNELSE' IS NOT NULL)) |
| skemaroller_check11 | (('TIMETYPE' IS NOT NULL)) |
| skemaroller_check6 | (('OPDMOD' IS NOT NULL)) |
| skemaroller_timetype_check | (((timetype)::text = ANY ((ARRAY['A'::character varying, 'U'::character varying, 'R'::character varying, 'E'::character varying, 'K'::character varying])::text[]))) |
| skemaroller_check7 | (('OPDTID' IS NOT NULL)) |
| skemaroller_omsorgsdag_check | (((omsorgsdag)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| skemaroller_vis_pa_lererskema_check | (((vis_pa_lererskema)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| skemaroller_check10 | (('SKEMRTYP_ID' IS NOT NULL)) |
| skemaroller_check_skemasammenfald_check | (((check_skemasammenfald)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| skemaroller_afspadsering_check | (((afspadsering)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| skemaroller_check2 | (('GENERERER_TIMEPOSTER' IS NOT NULL)) |
| skemaroller_check9 | (('SKEMAROL_ID' IS NOT NULL)) |