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)