Datadictionary OpenWave 3.1.25 |
|
Table: tbomguitvinsthistorie
Datadictionary OpenWave 3.1.25 |
|
Table: tbomguitvinsthistorie
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met historie uitvoerende instantie bij omgevingzaken
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbomguitvinsthistorie_dnkey_seq'::regclass) |
Primary key. |
|
|
dddatumvanaf |
timestamp |
|
|
|
|
Datun waarvanaf organisatie fungeerde als uitvoerende instantie bij dnkeyomgvergunningen. |
|
|
dnkeyoin |
integer |
|
|
|
|
Foreign key naar tboin.dnkey. |
|
|
dddatumtotmet |
timestamp |
|
|
|
|
Datun tot en met dat organisatie fungeerde als uitvoerende instantie bij dnkeyomgvergunningen. |
|
|
dnkeyomgvergunningen |
integer |
|
|
|
|
Foreign key naar tbomgvergunning.dnkey. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_omguihist_keyoin |
dnkeyoin |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_omguihist_keyomgverg |
dnkeyomgvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_omguihist_dnkeyoin |
dnkeyoin IS NOT NULL |
|
cnn_omguihist_dnkeyomgverg |
dnkeyomgvergunningen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbomguitvinsthistorie |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbomguitvinsthistorie
Rules
There are no rules for table tbomguitvinsthistorie
Policies
There are no policies for table tbomguitvinsthistorie
Referenced
There are no tables referenced by table tbomguitvinsthistorie
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dddatumvanaf TIMESTAMP WITHOUT TIME ZONE,
dnkeyoin INTEGER,
dddatumtotmet TIMESTAMP WITHOUT TIME ZONE,
dnkeyomgvergunningen INTEGER,
CONSTRAINT cpk_tbomguitvinsthistorie PRIMARY KEY(dnkey),
CONSTRAINT cnn_omguihist_dnkeyoin CHECK (dnkeyoin IS NOT NULL),
CONSTRAINT cnn_omguihist_dnkeyomgverg CHECK (dnkeyomgvergunningen IS NOT NULL),
CONSTRAINT cfk_omguihist_keyoin FOREIGN KEY (dnkeyoin)
REFERENCES public.tboin(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_omguihist_keyomgverg FOREIGN KEY (dnkeyomgvergunningen)
REFERENCES public.tbomgvergunning(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbomguitvinsthistorie
IS 'Tabel met historie uitvoerende instantie bij omgevingzaken';
COMMENT ON COLUMN public.tbomguitvinsthistorie.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbomguitvinsthistorie.dddatumvanaf
IS 'Datun waarvanaf organisatie fungeerde als uitvoerende instantie bij dnkeyomgvergunningen.';
COMMENT ON COLUMN public.tbomguitvinsthistorie.dnkeyoin
IS 'Foreign key naar tboin.dnkey.';
COMMENT ON COLUMN public.tbomguitvinsthistorie.dddatumtotmet
IS 'Datun tot en met dat organisatie fungeerde als uitvoerende instantie bij dnkeyomgvergunningen.';
COMMENT ON COLUMN public.tbomguitvinsthistorie.dnkeyomgvergunningen
IS 'Foreign key naar tbomgvergunning.dnkey.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|