| 1 | CREATE TABLE "file"
|
| 2 | (
|
| 3 | "id" uuid PRIMARY KEY NOT NULL DEFAULT uuid_generate_v4(),
|
| 4 | "contentLength" int NOT NULL,
|
| 5 | "bucketName" varchar NOT NULL,
|
| 6 | "contentType" varchar NOT NULL,
|
| 7 | "name" varchar NOT NULL,
|
| 8 | "meta" jsonb NOT NULL,
|
| 9 | "createdAt" timestamptz NOT NULL DEFAULT now(),
|
| 10 | "updatedAt" timestamptz NOT NULL DEFAULT now(),
|
| 11 | "deletedAt" timestamptz NULL
|
| 12 | );
|
| 13 |
|
| 14 | CREATE INDEX "fileBucketNameIdx" ON "file" ("bucketName");
|
| 15 | CREATE INDEX "fileDeletedAtIdx" ON "file" ("deletedAt");
|