test
Tables (8)
MEMBER_ADDRESS
- ADDRESS_ID — NUMBER — Primary key — NOT NULL
- MEMBER_ID — NUMBER — NOT NULL
- ADR — VARCHAR2(255)
- REG_DATE — DATE
MENU
- MENU_ID — NUMBER — Primary key — NOT NULL
- STORE_ID — NUMBER — NOT NULL
- CATEGORY — VARCHAR2(255)
- NAME — VARCHAR2(255)
- PRICE — NUMBER(8)
- URL — BLOB
MENU_OPTION
- OPTION_ID — NUMBER — Primary key — NOT NULL
- MENU_ID — NUMBER — NOT NULL
- OPTION_NAME — VARCHAR2(255)
- PRICE — NUMBER(8)
- STATUS — VARCHAR2(10)
ORDER
- ORDER_ID — NUMBER — Primary key — NOT NULL
- STORE_ID — NUMBER — NOT NULL
- MEMBER_ID — NUMBER — NOT NULL
REVIEW
- REVIEW_ID — NUMBER — Primary key — NOT NULL
- MEMBER_ID — NUMBER — NOT NULL
- STORE_ID — NUMBER — NOT NULL
- MENU_ID — NUMBER — NOT NULL
- RATING — NUMBER(3.2)
- TEXT — CLOB
STORES
- STORE_ID — NUMBER — Primary key — NOT NULL
- STORE_NAME — VARCHAR2(255)
- STORE_ADR — VARCHAR2(255)
- MOBILE — VARCHAR2(255)
- ABOUT — LONG
- RATING — NUMBER(3.2)
- STORE_TYPE — VARCHAR2(255)
- CREATED — DATE
- UPDATED — DATE
- OPENTIME — DATE
TOTAL_ORDER
- ORDER_ID — NUMBER — Foreign key → ORDER.ORDER_ID — NOT NULL
- MENU_ID — NUMBER — Foreign key → MENU.MENU_ID — NOT NULL
- OPTION_ID — NUMBER — Foreign key → MENU_OPTION.OPTION_ID — NOT NULL
- PRICE — NUMBER(9)
member
- MEMBER_ID — NUMBER — Primary key — NOT NULL
- LOGIN_ID — VARCHAR2(255)
- LOGIN_PW — VARCHAR2(255)
- MOBLIE — VARCHAR2(255)
- NAME — VARCHAR2(255)
- ORIGINAL_ADR — VARCHAR2(255)
- REG_DATE — DATE
- STATUS — VARCHAR2(10)