projecterd
Tables (10)
Untitled (item)
- Key (item_id) — Primary key — NOT NULL
- Field (dtype)
- Field (name)
- Field (price)
- Field2 (stock)
- Field (image)
- Field (content)
- Field (isbn)
- Field (author)
- Field (brand)
Untitled (orders)
- Key (order_id) — Primary key — NOT NULL
- member_id — Foreign key → member.member_id — NOT NULL
- Field (receiver_name)
- Field (receiver_phone)
- Field (receiver_address)
- Field (date)
- Field (status)
- Field (merchant_uid)
Untitled (order_item)
- Key (order_item_id) — Primary key — NOT NULL
- Key (order_id) — Foreign key → Untitled.Key — NOT NULL
- Key (item_id) — Foreign key → Untitled.Key — NOT NULL
- Field3 (orderprice)
- Field (count)
- Field (review_check)
Untitled (coupon)
- Key (coupon_id) — Primary key — NOT NULL
- Field (name)
- Field (discount)
- Field (type)
Untitled (delivery)
- Key (delivery_id) — Primary key — NOT NULL
- Key (order_id) — Foreign key → Untitled.Key — NOT NULL
- Field (address)
- Field2 (status)
Untitled (cart)
- Key (cart_id) — Primary key — NOT NULL
- member_id — Foreign key → member.member_id — NOT NULL
Untitled (cart_item)
- Key (cart_item_id) — Primary key — NOT NULL
- Key (cart_id) — Foreign key → Untitled.Key — NOT NULL
- Key (item_id) — Foreign key → Untitled.Key — NOT NULL
- Field (price)
- Field (count)
Untitled (member_coupon)
- Key (member_coupon_id) — Primary key — NOT NULL
- member_id — Foreign key → member.member_id — NOT NULL
- Key (coupon_id) — Foreign key → Untitled.Key — NOT NULL
- Field (count)
Untitled (review)
- Key (review_id) — Primary key — NOT NULL
- member_id — Foreign key → member.member_id — NOT NULL
- Key (item_id) — Foreign key → Untitled.Key — NOT NULL
- Key (order_item_id) — Foreign key → Untitled.Key — NOT NULL
- Field (date)
- Field2 (title)
- Field (content)
member
- member_id — Primary key — NOT NULL
- (email)
- (pwd)
- (name)
- (phone)
- Field (address)
- (type)
- Field (date)
- Field2 (grade)
- Field (sum_price)