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