Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| gansno_id | int8 | 19 | null |
|
|
||||||
| ganso_id | int8 | 19 | √ | null |
|
|
|||||
| lobenummer | int8 | 19 | √ | null |
|
|
|||||
| titel | varchar | 500 | √ | null |
|
|
|||||
| beskrivelse | varchar | 500 | √ | null |
|
|
|||||
| svar | varchar | 500 | √ | null |
|
|
|||||
| varchar | 500 | √ | null |
|
|
||||||
| svar_x | varchar | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| gansno_pk | Primary key | Asc | gansno_id |
| ganso_ftu_fk_i | Performance | Asc | ganso_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| generel_ansogning_noter_check | (('GANSNO_ID' IS NOT NULL)) |
| generel_ansogning_noter_check1 | (('GANSO_ID' IS NOT NULL)) |
| generel_ansogning_noter_check2 | (('LOBENUMMER' IS NOT NULL)) |