TMeRoom ERD v1

Tables (7)

Class (강의)

  • ID (id) — bigint — Primary key — NOT NULL
  • 관리자ID (manager_id) — varchar — Foreign key → Member.ID — NOT NULL
  • 강의명 (class_name) — varchar — NOT NULL

Comment (댓글)

  • ID (id) — bigint — Primary key — NOT NULL
  • 작성자ID (commenter_id) — varchar — Foreign key → Member.ID — NOT NULL
  • 질문ID (question_id) — bigint — Foreign key → Question.질문ID — NOT NULL
  • 내용 (content) — varchar — NOT NULL
  • 작성날짜 (created_at) — datetime — NOT NULL

File (파일)

  • ID (file_id) — bigint — Primary key — NOT NULL
  • 게시자ID (uploader_id) — varchar — Foreign key → Member.ID — NOT NULL
  • 강의ID (class_id) — bigint — Foreign key → Class.ID — NOT NULL
  • 파일링크 (file_link) — varchar — NOT NULL

Member (회원)

  • ID (member_id) — varchar — Primary key — NOT NULL
  • 비밀번호 (password) — varchar — NOT NULL
  • 닉네임 (nickname) — varchar — NOT NULL
  • 이메일 (email) — varchar — NOT NULL
  • 역할 (role) — varchar — NOT NULL

Question (질문)

  • 질문ID (id) — bigint — Primary key — NOT NULL
  • 작성자ID (author_id) — varchar — Foreign key → Member.ID — NOT NULL
  • 강의ID (class_id) — bigint — Foreign key → Class.ID — NOT NULL
  • 제목 (title) — varchar — NOT NULL
  • 내용 (content) — varchar — NOT NULL
  • 작성날짜 (created_at) — datetime — NOT NULL

Student (학생)

  • 학생ID (student_id) — varchar — Foreign key → Member.ID — NOT NULL
  • 강의ID (class_id) — bigint — Foreign key → Class.ID — NOT NULL
  • 신청 날짜 (applied_at) — datetime
  • 수락 날짜 (accepted_at) — datetime

Teacher (강사)

  • 강사ID (teacher_id) — varchar — Foreign key → Member.ID — NOT NULL
  • 강의ID (class_id) — bigint — Foreign key → Class.ID — NOT NULL