ERD_ACG
Tables (34)
admin
- admin_idx — SMALLINT(6) — Primary key — NOT NULL
- admin_email — VARCHAR(50) — NOT NULL
- admin_pass — VARCHAR(100) — NOT NULL
- admin_name — VARCHAR(300) — NOT NULL
- admin_cell — VARCHAR(20) — NOT NULL
- company_name — VARCHAR(50)
- company_tel — VARCHAR(20)
- security_use_yn — ENUM('Y', 'N') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- login_token — VARCHAR(300)
- login_fail_cnt — TINYINT(1) — NOT NULL
- admin_avail — DATETIME
- admin_grade_idx — TINYINT(4) — Foreign key → admin_grade.admin_grade_idx — NOT NULL
admin_grade
- admin_grade_idx — TINYINT(4) — Primary key — NOT NULL
- admin_grade_name — ENUM('감독관', '일반 관리자', '슈퍼 관리자', '개발자') — NOT NULL
admin_log
- log_idx — INT(11) — Primary key — NOT NULL
- log_ip — VARCHAR(15) — NOT NULL
- log_agent — VARCHAR(500) — NOT NULL
- log_at — DATETIME — NOT NULL
- auth_key — VARCHAR(6) — NOT NULL
- login_success_yn — ENUM('Y', 'N') — NOT NULL
- admin_idx — SMALLINT(6) — Foreign key → admin.admin_idx — NOT NULL
chat_log
- log_idx — INT(11) — Primary key — NOT NULL
- from_id — VARCHAR(40) — NOT NULL
- to_id — VARCHAR(40) — NOT NULL
- from_name — VARCHAR(255) — NOT NULL
- message — VARCHAR(255) — NOT NULL
- read_yn — ENUM('Y', 'N') — NOT NULL
- log_at — DATETIME — NOT NULL
- room_idx — INT(11) — Foreign key → room.room_idx — NOT NULL
chat_template
- chat_template_idx — INT(11) — Primary key — NOT NULL
- company_idx — SMALLINT(6) — NOT NULL
- category — ENUM('1:1문의', '전체공지') — NOT NULL
- title — VARCHAR(100) — NOT NULL
- message — VARCHAR(500) — NOT NULL
- company_idx (company_idx2) — SMALLINT(6) — Foreign key → company.company_idx — NOT NULL
company
- company_idx — SMALLINT(6) — Primary key — NOT NULL
- company_code — VARCHAR(20) — NOT NULL
- company_name — VARCHAR(100) — NOT NULL
- company_tel — VARCHAR(20)
- layout_idx — TINYINT(1) — NOT NULL
- ci_use_yn — ENUM('Y', 'N') — NOT NULL
- ci_file_path — VARCHAR(100)
- color_main — VARCHAR(7) — NOT NULL
- color_sub — VARCHAR(7) — NOT NULL
- bg_image_use_yn — ENUM('Y', 'N') — NOT NULL
- color_bg — VARCHAR(100) — NOT NULL
- room_use_yn — ENUM('Y', 'N') — NOT NULL
- room_max_user_cnt — TINYINT(4) — NOT NULL
- screen_share_use_yn — ENUM('Y', 'N') — NOT NULL
- mobile_share_use_yn — ENUM('Y', 'N') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- company_avail — DATETIME
- terms_idx — SMALLINT(6) — Foreign key → terms.terms_idx — NOT NULL
company_norm_list
- norm_idx — SMALLINT(6) — Foreign key → norm.norm_idx — NOT NULL
- company_idx — SMALLINT(6) — Foreign key → company.company_idx — NOT NULL
- norm_use_yn — ENUM('Y', 'N') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- report_idx — SMALLINT(6) — Foreign key → report.report_idx — NOT NULL
exam
- exam_idx — SMALLINT(6) — Primary key — NOT NULL
- exam_name — VARCHAR(20) — NOT NULL
- exam_use_yn — ENUM('Y', 'N') — NOT NULL
- exam_mean — FLOAT — NOT NULL
- exam_dev — FLOAT — NOT NULL
- exam_memo — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
exam_matrix
- exam_sub_idx — SMALLINT(6) — Foreign key → exam_sub.exam_sub_idx — NOT NULL
- exam_idx — SMALLINT(6) — Foreign key → exam.exam_idx — NOT NULL
- exam_sub_no — TINYINT(4) — NOT NULL
- exam_sub_weight — FLOAT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
exam_sub
- exam_sub_idx — SMALLINT(6) — Primary key — NOT NULL
- exam_sub_name — VARCHAR(20) — NOT NULL
- exam_sub_mean — FLOAT — NOT NULL
- exam_sub_dev — FLOAT — NOT NULL
- exam_minutes — SMALLINT(6) — NOT NULL
- no_use_yn — ENUM('Y', 'N') — NOT NULL
- prev_use_yn — ENUM('Y', 'N') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- practice_idx — SMALLINT(6) — Foreign key → practice.practice_idx — NOT NULL
- question_idx — SMALLINT(6) — Foreign key → question.question_idx — NOT NULL
faq
- faq_idx — INT(11) — Primary key — NOT NULL
- category — ENUM('로그인/접속', '주변기기', '프로그램', '기타') — NOT NULL
- question — VARCHAR(500) — NOT NULL
- answer — VARCHAR(1000) — NOT NULL
- created_at — DATETIME — NOT NULL
group_list
- group_idx — INT(11) — Primary key — NOT NULL
- group_name — VARCHAR(60) — NOT NULL
- norm_idx — SMALLINT(6) — NOT NULL
- room_use_yn — ENUM('Y', 'N') — NOT NULL
- room_max_user_cnt — TINYINT(4) — NOT NULL
- screen_share_use_yn — ENUM('Y', 'N') — NOT NULL
- mobile_share_use_yn — ENUM('Y', 'N') — NOT NULL
- pre_exam_use_yn — ENUM('Y', 'N') — NOT NULL
- pre_exam_s_at — DATETIME
- pre_exam_e_at — DATETIME
- exam_s_at — DATETIME — NOT NULL
- exam_e_at — DATETIME — NOT NULL
- virtual_group_yn — ENUM('Y', 'N') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- group_avail — DATETIME
- company_idx — SMALLINT(6) — Foreign key → company.company_idx — NOT NULL
- user_idx — SMALLINT(6) — Foreign key → user.user_idx — NOT NULL
- norm_idx (norm_idx2) — SMALLINT(6) — Foreign key → norm.norm_idx — NOT NULL
group_list_v
- tester_idx — INT(11) — Foreign key → tester.tester_idx — NOT NULL
- real_group_idx — INT(11) — NOT NULL
- real_room_idx — INT(11) — NOT NULL
- group_idx (group_idx2) — INT(11) — Foreign key → group_list.group_idx — NOT NULL
norm
- norm_idx — SMALLINT(6) — Primary key — NOT NULL
- norm_name — VARCHAR(50) — NOT NULL
- norm_mean — FLOAT — NOT NULL
- norm_dev — FLOAT — NOT NULL
- norm_memo — VARCHAR(500) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
norm_matrix
- exam_idx — SMALLINT(6) — Foreign key → exam.exam_idx — NOT NULL
- norm_idx — SMALLINT(6) — Foreign key → norm.norm_idx — NOT NULL
- exam_no — TINYINT(4) — NOT NULL
- exam_weight — FLOAT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- INDEX — `FK_4d3b4e29e65fd7d3543ec339a63`
practice ((예제))
- practice_idx — SMALLINT(6) — Primary key — NOT NULL
- practice_name — VARCHAR(50) — NOT NULL
- likert_yn — ENUM('Y', 'N') — NOT NULL
- max_scale — TINYINT(4) — NOT NULL
- ipsative_yn — ENUM('Y', 'N') — NOT NULL
- question_set_cnt — TINYINT(4) — NOT NULL
- practice_minutes — FLOAT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
practice_ex ((예제문항의 보기))
- question_ex_no — TINYINT(4) — Primary key — NOT NULL
- question_no — TINYINT(4) — Foreign key → practice_title.question_no — NOT NULL
- practice_idx — SMALLINT(6) — Foreign key → practice_title.practice_idx — NOT NULL
- question_ex_text — VARCHAR(100)
practice_title ((예제문항))
- question_no — TINYINT(4) — Primary key — NOT NULL
- practice_idx — SMALLINT(6) — Foreign key → practice.practice_idx — NOT NULL
- page_no — TINYINT(4) — NOT NULL
- question_text — VARCHAR(500) — NOT NULL
- question_sub_use_yn — ENUM('Y', 'N') — NOT NULL
- question_sub_text — VARCHAR(5000)
- button_name_popup — VARCHAR(20)
- popup_img — VARCHAR(500)
qna
- qna_idx — INT(11) — Primary key — NOT NULL
- category — ENUM('로그인/접속', '주변기기', '프로그램', '기타') — NOT NULL
- text — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- tester_idx — INT(11) — Foreign key → tester.tester_idx — NOT NULL
question
- question_idx — SMALLINT(6) — Primary key — NOT NULL
- question_name — VARCHAR(500) — NOT NULL
- likert_yn — ENUM('Y', 'N') — NOT NULL
- max_scale — TINYINT(4) — NOT NULL
- ipsative_yn — ENUM('Y', 'N') — NOT NULL
- question_set_cnt — TINYINT(4) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
question_ex
- question_idx — SMALLINT(6) — NOT NULL
- question_no — TINYINT(4) — NOT NULL
- question_ex_no — TINYINT(4) — NOT NULL
- question_ex_text — VARCHAR(300) — NOT NULL
- answer_score — FLOAT — NOT NULL
question_title
- question_no — SMALLINT(6) — Primary key — NOT NULL
- question_idx — SMALLINT(6) — Foreign key → question.question_idx — NOT NULL
- page_no — TINYINT(4) — NOT NULL
- question_text — VARCHAR(500) — NOT NULL
- question_sub_use_yn — ENUM('Y', 'N') — NOT NULL
- question_sub_text — VARCHAR(5000)
- question_ex_layout — TINYINT(4) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
report
- report_idx — SMALLINT(6) — Primary key — NOT NULL
- report_name — VARCHAR(40) — NOT NULL
- report_template_person — VARCHAR(100) — NOT NULL
- report_template_hr — VARCHAR(100) — NOT NULL
- report_use_yn — ENUM('Y', 'N') — NOT NULL
- report_pass_color — VARCHAR(7) — NOT NULL
- report_fail_color — VARCHAR(7) — NOT NULL
room
- room_idx — INT(11) — Primary key — NOT NULL
- room_no — TINYINT(4) — NOT NULL
- manager_name — VARCHAR(10)
- manager_cell — VARCHAR(13)
- auth_key — VARCHAR(6)
- group_idx — INT(11) — Foreign key → group_list.group_idx — NOT NULL
terms
- terms_idx — SMALLINT(6) — Primary key — NOT NULL
- terms_name — VARCHAR(30) — NOT NULL
- exam_privacy — VARCHAR(5000) — NOT NULL
- exam_secret — VARCHAR(5000) — NOT NULL
- exam_notice — VARCHAR(5000) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
tester
- tester_idx — INT(11) — Primary key — NOT NULL
- tester_name — VARCHAR(30) — NOT NULL
- tester_id — VARCHAR(30)
- tester_birth — VARCHAR(10) — NOT NULL
- tester_cell — VARCHAR(30) — NOT NULL
- tester_email — VARCHAR(30)
- foreign_login_yn — ENUM('Y', 'N') — NOT NULL
- pre_exam_yn — ENUM('Y', 'N') — NOT NULL
- agree_yn — ENUM('Y', 'N') — NOT NULL
- attendance_yn — ENUM('Y', 'N') — NOT NULL
- id_file_name — VARCHAR(100)
- login_token — VARCHAR(300)
- cheating_yn — ENUM('Y', 'N') — NOT NULL
- cheating_memo — VARCHAR(200)
- complete_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- free_pass_yn — ENUM('Y', 'N') — NOT NULL
- scoring_yn — ENUM('Y', 'N') — NOT NULL
- pass_yn — ENUM('Y', 'N') — NOT NULL
- tester_avail — DATETIME
- exam_status — ENUM('0', '1', '2') — NOT NULL
- room_idx — INT(11) — Foreign key → room.room_idx — NOT NULL
- group_idx — INT(11) — Foreign key → group_list.group_idx — NOT NULL
tester_exam_list
- tester_idx (tester_idx2) — INT(11) — Foreign key → tester.tester_idx — NOT NULL
- exam_sub_idx (exam_sub_idx2) — SMALLINT(6) — Foreign key → exam_sub.exam_sub_idx — NOT NULL
- exam_idx — SMALLINT(6) — Foreign key → exam.exam_idx — NOT NULL
- norm_idx — SMALLINT(6) — Foreign key → norm.norm_idx — NOT NULL
- exam_status — TINYINT(4) — NOT NULL
- save_page — TINYINT(1) — NOT NULL
- remaining_seconds — SMALLINT(1) — NOT NULL
- complete_at — DATETIME
tester_log
- log_idx — INT(11) — Primary key — NOT NULL
- log_ip — VARCHAR(15) — NOT NULL
- log_agent — VARCHAR(500) — NOT NULL
- log_network — VARCHAR(10) — NOT NULL
- log_at — DATETIME — NOT NULL
- auth_key — VARCHAR(6) — NOT NULL
- login_success_yn — ENUM('Y', 'N') — NOT NULL
- tester_idx — INT(11) — Foreign key → tester.tester_idx — NOT NULL
tester_mark
- question_no — SMALLINT(6) — Primary key — NOT NULL
- question_mark_cnt — TINYINT(1) — Primary key — NOT NULL
- tester_idx — INT(11) — Foreign key → tester.tester_idx — NOT NULL
- exam_sub_idx (exam_sub_idx2) — SMALLINT(6) — Foreign key → exam_sub.exam_sub_idx — NOT NULL
- question_mark — TINYINT(1)
- question_memo — VARCHAR(1000)
- page_no — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
tester_mark_complete
- question_no — SMALLINT(6) — Primary key — NOT NULL
- question_mark_cnt — TINYINT(1) — Primary key — NOT NULL
- tester_idx — INT(11) — Foreign key → tester.tester_idx — NOT NULL
- exam_sub_idx — SMALLINT(6) — Foreign key → exam_sub.exam_sub_idx — NOT NULL
- question_mark — TINYINT(1)
- question_memo — VARCHAR(1000)
- page_no — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
tester_record
- record_idx — INT(11) — Primary key — NOT NULL
- tester_idx — INT(11) — NOT NULL
- record_type — VARCHAR(10) — NOT NULL
- record_url — VARCHAR(500) — NOT NULL
- record_at — DATETIME — NOT NULL
user
- user_idx — SMALLINT(6) — Primary key — NOT NULL
- user_email — VARCHAR(100) — NOT NULL
- user_pass — VARCHAR(100) — NOT NULL
- user_name — VARCHAR(40) — NOT NULL
- user_cell — VARCHAR(20) — NOT NULL
- user_tel — VARCHAR(20)
- company_idx — SMALLINT(6) — NOT NULL
- security_use_yn — ENUM('Y', 'N') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- login_token — VARCHAR(300)
- login_fail_cnt — TINYINT(4) — NOT NULL
- user_avail — DATETIME
- company_idx (company_idx2) — SMALLINT(6) — Foreign key → company.company_idx — NOT NULL
- user_grade_idx — TINYINT(4) — Foreign key → user_grade.user_grade_idx — NOT NULL
user_grade
- user_grade_idx — TINYINT(4) — Primary key — NOT NULL
- user_grade_name — ENUM('일반 담당자', '메인 담당자') — NOT NULL
user_log
- log_idx — INT(11) — Primary key — NOT NULL
- log_ip — VARCHAR(15) — NOT NULL
- log_agent — VARCHAR(500) — NOT NULL
- log_at — DATETIME — NOT NULL
- auth_key — VARCHAR(6) — NOT NULL
- login_success_yn — ENUM('Y', 'N') — NOT NULL
- user_idx — SMALLINT(6) — Foreign key → user.user_idx — NOT NULL