Datadictionary OpenWave 3.1.26 |
|
Table: tbmilartmba
Datadictionary OpenWave 3.1.26 |
|
Table: tbmilartmba
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met artikel nummers Milieu belastende activiteiten per paragraaf (tbmilcodemba)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilartmba_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilcodemba |
integer |
|
|
|
|
Foreign key naar tbmilcodemba.dnkey. |
|
|
dvartikelnr |
varchar(20) |
|
|
|
|
Artikelnummer. |
|
|
dvartikeltekst |
varchar(4000) |
|
|
|
|
Beschrijving van artikelnummer. |
|
|
dvrisicocode |
varchar(20) |
|
|
|
|
Waardering van artikel naar risico |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum dat artikel is komen te vervallen |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilartmba_keymilcodemba |
dnkeymilcodemba |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tbmilartmba
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilartmba |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbmilartmba
Rules
There are no rules for table tbmilartmba
Policies
There are no policies for table tbmilartmba
Referenced
Table | Schema | Foreign Key | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|---|---|
public |
cfk_tbmilmba_dnkeymilartmbakz |
dnkeymilartmbakz |
dnkey |
Set Null |
No Action |
|
Immediate |
|
||
public |
cfk_tbmilmba_dnkeymilartmbavp |
dnkeymilartmbavp |
dnkey |
Set Null |
No Action |
|
Immediate |
|
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilcodemba INTEGER,
dvartikelnr VARCHAR(20),
dvartikeltekst VARCHAR(4000),
dvrisicocode VARCHAR(20),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbmilartmba PRIMARY KEY(dnkey),
CONSTRAINT cfk_tbmilartmba_keymilcodemba FOREIGN KEY (dnkeymilcodemba)
REFERENCES public.tbmilcodemba(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilartmba
IS 'Tabel met artikel nummers Milieu belastende activiteiten per paragraaf (tbmilcodemba)';
COMMENT ON COLUMN public.tbmilartmba.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilartmba.dnkeymilcodemba
IS 'Foreign key naar tbmilcodemba.dnkey.';
COMMENT ON COLUMN public.tbmilartmba.dvartikelnr
IS 'Artikelnummer.';
COMMENT ON COLUMN public.tbmilartmba.dvartikeltekst
IS 'Beschrijving van artikelnummer.';
COMMENT ON COLUMN public.tbmilartmba.dvrisicocode
IS 'Waardering van artikel naar risico';
COMMENT ON COLUMN public.tbmilartmba.ddvervaldatum
IS 'Datum dat artikel is komen te vervallen';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 28-4-2022 10:20 |
|