Datadictionary OpenWave 3.1.35 |
|
Table: tbbwaantekeningen
Datadictionary OpenWave 3.1.35 |
|
Table: tbbwaantekeningen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met brandweeraantekeningen gekoppeld aan een inrichting (de oude aantekeningen bij tbmilvergunningen en tbbouwvergunningen zijn overgezet naar tbmilalert onder de key van tbomgvergunning
Columns
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 |
|
|
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 | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
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 |
((dnkeymilvergunningen IS NOT NULL) AND (dnkeymilinrichtingen IS NULL)) OR ((dnkeymilinrichtingen IS NOT NULL) AND (dnkeymilvergunningen IS NULL)) |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbbwaantekeningen |
btree |
|
dnkey |
|
|
|
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
Policies
There are no policies 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 STORAGE PLAIN,
dddatum TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
dvmemo VARCHAR(2000),
dnkeymilinrichtingen INTEGER STORAGE PLAIN,
CONSTRAINT cpk_tbbwaantekeningen PRIMARY KEY(dnkey),
CONSTRAINT cnn_bwaantek_keyverg CHECK (((dnkeymilvergunningen IS NOT NULL) AND (dnkeymilinrichtingen IS NULL)) OR ((dnkeymilinrichtingen IS NOT NULL) AND (dnkeymilvergunningen IS NULL))),
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
) ;
COMMENT ON TABLE public.tbbwaantekeningen
IS 'Tabel met brandweeraantekeningen gekoppeld aan een inrichting (de oude aantekeningen bij tbmilvergunningen en tbbouwvergunningen zijn overgezet naar tbmilalert onder de key van tbomgvergunning';
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.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_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.sqlmanager.net/products/postgresql/manager) at 26/10/2026 11:10 |
|