109 lines
3.1 KiB
SQL
109 lines
3.1 KiB
SQL
-- Create "DivisionLink" table
|
|
CREATE TABLE "public"."DivisionLink" (
|
|
"Id" bigserial NOT NULL,
|
|
"CreatedAt" timestamptz NULL,
|
|
"UpdatedAt" timestamptz NULL,
|
|
"DeletedAt" timestamptz NULL,
|
|
"Simx_Id" bigint NULL,
|
|
"Simgos_Id" bigint NULL,
|
|
PRIMARY KEY ("Id"),
|
|
CONSTRAINT "uni_DivisionLink_Simgos_Id" UNIQUE ("Simgos_Id"),
|
|
CONSTRAINT "uni_DivisionLink_Simx_Id" UNIQUE ("Simx_Id")
|
|
);
|
|
-- Create "DivisionSimgosLog" table
|
|
CREATE TABLE "public"."DivisionSimgosLog" (
|
|
"Id" bigserial NOT NULL,
|
|
"CreatedAt" timestamptz NULL,
|
|
"UpdatedAt" timestamptz NULL,
|
|
"DeletedAt" timestamptz NULL,
|
|
"Value" text NULL,
|
|
"Date" timestamptz NULL,
|
|
"Status" text NULL,
|
|
"ErrMessage" text NULL,
|
|
PRIMARY KEY ("Id")
|
|
);
|
|
-- Create "DivisionSimxLog" table
|
|
CREATE TABLE "public"."DivisionSimxLog" (
|
|
"Id" bigserial NOT NULL,
|
|
"CreatedAt" timestamptz NULL,
|
|
"UpdatedAt" timestamptz NULL,
|
|
"DeletedAt" timestamptz NULL,
|
|
"Value" text NULL,
|
|
"Date" timestamptz NULL,
|
|
"Status" text NULL,
|
|
"ErrMessage" text NULL,
|
|
PRIMARY KEY ("Id")
|
|
);
|
|
-- Create "SpecialistLink" table
|
|
CREATE TABLE "public"."SpecialistLink" (
|
|
"Id" bigserial NOT NULL,
|
|
"CreatedAt" timestamptz NULL,
|
|
"UpdatedAt" timestamptz NULL,
|
|
"DeletedAt" timestamptz NULL,
|
|
"Simx_Id" bigint NULL,
|
|
"Simgos_Id" bigint NULL,
|
|
PRIMARY KEY ("Id"),
|
|
CONSTRAINT "uni_SpecialistLink_Simgos_Id" UNIQUE ("Simgos_Id"),
|
|
CONSTRAINT "uni_SpecialistLink_Simx_Id" UNIQUE ("Simx_Id")
|
|
);
|
|
-- Create "SpecialistSimgosLog" table
|
|
CREATE TABLE "public"."SpecialistSimgosLog" (
|
|
"Id" bigserial NOT NULL,
|
|
"CreatedAt" timestamptz NULL,
|
|
"UpdatedAt" timestamptz NULL,
|
|
"DeletedAt" timestamptz NULL,
|
|
"Value" text NULL,
|
|
"Date" timestamptz NULL,
|
|
"Status" text NULL,
|
|
"ErrMessage" text NULL,
|
|
PRIMARY KEY ("Id")
|
|
);
|
|
-- Create "SpecialistSimxLog" table
|
|
CREATE TABLE "public"."SpecialistSimxLog" (
|
|
"Id" bigserial NOT NULL,
|
|
"CreatedAt" timestamptz NULL,
|
|
"UpdatedAt" timestamptz NULL,
|
|
"DeletedAt" timestamptz NULL,
|
|
"Value" text NULL,
|
|
"Date" timestamptz NULL,
|
|
"Status" text NULL,
|
|
"ErrMessage" text NULL,
|
|
PRIMARY KEY ("Id")
|
|
);
|
|
-- Create "SubspecialistLink" table
|
|
CREATE TABLE "public"."SubspecialistLink" (
|
|
"Id" bigserial NOT NULL,
|
|
"CreatedAt" timestamptz NULL,
|
|
"UpdatedAt" timestamptz NULL,
|
|
"DeletedAt" timestamptz NULL,
|
|
"Simx_Id" bigint NULL,
|
|
"Simgos_Id" bigint NULL,
|
|
PRIMARY KEY ("Id"),
|
|
CONSTRAINT "uni_SubspecialistLink_Simgos_Id" UNIQUE ("Simgos_Id"),
|
|
CONSTRAINT "uni_SubspecialistLink_Simx_Id" UNIQUE ("Simx_Id")
|
|
);
|
|
-- Create "SubspecialistSimgosLog" table
|
|
CREATE TABLE "public"."SubspecialistSimgosLog" (
|
|
"Id" bigserial NOT NULL,
|
|
"CreatedAt" timestamptz NULL,
|
|
"UpdatedAt" timestamptz NULL,
|
|
"DeletedAt" timestamptz NULL,
|
|
"Value" text NULL,
|
|
"Date" timestamptz NULL,
|
|
"Status" text NULL,
|
|
"ErrMessage" text NULL,
|
|
PRIMARY KEY ("Id")
|
|
);
|
|
-- Create "SubspecialistSimxLog" table
|
|
CREATE TABLE "public"."SubspecialistSimxLog" (
|
|
"Id" bigserial NOT NULL,
|
|
"CreatedAt" timestamptz NULL,
|
|
"UpdatedAt" timestamptz NULL,
|
|
"DeletedAt" timestamptz NULL,
|
|
"Value" text NULL,
|
|
"Date" timestamptz NULL,
|
|
"Status" text NULL,
|
|
"ErrMessage" text NULL,
|
|
PRIMARY KEY ("Id")
|
|
);
|