데이터 대시보드
테이블 (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