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