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)