Index: .idea/sonarIssues.xml
===================================================================
diff -u -r8cc24326b89723344e57c63db7383f0ebb65b912 -r93d0e86c4ec9620f79bfdf732437bcf8600312c3
--- .idea/sonarIssues.xml (.../sonarIssues.xml) (revision 8cc24326b89723344e57c63db7383f0ebb65b912)
+++ .idea/sonarIssues.xml (.../sonarIssues.xml) (revision 93d0e86c4ec9620f79bfdf732437bcf8600312c3)
@@ -943,6 +943,11 @@
+
+
+
+
+
Index: standard/project/web/script/ddl/oracle/egovframework/api/rivalWar/specHashTag/SpecHashTag_DDL_Oracle.sql
===================================================================
diff -u
--- standard/project/web/script/ddl/oracle/egovframework/api/rivalWar/specHashTag/SpecHashTag_DDL_Oracle.sql (revision 0)
+++ standard/project/web/script/ddl/oracle/egovframework/api/rivalWar/specHashTag/SpecHashTag_DDL_Oracle.sql (revision 93d0e86c4ec9620f79bfdf732437bcf8600312c3)
@@ -0,0 +1,140 @@
+/*
+ * JsTree 추적 로그 테이블
+ * 트리거 Log를 저장합니다.
+ */
+CREATE TABLE T_JSTREE_SPEC_HASH_TAG_LOG
+(
+ C_ID NUMBER NOT NULL,
+ C_PARENTID NUMBER NOT NULL,
+ C_POSITION NUMBER NOT NULL,
+ C_LEFT NUMBER NOT NULL,
+ C_RIGHT NUMBER NOT NULL,
+ C_LEVEL NUMBER NOT NULL,
+ C_TITLE VARCHAR2(4000 BYTE),
+ C_TYPE VARCHAR2(4000 BYTE),
+ C_METHOD VARCHAR2(4000 BYTE),
+ C_STATE VARCHAR2(4000 BYTE),
+ C_DATE DATE NOT NULL
+);
+
+COMMENT ON TABLE T_JSTREE_SPEC_HASH_TAG_LOG IS '기본 트리 스키마 트리거 로그';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG_LOG.C_ID IS '노드 아이디';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG_LOG.C_PARENTID IS '부모 노드 아이디';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG_LOG.C_POSITION IS '노드 포지션';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG_LOG.C_LEFT IS '노드 좌측 끝 포인트';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG_LOG.C_RIGHT IS '노드 우측 끝 포인트';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG_LOG.C_LEVEL IS '노드 DEPTH ';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG_LOG.C_TITLE IS '노드 명';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG_LOG.C_TYPE IS '노드 타입';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG_LOG.C_METHOD IS '노드 변경 행위';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG_LOG.C_STATE IS '노드 상태값 ( 이전인지. 이후인지)';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG_LOG.C_DATE IS '노드 변경 시';
+
+/*
+ * JsTree
+ */
+CREATE TABLE T_JSTREE_SPEC_HASH_TAG
+(
+ C_ID NUMBER NOT NULL,
+ C_PARENTID NUMBER NOT NULL,
+ C_POSITION NUMBER NOT NULL,
+ C_LEFT NUMBER NOT NULL,
+ C_RIGHT NUMBER NOT NULL,
+ C_LEVEL NUMBER NOT NULL,
+ C_TITLE VARCHAR2(4000 BYTE),
+ C_TYPE VARCHAR2(4000 BYTE),
+
+ MAPPING_COMPARE_ID NUMBER,
+ TAG_SOURCE_CHAT_ID NUMBER,
+ TAG_NAME VARCHAR2(4000 BYTE),
+
+ CONSTRAINT T_JSTREE_SPEC_HASH_TAG_PK PRIMARY KEY (C_ID)
+ /*
+ * CONSTRAINT T_JSTREE_SPEC_HASH_TAG_FK1 FOREIGN KEY (OTHER_ID) REFERENCES OTHER T_JSTREE_SPEC_HASH_TAG(C_ID) ON DELETE CASCADE
+ */
+);
+
+COMMENT ON TABLE T_JSTREE_SPEC_HASH_TAG IS '기본 트리 스키마';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG.C_ID IS '노드 아이디';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG.C_PARENTID IS '부모 노드 아이디';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG.C_POSITION IS '노드 포지션';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG.C_LEFT IS '노드 좌측 끝 포인트';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG.C_RIGHT IS '노드 우측 끝 포인트';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG.C_LEVEL IS '노드 DEPTH ';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG.C_TITLE IS '노드 명';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG.C_TYPE IS '노드 타입';
+
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG.MAPPING_COMPARE_ID IS 'one to many : COMPARE_ITEM';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG.TAG_SOURCE_CHAT_ID IS '해쉬 태그 생성된 채팅 아이디';
+COMMENT ON COLUMN T_JSTREE_SPEC_HASH_TAG.TAG_NAME IS '해쉬 태그 이름';
+
+/*
+ * 인덱스는 되도록 걸지 말것.
+ * CREATE UNIQUE INDEX I_COMPREHENSIVETREE ON T_JSTREE_SPEC_HASH_TAG
+ * ("C_ID" ASC)
+ * DROP SEQUENCE S_JSTREE_SPEC_HASH_TAG;
+ */
+
+
+CREATE SEQUENCE S_JSTREE_SPEC_HASH_TAG
+ START WITH 10
+ MAXVALUE 999999999999999999999999999
+ MINVALUE 0
+ NOCYCLE
+ CACHE 20
+ NOORDER;
+
+/*
+ * JsTree 트리거
+ */
+CREATE OR REPLACE TRIGGER "TG_JSTREE_SPEC_HASH_TAG"
+BEFORE DELETE OR INSERT OR UPDATE
+ON T_JSTREE_SPEC_HASH_TAG
+REFERENCING NEW AS NEW OLD AS OLD
+FOR EACH ROW
+DECLARE
+tmpVar NUMBER;
+/******************************************************************************
+ NAME: TRIGGER_COMPREHENSIVETREE
+ PURPOSE:
+
+ REVISIONS:
+ Ver Date Author Description
+ --------- ---------- --------------- ------------------------------------
+ 1.0 2012-08-29 1. Created this trigger.
+
+ NOTES:
+
+ Automatically available Auto Replace Keywords:
+ Object Name: TRIGGER_COMPREHENSIVETREE
+ Sysdate: 2012-08-29
+ Date and Time: 2012-08-29, 오후 5:26:44, and 2012-08-29 오후 5:26:44
+ Username: (set in TOAD Options, Proc Templates)
+ Table Name: T_JSTREE_SPEC_HASH_TAG (set in the "New PL/SQL Object" dialog)
+ Trigger Options: (set in the "New PL/SQL Object" dialog)
+******************************************************************************/
+BEGIN
+ tmpVar := 0;
+ IF UPDATING THEN
+ insert into T_JSTREE_SPEC_HASH_TAG_LOG
+ values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'update','변경이전데이터',sysdate);
+ insert into T_JSTREE_SPEC_HASH_TAG_LOG
+ values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'update','변경이후데이터',sysdate);
+ END IF;
+ IF DELETING THEN
+ insert into T_JSTREE_SPEC_HASH_TAG_LOG
+ values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'delete','삭제된데이터',sysdate);
+ END IF;
+ IF INSERTING THEN
+ insert into T_JSTREE_SPEC_HASH_TAG_LOG
+ values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'insert','삽입된데이터',sysdate);
+ END IF;
+
+ EXCEPTION
+ WHEN OTHERS THEN
+ -- Consider logging the error and then re-raise
+ RAISE;
+END TG_JSTREE_SPEC_HASH_TAG;
+
+
+/
\ No newline at end of file
Index: standard/project/web/script/ddl/oracle/egovframework/api/rivalWar/userSelectedItem/UserSelectedItem_DDL_Oracle.sql
===================================================================
diff -u -r8cc24326b89723344e57c63db7383f0ebb65b912 -r93d0e86c4ec9620f79bfdf732437bcf8600312c3
--- standard/project/web/script/ddl/oracle/egovframework/api/rivalWar/userSelectedItem/UserSelectedItem_DDL_Oracle.sql (.../UserSelectedItem_DDL_Oracle.sql) (revision 8cc24326b89723344e57c63db7383f0ebb65b912)
+++ standard/project/web/script/ddl/oracle/egovframework/api/rivalWar/userSelectedItem/UserSelectedItem_DDL_Oracle.sql (.../UserSelectedItem_DDL_Oracle.sql) (revision 93d0e86c4ec9620f79bfdf732437bcf8600312c3)
@@ -2,7 +2,7 @@
* JsTree 추적 로그 테이블
* 트리거 Log를 저장합니다.
*/
-CREATE TABLE T_JSTREE_COMPARE_ITEM_LOG
+CREATE TABLE T_SELECTED_ITEM_LOG
(
C_ID NUMBER NOT NULL,
C_PARENTID NUMBER NOT NULL,
@@ -17,23 +17,23 @@
C_DATE DATE NOT NULL
);
-COMMENT ON TABLE T_JSTREE_COMPARE_ITEM_LOG IS '기본 트리 스키마 트리거 로그';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM_LOG.C_ID IS '노드 아이디';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM_LOG.C_PARENTID IS '부모 노드 아이디';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM_LOG.C_POSITION IS '노드 포지션';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM_LOG.C_LEFT IS '노드 좌측 끝 포인트';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM_LOG.C_RIGHT IS '노드 우측 끝 포인트';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM_LOG.C_LEVEL IS '노드 DEPTH ';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM_LOG.C_TITLE IS '노드 명';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM_LOG.C_TYPE IS '노드 타입';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM_LOG.C_METHOD IS '노드 변경 행위';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM_LOG.C_STATE IS '노드 상태값 ( 이전인지. 이후인지)';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM_LOG.C_DATE IS '노드 변경 시';
+COMMENT ON TABLE T_SELECTED_ITEM_LOG IS '기본 트리 스키마 트리거 로그';
+COMMENT ON COLUMN T_SELECTED_ITEM_LOG.C_ID IS '노드 아이디';
+COMMENT ON COLUMN T_SELECTED_ITEM_LOG.C_PARENTID IS '부모 노드 아이디';
+COMMENT ON COLUMN T_SELECTED_ITEM_LOG.C_POSITION IS '노드 포지션';
+COMMENT ON COLUMN T_SELECTED_ITEM_LOG.C_LEFT IS '노드 좌측 끝 포인트';
+COMMENT ON COLUMN T_SELECTED_ITEM_LOG.C_RIGHT IS '노드 우측 끝 포인트';
+COMMENT ON COLUMN T_SELECTED_ITEM_LOG.C_LEVEL IS '노드 DEPTH ';
+COMMENT ON COLUMN T_SELECTED_ITEM_LOG.C_TITLE IS '노드 명';
+COMMENT ON COLUMN T_SELECTED_ITEM_LOG.C_TYPE IS '노드 타입';
+COMMENT ON COLUMN T_SELECTED_ITEM_LOG.C_METHOD IS '노드 변경 행위';
+COMMENT ON COLUMN T_SELECTED_ITEM_LOG.C_STATE IS '노드 상태값 ( 이전인지. 이후인지)';
+COMMENT ON COLUMN T_SELECTED_ITEM_LOG.C_DATE IS '노드 변경 시';
/*
* JsTree
*/
-CREATE TABLE T_JSTREE_COMPARE_ITEM
+CREATE TABLE T_SELECTED_ITEM
(
C_ID NUMBER NOT NULL,
C_PARENTID NUMBER NOT NULL,
@@ -44,37 +44,39 @@
C_TITLE VARCHAR2(4000 BYTE),
C_TYPE VARCHAR2(4000 BYTE),
- MAPPING_MENU_ID NUMBER,
- COMPARE_ITEM_NAME VARCHAR2(4000 BYTE),
+ USER_CID NUMBER,
+ MENU_CID NUMBER,
+ COMPARE_ITEM_CID NUMBER,
- CONSTRAINT T_JSTREE_COMPARE_ITEM_PK PRIMARY KEY (C_ID)
+ CONSTRAINT T_SELECTED_ITEM_PK PRIMARY KEY (C_ID)
/*
- * CONSTRAINT T_JSTREE_COMPARE_ITEM_FK1 FOREIGN KEY (OTHER_ID) REFERENCES OTHER T_JSTREE_COMPARE_ITEM(C_ID) ON DELETE CASCADE
+ * CONSTRAINT T_SELECTED_ITEM_FK1 FOREIGN KEY (OTHER_ID) REFERENCES OTHER T_SELECTED_ITEM(C_ID) ON DELETE CASCADE
*/
);
-COMMENT ON TABLE T_JSTREE_COMPARE_ITEM IS '기본 트리 스키마';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM.C_ID IS '노드 아이디';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM.C_PARENTID IS '부모 노드 아이디';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM.C_POSITION IS '노드 포지션';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM.C_LEFT IS '노드 좌측 끝 포인트';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM.C_RIGHT IS '노드 우측 끝 포인트';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM.C_LEVEL IS '노드 DEPTH ';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM.C_TITLE IS '노드 명';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM.C_TYPE IS '노드 타입';
+COMMENT ON TABLE T_SELECTED_ITEM IS '기본 트리 스키마';
+COMMENT ON COLUMN T_SELECTED_ITEM.C_ID IS '노드 아이디';
+COMMENT ON COLUMN T_SELECTED_ITEM.C_PARENTID IS '부모 노드 아이디';
+COMMENT ON COLUMN T_SELECTED_ITEM.C_POSITION IS '노드 포지션';
+COMMENT ON COLUMN T_SELECTED_ITEM.C_LEFT IS '노드 좌측 끝 포인트';
+COMMENT ON COLUMN T_SELECTED_ITEM.C_RIGHT IS '노드 우측 끝 포인트';
+COMMENT ON COLUMN T_SELECTED_ITEM.C_LEVEL IS '노드 DEPTH ';
+COMMENT ON COLUMN T_SELECTED_ITEM.C_TITLE IS '노드 명';
+COMMENT ON COLUMN T_SELECTED_ITEM.C_TYPE IS '노드 타입';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM.MAPPING_MENU_ID IS '맵핑할 메뉴의 아이디';
-COMMENT ON COLUMN T_JSTREE_COMPARE_ITEM.COMPARE_ITEM_NAME IS '비교 하위 아이템 이름';
+COMMENT ON COLUMN T_SELECTED_ITEM.USER_CID IS '사용자 아이디';
+COMMENT ON COLUMN T_SELECTED_ITEM.MENU_CID IS '사용자가 선택할 진영에 대한 메뉴 아이디';
+COMMENT ON COLUMN T_SELECTED_ITEM.COMPARE_ITEM_CID IS '사용자가 선택한 진영(아디템) 아이디';
/*
* 인덱스는 되도록 걸지 말것.
- * CREATE UNIQUE INDEX I_COMPREHENSIVETREE ON T_JSTREE_COMPARE_ITEM
+ * CREATE UNIQUE INDEX I_COMPREHENSIVETREE ON T_SELECTED_ITEM
* ("C_ID" ASC)
- * DROP SEQUENCE S_JSTREE_COMPARE_ITEM;
+ * DROP SEQUENCE S_SELECTED_ITEM;
*/
-CREATE SEQUENCE S_JSTREE_COMPARE_ITEM
+CREATE SEQUENCE S_SELECTED_ITEM
START WITH 10
MAXVALUE 999999999999999999999999999
MINVALUE 0
@@ -85,9 +87,9 @@
/*
* JsTree 트리거
*/
-CREATE OR REPLACE TRIGGER "TG_JSTREE_COMPARE_ITEM"
+CREATE OR REPLACE TRIGGER "TG_SELECTED_ITEM"
BEFORE DELETE OR INSERT OR UPDATE
-ON T_JSTREE_COMPARE_ITEM
+ON T_SELECTED_ITEM
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
@@ -108,31 +110,31 @@
Sysdate: 2012-08-29
Date and Time: 2012-08-29, 오후 5:26:44, and 2012-08-29 오후 5:26:44
Username: (set in TOAD Options, Proc Templates)
- Table Name: T_JSTREE_COMPARE_ITEM (set in the "New PL/SQL Object" dialog)
+ Table Name: T_SELECTED_ITEM (set in the "New PL/SQL Object" dialog)
Trigger Options: (set in the "New PL/SQL Object" dialog)
******************************************************************************/
BEGIN
tmpVar := 0;
IF UPDATING THEN
- insert into T_JSTREE_COMPARE_ITEM_LOG
+ insert into T_SELECTED_ITEM_LOG
values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'update','변경이전데이터',sysdate);
- insert into T_JSTREE_COMPARE_ITEM_LOG
+ insert into T_SELECTED_ITEM_LOG
values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'update','변경이후데이터',sysdate);
END IF;
IF DELETING THEN
- insert into T_JSTREE_COMPARE_ITEM_LOG
+ insert into T_SELECTED_ITEM_LOG
values (:old.C_ID,:old.C_PARENTID,:old.C_POSITION,:old.C_LEFT,:old.C_RIGHT,:old.C_LEVEL,:old.C_TITLE,:old.C_TYPE,'delete','삭제된데이터',sysdate);
END IF;
IF INSERTING THEN
- insert into T_JSTREE_COMPARE_ITEM_LOG
+ insert into T_SELECTED_ITEM_LOG
values (:new.C_ID,:new.C_PARENTID,:new.C_POSITION,:new.C_LEFT,:new.C_RIGHT,:new.C_LEVEL,:new.C_TITLE,:new.C_TYPE,'insert','삽입된데이터',sysdate);
END IF;
EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
-END TG_JSTREE_COMPARE_ITEM;
+END TG_SELECTED_ITEM;
/
\ No newline at end of file