14 lines
485 B
SQL
14 lines
485 B
SQL
CREATE TABLE "forecast_import" (
|
|
"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
|
|
"receiving_plant_id" text NOT NULL,
|
|
"documentName" text,
|
|
"sender" text,
|
|
"customer_id" text,
|
|
"raw_data" jsonb DEFAULT '[]'::jsonb,
|
|
"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 "forecast_import_documentName_unique" UNIQUE("documentName")
|
|
);
|