Datadictionary OpenWave 3.1.32 |
|
Table: tbmilcodemba
Datadictionary OpenWave 3.1.32 |
|
Table: tbmilcodemba
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Deprecated met databaseversie 3.1.32 . zie tbsrttoestemming. Tabel met MBA-coderingen: Besluit Milieubelatende Activiteiten, waaronder BAL
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilcodemba_dnkey_seq'::regclass) |
Primary key. |
|
|
dvcode |
varchar(20) |
|
|
|
|
Codering van milieubelastende activiteit. |
|
|
dvomschrijving |
varchar(500) |
|
|
|
|
Omschrijving van milieubelastende activiteit. |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Vervaldatum van codering. |
|
|
dvplicht |
char(1) |
|
|
|
'G'::bpchar |
(G)een, (I)nformatieplicht, (M)eldingsplicht, (V)ergunningsplicht, (Z)orgplicht of X (Meerdere plichten). |
|
|
dvbron |
char(1) |
|
|
|
'B'::bpchar |
(B)AL, omgevings(P)lan, omgevings(V)erordening of (W)aterschapverordening. |
|
|
dvbevoegdgezag |
char(1) |
|
|
|
'G'::bpchar |
(G)emeente, (P)rovincie, (R)ijk of (W)aterschap. |
|
|
dlmagneetactiviteit |
char(1) |
|
|
|
'F'::bpchar |
Wordt niet meer ondersteund sinds databaseversie 3.1.27. T of F. Magneetactiviteit. |
|
|
dlkernactiviteit |
char(1) |
|
|
|
'T'::bpchar |
Wordt niet meer ondersteund sinds databaseversie 3.1.27.T of F. Indien T dan kernactiviteit anders functioneel ondersteunende activiteit. |
|
|
dvsoortactiv |
char(1) |
|
|
|
|
Leeg of gevuld met de letters F, M, B of K: Functioneel ondersteunend, Magneetactiviteit, Bedrijfsondersteundend of Kernactiviteit. |
|
|
dvidentificatie |
varchar(80) |
|
|
|
|
Informatiemodel Omgevinsgwet (IMOW)- code (ambtsgebied-identificatie) die I-Go gebruikt voor de Gelderse omgevingsdiensten. Mag leeg zijn. |
Foreign Keys
There are no foreign keys for table tbmilcodemba
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_milcodemba_dlmagneetact |
dlmagneetactiviteit = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_milcodemba_dvbevoegdgezag |
dvbevoegdgezag = ANY (ARRAY['G'::bpchar, 'P'::bpchar, 'W'::bpchar, 'R'::bpchar]) |
|
chk_milcodemba_dvbron |
dvbron = ANY (ARRAY['B'::bpchar, 'P'::bpchar, 'V'::bpchar, 'W'::bpchar]) |
|
chk_milcodemba_dvplicht |
dvplicht = ANY (ARRAY['G'::bpchar, 'I'::bpchar, 'M'::bpchar, 'V'::bpchar, 'Z'::bpchar, 'X'::bpchar]) |
|
chk_tbmilcodemba_dlkernactiviteit |
dlkernactiviteit = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_tbmilcodemba_dvsoortactiv |
dvsoortactiv = ANY (ARRAY['K'::bpchar, 'M'::bpchar, 'B'::bpchar, 'F'::bpchar]) |
|
cnn_milcodemba_dlmagneetact |
dlmagneetactiviteit IS NOT NULL |
|
cnn_milcodemba_dvbevoegdgezag |
dvbevoegdgezag IS NOT NULL |
|
cnn_milcodemba_dvbron |
dvbron IS NOT NULL |
|
cnn_milcodemba_dvplicht |
dvplicht IS NOT NULL |
|
cnn_tbmilcodemba_dlkernactiviteit |
dlkernactiviteit IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilcodemba |
btree |
|
dnkey |
|
|
|
idx_milcodemba_dvcode |
btree |
|
dvcode |
|
|
|
Triggers
There are no triggers for table tbmilcodemba
Rules
There are no rules for table tbmilcodemba
Policies
There are no policies for table tbmilcodemba
Referenced
There are no tables referenced by table tbmilcodemba
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcode VARCHAR(20),
dvomschrijving VARCHAR(500),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
dvplicht CHAR(1) DEFAULT 'G'::bpchar,
dvbron CHAR(1) DEFAULT 'B'::bpchar,
dvbevoegdgezag CHAR(1) DEFAULT 'G'::bpchar,
dlmagneetactiviteit CHAR(1) DEFAULT 'F'::bpchar,
dlkernactiviteit CHAR(1) DEFAULT 'T'::bpchar,
dvsoortactiv CHAR(1),
dvidentificatie VARCHAR(80),
CONSTRAINT cpk_tbmilcodemba PRIMARY KEY(dnkey),
CONSTRAINT chk_milcodemba_dlmagneetact CHECK (dlmagneetactiviteit = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_milcodemba_dvbevoegdgezag CHECK (dvbevoegdgezag = ANY (ARRAY['G'::bpchar, 'P'::bpchar, 'W'::bpchar, 'R'::bpchar])),
CONSTRAINT chk_milcodemba_dvbron CHECK (dvbron = ANY (ARRAY['B'::bpchar, 'P'::bpchar, 'V'::bpchar, 'W'::bpchar])),
CONSTRAINT chk_milcodemba_dvplicht CHECK (dvplicht = ANY (ARRAY['G'::bpchar, 'I'::bpchar, 'M'::bpchar, 'V'::bpchar, 'Z'::bpchar, 'X'::bpchar])),
CONSTRAINT chk_tbmilcodemba_dlkernactiviteit CHECK (dlkernactiviteit = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_tbmilcodemba_dvsoortactiv CHECK (dvsoortactiv = ANY (ARRAY['K'::bpchar, 'M'::bpchar, 'B'::bpchar, 'F'::bpchar])),
CONSTRAINT cnn_milcodemba_dlmagneetact CHECK (dlmagneetactiviteit IS NOT NULL),
CONSTRAINT cnn_milcodemba_dvbevoegdgezag CHECK (dvbevoegdgezag IS NOT NULL),
CONSTRAINT cnn_milcodemba_dvbron CHECK (dvbron IS NOT NULL),
CONSTRAINT cnn_milcodemba_dvplicht CHECK (dvplicht IS NOT NULL),
CONSTRAINT cnn_tbmilcodemba_dlkernactiviteit CHECK (dlkernactiviteit IS NOT NULL)
) ;
COMMENT ON TABLE public.tbmilcodemba
IS 'Deprecated met databaseversie 3.1.32 . zie tbsrttoestemming. Tabel met MBA-coderingen: Besluit Milieubelatende Activiteiten, waaronder BAL';
COMMENT ON COLUMN public.tbmilcodemba.dnkey
IS ' Primary key.';
COMMENT ON COLUMN public.tbmilcodemba.dvcode
IS 'Codering van milieubelastende activiteit.';
COMMENT ON COLUMN public.tbmilcodemba.dvomschrijving
IS 'Omschrijving van milieubelastende activiteit.';
COMMENT ON COLUMN public.tbmilcodemba.ddvervaldatum
IS 'Vervaldatum van codering.';
COMMENT ON COLUMN public.tbmilcodemba.dvplicht
IS '(G)een, (I)nformatieplicht, (M)eldingsplicht, (V)ergunningsplicht, (Z)orgplicht of X (Meerdere plichten).';
COMMENT ON COLUMN public.tbmilcodemba.dvbron
IS '(B)AL, omgevings(P)lan, omgevings(V)erordening of (W)aterschapverordening.';
COMMENT ON COLUMN public.tbmilcodemba.dvbevoegdgezag
IS '(G)emeente, (P)rovincie, (R)ijk of (W)aterschap.';
COMMENT ON COLUMN public.tbmilcodemba.dlmagneetactiviteit
IS 'Wordt niet meer ondersteund sinds databaseversie 3.1.27. T of F. Magneetactiviteit.';
COMMENT ON COLUMN public.tbmilcodemba.dlkernactiviteit
IS 'Wordt niet meer ondersteund sinds databaseversie 3.1.27.T of F. Indien T dan kernactiviteit anders functioneel ondersteunende activiteit.';
COMMENT ON COLUMN public.tbmilcodemba.dvsoortactiv
IS 'Leeg of gevuld met de letters F, M, B of K: Functioneel ondersteunend, Magneetactiviteit, Bedrijfsondersteundend of Kernactiviteit.';
COMMENT ON COLUMN public.tbmilcodemba.dvidentificatie
IS 'Informatiemodel Omgevinsgwet (IMOW)- code (ambtsgebied-identificatie) die I-Go gebruikt voor de Gelderse omgevingsdiensten. Mag leeg zijn.';
CREATE INDEX idx_milcodemba_dvcode ON public.tbmilcodemba
USING btree (dvcode COLLATE pg_catalog."default");
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49 |
|