ngds/sql/2021_01/jxStandard/AR_ORDER_STANDARD_GOODS.sql

-- ----------------------------
-- Table structure for AR_ORDER_STANDARD_GOODS
-- ----------------------------
DROP TABLE IF EXISTS `AR_ORDER_STANDARD_GOODS`;
CREATE TABLE `AR_ORDER_STANDARD_GOODS` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `ORDER_SN` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `GOODS_TITLE` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `PRICE` decimal(16,2) NOT NULL DEFAULT '0.00',
  `REAL_PRICE` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV` decimal(16,2) NOT NULL DEFAULT '0.00',
  `REAL_PV` decimal(16,2) NOT NULL DEFAULT '0.00',
  `SKU_CODE` varchar(16) COLLATE utf8mb4_bin NOT NULL,
  `BUY_NUMS` int(10) NOT NULL DEFAULT '0',
  `POINT` smallint(5) unsigned NOT NULL DEFAULT '0',
  `PERIOD_NUM` int(10) unsigned NOT NULL DEFAULT '0',
  `CALC_MONTH` int(10) unsigned NOT NULL COMMENT '结算月',
  `PAY_TYPE` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT 'cahs',
  PRIMARY KEY (`ID`),
  KEY `ORDER_SN` (`ORDER_SN`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='达标订单中包含的商品';