Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| eltyby_id | int8 | 19 | null |
|
|
||||||
| elevtype_byggeklods | varchar | 10 | √ | null |
|
|
|||||
| kort_betegnelse | varchar | 15 | √ | null |
|
|
|||||
| betegnelse | varchar | 50 | √ | null |
|
|
|||||
| ungdom_voksen | varchar | 1 | √ | null |
|
|
|||||
| talentspor | varchar | 1 | √ | null |
|
|
|||||
| eux | varchar | 1 | √ | null |
|
|
|||||
| gym | varchar | 1 | √ | null |
|
|
|||||
| mesterlere | varchar | 1 | √ | null |
|
|
|||||
| pskole_eud | varchar | 1 | √ | null |
|
|
|||||
| opdmod | varchar | 4 | √ | null |
|
|
|||||
| opdtid | timestamp | 22 | √ | null |
|
|
|||||
| opdinit | varchar | 30 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| eltyby_pk | Primary key | Asc | eltyby_id |
| eltyby_uk | Must be unique | Asc | elevtype_byggeklods |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| elevtyper_byggeklodser_check5 | (('KORT_BETEGNELSE' IS NOT NULL)) |
| elevtyper_byggeklodser_gym_check | (((gym)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| elevtyper_byggeklodser_eux_check | (((eux)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| elevtyper_byggeklodser_check | (('BETEGNELSE' IS NOT NULL)) |
| elevtyper_byggeklodser_check12 | (('UNGDOM_VOKSEN' IS NOT NULL)) |
| elevtyper_byggeklodser_check10 | (('PSKOLE_EUD' IS NOT NULL)) |
| elevtyper_byggeklodser_check2 | (('ELTYBY_ID' IS NOT NULL)) |
| elevtyper_byggeklodser_check3 | (('EUX' IS NOT NULL)) |
| elevtyper_byggeklodser_check9 | (('OPDTID' IS NOT NULL)) |
| elevtyper_byggeklodser_talentspor_check | (((talentspor)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| elevtyper_byggeklodser_pskole_eud_check | (((pskole_eud)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| elevtyper_byggeklodser_check6 | (('MESTERLERE' IS NOT NULL)) |
| elevtyper_byggeklodser_check1 | (('ELEVTYPE_BYGGEKLODS' IS NOT NULL)) |
| elevtyper_byggeklodser_check11 | (('TALENTSPOR' IS NOT NULL)) |
| elevtyper_byggeklodser_check8 | (('OPDMOD' IS NOT NULL)) |
| elevtyper_byggeklodser_ungdom_voksen_check | (((ungdom_voksen)::text = ANY ((ARRAY['U'::character varying, 'V'::character varying, 'I'::character varying])::text[]))) |
| elevtyper_byggeklodser_check4 | (('GYM' IS NOT NULL)) |
| elevtyper_byggeklodser_check7 | (('OPDINIT' IS NOT NULL)) |
| elevtyper_byggeklodser_mesterlere_check | (((mesterlere)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |