SoloProject
Tables (7)
BOARD
- BOARD_NO (게시판 번호) — NUMBER — Primary key — NOT NULL
- MEMBER_NO (맴버 번호) — NUMBER — Foreign key → Member.MEMBER_NO — NOT NULL
- BOARD_TITLE (글제목) — VARCHAR2(300)
- BAORD_CONTENT (글내용) — VARCHAR2(500)
- ATTACH_FILE (첨부 파일) — VARCHAR2(255)
- IMAGE (첨부 이미지) — VARCHAR2(255)
- BOARD_COUNT (게시글 추천수) — NUMBER
- BOARD_STATUS (게시글 상태) — VARCHAR2(5)
BOOK
- BOOK_NUMBER (책번호) — NUMBER — Primary key — NOT NULL
- BOOK_NAME (책이름) — VARCHAR2(100)
- BOOK_PRICE (책가격) — NUMBER
- BOOK_IMAGE (책이미지) — VARCHAR2(150)
- BOOK_AUTHOR (저자) — VARCHAR2(50)
- PUBLISHER (출판사) — VARCHAR2(50)
- BOOK_EXPLIAN (책설명) — VARCHAR2(300)
- BOOK_STATUSQ (책상태) — VARCHAR2(5)
CART
- CART_NO (카트 번호) — NUMBER — Primary key — NOT NULL
- BOOK_NUMBER (책번호) — NUMBER — Foreign key → BOOK.BOOK_NUMBER — NOT NULL
- MEMBER_NO (맴버 번호) — NUMBER — Foreign key → Member.MEMBER_NO — NOT NULL
- QUANTITY (수량) — NUMBER
ENQUIRY
- ENQUIRY_NO (문의글 번호) — NUMBER — Primary key — NOT NULL
- MEMBER_NO (맴버 번호) — NUMBER — Foreign key → Member.MEMBER_NO — NOT NULL
- ENQUIRY_TITLE (문의 제목) — VARCHAR2(300)
- ENQUIRY_CONTENT (문의 내용) — VARHAR2(500)
- ENQUIRY_STATUS (상태) — VARCHAR2(3)
Member
- MEMBER_NO (맴버 번호) — NUMBER — Primary key — NOT NULL
- MEMBER_NAME (이름) — VARCHAR2(50)
- MEMBER_EMAIL (이메일) — VARCHAR2(100)
- PHONE_NUMBER (폰번호) — VARCHAR2(100)
- ENROLL_DATE (가입일자) — DATE
- ADDRESS (주소) — VARCHAR2(100)
NOTICE
- NOTICE_NUMBER (공지글 번호) — NUMBER — Primary key — NOT NULL
- MEMBER_NO (맴버 번호) — NUMBER — Foreign key → Member.MEMBER_NO — NOT NULL
- NOTICE_TITLE (공지 제목) — VARCHAR2(300)
- NOTICE_CONTENT (공지 내용) — VARCHAR2(500)
REPLY
- REPLY_NO (댓글 번호) — NUMBER — Primary key — NOT NULL
- MEMBER_NO (맴버 번호) — NUMBER — Foreign key → Member.MEMBER_NO — NOT NULL
- BOARD_NO (게시판 번호) — NUMBER — Foreign key → BOARD.BOARD_NO — NOT NULL
- REPLY_CONTENT (댓글 내용) — VARCHAR2(500)
- REPLY_STATUS (댓글 상태) — VARCHAR2(50)