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