1. SHOW CREATE TABLE TB_LI_GERP_SEW_SHIP ; CREATE TABLE `tb_li_gerp_sew_ship` ( `pk_id` int(11) NOT NULL AUTO_INCREMENT, `corp_type` varchar(5) COLLATE utf8_bin DEFAULT NULL COMMENT '회사구분', `DC_CD` varchar(3) COLLATE utf8_bin DEFAULT NULL COMMENT '물류센터코드', `SHIPPING_LINE1` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'MDMS Code', `SHIPPING_LINE2` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'MDMS Code', `CARRIER_CODE1` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'MDMS Code', `CARRIER_CODE2` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'MDMS Code', `ORDER_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT 'GERP Order No', `LINE_NO` double NOT NULL DEFAULT '0' COMMENT 'GERP Order Line No', `ALLOCATION_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT 'Allocation NO', `CC_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT 'Allocation NO', `TOTAL_SHP_QTY` double NOT NULL DEFAULT '0' COMMENT 'Total Ship Qty', `ORDER_QTY` double DEFAULT NULL COMMENT 'Order Qty', `INVOICE_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT 'Invoice No', `AFFILIATE_FLAG` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT 'Y - 관계사, N -비관계사', `SHIP_METHOD` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT 'Shipping Method', `TRANSPORT_TYPE` varchar(5) COLLATE utf8_bin DEFAULT NULL, `ACCOUNT_UNIT` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT 'Accounting Unit Code', `WEIGHT` decimal(19,5) NOT NULL DEFAULT '0.00000' COMMENT 'Weight', `UNIT_CBM` decimal(19,6) NOT NULL DEFAULT '0.000000' COMMENT 'Unit CBM', `CBM_SUM` decimal(19,6) NOT NULL DEFAULT '0.000000' COMMENT 'Order별 Total CBM', `PICK_RELEASE_DATE` datetime DEFAULT NULL COMMENT 'Pick Release Date', `PG_YMD` datetime DEFAULT NULL COMMENT '출하일', `IOD_DATE` datetime DEFAULT NULL COMMENT '매출 확정일', `CURRENCY_CODE` varchar(10) COLLATE utf8_bin DEFAULT NULL, `ORDER_PRICE` decimal(19,6) NOT NULL DEFAULT '0.000000' COMMENT 'Unit Selling Price', `ORDER_TYPE` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT 'Order Type : Regular / Customer Pick Up 등등', `CONTAINER_TYPE` varchar(30) COLLATE utf8_bin DEFAULT NULL COMMENT '20FT, 40FT, 40HC, 45FT, 48FT...', `LCL_FLAG` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT 'Y - LCL, N - FCL', `CONTAINER_NO` varchar(20) COLLATE utf8_bin DEFAULT NULL, `MODEL_CD` varchar(50) COLLATE utf8_bin DEFAULT NULL, `PRODUCT_TYPE` varchar(5) COLLATE utf8_bin DEFAULT NULL, `BILL_TO_CODE` varchar(50) COLLATE utf8_bin DEFAULT NULL COMMENT '거래처코드', `BILL_TO_NAME` varchar(300) COLLATE utf8_bin DEFAULT NULL, `SHIP_TO_CODE` varchar(40) COLLATE utf8_bin DEFAULT NULL COMMENT '인도처코드', `SHIP_TO_NAME` varchar(150) COLLATE utf8_bin DEFAULT NULL, `L_PORT` varchar(5) COLLATE utf8_bin DEFAULT NULL, `D_PORT` varchar(5) COLLATE utf8_bin DEFAULT NULL, `F_DEST` varchar(5) COLLATE utf8_bin DEFAULT NULL COMMENT 'Destination Code', `NATION` varchar(5) COLLATE utf8_bin DEFAULT NULL COMMENT '국가 Code', `TRANSFER_FLAG` varchar(1) COLLATE utf8_bin DEFAULT 'N', `TRANSFER_DATE` datetime DEFAULT NULL, `CREATION_DATE` datetime DEFAULT NULL, `LAST_UPDATE_DATE` datetime DEFAULT NULL, `PRCS_MESSAGE` varchar(200) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE1` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE2` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE3` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE4` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE5` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE6` varchar(150) COLLATE utf8_bin DEFAULT NULL COMMENT 'departure place', `ATTRIBUTE7` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE8` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE9` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE10` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE11` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE12` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE13` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE14` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE15` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE16` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE17` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE18` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE19` varchar(150) COLLATE utf8_bin DEFAULT NULL, `ATTRIBUTE20` varchar(150) COLLATE utf8_bin DEFAULT NULL, `LAST_UPDATE_USER_ID` varchar(50) COLLATE utf8_bin DEFAULT NULL, `PRCS_STATUS` varchar(1) COLLATE utf8_bin DEFAULT 'N', `TRANSFER_MESSAGE` varchar(200) COLLATE utf8_bin DEFAULT NULL, `PRICE_TERMS` varchar(10) COLLATE utf8_bin DEFAULT NULL, `PAYMENT_TERM` varchar(30) COLLATE utf8_bin DEFAULT NULL, `CUSTOMER_PO_NO` varchar(50) COLLATE utf8_bin DEFAULT NULL, `INFO_CHANGE_FLAG` varchar(10) COLLATE utf8_bin DEFAULT NULL COMMENT '변경된 정보여부 판단 Flag. NEW/UPDATE/CANCEL', `ORIGIN_ALLOCATION_NO` varchar(30) COLLATE utf8_bin DEFAULT NULL, `DROP_QTY` double NOT NULL DEFAULT '0' COMMENT '경유지 수', `INTERFACE_ID` double NOT NULL COMMENT 'seq한 번호, ALLOCATION별로 같은 값', `OPTION_NO` double DEFAULT NULL COMMENT 'GERP Order Option No', `SERVICE_FLAG` varchar(1) COLLATE utf8_bin DEFAULT NULL COMMENT 'Service 비용 여부', `loading_type_code` varchar(40) COLLATE utf8_bin DEFAULT NULL, `SOURCE_SYSTEM_CODE` varchar(40) COLLATE utf8_bin DEFAULT NULL, `CONTAINER_tXN_ID` bigint(20) DEFAULT NULL, `LOAD_CONFIRM_DATE` datetime DEFAULT NULL, `RETURN_ORDER_DATE` datetime DEFAULT NULL, `SHUTTLE_QTY` decimal(22,0) NOT NULL DEFAULT '0', `EXPENSE_ID` bigint(20) DEFAULT NULL, `TRANSFER_FLAG1` varchar(1) COLLATE utf8_bin DEFAULT 'B' COMMENT 'GSI로 데이터를 보내기위해 관리하는 컬럼', `COMPANY_CODE` varchar(40) COLLATE utf8_bin DEFAULT NULL, `SEAL_NO` varchar(50) COLLATE utf8_bin DEFAULT NULL, `EDI_INTERFACE_DATE` datetime DEFAULT NULL, `TRANSFER_DATE1` datetime DEFAULT NULL, `ERROR_EDI_INTERFACE_FLAG` varchar(1) COLLATE utf8_bin DEFAULT 'N' COMMENT 'LOADING 시 에러가 발생하면 해당 테이블에 ERROR FLAG 마킹 후 MQ에서는 TRANSFER_FLAG = E 이면서 해당 FLAG가 N 인 건만 EDI로 전송', `ERROR_EDI_INTERFACE_DATE` datetime DEFAULT NULL, `STEP_CODE` varchar(30) COLLATE utf8_bin DEFAULT NULL, `STEP_STATUS_CODE` varchar(30) COLLATE utf8_bin DEFAULT NULL, `EDI_FUNC_ACKNOWLDG_NO` varchar(70) COLLATE utf8_bin DEFAULT NULL, `EDI_FUNC_ACKNOWLDG_DATE` datetime DEFAULT NULL, `EDI_FUNC_ACKNOWLDG_STATUS_CODE` varchar(5) COLLATE utf8_bin DEFAULT NULL, `EDI_ERROR_CODE` varchar(100) COLLATE utf8_bin DEFAULT NULL, `EDI_ERROR_MESSAGE_TEXT` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `EDI_SENDER_ID` varchar(50) COLLATE utf8_bin DEFAULT NULL, `EDI_RECEIVER_ID` varchar(50) COLLATE utf8_bin DEFAULT NULL, `XML_DOCUMENT_NO` varchar(100) COLLATE utf8_bin DEFAULT NULL, `DOCUMENT_SEQ_NO` int(11) DEFAULT NULL, `EDI_ENVELOPE_NO` varchar(50) COLLATE utf8_bin DEFAULT NULL, `EDI_GROUP_NO` varchar(50) COLLATE utf8_bin DEFAULT NULL, `EDI_TRANSACTION_NO` varchar(50) COLLATE utf8_bin DEFAULT NULL, `TRANSACTION_DATE` datetime DEFAULT CURRENT_TIMESTAMP, `D_PLACE_NAME` varchar(150) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`pk_id`), KEY `TB_LI_GERP_SEW_SHIP_N04` (`corp_type`,`ALLOCATION_NO`,`CONTAINER_NO`,`TRANSFER_FLAG`), KEY `TB_LI_GERP_SEW_SHIP_N05` (`corp_type`,`TRANSFER_FLAG`,`PRCS_STATUS`), KEY `TB_LI_GERP_SEW_SHIP_N02` (`corp_type`,`DC_CD`,`CONTAINER_NO`,`TRANSFER_FLAG`), KEY `TB_LI_GERP_SEW_SHIP_N07` (`corp_type`,`DC_CD`,`PRCS_STATUS`,`SERVICE_FLAG`,`PG_YMD`), KEY `TB_LI_GERP_SEW_SHIP_N01` (`corp_type`,`DC_CD`,`ALLOCATION_NO`,`TRANSFER_FLAG`), KEY `TB_LI_GERP_SEW_SHIP_N06` (`corp_type`,`DC_CD`,`CONTAINER_NO`,`PG_YMD`,`INTERFACE_ID`,`TRANSFER_FLAG`), KEY `TB_LI_GERP_SEW_SHIP_N08` (`CONTAINER_NO`,`INTERFACE_ID`), KEY `TB_LI_GERP_SEW_SHIP_N09` (`INTERFACE_ID`,`EDI_SENDER_ID`,`EDI_RECEIVER_ID`,`TRANSACTION_DATE`), KEY `TB_LI_GERP_SEW_SHIP_n10` (`TRANSFER_FLAG1`) ) ENGINE=InnoDB AUTO_INCREMENT=6435152 DEFAULT CHARSET=utf8 COLLATE=utf8_bin 2. SHOW INDEX IN TB_LI_GERP_SEW_SHIP ; "Table" "Non_unique" "Key_name" "Seq_in_index" "Column_name" "Collation" "Cardinality" "Sub_part" "Packed" "Null" "Index_type" "Comment" "Index_comment" "tb_li_gerp_sew_ship" "0" "PRIMARY" "1" "pk_id" "A" "3412125" \N \N "" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N04" "1" "corp_type" "A" "7482" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N04" "2" "ALLOCATION_NO" "A" "3412125" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N04" "3" "CONTAINER_NO" "A" "3412125" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N04" "4" "TRANSFER_FLAG" "A" "1706062" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N05" "1" "corp_type" "A" "56" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N05" "2" "TRANSFER_FLAG" "A" "232" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N05" "3" "PRCS_STATUS" "A" "474" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N02" "1" "corp_type" "A" "9861" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N02" "2" "DC_CD" "A" "18956" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N02" "3" "CONTAINER_NO" "A" "1706062" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N02" "4" "TRANSFER_FLAG" "A" "1706062" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N07" "1" "corp_type" "A" "8682" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N07" "2" "DC_CD" "A" "17958" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N07" "3" "PRCS_STATUS" "A" "20310" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N07" "4" "SERVICE_FLAG" "A" "21872" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N07" "5" "PG_YMD" "A" "200713" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N01" "1" "corp_type" "A" "6638" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N01" "2" "DC_CD" "A" "16644" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N01" "3" "ALLOCATION_NO" "A" "1706062" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N01" "4" "TRANSFER_FLAG" "A" "3412125" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N06" "1" "corp_type" "A" "8363" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N06" "2" "DC_CD" "A" "21733" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N06" "3" "CONTAINER_NO" "A" "1706062" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N06" "4" "PG_YMD" "A" "1706062" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N06" "5" "INTERFACE_ID" "A" "3412125" \N \N "" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N06" "6" "TRANSFER_FLAG" "A" "3412125" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N08" "1" "CONTAINER_NO" "A" "1137375" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N08" "2" "INTERFACE_ID" "A" "3412125" \N \N "" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N09" "1" "INTERFACE_ID" "A" "3412125" \N \N "" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N09" "2" "EDI_SENDER_ID" "A" "3412125" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N09" "3" "EDI_RECEIVER_ID" "A" "1706062" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_N09" "4" "TRANSACTION_DATE" "A" "3412125" \N \N "YES" "BTREE" "" "" "tb_li_gerp_sew_ship" "1" "TB_LI_GERP_SEW_SHIP_n10" "1" "TRANSFER_FLAG1" "A" "6" \N \N "YES" "BTREE" "" "" 3. SHOW TABLE STATUS LIKE 'TB_LI_GERP_SEW_SHIP'; "Name" "Engine" "Version" "Row_format" "Rows" "Avg_row_length" "Data_length" "Max_data_length" "Index_length" "Data_free" "Auto_increment" "Create_time" "Update_time" "Check_time" "Collation" "Checksum" "Create_options" "Comment" "tb_li_gerp_sew_ship" "InnoDB" "10" "Compact" "3412125" "527" "1801453568" "0" "1903755264" "7340032" "6435152" "2016-07-04 19:33:41" \N \N "utf8_bin" \N "" "" 4. SHOW TRIGGERS LIKE 'TB_LI_GERP_SEW_SHIP'; Nothing