Datadictionary OpenWave 3.1.26 |
|
Table: tbomgdsoaanvulintrek
Datadictionary OpenWave 3.1.26 |
|
Table: tbomgdsoaanvulintrek
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Ttabel met historie volgnummers (aanvullen, intrekken) bij dso stambericht
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbomgdsoaanvulintrek_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyomgvergunning |
integer |
|
|
|
|
foreign key naar tbomgvergunning.dnkey |
|
|
dvdsovolgnr |
varchar(5) |
|
|
|
|
dso volgnummer bij aanvullen of intrekken |
|
|
dddatum |
timestamp |
|
|
|
|
Datum van aanvulling cq intrekking |
|
|
dvdoel |
varchar(9) |
|
|
|
|
Aanvullen if Intrekken |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbomgdsoaanvulintrek_dnkeyomgvergunning |
dnkeyomgvergunning |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbomgdsoaanvulintrek_dnkeyomgvergunning |
dnkeyomgvergunning IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbomgdsoaanvulintrek |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbomgdsoaanvulintrek
Rules
There are no rules for table tbomgdsoaanvulintrek
Policies
There are no policies for table tbomgdsoaanvulintrek
Referenced
There are no tables referenced by table tbomgdsoaanvulintrek
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyomgvergunning INTEGER,
dvdsovolgnr VARCHAR(5),
dddatum TIMESTAMP WITHOUT TIME ZONE,
dvdoel VARCHAR(9),
CONSTRAINT cpk_tbomgdsoaanvulintrek PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbomgdsoaanvulintrek_dnkeyomgvergunning CHECK (dnkeyomgvergunning IS NOT NULL),
CONSTRAINT cfk_tbomgdsoaanvulintrek_dnkeyomgvergunning FOREIGN KEY (dnkeyomgvergunning)
REFERENCES public.tbomgvergunning(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbomgdsoaanvulintrek
IS 'Ttabel met historie volgnummers (aanvullen, intrekken) bij dso stambericht';
COMMENT ON COLUMN public.tbomgdsoaanvulintrek.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbomgdsoaanvulintrek.dnkeyomgvergunning
IS 'foreign key naar tbomgvergunning.dnkey';
COMMENT ON COLUMN public.tbomgdsoaanvulintrek.dvdsovolgnr
IS 'dso volgnummer bij aanvullen of intrekken';
COMMENT ON COLUMN public.tbomgdsoaanvulintrek.dddatum
IS 'Datum van aanvulling cq intrekking';
COMMENT ON COLUMN public.tbomgdsoaanvulintrek.dvdoel
IS 'Aanvullen if Intrekken';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 28-4-2022 10:20 |
|