|
CREATE TABLE ljh.ic_process_tbl
(
cycl character varying(10) NOT NULL, -- 회차
proc_code character varying(10) NOT NULL, -- 프로세스코드
proc_name character varying(100), -- 프로세스명
proc_cont character varying(1000), -- 프로세스 설명
prnt_proc_code character varying(10), -- 프로세스부모코드
proc_dept_code character varying(10), -- 프로세스주관팀
proc_duty_emp_no character varying(20), -- 프로세스책임자(PO)
proc_delg_emp_no character varying(20), -- 프로세스위임자(PO)
proc_eval_emp_no character varying(20), -- 프로세스평가자(PE)
rgst_date character varying(14) DEFAULT to_char(('now'::text)::timestamp without time zone, 'yyyymmddhh24miss'::text), -- 등록일자
modi_date character varying(14) DEFAULT to_char(('now'::text)::timestamp without time zone, 'yyyymmddhh24miss'::text), -- 수정일자
rgst_emp_no character varying(20), -- 등록자
modi_emp_no character varying(20), -- 수정자
last_gubn character varying(1) DEFAULT 'N'::character varying, -- 최하위구분
CONSTRAINT ic_process_tbl_pkey PRIMARY KEY (cycl, proc_code)
)
WITH (
OIDS=FALSE
);
ALTER TABLE ljh.ic_process_tbl
OWNER TO ljh;
COMMENT ON TABLE ljh.ic_process_tbl
IS '프로세스목록';
COMMENT ON COLUMN ljh.ic_process_tbl.cycl IS '회차';
COMMENT ON COLUMN ljh.ic_process_tbl.proc_code IS '프로세스코드';
COMMENT ON COLUMN ljh.ic_process_tbl.proc_name IS '프로세스명';
COMMENT ON COLUMN ljh.ic_process_tbl.proc_cont IS '프로세스 설명';
COMMENT ON COLUMN ljh.ic_process_tbl.prnt_proc_code IS '프로세스부모코드';
COMMENT ON COLUMN ljh.ic_process_tbl.proc_dept_code IS '프로세스주관팀';
COMMENT ON COLUMN ljh.ic_process_tbl.proc_duty_emp_no IS '프로세스책임자(PO)';
COMMENT ON COLUMN ljh.ic_process_tbl.proc_delg_emp_no IS '프로세스위임자(PO)';
COMMENT ON COLUMN ljh.ic_process_tbl.proc_eval_emp_no IS '프로세스평가자(PE)';
COMMENT ON COLUMN ljh.ic_process_tbl.rgst_date IS '등록일자';
COMMENT ON COLUMN ljh.ic_process_tbl.modi_date IS '수정일자';
COMMENT ON COLUMN ljh.ic_process_tbl.rgst_emp_no IS '등록자';
COMMENT ON COLUMN ljh.ic_process_tbl.modi_emp_no IS '수정자';
COMMENT ON COLUMN ljh.ic_process_tbl.last_gubn IS '최하위구분';
-- Index: ljh.xic_process_tbl_x1
-- DROP INDEX ljh.xic_process_tbl_x1;
CREATE INDEX xic_process_tbl_x1
ON ljh.ic_process_tbl
USING btree
(proc_duty_emp_no COLLATE pg_catalog."default");
-- Index: ljh.xic_process_tbl_x2
-- DROP INDEX ljh.xic_process_tbl_x2;
CREATE INDEX xic_process_tbl_x2
ON ljh.ic_process_tbl
USING btree
(proc_eval_emp_no COLLATE pg_catalog."default");
-- Index: ljh.xic_process_tbl_x3
-- DROP INDEX ljh.xic_process_tbl_x3;
CREATE INDEX xic_process_tbl_x3
ON ljh.ic_process_tbl
USING btree
(proc_delg_emp_no COLLATE pg_catalog."default");
해당 테이블을 생성하려는데
ORA-00907: 누락된 우괄호 에러가 발생하는데 어느 부분이 잘못된건가요? |
