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