Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met collegiale toetsen op een geregistreerd document (dochtertabel van tbcorrespondentie)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
---|---|---|---|---|---|---|---|---|
|
dnkey |
serial |
|
nextval('tbcorrespcollegtoets_dnkey_seq'::regclass) |
Primary key. |
|||
|
dnkeycorrespondentie |
integer |
|
|
|
|
Foreign key naar tbcorrespondentie.dnkey (geregistreerd document) waar de toets bijhoort |
|
|
dvcodemwaanvrager |
char(5) |
|
|
|
|
Foreign key naar tbmedewerkers.dvcode. Degene die de collegiale toets vraagt |
|
|
dvcodemwvoorwie |
char(5) |
|
|
|
|
Foreign key naar tbmedewerkers.dvcode. Degene die de toets uitvoert |
|
|
|
dddatumaanvraag |
timestamp |
|
|
|
|
Datum dat toet is aangevraagd |
|
|
dddatumgetoetst |
timestamp |
|
|
|
|
Datum dat de toets is gedaan |
|
|
dlakkoord |
char(1) |
|
|
|
'N'::bpchar |
T of F of N. (N)og niet bekend is de defaultwaarde |
|
|
dvopmerkingaanvraag |
varchar(500) |
|
|
|
|
Opmerking bij de aanvraag van de toets |
|
|
dvopmerkinggetoetst |
varchar(500) |
|
|
|
|
Opmerking van de toetser |
|
|
dlgezien |
char(1) |
|
|
|
'F'::bpchar |
T of F. Indien T dan heeft de aanvrager het resultaat van de toetser gezien. F is de default |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
---|---|---|---|---|---|---|---|---|
cfk_tbcorrespcolleg_codeav |
dvcodemwaanvrager |
dvcode |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbcorrespcolleg_codevw |
dvcodemwvoorwie |
dvcode |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbcorrespcolleg_keycorresp |
dnkeycorrespondentie |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
---|---|---|
chk_tbcorrespcolleg_dlakkoord |
dlakkoord = ANY (ARRAY['F'::bpchar, 'T'::bpchar, 'N'::bpchar]) |
|
chk_tbcorrespcolleg_dlgezien |
dlgezien = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
cnn_tbcorrespcolleg_codeav |
dvcodemwaanvrager IS NOT NULL |
|
cnn_tbcorrespcolleg_codevw |
dvcodemwvoorwie IS NOT NULL |
|
cnn_tbcorrespcolleg_dlakkoord |
dlakkoord IS NOT NULL |
|
cnn_tbcorrespcolleg_dlgezien |
dlgezien IS NOT NULL |
|
cnn_tbcorrespcolleg_keycorresp |
dnkeycorrespondentie IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
---|---|---|---|---|---|---|
cpk_tbcorrespcollegtoets |
btree |
|
dnkey |
|
||
idx_correspcolleg_codeaanvr |
btree |
|
dvcodemwaanvrager, dlgezien, dddatumgetoetst |
|
|
|
idx_correspcolleg_codetoetser |
btree |
|
dvcodemwvoorwie, dddatumaanvraag |
|
|
|
idx_correspcolleg_keycorresp |
btree |
|
dnkeycorrespondentie |
|
|
|
Triggers
There are no triggers for table tbcorrespcollegtoets
Rules
There are no rules for table tbcorrespcollegtoets
Referenced
There are no tables referenced by table tbcorrespcollegtoets
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE public.tbcorrespcollegtoets (
dnkey SERIAL,
dnkeycorrespondentie INTEGER,
dvcodemwaanvrager CHAR(5),
dvcodemwvoorwie CHAR(5),
dddatumaanvraag TIMESTAMP WITHOUT TIME ZONE,
dddatumgetoetst TIMESTAMP WITHOUT TIME ZONE,
dlakkoord CHAR(1) DEFAULT 'N'::bpchar,
dvopmerkingaanvraag VARCHAR(500),
dvopmerkinggetoetst VARCHAR(500),
dlgezien CHAR(1) DEFAULT 'F'::bpchar,
CONSTRAINT cpk_tbcorrespcollegtoets PRIMARY KEY(dnkey),
CONSTRAINT chk_tbcorrespcolleg_dlakkoord CHECK (dlakkoord = ANY (ARRAY['F'::bpchar, 'T'::bpchar, 'N'::bpchar])),
CONSTRAINT chk_tbcorrespcolleg_dlgezien CHECK (dlgezien = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT cnn_tbcorrespcolleg_codeav CHECK (dvcodemwaanvrager IS NOT NULL),
CONSTRAINT cnn_tbcorrespcolleg_codevw CHECK (dvcodemwvoorwie IS NOT NULL),
CONSTRAINT cnn_tbcorrespcolleg_dlakkoord CHECK (dlakkoord IS NOT NULL),
CONSTRAINT cnn_tbcorrespcolleg_dlgezien CHECK (dlgezien IS NOT NULL),
CONSTRAINT cnn_tbcorrespcolleg_keycorresp CHECK (dnkeycorrespondentie IS NOT NULL),
CONSTRAINT cfk_tbcorrespcolleg_codeav FOREIGN KEY (dvcodemwaanvrager)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbcorrespcolleg_codevw FOREIGN KEY (dvcodemwvoorwie)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbcorrespcolleg_keycorresp FOREIGN KEY (dnkeycorrespondentie)
REFERENCES public.tbcorrespondentie(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbcorrespcollegtoets
IS 'Tabel met collegiale toetsen op een geregistreerd document (dochtertabel van tbcorrespondentie)';
COMMENT ON COLUMN public.tbcorrespcollegtoets.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbcorrespcollegtoets.dnkeycorrespondentie
IS 'Foreign key naar tbcorrespondentie.dnkey (geregistreerd document) waar de toets bijhoort';
COMMENT ON COLUMN public.tbcorrespcollegtoets.dvcodemwaanvrager
IS 'Foreign key naar tbmedewerkers.dvcode. Degene die de collegiale toets vraagt';
COMMENT ON COLUMN public.tbcorrespcollegtoets.dvcodemwvoorwie
IS 'Foreign key naar tbmedewerkers.dvcode. Degene die de toets uitvoert';
COMMENT ON COLUMN public.tbcorrespcollegtoets.dddatumaanvraag
IS 'Datum dat toet is aangevraagd';
COMMENT ON COLUMN public.tbcorrespcollegtoets.dddatumgetoetst
IS 'Datum dat de toets is gedaan';
COMMENT ON COLUMN public.tbcorrespcollegtoets.dlakkoord
IS 'T of F of N. (N)og niet bekend is de defaultwaarde';
COMMENT ON COLUMN public.tbcorrespcollegtoets.dvopmerkingaanvraag
IS 'Opmerking bij de aanvraag van de toets';
COMMENT ON COLUMN public.tbcorrespcollegtoets.dvopmerkinggetoetst
IS 'Opmerking van de toetser';
COMMENT ON COLUMN public.tbcorrespcollegtoets.dlgezien
IS 'T of F. Indien T dan heeft de aanvrager het resultaat van de toetser gezien. F is de default';
CREATE INDEX idx_correspcolleg_codeaanvr ON public.tbcorrespcollegtoets
USING btree (dvcodemwaanvrager COLLATE pg_catalog."default", dlgezien COLLATE pg_catalog."default", dddatumgetoetst);
CREATE INDEX idx_correspcolleg_codetoetser ON public.tbcorrespcollegtoets
USING btree (dvcodemwvoorwie COLLATE pg_catalog."default", dddatumaanvraag);
CREATE INDEX idx_correspcolleg_keycorresp ON public.tbcorrespcollegtoets
USING btree (dnkeycorrespondentie);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 30-11-2020 15:21 |
![]() ![]() ![]() |