Datadictionary OpenWave 3.1.25 |
|
Table: tbbouwafwgeldbpl
Datadictionary OpenWave 3.1.25 |
|
Table: tbbouwafwgeldbpl
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met afwijkingen op het geldende bestemmmingsplan gekoppeld aan een bouw/sloop-vergunning
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbbouwafwgeldbpl_dnkey_seq'::regclass) |
Primary key. |
|
|
dvafwijking |
varchar(100) |
|
|
|
|
De afwijking die van toepassing is op het geldende bestemmingsplan. |
|
|
dnkeybouwvergunningen |
integer |
|
|
|
|
Foreign key naar TbBouwvergunningen.dnkey |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_bwafwgdbpl_bwvergun |
dnkeybouwvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_bwafwgdbpl_keybouwverg |
dnkeybouwvergunningen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbbouwafwgeldbpl |
btree |
|
dnkey |
|
|
|
idx_bwafwgdbpl_keybwverg |
btree |
|
dnkeybouwvergunningen |
|
|
|
Triggers
There are no triggers for table tbbouwafwgeldbpl
Rules
There are no rules for table tbbouwafwgeldbpl
Policies
There are no policies for table tbbouwafwgeldbpl
Referenced
There are no tables referenced by table tbbouwafwgeldbpl
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvafwijking VARCHAR(100),
dnkeybouwvergunningen INTEGER,
CONSTRAINT cpk_tbbouwafwgeldbpl PRIMARY KEY(dnkey),
CONSTRAINT cnn_bwafwgdbpl_keybouwverg CHECK (dnkeybouwvergunningen IS NOT NULL),
CONSTRAINT cfk_bwafwgdbpl_bwvergun FOREIGN KEY (dnkeybouwvergunningen)
REFERENCES public.tbbouwvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbbouwafwgeldbpl
IS 'Tabel met afwijkingen op het geldende bestemmmingsplan gekoppeld aan een bouw/sloop-vergunning';
COMMENT ON COLUMN public.tbbouwafwgeldbpl.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbbouwafwgeldbpl.dvafwijking
IS 'De afwijking die van toepassing is op het geldende bestemmingsplan.';
COMMENT ON COLUMN public.tbbouwafwgeldbpl.dnkeybouwvergunningen
IS 'Foreign key naar TbBouwvergunningen.dnkey';
CREATE INDEX idx_bwafwgdbpl_keybwverg ON public.tbbouwafwgeldbpl
USING btree (dnkeybouwvergunningen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|