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)