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)