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