Datadictionary OpenWave 3.1.25 |
|
Table: tbmilenergieprojecten
Datadictionary OpenWave 3.1.25 |
|
Table: tbmilenergieprojecten
Schema
public
Owner
waveuser005
Tablespace
(default)
Descriptions
Tabel met energieprojecten per inrichting.
Fields
PK | FK | Name | Data type | Not null | Unique | Inherited | Default | Description |
|---|---|---|---|---|---|---|---|---|
|
|
dnkey |
serial |
|
|
|
nextval('tbmilenergieprojecten_dnkey_seq'::regclass) |
Primary key. |
|
|
dnkeymilprojecten |
integer |
|
|
|
|
Foreign key naar tabel tbmilprojecten. |
|
|
dnkeymilinrichtingen |
integer |
|
|
|
|
Foreign key naar tabel tbmilinrichtingen. |
|
|
dvenergieprojectoms |
varchar(60) |
|
|
|
|
Omschrijving van het energieproject. |
|
|
dvhyperlink |
varchar(256) |
|
|
|
|
Verwijzing naar een map, url of bestand. |
|
|
ddstartdatum |
timestamp |
|
|
|
|
Startdatum van het energieproject bij de inrichting. |
|
|
ddeinddatum |
timestamp |
|
|
|
|
Einddatum van het energieproject bij de inrichting. |
Foreign Keys
Name | Fields | FK Table | FK Fields | Delete Action | Update Action | Deferrable | Check Time | Description |
|---|---|---|---|---|---|---|---|---|
cfk_tbmilenergieproj_keymilinr |
dnkeymilinrichtingen |
dnkey |
Cascade |
No Action |
|
Immediate |
|
|
cfk_tbmilenergproj_keymilproj |
dnkeymilprojecten |
dnkey |
Cascade |
No Action |
|
Immediate |
|
Check Constraints
Name | Condition | Description |
|---|---|---|
cnn_tbmilenergieproj_keymilinr |
dnkeymilinrichtingen IS NOT NULL |
|
cnn_tbmilenergieproj_oms |
dvenergieprojectoms IS NOT NULL |
|
cnn_tbmilenergproj_keymilproj |
dnkeymilprojecten IS NOT NULL |
|
Indices
Name | Type | Function | Fields | Primary Key | Unique | Description |
|---|---|---|---|---|---|---|
cpk_tbmilenergieproj |
btree |
|
dnkey |
|
|
|
Triggers
There are no triggers for table tbmilenergieprojecten
Rules
There are no rules for table tbmilenergieprojecten
Policies
There are no policies for table tbmilenergieprojecten
Referenced
There are no tables referenced by table tbmilenergieprojecten
Properties
Property | Value |
|---|---|
Inherited From |
|
Rows |
0 |
Pages |
0 |
System |
|
Temporary |
|
With OID |
|
Definition
dnkey SERIAL,
dnkeymilprojecten INTEGER,
dnkeymilinrichtingen INTEGER,
dvenergieprojectoms VARCHAR(60),
dvhyperlink VARCHAR(256),
ddstartdatum TIMESTAMP WITHOUT TIME ZONE,
ddeinddatum TIMESTAMP WITHOUT TIME ZONE,
CONSTRAINT cpk_tbmilenergieproj PRIMARY KEY(dnkey),
CONSTRAINT cnn_tbmilenergieproj_keymilinr CHECK (dnkeymilinrichtingen IS NOT NULL),
CONSTRAINT cnn_tbmilenergieproj_oms CHECK (dvenergieprojectoms IS NOT NULL),
CONSTRAINT cnn_tbmilenergproj_keymilproj CHECK (dnkeymilprojecten IS NOT NULL),
CONSTRAINT cfk_tbmilenergieproj_keymilinr FOREIGN KEY (dnkeymilinrichtingen)
REFERENCES public.tbmilinrichtingen(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE,
CONSTRAINT cfk_tbmilenergproj_keymilproj FOREIGN KEY (dnkeymilprojecten)
REFERENCES public.tbmilprojecten(dnkey)
ON DELETE CASCADE
ON UPDATE NO ACTION
NOT DEFERRABLE
) ;
COMMENT ON TABLE public.tbmilenergieprojecten
IS 'Tabel met energieprojecten per inrichting.';
COMMENT ON COLUMN public.tbmilenergieprojecten.dnkey
IS 'Primary key.';
COMMENT ON COLUMN public.tbmilenergieprojecten.dnkeymilprojecten
IS 'Foreign key naar tabel tbmilprojecten.';
COMMENT ON COLUMN public.tbmilenergieprojecten.dnkeymilinrichtingen
IS 'Foreign key naar tabel tbmilinrichtingen.';
COMMENT ON COLUMN public.tbmilenergieprojecten.dvenergieprojectoms
IS 'Omschrijving van het energieproject.';
COMMENT ON COLUMN public.tbmilenergieprojecten.dvhyperlink
IS 'Verwijzing naar een map, url of bestand.';
COMMENT ON COLUMN public.tbmilenergieprojecten.ddstartdatum
IS 'Startdatum van het energieproject bij de inrichting.';
COMMENT ON COLUMN public.tbmilenergieprojecten.ddeinddatum
IS 'Einddatum van het energieproject bij de inrichting.';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 5-1-2022 14:13 |
|