Test
Tables (10)
hospital_holiday
- idx — int(11) — Primary key — NOT NULL
- date — varchar(10) — 휴일
- time — varchar(10) — 예약불가능시간
- gubun — int(1) — 구분(의료진명/지점명)
hospital_jijeom
- idx — int(11) — Primary key — NOT NULL
- biz_jijeom — varchar(50) — 지점명
- biz_name — varchar(50) — 의원명
- biz_ceo — varchar(50) — 원장명
- biz_number — varchar(20) — 사업자등록번호
- biz_sido — varchar(255) — 시/도
- biz_gugun — varchar(255) — 구군
- biz_addr — varchar(255) — 상세주소
- biz_tel — varchar(20) — 고객센터
- biz_fax — varchar(20)
- biz_homepage — varchar(255) — 개인홈페이지 주소
- biz_blog — varchar(255) — 블로그 주소
- biz_img — varchar(255) — 진료시간|오시는길|주차장안내
- copyright — varchar(255)
- map_latitude — varchar(30) — 위도
- map_longitude — varchar(30) — 경도
hospital_reservation
- idx — int(11) — Primary key — NOT NULL
- reser_jijeom — int(1) — 지점
- reser_field — varchar(100) — 상담분류
- reser_crack — varchar(255) — NOT NULL — 진료구분
- reser_name — varchar(255) — 예약자
- reser_mobile — varchar(50) — 예약자 휴대폰
- reser_email — varchar(50) — 예약자 이메일
- reser_sex — varchar(10)
- reser_age — varchar(10)
- reser_comment — text — 상담내용
- sms_flag — varchar(20) — sms 수신여부
- email_flag — varchar(20) — 이메일 수신여부
- reply — text — NOT NULL — 관리자답변
- reg_date — varchar(20) — 등록일
- ip — varchar(20) — 등록IP
- reser_date — varchar(20) — 예약일
- status — varchar(20)
- is_mobile — varchar(10)
- reser_doctor — varchar(30)
- reser_hwa — varchar(10) — NOT NULL — 1 진료 2화상
hospital_search
- idx — int(11) — Primary key — NOT NULL
- subjects — varchar(255) — 노출문구
- link — varchar(255) — 지점
- biz_sort — int(5)
- created_date — datetime — 생성날짜
tblAdminMember
- tblSection — varchar(30)
- tblStrID — varchar(30)
- tblStrPass — varchar(255)
- tblStrName — varchar(30)
- tblStrNickName — varchar(30)
- tblStrPhone — varchar(20) — NOT NULL
- tblStrMobile — varchar(255) — NOT NULL
- tblStrEmail — varchar(100)
- tblIntLevel — int(11)
tblBasicConfig
- idx — int(11) — Primary key — NOT NULL
- tblTitle — varchar(255)
- tblKeyword — varchar(255)
- tblMeta — text
- siteName — varchar(50)
- bizNumber — varchar(20)
- bizAddr — varchar(255)
- bizCeo — varchar(50)
- bizTel — varchar(20)
- bizFax — varchar(20)
- medicalNumber — varchar(20)
- privacyName — varchar(50)
- copyRight — varchar(255)
- tblClauses — text
- tblConsent1 — text — NOT NULL
- tblConsent2 — text
- tblConsent3 — text
- tblConsent4 — text
- tblRejection — text
- nid_ClientID — varchar(50)
- nid_ClientSecret — varchar(50)
- fb_appId — varchar(50)
- fb_secret — varchar(50)
- m_fb_appId — varchar(50)
- m_fb_secret — varchar(50)
- google_secret — varchar(100)
- kakao_secret — varchar(50)
- site — varchar(20)
tblBoardManager
- tblNumber — int(11) — Primary key — NOT NULL
- tblBname — varchar(100) — NOT NULL
- tblBtable — varchar(100) — NOT NULL
- tblSkin — varchar(50) — NOT NULL
- tblCategory — text
- tblUser — int(11)
- tblListLevel — int(11) — NOT NULL
- tblViewLevel — int(11) — NOT NULL
- tblWriteLevel — int(11) — NOT NULL
- tblModifyLevel — int(11) — NOT NULL
- tblReplyLevel — int(11) — NOT NULL
- tblDeleteLevel — int(11) — NOT NULL
- tblHead — varchar(100)
- tblFoot — varchar(100)
- tblSub — enum('Y','N') — NOT NULL
- tblSecret — enum('Y','N') — NOT NULL
- tblHomePage — enum('Y','N') — NOT NULL
- tblLineNumber — int(11) — NOT NULL
- tblPageNumber — int(11) — NOT NULL
- tblmLineNumber — int(11)
- tblmPageNumber — int(11)
- tblViewImage — enum('Y','N') — NOT NULL
- tblThumbnail — char(2)
- tblListimg — varchar(20)
- tblAddfileNumber — int(11)
- tblUploadSize — int(11)
- tblNoExt — varchar(100)
- tblNotice — enum('Y','N') — NOT NULL
- tblUserComment — int(11)
- tblCommentLevel — int(11) — NOT NULL
- tblViewType — int(11)
- tblPoint — enum('Y','N') — NOT NULL
- tblChoice — enum('Y','N') — NOT NULL
- tblProfileView — enum('Y','N') — NOT NULL
- tblAppraisal — enum('Y','N') — NOT NULL
- tblScrap — enum('Y','N') — NOT NULL
- tblPrint — enum('Y','N') — NOT NULL
- tblNickname — enum('Y','N') — NOT NULL
- tblControl — enum('Y','N') — NOT NULL
- tblFilter — text
- tblGroup — varchar(50)
- tblWidth — int(11)
- tblStreaming — enum('Y','N') — NOT NULL
- tblWatermark — enum('Y','N') — NOT NULL
tblPopup
- tblNumber — int(10) — Primary key — NOT NULL
- tblIntSite — tinyint(3) — NOT NULL
- tblStrSubject — varchar(200) — NOT NULL
- tblStrComment — text — NOT NULL
- tblIntLeft — int(10) — NOT NULL
- tblIntTop — int(10) — NOT NULL
- tblIntWidth — int(10) — NOT NULL
- tblIntHeight — int(10) — NOT NULL
- tblIntStatus — tinyint(3)
- tblStrDevice — enum('mobile','pc')
- tblIntOrder — int(11)
- tblDtmSdate — date — NOT NULL
- tblDtmEdate — date — NOT NULL
- tblDtmRegDate — datetime — NOT NULL
tblStatistics
- statistics_idx — int(10) — Primary key — NOT NULL
- statistics_year — int(10)
- statistics_month — int(10)
- statistics_day — int(10)
- statistics_hour — int(10)
- statistics_week — int(10)
- statistics_date — datetime
- statistics_browser — varchar(225)
- statistics_host — varchar(100)
- statistics_hostname — varchar(100)
- statistics_keyword — varchar(100)
- statistics_refer — varchar(225)
- statistics_ip — varchar(45)
- statistics_member — varchar(45)
tblVisit_sum
- vs_date — date — Primary key — NOT NULL
- vs_count — int(11) — NOT NULL
- INDEX — `index1`(`vs_count`)