Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| aubet_id | int8 | 19 | null |
|
|
||||||
| medtag_jn | varchar | 1 | √ | null |
|
|
|||||
| sendes_jn | varchar | 1 | √ | null |
|
|
|||||
| cpr_nr | varchar | 11 | √ | null |
|
|
|||||
| varchar | 50 | √ | null |
|
|
||||||
| varchar | 50 | √ | null |
|
|
||||||
| cosa_formal | varchar | 4 | √ | null |
|
|
|||||
| version | varchar | 4 | √ | null |
|
|
|||||
| speciale | varchar | 2 | √ | null |
|
|
|||||
| se_nr | varchar | 8 | √ | null |
|
|
|||||
| startdato | timestamp | 22 | √ | null |
|
|
|||||
| slutdato | timestamp | 22 | √ | null |
|
|
|||||
| betaler | varchar | 11 | √ | null |
|
|
|||||
| belob | numeric | 10,2 | √ | null |
|
|
|||||
| betalt_dato | timestamp | 22 | √ | null |
|
|
|||||
| status | varchar | 25 | √ | null |
|
|
|||||
| manuel_jn | varchar | 1 | √ | null |
|
|
|||||
| send_igen_jn | varchar | 1 | √ | null |
|
|
|||||
| afsendt_opdtid | timestamp | 22 | √ | null |
|
|
|||||
| aub_indberet_id | varchar | 26 | √ | null |
|
|
|||||
| shje_id | int8 | 19 | √ | null |
|
|
|||||
| last_opd_opkr | timestamp | 22 | √ | null |
|
|
|||||
| last_opd_opkl | timestamp | 22 | √ | null |
|
|
|||||
| status_text | varchar | 4000 | √ | null |
|
|
|||||
| opdmod | varchar | 4 | √ | null |
|
|
|||||
| opdinit | varchar | 30 | √ | null |
|
|
|||||
| opdtid | timestamp | 22 | √ | null |
|
|
|||||
| statstilskud | varchar | 1 | √ | null |
|
|
|||||
| bemerkning | varchar | 300 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| aubb_pk | Primary key | Asc | aubet_id |
| aub_betalinger_i01 | Performance | Asc | shje_id |
| aubb_bet_sen_i | Performance | Asc/Asc | betaler + send_igen_jn |
| aubb_cpr_cofor_vrsd_i | Performance | Asc/Asc/Asc/Asc | cpr_nr + cosa_formal + version + startdato |
| aubb_mese_st_i | Performance | Asc/Asc/Asc | medtag_jn + sendes_jn + status |
| aubet_shje_id_idx | Performance | Asc | shje_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| aub_betalinger_check10 | (('SE_NR' IS NOT NULL)) |
| aub_betalinger_check5 | (('OPDINIT' IS NOT NULL)) |
| aub_betalinger_check3 | (('MANUEL_JN' IS NOT NULL)) |
| aub_betalinger_manuel_jn_check | (((manuel_jn)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| aub_betalinger_medtag_jn_check | (((medtag_jn)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| aub_betalinger_check | (('BETALT_DATO' IS NOT NULL)) |
| aub_betalinger_check12 | (('STARTDATO' IS NOT NULL)) |
| aub_betalinger_check2 | (('CPR_NR' IS NOT NULL)) |
| aub_betalinger_check6 | (('OPDMOD' IS NOT NULL)) |
| aub_betalinger_check7 | (('OPDTID' IS NOT NULL)) |
| aub_betalinger_check8 | (('SENDES_JN' IS NOT NULL)) |
| aub_betalinger_check9 | (('SEND_IGEN_JN' IS NOT NULL)) |
| aub_betalinger_check11 | (('SLUTDATO' IS NOT NULL)) |
| aub_betalinger_send_igen_jn_check | (((send_igen_jn)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| aub_betalinger_check13 | (('STATSTILSKUD' IS NOT NULL)) |
| aub_betalinger_check4 | (('MEDTAG_JN' IS NOT NULL)) |
| aub_betalinger_sendes_jn_check | (((sendes_jn)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| aub_betalinger_statstilskud_check | (((statstilskud)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| aub_betalinger_status_check | (((status)::text = ANY ((ARRAY['OK'::character varying, 'AFVIST'::character varying, 'OPRETTET'::character varying, 'OPDATERET'::character varying])::text[]))) |
| aub_betalinger_check1 | (('COSA_FORMAL' IS NOT NULL)) |
| aub_betalinger_check15 | (('VERSION' IS NOT NULL)) |
| aub_betalinger_check14 | (('STATUS' IS NOT NULL)) |