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