임포트테스트용
테이블 (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