Datadictionary OpenWave 3.1.32 |
|
Table: tbomgbevgezhistorie
Datadictionary OpenWave 3.1.32 |
|
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 |
|
|
|
|
Datum waarvanaf organisatie fungeerde als bevoegd gezag bij dnkeyomgvergunningen. |
|
|
dnkeyoin |
integer |
|
|
|
|
Foreign key naar tboin.dnkey. |
|
|
dddatumtotmet |
timestamp |
|
|
|
|
Datum tot en met dat organisatie fungeerde als bevoegd gezag bij dnkeyomgvergunningen. |
|
|
dnkeyomgvergunningen |
integer |
|
|
|
|
Foreign key naar tbomgvergunning.dnkey. |
|
|
dvcodemedewerker |
char(5) |
|
|
|
|
Foreign key naar tbmedewerkers,dvcode. Degene die bevoegd gezag heeft gewijzigd van DSO zaak |
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 |
|
|
cfk_tbomgbevgezhistorie_codemedewerker |
dvcodemedewerker |
dvcode |
No Action |
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,
dvcodemedewerker CHAR(5),
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,
CONSTRAINT cfk_tbomgbevgezhistorie_codemedewerker FOREIGN KEY (dvcodemedewerker)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE NO ACTION
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 'Datum waarvanaf organisatie fungeerde als bevoegd gezag bij dnkeyomgvergunningen.';
COMMENT ON COLUMN public.tbomgbevgezhistorie.dnkeyoin
IS 'Foreign key naar tboin.dnkey.';
COMMENT ON COLUMN public.tbomgbevgezhistorie.dddatumtotmet
IS 'Datum tot en met dat organisatie fungeerde als bevoegd gezag bij dnkeyomgvergunningen.';
COMMENT ON COLUMN public.tbomgbevgezhistorie.dnkeyomgvergunningen
IS 'Foreign key naar tbomgvergunning.dnkey.';
COMMENT ON COLUMN public.tbomgbevgezhistorie.dvcodemedewerker
IS 'Foreign key naar tbmedewerkers,dvcode. Degene die bevoegd gezag heeft gewijzigd van DSO zaak';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|