Datadictionary OpenWave 3.1.25 |
|
Table: tbprocitemcheck
Datadictionary OpenWave 3.1.25 |
|
Table: tbprocitemcheck
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tbchecklistnaam en tbprocitems
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbprocitemcheck_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyprocitems |
integer |
|
|
|
|
Foreign key naar tbprocitems.dnkey. |
|
|
dnkeychecklistnaam |
integer |
|
|
|
|
Foreign key naar tbchecklistnaam.dnkey. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_procitemcheck_keycheck |
dnkeychecklistnaam |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_procitemcheck_keyproci |
dnkeyprocitems |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbprocitemcheck_dnkeychk |
dnkeychecklistnaam IS NOT NULL |
|
cnn_tbprocitemcheck_dnkeyproc |
dnkeyprocitems IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbprocitemcheck |
btree |
|
dnkey |
|
|
|
idu_procitemcheck_procitem |
btree |
|
dnkeyprocitems |
|
|
|
Triggers
There are no triggers for table tbprocitemcheck
Rules
There are no rules for table tbprocitemcheck
Policies
There are no policies for table tbprocitemcheck
Referenced
There are no tables referenced by table tbprocitemcheck
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyprocitems INTEGER,
dnkeychecklistnaam INTEGER,
CONSTRAINT cpk_tbprocitemcheck PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbprocitemcheck_dnkeychk CHECK (dnkeychecklistnaam IS NOT NULL),
CONSTRAINT cnn_tbprocitemcheck_dnkeyproc CHECK (dnkeyprocitems IS NOT NULL),
CONSTRAINT cfk_procitemcheck_keycheck FOREIGN KEY (dnkeychecklistnaam)
REFERENCES public.tbchecklistnaam(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_procitemcheck_keyproci FOREIGN KEY (dnkeyprocitems)
REFERENCES public.tbprocitems(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbprocitemcheck
IS 'Koppeltabel tbchecklistnaam en tbprocitems';
COMMENT ON COLUMN public.tbprocitemcheck.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbprocitemcheck.dnkeyprocitems
IS 'Foreign key naar tbprocitems.dnkey.';
COMMENT ON COLUMN public.tbprocitemcheck.dnkeychecklistnaam
IS 'Foreign key naar tbchecklistnaam.dnkey.';
CREATE UNIQUE INDEX idu_procitemcheck_procitem ON public.tbprocitemcheck
USING btree (dnkeyprocitems);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|