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