qqqq
Tables (16)
Product_cart
- cart_ID — CHAR(10) — Primary key — NOT NULL
- product_ID — CHAR(10)
Untitled
- Key — VARCHAR(255) — Primary key — NOT NULL
color
- color_id — CHAR(10) — Primary key — NOT NULL
- color — CHAR(10)
coupon
- coupon_id — CHAR(20) — Primary key — NOT NULL
- discount_price — CHAR(6)
- user_id — VARCHAR(20) — NOT NULL
event
- event_id — CHAR(15) — Primary key — NOT NULL
- event_name — CHAR(20)
exchange
- exchange_id — CHAR(10) — Primary key — NOT NULL
- exchange_issue — VARCHAR(100)
- oder_id — CHAR(10) — NOT NULL
main_category
- main_category_id — CHAR(10) — Primary key — NOT NULL
- category — VARCHAR(100)
product
- product_id — CHAR(10) — Primary key — NOT NULL
- product_name — VARCHAR(100)
- desc — VARCHAR(100)
- product_price — INT
- thumnail_image — VARCHAR(100)
- isSoldout — TINYINT(1)
- cart_ID — CHAR(10) — NOT NULL
- sub_category — CHAR(10) — NOT NULL
- proudctTag — CHAR(5) — NOT NULL
productTag
- proudctTag — CHAR(5) — Primary key — NOT NULL
- TagName — CHAR(10)
- product_id — CHAR(10) — NOT NULL
product_detail
- product_detail_id — CHAR(10) — Primary key — NOT NULL
- season — VARCHAR(100)
- gender — VARCHAR(100)
- size — CHAR(4)
- brand — VARCHAR(100)
- origin — VARCHAR(100)
- stock — INT
- color — CHAR(10)
- product_id — CHAR(10) — NOT NULL
product_like
- producLike_id — CHAR(10) — Primary key — NOT NULL
- grade — VARCHAR(100)
- review — VARCHAR(100)
- like — INT
- isdiscount — CHAR(4)
- discount — INT
- ranking — INT
- sales_rate — CHAR(8)
- product_id2 — CHAR(10) — NOT NULL
product_order
- product_id — CHAR(10) — NOT NULL
- oder_id — CHAR(10) — NOT NULL
recipe
- oder_id — CHAR(10) — Primary key — NOT NULL
- delivery — CHAR(5)
- invoice_number — VARCHAR(100)
- address — VARCHAR(30)
- delivery_company — CHAR(10)
- user_id — VARCHAR(20) — NOT NULL
- cart_ID — VARCHAR(20) — NOT NULL
refund
- refund_id — CHAR(10) — Primary key — NOT NULL
- refund_issue — VARCHAR(100)
- product_photo — VARCHAR(100)
- isphoto — TINYINT(1)
- oder_id — VARCHAR(20) — NOT NULL
sub_category
- sub_category — CHAR(10) — Primary key — NOT NULL
- sub_category_name — VARCHAR(100)
- main_category_id — CHAR(10) — NOT NULL
user
- user_id — VARCHAR(20) — Primary key — NOT NULL
- user_pw — VARCHAR(30)
- user_email — VARCHAR(40)
- user_phone — CHAR(13)
- user_address — VARCHAR(100)
- user_personal — CHAR(15)
- nickname — CHAR(10)
- profile_photo — VARCHAR(100)
- photo_check — TINYINT
- first_message — VARCHAR(100)