Datadictionary OpenWave 3.1.25 |
|
Table: tbkopproccheck
Datadictionary OpenWave 3.1.25 |
|
Table: tbkopproccheck
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppelingstabel tussen termijnbewakingsprocessen (tbprocedures) en een ckecklijsten (tbckecklijstnaam)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkeyprocedure |
integer |
|
|
|
|
Foreign Key naar TbProcedures.DnKey. De combinatie dnkeychecklistnaam en dnkeyprocedure moet uniek zijn |
|
|
dnkeychecklistnaam |
integer |
|
|
|
|
Foreign Key naar TbChecklistnaam.DnKey.De combinatie dnkeychecklistnaam en dnkeyprocedure moet uniek zijn |
|
|
dnkey |
serial |
|
|
|
nextval('tbkopproccheck_dnkey_seq'::regclass) |
Primary key |
|
|
dlauto |
char(1) |
|
|
|
'T'::bpchar |
F of T, indien T dan wordt de checklijst automatisch aangemaakt bij het aanmaken van het proces |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbkopproc_tbcheck |
dnkeychecklistnaam |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbkopproc_tbproc |
dnkeyprocedure |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_kopproccheck_dlauto |
dlauto = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
cnn_kopproccheck_dlauto |
dlauto IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbkopproccheck |
btree |
|
dnkey |
|
|
|
idu_kopproc_keyprocchkl |
btree |
|
dnkeyprocedure, dnkeychecklistnaam |
|
|
|
idx_kopproc_keycheck |
btree |
|
dnkeychecklistnaam |
|
|
|
Triggers
There are no triggers for table tbkopproccheck
Rules
There are no rules for table tbkopproccheck
Policies
There are no policies for table tbkopproccheck
Referenced
There are no tables referenced by table tbkopproccheck
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkeyprocedure INTEGER NOT NULL,
dnkeychecklistnaam INTEGER NOT NULL,
dnkey SERIAL,
dlauto CHAR(1) DEFAULT 'T'::bpchar,
CONSTRAINT cpk_tbkopproccheck PRIMARY KEY(dnkey),
CONSTRAINT chk_kopproccheck_dlauto CHECK (dlauto = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT cnn_kopproccheck_dlauto CHECK (dlauto IS NOT NULL),
CONSTRAINT cfk_tbkopproc_tbcheck FOREIGN KEY (dnkeychecklistnaam)
REFERENCES public.tbchecklistnaam(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbkopproc_tbproc FOREIGN KEY (dnkeyprocedure)
REFERENCES public.tbprocedures(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbkopproccheck
IS 'Koppelingstabel tussen termijnbewakingsprocessen (tbprocedures) en een ckecklijsten (tbckecklijstnaam)';
COMMENT ON COLUMN public.tbkopproccheck.dnkeyprocedure
IS 'Foreign Key naar TbProcedures.DnKey. De combinatie dnkeychecklistnaam en dnkeyprocedure moet uniek zijn';
COMMENT ON COLUMN public.tbkopproccheck.dnkeychecklistnaam
IS 'Foreign Key naar TbChecklistnaam.DnKey.De combinatie dnkeychecklistnaam en dnkeyprocedure moet uniek zijn';
COMMENT ON COLUMN public.tbkopproccheck.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbkopproccheck.dlauto
IS 'F of T, indien T dan wordt de checklijst automatisch aangemaakt bij het aanmaken van het proces';
CREATE UNIQUE INDEX idu_kopproc_keyprocchkl ON public.tbkopproccheck
USING btree (dnkeyprocedure, dnkeychecklistnaam);
CREATE INDEX idx_kopproc_keycheck ON public.tbkopproccheck
USING btree (dnkeychecklistnaam);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|