데이터 대시보드

테이블 (4)

date_user_replica_curriculum_aggregation

  • id — bigint — 기본 키 — NOT NULL — auto increament
  • replica_curriculum_id — char(36) — NOT NULL
  • user_id — bigint — NOT NULL
  • study_date — date — 학습일자
  • due_date — date — 발송일자
  • total_count — integer — 발송된 SAI 개수
  • learning_study_count — integer — 학습한 SAI 개수
  • learning_rate — double precision — 학습완료율
  • answer_correct_count — integer — 맞은 SAI 개수
  • answer_rate — double precision — 정답률
  • total_study_time — integer — 하루 누적 학습시간
  • deleted_at — timestamp
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL

replica_curriculum_path

  • id — 기본 키 — NOT NULL — auto increament
  • replica_curriculum_id — char(36) — NOT NULL
  • replica_daily_curriculum_id — char(36)
  • replica_study_module_id — char(36)
  • replica_study_unit_id — char(36)
  • replica_study_activity_id — char(36)
  • replica_curriculum_title — char(36)
  • replica_daily_curriculum_title — char(36)
  • replica_study_module_title — char(36)
  • replica_study_unit_title — char(36)
  • replica_study_activity_title — char(36)
  • study_module_id — char(36)
  • study_unit_id — char(36)
  • study_activity_id — char(36)
  • deleted_at — timestamp
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL

study_activity_instance_log

  • study_activity_instance_id — char(36) — 기본 키 — NOT NULL
  • user_id — bigint — NOT NULL
  • study_module_id — char(36)
  • study_unit_id — char(36)
  • replica_daily_curriculum_id — char(36)
  • replica_study_module_id — char(36)
  • replica_study_unit_id — char(36)
  • replica_study_activity_id — char(36)
  • study_module_instance_id — char(36)
  • study_unit_instance_id — char(36)
  • curriculum_type — varchar(25) — NOT NULL — 일반/추천/오답
  • user_email — varchar(127) — NOT NULL
  • user_name — varchar(31) — NOT NULL
  • feed_id — bigint
  • feed_type — smallint — 19: 문제, 21 : 오답
  • due_date — date — 피드 발송일
  • group_id — integer — NOT NULL
  • group_name — varchar(255) — NOT NULL
  • sa_type — varchar(255) — NOT NULL — SA 타입
  • learning_state — varchar(40) — NOT NULL — 학습상태
  • metadata — json — sai 메타데이터
  • sai_updated_at — timestamp — sai의 updated_at
  • is_answer — smallint — 정답여부
  • solving_time — integer — 제출시간(초, 제출이 있는 타입의경우)
  • stay_time — 머문시간(초)
  • max_study_time — 설정한 최대학습시간
  • deleted_at — timestamp
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL

user_study_activity_aggregation

  • id — bigint — 기본 키 — NOT NULL — auto increament
  • study_activity_id — char(36)
  • user_id — bigint — NOT NULL
  • learning_state — varchar(40) — NOT NULL
  • frequency — smallint — NOT NULL — 푼 횟수
  • is_last_correct — smallint — NOT NULL — 마지막 정답여부
  • correct_count — smallint — NOT NULL — 맞은 횟수
  • incorrect_count — smallint — NOT NULL — 틀린 횟수
  • solving_time — smallint — 문제를푼시간
  • stay_time — smallint — NOT NULL — 본 시간
  • deleted_at — timestamp
  • updated_at — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL