backend_erd
Tables (4)
favorites
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- product_id — BIGINT — Foreign key → products.id — NOT NULL
product_images
- id — BIGINT
- product_id — BIGINT — Foreign key → products.id — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
products
- id — BIGINT
- seller_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- price — INT — NOT NULL
- platform — VARCHAR(30) — NOT NULL
- status — VARCHAR(20)
- created_at — TIMESTAMP
users
- id — BIGINT
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP