Datadictionary OpenWave 3.1.25 |
|
Table: tbmilmba
Datadictionary OpenWave 3.1.25 |
|
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) |
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 |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_tbmilmba_dlhoofdmba |
dlhoofdmba = ANY (ARRAY['F'::bpchar, 'T'::bpchar]) |
|
cnn_milmba_dnkeymilcodemba |
dnkeymilcodemba IS NOT NULL |
|
cnn_milmba_dnkeymilinrichtingen |
dnkeymilinrichtingen 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,
CONSTRAINT cpk_tbmilmba PRIMARY KEY(dnkey),
CONSTRAINT chk_tbmilmba_dlhoofdmba CHECK (dlhoofdmba = ANY (ARRAY['F'::bpchar, 'T'::bpchar])),
CONSTRAINT cnn_milmba_dnkeymilcodemba CHECK (dnkeymilcodemba IS NOT NULL),
CONSTRAINT cnn_milmba_dnkeymilinrichtingen CHECK (dnkeymilinrichtingen 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
) ;
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)';
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 5-1-2022 14:13 |
|