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