Datadictionary OpenWave 3.1.25 |
|
Table: tbmedewisadviseurvoor
Datadictionary OpenWave 3.1.25 |
|
Table: tbmedewisadviseurvoor
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel van adviesinstanties per medewerker waarvoor de betreffende medewerker externe advieseur is.
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmedewisadviseurvoor_dnkey_seq'::regclass) |
Primary key. |
|
|
dvcodemedewerkers |
char(5) |
|
|
|
|
Foreign key naar tbmedewerkers.dvcode. |
|
|
dvcodeadviesinstanties |
char(4) |
|
|
|
|
Foreign key naar tbadviesisntanties.dvcode. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_medewisadv_codeadv |
dvcodeadviesinstanties |
dvcode |
Cascade |
No Action |
|
Immediate |
|
|
cfk_medewisadv_codemw |
dvcodemedewerkers |
dvcode |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_medewisadv_codeadv |
dvcodeadviesinstanties IS NOT NULL |
|
cnn_medewisadv_codemw |
dvcodemedewerkers IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmedewisadviseurvoor |
btree |
|
dnkey |
|
|
|
idu_medewisadv_codemw_codeadv |
btree |
|
dvcodemedewerkers, dvcodeadviesinstanties |
|
|
|
Triggers
There are no triggers for table tbmedewisadviseurvoor
Rules
There are no rules for table tbmedewisadviseurvoor
Policies
There are no policies for table tbmedewisadviseurvoor
Referenced
There are no tables referenced by table tbmedewisadviseurvoor
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcodemedewerkers CHAR(5),
dvcodeadviesinstanties CHAR(4),
CONSTRAINT cpk_tbmedewisadviseurvoor PRIMARY KEY(dnkey),
CONSTRAINT cnn_medewisadv_codeadv CHECK (dvcodeadviesinstanties IS NOT NULL),
CONSTRAINT cnn_medewisadv_codemw CHECK (dvcodemedewerkers IS NOT NULL),
CONSTRAINT cfk_medewisadv_codeadv FOREIGN KEY (dvcodeadviesinstanties)
REFERENCES public.tbadviesinstanties(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_medewisadv_codemw FOREIGN KEY (dvcodemedewerkers)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmedewisadviseurvoor
IS 'Tabel van adviesinstanties per medewerker waarvoor de betreffende medewerker externe advieseur is.';
COMMENT ON COLUMN public.tbmedewisadviseurvoor.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmedewisadviseurvoor.dvcodemedewerkers
IS 'Foreign key naar tbmedewerkers.dvcode.';
COMMENT ON COLUMN public.tbmedewisadviseurvoor.dvcodeadviesinstanties
IS 'Foreign key naar tbadviesisntanties.dvcode.';
CREATE UNIQUE INDEX idu_medewisadv_codemw_codeadv ON public.tbmedewisadviseurvoor
USING btree (dvcodemedewerkers COLLATE pg_catalog."default", dvcodeadviesinstanties COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|