Datadictionary OpenWave 3.1.11 |
|
Table: tbomgpreparaties
Datadictionary OpenWave 3.1.11 |
|
Table: tbomgpreparaties
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met brandweer preparaties per vergunning (omgeving, milieu, gebruiks, bouw/sloop)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbomgpreparaties_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeypreparaties |
integer |
|
|
|
|
Foreign key naar tbpreparaties.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_tbomgprep_keybwverg |
dnkeybouwvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbomgprep_keymilverg |
dnkeymilvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbomgprep_keyomgverg |
dnkeyomgvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbomgprep_keyprep |
dnkeypreparaties |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_omgprep_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_tbomgprep_keyprep |
dnkeypreparaties IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbomgpreparaties |
btree |
|
dnkey |
|
|
|
idx_tbomgprep_keybwverg |
btree |
|
dnkeybouwvergunningen |
|
|
|
idx_tbomgprep_keymilverg |
btree |
|
dnkeymilvergunningen |
|
|
|
idx_tbomgprep_keyomgverg |
btree |
|
dnkeyomgvergunningen |
|
|
|
idx_tbomgprep_keyprep |
btree |
|
dnkeypreparaties |
|
|
|
Triggers
There are no triggers for table tbomgpreparaties
Rules
There are no rules for table tbomgpreparaties
Referenced
There are no tables referenced by table tbomgpreparaties
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeypreparaties INTEGER,
dnkeyomgvergunningen INTEGER,
dnkeybouwvergunningen INTEGER,
dnkeymilvergunningen INTEGER,
CONSTRAINT cpk_tbomgpreparaties PRIMARY KEY(dnkey),
CONSTRAINT cnn_omgprep_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_tbomgprep_keyprep CHECK (dnkeypreparaties IS NOT NULL),
CONSTRAINT cfk_tbomgprep_keybwverg FOREIGN KEY (dnkeybouwvergunningen)
REFERENCES public.tbbouwvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbomgprep_keymilverg FOREIGN KEY (dnkeymilvergunningen)
REFERENCES public.tbmilvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbomgprep_keyomgverg FOREIGN KEY (dnkeyomgvergunningen)
REFERENCES public.tbomgvergunning(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbomgprep_keyprep FOREIGN KEY (dnkeypreparaties)
REFERENCES public.tbpreparaties(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbomgpreparaties
IS 'Tabel met brandweer preparaties per vergunning (omgeving, milieu, gebruiks, bouw/sloop)';
COMMENT ON COLUMN public.tbomgpreparaties.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbomgpreparaties.dnkeypreparaties
IS 'Foreign key naar tbpreparaties.dnkey';
COMMENT ON COLUMN public.tbomgpreparaties.dnkeyomgvergunningen
IS 'Foreign key naar TbOmgvergunning.dnkey';
COMMENT ON COLUMN public.tbomgpreparaties.dnkeybouwvergunningen
IS 'Foreign key naar TbBouwvergunningen.dnkey';
COMMENT ON COLUMN public.tbomgpreparaties.dnkeymilvergunningen
IS 'Foreign key naar TbMilvergunningen.dnkey';
CREATE INDEX idx_tbomgprep_keybwverg ON public.tbomgpreparaties
USING btree (dnkeybouwvergunningen);
CREATE INDEX idx_tbomgprep_keymilverg ON public.tbomgpreparaties
USING btree (dnkeymilvergunningen);
CREATE INDEX idx_tbomgprep_keyomgverg ON public.tbomgpreparaties
USING btree (dnkeyomgvergunningen);
CREATE INDEX idx_tbomgprep_keyprep ON public.tbomgpreparaties
USING btree (dnkeypreparaties);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|