123124
Tables (27)
advice_sst
- ss_idx — int — Primary key — NOT NULL
- c_idx2 — bigint — Foreign key → course_t.c_idx — NOT NULL
- ss_time — varchar(45)
- ss_tname — varchar(45) — 상담사
- ss_name — varchar(45) — 상담대상자
- ss_msg — varchar(100)
- ss_msubject — varchar(3000)
- ss_img — varchar(45) — 회의사진
- ss_member — varchar(45)
- ss_mday — date
- ss_pa — varchar(100)
- ss_cnt — int
- ss_day — varchar(45)
- sf_idx — varchar(45)
- ss_p — varchar(3000)
- ss_status — varchar(45)
- ss_num — varchar(45)
advice_t
- so_idx — int — Primary key — NOT NULL
- sf_idx2 — bigint — Foreign key → staff_t.sf_idx — NOT NULL
- rt_idx2 — bigint — Foreign key → staff_t.rt_idx2 — NOT NULL
- c_idx2 — bigint — Foreign key → course_t.c_idx — NOT NULL
- ct_idx2 — bigint — Foreign key → course_t.ct_idx2 — NOT NULL
- tr_idx2 — bigint — Foreign key → trainee_t.tr_idx — NOT NULL
- so_day — date
- so_menu — varchar(45)
- so_pp — varchar(60)
- so_subject — varchar(3000)
- so_pd — varchar(3000)
- so_status — int
- so_tname — varchar(45)
board_t
- bd_idx — int — Primary key — NOT NULL
- c_idx2 — bigint — Foreign key → course_t.c_idx — NOT NULL
- rt_idx2 — bigint — Foreign key → course_t.rt_idx2 — NOT NULL
- ct_idx2 — bigint — Foreign key → course_t.ct_idx2 — NOT NULL
- bd_subject — varchar(45)
- bd_writer — varchar(45)
- bd_write_date — varchar(45)
- bd_hit — varchar(45)
- bd_content — longtext
- bd_fname — varchar(100)
- bd_oname — varchar(100)
- bd_notice — varchar(45)
- bd_status — varchar(45)
business_t
- bs_idx — int — Primary key — NOT NULL
- tr_idx2 — bigint — Foreign key → trainee_t.tr_idx — NOT NULL
- rt_idx2 — bigint — Foreign key → trainee_t.rt_idx2 — NOT NULL
- ct_idx2 — bigint — Foreign key → trainee_t.ct_idx2 — NOT NULL
- bs_name — varchar(45)
- bs_job — varchar(45)
- bs_re — varchar(45)
- bs_workdpt — varchar(45)
- bs_position — varchar(45)
- bs_phone — varchar(45)
- bs_location — varchar(45)
counselingdetail_t
- cd_idx — int — Primary key — NOT NULL
- c_idx2 — bigint — Foreign key → course_t.c_idx — NOT NULL
- ct_idx2 — bigint — Foreign key → course_t.ct_idx2 — NOT NULL
- sf_idx2 — bigint — Foreign key → staff_t.sf_idx — NOT NULL
- ct_idx3 — bigint — Foreign key → course_type_t.ct_idx — NOT NULL
- id_idx2 — int — Foreign key → inflowpath_t.id_idx — NOT NULL
- ns_idx2 — int — Foreign key → nextscheduled_t.ns_idx — NOT NULL
- cd_date — varchar(45)
- cd_name — varchar(45)
- cd_phone — varchar(45)
- cd_status — varchar(45)
- cd_manageStatus — varchar(45)
- cd_cancel — varchar(45)
- cd_subject — varchar(45)
- cd_status2 — varchar(45)
- cd_personalNum — varchar(45)
- cd_card — varchar(45)
- cd_address — varchar(45)
- cd_result — varchar(45)
- cd_cardType — varchar(45)
counselreceipt_t
- cr_idx — int — Primary key — NOT NULL
- cr_name — varchar(45)
- cr_score — varchar(45)
- cr_status — varchar(45)
- cr_status2 — int
course_t
- c_idx — bigint — Primary key — NOT NULL
- r_idx2 — bigint — Foreign key → room_t.r_idx — NOT NULL
- sf_idx2 — bigint — Foreign key → staff_t.sf_idx — NOT NULL
- rt_idx2 — bigint — Foreign key → staff_t.rt_idx2 — NOT NULL
- ct_idx2 — bigint — Foreign key → course_type_t.ct_idx — NOT NULL
- c_name — varchar(50)
- start_date — date
- end_date — date
- course_fee — varchar(45)
- c_peo_num — int
- c_round_num — int
- c_status — varchar(45)
- c_day — varchar(45)
- c_time — varchar(45)
course_type_t
- ct_idx — bigint — Primary key — NOT NULL
- ct_name — varchar(45)
- ct_color — varchar(45)
evaluation_factor_t
- ef_idx — int — Primary key — NOT NULL
- ef_name — varchar(45)
- ef_subject — varchar(300)
- ef_score — varchar(45)
file_t
- f_idx — bigint — Primary key — NOT NULL
- c_idx2 — bigint — Foreign key → course_t.c_idx — NOT NULL
- f_name — varchar(45)
- f_info — varchar(45)
formdownload_t
- fd_idx — bigint — Primary key — NOT NULL
- fd_subject — varchar(100)
- fd_fname — varchar(100)
- fd_oname — varchar(100)
inflowpath_t
- id_idx — int — Primary key — NOT NULL
- id_name — varchar(45)
- id_status — int
nextscheduled_t
- ns_idx — int — Primary key — NOT NULL
- ns_name — varchar(45)
- ns_status — int
qc_t
- qc_idx — int — Primary key — NOT NULL
- qc_name — varchar(45)
- qc_date — varchar(45)
- qc_place — varchar(45)
- tr_idx — varchar(45)
- qc_cname — varchar(45)
- qc_day — varchar(45)
- qc_job — varchar(45)
- qc_position — varchar(45)
- qc_sal — varchar(45)
- qc_elevel — varchar(45)
- qc_flevel — varchar(45)
- qc_wlevel — varchar(45)
- qc_memo — varchar(45)
- qc_plevel — varchar(45)
- qc_xlevel — varchar(45)
- c_idx — varchar(45)
- qc_tridx — varchar(45)
- qc_flname — varchar(45)
right_t
- rt_idx — bigint — Primary key — NOT NULL
- rt_name — varchar(45)
room_t
- r_idx — bigint — Primary key — NOT NULL
- r_name — varchar(45)
- r_sep — int
- r_status — int
skill_t
- sk_idx — bigint — Primary key — NOT NULL
- s_idx2 — bigint — Foreign key → subject_t.s_idx — NOT NULL
- sk_name — varchar(45)
- sk_status — varchar(45)
staff_t
- sf_idx — bigint — Primary key — NOT NULL
- rt_idx2 — bigint — Foreign key → right_t.rt_idx — NOT NULL
- sf_code — varchar(45) — NOT NULL
- sf_name — varchar(45)
- sf_phone — varchar(45)
- sf_email — varchar(45)
- sf_job — varchar(45)
- sf_hire_date — date
- sf_fire_date — date
- status — int
- sf_id — varchar(45)
- sf_pwd — varchar(45)
- sf_fname — varchar(45)
- sf_link — int
- sf_mgr — int
subject_t
- s_idx — bigint — Primary key — NOT NULL
- c_idx2 — bigint — Foreign key → course_t.c_idx — NOT NULL
- rt_idx2 — bigint — Foreign key → course_t.rt_idx2 — NOT NULL
- ct_idx2 — bigint — Foreign key → course_t.ct_idx2 — NOT NULL
- s_title — varchar(50)
- us_name — varchar(10)
- s_type — varchar(45)
- sf_name — varchar(40)
- s_category_num — varchar(40)
- hour — bigint
- r_name — varchar(40)
- s_status — varchar(10)
suggestion_t
- sg_idx — bigint — Primary key — NOT NULL
- c_idx2 — bigint — Foreign key → course_t.c_idx — NOT NULL
- rt_idx2 — bigint — Foreign key → course_t.rt_idx2 — NOT NULL
- ct_idx2 — bigint — Foreign key → course_t.ct_idx2 — NOT NULL
- sg_subject — varchar(45)
- sg_writer — varchar(45)
- sg_write_date — varchar(45)
- sg_hit — varchar(45)
- sg_content — longtext
- sg_file_name — varchar(45)
- sg_ori_name — varchar(45)
- notice — int
- status — int
time_t
- ti_idx — bigint — Primary key — NOT NULL
- ti_class — varchar(10)
- ti_str_time — time
- ti_end_time — time
trainee_t
- tr_idx — bigint — Primary key — NOT NULL
- c_idx2 — bigint — Foreign key → course_t.c_idx — NOT NULL
- rt_idx2 — bigint — Foreign key → course_t.rt_idx2 — NOT NULL
- ct_idx2 — bigint — Foreign key → course_t.ct_idx2 — NOT NULL
- tr_name — varchar(45)
- tr_rrn — varchar(45)
- tr_phone — varchar(45)
- tr_hp — varchar(45)
- tr_pos_code — varchar(45)
- tr_addr — varchar(45)
- status — int
- tr_memo — varchar(45)
- ct_code — varchar(45)
- tr_total_fee — bigint
- s_code — varchar(45)
- c_img — varchar(45)
- ss_end — date
- ss_num — varchar(45)
- tr_nowstatus — int
- tr_cancel_date — varchar(45)
- tr_cancel_text — varchar(45)
- t_path — varchar(45)
- file_name — varchar(45)
- ori_name — varchar(45)
- tr_hrd — varchar(45)
- tr_refund — varchar(45)
- tr_bc — varchar(45)
- tr_card — varchar(45)
- tr_charge — varchar(45)
- tr_etc — varchar(3000)
trainingdiary_t
- td_idx — int — Primary key — NOT NULL
- write_date — date
- td_attend — varchar(45)
- td_tardy — varchar(45)
- td_earlyLeave — varchar(45)
- td_significant — longtext
- c_idx — varchar(45)
- admin_check — varchar(45)
- ceo_check — varchar(45)
trainupload_t
- tn_idx — bigint — Primary key — NOT NULL
- subject — varchar(50)
- content — text
- file_name — varchar(50)
- ori_name — varchar(50)
- status — varchar(45)
- ip — varchar(45)
trfinal_t
- tf_idx — int — Primary key — NOT NULL
- tr_idx2 — bigint — Foreign key → trainee_t.tr_idx — NOT NULL
- tf_name — varchar(45)
- tf_year — varchar(45)
- tf_major — varchar(45)
weeklymeeting_t
- wk_idx — int — Primary key — NOT NULL
- wk_deptname — varchar(45)
- wk_name — varchar(45)
- wk_date — date
- wk_title — varchar(45)
- wk_attendance — varchar(45)
- wk_absentee — varchar(45)
- wk_discussion — varchar(500)
- wk_announcement — varchar(500)
- wk_item — varchar(200)
- wk_image — varchar(45)
- wk_status — varchar(45)
- wk_file_name — varchar(45)
- wk_ori_name — varchar(45)
workplus_t
- wp_idx — int — Primary key — NOT NULL
- c_idx2 — bigint — Foreign key → course_t.c_idx — NOT NULL
- tr_idx2 — bigint — Foreign key → trainee_t.tr_idx — NOT NULL
- wp_re — varchar(45)
- wp_name — varchar(45)
- wp_work — varchar(45)
- wp_skill — varchar(45)
- wp_etc — varchar(45)
- wp_area — varchar(45)
- wp_hope — varchar(45)
- wp_pay — varchar(45)
- wp_com — varchar(45)
- wp_form — varchar(45)
- wp_week — varchar(45)
- wp_time — varchar(45)
- wp_memo — varchar(45)
- wp_wname — varchar(45)
- wp_number — varchar(45)
- wp_check — varchar(45)
- wp_addr — varchar(45)
- wp_phone — varchar(45)
- wp_job — varchar(45)
- wp_is — varchar(45)
- wp_wday — varchar(45)
- file_name — varchar(45)
- ori_name — varchar(45)