ecodot_backend

Tables (21)

answer_tb

  • idx — serial
  • question_idx — integer — NOT NULL — 질문
  • teacher_idx — integer — NOT NULL — 선생님
  • content — text — NOT NULL — 답변
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

ar_learning_tb

  • idx — serial — 학습
  • description — varchar — NOT NULL — 설명
  • ar_data — varchar — NOT NULL — ar
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

banner_tb

  • idx — serial
  • title — varchar(30) — NOT NULL — 제목
  • content — varchar(100) — NOT NULL — 배너
  • link — varchar(30) — NOT NULL — 링크
  • image_path — text — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

block_coding_tb

  • idx — serial — 학습
  • description — varchar — NOT NULL — 설명
  • game_data — varchar — NOT NULL — 블록
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

class_curriculum_tb

  • class_idx — integer — Primary key — NOT NULL — 반
  • curriculum_idx — integer — Primary key — NOT NULL — 커리큘럼
  • order — integer — NOT NULL — 순서

class_tb

  • idx — serial
  • teacher_idx — integer — 선생님
  • name — varchar — NOT NULL — 반
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

content_complete_tb

  • student_idx — integer — Primary key — NOT NULL — 사용자
  • content_idx — integer — Primary key — NOT NULL
  • created_at — timestamp — NOT NULL

curriculum_content_tb

  • curriculum_idx — integer — Primary key — NOT NULL
  • content_idx — integer — Primary key — NOT NULL
  • order — integer — NOT NULL

curriculum_tb

  • idx — serial
  • title — varchar — NOT NULL — 커리큘럼
  • summary — varchar — NOT NULL — 커리큘럼
  • description — varchar — NOT NULL — 커리큘럼
  • image_path — text — NOT NULL — 커리큘럼
  • blocked_at — timestamp — 활성화
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

inquiry_tb

  • idx — serial
  • author — varchar — NOT NULL — 작성자
  • email — varchar — NOT NULL — 이메일
  • content — text — NOT NULL — 문의
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

institute_tb

  • idx — serial
  • name — varchar — NOT NULL — 기관
  • manager_name — varchar — NOT NULL — 담당자
  • manager_phone_number — char(11) — NOT NULL — 담당자
  • started_at — timestamp — NOT NULL — 시작
  • end_at — timestamp — NOT NULL — 종료
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

learning_content_tb

  • idx — serial
  • title — varchar — NOT NULL — 학습
  • blocked_at — timestamp — 활성화
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp
  • type — "LEARNING_CONTENT_TYPE" — NOT NULL

lecture_video_progress_tb

  • student_idx — integer — Primary key — NOT NULL — 사용자
  • video_idx — integer — Primary key — NOT NULL — 강의
  • watch_time — integer — NOT NULL — 시청

lecture_video_tb

  • idx — serial — 학습
  • url — text — NOT NULL — 강의
  • video_length — integer — NOT NULL — 강의
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

question_tb

  • idx — serial
  • student_idx — integer — NOT NULL — 학생
  • class_idx — integer — NOT NULL — 반
  • content — text — NOT NULL — 질문
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp

quiz_answer_tb

  • student_idx — integer — Primary key — NOT NULL — 유저
  • quiz_selection_idx — integer — Primary key — NOT NULL — 퀴즈
  • created_at — timestamp — NOT NULL

quiz_selection_tb

  • idx — serial
  • quiz_idx — integer — NOT NULL
  • select_number — smallint — NOT NULL
  • content — varchar — NOT NULL — 선택지
  • correct — boolean — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

quiz_tb

  • idx — serial
  • learning_content_idx — integer — NOT NULL — 학습
  • question — varchar — NOT NULL — 퀴즈
  • image_path — varchar — NOT NULL — 수업
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL

student_tb

  • user_idx — integer — NOT NULL — 사용자
  • class_idx — integer — 반

teacher_tb

  • user_idx — integer — NOT NULL — 사용자
  • institute_idx — integer — 기관
  • email — varchar — NOT NULL — 이메일

user_tb

  • idx — serial
  • login_id — varchar — NOT NULL — 로그인
  • password — varchar — NOT NULL — 비밀번호
  • name — varchar — NOT NULL — 이름
  • phone_number — char(11) — NOT NULL — 연락처
  • role — smallint — NOT NULL — 권한
  • blocked_at — timestamp — 로그인
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • deleted_at — timestamp