Datadictionary OpenWave 3.1.33

View: vwomgheeftbagactiviteiten_bt

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwomgheeftbagactiviteiten_bt

Columns

Rules

Indices

There are no indices for table vwomgheeftbagactiviteiten_bt

Definition

CREATE VIEW public.vwomgheeftbagactiviteiten_bt (
   dnkeyomgheeftbagact)
AS
SELECT DISTINCT a.dnkeyomgvergunningen AS dnkeyomgheeftbagact
FROM tbomgvergunning b
    JOIN tbtoestemmingen a ON b.dnkey = a.dnkeyomgvergunningen
    JOIN tbsrttoestemming c ON c.dnkey = a.dnkeysrttoestemming
WHERE a.ddvervallen IS NULL AND c.dluitvoering = 'T'::bpchar AND
   b.dlbeperktetoegang = 'T'::bpchar;

This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 21-10-2025 10:22