baemin
Tables (9)
Address (Untitled2)
- address_id — Primary key — NOT NULL
- user_id — Foreign key → Users.user_id — NOT NULL
- addressName — NOT NULL
- detailAddress — NOT NULL
- isDefault — NOT NULL
Category (Untitled3)
- category_id — Primary key — NOT NULL
- name — NOT NULL
Favorite (Untitled7)
- favorite_id — Primary key — NOT NULL
- user_id — Foreign key → Users.user_id — NOT NULL
- restaurant_id — Foreign key → Restaurant.restaurant_id — NOT NULL
Menu
- menu_id — Primary key — NOT NULL
- restaurant_id — Foreign key → Restaurant.restaurant_id — NOT NULL
- name — NOT NULL
- description — NOT NULL
- price — NOT NULL
Order (Untitled5)
- order_id — Primary key — NOT NULL
- user_id — Foreign key → Users.user_id — NOT NULL
- restaurant_id — Foreign key → Restaurant.restaurant_id — NOT NULL
- status — NOT NULL
- totalPrice — NOT NULL
- orderTime — NOT NULL
OrderItem (Untitled6)
- item_id — Primary key — NOT NULL
- menu_id — Foreign key → Menu.menu_id — NOT NULL
- order_id — Foreign key → Order.order_id — NOT NULL
- price — NOT NULL
Restaurant (Untitled4)
- restaurant_id — Primary key — NOT NULL
- category_id — Foreign key → Category.category_id — NOT NULL
- name — NOT NULL
- description
- rating — NOT NULL
- reviewCount — NOT NULL
- deliveryFee — NOT NULL
- minOrderAmount — NOT NULL
Review (Untitled8)
- review_id — Primary key — NOT NULL
- user_id — Foreign key → Users.user_id — NOT NULL
- restaurant_id — Foreign key → Restaurant.restaurant_id — NOT NULL
- order_id — Foreign key → Order.order_id — NOT NULL
- rating
- content
- owner_reply
Users (Untitled)
- user_id — Primary key — NOT NULL
- email — NOT NULL
- password — NOT NULL
- name — NOT NULL
- phoneNumber — NOT NULL
- birth — NOT NULL