Datadictionary OpenWave 3.1.34 |
|
Table: tbinternerollen
Datadictionary OpenWave 3.1.34 |
|
Table: tbinternerollen
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel van interne rollen die medewerkers kunnen aannemen bij omgevingszaken
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbinternerollen_dnkey_seq'::regclass) |
Primary key |
|
|
dvrolcode |
char(3) |
|
|
|
|
Code van interne rol |
|
|
dvrolomschrijving |
varchar(40) |
|
|
|
|
Omschrijving die hoort bij de interne rol zoals Deskundige of Jurist |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum waarop interne rol is komen te vervallen |
Foreign Keys
There are no foreign keys for table tbinternerollen
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbintrol_dvrolcode |
dvrolcode IS NOT NULL |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbinternerollen |
btree |
|
dnkey |
|
|
|
idu_tbinternerollen_rolcode |
btree |
|
dvrolcode |
|
|
|
Triggers
There are no triggers for table tbinternerollen
Rules
There are no rules for table tbinternerollen
Policies
There are no policies for table tbinternerollen
Referenced
Table | Schema | Foreign Key | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_kopsrtomgintrol_dnkeyinternerol |
dnkeyinternerol |
dnkey |
Cascade |
No Action |
|
Immediate |
|
||
public |
cfk_omgvergintbetrok_dnkeyinternerol |
dnkeyinternerol |
dnkey |
No Action |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvrolcode CHAR(3),
dvrolomschrijving VARCHAR(40),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE STORAGE PLAIN,
CONSTRAINT cpk_tbinternerollen PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbintrol_dvrolcode CHECK (dvrolcode IS NOT NULL)
) ;
COMMENT ON TABLE public.tbinternerollen
IS 'Tabel van interne rollen die medewerkers kunnen aannemen bij omgevingszaken';
COMMENT ON COLUMN public.tbinternerollen.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbinternerollen.dvrolcode
IS 'Code van interne rol';
COMMENT ON COLUMN public.tbinternerollen.dvrolomschrijving
IS 'Omschrijving die hoort bij de interne rol zoals Deskundige of Jurist';
COMMENT ON COLUMN public.tbinternerollen.ddvervaldatum
IS 'Datum waarop interne rol is komen te vervallen';
CREATE UNIQUE INDEX idu_tbinternerollen_rolcode ON public.tbinternerollen
USING btree (dvrolcode 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 |
|