13 lines
460 B
SQL
13 lines
460 B
SQL
CREATE TABLE IF NOT EXISTS "unifi_controllers" (
|
|
"id" uuid PRIMARY KEY DEFAULT gen_random_uuid() NOT NULL,
|
|
"org_id" text NOT NULL,
|
|
"site_id" uuid,
|
|
"base_url" text NOT NULL,
|
|
"role" text NOT NULL,
|
|
"region" text,
|
|
"created_at" timestamp DEFAULT now() NOT NULL,
|
|
"updated_at" timestamp DEFAULT now() NOT NULL
|
|
);
|
|
|
|
ALTER TABLE "unifi_controllers" ADD CONSTRAINT "unifi_controllers_site_id_fk" FOREIGN KEY ("site_id") REFERENCES "public"."sites"("id");
|