ㅌㅅㅌ
Tables (14)
sample_advertise
- num — int — Primary key — NOT NULL
- seller_num — int — NOT NULL
- file_copied — varchar(45) — NOT NULL
- store_name — varchar(45) — NOT NULL
- introduction — text
- regist_day — varchar(20) — NOT NULL
- noshow — tinyint(1) — NOT NULL
sample_board
- num — int — Primary key — NOT NULL
- group_num — int — NOT NULL
- group_depth — int — NOT NULL
- group_order — int — NOT NULL
- id — varchar(20) — NOT NULL
- name — varchar(10) — NOT NULL
- subject — varchar(200) — NOT NULL
- content — text — NOT NULL
- regist_day — varchar(20) — NOT NULL
- hit — int — NOT NULL
- file_name — varchar(45)
- file_copied — varchar(45)
- file_type — varchar(45)
sample_bookmark
- bookmark_num — int — Primary key — NOT NULL
- user_id — varchar(20) — NOT NULL
- bookmark_subject — varchar(200) — NOT NULL
- group_num — int — NOT NULL
- seller_num — text — NOT NULL
- regist_day — varchar(20) — NOT NULL
- file_name — varchar(45)
- file_copied — varchar(45)
- file_type — varchar(45)
sample_keyword_list
- keyword_num — int — Primary key — NOT NULL
- keywords_type — varchar(200) — NOT NULL
- keywords — varchar(400)
sample_menu_img
- num — int — Primary key — NOT NULL
- user_id — varchar(20) — NOT NULL
- seller_num — int — NOT NULL
- store_name — varchar(45) — NOT NULL
- menu_name — varchar(45) — NOT NULL
- menu_price — int — NOT NULL
- menu_file_name — varchar(45) — NOT NULL
- menu_file_type — varchar(45) — NOT NULL
- menu_file_copied — varchar(45) — NOT NULL
- menu_explain — text
sample_message
- message_num — int — Primary key — NOT NULL
- group_num — int — NOT NULL
- group_order — int — NOT NULL
- send_id — varchar(20) — NOT NULL
- seller_num — varchar(20) — NOT NULL
- subject — varchar(200) — NOT NULL
- content — text — NOT NULL
- regist_day — varchar(20) — NOT NULL
- file_name — varchar(45)
- file_copied — varchar(45)
- file_type — varchar(45)
sample_reservation
- reservation_num — int — Primary key — NOT NULL
- seller_num — int — NOT NULL
- store_name — varchar(45) — NOT NULL
- introduction — text
- user_id — varchar(45) — NOT NULL
- seller_id — varchar(45) — NOT NULL
- select_date — char(15) — NOT NULL
- select_time — char(8) — NOT NULL
- select_person — char(5) — NOT NULL
- select_menu — text — NOT NULL
- reservation_special — text
- intensity_of_reserv — char(2) — NOT NULL
- noshow — tinyint(1)
- cancel — tinyint(1)
sample_restaurants
- num — int — Primary key — NOT NULL
- trdp_area_dress_room — varchar(200)
- trdp_area — varchar(200)
- upso_site_telno — varchar(200)
- upso_sno — varchar(200)
- bdng_jisg_flr_num — varchar(200)
- upso_nm — varchar(200)
- ntn — varchar(200)
- bdng_jisg_flr_num2 — varchar(200)
- toil_etc_area_upso — varchar(200)
- bup_nm — varchar(200)
- grade_facil_gbn — varchar(200)
- area_wrk — varchar(200)
- perm_nt_cn — varchar(200)
- trdp_area_jorijang — varchar(200)
- cn_perm_stdt — varchar(200)
- ordtm_ptsof_avg — varchar(200)
- mng_gbn — varchar(200)
- perm_nt_ymd — varchar(200)
- cn_perm_enddt — varchar(200)
- site_addr — varchar(200)
- ptsof_sort — varchar(200)
- rfn_item — varchar(200)
- snt_cob_code — varchar(200)
- trdp_area_etc — varchar(200)
- cn_perm_nt_sayu — varchar(200)
- snt_cob_nm — varchar(200)
- bman_stdt — varchar(200)
- yy — varchar(200)
- one_ptsof_stf — varchar(200)
- site_addr_rd — varchar(200)
- site_loc_gbn — varchar(200)
- site_stdt — varchar(200)
- eip_woman — varchar(200)
- bdng_under_flr_num2 — varchar(200)
- trdp_area_guest_seat — varchar(200)
- trdp_disp_sil_ar — varchar(200)
- bdng_tot_flr_num — varchar(200)
- area_isp — varchar(200)
- admdng_nm — varchar(200)
- ed_fin_ymd — varchar(200)
- kor_frgnr_gbn — varchar(200)
- cgg_code — varchar(200)
- bdng_under_flr_num — varchar(200)
- snt_uptae_nm — varchar(200)
- eip_man — varchar(200)
- trdp_area_room — varchar(200)
- trdp_area_dance — varchar(200)
- dcb_gbn_nm — varchar(200)
- trdp_ware_depo_ar — varchar(200)
- toil_area_upso — varchar(200)
- dcb_why — varchar(200)
- perm_nt_no — varchar(200)
- ge_eh_yn — varchar(200)
- ordtm_ptsof_max — varchar(200)
- avg_food_amt — varchar(200)
- dcb_ymd — varchar(200)
- upso_latitude — varchar(200)
- upso_longitude — varchar(200)
sample_review
- num — int — Primary key — NOT NULL
- seller_num — int — NOT NULL
- user_Email — varchar(100)
- user_name — varchar(20)
- store_name — varchar(45) — NOT NULL
- content — text
- file_name — varchar(45)
- file_copied — varchar(45)
- file_type — varchar(45)
- star_access — int
- star_service — int
- star_flavor — int
- star_avg — float(2,1)
- chu_up — int
- chu_down — int
- regist_day — varchar(20) — NOT NULL
- noshow — tinyint(1)
sample_seller
- seller_num — int — Primary key — NOT NULL
- user_id — varchar(20) — NOT NULL
- business_license — char(10) — NOT NULL
- store_name — varchar(45) — NOT NULL
- store_type — varchar(45) — NOT NULL
- store_address — varchar(400) — NOT NULL
- store_postcode — char(10) — NOT NULL
- store_lat — double — NOT NULL
- store_lon — double — NOT NULL
- convenient_facilities — varchar(80) — NOT NULL
- introduction — text
- break_start — char(10)
- break_end — char(10)
- nokids — tinyint(1) — NOT NULL
- opening_day — date — NOT NULL
- opening_hours_start — char(10) — NOT NULL
- opening_hours_end — char(10) — NOT NULL
- store_tel — char(13) — NOT NULL
- special_note — text
- max_reserv_time_num_of_people — int — NOT NULL
- max_reserv_month — char(10) — NOT NULL
- intensity_of_reserv — char(10) — NOT NULL
- keywords — varchar(100)
sample_seller_keyword (하잇)
- num — int — NOT NULL
- seller_num — varchar(100) — NOT NULL
- seller_name — varchar(100) — NOT NULL
- seller_address — varchar(300) — NOT NULL
- seller_uptae_nm — varchar(100) — NOT NULL
- tag_class — varchar(100) — NOT NULL
sample_store_img
- num — int — Primary key — NOT NULL
- user_id — varchar(20) — NOT NULL
- seller_num — int — NOT NULL
- store_name — varchar(45) — NOT NULL
- store_file_name — varchar(45) — NOT NULL
- store_file_type — varchar(45) — NOT NULL
- store_file_copied — varchar(45) — NOT NULL
sample_user
- idx — int — Primary key — NOT NULL
- user_sns — varchar(3)
- user_email — varchar(50)
- user_email_check — varchar(2)
- user_password — varchar(30)
- user_name — varchar(20)
- user_age — varchar(100)
- user_phone — varchar(20)
- user_regist_day — varchar(30)
- user_profile — varchar(50)
- user_profile_copied — varchar(50)
- user_profile_type — varchar(50)
- user_about — varchar(300)
- user_level — varchar(100)
sample_user_mylist
- mylist_num — int — Primary key — NOT NULL
- user_num — int — NOT NULL
- seller_num — int — NOT NULL
- store_name — varchar(80) — NOT NULL
- pic_file — varchar(80)
- regist_day — varchar(45) — NOT NULL