임포트테스트용

테이블 (26)

assessment_options

  • q_id — INT — 외래 키 → assessment_questions.id — NOT NULL
  • id — BIGINT
  • opt_text — VARCHAR(200) — NOT NULL
  • score — INT — NOT NULL
  • disp_ord — INT
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP
  • attr1 — INT

assessment_questions

  • id — INT
  • comp_id — INT — NOT NULL
  • q_text — TEXT — NOT NULL
  • q_type — VARCHAR(20) — NOT NULL
  • disp_ord — INT
  • is_act — BOOLEAN — NOT NULL
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP

assessment_responses

  • id — INT
  • q_id — INT — NOT NULL
  • opt_id — BIGINT — NOT NULL
  • res_id — INT — NOT NULL
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP

assessment_results

  • id — INT
  • user_id — INT — NOT NULL
  • assm_id — INT — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP
  • is_sub — BOOLEAN
  • sub_at — TIMESTAMP

assessment_sections

  • id — INT
  • title — VARCHAR(200) — NOT NULL
  • desc — TEXT
  • st_dt — DATETIME — NOT NULL
  • ed_dt — DATETIME — NOT NULL
  • is_act — BOOLEAN — NOT NULL
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP

common_codes

  • id — INT
  • grp_cd — VARCHAR(50) — NOT NULL
  • cd_val — VARCHAR(50) — NOT NULL
  • cd_nm — VARCHAR(100) — NOT NULL
  • desc — TEXT
  • disp_ord — INT
  • is_act — BOOLEAN — NOT NULL
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP

competencies

  • id — INT
  • comp_cd — INT — NOT NULL
  • comp_nm — VARCHAR(100) — NOT NULL
  • desc — TEXT
  • disp_ord — INT
  • is_act — BOOLEAN — NOT NULL
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP
  • attr1 — VARCHAR(255)
  • attr2 — VARCHAR(255)

counseling_records

  • id — INT
  • user_id — INT — NOT NULL
  • resv_id — INT — NOT NULL
  • cns_dt — DATETIME — NOT NULL
  • cont — TEXT — NOT NULL
  • memo — TEXT
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP

counseling_reservations

  • id — INT
  • user_id — INT — NOT NULL — 학생 or 상담사
  • cns_type — VARCHAR(20) — NOT NULL
  • cont — TEXT — NOT NULL
  • pref_dt — DATETIME
  • stat — VARCHAR(20) — PENDING, APPROVED, REJECTED, COMPLETED, CANCELLED
  • conf_dt — DATETIME
  • rej_rsn — TEXT
  • cnl_rsn — TEXT
  • crt_at — TIMESTAMP — NOT NULL
  • rej_at — TIMESTAMP
  • cnl_at — TIMESTAMP

counseling_satisfaction

  • id — INT
  • std_id — INT — NOT NULL
  • resv_id — INT — NOT NULL
  • cnsr_id — INT — NOT NULL
  • avg_sc — DECIMAL(3,2) — NOT NULL
  • fb — TEXT
  • sub_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP

counseling_satisfaction_survey_answer

  • id — INT
  • q_id — INT — NOT NULL
  • satis_id — INT — NOT NULL
  • ans_score — INT
  • ans_text — TEXT — NOT NULL
  • crt_at — TIMESTAMP
  • upd_at — TIMESTAMP

counseling_satisfaction_survey_question

  • id — INT
  • q_text — TEXT — NOT NULL
  • q_type — ENUM('objective','subjective') — NOT NULL
  • is_act — BOOLEAN
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP

counselor_weekly_unavailability

  • id — INT
  • unavail_dt — DATE — NOT NULL
  • st_time — TIME — NOT NULL — 불가능 시작시간
  • ed_time — TIME — 불가능 종료시간
  • reason — VARCHAR(100) — 사유 (휴가, 외부회의 등)
  • crt_at — DATETIME — NOT NULL
  • upd_at — DATETIME
  • cnsr_id — INT — NOT NULL — counselor_id

counselors

  • id — INT
  • spec — VARCHAR(100)
  • intro — TEXT
  • avail_days — VARCHAR(100)
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP

email_logs

  • id — INT
  • rcv_id — INT — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • subj — VARCHAR(255) — NOT NULL
  • tpl_nm — VARCHAR(100)
  • stat — VARCHAR(20) — NOT NULL — SUCCESS, FAILED
  • err_msg — TEXT
  • sent_at — TIMESTAMP — NOT NULL
  • cont — TEXT

login_history

  • id — INT
  • user_id — INT — NOT NULL
  • login_at — TIMESTAMP
  • ip — VARCHAR(45)
  • ua — VARCHAR(255)
  • is_succ — BOOLEAN — NOT NULL
  • fail_msg — VARCHAR(255)

mileage_records

  • id — INT
  • std_id — INT — NOT NULL
  • prog_id — INT — NOT NULL
  • pts — INT — NOT NULL
  • type — VARCHAR(20) — EARN, USE, ADJUST
  • desc — VARCHAR(255)
  • crt_by — INT — NOT NULL
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP

notifications

  • id — INT
  • user_id — INT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • cont — TEXT
  • ntf_type — VARCHAR(20) — NOT NULL — COUNSELING, PROGRAM, ASSESSMENT, SYSTEM
  • is_read — BOOLEAN — NOT NULL
  • link_url — VARCHAR(500)
  • crt_at — TIMESTAMP — NOT NULL
  • read_at — TIMESTAMP

program_applications

  • id — INT
  • prog_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • app_stat — VARCHAR(20) — NOT NULL — PENDING, APPROVED, REJECTED, CANCELLED
  • rej_rsn — TEXT
  • app_at — TIMESTAMP — NOT NULL
  • applied_at — TIMESTAMP
  • cnl_at — TIMESTAMP

program_attendance

  • id — INT
  • app_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • att_dt — DATE — NOT NULL
  • stat — VARCHAR(20) — NOT NULL — PRESENT, ABSENT, LATE, EXCUSED
  • note — TEXT
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP

program_categories

  • id — INT
  • cat_nm — VARCHAR(100)
  • desc — TEXT
  • is_act — BOOLEAN — NOT NULL
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP

program_competencies

  • id — INT
  • prog_id — INT — NOT NULL
  • comp_id — INT — NOT NULL
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP

program_reports

  • id — INT
  • prog_id — INT — NOT NULL
  • app_id — INT
  • user_id — INT — NOT NULL
  • wrt_type — VARCHAR(20) — NOT NULL — STUDENT, MANAGER
  • cont — TEXT — NOT NULL
  • file_path — VARCHAR(500)
  • sub_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP

program_satisfaction

  • id — INT
  • prog_id — INT — NOT NULL
  • std_id — INT — NOT NULL
  • rate — INT — NOT NULL — 1~5
  • fb — TEXT
  • sub_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP

programs

  • id — INT
  • cat_id — INT — NOT NULL
  • reg_id — INT — NOT NULL — 등록자(운영자)
  • title — VARCHAR(200) — NOT NULL
  • desc — TEXT
  • st_dt — DATETIME — NOT NULL
  • ed_dt — DATETIME — NOT NULL
  • app_st — DATETIME — NOT NULL
  • app_ed — DATETIME — NOT NULL
  • max_cnt — INT — NOT NULL
  • min_cnt — INT
  • cur_cnt — INT — NOT NULL
  • mile — INT — NOT NULL
  • loc — VARCHAR(200)
  • stat — VARCHAR(20) — NOT NULL — DRAFT, PENDING, APPROVED, REJECTED, ONGOING, COMPLETED, CANCELLED
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP

users

  • id — INT
  • std_no — INT — NOT NULL — 학생 학번
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(100)
  • pwd — VARCHAR(255)
  • birth_dt — DATE — NOT NULL
  • dept — VARCHAR(100)
  • grade — INT
  • role — VARCHAR(20) — STUDENT, COUNSELOR, ADMIN
  • is_lock — BOOLEAN — NOT NULL
  • fail_cnt — INT — NOT NULL
  • crt_at — TIMESTAMP — NOT NULL
  • upd_at — TIMESTAMP
  • del_at — TIMESTAMP