Datadictionary OpenWave 3.1.25 |
|
Table: tbekrubricering
Datadictionary OpenWave 3.1.25 |
|
Table: tbekrubricering
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel rubriceringen van erkende maatregelen (percentage uitgevoerd)
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbekrubricering_dnkey_seq'::regclass) |
Primary key. |
|
|
dvcode |
varchar(40) |
|
|
|
|
Codering rubriek erende maatregel bijv R1!!!-M |
|
|
dvomschrijving |
varchar(200) |
|
|
|
|
Bijvoorbeeld: 75-100% van de maatregelen (nog) niet uitgevoerd, energieverbruik Middelgroot |
|
|
ddvervaldatum |
timestamp |
|
|
|
|
Datum waarop rubriek is komen te vervallen. |
Foreign Keys
There are no foreign keys for table tbekrubricering
Check Constraints
There are no check constraints for table tbekrubricering
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbekrubricering |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbekrubricering
Rules
There are no rules for table tbekrubricering
Policies
There are no policies for table tbekrubricering
Referenced
There are no tables referenced by table tbekrubricering
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dvcode VARCHAR(40),
dvomschrijving VARCHAR(200),
ddvervaldatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbekrubricering PRIMARY KEY(dnkey)
) ;
COMMENT ON TABLE public.tbekrubricering
IS 'Tabel rubriceringen van erkende maatregelen (percentage uitgevoerd)';
COMMENT ON COLUMN public.tbekrubricering.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbekrubricering.dvcode
IS 'Codering rubriek erende maatregel bijv R1!!!-M';
COMMENT ON COLUMN public.tbekrubricering.dvomschrijving
IS 'Bijvoorbeeld: 75-100% van de maatregelen (nog) niet uitgevoerd, energieverbruik Middelgroot';
COMMENT ON COLUMN public.tbekrubricering.ddvervaldatum
IS 'Datum waarop rubriek is komen te vervallen.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|