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