Datadictionary OpenWave 3.1.11 |
|
Table: tbomgbwinstallaties
Datadictionary OpenWave 3.1.11 |
|
Table: tbomgbwinstallaties
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met brandweer installaties per vergunning (omgeving, milieu, gebruiks, bouw/sloop)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbomgbwinstallaties_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeybwinstallaties |
integer |
|
|
|
|
Foreign key naar tbbwinstallaties.dnkey |
|
|
dnkeyomgvergunningen |
integer |
|
|
|
|
Foreign key naar TbOmgvergunning.dnkey |
|
|
dnkeybouwvergunningen |
integer |
|
|
|
|
Foreign key naar TbBouwvergunningen.dnkey |
|
|
dnkeymilvergunningen |
integer |
|
|
|
|
Foreign key naar TbMilvergunningen.dnkey |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbomgbwinst_keybwinst |
dnkeybwinstallaties |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbomgbwinst_keybwverg |
dnkeybouwvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbomgbwinst_keymilverg |
dnkeymilvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbomgbwinst_keyomgverg |
dnkeyomgvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_omgbwinst_keyverg |
((((dnkeybouwvergunningen IS NOT NULL) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) OR (((dnkeymilvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL))) OR (((dnkeyomgvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) |
|
cnn_tbomgbwinst_keybwinst |
dnkeybwinstallaties IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbomgbwinstallaties |
btree |
|
dnkey |
|
|
|
idx_tbomgbwinst_keybwinst |
btree |
|
dnkeybwinstallaties |
|
|
|
idx_tbomgbwinst_keybwverg |
btree |
|
dnkeybouwvergunningen |
|
|
|
idx_tbomgbwinst_keymilverg |
btree |
|
dnkeymilvergunningen |
|
|
|
idx_tbomgbwinst_keyomgverg |
btree |
|
dnkeyomgvergunningen |
|
|
|
Triggers
There are no triggers for table tbomgbwinstallaties
Rules
There are no rules for table tbomgbwinstallaties
Referenced
There are no tables referenced by table tbomgbwinstallaties
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeybwinstallaties INTEGER,
dnkeyomgvergunningen INTEGER,
dnkeybouwvergunningen INTEGER,
dnkeymilvergunningen INTEGER,
CONSTRAINT cpk_tbomgbwinstallaties PRIMARY KEY(dnkey),
CONSTRAINT cnn_omgbwinst_keyverg CHECK (((((dnkeybouwvergunningen IS NOT NULL) AND (dnkeymilvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL)) OR (((dnkeymilvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeyomgvergunningen IS NULL))) OR (((dnkeyomgvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL))),
CONSTRAINT cnn_tbomgbwinst_keybwinst CHECK (dnkeybwinstallaties IS NOT NULL),
CONSTRAINT cfk_tbomgbwinst_keybwinst FOREIGN KEY (dnkeybwinstallaties)
REFERENCES public.tbbwinstallaties(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbomgbwinst_keybwverg FOREIGN KEY (dnkeybouwvergunningen)
REFERENCES public.tbbouwvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbomgbwinst_keymilverg FOREIGN KEY (dnkeymilvergunningen)
REFERENCES public.tbmilvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbomgbwinst_keyomgverg FOREIGN KEY (dnkeyomgvergunningen)
REFERENCES public.tbomgvergunning(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbomgbwinstallaties
IS 'Tabel met brandweer installaties per vergunning (omgeving, milieu, gebruiks, bouw/sloop)';
COMMENT ON COLUMN public.tbomgbwinstallaties.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbomgbwinstallaties.dnkeybwinstallaties
IS 'Foreign key naar tbbwinstallaties.dnkey';
COMMENT ON COLUMN public.tbomgbwinstallaties.dnkeyomgvergunningen
IS 'Foreign key naar TbOmgvergunning.dnkey';
COMMENT ON COLUMN public.tbomgbwinstallaties.dnkeybouwvergunningen
IS 'Foreign key naar TbBouwvergunningen.dnkey';
COMMENT ON COLUMN public.tbomgbwinstallaties.dnkeymilvergunningen
IS 'Foreign key naar TbMilvergunningen.dnkey';
CREATE INDEX idx_tbomgbwinst_keybwinst ON public.tbomgbwinstallaties
USING btree (dnkeybwinstallaties);
CREATE INDEX idx_tbomgbwinst_keybwverg ON public.tbomgbwinstallaties
USING btree (dnkeybouwvergunningen);
CREATE INDEX idx_tbomgbwinst_keymilverg ON public.tbomgbwinstallaties
USING btree (dnkeymilvergunningen);
CREATE INDEX idx_tbomgbwinst_keyomgverg ON public.tbomgbwinstallaties
USING btree (dnkeyomgvergunningen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|