Datadictionary OpenWave 3.1.25 |
|
Table: tbprognose
Datadictionary OpenWave 3.1.25 |
|
Table: tbprognose
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met prognoses per jaar en gemeente op prognosecategorie
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbprognose_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeyprogncategorie |
integer |
|
|
|
|
Foreign key naar tbprogncategorie.dnkey |
|
|
dvgemeenteid |
varchar(4) |
|
|
|
|
Gemeenteid volgens tabel 33 van gemeente waar prognose voor is. |
|
|
dnhoofdstuk |
integer |
|
|
|
|
Indelingcodering in soort werk. |
|
|
dnjaar |
integer |
|
|
|
|
Jaar van prognose |
|
|
dnprognose |
integer |
|
|
|
|
Prognosecijfer (aantal uren). |
|
|
dvrisicoklasse |
varchar(6) |
|
|
|
|
Indelingcodering in risico. |
|
|
dnfrequentie |
integer |
|
|
|
|
Frequentiecijfer (aantal bezoeken). |
|
|
dfnormuren |
double precision |
|
|
|
|
Aantal normuren per product |
|
|
dfuurtarief |
double precision |
|
|
|
|
Uurtarief per product |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_prognose_keyprogncateg |
dnkeyprogncategorie |
dnkey |
No Action |
No Action |
|
Immediate |
|
Check Constraints
There are no check constraints for table tbprognose
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbprognose |
btree |
|
dnkey |
|
|
|
idx_prognose_dnjaar |
btree |
|
dnjaar, dvgemeenteid, dnhoofdstuk, dnkeyprogncategorie |
|
|
|
Triggers
There are no triggers for table tbprognose
Rules
There are no rules for table tbprognose
Policies
There are no policies for table tbprognose
Referenced
There are no tables referenced by table tbprognose
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeyprogncategorie INTEGER,
dvgemeenteid VARCHAR(4),
dnhoofdstuk INTEGER,
dnjaar INTEGER,
dnprognose INTEGER,
dvrisicoklasse VARCHAR(6),
dnfrequentie INTEGER,
dfnormuren DOUBLE PRECISION,
dfuurtarief DOUBLE PRECISION,
CONSTRAINT cpk_tbprognose PRIMARY KEY(dnkey),
CONSTRAINT cfk_prognose_keyprogncateg FOREIGN KEY (dnkeyprogncategorie)
REFERENCES public.tbprogncategorie(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbprognose
IS 'Tabel met prognoses per jaar en gemeente op prognosecategorie';
COMMENT ON COLUMN public.tbprognose.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbprognose.dnkeyprogncategorie
IS 'Foreign key naar tbprogncategorie.dnkey';
COMMENT ON COLUMN public.tbprognose.dvgemeenteid
IS 'Gemeenteid volgens tabel 33 van gemeente waar prognose voor is.';
COMMENT ON COLUMN public.tbprognose.dnhoofdstuk
IS 'Indelingcodering in soort werk.';
COMMENT ON COLUMN public.tbprognose.dnjaar
IS 'Jaar van prognose';
COMMENT ON COLUMN public.tbprognose.dnprognose
IS 'Prognosecijfer (aantal uren).';
COMMENT ON COLUMN public.tbprognose.dvrisicoklasse
IS 'Indelingcodering in risico.';
COMMENT ON COLUMN public.tbprognose.dnfrequentie
IS 'Frequentiecijfer (aantal bezoeken).';
COMMENT ON COLUMN public.tbprognose.dfnormuren
IS 'Aantal normuren per product';
COMMENT ON COLUMN public.tbprognose.dfuurtarief
IS 'Uurtarief per product';
CREATE INDEX idx_prognose_dnjaar ON public.tbprognose
USING btree (dnjaar, dvgemeenteid COLLATE pg_catalog."default", dnhoofdstuk, dnkeyprogncategorie);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|