| 1 | CREATE TABLE "job"
|
| 2 | (
|
| 3 | "id" BIGSERIAL PRIMARY KEY NOT NULL,
|
| 4 | "isComplete" boolean NOT NULL,
|
| 5 | "priority" int NOT NULL,
|
| 6 | "name" varchar NOT NULL,
|
| 7 | "scheduledAt" timestamptz NOT NULL DEFAULT now(),
|
| 8 | "data" jsonb NOT NULL,
|
| 9 | "createdAt" timestamptz NOT NULL DEFAULT now(),
|
| 10 | "updatedAt" timestamptz NOT NULL DEFAULT now()
|
| 11 | );
|
| 12 |
|
| 13 | CREATE INDEX "jobIsCompleteScheduledAtIdx" ON "job" ("isComplete", "scheduledAt");
|
| 14 | CREATE INDEX "jobNameIdx" ON "job" ("name");
|
| 15 | CREATE INDEX "jobScheduledAtIdx" ON "job" ("scheduledAt");
|