Datadictionary OpenWave 3.1.11 |
|
Table: tbkopproccheck
Datadictionary OpenWave 3.1.11 |
|
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. Tezamen met DnKeyChecklistNaam primary key. |
|
|
dnkeychecklistnaam |
integer |
|
|
|
|
Foreign Key naar TbChecklistnaam.DnKey. Tezamen met DnKeyprocedures primary key. |
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
There are no check constraints for table tbkopproccheck
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbkopproccheck |
btree |
|
dnkeyprocedure, dnkeychecklistnaam |
|
|
|
idu_kopproc_keyproc |
btree |
|
dnkeyprocedure |
|
|
|
idx_kopproc_keycheck |
btree |
|
dnkeychecklistnaam |
|
|
|
Triggers
There are no triggers for table tbkopproccheck
Rules
There are no rules 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,
CONSTRAINT cpk_tbkopproccheck PRIMARY KEY(dnkeyprocedure, dnkeychecklistnaam),
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
)
WITH (oids = false);
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. Tezamen met DnKeyChecklistNaam primary key.';
COMMENT ON COLUMN public.tbkopproccheck.dnkeychecklistnaam
IS 'Foreign Key naar TbChecklistnaam.DnKey. Tezamen met DnKeyprocedures primary key.';
CREATE UNIQUE INDEX idu_kopproc_keyproc ON public.tbkopproccheck
USING btree (dnkeyprocedure);
CREATE INDEX idx_kopproc_keycheck ON public.tbkopproccheck
USING btree (dnkeychecklistnaam);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|