중고나라 test2

테이블 (13)

answerBoard

  • answerBoardNumber — NUMBER — 기본 키 — NOT NULL
  • quNumber — NUMBER — 외래 키 → questionBoard.quNumber — NOT NULL
  • memberNumber — NUMBER — 외래 키 → questionBoard.memberNumber — NOT NULL
  • anContent — VARCHAR2(500)

board

  • bno — VARCHAR(255) — 기본 키 — NOT NULL
  • memberNumber2 — NUMBER — 외래 키 → member.memberNumber — NOT NULL
  • commentNumber — NUMBER — 외래 키 → commentList.commentNumber — NOT NULL
  • title — VARCHAR2(500) — NOT NULL
  • content — VARCHAR2(1000) — NOT NULL
  • regdate — DATE
  • viewcnt — NUMBER — NOT NULL

commentList

  • commentNumber — NUMBER — 기본 키 — NOT NULL
  • memberNumber — NUMBER — 외래 키 → member.memberNumber — NOT NULL
  • productNumber — NUMBER — 외래 키 → product.productNumber — NOT NULL
  • commentContent — VARCHAR2(50) — NOT NULL

interiorReview

  • reviewNumber — NUMBER — 기본 키 — NOT NULL
  • memberNumber — NUMBER — 외래 키 → member.memberNumber — NOT NULL
  • reviewTitle — VARCHAR2(50) — NOT NULL
  • reviewContent — VARCHAR2(500) — NOT NULL
  • reviewPhoto — VARCHAR2(50) — NOT NULL
  • reviewCount — NUMBER — NOT NULL
  • reviewDate — DATE — NOT NULL

likey

  • likeLike — NUMBER — 기본 키 — NOT NULL
  • memberNumber — NUMBER — 외래 키 → member.memberNumber — NOT NULL
  • productNumber — NUMBER — 외래 키 → product.productNumber — NOT NULL

marketPlace

  • marketPlaceNum — NUMBER — 기본 키 — NOT NULL
  • memberNumber — NUMBER — 외래 키 → member.memberNumber — NOT NULL
  • productNumber — NUMBER — 외래 키 → product.productNumber — NOT NULL
  • buyerNumber — NUMBER — NOT NULL
  • productName — VARCHAR2(50) — NOT NULL
  • productPrice — NUMBER — NOT NULL

member

  • memberNumber — NUMBER — 기본 키 — NOT NULL
  • memberName — VARCHAR2(20) — NOT NULL
  • memberId — VARCHAR2(20) — NOT NULL
  • memberPw — VARCHAR2(20) — NOT NULL
  • memberTel — VARCHAR2(15) — NOT NULL
  • memberAddress — VARCHAR2(100) — NOT NULL
  • memberNickname — VARCHAR2(30) — NOT NULL
  • memberGrade — NUMBER(1) — NOT NULL
  • memberProfile — VARCHAR2(50)
  • memberPoint — NUMBER — NOT NULL

message

  • message — NUMBER — 기본 키 — NOT NULL
  • memberNumber — NUMBER — 외래 키 → member.memberNumber — NOT NULL
  • messageSender — VARCAHR2(30) — NOT NULL
  • messageTitle — VARCHAR2(30) — NOT NULL
  • messageContent — VARCHAR2(500) — NOT NULL
  • messageDate — DATE — NOT NULL

orderHistory

  • ordernumber — NUMBER — 기본 키 — NOT NULL
  • memberNumber — NUMBER — 외래 키 → member.memberNumber — NOT NULL
  • productNumber — NUMBER — 외래 키 → product.productNumber — NOT NULL
  • categoryNumber — NUMBER — 외래 키 → product.categoryNumber — NOT NULL
  • memberNumber2 — NUMBER — 외래 키 → product.memberNumber — NOT NULL
  • productpicture — VARCHAR2(50) — NOT NULL
  • orderdate — DATE — NOT NULL
  • productprice — NUMBER — NOT NULL
  • Field — VARCHAR(255)

product

  • productNumber — NUMBER — 기본 키 — NOT NULL
  • categoryNumber — NUMBER — 외래 키 → productCategory.categoryNumber — NOT NULL
  • memberNumber — NUMBER — 외래 키 → member.memberNumber — NOT NULL
  • productTitle — VARCHAR2(50) — NOT NULL
  • productPrice — NUMBER — NOT NULL
  • productText — VARCHAR2(500) — NOT NULL
  • productName — VARCHAR2(50) — NOT NULL
  • productPictureNameURL — VARCHAR2(50) — NOT NULL
  • productCount — NUMBER — NOT NULL
  • productDate — DATE — NOT NULL

productCategory

  • categoryNumber — NUMBER — 기본 키 — NOT NULL
  • categoryName — VARCHAR2(50) — NOT NULL

questionBoard

  • quNumber — NUMBER — 기본 키 — NOT NULL
  • memberNumber — NUMBER — 외래 키 → member.memberNumber — NOT NULL
  • noticeNumber — NUMBER — NOT NULL
  • quTitle — VARCHAR2(50) — NOT NULL
  • quContent — VARCHAR2(500) — NOT NULL
  • quType — NUMBER — NOT NULL

reviewLike

  • reviewLike — NUMBER — 기본 키 — NOT NULL
  • memberNumber — NUMBER — 외래 키 → member.memberNumber — NOT NULL
  • reviewNumber — NUMBER — 외래 키 → interiorReview.reviewNumber — NOT NULL