StudyMate
Tables (9)
Group (study)
- id — bigint — Primary key — NOT NULL
- id (admin_id) — bigint — Foreign key → Member.id — NOT NULL
- name — varchar — NOT NULL
- Field (description) — text
- Field (created_at) — datetime — NOT NULL
- Field (max_members) — int — NOT NULL
- Field (current_members) — int — NOT NULL
- Field (status) — varchar(30) — NOT NULL
- Field (is_private) — bit(1) — NOT NULL
Member (member)
- id — bigint — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- Field (password) — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL — unique
- Field (email_verified) — bit(1) — NOT NULL — 0 -> 비인증 1 -> 인증
- Field (role) — varchar — NOT NULL — 자바에서 enum으로 처리 (user, admin)
- Field (status) — varchar — NOT NULL — ACTIVE(활성), INACTIVE(비활성), DELETED(탈퇴)
- Field2 (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime
- Field (deleted_at) — datetime
- Field (profile_image) — varchar(255)
- Field (phone_number) — varchar(20)
- Field (oauth_id) — varchar(255) — OAuth 로그인에서 받은 고유 ID
Untitled (oauth_provider)
- Key (id) — bigint — Primary key — NOT NULL
- id (member_id) — bigint — Foreign key → Member.id — NOT NULL
- Field (provider_name) — varchar(50) — NOT NULL
Untitled (apply)
- Key (id) — bigint — Primary key — NOT NULL
- id (member_id) — bigint — Foreign key → Member.id — NOT NULL
- id (study_id) — bigint — Foreign key → Group.id — NOT NULL
- Field (status) — varchar(10) — NOT NULL — 대기(PENDING), 승인(APPROVED), 거절(REJECTED)
- Field (created_at) — datetime — NOT NULL — CURRENT_TIMESTAMP
- Field (updated_at) — datetime — 상태가 변경된 날짜
Untitled (study_meeting)
- Key (id) — bigint — Primary key — NOT NULL
- id (study_id) — bigint — Foreign key → Group.id — NOT NULL
- Field (start_time) — datetime — NOT NULL
- Field (end_time) — datetime — NOT NULL
- Field (title) — varchar(100) — NOT NULL
- Field (description) — text
Untitled (post)
- Key (id) — bigint — Primary key — NOT NULL
- id (member_id) — bigint — Foreign key → Member.id — NOT NULL
- id (study_id) — bigint — Foreign key → Group.id — NOT NULL
- Field (title) — varchar(255) — NOT NULL
- Field2 (content) — text — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime
Untitled (comment)
- Key (id) — bigint — Primary key — NOT NULL
- id (member_id) — bigint — Foreign key → Member.id — NOT NULL
- Key (post_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (content) — text — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime
Untitled (notify)
- Key (id) — bigint — Primary key — NOT NULL
- id (member_id) — bigint — Foreign key → Member.id — NOT NULL
- Field (related_id) — bigint — NOT NULL
- Field (type) — varchar(50) — NOT NULL — 알림 유형(신청, 게시글, 미팅, 댓글) apply, new_post, new_metting, new_comment
- Field (content) — text — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (delated_at) — datetime — 일정 기간 후 삭제
Untitled (file)
- Key (id) — bigint — Primary key — NOT NULL
- Field (related_id) — bigint — NOT NULL
- Field (type) — varchar(50) — NOT NULL — 자바에서 Enum으로 처리 회원프로필( PROFILE), 게시글(POST), 스터디(STUDY)
- Field (url) — varchar(255) — NOT NULL
- Field (filename) — varchar(255) — NOT NULL
- Field (file_size) — bigint — NOT NULL — 파일 크기 (bytes)
- Field (file_type) — varchar(50) — NOT NULL
- Field (uploaded_at) — datetime — NOT NULL