Datadictionary OpenWave 3.1.25 |
|
Table: tbovvrijnwbplnn
Datadictionary OpenWave 3.1.25 |
|
Table: tbovvrijnwbplnn
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen een overige vergunning en een nieuw bestemmingsplan in de categorie Vrijstelling
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkeyovvergunningen |
integer |
|
|
|
|
Foreign key naar TbOvvergunningen.dnkey. Vormt te zamen met DnKeybestemmingsplannen de primary key. |
|
|
dnkeybplvrijst |
integer |
|
|
|
|
Foreign key naar TbBestemmingsplannen.DnKey. Vormt te zamen met DnKeyOvvergunningen de primary key. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_ovnwbplvrijst_bestplan |
dnkeybplvrijst |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_ovvrijnwbplnn_ovverg |
dnkeyovvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tbovvrijnwbplnn
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbovvrijnwbplnn |
btree |
|
dnkeyovvergunningen, dnkeybplvrijst |
|
|
|
idx_ovnwbplvrijst_keybestplan |
btree |
|
dnkeybplvrijst |
|
|
|
idx_ovvrijnwbplnn_keyovvergun |
btree |
|
dnkeyovvergunningen |
|
|
|
Triggers
There are no triggers for table tbovvrijnwbplnn
Rules
There are no rules for table tbovvrijnwbplnn
Policies
There are no policies for table tbovvrijnwbplnn
Referenced
There are no tables referenced by table tbovvrijnwbplnn
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkeyovvergunningen INTEGER NOT NULL,
dnkeybplvrijst INTEGER NOT NULL,
CONSTRAINT cpk_tbovvrijnwbplnn PRIMARY KEY(dnkeyovvergunningen, dnkeybplvrijst),
CONSTRAINT cfk_ovnwbplvrijst_bestplan FOREIGN KEY (dnkeybplvrijst)
REFERENCES public.tbbestemmingsplannen(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_ovvrijnwbplnn_ovverg FOREIGN KEY (dnkeyovvergunningen)
REFERENCES public.tbovvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbovvrijnwbplnn
IS 'Koppeltabel tussen een overige vergunning en een nieuw bestemmingsplan in de categorie Vrijstelling';
COMMENT ON COLUMN public.tbovvrijnwbplnn.dnkeyovvergunningen
IS 'Foreign key naar TbOvvergunningen.dnkey. Vormt te zamen met DnKeybestemmingsplannen de primary key.';
COMMENT ON COLUMN public.tbovvrijnwbplnn.dnkeybplvrijst
IS 'Foreign key naar TbBestemmingsplannen.DnKey. Vormt te zamen met DnKeyOvvergunningen de primary key.';
CREATE INDEX idx_ovnwbplvrijst_keybestplan ON public.tbovvrijnwbplnn
USING btree (dnkeybplvrijst);
CREATE INDEX idx_ovvrijnwbplnn_keyovvergun ON public.tbovvrijnwbplnn
USING btree (dnkeyovvergunningen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|