kyj-yanglao-end-new/sql/mysql/elderly_build_floor_order_food.sql

DROP TABLE IF EXISTS `elderly_build_floor_order_food`;
CREATE TABLE `elderly_build_floor_order_food`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `build_id` int(11) NULL DEFAULT NULL COMMENT '楼栋id',
  `build_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '楼栋名称',
  `floor_id` int(11) NULL DEFAULT NULL COMMENT '楼层id',
  `floor_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '楼层名称',
  `order_date` date NULL DEFAULT NULL COMMENT '报餐日期',
  `order_data_json` varchar(2048) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报餐json数据',
  `remark` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `creator` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间',
  `updater` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
  `tenant_id` bigint(20) NULL DEFAULT NULL COMMENT '机构id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '楼层报餐' ROW_FORMAT = Dynamic;