TMeRoom ERD v2

Tables (7)

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 (lecture_id) — bigint — Foreign key → Lecture.강의코드 — NOT NULL
  • 파일이름 (file_name) — varchar — NOT NULL
  • 파일링크 (file_link) — varchar — NOT NULL
  • 파일타입 (file_type) — varhar
  • 게시자닉네임 (uploader_nickname) — varchar
  • 업로드 날짜 (uploaded_at) — datetime — NOT NULL

Lecture (강의)

  • 강의코드 (code) — varchar — Primary key — NOT NULL
  • 관리자ID (manager_id) — varchar — Foreign key → Member.ID — NOT NULL
  • 강의명 (lecture_name) — varchar — NOT NULL

Member (회원)

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

Question (질문)

  • 질문ID (id) — bigint — Primary key — NOT NULL
  • 강의ID (lecture_id) — bigint — Foreign key → Lecture.강의코드 — NOT NULL
  • 작성자ID (author_id) — varchar — Foreign key → Member.ID
  • 제목 (title) — varchar — NOT NULL
  • 내용 (content) — varchar — NOT NULL
  • 작성날짜 (created_at) — datetime — NOT NULL
  • 작성자닉네임 (author_nickname) — varchar

Student (학생)

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

Teacher (강사)

  • 강사ID (teacher_id) — varchar — Foreign key → Member.ID — NOT NULL
  • 강의ID (lecture_id) — bigint — Foreign key → Lecture.강의코드 — NOT NULL