
CREATE EXTENSION IF NOT EXISTS pgcrypto;
CREATE TABLE "public"."dms_vehicles"("id" uuid NOT NULL DEFAULT gen_random_uuid(), "created_at" timestamptz NOT NULL DEFAULT now(), "makecode" text NOT NULL, "modelcode" text NOT NULL, "make" text NOT NULL, "model" text NOT NULL, "bodyshopid" uuid NOT NULL, PRIMARY KEY ("id") , FOREIGN KEY ("bodyshopid") REFERENCES "public"."bodyshops"("id") ON UPDATE cascade ON DELETE cascade);