Datadictionary OpenWave 3.1.11 |
|
Table: tbomsmeldingen
Datadictionary OpenWave 3.1.11 |
|
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
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
)
WITH (oids = false);
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 22-2-2017 10:50 |
|