cafe
테이블 (8)
CATEGORY (카테고리)
- CATEGORY_ID (Key) — 기본 키 — NOT NULL
- CATEGORY_NAME (Field)
- CATEGORY_DESC (Field2)
- DISPLAY_ORDER (Field3)
- IS_USED (Field4)
- CREATED_TIME (Field5)
- UPDATED_TIME (Field6)
MENU (메뉴)
- MENU_ID (Key) — 기본 키 — NOT NULL
- CATEGORY_ID (Key3) — 외래 키 → CATEGORY.CATEGORY_ID — NOT NULL
- NAME (Field)
- PRICE (Field2)
- IS_AVAILABLE (Field3)
- CREATED_AT (Field4)
- UPDATED_AT (Field5)
- IS_USED (Field6)
- IMAGE_PATH (Field7)
- DESCRIPTION (Field8)
ORDERS (Untitled)
- ORDER_ID (Key) — 기본 키 — NOT NULL
- USER_ID (Key4) — 외래 키 → USERS.USER_ID — NOT NULL
- STATUS (Field) — 요청, 승인, 취소, 완료
- CREATED_TIME (Field2)
- UPDATED_TIME (Field3)
- IS_USED (Field4)
- AMOUNT (Field5) — 총 가격
ORDER_ITEM (음료) (Untitled2)
- ORDER_ITEM_ID (Key) — 기본 키 — NOT NULL
- ORDER_ID (Key4) — 외래 키 → ORDERS.ORDER_ID — NOT NULL
- MENU_ID (Key2) — 외래 키 → MENU.MENU_ID — NOT NULL
- QUANTITY (Field)
- SEQUENCE (Field2)
- CREATED_TIME (Field3)
- UPDATED_TIME (Field4)
- IS_USED (Field5)
RESERVATION (좌석 예약) (Untitled3)
- RESERVATION_ID (Key) — 기본 키 — NOT NULL
- ORDER_ID (Key4) — 외래 키 → ORDERS.ORDER_ID — NOT NULL
- SEAT_ID (Key5) — 외래 키 → SEAT.SEAT_ID — NOT NULL
- RESERVE_DATE (Field)
- START_TIME (Field2)
- END_TIME (Field3)
- STATUS (Field4)
- CREATED_TIME (Field5)
- UPDATED_TIME (Field6)
- IS_USED (Field7)
RESERVATION_TEMP (CopyOfUntitled4)
- RESERVATION_TEMP_ID (Key) — 기본 키 — NOT NULL
- SEAT_ID (Field)
- _TIME (Field2)
- CREATED_TIME (Field3)
- UPDATED_TIME (Field4)
- IS_USED (Field5)
SEAT (Untitled4)
- SEAT_ID (Key) — 기본 키 — NOT NULL
- SEAT_NUMBER (Field)
- STATUS (Field2)
- CREATED_TIME (Field3)
- UPDATED_TIME (Field4)
- IS_USED (Field5)
USERS (Untitled5)
- USER_ID (Key) — 기본 키 — NOT NULL
- EMAIL (Field)
- PASSWORD (Field2)
- SALT (Field3)
- ROLE (Field4)
- CREATED_TIME (Field5)
- UPDATED_TIME (Field6)
- IS_USED (Field7)