Datadictionary OpenWave 3.1.25 |
|
Table: tbzaakstatus
Datadictionary OpenWave 3.1.25 |
|
Table: tbzaakstatus
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Vertalingstabel voor zaakstatussen tbv actualiseerstatus (zaak/dms koppeling)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbzaakstatus_dnkey_seq'::regclass) |
Primary key. |
|
|
dvwavecode |
varchar(20) |
|
|
|
|
Codering van status in wave |
|
|
dvextcode |
varchar(20) |
|
|
|
|
Codering van status in extern zaaksysteem |
|
|
dvextomschrijving |
varchar(100) |
|
|
|
|
Omschrijving van status in extern zaaksysteem |
|
|
dvresultaatoms |
varchar(200) |
|
|
|
|
Resultaatomschirijving bij status ingetrokken en vervallen |
Foreign Keys
There are no foreign keys for table tbzaakstatus
Check Constraints
There are no check constraints for table tbzaakstatus
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbzaakstatus |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbzaakstatus
Rules
There are no rules for table tbzaakstatus
Policies
There are no policies for table tbzaakstatus
Referenced
There are no tables referenced by table tbzaakstatus
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvwavecode VARCHAR(20),
dvextcode VARCHAR(20),
dvextomschrijving VARCHAR(100),
dvresultaatoms VARCHAR(200),
CONSTRAINT cpk_tbzaakstatus PRIMARY KEY(dnkey)
) ;
COMMENT ON TABLE public.tbzaakstatus
IS 'Vertalingstabel voor zaakstatussen tbv actualiseerstatus (zaak/dms koppeling)';
COMMENT ON COLUMN public.tbzaakstatus.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbzaakstatus.dvwavecode
IS 'Codering van status in wave';
COMMENT ON COLUMN public.tbzaakstatus.dvextcode
IS 'Codering van status in extern zaaksysteem';
COMMENT ON COLUMN public.tbzaakstatus.dvextomschrijving
IS 'Omschrijving van status in extern zaaksysteem';
COMMENT ON COLUMN public.tbzaakstatus.dvresultaatoms
IS 'Resultaatomschirijving bij status ingetrokken en vervallen';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|