Datadictionary OpenWave 3.1.25 |
|
Table: tblokcritkoppel
Datadictionary OpenWave 3.1.25 |
|
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
Policies
There are no policies 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
) ;
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 5-1-2022 14:13 |
|