Renovus-Tech / solarec-db

GNU Affero General Public License v3.0
0 stars 0 forks source link

Free metadata for client / location / generator / station #5

Closed pferrariuy closed 4 months ago

pferrariuy commented 4 months ago

Add free-metadata tables for:

The free metadata columns will be use for the differente invereters / cretificate services to store / retrieve data that are specific for each one of them, and will allow to store any type of data in required by future implementations.

pferrariuy commented 4 months ago

At the Java code, the changes will uploaded initially by the following issues:

pferrariuy commented 4 months ago

Tables to be use:

CREATE TABLE cli_metadata (
  cli_id INTEGER NOT NULL,
  metadata_name VARCHAR(100) NOT NULL,
  metadata_title VARCHAR(200) NULL,
  metadata_value VARCHAR(200) NULL,
  metadata_date_added timestamp with time zone NULL
);--

CREATE TABLE loc_metadata (
  cli_id INTEGER NOT NULL,
  loc_id INTEGER NOT NULL,
  metadata_name VARCHAR(100) NOT NULL,
  metadata_title VARCHAR(200) NULL,
  metadata_value VARCHAR(200) NULL,
  metadata_date_added timestamp with time zone NULL
);--

CREATE TABLE gen_metadata (
  cli_id INTEGER NOT NULL,
  gen_id INTEGER NOT NULL,
  metadata_code VARCHAR(100) NOT NULL,
  metadata_title VARCHAR(200) NULL,
  metadata_value VARCHAR(200) NULL,
  metadata_date_added timestamp with time zone NULL
);--

CREATE TABLE sta_metadata (
  cli_id INTEGER NOT NULL,
  sta_id INTEGER NOT NULL,
  metadata_name VARCHAR(100) NOT NULL,
  metadata_title VARCHAR(200) NULL,
  metadata_value VARCHAR(200) NULL,
  metadata_date_added timestamp with time zone NULL
);--