Personal Project
Tables (12)
BOARD
- BoardNumber (Key) — number — Primary key — NOT NULL
- UserID (Field2) — varchar2(100) — NOT NULL — FK (MEMBER)
- Title (Field) — varchar2(100) — NOT NULL
- Content (Field3) — varchar2(400) — NOT NULL
- Hits (Field4) — number
- BoardImage (Field10) — varchar2(300)
- RegDate (Field5) — DATE
- NoticeYN (Field6) — number
BOARD_LIKE
- BoardLIkeNumber (Key) — number — Primary key — NOT NULL
- UserID (Field) — varchar2(100) — NOT NULL — FK (MEMBER)
- BoardNumber (Field2) — number — NOT NULL — FK (BOARD)
BOARD_REPLY
- RepNumber (Key) — number — Primary key — NOT NULL
- BoardNumber (Field) — number — NOT NULL — FK (BOARD)
- UserID (Field3) — varchar2(100) — NOT NULL — FK (MEMBER)
- ReplyContent (Field2) — varchar2(400)
- ReplyRegDate (Field4) — DATE
CART
- CartSeq (Key) — number — Primary key — NOT NULL — PK
- UserID (Field2) — varchar2(100) — NOT NULL — FK (MEMBER)
- ProductSeq (Field) — number — NOT NULL — FK(PRODUCT)
- CartQuantity (Field4) — number — NOT NULL
- CartResult (Field3) — number
- CartRegDate (Field5) — DATE
MEMBER
- UserID (Key) — varchar2(100) — Primary key — NOT NULL — PK
- PW (Field) — varchar2(100) — NOT NULL
- UserName (Field10) — varchar2(100) — NOT NULL
- Nickname (Field2) — varchar2(100) — NOT NULL — UNIQUE
- Male/Female (Field9) — number — NOT NULL
- E-mail (Field3) — varchar2(100) — NOT NULL
- Phone (Field6) — varchar2(100) — NOT NULL
- ZipCode (Field8) — number — NOT NULL
- Address1 (Field4) — varchar2(100) — NOT NULL
- Address2 (Field12) — varchar2(100)
- Profile (Field5) — varchar2(300)
- Registered Date (Field7) — DATE
- Dormant Status (Field11) — number
- Admin (Field13) — number
ORDER
- Order Seq (Key) — number — Primary key — NOT NULL — PK
- UserID (Field) — varchar2(100) — NOT NULL — FK (MEMBER)
- OrderRegDate (Field3) — date
- Zipcode (Field4) — number — NOT NULL
- Address1 (Field2) — varchar2(100) — NOT NULL
- Address2 (Field5) — varchar2(100) — NOT NULL
ORDER_DETAIL
- OrderDetailSeq (Key) — number — Primary key — NOT NULL — PK
- OrderSeq (Field) — number — NOT NULL — FK (ORDER)
- ProductSeq (Field2) — number — NOT NULL — FK (PRODUCT)
- ODQuantity (Field3) — number — NOT NULL
- ODResult (Field4) — number
PRODUCT
- ProductSeq (Key) — number — Primary key — NOT NULL — PK
- ProductName (Field) — varchar2(300) — NOT NULL
- Kind (Field5) — varchar2(100) — NOT NULL — electric & acoustic & amp & acc
- Price1 (Field2) — number — NOT NULL
- Price2 (Field6) — number — NOT NULL
- Price3 (Field7) — number — NOT NULL
- ProductContent (Field8) — varchar2(4000)
- ProductQuantity (Field3) — number — NOT NULL
- ProductImage (Field4) — varchar2(300)
- ProductRegDate (Field9) — date
- BestYN (Field10) — number
- SaleYN (Field11) — number
PRODUCT_COMMENT
- CommentNumber (Key) — number — Primary key — NOT NULL
- ProductSeq (Field3) — number — NOT NULL — FK (PRODUCT)
- UserID (Field) — varchar2(100) — NOT NULL — FK (MEMBER)
- CommentContent (Field2) — varchar2(4000)
- CommentReply (Field6) — varchar2(4000)
- CommentRegDate (Field4) — date
PRODUCT_REVIEW
- ReviewNumber (Key) — number — Primary key — NOT NULL
- ProductSeq (Field) — number — NOT NULL — FK (PRODUCT)
- UserID (Field2) — varchar2(100) — NOT NULL — FK (MEMBER)
- ReviewContent (Field3) — varchar2(4000)
- ReviewRegDate (Field4) — date
PRODUCT_WISH
- WishNumber (Key) — number — Primary key — NOT NULL
- UserID (Field) — varchar2(100) — NOT NULL — FK (MEMBER)
- ProductSeq (Field2) — number — NOT NULL — FK (PRODUCT)
QNA
- QnaSeq (Key) — number — Primary key — NOT NULL
- UserID (Field3) — varchar2(100) — NOT NULL — FK (MEMBER)
- QnaTitle (Field4) — varchar2(100) — NOT NULL
- QnaContent (Field5) — varchar2(400) — NOT NULL
- QnaReply (Field) — varchar2(400)
- QnaResult (Field2) — number
- QnaRegDate (Field6) — date