Datadictionary OpenWave 3.1.35 |
|
Table: tbkopinsptoest
Datadictionary OpenWave 3.1.35 |
|
Table: tbkopinsptoest
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tbinspecties en tbtoestemmingen voor het ondersteunen van Milieubelastende activiteiten registratie in Digitale Checklisten.
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbkopinsptoest_dnkey_seq'::regclass) |
Primary key |
|
|
dnkeyinspectie |
integer |
|
|
|
|
Foreign key naar tbinspecties.dnkey |
|
|
dnkeytoestemming |
integer |
|
|
|
|
Foreign key naar tbtoestemmingen.dnkey |
|
|
dvextchkldossierid |
varchar(40) |
|
|
|
|
Het (externe) dossier ID van de milieubelastende activiteit in Digitale Checklisten. |
|
|
dndclistnr |
integer |
|
|
|
|
Checklist nummer dat met het lijstnummer in de inspectie correspondeert. |
|
|
dvextchkllistid |
varchar(40) |
|
|
|
|
Het (externe) checklist ID van de milieubelastende activiteit in Digitale Checklisten. |
|
|
ddextchkllistreg |
timestamp |
|
|
|
|
Datum dat de checklist aangemaakt is in Digitale Checklisten. |
|
|
dvextchkllistoms |
varchar(1000) |
|
|
|
|
Omschrijving van de checklist zoals deze in Digitale Checklisten staat. |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbkopinsptoest_dnkeyinspectie |
dnkeyinspectie |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbkopinsptoest_dnkeytoestemming |
dnkeytoestemming |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbkopinsptoest_dnkeyinspectie |
dnkeyinspectie IS NOT NULL |
|
cnn_tbkopinsptoest_dnkeytoestemming |
dnkeytoestemming IS NOT NULL |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbkopinsptoest |
btree |
|
dnkey |
|
|
|
idu_tbkopinsptoest_dnkeytoestemming_dnkeyinspectie_dndclistnr |
btree |
|
dnkeyinspectie, dnkeytoestemming, dndclistnr |
|
|
|
idx_kopinsptoest_checklistid |
btree |
|
dvextchkllistid |
|
|
|
idx_kopinsptoest_toestemming |
btree |
|
dnkeytoestemming |
|
|
|
Triggers
There are no triggers for table tbkopinsptoest
Rules
There are no rules for table tbkopinsptoest
Policies
There are no policies for table tbkopinsptoest
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbinsponrechtm_dnkeykopinsptoest |
dnkeykopinsptoest |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyinspectie INTEGER STORAGE PLAIN,
dnkeytoestemming INTEGER STORAGE PLAIN,
dvextchkldossierid VARCHAR(40),
dndclistnr INTEGER STORAGE PLAIN,
dvextchkllistid VARCHAR(40),
ddextchkllistreg TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
dvextchkllistoms VARCHAR(1000),
CONSTRAINT cpk_tbkopinsptoest PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbkopinsptoest_dnkeyinspectie CHECK (dnkeyinspectie IS NOT NULL),
CONSTRAINT cnn_tbkopinsptoest_dnkeytoestemming CHECK (dnkeytoestemming IS NOT NULL),
CONSTRAINT cfk_tbkopinsptoest_dnkeyinspectie FOREIGN KEY (dnkeyinspectie)
REFERENCES public.tbinspecties(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbkopinsptoest_dnkeytoestemming FOREIGN KEY (dnkeytoestemming)
REFERENCES public.tbtoestemmingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbkopinsptoest
IS 'Koppeltabel tbinspecties en tbtoestemmingen voor het ondersteunen van Milieubelastende activiteiten registratie in Digitale Checklisten.';
COMMENT ON COLUMN public.tbkopinsptoest.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbkopinsptoest.dnkeyinspectie
IS 'Foreign key naar tbinspecties.dnkey';
COMMENT ON COLUMN public.tbkopinsptoest.dnkeytoestemming
IS 'Foreign key naar tbtoestemmingen.dnkey';
COMMENT ON COLUMN public.tbkopinsptoest.dvextchkldossierid
IS 'Het (externe) dossier ID van de milieubelastende activiteit in Digitale Checklisten.';
COMMENT ON COLUMN public.tbkopinsptoest.dndclistnr
IS 'Checklist nummer dat met het lijstnummer in de inspectie correspondeert.';
COMMENT ON COLUMN public.tbkopinsptoest.dvextchkllistid
IS 'Het (externe) checklist ID van de milieubelastende activiteit in Digitale Checklisten.';
COMMENT ON COLUMN public.tbkopinsptoest.ddextchkllistreg
IS 'Datum dat de checklist aangemaakt is in Digitale Checklisten.';
COMMENT ON COLUMN public.tbkopinsptoest.dvextchkllistoms
IS 'Omschrijving van de checklist zoals deze in Digitale Checklisten staat.';
CREATE UNIQUE INDEX idu_tbkopinsptoest_dnkeytoestemming_dnkeyinspectie_dndclistnr ON public.tbkopinsptoest
USING btree (dnkeyinspectie, dnkeytoestemming, dndclistnr)
NULLS NOT DISTINCT;
CREATE INDEX idx_kopinsptoest_checklistid ON public.tbkopinsptoest
USING btree (dvextchkllistid COLLATE pg_catalog."default");
CREATE INDEX idx_kopinsptoest_toestemming ON public.tbkopinsptoest
USING btree (dnkeytoestemming);
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 26/10/2026 11:10 |
|