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