CREATE TABLE ns20_1_ai_report (
  id INT AUTO_INCREMENT PRIMARY KEY,
  deviceid VARCHAR(20) NOT NULL,
  farm_name VARCHAR(50) NOT NULL,
  crop_type VARCHAR(20) NOT NULL,
  report_date DATE NOT NULL,
  json_file VARCHAR(100) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);