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