数据表代码

/*
 Navicat Premium Data Transfer

 Source Server         : phonesy
 Source Server Type    : MySQL
 Source Server Version : 50714
 Source Host           : localhost:3306
 Source Schema         : phonesy

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

 Date: 17/04/2023 09:34:20
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for 供货商表
-- ----------------------------
DROP TABLE IF EXISTS `供货商表`;
CREATE TABLE `供货商表`  (
  `供货商ID` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `供货商名称` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `厂家地址` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `账户` char(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `联系人` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`供货商ID`) USING BTREE,
  UNIQUE INDEX `供货商名称`(`供货商名称`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of 供货商表
-- ----------------------------
INSERT INTO `供货商表` VALUES ('1', '北京三星有限公司', '北京西城区德外大街８号', '６２０３５０００２１５４２２５', '陈友谅');
INSERT INTO `供货商表` VALUES ('10', '北京苹果有限公司', '北京西郊百万庄２０８号', '６２０３２５５５２４１２５４５', '李东平');
INSERT INTO `供货商表` VALUES ('11', '北京魅族有限公司', '北京朝阳区惠新里８号', '６２０３２６５４２２５８９６６', '王辉');
INSERT INTO `供货商表` VALUES ('12', '北京联想科技有限公司', '北京东四十二条３３号', '６２０３２１２３５６５８９６６', '刘芳芳');
INSERT INTO `供货商表` VALUES ('13', '北京华为信息技术有限公司', '北京三里河路１４号', '６２０３２６８９３２５８９６６', '张国良');
INSERT INTO `供货商表` VALUES ('14', '北京金立科技', '北京朝阳区平乐园８８号', '６２０３２７５２１４５８９６６', '刘彻');
INSERT INTO `供货商表` VALUES ('15', '北京锤子科技', '北京沙滩嵩祝北巷４４号', '６２０３２６５４２２６８５５２', '毛青青');

-- ----------------------------
-- Table structure for 员工表
-- ----------------------------
DROP TABLE IF EXISTS `员工表`;
CREATE TABLE `员工表`  (
  `员工ID` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `姓名` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `性别` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `出生日期` date NOT NULL,
  `部门` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `工作时间` date NOT NULL,
  `个人简历` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`员工ID`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of 员工表
-- ----------------------------
INSERT INTO `员工表` VALUES ('101001', '刘海', '男', '1980-03-06', '办公室', '2004-12-10', '2004年7月毕业于南昌大学');
INSERT INTO `员工表` VALUES ('101002', '孙淑萍', '女', '1983-04-18', '销售部', '2004-11-03', '2003年7月毕业于江苏师范大学');
INSERT INTO `员工表` VALUES ('101003', '王忠', '男', '1982-11-12', '办公室', '2004-09-06', '2002年7月毕业于清华大学');
INSERT INTO `员工表` VALUES ('101004', '蔡远方', '女', '1979-06-06', '销售部', '2004-01-10', NULL);
INSERT INTO `员工表` VALUES ('101005', '钟飞虎', '男', '1986-08-16', '销售部', '2006-07-03', NULL);
INSERT INTO `员工表` VALUES ('101006', '刘菲菲', '女', '1987-03-22', '后勤部', '2007-06-05', NULL);
INSERT INTO `员工表` VALUES ('101007', '陈大海', '男', '1989-03-17', '办公室', '2009-12-15', NULL);
INSERT INTO `员工表` VALUES ('101008', '陈舒', '女', '1991-03-06', '办公室', '2009-12-29', NULL);
INSERT INTO `员工表` VALUES ('101009', '李冬梅', '女', '1990-06-06', '后勤部', '2008-11-10', NULL);
INSERT INTO `员工表` VALUES ('101010', '王圆圆', '女', '1991-03-23', '办公室', '2011-12-07', NULL);
INSERT INTO `员工表` VALUES ('101011', '马飞', '男', '1993-03-18', '销售部', '2011-12-26', NULL);
INSERT INTO `员工表` VALUES ('101012', '刘飞', '男', '1993-03-08', '销售部', '2013-12-02', NULL);
INSERT INTO `员工表` VALUES ('101013', '郭琳琳', '女', '1990-03-16', '销售部', '2013-12-19', NULL);

-- ----------------------------
-- Table structure for 商品一览表
-- ----------------------------
DROP TABLE IF EXISTS `商品一览表`;
CREATE TABLE `商品一览表`  (
  `货号` char(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `货名` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `规格` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `单位` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `平均进价` decimal(8, 2) NOT NULL,
  `参考价格` decimal(8, 2) NOT NULL,
  `库存量` tinyint(4) NULL DEFAULT NULL,
  PRIMARY KEY (`货号`) USING BTREE,
  UNIQUE INDEX `货名`(`货名`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of 商品一览表
-- ----------------------------
INSERT INTO `商品一览表` VALUES ('1001', 'Apple iPhone 8', 'AD', '部', 4300.00, 5200.00, 26);
INSERT INTO `商品一览表` VALUES ('1002', 'Apple iPhone 7 p', 'AE', '部', 5300.00, 6200.00, 25);
INSERT INTO `商品一览表` VALUES ('1003', 'Apple iPhone X', 'AF', '部', 6300.00, 7200.00, 25);
INSERT INTO `商品一览表` VALUES ('1004', '华为P20', 'HB', '部', 3800.00, 4600.00, 25);
INSERT INTO `商品一览表` VALUES ('1005', '华为Mate 20', 'HC', '部', 4200.00, 4800.00, 25);

-- ----------------------------
-- Table structure for 进货表
-- ----------------------------
DROP TABLE IF EXISTS `进货表`;
CREATE TABLE `进货表`  (
  `序号` tinyint(4) UNSIGNED NOT NULL AUTO_INCREMENT,
  `进货日期` date NULL DEFAULT NULL,
  `货号` char(4) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `数量` int(4) NULL DEFAULT NULL,
  `进价` decimal(8, 2) NULL DEFAULT NULL,
  `供货商ID` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `收货人ID` char(6) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  PRIMARY KEY (`序号`) USING BTREE,
  INDEX `货号`(`货号`) USING BTREE,
  INDEX `供货商ID`(`供货商ID`) USING BTREE,
  INDEX `收货人ID`(`收货人ID`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of 进货表
-- ----------------------------
INSERT INTO `进货表` VALUES (1, '2018-06-13', '1001', 10, 4300.00, '10', '101011');
INSERT INTO `进货表` VALUES (2, '2018-06-13', '1002', 20, 5300.00, '10', '101011');
INSERT INTO `进货表` VALUES (3, '2018-06-14', '1003', 15, 6300.00, '10', '101011');
INSERT INTO `进货表` VALUES (4, '2018-06-14', '1004', 20, 3800.00, '13', '101005');
INSERT INTO `进货表` VALUES (5, '2018-06-14', '1005', 20, 4200.00, '13', '101005');

-- ----------------------------
-- Table structure for 销售表
-- ----------------------------
DROP TABLE IF EXISTS `销售表`;
CREATE TABLE `销售表`  (
  `序号` tinyint(4) UNSIGNED NOT NULL AUTO_INCREMENT,
  `销售日期` date NULL DEFAULT NULL,
  `客户名称` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `货号` char(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `单价` decimal(8, 2) NULL DEFAULT NULL,
  `数量` int(4) NULL DEFAULT NULL,
  `销售员ID` char(6) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`序号`) USING BTREE,
  INDEX `货号`(`货号`) USING BTREE,
  INDEX `销售员ID`(`销售员ID`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of 销售表
-- ----------------------------
INSERT INTO `销售表` VALUES (1, '2018-06-22', '张大大', '1001', 5200.00, 1, '101002');
INSERT INTO `销售表` VALUES (2, '2018-06-23', '刘晓', '1003', 7200.00, 1, '101013');
INSERT INTO `销售表` VALUES (3, '2018-07-22', '袁大头', '1003', 7200.00, 1, '101004');
INSERT INTO `销售表` VALUES (4, '2018-08-12', '郑舒淇', '1004', 3800.00, 1, '101004');
INSERT INTO `销售表` VALUES (5, '2018-08-22', '刘君', '1005', 4600.00, 1, '101012');

SET FOREIGN_KEY_CHECKS = 1;