Datadictionary OpenWave 3.1.11 |
|
Table: tbbwaantekeningen
Datadictionary OpenWave 3.1.11 |
|
Table: tbbwaantekeningen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met brandweeraantekeningen gekoppeld aan een inrichting, gebruiks-, bouw/sloop- of milieuvergunning
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbbwaantekeningen_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilvergunningen |
integer |
|
|
|
|
Foreign key naar tbmilvergunningen.dnkey |
|
|
dnkeybouwvergunningen |
integer |
|
|
|
|
Foreign key naar tbbouwvergunningen.dnkey |
|
|
dddatum |
timestamp |
|
|
|
|
Datum waarop memo is geschreven. |
|
|
dvmemo |
varchar(2000) |
|
|
|
|
De aantekeningen van de brandweer. Memo is niet geencrypt. |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar tbmilinrichtingen.dnkey |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbbwaantek_keybouwverg |
dnkeybouwvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbbwaantek_keymilinr |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbbwaantek_keymilverg |
dnkeymilvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_bwaantek_keyverg |
((((dnkeybouwvergunningen IS NOT NULL) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) OR (((dnkeymilvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL))) OR (((dnkeymilinrichtingen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL)) |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbbwaantekeningen |
btree |
|
dnkey |
|
|
|
idx_tbbwaantek_keybouwverg |
btree |
|
dnkeybouwvergunningen |
|
|
|
idx_tbbwaantek_keymilinr |
btree |
|
dnkeymilinrichtingen |
|
|
|
idx_tbbwaantek_keymilverg |
btree |
|
dnkeymilvergunningen |
|
|
|
Triggers
There are no triggers for table tbbwaantekeningen
Rules
There are no rules for table tbbwaantekeningen
Referenced
There are no tables referenced by table tbbwaantekeningen
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilvergunningen INTEGER,
dnkeybouwvergunningen INTEGER,
dddatum TIMESTAMP WITHOUT TIME ZONE,
dvmemo VARCHAR(2000),
dnkeymilinrichtingen INTEGER,
CONSTRAINT cpk_tbbwaantekeningen PRIMARY KEY(dnkey),
CONSTRAINT cnn_bwaantek_keyverg CHECK (((((dnkeybouwvergunningen IS NOT NULL) AND (dnkeymilvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL)) OR (((dnkeymilvergunningen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeymilinrichtingen IS NULL))) OR (((dnkeymilinrichtingen IS NOT NULL) AND (dnkeybouwvergunningen IS NULL)) AND (dnkeymilvergunningen IS NULL))),
CONSTRAINT cfk_tbbwaantek_keybouwverg FOREIGN KEY (dnkeybouwvergunningen)
REFERENCES public.tbbouwvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbbwaantek_keymilinr FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbbwaantek_keymilverg FOREIGN KEY (dnkeymilvergunningen)
REFERENCES public.tbmilvergunningen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbbwaantekeningen
IS 'Tabel met brandweeraantekeningen gekoppeld aan een inrichting, gebruiks-, bouw/sloop- of milieuvergunning';
COMMENT ON COLUMN public.tbbwaantekeningen.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbbwaantekeningen.dnkeymilvergunningen
IS 'Foreign key naar tbmilvergunningen.dnkey';
COMMENT ON COLUMN public.tbbwaantekeningen.dnkeybouwvergunningen
IS 'Foreign key naar tbbouwvergunningen.dnkey';
COMMENT ON COLUMN public.tbbwaantekeningen.dddatum
IS 'Datum waarop memo is geschreven.';
COMMENT ON COLUMN public.tbbwaantekeningen.dvmemo
IS 'De aantekeningen van de brandweer. Memo is niet geencrypt.';
COMMENT ON COLUMN public.tbbwaantekeningen.dnkeymilinrichtingen
IS 'Foreign key naar tbmilinrichtingen.dnkey';
CREATE INDEX idx_tbbwaantek_keybouwverg ON public.tbbwaantekeningen
USING btree (dnkeybouwvergunningen);
CREATE INDEX idx_tbbwaantek_keymilinr ON public.tbbwaantekeningen
USING btree (dnkeymilinrichtingen);
CREATE INDEX idx_tbbwaantek_keymilverg ON public.tbbwaantekeningen
USING btree (dnkeymilvergunningen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|