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