Datadictionary OpenWave 3.1.11 |
|
Table: tbmilenergie
Datadictionary OpenWave 3.1.11 |
|
Table: tbmilenergie
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel om energieverbruik van een inrichting per jaar en soort te noteren
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilenergie_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilcodeenergie |
integer |
|
|
|
|
Foreign key naar TbMilCodeEenrgie.dnkey (dus de soort energie zoals gas of elektra) |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar TbMilinrichtingen.dnkey |
|
|
dnjaar |
integer |
|
|
|
|
Jaar van energiemeting |
|
|
dlmja |
char(1) |
|
|
|
'F'::bpchar |
MeerjarenAfspraken (T of F) |
|
|
dvnotitie |
varchar(2000) |
|
|
|
|
Opmerkingen, notities |
|
|
dlenergondzuitg |
char(1) |
|
|
|
'F'::bpchar |
Energieonderzoek uitgevoerd? (T of F ) |
|
|
dvverbruikcat |
char(1) |
|
|
|
NULL::bpchar |
De verbruikscategorie (A,B of C) van de energiemeting. Bij elektra: A = minder dan 50.000 Kwh, B = 50.000 tot 200000, C = meer dan 200000. Bij gas: A = minder dan 25000 Kuub, B = 25000 tot 75000, C = meer dan 75000. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilcodeenerg_keymilcode |
dnkeymilcodeenergie |
dnkey |
No Action |
No Action |
|
Immediate |
|
|
cfk_tbmilenergie_keymilinr |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
chk_milenergie_dlenondz |
dlenergondzuitg = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_milenergie_dlmja |
dlmja = ANY (ARRAY['T'::bpchar, 'F'::bpchar]) |
|
chk_milenergie_dvverbuikcat |
dvverbruikcat = ANY (ARRAY['A'::bpchar, 'B'::bpchar, 'C'::bpchar]) |
|
cnn_milenergie_keymilcodeen |
dnkeymilcodeenergie IS NOT NULL |
|
cnn_milenergie_keymilinr |
dnkeymilinrichtingen IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilenergie |
btree |
|
dnkey |
|
|
|
idx_tbmilenergie_keymilcode |
btree |
|
dnkeymilcodeenergie |
|
|
|
idx_tbmilenergie_keymilinr |
btree |
|
dnkeymilinrichtingen |
|
|
|
Triggers
There are no triggers for table tbmilenergie
Rules
There are no rules for table tbmilenergie
Referenced
There are no tables referenced by table tbmilenergie
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilcodeenergie INTEGER,
dnkeymilinrichtingen INTEGER,
dnjaar INTEGER,
dlmja CHAR(1) DEFAULT 'F'::bpchar,
dvnotitie VARCHAR(2000),
dlenergondzuitg CHAR(1) DEFAULT 'F'::bpchar,
dvverbruikcat CHAR(1) DEFAULT NULL::bpchar,
CONSTRAINT cpk_tbmilenergie PRIMARY KEY(dnkey),
CONSTRAINT chk_milenergie_dlenondz CHECK (dlenergondzuitg = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_milenergie_dlmja CHECK (dlmja = ANY (ARRAY['T'::bpchar, 'F'::bpchar])),
CONSTRAINT chk_milenergie_dvverbuikcat CHECK (dvverbruikcat = ANY (ARRAY['A'::bpchar, 'B'::bpchar, 'C'::bpchar])),
CONSTRAINT cnn_milenergie_keymilcodeen CHECK (dnkeymilcodeenergie IS NOT NULL),
CONSTRAINT cnn_milenergie_keymilinr CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cfk_tbmilcodeenerg_keymilcode FOREIGN KEY (dnkeymilcodeenergie)
REFERENCES public.tbmilcodeenergie(dnkey)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilenergie_keymilinr FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
)
WITH (oids = false);
COMMENT ON TABLE public.tbmilenergie
IS 'Tabel om energieverbruik van een inrichting per jaar en soort te noteren';
COMMENT ON COLUMN public.tbmilenergie.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilenergie.dnkeymilcodeenergie
IS 'Foreign key naar TbMilCodeEenrgie.dnkey (dus de soort energie zoals gas of elektra)';
COMMENT ON COLUMN public.tbmilenergie.dnkeymilinrichtingen
IS 'Foreign key naar TbMilinrichtingen.dnkey';
COMMENT ON COLUMN public.tbmilenergie.dnjaar
IS 'Jaar van energiemeting';
COMMENT ON COLUMN public.tbmilenergie.dlmja
IS 'MeerjarenAfspraken (T of F)';
COMMENT ON COLUMN public.tbmilenergie.dvnotitie
IS 'Opmerkingen, notities';
COMMENT ON COLUMN public.tbmilenergie.dlenergondzuitg
IS 'Energieonderzoek uitgevoerd? (T of F )';
COMMENT ON COLUMN public.tbmilenergie.dvverbruikcat
IS 'De verbruikscategorie (A,B of C) van de energiemeting. Bij elektra: A = minder dan 50.000 Kwh, B = 50.000 tot 200000, C = meer dan 200000. Bij gas: A = minder dan 25000 Kuub, B = 25000 tot 75000, C = meer dan 75000.';
CREATE INDEX idx_tbmilenergie_keymilcode ON public.tbmilenergie
USING btree (dnkeymilcodeenergie);
CREATE INDEX idx_tbmilenergie_keymilinr ON public.tbmilenergie
USING btree (dnkeymilinrichtingen);
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|