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