TB_LIKE
Tables (4)
MCD_MENU (CopyOfUntitled2)
- WAITING_NAME (대기자) — VARCHAR2(20) — Primary key — NOT NULL
- MENU_NO (메뉴번호) — NUMBER — Primary key — NOT NULL
- MENU_NAME (메뉴이름) — VARCHAR2(20)
- PRICE (가격) — NUMBER
- RESTAURANT_CODE (매장코드) — NUMBER
- FOOD (음식여부) — CHAR(3)
- STARSCORE (음식평점) — NUMBER
RESTAURANT (Untitled3)
- RESTAURANT_NAME (매장이름) — VARCHAR2(20)
- RESTAURANT_CODE (매장코드) — VARCHAR2(20)
SURVEY (Untitled2)
- SURVEY_CODE (작성자번호) — NUMBER — Primary key — NOT NULL
- RESTAURANT_CODE (매장코드) — NUMBER — Primary key — NOT NULL
- SERVICE_LEVEL (서비스만족도) — NUMBER
- CLEAN_SCORE (매장청결도) — NUMBER
- IMPROVEMENT_POINTS (개선점) — VARCHAR2(50)
- SURVEY_WRITER (작성자) — VARCHAR2(20)
TB_LIKE (Untitled)
- MEM_NO (NUMBER) — Primary key — NOT NULL
- PRODUCT_NAME (VARCHAR2(10)) — Primary key — NOT NULL
- LIKE_DATE (DATE)