d

Tables (11)

feeds

  • feed_id — BINARY(16) — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • type — VARCHAR(255) — NOT NULL
  • content — JSON — NOT NULL
  • estimated_time — INT
  • thumbnail_url — VARCHAR(255)
  • answer_and_commentary — JSON

group_members

  • group_id — BINARY(16) — Primary key — NOT NULL
  • member_id — BINARY(16) — Primary key — NOT NULL

groups

  • group_id — BINARY(16) — Primary key — NOT NULL
  • 이름 — VARCHAR(100) — NOT NULL
  • 설명 — TEXT

issued_learning_content

  • issued_learning_content_id — BINARY(16) — Primary key — NOT NULL
  • group_id — BINARY(16)
  • 학습_내용_id — BINARY(16) — NOT NULL
  • 시작_시간 — DATETIME
  • 마감_시간 — DATETIME
  • 진행_현황 — TINYINT — NOT NULL

issued_learning_content_details

  • issued_learning_content_id — BINARY(16) — Primary key — NOT NULL
  • member_id — BINARY(16) — Primary key — NOT NULL
  • progress_percent — TINYINT — NOT NULL

learned_feeds

  • learned_feed_id — BINARY(16) — Primary key — NOT NULL
  • member_id — BINARY(16) — NOT NULL
  • learning_content_feed_id — BINARY(16) — NOT NULL

learning_content_feeds

  • learning_content_feed_id — BINARY(16) — Primary key — NOT NULL
  • learning_content_id — BINARY(16) — NOT NULL
  • feed_id — BINARY(16) — NOT NULL

learning_contents

  • learning_content_id — BINARY(16) — Primary key — NOT NULL
  • 제목 — VARCHAR(255) — NOT NULL
  • 설명 — TEXT
  • 썸네일_url — VARCHAR(255)

members

  • member_id — BINARY(16) — Primary key — NOT NULL
  • 이메일 — VARCHAR(255) — NOT NULL
  • 이름 — VARCHAR(10)
  • 타입 — VARCHAR(20) — NOT NULL
  • 성별 — CHAR(1)
  • 전화번호 — VARCHAR(20)
  • 비밀번호 — VARCHAR(255) — NOT NULL

student_infos

  • member_id — BINARY(16) — Primary key — NOT NULL
  • 수준 — VARCHAR(10) — NOT NULL
  • 학년 — VARCHAR(10) — NOT NULL
  • 메모 — TEXT

teacher_infos

  • member_id — BINARY(16) — Primary key — NOT NULL
  • 담당_과목 — VARCHAR(20) — NOT NULL
  • 경력_년수 — INT
  • 메모 — TEXT