아이헤이트플라잉버그스

테이블 (12)

FeedResults

  • result_id — VARCHAR(36)
  • feed_id — VARCHAR(36) — NOT NULL
  • student_id — VARCHAR(36) — NOT NULL
  • result_type — ENUM('VIDEO', 'MULTIPLE_CHOICE', 'GRAMMAR') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

Feeds

  • feed_id — VARCHAR(36)
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • feed_type — ENUM('VIDEO', 'MULTIPLE_CHOICE', 'GRAMMAR') — NOT NULL
  • content — LONGTEXT
  • group_id — VARCHAR(36) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

GrammarFeeds

  • feed_id — VARCHAR(36)
  • question — TEXT — NOT NULL
  • correct_answer — TEXT — NOT NULL
  • explanation — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

GrammarResults

  • result_id — VARCHAR(36)
  • answer — TEXT — NOT NULL
  • is_correct — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

GroupStudents

  • group_id — VARCHAR(36) — 기본 키 — NOT NULL
  • student_id — VARCHAR(36) — 기본 키 — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

Groups

  • group_id — VARCHAR(36)
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • grade — INT
  • level — ENUM('BEGINNER', 'INTERMEDIATE', 'ADVANCED') — NOT NULL
  • teacher_id — VARCHAR(36) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

MultipleChoiceFeeds

  • feed_id — VARCHAR(36)
  • question — TEXT — NOT NULL
  • options — JSON — NOT NULL
  • correct_answer — VARCHAR(10) — NOT NULL
  • explanation — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

MultipleChoiceResults

  • result_id — VARCHAR(36)
  • selected_option — VARCHAR(10) — NOT NULL
  • is_correct — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

Students

  • student_id — VARCHAR(36)
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

Teachers

  • teacher_id — VARCHAR(36)
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

VideoFeeds

  • feed_id — VARCHAR(36)
  • video_url — VARCHAR(255) — NOT NULL
  • duration — INT — NOT NULL
  • thumbnail_url — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

VideoResults

  • result_id — VARCHAR(36)
  • watch_duration — INT — NOT NULL
  • completed — BOOLEAN
  • last_position — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP