lh
Tables (35)
banner
- b_l_num — int(4) — Primary key — NOT NULL
- b_l_code — int(4)
- b_l_img — varchar(200)
- b_l_url — varchar(300)
- b_l_chk — varchar(1)
- b_l_sdate — varchar(30)
- b_l_edate — varchar(30)
- b_l_subject — varchar(100)
- b_l_wdate — varchar(30)
- b_l_mdate — varchar(30)
- unlimited — varchar(1) — NOT NULL
- site_dir (bs_num) — varchar(200) — Foreign key → builder_site.bs_num — NOT NULL
banner2
- b_l_num — int(4) — Primary key — NOT NULL
- b_l_code — int(4)
- b_l_url — varchar(300)
- b_l_chk — varchar(1)
- b_l_sdate — varchar(30)
- b_l_edate — varchar(30)
- b_l_subject — varchar(500)
- b_l_wdate — varchar(30)
- b_l_mdate — varchar(30)
- b_main_img — varchar(100)
- b_l_win — varchar(1) — NOT NULL
- b_l_page — varchar(1) — NOT NULL
- w_width — varchar(4)
- w_height — varchar(4)
- w_top — varchar(4)
- w_left — varchar(4)
- scrollbars — varchar(3)
- toolbar — varchar(3)
- menubar — varchar(3)
- locations — varchar(3)
- content — mediumtext
- unlimited — varchar(1) — NOT NULL
- site_dir (bs_num) — varchar(200) — Foreign key → builder_site.bs_num — NOT NULL
banner3
- b_l_num — int(4) — Primary key — NOT NULL
- b_l_code — int(4)
- b_l_img — varchar(200)
- b_l_url — varchar(300)
- b_l_chk — varchar(1)
- b_l_sdate — varchar(30)
- b_l_edate — varchar(30)
- b_l_subject — varchar(100)
- b_l_wdate — varchar(30)
- b_l_mdate — varchar(30)
- b_l_win — varchar(1)
- unlimited — varchar(1) — NOT NULL
- site_dir (bs_num) — varchar(200) — Foreign key → builder_site.bs_num — NOT NULL
board
- b_num — int(4) — Primary key — NOT NULL
- a_num (a_idx) — int(11) — Foreign key → board_config.a_idx — NOT NULL
- b_type — char(1)
- b_id — varchar(30)
- b_name — varchar(30)
- b_pwd — varchar(100)
- b_subject — varchar(200)
- b_email — varchar(200)
- b_jumin — varchar(100)
- b_phone1 — varchar(200)
- b_phone2 — varchar(200)
- b_phone3 — varchar(200)
- b_cate (ct_idx) — int(4) — Foreign key → board_code.ct_idx — NOT NULL
- b_catename — varchar(100)
- b_noticechk — char(1)
- b_content — mediumtext
- b_ip — varchar(15)
- b_count — int(4)
- b_look — char(1)
- b_open — char(1)
- b_ref — int(11)
- b_step — int(3)
- b_level — int(3)
- b_regdate — varchar(30)
- b_chuchun — int(3)
- b_sbjclr — varchar(10)
- b_sdate — varchar(10)
- b_edate — varchar(10)
- b_temp1 — varchar(200)
- b_temp2 — varchar(200)
- b_temp3 — varchar(200)
- b_temp4 — varchar(200)
- b_temp5 — varchar(200)
- b_temp6 — varchar(200)
- b_temp7 — varchar(200)
- b_temp8 — varchar(200)
- b_temp9 — varchar(200)
- b_temp10 — varchar(200)
- b_re_buseo — varchar(50)
- b_re_date — varchar(50)
- b_re_state — varchar(50)
- b_re_content — text
- b_file1 — varchar(200)
- b_file2 — varchar(200)
- b_file3 — varchar(200)
- b_file4 — varchar(200)
- b_file5 — varchar(200)
- b_file6 — varchar(200)
- b_file7 — varchar(200)
- b_file8 — varchar(200)
- b_file9 — varchar(200)
- b_file10 — varchar(200)
- b_keyword — varchar(100)
- b_c_count — int(4)
- b_zip1 — varchar(200)
- b_zip2 — varchar(200)
- b_addr1 — varchar(200)
- b_addr2 — varchar(200)
- b_show_sdate — varchar(30)
- b_show_edate — varchar(30)
- … +3
board_access
- Bl_num — int(4) — Primary key — NOT NULL
- g_num — int(4)
- a_num (a_idx) — int(4) — Foreign key → board_config.a_idx — NOT NULL
- Bl_ad_cms — varchar(1)
- Bl_list — varchar(1)
- Bl_read — varchar(1)
- Bl_write — varchar(1)
- Bl_delete — varchar(1)
- Bl_reply — varchar(1)
board_access_member
- Bl_num — int(4) — Primary key — NOT NULL
- m_num — int(4)
- a_num (a_idx) — int(4) — Foreign key → board_config.a_idx — NOT NULL
- Bl_ad_cms — varchar(1)
- Bl_list — varchar(1)
- Bl_read — varchar(1)
- Bl_write — varchar(1)
- Bl_delete — varchar(1)
- Bl_reply — varchar(1)
board_code
- ct_idx — int(4) — Primary key — NOT NULL
- ct_code — int(4)
- ct_name — varchar(200)
- ct_ref — int(4)
- ct_depth — varchar(1)
- ct_chk — varchar(1)
- ct_wdate — varchar(30)
- ct_codeno — varchar(30)
- a_num (a_idx) — int(4) — Foreign key → board_config.a_idx — NOT NULL
- ct_file — varchar(50)
board_config
- a_idx — int(11) — Primary key — NOT NULL
- a_num — int(4) — NOT NULL
- a_site_dir (bs_num) — varchar(200) — Foreign key → builder_site.bs_num — NOT NULL
- a_bbsname — varchar(200)
- a_level — varchar(30)
- a_type — varchar(1)
- a_tablename — varchar(10)
- a_tablecnt — int(11) — NOT NULL
- a_imgline — varchar(2)
- a_imgwidth — varchar(3)
- a_imgheight — varchar(3)
- a_member — varchar(1)
- a_ad_cms_id — mediumtext
- a_ad_cms — varchar(1)
- a_cate — varchar(1)
- a_email — varchar(1)
- a_email_req — varchar(1)
- a_phone — varchar(1)
- a_phone_req — varchar(1)
- a_home — varchar(1)
- a_home_req — varchar(1)
- a_content — varchar(1)
- a_content_req — varchar(1)
- a_jumin — varchar(1)
- a_jumin_opt — varchar(1)
- a_ftemp1 — varchar(1) — NOT NULL
- a_ftemp1_type — varchar(1)
- a_ftemp1_str — varchar(30)
- a_ftemp1_val — varchar(100)
- a_ftemp1_req — varchar(1) — NOT NULL
- a_ftemp2 — varchar(1) — NOT NULL
- a_ftemp2_type — varchar(1)
- a_ftemp2_str — varchar(30)
- a_ftemp2_val — varchar(100)
- a_ftemp2_req — varchar(1) — NOT NULL
- a_ftemp3 — varchar(1) — NOT NULL
- a_ftemp3_type — varchar(1)
- a_ftemp3_str — varchar(30)
- a_ftemp3_val — varchar(100)
- a_ftemp3_req — varchar(1) — NOT NULL
- a_ftemp4 — varchar(1) — NOT NULL
- a_ftemp4_type — varchar(1)
- a_ftemp4_str — varchar(30)
- a_ftemp4_val — varchar(100)
- a_ftemp4_req — varchar(1) — NOT NULL
- a_ftemp5 — varchar(1) — NOT NULL
- a_ftemp5_type — varchar(1)
- a_ftemp5_str — varchar(30)
- a_ftemp5_val — varchar(100)
- a_ftemp5_req — varchar(1) — NOT NULL
- a_ftemp6 — varchar(1) — NOT NULL
- a_ftemp6_type — varchar(1)
- a_ftemp6_str — varchar(30)
- a_ftemp6_val — varchar(100)
- a_ftemp6_req — varchar(1) — NOT NULL
- a_ftemp7 — varchar(1) — NOT NULL
- a_ftemp7_type — varchar(1)
- a_ftemp7_str — varchar(30)
- a_ftemp7_val — varchar(100)
- a_ftemp7_req — varchar(1) — NOT NULL
- … +52
builder_site
- bs_num — int(10) — Primary key — NOT NULL
- bs_sitename — varchar(200) — NOT NULL
- bs_directory — varchar(200) — NOT NULL
- bs_main — varchar(200)
- bs_skin — varchar(200)
- bs_writer — varchar(50) — NOT NULL
- bs_regdate — varchar(20) — NOT NULL
- bs_chk — char(1) — NOT NULL
- bs_logo — varchar(200)
- bs_header_meta — text
- bs_copyright — text
- bs_manager_ip — varchar(1)
- bs_manager_mobile — varchar(1)
- bs_code — int(11) — NOT NULL
buseo
- ct_idx — int(4) — Primary key — NOT NULL
- ct_code — int(4)
- ct_name — varchar(100)
- ct_ref — int(4)
- ct_depth — varchar(1)
- ct_chk — varchar(1)
- ct_wdate — varchar(30)
- ct_codeno — varchar(30)
- ct_memo — mediumtext
- site_dir (bs_num) — varchar(20) — Foreign key → builder_site.bs_num — NOT NULL
buseo_member
- m_num — int(4) — Primary key — NOT NULL
- m_name — varchar(30)
- m_tel — varchar(20)
- m_fax — varchar(20)
- ct_idx (ct_idx2) — int(4) — Foreign key → buseo.ct_idx — NOT NULL
- ct_codeno — varchar(30)
- m_work — varchar(4000)
- m_code — int(4) — NOT NULL
- m_wdate — varchar(30)
- m_mdate — varchar(30)
- m_memo — mediumtext
- m_spot — varchar(30)
css_history
- c_idx — int(4) — Primary key — NOT NULL
- ct_idx (ct_idx2) — int(4) — Foreign key → homepage_menu.ct_idx — NOT NULL
- c_content — mediumtext
- c_wdate — varchar(30)
- m_id — varchar(30)
examfee
- ef_idx — int(10) — Primary key — NOT NULL
- ef_gb — int(10) — NOT NULL — x
- ef_up_gb (ec_idx) — int(10) — Foreign key → examfee_code.ec_idx — NOT NULL — up_code
- ef_lar_code — varchar(50) — 품목코드
- ef_lar_name — varchar(100) — 품목명
- ef_item_code — varchar(50) — 항목코드
- ef_item_eq — varchar(50) — 동일항목코드
- ef_item_name — varchar(100) — 시험항목명
- ef_method — varchar(50) — 시험방법
- ef_period — varchar(50) — 처리기간
- ef_qty — varchar(100) — 시료량
- ef_unit — varchar(50) — 단위명
- ef_etc — varchar(255) — 비고
- ef_utility — varchar(50) — 공공요금
- ef_labor_m — varchar(50) — 인건비(관리)
- ef_labor_t — varchar(50) — 인건비(시험)
- ef_material — varchar(50) — 재료비
- ef_impair — varchar(50) — 장비손료
- ef_facility — varchar(50) — 시설비,장비손료
- ef_fee — varchar(50) — 수수료금액
- is_del — tinyint(4) — NOT NULL — x
- ef_use — tinyint(4)
- ef_sort — int(11)
- ef_regdate — varchar(30)
- ef_regid — varchar(30)
examfee_code
- ec_idx — int(11) — Primary key — NOT NULL
- ec_name — varchar(100) — NOT NULL
- ec_use — tinyint(4) — NOT NULL
- ec_sort — int(11)
- ec_regdate — varchar(30)
- ec_regid — varchar(30)
homepage_log_work
- hl_idx — int(11) — Primary key — NOT NULL
- hl_type — varchar(10) — NOT NULL
- hl_job — varchar(500) — NOT NULL
- hl_id — varchar(30) — NOT NULL
- hl_name — varchar(30) — NOT NULL
- hl_ci — varchar(200) — NOT NULL
- hl_ip — varchar(50) — NOT NULL
- hl_ymd — int(10) — NOT NULL
- hl_regdate — varchar(20) — NOT NULL
- site_dir (bs_num) — varchar(200) — Foreign key → builder_site.bs_num — NOT NULL
homepage_menu
- ct_idx — int(4) — Primary key — NOT NULL
- ct_code — int(4)
- ct_name — varchar(200)
- ct_name_eng — varchar(200)
- ct_ref — int(4)
- ct_depth — varchar(1)
- ct_chk — varchar(1)
- ct_wdate — varchar(30)
- ct_mdate — varchar(20)
- ct_codeno — varchar(100)
- ct_url — varchar(100)
- ct_url_target — char(1)
- ct_pagetype — char(1) — NOT NULL
- ct_content — mediumtext
- ct_anum — varchar(15)
- ct_header — mediumtext
- ct_footer — mediumtext
- ct_program — varchar(50)
- ct_top_url — varchar(200)
- ct_bottom_url — varchar(200)
- ct_img_on — varchar(50)
- ct_img_off — varchar(50)
- ct_img_status — char(1) — NOT NULL
- ct_popup_w — int(11) — NOT NULL
- ct_popup_h — int(11) — NOT NULL
- ct_point — int(11)
- ct_manage_num — varchar(4)
- ct_layout — int(11)
- ct_img_on2 — varchar(50)
- ct_img_off2 — varchar(50)
- ct_menu_url — varchar(200)
- ct_tab — varchar(1)
- ct_board_header — mediumtext
- ct_board_footer — mediumtext
- ct_group — varchar(300)
- ct_site_dir (bs_num) — varchar(200) — Foreign key → builder_site.bs_num — NOT NULL
- ct_metatag — mediumtext
homepage_menu_history
- cth_idx — int(4) — Primary key — NOT NULL
- ct_idx (ct_idx2) — int(4) — Foreign key → homepage_menu.ct_idx — NOT NULL
- ct_name — varchar(200)
- ct_chk — char(1)
- ct_url — varchar(100)
- ct_url_target — char(1)
- ct_pagetype — char(1) — NOT NULL
- ct_content — mediumtext
- ct_wdate — varchar(30)
- ct_mdate — varchar(30)
- ct_anum — varchar(15)
- ct_header — mediumtext
- ct_footer — mediumtext
- ct_program — varchar(50)
- ct_top_url — varchar(200)
- ct_bottom_url — varchar(200)
- ct_img_on — varchar(50)
- ct_img_off — varchar(50)
- ct_img_status — char(1) — NOT NULL
- ct_popup_w — int(11) — NOT NULL
- ct_popup_h — int(11) — NOT NULL
- ct_point — int(11)
- ct_manage_num — varchar(4)
- ct_layout — int(11) — NOT NULL
- ct_img_on2 — varchar(50)
- ct_img_off2 — varchar(50)
- ct_menu_url — varchar(200)
- ct_mobile_menu_url — varchar(200)
- m_id — varchar(30)
- ct_board_header — mediumtext
- ct_board_footer — mediumtext
- ct_group — varchar(300)
- ct_metatag — mediumtext
manager_connect_status
- mc_num — int(11) — Primary key — NOT NULL
- mc_session_id — varchar(200) — NOT NULL
- mc_connect_time — varchar(20) — NOT NULL
manager_ip
- mi_num — int(11) — Primary key — NOT NULL
- mi_ip — varchar(100) — NOT NULL
- mi_memo — varchar(200) — NOT NULL
- mi_chk — varchar(1) — NOT NULL
- mi_regdate — varchar(20) — NOT NULL
- mi_modidate — varchar(20) — NOT NULL
- mi_sdate — char(10)
- mi_edate — char(10)
- site_dir (bs_num) — varchar(200) — Foreign key → builder_site.bs_num — NOT NULL
manager_menu
- ct_idx — int(4) — Primary key — NOT NULL
- ct_code — int(4)
- ct_name — varchar(100)
- ct_ref — int(4)
- ct_depth — varchar(1)
- ct_chk — varchar(1)
- ct_wdate — varchar(30)
- ct_codeno — varchar(30)
- ct_url — varchar(100)
- ct_icon — varchar(100) — NOT NULL
- ct_folder — varchar(200)
- ct_site_dir (bs_num) — varchar(200) — Foreign key → builder_site.bs_num — NOT NULL
manager_menu_access
- num — int(4) — Primary key — NOT NULL
- g_num — int(4)
- ct_idx (ct_idx2) — int(4) — Foreign key → manager_menu.ct_idx — NOT NULL
- ct_codeno — varchar(50)
manager_menu_access_member
- num — int(4) — Primary key — NOT NULL
- m_num — int(4)
- ct_idx (ct_idx2) — int(4) — Foreign key → manager_menu.ct_idx — NOT NULL
- ct_codeno — varchar(50)
manager_sql
- ms_num — int(11) — Primary key — NOT NULL
- ms_get — text — NOT NULL
- ms_post — text — NOT NULL
member
- m_num — int(4) — Primary key — NOT NULL
- m_id — varchar(30)
- m_pwd — varchar(100)
- m_name — varchar(30)
- m_nickname — varchar(30)
- m_zipcode — varchar(200)
- m_addr1 — varchar(200)
- m_addr2 — varchar(200)
- m_phone1 — varchar(200)
- m_phone2 — varchar(200)
- m_phone3 — varchar(200)
- m_email — varchar(200)
- m_mobile1 — varchar(200)
- m_mobile2 — varchar(200)
- m_mobile3 — varchar(200)
- m_fax1 — varchar(4)
- m_fax2 — varchar(4)
- m_fax3 — varchar(4)
- m_homepage — varchar(100)
- m_date — varchar(30)
- m_modymate — varchar(30)
- m_lastdate — varchar(30)
- m_chuchun — int(4)
- m_ip — varchar(16)
- m_level (g_num) — int(4) — Foreign key → member_group.g_num — NOT NULL
- m_autoimg_str — varchar(6)
- m_temp1 — varchar(50)
- m_temp2 — varchar(50)
- m_temp3 — varchar(50)
- m_secede_date — varchar(30) — 탈퇴일
- m_secede_reason — varchar(2) — 탈퇴사유
- m_point — int(11) — NOT NULL — 적립금
- m_sex — varchar(1)
- m_birth — varchar(200)
- m_sms — varchar(1)
- m_mailing — varchar(1)
- m_marry — varchar(1)
- m_marrydate — varchar(10)
- m_job — varchar(50)
- m_text — mediumtext
- m_recom_id — varchar(30)
- m_license — varchar(10)
- m_buseo — varchar(50)
- m_incorrect — int(4) — NOT NULL
- m_incorrect_time — varchar(20)
- m_pwd_change — varchar(1)
- m_dupinfo — varchar(100)
- m_coinfo — varchar(100)
- m_site — varchar(100)
- m_ncms_manager — varchar(1)
- m_site_manager — varchar(1)
- m_kakao_id — varchar(100)
- m_naver_id — varchar(100)
- m_google_id — varchar(100)
- m_facebook_id — varchar(100)
- m_apple_id — varchar(100)
member_config
- mc_idx — int(4) — Primary key — NOT NULL
- mc_addr — varchar(1) — NOT NULL
- mc_nickname — varchar(1) — NOT NULL
- mc_phone — varchar(1) — NOT NULL
- mc_mobile — varchar(1) — NOT NULL
- mc_email — varchar(1) — NOT NULL
- mc_homepage — varchar(1) — NOT NULL
- mc_joinlevel — varchar(5) — NOT NULL
- mc_wdate — varchar(30) — NOT NULL
- mc_mailing — varchar(1) — NOT NULL
- mc_sms — varchar(1) — NOT NULL
- mc_sex — varchar(1) — NOT NULL
- mc_birth — varchar(1) — NOT NULL
- mc_fax — varchar(1) — NOT NULL
- mc_marry — varchar(1) — NOT NULL
- mc_marrydate — varchar(1) — NOT NULL
- mc_job — varchar(1) — NOT NULL
- mc_text — varchar(1) — NOT NULL
- mc_nickname_req — varchar(1) — NOT NULL
- mc_jumin_req — varchar(1) — NOT NULL
- mc_sex_req — varchar(1) — NOT NULL
- mc_birth_req — varchar(1) — NOT NULL
- mc_phone_req — varchar(1) — NOT NULL
- mc_fax_req — varchar(1) — NOT NULL
- mc_mobile_req — varchar(1) — NOT NULL
- mc_email_req — varchar(1) — NOT NULL
- mc_addr_req — varchar(1) — NOT NULL
- mc_homepage_req — varchar(1) — NOT NULL
- mc_marry_req — varchar(1) — NOT NULL
- mc_marrydate_req — varchar(1) — NOT NULL
- mc_job_req — varchar(1) — NOT NULL
- mc_text_req — varchar(1) — NOT NULL
- mc_recom — varchar(1) — NOT NULL — 추천제사용여부
- mc_recom_point — int(11) — NOT NULL — 추천받은사람 포인트 지급
- mc_new_point — int(11) — NOT NULL — 추천한사람 포인트지급
- mc_agree — varchar(1)
- mc_agree_str — mediumtext
- mc_info — varchar(1) — NOT NULL
- mc_info_str — mediumtext
- mc_join — varchar(1)
- mc_pwd_check — varchar(1) — NOT NULL
- mc_regist_yn — varchar(1) — NOT NULL
- mc_snslogin_yn — varchar(1) — NOT NULL
- mc_auth_method — varchar(20) — NOT NULL
member_group
- g_num — int(4) — Primary key — NOT NULL
- g_code — int(4)
- g_menuname — varchar(50)
- g_chk — varchar(1)
- g_wdate — varchar(30)
- g_manager — varchar(1)
- g_site_dir — varchar(100)
- g_site_manager — varchar(1) — NOT NULL — 사이트관리자 여부
member_group_manage_site
- idx — int(11) — Primary key — NOT NULL
- g_num (g_num2) — int(11) — Foreign key → member_group.g_num — NOT NULL
- bs_directory — varchar(200) — NOT NULL
member_group_site
- idx — int(11) — Primary key — NOT NULL
- g_num (g_num2) — int(11) — Foreign key → member_group.g_num — NOT NULL
- bs_directory — varchar(200) — NOT NULL
menu_counter_YYYYMM (menu_counter_202310)
- idx — int(11) — Primary key — NOT NULL
- page_id — int(4) — NOT NULL
- vDD — tinyint(4) — NOT NULL
- vHH — tinyint(4) — NOT NULL
- counter — int(11) — NOT NULL
- vOut — char(1) — NOT NULL
- page_codeno — varchar(200)
- mobile — varchar(1)
- site_dir — varchar(200)
- bs_num — int(10) — Foreign key → builder_site.bs_num — NOT NULL
popup
- idx — int(4) — Primary key — NOT NULL
- w_width — varchar(4)
- w_height — varchar(4)
- w_top — varchar(4)
- w_left — varchar(4)
- ck_chk — varchar(2)
- ck_val — varchar(2)
- scrollbars — varchar(3)
- toolbar — varchar(3)
- menubar — varchar(3)
- locations — varchar(3)
- subject — varchar(200)
- content — mediumtext
- w_chk — varchar(1)
- wdate — varchar(30)
- mdate — varchar(30)
- sdate — varchar(30)
- edate — varchar(30)
- unlimited — varchar(1) — NOT NULL
- site_dir (bs_num) — varchar(200) — Foreign key → builder_site.bs_num — NOT NULL
- pos — char(1)
popup_layer
- idx — int(4) — Primary key — NOT NULL
- w_width — varchar(4)
- w_height — varchar(4)
- w_top — varchar(4)
- w_left — varchar(4)
- ck_chk — varchar(2)
- ck_val — varchar(2)
- subject — varchar(200)
- content — mediumtext
- w_chk — varchar(1)
- wdate — varchar(30)
- mdate — varchar(30)
- sdate — varchar(30)
- edate — varchar(30)
- unlimited — varchar(1) — NOT NULL
- site_dir (bs_num) — varchar(200) — Foreign key → builder_site.bs_num — NOT NULL
- pos — char(1)
popup_slide
- idx — int(4) — Primary key — NOT NULL
- subject — varchar(200)
- content — mediumtext
- w_chk — varchar(1)
- wdate — varchar(30)
- mdate — varchar(30)
- sdate — varchar(30)
- edate — varchar(30)
- unlimited — varchar(1) — NOT NULL
- site_dir (bs_num) — varchar(200) — Foreign key → builder_site.bs_num — NOT NULL
- pos — char(1)
site_config
- sc_idx — int(4) — Primary key — NOT NULL
- sc_sitename — varchar(100)
- sc_sitename_en — varchar(100)
- sc_ademail — varchar(100)
- sc_url — varchar(150)
- sc_company — varchar(50)
- sc_logo — varchar(200)
- sc_uptae — varchar(30)
- sc_jongmok — varchar(30)
- sc_zipcode — varchar(6)
- sc_addr1 — varchar(100)
- sc_addr2 — varchar(100)
- sc_no — varchar(20)
- sc_no2 — varchar(20)
- sc_ceo — varchar(30)
- sc_phone1 — varchar(4)
- sc_phone2 — varchar(4)
- sc_phone3 — varchar(4)
- sc_fax1 — varchar(4)
- sc_fax2 — varchar(4)
- sc_fax3 — varchar(4)
- sc_title — varchar(100)
- sc_skeyword — varchar(1000)
- sc_hdate1 — varchar(10)
- sc_hdate2 — varchar(10)
- sc_hdd — varchar(3)
- sc_copyright — mediumtext
- sc_logouttime — varchar(4)
- sc_wdate — varchar(30)
- sc_date_chk — varchar(1)
- sc_hdd_chk — varchar(1)
- sc_editor — varchar(20) — NOT NULL
- sc_manager_ip — varchar(1) — NOT NULL
- sc_manager_mobile — varchar(1) — NOT NULL
- sc_session_time — int(5) — NOT NULL
- sc_session_use — char(1) — NOT NULL
- sc_session_count — int(11) — NOT NULL
- sc_session_wait — int(2) — NOT NULL
- sc_person — int(11)
- sc_group — int(11)
- sc_header_meta — mediumtext
- ncms_api_version — float — NOT NULL
visit_counter_YYYYMM (visit_counter_202310)
- vNum — int(4) — Primary key — NOT NULL
- vIP — varchar(15) — NOT NULL
- vDD — tinyint(4) — NOT NULL
- vHH — tinyint(4) — NOT NULL
- vMT — tinyint(4) — NOT NULL
- vSeason — tinyint(4) — NOT NULL
- vDW — tinyint(4) — NOT NULL
- vBrowser — varchar(200) — NOT NULL
- vOS — varchar(200) — NOT NULL
- vURL — varchar(1000) — NOT NULL
- vDomain — varchar(200) — NOT NULL
visit_counter_site_YYYYMM (visit_counter_site_202310)
- vNum — int(4) — Primary key — NOT NULL
- vIP — varchar(15) — NOT NULL
- vDD — tinyint(4) — NOT NULL
- vHH — tinyint(4) — NOT NULL
- vMT — tinyint(4) — NOT NULL
- vSeason — tinyint(4) — NOT NULL
- vDW — tinyint(4) — NOT NULL
- vBrowser — varchar(200) — NOT NULL
- vOS — varchar(200) — NOT NULL
- vURL — varchar(1000) — NOT NULL
- vDomain — varchar(200) — NOT NULL
- vSite_dir (bs_num) — varchar(200) — Foreign key → builder_site.bs_num — NOT NULL