판다마켓

테이블 (4)

comments

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • product_id — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

likes

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • product_id — INTEGER — NOT NULL
  • created_at — TIMESTAMP
  • UNIQUE(user_id, — product_id)

products

  • id — SERIAL
  • user_id — INTEGER — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • price — DECIMAL(19, 2) — NOT NULL
  • created_at — TIMESTAMP

users

  • id — SERIAL
  • nickname — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP