project
Tables (42)
advice_sst
- ss_idx — int — Primary key — 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)
- c_idx — 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
- so_day — date
- tr_idx — int
- sf_idx — int
- so_menu — varchar(45)
- so_pp — varchar(60)
- so_subject — varchar(3000)
- so_pd — varchar(3000)
- c_idx — int
- so_status — int
- so_tname — varchar(45)
board_t (게시판)
- bd_idx (Key) — BIGINT — Primary key — NOT NULL
- bd_subject (Field) — VARCHAR(45)
- bd_writer (Field2) — VARCHAR(45)
- bd_write_date (Field3) — VARCHAR(45)
- bd_hit (Field4) — VARCHAR(45)
- bd_content (Field5) — LONGTEXT
- bd_file (Field6) — VARCHAR(45)
- bd_notice (Field7) — VARCHAR(45)
- bd_status (Field8) — VARCHAR(45)
board_t
- bd_idx — int — Primary key — 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)
- c_idx — bigint — NOT NULL
business_t
- bs_idx — int — Primary key — 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)
- tr_idx — varchar(45)
counselingdetail_t
- cd_idx — int — Primary key — NOT NULL
- sf_idx — int
- cd_date — varchar(45)
- cd_name — varchar(45)
- cd_phone — varchar(45)
- ct_idx — varchar(45)
- c_idx — varchar(45)
- cd_status — varchar(45)
- cd_manageStatus — varchar(45)
- cd_cancel — varchar(45)
- ns_idx — varchar(45)
- cd_subject — varchar(45)
- cd_status2 — varchar(45)
- cd_personalNum — varchar(45)
- cd_card — varchar(45)
- cd_address — varchar(45)
- id_idx — 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 (Key) — BIGINT — Primary key — NOT NULL
- ct_idx (Key2) — BIGINT — Foreign key → course_type.ct_idx — NOT NULL
- ti_idx (Key3) — BIGINT — Foreign key → time_t.ti_idx — NOT NULL
- sf_idx (Key4) — BIGINT — Foreign key → staff_t.sf_idx — NOT NULL
- s_idx (Key5) — BIGINT — Foreign key → subject_t.s_idx — NOT NULL
- r_idx (Key6) — BIGINT — Foreign key → room_t.r_idx — NOT NULL
- rt_idx (Key22) — BIGINT — Foreign key → staff_t.rt_idx — NOT NULL
- c_name (Field) — VARCHAR(45)
- start_date (Field2) — DATE
- end_date (Field3) — DATE
- course_fee (Field4) — VARCHAR(45)
- c_peo_num (Field5) — INT
- c_round_num (Field6) — INT
- c_status (Field12) — VARCHAR(45)
course_t
- c_idx — bigint — Primary key — NOT NULL
- c_name — varchar(50)
- start_date — date
- end_date — date
- course_fee — varchar(45)
- c_peo_num — int
- c_round_num — int
- sf_idx — bigint
- r_idx — bigint
- ct_idx — bigint
- c_status — varchar(45)
- c_day — varchar(45)
- c_time — varchar(45)
- c_timeExel — varchar(100)
course_type (과정타입)
- ct_idx (Key) — BIGINT — Primary key — NOT NULL
- ct_name (Field) — VARCHAR(45)
- ct_color (Field2) — 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
- f_name — varchar(45)
- f_info — varchar(45)
- c_idx — bigint
file_t (첨부파일)
- f_idx (Key) — BIGINT — Primary key — NOT NULL
- c_idx (Key2) — BIGINT — Foreign key → course_t.c_idx — NOT NULL
- r_idx (Key6) — BIGINT — Foreign key → course_t.r_idx — NOT NULL
- rt_idx (Key22) — BIGINT — Foreign key → course_t.rt_idx — NOT NULL
- f_name (Field) — VARCHAR(45)
- f_infi (Field2) — 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 (Key) — BIGINT — Primary key — NOT NULL
- rt_name (Field) — VARCHAR(45)
right_t
- rt_idx — bigint — Primary key — NOT NULL
- rt_name — varchar(45)
room_t (강의실)
- r_idx (Key) — BIGINT — Primary key — NOT NULL
- r_name (Field) — VARCHAR(45)
- r_sep (Field2) — INT
- Field3 — INT
room_t
- r_idx — bigint — Primary key — NOT NULL
- r_name — varchar(45)
- r_sep — int
- r_status — int
schedule_t
- schedule_idx — int — Primary key — NOT NULL
- schedule_name — varchar(45)
- start_date — varchar(45)
- end_date — varchar(45)
- schedule_detail — varchar(100)
skill_t (능력단위요소)
- sk_idx (Key) — BIGINT — Primary key — NOT NULL
- us_idx (Key2) — BIGINT — Foreign key → upskill_t.us_idx — NOT NULL
- c_idx (Key22) — BIGINT — Foreign key → upskill_t.c_idx — NOT NULL
- r_idx (Key6) — BIGINT — Foreign key → upskill_t.r_idx — NOT NULL
- rt_idx (Key222) — BIGINT — Foreign key → upskill_t.rt_idx — NOT NULL
- sk_name (Field) — VARCHAR(45)
skill_t
- sk_idx — bigint — Primary key — NOT NULL
- sk_name — varchar(45)
- s_idx — bigint
- sk_status — varchar(45)
staff_t (교직원)
- sf_idx (Key) — BIGINT — Primary key — NOT NULL
- rt_idx (Key2) — BIGINT — Foreign key → right_t.rt_idx — NOT NULL
- sf_code (Field) — VARCHAR(45)
- sf_name (Field2) — VARCHAR(45)
- sf_phone (Field3) — VARCHAR(45)
- sf_email (Field4) — VARCHAR(45)
- sf_job (Field5) — VARCHAR(45)
- sf_hire_date (Field6) — DATE
- sf_fire_date (Field7) — DATE
- status (Field8) — INT
- sf_id (Field9) — VARCHAR(45)
- sf_pwd (Field10) — VARCHAR(45)
- sf_fname (Field12) — VARCHAR(45)
- sf_link (Field13) — INT
- sf_mgr (Field14) — INT
staff_t
- sf_idx — bigint — Primary key — 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_tcr — int
- sf_mgr — int
- sf_fname — varchar(45)
- sf_link — int
- sf_tmgr — int
subject_t
- s_idx — bigint — Primary key — 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)
- c_idx — varchar(45)
- s_status — varchar(10)
subject_t (교과목)
- s_idx (Key) — BIGINT — Primary key — NOT NULL
- c_idx (Key2) — BIGINT — Foreign key → course_t.c_idx — NOT NULL
- r_idx (Key6) — BIGINT — Foreign key → course_t.r_idx — NOT NULL
- rt_idx (Key22) — BIGINT — Foreign key → course_t.rt_idx — NOT NULL
- s_title (Field) — VARCHAR(45)
- s_type (Field2) — VARCHAR(45)
- s_time (Field3) — BIGINT
- sf_idx (Field4) — BIGINT
- r_idx (Field5) — BIGINT
- sk_idx (Field6) — BIGINT
suggestion_t (건의사항)
- sg_idx (Key) — BIGINT — Primary key — NOT NULL
- sg_subject (Field) — VARCHAR(45)
- sg_writer (Field2) — VARCHAR(45)
- sg_write_date (Field3) — VARCHAR(45)
- sg_hit (Field4) — VARCHAR(45)
- sg_content (Field5) — LONGTEXT
- sg_file (Field6) — VARCHAR(45)
- notice (Field7) — INT
- c_code (Field8) — VARCHAR(45)
- status (Field9) — INT
suggestion_t
- sg_idx — bigint — Primary key — 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
- c_idx — bigint
- status — int
time_t (시간표)
- ti_idx (Key) — BIGINT — Primary key — NOT NULL
- ti_class (Field) — VARCHAR(10)
- ti_str_time (Field2) — TIME
- ti_end_time (Field3) — TIME
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
- 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)
- c_idx — 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)
trainee_t (수강생)
- tr_idx (Key) — BIGINT — Primary key — NOT NULL
- c_idx (Key2) — BIGINT — Foreign key → course_t.c_idx — NOT NULL
- ct_idx (Key3) — BIGINT — Foreign key → course_type.ct_idx — NOT NULL
- r_idx (Key6) — BIGINT — Foreign key → course_t.r_idx — NOT NULL
- rt_idx (Key22) — BIGINT — Foreign key → course_t.rt_idx — NOT NULL
- tr_name (Field) — VARCHAR(45)
- tr_rrn (Field2) — VARCHAR(45)
- tr_phone (Field3) — VARCHAR(45)
- tr_hp (Field4) — VARCHAR(45)
- tr_pos_code (Field5) — VARCHAR(45)
- tr_addr (Field6) — VARCHAR(45)
- status (Field7) — INT
- memo (Field8) — VARCHAR(45)
- tr_total_fee (Field11) — BIGINT
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 (훈련생 확인서류)
- tn_idx (Key) — BIGINT — Primary key — NOT NULL
- subject (Field) — VARCHAR(45)
- content (Field2) — LONGTEXT
- file_name (Field3) — VARCHAR(45)
- ori_name (Field4) — VARCHAR(45)
- tn_name (Field5) — VARCHAR(45)
- status (Field6) — 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
- tf_name — varchar(45)
- tf_year — varchar(45)
- tf_major — varchar(45)
- tr_idx — varchar(45)
upskill_t (능력단위)
- us_idx (Key) — BIGINT — Primary key — NOT NULL
- s_idx (Key2) — BIGINT — Foreign key → subject_t.s_idx — NOT NULL
- c_idx (Key22) — BIGINT — Foreign key → subject_t.c_idx — NOT NULL
- r_idx (Key6) — BIGINT — Foreign key → subject_t.r_idx — NOT NULL
- rt_idx (Key222) — BIGINT — Foreign key → subject_t.rt_idx — NOT NULL
- us_name (Field) — 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
- 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)
- tr_idx — varchar(45)
- c_idx — varchar(45)