해비타트
테이블 (57)
sp_ad_log
- wm_id — int(11) — 기본 키 — NOT NULL
- member_id — varchar(50) — NOT NULL — 정보주체
- admin_id — varchar(255) — 관리자id
- wm_wdate — datetime — NOT NULL — 작업일
- mb_ip — varchar(255) — ip
- change_memo — varchar(255) — 수행업무
- change_etc — varchar(255) — 비고
- adminYN — char(50)
- wm_id (wm_id2) — int(11) — 외래 키 → sp_member.wm_id — NOT NULL
sp_affiliate
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_title_y — varchar(255) — NOT NULL
- wm_title_en — varchar(255) — NOT NULL
- wm_email — varchar(50) — NOT NULL
- wm_x — varchar(100) — NOT NULL
- wm_y — varchar(100) — NOT NULL
- wm_tel — char(20) — NOT NULL
- wm_fax — char(20) — NOT NULL
- wm_zipcode — char(5) — NOT NULL
- wm_addr1 — varchar(255) — NOT NULL
- wm_addr2 — varchar(255) — NOT NULL
- wm_addr3 — varchar(255) — NOT NULL
- wm_bank1 — varchar(100) — NOT NULL
- wm_banknum1 — varchar(100) — NOT NULL
- wm_bankname1 — varchar(100) — NOT NULL
- wm_bank2 — varchar(100) — NOT NULL
- wm_banknum2 — varchar(100) — NOT NULL
- wm_bankname2 — varchar(100) — NOT NULL
- wm_dam_name — varchar(50) — NOT NULL
- wm_dam_tel — char(20) — NOT NULL
- wm_dam_num — varchar(50) — NOT NULL
- wm_builddate — date — NOT NULL
- wm_house1 — varchar(50) — NOT NULL
- wm_house2 — varchar(50) — NOT NULL
- wm_use — char(1) — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_wdate — datetime — NOT NULL
sp_apply
- wm_id — int(11) — 기본 키 — NOT NULL
- apply_idx — int(11) — NOT NULL — 지원 idx
- wm_name — varchar(100) — NOT NULL — 성명(한글)
- wm_name_eng1 — varchar(100) — NOT NULL — 성명 영문 - 성
- wm_name_eng2 — varchar(100) — NOT NULL — 성명 영문 - 이름
- wm_birth — varchar(100) — NOT NULL — 생년월일
- wm_gender — varchar(100) — NOT NULL — 성별
- wm_zipcode — varchar(50) — NOT NULL
- wm_addr1 — varchar(200) — NOT NULL
- wm_addr2 — varchar(200) — NOT NULL
- wm_tel — varchar(100) — NOT NULL — 연락처
- wm_hp — varchar(100) — NOT NULL — 긴급연락처
- wm_email — varchar(100) — NOT NULL — 이메일
- wm_yn1 — varchar(100) — NOT NULL — 보훈대상여부
- wm_bo — varchar(100) — NOT NULL — 보훈번호
- wm_yn2 — varchar(100) — NOT NULL — 장애여부
- wm_jong — varchar(100) — NOT NULL — 종교
- wm_school_check — varchar(100) — NOT NULL — 졸업상태2 / 예아니요
- wm_school — varchar(255) — NOT NULL — 학위
- wm_school1 — varchar(255) — NOT NULL — 졸업상태1
- wm_school2 — varchar(255) — NOT NULL — 입학년
- wm_school3 — varchar(255) — NOT NULL — 입학월
- wm_school4 — varchar(255) — NOT NULL — 졸업년
- wm_school5 — varchar(255) — NOT NULL — 졸업월
- wm_school6 — varchar(255) — NOT NULL — 학교
- wm_school7 — varchar(255) — NOT NULL — 전공
- wm_school8 — varchar(255) — NOT NULL — 부전공
- wm_school9 — varchar(255) — NOT NULL — 복수전공
- wm_school10 — varchar(255) — NOT NULL — 학점
- wm_school11 — varchar(255) — NOT NULL — 학점만점
- wm_school12 — varchar(255) — NOT NULL — 편입여부
- wm_school13 — varchar(255) — NOT NULL — 주/야
- wm_school14 — varchar(255) — NOT NULL — 소재지
- wm_military — varchar(255) — NOT NULL — 군필여부
- wm_military1 — varchar(255) — NOT NULL — 군별
- wm_military2 — varchar(255) — NOT NULL — 계급
- wm_military3 — varchar(255) — NOT NULL — 병과
- wm_military44 — varchar(255) — NOT NULL — 제대사유
- wm_military4 — varchar(255) — NOT NULL — 기간년1
- wm_military5 — varchar(255) — NOT NULL — 기간월1
- wm_military6 — varchar(255) — NOT NULL — 기간년2
- wm_military7 — varchar(255) — NOT NULL — 기간월2
- wm_military8 — varchar(255) — NOT NULL — 특이사항
- wm_language1 — varchar(255) — NOT NULL — 외국어명
- wm_language2 — varchar(255) — NOT NULL — 외국어시험명
- wm_language3 — varchar(255) — NOT NULL — 응시년월일 - 년
- wm_language4 — varchar(255) — NOT NULL — 응시년월일 - 월
- wm_language4_1 — varchar(255) — NOT NULL — 응시년월일 - 일
- wm_language5 — varchar(255) — NOT NULL — 외국어 - 점수
- wm_license1 — varchar(255) — NOT NULL — 자격사항 - 종류
- wm_license2 — varchar(255) — NOT NULL — 자격사항 - 등급
- wm_license3 — varchar(255) — NOT NULL — 자격사항 - 인증기관
- wm_license4 — varchar(255) — NOT NULL — 자격사항 - 취득일 년
- wm_license5 — varchar(255) — NOT NULL — 자격사항 - 취득일 월
- wm_active1 — varchar(255) — NOT NULL — 활동구분
- wm_active2 — varchar(255) — NOT NULL — 활동명
- wm_active3 — varchar(255) — NOT NULL — 활동기간1 년
- wm_active4 — varchar(255) — NOT NULL — 활동기간1 월
- wm_active5 — varchar(255) — NOT NULL — 활동기간2 년
- wm_active6 — varchar(255) — NOT NULL — 활동기간2 월
- … +26
sp_banner
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_type — varchar(10) — NOT NULL
- wm_type2 — char(1) — NOT NULL
- wm_type3 — varchar(50) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_title1 — text — NOT NULL
- wm_link — varchar(255) — NOT NULL
- wm_movelink — varchar(255) — NOT NULL
- wm_link_target — varchar(10) — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_upfile_name — varchar(50) — NOT NULL
- wm_upfile_mo_name — varchar(50) — NOT NULL
- wm_useYN — char(1) — NOT NULL
- wm_wdate — datetime — NOT NULL
sp_banner2
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_type — varchar(10) — NOT NULL
- wm_main — varchar(10) — NOT NULL — 메인노출여부
- wm_state — varchar(10) — NOT NULL — 황성상태
- wm_photo_yn — varchar(10) — NOT NULL — 포토 갤러리 사용여부
- wm_photo_ca — varchar(255) — NOT NULL — 포토갤러리 카테고리
- wm_photo_ca2 — varchar(255) — NOT NULL — 포토갤러리 카테고리
- wm_type2 — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_hit — varchar(255) — NOT NULL — 조회
- wm_temp1 — text — NOT NULL — 소개제목
- wm_temp2 — text — NOT NULL — 소개내용
- wm_year — text — NOT NULL — 황동년도
- wm_act — mediumtext — NOT NULL — 황동내용
- wm_link — varchar(255) — NOT NULL
- wm_movelink — varchar(255) — NOT NULL
- wm_link_target — varchar(10) — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_upfile_name — varchar(50) — NOT NULL
- wm_upfile_name1 — varchar(50) — NOT NULL
- wm_upfile_name2 — varchar(50) — NOT NULL
- wm_upfile_name3 — varchar(50) — NOT NULL
- wm_upfile_name4 — varchar(50) — NOT NULL
- wm_upfile_mo_name — varchar(50) — NOT NULL
- wm_wdate — datetime — NOT NULL
sp_banner3
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_type — varchar(50) — NOT NULL — 후원등급
- wm_main — varchar(10) — NOT NULL — 메인노출여부
- wm_state — varchar(10) — NOT NULL — 후원기업 소개 페이지 노출
- wm_title — varchar(255) — NOT NULL
- wm_sdate — varchar(50) — NOT NULL
- wm_edate — varchar(50) — NOT NULL
- wm_name — varchar(50) — NOT NULL — 담당자
- wm_tel — varchar(50) — NOT NULL — 담당자 연락처
- wm_link — varchar(255) — NOT NULL
- wm_content1 — mediumtext — NOT NULL
- wm_price — int(11) — NOT NULL — 후원금액
- wm_sort — int(11) — NOT NULL
- wm_upfile_name — varchar(100) — NOT NULL
- wm_upfile_name4 — varchar(100) — NOT NULL
- wm_upfile_mo_name — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
sp_banner4
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_type — varchar(10) — NOT NULL
- wm_main — varchar(10) — NOT NULL — 메인노출여부
- wm_state — varchar(10) — NOT NULL — 황성상태
- wm_title — varchar(255) — NOT NULL
- wm_content1 — varchar(255) — NOT NULL
- wm_hit — varchar(255) — NOT NULL — 조회
- wm_link — varchar(255) — NOT NULL
- wm_movelink — varchar(255) — NOT NULL
- wm_link_target — varchar(10) — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_upfile_name — varchar(50) — NOT NULL
- wm_upfile_mo_name — varchar(50) — NOT NULL
- wm_wdate — datetime — NOT NULL
sp_board_file
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_table — varchar(20) — NOT NULL
- wm_bid — int(11) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_filename — varchar(255) — NOT NULL
- wm_source — varchar(255) — NOT NULL
- wm_down_count — int(11) — NOT NULL
- wm_file_width — int(11) — NOT NULL
- wm_file_height — smallint(6) — NOT NULL
- wm_file_type — tinyint(4) — NOT NULL
- wm_file_size — int(11) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_id (wm_id2) — int(11) — 외래 키 → sp_wm_supportnews1.wm_id — NOT NULL
- wm_id (wm_id3) — int(11) — 외래 키 → sp_wm_supportnews.wm_id — NOT NULL
- wm_id (wm_id4) — int(11) — 외래 키 → sp_wm_campaign.wm_id — NOT NULL
- wm_id (wm_id5) — int(11) — 외래 키 → sp_wm_notice.wm_id — NOT NULL
- wm_id (wm_id6) — int(11) — 외래 키 → sp_wm_newsroom3.wm_id — NOT NULL
- wm_id (wm_id7) — int(11) — 외래 키 → sp_wm_newsroom4.wm_id — NOT NULL
- wm_id (wm_id8) — int(11) — 외래 키 → sp_wm_newsroom.wm_id — NOT NULL
- wm_id (wm_id9) — int(11) — 외래 키 → sp_wm_video.wm_id — NOT NULL
- wm_id (wm_id10) — int(11) — 외래 키 → sp_wm_campaign1.wm_id — NOT NULL
- wm_id (wm_id11) — int(11) — 외래 키 → sp_wm_reporteng.wm_id — NOT NULL
- wm_id (wm_id12) — int(11) — 외래 키 → sp_wm_recruit.wm_id — NOT NULL
- wm_id (wm_id13) — int(11) — 외래 키 → sp_wm_notice3.wm_id — NOT NULL
- wm_id (wm_id14) — int(11) — 외래 키 → sp_wm_notice2.wm_id — NOT NULL
- wm_id (wm_id15) — int(11) — 외래 키 → sp_wm_qna.wm_id — NOT NULL
- wm_id (wm_id16) — int(11) — 외래 키 → sp_wm_newsroom2.wm_id — NOT NULL
- wm_id (wm_id17) — int(11) — 외래 키 → sp_wm_faq.wm_id — NOT NULL
- wm_id (wm_id18) — int(11) — 외래 키 → sp_wm_videoeng.wm_id — NOT NULL
- wm_id (wm_id19) — int(11) — 외래 키 → sp_wm_report.wm_id — NOT NULL
sp_board_set
- wm_table — varchar(20) — 기본 키 — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_pagename — varchar(255) — NOT NULL
- wm_mpagename — varchar(255) — NOT NULL
- wm_category — varchar(255) — NOT NULL
- wm_list_level — tinyint(4) — NOT NULL
- wm_read_level — tinyint(4) — NOT NULL
- wm_write_level — tinyint(4) — NOT NULL
- wm_replay_level — tinyint(4) — NOT NULL
- wm_comment_level — tinyint(4) — NOT NULL
- wm_replay — char(1) — NOT NULL
- wm_comment — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_file — char(1) — NOT NULL
- wm_file_count — tinyint(4) — NOT NULL
- wm_use_filedown — char(1) — NOT NULL
- wm_skin — varchar(255) — NOT NULL
- wm_mskin — varchar(255) — NOT NULL
- wm_content — varchar(1000) — NOT NULL
- wm_new_icon — tinyint(4) — NOT NULL
- wm_orderby — varchar(255) — NOT NULL
- wm_pagenum — tinyint(4) — NOT NULL
- wm_editor — varchar(10) — NOT NULL
- wm_menunum — int(11) — NOT NULL
- wm_ip — char(1) — NOT NULL
- wm_thumb_width — smallint(6) — NOT NULL
- wm_thumb_height — smallint(6) — NOT NULL
- wm_add_type — char(1) — NOT NULL
- wm_add_num — tinyint(4) — NOT NULL
- wm_recapcha_use — char(1) — NOT NULL
- wm_recapcha_level — tinyint(4) — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wm_wdate — datetime — NOT NULL
sp_campaign
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — text — NOT NULL
- wm_sdate — datetime — NOT NULL
- wm_edate — datetime — NOT NULL
- wm_state — varchar(10) — NOT NULL
- wm_kind — varchar(10) — NOT NULL
- wm_upfile_name — varchar(50) — NOT NULL
- wm_1 — varchar(255) — NOT NULL
- wm_2 — varchar(255) — NOT NULL
- wm_hit — int(10) — NOT NULL
- wm_content_pc — mediumtext — NOT NULL
- wm_content_m — mediumtext — NOT NULL
- wm_wdate — datetime — NOT NULL
sp_category
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_ca_id — char(6) — NOT NULL
- wm_ca_name — varchar(255) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — text — NOT NULL
- wm_upfile_name — varchar(150) — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_wdate — datetime — NOT NULL
sp_company
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_area — varchar(50) — NOT NULL
- wm_area2 — varchar(50) — NOT NULL
- wm_name — varchar(100) — NOT NULL
- wm_view_yn — varchar(50) — NOT NULL
- wm_tel — varchar(50) — NOT NULL
- wm_tel2 — varchar(50) — NOT NULL
- wm_addr — varchar(255) — NOT NULL
- wm_zipcode — varchar(255) — NOT NULL
- wm_xval — varchar(30) — NOT NULL
- wm_yval — varchar(30) — NOT NULL
- wm_business_hour — varchar(150) — NOT NULL
- wm_content — text — NOT NULL
- wm_upfile_name — varchar(150) — NOT NULL
- wm_upfile_name2 — varchar(150) — NOT NULL
- wm_upfile_name3 — varchar(150) — NOT NULL
- wm_upfile_name4 — varchar(150) — NOT NULL
- wm_file2 — varchar(150) — NOT NULL
- wm_file3 — varchar(150) — NOT NULL
- wm_file4 — varchar(150) — NOT NULL
- wm_wdate — datetime — NOT NULL
sp_cons
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_pagename — varchar(255) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — text — NOT NULL
- wm_wdate — datetime — NOT NULL
sp_email
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_level — tinyint(4)
- wm_to — varchar(500)
- wm_from — varchar(100)
- wm_title — varchar(255) — NOT NULL
- wm_content — text
- wm_wdate — datetime — NOT NULL
sp_emailform
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_code — varchar(100) — NOT NULL
- wm_form — varchar(100) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — text — NOT NULL
- wm_type — varchar(50) — NOT NULL
- wm_from — varchar(50) — NOT NULL
- wm_to — varchar(50) — NOT NULL
- wm_use — char(1) — NOT NULL
sp_header
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_description — varchar(255)
- wm_ogtype — varchar(255)
- wm_ogtitle — varchar(255)
- wm_ogdescription — varchar(255)
- wm_upfile_name — varchar(255)
- wm_ogurl — varchar(255)
- wm_naverkey — varchar(255)
- wm_script — text — NOT NULL
- wm_wdate — datetime — NOT NULL
sp_history
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_lang — char(2) — NOT NULL
- wm_category — varchar(100) — NOT NULL
- wm_year — varchar(255) — NOT NULL
- wm_month — varchar(255) — NOT NULL
- wm_day — varchar(255) — NOT NULL
- wm_content — text — NOT NULL
- wm_wdate — datetime — NOT NULL
sp_letter
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_name — varchar(50)
- wm_email — varchar(100)
- wm_ip — varchar(20) — NOT NULL
- wm_wdate — datetime — NOT NULL
sp_log_pv
- wm_join_date — char(8) — NOT NULL
- wm_join_time — char(6) — NOT NULL
- wm_join_weekday — tinyint(4) — NOT NULL
- wm_join_count — tinyint(4) — NOT NULL
- wm_join_route — varchar(500)
- wm_join_ip — varchar(20) — NOT NULL
- wm_join_id — varchar(30) — NOT NULL
- wm_join_name — varchar(30) — NOT NULL
- wm_join_page — varchar(300)
- wm_join_browser — varchar(30) — NOT NULL
- wm_join_os — varchar(30) — NOT NULL
- wm_join_agent — varchar(300)
- wm_wdate — datetime — NOT NULL
sp_log_uv
- wm_join_date — char(8) — NOT NULL
- wm_join_time — char(6) — NOT NULL
- wm_join_weekday — tinyint(4) — NOT NULL
- wm_join_count — tinyint(4) — NOT NULL
- wm_join_route — varchar(500)
- wm_join_ip — varchar(20) — NOT NULL
- wm_join_id — varchar(30) — NOT NULL
- wm_join_name — varchar(30) — NOT NULL
- wm_join_page — varchar(300)
- wm_join_browser — varchar(30) — NOT NULL
- wm_join_os — varchar(30) — NOT NULL
- wm_join_agent — varchar(300)
- wm_wdate — datetime — NOT NULL
sp_member
- wm_id — int(11) — 기본 키 — NOT NULL
- member_id — varchar(50) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(50) — NOT NULL
- wm_name_e1 — varchar(100) — NOT NULL
- wm_name_e2 — varchar(100) — NOT NULL
- wm_email — varchar(50) — NOT NULL
- wm_level — tinyint(4) — NOT NULL
- wm_sex — char(1) — NOT NULL
- wm_birth — char(8) — NOT NULL
- wm_tel — char(14) — NOT NULL
- wm_tel_bak — char(14) — NOT NULL
- wm_zipcode — char(5) — NOT NULL
- wm_addr1 — varchar(255) — NOT NULL
- wm_addr2 — varchar(255) — NOT NULL
- wm_addr3 — varchar(255) — NOT NULL
- wm_ip — varchar(50) — NOT NULL
- wm_auth — char(1) — NOT NULL
- wm_leave_date — char(10)
- wm_mailling — char(1) — NOT NULL
- wm_sms — char(1) — NOT NULL
- wm_adm_menu — varchar(500) — NOT NULL
- wm_login_ip — varchar(50) — NOT NULL
- wm_sns_state — varchar(10) — NOT NULL
- wm_sns_id — varchar(30)
- wm_login_date — datetime — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
sp_member1
- wm_id — int(11) — 기본 키 — NOT NULL
- member_id — varchar(50) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(50) — NOT NULL
- wm_name_e1 — varchar(100) — NOT NULL
- wm_name_e2 — varchar(100) — NOT NULL
- wm_email — varchar(50) — NOT NULL
- wm_level — tinyint(4) — NOT NULL
- wm_sex — char(1) — NOT NULL
- wm_birth — char(8) — NOT NULL
- wm_tel — char(14) — NOT NULL
- wm_zipcode — char(5) — NOT NULL
- wm_addr1 — varchar(255) — NOT NULL
- wm_addr2 — varchar(255) — NOT NULL
- wm_addr3 — varchar(255) — NOT NULL
- wm_ip — varchar(50) — NOT NULL
- wm_auth — char(1) — NOT NULL
- wm_leave_date — char(10)
- wm_mailling — char(1) — NOT NULL
- wm_sms — char(1) — NOT NULL
- wm_adm_menu — varchar(500) — NOT NULL
- wm_login_ip — varchar(50) — NOT NULL
- wm_sns_state — varchar(10) — NOT NULL
- wm_sns_id — varchar(30)
- wm_login_date — datetime — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
sp_member_change
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_level — tinyint(4) — NOT NULL
- wm_name — varchar(50) — NOT NULL
- member_id — varchar(50) — NOT NULL
- change_member_id — varchar(50) — NOT NULL
- change_memo — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wm_id (wm_id2) — int(11) — 외래 키 → sp_member.wm_id — NOT NULL
sp_online
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_kind — varchar(50)
- wm_company — varchar(100)
- wm_name — varchar(50)
- wm_tel — varchar(15)
- wm_hp — varchar(15)
- wm_email — varchar(100)
- wm_title — varchar(255)
- wm_content — text
- wm_upfile_name — varchar(50)
- wm_upfile_rename — varchar(50)
- wm_ip — varchar(20) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_retitle — varchar(255)
- wm_recontent — text
- wm_reemail — varchar(50)
- wm_state — char(1) — NOT NULL
- wm_rewdate — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
sp_online1
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_kind — varchar(50)
- wm_company — varchar(100)
- wm_name — varchar(50)
- wm_tel — varchar(15)
- wm_hp — varchar(15)
- wm_email — varchar(100)
- wm_title — varchar(255)
- wm_content — text
- wm_upfile_name — varchar(50)
- wm_upfile_rename — varchar(50)
- wm_ip — varchar(20) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_retitle — varchar(255)
- wm_recontent — text
- wm_reemail — varchar(50)
- wm_state — char(1) — NOT NULL
- wm_rewdate — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
sp_online2
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_kind — varchar(50)
- wm_company — varchar(100)
- wm_name — varchar(50)
- wm_tel — varchar(15)
- wm_hp — varchar(15)
- wm_email — varchar(100)
- wm_title — varchar(255)
- wm_content — text
- wm_upfile_name — varchar(50)
- wm_upfile_rename — varchar(50)
- wm_ip — varchar(20) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_retitle — varchar(255)
- wm_recontent — text
- wm_reemail — varchar(50)
- wm_state — char(1) — NOT NULL
- wm_rewdate — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
sp_popup
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_type — varchar(10) — NOT NULL
- wm_site_type — varchar(10) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_left — smallint(6) — NOT NULL
- wm_top — smallint(6) — NOT NULL
- wm_width — smallint(6) — NOT NULL
- wm_height — smallint(6) — NOT NULL
- wm_use — char(1) — NOT NULL
- wm_start — char(10) — NOT NULL
- wm_end — char(10) — NOT NULL
- wm_content — text
- wm_wdate — datetime — NOT NULL
sp_product
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_ca_id1 — int(11) — NOT NULL
- wm_ca_id2 — int(11) — NOT NULL
- wm_ca_id3 — int(11) — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content1 — text — NOT NULL
- wm_content2 — text
- wm_content3 — text
- wm_use — char(1)
- wm_main — char(1)
- wm_1 — varchar(500)
- wm_2 — varchar(500)
- wm_3 — varchar(500)
- wm_4 — varchar(500)
- wm_5 — varchar(500)
- wm_6 — varchar(500)
- wm_7 — varchar(500)
- wm_8 — varchar(500)
- wm_9 — varchar(500)
- wm_10 — varchar(500)
- wm_file — tinyint(4) — NOT NULL
- wm_wdate — datetime — NOT NULL
sp_schedule
- wm_id — int(11) — 기본 키 — NOT NULL
- apply_id — int(10) — NOT NULL
- idx — int(10) — NOT NULL — 신청한 봉사 wm_id값
- mb_no — int(10) — NOT NULL — 신청한 회원아이디
- mb_name — varchar(50) — NOT NULL — 신청한 회원이름
- mb_birth — varchar(50) — NOT NULL
- wm_sdate — date — NOT NULL — 봉사시작기간
- wm_edate — date — NOT NULL — 봉사끝나는기간
- wm_date_num — int(5) — NOT NULL — 봉사일수
- wm_tel — varchar(50) — NOT NULL — 신청자연락처
- wm_email — varchar(255) — NOT NULL — 신청자이메일
- wm_name — varchar(255) — NOT NULL — 긴급연락 성명
- wm_relation — varchar(10) — NOT NULL — 긴급연락 관계
- wm_hp — varchar(50) — NOT NULL — 긴급연락 연락처
- wm_bankname — varchar(50) — NOT NULL — 입금자명
- wm_price — varchar(50) — NOT NULL — 총참가비
- wm_information_m — varchar(10) — NOT NULL — 진료정보
- wm_information_al — varchar(255) — NOT NULL
- wm_information_ac — varchar(255) — NOT NULL
- wm_information_check — varchar(255) — NOT NULL
- wm_information_txt — text — NOT NULL
- wm_status — varchar(10) — NOT NULL — 상태
- wm_bank — varchar(100) — NOT NULL
- wm_bank_mem — varchar(100) — NOT NULL
- wm_bank_num — varchar(100) — NOT NULL
- wm_bank_date — datetime — NOT NULL — 환불요청일
- wm_bank_succ_date — datetime — NOT NULL — 환불완료일
- wm_timeh1 — varchar(10) — NOT NULL
- wm_timei1 — varchar(10) — NOT NULL
- wm_timeh2 — varchar(10) — NOT NULL
- wm_timei2 — varchar(10) — NOT NULL
- wm_wdate — datetime — NOT NULL
- cancel_day — datetime — NOT NULL — 봉사취소날짜
- price_datetime — datetime — NOT NULL — 입금완료일
- complete_datetime — datetime — NOT NULL — 봉사완료일
- cancel_datetime — datetime — NOT NULL — 취소완료일
- wm_id (wm_id2) — int(11) — 외래 키 → sp_member.wm_id — NOT NULL
- wm_id (wm_id3) — int(11) — 외래 키 → sp_welfare1.wm_id — NOT NULL
sp_schedule2
- wm_id — int(11) — 기본 키 — NOT NULL
- idx — int(10) — NOT NULL — 신청한 봉사 wm_id값
- mb_no — int(10) — NOT NULL — 신청한 회원아이디
- mb_name — varchar(50) — NOT NULL
- mb_birth — varchar(50) — NOT NULL
- wm_volunteer_time — varchar(10) — NOT NULL — 봉사시간
- wm_tel — varchar(50) — NOT NULL — 신청자연락처
- wm_addr1 — varchar(10) — NOT NULL
- wm_addr2 — varchar(100) — NOT NULL
- wm_addr3 — varchar(100)
- wm_email — varchar(255) — 이메일
- wm_engname — varchar(100) — NOT NULL — 영문성
- wm_engname1 — varchar(100) — NOT NULL — 이름
- wm_nationality — varchar(100) — NOT NULL — 국적
- wm_occupation1 — varchar(100) — NOT NULL — 직업
- wm_occupation2 — varchar(100) — NOT NULL — 직장명 또는 학교명
- wm_number — varchar(100) — NOT NULL — 직장, 학교 연락처
- wm_emer_name — varchar(100) — NOT NULL — 보호자 이름/국문
- wm_emer_relation — varchar(100) — NOT NULL — 본인과의 관계
- wm_emer_address — varchar(10) — NOT NULL — 우편번호
- wm_emer_address1 — varchar(100) — NOT NULL — 기본주소
- wm_emer_address2 — varchar(100) — NOT NULL — 상세주소
- wm_emer_number — varchar(100) — NOT NULL — 보호자연락처
- wm_passport_use — varchar(100) — NOT NULL — 여권 유무
- wm_passport_eng_name — varchar(100) — NOT NULL — 영문이름 성
- wm_passport_eng_name1 — varchar(100) — NOT NULL — 이름
- wm_passportnationality — varchar(100) — NOT NULL — 국적
- wm_passport_number — varchar(100) — NOT NULL — 여권번호
- wm_passport_authority — varchar(100) — NOT NULL — 여권발행국
- wm_passport_expiry — varchar(100) — NOT NULL — 여권만료일(년/월/일)
- wm_passport_file_name1 — varchar(100) — NOT NULL — 여권사본첨부
- wm_passport_file_name2 — varchar(100) — NOT NULL
- wm_habitat_use — varchar(100) — NOT NULL — 해비타트활동경험유무
- wm_habitat_content — text — NOT NULL — 해비타트경험text
- wm_etc_english_skill — varchar(100) — NOT NULL — 기타 영어가능정도
- wm_etc_lang — varchar(100) — NOT NULL — 기타언어
- wm_etc_nick — varchar(100) — NOT NULL — 닉네임
- wm_etc_skill — varchar(100) — NOT NULL — 건축관련기술
- wm_etc_size — varchar(100) — NOT NULL — 티셔트사이즈
- wm_emergency_blood — varchar(100) — NOT NULL — 혈액형
- wm_emergency_blood_1 — varchar(100) — NOT NULL — 혈액형옵션
- wm_emergency_tetanus — varchar(100) — NOT NULL — 파상풍예방접종
- wm_emergency_other — varchar(100) — NOT NULL — 기타예방접종
- wm_emergency_diet — varchar(100) — NOT NULL — 식단
- wm_emergency_allergies_use — char(50) — NOT NULL — 알레르기
- wm_emergency_allergies_content — text — NOT NULL
- wm_emergency_health_use — char(50) — NOT NULL — 최근6개월내 입원
- wm_emergency_health_content — text — NOT NULL
- wm_emergency_homedoctor_use — char(50) — NOT NULL — 개인주치의 정보
- wm_emergency_homedoctor_content — text — NOT NULL
- wm_emergency_insurance_use — varchar(100) — NOT NULL — 별도로 가입된 보험회사정보
- wm_emergency_insurance_company — varchar(100) — NOT NULL — 회사명
- wm_emergency_insurance_product — varchar(100) — NOT NULL — 상품명
- wm_status — varchar(100) — NOT NULL — 상태
- wm_wdate — datetime — NOT NULL
- cancel_day — datetime — NOT NULL
- price_datetime — datetime — NOT NULL
- complete_datetime — datetime — NOT NULL
- cancel_datetime — datetime — NOT NULL
- refund_datetime — datetime — NOT NULL
- … +3
sp_schedule3
- wm_id — int(11) — 기본 키 — NOT NULL
- idx — int(10) — NOT NULL — 신청한 봉사 wm_id값
- mb_no — int(10) — NOT NULL — 신청한 회원아이디
- mb_name — varchar(50) — NOT NULL
- wm_volunteer_time — varchar(10) — NOT NULL — 봉사시간
- wm_tel — varchar(50) — NOT NULL — 신청자연락처
- wm_email — varchar(255) — 이메일
- wm_bankname — varchar(100) — NOT NULL — 입금자명
- wm_occupation1 — varchar(100) — NOT NULL — 직업
- wm_occupation2 — varchar(100) — NOT NULL — 직장명 또는 학교명
- wm_etc_size — varchar(100) — NOT NULL — 티셔트사이즈
- wm_write1_use — char(10) — NOT NULL — 목조주택관련경험
- wm_write_content — text — NOT NULL
- wm_write_content1 — text — NOT NULL — 교육에 참가하는이유
- wm_write_content2 — text — NOT NULL — 해비타트 목조건축학교계기
- wm_write2_use — text — NOT NULL — 활동내용
- wm_write_content3 — text — NOT NULL — 자기소개
- wm_bank — varchar(100) — NOT NULL
- wm_bank_mem — varchar(100) — NOT NULL
- wm_bank_num — varchar(100) — NOT NULL
- wm_bank_date — datetime — NOT NULL — 환불요청일
- wm_status — varchar(100) — NOT NULL — 상태
- wm_wdate — datetime — NOT NULL
- cancel_day — datetime — NOT NULL
- price_datetime — datetime — NOT NULL
- complete_datetime — datetime — NOT NULL
- cancel_datetime — datetime — NOT NULL
- refund_datetime — datetime — NOT NULL
- refund_status_datetime — datetime — NOT NULL
- wm_id (wm_id2) — int(11) — 외래 키 → sp_member.wm_id — NOT NULL
- wm_id (wm_id3) — int(11) — 외래 키 → sp_welfare3.wm_id — NOT NULL
sp_schedule_p
- wm_id — int(10) — 기본 키 — NOT NULL
- program_id — int(10) — NOT NULL
- volunteer_date — date — NOT NULL
- volunteer_number — varchar(255) — NOT NULL
- register_datetime — datetime — NOT NULL
- register_ip — varchar(100) — NOT NULL
sp_site_config
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_company — varchar(50) — NOT NULL
- wm_ceo — varchar(20)
- wm_name — varchar(20)
- wm_email — varchar(50)
- wm_email1 — varchar(50)
- wm_zipcode — text
- wm_addr1 — text
- wm_addr2 — text
- wm_tel_exp — text
- wm_tel — text
- wm_fax — text
- wm_company_no — varchar(20)
- wm_editor — char(1) — NOT NULL
- wm_daum_map_key — varchar(50)
- wm_naver_map_key — varchar(50)
- wm_google_map_key — varchar(50)
- wm_icode_key — varchar(50)
- wm_kcp_site_code_key — varchar(50)
- wm_kcp_site_key — varchar(50)
- wm_hosting_startdate — varchar(10)
- wm_hosting_enddate — varchar(10)
- wm_title — varchar(255) — NOT NULL
- wm_description — varchar(255)
- wm_ogtype — varchar(255)
- wm_ogtitle — varchar(255)
- wm_ogdescription — varchar(255)
- wm_upfile1 — varchar(255)
- wm_upfile2 — varchar(255)
- wm_upfile3 — varchar(255)
- wm_ogurl — varchar(255)
- wm_naverkey — varchar(255)
- wm_googlekey — varchar(255)
- wm_script — text — NOT NULL
- wm_privacy — text — NOT NULL
- wm_access — text — NOT NULL
- wm_online_privacy — text — NOT NULL
- wm_fix_privacy — text — NOT NULL
- wm_antiemail — text
- wm_recapcha_sitekey — varchar(255)
- wm_recapcha_secretkey — varchar(255)
- wm_member_recapcha_use — char(1)
- wm_online_recapcha_use — char(1)
- wm_wdate — datetime — NOT NULL
sp_sns_channel
- ch1 — text
- ch2 — text
- ch3 — text
- ch4 — text
- ch5 — text
- ch6 — text
- ch7 — text
- ch8 — text
- ch9 — text
- ch10 — text
- ch11 — text
- ch12 — text
- ch13 — text
- ch14 — text
- ch15 — text
- ch16 — text
- ch17 — text
- ch18 — text
- ch19 — text
- ch20 — text
sp_sns_config
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_naverlogin_state — char(1) — NOT NULL
- wm_naverlogin_key — varchar(100)
- wm_naverlogin_secret_key — varchar(100)
- wm_naver_callback — varchar(100)
- wm_facebook_state — char(1) — NOT NULL
- wm_facebook_key — varchar(100)
- wm_facebook_secret_key — varchar(100)
- wm_facebook_callback — varchar(100)
- wm_kakao_state — char(1) — NOT NULL
- wm_kakao_key — varchar(100)
- wm_kakao_callback — varchar(100)
- wm_join_page — varchar(100)
- wm_login_page — varchar(100)
- wm_google_state — varchar(100)
- wm_google_key — varchar(100)
- wm_google_secret_key — varchar(100)
- wm_google_callback — varchar(100)
- wm_wdate — datetime — NOT NULL
sp_welfare1
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_state — char(5) — NOT NULL
- wm_affiliate — varchar(50) — NOT NULL
- wm_affiliate_name — varchar(100) — NOT NULL
- wm_memid — varchar(50) — NOT NULL
- wm_memnum — varchar(50) — NOT NULL
- wm_group_name — varchar(100) — NOT NULL
- wm_program — int(11) — NOT NULL
- wm_program_name — varchar(50) — NOT NULL
- wm_program_name1 — varchar(50) — NOT NULL
- wm_volunteer_type — char(5) — NOT NULL
- wm_apply_path — varchar(50) — NOT NULL
- wm_expose — char(5) — NOT NULL
- wm_expose_pass — varchar(50) — NOT NULL
- wm_sdate — date — NOT NULL
- wm_edate — date — NOT NULL
- wm_sdate1 — date — NOT NULL
- wm_edate1 — date — NOT NULL
- wm_people_count — int(5) — NOT NULL
- wm_price_yn — char(5) — NOT NULL
- wm_price — int(10) — NOT NULL
- wm_user_ssn — char(5) — NOT NULL
- wm_map — char(5) — NOT NULL
- wm_upfile_name — varchar(50) — NOT NULL
- wm_href — varchar(100) — NOT NULL
- wm_content — text — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_minor_part — varchar(10)
sp_welfare2
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_state — char(5) — NOT NULL
- wm_program_name — varchar(50) — NOT NULL
- wm_volunteer_type — char(5) — NOT NULL
- wm_apply_path — varchar(50) — NOT NULL
- wm_expose — char(5) — NOT NULL
- wm_expose_pass — varchar(50) — NOT NULL
- wm_country — varchar(50) — NOT NULL
- wm_country1 — varchar(50) — NOT NULL
- wm_people_count — int(5) — NOT NULL
- wm_price — int(5) — NOT NULL
- wm_sdate — date — NOT NULL
- wm_edate — date — NOT NULL
- wm_sdate1 — date — NOT NULL
- wm_edate1 — date — NOT NULL
- wm_review_url — varchar(150) — NOT NULL
- wm_content — text — NOT NULL
- wm_name — varchar(50) — NOT NULL
- wm_email — varchar(100) — NOT NULL
- wm_tel — varchar(100) — NOT NULL
- wm_upfile_name — varchar(100) — NOT NULL
- wm_upfile_name1 — varchar(100) — NOT NULL
- wm_upfile_name2 — varchar(100) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_id (wm_id2) — int(11) — 외래 키 → sp_welfare2_country.wm_id — NOT NULL
sp_welfare2_country
- wm_id — int(11) — 기본 키 — NOT NULL
- country_name — varchar(100) — NOT NULL
- member_id — varchar(50) — NOT NULL
- wm_use — varchar(50) — NOT NULL
- wm_wdate — datetime — NOT NULL
- register_ip — varchar(50) — NOT NULL
sp_welfare3
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_state — char(5) — NOT NULL
- wm_affiliate — varchar(100) — NOT NULL
- wm_number — varchar(50) — NOT NULL
- wm_program — int(11) — NOT NULL
- wm_program_name — varchar(50) — NOT NULL
- wm_sdate — date — NOT NULL
- wm_edate — date — NOT NULL
- wm_sdate1 — date — NOT NULL
- wm_edate1 — date — NOT NULL
- wm_people_count — int(5) — NOT NULL
- wm_price_yn — char(5) — NOT NULL
- wm_price — int(10) — NOT NULL
- wm_user_ssn — char(5) — NOT NULL
- wm_map — char(5) — NOT NULL
- wm_upfile_name — varchar(50) — NOT NULL
- wm_href — varchar(100) — NOT NULL
- wm_content — text — NOT NULL
- wm_content1 — text — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_wdate — datetime — NOT NULL
sp_wm_campaign
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_ca — varchar(255) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_reply — varchar(10) — NOT NULL
- wm_parent — int(11) — NOT NULL
- wm_is_comment — tinyint(4) — NOT NULL
- wm_comment_reply — varchar(10) — NOT NULL
- wm_comment — int(11) — NOT NULL
- wm_notice — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — text — NOT NULL
- wm_hit — int(11) — NOT NULL
- member_id — varchar(50) — NOT NULL
- member_seq — int(11) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(255) — NOT NULL
- wm_file — tinyint(4) — NOT NULL
- wm_ip — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_last — datetime — NOT NULL
- wm_1 — text
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wmp_1 — varchar(500)
- wmp_2 — varchar(500)
- wmp_3 — varchar(500)
- wmp_4 — varchar(500)
- wmp_5 — varchar(500)
- wmp_6 — varchar(500)
- wmp_7 — varchar(500)
- wmp_8 — varchar(500)
- wmp_9 — varchar(500)
- wmp_10 — varchar(500)
- wm_table — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL
sp_wm_campaign1
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_ca — varchar(255) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_reply — varchar(10) — NOT NULL
- wm_parent — int(11) — NOT NULL
- wm_is_comment — tinyint(4) — NOT NULL
- wm_comment_reply — varchar(10) — NOT NULL
- wm_comment — int(11) — NOT NULL
- wm_notice — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — text — NOT NULL
- wm_content_pc — text — NOT NULL
- wm_content_m — text — NOT NULL
- wm_hit — int(11) — NOT NULL
- member_id — varchar(50) — NOT NULL
- member_seq — int(11) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(255) — NOT NULL
- wm_file — tinyint(4) — NOT NULL
- wm_ip — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_last — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wmp_1 — varchar(500)
- wmp_2 — varchar(500)
- wmp_3 — varchar(500)
- wmp_4 — varchar(500)
- wmp_5 — varchar(500)
- wmp_6 — varchar(500)
- wmp_7 — varchar(500)
- wmp_8 — varchar(500)
- wmp_9 — varchar(500)
- wmp_10 — varchar(500)
- wm_table — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL
sp_wm_faq
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_ca — varchar(255) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_reply — varchar(10) — NOT NULL
- wm_parent — int(11) — NOT NULL
- wm_is_comment — tinyint(4) — NOT NULL
- wm_comment_reply — varchar(10) — NOT NULL
- wm_comment — int(11) — NOT NULL
- wm_notice — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — text — NOT NULL
- wm_hit — int(11) — NOT NULL
- member_id — varchar(50) — NOT NULL
- member_seq — int(11) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(255) — NOT NULL
- wm_file — tinyint(4) — NOT NULL
- wm_ip — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_last — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wmp_1 — varchar(500)
- wmp_2 — varchar(500)
- wmp_3 — varchar(500)
- wmp_4 — varchar(500)
- wmp_5 — varchar(500)
- wmp_6 — varchar(500)
- wmp_7 — varchar(500)
- wmp_8 — varchar(500)
- wmp_9 — varchar(500)
- wmp_10 — varchar(500)
- wm_table — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL
sp_wm_newsroom
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_ca — varchar(255) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_reply — varchar(10) — NOT NULL
- wm_parent — int(11) — NOT NULL
- wm_is_comment — tinyint(4) — NOT NULL
- wm_comment_reply — varchar(10) — NOT NULL
- wm_comment — int(11) — NOT NULL
- wm_notice — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — mediumtext — NOT NULL
- wm_hit — int(11) — NOT NULL
- member_id — varchar(50) — NOT NULL
- member_seq — int(11) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(255) — NOT NULL
- wm_file — tinyint(4) — NOT NULL
- wm_ip — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_last — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wmp_1 — varchar(500)
- wmp_2 — varchar(500)
- wmp_3 — varchar(500)
- wmp_4 — varchar(500)
- wmp_5 — varchar(500)
- wmp_6 — varchar(500)
- wmp_7 — varchar(500)
- wmp_8 — varchar(500)
- wmp_9 — varchar(500)
- wmp_10 — varchar(500)
- wm_table — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL
sp_wm_newsroom2
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_ca — varchar(255) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_reply — varchar(10) — NOT NULL
- wm_parent — int(11) — NOT NULL
- wm_is_comment — tinyint(4) — NOT NULL
- wm_comment_reply — varchar(10) — NOT NULL
- wm_comment — int(11) — NOT NULL
- wm_notice — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — mediumtext — NOT NULL
- wm_hit — int(11) — NOT NULL
- member_id — varchar(50) — NOT NULL
- member_seq — int(11) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(255) — NOT NULL
- wm_file — tinyint(4) — NOT NULL
- wm_ip — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_last — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wmp_1 — varchar(500)
- wmp_2 — varchar(500)
- wmp_3 — varchar(500)
- wmp_4 — varchar(500)
- wmp_5 — varchar(500)
- wmp_6 — varchar(500)
- wmp_7 — varchar(500)
- wmp_8 — varchar(500)
- wmp_9 — varchar(500)
- wmp_10 — varchar(500)
- wm_table — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL
sp_wm_newsroom3
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_ca — varchar(255) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_reply — varchar(10) — NOT NULL
- wm_parent — int(11) — NOT NULL
- wm_is_comment — tinyint(4) — NOT NULL
- wm_comment_reply — varchar(10) — NOT NULL
- wm_comment — int(11) — NOT NULL
- wm_notice — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — mediumtext — NOT NULL
- wm_hit — int(11) — NOT NULL
- member_id — varchar(50) — NOT NULL
- member_seq — int(11) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(255) — NOT NULL
- wm_file — tinyint(4) — NOT NULL
- wm_ip — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_last — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wmp_1 — varchar(500)
- wmp_2 — varchar(500)
- wmp_3 — varchar(500)
- wmp_4 — varchar(500)
- wmp_5 — varchar(500)
- wmp_6 — varchar(500)
- wmp_7 — varchar(500)
- wmp_8 — varchar(500)
- wmp_9 — varchar(500)
- wmp_10 — varchar(500)
- wm_table — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL
sp_wm_newsroom4
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_ca — varchar(255) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_reply — varchar(10) — NOT NULL
- wm_parent — int(11) — NOT NULL
- wm_is_comment — tinyint(4) — NOT NULL
- wm_comment_reply — varchar(10) — NOT NULL
- wm_comment — int(11) — NOT NULL
- wm_notice — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — mediumtext — NOT NULL
- wm_hit — int(11) — NOT NULL
- member_id — varchar(50) — NOT NULL
- member_seq — int(11) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(255) — NOT NULL
- wm_file — tinyint(4) — NOT NULL
- wm_ip — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_last — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wmp_1 — varchar(500)
- wmp_2 — varchar(500)
- wmp_3 — varchar(500)
- wmp_4 — varchar(500)
- wmp_5 — varchar(500)
- wmp_6 — varchar(500)
- wmp_7 — varchar(500)
- wmp_8 — varchar(500)
- wmp_9 — varchar(500)
- wmp_10 — varchar(500)
- wm_table — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL
sp_wm_notice
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_ca — varchar(255) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_reply — varchar(10) — NOT NULL
- wm_parent — int(11) — NOT NULL
- wm_is_comment — tinyint(4) — NOT NULL
- wm_comment_reply — varchar(10) — NOT NULL
- wm_comment — int(11) — NOT NULL
- wm_notice — char(1) — NOT NULL
- wm_useYN — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — mediumtext — NOT NULL
- wm_hit — int(11) — NOT NULL
- member_id — varchar(50) — NOT NULL
- member_seq — int(11) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(255) — NOT NULL
- wm_file — tinyint(4) — NOT NULL
- wm_ip — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_last — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wmp_1 — varchar(500)
- wmp_2 — varchar(500)
- wmp_3 — varchar(500)
- wmp_4 — varchar(500)
- wmp_5 — varchar(500)
- wmp_6 — varchar(500)
- wmp_7 — varchar(500)
- wmp_8 — varchar(500)
- wmp_9 — varchar(500)
- wmp_10 — varchar(500)
- wm_table — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL
sp_wm_notice2
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_ca — varchar(255) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_reply — varchar(10) — NOT NULL
- wm_parent — int(11) — NOT NULL
- wm_is_comment — tinyint(4) — NOT NULL
- wm_comment_reply — varchar(10) — NOT NULL
- wm_comment — int(11) — NOT NULL
- wm_notice — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — mediumtext — NOT NULL
- wm_hit — int(11) — NOT NULL
- member_id — varchar(50) — NOT NULL
- member_seq — int(11) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(255) — NOT NULL
- wm_file — tinyint(4) — NOT NULL
- wm_ip — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_last — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wmp_1 — varchar(500)
- wmp_2 — varchar(500)
- wmp_3 — varchar(500)
- wmp_4 — varchar(500)
- wmp_5 — varchar(500)
- wmp_6 — varchar(500)
- wmp_7 — varchar(500)
- wmp_8 — varchar(500)
- wmp_9 — varchar(500)
- wmp_10 — varchar(500)
- wm_table — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL
sp_wm_notice3
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_ca — varchar(255) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_reply — varchar(10) — NOT NULL
- wm_parent — int(11) — NOT NULL
- wm_is_comment — tinyint(4) — NOT NULL
- wm_comment_reply — varchar(10) — NOT NULL
- wm_comment — int(11) — NOT NULL
- wm_notice — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — mediumtext — NOT NULL
- wm_hit — int(11) — NOT NULL
- member_id — varchar(50) — NOT NULL
- member_seq — int(11) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(255) — NOT NULL
- wm_file — tinyint(4) — NOT NULL
- wm_ip — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_last — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wmp_1 — varchar(500)
- wmp_2 — varchar(500)
- wmp_3 — varchar(500)
- wmp_4 — varchar(500)
- wmp_5 — varchar(500)
- wmp_6 — varchar(500)
- wmp_7 — varchar(500)
- wmp_8 — varchar(500)
- wmp_9 — varchar(500)
- wmp_10 — varchar(500)
- wm_table — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL
- wm_table (wm_table2) — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL
sp_wm_qna
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_ca — varchar(255) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_reply — varchar(10) — NOT NULL
- wm_parent — int(11) — NOT NULL
- wm_is_comment — tinyint(4) — NOT NULL
- wm_comment_reply — varchar(10) — NOT NULL
- wm_comment — int(11) — NOT NULL
- wm_notice — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — text — NOT NULL
- wm_hit — int(11) — NOT NULL
- member_id — varchar(50) — NOT NULL
- member_seq — int(11) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(255) — NOT NULL
- wm_file — tinyint(4) — NOT NULL
- wm_ip — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_last — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wmp_1 — varchar(500)
- wmp_2 — varchar(500)
- wmp_3 — varchar(500)
- wmp_4 — varchar(500)
- wmp_5 — varchar(500)
- wmp_6 — varchar(500)
- wmp_7 — varchar(500)
- wmp_8 — varchar(500)
- wmp_9 — varchar(500)
- wmp_10 — varchar(500)
- wm_table — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL
sp_wm_recruit
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_ca — varchar(255) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_reply — varchar(10) — NOT NULL
- wm_parent — int(11) — NOT NULL
- wm_is_comment — tinyint(4) — NOT NULL
- wm_comment_reply — varchar(10) — NOT NULL
- wm_comment — int(11) — NOT NULL
- wm_notice — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — text — NOT NULL
- wm_hit — int(11) — NOT NULL
- member_id — varchar(50) — NOT NULL
- member_seq — int(11) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(255) — NOT NULL
- wm_file — tinyint(4) — NOT NULL
- wm_ip — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_last — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wmp_1 — varchar(500)
- wmp_2 — varchar(500)
- wmp_3 — varchar(500)
- wmp_4 — varchar(500)
- wmp_5 — varchar(500)
- wmp_6 — varchar(500)
- wmp_7 — varchar(500)
- wmp_8 — varchar(500)
- wmp_9 — varchar(500)
- wmp_10 — varchar(500)
- wm_table — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL
sp_wm_report
- wm_id — int(11) — 기본 키 — NOT NULL
- wm_sort — int(11) — NOT NULL
- wm_ca — varchar(255) — NOT NULL
- wm_num — int(11) — NOT NULL
- wm_reply — varchar(10) — NOT NULL
- wm_parent — int(11) — NOT NULL
- wm_is_comment — tinyint(4) — NOT NULL
- wm_comment_reply — varchar(10) — NOT NULL
- wm_comment — int(11) — NOT NULL
- wm_notice — char(1) — NOT NULL
- wm_secret — char(1) — NOT NULL
- wm_title — varchar(255) — NOT NULL
- wm_content — text — NOT NULL
- wm_hit — int(11) — NOT NULL
- member_id — varchar(50) — NOT NULL
- member_seq — int(11) — NOT NULL
- wm_password — varchar(255) — NOT NULL
- wm_passkey — varchar(30) — NOT NULL
- wm_name — varchar(255) — NOT NULL
- wm_file — tinyint(4) — NOT NULL
- wm_ip — varchar(255) — NOT NULL
- wm_wdate — datetime — NOT NULL
- wm_last — datetime — NOT NULL
- wm_1 — varchar(255)
- wm_2 — varchar(255)
- wm_3 — varchar(255)
- wm_4 — varchar(255)
- wm_5 — varchar(255)
- wm_6 — varchar(255)
- wm_7 — varchar(255)
- wm_8 — varchar(255)
- wm_9 — varchar(255)
- wm_10 — varchar(255)
- wmp_1 — varchar(500)
- wmp_2 — varchar(500)
- wmp_3 — varchar(500)
- wmp_4 — varchar(500)
- wmp_5 — varchar(500)
- wmp_6 — varchar(500)
- wmp_7 — varchar(500)
- wmp_8 — varchar(500)
- wmp_9 — varchar(500)
- wmp_10 — varchar(500)
- wm_table — varchar(20) — 외래 키 → sp_board_set.wm_table — NOT NULL