RGT

Tables (9)

Cart (장바구니)

  • id (Key) — Long — Primary key — NOT NULL
  • storeTable (식당 테이블) — StoreTable — Foreign key → StoreTable.id — NOT NULL
  • storeMenu (식당 메뉴) — StoreMenu — Foreign key → StoreMenu.menu — NOT NULL
  • count (수량) — Long

Menu (메뉴)

  • id (Key) — Long — Primary key — NOT NULL
  • name (메뉴명) — String
  • price (가격) — Long
  • content (설명) — String

MyOrder (주문)

  • id (Key) — Long — Primary key — NOT NULL
  • totalPrice (총 결제 금액) — Long
  • status (주문 상태) — ENUM
  • orderTime (주문 시간) — LocalDateTime

MyTable (테이블)

  • id (Key) — Long — Primary key — NOT NULL
  • tableNumber (Field) — String

OrderMenu (주문 내역)

  • id (Key) — Long — Primary key — NOT NULL
  • myOrder (주문) — MyOrder — Foreign key → MyOrder.id — NOT NULL
  • menuName (메뉴명) — String
  • price (가격) — Long
  • count (수량) — Long
  • total (총 금액) — Long

SiteUser (손님)

  • id (Key) — Long — Primary key — NOT NULL
  • storeTable (식당 테이블) — StoreTable — Foreign key → StoreTable.id — NOT NULL
  • username (아이디) — String
  • password (비밀번호) — String

Store (식당)

  • id (Key) — Long — Primary key — NOT NULL
  • name (식당 이름) — String
  • Field

StoreMenu (식당 메뉴)

  • id (Key) — Long — Primary key — NOT NULL
  • store (식당) — Store — Foreign key → Store.id — NOT NULL
  • menu (메뉴) — Menu — Foreign key → Menu.id — NOT NULL

StoreTable (식당 테이블)

  • id (Key) — Long — Primary key — NOT NULL
  • store (식당) — Store — Foreign key → MyTable.id — NOT NULL
  • myTable (테이블) — MyTable — Foreign key → Store.id — NOT NULL