JAVA实战开源项目：超市商品管理系统(Vue+SpringBoot)-五、数据库设计

-- 商品表
CREATE TABLE IF NOT EXISTS `a_commodity` (
  `id` varchar(255) COLLATE utf8mb3_croatian_ci NOT NULL,
  `create_by` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `del_flag` int NOT NULL,
  `update_by` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `area` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `big_type` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `guarantee_date` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `money1` decimal(38,2) DEFAULT NULL,
  `money2` decimal(38,2) DEFAULT NULL,
  `product_factory` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `prove` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `remark` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `sell_factory` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `shelves` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `shelves_id` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `type_id` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_croatian_ci;

-- 商品类型表
CREATE TABLE IF NOT EXISTS `a_commodity_type` (
  `id` varchar(255) COLLATE utf8mb3_croatian_ci NOT NULL,
  `create_by` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `del_flag` int NOT NULL,
  `update_by` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `remark` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `sort_order` decimal(38,2) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_croatian_ci;

-- 超市区域表
CREATE TABLE IF NOT EXISTS `a_supermarket_area` (
  `id` varchar(255) COLLATE utf8mb3_croatian_ci NOT NULL,
  `create_by` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `del_flag` int NOT NULL,
  `update_by` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `remark` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `sort_order` decimal(38,2) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_croatian_ci;

-- 超市货架表
CREATE TABLE IF NOT EXISTS `a_supermarket_shelves` (
  `id` varchar(255) COLLATE utf8mb3_croatian_ci NOT NULL,
  `create_by` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `create_time` datetime(6) DEFAULT NULL,
  `del_flag` int NOT NULL,
  `update_by` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `update_time` datetime(6) DEFAULT NULL,
  `area` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `area_id` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `remark` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `sort_order` decimal(38,2) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb3_croatian_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_croatian_ci;