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)