JBeans

Tables (5)

TBL_MEMBER (Untitled)

  • MEMBER_ID — VARCHAR2 — Primary key — NOT NULL
  • MEMBER_PW — VARCHAR2
  • MEMBER_EMAIL — VARCHAR2
  • MEMBER_ADDR — VARCHAR2
  • MEMBER_PHONE — VARCHAR2
  • MEMBER_NAME — VARCHAR2
  • MEMBER_LIKECNT — NUMBER

TBL_RECIPE_BOARD (Untitled2)

  • R_BOARD_NUM — NUMBER — Primary key
  • MEMBER_ID (R_M_FK) — VARCHAR2 — Foreign key → TBL_MEMBER.MEMBER_ID — NOT NULL
  • R_BOARD_TITLE — VARCHAR2
  • R_BOARD_CONTENT — VARCHAR2
  • R_BOARD_DATE — VARCHAR2
  • R_BOARD_LIKECNT — NUMBER
  • R_BOARD_TAG — VARCHAR2

TBL_RECIPE_REPLY (Untitled3)

  • R_REPLY_NUM — NUMBER — Primary key
  • R_BOARD_NUM — NUMBER — Foreign key → TBL_RECIPE_BOARD.R_BOARD_NUM
  • R_REPLY_CONTENT — VARCAHAR2

TBL_SHARE_BOARD (Untitled4)

  • SH_BOARD_NUM — NUMBER — Primary key
  • MEMBER_ID — VARCHAR2 — Foreign key → TBL_MEMBER.MEMBER_ID — NOT NULL
  • SH_BOARD_TITLE — VARCHAR2
  • SH_BOARD_CONTENT — VARCHAR2
  • SH_BOARD_DATE — VARCHAR2
  • SH_BOARD_LIKECNT — NUMBER

TBL_SHARE_REPLY (Untitled5)

  • SH_REPLY_NUM — NUMBER — Primary key
  • SH_BOARD_NUM (SH_BOARD_NUM2) — NUMBER — Foreign key → TBL_SHARE_BOARD.SH_BOARD_NUM
  • SH_REPLY_CONTENT — VARCHAR2