Datadictionary OpenWave 3.1.25 |
|
View: vwkoptoestadv
Datadictionary OpenWave 3.1.25 |
|
View: vwkoptoestadv
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwkoptoestadv
Fields
Name | Data type | Description |
|---|---|---|
dvcodeadviesinst |
char(4) |
|
dnkeysoortomg |
integer |
|
dnkeysrttoest |
integer |
|
dvbehandelfase |
char(1) |
|
dnbehrappel |
integer |
|
dvbeheenheid |
char(1) |
|
dvadviesinstantie |
varchar(40) |
|
dvtoestemmingnaam |
varchar(100) |
|
dvcodedefbehandelaar |
char(5) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwkoptoestadv
Definition
dvcodeadviesinst,
dnkeysoortomg,
dnkeysrttoest,
dvbehandelfase,
dnbehrappel,
dvbeheenheid,
dvadviesinstantie,
dvtoestemmingnaam,
dvcodedefbehandelaar)
AS
SELECT tbkoptoestadv.dvcodeadviesinst,
tbkoptoestadv.dnkeysoortomg,
tbkoptoestadv.dnkeysrttoest,
tbkoptoestadv.dvbehandelfase,
tbkoptoestadv.dnbehrappel,
tbkoptoestadv.dvbeheenheid,
tbadviesinstanties.dvomschrijving AS dvadviesinstantie,
tbsrttoestemming.dvtoestemmingnaam,
tbadviesinstanties.dvcodedefbehandelaar
FROM tbkoptoestadv
JOIN tbadviesinstanties ON tbkoptoestadv.dvcodeadviesinst =
tbadviesinstanties.dvcode
JOIN tbsrttoestemming ON tbkoptoestadv.dnkeysrttoest = tbsrttoestemming.dnkey;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|