project

Tables (13)

chat_message

  • message_id — INT — Primary key — NOT NULL — 메시지 ID
  • post_id — INT — Foreign key → study_post.post_id — NOT NULL — 스터디 ID
  • sender_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL — 발신자 ID
  • content — TEXT — NOT NULL — 내용
  • sent_at — DATETIME — NOT NULL — 전송시각

chat_read_status

  • read_id — INT — Primary key — NOT NULL — 읽음 ID
  • message_id — INT — Foreign key → chat_message.message_id — NOT NULL — 메시지 ID
  • user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL — 회원 ID
  • is_read — BOOLEAN — NOT NULL — 읽음여부

common_tag

  • tag_id — INT — Primary key — NOT NULL — 태그 고유 ID
  • tag_name — VARCHAR(50) — NOT NULL — 태그 이름
  • tag_type — VARCHAR(50) — NOT NULL — 태그 유형

notification

  • notification_id — INT — Primary key — NOT NULL — 알림 ID
  • receiver_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL — 수신자 ID
  • type — ENUM(SYSTEM, CHAT, APPLICATION_STATUS, REVIEW_REMINDER) — NOT NULL — 알림유형
  • content — TEXT — 내용
  • is_read — BOOLEAN — NOT NULL — 읽음여부
  • created_at — DATETIME — 생성일시

peer_review

  • review_id — INT — Primary key — NOT NULL — 평가 ID
  • post_id — INT — Foreign key → study_post.post_id — NOT NULL — 공고ID
  • reviewer_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL — 평가자 ID
  • reviewee_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL — 피평가자 ID
  • contribution_score — TINYINT — NOT NULL — 기여도 점수(1-5)
  • communication_score — TINYINT — 소통 능력 점수(1-5)
  • time_compliance_score — TINYINT — 시간 준수 점수(1-5)
  • diligence_score — TINYINT — 성실도 점수(1-5)
  • reviewed_at — DATETIME — NOT NULL — 평가일시

post_tag

  • post_tag_id — INT — Primary key — NOT NULL — 공고 태그 ID
  • post_id — INT — Foreign key → study_post.post_id — NOT NULL — 공고 ID
  • tag_id — INT — Foreign key → common_tag.tag_id — NOT NULL — 태그 ID

shared_file

  • file_id — INT — Primary key — NOT NULL — 파일 ID
  • message_id — INT — Foreign key → chat_message.message_id — NOT NULL — 메시지 ID
  • uploader_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL — 업로더 ID
  • file_name — VARCHAR(255) — NOT NULL — 파일명
  • file_path — VARCHAR(255) — NOT NULL — 파일경로
  • created_at — DATETIME — NOT NULL — 업로드일시

study_member

  • member_id — INT — Primary key — NOT NULL — 멤버 관리 ID
  • post_id — INT — Foreign key → study_post.post_id — NOT NULL — 공고 ID
  • user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL — 회원 ID
  • role — ENUM(LEADER, MEMBER) — NOT NULL — 역할
  • status — ENUM(PENDING, ACCEPTED, REJECTED, WITHDRAWN, KICKED) — NOT NULL — 참여상태
  • status_updated_at — DATETIME — NOT NULL — 상태변경일

study_post

  • post_id — INT — Primary key — NOT NULL — 공고 ID
  • leader_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL — 팀장 ID
  • title — VARCHAR(255) — NOT NULL — 제목
  • content — TEXT — NOT NULL — 상세내용
  • max_participants — INT — NOT NULL — 모집인원
  • post_status — ENUM(RECRUITING, IN_PROGRESS, COMPLETED, CANCELLED) — NOT NULL — 모집상태
  • created_at — DATETIME — NOT NULL — 등록일시
  • updated_at — DATETIME — NOT NULL — 수정일시

user

  • user_id — VARCHAR(50) — Primary key — NOT NULL — 아이디
  • pw — VARCHAR(255) — NOT NULL — 비밀번호
  • name — VARCHAR(50) — NOT NULL — 이름
  • gender — ENUM(M, F) — 성별
  • birth_date — DATE — NOT NULL — 생년월일
  • phone — VARCHAR(20) — NOT NULL — 휴대폰 번호
  • nickname — VARCHAR(50) — NOT NULL — 닉네임
  • profile_image — VARCHAR(255) — 프로필사진
  • email — VARCHAR(100) — NOT NULL — 이메일
  • address — VARCHAR(255) — 주소
  • completed_studies — INT — NOT NULL — 스터디완수 횟수
  • penalty_count — INT — NOT NULL — 패널티 횟수
  • reliability_score — INT — NOT NULL — 신뢰지수
  • status — ENUM(ACTIVE, SUSPENDED, WITHDRAWN) — NOT NULL — 회원상태
  • created_at — DATETIME — NOT NULL — 가입일시

user_available_time

  • time_id — INT — Primary key — NOT NULL — 시간 설정 ID
  • user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL — 회원 ID
  • day_of_week — ENUM(MON, TUE, WED, THU, FRI, SAT, SUN) — NOT NULL — 요일
  • start_time — TIME — NOT NULL — 시작 시간
  • end_time — TIME — NOT NULL — 종료 시간

user_report

  • report_id — INT — Primary key — NOT NULL — 신고 ID
  • reporter_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL — 신고자 ID
  • target_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL — 피신고자 ID
  • reason_type — ENUM(ABUSE, INSINCERITY, SPAM, INAPPROPRIATE_CONTENT, OTHER) — NOT NULL — 신고사유
  • reason_detail — TEXT — 상세내용
  • created_at — DATETIME — 신고일시

user_tech_stack

  • user_tech_id — INT — Primary key — NOT NULL — 유저 기술 ID
  • user_id — VARCHAR(50) — Foreign key → user.user_id — NOT NULL — 회원 ID
  • tag_id — INT — Foreign key → common_tag.tag_id — NOT NULL — 태그 ID