semi

Tables (6)

BOARD

  • NO — NUMBER — Primary key — NOT NULL — 게시글번호
  • USER_ID — VARCHAR2(10) — Foreign key → MEMBER.USER_ID — NOT NULL — 아이디
  • TITLE — VARCHAR2(20) — NOT NULL — 게시글제목
  • CONTENT — VARCHAR2(250) — NOT NULL — 내용
  • REG_DATE — DATE — NOT NULL — 게시날짜
  • VIEW_COUNT — NUMBER — 조회수

COMMENTS

  • COMMENT_NO — NUMBER — Primary key — NOT NULL — 댓글번호
  • NO — NUMBER — Foreign key → BOARD.NO — NOT NULL — 게시글번호
  • USER_ID — VARCHAR2(10) — Foreign key → MEMBER.USER_ID — NOT NULL — 아이디
  • COMMENT_CONTENT — VARCHAR2(100) — NOT NULL — 댓글내용
  • COMMENT_DATE — DATE — NOT NULL — 댓글작성날짜

MEMBER

  • USER_ID — VARCHAR2(10) — Primary key — NOT NULL — 아이디
  • EMAIL — VARCHAR2(25) — NOT NULL — 이메일
  • PASSWORD — VARCHAR2(12) — NOT NULL — 비밀번호
  • NAME — VARCHAR2(15) — NOT NULL — 이름
  • PHONE — VARCHAR2(11) — 연락처
  • IS_LEAVE — NUMBER — NOT NULL — 탈퇴여부

RECIPE

  • RCP_SEQ — NUMBER — Primary key — NOT NULL — 일련번호
  • RCP_NM — VARCHAR2(100) — NOT NULL — 메뉴명
  • RCP_WAY2 — VARCHAR2(10) — NOT NULL — 조리방법
  • RCP_PAT2 — VARCHAR2(10) — NOT NULL — 요리종류
  • INFO_ENG — NUMBER — NOT NULL — 열량
  • INFO_CAR — NUMBER — NOT NULL — 탄수화물
  • INFO_PRO — NUMBER — NOT NULL — 단백질
  • INFO_FAT — NUMBER — NOT NULL — 지방
  • INFO_NA — NUMBER — NOT NULL — 나트륨
  • ATT_FILE_NO_MAIN — VARCHAR2(100) — 이미지경로(소)
  • ATT_FILE_NO_MK — VARCHAR2(100) — 이미지경로(대)
  • RCP_PARTS_DTLS — VARCHAR2(1000) — NOT NULL — 재료정보
  • MANUAL01 — VARCHAR2(500) — 만드는법01
  • MANUAL02 — VARCHAR2(500) — 만드는법02
  • MANUAL_IMG01 — VARCHAR2(500) — 만드는법_이미지_1
  • MANUAL_IMG02 — VARCHAR2(500) — 만드는법_이미지_2

REVIEW

  • REVIEW_NO — NUMBER — Primary key — NOT NULL — 댓글번호
  • RCP_SEQ — NUMBER — Foreign key → RECIPE.RCP_SEQ — NOT NULL — 일련번호
  • USER_ID — VARCHAR2(10) — Foreign key → MEMBER.USER_ID — NOT NULL — 아이디
  • REVIEW_CONTENTS — VARCHAR2(100) — NOT NULL — 댓글내용
  • REVIEW_DATE — DATE — NOT NULL — 댓글작성날짜

SCRAP

  • SCR_INDEX — NUMBER — Primary key — NOT NULL — 인덱스
  • USER_ID — VARCHAR2(10) — Foreign key → MEMBER.USER_ID — NOT NULL — 아이디
  • RCP_SEQ — NUMBER — Foreign key → RECIPE.RCP_SEQ — NOT NULL — 일련번호