20 lines
678 B
SQL
20 lines
678 B
SQL
CREATE TABLE "rfidReaders" (
|
|
"rfidReader_id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
|
|
"reader" text,
|
|
"readerIP" text,
|
|
"lastHeartBeat" timestamp DEFAULT now()
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE TABLE "rfidTags" (
|
|
"rfidTag_id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
|
|
"tagHex" text,
|
|
"tag" text,
|
|
"timeStamp" timestamp DEFAULT now(),
|
|
"counts" jsonb NOT NULL,
|
|
"lastareaIn" text NOT NULL,
|
|
"runningNumber" numeric NOT NULL,
|
|
"created_at" timestamp DEFAULT now()
|
|
);
|
|
--> statement-breakpoint
|
|
CREATE UNIQUE INDEX "reader" ON "rfidReaders" USING btree ("reader");--> statement-breakpoint
|
|
CREATE UNIQUE INDEX "tagHex" ON "rfidTags" USING btree ("tagHex"); |