Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pety_id | int8 | 19 | null |
|
|
||||||
| periodetype | varchar | 10 | √ | null |
|
|
|||||
| kort_betegnelse | varchar | 15 | √ | null |
|
|
|||||
| betegnelse | varchar | 50 | √ | null |
|
|
|||||
| overlap_tilladt_skoleforlob | varchar | 1 | √ | null |
|
|
|||||
| aer_refusion | varchar | 1 | √ | null |
|
|
|||||
| overlap_tilladt_skolepraktik | varchar | 1 | √ | null |
|
|
|||||
| opdmod | varchar | 4 | √ | null |
|
|
|||||
| opdinit | varchar | 30 | √ | null |
|
|
|||||
| opdtid | timestamp | 22 | √ | null |
|
|
|||||
| ftu_indberettes | varchar | 1 | √ | null |
|
|
|||||
| grundforlob_del_1 | varchar | 1 | √ | null |
|
|
|||||
| grundforlob_del_2 | varchar | 1 | √ | null |
|
|
|||||
| hovedforlob | varchar | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pety_pk | Primary key | Asc | pety_id |
| pety_pety1_uk | Must be unique | Asc | periodetype |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| periodetyper_check4 | (('GRUNDFORLOB_DEL_2' IS NOT NULL)) |
| periodetyper_ftu_indberettes_check | (((ftu_indberettes)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| periodetyper_check13 | (('PETY_ID' IS NOT NULL)) |
| periodetyper_check2 | (('FTU_INDBERETTES' IS NOT NULL)) |
| periodetyper_check7 | (('OPDINIT' IS NOT NULL)) |
| periodetyper_check3 | (('GRUNDFORLOB_DEL_1' IS NOT NULL)) |
| periodetyper_check | (('AER_REFUSION' IS NOT NULL)) |
| periodetyper_check11 | (('OVERLAP_TILLADT_SKOLEPRAKTIK' IS NOT NULL)) |
| periodetyper_overlap_tilladt_skoleforlob_check | (((overlap_tilladt_skoleforlob)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| periodetyper_hovedforlob_check | (((hovedforlob)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| periodetyper_check12 | (('PERIODETYPE' IS NOT NULL)) |
| periodetyper_check5 | (('HOVEDFORLOB' IS NOT NULL)) |
| periodetyper_grundforlob_del_1_check | (((grundforlob_del_1)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| periodetyper_check1 | (('BETEGNELSE' IS NOT NULL)) |
| periodetyper_check10 | (('OVERLAP_TILLADT_SKOLEFORLOB' IS NOT NULL)) |
| periodetyper_check6 | (('KORT_BETEGNELSE' IS NOT NULL)) |
| periodetyper_grundforlob_del_2_check | (((grundforlob_del_2)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| periodetyper_aer_refusion_check | (((aer_refusion)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| periodetyper_check8 | (('OPDMOD' IS NOT NULL)) |
| periodetyper_check9 | (('OPDTID' IS NOT NULL)) |
| periodetyper_overlap_tilladt_skolepraktik_check | (((overlap_tilladt_skolepraktik)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |