/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50719
 Source Host           : localhost:3306
 Source Schema         : fram

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

 Date: 10/05/2022 23:39:40
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for fram_crops
-- ----------------------------
DROP TABLE IF EXISTS `fram_crops`;
CREATE TABLE `fram_crops`  (
  `id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `cName` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cVariety` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cStandard` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cWay` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cOperateway` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `dDate` date NULL DEFAULT NULL,
  `dEstimatedtime` date NULL DEFAULT NULL,
  `iOutput` int(11) NULL DEFAULT NULL,
  `iCount` int(11) NULL DEFAULT NULL,
  `isDelete` int(11) NULL DEFAULT NULL,
  `ismature` int(11) NULL DEFAULT NULL,
  `coperator` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cland` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fram_crops
-- ----------------------------
INSERT INTO `fram_crops` VALUES ('682591642699370496', '黄瓜', '移栽', '普通', '人工', '小叶', '2022-05-06', '2022-06-06', 30, 20, 0, 1, '张三', '一号地');
INSERT INTO `fram_crops` VALUES ('682931721917632512', '土豆', '大叶', '有机', '移栽', '机械', '2022-05-07', '2022-08-01', 230, 200, 0, 0, '李四', '二号地');
INSERT INTO `fram_crops` VALUES ('683154342210899968', '西瓜', '西瓜', '有机', '直播', '机械', '2022-05-08', '2022-07-05', 600, 300, 0, 1, '王五', '三号地');
INSERT INTO `fram_crops` VALUES ('683208521604337664', '西葫芦', '西葫芦', '有机', '直播', '机耕', '2022-05-09', '2022-09-08', 300, 50, 0, 0, '王五', '四号地');
INSERT INTO `fram_crops` VALUES ('683615202570080256', '西红柿', '西红柿', '有机', '移栽', '机械', '2022-05-09', '2022-07-09', 200, 100, 0, 1, '王五', '七号地');
INSERT INTO `fram_crops` VALUES ('684028531109203968', '黄瓜', '黄瓜', '有机', '直播', '机械', '2022-05-10', '2022-06-10', 500, 200, 0, 0, '王五', '八号地');

-- ----------------------------
-- Table structure for fram_cycle
-- ----------------------------
DROP TABLE IF EXISTS `fram_cycle`;
CREATE TABLE `fram_cycle`  (
  `id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ddate` date NULL DEFAULT NULL,
  `cgrowthcycle` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cairtemper` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cairhumidity` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cco2` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cguang` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `csoiltemper` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `csiolhumidity` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `coperator` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fram_cycle
-- ----------------------------
INSERT INTO `fram_cycle` VALUES ('0', '682591642699370496', '黄瓜', '2022-05-08', '缓苗期', '16', '30', '25', '36', '18', '12', '张三');
INSERT INTO `fram_cycle` VALUES ('683158631901761536', '683154342210899968', '西瓜', '2022-05-08', '开花期', '16', '20', '5', '6', '18', '20', '孙悟空');
INSERT INTO `fram_cycle` VALUES ('683616187849838592', '683615202570080300', '黄瓜', '2022-05-08', '开花期', '16', '20', '5', '6', '18', '20', '孙悟空');

-- ----------------------------
-- Table structure for fram_growthcycle
-- ----------------------------
DROP TABLE IF EXISTS `fram_growthcycle`;
CREATE TABLE `fram_growthcycle`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cgrowthcycle` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fram_growthcycle
-- ----------------------------
INSERT INTO `fram_growthcycle` VALUES (1, '缓苗期');
INSERT INTO `fram_growthcycle` VALUES (2, '生长 旺盛期');
INSERT INTO `fram_growthcycle` VALUES (3, '花蕾期');
INSERT INTO `fram_growthcycle` VALUES (4, '开花期');
INSERT INTO `fram_growthcycle` VALUES (5, '结果期');
INSERT INTO `fram_growthcycle` VALUES (6, '落果期');

-- ----------------------------
-- Table structure for fram_land
-- ----------------------------
DROP TABLE IF EXISTS `fram_land`;
CREATE TABLE `fram_land`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `darea` decimal(10, 2) NULL DEFAULT NULL,
  `ctype` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `clocation` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `isuse` int(10) NULL DEFAULT 0,
  PRIMARY KEY (`id`, `cname`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fram_land
-- ----------------------------
INSERT INTO `fram_land` VALUES (1, '一号地', 28.32, '大田，大棚', '山西', 1);
INSERT INTO `fram_land` VALUES (2, '二号地', 50.32, '大棚', '山西', 1);
INSERT INTO `fram_land` VALUES (3, '三号地', 100.32, '果园', '上海', 1);
INSERT INTO `fram_land` VALUES (4, '四号地', 88.32, '鱼塘', '江苏', 1);
INSERT INTO `fram_land` VALUES (5, '五号地', 188.32, '山地', '新疆', 0);
INSERT INTO `fram_land` VALUES (6, '六号地', 20.32, '养殖区', '山西', 0);
INSERT INTO `fram_land` VALUES (7, '七号地', 28.32, '大田', '山西', 1);
INSERT INTO `fram_land` VALUES (8, '八号地', 28.32, '大田', '山西', 1);

-- ----------------------------
-- Table structure for fram_product
-- ----------------------------
DROP TABLE IF EXISTS `fram_product`;
CREATE TABLE `fram_product`  (
  `id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cvariety` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `iweight` int(11) NULL DEFAULT NULL,
  `cway` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ddate` date NULL DEFAULT NULL,
  `cproduct` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `coperator` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `clevel` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `isSale` int(11) UNSIGNED ZEROFILL NULL DEFAULT NULL,
  `iamount` int(11) NOT NULL COMMENT '剩余',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fram_product
-- ----------------------------
INSERT INTO `fram_product` VALUES ('683111031286730752', '682591642699370496', '黄瓜', 200, '机械', '2022-05-08', '黄瓜', '张三', '一等品', NULL, 120);
INSERT INTO `fram_product` VALUES ('683158796188454912', '683154342210899968', '西瓜', 300, '机械', '2022-05-08', '西瓜', '张三', '一等品', NULL, 260);
INSERT INTO `fram_product` VALUES ('683616916341723136', '683615202570080300', '西红柿', 300, '机械', '2022-05-10', '西红柿', '张三', '一等品', NULL, 300);

-- ----------------------------
-- Table structure for fram_productfile
-- ----------------------------
DROP TABLE IF EXISTS `fram_productfile`;
CREATE TABLE `fram_productfile`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `ddate` date NULL DEFAULT NULL,
  `coperate` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `coperateor` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cmemory` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `caddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fram_productfile
-- ----------------------------
INSERT INTO `fram_productfile` VALUES (1, '683154342210899968', '西瓜', '2022-05-08', '机械', '王五', '有机 种植数量300', NULL);
INSERT INTO `fram_productfile` VALUES (2, '683154342210899968', '西瓜', '2022-05-08', '环境记录', '孙悟空', ' 开花期', NULL);
INSERT INTO `fram_productfile` VALUES (3, '683154342210899968', '西瓜', '2022-05-08', '机械', '张三', '采收重量300 ', NULL);
INSERT INTO `fram_productfile` VALUES (4, '683154342210899968', '西瓜', '2022-05-08', '销售', '张三', '销售数量40  销售渠道：批发市场', NULL);
INSERT INTO `fram_productfile` VALUES (5, '683208521604337664', '西葫芦', '2022-05-09', '机耕', '王五', '有机 种植数量: 50 四号地', NULL);
INSERT INTO `fram_productfile` VALUES (6, '683615202570080256', '西红柿', '2022-05-09', '机械', '王五', '有机 种植数量: 100 七号地', NULL);
INSERT INTO `fram_productfile` VALUES (7, '683615202570080300', '黄瓜', '2022-05-08', '环境记录', '孙悟空', ' 开花期', NULL);
INSERT INTO `fram_productfile` VALUES (8, '683615202570080300', '西红柿', '2022-05-10', '机械', '张三', '采收重量300 ', NULL);
INSERT INTO `fram_productfile` VALUES (9, '682591642699370500', '西红柿', '2022-05-11', '销售', '张三', '销售数量40  销售渠道：批发市场', NULL);
INSERT INTO `fram_productfile` VALUES (10, '684028531109203968', '黄瓜', '2022-05-10', '机械', '王五', '有机 种植数量: 200 八号地', 'huanggua.png');

-- ----------------------------
-- Table structure for fram_sale
-- ----------------------------
DROP TABLE IF EXISTS `fram_sale`;
CREATE TABLE `fram_sale`  (
  `id` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `uid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cvariety` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `dsaledate` date NULL DEFAULT NULL,
  `isaleamount` int(30) NULL DEFAULT NULL,
  `cgoway` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `dprice` decimal(10, 2) NULL DEFAULT NULL,
  `coperator` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fram_sale
-- ----------------------------
INSERT INTO `fram_sale` VALUES ('683112287673716736', '682591642699370496', '683111031286730752', '黄瓜', '2022-05-08', 40, '批发市场', 3.80, '张三');
INSERT INTO `fram_sale` VALUES ('683160574787260416', '683154342210899968', '683158796188454912', '西瓜', '2022-05-08', 40, '批发市场', 3.80, '张三');
INSERT INTO `fram_sale` VALUES ('683617613325996032', '682591642699370500', '683111031286730800', '西红柿', '2022-05-11', 40, '批发市场', 3.80, '张三');

-- ----------------------------
-- Table structure for fram_vegetables
-- ----------------------------
DROP TABLE IF EXISTS `fram_vegetables`;
CREATE TABLE `fram_vegetables`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `caddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of fram_vegetables
-- ----------------------------
INSERT INTO `fram_vegetables` VALUES (1, '黄瓜', 'huanggua.png');
INSERT INTO `fram_vegetables` VALUES (2, '娃娃菜', 'wawacai.png');
INSERT INTO `fram_vegetables` VALUES (3, '小白菜', 'xiaobaicai.png');
INSERT INTO `fram_vegetables` VALUES (4, '花椰菜', 'huayecai.png');
INSERT INTO `fram_vegetables` VALUES (5, '卷心菜', 'juanxincai.png');
INSERT INTO `fram_vegetables` VALUES (6, '芹菜', NULL);
INSERT INTO `fram_vegetables` VALUES (7, '青菜', 'qingcai.png');
INSERT INTO `fram_vegetables` VALUES (8, '紫甘蓝', 'ziganlan.png');
INSERT INTO `fram_vegetables` VALUES (9, '芥兰', NULL);
INSERT INTO `fram_vegetables` VALUES (10, '小茴香', NULL);
INSERT INTO `fram_vegetables` VALUES (11, '西兰花', NULL);
INSERT INTO `fram_vegetables` VALUES (12, '茄子', 'qiezi.png');
INSERT INTO `fram_vegetables` VALUES (13, '韭菜', NULL);
INSERT INTO `fram_vegetables` VALUES (14, '草莓', NULL);
INSERT INTO `fram_vegetables` VALUES (15, '辣椒', NULL);
INSERT INTO `fram_vegetables` VALUES (16, '大白菜', 'dabaicai.png');
INSERT INTO `fram_vegetables` VALUES (17, '油麦菜', NULL);
INSERT INTO `fram_vegetables` VALUES (18, '西葫芦', 'xihulu.png');
INSERT INTO `fram_vegetables` VALUES (19, '冬瓜', NULL);
INSERT INTO `fram_vegetables` VALUES (20, '豌豆', NULL);
INSERT INTO `fram_vegetables` VALUES (21, '黄豆', NULL);
INSERT INTO `fram_vegetables` VALUES (22, '大葱', NULL);
INSERT INTO `fram_vegetables` VALUES (23, '小葱', NULL);
INSERT INTO `fram_vegetables` VALUES (24, '大蒜', NULL);
INSERT INTO `fram_vegetables` VALUES (25, '山药', NULL);
INSERT INTO `fram_vegetables` VALUES (26, '红薯', NULL);
INSERT INTO `fram_vegetables` VALUES (27, '苹果', NULL);
INSERT INTO `fram_vegetables` VALUES (28, '核桃', NULL);

-- ----------------------------
-- Table structure for product_goway
-- ----------------------------
DROP TABLE IF EXISTS `product_goway`;
CREATE TABLE `product_goway`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cgoway` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of product_goway
-- ----------------------------
INSERT INTO `product_goway` VALUES (1, '田头销售');
INSERT INTO `product_goway` VALUES (2, '超市');
INSERT INTO `product_goway` VALUES (3, '企业事业单位');
INSERT INTO `product_goway` VALUES (4, '菜场');
INSERT INTO `product_goway` VALUES (5, '批发市场');
INSERT INTO `product_goway` VALUES (6, '粮管所');
INSERT INTO `product_goway` VALUES (7, '其他');

-- ----------------------------
-- Table structure for sensor
-- ----------------------------
DROP TABLE IF EXISTS `sensor`;
CREATE TABLE `sensor`  (
  `id` int(11) NOT NULL COMMENT '传感器id',
  `index` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '检测指标',
  `value` double(255, 0) NULL DEFAULT NULL COMMENT '检测指标值',
  `unit` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '单位',
  `garden_id` int(11) NULL DEFAULT NULL COMMENT '菜园id',
  `person` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL COMMENT '负责人',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `shreshold` double(255, 0) NULL DEFAULT NULL COMMENT '阈值',
  `alarm_flag` int(255) NULL DEFAULT NULL COMMENT '报警值  1：报警  0：不报警',
  `device_flag` int(255) NULL DEFAULT NULL COMMENT '设备标识：1：传感器 2：监控设备',
  `cancel_alarm` int(255) NULL DEFAULT NULL COMMENT '取消报警值  1：不取消  0：取消报警',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sensor
-- ----------------------------

-- ----------------------------
-- Table structure for sensor_table
-- ----------------------------
DROP TABLE IF EXISTS `sensor_table`;
CREATE TABLE `sensor_table`  (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '传感器id',
  `indexName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '检测指标',
  `indexValue` double(20, 2) NULL DEFAULT NULL COMMENT '检测指标值',
  `unit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位',
  `gardenId` int(11) NULL DEFAULT NULL COMMENT '菜园id',
  `person` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '负责人',
  `updateTime` timestamp(0) NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
  `shreshold` double(20, 2) NULL DEFAULT NULL COMMENT '阈值',
  `alarmFlag` int(11) NULL DEFAULT NULL COMMENT '报警值  1：报警  0：不报警',
  `deviceFlag` int(11) NULL DEFAULT NULL COMMENT '设备标识：1：传感器 2：监控设备',
  `cancelAlarm` int(11) NULL DEFAULT NULL COMMENT '取消报警值  1：不取消  0：取消报警',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sensor_table
-- ----------------------------
INSERT INTO `sensor_table` VALUES (1, '黄晓卓', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;