ngds/sql/2021_01/jxStandard/AR_ORDER_STANDARD.sql

-- ----------------------------
-- Table structure for AR_ORDER_STANDARD
-- ----------------------------
DROP TABLE IF EXISTS `AR_ORDER_STANDARD`;
CREATE TABLE `AR_ORDER_STANDARD` (
  `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',
  `CALC_MONTH` int(10) unsigned NOT NULL COMMENT '结算月',
  `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 '',
  `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 `CALC_MONTH` (`CALC_MONTH`),
  KEY `IS_DELETE` (`IS_DELETE`),
  KEY `ORDER_TYPE` (`ORDER_TYPE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='达标商品订单';