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