Blake Matthes
7671172d97
All checks were successful
Build and Push LST Docker Image / docker (push) Successful in 1m47s
ref #12
14 lines
500 B
SQL
14 lines
500 B
SQL
CREATE TABLE "dock_door_scans" (
|
|
"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
|
|
"loading_order" text NOT NULL,
|
|
"loading_Unit" text,
|
|
"loading_unit_status" text DEFAULT 'loaded',
|
|
"message" text,
|
|
"status" text DEFAULT 'active',
|
|
"add_date" timestamp with time zone DEFAULT now(),
|
|
"add_user" text DEFAULT 'lst-system',
|
|
"upd_date" timestamp with time zone DEFAULT now(),
|
|
"upd_user" text DEFAULT 'lst-system',
|
|
CONSTRAINT "dock_door_scans_loading_Unit_unique" UNIQUE("loading_Unit")
|
|
);
|