programs_info/宜兴紫砂拍卖系统/数据库备份/宜兴数据库结构2023年5月12日.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 01_47.113.200.81
 Source Server Type    : MySQL
 Source Server Version : 50716
 Source Host           : 47.113.200.81:3306
 Source Schema         : yixing_auction

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

 Date: 19/04/2023 08:57:56
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for auction_booth
-- ----------------------------
DROP TABLE IF EXISTS `auction_booth`;
CREATE TABLE `auction_booth`  (
  `number` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号(KW001)',
  `boothname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '展位名称',
  `boothaddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '位置说明',
  `boothsize` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '尺寸(cm)',
  `boothvolume` int(11) NULL DEFAULT NULL COMMENT '展格数',
  `createdat` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `updatedat` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `status` int(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '行状态默认0正常,2是删除',
  `createid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人id',
  `updateid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `islocking` int(4) NULL DEFAULT 0 COMMENT '是否锁定展位,0未锁定/解除待拍卖状态,1.锁定原因已经选为待拍卖,2中标展位,要小心处理',
  PRIMARY KEY (`number`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '展位管理数据' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for auction_booth_product
-- ----------------------------
DROP TABLE IF EXISTS `auction_booth_product`;
CREATE TABLE `auction_booth_product`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `boothnum` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '展位编号(KW001)',
  `productid` bigint(20) NOT NULL COMMENT '藏品表id',
  `productnum` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品编号',
  `productname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品名称',
  `productbrand` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品品牌',
  `productsize` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品尺寸(cm)',
  `productspecifications` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品规格',
  `productunit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品单位',
  `productprice` double NULL DEFAULT NULL COMMENT '参考单价(元)',
  `inoutnum` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '入库单编号(RK22121500001)',
  `personwinnumber` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中标订单号',
  `incount` int(11) NOT NULL COMMENT '入库数量',
  `createdat` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `status` int(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '行状态默认0正常',
  `createid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '展位和藏品关系管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for auction_current_quan (潘毅建的表)
-- ----------------------------
DROP TABLE IF EXISTS `auction_current_quan`;
CREATE TABLE `auction_current_quan`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型 1-入库  2-出库',
  `current_date_no` date NULL DEFAULT NULL COMMENT '当前时间',
  `quan` int(11) NULL DEFAULT NULL COMMENT '当天的数据',
  `created_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  `updated_by` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `updated_at` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 31 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for auction_father_inout_log
-- ----------------------------
DROP TABLE IF EXISTS `auction_father_inout_log`;
CREATE TABLE `auction_father_inout_log`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fathernum` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出入库母单编号(RK2303020001)(母单编号)',
  `supplierid` int(11) NOT NULL COMMENT '供应商id',
  `createdat` datetime NOT NULL COMMENT '创建时间',
  `status` int(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '行状态默认0正常,1删除,2第一次新建,还没有子单信息',
  `createid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '创建人id(操作人的意思)',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '入库说明',
  `backtoperson` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退货的收货人(也可以是入货人)',
  `remark2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `fathernum`(`fathernum`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 175 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '出入库台账(母单)' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for auction_inout_log
-- ----------------------------
DROP TABLE IF EXISTS `auction_inout_log`;
CREATE TABLE `auction_inout_log`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fathernum` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出入库母单编号(RK2303020001)(母单编号)',
  `number` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '出入库单编号(RK2303020001KW002)(子单编号)',
  `personwinnumber` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中标订单号',
  `supplierid` int(11) NOT NULL COMMENT '供应商id',
  `productid` bigint(20) NOT NULL COMMENT '藏品表id',
  `productnum` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品编号',
  `productname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品名称',
  `productbrand` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品品牌',
  `productsize` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品尺寸(cm)',
  `productspecifications` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品规格',
  `productunit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品单位',
  `inouttype` int(4) NOT NULL COMMENT '进出库类型新品入库1,移库入库2,盘点调整入库3,提货出库-1,入库单退货-2,移库出库-3,盘点调整出库-4,其他出库-5',
  `inoutcount` int(11) NULL DEFAULT NULL COMMENT '进出库数量',
  `outprocess` int(1) NULL DEFAULT NULL COMMENT '出库过程(1单个出库/2整架出库)',
  `boothnum` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '展位编号',
  `createdat` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `status` int(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '行状态默认0正常',
  `createid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人id(操作人的意思)',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原因说明',
  `relationnumber` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联单号',
  `backtoperson` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退货的收货人',
  `remark2` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注2,每个入库藏品的唯一标识(相同的藏品编号也有不同的入库标识),用来串联该藏品所有的流转记录了',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `number`(`number`) USING BTREE,
  INDEX `createdat`(`createdat`) USING BTREE,
  INDEX `remark2`(`remark2`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 102 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '出入库台账(子单)' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for auction_operation
-- ----------------------------
DROP TABLE IF EXISTS `auction_operation`;
CREATE TABLE `auction_operation`  (
  `number` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '拍卖场次(20221111-04)',
  `addressdetail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '拍卖详细地址(20221115-001)',
  `starttime` datetime NOT NULL COMMENT '开始时间',
  `endtime` datetime NULL DEFAULT NULL COMMENT '结束时间',
  `hostname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主持人名称',
  `biddinground` int(4) NULL DEFAULT NULL COMMENT '竞拍轮次',
  `winround` int(4) NULL DEFAULT NULL COMMENT '中标轮次',
  `status` int(4) NULL DEFAULT 0 COMMENT '拍卖状态默认0是待开始或者进行中,1为结束拍卖,2删除',
  `createid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人id',
  `createdat` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `deposits` double NULL DEFAULT NULL COMMENT '保证金(元)',
  `updatedat` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `updateid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  PRIMARY KEY (`number`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '竞拍场次管理' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for auction_operation_round
-- ----------------------------
DROP TABLE IF EXISTS `auction_operation_round`;
CREATE TABLE `auction_operation_round`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '竞拍轮次主键',
  `operationnum` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '拍卖场次编号',
  `biddingroundid` int(4) NULL DEFAULT NULL COMMENT '竞拍轮次(后期要用,又启用了)',
  `biddingcount` int(4) NULL DEFAULT NULL COMMENT '标的数量',
  `result` int(4) NULL DEFAULT NULL COMMENT '拍卖结果null没有结果,1中标,2流拍,3中标后违约',
  `unsoldreason` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流拍原因',
  `winername` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中标人姓名',
  `winercard` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '中标人身份证号',
  `winerid` bigint(20) NULL DEFAULT NULL COMMENT '中标人id',
  `winamount` double(12, 2) NULL DEFAULT NULL COMMENT '中标金额(元)',
  `commissionrate` double(8, 6) NULL DEFAULT NULL COMMENT '设置佣金比例',
  `commission` double(12, 2) NULL DEFAULT NULL COMMENT '佣金',
  `personwinnumber` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参拍人中标后订单编号',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `createdat` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `updatedat` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `status` int(4) NOT NULL DEFAULT 0 COMMENT '状态默认0正常',
  `createid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人id',
  `updateid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `boothnumber` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '展位编号(KW001)',
  `startingprice` double(10, 2) NULL DEFAULT NULL COMMENT '起拍价格,单位元',
  `pictureaddress` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '群像照片地址',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `personwinnumber`(`personwinnumber`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '竞拍场拍卖轮次管理表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for auction_operation_round_product
-- ----------------------------
DROP TABLE IF EXISTS `auction_operation_round_product`;
CREATE TABLE `auction_operation_round_product`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `auction_operation_roundid` bigint(20) NOT NULL COMMENT '竞拍轮次id(发现没有意义,不做处理)',
  `operationnum` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '竞拍场次编号',
  `biddingroundid` int(4) NOT NULL COMMENT '竞拍轮次',
  `productid` bigint(20) NOT NULL COMMENT '藏品表id',
  `productnum` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品编号',
  `productname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品名称',
  `productbrand` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品品牌',
  `productsize` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品尺寸(cm)',
  `productspecifications` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品规格',
  `productunit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品单位',
  `productprice` double NULL DEFAULT NULL COMMENT '参考单价(元)',
  `inoutnum` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '入库单编号(RK22121500001)',
  `incount` int(11) NOT NULL COMMENT '入库数量',
  `createdat` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `status` int(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '状态默认0正常',
  `createid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 119 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '竞拍场拍卖轮次藏品管理表(藏品数据从auction_booth_product表中获取)' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for auction_person
-- ----------------------------
DROP TABLE IF EXISTS `auction_person`;
CREATE TABLE `auction_person` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `personname` varchar(128) DEFAULT NULL COMMENT '姓名/公司名称',
  `personcard` varchar(128) DEFAULT NULL COMMENT '身份证号/信用代码',
  `personphone` varchar(64) DEFAULT NULL COMMENT '手机号/联系电话',
  `contacts` varchar(128) DEFAULT NULL COMMENT '公司联系人姓名',
  `createdat` datetime DEFAULT NULL COMMENT '创建时间',
  `updatedat` datetime DEFAULT NULL COMMENT '修改时间',
  `status` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '行状态默认0正常',
  `createid` varchar(50) DEFAULT NULL COMMENT '创建人id',
  `updateid` varchar(50) DEFAULT NULL COMMENT '修改人id',
  `iscompany` varchar(2) DEFAULT NULL COMMENT '0不是公司1是公司',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='参拍人员信息表';




-- ----------------------------
-- Table structure for auction_person_join_log
-- ----------------------------
DROP TABLE IF EXISTS `auction_person_join_log`;
CREATE TABLE `auction_person_join_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `persionid` bigint(20) DEFAULT NULL COMMENT '参拍人员id',
  `personname` varchar(64) DEFAULT NULL COMMENT '参拍人姓名',
  `personcard` varchar(255) DEFAULT NULL COMMENT '参拍人身份证号码',
  `personphone` varchar(64) DEFAULT NULL COMMENT '手机号',
  `operationnum` varchar(16) DEFAULT NULL COMMENT '拍卖场次编号',
  `deposits` double DEFAULT NULL COMMENT '保证金(元)',
  `joinpictureaddress` text COMMENT '上传凭证照片地址',
  `depositstype` int(4) DEFAULT NULL COMMENT '保证金支付方式1线上支付,2现金,3刷卡',
  `depositsnum` varchar(128) DEFAULT NULL COMMENT '保证金支付流水号(微信为订单号p123456)',
  `depositscardnum` varchar(128) DEFAULT NULL COMMENT '保证金支付账号',
  `depositsmoney` double DEFAULT NULL COMMENT '保证金支付金额(元)',
  `depositsdat` datetime DEFAULT NULL COMMENT '保证金支付时',
  `createdat` datetime DEFAULT NULL COMMENT '创建时间',
  `personwinlogcount` int(4) DEFAULT NULL COMMENT '中标次数',
  `ispay` int(2) DEFAULT NULL COMMENT '中标支付数量:状态:0未支付1已支付1次中标金额,2支付两次中标金额(可以关联中标支付表,不一定要用)',
  `isreturndeposits` int(2) DEFAULT NULL COMMENT '保证金状态:0滞压保证金1已经退还保证金,2待退保证金,3罚没保证金',
  `starttimereturndeposits` datetime DEFAULT NULL COMMENT '开始退还保证金的时间',
  `isreturndepositstype` int(2) DEFAULT NULL COMMENT '保证金退还最终状态:1罚没,2退款',
  `usedepositsmoney` double DEFAULT NULL COMMENT '退款或罚没的金额',
  `usetime` datetime DEFAULT NULL COMMENT '退款或罚没的执行时间',
  `usepassername` varchar(255) DEFAULT NULL COMMENT '退款或罚没经手人姓名',
  `iscompany` varchar(2) DEFAULT NULL COMMENT '0不是公司1是公司',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注(滞压,罚没的说明)',
  `updatedat` datetime DEFAULT NULL COMMENT '修改时间',
  `status` int(4) NOT NULL DEFAULT '0' COMMENT '状态默认0正常',
  `createid` varchar(50) DEFAULT NULL COMMENT '创建人id',
  `updateid` varchar(50) DEFAULT NULL COMMENT '修改人id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `isreturndeposits` (`isreturndeposits`),
  KEY `starttimereturndeposits` (`starttimereturndeposits`),
  KEY `personcard` (`personcard`),
  KEY `operationnum` (`operationnum`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COMMENT='参拍人员参拍记录表';

-- ----------------------------
-- Table structure for auction_person_join_picture
-- ----------------------------
DROP TABLE IF EXISTS `auction_person_join_picture`;
CREATE TABLE `auction_person_join_picture` (
  `id` varchar(255) NOT NULL,
  `personjoinid` bigint(20) DEFAULT NULL COMMENT '参拍人员参拍记录表id',
  `file_name` varchar(255) DEFAULT NULL COMMENT '文件名',
  `file_path` varchar(255) DEFAULT NULL COMMENT '文件路径',
  `file_type` varchar(255) DEFAULT NULL COMMENT '文件类型',
  `file_content_type` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `status` int(2) DEFAULT '0' COMMENT '0正常,2删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='参拍人员参拍记录一对多数据(用户进行退款/罚没时的保存图片)';

-- ----------------------------
-- Table structure for auction_person_win_log
-- ----------------------------
DROP TABLE IF EXISTS `auction_person_win_log`;
CREATE TABLE `auction_person_win_log` (
  `number` varchar(32) NOT NULL COMMENT '订单编号',
  `personjoinid` bigint(20) NOT NULL COMMENT '参拍记录表id',
  `operationroundid` bigint(20) NOT NULL COMMENT '竞拍场拍卖轮次id',
  `operationnum` varchar(16) DEFAULT NULL COMMENT '拍卖场次编号',
  `starttime` datetime DEFAULT NULL COMMENT '开始时间(因为结束时间是和拍卖场次相关,所以到对应表找)',
  `endtime` datetime DEFAULT NULL COMMENT '结束时间(因为结束时间是和拍卖场次相关,所以到对应表找)',
  `personname` varchar(64) DEFAULT NULL COMMENT '参拍人姓名',
  `personcard` varchar(64) DEFAULT NULL COMMENT '参拍人身份证号码',
  `personphone` varchar(64) DEFAULT NULL COMMENT '参拍人手机号',
  `winamount` double(12,2) DEFAULT NULL COMMENT '中标金额(元)',
  `commission` double(12,2) DEFAULT NULL COMMENT '佣金',
  `ispay` int(2) DEFAULT NULL COMMENT '0未支付1已支付中标金额',
  `paytime` datetime DEFAULT NULL COMMENT '支付时间',
  `paynumber` varchar(255) DEFAULT NULL COMMENT '支付流水号',
  `paytype` int(2) DEFAULT NULL COMMENT '支付方式1线上支付,2现金,3刷卡',
  `paycardnum` varchar(128) DEFAULT NULL COMMENT '金支付账号',
  `paymoney` double DEFAULT NULL COMMENT '支付金额(元)',
  `winpictureaddress` text COMMENT '上传凭证照片地址',
  `taketype` int(2) DEFAULT NULL COMMENT '提货状态1待提货,2已提货,3部分提货',
  `createdat` datetime DEFAULT NULL COMMENT '创建时间',
  `updatedat` datetime DEFAULT NULL COMMENT '修改时间',
  `status` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '状态默认0正常',
  `createid` varchar(50) DEFAULT NULL COMMENT '创建人id',
  `updateid` varchar(50) DEFAULT NULL COMMENT '修改人id',
  PRIMARY KEY (`number`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='参拍人员中标支付记录表';

-- ----------------------------
-- Table structure for auction_product
-- ----------------------------
DROP TABLE IF EXISTS `auction_product`;
CREATE TABLE `auction_product`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `number` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '编号(cp22121500001)',
  `supplierid` int(11) NOT NULL COMMENT '供应商编号',
  `productname` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '藏品名称',
  `productbrand` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品品牌',
  `productsize` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品尺寸(cm)',
  `productspecifications` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品规格',
  `productinfo` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '藏品简介',
  `productprice` double NULL DEFAULT NULL COMMENT '参考单价(元)',
  `productunit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品单位',
  `producturl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '藏品图片',
  `createdat` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `updatedat` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `status` int(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '行状态默认0正常,1只保存,不发布,2删除',
  `createid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人id',
  `updateid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `number`(`number`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '藏品管理数据' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for auction_product_picture
-- ----------------------------
DROP TABLE IF EXISTS `auction_product_picture`;
CREATE TABLE `auction_product_picture`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `productid` bigint(20) NULL DEFAULT NULL COMMENT '藏品管理id',
  `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名',
  `file_path` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件路径',
  `file_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件类型',
  `file_content_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `created_at` datetime NULL DEFAULT NULL,
  `status` int(2) NULL DEFAULT 0 COMMENT '0正常,2删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '产品一对多数据' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for auction_supplier
-- ----------------------------
DROP TABLE IF EXISTS `auction_supplier`;
CREATE TABLE `auction_supplier`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '供应商名称',
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商联系电话',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商地址',
  `createdat` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `updatedat` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `status` int(4) UNSIGNED NOT NULL DEFAULT 0 COMMENT '行状态默认0正常',
  `createid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人id',
  `updateid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人id',
  `havediscount` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否有优惠有,否',
  `contacts` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '供应商数据' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;