SecondHands
Tables (6)
Untitled (zh_users)
- Key (id) — int — Primary key — NOT NULL
- Field (username) — string
- Field2 (password) — string
- Field (name) — string
- Field (sex) — string
- Field (phone_number) — string
Untitled (zh_user_address)
- Key (id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (postal_code) — string
- Field (road_name_address) — string
- Field (land_number_address) — string
- Field (detailed_address) — string
- Field (refernce) — string
Untitled (zh_basket)
- Key (id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (product_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field2 (count) — int
Untitled (zh_product)
- Key (id) — int — Primary key — NOT NULL
- Field (product_name) — string
- Field (product_image) — string
- Field (product_description) — string
- Field (product_price) — int
- Field (product_quantity) — int
- Field (product_etc) — string
- Field (product_type) — string
Untitled (zh_product_review)
- Key (id) — int — Primary key — NOT NULL
- Key (product_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (review_content) — string
- Field (review_count) — int
Untitled (zh_order)
- Key (id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (product_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (total_price) — int