QrOrder

Tables (13)

TB_ACCOUNT (Account)

  • AC_ID (acId) — Primary key — NOT NULL
  • AC_LOGIN_ID (acLoginId)
  • AC_PASSWORD (acPassword)
  • AC_NAME (acName)

TB_CATEGORY (Category)

  • CA_ID (caId) — Primary key — NOT NULL
  • CA_NAME (caName)

TB_CLOSING (Closing)

  • CL_ID (clId) — Primary key — NOT NULL
  • CL_START (clStart)
  • CL_END (clEnd)

TB_CLOSING_FIXED (ClosingFixed)

  • CF_ID (cfId) — Primary key — NOT NULL
  • CL_WEEK_NUM (clWeekNum)
  • CL_WEEK_DAY (clWeekDay)
  • CL_START_TIME (clStartTime)
  • CL_END_TIME (clEndTime)

TB_MENU (Menu)

  • ME_ID (meId) — Primary key — NOT NULL
  • ME_NAME (meName)
  • ME_PRICE (mePrice)
  • ME_STATUS (meStatus)
  • ME_DISCRIPTION (meDiscription)
  • ME_IMAGE_PATH (meImagePath)
  • ME_CA_ID (meCaId) — Foreign key → TB_CATEGORY.CA_ID — NOT NULL

TB_MENU_MANAGE (ManuManage)

  • MM_ID (mmId) — Primary key — NOT NULL
  • MM_START (mmStart)
  • MM_END (mmEnd)
  • MM_ME_ID (mmMeId) — Foreign key → TB_MENU.ME_ID — NOT NULL

TB_MENU_OPTION (MenuOption)

  • OP_ID (opId) — Primary key — NOT NULL
  • OP_NAME (opName)
  • OP_PRICE (opPrice)
  • OP_OG_ID (opOgId) — Foreign key → TB_MENU_OPTION_GROUP.OG_ID — NOT NULL

TB_MENU_OPTION_GROUP (MenuOptionGroup)

  • OG_ID (ogId) — Primary key — NOT NULL
  • OG_NAME (ogName)
  • OG_MIN_SELECT
  • OG_MAX_SELECT

TB_MENU_OPTION_GROUP_JUNCTION (MenuOptionGroupJunction)

  • MJ_ID (mjId) — Primary key — NOT NULL
  • MJ_SEQ (mjSeq)
  • MJ_OG_ID (mjOgId) — Foreign key → TB_MENU_OPTION_GROUP.OG_ID — NOT NULL
  • MJ_ME_ID (mjMeId) — Foreign key → TB_MENU.ME_ID — NOT NULL

TB_MENU_OPTION_MANAGE (MenuOptionManage)

  • OM_ID (omId) — Primary key — NOT NULL
  • OM_START (omStart)
  • OM_END (omEnd)
  • OM_OP_ID (omOpId) — Foreign key → TB_MENU_OPTION.OP_ID — NOT NULL

TB_MENU_ORDER (MenuOrder)

  • MO_ID (moId) — Primary key — NOT NULL
  • MO_COUNT (moCount)
  • MO_ME_ID (moMeId) — Foreign key → TB_MENU.ME_ID — NOT NULL
  • MO_OR_ID (moOrId) — Foreign key → TB_ORDER.OR_ID — NOT NULL

TB_MENU_ORDER_OPTION (MenuOrderOption)

  • OO_ID (ooId) — Primary key — NOT NULL
  • OO_MO_ID (ooMoId) — Foreign key → TB_MENU_ORDER.MO_ID — NOT NULL
  • OO_OP_ID (ooOpId) — Foreign key → TB_MENU_OPTION.OP_ID — NOT NULL

TB_ORDER (Order)

  • OR_ID (orId) — Primary key — NOT NULL
  • OR_UUID (orUuid)
  • OR_STATUS (orStatus)
  • OR_PAYMENT (orPayment)
  • OR_PHONE (orPhone)