Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| tilpr_skhp_id | int8 | 19 | null |
|
|
||||||
| skph_id | int8 | 19 | √ | null |
|
|
|||||
| tlprisar_id | int8 | 19 | √ | null |
|
|
|||||
| pris | numeric | 10,2 | √ | null |
|
|
|||||
| tillagspris_begrundelse | varchar | 600 | √ | null |
|
|
|||||
| tillagspris_guid | varchar | 32 | √ | null |
|
|
|||||
| opdmod | varchar | 4 | √ | null |
|
|
|||||
| opdtid | timestamp | 22 | √ | null |
|
|
|||||
| opdinit | varchar | 30 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tilpr_skhp_id_pk1 | Primary key | Asc | tilpr_skhp_id |
| skhp_id_fk1_i | Performance | Asc | skph_id |
| tlprisar_id_fk3_i | Performance | Asc | tlprisar_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| tillagspriser_skolefag_pa_hold_check3 | (('PRIS' IS NOT NULL)) |
| tillagspriser_skolefag_pa_hold_check | (('OPDINIT' IS NOT NULL)) |
| tillagspriser_skolefag_pa_hold_check2 | (('OPDTID' IS NOT NULL)) |
| tillagspriser_skolefag_pa_hold_check7 | (('TLPRISAR_ID' IS NOT NULL)) |
| tillagspriser_skolefag_pa_hold_check5 | (('TILLAGSPRIS_GUID' IS NOT NULL)) |
| tillagspriser_skolefag_pa_hold_check6 | (('TILPR_SKHP_ID' IS NOT NULL)) |
| tillagspriser_skolefag_pa_hold_check4 | (('SKPH_ID' IS NOT NULL)) |
| tillagspriser_skolefag_pa_hold_check1 | (('OPDMOD' IS NOT NULL)) |