Weightrip

Tables (10)

EmailCode

  • id — Integer — Primary key — NOT NULL
  • email — String(120) — NOT NULL
  • code — String(120) — NOT NULL
  • date_time — DateTime

Item

  • id — Integer — Primary key — NOT NULL
  • item_name — String(120) — NOT NULL
  • category — String(120) — NOT NULL
  • price — Integer — NOT NULL
  • image — Text
  • image_url — String(120)
  • unit_weight — Float — NOT NULL
  • max_weight — Float — NOT NULL
  • recommand_order_weight — Float — NOT NULL
  • code — String(255)
  • division — String(120) — NOT NULL
  • volume — String(120) — NOT NULL
  • desc — Text
  • created — DateTime

Orderlist

  • id — Integer — Primary key — NOT NULL
  • date_time — DateTime — NOT NULL
  • weightrip_id — Integer — NOT NULL
  • item_name — String(120) — NOT NULL
  • item_price — Integer — NOT NULL
  • item_count — Integer — NOT NULL
  • total_price — Integer — NOT NULL
  • desc

Rawdata (Rrawdata)

  • id — Integer — Primary key — NOT NULL
  • weightrip_id — Integer — Foreign key → Weightrip.id — NOT NULL
  • date_time — DateTime
  • weight — Float
  • battery — Float

ServerUrl

  • id — Integer — Primary key — NOT NULL
  • user_division — String(120) — NOT NULL
  • server_url — String(120) — NOT NULL
  • date_time — DateTime

Summary

  • id — Integer — Primary key — NOT NULL
  • item_id — Integer
  • item_name — String(120) — NOT NULL
  • item_category — String(120)
  • address — String(120)
  • address_detail — String(120)
  • weight_sum — Float
  • user_name — String(120)
  • summary_time — DateTime

Temperature

  • id — Integer — Primary key — NOT NULL
  • desc — String(120) — NOT NULL
  • temperature (server_url) — Float — NOT NULL
  • humidity — Float — NOT NULL
  • rssi — String(120)
  • date_time — DateTime

User

  • id — Integer — Primary key — NOT NULL
  • user_name — String(120) — NOT NULL
  • password — String(120) — NOT NULL
  • Contact — String(120) — NOT NULL
  • email — String(120) — NOT NULL
  • post_no — String(120) — NOT NULL
  • address — String(120) — NOT NULL
  • address_detail — String(120)
  • division — String(120) — NOT NULL
  • desc — String(120)
  • created — DateTime

Weightrip

  • id — Integer — Primary key — NOT NULL
  • user_id — Integer — Foreign key → User.id — NOT NULL
  • item_id — Integer — Foreign key → Item.id — NOT NULL
  • weightrip_model_id — Integer — Foreign key → WeightripModel.id — NOT NULL
  • sid — String(120) — NOT NULL
  • address — String(120) — NOT NULL
  • address_detail — String(120)
  • order_weight — Float — NOT NULL
  • nick_name — String(120)
  • desc — String(120)
  • order_state — Integer
  • active — String(120)
  • created — DateTime

WeightripModel

  • id — Integer — Primary key — NOT NULL
  • model — Stirng(120) — NOT NULL
  • image — Text
  • desc — Text
  • created — DateTime