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)