Ziosk_v2
Tables (9)
Car (자동차)
- id (Key) — Long — Primary key — NOT NULL
- siteOrderId (주문) — SiteOrder — Foreign key → SiteOrder.id — NOT NULL
- first (앞번호) — String
- end (뒷번호) — String
- parkingTime (주차시간) — LocalDate
- freeTime (정산시간) — LocalDate
Category (카테고리)
- id (Key) — Long — Primary key — NOT NULL
- name (카테고리명) — String
Item (아이템)
- id (Key) — Long — Primary key — NOT NULL
- name (아이템명) — String
- price (가격) — Long
Menu (메뉴)
- id (Key) — Long — Primary key — NOT NULL
- categoryId (카테고리) — Category — Foreign key → Category.id — NOT NULL
- name (메뉴명) — String
- price (가격) — Long
MenuItem (메뉴아이템)
- id (Key) — Long — Primary key — NOT NULL
- itemId (아이템) — Item — Foreign key → Item.id — NOT NULL
- menuId (메뉴) — Menu — Foreign key → Menu.id — NOT NULL
OrderItem (주문아이템)
- id (Key) — Long — Primary key — NOT NULL
- orderMenuId (주문메뉴) — OrderMenu — Foreign key → OrderMenu.id — NOT NULL
- name (아이템명) — String
- price (가격) — Long
- count (수량) — Long
- total (총금액) — Long
OrderMenu (주문메뉴)
- id (Key) — Long — Primary key — NOT NULL
- siteOrder (주문) — SiteOrder — Foreign key → SiteOrder.id — NOT NULL
- name (메뉴명) — String
- price (가격) — Long
- count (수량) — Long
- total (총금액) — Long
SiteOrder (주문)
- id (Key) — Long — Primary key — NOT NULL
- orderStatus (주문상태) — Enum
- orderTime (주문시간) — LocalDate
- completeTime (완료시간) — LocalDate
SiteUser (관리자)
- username (유저아이디) — String — Primary key — NOT NULL
- password (비밀번호) — String