sns + chat

Tables (13)

Untitled

    chat_message (채팅메시지)

    • id — Primary key — NOT NULL
    • content (내용)
    • chat_rood_id (채팅방ID) — Foreign key → chat_room.Key — NOT NULL
    • member_id (멤버ID) — Foreign key → member.id — NOT NULL

    chat_participant (채팅참여자)

    • Key (id) — Primary key — NOT NULL
    • member_id (멤버ID) — Foreign key → member.id — NOT NULL
    • chat_room_id (채팅방ID) — Foreign key → chat_room.Key — NOT NULL

    chat_room (채팅방)

    • Key (id) — Primary key — NOT NULL
    • isGroupChat (오픈채팅여부) — NOT NULL
    • Field

    comment (댓글)

    • id — Primary key — NOT NULL
    • post (게시물)
    • comment_parent (부모코멘트)
    • comment_childs (자식코멘트)
    • updated_at (content) — NOT NULL
    • member (댓글작성자) — Foreign key → member.id — NOT NULL

    comment_vote (댓글투표(좋아요/싫어요))

    • id — Foreign key → vote_base.id — NOT NULL
    • comment (투표한 댓글) — Foreign key → comment.id — NOT NULL

    follow (팔로우)

      member (회원)

      • id — Primary key — NOT NULL
      • name (이름)
      • email (이메일)
      • password (패스워드) — NOT NULL
      • created_at (만들어진 때)
      • updated_at (업데이트된 때)

      message_read_status (메시지읽음)

      • id — Primary key — NOT NULL
      • isRead (읽음여부) — NOT NULL
      • chat_message_id (메시지ID) — Foreign key → chat_message.id — NOT NULL
      • chat_room_id (채팅방ID) — Foreign key → chat_room.Key — NOT NULL
      • member_id (멤버ID(메시지보낸사람)) — Foreign key → member.id — NOT NULL

      post (게시물)

      • id — Primary key — NOT NULL
      • title (제목) — NOT NULL
      • content (내용) — NOT NULL
      • like_count (좋아요) — NOT NULL
      • dislike_count (싫어요) — NOT NULL
      • edited (수정여부) — NOT NULL
      • comment)count (댓글 개수)
      • post_media_list (포스트미디어리스트)
      • created_at (만들어진때) — NOT NULL
      • updated_at (업데이트된때)
      • id (member) — Foreign key → member.id — NOT NULL

      post_media (포스트 미디어)

        post_vote (게시글투표(좋아요/싫어요))

        • id — Foreign key → vote_base.id — NOT NULL
        • post (투표게시글) — Foreign key → post.id — NOT NULL

        vote_base (투표베이스)

        • id — Primary key — NOT NULL
        • member (투표자) — NOT NULL
        • vote_type (투표타입(좋아요/싫어요)) — NOT NULL
        • created_at (만들어진때) — NOT NULL
        • updated_at (업데이트된 때)