finalProject

Tables (5)

DeliveryInfo

  • id — int — Primary key — NOT NULL
  • 가게ID (shopid) — int
  • 주문날짜 (assignDate) — Date
  • 가게위치X축 (deliveryAddrX) — float
  • 가게위치Y축 (deliveryAddrY) — float
  • 주문상태 (status) — int
  • 가게전화번호 (phone) — varchar
  • 영수증번호 (receipt) — int
  • 업종 (category) — varchar

DeliverySensorData

  • id — int — Primary key — NOT NULL
  • AX — float
  • AY — float
  • AZ — float
  • AX변화량 (AX_compare) — float
  • AY변화량 (AY_compare) — float

UserInfo

  • id — int — Primary key — NOT NULL
  • uid (user_id) — varchar
  • username — varchar

UserPos

  • id — int — Foreign key → UserInfo.id — NOT NULL
  • 사용자위치X축 (userPosX) — float
  • 사용자위치Y축 (userPosY) — float

UserRating

  • id — int — Foreign key → UserInfo.id — NOT NULL
  • 평점 (rate) — int