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