how-yogo
Tables (8)
COCOMMENT
- COMID (COCOMMENT_COMID) — NUMBER(6) — Primary key — NOT NULL
- C_NUM — NUMBER(6) — Foreign key → COMMUNITY.C_NUM — NOT NULL
- NICKNAME (MEMBER_NICKNAME) — VARCHAR2(50) — Foreign key → MEMBER.MEMBERID — NOT NULL
- CO_PARENTID (COMMUNITY_NUM) — NUMBER(6) — Foreign key → COMMUNITY.C_NUM
- CO_CONTENT (COCOMMENT_CONTENT) — VARCHAR2(500) — NOT NULL
- CO_POSTDATE (COCOMMENT_POSTDATE) — DATE — NOT NULL
COMMUNITY
- C_NUM (COMMUNITY_NUM) — NUMBER(6) — Primary key — NOT NULL
- NICKNAME (MEMBER_NICKNAME) — VARCHAR2(50) — Foreign key → MEMBER.MEMBERID — NOT NULL
- C_TITLE (COMMUNITY_TITLE) — VARCAHR2(100) — NOT NULL
- C_CONTENT (COMMUNITY_CONTENT) — VARCHAR2(1000) — NOT NULL
- C_POSTDATE (COMMUNITY_POSTDATE) — DATE — NOT NULL
- C_EDITDATE (COMMUNITY_EDITDATE) — DATE
- C_IMGONAME (COMMUNITY_IMGONAME) — VARCHAR2(255)
- C_IMGSNAME (COMMUNITY_IMGSNAME) — VARCHAR2(255)
- C_LIKECOUNT (COMMUNITY_LIKECOUNT) — NUMBER — NOT NULL
- C_PWD (COMMUNITY_PWD) — VARCHAR2(10) — NOT NULL
- C_HITS (COMMUNITY_HITS) — NUMBER — NOT NULL
- C_CATEGORY (COMMUNITY_CATEGORY) — VARCHAR2(10) — NOT NULL
MEMBER
- MEMBERID (MEMBER_ID) — VARCHAR2(20) — Primary key — NOT NULL
- NICKNAME (MEMBER_NICKNAME) — VARCHAR2(50) — NOT NULL
- EMAIL (MEMBER_EMAIL) — VARCHAR2(30) — NOT NULL
- MPWD (MEMBER_MPWD) — VARCHAR2(20) — NOT NULL
- REGDATE (MEMBER_REGDATE) — DATE — NOT NULL
- EDITDATE (MEMBER_EDITDATE) — DATE
- imgSrc (MEMBER_imgSrc) — VARCHAR2(255)
- IMGSNAME (MEMBER_IMGSNAME) — VARCHAR2(255)
NOTICE
- NNUM (NOTICE_NNUM) — NUMBER — Primary key — NOT NULL
- WRITER (NOTICE_WRITER) — VARCHAR2(50) — NOT NULL
- NTITLE (NOTICE_NTITLE) — VARCHAR2(100) — NOT NULL
- NPWD (NOTICE_NPWD) — VARCHAR2(20) — NOT NULL
- NCONTENT (NOTICE_NCONTENT) — VARCHAR2(1000) — NOT NULL
- IMGSNAME (NOTICE_IMGSNAME) — VARCHAR2(255)
- IMGONAME (NOTICE_IMGONAME) — VARCHAR2(255)
- POSTDATE (NOTICE_POSTDATE) — DATE — NOT NULL
- EDITDATE (NOTICE_EDITDATE) — DATE
- HITS (NOTICE_HITS) — NUMBER — NOT NULL
RECIPE
- RECIPEID (RECIPEBOARD_ID) — NUMBER(6) — Foreign key → RECIPEBOARD.RECIPEID — NOT NULL
- RECIPESTEP (RECIPE_STEP) — NUMBER(2) — NOT NULL
- STEPCONTENT — VARCHAR2(1000) — NOT NULL
- IMGONAME — VARCHAR2(255) — NOT NULL
- IMGSNAME — VARCHAR2(255) — NOT NULL
RECIPEBOARD
- RECIPEID (RECIPEBOARD_ID) — NUMBER(6) — Primary key — NOT NULL
- MEMBERID (MEMBER_NICKNAME) — VARCHAR2(20) — Foreign key → MEMBER.MEMBERID — NOT NULL
- RECIPETITLE (RECIPEBOARD_TITLE) — VARCHAR2(100) — NOT NULL
- INGREDIENTS (RECIPEBOARD_INGREDIENTS) — VARCHAR2(500) — NOT NULL
- POSTDATE (RECIPEBOARD_POSTDATE) — DATE — NOT NULL
- EDITDATE (RECIPEBOARD_EDITDATE) — DATE
- MAIN0NAME (RECIPEBOARD_MAINONAME) — VARCHAR2(255) — NOT NULL
- MAINSNAME (RECIPEBOARD_MAINSNAME) — VARCHAR2(255) — NOT NULL
- INONAME (RECIPEBOARD_INONAME) — VARCHAR2(255) — NOT NULL
- INSNAME (RECIPEBOARD_INSNAME) — VARCHAR2(255) — NOT NULL
- RECIPECATEGORY (RECIPEBOARD_CATEGORY) — VARCHAR2(10) — NOT NULL
- HITS (RECIPEBOARD_HITS) — NUMBER — NOT NULL
RECIPECOMMENT
- COMMENTID (RECIPECOMMENT_ID) — NUMBER(6) — Primary key — NOT NULL
- MEMBERID (MEMBER_ID) — VARCHAR2(20) — Foreign key → MEMBER.MEMBERID — NOT NULL
- RECIPEID (RECIPEBOARD_ID) — NUMBER(6) — Foreign key → RECIPEBOARD.RECIPEID — NOT NULL
- PARENTID (RECIPECOMMENT_ID2) — NUMBER(6) — Foreign key → RECIPECOMMENT.COMMENTID
- COMMENTCONTENT (RECIPECOMMENT_CONTENT) — VARCHAR2(500) — NOT NULL
- POSTDATE (RECIPECOMMENT_POSTDATE) — DATE — NOT NULL
RECIPELIKE
- LIKEID (RECIPELIKE_LIKEID) — NUMBER(6) — Primary key — NOT NULL
- MEMBERID (MEMBER_ID) — VARCHAR2(20) — Foreign key → MEMBER.MEMBERID — NOT NULL
- RECIPEID (RECIPEBOARD_ID) — NUMBER(6) — Foreign key → RECIPEBOARD.RECIPEID — NOT NULL
- POSTDATE (RECIPELIKE_POSTDATE) — DATE — NOT NULL