test

Tables (12)

alert

  • alert_id — NUMBER
  • log_id — NUMBER — Foreign key → sensor_log.log_id
  • alert_msg — VARCHAR2(200)

crop

  • crop_id — VARCHAR2(20)
  • crop_name — VARCHAR2(50) — NOT NULL

cultivation

  • cult_id — VARCHAR2(20)
  • house_id — VARCHAR2(20) — Foreign key → greenhouse.house_id
  • crop_id — VARCHAR2(20) — Foreign key → crop.crop_id
  • start_date — DATE
  • end_date — DATE

employee

  • emp_id — VARCHAR2(20)
  • emp_name — VARCHAR2(50) — NOT NULL

equipment

  • equip_id — VARCHAR2(20)
  • house_id — VARCHAR2(20) — Foreign key → greenhouse.house_id
  • equip_name — VARCHAR2(50)
  • status — VARCHAR2(20)

farm

  • farm_id — VARCHAR2(20)
  • farm_name — VARCHAR2(50) — NOT NULL

greenhouse

  • house_id — VARCHAR2(20)
  • farm_id — VARCHAR2(20) — Foreign key → farm.farm_id
  • house_name — VARCHAR2(50)

harvest

  • harvest_id — NUMBER
  • cult_id — VARCHAR2(20) — Foreign key → cultivation.cult_id
  • harvest_date — DATE
  • amount — NUMBER

sales

  • sales_id — NUMBER
  • harvest_id — NUMBER — Foreign key → harvest.harvest_id
  • sales_date — DATE
  • price — NUMBER

sensor

  • sensor_id — VARCHAR2(20)
  • house_id — VARCHAR2(20) — Foreign key → greenhouse.house_id
  • sensor_type — VARCHAR2(20)

sensor_log

  • log_id — NUMBER
  • sensor_id — VARCHAR2(20) — Foreign key → sensor.sensor_id
  • log_time — TIMESTAMP
  • log_value — NUMBER(10,2)

work_log

  • work_id — NUMBER
  • emp_id — VARCHAR2(20) — Foreign key → employee.emp_id
  • cult_id — VARCHAR2(20) — Foreign key → cultivation.cult_id
  • work_date — DATE
  • work_detail — VARCHAR2(500)