beamin
Tables (6)
ADDRESS
- Key (id) — int — Primary key — NOT NULL
- Field (address) — varchar(300)
- Field (address_detail) — varchar(300)
- Key (user_id) — int — Foreign key → USER.Key — NOT NULL
- Field2 (is_prime) — boolean
MENU
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchat(200)
- Field (price) — int
- Field (description) — varchat(1000)
- Field (category) — varchar(50)
- Key (restaurant_id) — int — Foreign key → RESTAURANT.Key — NOT NULL
MENU_ORDER
- Key (menu_id) — int — Foreign key → MENU.Key — NOT NULL
- Key (order_id) — int — Foreign key → ORDER.Key — NOT NULL
- Field (count)
ORDER
- Key (id) — int — Primary key — NOT NULL
- Field (request_message) — varchar(200)
- Field2 (total_price) — int
- Field (status) — varchar(200)
- Field (startAt) — datetime
- Field (endAt) — datetime
- Field
- Key (contect_info_id) — int — Foreign key → ADDRESS.Key — NOT NULL
RESTAURANT
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar(45)
- Field2 (address) — varchar(200)
- Field (address_detail) — varchat(200)
- Field (telephone) — varchat(20)
USER
- Key (id) — int — Primary key — NOT NULL
- Field (email) — varchat(45)
- Field (pwd) — varchat(300)
- Field (phone_number)