중고나라 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