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