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