-- ============================================================
-- 关务对接表 - Oracle主键序列
-- 命名规则：表名_SEQ
-- MyBatis-Plus通过@KeySequence注解自动从序列取nextval作为主键
-- ============================================================

-- WO101账册备案
CREATE SEQUENCE GW_EMS_HEAD_SEQ    START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
CREATE SEQUENCE GW_EMS_LIST_SEQ    START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;

-- WO102出入库确认
CREATE SEQUENCE GW_CONFIRM_HEAD_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
CREATE SEQUENCE GW_CONFIRM_LIST_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;

-- WO103工单
CREATE SEQUENCE GW_WO_HEAD_SEQ     START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
CREATE SEQUENCE GW_WO_EXG_LIST_SEQ  START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
CREATE SEQUENCE GW_WO_IMG_LIST_SEQ  START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;

-- WO105实盘库存
CREATE SEQUENCE GW_WH_HEAD_SEQ     START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
CREATE SEQUENCE GW_WH_LIST_SEQ     START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;

-- WO106核销结案
CREATE SEQUENCE GW_DCR_HEAD_SEQ    START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
CREATE SEQUENCE GW_DCR_INVT_LIST_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
CREATE SEQUENCE GW_DCR_WO_LIST_SEQ  START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
CREATE SEQUENCE GW_DCR_STOCK_LIST_SEQ START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;

-- MQ日志 & 回执
CREATE SEQUENCE GW_MQ_LOG_SEQ      START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;
CREATE SEQUENCE GW_RESPONSE_SEQ    START WITH 1 INCREMENT BY 1 NOCACHE NOCYCLE;

COMMIT;

-- 验证：查询所有序列
SELECT SEQUENCE_NAME FROM USER_SEQUENCES WHERE SEQUENCE_NAME LIKE 'GW_%' ORDER BY SEQUENCE_NAME;