Datadictionary OpenWave 3.1.25 |
|
Table: tbomsmeldingen
Datadictionary OpenWave 3.1.25 |
|
Table: tbomsmeldingen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met geregistreerde OMS-meldingen
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbomsmeldingen_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyomsinstallaties |
integer |
|
|
|
|
Foreign key naar tbomsinstallaties.dnkey. |
|
|
dnkeyomssrtmelding |
integer |
|
|
|
|
Foreign key naar tbOmsrtmelding.dnkey. |
|
|
dnkeyomsoorzaak |
integer |
|
|
|
|
Foreign key naar tbomsOorzaak.dnkey. |
|
|
dnkeyomswvu |
integer |
|
|
|
|
Foreign key naar TbOmsWVU.dnkey (wijze van uitrukken). |
|
|
dnkeyomskwal |
integer |
|
|
|
|
Foreign key naar TbOmsKwal.dnkey (kwaliteit). |
|
|
dnkeyomssrtmelder |
integer |
|
|
|
|
Foreign key naar TbOmsSrtMelder.dnkey. |
|
|
dddatumtijd |
timestamp |
|
|
|
|
Datum en tijdstip van melding. |
|
|
dvopmerking |
varchar(50) |
|
|
|
|
Vrije opmerking. |
|
|
dvmeldergroep |
varchar(50) |
|
|
|
|
Vrij veld m.b.t. meldergroep / lokatie |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbomsmeld_keyomsinstal |
dnkeyomsinstallaties |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbomsmeld_keyomskwal |
dnkeyomskwal |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbomsmeld_keyomsoorzaak |
dnkeyomsoorzaak |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbomsmeld_keyomssrtmelder |
dnkeyomssrtmelder |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbomsmeld_keyomssrtmelding |
dnkeyomssrtmelding |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbomsmeld_keyomswvu |
dnkeyomswvu |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbomsmeld_datumtijd |
dddatumtijd IS NOT NULL |
|
cnn_tbomsmeld_keyomsinstal |
dnkeyomsinstallaties IS NOT NULL |
|
cnn_tbomsmeld_keyomskwal |
dnkeyomskwal IS NOT NULL |
|
cnn_tbomsmeld_keyomsoorzaak |
dnkeyomsoorzaak IS NOT NULL |
|
cnn_tbomsmeld_keyomssrtmelder |
dnkeyomssrtmelder IS NOT NULL |
|
cnn_tbomsmeld_keyomssrtmelding |
dnkeyomssrtmelding IS NOT NULL |
|
cnn_tbomsmeld_keyomswvu |
dnkeyomswvu IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbomsmeldingen |
btree |
|
dnkey |
|
|
|
idx_tbomsmeld_datumtijd |
btree |
|
dddatumtijd |
|
|
|
idx_tbomsmeld_keyomsinstal |
btree |
|
dnkeyomsinstallaties |
|
|
|
Triggers
There are no triggers for table tbomsmeldingen
Rules
There are no rules for table tbomsmeldingen
Policies
There are no policies for table tbomsmeldingen
Referenced
There are no tables referenced by table tbomsmeldingen
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyomsinstallaties INTEGER,
dnkeyomssrtmelding INTEGER,
dnkeyomsoorzaak INTEGER,
dnkeyomswvu INTEGER,
dnkeyomskwal INTEGER,
dnkeyomssrtmelder INTEGER,
dddatumtijd TIMESTAMP WITHOUT TIME ZONE,
dvopmerking VARCHAR(50),
dvmeldergroep VARCHAR(50),
CONSTRAINT cpk_tbomsmeldingen PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbomsmeld_datumtijd CHECK (dddatumtijd IS NOT NULL),
CONSTRAINT cnn_tbomsmeld_keyomsinstal CHECK (dnkeyomsinstallaties IS NOT NULL),
CONSTRAINT cnn_tbomsmeld_keyomskwal CHECK (dnkeyomskwal IS NOT NULL),
CONSTRAINT cnn_tbomsmeld_keyomsoorzaak CHECK (dnkeyomsoorzaak IS NOT NULL),
CONSTRAINT cnn_tbomsmeld_keyomssrtmelder CHECK (dnkeyomssrtmelder IS NOT NULL),
CONSTRAINT cnn_tbomsmeld_keyomssrtmelding CHECK (dnkeyomssrtmelding IS NOT NULL),
CONSTRAINT cnn_tbomsmeld_keyomswvu CHECK (dnkeyomswvu IS NOT NULL),
CONSTRAINT cfk_tbomsmeld_keyomsinstal FOREIGN KEY (dnkeyomsinstallaties)
REFERENCES public.tbomsinstallaties(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbomsmeld_keyomskwal FOREIGN KEY (dnkeyomskwal)
REFERENCES public.tbomskwal(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbomsmeld_keyomsoorzaak FOREIGN KEY (dnkeyomsoorzaak)
REFERENCES public.tbomsoorzaak(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbomsmeld_keyomssrtmelder FOREIGN KEY (dnkeyomssrtmelder)
REFERENCES public.tbomssrtmelder(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbomsmeld_keyomssrtmelding FOREIGN KEY (dnkeyomssrtmelding)
REFERENCES public.tbomssrtmelding(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbomsmeld_keyomswvu FOREIGN KEY (dnkeyomswvu)
REFERENCES public.tbomswvu(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbomsmeldingen
IS 'Tabel met geregistreerde OMS-meldingen';
COMMENT ON COLUMN public.tbomsmeldingen.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbomsmeldingen.dnkeyomsinstallaties
IS 'Foreign key naar tbomsinstallaties.dnkey.';
COMMENT ON COLUMN public.tbomsmeldingen.dnkeyomssrtmelding
IS 'Foreign key naar tbOmsrtmelding.dnkey.';
COMMENT ON COLUMN public.tbomsmeldingen.dnkeyomsoorzaak
IS 'Foreign key naar tbomsOorzaak.dnkey.';
COMMENT ON COLUMN public.tbomsmeldingen.dnkeyomswvu
IS 'Foreign key naar TbOmsWVU.dnkey (wijze van uitrukken).';
COMMENT ON COLUMN public.tbomsmeldingen.dnkeyomskwal
IS 'Foreign key naar TbOmsKwal.dnkey (kwaliteit).';
COMMENT ON COLUMN public.tbomsmeldingen.dnkeyomssrtmelder
IS 'Foreign key naar TbOmsSrtMelder.dnkey.';
COMMENT ON COLUMN public.tbomsmeldingen.dddatumtijd
IS 'Datum en tijdstip van melding.';
COMMENT ON COLUMN public.tbomsmeldingen.dvopmerking
IS 'Vrije opmerking.';
COMMENT ON COLUMN public.tbomsmeldingen.dvmeldergroep
IS 'Vrij veld m.b.t. meldergroep / lokatie';
CREATE INDEX idx_tbomsmeld_datumtijd ON public.tbomsmeldingen
USING btree (dddatumtijd);
CREATE INDEX idx_tbomsmeld_keyomsinstal ON public.tbomsmeldingen
USING btree (dnkeyomsinstallaties);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|