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)