Datadictionary OpenWave 3.1.33 |
|
Table: tbmilvergwetgrond
Datadictionary OpenWave 3.1.33 |
|
Table: tbmilvergwetgrond
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel van wettelijke grondslagen (tbmilcodewetgrond) en milieu/gebruiksvergunningen
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilvergwetgrond_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilcodewetgrond |
integer |
|
|
|
|
Foreign key naar TbMilCodeWetGrond.dnkey. |
|
|
dnkeymilvergunningen |
integer |
|
|
|
|
Foreign key naar TbMilVergunningen.dnkey. |
|
|
dvopmerking |
varchar(60) |
|
|
|
|
Extra opmerking. |
|
|
dnkeyomgvergunningen |
integer |
|
|
|
|
Foreign key naar omgevingszaak waarin de bovenliggende zaak is opgegaan (tbomgvergunning.dnkey). |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilvergwetgrond_dnkeyomgverg |
dnkeyomgvergunningen |
dnkey |
Set Null |
No Action |
|
Immediate |
|
|
cfk_tbmilvergwg_tbmilcodewg |
dnkeymilcodewetgrond |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilvergwg_tbmilverg |
dnkeymilvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_milvergwg_keymilcodewg |
dnkeymilcodewetgrond IS NOT NULL |
|
cnn_milvergwg_keymilverg |
dnkeymilvergunningen IS NOT NULL |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilvergwetgrond |
btree |
|
dnkey |
|
|
|
idx_milvergwg_milcodewg |
btree |
|
dnkeymilcodewetgrond |
|
|
|
idx_milvergwg_milverg |
btree |
|
dnkeymilvergunningen |
|
|
|
Triggers
There are no triggers for table tbmilvergwetgrond
Rules
There are no rules for table tbmilvergwetgrond
Policies
There are no policies for table tbmilvergwetgrond
Referenced
There are no tables referenced by table tbmilvergwetgrond
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilcodewetgrond INTEGER STORAGE PLAIN,
dnkeymilvergunningen INTEGER STORAGE PLAIN,
dvopmerking VARCHAR(60),
dnkeyomgvergunningen INTEGER STORAGE PLAIN,
CONSTRAINT cpk_tbmilvergwetgrond PRIMARY KEY(dnkey),
CONSTRAINT cnn_milvergwg_keymilcodewg CHECK (dnkeymilcodewetgrond IS NOT NULL),
CONSTRAINT cnn_milvergwg_keymilverg CHECK (dnkeymilvergunningen IS NOT NULL),
CONSTRAINT cfk_tbmilvergwetgrond_dnkeyomgverg FOREIGN KEY (dnkeyomgvergunningen)
REFERENCES public.tbomgvergunning(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilvergwg_tbmilcodewg FOREIGN KEY (dnkeymilcodewetgrond)
REFERENCES public.tbmilcodewetgrond(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilvergwg_tbmilverg FOREIGN KEY (dnkeymilvergunningen)
REFERENCES public.tbmilvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilvergwetgrond
IS 'Koppeltabel van wettelijke grondslagen (tbmilcodewetgrond) en milieu/gebruiksvergunningen';
COMMENT ON COLUMN public.tbmilvergwetgrond.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilvergwetgrond.dnkeymilcodewetgrond
IS 'Foreign key naar TbMilCodeWetGrond.dnkey.';
COMMENT ON COLUMN public.tbmilvergwetgrond.dnkeymilvergunningen
IS 'Foreign key naar TbMilVergunningen.dnkey.';
COMMENT ON COLUMN public.tbmilvergwetgrond.dvopmerking
IS 'Extra opmerking.';
COMMENT ON COLUMN public.tbmilvergwetgrond.dnkeyomgvergunningen
IS 'Foreign key naar omgevingszaak waarin de bovenliggende zaak is opgegaan (tbomgvergunning.dnkey).';
CREATE INDEX idx_milvergwg_milcodewg ON public.tbmilvergwetgrond
USING btree (dnkeymilcodewetgrond);
CREATE INDEX idx_milvergwg_milverg ON public.tbmilvergwetgrond
USING btree (dnkeymilvergunningen);
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 21-10-2025 10:22 |
|