unicorn

Tables (12)

Untitled

  • coupon — varchar2(20) — Primary key — NOT NULL
  • Field — VARCHAR(255)

Untitled2

  • product_no — int — Foreign key → product.product_no — NOT NULL
  • user_no — int — Foreign key → user.user_no — NOT NULL

cart

  • cart_no — varchar2(10) — Primary key — NOT NULL
  • product_no — int — Foreign key → product.product_no — NOT NULL
  • user_no — int — Foreign key → user.user_no — NOT NULL
  • option_no — varchar2(10) — Foreign key → product_option.option_no — NOT NULL
  • Field — VARCHAR(255)

event

  • event_no — varchar2(20) — Primary key — NOT NULL
  • event_title — varchar2(1000)
  • event_details — varchar2(1000)
  • event_start — date
  • event_end — date
  • event_dc — int

inquiry

  • inquiry_no — varchar2(20) — Primary key — NOT NULL
  • user_no — int — Foreign key → user.user_no — NOT NULL
  • product_no — int — Foreign key → product.product_no — NOT NULL
  • inquiry_title — varchar2(500)
  • inquiry_details — varchar2(3000)
  • inquiry_date — date

notice

  • notice_no — varchar2(30) — Primary key — NOT NULL
  • notice_title — varchar2(1000)
  • notice_details — varchar2(3000)
  • notice_date — date

order

  • order_no — varchar2(30) — Primary key — NOT NULL
  • user_no2 — int — Foreign key → user.user_no — NOT NULL
  • product_no — int — Foreign key → product.product_no — NOT NULL
  • option_no — varchar2(10) — Foreign key → product_option.option_no — NOT NULL
  • order_quantity — int
  • order_address — VARCHAR(255)
  • order_status — varchar2(20)
  • invoice_no — varchar2(20)

product

  • product_no — int — Primary key — NOT NULL
  • event_no — varchar2(20) — Foreign key → event.event_no — NOT NULL
  • product_name — varchar2(30)
  • product_ex — varchar2(200)
  • main_img1 — varchar2(1000)
  • main_img2 — varchar2(1000)
  • main_img3 — varchar2(1000)
  • fabric — varchar2(30)
  • company — varchar2(30)

product_img

  • imgdetails_no — varchar2(3000) — Primary key — NOT NULL
  • product_no — int — Foreign key → product.product_no — NOT NULL
  • img — varchar2(3000)
  • imgNo — int

product_option

  • option_no — varchar2(10) — Primary key — NOT NULL
  • product_no — int — Foreign key → product.product_no — NOT NULL
  • size — varchar2((8)
  • price — int
  • count — int

review

  • review_no — varchar2(20) — Primary key — NOT NULL
  • user_no — int — Foreign key → user.user_no — NOT NULL
  • product_no — int — Foreign key → product.product_no — NOT NULL
  • review_date — date
  • review_img — varchar2(1000) — NOT NULL
  • review_details — varchar2(2000)

user

  • user_no — int — Primary key — NOT NULL
  • id — varchar2(10)
  • pw — varchar2(20)
  • name — varchar2(10)
  • address — varchar2(100)
  • address_details — varchar2(100)
  • postCode — int
  • tel — int
  • email — varchar2(20)
  • point — int
  • grade — int