Hosion-Final
Tables (50)
admin
- idx — int(11) — Primary key — NOT NULL
- id — varchar(20)
- passwd — varchar(255)
- name — varchar(30)
- nick — varchar(50)
- email — varchar(200)
- hphone — varchar(15)
- level — tinyint(4)
- wdate — datetime
- wid — varchar(20)
- mdate — datetime
- mid — varchar(20)
- isdel — varchar(2)
- ddate — datetime
- did — varchar(20)
- last — datetime
- photo — varchar(100)
- photo_name — varchar(255)
- memo — text
- ip — varchar(45)
- post — varchar(5)
- address1 — varchar(100)
- address2 — varchar(200)
admin_auth
- id — varchar(20)
- menu — varchar(10)
- wid — varchar(20)
- wdate — datetime
admin_log
- admin_id — varchar(20)
- mdate — datetime
- mip — varchar(20)
- mid — varchar(20)
- code — varchar(10)
aligo_talk_log
- idx — int(11) — Primary key — NOT NULL
- code — varchar(10)
- message — varchar(100)
- type — varchar(10)
- mid — varchar(45)
- current — int(11)
- unit — int(11)
- total — int(11)
- scnt — int(11)
- fcnt — int(11)
- wdate — datetime
- wid — varchar(20)
aligo_templete
- idx — int(11) — Primary key — NOT NULL
- templtName — varchar(200)
- status — varchar(10)
- inspStatus — varchar(10)
- senderKey — varchar(45)
- cdate — datetime
- templtCode — varchar(20)
- templtContent — text
- wdate — datetime
- wid — varchar(20)
- mdate — datetime
- mid — varchar(20)
aligo_token
- idx — int(11) — Primary key — NOT NULL
- token — varchar(255)
- code — int(11)
- message — varchar(255)
- ip — varchar(20)
- wdate — datetime
- wid — varchar(20)
- urlencode — varchar(255)
api_conn_log
- wdate — date
- token — varchar(255)
- type — varchar(20)
- tidx — int(11)
app_info
- app_ver — varchar(50)
- mng_ver — varchar(50)
- site_name — varchar(20)
- site_url — varchar(100)
- ftp_host — varchar(100)
- ftp_id — varchar(50)
- ftp_passwd — varchar(255)
- super_id — varchar(20)
- super_passwd — varchar(255)
- com_num — varchar(15)
- com_name — varchar(25)
- com_owner — varchar(50)
- com_post — varchar(5)
- com_address1 — varchar(255)
- com_address2 — varchar(255)
- com_kind — varchar(20)
- com_class — varchar(20)
- com_tel — varchar(15)
- com_fax — varchar(15)
- com_email — varchar(45)
- com_seal — varchar(50)
- com_seal_name — varchar(50)
- og_title — varchar(50)
- og_keyword — varchar(255)
- og_description — varchar(255)
- og_image — varchar(100)
- favicon — varchar(100)
- review_point — int(11)
- reserve_per — float
- naver_key — varchar(255)
- og_image_name — varchar(255)
- benefit_per — float
- com_seller_num — varchar(100)
- imp_id — varchar(45)
- imp_apikey — varchar(255)
- imp_secret — varchar(255)
- admin_copyright — varchar(255)
- favicon_name — varchar(50)
- point_expired — varchar(20)
- customer_email — varchar(100)
- customer_tel — varchar(20)
- partner_copyright — varchar(255)
- kakao_channel — varchar(45)
- aligo_key — varchar(45)
- aligo_id — varchar(45)
- aligo_plusid — varchar(45)
- aligo_phone — varchar(45)
- aligo_code — varchar(45)
- aligo_senderkey — varchar(255)
- aligo_token — varchar(255)
- aligo_alt_cnt — int(11)
- aligo_sms_cnt — int(11)
- aligo_lms_cnt — int(11)
- aligo_mms_cnt — int(11)
- customer_stime — time
- customer_etime — time
- kakao_stime — time
- kakao_etime — time
- customer_member — tinyint(4)
- kakao_member — tinyint(4)
- … +2
app_token_log
- token — varchar(255)
- wdate — datetime
- mdate — datetime
- id — varchar(20)
app_tutorial
- idx — int(11) — Primary key — NOT NULL
- title — varchar(20)
- upfile — varchar(30)
- upfile_name — varchar(255)
- wid — varchar(20)
- wdate — datetime
- prior — tinyint(4)
- size — varchar(30)
- mid — varchar(20)
- mdate — datetime
banner
- idx — int(11) — Primary key — NOT NULL
- code — varchar(20)
- prior — int(3)
- btype — varchar(10)
- relidx — int(11)
- isshow — tinyint(4)
- stime — datetime
- etime — datetime
- memo — varchar(45)
- wdate — datetime
- wid — varchar(20)
- mdate — datetime
- mid — varchar(20)
- ddate — datetime
- did — varchar(20)
- isdel — varchar(2)
- upfile — varchar(50)
- upfile_name — varchar(255)
- sdate — date
- edate — date
banner_info
- idx — int(11) — Primary key — NOT NULL
- title — varchar(30)
- code — varchar(20)
- width — int(11) — 배너 등록 시 예시용
- height — int(11) — 배너 등록 시 예시용
- wdate — datetime
- wid — varchar(20)
- mdate — datetime
- mid — varchar(20)
- ddate — datetime
- did — varchar(20)
- isdel — varchar(20)
bbs
- idx — int(11) — Primary key — NOT NULL
- code — varchar(10)
- ridx — int(11)
- vidx — int(11)
- vridx — int(11)
- prior — int(11)
- id — varchar(20)
- name — varchar(100)
- hphone — varchar(20)
- email — varchar(200)
- subject — varchar(200)
- content — text
- cnt — int(11)
- cmt_cnt — int(11)
- upfile1 — varchar(50)
- upfile1_name — varchar(255)
- wid — varchar(20)
- wdate — datetime
- mid — varchar(20)
- mdate — datetime
- isdel — varchar(2)
- did — varchar(20)
- ddate — datetime
- answer — text
- status — varchar(2)
- category — varchar(30)
- aid — varchar(20)
- aname — varchar(100)
- issecret — varchar(2)
- star — tinyint(4)
- upfile2 — varchar(100)
- upfile3 — varchar(100)
- upfile4 — varchar(100)
- upfile2_name — varchar(255)
- upfile3_name — varchar(255)
- upfile4_name — varchar(255)
- adate — datetime
- delreq — varchar(2)
- addinfo1 — varchar(255)
- addinfo2 — varchar(255)
bbs_info
- code — varchar(10) — Primary key — NOT NULL
- title — varchar(20)
- category — varchar(255)
comment
- idx — int(11) — Primary key — NOT NULL
- code — varchar(10)
- bidx — varchar(10)
- ridx — varchar(10)
- vidx — varchar(10)
- vridx — varchar(10)
- star — tinyint(4)
- id — varchar(20)
- name — varchar(20)
- content — text
- depth — tinyint(4)
- grp — int(11)
- cidx — int(11)
- recom — int(11)
- wid — varchar(20)
- wdate — datetime
- mid — varchar(20)
- mdate — datetime
- isdel — varchar(2)
- did — varchar(20)
- ddate — datetime
conn_log
- time — varchar(10)
- cnt — int(11)
conn_member
- wdate — datetime
- token — varchar(255)
curation
- idx — int(11) — Primary key — NOT NULL
- title — varchar(30)
- cnt — int(11)
- wdate — datetime
- wid — varchar(20)
- mdate — datetime
- mid — varchar(20)
- ddate — datetime
- did — varchar(20)
- isdel — varchar(2)
- prior — tinyint(4)
- memo — text
- code — varchar(10)
curation_rel
- cidx — int(11)
- vidx — int(11)
- prior — int(11)
duple_check
- wdate — datetime
- token — varchar(255)
- type — varchar(10)
- idx — int(11)
holiday
- idx — int(11) — Primary key — NOT NULL
- name — varchar(45)
- hdate — date
- wid — varchar(20)
- wdate — datetime
- mid — varchar(20)
- mdate — datetime
iamport_log
- idx — int(11) — Primary key — NOT NULL
- rno — varchar(30)
- ridx — int(11)
- access_token — varchar(255)
- code — varchar(10)
- message — varchar(255)
- amount — int(11)
- apply_num — varchar(20)
- bank_code — varchar(10)
- bank_name — varchar(20)
- buyer_addr — varchar(100)
- buyer_email — varchar(40)
- buyer_name — varchar(20)
- buyer_postcode — varchar(5)
- buyer_tel — varchar(11)
- cancel_amount — int(11)
- cancel_reason — varchar(255)
- cancelled_at — varchar(45)
- card_code — varchar(10)
- card_name — varchar(20)
- card_number — varchar(30)
- card_quota — int(11)
- card_type — int(11)
- cash_receipt_issued — varchar(30)
- channel — varchar(30)
- currency — varchar(5)
- emb_pg_provider — varchar(45)
- escrow — varchar(45)
- fail_reason — varchar(45)
- failed_at — varchar(45)
- imp_uid — varchar(45)
- merchant_uid — varchar(45)
- name — varchar(45)
- paid_at — varchar(45)
- pay_method — varchar(45)
- pg_id — varchar(45)
- pg_provider — varchar(45)
- pg_tid — varchar(255)
- receipt_url — varchar(255)
- started_at — varchar(45)
- status — varchar(45)
- user_agent — varchar(255)
- wdate — datetime
- cancel_receipt_urls — varchar(100)
- cancel_history — varchar(255)
iamport_token
- idx — int(11) — Primary key — NOT NULL
- access_token — varchar(255)
- token_now — varchar(30)
- expired_at — varchar(30)
- ip — varchar(20)
- wdate — datetime
- wid — varchar(20)
mail_token
- idx — int(11) — Primary key — NOT NULL
- id — varchar(50)
- token — varchar(255)
- email — varchar(100)
- wdate — datetime
member
- idx — int(11) — Primary key — NOT NULL
- id — varchar(20)
- email — varchar(200)
- passwd — varchar(255)
- naverkey — varchar(255)
- kakaokey — varchar(255)
- googlekey — varchar(255)
- applekey — varchar(255)
- name — varchar(20)
- nick — varchar(100)
- hphone — varchar(15)
- birthday — date
- sex — varchar(2)
- token — varchar(255)
- os — varchar(10)
- isout — varchar(2)
- odate — datetime
- wdate — datetime
- mdate — datetime
- mid — varchar(20)
- visit — int(11)
- vtime — datetime
- isdel — varchar(2)
- ddate — datetime
- did — varchar(20)
- memo — text
- out_memo — text
- wid — varchar(20)
- sns — varchar(10)
page
- idx — int(11) — Primary key — NOT NULL
- code — varchar(10)
- title — varchar(50)
- content — longtext
- wdate — datetime
- wid — varchar(20)
- mdate — datetime
- mid — varchar(20)
- isdel — varchar(2)
- did — varchar(20)
- ddate — datetime
page_info
- idx — int(11) — Primary key — NOT NULL
- code — varchar(10)
- title — varchar(100)
- memo — text
- wid — varchar(20)
- wdate — datetime
- mid — varchar(20)
- mdate — datetime
- isdel — varchar(2)
- did — varchar(20)
- ddate — datetime
- prior — tinyint(4)
- required — tinyint(4)
- joined — tinyint(4)
- main — tinyint(4)
partner
- idx — int(11) — Primary key — NOT NULL
- id — varchar(50)
- passwd — varchar(255)
- name — varchar(100)
- com_owner — varchar(50)
- com_post — varchar(5)
- com_address1 — varchar(200)
- com_address2 — varchar(255)
- com_tel — varchar(25)
- com_num — varchar(13)
- hphone — varchar(15)
- token — varchar(255)
- os — varchar(10)
- wid — varchar(20)
- wdate — datetime
- mid — varchar(20)
- mdate — datetime
- isdel — varchar(2)
- did — varchar(20)
- ddate — datetime
- com_email — varchar(200)
- com_name — varchar(100)
- com_kind — varchar(50)
- com_class — varchar(45)
- acc_bank — varchar(20)
- acc_owner — varchar(20)
- acc_num — varchar(50)
- benefit_per — float
- memo — text
- max_day — int(5)
- last — datetime
partner_calc
- idx — int(11) — Primary key — NOT NULL
- id — varchar(50)
- rno — varchar(30)
- ridx — int(11)
- price — int(11)
- pay — int(11)
- profit — int(11)
- calc — int(11)
- pdate — date
- wdate — datetime
- wid — varchar(20)
- isdel — varchar(2)
- ddate — datetime
- did — varchar(20)
- memo — varchar(100)
point
- idx — int(11) — Primary key — NOT NULL
- id — varchar(20)
- ridx — int(11)
- rno — varchar(30)
- bidx — int(11)
- status — tinyint(4) — 0:적립,1:사용,-1:유효기간만료
- point — int(11)
- uidx — int(11)
- uno — varchar(30)
- edate — datetime
- ptype — varchar(15) — reservation : 예약적립 / \nservice : 서비스적립 / \nReview : 후기적립
- wid — varchar(20)
- wdate — datetime
- isdel — varchar(2)
- did — varchar(20)
- ddate — datetime
- memo — text
point_event
- idx — int(11) — Primary key — NOT NULL
- id — varchar(20)
- status — tinyint(4) — 0:적립,1:사용,-1:유효기간만료
- point — int(11)
- edate — datetime
- pidx — int(11)
- midx — int(11)
- aidx — int(11)
- wid — varchar(20)
- wdate — datetime
- isdel — varchar(2)
- did — varchar(20)
- ddate — datetime
push_check
- idx — int(11)
- id — varchar(20)
push_list
- idx — int(11)
- token — varchar(255)
- id — varchar(50)
push_noti
- idx — int(11) — Primary key — NOT NULL
- title — varchar(50)
- content — varchar(255)
- image — varchar(50)
- ispublic — varchar(2)
- cnt — int(11)
- wid — varchar(20)
- wdate — datetime
- rstatus — varchar(2)
- screen — varchar(100)
- screen_idx — varchar(20)
reservation
- idx — int(11) — Primary key — NOT NULL
- vidx — int(11)
- vridx — int(11)
- rno — varchar(30)
- id — varchar(20)
- rname — varchar(30)
- rhphone — varchar(15)
- uname — varchar(30)
- uhphone — varchar(15)
- ucnt — tinyint(4)
- memo — text
- sdate — date
- edate — date
- days — tinyint(4)
- wdate — datetime
- status — varchar(2)
- price — int(11)
- point — int(11)
- pay — int(11)
- point_per — tinyint(4)
- pdate — datetime
- cancel — int(11)
- cdate — datetime
- imp_uid — varchar(30)
- pg_tid — varchar(200)
- receipt_url — text
- card_name — varchar(20)
- card_code — varchar(10)
- card_number — varchar(30)
- card_quota — tinyint(4)
- bank_name — varchar(30)
- bank_code — varchar(30)
- apply_num — varchar(30)
- chkin — time
- chkout — time
- isdel — varchar(2)
- ddate — datetime
- did — varchar(20)
- wid — varchar(20)
- mdate — datetime
- mid — varchar(20)
- pay_method — varchar(10)
- pid — varchar(50)
- isshow — tinyint(4)
- profit — int(11)
- calc — int(11)
- user_agent — varchar(255)
- cmemo — varchar(255)
reservation_prd
- ridx — int(11)
- rno — varchar(30)
- rdate — date
- price — int(11)
- status — varchar(4)
- profit — int(11)
sms_auth
- idx — int(11) — Primary key — NOT NULL
- token — varchar(255)
- hphone — varchar(15)
- auth_num — varchar(10)
- status — varchar(2)
- msg_id — varchar(50)
- wdate — datetime
- mdate — datetime
test
- idx — int(11) — Primary key — NOT NULL
- testtime — datetime
test2
- idx — int(11) — Primary key — NOT NULL
- testtime — datetime
villa
- idx — int(11) — Primary key — NOT NULL
- title — varchar(50)
- id — varchar(50)
- post — varchar(5)
- address1 — varchar(50)
- address2 — varchar(100)
- lat — float
- lng — float
- isin — tinyint(4)
- isfin — varchar(2)
- isshow — tinyint(4)
- intro — text
- intro2 — varchar(255)
- info — text
- info2 — text
- category — tinyint(4) — 0:일반,1:독채,2:단독채
- chkin — time
- chkout — time
- star — float
- rvcnt — int(11)
- lkcnt — int(11)
- vcnt — int(11)
- wid — varchar(20)
- wdate — datetime
- mid — varchar(20)
- mdate — datetime
- isdel — varchar(2)
- did — varchar(20)
- ddate — datetime
villa_1night
- vidx — int(11)
- month — varchar(2)
villa_area
- vidx — int(11)
- area1 — varchar(45)
- area2 — varchar(45)
- area3 — varchar(45)
villa_cancel
- vidx — int(11)
- vridx — varchar(20)
- cday — tinyint(4)
- refund — tinyint(4)
villa_event
- vidx — int(11)
- eidx — int(11)
- vpidx — int(11)
- prior — int(11)
- discount — varchar(45)
- sdate — date
- edate — date
villa_event_info
- idx — int(11) — Primary key — NOT NULL
- subject — varchar(200)
- content — text
- sdate — date
- edate — date
- upfile — varchar(50)
- upfile_name — varchar(255)
- intro — varchar(255)
- discount_type — tinyint(4)
- discount — int(11)
- wid — varchar(20)
- wdate — datetime
- mid — varchar(20)
- mdate — datetime
- isdel — varchar(2)
- did — varchar(20)
- ddate — datetime
- isend — tinyint(4)
villa_like
- vidx — varchar(20)
- id — varchar(20)
villa_noti
- idx — int(11) — Primary key — NOT NULL
- vidx — int(11)
- subject — varchar(50)
- contents — text — 내용^내용^내용^
- wid — varchar(20)
- wdate — datetime
- prior — tinyint(4)
villa_off
- vidx — int(11)
- vridx — int(11)
- offdate — date
villa_opt
- vidx — int(11)
- oidx — int(11)
- code — varchar(10)
villa_opt_grp
- code — varchar(10)
- title — varchar(50)
- wid — varchar(45)
- wdate — datetime
- mid — varchar(45)
- mdate — datetime
- isdel — varchar(2)
- did — varchar(45)
- ddate — datetime
- prior — tinyint(4)
- memo — text