24단풍톤
테이블 (8)
게시물 (feed)
- feed_id (Key) — 기본 키 — NOT NULL
- member_id (기본키) — 외래 키 → 회원.member_id — NOT NULL
- title (Field)
- content (Field2)
- hashtag (Field3) — array
- image (Field4)
- created_at (Field5)
- updated_at (Field6)
- status (Field7)
게시물 좋아요 (feedlike)
- feedlike_id (Key) — 기본 키 — NOT NULL
- member_id (기본키) — 외래 키 → 회원.member_id — NOT NULL
- feed_id (Key2) — 외래 키 → 게시물.feed_id — NOT NULL
- created_at (Field5)
- updated_at (Field6)
- status (Field7)
댓글 (comment)
- comment_id (Key) — 기본 키 — NOT NULL
- feed_id (Key2) — 외래 키 → 게시물.feed_id — NOT NULL
- member_id (기본키) — 외래 키 → 게시물.member_id — NOT NULL
- content (Field2)
- created_at (Field5)
- updated_at (Field6)
- status (Field7)
랭킹 (ranking)
- ranking (Key) — 기본 키 — NOT NULL
- member_id (기본키) — 외래 키 → 회원.member_id — NOT NULL
- streakrank (Field)
- likerank (Field2)
- likecount (Field6)
- streakcount (Field7)
- created_at (Field3)
- updated_at (Field4)
- status (Field5)
신고 (declearation)
- declearation_id (Key) — 기본 키 — NOT NULL
- title (Field)
- content (Field2)
알림 (alarm)
- alarm_id (Key) — 기본 키 — NOT NULL
- member_id (기본키) — 외래 키 → 회원.member_id — NOT NULL
- content (Field)
채팅 (chatting)
- chatting_id (Key) — 기본 키 — NOT NULL
- member_id (기본키) — 외래 키 → 회원.member_id — NOT NULL
- title (Field2)
- created_at (Field)
- updated_at (Field3)
회원 (member)
- member_id (기본키) — 기본 키 — NOT NULL
- email (Field2) — String
- name (Field5)
- picture (Field6)
- nationality (Field7)
- introduction (Field8)
- school (Field9)
- streak (Field10)
- hassolved (Field11) — enum값으로
- created_at (Field3)
- updated_at (Field4)
- status (Field) — enum