aa
Tables (41)
accomodation_option
- ao_num — int — Primary key — NOT NULL
- ao_name — varchar(20) — NOT NULL
- ao_capacity — int — NOT NULL
- ao_price — int — NOT NULL
- ao_room_number — varchar(20) — NOT NULL
- ao_room_detail — longtext — NOT NULL
- ao_pd_num — int — NOT NULL
attendance
- ad_num — int — Primary key — NOT NULL
- ad_me_id — varchar(45) — NOT NULL
- ad_date — datetime — NOT NULL
buy_list
- bl_num — varchar(45) — Primary key — NOT NULL
- bl_state — varchar(10) — NOT NULL
- bl_total_price — int — NOT NULL
- bl_stack_mile — int — NOT NULL
- bl_use_mile — int
- bl_me_id — varchar(12) — NOT NULL
- bl_date — datetime — NOT NULL
- bl_receipt_id — varchar(45)
- bl_name — varchar(45) — NOT NULL
change_product
- cp_num — int — Primary key — NOT NULL
- cp_pd_num — int — NOT NULL
- cp_rated — int — NOT NULL
- cp_viewcount — int — NOT NULL
- cp_search_volume_count — int — NOT NULL
- cp_date — datetime — NOT NULL
course
- co_num — int — Primary key — NOT NULL
- co_me_id — varchar(12) — NOT NULL
- co_title — varchar(50) — NOT NULL
- co_content — longtext — NOT NULL
- co_cc_category_num — int — NOT NULL
- co_cs_schedule_num — int — NOT NULL
- co_total_distance — varchar(15)
- co_register_date — datetime — NOT NULL
- co_update_date — datetime
- co_up — int — NOT NULL
- co_views — int — NOT NULL
- co_down — int — NOT NULL
- co_report — int — NOT NULL
course_category
- cc_category_num — int — Primary key — NOT NULL
- cc_category_name — varchar(45)
course_item
- ci_num — int — Primary key — NOT NULL
- ci_index — varchar(255) — NOT NULL
- ci_co_num — int — NOT NULL
- ci_pd_num — int — NOT NULL
course_schedule
- cs_schedule_num — int — Primary key — NOT NULL
- cs_schedule_name — varchar(45)
day_off
- do_num — int — Primary key — NOT NULL
- do_pd_num — int — NOT NULL
- do_state — char(2) — NOT NULL
- do_date — varchar(3)
festival_option
- fo_num — int — Primary key — NOT NULL
- fo_price — int — NOT NULL
- fo_age — varchar(6) — NOT NULL
- fo_pd_num — int — NOT NULL
file
- fi_num — int — Primary key — NOT NULL
- fi_category — varchar(20)
- fi_ori_name — varchar(255) — NOT NULL
- fi_name — varchar(255) — NOT NULL
- fi_table — varchar(255) — NOT NULL
- fi_table_key — int — NOT NULL
file_checked
- fc_num — int — Primary key — NOT NULL
- fc_fi_num — int — NOT NULL
- fc_checked — int — NOT NULL
hash_tag
- hg_num — int — Primary key — NOT NULL
- hg_name — varchar(50) — NOT NULL
- hg_pd_num — int — NOT NULL
landmark_option
- lo_num — int — Primary key — NOT NULL
- lo_price — int — NOT NULL
- lo_age — varchar(6) — NOT NULL
- lo_pd_num — int — NOT NULL
like
- li_num — int — Primary key — NOT NULL
- li_me_id — varchar(12) — NOT NULL
- li_table_key — int — NOT NULL
- li_updown — int — NOT NULL
- li_table — varchar(45) — NOT NULL
map_position
- mp_index — int — Primary key — NOT NULL
- mp_x — double — NOT NULL
- mp_y — double — NOT NULL
- mp_pd_num — int — NOT NULL
member
- me_id — varchar(12) — Primary key — NOT NULL
- me_pw — varchar(255) — NOT NULL
- me_name — varchar(13) — NOT NULL
- me_birthday — date — NOT NULL
- me_phone — varchar(13) — NOT NULL — unique_key
- me_gender — char(10) — NOT NULL
- me_authority — int — NOT NULL
- me_nickname — varchar(255) — NOT NULL
- me_street_address — varchar(50) — NOT NULL
- me_registered_address — varchar(50) — NOT NULL
- me_detail_address — varchar(100) — NOT NULL
- me_mileage — int — NOT NULL
- me_session_id — varchar(45)
- me_session_limit — datetime
- me_ma_email — varchar(50) — NOT NULL
- me_post — varchar(100)
- me_score_ao — int — NOT NULL
- me_score_fe — int — NOT NULL
- me_score_la — int — NOT NULL
- me_score_reo — int — NOT NULL
member_approve
- ma_email — varchar(50) — Primary key — NOT NULL
- ma_code — varchar(6) — NOT NULL
- ma_validate_time — datetime — NOT NULL
member_profile
- mf_num — int — Primary key — NOT NULL
- mf_name — varchar(255) — NOT NULL
- mf_ori_name — varchar(255) — NOT NULL
- mf_me_id — varchar(12) — NOT NULL
mileage
- mi_num — int — Primary key — NOT NULL
- mi_date — datetime — NOT NULL
- mi_update — int — NOT NULL
- mi_me_id — varchar(12) — NOT NULL
- mi_bl_num — varchar(45)
note
- nt_num — int — Primary key — NOT NULL
- nt_sender — varchar(45) — NOT NULL
- nt_receiver — varchar(45) — NOT NULL
- nt_is_read — tinyint(1) — NOT NULL
- nt_content — longtext — NOT NULL
- nt_date — datetime — NOT NULL
order_list
- ol_num — int — Primary key — NOT NULL
- ol_amount — int — NOT NULL
- ol_price — int — NOT NULL
- ol_bl_num — varchar(45) — NOT NULL
- ol_table — varchar(30) — NOT NULL
- ol_table_key — int — NOT NULL
- ol_date — date — NOT NULL
- ol_time — int
product
- pd_num — int — Primary key — NOT NULL
- pd_title — varchar(50) — NOT NULL
- pd_content — longtext — NOT NULL
- pd_subtitle — varchar(50) — NOT NULL
- pd_street_address — varchar(50) — NOT NULL
- pd_registerd_address — varchar(50) — NOT NULL
- pd_detail_address — varchar(100) — NOT NULL
- pd_parking — varchar(10) — NOT NULL
- pd_capacity — int — NOT NULL
- pd_viewcount — int — NOT NULL
- pd_open_time — time — NOT NULL
- pd_close_time — time — NOT NULL
- pd_pc_num — int — NOT NULL
- pd_fe_start — datetime
- pd_fe_end — datetime
- pd_score — int — NOT NULL
product_category
- pc_num — int — Primary key — NOT NULL
- pc_category — varchar(10) — NOT NULL
product_checked
- pdc_num — int — Primary key — NOT NULL
- pdc_checked — char(1) — NOT NULL
- pdc_pd_num — int — NOT NULL
qna
- qa_num — int — Primary key — NOT NULL
- qa_title — varchar(100) — NOT NULL
- qa_content — longtext — NOT NULL
- qa_registerd_date — datetime — NOT NULL
- qa_state — varchar(10) — NOT NULL
- qa_me_id — varchar(12) — NOT NULL
- qa_pd_num — int — NOT NULL
- qa_qs_category — varchar(10) — NOT NULL
qna_answer
- qaa_num — int — Primary key — NOT NULL
- qaa_qa_num — int — NOT NULL
- qaa_content — longtext — NOT NULL
- qaa_registerd_date — datetime — NOT NULL
qna_category
- qc_category — varchar(10) — Primary key — NOT NULL
qna_sub_category
- qs_category — varchar(10) — Primary key — NOT NULL
- qs_qc_category — varchar(10) — Foreign key → qna_category.qc_category — NOT NULL
report
- rep_num — int — Primary key — NOT NULL
- rep_table_key — int — NOT NULL
- rep_content — longtext — NOT NULL
- rep_date — datetime — NOT NULL
- rep_category — varchar(25) — NOT NULL
- rep_table — varchar(45)
- rep_me_id — varchar(12) — NOT NULL
reservated_option
- ro_num — int — Primary key — NOT NULL
- ro_option_name — varchar(30) — NOT NULL
- ro_date — date — NOT NULL
- ro_time — int — NOT NULL
- ro_pd_num — int — NOT NULL
- ro_me_id — varchar(12) — NOT NULL
- ro_bl_num — varchar(45) — NOT NULL
reservation_room
- rr_num — int — Primary key — NOT NULL
- rr_check_in — date — NOT NULL
- rr_check_out — date — NOT NULL
- rr_ao_num — int — NOT NULL
- rr_pd_num — int — NOT NULL
- rr_me_id — varchar(12) — NOT NULL
- rr_bl_num — varchar(45) — NOT NULL
restraunt_option
- reo_num — int — Primary key — NOT NULL
- reo_name — varchar(30) — NOT NULL
- reo_price — int — NOT NULL
- reo_content — varchar(100) — NOT NULL
- reo_pd_num — int — NOT NULL
review
- re_num — int — Primary key — NOT NULL
- re_me_id — varchar(12) — NOT NULL
- re_content — longtext — NOT NULL
- re_date — datetime — NOT NULL
- re_update_date — datetime
- re_rating — float — NOT NULL
- re_pd_num — int — NOT NULL
review_comment
- rc_num — int — Primary key — NOT NULL
- rc_re_num — int — NOT NULL
- rc_me_id — varchar(12) — NOT NULL
- rc_content — longtext — NOT NULL
- rc_date — datetime — NOT NULL
search_keyword
- sk_num — int — Primary key — NOT NULL
- sk_keyword — varchar(45) — NOT NULL
- sk_pd_num — int
- sk_date — datetime — NOT NULL
- sk_id — varchar(45)
shopping_basket
- sb_num — int — Primary key — NOT NULL
- sb_me_id — varchar(12) — NOT NULL
- sb_amount — int — NOT NULL
- sb_table — varchar(30) — NOT NULL
- sb_table_key — int — NOT NULL
- sb_price — int — NOT NULL
- sb_date — date — NOT NULL
- sb_time — int
temp_off
- to_num — int — Primary key — NOT NULL
- to_do_num — int — Foreign key → day_off.do_num — NOT NULL
- to_start — date — NOT NULL
- to_end — date — NOT NULL
use_member
- um_bl_num — varchar(45) — Primary key — NOT NULL
- um_name — varchar(10) — NOT NULL
- um_email — varchar(30) — NOT NULL
- um_phone — varchar(13) — NOT NULL
visited
- vi_num — int — Primary key — NOT NULL
- vi_session_id — varchar(255) — NOT NULL
- vi_date — datetime — NOT NULL
- vi_is_member — char(4) — NOT NULL
wishitem
- wi_num — int — Primary key — NOT NULL
- wi_pd_num — int — NOT NULL
- wi_me_id — varchar(12) — NOT NULL