Datadictionary OpenWave 3.1.34 |
|
Table: tbomsinstallaties
Datadictionary OpenWave 3.1.34 |
|
Table: tbomsinstallaties
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met geinstalleerde Openbare Meld Systemen (brandweer) per inrichting
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbomsinstallaties_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar tbmilinrichtingen.dnkey. |
|
|
dvomsnr |
varchar(25) |
|
|
|
|
Het OMS nummer. |
|
|
dvinstalnr |
varchar(20) |
|
|
|
|
Het lijnnummer van de OMS-installatie. |
|
|
dvlokatieoms |
varchar(80) |
|
|
|
|
Lokatieduiding van het geplaatste meldsysteem. |
|
|
ddaansluitdatum |
timestamp |
|
|
|
|
Aangesloten vanaf. |
|
|
dvcontnaam |
varchar(40) |
|
|
|
|
Naam van de contactpersoon. |
|
|
dvcontacttel |
varchar(20) |
|
|
|
|
Telefoon van contactpersoon. |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum dat OMS-installatie is komen te vervallen. |
|
|
dvopmerking |
varchar(100) |
|
|
|
|
Memo veld. |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbomsinstal_keymilinricht |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbomsinstal_keymilinricht |
dnkeymilinrichtingen IS NOT NULL |
|
cnn_tbomsinstal_omsnr |
dvomsnr IS NOT NULL |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbomsinstallaties |
btree |
|
dnkey |
|
|
|
idx_tbomsinstal_keymilinricht |
btree |
|
dnkeymilinrichtingen |
|
|
|
idx_tbomsinstal_omsnr |
btree |
|
dvomsnr |
|
|
|
Triggers
There are no triggers for table tbomsinstallaties
Rules
There are no rules for table tbomsinstallaties
Policies
There are no policies for table tbomsinstallaties
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbomsmeld_keyomsinstal |
dnkeyomsinstallaties |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilinrichtingen INTEGER STORAGE PLAIN,
dvomsnr VARCHAR(25),
dvinstalnr VARCHAR(20),
dvlokatieoms VARCHAR(80),
ddaansluitdatum TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
dvcontnaam VARCHAR(40),
dvcontacttel VARCHAR(20),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
dvopmerking VARCHAR(100),
CONSTRAINT cpk_tbomsinstallaties PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbomsinstal_keymilinricht CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cnn_tbomsinstal_omsnr CHECK (dvomsnr IS NOT NULL),
CONSTRAINT cfk_tbomsinstal_keymilinricht FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbomsinstallaties
IS 'Tabel met geinstalleerde Openbare Meld Systemen (brandweer) per inrichting';
COMMENT ON COLUMN public.tbomsinstallaties.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbomsinstallaties.dnkeymilinrichtingen
IS 'Foreign key naar tbmilinrichtingen.dnkey.';
COMMENT ON COLUMN public.tbomsinstallaties.dvomsnr
IS 'Het OMS nummer.';
COMMENT ON COLUMN public.tbomsinstallaties.dvinstalnr
IS 'Het lijnnummer van de OMS-installatie.';
COMMENT ON COLUMN public.tbomsinstallaties.dvlokatieoms
IS 'Lokatieduiding van het geplaatste meldsysteem.';
COMMENT ON COLUMN public.tbomsinstallaties.ddaansluitdatum
IS 'Aangesloten vanaf.';
COMMENT ON COLUMN public.tbomsinstallaties.dvcontnaam
IS 'Naam van de contactpersoon.';
COMMENT ON COLUMN public.tbomsinstallaties.dvcontacttel
IS 'Telefoon van contactpersoon.';
COMMENT ON COLUMN public.tbomsinstallaties.ddvervaldatum
IS 'Datum dat OMS-installatie is komen te vervallen.';
COMMENT ON COLUMN public.tbomsinstallaties.dvopmerking
IS 'Memo veld.';
CREATE INDEX idx_tbomsinstal_keymilinricht ON public.tbomsinstallaties
USING btree (dnkeymilinrichtingen);
CREATE INDEX idx_tbomsinstal_omsnr ON public.tbomsinstallaties
USING btree (dvomsnr COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10 |
|