imf

Tables (8)

CATEGORY

  • 카테고리 (CATEGORY) — VARCHAR2(30) — Primary key — NOT NULL

COMMENTS

  • RC_NUM — NUMBER — Primary key — NOT NULL
  • RC_CONTENT — VARCHAR2(80) — NOT NULL
  • RC_DATE — DATE — NOT NULL
  • R_NUM — NUMBER — Foreign key → REVIEW.R_NUM — NOT NULL
  • R_TITLE — VARCHAR2(30) — NOT NULL
  • U_NUM — NUMBER — Foreign key → USER.U_NUM — NOT NULL
  • U_ID — VARCHAR2(30) — NOT NULL

COMPANY

  • C_NUM — NUMBER — Primary key — NOT NULL
  • 카테고리 (CATEGORY) — VARCHAR2(30) — Foreign key → CATEGORY.카테고리 — NOT NULL
  • C_NAME — VARCHAR2(30) — NOT NULL
  • C_RMENU — VARCHAR2(30) — NOT NULL
  • C_TEL — NUMBER
  • C_AVG_P — NUMBER

HONEY

  • H_NUM — NUMBER — Primary key — NOT NULL
  • H_TITLE — VARCHAR2(30) — NOT NULL
  • H_CONTENT — VARCHAR2(3000) — NOT NULL
  • H_RECOMMEND — NUMBER
  • C_NUM — NUMBER — Foreign key → COMPANY.C_NUM — NOT NULL
  • C_NAME — VARCHAR2(30) — NOT NULL
  • U_NUM — NUMBER — Foreign key → USER.U_NUM — NOT NULL
  • U_ID — VARCHAR2(30) — NOT NULL

MENU

  • M_NUM — NUMBER — Primary key — NOT NULL
  • M_NAME — VARCHAR2(30) — NOT NULL
  • M_PRICE — NUMBER — NOT NULL
  • M_INFO — VARCHAR2(500) — NOT NULL
  • M_OPT — VARCHAR2(500)
  • M_ING — VARCHAR2(500)
  • C_NUM — NUMBER — Foreign key → COMPANY.C_NUM — NOT NULL
  • C_NAME — VARCHAR2(30) — NOT NULL

RECOMMAND

  • G_NUM — NUMBER — Primary key — NOT NULL
  • H_NUM — NUMBER — Foreign key → HONEY.H_NUM — NOT NULL
  • R_NUM — NUMBER — Foreign key → REVIEW.R_NUM — NOT NULL
  • U_NUM — NUMBER — Foreign key → USER.U_NUM — NOT NULL
  • U_ID — VARCHAR2(30) — NOT NULL

REVIEW

  • R_NUM — NUMBER — Primary key — NOT NULL
  • R_TITLE — VARCHAR2(30) — NOT NULL
  • R_CONTENT — VARCHAR2(3000) — NOT NULL
  • R_IMG — VARCHAR2(300)
  • R_DATE — DATE — NOT NULL
  • R_RATING — NUMBER
  • R_RECOMMEND — NUMBER
  • M_NUM — NUMBER — Foreign key → MENU.M_NUM — NOT NULL
  • M_NAME — VARCHAR2(30) — NOT NULL
  • U_NUM — NUMBER — Foreign key → USER.U_NUM — NOT NULL
  • U_ID — VARCHAR2(30) — NOT NULL

USER

  • U_NUM — NUMBER — Primary key — NOT NULL
  • U_ID — VARCHAR2(30) — NOT NULL
  • U_PWD — VARCHAR2(300) — NOT NULL
  • U_NAME — VARCHAR2(10) — NOT NULL
  • U_BIRTH — DATE — NOT NULL
  • U_GENDER — CHAR(2) — NOT NULL
  • U_PHONE — NUMBER — NOT NULL
  • EMAIL — VARCHAR2(100) — NOT NULL
  • ADDRESS — VARCHAR2(300)
  • Interests — VARCHAR2(30)
  • AVG_PNUM — NUMBER
  • HINT_Q — NUMBER
  • HINT_A — VARCHAR2(30)