CafeKiosk

Tables (4)

Member (회원)

  • id (member_pk) — int — Primary key
  • member_id (회원아이디) — varchar(255)
  • password (회원비밀번호) — varchar(255)
  • auth (관리자여부) — int

Menu (메뉴)

  • id (menu_pk) — int — Primary key — NOT NULL
  • name (메뉴이름) — varchar(255)
  • price (가격) — decimal(10,2)
  • category (카테고리) — enum
  • imagePath (이미지경로) — varchar(255)

Order (주문)

  • id (order_pk) — int — Primary key — NOT NULL
  • orderDate (주문일시) — datetime
  • id (member_pk) — int — Foreign key → Member.id

OrderItem (주문상세내역)

  • id (orderItem_pk) — int — Primary key — NOT NULL
  • quantity (주문수량) — int
  • temperature (음료온도) — enum
  • totalPrice (총가격) — decimal(10,2)
  • orderType (주문타입) — enum
  • id (order_pk) — int — Foreign key → Order.id — NOT NULL
  • id (menu_pk) — int — Foreign key → Menu.id — NOT NULL