ngds/sql/2020_07/AR_ORDER_SHOP.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:32:58
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for AR_ORDER_SHOP
-- ----------------------------
DROP TABLE IF EXISTS `AR_ORDER_SHOP`;
CREATE TABLE `AR_ORDER_SHOP` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `SN` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `DEC_SN` varchar(32) COLLATE utf8mb4_bin DEFAULT '',
  `USER_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `USER_NAME` varchar(16) COLLATE utf8mb4_bin NOT NULL,
  `ORDER_TYPE` varchar(12) COLLATE utf8mb4_bin NOT NULL,
  `ORDER_AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PAY_AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PAY_PV` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PAY_AT` int(10) NOT NULL DEFAULT '0',
  `FREIGHT` float(10,2) NOT NULL DEFAULT '0.00',
  `PAY_FREIGHT` float(10,2) NOT NULL DEFAULT '0.00',
  `DELIVERY_STATUS` tinyint(2) NOT NULL DEFAULT '0',
  `DELIVERY_PERIOD` int(10) NOT NULL DEFAULT '0',
  `DELIVERY_AT` int(10) NOT NULL DEFAULT '0',
  `EXPRESS_COMPANY` varchar(128) COLLATE utf8mb4_bin DEFAULT '',
  `ORDER_TRACK_NO` varchar(32) COLLATE utf8mb4_bin DEFAULT '',
  `EXPRESS_TYPE` tinyint(1) NOT NULL DEFAULT '0',
  `FRONT_REMARK` varchar(1000) COLLATE utf8mb4_bin DEFAULT '',
  `REMARK` text COLLATE utf8mb4_bin,
  `PERIOD_NUM` int(10) NOT NULL DEFAULT '0',
  `STATUS` int(3) NOT NULL DEFAULT '0',
  `CONSIGNEE` varchar(120) COLLATE utf8mb4_bin DEFAULT '',
  `MOBILE` varchar(11) COLLATE utf8mb4_bin DEFAULT '',
  `TEL` varchar(16) COLLATE utf8mb4_bin DEFAULT '',
  `PROVINCE` varchar(32) COLLATE utf8mb4_bin DEFAULT '0',
  `CITY` varchar(32) COLLATE utf8mb4_bin DEFAULT '0',
  `COUNTY` varchar(32) COLLATE utf8mb4_bin DEFAULT '0',
  `ADDRESS` varchar(255) COLLATE utf8mb4_bin DEFAULT '',
  `P_CALC_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL DEFAULT '0',
  `CREATE_USER` varchar(16) COLLATE utf8mb4_bin NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `UPDATER` varchar(16) COLLATE utf8mb4_bin DEFAULT '',
  `IS_DELETE` int(10) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  `PAY_TYPE` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT 'cash',
  `WAREHOUSE` varchar(16) COLLATE utf8mb4_bin NOT NULL DEFAULT '01',
  PRIMARY KEY (`ID`),
  KEY `SN` (`SN`),
  KEY `USER_ID` (`USER_ID`),
  KEY `USER_NAME` (`USER_NAME`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`),
  KEY `IS_DELETE` (`IS_DELETE`),
  KEY `ORDER_TYPE` (`ORDER_TYPE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='商品订单';

SET FOREIGN_KEY_CHECKS = 1;