village0518

Tables (50)

admin

  • admin_idx — bigint(20) — Primary key — NOT NULL
  • access_token — tinytext
  • active_yn — bit(1)
  • approval_date — datetime
  • certification_number — varchar(255)
  • certification_yn — bit(1)
  • create_at — datetime — NOT NULL
  • delete_at — datetime
  • delete_yn — bit(1)
  • id — varchar(255) — NOT NULL
  • ip_value — tinytext
  • last_login_date — datetime
  • name — varchar(255) — NOT NULL
  • nick_name — varchar(255)
  • password — varchar(1000) — NOT NULL
  • phone_num — varchar(255)
  • update_at — datetime
  • updator — varchar(255)
  • team_idx — bigint(20) — Foreign key → affiliated_team.team_idx — NOT NULL
  • team_name — varchar(255)

admin_group

  • group_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • create_at — datetime — NOT NULL
  • delete_at — datetime
  • delete_yn — bit(1)
  • group_desc — varchar(1000)
  • group_name — varchar(255)
  • update_at — datetime
  • updator — varchar(255)
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx — NOT NULL

admin_log

  • log_idx — bigint(20) — Primary key — NOT NULL
  • content — varchar(255)
  • create_at — datetime — NOT NULL
  • menu_name — varchar(255)
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx — NOT NULL

affiliated_team

  • team_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • create_at — datetime
  • name — varchar(255)
  • update_at — datetime
  • updator — varchar(255)
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx — NOT NULL

alarm

  • alarm_idx — bigint(20) — Primary key — NOT NULL
  • content — varchar(255)
  • create_at — datetime — NOT NULL
  • delete_at — datetime
  • delete_yn — bit(1)
  • read_yn — bit(1)
  • update_at — datetime
  • user_idx — bigint(20) — Foreign key — NOT NULL
  • chat_idx — bigint(20)
  • rental_idx — bigint(20)
  • review_idx — bigint(20)
  • host_idx — bigint(20)

am_image

  • image_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime
  • image_url — tinytext
  • update_at — datetime
  • updator — varchar(255)
  • am_idx — bigint(20) — Foreign key → arbitration_management.am_idx — NOT NULL

arbitration_management

  • am_idx — bigint(20) — Primary key — NOT NULL
  • am_content — longtext
  • am_status — int(10)
  • answer_content — longtext
  • complete_at — datetime
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • update_at — datetime
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx
  • transaction_idx — bigint(20) — Foreign key — NOT NULL
  • user_idx — bigint(20) — Foreign key — NOT NULL
  • updator — varchar(255)

black

  • black_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime — NOT NULL
  • delete_at — datetime
  • delete_yn — bit(1)
  • reason — varchar(255)
  • sign_at — datetime — NOT NULL
  • update_at — datetime
  • updator — varchar(255)
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx — NOT NULL
  • user_idx — bigint(20) — Foreign key — NOT NULL

block_post

  • block_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • processing_content — varchar(1000)
  • processing_status — int(11)
  • reason — varchar(255)
  • reporter_idx — bigint(20)
  • update_at — datetime
  • updator — varchar(255)
  • category_idx — bigint(20) — Foreign key → category.category_idx — NOT NULL
  • rental_idx — bigint(20) — Foreign key → rental.rental_idx — NOT NULL
  • complete_at — datetime

block_review

  • block_review_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • processing_content — varchar(1000)
  • processing_status — int(11)
  • reason — varchar(255)
  • reporter_idx — bigint(20)
  • update_at — datetime
  • updator — varchar(255)
  • category_idx — bigint(20) — Foreign key → category.category_idx — NOT NULL
  • review_idx — bigint(20) — Foreign key → review.review_idx — NOT NULL
  • complete_at — datetime

block_type

  • block_type_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • type_flag — int(11)
  • type_name — varchar(255)
  • update_at — datetime
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx — NOT NULL

block_user

  • block_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • processing_content — varchar(1000)
  • processing_status — int(11)
  • reason — varchar(255)
  • reporter_idx — bigint(20)
  • update_at — datetime
  • updator — varchar(255)
  • category_idx — bigint(20) — Foreign key → category.category_idx — NOT NULL
  • user_idx — bigint(20) — Foreign key — NOT NULL
  • complete_at — datetime

category

  • category_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • name — varchar(255)
  • off_image_url — varchar(1000)
  • on_image_url — varchar(1000)
  • order_num — int(11)
  • update_at — datetime
  • updator — varchar(255)
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx — NOT NULL
  • image_url — varchar(1000)
  • category_type — varchar(255)

category_image

  • image_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime — NOT NULL
  • image_url — varchar(1000)
  • update_at — datetime
  • updator — varchar(255)
  • category_idx — bigint(20) — Foreign key → category.category_idx — NOT NULL

charge

  • charge_idx — bigint(20) — Primary key — NOT NULL
  • amount — varchar(255)
  • bank_name — varchar(255)
  • bank_number — varchar(255)
  • create_at — datetime — NOT NULL
  • method_id — varchar(255)
  • order_id — varchar(255)
  • pay_fee — varchar(255)
  • payment_key — varchar(255)
  • payments_info_idx — bigint(20) — Foreign key → payments_info.payments_info_idx
  • user_idx — bigint(20) — Foreign key

chat_content

  • chat_idx — bigint(20) — Primary key — NOT NULL
  • check_yn — bit(1)
  • content — varchar(255)
  • create_at — datetime
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx
  • chat_room_idx — bigint(20) — Foreign key → chat_room.chat_room_idx — NOT NULL
  • user_idx — bigint(20) — Foreign key — NOT NULL

chat_image

  • image_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime
  • image_url — varchar(1000)
  • chat_idx — bigint(20) — Foreign key → chat_content.chat_idx — NOT NULL

chat_room

  • chat_room_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime
  • receiver_idx — bigint(20)
  • sender_idx — bigint(20)
  • update_at — datetime
  • updator — varchar(255)
  • rental_idx — bigint(20) — Foreign key → rental.rental_idx — NOT NULL
  • transaction_idx — bigint(20) — Foreign key

connect_menu

  • connect_idx — bigint(20) — Primary key — NOT NULL
  • connect_cnt — bigint(20)
  • create_at — datetime
  • update_at — datetime
  • view_id — varchar(255)
  • view_name — varchar(255)

connect_menu_stattistics

  • cms_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime
  • today_cnt — bigint(20)
  • connect_menu_idx — bigint(20) — Foreign key → connect_menu.connect_idx
  • leave_menu_idx — bigint(20) — Foreign key → leave_menu.leave_idx

coupon

  • coupon_idx — bigint(20) — Primary key — NOT NULL
  • coupon_desc — varchar(1000)
  • coupon_fee — varchar(100)
  • coupon_name — varchar(100) — NOT NULL
  • create_at — datetime — NOT NULL
  • delete_at — datetime
  • delete_yn — bit(1)
  • end_date — datetime
  • open_date — datetime
  • start_date — datetime
  • update_at — datetime
  • updator — varchar(255)
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx — NOT NULL

coupon_management

  • coupon_manage_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime — NOT NULL
  • delete_at — datetime
  • delete_yn — bit(1)
  • update_at — datetime
  • updator — varchar(255)
  • use_at — datetime
  • use_yn — bit(1)
  • coupon_idx — bigint(20) — Foreign key → coupon.coupon_idx — NOT NULL
  • user_idx — bigint(20) — Foreign key — NOT NULL

crud_auth

  • crud_idx — bigint(20) — Primary key — NOT NULL
  • auth — int(11) — NOT NULL
  • create_at — datetime — NOT NULL
  • menu_url — varchar(255) — NOT NULL
  • menu_idx — bigint(20) — Foreign key → menu.menu_idx — NOT NULL

evaluation_items

  • items_idx — bigint(20) — Primary key — NOT NULL
  • comment — varchar(100)
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • order_num — int(11)
  • update_at — datetime
  • updator — varchar(255)
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx — NOT NULL

faq

  • faq_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • content — longtext
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • title — varchar(255)
  • update_at — datetime
  • updator — varchar(255)
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx — NOT NULL
  • category_idx — bigint(20) — Foreign key → category.category_idx — NOT NULL
  • active_at — datetime
  • answer — longtext

faq_type

  • faq_type_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime
  • delete_yn — bit(1)
  • delete_at — datetime
  • order_num — int(11)
  • type_name — varchar(255)
  • update_at — datetime
  • updator — varchar(255)
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx — NOT NULL

grade

  • grade_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • admin_idx — bigint(20)
  • create_at — datetime
  • grade_name — varchar(50)
  • grade_score — int(11)
  • image_url — varchar(1000)
  • middle_grade — varchar(255)
  • update_at — datetime
  • updator — varchar(255)
  • menu_num — int(11)
  • middle_name — varchar(255)

group_auth

  • group_auth_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime — NOT NULL
  • delete_yn — bit(1)
  • delete_at — datetime
  • update_at — datetime
  • updator — varchar(255)
  • group_idx — bigint(20) — Foreign key → admin_group.group_idx — NOT NULL
  • crud_idx — bigint(20) — Foreign key → crud_auth.crud_idx — NOT NULL

group_member

  • group_member_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime — NOT NULL
  • member_idx — int(11)
  • update_at — datetime
  • updator — varchar(255)
  • group_idx — bigint(20) — Foreign key → admin_group.group_idx — NOT NULL

inquiry_image

  • image_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime
  • image_url — tinytext
  • one_idx — bigint(20) — Foreign key → one_to_one_inquiry.one_idx — NOT NULL

leave_menu

  • leave_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime
  • leave_cnt — bigint(20)
  • update_at — datetime
  • view_id — varchar(255)
  • view_name — varchar(255)

likes

  • like_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime — NOT NULL
  • delete_at — datetime
  • delete_yn — bit(1)
  • updator — varchar(255)
  • rental_idx — bigint(20) — Foreign key → rental.rental_idx — NOT NULL
  • user_idx — bigint(20) — Foreign key — NOT NULL

member_out_type

  • out_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • type — varchar(255) — NOT NULL
  • update_at — datetime
  • updator — varchar(255)
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx — NOT NULL

menu

  • menu_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime — NOT NULL
  • menu_name — varchar(255)
  • menu_num — int(11)

my_attention

  • attention_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime — NOT NULL
  • delete_at — datetime
  • delete_yn — bit(1)
  • updator — varchar(255)
  • category_idx — bigint(20) — Foreign key → category.category_idx — NOT NULL
  • user_idx — bigint(20) — Foreign key — NOT NULL

notice

  • notice_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • create_at — datetime — NOT NULL
  • delete_at — datetime
  • delete_yn — bit(1)
  • notice_type — varchar(255)
  • title — varchar(255)
  • update_at — datetime
  • updator — varchar(255)
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx — NOT NULL
  • view_type — varchar(255)
  • active_at — datetime
  • content — longtext

one_to_one_inquiry

  • one_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • answer_at — datetime
  • answer_content — longtext
  • content — longtext
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • status — varchar(255)
  • title — varchar(255)
  • update_at — datetime
  • updator — varchar(255)
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx
  • category_idx — bigint(20) — Foreign key → category.category_idx — NOT NULL
  • user_idx — bigint(20) — Foreign key — NOT NULL

one_to_one_type

  • one_type_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • order_num — int(11)
  • type_name — varchar(255)
  • update_at — datetime
  • updator — varchar(255)
  • admin_idx — bigint(20) — Foreign key → admin.admin_idx — NOT NULL

payments_info

  • payments_info_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime — NOT NULL
  • pay_finished_date — datetime
  • pay_request_date — datetime
  • reason — tinytext
  • rental_owner_price — int(11)
  • renter_price — int(11)
  • update_at — datetime
  • updator — varchar(255)
  • transaction_idx — bigint(20) — Foreign key — NOT NULL

rental

  • rental_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • complete_at — datetime
  • content — longtext
  • create_at — datetime — NOT NULL
  • delete_at — datetime
  • delete_yn — bit(1)
  • deposit — int(11) — NOT NULL
  • like_cnt — int(11)
  • pull_up_at — datetime — NOT NULL
  • pull_up_cnt — int(11)
  • rental_price — bigint(20)
  • renter_name — varchar(255)
  • status — int(11)
  • title — varchar(255) — NOT NULL
  • trading_method — int(11)
  • update_at — datetime
  • updator — varchar(255)
  • view_cnt — int(11)
  • user_idx — bigint(20) — Foreign key — NOT NULL
  • lead_town — int(11)
  • town_1 — int(11)
  • town_2 — int(11)
  • town_3 — int(11)
  • town_4 — int(11)
  • owner_name — varchar(255)

rental_category_info

  • rental_category_info_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime — NOT NULL
  • update_at — datetime
  • updator — varchar(255)
  • category_idx — bigint(20) — Foreign key → category.category_idx — NOT NULL
  • rental_idx — bigint(20) — Foreign key → rental.rental_idx — NOT NULL

rental_history

  • history_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • complete_at — datetime
  • content — tinytext
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • deposit — int(11)
  • lead_town — int(11)
  • like_cnt — int(11)
  • memo — tinytext
  • pull_up_at — datetime
  • pull_up_cnt — int(11)
  • rental_price — int(11)
  • renter_name — varchar(255)
  • status — int(11) — NOT NULL
  • title — varchar(255)
  • town_1 — int(11)
  • town_2 — int(11)
  • town_3 — int(11)
  • town_4 — int(11)
  • trading_method — int(11)
  • update_at — datetime
  • updator — varchar(255)
  • user_idx — bigint(20)
  • view_cnt — int(11)
  • rental_idx — bigint(20) — Foreign key → rental.rental_idx — NOT NULL
  • renter — varchar(255)
  • owner_name — varchar(255)
  • owner — varchar(255)

rental_image

  • image_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime — NOT NULL
  • image_url — varchar(1000)
  • update_at — datetime
  • updator — varchar(255)
  • rental_idx — bigint(20) — Foreign key → rental.rental_idx — NOT NULL

rental_town_info

  • rental_town_info_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • create_at — datetime
  • update_at — datetime
  • updator — varchar(255)
  • rental_idx — bigint(20) — Foreign key → rental.rental_idx — NOT NULL
  • town_idx — bigint(20) — Foreign key → town.town_idx — NOT NULL
  • lead_town — bit(1)
  • town_name — varchar(255)

review

  • review_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • owner_idx — bigint(20)
  • renter_idx — bigint(20)
  • review_content — tinytext
  • review_score — decimal(2,1)
  • update_at — datetime
  • updator — varchar(255)
  • transaction_idx — bigint(20) — Foreign key — NOT NULL

review_image

  • image_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime — NOT NULL
  • image_url — varchar(1000)
  • update_at — datetime
  • updator — varchar(255)
  • review_idx — bigint(20) — Foreign key → review.review_idx — NOT NULL
  • chat_idx — bigint(20) — NOT NULL

search_keyword

  • search_idx — bigint(20) — Primary key — NOT NULL
  • create_at — datetime — NOT NULL
  • keyword — varchar(255)
  • user_idx — bigint(20) — Foreign key — NOT NULL

test_town_info

  • test_town_info_idx — bigint(20) — Primary key — NOT NULL
  • active_yn — bit(1)
  • create_at — datetime
  • test_rental_idx — int(11)
  • town_idx — int(11)
  • update_at — datetime
  • updator — varchar(255)

town

  • town_idx — bigint(20) — Primary key — NOT NULL
  • auth_count — int(11)
  • auth_status — bit(1)
  • create_at — datetime
  • delete_at — datetime
  • delete_yn — bit(1)
  • region_latitue — decimal(18,10)
  • region_longitude — decimal(18,10)
  • town_name — varchar(255)
  • update_at — datetime
  • updator — varchar(255)
  • lead_town — bit(1)

transaction_history

  • history_idx — bigint(20) — Primary key — NOT NULL
  • cancel_at — datetime
  • cancel_yn — bit(1)
  • complete_at — datetime
  • coupon_fee — varchar(100)
  • coupon_idx — int(11)
  • create_at — datetime
  • final_pay_fee — varchar(100)
  • mypay_fee — varchar(100)
  • owner_status — int(11)
  • pay_at — datetime
  • pay_method — int(11)
  • rental_idx — bigint(20)
  • renter_status — int(11)
  • return_at — datetime
  • return_yn — bit(1)
  • transaction_idx — bigint(20)
  • update_at — datetime
  • updator — varchar(255)
  • user_idx — bigint(20)
  • status_at — datetime