쿠팡
테이블 (7)
Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (Reward)
- userID (reward_ID) — 기본 키 — NOT NULL
- userID (review_ID) — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled.userID — NOT NULL
- userID — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled.userID — NOT NULL
- Field (points)
- Field (review)
- Field (review_date)
- Email (review_text)
- Name (rating)
- Field (coupon)
Copy Of Copy Of Copy Of Copy Of Untitled (Review)
- userID (review_ID) — 기본 키 — NOT NULL
- userID — 외래 키 → Users.userID — NOT NULL
- Field (product_ID)
- Field (payment_ID)
- Field (order_ID)
- Field (comment)
- Field (submitted_date)
Copy Of Copy Of Copy Of Copy Of Untitled2 (Payment)
- userID (payment_ID) — 기본 키 — NOT NULL
- userID (order_ID) — 외래 키 → Copy Of Copy Of Untitled.userID — NOT NULL
- product_ID — 외래 키 → Copy Of Copy Of Untitled.product_ID — NOT NULL
- Field (order_id)
- Field (payment_method)
- Name (transaction_date)
- Email (transaction_status)
Copy Of Copy Of Copy Of Untitled (Delivery)
- userID (delivery_ID) — 기본 키 — NOT NULL
- userID (payment_ID) — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled2.userID — NOT NULL
- userID (order_ID) — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled2.userID — NOT NULL
- product_ID — 외래 키 → Copy Of Copy Of Copy Of Copy Of Untitled2.product_ID — NOT NULL
- Field (tracking_number)
- Name (carrier)
- Email (status)
- Field (estimated_delivery_date)
Copy Of Copy Of Untitled (Orders)
- userID (order_ID) — 기본 키 — NOT NULL
- product_ID — 외래 키 → Products.product_ID — NOT NULL
- Field (userID)
- Field (order_date)
- Name (total_amount)
- Email (order_status)
Products
- product_ID — 기본 키 — NOT NULL
- userID — 외래 키 → Users.userID — NOT NULL
- brand
- category
- description
- Email (product_name)
- Field (selller_id)
- Phone Number (price)
- Field2 (stock_quantity)
Users
- userID — 기본 키 — NOT NULL
- name
- Name (email)
- Phone Number (phone_number)
- Field2 (address)
- Field (identifcation_number)
- (signup_date)