超市管理项目-1.相关资料

• 数据库脚本文件

• /*
   Navicat Premium Data Transfer
  
   Source Server         : root
   Source Server Type    : MySQL
   Source Server Version : 50529
   Source Host           : localhost:3306
   Source Schema         : supermaket
  
   Target Server Type    : MySQL
   Target Server Version : 50529
   File Encoding         : 65001
  
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for clock_info
  -- ----------------------------
  DROP TABLE IF EXISTS `clock_info`;
  CREATE TABLE `clock_info`  (
    `clock_id` int(11) NOT NULL AUTO_INCREMENT,
    `employee_no` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
    `clock_in_time` datetime NULL DEFAULT NULL,
    `clock_off_time` datetime NULL DEFAULT NULL,
    `clock_date` date NULL DEFAULT NULL,
    PRIMARY KEY (`clock_id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
  
  -- ----------------------------
  -- Records of clock_info
  -- ----------------------------
  INSERT INTO `clock_info` VALUES (1, 'S0002', '2021-04-01 11:30:52', '2021-04-01 18:30:30', '2021-04-01');
  INSERT INTO `clock_info` VALUES (2, 's0004', '2021-04-02 09:46:52', '2021-04-02 17:30:30', '2021-04-02');
  INSERT INTO `clock_info` VALUES (3, 's0005', '2021-04-03 08:46:52', '2021-04-03 17:30:30', '2021-04-03');
  INSERT INTO `clock_info` VALUES (4, 's0003', '2021-04-04 09:13:52', '2021-04-04 18:30:30', '2021-04-04');
  INSERT INTO `clock_info` VALUES (5, 's0004', '2021-04-05 09:46:52', '2021-04-05 18:30:30', '2021-04-05');
  INSERT INTO `clock_info` VALUES (6, 's0005', NULL, '2021-04-06 18:30:30', '2021-04-06');
  INSERT INTO `clock_info` VALUES (7, 'S0005', '2021-04-01 08:46:52', '2021-04-01 18:30:30', '2021-04-01');
  INSERT INTO `clock_info` VALUES (8, 'S0002', '2021-04-02 09:46:52', '2021-04-02 17:30:30', '2021-04-02');
  INSERT INTO `clock_info` VALUES (9, 'S0006', '2021-04-03 08:46:52', '2021-04-03 17:30:30', '2021-04-03');
  INSERT INTO `clock_info` VALUES (10, 'S0003', '2021-04-01 09:46:52', '2021-04-01 18:30:30', '2021-04-01');
  INSERT INTO `clock_info` VALUES (11, 'S0004', '2021-04-02 09:46:52', '2021-04-02 17:30:30', '2021-04-02');
  INSERT INTO `clock_info` VALUES (12, 'S0003', '2021-04-03 08:46:52', '2021-04-03 17:30:30', '2021-04-03');
  INSERT INTO `clock_info` VALUES (13, 'S0004', '2021-04-04 09:13:52', '2021-04-04 18:30:30', '2021-04-04');
  INSERT INTO `clock_info` VALUES (14, 'S0005', '2021-04-05 09:46:52', '2021-0