Datadictionary OpenWave 3.1.25 |
|
View: vwadvies_instantie
Datadictionary OpenWave 3.1.25 |
|
View: vwadvies_instantie
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwadvies_instantie
Fields
Name | Data type | Description |
|---|---|---|
dvcodeadviesinstantie |
char(4) |
|
dvomschradviesinstantie |
varchar(40) |
|
dnrappeldagen |
integer |
|
dnkeyautolegessoort |
integer |
|
ddaanvraagdatum |
timestamp |
|
ddadviesdatum |
timestamp |
|
ddrappeldatum |
timestamp |
|
dladviespositief |
char(1) |
|
dnkey |
integer |
|
dnkeybouwvergunningen |
integer |
|
dnkeyhandhavingen |
integer |
|
dnkeyovvergunningen |
integer |
|
dnkeyhorecavergunningen |
integer |
|
dnkeyinfoaanvraag |
integer |
|
dvomschrijving |
varchar(40) |
|
dnkeymilvergunningen |
integer |
|
dnkeyomgvergunningen |
integer |
|
ddvervallen |
timestamp |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwadvies_instantie
Definition
dvcodeadviesinstantie,
dvomschradviesinstantie,
dnrappeldagen,
dnkeyautolegessoort,
ddaanvraagdatum,
ddadviesdatum,
ddrappeldatum,
dladviespositief,
dnkey,
dnkeybouwvergunningen,
dnkeyhandhavingen,
dnkeyovvergunningen,
dnkeyhorecavergunningen,
dnkeyinfoaanvraag,
dvomschrijving,
dnkeymilvergunningen,
dnkeyomgvergunningen,
ddvervallen)
AS
SELECT tbadviesinstanties.dvcode AS dvcodeadviesinstantie,
tbadviesinstanties.dvomschrijving AS dvomschradviesinstantie,
tbadviesinstanties.dnrappeldagen,
tbadviesinstanties.dnkeyautolegessoort,
tbadviezen.ddaanvraagdatum,
tbadviezen.ddadviesdatum,
tbadviezen.ddrappeldatum,
tbadviezen.dladviespositief,
tbadviezen.dnkey,
tbadviezen.dnkeybouwvergunningen,
tbadviezen.dnkeyhandhavingen,
tbadviezen.dnkeyovvergunningen,
tbadviezen.dnkeyhorecavergunningen,
tbadviezen.dnkeyinfoaanvraag,
tbadviezen.dvomschrijving,
tbadviezen.dnkeymilvergunningen,
tbadviezen.dnkeyomgvergunningen,
tbadviezen.ddvervallen
FROM tbadviezen
LEFT JOIN tbadviesinstanties ON tbadviezen.dvcodeadviesinstanties =
tbadviesinstanties.dvcode;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|