Datadictionary OpenWave 3.1.32 |
|
Table: tbdsokopprojgroep
Datadictionary OpenWave 3.1.32 |
|
Table: tbdsokopprojgroep
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen DSO projecten (tbdsoproject) en DSO projectgroepen (tbdsoprojectgroep). Een DSO project kan maar aan 1 projectgroep gekoppeld zijn
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbdsokopprojgroep_dnkey_seq'::regclass) |
Primary key |
|
|
dnkeydsoproject |
integer |
|
|
|
|
Foreign key naar DSO project (tbdsoproject.dnkey) |
|
|
dnkeydsoprojectgroep |
integer |
|
|
|
|
Foreign key naar DSO projectgroep (tbdsoprojectgroep.dnkey) |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbdsokopprojgroep_keydsoproject |
dnkeydsoproject |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbdsokopprojgroep_keydsoprojectgroep |
dnkeydsoprojectgroep |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbdsokopprojgroep_keydsoproject |
dnkeydsoproject IS NOT NULL |
|
cnn_tbdsokopprojgroep_keydsoprojectgroep |
dnkeydsoprojectgroep IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbdsokopprojgroep |
btree |
|
dnkey |
|
|
|
idu_tbdsokopprojgroep_keydsoproj |
btree |
|
dnkeydsoproject |
|
|
|
Triggers
There are no triggers for table tbdsokopprojgroep
Rules
There are no rules for table tbdsokopprojgroep
Policies
There are no policies for table tbdsokopprojgroep
Referenced
There are no tables referenced by table tbdsokopprojgroep
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeydsoproject INTEGER,
dnkeydsoprojectgroep INTEGER,
CONSTRAINT cpk_tbdsokopprojgroep PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbdsokopprojgroep_keydsoproject CHECK (dnkeydsoproject IS NOT NULL),
CONSTRAINT cnn_tbdsokopprojgroep_keydsoprojectgroep CHECK (dnkeydsoprojectgroep IS NOT NULL),
CONSTRAINT cfk_tbdsokopprojgroep_keydsoproject FOREIGN KEY (dnkeydsoproject)
REFERENCES public.tbdsoproject(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbdsokopprojgroep_keydsoprojectgroep FOREIGN KEY (dnkeydsoprojectgroep)
REFERENCES public.tbdsoprojectgroep(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbdsokopprojgroep
IS 'Koppeltabel tussen DSO projecten (tbdsoproject) en DSO projectgroepen (tbdsoprojectgroep). Een DSO project kan maar aan 1 projectgroep gekoppeld zijn';
COMMENT ON COLUMN public.tbdsokopprojgroep.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbdsokopprojgroep.dnkeydsoproject
IS 'Foreign key naar DSO project (tbdsoproject.dnkey)';
COMMENT ON COLUMN public.tbdsokopprojgroep.dnkeydsoprojectgroep
IS 'Foreign key naar DSO projectgroep (tbdsoprojectgroep.dnkey)';
CREATE UNIQUE INDEX idu_tbdsokopprojgroep_keydsoproj ON public.tbdsokopprojgroep
USING btree (dnkeydsoproject);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|