Datadictionary OpenWave 3.1.25 |
|
Table: tbmwloginverklaringen
Datadictionary OpenWave 3.1.25 |
|
Table: tbmwloginverklaringen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen tbmedewerkers en tbloginverklaringen. Een rij betekent dat de medewerkers de verklaring heeft gelezen
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmwloginverklaringen_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyloginverklaringen |
integer |
|
|
|
|
Foreign key naar tbloginverklaringen.dnkey |
|
|
dvcodemedewerkers |
char(5) |
|
|
|
|
Foreign key naar tbmedewerkers.dvcode. |
|
|
dddatumgelezen |
timestamp |
|
|
|
|
Datum dat medewerker de verklaring heeft gelezen. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_mwloginverkl_codemw |
dvcodemedewerkers |
dvcode |
Cascade |
No Action |
|
Immediate |
|
|
cfk_mwloginverkl_keyloginverkl |
dnkeyloginverklaringen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tbmwloginverklaringen
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmwloginverklaringen |
btree |
|
dnkey |
|
|
|
idx_mwloginverkl_codemw |
btree |
|
dvcodemedewerkers |
|
|
|
idx_mwloginverkl_keyloginverkl |
btree |
|
dnkeyloginverklaringen |
|
|
|
Triggers
There are no triggers for table tbmwloginverklaringen
Rules
There are no rules for table tbmwloginverklaringen
Policies
There are no policies for table tbmwloginverklaringen
Referenced
There are no tables referenced by table tbmwloginverklaringen
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyloginverklaringen INTEGER,
dvcodemedewerkers CHAR(5),
dddatumgelezen TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbmwloginverklaringen PRIMARY KEY(dnkey),
CONSTRAINT cfk_mwloginverkl_codemw FOREIGN KEY (dvcodemedewerkers)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_mwloginverkl_keyloginverkl FOREIGN KEY (dnkeyloginverklaringen)
REFERENCES public.tbloginverklaringen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmwloginverklaringen
IS 'Koppeltabel tussen tbmedewerkers en tbloginverklaringen. Een rij betekent dat de medewerkers de verklaring heeft gelezen';
COMMENT ON COLUMN public.tbmwloginverklaringen.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmwloginverklaringen.dnkeyloginverklaringen
IS 'Foreign key naar tbloginverklaringen.dnkey';
COMMENT ON COLUMN public.tbmwloginverklaringen.dvcodemedewerkers
IS 'Foreign key naar tbmedewerkers.dvcode.';
COMMENT ON COLUMN public.tbmwloginverklaringen.dddatumgelezen
IS 'Datum dat medewerker de verklaring heeft gelezen.';
CREATE INDEX idx_mwloginverkl_codemw ON public.tbmwloginverklaringen
USING btree (dvcodemedewerkers COLLATE pg_catalog."default");
CREATE INDEX idx_mwloginverkl_keyloginverkl ON public.tbmwloginverklaringen
USING btree (dnkeyloginverklaringen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|