Datadictionary OpenWave 3.1.11 |
|
Table: tbprognose
Datadictionary OpenWave 3.1.11 |
|
Table: tbprognose
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
There is no description for table tbprognose
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. |
|
|
dvrisicoklasse |
varchar(6) |
|
|
|
|
Indelingcodering in risico. |
|
|
dnfrequentie |
integer |
|
|
|
|
Frequentiecijfer. |
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
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,
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
)
WITH (oids = false);
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.';
COMMENT ON COLUMN public.tbprognose.dvrisicoklasse
IS 'Indelingcodering in risico.';
COMMENT ON COLUMN public.tbprognose.dnfrequentie
IS 'Frequentiecijfer.';
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 22-2-2017 10:50 |
|