yogiyo
Tables (8)
Untitled (Restaurant)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Field (name) — NOT NULL
- Field2 (category) — NOT NULL
- Field3 (thumbnailUrl) — NOT NULL
- Field4 (address) — NOT NULL
- Field5 (lng) — NOT NULL
- Field (lat) — NOT NULL
- Field2 (openTime) — NOT NULL
- Field3 (deliveryTime) — NOT NULL
- Field4 (representativeMenus) — NOT NULL
- Field5 (deliveryFee) — NOT NULL
- Field6 (minOrderAmount) — int(11)
- Field7 (paymentMethods) — NOT NULL
- Field8 (created_at) — NOT NULL
- Field9 (updated_at) — NOT NULL
Untitled (Menu)
- Key2 (id) — NOT NULL — Primary key — NOT NULL
- Key (restaurantId) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Field2 (name) — NOT NULL
- Field (label) — NULL
- Field3 (price) — NOT NULL
- Field4 (created_at) — NOT NULL
- Field5 (updated_at) — NOT NULL
Untitled (Category)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Field (name) — NOT NULL
- Field2 (imgUrl) — NOT NULL
Untitled (User)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Field (name) — NOT NULL
- Field
- Field2 (password) — NOT NULL
- Field3 (address) — NULL
- Field4 (lng) — NULL
- Field5 (lat) — NULL
- Field (phoneNum) — NOT NULL
- Field (created_at) — NOT NULL
- Field (updated_atd) — NOT NULL
Untitled (History)
- Key (id) — NOT NULL — Primary key — NOT NULL
- Key (uid) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Key (restaurantId) — NOT NULL — Foreign key → Untitled.Key — NOT NULL
- Field3 (orderedMenus) — NOT NULL
- Field (orderedPrice) — NOT NULL
- Field2 (orderedDate) — NOT NULL
- Field (orderedAddress) — NOT NULL
Untitled (Ad)
- Key — NOT NULL — Primary key — NOT NULL
- Field (name) — NOT NULL
- Field (imgUrl) — NOT NULL
- Field2 (type) — NOT NULL
- Field (startDate) — NOT NULL
- Field2 (endDate) — NOT NULL
Untitled (Cart)
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4
Untitled (TOS)
- Key — Primary key — NOT NULL
- Field (title) — NOT NULL
- Field2 (content) — NOT NULL
- Field (isEssential) — NOT NULL