과제

테이블 (6)

bookmarks

  • user_id — INT — 외래 키 → users.id — NOT NULL
  • post_id — INT — 외래 키 → posts.id — NOT NULL
  • created_at — TIMESTAMP

comments

  • id — INT
  • post_id — INT — 외래 키 → posts.id — NOT NULL
  • user_id — INT — 외래 키 → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

post_tags

  • post_id — INT — 외래 키 → posts.id — NOT NULL
  • tag_id — INT — 외래 키 → tags.id — NOT NULL

posts

  • id — INT
  • user_id — INT — 외래 키 → users.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • description — TEXT
  • media_url — VARCHAR(500) — NOT NULL
  • media_type — VARCHAR(10) — NOT NULL
  • original_link — VARCHAR(500)
  • category — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

tags

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP

users

  • id — INT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20)
  • created_at — TIMESTAMP