Table tbteams

Datadictionary OpenWave 3.1.25

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.

Fields

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 nier meer gekozen kan worden
dvcodeteamleider	char(5)		Foreign key naar tbmedewerkers.dvcode
dnkeycompartiment	integer		Foreign key naar tbcompartiment.dnkey

Foreign Keys

Name	Fields	FK Table	FK Fields	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

There are no check constraints for table tbteams

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
cpk_tbteams	btree		dnkey

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	Fields	FK Table	FK Fields	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
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
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
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
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, dvcodeteamleider CHAR(5), dnkeycompartiment INTEGER, CONSTRAINT cpk_tbteams PRIMARY KEY(dnkey), 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 nier 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';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13