cheese_erd

Tables (3)

Untitled (orders)

  • Key (order_no) — NOT NULL — Primary key — NOT NULL
  • Field (buy_count) — NULL
  • Field (total_price) — NULL
  • user_id — NOT NULL — Foreign key → users.user_id — NOT NULL
  • Key (cheese_id) — NOT NULL — Foreign key → Untitled.Key — NOT NULL

Untitled (cheeses)

  • Key (cheese_id) — NOT NULL — Primary key — NOT NULL
  • Field (ranking) — NULL
  • Field (category) — NULL
  • Field (brand) — NULL
  • Field (name) — NULL
  • Field (content) — NULL
  • Field (texture) — NULL
  • Field (types) — NULL
  • Field (price) — NULL
  • Field (img) — NULL

users

  • user_id — NOT NULL — Primary key — NOT NULL
  • password — NULL
  • name — NULL
  • Field (gender) — NULL
  • Field (age) — NULL
  • Field (phone) — NULL
  • Field (email) — NULL