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