Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| kvotetype_kode | "kodeverk"."kode_domain" | 2147483647 | null |
|
|
Kode for kvotetypen |
|||||
| grunnlagkode_default | "kodeverk"."kode_domain" | 2147483647 | null |
|
|
Standard kode for grunnlag |
|||||
| aldersgrense_default | int4 | 10 | √ | null |
|
|
Standard aldersgrense |
||||
| aldersgrense_operator_default | "kodeverk"."operator_domain" | 2147483647 | √ | null |
|
|
Standard operator for aldersgrense |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| kvotetype_grunnlag_pk | Primary key | Asc/Asc | kvotetype_kode + grunnlagkode_default |
| kvotetypegrunnlag_aldersgrenseoperator_ix | Performance | Asc | aldersgrense_operator_default |
| kvotetypegrunnlag_grunnlag_default_ix | Performance | Asc | grunnlagkode_default |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| kvotetype_grunnlag_aldersgrense_default_check | (((aldersgrense_default > 0) AND (aldersgrense_default < 100))) |