madcamp_failly

Tables (6)

Badge (Untitled2)

  • tag (해시태그) — NOT NULL — Primary key
  • badge_name (뱃지 이름) — NOT NULL
  • image_url (이미지 url) — NOT NULL

FailPost (Untitled)

  • id (게시물 id) — NOT NULL — Primary key — NOT NULL
  • user_id (유저 id) — NOT NULL — Foreign key → User.id — NOT NULL
  • tag (해시태그) — NOT NULL — Foreign key → Badge.tag
  • text (게시물 텍스트) — NOT NULL
  • image_id (클라우드 스토리지 이미지 id) — NOT NULL
  • created_at (created_At) — NOT NULL

FailpostReaction (Untitled4)

  • failpost_id (게시물 id) — NOT NULL — Foreign key → FailPost.id — NOT NULL
  • count (반응 개수) — NOT NULL
  • reaction_type (반응 종류) — NOT NULL — Foreign key → Reaction.reaction_type — NOT NULL

Reaction (Untitled5)

  • reaction_type (반응 종류) — NOT NULL — Primary key — NOT NULL
  • image_url (이미지 url) — NOT NULL

User

  • id (아이디) — NOT NULL — Primary key — NOT NULL
  • email (이메일) — NOT NULL
  • password (비밀번호) — NOT NULL
  • nickname (닉네임) — NOT NULL
  • created_at (created_At) — NOT NULL
  • current_tag (오늘 올린 게시물 태그) — NOT NULL

UserBadge (Untitled3)

  • tag (해시태그) — NOT NULL — Foreign key → Badge.tag
  • obtained_at (획득 시간) — NOT NULL
  • user_id (아이디) — NOT NULL — Foreign key → User.id — NOT NULL