ssafy2
Tables (7)
Untitled (product)
- Key (id) — INTEAGER — Primary key — NOT NULL
- Field (name) — VARCHAR(32)
- Field (detail) — TEXT
- Field (price) — INTEAGER
Untitled (order)
- Key (id) — INTEAGER — Primary key — NOT NULL
- Key (user_id) — VARCHAR(32) — Foreign key → user.Key — NOT NULL
- Key (address_id) — INTEAGER — Foreign key → Untitled.Key — NOT NULL
- Field (date) — INTEAGER
Untitled (cart)
- Key (id) — INTEAGER — Primary key — NOT NULL
- Key (product_id) — INTEAGER — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — VARCHAR(32) — Foreign key → user.Key — NOT NULL
- Field (count) — INTEAGER
Untitled (order_detail)
- Key (id) — INTEAGER — Primary key — NOT NULL
- Key (order_id) — INTEAGER — Foreign key → Untitled.Key — NOT NULL
- Key (product_id) — INTEAGER — Foreign key → Untitled.Key — NOT NULL
- Field (count) — INTEAGER
Untitled (address)
- Key (id) — INTEAGER — Primary key — NOT NULL
- Key (user_id) — VARCHAR(32) — Foreign key → user.Key — NOT NULL
- Field (addr) — VARCHAR(32)
- Field (name) — VARCHAR(32)
Untitled (grade)
- Key (id) — INTEAGER — Primary key — NOT NULL
- Field (name) — VARCHAR(32)
- Field (rate) — INTEAGER
user
- Key (id) — VARCHAR(32) — Primary key — NOT NULL
- Key (grade_id) — INTEAGER — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(32)
- Field (pw) — VARCHAR(32)