SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE "lpr_rules" ( "id" serial PRIMARY KEY, "created_at" timestamp default current_timestamp, "updated_at" timestamp default current_timestamp, "user_email" varchar(128) NOT NULL, "lp" varchar(24), "uuid" uuid, -- This will be set after we get uuid from the central rules DB, need to set unique "type" varchar(36) NOT NULL, "alert_priority" int default 1, "account_id" bigint NOT NULL, -- "esns" bigint[] NOT NULL, -- TODO: Remove this "state" int default 0, -- 1 is active "location_name" varchar(64), -- Should this be present along with esn ? "location_id" uuid, -- Should this be present along with esn ? "schedule" varchar(256), "config_params" jsonb, "description" varchar(256), "mapping" varchar(24) -- esn or location or account );
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear