Table tbteams

Datadictionary OpenWave 3.1.34

Table: tbteams

Schema

public

Owner

waveuser005

Tablespace

(default)

Descriptions

Tabel met teamnamen waar een of meer medewerkers aan verbonden zijn. Anders dan in rechtengroep kunnen medewerkers aan meerdere teams verbonden zijn

Columns

Name	Data type	Default	Description
dnkey	serial	nextval('tbteams_dnkey_seq'::regclass)	Primary key
dvteamnaam	varchar(100)		Naam van het team
ddvervaldatum	timestamp		Datum waar vanaf team niet meer gekozen kan worden
dvcodeteamleider	char(5)		Foreign key naar tbmedewerkers.dvcode
dnkeycompartiment	integer		Foreign key naar tbcompartiment.dnkey
dlisctteam	char(1)	'T'::bpchar	T of F. Indien T dan mag dit team gekozen worden bij het aanmaken van een collegiale toets. Default true.

Foreign Keys

Name	Columns	FK Table	FK Columns	Delete Action	Update Action	Deferrable	Check Time	Description
cfk_tbteams_codeteaml	dvcodeteamleider	public.tbmedewerkers	dvcode	Set Null	No Action		Immediate
cfk_tbteams_keycomp	dnkeycompartiment	public.tbcompartiment	dnkey	Set Null	No Action		Immediate

Check Constraints

Name	Condition	Description
chk_tbteams_dlisctteam	dlisctteam = ANY (ARRAY['F'::bpchar, 'T'::bpchar])
cnn_tbteams_dlisctteam	dlisctteam IS NOT NULL

Indices

Name	Type	Function	Columns	Primary Key	Unique	Description
cpk_tbteams	btree		dnkey
idx_teams_teamnaam	btree		dvteamnaam

Triggers

There are no triggers for table tbteams

Rules

There are no rules for table tbteams

Policies

There are no policies for table tbteams

Referenced

Table	Schema	Foreign Key	Columns	FK Table	FK Columns	Delete Action	Update Action	Check Time
tbadviesinstanties	public	cfk_tbadviesinst_keyteamsdefv	dnkeyteamsdefverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbadviezen	public	cfk_tbadviesinst_keyteamsver	dnkeyteamsverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbbulkinsptoezicht	public	cfk_tbbulkinsptoezicht_keyteamzaakverantw	dnkeyteamszaakverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbcorrespcollegtoets	public	cfk_tbcorrespcolleg_dnkeyteamsverantw	dnkeyteamsverantw	public.tbteams	dnkey	No Action	No Action	Immediate
tbhandhavingen	public	cfk_tbhandh_keyteamzaakv	dnkeyteamszaakverantw	public.tbteams	dnkey	No Action	No Action	Immediate
tbhorecavergunningen	public	cfk_tbhorverg_keyteamzaakv	dnkeyteamszaakverantw	public.tbteams	dnkey	No Action	No Action	Immediate
tbinfoaanvragen	public	cfk_tbinfoavrg_keyteamzaakv	dnkeyteamszaakverantw	public.tbteams	dnkey	No Action	No Action	Immediate
tbkopcompsrthhzaak	public	cfk_kopcmpsrthh_keyteamdefver	dnkeyteamsdefverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbkopcompsrthorverg	public	cfk_kopcmpsrthor_keyteamdefver	dnkeyteamsdefverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbkopcompsrtinfoav	public	cfk_kopcmpsrtinf_keyteamdefver	dnkeyteamsdefverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbkopcompsrtmilverg	public	cfk_kopcmpsrtmil_keyteamdefver	dnkeyteamsdefverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbkopcompsrtomgverg	public	cfk_kopcmpsrtomg_keyteamdefver	dnkeyteamsdefverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbkopcompsrtovvverg	public	cfk_kopcmpsrtovv_keyteamdefver	dnkeyteamsdefverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbkopsrtomginternrol	public	cfk_kopsrtomgintrol_dnkeyteams	dnkeyteams	public.tbteams	dnkey	Set Null	No Action	Immediate
tbkopsrttoestproduct	public	cfk_tbkopsrttoestproduct_dnkeyteams	dnkeyteams	public.tbteams	dnkey	Set Null	No Action	Immediate
tbmilvergunningen	public	cfk_tbmilverg_keyteamzaakv	dnkeyteamszaakverantw	public.tbteams	dnkey	No Action	No Action	Immediate
tbmwteams	public	cfk_tbmwteams_keyteam	dnkeyteam	public.tbteams	dnkey	Cascade	No Action	Immediate
tbomgvergintbetrokkenennn	public	cfk_omgvergintbetrok_dnkeyteams	dnkeyteams	public.tbteams	dnkey	No Action	No Action	Immediate
tbomgvergunning	public	cfk_tbomgverg_keyteamzaakv	dnkeyteamszaakverantw	public.tbteams	dnkey	No Action	No Action	Immediate
tbovvergunningen	public	cfk_tbovverg_keyteamzaakv	dnkeyteamszaakverantw	public.tbteams	dnkey	No Action	No Action	Immediate
tbprocitems	public	cfk_tbprocitems_keyteams	dnkeyteams	public.tbteams	dnkey	Set Null	No Action	Immediate
tbsoorthhzaak	public	cfk_tbsrthhzaak_keyteamdefver	dnkeyteamsdefverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbsoorthorverg	public	cfk_tbsrthorverg_keyteamdefver	dnkeyteamsdefverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbsoortinfoaanvraag	public	cfk_tbsrtinfvrg_keyteamdefver	dnkeyteamsdefverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbsoortmilverg	public	cfk_tbsrtmilverg_keyteamdefver	dnkeyteamsdefverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbsoortomgverg	public	cfk_tbsoortomgv_keyteamdefver	dnkeyteamsdefverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbsoortovverg	public	cfk_tbsrtovverg_keyteamdefver	dnkeyteamsdefverantw	public.tbteams	dnkey	Set Null	No Action	Immediate
tbsrttoestemming	public	cfk_tbsrttoestemming_dnkeyteams	dnkeyteams	public.tbteams	dnkey	Set Null	No Action	Immediate
tbtermijnbewstappen	public	cfk_termijnbewst_keyteams	dnkeyteams	public.tbteams	dnkey	Set Null	No Action	Immediate

Properties

Property	Value
Inherited From
Rows	0
Pages	0
System
Temporary
With OID

Definition

CREATE TABLE public.tbteams ( dnkey SERIAL, dvteamnaam VARCHAR(100), ddvervaldatum TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN, dvcodeteamleider CHAR(5), dnkeycompartiment INTEGER STORAGE PLAIN, dlisctteam CHAR(1) DEFAULT 'T'::bpchar, CONSTRAINT cpk_tbteams PRIMARY KEY(dnkey), CONSTRAINT chk_tbteams_dlisctteam CHECK (dlisctteam = ANY (ARRAY['F'::bpchar, 'T'::bpchar])), CONSTRAINT cnn_tbteams_dlisctteam CHECK (dlisctteam IS NOT NULL), CONSTRAINT cfk_tbteams_codeteaml FOREIGN KEY (dvcodeteamleider) REFERENCES public.tbmedewerkers(dvcode) ON DELETE SET NULL ON UPDATE NO ACTION NOT DEFERRABLE, CONSTRAINT cfk_tbteams_keycomp FOREIGN KEY (dnkeycompartiment) REFERENCES public.tbcompartiment(dnkey) ON DELETE SET NULL ON UPDATE NO ACTION NOT DEFERRABLE ) ; COMMENT ON TABLE public.tbteams IS 'Tabel met teamnamen waar een of meer medewerkers aan verbonden zijn. Anders dan in rechtengroep kunnen medewerkers aan meerdere teams verbonden zijn'; COMMENT ON COLUMN public.tbteams.dnkey IS 'Primary key'; COMMENT ON COLUMN public.tbteams.dvteamnaam IS 'Naam van het team'; COMMENT ON COLUMN public.tbteams.ddvervaldatum IS 'Datum waar vanaf team niet meer gekozen kan worden'; COMMENT ON COLUMN public.tbteams.dvcodeteamleider IS 'Foreign key naar tbmedewerkers.dvcode'; COMMENT ON COLUMN public.tbteams.dnkeycompartiment IS 'Foreign key naar tbcompartiment.dnkey'; COMMENT ON COLUMN public.tbteams.dlisctteam IS 'T of F. Indien T dan mag dit team gekozen worden bij het aanmaken van een collegiale toets. Default true.'; CREATE INDEX idx_teams_teamnaam ON public.tbteams USING btree (dvteamnaam COLLATE pg_catalog."default");

This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10