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/0221_neat_grey_gargoyle.sql | |
| parent | 14f61e24947fb92dd71ec0a7196a6e815f8e66da (diff) | |
(대표님, 최겸) 이메일 템플릿, 벤더데이터 변경사항 대응, 기술영업 변경요구사항 구현
Diffstat (limited to 'db/migrations/0221_neat_grey_gargoyle.sql')
| -rw-r--r-- | db/migrations/0221_neat_grey_gargoyle.sql | 46 |
1 files changed, 46 insertions, 0 deletions
diff --git a/db/migrations/0221_neat_grey_gargoyle.sql b/db/migrations/0221_neat_grey_gargoyle.sql new file mode 100644 index 00000000..79e430d7 --- /dev/null +++ b/db/migrations/0221_neat_grey_gargoyle.sql @@ -0,0 +1,46 @@ +CREATE SCHEMA "knox"; +--> statement-breakpoint +CREATE TABLE "knox"."employee" ( + "ep_id" varchar(25) PRIMARY KEY NOT NULL, + "employee_number" varchar(20), + "user_id" varchar(50), + "full_name" varchar(100), + "given_name" varchar(100), + "sir_name" varchar(50), + "company_code" varchar(10), + "company_name" varchar(100), + "department_code" varchar(50), + "department_name" varchar(255), + "title_code" varchar(20), + "title_name" varchar(100), + "email_address" varchar(255), + "mobile" varchar(50), + "employee_status" varchar(2), + "employee_type" varchar(2), + "account_status" varchar(2), + "security_level" varchar(2), + "preferred_language" varchar(5), + "description" text, + "raw" jsonb NOT NULL, + "created_at" timestamp with time zone DEFAULT now() NOT NULL, + "updated_at" timestamp with time zone DEFAULT now() NOT NULL, + "en_company_name" varchar(100), + "en_department_name" varchar(255), + "en_discription" varchar(255), + "en_full_name" varchar(100), + "en_given_name" varchar(100), + "en_grade_name" varchar(100), + "en_sir_name" varchar(50), + "en_title_name" varchar(100), + "grade_name" varchar(100), + "grade_title_indi_code" varchar(2), + "job_name" varchar(100), + "real_name_yn" varchar(2), + "server_location" varchar(2), + "title_sort_order" varchar(10) +); +--> statement-breakpoint +CREATE INDEX "knox_employee_company_department_idx" ON "knox"."employee" USING btree ("company_code","department_code");--> statement-breakpoint +CREATE INDEX "knox_employee_number_idx" ON "knox"."employee" USING btree ("employee_number");--> statement-breakpoint +CREATE INDEX "knox_employee_user_id_idx" ON "knox"."employee" USING btree ("user_id");--> statement-breakpoint +CREATE INDEX "knox_employee_email_idx" ON "knox"."employee" USING btree ("email_address");
\ No newline at end of file |