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. |
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 |
---|---|---|
cnn_milmba_dnkeymilcodemba |
dnkeymilcodemba IS NOT NULL |
|
cnn_milmba_dnkeymilinrichtingen |
dnkeymilinrichtingen 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
Referenced
There are no tables referenced by table tbmilmba
Properties
Property | Value |
---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
CREATE TABLE public.tbmilmba (
dnkey SERIAL,
dnkeymilinrichtingen INTEGER,
dnkeymilcodemba INTEGER,
dvopmerking VARCHAR(2000),
CONSTRAINT cpk_tbmilmba PRIMARY KEY(dnkey),
CONSTRAINT cnn_milmba_dnkeymilcodemba CHECK (dnkeymilcodemba IS NOT NULL),
CONSTRAINT cnn_milmba_dnkeymilinrichtingen CHECK (dnkeymilinrichtingen 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
)
WITH (oids = false);
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.';
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 2-9-2021 14:10 |
![]() ![]() ![]() |