Datadictionary OpenWave 3.1.34 |
|
Table: tbovafwgeldbpl
Datadictionary OpenWave 3.1.34 |
|
Table: tbovafwgeldbpl
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met afwijkingen op het geldende bestemmmingsplan gekoppeld aan een overige vergunning
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbovafwgeldbpl_dnkey_seq'::regclass) |
Primary key. |
|
|
dvafwijking |
varchar(100) |
|
|
|
|
De afwijking die van toepassing is op het geldende bestemmingsplan. |
|
|
dnkeyovvergunningen |
integer |
|
|
|
|
Foreign key naar TbOvVergunningen.dnkey. |
|
|
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_ovafwgdbpl_ovvergun |
dnkeyovvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbovafwgeldbpl_dnkeyomgverg |
dnkeyomgvergunningen |
dnkey |
Set Null |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_ovafwgeldbpl_ovverg |
dnkeyovvergunningen IS NOT NULL |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbovafwgeldbpl |
btree |
|
dnkey |
|
|
|
idx_ovafwgdbpl_keyovverg |
btree |
|
dnkeyovvergunningen |
|
|
|
Triggers
There are no triggers for table tbovafwgeldbpl
Rules
There are no rules for table tbovafwgeldbpl
Policies
There are no policies for table tbovafwgeldbpl
Referenced
There are no tables referenced by table tbovafwgeldbpl
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvafwijking VARCHAR(100),
dnkeyovvergunningen INTEGER STORAGE PLAIN,
dnkeyomgvergunningen INTEGER STORAGE PLAIN,
CONSTRAINT cpk_tbovafwgeldbpl PRIMARY KEY(dnkey),
CONSTRAINT cnn_ovafwgeldbpl_ovverg CHECK (dnkeyovvergunningen IS NOT NULL),
CONSTRAINT cfk_ovafwgdbpl_ovvergun FOREIGN KEY (dnkeyovvergunningen)
REFERENCES public.tbovvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbovafwgeldbpl_dnkeyomgverg FOREIGN KEY (dnkeyomgvergunningen)
REFERENCES public.tbomgvergunning(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbovafwgeldbpl
IS 'Tabel met afwijkingen op het geldende bestemmmingsplan gekoppeld aan een overige vergunning';
COMMENT ON COLUMN public.tbovafwgeldbpl.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbovafwgeldbpl.dvafwijking
IS 'De afwijking die van toepassing is op het geldende bestemmingsplan.';
COMMENT ON COLUMN public.tbovafwgeldbpl.dnkeyovvergunningen
IS 'Foreign key naar TbOvVergunningen.dnkey.';
COMMENT ON COLUMN public.tbovafwgeldbpl.dnkeyomgvergunningen
IS 'Foreign key naar omgevingszaak waarin de bovenliggende zaak is opgegaan (tbomgvergunning.dnkey).';
CREATE INDEX idx_ovafwgdbpl_keyovverg ON public.tbovafwgeldbpl
USING btree (dnkeyovvergunningen);
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10 |
|