Datadictionary OpenWave 3.1.34 |
|
Table: tbmilwpmrapportageregels
Datadictionary OpenWave 3.1.34 |
|
Table: tbmilwpmrapportageregels
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
In deze tabel staan de details per vervoerscategorie per rapportage
Columns
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilwpmrapportageregels_dnkey_seq'::regclass) |
Primary key |
|
|
dnkeyrapportage |
integer |
|
|
|
|
Foreign key naar tbmilwpmrapportagekoppen.dnkey |
|
|
dvcategorie |
varchar(100) |
|
|
|
|
Aangeleverde categorie |
|
|
dvvervoermiddel |
varchar(100) |
|
|
|
|
Aangeleverde vervoersmiddel binnen categorie |
|
|
dnaantalautos |
integer |
|
|
|
|
Aangeleverde aantal autos van betreffende categorie |
|
|
dfingevoerdekm |
double precision |
|
|
|
|
Aangeleverde aantal km van betreffende categorie |
|
|
dfreizigerskm |
double precision |
|
|
|
|
Aangeleverde aantal reizigerskm van betreffende categorie |
|
|
dfemissie |
double precision |
|
|
|
|
Aangeleverde emissie van betreffende categorie |
|
|
dfemissieobvnorm |
double precision |
|
|
|
|
Aangeleverde aantal reizigerskm van betreffende categorie keer de toekomstige emissienorm |
Foreign Keys
Name | Columns | FK Table | FK Columns | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilwpmrapportageregels_dnkeyrapportage |
dnkeyrapportage |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbmilwpmrapportageregels_dnkeyrapportage |
dnkeyrapportage IS NOT NULL |
|
Indices
Name | Type | Function | Columns | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilwpmrapportageregels |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbmilwpmrapportageregels
Rules
There are no rules for table tbmilwpmrapportageregels
Policies
There are no policies for table tbmilwpmrapportageregels
Referenced
There are no tables referenced by table tbmilwpmrapportageregels
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyrapportage INTEGER STORAGE PLAIN,
dvcategorie VARCHAR(100),
dvvervoermiddel VARCHAR(100),
dnaantalautos INTEGER STORAGE PLAIN,
dfingevoerdekm DOUBLE PRECISION STORAGE PLAIN,
dfreizigerskm DOUBLE PRECISION STORAGE PLAIN,
dfemissie DOUBLE PRECISION STORAGE PLAIN,
dfemissieobvnorm DOUBLE PRECISION STORAGE PLAIN,
CONSTRAINT cpk_tbmilwpmrapportageregels PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbmilwpmrapportageregels_dnkeyrapportage CHECK (dnkeyrapportage IS NOT NULL),
CONSTRAINT cfk_tbmilwpmrapportageregels_dnkeyrapportage FOREIGN KEY (dnkeyrapportage)
REFERENCES public.tbmilwpmrapportagekoppen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilwpmrapportageregels
IS 'In deze tabel staan de details per vervoerscategorie per rapportage';
COMMENT ON COLUMN public.tbmilwpmrapportageregels.dnkey
IS 'Primary key';
COMMENT ON COLUMN public.tbmilwpmrapportageregels.dnkeyrapportage
IS 'Foreign key naar tbmilwpmrapportagekoppen.dnkey';
COMMENT ON COLUMN public.tbmilwpmrapportageregels.dvcategorie
IS 'Aangeleverde categorie';
COMMENT ON COLUMN public.tbmilwpmrapportageregels.dvvervoermiddel
IS 'Aangeleverde vervoersmiddel binnen categorie';
COMMENT ON COLUMN public.tbmilwpmrapportageregels.dnaantalautos
IS 'Aangeleverde aantal autos van betreffende categorie';
COMMENT ON COLUMN public.tbmilwpmrapportageregels.dfingevoerdekm
IS 'Aangeleverde aantal km van betreffende categorie';
COMMENT ON COLUMN public.tbmilwpmrapportageregels.dfreizigerskm
IS 'Aangeleverde aantal reizigerskm van betreffende categorie';
COMMENT ON COLUMN public.tbmilwpmrapportageregels.dfemissie
IS 'Aangeleverde emissie van betreffende categorie';
COMMENT ON COLUMN public.tbmilwpmrapportageregels.dfemissieobvnorm
IS 'Aangeleverde aantal reizigerskm van betreffende categorie keer de toekomstige emissienorm';
This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10 |
|