Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: punjab_iot
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
1
punjab_iot
{"j_tabs":{"punjab_iot.activity_log":1,"punjab_iot.admins":1,"punjab_iot.block_fieldid":1,"punjab_iot.client_connected_status":1,"punjab_iot.client_details":1,"punjab_iot.crop_details":1,"punjab_iot.crop_irrigation_schedules":1,"punjab_iot.crop_varieties":1,"punjab_iot.days_min_maxes":1,"punjab_iot.days_splits":1,"punjab_iot.days_split_details":1,"punjab_iot.districts":1,"punjab_iot.district_details":1,"punjab_iot.equipment_details":1,"punjab_iot.farmer_crop_infos":1,"punjab_iot.farmer_details":1,"punjab_iot.field_stations":1,"punjab_iot.irrigationdata":0,"punjab_iot.irrigation_schedules":1,"punjab_iot.massage_reminder":1,"punjab_iot.masters":1,"punjab_iot.master_remindertype":1,"punjab_iot.max_level":1,"punjab_iot.max_levels":1,"punjab_iot.migrations":1,"punjab_iot.msg_histories":1,"punjab_iot.pages":1,"punjab_iot.password_resets":1,"punjab_iot.permissions":1,"punjab_iot.permission_role":1,"punjab_iot.pump_controller_models":1,"punjab_iot.remote_commands":1,"punjab_iot.remote_command_histories":1,"punjab_iot.report_mail_masters":1,"punjab_iot.research_centers":1,"punjab_iot.roles":1,"punjab_iot.role_user":1,"punjab_iot.sansor_data":1,"punjab_iot.sansor_history_data":1,"punjab_iot.season_details":1,"punjab_iot.sensor_details":1,"punjab_iot.settings":1,"punjab_iot.site_details":1,"punjab_iot.station_details":1,"punjab_iot.talukas":1,"punjab_iot.users":1,"punjab_iot.villages":1,"punjab_iot.work_types":1},"h_tabs":{"punjab_iot.activity_log":1,"punjab_iot.admins":1,"punjab_iot.block_fieldid":1,"punjab_iot.client_connected_status":1,"punjab_iot.client_details":1,"punjab_iot.crop_details":1,"punjab_iot.crop_irrigation_schedules":1,"punjab_iot.crop_varieties":1,"punjab_iot.days_min_maxes":1,"punjab_iot.days_splits":1,"punjab_iot.days_split_details":1,"punjab_iot.districts":1,"punjab_iot.district_details":1,"punjab_iot.equipment_details":1,"punjab_iot.farmer_crop_infos":1,"punjab_iot.farmer_details":1,"punjab_iot.field_stations":1,"punjab_iot.irrigationdata":1,"punjab_iot.irrigation_schedules":1,"punjab_iot.massage_reminder":1,"punjab_iot.masters":1,"punjab_iot.master_remindertype":1,"punjab_iot.max_level":1,"punjab_iot.max_levels":1,"punjab_iot.migrations":1,"punjab_iot.msg_histories":1,"punjab_iot.pages":1,"punjab_iot.password_resets":1,"punjab_iot.permissions":1,"punjab_iot.permission_role":1,"punjab_iot.pump_controller_models":1,"punjab_iot.remote_commands":1,"punjab_iot.remote_command_histories":1,"punjab_iot.report_mail_masters":1,"punjab_iot.research_centers":1,"punjab_iot.roles":1,"punjab_iot.role_user":1,"punjab_iot.sansor_data":1,"punjab_iot.sansor_history_data":1,"punjab_iot.season_details":1,"punjab_iot.sensor_details":1,"punjab_iot.settings":1,"punjab_iot.site_details":1,"punjab_iot.station_details":1,"punjab_iot.talukas":1,"punjab_iot.users":1,"punjab_iot.villages":1,"punjab_iot.work_types":1}}
[]
{"activity_log":"log_name","block_fieldid":"fieldId","client_connected_status":"fieldId","client_details":"fieldId","crop_details":"cropName","crop_irrigation_schedules":"farmer","crop_varieties":"crop","days_splits":"type","days_split_details":"daySpiltId","districts":"districtName","district_details":"districtName","equipment_details":"equipName","farmer_crop_infos":"year","farmer_details":"farmerName","field_stations":"fieldId","irrigationdata":"farmerName","irrigation_schedules":"stationId","massage_reminder":"fieldId","master_remindertype":"description","max_level":"fieldId","max_levels":"fieldId","migrations":"migration","msg_histories":"fieldId","pages":"title","password_resets":"email","permissions":"name","pump_controller_models":"fieldId","remote_commands":"stationId","remote_command_histories":"stationId","report_mail_masters":"OfficerName","research_centers":"stationId","roles":"name","sansor_data":"fieldId","sansor_history_data":"fieldId","season_details":"season","sensor_details":"sensorName","settings":"key","site_details":"siteName","station_details":"stationName","talukas":"talukaName","users":"name","villages":"villageName","work_types":"work_type"}
-1
1
Untitled *
v Show/Hide tables list View in fullscreen New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v punjab_iot activity_log
* id : int(10) unsigned
* log_name : varchar(191)
* description : text
* subject_id : int(11)
* subject_type : varchar(191)
* causer_id : int(11)
* causer_type : varchar(191)
* properties : text
* created_at : timestamp
* updated_at : timestamp
v punjab_iot admins
* id : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v punjab_iot block_fieldid
* id : bigint(20) unsigned
* fieldId : text
* flag : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot client_connected_status
* id : bigint(20) unsigned
* fieldId : text
* createdDate : date
* createdDateTime : datetime
* ipadd : text
* dataflag : tinyint(1)
v punjab_iot client_details
* id : bigint(20) unsigned
* fieldId : text
* mobileNo_IP : text
* created_at : timestamp
* updated_at : timestamp
v punjab_iot crop_details
* id : bigint(20) unsigned
* cropName : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot crop_irrigation_schedules
* id : bigint(20) unsigned
* farmer : text
* dayType : text
* startDate : text
* endDate : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot crop_varieties
* id : bigint(20) unsigned
* crop : text
* crop_variety : text
* crop_duration : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot days_min_maxes
* id : bigint(20) unsigned
* workTypeId : int(11)
* days : int(11)
* maxWL : int(11)
* minWL : int(11)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot days_splits
* id : bigint(20) unsigned
* type : text
* duration : text
* work_type : text
* status : text
* createdBy : varchar(191)
* maxWL : int(11)
* minWL : int(11)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot days_split_details
* id : bigint(20) unsigned
* daySpiltId : text
* status : text
* maxWL : int(11)
* minWL : int(11)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot districts
* id : bigint(20) unsigned
* districtName : text
* pincode : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot district_details
* id : bigint(20) unsigned
* districtName : text
* pincode : text
* remark : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot equipment_details
* id : bigint(20) unsigned
* equipName : text
* equipType : text
* equipMake : text
* equipModel : text
* equipQuality : text
* equipSerialNo : text
* equipDesc : text
* equipWeight : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot farmer_crop_infos
* id : bigint(20) unsigned
* year : text
* season : text
* farmer : text
* crop_variety : text
* sowing_date : text
* transplanting_date : text
* harvesting_date : text
* area : text
* plot_no : text
* schedule : tinyint(1)
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot farmer_details
* id : bigint(20) unsigned
* farmerName : text
* village : text
* taluka : text
* district : text
* contactNo : text
* emailId : text
* rCenter : text
* fStation : text
* pumpSize : text
* borewellDepth : text
* borewellDia : text
* pumpDia : text
* plotArea : text
* deviceNo : text
* soilType : text
* latitude : text
* longitude : text
* status : text
* active_status : tinyint(1)
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot field_stations
* id : bigint(20) unsigned
* fieldId : text
* fieldName : text
* stationId : text
* district : text
* taluka : text
* village : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot irrigationdata
* farmerName : text
* farmerId : bigint(20) unsigned
* id : bigint(20) unsigned
* stationId : text
* fieldId : text
* startDate : text
* startTime : text
* endDate : text
* endTime : text
* flow : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot irrigation_schedules
* id : bigint(20) unsigned
* stationId : text
* fieldId : text
* startDate : text
* startTime : text
* endDate : text
* endTime : text
* flow : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot massage_reminder
* id : bigint(20) unsigned
* fieldId : text
* sendDateTime : datetime
* nextSendDateTime : datetime
* waterlevel : double(10,3)
* sendid : int(11)
* rtypid : int(11)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot masters
* id : bigint(20) unsigned
* created_at : timestamp
* updated_at : timestamp
v punjab_iot master_remindertype
* id : int(11)
* rtypid : int(11)
* description : text
* message : text
v punjab_iot max_level
* ID : int(11)
* fieldId : text
* maxlevel : double(10,3)
* groundlevel : double(5,2)
* openlevel : double(5,2)
* minDWLR : decimal(10,3)
* maxDWLR : decimal(10,3)
v punjab_iot max_levels
* id : bigint(20) unsigned
* fieldId : text
* maxlevel : double
* groundlevel : double
* openlevel : double
* minDWLR : decimal(8,2)
* maxDWLR : decimal(8,2)
* minSoil : decimal(10,3)
* maxSoil : decimal(10,3)
* maintainRange : decimal(10,3)
* status : varchar(191)
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot migrations
* id : int(10) unsigned
* migration : varchar(191)
* batch : int(11)
v punjab_iot msg_histories
* id : bigint(20) unsigned
* fieldId : varchar(191)
* msgSentTime : datetime
* waterLevel_battery : varchar(191)
* sentId : varchar(191)
* msgrtypid : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot pages
* id : int(10) unsigned
* created_at : timestamp
* updated_at : timestamp
* deleted_at : timestamp
* title : varchar(191)
* content : text
v punjab_iot password_resets
* email : varchar(191)
* token : varchar(191)
* created_at : timestamp
v punjab_iot permissions
* id : int(10) unsigned
* name : varchar(191)
* label : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot permission_role
* permission_id : int(10) unsigned
* role_id : int(10) unsigned
v punjab_iot pump_controller_models
* id : bigint(20) unsigned
* fieldId : text
* createdDate : date
* createdDateTime : datetime
* pumpStatus : tinyint(1)
* powerStatus : tinyint(1)
* overVoltStatus : tinyint(1)
* underVoltStatus : tinyint(1)
* overLoadStatus : tinyint(1)
* underLoadStatus : tinyint(1)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot remote_commands
* id : bigint(20) unsigned
* stationId : text
* fieldId : text
* command : text
* created_at : timestamp
* updated_at : timestamp
v punjab_iot remote_command_histories
* id : bigint(20) unsigned
* parent_Id : int(11)
* stationId : text
* fieldId : text
* command : text
* created_at : timestamp
* updated_at : timestamp
v punjab_iot report_mail_masters
* id : bigint(20) unsigned
* OfficerName : text
* Designation : text
* MailId : text
* MobileNo : text
* MailType : text
* status : varchar(191)
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot research_centers
* id : bigint(20) unsigned
* stationId : text
* stationName : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot roles
* id : int(10) unsigned
* name : varchar(191)
* label : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot role_user
* role_id : int(10) unsigned
* user_id : bigint(20) unsigned
v punjab_iot sansor_data
* id : bigint(20) unsigned
* fieldId : text
* createdDate : date
* createdDateTime : datetime
* configCode : int(11)
* waterLevel : double(10,3)
* waterLevelAlarm : int(11)
* nrCounter : int(11)
* soil : double(10,3)
* soilAlarm : int(11)
* pumpStatus : int(11)
* pumpRunHours : varchar(191)
* pumpAlarm : int(11)
* dwlr : double(10,3)
* dwlrAlarm : int(11)
* flow : double(10,3)
* flowcumulative : double(10,3)
* flowAlarm : int(11)
* flow1 : double(10,3)
* flowcumulative1 : double(10,3)
* flowAlarm1 : int(11)
* rainPulse : decimal(12,3)
* rainToday : double(10,3)
* rainTotal : double(10,3)
* rainAlarm : int(11)
* PulsesCount : double(10,3)
* PulsesCumm : decimal(12,3)
* PulsesSeasonCumm : decimal(12,3)
* PulsesYestCumm : decimal(12,3)
* PulsesCumm3 : decimal(12,3)
* PulsesSeasonCumm3 : decimal(12,3)
* PulsesYestCumm3 : decimal(12,3)
* batteryAlarm : int(11)
* AWDBatAlarm : int(11)
* checksum : varchar(191)
* month : varchar(191)
* year : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot sansor_history_data
* id : bigint(20) unsigned
* fieldId : text
* createdDate : date
* createdDateTime : datetime
* configCode : int(11)
* waterLevel : double(10,3)
* waterLevelAlarm : int(11)
* soil : double(10,3)
* soilAlarm : int(11)
* pumpStatus : int(11)
* pumpRunHours : varchar(191)
* pumpAlarm : int(11)
* dwlr : double(10,3)
* dwlrAlarm : int(11)
* flow : double(10,3)
* flowcumulative : double(10,3)
* flowAlarm : int(11)
* flow1 : double(10,3)
* flowcumulative1 : double(10,3)
* flowAlarm1 : int(11)
* rainPulse : decimal(12,3)
* rainToday : double(10,3)
* rainTotal : double(10,3)
* rainAlarm : int(11)
* PulsesCount : double(10,3)
* PulsesCumm : decimal(12,3)
* PulsesSeasonCumm : decimal(12,3)
* PulsesYestCumm : decimal(12,3)
* PulsesCumm3 : decimal(12,3)
* PulsesSeasonCumm3 : decimal(12,3)
* PulsesYestCumm3 : decimal(12,3)
* batteryAlarm : int(11)
* AWDBatAlarm : int(11)
* checksum : varchar(191)
* month : varchar(191)
* year : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot season_details
* id : bigint(20) unsigned
* season : varchar(191)
* fromDate : text
* endDate : text
* status : varchar(191)
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot sensor_details
* id : bigint(20) unsigned
* sensorName : text
* sensorType : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot settings
* id : int(10) unsigned
* key : varchar(191)
* value : varchar(191)
v punjab_iot site_details
* id : bigint(20) unsigned
* siteName : text
* lat : text
* long : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot station_details
* id : bigint(20) unsigned
* stationName : text
* area : text
* lat : text
* long : text
* stationType : text
* sensorType : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot talukas
* id : bigint(20) unsigned
* talukaName : text
* district : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot users
* id : bigint(20) unsigned
* name : varchar(191)
* farmer : varchar(191)
* email : varchar(191)
* email_verified_at : timestamp
* username : text
* password : varchar(191)
* remember_token : varchar(100)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot villages
* id : bigint(20) unsigned
* villageName : text
* taluka : text
* district : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp
v punjab_iot work_types
* id : bigint(20) unsigned
* work_type : text
* duration : text
* varietyId : text
* status : text
* createdBy : varchar(191)
* created_at : timestamp
* updated_at : timestamp