diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-07-22 02:57:00 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-07-22 02:57:00 +0000 |
| commit | ee57cc221ff2edafd3c0f12a181214c602ed257e (patch) | |
| tree | 148f552f503798f7a350d6eff936b889f16be49f /db/migrations/0222_stiff_nehzno.sql | |
| parent | 14f61e24947fb92dd71ec0a7196a6e815f8e66da (diff) | |
(대표님, 최겸) 이메일 템플릿, 벤더데이터 변경사항 대응, 기술영업 변경요구사항 구현
Diffstat (limited to 'db/migrations/0222_stiff_nehzno.sql')
| -rw-r--r-- | db/migrations/0222_stiff_nehzno.sql | 46 |
1 files changed, 46 insertions, 0 deletions
diff --git a/db/migrations/0222_stiff_nehzno.sql b/db/migrations/0222_stiff_nehzno.sql new file mode 100644 index 00000000..302d28dc --- /dev/null +++ b/db/migrations/0222_stiff_nehzno.sql @@ -0,0 +1,46 @@ +CREATE TABLE "knox"."organization" ( + "company_code" varchar(10) NOT NULL, + "department_code" varchar(50) NOT NULL, + "company_name" varchar(100), + "department_level" varchar(10), + "department_name" varchar(255), + "department_order" varchar(10), + "en_company_name" varchar(100), + "en_department_name" varchar(255), + "en_manager_title" varchar(255), + "en_sub_org_code" varchar(50), + "in_department_code" varchar(50), + "low_department_yn" varchar(2), + "manager_id" varchar(50), + "manager_name" varchar(100), + "manager_title" varchar(255), + "preferred_language" varchar(5), + "sub_org_code" varchar(50), + "sub_org_name" varchar(255), + "upr_department_code" varchar(50), + "en_upr_department_name" varchar(255), + "upr_department_name" varchar(255), + "hidden_department_yn" varchar(2), + "corp_code" varchar(20), + "corp_name" varchar(100), + "en_corp_name" varchar(100), + "raw" jsonb NOT NULL, + "created_at" timestamp with time zone DEFAULT now() NOT NULL, + "updated_at" timestamp with time zone DEFAULT now() NOT NULL, + CONSTRAINT "organization_company_code_department_code_pk" PRIMARY KEY("company_code","department_code") +); +--> statement-breakpoint +CREATE TABLE "knox"."title" ( + "company_code" varchar(10) NOT NULL, + "title_code" varchar(20) NOT NULL, + "title_name" varchar(100), + "en_title_name" varchar(100), + "sort_order" varchar(10), + "raw" jsonb NOT NULL, + "created_at" timestamp with time zone DEFAULT now() NOT NULL, + "updated_at" timestamp with time zone DEFAULT now() NOT NULL, + CONSTRAINT "title_company_code_title_code_pk" PRIMARY KEY("company_code","title_code") +); +--> statement-breakpoint +CREATE INDEX "knox_org_company_idx" ON "knox"."organization" USING btree ("company_code");--> statement-breakpoint +CREATE INDEX "knox_title_company_idx" ON "knox"."title" USING btree ("company_code");
\ No newline at end of file |