直播间信息表 Broadcastroom
RoomID varchar(30)FarmerID varchar(30)CameraID varchar(30)
认领人信息表PointPersons
PersonID varchar(20)PersonName varchar(20)Password varchar(30)MobilePhone varchar(30)EmailAddress varchar(30)Sex varchar(2)QQ varchar(20)WeChat varchar(30)
农场主信息表Farmers
FarmerID varchar(30)FarmerName varchar(30)Password varchar(30)Authorizations Varchar(30)Sex varchar(2)MobilePhone varchar(30)EmailAddress varchar(30)QQ varchar(20)WeChat varchar(30)Checkstatus Char(2)
农场主土地表
FarmerID varchar(30)FarmID varchar(30)
农场劳务表PLabors
FarmID varchar(30)LaborID varchar(30)Text varchar(30)
认领人选择农场表PFarms
PersonID\tvarchar(20)FarmID\tvarchar(30)NumberID\tvarchar(30)
农场信息表Farms
FarmID varchar(30)FarmName varchar(50)Checkstatus Char(2)Text varchar(50)
农场摄像头分布表Fcamera
CameraID varchar(30)FarnID varchar(30)
