StudyMate

Tables (9)

Attendance (Untitled7)

  • PK (attendance_id) — BIGINT — Primary key — NOT NULL
  • FK (session_id) — BIGINT — Foreign key → Attendance_session.PK — NOT NULL
  • FK (study_member_id) — BIGINT — Foreign key → Study_Member.PK — NOT NULL
  • 출석상태 (status) — ENUM('PRESENT','LATE','ABSENT')
  • 출석체크일시 (checked_at) — TIMESTAMP

Attendance_session (Untitled5)

  • PK (session_id) — BIGINT — Primary key — NOT NULL
  • FK (study_id) — BIGINT — Foreign key → Study.PK — NOT NULL
  • 제목 (title) — VARCHAR(100)
  • 날짜 (session_date) — DATE
  • 생성일 (created_at) — TIMESTAMP

Category (Untitled4)

  • PK (category_id) — INT — Primary key — NOT NULL
  • 이름 (name) — VARCHAR(50)

Comment (Untitled9)

  • PK (comment_id) — BIGINT — Primary key — NOT NULL
  • FK (post_id) — BIGINT — Foreign key → Post.PK — NOT NULL
  • FK (author_id) — BIGINT — Foreign key → User.PK — NOT NULL
  • 댓글내용 (content) — TEXT
  • 작성일시 (created_at) — TIMESTAMP

Post (Untitled8)

  • PK (post_id) — BIGINT — Primary key — NOT NULL
  • FK (study_id) — BIGINT — Foreign key → Study.PK — NOT NULL
  • FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
  • 게시글유형 (type) — ENUM('NOTICE','ASSIGNMENT','GENERAL')
  • 게시글제목 (title) — VARCHAR(200)
  • 본문 (content) — TEXT
  • 작성일 (created_at) — TIMESTAMP
  • 수정일 (updated_at) — TIMESTAMP

Study (Untitled2)

  • PK (study_id) — BIGINT — Primary key — NOT NULL
  • FK (category_id) — INT — Foreign key → Category.PK — NOT NULL
  • FK (leader_id) — BIGINT — Foreign key → User.PK — NOT NULL
  • 제목 (title) — VARCHAR(50)
  • 설명 (description) — TEXT
  • 스터디모집상태 (status) — ENUM('모집중','모집완료','종료')
  • 최대인원 (max_members) — INT
  • 시작일 (start_date) — DATE
  • 종료일 (end_date) — DATE
  • 스터디형태 (meeting_type) — ENUM('온라인','오프라인')
  • 생성일 (created_at) — TIMESTAMP

Study_Member (Untitled3)

  • PK (study_member_id) — BIGINT — Primary key — NOT NULL
  • FK (study_id) — BIGINT — Foreign key → Study.PK — NOT NULL
  • FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
  • 역할 (role) — ENUM('리더','멤버')
  • 참여일 (joined_at) — TIMESTAMP

Study_application (Untitled6)

  • PK (application_id) — BIGINT — Primary key — NOT NULL
  • FK (user_id) — BIGINT — Foreign key → User.PK — NOT NULL
  • FK (study_id) — BIGINT — Foreign key → Study.PK — NOT NULL
  • 신청메시지 (message) — TEXT
  • 신청상태 (status) — ENUM('PENDING','APPROVED','REJECTED')
  • 신청일시 (created_at) — TIMESTAMP

User (Untitled)

  • PK (user_id) — BIGINT — Primary key — NOT NULL
  • 닉네임 (nickname) — VARCHAR(50)
  • 비밀번호 (password) — VARCHAR(100)
  • 이메일 (email) — VARCHAR(100)
  • 생성일 (created_at) — DATETIME
  • 수정일 (modified_at) — DATETIME
  • 이름 (name) — VARCHAR(50)
  • 권한 (role) — ENUM('USER','ADMIN')