Datadictionary OpenWave 3.1.21 |
|
Table: tblokcritkoppel
Datadictionary OpenWave 3.1.21 |
|
Table: tblokcritkoppel
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen tblokcrititems en tblokcritlijsten (t.b.v. criteria bij brandweer aanvalsplan/breiekbaarheidskaart)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tblokcritkoppel_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeylokcrititems |
integer |
|
|
|
|
Foreign key naar TbLokCritItems.dnkey |
|
|
dnkeylokcritlijsten |
integer |
|
|
|
|
Foreign key naar TbLokCritLijsten.dnkey |
|
|
dlvoldoet |
char(1) |
|
|
|
'T'::bpchar |
Criterium voldoet (T of F). |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tblkcrtkop_keylkcrtitem |
dnkeylokcrititems |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tblkcrtkop_keylkcrtlst |
dnkeylokcritlijsten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_tblkcrtkop_dlvoldoet |
dlvoldoet = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
cnn_tblkcrtkop_keylkcrtitem |
dnkeylokcrititems IS NOT NULL |
|
cnn_tblkcrtkop_keylkcrtlst |
dnkeylokcritlijsten IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tblokcritkoppel |
btree |
|
dnkey |
|
|
|
idx_tblkcrtkop_keylkcrtitem |
btree |
|
dnkeylokcrititems |
|
|
|
idx_tblkcrtkop_keylkcrtls |
btree |
|
dnkeylokcritlijsten |
|
|
|
Triggers
There are no triggers for table tblokcritkoppel
Rules
There are no rules for table tblokcritkoppel
Referenced
There are no tables referenced by table tblokcritkoppel
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeylokcrititems INTEGER,
dnkeylokcritlijsten INTEGER,
dlvoldoet CHAR(1) DEFAULT 'T'::bpchar,
CONSTRAINT cpk_tblokcritkoppel PRIMARY KEY(dnkey),
CONSTRAINT chk_tblkcrtkop_dlvoldoet CHECK (dlvoldoet = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT cnn_tblkcrtkop_keylkcrtitem CHECK (dnkeylokcrititems IS NOT NULL),
CONSTRAINT cnn_tblkcrtkop_keylkcrtlst CHECK (dnkeylokcritlijsten IS NOT NULL),
CONSTRAINT cfk_tblkcrtkop_keylkcrtitem FOREIGN KEY (dnkeylokcrititems)
REFERENCES public.tblokcrititems(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tblkcrtkop_keylkcrtlst FOREIGN KEY (dnkeylokcritlijsten)
REFERENCES public.tblokcritlijsten(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tblokcritkoppel
IS 'Koppeltabel tussen tblokcrititems en tblokcritlijsten (t.b.v. criteria bij brandweer aanvalsplan/breiekbaarheidskaart)';
COMMENT ON COLUMN public.tblokcritkoppel.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tblokcritkoppel.dnkeylokcrititems
IS 'Foreign key naar TbLokCritItems.dnkey';
COMMENT ON COLUMN public.tblokcritkoppel.dnkeylokcritlijsten
IS 'Foreign key naar TbLokCritLijsten.dnkey';
COMMENT ON COLUMN public.tblokcritkoppel.dlvoldoet
IS 'Criterium voldoet (T of F).';
CREATE INDEX idx_tblkcrtkop_keylkcrtitem ON public.tblokcritkoppel
USING btree (dnkeylokcrititems);
CREATE INDEX idx_tblkcrtkop_keylkcrtls ON public.tblokcritkoppel
USING btree (dnkeylokcritlijsten);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-10-2020 12:10 |
|