Datadictionary OpenWave 3.1.34 |
|
Table: tbkopsrttoestproduct
Datadictionary OpenWave 3.1.34 |
|
Table: tbkopsrttoestproduct
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel ten dienste van het automatisch toekennen van een zaakverantw team en product.subproduct bij verwerken van DSO zaken
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbkopsrttoestproduct_dnkey_seq'::regclass) |
Primary key |
|
|
dnkeysrttoestemming |
integer |
|
|
|
|
Not null. Foreign key naar tbsrttoestemming.dnkey |
|
|
dnkeyproducten |
integer |
|
|
|
|
Not null. Foreign key naar tbproducten.dnkey (productdefinities per zaaktype) bij omgevingzaaktypes. |
|
|
dnkeysubproductdef |
integer |
|
|
|
|
Foreign key naar tbsusbproductendef.dnkey (koppeltabel tbproductdef en tbsubproducten) |
|
|
dnkeyteams |
integer |
|
|
|
|
Foreign key naar tbtemas.dnkey. |
|
|
dnkeysoortomgverg |
integer |
|
|
|
|
Not null. Foreign key naar tbsoortomgverg.dnkey (zaaktypes omgvergunningen) |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbkopsrttoestproduct_dnkeyproducten |
dnkeyproducten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbkopsrttoestproduct_dnkeysoortomgverg |
dnkeysoortomgverg |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbkopsrttoestproduct_dnkeysrttoestemming |
dnkeysrttoestemming |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbkopsrttoestproduct_dnkeysubproductdef |
dnkeysubproductdef |
dnkey |
Set Null |
No Action |
|
Immediate |
|
|
cfk_tbkopsrttoestproduct_dnkeyteams |
dnkeyteams |
dnkey |
Set Null |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbkopsrttoestproduct_dnkeydnkeyproducten |
dnkeyproducten IS NOT NULL |
|
cnn_tbkopsrttoestproduct_dnkeysoortomgverg |
dnkeysoortomgverg IS NOT NULL |
|
cnn_tbkopsrttoestproduct_dnkeysrttoestemming |
dnkeysrttoestemming IS NOT NULL |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbkopsrttoestproduct |
btree |
|
dnkey |
|
|
|
idu_tbkopsrttoestproduct_keysrttstsrtomg |
btree |
|
dnkeysrttoestemming, dnkeysoortomgverg |
|
|
|
Triggers
There are no triggers for table tbkopsrttoestproduct
Rules
There are no rules for table tbkopsrttoestproduct
Policies
There are no policies for table tbkopsrttoestproduct
Referenced
There are no tables referenced by table tbkopsrttoestproduct
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeysrttoestemming INTEGER STORAGE PLAIN,
dnkeyproducten INTEGER STORAGE PLAIN,
dnkeysubproductdef INTEGER STORAGE PLAIN,
dnkeyteams INTEGER STORAGE PLAIN,
dnkeysoortomgverg INTEGER STORAGE PLAIN,
CONSTRAINT cpk_tbkopsrttoestproduct PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbkopsrttoestproduct_dnkeydnkeyproducten CHECK (dnkeyproducten IS NOT NULL),
CONSTRAINT cnn_tbkopsrttoestproduct_dnkeysoortomgverg CHECK (dnkeysoortomgverg IS NOT NULL),
CONSTRAINT cnn_tbkopsrttoestproduct_dnkeysrttoestemming CHECK (dnkeysrttoestemming IS NOT NULL),
CONSTRAINT cfk_tbkopsrttoestproduct_dnkeyproducten FOREIGN KEY (dnkeyproducten)
REFERENCES public.tbproducten(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbkopsrttoestproduct_dnkeysoortomgverg FOREIGN KEY (dnkeysoortomgverg)
REFERENCES public.tbsoortomgverg(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbkopsrttoestproduct_dnkeysrttoestemming FOREIGN KEY (dnkeysrttoestemming)
REFERENCES public.tbsrttoestemming(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbkopsrttoestproduct_dnkeysubproductdef FOREIGN KEY (dnkeysubproductdef)
REFERENCES public.tbsubproductdef(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbkopsrttoestproduct_dnkeyteams FOREIGN KEY (dnkeyteams)
REFERENCES public.tbteams(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbkopsrttoestproduct
IS 'Koppeltabel ten dienste van het automatisch toekennen van een zaakverantw team en product.subproduct bij verwerken van DSO zaken';
COMMENT ON COLUMN public.tbkopsrttoestproduct.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbkopsrttoestproduct.dnkeysrttoestemming
IS 'Not null. Foreign key naar tbsrttoestemming.dnkey';
COMMENT ON COLUMN public.tbkopsrttoestproduct.dnkeyproducten
IS 'Not null. Foreign key naar tbproducten.dnkey (productdefinities per zaaktype) bij omgevingzaaktypes.';
COMMENT ON COLUMN public.tbkopsrttoestproduct.dnkeysubproductdef
IS 'Foreign key naar tbsusbproductendef.dnkey (koppeltabel tbproductdef en tbsubproducten)';
COMMENT ON COLUMN public.tbkopsrttoestproduct.dnkeyteams
IS 'Foreign key naar tbtemas.dnkey.';
COMMENT ON COLUMN public.tbkopsrttoestproduct.dnkeysoortomgverg
IS 'Not null. Foreign key naar tbsoortomgverg.dnkey (zaaktypes omgvergunningen)';
CREATE UNIQUE INDEX idu_tbkopsrttoestproduct_keysrttstsrtomg ON public.tbkopsrttoestproduct
USING btree (dnkeysrttoestemming, dnkeysoortomgverg);
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10 |
|