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