Query

database.sqlite — insights_by_period

SQL

CREATE TABLE "insights_by_period"  (
  "id" integer PRIMARY KEY NOT NULL,
  "metaId" integer NOT NULL,
  "type" integer NOT NULL,
  "value" bigint NOT NULL,
  "periodUnit" integer NOT NULL,
  "periodStart" datetime(0) DEFAULT (CURRENT_TIMESTAMP),
  CONSTRAINT "FK_e8881f2214df046dc2740260fe8" FOREIGN KEY ("metaId") REFERENCES "insights_metadata" ("metaId") ON DELETE CASCADE
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
metaId INTEGER Rename | Drop
type INTEGER Rename | Drop
value bigint Rename | Drop
periodUnit INTEGER Rename | Drop
periodStart datetime(0) ✓ Rename | Drop

Foreign Keys

Column Destination
metaId insights_metadata.metaId

+ Add index

Indexes

Name Columns Unique SQL Drop?
IDX_a4da41795da1422f680c723e80
  • periodStart
  • type
  • periodUnit
  • metaId
 ✓ SQL 
CREATE UNIQUE INDEX "IDX_a4da41795da1422f680c723e80"
ON "insights_by_period" ("periodStart", "type", "periodUnit", "metaId")
Drop