Datadictionary OpenWave 3.1.26 |
|
Table: tbmilmba
Datadictionary OpenWave 3.1.26 |
|
Table: tbmilmba
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met mba-coderingen (milieu belastende activiteiten) per inrichting)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilmba_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar TbMilInrichtingen.dnkey |
|
|
dnkeymilcodemba |
integer |
|
|
|
|
Foreign key naar TbMilCodemba.dnkey |
|
|
dvopmerking |
varchar(2000) |
|
|
|
|
Extra opmerking. |
|
|
dlhoofdmba |
char(1) |
|
|
|
'F'::bpchar |
T of F. Indien T dan is dit de belangrijkste MBA-activiteit bij de inrichting (er kan er maar één op T staan) |
|
|
dnkeymilartmbakz |
integer |
|
|
|
|
Foreign key naar tbmilartmba.dnkey. Artikel waarop paragraafkeuze is gebaseerd |
|
|
dnkeymilartmbavp |
integer |
|
|
|
|
Foreign key naar tbmilartmba.dnkey. Artikel waarop vergunningsplicht is gebaseerd |
|
|
ddvervallen |
timestamp |
|
|
|
|
Datum dat MBA-activiteit niet meer wordt uitgevoerd |
|
|
dvplicht |
char(1) |
|
|
|
'M'::bpchar |
(G)een, (I)informatieplicht, (M)eldingsplicht of (V)ergunningsplicht of (Z)orgplicht. |
|
|
dlippc |
char(1) |
|
|
|
'F'::bpchar |
Integrated Pollution Prevention and Control -richtlijn (europees) van toepassing. Alleen T of F. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_milmba_keycodemba |
dnkeymilcodemba |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_milmba_keyinrichtingen |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbmilmba_dnkeymilartmbakz |
dnkeymilartmbakz |
dnkey |
Set Null |
No Action |
|
Immediate |
|
|
cfk_tbmilmba_dnkeymilartmbavp |
dnkeymilartmbavp |
dnkey |
Set Null |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_milmba_dlippc |
dlippc = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
chk_milmba_dvplicht |
dvplicht = ANY (ARRAY['G'::bpchar, 'I'::bpchar, 'M'::bpchar, 'V'::bpchar, 'Z'::bpchar]) |
|
chk_tbmilmba_dlhoofdmba |
dlhoofdmba = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
cnn_milmba_dlippc |
dlippc IS NOT NULL |
|
cnn_milmba_dnkeymilcodemba |
dnkeymilcodemba IS NOT NULL |
|
cnn_milmba_dnkeymilinrichtingen |
dnkeymilinrichtingen IS NOT NULL |
|
cnn_milmba_dvplicht |
dvplicht IS NOT NULL |
|
cnn_tbmilmba_dlhoofdmba |
dlhoofdmba IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilmba |
btree |
|
dnkey |
|
|
|
idu_milmba_dvcodeinr |
btree |
|
dnkeymilinrichtingen, dnkeymilcodemba |
|
|
|
Triggers
There are no triggers for table tbmilmba
Rules
There are no rules for table tbmilmba
Policies
There are no policies for table tbmilmba
Referenced
There are no tables referenced by table tbmilmba
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilinrichtingen INTEGER,
dnkeymilcodemba INTEGER,
dvopmerking VARCHAR(2000),
dlhoofdmba CHAR(1) DEFAULT 'F'::bpchar,
dnkeymilartmbakz INTEGER,
dnkeymilartmbavp INTEGER,
ddvervallen TIMESTAMP WITHOUT TIME ZONE,
dvplicht CHAR(1) DEFAULT 'M'::bpchar,
dlippc CHAR(1) DEFAULT 'F'::bpchar,
CONSTRAINT cpk_tbmilmba PRIMARY KEY(dnkey),
CONSTRAINT chk_milmba_dlippc CHECK (dlippc = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT chk_milmba_dvplicht CHECK (dvplicht = ANY (ARRAY['G'::bpchar, 'I'::bpchar, 'M'::bpchar, 'V'::bpchar, 'Z'::bpchar])),
CONSTRAINT chk_tbmilmba_dlhoofdmba CHECK (dlhoofdmba = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT cnn_milmba_dlippc CHECK (dlippc IS NOT NULL),
CONSTRAINT cnn_milmba_dnkeymilcodemba CHECK (dnkeymilcodemba IS NOT NULL),
CONSTRAINT cnn_milmba_dnkeymilinrichtingen CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cnn_milmba_dvplicht CHECK (dvplicht IS NOT NULL),
CONSTRAINT cnn_tbmilmba_dlhoofdmba CHECK (dlhoofdmba IS NOT NULL),
CONSTRAINT cfk_milmba_keycodemba FOREIGN KEY (dnkeymilcodemba)
REFERENCES public.tbmilcodemba(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_milmba_keyinrichtingen FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilmba_dnkeymilartmbakz FOREIGN KEY (dnkeymilartmbakz)
REFERENCES public.tbmilartmba(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilmba_dnkeymilartmbavp FOREIGN KEY (dnkeymilartmbavp)
REFERENCES public.tbmilartmba(dnkey)
ON DELETE SET NULL
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilmba
IS 'Tabel met mba-coderingen (milieu belastende activiteiten) per inrichting)';
COMMENT ON COLUMN public.tbmilmba.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilmba.dnkeymilinrichtingen
IS 'Foreign key naar TbMilInrichtingen.dnkey';
COMMENT ON COLUMN public.tbmilmba.dnkeymilcodemba
IS 'Foreign key naar TbMilCodemba.dnkey';
COMMENT ON COLUMN public.tbmilmba.dvopmerking
IS 'Extra opmerking.';
COMMENT ON COLUMN public.tbmilmba.dlhoofdmba
IS 'T of F. Indien T dan is dit de belangrijkste MBA-activiteit bij de inrichting (er kan er maar één op T staan)';
COMMENT ON COLUMN public.tbmilmba.dnkeymilartmbakz
IS 'Foreign key naar tbmilartmba.dnkey. Artikel waarop paragraafkeuze is gebaseerd';
COMMENT ON COLUMN public.tbmilmba.dnkeymilartmbavp
IS 'Foreign key naar tbmilartmba.dnkey. Artikel waarop vergunningsplicht is gebaseerd';
COMMENT ON COLUMN public.tbmilmba.ddvervallen
IS 'Datum dat MBA-activiteit niet meer wordt uitgevoerd';
COMMENT ON COLUMN public.tbmilmba.dvplicht
IS '(G)een, (I)informatieplicht, (M)eldingsplicht of (V)ergunningsplicht of (Z)orgplicht.';
COMMENT ON COLUMN public.tbmilmba.dlippc
IS 'Integrated Pollution Prevention and Control -richtlijn (europees) van toepassing. Alleen T of F.';
CREATE UNIQUE INDEX idu_milmba_dvcodeinr ON public.tbmilmba
USING btree (dnkeymilinrichtingen, dnkeymilcodemba);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 28-4-2022 10:20 |
|