sns 기원

테이블 (5)

Article (게시글)

  • id — type — 기본 키 — NOT NULL
  • user_id — type — 외래 키 → User.user_id — NOT NULL
  • title — char, blank =True
  • content — text
  • hashtag — ManytoManyfield
  • like — ManyToManyfield
  • view — integer
  • delete_flag
  • created_at — core-datetime
  • modified_at — core-datetime

Hashtag (해시태그)

  • id — type — 기본 키 — NOT NULL
  • hashtag — char

Hashtag (해시태그 중간 테이블)

  • id — type — 기본 키 — NOT NULL
  • hashtag_id — type — 외래 키 → Hashtag.id — NOT NULL
  • article_id — type — 외래 키 → Article.id — NOT NULL

Like (좋아요 중간테이블)

  • article_id — type — 외래 키 → Article.id — NOT NULL
  • user_id — type — 외래 키 → User.user_id — NOT NULL

User (사용자)

  • user_id — type — 기본 키 — NOT NULL
  • email — email, unique=True
  • password — char
  • name — char, unique=True
  • created_at — core- datetime
  • modified_At (modified_at) — core-datetime