ngds/sql/2020_12/AR_ORDER_GOODS_DEC.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost:3306
 Source Schema         : aikang_online

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 24/07/2020 16:10:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for AR_ORDER_GOODS_DEC
-- ----------------------------
DROP TABLE IF EXISTS `AR_ORDER_GOODS_DEC`;
CREATE TABLE `AR_ORDER_GOODS_DEC` (
  `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',
  `P_CALC_MONTH` date NOT NULL,
  `POINT` smallint(5) unsigned NOT NULL DEFAULT '0',
  `PERIOD_NUM` int(10) NOT NULL DEFAULT '0',
  `ORDER_DAY` date NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `ORDER_SN` (`ORDER_SN`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='报单订单中包含的商品';

SET FOREIGN_KEY_CHECKS = 1;