Datadictionary OpenWave 3.1.25 |
|
Table: tbomgbevgezhistorie
Datadictionary OpenWave 3.1.25 |
|
Table: tbomgbevgezhistorie
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met historie bevoegd gezag bij omgevingzaken
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbomgbevgezhistorie_dnkey_seq'::regclass) |
Primary key. |
|
|
dddatumvanaf |
timestamp |
|
|
|
|
Datun waarvanaf organisatie fungeerde als bevoegdgezag bij dnkeyomgvergunningen. |
|
|
dnkeyoin |
integer |
|
|
|
|
Foreign key naar tboin.dnkey. |
|
|
dddatumtotmet |
timestamp |
|
|
|
|
Datun tot en met dat organisatie fungeerde als bevoegdgezag 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_omgbghist_keyoin |
dnkeyoin |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_omgbghist_keyomgverg |
dnkeyomgvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_omgbghist_dnkeyoin |
dnkeyoin IS NOT NULL |
|
cnn_omgbghist_dnkeyomgverg |
dnkeyomgvergunningen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbomgbevgezhistorie |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbomgbevgezhistorie
Rules
There are no rules for table tbomgbevgezhistorie
Policies
There are no policies for table tbomgbevgezhistorie
Referenced
There are no tables referenced by table tbomgbevgezhistorie
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_tbomgbevgezhistorie PRIMARY KEY(dnkey),
CONSTRAINT cnn_omgbghist_dnkeyoin CHECK (dnkeyoin IS NOT NULL),
CONSTRAINT cnn_omgbghist_dnkeyomgverg CHECK (dnkeyomgvergunningen IS NOT NULL),
CONSTRAINT cfk_omgbghist_keyoin FOREIGN KEY (dnkeyoin)
REFERENCES public.tboin(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_omgbghist_keyomgverg FOREIGN KEY (dnkeyomgvergunningen)
REFERENCES public.tbomgvergunning(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbomgbevgezhistorie
IS 'Tabel met historie bevoegd gezag bij omgevingzaken';
COMMENT ON COLUMN public.tbomgbevgezhistorie.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbomgbevgezhistorie.dddatumvanaf
IS 'Datun waarvanaf organisatie fungeerde als bevoegdgezag bij dnkeyomgvergunningen.';
COMMENT ON COLUMN public.tbomgbevgezhistorie.dnkeyoin
IS 'Foreign key naar tboin.dnkey.';
COMMENT ON COLUMN public.tbomgbevgezhistorie.dddatumtotmet
IS 'Datun tot en met dat organisatie fungeerde als bevoegdgezag bij dnkeyomgvergunningen.';
COMMENT ON COLUMN public.tbomgbevgezhistorie.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 |
|