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

CREATE TABLE ap_order_detail (
  AOD_ID 				varchar(20) 	NOT NULL 		COMMENT '详情编号',
  AOD_ORDER_ID 			varchar(20) 			 		COMMENT '所属订单ID·',
--  #AOD_PRODUCT_ID 		varchar(20) 			 		COMMENT '商品ID',  删除
  AOD_STANDARD_ID 		varchar(20) 			 		COMMENT '规格ID',
  AOD_WEIGHT 			varchar(20) 		 			COMMENT '重量',
  AOD_PRICE 			varchar(15) 		 			COMMENT '原币单价',
  AOD_AMOUNT 			varchar(15) 		 			COMMENT '原币总金额',
  AOD_CREATE_USER 		varchar(20)  					COMMENT '创建人',
  AOD_CREATE_TIME 		varchar(14)  					COMMENT '创建时间',
  AOD_MODIFY_USER 		varchar(20)  					COMMENT '最后修改人',
  AOD_MODIFY_TIME 		varchar(14)  					COMMENT '最后修改时间',
  AOD_STATE 			varchar(2) 		DEFAULT '00'	COMMENT '状态：00执行中01关闭02取消',
  AOD_HUODAI 			varchar(20) 					COMMENT '货代公司id',
  AOD_LOCAL_PRICE 		varchar(15) 		 			COMMENT '本币单价',
  AOD_LOCAL_AMOUNT 		varchar(15) 		 			COMMENT '本币总金额',
  AOD_DELIVERY 			varchar(20) 		 			COMMENT '交货地',
  AOD_WARE_ID 			varchar(20) 		 			COMMENT '出货仓库',
  AOD_REMARK 			varchar(50) 		 			COMMENT '备注',
  AOD_CONTRACT_DETAIL_ID varchar(20) 		 			COMMENT '合同明细编号',
  PRIMARY KEY (AOD_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单详情表';