yvjia/db/b2c_warehouse_shelf.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/08/18 12:51:10
*/

DROP TABLE IF EXISTS `b2c_warehouse_shelf`;
CREATE TABLE `b2c_warehouse_shelf` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `warehouse_id` BIGINT NOT NULL COMMENT '仓库ID',
    `shelf_type` TINYINT(1) NOT NULL COMMENT '仓库货位状态 (1可销售, 2不可销售)',
    `shelf_floor` VARCHAR(10) NOT NULL COMMENT '货位-楼层',
    `shelf_row` VARCHAR(10) NOT NULL COMMENT '货位-列',
    `shelf_cloumn` VARCHAR(10) NOT NULL COMMENT '货位-行',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='仓库货位表';

INSERT INTO b2c_warehouse_shelf(warehouse_id, shelf_type, shelf_floor, shelf_row, shelf_cloumn) VALUES
    (1, 1, '1', '1', '1'),
    (1, 1, '1', '1', '2'),
    (1, 1, '1', '1', '3'),
    (1, 1, '1', '1', '4'),
    (1, 2, '2', '1', '1'),
    (1, 2, '2', '1', '2')
;