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