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