guomao/DOC/DB/00_table/ap_contract_plan_inf.sql

CREATE TABLE ap_contract_plan_inf (
  ACP_ID           		VARCHAR(20) NOT NULL 			COMMENT '编号',
  ACP_CONTRACT_ID       VARCHAR(20)                    COMMENT '合同编号',
  ACP_REGION        	VARCHAR(2)                    	COMMENT '区域00华东01华北02华南03华中',
  ACP_NUMS        		VARCHAR(20)                    	COMMENT '计划量',
  ACP_MONTH          	VARCHAR(10)                    	COMMENT '月份',
  ACP_CONTRAC_MONTH     VARCHAR(20)                    	COMMENT '合同月',
  PRIMARY KEY (ACP_ID)
) ENGINE=INNODB DEFAULT CHARSET=UTF8 COMMENT='合同计划信息表';