Creacion De Base De Datos Sql Db2

--

ALTER TABLE "EB_DATABASE"."DEVICES" DROP CONSTRAINT "DEVICES_HOMES_FK";

ALTER TABLE "EB_DATABASE"."DEVICES_MEASUREMENTS" DROP CONSTRAINT "DEVICES_MEASUREMENTS_DEVICES_FK";

ALTER TABLE"EB_DATABASE"."FUTURES" DROP CONSTRAINT "FUTURES_DEVICES_FK";

ALTER TABLE "EB_DATABASE"."HOMES_MEASUREMENTS" DROP CONSTRAINT "HOMES_MEASUREMENTS_HOMES_FK";

ALTER TABLE "EB_DATABASE"."DEVICES" DROPCONSTRAINT "DEVICES_PK";

ALTER TABLE "EB_DATABASE"."DEVICES_MEASUREMENTS" DROP CONSTRAINT "DEVICES_MEASUREMENTS_PK";

ALTER TABLE "EB_DATABASE"."FUTURES" DROP CONSTRAINT "FUTURES_PK";

ALTERTABLE "EB_DATABASE"."HOMES" DROP CONSTRAINT "HOMES_PK";

ALTER TABLE "EB_DATABASE"."HOMES_MEASUREMENTS" DROP CONSTRAINT "HOMES_MEASUREMENTS_PK";

DROP TABLE "EB_DATABASE"."DEVICES";

DROP TABLE"EB_DATABASE"."DEVICES_MEASUREMENTS";

DROP TABLE "EB_DATABASE"."FUTURES";

DROP TABLE "EB_DATABASE"."HOMES";

DROP TABLE "EB_DATABASE"."HOMES_MEASUREMENTS";

DROP SCHEMA "EB_DATABASE" RESTRICT;CREATE SCHEMA "EB_DATABASE";

CREATE TABLE "EB_DATABASE"."DEVICES" (
"ID_DEVICE" INTEGER NOT NULL,
"ID_HOME" INTEGER NOT NULL,
"NAME" CHAR(20) NOT NULL,
"STATUS" INTEGER NOT NULL,"POWER" DECIMAL(2 , 0) NOT NULL,
"MAX" DECIMAL(2 , 0) NOT NULL,
"MIN" DECIMAL(2 , 0) NOT NULL,
"HAVE_USAGE" INTEGER NOT NULL,
"USAGE" DECIMAL(1 , 0) NOT NULL,
"LEVEL" INTEGERNOT NULL,
"HAVE_LEVEL" INTEGER NOT NULL,
"LEVEL_HIGH" DECIMAL(1 , 0),
"LEVEL_MEDIUM" DECIMAL(1 , 0),
"LEVEL_LOW" DECIMAL(1 , 0)
)
DATA CAPTURE NONE
COMPRESS NO;

CREATE TABLE"EB_DATABASE"."DEVICES_MEASUREMENTS" (
"ID_DEVICES_MEASUREMENT" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY ( START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 NO CYCLE CACHE 20 NO ORDER),
"ID_DEVICE" INTEGER NOT NULL,
"ID_HOME" INTEGER NOT NULL,
"TIMESTAMP" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
"ENERGY" DECIMAL(2 , 0) NOT NULL,
"STATUS" INTEGER NOT...