indudoctor
테이블 (3)
구인게시판 (g5_write_jobsearch)
- wr_id — int(11) — 기본 키 — NOT NULL — wr_id
- wr_num — int(11) — wr_num
- wr_reply — varchar(10) — wr_reply
- wr_parent — int(11) — wr_parent
- wr_is_comment — tinyint(11) — wr_is_comment
- wr_comment — int(11) — wr_comment
- wr_comment_reply — varchar(5) — wr_comment_reply
- ca_name — varchar(255) — ca_name
- wr_option — set — wr_option
- wr_subject — varchar(255) — wr_subject
- wr_content — text — wr_content
- wr_seo_title — varchar(255) — wr_seo_title
- wr_link1 — text — wr_link1
- wr_link2 — text — wr_link2
- wr_link1_hit — int(11) — wr_link1_hit
- wr_link2_hit — int(11) — wr_link2_hit
- wr_hit — int(11) — wr_hit
- wr_good — int(11) — wr_good
- wr_nogood — INT(11) — wr_nogood
- mb_id — VARCHAR(20) — mb_id
- wr_password — VARCHAR(255) — wr_password
- wr_name — VARCHAR(255) — wr_name
- wr_email — VARCHAR(255) — wr_email
- wr_homepage — VARCHAR(255) — wr_homepage
- wr_datetime — DATETIME — wr_datetime
- wr_file — TINYINT — wr_file
- wr_last — VARCHAR(19) — wr_last
- wr_ip — VARCHAR(255) — wr_ip
- wr_facebook_user — VARCHAR(255) — wr_facebook_user
- wr_twitter_user — VARCHAR(255) — wr_twitter_user
- wr_1 — VARCHAR(255) — wr_1
- wr_2 — VARCHAR(255) — wr_2
- wr_3 — VARCHAR(255) — wr_3
- wr_4 — VARCHAR(255) — wr_4
- wr_5 — VARCHAR(255) — wr_5
- wr_6 — VARCHAR(255) — wr_6
- wr_7 — VARCHAR(255) — wr_7
- WR_8 — VARCHAR(255) — WR_8
- WR_9 — VARCHAR(255) — WR_9
- WR_10 — VARCHAR(255) — WR_10
- 구인_공고_종류 (wr_gooin_mem) — varchar(255) — 구인_공고_종류
- 구인기간(채용시 마감) (wr_gooin_chk) — char(50) — 구인기간(채용시 마감)
- 구인기간_끝나는날짜 (wr_fin_date) — DATETIME — wr_fin_date
- 급여조건 (wr_salary_conditions) — VARCHAR(50) — wr_salary_conditions
- 급여범위 (wr_salary_condit_range) — VARCHAR(50) — wr_salary_condit_range
- 근무형태 (wr_form_service) — VARCHAR(50) — wr_form_service
- 이메일_전화_선택_여부 (wr_email_check) — VARCHAR(50) — 이메일_전화_선택_여부
- 연락처_선택_여부 (wr_phone_check) — VARCHAR(50) — 연락처_선택_여부
- 당담자 (wr_person_in_charge) — VARCHAR(50) — wr_person_in_charge
- 직책 (wr_position_office) — VARCHAR(50) — 직책
- 연락쳐 (wr_repr_phone) — VARCHAR(50) — wr_repr_phone
- 이메일 (wr_repr_email) — VARCHAR(50) — 이메일
- 파일 경로 1 (wr_file_patch1) — text — 파일 경로 1
- 파일_경로2 (wr_file_patch2) — text — file_patch2
- 희망지역 (wr_hope_region) — varchar(50) — 희망지역
- 직업 (wr_job) — varchar(50) — 직업
구직게시판 (write_doctorjoboffer)
- wr_id — int(11) — 기본 키 — NOT NULL — wr_id
- wr_num — int(11) — wr_num
- wr_reply — varchar(10) — wr_reply
- wr_parent — int(11) — wr_parent
- wr_is_comment — tinyint(11) — wr_is_comment
- wr_comment — int(11) — wr_comment
- wr_comment_reply — varchar(5) — wr_comment_reply
- ca_name — varchar(255) — ca_name
- wr_option — set — wr_option
- wr_subject — varchar(255) — wr_subject
- wr_content — text — wr_content
- wr_seo_title — varchar(255) — wr_seo_title
- wr_link1 — text — wr_link1
- wr_link2 — text — wr_link2
- wr_link1_hit — int(11) — wr_link1_hit
- wr_link2_hit — int(11) — wr_link2_hit
- wr_hit — int(11) — wr_hit
- wr_good — int(11) — wr_good
- wr_nogood — INT(11) — wr_nogood
- mb_id — VARCHAR(20) — mb_id
- wr_password — VARCHAR(255) — wr_password
- wr_name — VARCHAR(255) — wr_name
- wr_email — VARCHAR(255) — wr_email
- wr_homepage — VARCHAR(255) — wr_homepage
- wr_datetime — DATETIME — wr_datetime
- wr_file — TINYINT — wr_file
- wr_last — VARCHAR(19) — wr_last
- wr_ip — VARCHAR(255) — wr_ip
- wr_facebook_user — VARCHAR(255) — wr_facebook_user
- wr_twitter_user — VARCHAR(255) — wr_twitter_user
- wr_1 — VARCHAR(255) — wr_1
- wr_2 — VARCHAR(255) — wr_2
- wr_3 — VARCHAR(255) — wr_3
- wr_4 — VARCHAR(255) — wr_4
- wr_5 — VARCHAR(255) — wr_5
- wr_6 — VARCHAR(255) — wr_6
- wr_7 — VARCHAR(255) — wr_7
- WR_8 — VARCHAR(255) — WR_8
- WR_9 — VARCHAR(255) — WR_9
- WR_10 — VARCHAR(255) — WR_10
- 구인_공고_종류 (wr_gooin_mem) — varchar(255) — 구인_공고_종류
- 구인기간(채용시 마감) (wr_gooin_chk) — char(50) — 구인기간(채용시 마감)
- 구인기간_끝나는날짜 (wr_fin_date) — DATETIME — wr_fin_date
- 급여조건 (wr_salary_conditions) — VARCHAR(50) — wr_salary_conditions
- 급여범위 (wr_salary_condit_range) — VARCHAR(50) — wr_salary_condit_range
- 근무형태 (wr_form_service) — VARCHAR(50) — wr_form_service
- 이메일_전화_선택_여부 (wr_email_check) — VARCHAR(50) — 이메일_전화_선택_여부
- 연락처_선택_여부 (wr_phone_check) — VARCHAR(50) — 연락처_선택_여부
- 당담자 (wr_person_in_charge) — VARCHAR(50) — wr_person_in_charge
- 직책 (wr_position_office) — VARCHAR(50) — 직책
- 연락쳐 (wr_repr_phone) — VARCHAR(50) — wr_repr_phone
- 이메일 (wr_repr_email) — VARCHAR(50) — 이메일
- 파일_경로_1 (wr_file_patch1) — TEXT — 파일_경로_1
- 파일_경로_2 (wr_file_patch2) — TEXT — 파일_경로_2
- 희망지역 (wr_hope_region) — varchar(50) — 희망지역
- 직업 (wr_job) — varchar(50) — 직업
- 신입_경력_선택 (wr_new_career_checkyn) — varchar(50) — 신입_경력_선택
- 년차 (wr_career_year) — int(11) — 년차
의사 전용 구인게시판 (g5_write_doctorjoboffer)
- wr_id — int(11) — 기본 키 — NOT NULL — wr_id
- wr_num — int(11) — wr_num
- wr_reply — varchar(10) — wr_reply
- wr_parent — int(11) — wr_parent
- wr_is_comment — tinyint(11) — wr_is_comment
- wr_comment — int(11) — wr_comment
- wr_comment_reply — varchar(5) — wr_comment_reply
- ca_name — varchar(255) — ca_name
- wr_option — set — wr_option
- wr_subject — varchar(255) — wr_subject
- wr_content — text — wr_content
- wr_seo_title — varchar(255) — wr_seo_title
- wr_link1 — text — wr_link1
- wr_link2 — text — wr_link2
- wr_link1_hit — int(11) — wr_link1_hit
- wr_link2_hit — int(11) — wr_link2_hit
- wr_hit — int(11) — wr_hit
- wr_good — int(11) — wr_good
- wr_nogood — INT(11) — wr_nogood
- mb_id — VARCHAR(20) — mb_id
- wr_password — VARCHAR(255) — wr_password
- wr_name — VARCHAR(255) — wr_name
- wr_email — VARCHAR(255) — wr_email
- wr_homepage — VARCHAR(255) — wr_homepage
- wr_datetime — DATETIME — wr_datetime
- wr_file — TINYINT — wr_file
- wr_last — VARCHAR(19) — wr_last
- wr_ip — VARCHAR(255) — wr_ip
- wr_facebook_user — VARCHAR(255) — wr_facebook_user
- wr_twitter_user — VARCHAR(255) — wr_twitter_user
- wr_1 — VARCHAR(255) — wr_1
- wr_2 — VARCHAR(255) — wr_2
- wr_3 — VARCHAR(255) — wr_3
- wr_4 — VARCHAR(255) — wr_4
- wr_5 — VARCHAR(255) — wr_5
- wr_6 — VARCHAR(255) — wr_6
- wr_7 — VARCHAR(255) — wr_7
- WR_8 — VARCHAR(255) — WR_8
- WR_9 — VARCHAR(255) — WR_9
- WR_10 — VARCHAR(255) — WR_10
- 구인_공고_종류 (wr_gooin_mem) — varchar(255) — 구인_공고_종류
- 구인기간(채용시 마감) (wr_gooin_chk) — char(50) — 구인기간(채용시 마감)
- 구인기간_끝나는날짜 (wr_fin_date) — DATETIME — wr_fin_date
- 급여조건 (wr_salary_conditions) — VARCHAR(50) — wr_salary_conditions
- 급여범위 (wr_salary_condit_range) — VARCHAR(50) — wr_salary_condit_range
- 근무형태 (wr_form_service) — VARCHAR(50) — wr_form_service
- 이메일_전화_선택_여부 (wr_email_check) — VARCHAR(50) — 이메일_전화_선택_여부
- 연락처_선택_여부 (wr_phone_check) — VARCHAR(50) — 연락처_선택_여부
- 당담자 (wr_person_in_charge) — VARCHAR(50) — wr_person_in_charge
- 직책 (wr_position_office) — VARCHAR(50) — 직책
- 연락쳐 (wr_repr_phone) — VARCHAR(50) — wr_repr_phone
- 이메일 (wr_repr_email) — VARCHAR(50) — 이메일
- 파일 경로 1 (wr_file_patch1) — text — 파일 경로 1
- 피일 경로2 (wr_file_patch2) — text — wr_file_fatch2
- 희망지역 (wr_hope_region) — varchar(50) — 희망지역
- 직업 (wr_job) — VARCHAR(50) — 직업