Datadictionary OpenWave 3.1.25 |
|
Table: tbmwteams
Datadictionary OpenWave 3.1.25 |
|
Table: tbmwteams
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Verbindingstabel tussen tbtemas en tbmedewerkers
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmwteams_dnkey_seq'::regclass) |
Primary key |
|
|
dnkeyteam |
integer |
|
|
|
|
Foreign key naar tbteams.dnkey |
|
|
dvcodemw |
char(5) |
|
|
|
|
Foreign key naar tbmedewerkers.dvcode |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum waar vanaf combinatie team medewerker nier meer geldig is |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmwteams_codemw |
dvcodemw |
dvcode |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbmwteams_keyteam |
dnkeyteam |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbmwteams_codemw |
dvcodemw IS NOT NULL |
|
cnn_tbmwteams_keyteam |
dnkeyteam IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmwteams |
btree |
|
dnkey |
|
|
|
idu_mwkeyteam_tbmwteams |
btree |
|
dvcodemw, dnkeyteam |
|
|
|
Triggers
There are no triggers for table tbmwteams
Rules
There are no rules for table tbmwteams
Policies
There are no policies for table tbmwteams
Referenced
There are no tables referenced by table tbmwteams
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyteam INTEGER,
dvcodemw CHAR(5),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbmwteams PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbmwteams_codemw CHECK (dvcodemw IS NOT NULL),
CONSTRAINT cnn_tbmwteams_keyteam CHECK (dnkeyteam IS NOT NULL),
CONSTRAINT cfk_tbmwteams_codemw FOREIGN KEY (dvcodemw)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmwteams_keyteam FOREIGN KEY (dnkeyteam)
REFERENCES public.tbteams(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmwteams
IS 'Verbindingstabel tussen tbtemas en tbmedewerkers';
COMMENT ON COLUMN public.tbmwteams.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbmwteams.dnkeyteam
IS 'Foreign key naar tbteams.dnkey';
COMMENT ON COLUMN public.tbmwteams.dvcodemw
IS 'Foreign key naar tbmedewerkers.dvcode';
COMMENT ON COLUMN public.tbmwteams.ddvervaldatum
IS 'Datum waar vanaf combinatie team medewerker nier meer geldig is';
CREATE UNIQUE INDEX idu_mwkeyteam_tbmwteams ON public.tbmwteams
USING btree (dvcodemw COLLATE pg_catalog."default", dnkeyteam);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|