Table tbcompartiment

Datadictionary OpenWave 3.1.16

Table: tbcompartiment

Schema

public

Owner

waveuser005

Tablespace

(default)

Descriptions

Tabel van compartimenten (verbindingstabel van medewerkers, soorten zaken ,soorten inrrichtingen en gemeentes).

Fields

Name	Data type	Default	Description
dnkey	serial	nextval('tbcompartiment_dnkey_seq'::regclass)	Primary key.
dvnaam	varchar(50)		Naam van het compartiment bijv omgevingsdient Y of gemeente X.
dvomschrijving	varchar(2000)		Omschrijving van het compartiment .
ddvervaldatum	timestamp		Datum waarvanaf het compartiment niet meer in gebruik is.

Foreign Keys

There are no foreign keys for table tbcompartiment

Check Constraints

There are no check constraints for table tbcompartiment

Indices

Name	Type	Function	Fields	Primary Key	Unique	Description
cpk_tbcompartiment	btree		dnkey

Triggers

There are no triggers for table tbcompartiment

Rules

There are no rules for table tbcompartiment

Referenced

Table	Schema	Foreign Key	Fields	FK Table	FK Fields	Delete Action	Update Action	Check Time
tbadviesinstanties	public	cfk_tbadviesinst_keycomp	dnkeycompartiment	public.tbcompartiment	dnkey	Cascade	No Action	Immediate
tbdocumenten	public	cfk_documenten_keycomp	dnkeycompartiment	public.tbcompartiment	dnkey	Cascade	No Action	Immediate
tbkopcompgem	public	cfk_kopcompgem_keycomp	dnkeycompartiment	public.tbcompartiment	dnkey	Cascade	No Action	Immediate
tbkopcompsrtbwvverg	public	cfk_kopcompsrtbwvverg_keycomp	dnkeycompartiment	public.tbcompartiment	dnkey	Cascade	No Action	Immediate
tbkopcompsrthhzaak	public	cfk_kopcompsrthhzaak_keycomp	dnkeycompartiment	public.tbcompartiment	dnkey	Cascade	No Action	Immediate
tbkopcompsrthorverg	public	cfk_kopcompsrthorverg_keycomp	dnkeycompartiment	public.tbcompartiment	dnkey	Cascade	No Action	Immediate
tbkopcompsrtinfoav	public	cfk_kopcompsrtinfoav_keycomp	dnkeycompartiment	public.tbcompartiment	dnkey	Cascade	No Action	Immediate
tbkopcompsrtmilinr	public	cfk_kopcompsrtmilinr_keycomp	dnkeycompartiment	public.tbcompartiment	dnkey	Cascade	No Action	Immediate
tbkopcompsrtmilverg	public	cfk_kopcompsrtmilverg_keycomp	dnkeycompartiment	public.tbcompartiment	dnkey	Cascade	No Action	Immediate
tbkopcompsrtomgverg	public	cfk_kopcompsrtomgverg_keycomp	dnkeycompartiment	public.tbcompartiment	dnkey	Cascade	No Action	Immediate
tbkopcompsrtovvverg	public	cfk_kopcompsrtovvverg_keycomp	dnkeycompartiment	public.tbcompartiment	dnkey	Cascade	No Action	Immediate
tbmedewerkers	public	cfk_medew_keycompartiment	dnkeycompartiment	public.tbcompartiment	dnkey	Set Null	No Action	Immediate
tbrapporten	public	cfk_tbrapporten_keycomp	dnkeycompartiment	public.tbcompartiment	dnkey	Cascade	No Action	Immediate

Properties

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

Definition

CREATE TABLE public.tbcompartiment ( dnkey SERIAL, dvnaam VARCHAR(50), dvomschrijving VARCHAR(2000), ddvervaldatum TIMESTAMP WITHOUT TIME ZONE, CONSTRAINT cpk_tbcompartiment PRIMARY KEY(dnkey) ) WITH (oids = false); COMMENT ON TABLE public.tbcompartiment IS 'Tabel van compartimenten (verbindingstabel van medewerkers, soorten zaken ,soorten inrrichtingen en gemeentes).'; COMMENT ON COLUMN public.tbcompartiment.dnkey IS 'Primary key.'; COMMENT ON COLUMN public.tbcompartiment.dvnaam IS 'Naam van het compartiment bijv omgevingsdient Y of gemeente X.'; COMMENT ON COLUMN public.tbcompartiment.dvomschrijving IS 'Omschrijving van het compartiment .'; COMMENT ON COLUMN public.tbcompartiment.ddvervaldatum IS 'Datum waarvanaf het compartiment niet meer in gebruik is.';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 19-3-2019 13:43