study

Tables (16)

Chat_Participant (채팅목록)

  • 참여ID (participant_id) — BIGINT — Primary key — NOT NULL
  • 맴버ID (member_id) — BIGINT — Foreign key → Member.맴버ID — NOT NULL
  • 채팅ID (chat_id) — BIGINT — Foreign key → Chat_room.채팅ID — NOT NULL
  • 방ID (room_id) — BIGINT — Foreign key → Chat_room.방ID — NOT NULL
  • 방장ID (leader_id) — BIGINT — Foreign key → Chat_room.방장ID — NOT NULL

Chat_image (채팅 파일)

  • 이미지ID (image_id) — BIGINT — Primary key — NOT NULL
  • 메시지ID (message_id) — BIGINT — Foreign key → Chat_message.메시지ID — NOT NULL
  • 채팅ID (chat_id) — BIGINT — Foreign key → Chat_message.채팅ID — NOT NULL
  • 방ID (room_id) — BIGINT — Foreign key → Chat_message.방ID — NOT NULL
  • 멤버ID (member_id) — BIGINT — Foreign key → Chat_message.맴버ID — NOT NULL
  • 이미지 (image) — VARCHAR
  • 삭제 (is_deleted) — BOOL
  • 생성날짜 (created_at) — TIMESTAMP
  • 수정날짜 (updated_at) — TIMESTAMP
  • 삭제날짜 (deleted_at) — TIMESTAMP

Chat_message (메시지)

  • 메시지ID (message_id) — BIGINT — Primary key — NOT NULL
  • 채팅ID (chat_id) — BIGINT — Foreign key → Chat_room.채팅ID — NOT NULL
  • 방ID (room_id) — BIGINT — Foreign key → Chat_room.방ID — NOT NULL
  • 맴버ID (member_id) — BIGINT — Foreign key → Chat_room.방장ID — NOT NULL
  • 메시지 (message) — TEXT
  • 삭제 (is_deleted) — BOOL
  • 생성날짜 (created_at) — TIMESTAMP
  • 수정날짜 (updated_at) — TIMESTAMP
  • 삭제날짜 (deleted_at) — TIMESTAMP

Chat_room (채팅방)

  • 채팅ID (ID) — BIGINT — Primary key — NOT NULL
  • 방ID (room_id) — BIGINT — Foreign key → StudyRoom.방ID — NOT NULL
  • 방장ID (leader_id) — BIGINT — Foreign key → StudyRoom.맴버ID — NOT NULL
  • 이름 (name) — VARCHAR
  • 생성날짜 (created_at) — TIMESTAMP
  • 수정날짜 (updated_at) — TIMESTAMP

Comment (댓글)

  • 댓글 ID (id) — BIGINT — Primary key — NOT NULL
  • 게시판 ID (post_id) — BIGINT — Foreign key → Post.게시판 ID — NOT NULL
  • 맴버ID (member_id) — BIGINT — Foreign key → Post.맴버ID — NOT NULL
  • 내용 (content) — TEXT
  • 삭제 (is_deleted) — BOOL
  • 작성일 (created_at) — TIMESTAMP
  • 수정날짜 (updated_at) — TIMESTAMP
  • 삭제날짜 (deleted_at) — TIMESTAMP

File (파일)

  • 파일 ID (id) — BIGINT — Primary key — NOT NULL
  • 게시판 ID (post_id) — BIGINT — Foreign key → Post.게시판 ID — NOT NULL
  • 맴버ID (member_id) — BIGINT — Foreign key → Post.맴버ID — NOT NULL
  • 파일 (file) — VARHCAR
  • 삭제 (is_deleted) — BOOL
  • 업로드 (created_at) — TIMESTAMP
  • 수정날짜 (updated_at) — TIMESTAMP
  • 삭제날짜 (deleted_at) — TIMESTAMP

Interest (관심분야)

  • 관심ID (ID) — BIGINT — Primary key — NOT NULL
  • 맴버ID (member_id) — BIGINT — Foreign key → Member.맴버ID — NOT NULL
  • 언어 (language) — VARCHAR
  • 생성날짜 (created_at) — TIMESTAMP
  • 수정날짜 (updated_at) — TIMESTAMP

Like (좋아요)

  • 좋아요 ID (id) — BIGINT — Primary key — NOT NULL
  • 게시판 ID (post_id) — BIGINT — Foreign key → Post.게시판 ID — NOT NULL
  • 맴버ID (member_id) — BIGINT — Foreign key → Post.맴버ID — NOT NULL
  • 생성날짜 (created_at) — TIMESTAMP

Member (회원)

  • 맴버ID (ID) — BIGINT — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR
  • 비밀번호 (password) — VARCHAR
  • 닉네임 (nickname) — VARCHAR
  • 프로필사진 (profile) — VARCHAR
  • 알림설정 (push) — BOOL
  • 자기소개 (introduce) — TEXT
  • 역할 (role) — ENUM
  • 계정삭제 (is_deleted) — BOOL
  • 가입일 (created_at) — TIMESTAMP
  • 수정날짜 (updated_at) — TIMESTAMP
  • 삭제날짜 (deleted_at) — TIMESTAMP

Member_Activity (맴버 활동)

  • 로그ID (id) — BIGINT — Primary key — NOT NULL
  • 맴버ID (ID) — BIGINT — Foreign key → Member.맴버ID — NOT NULL
  • 활동 종류 (activity_type) — VARCHAR
  • 설명 (description) — TEXT
  • 생성날짜 (created_at) — TIMESTAMP

Notification (알림)

  • 알림ID (Id) — BIGINT — Primary key — NOT NULL
  • 맴버ID (member_id) — BIGINT — Foreign key → Member.맴버ID — NOT NULL
  • 제목 (title) — VARCHAR
  • 내용 (content) — TEXT
  • 읽음 (read) — BOOL
  • 생성날짜 (created_at) — TIMESTAMP

Participants (참가자)

  • 참가자ID (participant_id) — BIGINT — Primary key — NOT NULL
  • 방ID (room_id) — BIGINT — Foreign key → StudyRoom.방ID — NOT NULL
  • 방장ID (leader_id) — BIGINT — Foreign key → StudyRoom.맴버ID — NOT NULL
  • 맴버ID (member_id) — BIGINT — Foreign key → Member.맴버ID — NOT NULL
  • 역할 (role) — ENUM
  • 강퇴 (is_kicked) — BOOL
  • 가입일 (created_at) — TIMESTAMP
  • 수정날짜 (updated_at) — TIMESTAMP
  • 강퇴시간 (kicked_at) — TIMESTAMP

Post (게시판)

  • 게시판 ID (ID) — BIGINT — Primary key — NOT NULL
  • 맴버ID (member_id) — BIGINT — Foreign key → Member.맴버ID — NOT NULL
  • 종류 (kind) — VARCHAR
  • 제목 (title) — VARCHAR
  • 내용 (content) — TEXT
  • 조회수 (views) — BIGINT
  • 삭제 (is_deleted) — BOOL
  • 작성일 (created_at) — TIMESTAMP
  • 수정날짜 (updated_at) — TIMESTAMP
  • 삭제날짜 (deleted_at) — TIMESTAMP

Schedule (일정)

  • 스케줄ID (ID) — BIGINT — Primary key — NOT NULL
  • 방ID (room_id) — BIGINT — Foreign key → StudyRoom.방ID — NOT NULL
  • 맴버ID (member_id) — BIGINT — Foreign key → StudyRoom.맴버ID — NOT NULL
  • 시작 (start_time) — TIMESTAMP
  • 끝 (end_time) — TIMESTAMP
  • 취소 (is_cancel) — BOOL
  • 내용 (description) — TEXT
  • 생성날짜 (created_at) — TIMESTAMP
  • 수정날짜 (updated_at) — TIMESTAMP
  • 취소날짜 (canceled_at) — TIMESTAMP

StudyRoom (스터디방)

  • 방ID (room_id) — BIGINT — Primary key — NOT NULL
  • 맴버ID (leader_id) — BIGINT — Foreign key → Member.맴버ID — NOT NULL
  • 방 이름 (room_name) — VARCHAR
  • 내용 (description) — TEXT
  • 최대 인원수 (max_member) — INTEGER
  • 삭제 (is_deleted) — BOOL
  • 생성날짜 (created_at) — TIMESTAMP
  • 수정날짜 (updated_at) — TIMESTAMP
  • 삭제날짜 (deleted_at) — TIMESTAMP

attendance (출석)

  • 출석ID (attendance_id) — BIGINT — Primary key — NOT NULL
  • 참가자ID (participants_id) — BIGINT — Foreign key → Participants.참가자ID — NOT NULL
  • 방ID (room_id) — BIGINT — Foreign key → Participants.방ID — NOT NULL
  • 방장ID (leader_id) — BIGINT — Foreign key → Participants.방장ID — NOT NULL
  • 맴버ID (member_id) — BIGINT — Foreign key → Participants.맴버ID — NOT NULL
  • 출석상태 (status) — ENUM
  • 출석날짜 (attendance_date) — TIMESTAMP
  • 출석시간 (created_at) — TIMESTAMP