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