mini
Tables (6)
AppleBatch (Untitled3)
- id (Key) — Long — Primary key — NOT NULL
- storage_id (Key2) — Long — Foreign key → Storage.id — NOT NULL
- variety (Field) — String
- harvest_date (Field2) — Date
- quantity (Field3) — int
- storage_start_date (Field4) — DateTime
Prediction (Untitled6)
- id (Key) — Long — Primary key — NOT NULL
- recommend_date (Field) — Date
- days_until_recommend (Field2) — int
- expected_total_price (Field3) — int
- expected_unit_price (Field4) — int
- box_count (Field5) — int
- quality_status (Field6) — String
- warning_message (Field7) — String
- recommend_reason (Field8) — String
- created_at (Field9) — DateTime
- batch_id (Key2) — Long — Foreign key → AppleBatch.id — NOT NULL
PriceHistory (Untitled5)
- id (Key) — Long — Primary key — NOT NULL
- date (Field) — Date
- market (Field2) — String
- item (Field3) — String
- price (Field4) — int
- variety (Field5) — String
Sensor (Untitled4)
- id (Key) — Long — Primary key — NOT NULL
- batch_id (Key2) — Long — Foreign key → AppleBatch.id — NOT NULL
- temperture (Field) — Double
- humidity (Field2) — Double
- ethylene (Field3) — Double
- measured_at (Field4) — DateTime
Storage (Untitled2)
- id (Key) — Long — Primary key — NOT NULL
- user_id (Key2) — Long — Foreign key → User.id — NOT NULL
- name (Field) — String
User (Untitled)
- id (Key) — Long — Primary key — NOT NULL
- loginId (Field) — Long
- password (Field2) — String
- name (Field3) — String