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 — 일련번호