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