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) — 직업