Datadictionary OpenWave 3.1.32 |
|
View: vwfrmexportinrkrt_sql
Datadictionary OpenWave 3.1.32 |
|
View: vwfrmexportinrkrt_sql
Schema
public
Owner
waveuser005
Descriptions
View van tabel met SQL statements op de de tabel tbmilinrichtingen ingedeeld in thema en subthema voor export naar de kaart
Fields
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
Primary key van tbexportinrkrt_sql |
dnkeyexportinrkrt_thema |
integer |
Foreign key naar tbexportinrkrt_thema.dnkey |
dnkeyexportinrkrt_subthema |
integer |
Foreign key naar tbexportinrkrt_subthema.dnkey |
dvomschrijving |
varchar(200) |
Beschrijving van de query |
dvsql |
text |
Select query statement |
ddvervaldatum |
timestamp |
Datum waarvanaf de query niet meer operationeel is |
dvthema |
varchar(100) |
Themanaam uit xportinrkrt_thema |
dvsubthema |
varchar(100) |
Subthemanaam uit exportinrkrt_subthema |
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwfrmexportinrkrt_sql
Definition
dnkey,
dnkeyexportinrkrt_thema,
dnkeyexportinrkrt_subthema,
dvomschrijving,
dvsql,
ddvervaldatum,
dvthema,
dvsubthema)
AS
SELECT a.dnkey,
a.dnkeyexportinrkrt_thema,
a.dnkeyexportinrkrt_subthema,
a.dvomschrijving,
a.dvsql,
a.ddvervaldatum,
b.dvthema,
c.dvsubthema
FROM tbexportinrkrt_sql a
JOIN tbexportinrkrt_thema b ON a.dnkeyexportinrkrt_thema = b.dnkey
LEFT JOIN tbexportinrkrt_subthema c ON a.dnkeyexportinrkrt_subthema = c.dnkey;
COMMENT ON VIEW public.vwfrmexportinrkrt_sql
IS 'View van tabel met SQL statements op de de tabel tbmilinrichtingen ingedeeld in thema en subthema voor export naar de kaart';
COMMENT ON COLUMN public.vwfrmexportinrkrt_sql.dnkey
IS 'Primary key van tbexportinrkrt_sql';
COMMENT ON COLUMN public.vwfrmexportinrkrt_sql.dnkeyexportinrkrt_thema
IS 'Foreign key naar tbexportinrkrt_thema.dnkey';
COMMENT ON COLUMN public.vwfrmexportinrkrt_sql.dnkeyexportinrkrt_subthema
IS 'Foreign key naar tbexportinrkrt_subthema.dnkey';
COMMENT ON COLUMN public.vwfrmexportinrkrt_sql.dvomschrijving
IS 'Beschrijving van de query';
COMMENT ON COLUMN public.vwfrmexportinrkrt_sql.dvsql
IS 'Select query statement';
COMMENT ON COLUMN public.vwfrmexportinrkrt_sql.ddvervaldatum
IS 'Datum waarvanaf de query niet meer operationeel is';
COMMENT ON COLUMN public.vwfrmexportinrkrt_sql.dvthema
IS 'Themanaam uit xportinrkrt_thema';
COMMENT ON COLUMN public.vwfrmexportinrkrt_sql.dvsubthema
IS 'Subthemanaam uit exportinrkrt_subthema';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|