acs_edu
Tables (21)
article_about
- id — INTEGER — Primary key — NOT NULL
- layout_type — VARCHAR(20) — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT
- image — VARCHAR(100) — NOT NULL
- visible_type — VARCHAR(20) — NOT NULL
- order — INTEGER — NOT NULL
- type — VARCHAR(20) — NOT NULL
article_activity
- id — INTEGER — Primary key — NOT NULL
- author_id — INTEGER — Foreign key → user_user.id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATE — NOT NULL
article_faq
- id — INTEGER — Primary key — NOT NULL
- category — VARCHAR(50) — NOT NULL
- question — VARCHAR(200) — NOT NULL
- answer — TEXT — NOT NULL
article_filecontent
- id — INTEGER — Primary key — NOT NULL
- code — VARCHAR(200) — NOT NULL
- file — VARCHAR(100) — NOT NULL
- info — VARCHAR(200) — NOT NULL
- path — VARCHAR(200) — NOT NULL
article_inquiry
- id — INTEGER — Primary key — NOT NULL
- author_id — INTEGER — Foreign key → user_user.id — NOT NULL
- title — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- answer — TEXT
- status — BOOL — NOT NULL
- attachment — VARCHAR(100)
- created_at — DATE — NOT NULL
article_multifilecontent
- id — INTEGER — Primary key — NOT NULL
- code — VARCHAR(200) — NOT NULL
- info — VARCHAR(200) — NOT NULL
- path — VARCHAR(200) — NOT NULL
article_multifilecontentfile
- id — INTEGER — Primary key — NOT NULL
- file — VARCHAR(100) — NOT NULL
- multi_file_content_id — BIGINT — NOT NULL
article_notice
- id — INTEGER — Primary key — NOT NULL
- author_id — INTEGER — Foreign key → user_user.id — NOT NULL
- title — VARCHAR(50) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATE — NOT NULL
article_noticeattachment
- id — INTEGER — Primary key — NOT NULL
- notice_id — INTEGER — Foreign key → article_notice.id — NOT NULL
- attachment — VARCHAR(100) — NOT NULL
article_term
- id — INTEGER — Primary key — NOT NULL
- type — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- version — VARCHAR(200) — NOT NULL
article_textcontent
- id — INTEGER — Primary key — NOT NULL
- code — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- info — VARCHAR(200) — NOT NULL
- path — VARCHAR(200) — NOT NULL
lecture_board
- id — INTEGER — Primary key — NOT NULL
- author_id — INTEGER — Foreign key → user_user.id — NOT NULL
- title — VARCHAR(50) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATE — NOT NULL
lecture_course
- id — INTEGER — Primary key — NOT NULL
- order — INTEGER — NOT NULL
- level — VARCHAR(50) — NOT NULL
- name — VARCHAR(200) — NOT NULL
- information — TEXT — NOT NULL
- curriculum_guide — TEXT — NOT NULL
- detail — TEXT — NOT NULL
- material_file — VARCHAR(100)
- thumbnail — VARCHAR(100) — NOT NULL
lecture_lecture
- id — INTEGER — Primary key — NOT NULL
- course_id — INTEGER — Foreign key → lecture_course.id — NOT NULL
- order — INTEGER — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- video — VARCHAR(100) — NOT NULL
- video_duration — INTEGER — NOT NULL
lecture_lectureprogress
- id — INTEGER — Primary key — NOT NULL
- lecture_id — INTEGER — Foreign key → lecture_lecture.id — NOT NULL
- user_id — INTEGER — Foreign key → user_user.id — NOT NULL
- last_byte_position — INTEGER — NOT NULL
- rate — INTEGER — NOT NULL
- is_done — BOOL — NOT NULL
- created_at — DATE — NOT NULL
- updated_at — DATE — NOT NULL
lecture_livelecturedate
- id — INTEGER — Primary key — NOT NULL
- date — DATE — NOT NULL
- describe — TEXT — NOT NULL
- course_id — INTEGER — Foreign key → lecture_course.id — NOT NULL
lecture_quiz
- id — INTEGER — Primary key — NOT NULL
- type — VARCHAR(50) — NOT NULL
- question — TEXT — NOT NULL
- answer — VARCHAR(200) — NOT NULL
- lecture_id — INTEGER — Foreign key → lecture_lectureprogress.id — NOT NULL
lecture_quizchoice
- id — INTEGER — Primary key — NOT NULL
- choice — VARCHAR(20) — NOT NULL
- describe — VARCHAR(200) — NOT NULL
- quiz_id — INTEGER — Foreign key → lecture_quiz.id — NOT NULL
lecture_quizhistory
- id — INTEGER — Primary key — NOT NULL
- answer — VARCHAR(200) — NOT NULL
- is_correct — BOOL — NOT NULL
- created_at — DATE — NOT NULL
- updated_at — DATE — NOT NULL
- quiz_id — INTEGER — Foreign key → lecture_quiz.id — NOT NULL
- user_id — INTEGER — Foreign key → user_user.id — NOT NULL
user_emailverification
- id — INTEGER — Primary key — NOT NULL
- email — VARCHAR(254) — NOT NULL
- code — INTEGER
- expired_time — DATETIME
user_user
- id — INTEGER — Primary key — NOT NULL
- last_login — DATETIME
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(128) — NOT NULL
- email — VARCHAR(254) — NOT NULL
- fullname — VARCHAR(50) — NOT NULL
- birthday — DATE — NOT NULL
- occupation_ovf_interest — TEXT
- profile_image — VARCHAR(100)
- type — VARCHAR(20) — NOT NULL
- otp_key — VARCHAR(16)
- is_active — BOOL — NOT NULL
- is_admin — BOOL — NOT NULL
- join_date — DATE — NOT NULL