SQL> drop table "USER"
     [OK]

SQL> drop table "COUNTER"
     [OK]

SQL> drop table "TIME"
     [OK]

SQL> drop table "USAGE"
     [OK]

SQL> create table "USER" (
    "ID" BIGINT,
    "EMAIL" VARCHAR(50),
    "COMPANY" VARCHAR(50),
    "COUNTRY" VARCHAR(50),
    "SKILL" VARCHAR(50)
    )
     [OK]

SQL> create index "USER_ID" on "USER" ("ID")
     [OK]

SQL> create index "USER_EMAIL" on "USER" ("EMAIL")
     [OK]

SQL> create index "USER_COMPANY" on "USER" ("COMPANY")
     [OK]

SQL> create index "USER_COUNTRY" on "USER" ("COUNTRY")
     [OK]

SQL> create index "USER_SKILL" on "USER" ("SKILL")
     [OK]

SQL> create table "COUNTER" (
    "ID" BIGINT,
    "COUNTERNAME" VARCHAR(50),
    "TASK" VARCHAR(50),
    "MODULE" VARCHAR(50),
    "APPLICATION" VARCHAR(50),
    "SEVERITY" VARCHAR(50)
    )
     [OK]

SQL> create index "COUNTER_ID" on "COUNTER" ("ID")
     [OK]

SQL> create index "COUNTER_COUNTERNAME" on "COUNTER" ("COUNTERNAME")
     [OK]

SQL> create index "COUNTER_TASK" on "COUNTER" ("TASK")
     [OK]

SQL> create index "COUNTER_MODULE" on "COUNTER" ("MODULE")
     [OK]

SQL> create index "COUNTER_APPLICATION" on "COUNTER" ("APPLICATION")
     [OK]

SQL> create index "COUNTER_SEVERITY" on "COUNTER" ("SEVERITY")
     [OK]

SQL> create table "TIME" (
    "ID" BIGINT,
    "DAY" VARCHAR(50),
    "ORD_DAY" INTEGER,
    "MONTH" VARCHAR(50),
    "ORD_MONTH" INTEGER,
    "QUARTER" VARCHAR(50),
    "ORD_QUARTER" INTEGER,
    "YEAR" VARCHAR(50),
    "ORD_YEAR" INTEGER,
    "WEEK" VARCHAR(50),
    "ORD_WEEK" INTEGER
    )
     [OK]

SQL> create index "TIME_ID" on "TIME" ("ID")
     [OK]

SQL> create index "TIME_DAY" on "TIME" ("DAY")
     [OK]

SQL> create index "TIME_MONTH" on "TIME" ("MONTH")
     [OK]

SQL> create index "TIME_QUARTER" on "TIME" ("QUARTER")
     [OK]

SQL> create index "TIME_YEAR" on "TIME" ("YEAR")
     [OK]

SQL> create index "TIME_WEEK" on "TIME" ("WEEK")
     [OK]

SQL> create table "USAGE" (
    "ID_USER" BIGINT,
    "ID_DATE" BIGINT,
    "ID_COUNTER" BIGINT,
    "ID_TASK" BIGINT,
    "ID_SEVERITY" BIGINT,
    "COUNT" DOUBLE
    )
     [OK]

SQL> create index "USAGE_ID_USER" on "USAGE" ("ID_USER")
     [OK]

SQL> create index "USAGE_ID_DATE" on "USAGE" ("ID_DATE")
     [OK]

SQL> create index "USAGE_ID_COUNTER" on "USAGE" ("ID_COUNTER")
     [OK]

SQL> create index "USAGE_ID_TASK" on "USAGE" ("ID_TASK")
     [OK]

SQL> create index "USAGE_ID_SEVERITY" on "USAGE" ("ID_SEVERITY")
     [OK]