Datadictionary OpenWave 3.1.34 |
|
Table: tbomgvergintbetrokkenennn
Datadictionary OpenWave 3.1.34 |
|
Table: tbomgvergintbetrokkenennn
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Koppeltabel tussen tbinternerollen en tbomgvergunning, en tbmedewerkers of tbteams : welke medewerkers/teams zijn onder welke rol verbonden aan een omgevingszaak
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbomgvergintbetrokkenennn_dnkey_seq'::regclass) |
Primary key |
|
|
dnkeyomgvergunningen |
integer |
|
|
|
|
Not null. Foreign key naar tbomgvergunning.dnkey (omgevingszaak) |
|
|
dnkeyinternerol |
integer |
|
|
|
|
Not null. Foreign key naar tbinternerollen.dnkey |
|
|
dvcodemedewerkers |
char(5) |
|
|
|
|
Foreign key naar tbmedewerkers.dvcode |
|
|
dnkeyteams |
integer |
|
|
|
|
Foreign key naar tbteams.dnkey |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_omgvergintbetrok_dnkeyinternerol |
dnkeyinternerol |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_omgvergintbetrok_dnkeyomgvergunningen |
dnkeyomgvergunningen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_omgvergintbetrok_dnkeyteams |
dnkeyteams |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_omgvergintbetrok_dvcodemedew |
dvcodemedewerkers |
dvcode |
No Action |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_omgvergintbetrok_dnkeyinternerol |
dnkeyinternerol IS NOT NULL |
|
cnn_omgvergintbetrok_dnkeyomgvergunningen |
dnkeyomgvergunningen IS NOT NULL |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbomgvergintbetrokkenennn |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbomgvergintbetrokkenennn
Rules
There are no rules for table tbomgvergintbetrokkenennn
Policies
There are no policies for table tbomgvergintbetrokkenennn
Referenced
There are no tables referenced by table tbomgvergintbetrokkenennn
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyomgvergunningen INTEGER STORAGE PLAIN,
dnkeyinternerol INTEGER STORAGE PLAIN,
dvcodemedewerkers CHAR(5),
dnkeyteams INTEGER STORAGE PLAIN,
CONSTRAINT cpk_tbomgvergintbetrokkenennn PRIMARY KEY(dnkey),
CONSTRAINT cnn_omgvergintbetrok_dnkeyinternerol CHECK (dnkeyinternerol IS NOT NULL),
CONSTRAINT cnn_omgvergintbetrok_dnkeyomgvergunningen CHECK (dnkeyomgvergunningen IS NOT NULL),
CONSTRAINT cfk_omgvergintbetrok_dnkeyinternerol FOREIGN KEY (dnkeyinternerol)
REFERENCES public.tbinternerollen(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_omgvergintbetrok_dnkeyomgvergunningen FOREIGN KEY (dnkeyomgvergunningen)
REFERENCES public.tbomgvergunning(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_omgvergintbetrok_dnkeyteams FOREIGN KEY (dnkeyteams)
REFERENCES public.tbteams(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_omgvergintbetrok_dvcodemedew FOREIGN KEY (dvcodemedewerkers)
REFERENCES public.tbmedewerkers(dvcode)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbomgvergintbetrokkenennn
IS 'Koppeltabel tussen tbinternerollen en tbomgvergunning, en tbmedewerkers of tbteams : welke medewerkers/teams zijn onder welke rol verbonden aan een omgevingszaak';
COMMENT ON COLUMN public.tbomgvergintbetrokkenennn.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbomgvergintbetrokkenennn.dnkeyomgvergunningen
IS 'Not null. Foreign key naar tbomgvergunning.dnkey (omgevingszaak)';
COMMENT ON COLUMN public.tbomgvergintbetrokkenennn.dnkeyinternerol
IS 'Not null. Foreign key naar tbinternerollen.dnkey';
COMMENT ON COLUMN public.tbomgvergintbetrokkenennn.dvcodemedewerkers
IS 'Foreign key naar tbmedewerkers.dvcode';
COMMENT ON COLUMN public.tbomgvergintbetrokkenennn.dnkeyteams
IS 'Foreign key naar tbteams.dnkey';
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10 |
|