dbS
Tables (13)
Answer
- answer_id (answerId) — Primary key — NOT NULL
- 답변작성한학생 (studentId) — Primary key — NOT NULL
- 답변작성할콘텐츠 (contentId) — Foreign key → Content.content_id — NOT NULL
- Field (createdAt)
- Field (updatedAt)
- Field (deletedAt)
Answer_Ticket
- answer_ticket_id (answerTid) — Primary key — NOT NULL
- 탑변작성한학생 (ticketId) — Primary key — NOT NULL
- 답변작성할콘텐츠 (contentId) — Foreign key → Content.content_id — NOT NULL
Chapter
- chapter_id (chapterId) — Primary key — NOT NULL
- space_id (spaceId) — Foreign key → LearningSpace.space_id — NOT NULL
- Field (createdAt)
- Field (updatedAt)
- Field (deletedAt)
Content
- content_id (contentId) — Primary key — NOT NULL
- 파일 (fileId) — Primary key — NOT NULL
- chapter_id (chapterId) — Foreign key → Chapter.chapter_id — NOT NULL
- Field (createdAt)
- Field (updatedAt)
- Field (deletedAt)
Feedback
- feedback_id (feedbackId) — Primary key — NOT NULL
- 피드백받는학생 (studentId) — Primary key — NOT NULL
- chapter_id (chapterId) — Foreign key → Chapter.chapter_id — NOT NULL
- Field (createdAt)
- Field (updatedAt)
- Field (deletedAt)
Feedback_Ticket
- feedback_ticket_id (feedbackTid) — Primary key — NOT NULL
- 피드백받는티켓 (ticketId) — Primary key — NOT NULL
- chapter_id (chapterId) — Foreign key → Chapter.chapter_id — NOT NULL
File
- Key (fileId) — Primary key — NOT NULL
- 파일매핑용 (fileMasterId) — Foreign key → FileMaster.Key — NOT NULL
- Field (orginalName)
- Field (serverName)
- Field (fileSize)
- Field (fileType)
- Field (createdAt)
- Field (updatedAt)
- Field (deletedAt)
FileMaster (Content_File)
- Key (fileMasterId) — Primary key — NOT NULL
- Field (createdAt)
- Field (deletedAt)
LearningSpace
- space_id (spaceId) — Primary key — NOT NULL
- 호스트 (memberId) — Primary key — NOT NULL
- 스페이스명 (title)
- 생성일 (createdAt)
- 수정일 (updatedAt)
- 삭제일 (deletedAt)
- uuid
Member
- member_id (memberId) — Primary key — NOT NULL
- 이름 (name)
- 이메일 (email)
- 패스워드 (password)
- 생성일 (createdAt)
- 수정일 (updatedAt)
- 삭제일 (deletedAt)
- uuid
Student
- Key — Primary key — NOT NULL
- 학생 (studentId) — Primary key — NOT NULL
- 선생님 (memberId) — Foreign key → Member.member_id — NOT NULL
- Field (createdAt)
- Field (updatedAt)
- Field (deletedAt)
Ticket
- ticket_id (ticketId) — Primary key — NOT NULL
- 러닝스페이스아이디 (spaceId) — Primary key — NOT NULL
- 선생님 (memberId) — Foreign key → Member.member_id — NOT NULL
- 학생이름 (name)
- 학생코드 (code)
- Field (createdAt)
- Field (updatedAt)
- Field (deletedAt)
- 선생정보 (teacher)
User_LearningSpace
- Key — Primary key — NOT NULL
- 학생 (guestId) — Primary key — NOT NULL
- 러닝스페이스아이디 (spaceId) — Primary key — NOT NULL
- 선생 (hostId) — Foreign key → Member.member_id — NOT NULL
- Field (createdAt)
- Field (deletedAt)