#市场表
CREATE TABLE tb_market(
  market_id INT PRIMARY KEY AUTO_INCREMENT,
  market_name VARCHAR(50) COMMENT '农贸市场'
);
INSERT INTO tb_market(market_id,market_name) VALUES(1,'沭阳县上东郡农贸市场');
INSERT INTO tb_market(market_id,market_name) VALUES(2,'兴阳农贸市场');
INSERT INTO tb_market(market_id,market_name) VALUES(3,'梦溪农贸市场');

#菜农表
CREATE TABLE tb_farmer(
  fid INT PRIMARY KEY AUTO_INCREMENT,
  fname VARCHAR(50) COMMENT '菜农名称',
  age INT COMMENT '菜农年龄',
  photo VARCHAR(100) COMMENT '头像',
  market_id INT COMMENT '所属市场'
);

INSERT INTO tb_farmer(fid,fname,age,photo,market_id) 
VALUES
(1,'张三',18,'https://tva2.sinaimg.cn/crop.0.0.996.996.1024/a818cb9ajw8ezq0h4qg8wj20ro0rptar.jpg',1),
(2,'张三三',18,'https://tvax1.sinaimg.cn/crop.0.0.512.512.1024/b8b96874ly8g4ngp1u0xdj20e80e8t9p.jpg',1),
(3,'李四',19,'https://tva3.sinaimg.cn/crop.0.44.421.421.1024/676e7956jw8f9ic2cdnouj20bp0e6q3j.jpg',2),
(4,'李四四',19,'https://tvax3.sinaimg.cn/crop.0.0.664.664.1024/007qwBaUly8g9xod0ja57j30ig0ig3zk.jpg',2),
(5,'王五',20,'https://tvax3.sinaimg.cn/crop.0.0.439.439.1024/007d3wpply8ftn74yyy94j30c80c775i.jpg',3),
(6,'王五五',21,'https://tvax2.sinaimg.cn/crop.0.114.500.500.1024/006r3Xirly8fuil9ib0cxj30dw0joaat.jpg',3)
;