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