38 lines
1.4 KiB
SQL
38 lines
1.4 KiB
SQL
UPDATE "courses"
|
|
SET "organization_name" = '공통'
|
|
WHERE "slug" = 'futuredrive-autonomy-basic'
|
|
AND "organization_name" = '퓨처드라이브';
|
|
|
|
CREATE TABLE "instructor_curriculum_week_overrides" (
|
|
"id" UUID NOT NULL DEFAULT gen_random_uuid(),
|
|
"organization_id" UUID,
|
|
"organization_name" TEXT NOT NULL,
|
|
"course_id" UUID NOT NULL,
|
|
"week" INTEGER NOT NULL,
|
|
"title" TEXT,
|
|
"overview" TEXT,
|
|
"deliverable" TEXT,
|
|
"topics" JSONB,
|
|
"topic_details" JSONB,
|
|
"created_at" TIMESTAMPTZ(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updated_at" TIMESTAMPTZ(3) NOT NULL,
|
|
|
|
CONSTRAINT "instructor_curriculum_week_overrides_pkey" PRIMARY KEY ("id")
|
|
);
|
|
|
|
CREATE UNIQUE INDEX "instructor_curriculum_week_overrides_organization_name_course_id_week_key"
|
|
ON "instructor_curriculum_week_overrides"("organization_name", "course_id", "week");
|
|
|
|
CREATE INDEX "instructor_curriculum_week_overrides_organization_id_idx"
|
|
ON "instructor_curriculum_week_overrides"("organization_id");
|
|
|
|
CREATE INDEX "instructor_curriculum_week_overrides_organization_name_idx"
|
|
ON "instructor_curriculum_week_overrides"("organization_name");
|
|
|
|
CREATE INDEX "instructor_curriculum_week_overrides_course_id_idx"
|
|
ON "instructor_curriculum_week_overrides"("course_id");
|
|
|
|
ALTER TABLE "instructor_curriculum_week_overrides"
|
|
ADD CONSTRAINT "instructor_curriculum_week_overrides_course_id_fkey"
|
|
FOREIGN KEY ("course_id") REFERENCES "courses"("id") ON DELETE CASCADE ON UPDATE CASCADE;
|