Baemin
Tables (7)
Address
- id — bigint — Primary key — NOT NULL
- road_address — varchar(40)
- detail_address — varchar(40)
- is_default — boolean
- user_id — bigint — Foreign key → User.id — NOT NULL
Menu
- id — bigint — Primary key — NOT NULL
- menu_name — varchar(40)
- description — text
- price — int
- is_available — boolean
- id (id2) — bigint — Foreign key → Restaurant.id — NOT NULL
Order
- id — bigint — Primary key — NOT NULL
- status — varchar(20)
- total_price — int
- payment_method — varchar(20)
- address_id — bigint — Foreign key → Address.id — NOT NULL
- user_id — bigint — Foreign key → User.id — NOT NULL
- restaurant_id — bigint — Foreign key → Restaurant.id — NOT NULL
- request_note — text
- ordered_at — timestamp
OrderItem
- id — bigint — Primary key — NOT NULL
- menu_id — bigint — Foreign key → Menu.id — NOT NULL
- order_id — bigint — Foreign key → Order.id — NOT NULL
- quantity — int
- unit_price — int
Restaurant
- id — bigint — Primary key — NOT NULL
- restaurant_name — varchar(20)
- category — varchar
- address — varchar(40)
- min_order_amount — float
- delivery_fee — float
- rate — float
- is_open — boolean
Review
- id — bigint — Primary key — NOT NULL
- order_id — bigint — Foreign key → Order.id — NOT NULL
- user_id — bigint — Foreign key → User.id — NOT NULL
- restaurant_id — bigint — Foreign key → Restaurant.id — NOT NULL
- rate — int
- content — text
- created_at — timestamp
User
- id — bigint — Primary key — NOT NULL
- user_id — bigint
- user_name — varchar(20)
- password — bigint
- email — varchar(20)
- phone_number — varchar(20)
- created_at — timestamp
- updated_at — timestamp