Datadictionary OpenWave 3.1.11 |
|
Table: tbzaakstatus
Datadictionary OpenWave 3.1.11 |
|
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
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)
)
WITH (oids = false);
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 22-2-2017 10:50 |
|