123

Tables (20)

APPROVAL_STATUS

  • NO — NUMBER
  • STATUS — VARCHAR2(10) — NOT NULL

CART

  • NO — NUMBER
  • USER_NO — NUMBER — Foreign key → MEMBER_USER.NO — NOT NULL
  • FOOD_COUNT — NUMBER — NOT NULL
  • FOOD_NO — NUMBER — Foreign key → FOOD_INFOR.NO — NOT NULL

CLOSED_DAY

  • NO — NUMBER
  • DAY — DATE — NOT NULL
  • COMMENT — VARCHAR2(100) — NOT NULL
  • STORE_NO — NUMBER — NOT NULL

DELIVERY_PROBLEM

  • NO — NUMBER
  • DELIVERY_PROBLEM — VARCHAR2(30) — NOT NULL

DELIVERY_ZONE

  • NO — NUMBER

FOOD_INFOR

  • NO — NUMBER
  • NAME — VARCHAR2(60) — NOT NULL
  • PRICE — NUMBER — NOT NULL
  • FOOD_MENU_CATEGORY_NO — NUMBER — NOT NULL
  • VIEW_YN — CHAR(1) — NOT NULL
  • DEL_YN — CHAR(1)
  • STORE_NO — NUMBER — NOT NULL
  • FOOD_IMG — VARCHAR2(1000)

FOOD_MENU_CATEGORY

  • NO — NUMBER
  • NAME — VARCHAR2(60) — NOT NULL
  • VIEW_YN — CHAR(1) — NOT NULL
  • DEL_YN — CHAR(1)
  • STORE_NO — NUMBER — Foreign key → STORE_INFOR.NO — NOT NULL

GENERATION

  • NO — NUMBER
  • GENERATION — VARCHAR2(30) — NOT NULL

LOCAL_NAME

  • NO — NUMBER
  • ZONE_NUMBER — NUMBER — NOT NULL
  • ADDRESS — VARCHAR2(50) — NOT NULL

MEMBER_ADMIN

  • NO — NUMBER
  • ID — VARCHAR2(10) — NOT NULL
  • PWD — VARCHAR2(10) — NOT NULL
  • DEL_YN — CHAR(1) — NOT NULL

MEMBER_STORE_OWNER

  • NO — NUMBER
  • ID — VARCHAR2(10) — NOT NULL
  • PWD — VARCHAR2(10) — NOT NULL
  • NAME — VARCHAR2(30) — NOT NULL
  • PHONE — CHAR(11) — NOT NULL
  • DEL_YN — CHAR(1)
  • COMPANY_RESITRATION_NUMBER — CHAR(11) — NOT NULL
  • PROFILE — VARCHAR2(1000) — NOT NULL

MEMBER_USER

  • NO — NUMBER
  • NICK — VARCHAR2(30) — NOT NULL
  • ID — VARCHAR2(10) — NOT NULL
  • PWD — VARCHAR2(10) — NOT NULL
  • NAME — VARCHAR2(30) — NOT NULL
  • ADDRESS — VARCHAR2(60) — NOT NULL
  • ADDRESS_DETAIL — VARCHAR2(60) — NOT NULL
  • PHONE — CHAR(11) — NOT NULL
  • ACCOUNT_BALANCE — NUMBER — NOT NULL
  • DEL_YN — CHAR(1)
  • N)) — NOT — NOT NULL
  • GENDER — CHAR(6) — NOT NULL
  • PROFILE — VARCHAR2(60) — NOT NULL
  • GENERATION — NUMBER — Foreign key → GENERATION.NO — NOT NULL

ORDER_DETAIL

  • NO — NUMBER
  • FOOD_COUNT — NUMBER — NOT NULL
  • FOOD_PRICE — NUMBER — NOT NULL
  • ORDER_NO — NUMBER — Foreign key → ORDER_SHEET.NO — NOT NULL
  • FOOD_NO — NUMBER — Foreign key → FOOD_INFOR.NO — NOT NULL

ORDER_SHEET

  • NO — NUMBER
  • REQUEST_MSG — VARCHAR2(50)
  • TOTAL_ORDER_PAY — NUMBER — NOT NULL
  • ORDER_DAY — DATE — NOT NULL
  • ADDRESS — VARCHAR2(50) — NOT NULL
  • STORE_NO — NUMBER — Foreign key → STORE_INFOR.NO — NOT NULL
  • USER_NO — NUMBER — Foreign key → MEMBER_USER.NO — NOT NULL
  • STATUS_NO — NUMBER — Foreign key → ORDER_STATUS.NO — NOT NULL
  • DELIVERY_PROBLEM — NUMBER — Foreign key → DELIVERY_PROBLEM.NO

ORDER_STATUS

  • NO — NUMBER
  • STATUS — VARCHAR2(15) — NOT NULL

REVIEW_COMMUNICATION

  • NO — NUMBER
  • ORDER_NO — NUMBER — Foreign key → ORDER_SHEET.NO — NOT NULL
  • RATING — NUMBER — NOT NULL
  • USER_CONTENT — VARCHAR2(50)
  • STORE_CONTENT — VARCHAR2(50)
  • IMG — VARCHAR2(200)
  • ENROLL_DATE — TIMESTAMP
  • DEL_YN — CHAR(1)
  • N)) — NOT — NOT NULL

STAMP

  • NO — NUMBER
  • STORE_NO — NUMBER — Foreign key → STORE_INFOR.NO — NOT NULL
  • MEMBER_USER_NO — NUMBER — Foreign key → MEMBER_USER.NO — NOT NULL

STORE_CATEGORY

  • NO — NUMBER
  • NAME — VARCHAR2(20) — NOT NULL

STORE_DELIVERY_ZONE

  • ZONE_NO — NUMBER — Foreign key → DELIVERY_ZONE.NO
  • STORE_NO — NUMBER — Foreign key → STORE_INFOR.NO

STORE_INFOR

  • NO — NUMBER
  • NAME — VARCHAR2(60) — NOT NULL
  • ADDRESS — VARCHAR2(60) — NOT NULL
  • ADDRESS_DETAIL — VARCHAR2(60) — NOT NULL
  • BUSINESS_REGISTRATION_CERTIFICATE_IMG — VARCHAR2(1000)
  • INTRODUCTION_IMG — VARCHAR2(1000)
  • INTRODUCE — VARCHAR2(50)
  • MAIN_IMG — VARCHAR2(1000) — NOT NULL
  • PHONE — CHAR(14)
  • MINIMUM_ORDER_AMOUNT — NUMBER
  • VIEWED_CNT — NUMBER
  • OPEN_TIME — DATE — NOT NULL
  • END_TIME — DATE — NOT NULL
  • BREAK_TIME_START — DATE
  • BREAK_TIME_END — DATE
  • STORE_OWNER_NO — NUMBER — NOT NULL
  • STORE_CATEGORY_NO — NUMBER — NOT NULL
  • APPROVAL_STATUS_NO — NUMBER — NOT NULL