Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwmilstalnh3mvetotalen
Columns
Name | Data type | Description |
|---|---|---|
dnkeymilinrichtingen |
integer |
|
dftotaalnh3 |
double precision |
|
dftotaalmve |
double precision |
|
dftotaalodeur |
double precision |
|
dftotaalfijnstof |
double precision |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Indices
There are no indices for table vwmilstalnh3mvetotalen
Definition
CREATE VIEW public.vwmilstalnh3mvetotalen (
dnkeymilinrichtingen,
dftotaalnh3,
dftotaalmve,
dftotaalodeur,
dftotaalfijnstof)
AS
SELECT dnkeymilinrichtingen,
sum(dfnh3totaal) AS dftotaalnh3,
sum(dfmvetotaal) AS dftotaalmve,
sum(dfodeurtotaal) AS dftotaalodeur,
sum(dffijnstoftotaal) AS dftotaalfijnstof
FROM tbmilemstal
GROUP BY dnkeymilinrichtingen;
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10 |
|