CoffeeBean
Tables (5)
CoffeeBean (커피콩)
- coffee_id (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- price (Field2) — int
- stock (Field3) — int
Delivery (배송)
- delivery_id (Key) — Long — Primary key — NOT NULL
- delivery_date (Field) — LocalDateTime
- status (Field2) — String
- user_id (Key2) — Long — Foreign key → User.user_id — NOT NULL
Order (주문)
- order_id (Key) — Long — Primary key — NOT NULL
- order_date (Field) — LocalDateTime
- user_id (Key2) — Long — Foreign key → User.user_id — NOT NULL
- delivery_id (Key3) — Long — Foreign key → Delivery.delivery_id — NOT NULL
OrderDetails (주문 상세)
- order_id (Key) — Long — Primary key — NOT NULL
- coffee_Id (Key2) — Long — Primary key — NOT NULL
- quantity (Field) — int
- order_id (Key3) — Long — Foreign key → Order.order_id — NOT NULL
- coffee_id (Key4) — Long — Foreign key → CoffeeBean.coffee_id — NOT NULL
User (사용자)
- user_id (Key) — Long — Primary key — NOT NULL
- email (Field) — String