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')