unicorn1120

Tables (12)

cart

  • cartNo — varchar2(10) — Primary key — NOT NULL
  • productNo — int — Foreign key → product.productNo — NOT NULL
  • userNo — int — Foreign key → users.userNo — NOT NULL
  • optionNo — varchar2(10) — Foreign key → product_option.optionNo — NOT NULL
  • cartCount — int

coupon

  • couponNo — varchar2(20) — Primary key — NOT NULL
  • userNo — int — Foreign key → users.userNo — NOT NULL
  • couponDc — int

event

  • eventNo — varchar2(30) — Primary key — NOT NULL
  • eventTitle — varchar2(1000)
  • eventDetails — varchar2(1000)
  • eventStart — date
  • eventEnd — date
  • eventMainImg — varchar2(3000)

inquiry

  • inquiryNo — varchar2(20) — Primary key — NOT NULL
  • userNo — int — Foreign key → users.userNo — NOT NULL
  • productNo — int — Foreign key → product.productNo — NOT NULL
  • inquiryTitle — varchar2(500)
  • inquiryDetails — varchar2(3000)
  • inquiryDate — date

notice

  • noticeNo — varchar2(30) — Primary key — NOT NULL
  • noticeTitle — varchar2(1000)
  • noticeDetails — varchar2(3000)
  • noticeDate — date

orders

  • orderNo — varchar2(30) — Primary key — NOT NULL
  • userNo — int — Foreign key → users.userNo — NOT NULL
  • productNo — int — Foreign key → product.productNo — NOT NULL
  • optionNo — varchar2(10) — Foreign key → product_option.optionNo — NOT NULL
  • orderQuantity — int
  • orderAddress — varchar2(500)
  • orderStatus — varchar2(20)
  • invoiceNo — varchar2(20)
  • 결제가격 (totalprice) — int
  • 결제메시지 (message) — varchar2(1000)
  • 배송료 (deliveryFee) — int

product

  • productNo — int — Primary key — NOT NULL
  • productName — varchar2(30)
  • productEx — varchar2(200)
  • mainImg1 — varchar2(1000)
  • mainImg2 — varchar2(1000)
  • mainImg3 — varchar2(1000)
  • fabric — varchar2(30)
  • company — varchar2(30)
  • popularity — int
  • productPrice — int

product_img

  • imgdetailsNo — varchar2(3000) — Primary key — NOT NULL
  • productNo — int — Primary key — NOT NULL
  • img — varchar2(3000)
  • imgNo — int

product_option

  • optionNo — varchar2(10) — Primary key — NOT NULL
  • productNo — int — Foreign key → product.productNo — NOT NULL
  • productSize — varchar2((8)
  • price — int
  • inventoryCount — int

review

  • reviewNo — varchar2(20) — Primary key — NOT NULL
  • userNo — int — Foreign key → users.userNo — NOT NULL
  • productNo — int — Foreign key → product.productNo — NOT NULL
  • orderNo — varchar2(30) — Foreign key → orders.orderNo — NOT NULL
  • reviewDate — date
  • reviewImg — varchar2(1000) — NOT NULL
  • reviewDetails — varchar2(2000)
  • reviewrates — int

users

  • userNo — int — Primary key — NOT NULL
  • id — varchar2(10)
  • pw — varchar2(20)
  • name — varchar2(10)
  • address — varchar2(100)
  • addressDetails — varchar2(100)
  • postCode — int
  • tel — varchar2(100)
  • userPoint — int
  • grade — int
  • signupdate — date

wishlist

  • Key — varchar2(20) — Primary key — NOT NULL
  • productNo — int — Foreign key → product.productNo — NOT NULL
  • userNo — int — Foreign key → users.userNo — NOT NULL