32 lines
898 B
SQL
32 lines
898 B
SQL
-- CreateTable
|
|
CREATE TABLE "public"."MainLedger" (
|
|
"id" SERIAL NOT NULL,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
"reference" VARCHAR(128) NOT NULL,
|
|
"amount" DECIMAL(18,6) NOT NULL,
|
|
"currency" VARCHAR(16) NOT NULL,
|
|
"description" TEXT,
|
|
"metadata" JSONB,
|
|
|
|
CONSTRAINT "MainLedger_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateTable
|
|
CREATE TABLE "public"."Registry" (
|
|
"id" SERIAL NOT NULL,
|
|
"createdAt" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updatedAt" TIMESTAMP(3) NOT NULL,
|
|
"key" VARCHAR(128) NOT NULL,
|
|
"value" JSONB NOT NULL,
|
|
"description" TEXT,
|
|
|
|
CONSTRAINT "Registry_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE INDEX "MainLedger_reference_idx" ON "public"."MainLedger"("reference");
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "Registry_key_key" ON "public"."Registry"("key");
|