-- Dumping data for table `innodb_table_stats`
--

INSERT  IGNORE INTO `innodb_table_stats` VALUES ('BUYA','abouts','2021-08-11 03:25:44',0,1,0),('BUYA','aboutus','2021-08-11 03:26:35',0,1,0),('BUYA','aboutus_columns','2021-08-11 03:26:48',6,1,0),('BUYA','access_actions','2021-08-11 03:26:40',0,1,0),('BUYA','access_admins','2021-08-11 03:26:40',0,1,0),('BUYA','access_classes','2021-08-11 03:26:42',0,1,0),('BUYA','access_controll_log','2021-08-11 03:26:42',0,1,0),('BUYA','access_door_cardmachines','2021-08-11 03:26:39',0,1,0),('BUYA','access_doors','2021-08-11 03:26:45',0,1,0),('BUYA','access_locations','2021-08-11 03:26:42',0,1,0),('BUYA','access_settings','2021-08-11 03:26:45',0,1,0),('BUYA','access_staff_cards','2021-08-11 03:26:39',0,1,0),('BUYA','access_staff_to_doors','2021-08-11 03:26:39',0,1,0),('BUYA','access_staffs','2021-08-11 03:26:45',0,1,0),('BUYA','accesses','2021-08-11 03:26:43',0,1,0),('BUYA','accts','2021-08-11 03:26:46',0,1,0),('BUYA','acquired_source','2021-08-11 03:26:32',0,1,0),('BUYA','action_api_logs','2021-08-11 03:26:45',0,1,0),('BUYA','action_logs','2021-09-13 02:20:36',7,1,0),('BUYA','activations','2021-09-11 10:57:35',99,1,0),('BUYA','activities','2021-08-11 03:26:35',0,1,0),('BUYA','activities_applies','2021-08-11 03:26:35',0,1,0),('BUYA','air_conditioning_energies','2021-08-11 03:26:45',0,1,0),('BUYA','air_conditioning_error_logs','2021-08-11 03:26:45',0,1,0),('BUYA','album_folders','2021-08-11 03:25:40',0,1,0),('BUYA','album_images','2021-08-11 03:25:39',0,1,0),('BUYA','albums','2021-08-11 03:25:39',0,1,0),('BUYA','app_icon_replace','2021-08-11 03:26:38',0,1,0),('BUYA','applicant','2021-08-11 03:26:38',0,1,4),('BUYA','asset_check_import','2021-08-11 03:26:34',0,1,0),('BUYA','asset_custodian_log','2021-08-11 03:26:35',0,1,1),('BUYA','asset_images','2021-08-11 03:26:32',0,1,1),('BUYA','asset_import','2021-08-11 03:26:34',0,1,0),('BUYA','asset_maintenance_log','2021-08-11 03:26:35',0,1,2),('BUYA','asset_punish','2021-08-11 03:26:32',0,1,0),('BUYA','assets','2021-08-11 03:26:45',0,1,5),('BUYA','authority','2021-08-11 03:26:48',31,1,0),('BUYA','ba_building','2021-08-11 03:26:38',0,1,0),('BUYA','ba_eqLog','2021-08-11 03:26:38',0,1,0),('BUYA','ba_floor','2021-08-11 03:26:38',0,1,0),('BUYA','ba_import','2021-08-11 03:26:33',0,1,0),('BUYA','bike_logs','2021-08-11 03:26:45',0,1,0),('BUYA','bus_logs','2021-08-11 03:26:45',0,1,0),('BUYA','calendar_comprehensives','2021-08-11 03:26:44',0,1,0),('BUYA','calendar_events','2021-08-11 03:26:42',12,1,0),('BUYA','calendars','2021-08-11 03:25:44',3,1,0),('BUYA','camera_classes','2021-08-11 03:26:40',0,1,0),('BUYA','camera_locations','2021-08-11 03:26:39',0,1,0),('BUYA','camera_settings','2021-08-11 03:26:38',0,1,0),('BUYA','cameras','2021-08-11 03:26:38',0,1,0),('BUYA','card_sets','2021-08-11 03:25:40',0,1,0),('BUYA','cards','2021-09-11 10:56:34',428,3,1),('BUYA','category','2021-08-11 03:26:46',0,1,2),('BUYA','central_weather_logs','2021-08-11 03:26:44',0,1,0),('BUYA','central_weather_settings','2021-08-11 03:27:55',2,1,0),('BUYA','charge_equipments','2021-08-11 03:26:43',0,1,0),('BUYA','charge_logs','2021-08-11 03:26:43',0,1,0),('BUYA','charge_orders','2021-08-11 03:26:43',0,1,0),('BUYA','charge_times','2021-08-11 03:26:43',0,1,0),('BUYA','charges','2021-08-11 03:26:43',0,1,0),('BUYA','chicony_park_log','2021-08-11 03:26:44',0,1,0),('BUYA','chicony_settings','2021-08-11 03:27:45',15,1,0),('BUYA','communities','2021-08-11 03:26:40',1,1,0),('BUYA','community_images','2021-08-11 03:26:48',6,1,0),('BUYA','community_settings','2021-08-11 03:26:39',0,1,0),('BUYA','convinients','2021-08-11 03:26:34',10,1,0),('BUYA','costs','2021-08-11 03:26:45',0,1,0),('BUYA','cron_tabs','2021-08-11 03:26:39',0,1,0),('BUYA','data_bas','2021-08-11 03:25:40',0,1,0),('BUYA','data_weemas','2021-08-11 03:25:40',0,1,0),('BUYA','departments','2021-08-11 03:26:39',0,1,1),('BUYA','device_config','2021-08-11 03:26:37',0,1,0),('BUYA','device_contrasts','2021-08-11 03:26:45',0,1,0),('BUYA','device_event','2021-08-11 03:26:37',0,1,0),('BUYA','device_format','2021-08-11 03:26:37',0,1,0),('BUYA','device_items','2021-08-11 03:26:37',0,1,0),('BUYA','device_location','2021-08-11 03:26:37',0,1,0),('BUYA','device_log','2021-08-11 03:26:37',0,1,0),('BUYA','device_off_log','2021-08-11 03:26:37',0,1,0),('BUYA','device_records','2021-08-11 03:26:43',0,1,0),('BUYA','device_route','2021-08-11 03:26:37',0,1,0),('BUYA','disposal_item','2021-08-11 03:26:36',0,1,0),('BUYA','document_files','2021-08-11 03:25:40',0,1,0),('BUYA','document_folders','2021-08-11 03:25:40',0,1,0),('BUYA','documents','2021-08-11 03:25:40',0,1,0),('BUYA','doorplates','2021-09-11 10:50:26',87,1,0),('BUYA','dorm_bed_logs','2021-08-11 03:26:45',0,1,0),('BUYA','dorm_bed_settings','2021-08-11 03:26:45',0,1,0),('BUYA','dorm_btu_mappings','2021-08-11 03:26:45',0,1,0),('BUYA','dorm_ele_mappings','2021-08-11 03:26:45',0,1,0),('BUYA','dorm_ele_prices','2021-08-11 03:26:45',0,1,0),('BUYA','dorm_tenants','2021-08-11 03:26:45',0,1,0),('BUYA','dorm_water_mappings','2021-08-11 03:26:45',0,1,0),('BUYA','dormitory_electricities','2021-08-11 03:26:45',0,1,0),('BUYA','e_tags','2021-08-11 03:26:43',0,1,0),('BUYA','ehr_location','2021-08-11 03:26:35',0,1,0),('BUYA','ehr_log','2021-08-11 03:26:35',0,1,0),('BUYA','ehr_schedule','2021-08-11 03:26:35',0,1,0),('BUYA','ehr_shift','2021-08-11 03:26:35',0,1,0),('BUYA','electric_fees','2021-08-11 03:26:43',0,1,0),('BUYA','electric_mails','2021-08-11 03:26:43',0,1,0),('BUYA','electric_xls_imports','2021-08-11 03:26:42',0,1,0),('BUYA','electricity','2021-08-11 03:27:18',144,1,0),('BUYA','electricity_energies','2021-08-11 03:26:45',0,1,0),('BUYA','electricity_prices','2021-08-11 03:26:40',0,1,0),('BUYA','electro_mechanical_checklist','2021-08-11 03:26:38',0,1,0),('BUYA','electro_mechanical_checklist_fixlist','2021-08-11 03:26:37',0,1,0),('BUYA','electro_mechanical_checklist_report_data','2021-08-11 03:26:37',0,1,0),('BUYA','electro_mechanical_checklist_report_list','2021-08-11 03:26:37',0,1,0),('BUYA','electro_mechanical_detail','2021-08-11 03:26:37',0,1,0),('BUYA','electro_mechanical_import','2021-08-11 03:26:36',0,1,0),('BUYA','electro_mechanical_patrol','2021-08-11 03:26:43',0,1,0),('BUYA','email_receivers','2021-08-11 03:26:35',0,1,0),('BUYA','emails','2021-08-11 03:26:35',0,1,0),('BUYA','energies','2021-08-11 03:26:42',0,1,0),('BUYA','energy_categories','2021-08-11 03:26:45',0,1,0),('BUYA','energy_details','2021-08-11 03:26:45',0,1,0),('BUYA','energy_imports','2021-08-11 03:26:44',0,1,0),('BUYA','energy_locations','2021-08-11 03:26:44',0,1,0),('BUYA','energy_logs','2021-08-11 03:26:43',0,1,0),('BUYA','energy_records','2021-08-11 03:26:42',0,1,0),('BUYA','energy_sensors','2021-08-11 03:26:45',0,1,0),('BUYA','energy_settings','2021-08-11 03:26:44',0,1,0),('BUYA','error_energies','2021-08-11 03:26:46',0,1,0),('BUYA','expenses','2021-08-11 03:26:45',0,1,0),('BUYA','factories','2021-08-11 03:26:39',0,1,0),('BUYA','fault_dispatches','2021-08-11 03:26:44',0,1,0),('BUYA','fault_handle_outsides','2021-08-11 03:26:44',0,1,0),('BUYA','fault_handles','2021-08-11 03:26:44',0,1,0),('BUYA','fault_report_lists','2021-08-11 03:26:37',0,1,0),('BUYA','fault_report_outlists','2021-08-11 03:26:37',0,1,0),('BUYA','fault_report_outsides','2021-08-11 03:26:44',0,1,0),('BUYA','fault_reports','2021-08-11 03:26:44',0,1,0),('BUYA','festivals','2021-08-11 03:26:34',0,1,0),('BUYA','files','2021-08-11 03:25:39',0,1,0),('BUYA','fire_control_cctvs','2021-08-11 03:26:42',0,1,0),('BUYA','fire_control_imports','2021-08-11 03:26:42',0,1,0),('BUYA','fire_control_phones','2021-08-11 03:26:42',0,1,0),('BUYA','fire_control_subtitles','2021-08-11 03:26:42',0,1,0),('BUYA','fire_control_voices','2021-08-11 03:26:42',0,1,0),('BUYA','firms','2021-08-11 03:26:44',0,1,1),('BUYA','forum_classes','2021-08-11 03:26:19',4,1,0),('BUYA','forum_contents','2021-08-11 03:26:42',0,1,0),('BUYA','forum_lists','2021-08-11 03:26:42',0,1,0),('BUYA','forums','2021-08-11 03:25:39',0,1,0),('BUYA','general_category','2021-08-11 03:26:46',0,1,0),('BUYA','guest_pawns','2021-08-11 03:25:44',3,1,0),('BUYA','guests','2021-08-11 03:26:43',0,1,0),('BUYA','health_classes','2021-08-11 03:26:43',0,1,0),('BUYA','health_devices','2021-08-11 03:26:43',0,1,0),('BUYA','health_locations','2021-08-11 03:26:43',0,1,0),('BUYA','health_logs','2021-08-11 03:26:45',0,1,0),('BUYA','health_records','2021-08-11 03:26:43',0,1,0),('BUYA','healths','2021-08-11 03:25:40',0,1,0),('BUYA','home_service_items','2021-08-11 03:25:40',0,1,0),('BUYA','home_services','2021-08-11 03:25:39',0,1,0),('BUYA','home_services_handles','2021-08-11 03:26:38',0,1,0),('BUYA','hosts','2021-08-11 03:26:40',0,1,0),('BUYA','hosts_classes','2021-08-11 03:26:40',0,1,0),('BUYA','hosts_locations','2021-08-11 03:26:40',0,1,0),('BUYA','hosts_logs','2021-08-11 03:26:40',0,1,0),('BUYA','hot_pump_energies','2021-08-11 03:26:45',0,1,0),('BUYA','hotpump_facilities','2021-08-11 03:26:45',0,1,0),('BUYA','images','2021-08-11 03:25:40',0,1,0),('BUYA','import_settings','2021-08-11 03:25:40',0,1,0),('BUYA','imports','2021-08-11 03:25:39',0,1,0),('BUYA','inouts','2021-08-11 03:26:35',0,1,1),('BUYA','inst_equipment_orders','2021-08-11 03:26:35',0,1,0),('BUYA','inst_equipments','2021-08-11 03:26:35',0,1,0),('BUYA','inst_order_timings','2021-08-11 03:26:36',0,1,0),('BUYA','inst_orders','2021-08-11 03:26:39',0,1,0),('BUYA','inst_timings','2021-08-11 03:26:35',0,1,0),('BUYA','insts','2021-08-11 03:26:38',0,1,0),('BUYA','intercom','2021-08-11 03:26:36',0,1,0),('BUYA','intercom_classes','2021-08-11 03:26:40',0,1,0),('BUYA','intercom_house','2021-08-11 03:26:40',0,1,0),('BUYA','intercom_import','2021-08-11 03:26:36',0,1,0),('BUYA','intercom_locations','2021-08-11 03:26:40',0,1,0),('BUYA','intercom_log','2021-08-11 03:26:40',0,1,0),('BUYA','jobs','2021-09-13 05:02:08',0,1,1),('BUYA','keeper_lockers','2021-08-11 03:25:44',6,1,0),('BUYA','keepers','2021-08-11 03:26:43',0,1,0),('BUYA','lang','2021-08-11 03:26:48',2,1,0),('BUYA','lang_import','2021-08-11 03:26:34',0,1,0),('BUYA','library_borrowed_logs','2021-08-11 03:26:38',0,1,0),('BUYA','library_classes','2021-08-11 03:26:38',0,1,0),('BUYA','library_presses','2021-08-11 03:26:38',0,1,0),('BUYA','library_punish_reports','2021-08-11 03:26:38',0,1,0),('BUYA','library_punishs','2021-08-11 03:26:38',0,1,0),('BUYA','library_settings','2021-08-11 03:26:38',0,1,0),('BUYA','library_users','2021-08-11 03:26:38',0,1,0),('BUYA','librarys','2021-08-11 03:26:38',0,1,0),('BUYA','links','2021-08-11 03:25:40',0,1,0),('BUYA','location','2021-08-11 03:26:38',0,1,0),('BUYA','login_logs','2021-09-13 02:20:36',7,1,0),('BUYA','lost_things','2021-08-11 03:26:42',0,1,0),('BUYA','lost_things_handle','2021-08-11 03:26:38',0,1,0),('BUYA','mail_sources','2021-08-11 03:25:44',10,1,0),('BUYA','mail_types','2021-08-11 03:25:44',5,1,0),('BUYA','mails','2021-08-11 03:26:37',0,1,0),('BUYA','matter_handles','2021-08-11 03:26:35',0,1,0),('BUYA','matter_reports','2021-08-11 03:26:35',0,1,0),('BUYA','meal_bloods','2021-08-11 03:26:38',0,1,0),('BUYA','meal_carts','2021-08-11 03:26:39',0,1,0),('BUYA','meal_classes','2021-08-11 03:25:40',0,1,0),('BUYA','meal_food_logs','2021-08-11 03:26:38',0,1,0),('BUYA','meal_foods','2021-08-11 03:26:38',0,1,0),('BUYA','meal_items','2021-08-11 03:26:43',0,1,0),('BUYA','meal_order_details','2021-08-11 03:26:44',0,1,0),('BUYA','meal_orders','2021-08-11 03:26:42',0,1,0),('BUYA','meal_seats','2021-08-11 03:26:38',0,1,0),('BUYA','meetings','2021-08-11 03:25:40',0,1,0),('BUYA','message_sets','2021-08-11 03:26:34',0,1,0),('BUYA','messages','2021-08-11 03:25:39',0,1,0),('BUYA','migrations','2021-08-11 03:26:58',675,5,0),('BUYA','monitor','2021-08-11 03:26:40',0,1,0),('BUYA','monitor_icons','2021-08-11 03:26:40',0,1,0),('BUYA','monthly_statuses','2021-08-11 03:26:46',0,1,0),('BUYA','mooncard','2021-08-11 03:26:36',0,1,0),('BUYA','mooncard_log','2021-08-11 03:26:36',0,1,0),('BUYA','mooncard_user','2021-08-11 03:26:36',0,1,0),('BUYA','mqtt_ba_alarm','2021-08-11 03:26:38',0,1,0),('BUYA','mqtt_ba_log','2021-08-11 03:26:38',0,1,0),('BUYA','museum_sales','2021-08-11 03:26:36',0,1,0),('BUYA','news','2021-08-11 03:26:38',1,1,0),('BUYA','news_columns','2021-08-11 03:25:44',6,1,0),('BUYA','news_logs','2021-08-11 03:26:36',0,1,0),('BUYA','news_types','2021-08-11 03:25:44',4,1,0),('BUYA','notices','2021-08-11 03:25:39',0,1,0),('BUYA','orchestra_options','2021-08-11 03:25:39',0,1,0),('BUYA','other_fees','2021-08-11 03:26:40',0,1,0),('BUYA','parking_garages','2021-08-11 03:26:43',0,1,0),('BUYA','parking_import','2021-08-11 03:26:42',0,1,0),('BUYA','parking_logs','2021-08-11 03:26:45',0,1,0),('BUYA','parking_temporaries','2021-08-11 03:26:43',0,1,0),('BUYA','password_resets','2021-08-11 03:25:39',0,1,0),('BUYA','patrol_config','2021-08-11 03:26:34',0,1,0),('BUYA','patrol_event','2021-08-11 03:26:34',0,1,0),('BUYA','patrol_format','2021-08-11 03:26:34',0,1,0),('BUYA','patrol_items','2021-08-11 03:26:34',0,1,0),('BUYA','patrol_location','2021-08-11 03:26:34',0,1,0),('BUYA','patrol_log','2021-08-11 03:26:35',0,1,3),('BUYA','patrol_off_log','2021-08-11 03:26:35',0,1,1),('BUYA','patrol_route','2021-08-11 03:26:35',0,1,0),('BUYA','pay_to_points','2021-08-11 03:26:45',0,1,0),('BUYA','payable_expenses','2021-08-11 03:26:45',0,1,0),('BUYA','payment_btu_facilities','2021-08-11 03:26:41',0,1,0),('BUYA','payment_datas','2021-08-11 03:26:40',0,1,0),('BUYA','payment_facilities','2021-08-11 03:26:43',0,1,0),('BUYA','payment_imports','2021-08-11 03:26:42',0,1,0),('BUYA','payment_logs','2021-08-11 03:26:40',0,1,0),('BUYA','payment_notices','2021-08-11 03:26:42',0,1,0),('BUYA','payment_parking_fees','2021-08-11 03:26:41',0,1,0),('BUYA','payment_peak_days','2021-08-11 03:26:40',0,1,0),('BUYA','payment_tenant_settings','2021-08-11 03:26:42',0,1,0),('BUYA','payment_tenants','2021-08-11 03:26:43',0,1,0),('BUYA','pccs_buildings','2021-08-11 03:26:39',0,1,0),('BUYA','pccs_floors','2021-08-11 03:26:39',0,1,0),('BUYA','pccs_graphs','2021-08-11 03:26:39',0,1,0),('BUYA','permissions','2021-08-11 03:26:44',0,1,0),('BUYA','persistences','2021-09-13 02:20:36',4,1,1),('BUYA','phone_lists','2021-08-11 03:26:42',0,1,0),('BUYA','picklist','2021-08-11 03:26:38',0,1,2),('BUYA','picklist_item','2021-08-11 03:26:33',0,1,2),('BUYA','planting_holidays','2021-08-11 03:26:44',0,1,0),('BUYA','planting_infos','2021-08-11 03:26:43',0,1,0),('BUYA','planting_logs','2021-08-11 03:26:43',0,1,0),('BUYA','planting_orders','2021-08-11 03:26:43',0,1,0),('BUYA','plantings','2021-08-11 03:26:44',0,1,0),('BUYA','point_allgives','2021-08-11 03:25:40',0,1,0),('BUYA','point_costs','2021-08-11 03:25:40',0,1,0),('BUYA','point_incomes','2021-08-11 03:25:40',0,1,0),('BUYA','point_settings','2021-08-11 03:26:45',1,1,0),('BUYA','purchase','2021-08-11 03:26:44',0,1,2),('BUYA','purchase_item','2021-08-11 03:26:44',0,1,2),('BUYA','purifying_config','2021-08-11 03:26:37',0,1,0),('BUYA','purifying_event','2021-08-11 03:26:37',0,1,0),('BUYA','purifying_format','2021-08-11 03:26:37',0,1,0),('BUYA','purifying_items','2021-08-11 03:26:37',0,1,0),('BUYA','purifying_location','2021-08-11 03:26:37',0,1,0),('BUYA','purifying_log','2021-08-11 03:26:37',0,1,0),('BUYA','purifying_off_log','2021-08-11 03:26:37',0,1,0),('BUYA','purifying_route','2021-08-11 03:26:37',0,1,0),('BUYA','push_log_manages','2021-08-11 03:26:36',0,1,0),('BUYA','push_logs','2021-08-11 03:25:40',0,1,0),('BUYA','push_manages','2021-08-11 03:26:36',0,1,0),('BUYA','push_tip_manages','2021-08-11 03:26:36',0,1,0),('BUYA','push_tips','2021-08-11 03:26:36',0,1,0),('BUYA','pushes','2021-08-11 03:26:38',0,1,0),('BUYA','questionnaires','2021-08-11 03:27:08',10,1,0),('BUYA','questionnaires_fault_outsides','2021-08-11 03:26:39',0,1,0),('BUYA','questionnaires_faults','2021-08-11 03:26:39',0,1,0),('BUYA','recognition_logs','2021-08-11 03:26:44',0,1,0),('BUYA','recognition_setting_logs','2021-08-11 03:26:44',0,1,0),('BUYA','record_lists','2021-08-11 03:25:40',0,1,0),('BUYA','records','2021-08-11 03:25:40',0,1,0),('BUYA','recruits','2021-08-11 03:25:40',0,1,0),('BUYA','reminders','2021-08-11 03:25:39',0,1,0),('BUYA','rentsales','2021-08-11 03:26:34',0,1,0),('BUYA','repair_lists','2021-08-11 03:26:36',0,1,0),('BUYA','repair_outlists','2021-08-11 03:26:36',0,1,0),('BUYA','repair_settings','2021-08-11 03:26:48',3,1,0),('BUYA','repairs','2021-08-11 03:26:38',0,1,0),('BUYA','role_users','2021-09-11 10:57:35',99,1,0),('BUYA','roles','2021-08-11 03:25:44',2,1,1),('BUYA','room_temperatures','2021-08-11 03:26:43',0,1,0),('BUYA','sales','2021-08-11 03:26:34',0,1,0),('BUYA','secondhands','2021-08-11 03:26:34',0,1,0),('BUYA','sensor_api_config','2021-08-11 03:26:33',0,1,0),('BUYA','sensor_category','2021-08-11 03:27:25',7,1,0),('BUYA','sensor_faults','2021-08-11 03:26:43',0,1,0),('BUYA','sensor_para_config','2021-08-11 03:26:33',0,1,0),('BUYA','sensor_records','2021-08-11 03:26:33',0,1,0),('BUYA','sensor_runtimes','2021-08-11 03:26:45',0,1,0),('BUYA','sensors','2021-08-11 03:26:45',0,1,4),('BUYA','setting_columns','2021-08-11 03:26:44',0,1,0),('BUYA','setting_tables','2021-08-11 03:26:44',0,1,0),('BUYA','settings','2021-08-11 03:27:35',123,1,1),('BUYA','sms_logs','2021-08-11 03:25:40',0,1,0),('BUYA','solar_energies','2021-08-11 03:26:43',0,1,0),('BUYA','spaces','2021-08-11 03:26:44',0,1,0),('BUYA','spots','2021-08-11 03:26:34',0,1,0),('BUYA','storage_import','2021-08-11 03:26:35',0,1,0),('BUYA','storage_place','2021-08-11 03:26:43',0,1,0),('BUYA','storage_substitute','2021-08-11 03:26:33',0,1,1),('BUYA','storage_unit','2021-08-11 03:26:32',0,1,0),('BUYA','storages','2021-08-11 03:26:35',0,1,1),('BUYA','stores','2021-08-11 03:26:34',0,1,0),('BUYA','subtitle_logs','2021-08-11 03:26:39',0,1,0),('BUYA','subtitles','2021-08-11 03:26:39',0,1,0),('BUYA','summarys','2021-08-11 03:26:44',0,1,0),('BUYA','summons','2021-08-11 03:26:45',0,1,0),('BUYA','tags','2021-08-11 03:26:48',46,1,0),('BUYA','theme_spots','2021-08-11 03:26:34',0,1,0),('BUYA','throttle','2021-08-11 03:25:39',0,1,0),('BUYA','tickets','2021-08-11 03:26:36',0,1,0),('BUYA','tours','2021-08-11 03:26:34',0,1,0),('BUYA','transfer_log','2021-08-11 03:26:44',0,1,0),('BUYA','unrecognized','2021-08-11 03:26:45',0,1,0),('BUYA','user_atts','2021-08-11 03:25:40',0,1,0),('BUYA','user_authority','2021-08-11 03:26:33',0,1,0),('BUYA','user_facility_mappings','2021-08-11 03:26:40',0,1,0),('BUYA','user_licenses','2021-08-11 03:26:37',0,1,0),('BUYA','user_options','2021-08-11 03:26:37',0,1,0),('BUYA','user_water_facility_mappings','2021-08-11 03:26:42',0,1,0),('BUYA','users','2021-09-11 10:57:35',99,3,2),('BUYA','voice_codes','2021-08-11 03:26:42',0,1,0),('BUYA','vote_comments','2021-08-11 03:25:39',0,1,0),('BUYA','vote_lists','2021-08-11 03:25:40',0,1,0),('BUYA','vote_options','2021-08-11 03:25:39',0,1,0),('BUYA','votes','2021-08-11 03:26:44',0,1,0),('BUYA','water_degrees','2021-08-11 03:26:41',0,1,0),('BUYA','water_energies','2021-08-11 03:26:45',0,1,0),('BUYA','water_facilities','2021-08-11 03:26:41',0,1,0),('BUYA','water_fees','2021-08-11 03:26:40',0,1,0),('BUYA','water_logs','2021-08-11 03:26:45',0,1,0),('BUYA','water_meters','2021-08-11 03:26:43',0,1,0),('BUYA','water_records','2021-08-11 03:26:42',0,1,0),('BUYA','water_taishui_mappings','2021-08-11 03:26:42',0,1,0),('BUYA','weather__station_classes','2021-08-11 03:26:39',0,1,0),('BUYA','weather__station_locations','2021-08-11 03:26:39',0,1,0),('BUYA','weather__station_logs','2021-08-11 03:26:39',0,1,0),('BUYA','weather__stations','2021-08-11 03:26:39',0,1,0),('BUYA','weathers','2021-08-11 03:26:40',0,1,0),('BUYA','wenlin_columns','2021-08-11 03:26:35',0,1,0),('BUYA','wenlins','2021-08-11 03:26:35',0,1,0),('BUYA','working_logs','2021-08-11 03:26:45',0,1,0),('mysql','component','2021-08-11 02:27:55',0,1,0),('phpmyadmin','pma__bookmark','2021-08-11 02:31:17',0,1,0),('phpmyadmin','pma__central_columns','2021-08-11 02:31:17',0,1,0),('phpmyadmin','pma__column_info','2021-08-11 02:31:17',0,1,1),('phpmyadmin','pma__designer_settings','2021-08-11 02:31:17',0,1,0),('phpmyadmin','pma__export_templates','2021-08-11 02:31:17',0,1,1),('phpmyadmin','pma__favorite','2021-08-11 02:31:17',0,1,0),('phpmyadmin','pma__history','2021-08-11 02:31:17',0,1,1),('phpmyadmin','pma__navigationhiding','2021-08-11 02:31:17',0,1,0),('phpmyadmin','pma__pdf_pages','2021-08-11 02:31:17',0,1,1),('phpmyadmin','pma__recent','2021-08-11 02:31:17',0,1,0),('phpmyadmin','pma__relation','2021-08-11 02:31:17',0,1,1),('phpmyadmin','pma__savedsearches','2021-08-11 02:31:17',0,1,1),('phpmyadmin','pma__table_coords','2021-08-11 02:31:17',0,1,0),('phpmyadmin','pma__table_info','2021-08-11 02:31:17',0,1,0),('phpmyadmin','pma__table_uiprefs','2021-08-11 02:31:17',0,1,0),('phpmyadmin','pma__tracking','2021-08-11 02:31:17',0,1,0),('phpmyadmin','pma__userconfig','2021-08-11 02:31:17',0,1,0),('phpmyadmin','pma__usergroups','2021-08-11 02:31:17',0,1,0),('phpmyadmin','pma__users','2021-08-11 02:31:17',0,1,0),('sys','sys_config','2021-08-11 02:27:55',2,1,0);

--
-- Table structure for table `password_history`
--

CREATE TABLE `password_history` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Password_timestamp` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `Password` text COLLATE utf8_bin,
  PRIMARY KEY (`Host`,`User`,`Password_timestamp` DESC)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Password history for user accounts';

--
-- Dumping data for table `password_history`
--


--
-- Table structure for table `plugin`
--

CREATE TABLE `plugin` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `dl` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='MySQL plugins';

--
-- Dumping data for table `plugin`
--

INSERT INTO `plugin` VALUES ('auth_socket','auth_socket.so');

--
-- Table structure for table `procs_priv`
--

CREATE TABLE `procs_priv` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Routine_name` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `Routine_type` enum('FUNCTION','PROCEDURE') COLLATE utf8_bin NOT NULL,
  `Grantor` varchar(288) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proc_priv` set('Execute','Alter Routine','Grant') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`Db`,`User`,`Routine_name`,`Routine_type`),
  KEY `Grantor` (`Grantor`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Procedure privileges';

--
-- Dumping data for table `procs_priv`
--


--
-- Table structure for table `proxies_priv`
--

CREATE TABLE `proxies_priv` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Proxied_host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Proxied_user` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `With_grant` tinyint(1) NOT NULL DEFAULT '0',
  `Grantor` varchar(288) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`Host`,`User`,`Proxied_host`,`Proxied_user`),
  KEY `Grantor` (`Grantor`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='User proxy privileges';

--
-- Dumping data for table `proxies_priv`
--

INSERT INTO `proxies_priv` VALUES ('localhost','root','','',1,'boot@','0000-00-00 00:00:00');

--
-- Table structure for table `replication_asynchronous_connection_failover`
--

CREATE TABLE `replication_asynchronous_connection_failover` (
  `Channel_name` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'The replication channel name that connects source and replica.',
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The source hostname that the replica will attempt to switch over the replication connection to in case of a failure.',
  `Port` int unsigned NOT NULL COMMENT 'The source port that the replica will attempt to switch over the replication connection to in case of a failure.',
  `Network_namespace` char(64) NOT NULL COMMENT 'The source network namespace that the replica will attempt to switch over the replication connection to in case of a failure. If its value is empty, connections use the default (global) namespace.',
  `Weight` tinyint unsigned NOT NULL COMMENT 'The order in which the replica shall try to switch the connection over to when there are failures. Weight can be set to a number between 1 and 100, where 100 is the highest weight and 1 the lowest.',
  `Managed_name` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'The name of the group which this server belongs to.',
  PRIMARY KEY (`Channel_name`,`Host`,`Port`,`Network_namespace`,`Managed_name`),
  KEY `Channel_name` (`Channel_name`,`Managed_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='The source configuration details';

--
-- Dumping data for table `replication_asynchronous_connection_failover`
--


--
-- Table structure for table `replication_asynchronous_connection_failover_managed`
--

CREATE TABLE `replication_asynchronous_connection_failover_managed` (
  `Channel_name` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'The replication channel name that connects source and replica.',
  `Managed_name` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'The name of the source which needs to be managed.',
  `Managed_type` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'Determines the managed type.',
  `Configuration` json DEFAULT NULL COMMENT 'The data to help manage group. For Managed_type = GroupReplication, Configuration value should contain {"Primary_weight": 80, "Secondary_weight": 60}, so that it assigns weight=80 to PRIMARY of the group, and weight=60 for rest of the members in mysql.replication_asynchronous_connection_failover table.',
  PRIMARY KEY (`Channel_name`,`Managed_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='The managed source configuration details';

--
-- Dumping data for table `replication_asynchronous_connection_failover_managed`
--


--
-- Table structure for table `replication_group_configuration_version`
--

CREATE TABLE `replication_group_configuration_version` (
  `name` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The configuration name.',
  `version` bigint unsigned NOT NULL COMMENT 'The version of the configuration name.',
  PRIMARY KEY (`name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='The group configuration version.';

--
-- Dumping data for table `replication_group_configuration_version`
--

INSERT INTO `replication_group_configuration_version` VALUES ('replication_group_member_actions',1);

--
-- Table structure for table `replication_group_member_actions`
--

CREATE TABLE `replication_group_member_actions` (
  `name` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The action name.',
  `event` char(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The event that will trigger the action.',
  `enabled` tinyint(1) NOT NULL COMMENT 'Whether the action is enabled.',
  `type` char(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'The action type.',
  `priority` tinyint unsigned NOT NULL COMMENT 'The order on which the action will be run, value between 1 and 100, lower values first.',
  `error_handling` char(64) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL COMMENT 'On errors during the action will be handled: IGNORE, CRITICAL.',
  PRIMARY KEY (`name`,`event`),
  KEY `event` (`event`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='The member actions configuration.';

--
-- Dumping data for table `replication_group_member_actions`
--

INSERT INTO `replication_group_member_actions` VALUES ('mysql_disable_super_read_only_if_primary','AFTER_PRIMARY_ELECTION',1,'INTERNAL',1,'IGNORE');

--
-- Table structure for table `role_edges`
--

CREATE TABLE `role_edges` (
  `FROM_HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `FROM_USER` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `TO_HOST` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `TO_USER` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `WITH_ADMIN_OPTION` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`FROM_HOST`,`FROM_USER`,`TO_HOST`,`TO_USER`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Role hierarchy and role grants';

--
-- Dumping data for table `role_edges`
--


--
-- Table structure for table `server_cost`
--

CREATE TABLE `server_cost` (
  `cost_name` varchar(64) NOT NULL,
  `cost_value` float DEFAULT NULL,
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `comment` varchar(1024) DEFAULT NULL,
  `default_value` float GENERATED ALWAYS AS ((case `cost_name` when _utf8mb3'disk_temptable_create_cost' then 20.0 when _utf8mb3'disk_temptable_row_cost' then 0.5 when _utf8mb3'key_compare_cost' then 0.05 when _utf8mb3'memory_temptable_create_cost' then 1.0 when _utf8mb3'memory_temptable_row_cost' then 0.1 when _utf8mb3'row_evaluate_cost' then 0.1 else NULL end)) VIRTUAL,
  PRIMARY KEY (`cost_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `server_cost`
--

INSERT INTO `server_cost` (`cost_name`, `cost_value`, `last_update`, `comment`) VALUES ('disk_temptable_create_cost',NULL,'2021-08-11 02:27:55',NULL),('disk_temptable_row_cost',NULL,'2021-08-11 02:27:55',NULL),('key_compare_cost',NULL,'2021-08-11 02:27:55',NULL),('memory_temptable_create_cost',NULL,'2021-08-11 02:27:55',NULL),('memory_temptable_row_cost',NULL,'2021-08-11 02:27:55',NULL),('row_evaluate_cost',NULL,'2021-08-11 02:27:55',NULL);

--
-- Table structure for table `servers`
--

CREATE TABLE `servers` (
  `Server_name` char(64) NOT NULL DEFAULT '',
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Db` char(64) NOT NULL DEFAULT '',
  `Username` char(64) NOT NULL DEFAULT '',
  `Password` char(64) NOT NULL DEFAULT '',
  `Port` int NOT NULL DEFAULT '0',
  `Socket` char(64) NOT NULL DEFAULT '',
  `Wrapper` char(64) NOT NULL DEFAULT '',
  `Owner` char(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`Server_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='MySQL Foreign Servers table';

--
-- Dumping data for table `servers`
--


--
-- Table structure for table `slave_master_info`
--

CREATE TABLE IF NOT EXISTS `slave_master_info` (
  `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file.',
  `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',
  `Master_log_pos` bigint unsigned NOT NULL COMMENT 'The master log position of the last read event.',
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'The host name of the master.',
  `User_name` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The user name used to connect to the master.',
  `User_password` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The password used to connect to the master.',
  `Port` int unsigned NOT NULL COMMENT 'The network port used to connect to the master.',
  `Connect_retry` int unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
  `Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',
  `Ssl_ca` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',
  `Ssl_capath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',
  `Ssl_cert` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL certificate file.',
  `Ssl_cipher` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the cipher in use for the SSL connection.',
  `Ssl_key` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL key file.',
  `Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',
  `Heartbeat` float NOT NULL,
  `Bind` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',
  `Ignored_server_ids` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',
  `Uuid` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The master server uuid.',
  `Retry_count` bigint unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',
  `Ssl_crl` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',
  `Ssl_crlpath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',
  `Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',
  `Channel_name` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'The channel on which the slave is connected to a source. Used in Multisource Replication',
  `Tls_version` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Tls version',
  `Public_key_path` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file containing public key of master server.',
  `Get_public_key` tinyint(1) NOT NULL COMMENT 'Preference to get public key from master.',
  `Network_namespace` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Network namespace used for communication with the master server.',
  `Master_compression_algorithm` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'Compression algorithm supported for data transfer between master and slave.',
  `Master_zstd_compression_level` int unsigned NOT NULL COMMENT 'Compression level associated with zstd compression algorithm.',
  `Tls_ciphersuites` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Ciphersuites used for TLS 1.3 communication with the master server.',
  `Source_connection_auto_failover` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates whether the channel connection failover is enabled.',
  PRIMARY KEY (`Channel_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Master Information';

--
-- Table structure for table `slave_relay_log_info`
--

CREATE TABLE IF NOT EXISTS `slave_relay_log_info` (
  `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
  `Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the current relay log file.',
  `Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.',
  `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
  `Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.',
  `Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
  `Number_of_workers` int unsigned DEFAULT NULL,
  `Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.',
  `Channel_name` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'The channel on which the slave is connected to a source. Used in Multisource Replication',
  `Privilege_checks_username` char(32) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.',
  `Privilege_checks_hostname` char(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.',
  `Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.',
  `Require_table_primary_key_check` enum('STREAM','ON','OFF') NOT NULL DEFAULT 'STREAM' COMMENT 'Indicates what is the channel policy regarding tables having primary keys on create and alter table queries',
  `Assign_gtids_to_anonymous_transactions_type` enum('OFF','LOCAL','UUID') NOT NULL DEFAULT 'OFF' COMMENT 'Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value',
  `Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions',
  PRIMARY KEY (`Channel_name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information';

--
-- Table structure for table `slave_worker_info`
--

CREATE TABLE `slave_worker_info` (
  `Id` int unsigned NOT NULL,
  `Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Relay_log_pos` bigint unsigned NOT NULL,
  `Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Master_log_pos` bigint unsigned NOT NULL,
  `Checkpoint_relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Checkpoint_relay_log_pos` bigint unsigned NOT NULL,
  `Checkpoint_master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `Checkpoint_master_log_pos` bigint unsigned NOT NULL,
  `Checkpoint_seqno` int unsigned NOT NULL,
  `Checkpoint_group_size` int unsigned NOT NULL,
  `Checkpoint_group_bitmap` blob NOT NULL,
  `Channel_name` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'The channel on which the slave is connected to a source. Used in Multisource Replication',
  PRIMARY KEY (`Channel_name`,`Id`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Worker Information';

--
-- Dumping data for table `slave_worker_info`
--


--
-- Table structure for table `tables_priv`
--

CREATE TABLE `tables_priv` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `Db` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Table_name` char(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Grantor` varchar(288) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `Table_priv` set('Select','Insert','Update','Delete','Create','Drop','Grant','References','Index','Alter','Create View','Show view','Trigger') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `Column_priv` set('Select','Insert','Update','References') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`Host`,`Db`,`User`,`Table_name`),
  KEY `Grantor` (`Grantor`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Table privileges';

--
-- Dumping data for table `tables_priv`
--

INSERT INTO `tables_priv` VALUES ('localhost','mysql','mysql.session','user','boot@','0000-00-00 00:00:00','Select',''),('localhost','sys','mysql.sys','sys_config','root@localhost','2021-08-11 02:27:55','Select','');

--
-- Table structure for table `time_zone`
--

CREATE TABLE `time_zone` (
  `Time_zone_id` int unsigned NOT NULL AUTO_INCREMENT,
  `Use_leap_seconds` enum('Y','N') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  PRIMARY KEY (`Time_zone_id`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Time zones';

--
-- Dumping data for table `time_zone`
--


--
-- Table structure for table `time_zone_leap_second`
--

CREATE TABLE `time_zone_leap_second` (
  `Transition_time` bigint NOT NULL,
  `Correction` int NOT NULL,
  PRIMARY KEY (`Transition_time`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Leap seconds information for time zones';

--
-- Dumping data for table `time_zone_leap_second`
--


--
-- Table structure for table `time_zone_name`
--

CREATE TABLE `time_zone_name` (
  `Name` char(64) NOT NULL,
  `Time_zone_id` int unsigned NOT NULL,
  PRIMARY KEY (`Name`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Time zone names';

--
-- Dumping data for table `time_zone_name`
--


--
-- Table structure for table `time_zone_transition`
--

CREATE TABLE `time_zone_transition` (
  `Time_zone_id` int unsigned NOT NULL,
  `Transition_time` bigint NOT NULL,
  `Transition_type_id` int unsigned NOT NULL,
  PRIMARY KEY (`Time_zone_id`,`Transition_time`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Time zone transitions';

--
-- Dumping data for table `time_zone_transition`
--


--
-- Table structure for table `time_zone_transition_type`
--

CREATE TABLE `time_zone_transition_type` (
  `Time_zone_id` int unsigned NOT NULL,
  `Transition_type_id` int unsigned NOT NULL,
  `Offset` int NOT NULL DEFAULT '0',
  `Is_DST` tinyint unsigned NOT NULL DEFAULT '0',
  `Abbreviation` char(8) NOT NULL DEFAULT '',
  PRIMARY KEY (`Time_zone_id`,`Transition_type_id`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Time zone transition types';

--
-- Dumping data for table `time_zone_transition_type`
--


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `Host` char(255) CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL DEFAULT '',
  `User` char(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `Select_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Insert_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Update_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Delete_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Create_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Drop_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Reload_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Shutdown_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Process_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `File_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Grant_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `References_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Index_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Alter_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Show_db_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Super_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Create_tmp_table_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Lock_tables_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Execute_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Repl_slave_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Repl_client_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Create_view_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Show_view_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Create_routine_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Alter_routine_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Create_user_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Event_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Trigger_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Create_tablespace_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `ssl_type` enum('','ANY','X509','SPECIFIED') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `ssl_cipher` blob NOT NULL,
  `x509_issuer` blob NOT NULL,
  `x509_subject` blob NOT NULL,
  `max_questions` int unsigned NOT NULL DEFAULT '0',
  `max_updates` int unsigned NOT NULL DEFAULT '0',
  `max_connections` int unsigned NOT NULL DEFAULT '0',
  `max_user_connections` int unsigned NOT NULL DEFAULT '0',
  `plugin` char(64) COLLATE utf8_bin NOT NULL DEFAULT 'caching_sha2_password',
  `authentication_string` text COLLATE utf8_bin,
  `password_expired` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `password_last_changed` timestamp NULL DEFAULT NULL,
  `password_lifetime` smallint unsigned DEFAULT NULL,
  `account_locked` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Create_role_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Drop_role_priv` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'N',
  `Password_reuse_history` smallint unsigned DEFAULT NULL,
  `Password_reuse_time` smallint unsigned DEFAULT NULL,
  `Password_require_current` enum('N','Y') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `User_attributes` json DEFAULT NULL,
  PRIMARY KEY (`Host`,`User`)
) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Users and global privileges';

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES ('localhost','debian-sys-maint','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'caching_sha2_password','$A$005$?ZYdRMVa:C[7f2.oWfQUsAgse.zxbOJGnqKUxvYo2PpNHye/0rQCkudiro6','N','2021-08-11 02:27:56',NULL,'N','Y','Y',NULL,NULL,NULL,NULL),('localhost','mysql.infoschema','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'caching_sha2_password','$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED','N','2021-08-11 02:27:55',NULL,'Y','N','N',NULL,NULL,NULL,NULL),('localhost','mysql.session','N','N','N','N','N','N','N','Y','N','N','N','N','N','N','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'caching_sha2_password','$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED','N','2021-08-11 02:27:55',NULL,'Y','N','N',NULL,NULL,NULL,NULL),('localhost','mysql.sys','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'caching_sha2_password','$A$005$THISISACOMBINATIONOFINVALIDSALTANDPASSWORDTHATMUSTNEVERBRBEUSED','N','2021-08-11 02:27:55',NULL,'Y','N','N',NULL,NULL,NULL,NULL),('localhost','phpmyadmin','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','','','','',0,0,0,0,'caching_sha2_password','$A$005$.dT#=OETYl%P,dcF2clvlGcnI67CTnW9uZ/yemRRNCAnioS9xcbNdr9zMn0','N','2021-08-11 02:31:17',NULL,'N','N','N',NULL,NULL,NULL,NULL),('localhost','root','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','',0,0,0,0,'mysql_native_password','*7323C453138CB0687B9F20871C3818249DFA808F','N','2021-08-11 02:35:03',NULL,'N','Y','Y',NULL,NULL,NULL,NULL);

--
-- Table structure for table `general_log`
--

CREATE TABLE IF NOT EXISTS `general_log` (
  `event_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `user_host` mediumtext NOT NULL,
  `thread_id` bigint unsigned NOT NULL,
  `server_id` int unsigned NOT NULL,
  `command_type` varchar(64) NOT NULL,
  `argument` mediumblob NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8mb3 COMMENT='General log';

--
-- Table structure for table `slow_log`
--

CREATE TABLE IF NOT EXISTS `slow_log` (
  `start_time` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `user_host` mediumtext NOT NULL,
  `query_time` time(6) NOT NULL,
  `lock_time` time(6) NOT NULL,
  `rows_sent` int NOT NULL,
  `rows_examined` int NOT NULL,
  `db` varchar(512) NOT NULL,
  `last_insert_id` int NOT NULL,
  `insert_id` int NOT NULL,
  `server_id` int unsigned NOT NULL,
  `sql_text` mediumblob NOT NULL,
  `thread_id` bigint unsigned NOT NULL
) ENGINE=CSV DEFAULT CHARSET=utf8mb3 COMMENT='Slow log';

--
-- Current Database: `BUYA`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `BUYA` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;

USE `BUYA`;

--
-- Table structure for table `abouts`
--

CREATE TABLE `abouts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `about_1` text COLLATE utf8_unicode_ci NOT NULL,
  `about_2` text COLLATE utf8_unicode_ci NOT NULL,
  `about_3` text COLLATE utf8_unicode_ci NOT NULL,
  `about_4` text COLLATE utf8_unicode_ci NOT NULL,
  `about_5` text COLLATE utf8_unicode_ci NOT NULL,
  `cmc_1` text COLLATE utf8_unicode_ci NOT NULL,
  `cmc_2` text COLLATE utf8_unicode_ci NOT NULL,
  `cmc_3` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `abouts`
--

INSERT INTO `abouts` VALUES (1,'<h1>「社區介紹」內文</h1><p>這裡可以編輯內文。</p>','<h1>「社區故事」內文</h1><p>這裡可以編輯內文。</p>','<h1>「社區服務」內文</h1><p>這裡可以編輯內文。</p>','<h1>「註冊約定」內文</h1><p>這裡可以編輯內文。</p>','<h1>「其他」內文</h1></p>這裡可以編輯內文。</p>','<p>這裡可以編輯內文。</p>','<p>這裡可以編輯內文。</p>','<p>這裡可以編輯內文。</p>','2021-08-11 11:25:44','2021-08-11 11:25:44');

--
-- Table structure for table `aboutus`
--

CREATE TABLE `aboutus` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `author` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `column` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `cover_img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `aboutus`
--


--
-- Table structure for table `aboutus_columns`
--

CREATE TABLE `aboutus_columns` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `aboutus_columns`
--

INSERT INTO `aboutus_columns` VALUES (1,'大樓介紹','0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'大樓故事','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'大樓服務','0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,'服務團隊','0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,'管委會規章','0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,'大樓規章','0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- Table structure for table `access_actions`
--

CREATE TABLE `access_actions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `cardmachine_number` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `cm_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'access',
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `subtype` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `action_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `action_content` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `type_mode` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `solution` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `access_actions`
--


--
-- Table structure for table `access_admins`
--

CREATE TABLE `access_admins` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `doorplates` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `username` text COLLATE utf8_unicode_ci NOT NULL,
  `staff` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `door` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `access_admins`
--


--
-- Table structure for table `access_classes`
--

CREATE TABLE `access_classes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '卡機類別',
  `class` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '車輛類型(car汽車、moto機車)',
  `cm_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'access' COMMENT '卡機功能類型(access門禁、parking停車)',
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '圖片路徑',
  `error_image` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '告警圖片路徑',
  `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '0啟用、1關閉',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `access_classes`
--


--
-- Table structure for table `access_controll_log`
--

CREATE TABLE `access_controll_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `command_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `company_id` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `cardmachine_number` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `Staff_group` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Cardmachine_group` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Category_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mail_position` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  `floor_limit` text COLLATE utf8_unicode_ci,
  `user_card_number` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `etag_number` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `subtype` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `subject` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `message` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `invalid_time` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `event_date` date NOT NULL,
  `event_time` time NOT NULL,
  `type_mode` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `Recover_status` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_group_id` text COLLATE utf8_unicode_ci,
  `cardmachine_group_id` text COLLATE utf8_unicode_ci,
  `card_number_list` text COLLATE utf8_unicode_ci,
  `cardmachine_number_list` text COLLATE utf8_unicode_ci,
  `schedule_id` int DEFAULT NULL,
  `inst_order_id` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `time_start` datetime DEFAULT NULL,
  `time_end` datetime DEFAULT NULL,
  `cm_list` text COLLATE utf8_unicode_ci,
  `cm_pass` text COLLATE utf8_unicode_ci,
  `cm_failed` text COLLATE utf8_unicode_ci,
  `result` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `operator` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `error_msg` text COLLATE utf8_unicode_ci,
  `emergency_video_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `access_controll_log`
--


--
-- Table structure for table `access_door_cardmachines`
--

CREATE TABLE `access_door_cardmachines` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `cardmachine_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `door_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `access_door_cardmachines`
--


--
-- Table structure for table `access_doors`
--

CREATE TABLE `access_doors` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '門組名稱',
  `class` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '車輛類型(car汽車、moto機車)',
  `cm_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'access' COMMENT '卡機功能類型(access門禁、parking停車)',
  `floor` smallint NOT NULL DEFAULT '0' COMMENT '樓層管制功能是否開啟(0關閉、1開啟)',
  `status` smallint NOT NULL DEFAULT '0' COMMENT '0啟用、1關閉',
  `soga_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'SOGA門組ID',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `access_doors`
--


--
-- Table structure for table `access_locations`
--

CREATE TABLE `access_locations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `building` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '建物id',
  `floor` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '樓層',
  `class` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '車輛類型(car汽車、moto機車)',
  `cm_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'access' COMMENT '卡機功能類型(access門禁、parking停車)',
  `location` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '地上、地下',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '名稱',
  `status` int NOT NULL COMMENT '0啟用、1關閉',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `access_locations`
--


--
-- Table structure for table `access_settings`
--

CREATE TABLE `access_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '路徑類型',
  `status` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `access_settings`
--


--
-- Table structure for table `access_staff_cards`
--

CREATE TABLE `access_staff_cards` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `card_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `staff_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `access_staff_cards`
--


--
-- Table structure for table `access_staff_to_doors`
--

CREATE TABLE `access_staff_to_doors` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `door_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `staff_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `access_staff_to_doors`
--


--
-- Table structure for table `access_staffs`
--

CREATE TABLE `access_staffs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '人組名稱',
  `class` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '車輛類型(car汽車、moto機車)',
  `cm_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'access' COMMENT '卡機功能類型(access門禁、parking停車)',
  `floor_limit` text CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT '允許進入的樓層(用，隔開)',
  `soga_d_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '對應創價部門',
  `status` smallint NOT NULL COMMENT '0啟用、1關閉',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `access_staffs`
--


--
-- Table structure for table `accesses`
--

CREATE TABLE `accesses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `class_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '卡機類別',
  `cardmachine_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '卡機號碼',
  `class` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '車輛類型(car汽車、moto機車)',
  `cm_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'access' COMMENT '卡機功能類型(access門禁、parking停車)',
  `inout` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '進出方向(in、out)',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '卡機名稱(便於物業識別)',
  `location` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '卡機名稱(便於物業識別)',
  `is_subtitle` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '是否連動字幕機(0否、1是)',
  `is_box` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是不是信箱',
  `box_num` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '信箱編號',
  `subtitle_array` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '字幕機id用,隔開',
  `company_code` int NOT NULL COMMENT '卡機對應的公司代碼id',
  `access_model` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '卡機型號',
  `access_serial` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '卡機序號',
  `status` int NOT NULL COMMENT '0啟用、1關閉',
  `info` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '備註',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `accesses`
--


--
-- Table structure for table `accts`
--

CREATE TABLE `accts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `acct_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '科目代號',
  `sub_id` int NOT NULL COMMENT '子代號',
  `acct_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '科目類別',
  `acct_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '會計科目',
  `borrow` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '借/貸(d/c)',
  `balance` int NOT NULL COMMENT '餘額',
  `summary` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '摘要',
  `default` int NOT NULL COMMENT '是否預設',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `accts`
--


--
-- Table structure for table `acquired_source`
--

CREATE TABLE `acquired_source` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `function` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `source` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `acquired_source`
--


--
-- Table structure for table `action_api_logs`
--

CREATE TABLE `action_api_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `a_id` int NOT NULL COMMENT '活動ID',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '活動名稱',
  `d_start` date NOT NULL COMMENT '活動日期起',
  `d_end` date NOT NULL COMMENT '活動日期迄',
  `time` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '活動時間',
  `info` text COLLATE utf8_unicode_ci NOT NULL COMMENT '說明',
  `info2` text COLLATE utf8_unicode_ci NOT NULL COMMENT '說明2',
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '地點',
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '地址',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `action_api_logs`
--


--
-- Table structure for table `action_logs`
--

CREATE TABLE `action_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `info` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `service` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `action_logs`
--

INSERT INTO `action_logs` VALUES (1,1,'log','住戶:系統管理員(admin)於剛才從網站登入','2021-08-11 11:27:25','2021-08-11 11:27:25',NULL),(2,1,'log','住戶:系統管理員(admin)於剛才從網站登入','2021-09-11 18:13:51','2021-09-11 18:13:51',NULL),(3,22,'log','住戶:管理者(BUYA)於剛才從網站登入','2021-09-11 18:18:45','2021-09-11 18:18:45',NULL),(4,1,'log','住戶:系統管理員(admin)於剛才從網站登入','2021-09-13 09:54:38','2021-09-13 09:54:38',NULL),(5,23,'log','住戶:安管日班(002)於剛才從網站登入','2021-09-13 10:15:15','2021-09-13 10:15:15',NULL),(6,22,'log','住戶:管理者(buya)於剛才從網站登入','2021-09-13 10:15:33','2021-09-13 10:15:33',NULL),(7,23,'log','住戶:安管日班(002)於剛才從網站登入','2021-09-13 10:20:36','2021-09-13 10:20:36',NULL),(8,22,'log','住戶:管理者(buya)於剛才從網站登入','2021-09-13 13:01:54','2021-09-13 13:01:54',NULL);

--
-- Table structure for table `activations`
--

CREATE TABLE `activations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `completed_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `activations`
--

INSERT INTO `activations` VALUES (1,1,'ipp9UOvdQXHmxa7AQqIfEXgFXyAiWovJ',1,'2021-08-11 11:25:44','2021-08-11 11:25:44','2021-08-11 11:25:44'),(22,22,'Wm7AW0R1Xsex3dT1KJS7JfhK6eFk9zDf',1,'2021-09-11 18:15:39','2021-09-11 18:15:39','2021-09-11 18:15:39'),(23,23,'VjUjfCBwsLwScZizJtUKGcmBfbBezaJU',1,'2021-09-11 18:46:54','2021-09-11 18:46:54','2021-09-11 18:46:54'),(24,24,'BDTMMCSQfbkjdBBCm0LdBhxQTXvmjPVr',1,'2021-09-11 18:47:35','2021-09-11 18:47:35','2021-09-11 18:47:35'),(25,25,'sn68HFxtcXAczZQwDSgyfChUoNQSV4em',1,'2021-09-11 18:56:13','2021-09-11 18:56:13','2021-09-11 18:56:13'),(26,26,'itLH1sqUkzdYOd60uSvz5Ytaljo5Tgzz',1,'2021-09-11 18:56:13','2021-09-11 18:56:13','2021-09-11 18:56:13'),(27,27,'CZLpHyDN6CuHbBumbvgnSPWjEMj8ydg6',1,'2021-09-11 18:56:13','2021-09-11 18:56:13','2021-09-11 18:56:13'),(28,28,'2xBcD1hmOxI4vBFSImJKvLlPbOzGtquE',1,'2021-09-11 18:56:13','2021-09-11 18:56:13','2021-09-11 18:56:13'),(29,29,'D98duX1bvKjV5V4ytpttdfFUf6R6e0DB',1,'2021-09-11 18:56:13','2021-09-11 18:56:13','2021-09-11 18:56:13'),(30,30,'WMa2ksGzwq0w3sA5RhWOubhl7Sj1TQ7M',1,'2021-09-11 18:56:13','2021-09-11 18:56:13','2021-09-11 18:56:13'),(31,31,'LEBhIS9RFyVG7M1BzmoRCrI40nR3LIXI',1,'2021-09-11 18:56:13','2021-09-11 18:56:13','2021-09-11 18:56:13'),(32,32,'goemYBpxopZGzPDy8UkYcqqIvbfYDZ5J',1,'2021-09-11 18:56:13','2021-09-11 18:56:13','2021-09-11 18:56:13'),(33,33,'CwGw8xuHCKhxsRCXC2g9c8tQcu6izM0N',1,'2021-09-11 18:56:13','2021-09-11 18:56:13','2021-09-11 18:56:13'),(34,34,'umWuF8D1SUp0PDayLKGXE1yzyp7m2Lpt',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(35,35,'NQAbTdSqtqTJpGNT5alwO9tV0KHPaco6',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(36,36,'h3s2iZPUYUczf2nEYCXCwQTz2pGV19Wy',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(37,37,'rBx1QN7wNeJTTuZr6ZuXcsjA8fcdGZV3',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(38,38,'yKQ1F4IE9jG8MeLxhiFaS6G4innGwX1G',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(39,39,'HrnLgKp0t6DJMyLKJnlhqjpnJt57Noq8',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(40,40,'ncYQK95pifD2fXK2uhTd4nyxmozbJ7iG',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(41,41,'8IMgEQo4WHTypVTU5xqf85ovC61BdrcO',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(42,42,'WfDISQUWaBxQFH5kC0qt3PIcgKu2x8Vg',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(43,43,'A9QhKk9tVAeLxNk5Lo18GVNuNttubroi',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(44,44,'P9b81BI75eolPeWdEtRJlsw6kIJPB4JQ',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(45,45,'9arMkl0zkkLmc4Rlgxx5dEGXxGoMfk4K',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(46,46,'zdfDdf966KQELO30skAf2VY3Ew5XPhuC',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(47,47,'riMWSrm1i18jDjHwQEG5a5dy7pKdFsQL',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(48,48,'KzRdjsgXZMrL39dpalzssaOoJhVljBEQ',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(49,49,'03Qy1O0k2vzgabgergy69K76wbZalqxk',1,'2021-09-11 18:56:14','2021-09-11 18:56:14','2021-09-11 18:56:14'),(50,50,'2WN4EhEQBiGfkiDYzsGgQQvJwV6SCLH5',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(51,51,'YmVRnApwTUWtaRTfRGMbduAlFgXjFHHj',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(52,52,'IbOmULdCxWqGyKGF9CM2HScrInXHbsTV',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(53,53,'4zGFmKahGm4TekgAR00ieSJS5LTvS3pB',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(54,54,'FV1T9KK6vhyVkQs2RgxVw1iBNDTnw47Q',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(55,55,'IDGmJCrpg7HsUTvFm6pgGcBzdZjnmMAc',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(56,56,'QFBcZGCJZzTHDBGd99P4yoKTqgRTJjWC',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(57,57,'S2j6Mrpmde26nRr0s91W56fTQ2XJHOmT',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(58,58,'onFJuDLiuD1oOkzhAAINnVT5asPUnkNE',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(59,59,'RpUVKq6EN78ipWjJUSYTRgMwBli0DKSY',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(60,60,'Gt2kOKdwQqAb4vAr3zAoMcyup9Rw0rGs',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(61,61,'KPQGHyza98BeFeO1B2lRmqC2s30LtHje',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(62,62,'NYzevwKcfuYCn1ZDjLv0oaAwsxIBzchE',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(63,63,'x9EwxOK64REXvVHEWXIzbuThS6VA8PpV',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(64,64,'WryjTO6ghzU8d6ghAS2vqf1yKJqLSErr',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(65,65,'C8zPtmHXaVGQOhpOW8m1hNSB2fLPP4Tb',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(66,66,'BSS1CVH9kqjmQ8GbZ5MYkd6BCHcovIww',1,'2021-09-11 18:56:15','2021-09-11 18:56:15','2021-09-11 18:56:15'),(67,67,'1EMDchj3cxYfku1W9Yh9urHfbBoRhn0I',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(68,68,'kREF68BZySkGIHFJJRCdasWZEHstsT9a',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(69,69,'GopjF3BVVQDZ9Gc6vYO1qwdTu33VYGpE',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(70,70,'H8tW8ZGnwnEBwROxZgTTBH0xdg63wAdo',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(71,71,'er1ZMvoLthwjenQeu0tYRVOhJ7Lq6dDh',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(72,72,'UcMjCOzUr81XHWGsx8TgE7fKhnPEUPQm',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(73,73,'Ulm7xq1feSpKf8TrNQuzb8AnuoVKz88m',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(74,74,'HiHAlQoApfBHRarS5bjfFuPB0iRfeKal',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(75,75,'deQRZHe0EsW26a7KSYkBNZonxIJFPFiD',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(76,76,'DIa4X7LiPoBVhO8TRUSX6fITXOSYHEhk',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(77,77,'82imW6Fiu5N6urUUU0HDfzAQzs8mfegY',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(78,78,'wmD3rQnWUZC6Odc79moUQGFLRuak1NVX',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(79,79,'whP2PiMRhNl5l0DBkgbrVYZkAKr1TfpW',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(80,80,'fyr50Ha1fMSVo4KOC3FhiBo3Yfi9Pg61',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(81,81,'50GriavVj7V2o012uyNqVwRfuZJ2TGSl',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(82,82,'tbShOqF47PDC2UarHRqN7eQ1qvesCrJE',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(83,83,'sfjNoxqSYD1EIvQL1b1cWxgo0PHp2zYg',1,'2021-09-11 18:56:16','2021-09-11 18:56:16','2021-09-11 18:56:16'),(84,84,'HT9b70MdGfkXYBHUUvOt9ezmblHhPuWM',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(85,85,'QnZpfWxq6mdn7TfOjnOFiRmonvxakEhI',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(86,86,'Vlpv7T1rQZAOgXsisPxQuQsF9047R7BX',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(87,87,'EzQJN5x4MMO7vZJmlqbbfxFmudZRvIZ9',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(88,88,'4LYAriDfFWC4dJfcJ1PPpCYT5isIUcGI',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(89,89,'tTH2VTqM0GPelM5fPGXF2PlOLz8HXxQU',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(90,90,'nKeijJhtTsbd45XOwqIeqrz5vQxgXVCf',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(91,91,'OUe5mDoGzUaleSIyEg5QbdPukLvDYer8',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(92,92,'MoAB4oilavW3dy5awKVw8wHrkwx4Jusl',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(93,93,'LC8L0IQODq4srpWbEOSuJAKv9wWieGht',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(94,94,'NAQ80Bc2VVBXc5XdKNy0Hm9pfO1lTnEn',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(95,95,'hcHmpzGwwqKHVBYfg5azUmAfQ44JRxFm',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(96,96,'TyHXVbOgjq35UEP4z3D3p9trkVvdPh2L',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(97,97,'YJAQp8Peiuk01RrQbJq2xPoaNwXZb8wp',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(98,98,'mFWIlpkSDvBZRd3ja7spwBTsd4rE8y86',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(99,99,'JZ0nT5NPRx8OvcDCr7SxIire8fd48DM1',1,'2021-09-11 18:56:17','2021-09-11 18:56:17','2021-09-11 18:56:17'),(100,100,'xBAruPazZDz3jdxqz0jJgRWbiOxqwMW5',1,'2021-09-11 18:56:18','2021-09-11 18:56:18','2021-09-11 18:56:18'),(101,101,'eywVS3CyVpzvsSGL6elw1mLKFEB4RBPP',1,'2021-09-11 18:56:18','2021-09-11 18:56:18','2021-09-11 18:56:18'),(102,102,'ol1m0lX6DkubTapEkAkD3P4DcCWBzNng',1,'2021-09-11 18:56:18','2021-09-11 18:56:18','2021-09-11 18:56:18'),(103,103,'GwkonyYpLGEDDgzXruBoiLvRJRROjFuZ',1,'2021-09-11 18:56:18','2021-09-11 18:56:18','2021-09-11 18:56:18'),(104,104,'waAUtF50siJhaHXgpD0dsGuqsnhAi3mj',1,'2021-09-11 18:56:18','2021-09-11 18:56:18','2021-09-11 18:56:18'),(105,105,'qmjWKR28AJEOGazOaICeNkH6IoY06QNd',1,'2021-09-11 18:56:18','2021-09-11 18:56:18','2021-09-11 18:56:18'),(106,106,'ccbGBFOg0ccVnOAeQ6ruMTmJB6lD1Wco',1,'2021-09-11 18:56:18','2021-09-11 18:56:18','2021-09-11 18:56:18'),(107,107,'texbYXy0XvchV9QI3yyiaRQQk9fCFdfx',1,'2021-09-11 18:56:18','2021-09-11 18:56:18','2021-09-11 18:56:18'),(108,108,'unt9EERao7hreZc9qDvw6WK2mTGsliT3',1,'2021-09-11 18:56:18','2021-09-11 18:56:18','2021-09-11 18:56:18'),(109,109,'f3zs7EzZyrJLZcE3xe3dHJKfsAMmP55z',1,'2021-09-11 18:56:18','2021-09-11 18:56:18','2021-09-11 18:56:18'),(110,110,'oL1bbaFOhnGIJOLMYyMYCyNU6inlYrdo',1,'2021-09-11 18:56:18','2021-09-11 18:56:18','2021-09-11 18:56:18'),(111,111,'FZrY7p7tR8N3duZSlGD64B5ep1VEEUwY',1,'2021-09-11 19:08:01','2021-09-11 19:08:01','2021-09-11 19:08:01');

--
-- Table structure for table `activities`
--

CREATE TABLE `activities` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `time_start` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time_end` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time_range` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `purpose` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `holder` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `area` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fee` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cover_img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `forwho` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `need_cards` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `safe_note` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8_unicode_ci,
  `sign_flag` tinyint(1) DEFAULT NULL,
  `sign_start` datetime DEFAULT NULL,
  `sign_end` datetime DEFAULT NULL,
  `sign_person_max_flag` tinyint(1) DEFAULT NULL,
  `sign_person_max` int DEFAULT NULL,
  `sign_person_each_max_flag` tinyint(1) DEFAULT NULL,
  `sign_person_each_max` int DEFAULT NULL,
  `sign_info` text COLLATE utf8_unicode_ci,
  `sign_user` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `photo1_img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `photo2_img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `photo3_img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `photo4_img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `photo5_img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `place_cover_img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `activities`
--


--
-- Table structure for table `activities_applies`
--

CREATE TABLE `activities_applies` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `activities_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `number_people` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `handled` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `activities_applies`
--


--
-- Table structure for table `air_conditioning_energies`
--

CREATE TABLE `air_conditioning_energies` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `device_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備代號',
  `room_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '宿舍號碼',
  `date` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '日期',
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '數值',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `air_conditioning_energies`
--


--
-- Table structure for table `air_conditioning_error_logs`
--

CREATE TABLE `air_conditioning_error_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `device_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備代號',
  `room_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '宿舍號碼',
  `date` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '日期',
  `error_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '數值',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `air_conditioning_error_logs`
--


--
-- Table structure for table `album_folders`
--

CREATE TABLE `album_folders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `info` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `album_folders`
--


--
-- Table structure for table `album_images`
--

CREATE TABLE `album_images` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `album_id` int unsigned NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `album_images`
--


--
-- Table structure for table `albums`
--

CREATE TABLE `albums` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `folder_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `info` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int NOT NULL,
  `cover_img` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `albums`
--


--
-- Table structure for table `app_icon_replace`
--

CREATE TABLE `app_icon_replace` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `icon_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `app_icon_replace`
--


--
-- Table structure for table `applicant`
--

CREATE TABLE `applicant` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `no` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `function` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `number` int NOT NULL,
  `applicant` int NOT NULL,
  `applicant_time` datetime NOT NULL,
  `approved` int NOT NULL,
  `approved_time` datetime NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `target_id` int NOT NULL,
  `explain` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `issued_number` int NOT NULL,
  `approved2` int NOT NULL,
  `approved_time2` datetime NOT NULL,
  `amount` int NOT NULL,
  `sign_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sign_image2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cause` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `applicant_function_index` (`function`),
  KEY `applicant_applicant_index` (`applicant`),
  KEY `applicant_approved_index` (`approved`),
  KEY `applicant_target_id_index` (`target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `applicant`
--


--
-- Table structure for table `asset_check_import`
--

CREATE TABLE `asset_check_import` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `success` int NOT NULL,
  `fail` int NOT NULL,
  `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `file_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `asset_check_import`
--


--
-- Table structure for table `asset_custodian_log`
--

CREATE TABLE `asset_custodian_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `old_custodian` int NOT NULL,
  `new_custodian` int NOT NULL,
  `asset_id` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `punish_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_custodian_log_asset_id_index` (`asset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `asset_custodian_log`
--


--
-- Table structure for table `asset_images`
--

CREATE TABLE `asset_images` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `asset_id` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_images_asset_id_index` (`asset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `asset_images`
--


--
-- Table structure for table `asset_import`
--

CREATE TABLE `asset_import` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `success` int NOT NULL,
  `fail` int NOT NULL,
  `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `file_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `asset_import`
--


--
-- Table structure for table `asset_maintenance_log`
--

CREATE TABLE `asset_maintenance_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `firm_id` int NOT NULL,
  `asset_id` int NOT NULL,
  `reason` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cost` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_maintenance_log_firm_id_index` (`firm_id`),
  KEY `asset_maintenance_log_asset_id_index` (`asset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `asset_maintenance_log`
--


--
-- Table structure for table `asset_punish`
--

CREATE TABLE `asset_punish` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `date` date NOT NULL,
  `reason` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `registrant` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `a_id` int NOT NULL,
  `di_id` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `asset_punish_a_id_index` (`a_id`),
  KEY `asset_punish_di_id_index` (`di_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `asset_punish`
--


--
-- Table structure for table `assets`
--

CREATE TABLE `assets` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `no` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `asset_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `specification` text COLLATE utf8_unicode_ci NOT NULL,
  `model` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `installation_date` date NOT NULL COMMENT '安裝日期',
  `barcode` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備條碼',
  `typename` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備種類',
  `devorder` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備流水號',
  `affiliated_asset` text COLLATE utf8_unicode_ci NOT NULL,
  `sn` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `devuuid` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備編號',
  `entifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '識別碼',
  `manufacturer` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '製造廠商',
  `warranty_duration_labor` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '保固時程',
  `warranty_duration_unit` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '保固時程單位',
  `warranty_guarantor_labor` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '保固廠商',
  `replacement_cost` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '置換成本',
  `cust_stand` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '產品別',
  `expected_life` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '可用期限',
  `duration_unit` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '可用期限單位',
  `model_reference` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '型號參照',
  `shape` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備形狀',
  `size` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備大小',
  `color` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備顏色',
  `finish` date NOT NULL COMMENT '竣工點交日期',
  `grade` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備等級',
  `material` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備材質',
  `system_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '系統別',
  `dev_name2` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備合約名稱',
  `accessibility_performance` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '無障礙功能',
  `sensor_id` int NOT NULL COMMENT '對應sensor',
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '帶電或不帶電',
  `c_id` int NOT NULL,
  `purchase_date` date NOT NULL,
  `as_id` int NOT NULL,
  `age_limit` int NOT NULL,
  `costs` int NOT NULL,
  `depreciation_price` int NOT NULL,
  `purchase_reason` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `situation` text COLLATE utf8_unicode_ci NOT NULL,
  `custodian` int NOT NULL,
  `sp_id` int NOT NULL,
  `repairer_tel` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `repairer_contact` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `warranty_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `warranty_exp_date` date NOT NULL,
  `warranty_start_date` date NOT NULL COMMENT '保固起始日期',
  `budget_amount` int NOT NULL COMMENT '預算金額',
  `budget_year` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '預算年度',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int NOT NULL,
  `f_id` int NOT NULL,
  `xls_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `check_status` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `assets_c_id_index` (`c_id`),
  KEY `assets_as_id_index` (`as_id`),
  KEY `assets_custodian_index` (`custodian`),
  KEY `assets_sp_id_index` (`sp_id`),
  KEY `assets_f_id_index` (`f_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `assets`
--


--
-- Table structure for table `authority`
--

CREATE TABLE `authority` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `route` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `authority`
--

INSERT INTO `authority` VALUES (1,'資產設備基本資料建立','manage/asset/assets','0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'資產設備異動動處理','manage/asset/punish','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'資產申請','manage/asset/applicant','0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,'資產領用','manage/asset/picklist','0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,'資產申請審核','manage/asset/examine','0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,'存放位置資料建立','manage/asset/storage_place','0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,'取得來源項目建立','manage/asset/acquired_source','0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,'處份異動項目建立','manage/asset/disposal_item','0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,'總類類別設定','manage/asset/general_category','0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,'資產設備分類類別設定','manage/asset/category','0000-00-00 00:00:00','0000-00-00 00:00:00'),(11,'資產設備匯入','manage/asset/assetImport','0000-00-00 00:00:00','0000-00-00 00:00:00'),(12,'資產盤點匯入','manage/asset/assetCheckImport','0000-00-00 00:00:00','0000-00-00 00:00:00'),(13,'資產設備維修管理','manage/asset/maintenance','0000-00-00 00:00:00','0000-00-00 00:00:00'),(14,'儲物基本資料建立','manage/storage/storages','0000-00-00 00:00:00','0000-00-00 00:00:00'),(15,'儲物申請','manage/storage/applicant','0000-00-00 00:00:00','0000-00-00 00:00:00'),(16,'儲物領用','manage/storage/picklist','0000-00-00 00:00:00','0000-00-00 00:00:00'),(17,'儲物分類類別設定','manage/storage/category','0000-00-00 00:00:00','0000-00-00 00:00:00'),(18,'儲物異動管理','manage/storage/substitute','0000-00-00 00:00:00','0000-00-00 00:00:00'),(19,'儲物單位管理','manage/storage/unit','0000-00-00 00:00:00','0000-00-00 00:00:00'),(20,'儲物資料進貨管理','manage/storage/purchase','0000-00-00 00:00:00','0000-00-00 00:00:00'),(21,'儲物申請審核','manage/storage/examine','0000-00-00 00:00:00','0000-00-00 00:00:00'),(22,'儲物資料匯入','manage/asset/storageImport','0000-00-00 00:00:00','0000-00-00 00:00:00'),(23,'計費承租戶管理','manage/payment/tenant','0000-00-00 00:00:00','0000-00-00 00:00:00'),(24,'計費電價設定','manage/payment/electricity_bill','0000-00-00 00:00:00','0000-00-00 00:00:00'),(25,'計費度數修改','manage/payment/edit_electricity_view','0000-00-00 00:00:00','0000-00-00 00:00:00'),(26,'計費設備建立','manage/payment/add_facility_view','0000-00-00 00:00:00','0000-00-00 00:00:00'),(27,'計費設定設備對應用戶','manage/payment/set_user_facility','0000-00-00 00:00:00','0000-00-00 00:00:00'),(28,'計費請款金額','manage/payment/electricity_fee','0000-00-00 00:00:00','0000-00-00 00:00:00'),(29,'計費建立度數資料','manage/payment/electricity_btu_record','0000-00-00 00:00:00','0000-00-00 00:00:00'),(30,'計費各式報表','manage/payment/electricity_meter','0000-00-00 00:00:00','0000-00-00 00:00:00'),(31,'計費各式報表','manage/payment/formula','0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- Table structure for table `ba_building`
--

CREATE TABLE `ba_building` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `BAID` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `BAName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `UpdNo` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ba_building`
--


--
-- Table structure for table `ba_eqLog`
--

CREATE TABLE `ba_eqLog` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `ActionType` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `LGSSID` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `EqMdle` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `EqType` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `EqID` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `EqAttrType` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `EqAttr` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `EqAttrName` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `EqStatus` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `EqStatusDesc` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `CID` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `BAID` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `FID` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `HID` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ba_eqLog`
--


--
-- Table structure for table `ba_floor`
--

CREATE TABLE `ba_floor` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `BAID` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `FID` varchar(3) COLLATE utf8_unicode_ci NOT NULL,
  `FName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `UpdNo` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ba_floor`
--


--
-- Table structure for table `ba_import`
--

CREATE TABLE `ba_import` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `success` int NOT NULL,
  `fail` int NOT NULL,
  `title` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `file_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ba_import`
--


--
-- Table structure for table `bike_logs`
--

CREATE TABLE `bike_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '場站中文名稱',
  `total` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '總車位數',
  `stock` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '目前車輛數',
  `idle` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '閒置車位數',
  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '地址',
  `last_datetime` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '最後更新時間',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bike_logs`
--


--
-- Table structure for table `bus_logs`
--

CREATE TABLE `bus_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `num` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '公車號',
  `status` int NOT NULL COMMENT '狀態',
  `sec` int NOT NULL COMMENT '到站時間',
  `last_update` datetime NOT NULL COMMENT '最後更新時間',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `bus_logs`
--


--
-- Table structure for table `calendar_comprehensives`
--

CREATE TABLE `calendar_comprehensives` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL COMMENT '使用者ID',
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '是哪一個事件',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '標題',
  `start_section` datetime NOT NULL COMMENT '開始時間',
  `end_section` datetime NOT NULL COMMENT '結束時間',
  `all_day` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否為整天',
  `details` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '詳細資料',
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '地點',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `calendar_comprehensives`
--


--
-- Table structure for table `calendar_events`
--

CREATE TABLE `calendar_events` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `info` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' COMMENT '0未處理 1處理中 2處理完成',
  `allDay` tinyint(1) NOT NULL DEFAULT '1',
  `start` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `end` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cal_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `cover_img` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `calendar_events`
--

INSERT INTO `calendar_events` VALUES (15,'社區管委會會議','管委會','會議室','事件說明','0',1,'2015-12-24','2015-12-24','4','2015-12-15 16:50:18','2015-12-15 16:51:37','',''),(16,'區分所有權人代表大會','管委會','會議室','','0',1,'2015-12-30','2015-12-30','4','2015-12-15 16:50:44','2015-12-15 16:50:44','',''),(17,'物業管理會議','物管公司','總公司','','0',1,'2015-12-16','2015-12-16','3','2015-12-15 16:51:57','2015-12-15 16:51:57','',''),(18,'週會','管委會','會議室','','0',1,'2015-12-07','2015-12-07','4','2015-12-15 16:53:03','2015-12-15 16:53:03','',''),(19,'週會','管委會','會議室','','0',1,'2015-12-14','2015-12-14','4','2015-12-15 16:53:05','2015-12-15 16:53:05','',''),(20,'週會','管委會','會議室','','0',1,'2015-12-21','2015-12-21','4','2015-12-15 16:53:06','2015-12-15 16:53:06','',''),(21,'週會','管委會','會議室','','0',1,'2015-12-28','2015-12-28','4','2015-12-15 16:53:08','2015-12-15 16:53:08','',''),(22,'社區活動-美食大賽','管委會','會議室','','0',1,'2015-12-18','2015-12-18','1','2015-12-15 16:53:40','2015-12-15 16:53:40','',''),(23,'社區活動-本月電影日','管委會','會議室','免費的電影可以看','0',1,'2015-12-29','2015-12-29','1','2015-12-15 16:54:00','2015-12-15 16:54:00','',''),(24,'消防設備廠商檢修','管委會','會議室','消防設備檢修','0',1,'2015-12-03','2015-12-03','3','2015-12-15 16:54:25','2015-12-15 16:54:25','',''),(25,'消防設備廠商檢修','管委會','會議室','消防設備檢修','0',1,'2015-12-27','2015-12-27','3','2015-12-15 16:54:27','2015-12-15 16:54:27','',''),(26,'游泳池維修','管委會','會議室','此段時間游泳池維修 暫不開放','0',0,'2015-12-07','2015-12-10','1','2015-12-15 16:55:04','2015-12-15 16:55:07','','');

--
-- Table structure for table `calendars`
--

CREATE TABLE `calendars` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `info` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lock` int NOT NULL DEFAULT '0',
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `calendars`
--

INSERT INTO `calendars` VALUES (1,'社區行事曆','社區行事曆',NULL,'#3da3bd',0,NULL,'2015-12-14 18:02:01','2015-12-15 16:49:30'),(3,'物業管理行事曆','物業管理公司專用的行事曆',NULL,'#d4c239',0,NULL,'2015-12-15 16:49:14','2015-12-15 16:49:14'),(4,'管委會行事曆','管委會專用行事曆',NULL,'#d15072',0,NULL,'2015-12-15 16:49:52','2015-12-15 16:49:52');

--
-- Table structure for table `camera_classes`
--

CREATE TABLE `camera_classes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `error_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `camera_classes`
--


--
-- Table structure for table `camera_locations`
--

CREATE TABLE `camera_locations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `building` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `floor` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `camera_locations`
--


--
-- Table structure for table `camera_settings`
--

CREATE TABLE `camera_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `length` int NOT NULL,
  `part` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `camera_settings`
--

INSERT INTO `camera_settings` VALUES (1,'',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- Table structure for table `cameras`
--

CREATE TABLE `cameras` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `class_id` int NOT NULL,
  `camera_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `camera_model` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `camera_serial` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `link_url` text COLLATE utf8_unicode_ci NOT NULL,
  `camera_account` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `camera_password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `low_speed` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `high_speed` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `info` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cameras`
--


--
-- Table structure for table `card_sets`
--

CREATE TABLE `card_sets` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `card_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `active_key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `card_sets`
--


--
-- Table structure for table `cards`
--

CREATE TABLE `cards` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `card_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '卡片類別',
  `card_category` int NOT NULL COMMENT '卡片類型 0為一般卡 1為安心卡 2為脅迫卡',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `cards_user_id_foreign` (`user_id`),
  CONSTRAINT `cards_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=429 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cards`
--

INSERT INTO `cards` VALUES (1,25,'08835203','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(2,25,'08998387','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(3,25,'09000739','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(4,25,'09028915','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(5,25,'09316179','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(6,26,'09318163','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(7,26,'08805907','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(8,26,'08772291','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(9,26,'08776115','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(10,26,'09322227','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(11,27,'09281299','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(12,27,'08831267','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(13,27,'09316035','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(14,27,'08788611','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(15,27,'09000659','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(16,28,'08665411','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(17,28,'08998307','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(18,28,'08699123','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(19,28,'08665219','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(20,28,'08842451','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(21,29,'08665251','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(22,29,'08808339','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(23,29,'09297939','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(24,29,'08833299','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(25,29,'09316563','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(26,30,'08772083','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(27,30,'08863331','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(28,30,'08828787','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(29,30,'08863267','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(30,30,'08816739','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(31,31,'08665619','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(32,31,'08961139','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(33,31,'08844531','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(34,31,'08842851','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(35,31,'09306083','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(36,32,'08810963','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(37,32,'08829075','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(38,32,'08868019','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(39,32,'08885811','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(40,32,'08697027','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(41,33,'08808435','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(42,33,'08844979','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(43,33,'08882003','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(44,33,'09030819','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(45,33,'08900563','',0,'2021-09-11 18:56:13','2021-09-11 18:56:13'),(46,34,'08759315','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(47,34,'08759139','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(48,34,'08833139','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(49,34,'08833155','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(50,34,'08863427','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(51,35,'09316227','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(52,35,'08664131','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(53,35,'08867987','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(54,35,'08808467','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(55,35,'08784595','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(56,36,'08998131','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(57,36,'08883715','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(58,36,'09280995','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(59,36,'08867427','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(60,36,'08665827','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(61,37,'08844611','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(62,37,'09315923','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(63,37,'09317971','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(64,37,'08865123','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(65,37,'08665523','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(66,38,'08670163','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(67,38,'09314227','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(68,38,'09003107','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(69,38,'09032739','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(70,38,'08804563','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(71,39,'09320595','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(72,39,'08879875','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(73,39,'08806691','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(74,39,'08834995','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(75,39,'08881795','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(76,40,'09318467','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(77,40,'08838195','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(78,40,'08649875','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(79,40,'09084291','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(80,40,'08887539','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(81,41,'08644915','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(82,41,'08982723','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(83,41,'09006883','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(84,41,'08869171','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(85,41,'08670211','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(86,42,'08887843','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(87,42,'09028675','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(88,42,'09322291','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(89,42,'09322019','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(90,42,'08838435','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(91,43,'08806931','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(92,43,'09028947','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(93,43,'08668003','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(94,43,'08838179','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(95,43,'09270915','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(96,44,'08808675','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(97,44,'09318691','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(98,44,'08844355','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(99,44,'08957267','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(100,44,'09316387','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(101,45,'08959619','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(102,45,'08867875','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(103,45,'08833123','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(104,45,'08803891','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(105,45,'08869395','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(106,46,'08831059','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(107,46,'09320819','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(108,46,'08809155','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(109,46,'08644835','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(110,46,'08697219','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(111,47,'08840707','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(112,47,'08807155','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(113,47,'08867603','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(114,47,'08804739','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(115,47,'09322099','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(116,48,'08788947','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(117,48,'08889747','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(118,48,'08805843','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(119,48,'08809027','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(120,48,'08813267','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(121,49,'09032979','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(122,49,'09300243','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(123,49,'08959315','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(124,49,'08808371','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(125,49,'08815107','',0,'2021-09-11 18:56:14','2021-09-11 18:56:14'),(126,50,'08813123','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(127,50,'08812371','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(128,50,'08811075','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(129,51,'08828803','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(130,51,'08813315','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(131,51,'08790659','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(132,51,'09281139','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(133,51,'09084515','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(134,52,'08755219','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(135,52,'08578595','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(136,52,'09283139','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(137,52,'08700899','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(138,52,'08670227','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(139,53,'08883651','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(140,53,'08812531','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(141,53,'08828883','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(142,53,'08900611','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(143,53,'08885619','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(144,54,'08782755','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(145,54,'08757251','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(146,54,'08958963','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(147,54,'09316051','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(148,54,'08844675','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(149,55,'08889683','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(150,55,'08840323','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(151,55,'09304259','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(152,55,'09084451','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(153,55,'09304115','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(154,56,'08865555','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(155,56,'09300323','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(156,56,'08881811','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(157,56,'08814883','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(158,56,'08808259','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(159,57,'09316611','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(160,57,'08846499','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(161,57,'08790995','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(162,57,'08814931','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(163,57,'08807107','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(164,58,'08791123','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(165,58,'08842195','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(166,58,'08869539','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(167,58,'08788851','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(168,58,'08835395','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(169,59,'09287427','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(170,59,'09284691','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(171,59,'08803875','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(172,59,'08996291','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(173,59,'08667859','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(174,60,'08868083','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(175,60,'09314595','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(176,60,'08804115','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(177,60,'08814403','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(178,60,'09302451','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(179,61,'08804435','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(180,61,'08807011','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(181,61,'09082195','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(182,61,'08994147','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(183,61,'09003091','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(184,62,'08844723','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(185,62,'08868099','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(186,62,'09320899','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(187,62,'08774515','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(188,62,'12491376','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(189,63,'08791075','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(190,63,'09304355','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(191,63,'09000851','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(192,63,'08881939','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(193,63,'08838147','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(194,64,'08774435','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(195,64,'09285571','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(196,64,'08842963','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(197,64,'08577571','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(198,64,'09132163','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(199,65,'08959715','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(200,65,'08842147','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(201,65,'09314739','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(202,65,'08664163','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(203,65,'08883955','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(204,66,'08996051','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(205,66,'08846675','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(206,66,'09302131','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(207,66,'09000131','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(208,66,'08961043','',0,'2021-09-11 18:56:15','2021-09-11 18:56:15'),(209,67,'08840259','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(210,67,'09287571','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(211,67,'08668019','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(212,67,'09032835','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(213,67,'08842099','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(214,68,'09004691','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(215,68,'08804035','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(216,68,'09030867','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(217,68,'09321955','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(218,68,'08960851','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(219,69,'09030787','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(220,69,'08808547','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(221,69,'09320723','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(222,69,'08869155','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(223,69,'08806435','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(224,70,'08867107','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(225,70,'08865251','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(226,70,'08826851','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(227,70,'09032579','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(228,70,'08577523','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(229,71,'08700867','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(230,71,'09321699','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(231,71,'09320147','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(232,71,'08804515','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(233,71,'09085571','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(234,72,'09287251','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(235,72,'09321923','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(236,72,'09316627','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(237,72,'08701075','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(238,72,'08959283','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(239,73,'08813251','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(240,73,'08865363','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(241,73,'08784739','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(242,73,'09320915','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(243,73,'08991971','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(244,74,'09000195','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(245,74,'09299987','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(246,74,'08840771','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(247,74,'09028611','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(248,74,'08957763','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(249,75,'08807091','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(250,75,'09287059','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(251,75,'08695299','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(252,75,'09283123','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(253,75,'08867491','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(254,76,'09283283','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(255,76,'08842211','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(256,76,'08840435','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(257,76,'08883907','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(258,76,'09031011','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(259,77,'08863123','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(260,77,'08774243','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(261,77,'08668115','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(262,77,'09322083','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(263,77,'08665123','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(264,78,'09281027','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(265,78,'08665139','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(266,78,'08804723','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(267,78,'09283363','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(268,78,'08884035','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(269,79,'09320515','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(270,79,'08828899','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(271,79,'09285107','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(272,79,'09006963','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(273,79,'08958995','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(274,80,'09286835','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(275,80,'09300099','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(276,80,'09319987','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(277,80,'08804579','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(278,80,'08803955','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(279,81,'08961523','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(280,81,'08869459','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(281,81,'08998291','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(282,81,'09320019','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(283,81,'08838371','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(284,82,'08701171','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(285,82,'08807043','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(286,82,'09299939','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(287,82,'08957699','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(288,82,'09034835','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(289,83,'08814419','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(290,83,'08806579','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(291,83,'08844787','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(292,83,'08882131','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(293,83,'08889731','',0,'2021-09-11 18:56:16','2021-09-11 18:56:16'),(294,84,'09318451','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(295,84,'08867523','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(296,84,'08867155','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(297,84,'09318403','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(298,84,'08667827','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(299,85,'09082547','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(300,85,'08793123','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(301,85,'08881747','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(302,85,'08790931','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(303,85,'08887651','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(304,86,'08961427','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(305,86,'08576035','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(306,86,'08786963','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(307,86,'08772355','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(308,86,'08867283','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(309,87,'09316739','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(310,87,'09296339','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(311,87,'08814851','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(312,87,'09285171','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(313,87,'09322195','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(314,88,'09321651','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(315,88,'09304467','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(316,88,'08776339','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(317,88,'09039699','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(318,88,'09244963','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(319,89,'08806307','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(320,89,'09316451','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(321,89,'09318435','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(322,89,'08840403','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(323,89,'09004883','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(324,90,'08887795','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(325,90,'09032851','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(326,90,'09304483','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(327,90,'08760643','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(328,90,'08815139','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(329,91,'08809043','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(330,91,'08845091','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(331,91,'09008771','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(332,91,'08846739','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(333,91,'08789043','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(334,92,'08846691','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(335,92,'08816771','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(336,92,'08959763','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(337,92,'08808387','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(338,92,'09006915','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(339,93,'09296291','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(340,93,'08580867','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(341,93,'08998227','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(342,93,'08867315','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(343,93,'09272915','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(344,94,'08582627','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(345,94,'08838051','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(346,94,'09000883','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(347,94,'09315843','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(348,94,'09283411','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(349,95,'08992131','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(350,95,'09300147','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(351,95,'09034739','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(352,95,'09321891','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(353,95,'08838067','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(354,96,'08887699','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(355,96,'09302163','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(356,96,'08838355','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(357,96,'08879699','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(358,96,'08666083','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(359,97,'08666099','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(360,97,'08757299','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(361,97,'08846531','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(362,97,'08982787','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(363,97,'08987027','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(364,98,'08842259','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(365,98,'08701059','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(366,98,'09320771','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(367,98,'08883779','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(368,98,'08804355','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(369,99,'08844851','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(370,99,'09314579','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(371,99,'08982963','',0,'2021-09-11 18:56:17','2021-09-11 18:56:17'),(372,99,'09084275','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(373,99,'08813139','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(374,100,'08812979','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(375,100,'08786579','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(376,100,'08804259','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(377,100,'08668051','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(378,100,'08790899','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(379,101,'08667635','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(380,101,'09304179','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(381,101,'08840531','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(382,101,'08830915','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(383,101,'08840243','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(384,102,'08844595','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(385,102,'09004899','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(386,102,'09316579','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(387,102,'08788803','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(388,102,'09296243','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(389,103,'08812691','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(390,103,'09298147','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(391,103,'08869667','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(392,103,'09320179','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(393,103,'08577475','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(394,104,'09322307','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(395,104,'08810291','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(396,104,'08665171','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(397,104,'08881843','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(398,104,'08810531','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(399,105,'09316531','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(400,105,'08840083','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(401,105,'08867507','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(402,105,'08806371','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(403,105,'08806403','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(404,106,'09300419','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(405,106,'08838259','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(406,106,'08960867','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(407,106,'09315811','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(408,106,'08786723','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(409,107,'08806003','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(410,107,'08648851','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(411,107,'08959251','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(412,107,'09006931','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(413,107,'08887747','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(414,108,'08842899','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(415,108,'09007011','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(416,108,'08831091','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(417,108,'09283251','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(418,108,'09000227','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(419,109,'08959219','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(420,109,'09321811','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(421,109,'08961091','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(422,109,'08868003','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(423,109,'08844483','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(424,110,'08667795','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(425,110,'08884051','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(426,110,'09278915','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(427,110,'08961587','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18'),(428,110,'09321859','',0,'2021-09-11 18:56:18','2021-09-11 18:56:18');

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `no` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `function` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `age_limit` int NOT NULL,
  `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `gid` int NOT NULL,
  `budget_amount` int NOT NULL COMMENT '預算',
  `budget_year` int NOT NULL COMMENT '年度',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `prefix` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_gid_index` (`gid`),
  KEY `category_no_index` (`no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `category`
--


--
-- Table structure for table `central_weather_logs`
--

CREATE TABLE `central_weather_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `datetime` datetime NOT NULL COMMENT '日期時間',
  `county` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '地區',
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '資料類型',
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '資料值',
  `count` int NOT NULL COMMENT '查詢計數',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `central_weather_logs`
--


--
-- Table structure for table `central_weather_settings`
--

CREATE TABLE `central_weather_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設定名稱',
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設定代碼',
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設定值',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `central_weather_settings`
--

INSERT INTO `central_weather_settings` VALUES (1,'會員授權碼','key','','2021-08-11 11:26:48','0000-00-00 00:00:00'),(2,'端口','role','客戶端','2021-08-11 11:26:48','0000-00-00 00:00:00');

--
-- Table structure for table `charge_equipments`
--

CREATE TABLE `charge_equipments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `no` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '財產編號',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備名稱',
  `custodian_id` int NOT NULL COMMENT '保管人ID',
  `purchase` date NOT NULL COMMENT '取得日期',
  `costs` int NOT NULL COMMENT '成本',
  `age_limit` int NOT NULL COMMENT '年限',
  `placement` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '放置位置',
  `specification` text COLLATE utf8_unicode_ci NOT NULL COMMENT '規格',
  `cover_img` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備照片',
  `status` int NOT NULL COMMENT '狀態',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `charge_equipments`
--


--
-- Table structure for table `charge_logs`
--

CREATE TABLE `charge_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `command_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '流水號',
  `company_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '廠商代號',
  `device_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備代碼',
  `user_card_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '用戶卡號',
  `device_status` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備狀態',
  `charge_watt` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '千瓦小時',
  `finish_time` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '充電完成時間',
  `status` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `charge_logs`
--


--
-- Table structure for table `charge_orders`
--

CREATE TABLE `charge_orders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `charge_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '充電樁ID',
  `user_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '預約者ID',
  `select_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '選擇日期',
  `select_time` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '選擇時段',
  `status` int NOT NULL COMMENT '狀態',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `charge_orders`
--


--
-- Table structure for table `charge_times`
--

CREATE TABLE `charge_times` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '充電樁名稱',
  `cover_img` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '封面照片',
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '狀態',
  `point_use` int NOT NULL COMMENT '所需點數',
  `point_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '扣點類型',
  `rule` text COLLATE utf8_unicode_ci NOT NULL COMMENT '條款',
  `info` text COLLATE utf8_unicode_ci NOT NULL COMMENT '描述',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `charge_times`
--


--
-- Table structure for table `charges`
--

CREATE TABLE `charges` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '充電樁名稱',
  `cover_img` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '封面照片',
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '狀態',
  `point_use` int NOT NULL COMMENT '所需點數',
  `point_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '扣點類型',
  `orders_pre_days` int NOT NULL COMMENT '提前預約天數',
  `orders_one_day_flag` int NOT NULL COMMENT '預約單每日上限',
  `orders_one_day` int NOT NULL COMMENT '預約單每日限制數',
  `persons_one_day_flag` int NOT NULL COMMENT '每日使用人數上限',
  `persons_one_day` int NOT NULL COMMENT '每日使用人數限制數',
  `orders_one_user_one_day_flag` int NOT NULL COMMENT '每個用戶每日預約上限',
  `orders_one_user_one_day` int NOT NULL COMMENT '每個用戶每日預約上限限制數',
  `orders_by_today_flag` int NOT NULL COMMENT '是否限制當日不可預約',
  `time_section` text COLLATE utf8_unicode_ci NOT NULL COMMENT '營業時間',
  `each_section` text COLLATE utf8_unicode_ci NOT NULL COMMENT '設定時段',
  `rule` text COLLATE utf8_unicode_ci NOT NULL COMMENT '條款',
  `info` text COLLATE utf8_unicode_ci NOT NULL COMMENT '描述',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `charges`
--


--
-- Table structure for table `chicony_park_log`
--

CREATE TABLE `chicony_park_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `parking_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '車牌',
  `user_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '預約者',
  `guest_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '訪客',
  `start_time` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '開始時間',
  `end_time` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '結束時間',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `chicony_park_log`
--


--
-- Table structure for table `chicony_settings`
--

CREATE TABLE `chicony_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '名稱',
  `url` text COLLATE utf8_unicode_ci NOT NULL COMMENT '路徑',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `chicony_settings`
--

INSERT INTO `chicony_settings` VALUES (1,'設備異動','http://114.34.6.84/API/Device','2021-08-11 11:26:48','0000-00-00 00:00:00'),(2,'設備處份','http://114.34.6.84/API/DeviceX','2021-08-11 11:26:48','0000-00-00 00:00:00'),(3,'報修與回應','http://114.34.6.84/api/AlertEvent','2021-08-11 11:26:48','0000-00-00 00:00:00'),(4,'派工清單','http://114.34.6.84/api/TaskList','2021-08-11 11:26:48','0000-00-00 00:00:00'),(5,'維修紀錄','http://114.34.6.84/api/RepairRecord','2021-08-11 11:26:48','0000-00-00 00:00:00'),(6,'保養週期','http://114.34.6.84/api/Cycle','2021-08-11 11:26:48','0000-00-00 00:00:00'),(7,'排程清單','http://114.34.6.84/api/ScheduleList','2021-08-11 11:26:48','0000-00-00 00:00:00'),(8,'定保紀錄','http://114.34.6.84/api/MaintainRecord','2021-08-11 11:26:48','0000-00-00 00:00:00'),(9,'耗材類別異動','http://114.34.6.84/api/Consumables','2021-08-11 11:26:48','0000-00-00 00:00:00'),(10,'耗材存取','http://114.34.6.84/api/ConsumablesRecord','2021-08-11 11:26:48','0000-00-00 00:00:00'),(11,'管理員異動','http://114.34.6.84/api/Administrator','2021-08-11 11:26:48','0000-00-00 00:00:00'),(12,'廠商異動','http://114.34.6.84/api/Supplier','2021-08-11 11:26:48','0000-00-00 00:00:00'),(13,'承租戶異動','http://114.34.6.84/api/Tenant','2021-08-11 11:26:48','0000-00-00 00:00:00'),(14,'建物建立資產(帶電)','http://61.221.12.88:48203/setting/BuildingInformationModelings/api-check-device','2021-08-11 11:26:48','0000-00-00 00:00:00'),(15,'建物建立資產(不帶電)','http://61.221.12.88:48203/setting/BuildingInformationModelings/api-add-device ','2021-08-11 11:26:48','0000-00-00 00:00:00');

--
-- Table structure for table `communities`
--

CREATE TABLE `communities` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `fullname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name_en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fullname_en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cmc_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cmc_name_en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tel` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `district` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address_en` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `web_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `company_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_license` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_business_class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_industry_class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_build_time` date DEFAULT NULL,
  `company_charge` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_capital_registe` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `company_capital_paid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `builder_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `build_time` date DEFAULT NULL,
  `property_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `security_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `lot_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `door_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `base_area` double DEFAULT NULL,
  `building_area` double DEFAULT NULL,
  `built_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `floor_ground` int DEFAULT NULL,
  `floor_under` int DEFAULT NULL,
  `floor_area` double DEFAULT NULL,
  `ownership_unit` int DEFAULT NULL,
  `public_list` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `public_num` int DEFAULT NULL,
  `public_rate` double DEFAULT NULL,
  `parking_car` int DEFAULT NULL,
  `parking_car_m` int DEFAULT NULL,
  `parking_moto` int DEFAULT NULL,
  `img` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `communities`
--

INSERT INTO `communities` VALUES (1,'幸福璞園','新保科技範例專用系統社區','Sample Community',NULL,'範例社區管理委員會',NULL,'02-2314-1234','02-2311-4321',NULL,NULL,'台北市仁愛路123號','No 123, Ren\'ai Rd., Da\'an Dist., Taipei City, Taiwan (R.O.C.)',NULL,'sample@samplecom.com','台北市','新保科技有限公司','02-2356-7705','12345678','TP01231576','科技','科技','2015-11-01','楊坤昌','1000000','1000000','石頭建設股份有限公司','2016-11-12','全能物業管理','精實保全','板橋市國光段37號','板橋市中正路355巷42號1至9樓',668.44,437,'SRC造',13,2,8974,154,'游泳館、撞球室、籃球場、健身房、美食餐廳',10,13,130,10,20,'','2021-08-11 11:25:44','2021-09-11 18:16:10');

--
-- Table structure for table `community_images`
--

CREATE TABLE `community_images` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image_1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image_2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image_3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image_4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image_5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `community_images`
--

INSERT INTO `community_images` VALUES (1,'','','','','','2021-08-11 11:26:48','0000-00-00 00:00:00'),(2,'','','','','','2021-08-11 11:26:48','0000-00-00 00:00:00'),(3,'','','','','','2021-08-11 11:26:48','0000-00-00 00:00:00'),(4,'','','','','','2021-08-11 11:26:48','0000-00-00 00:00:00'),(5,'','','','','','2021-08-11 11:26:48','0000-00-00 00:00:00'),(6,'','','','','','2021-08-11 11:26:48','0000-00-00 00:00:00');

--
-- Table structure for table `community_settings`
--

CREATE TABLE `community_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `building_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `villa_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `case_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `newcase_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `official_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `facebook_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `life_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `food_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `hotel_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `alliance_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `news_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `house_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `line_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `project_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `teaching_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `management_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `activity_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `charitable_link` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `youtube_link_list` text COLLATE utf8_unicode_ci NOT NULL,
  `ad_image_link_list` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `community_settings`
--

INSERT INTO `community_settings` VALUES (1,'','','','','','','','','','','','','','','','','','','','','2021-08-11 11:26:48','0000-00-00 00:00:00');

--
-- Table structure for table `convinients`
--

CREATE TABLE `convinients` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cover_img` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `content` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `convinients`
--

INSERT INTO `convinients` VALUES (1,'統一發票','assets/images/1_11.png','https://www.einvoice.nat.gov.tw/','2016-06-08 11:46:50','2016-06-08 11:46:50','',NULL),(2,'台灣彩券','assets/images/1_11-14.png','http://www.taiwanlottery.com.tw/','2016-06-08 11:46:50','2016-06-08 11:46:50','',NULL),(3,'台灣郵局','assets/images/1_11-18.png','http://www.post.gov.tw/post/index.jsp','2016-06-08 11:46:50','2016-06-08 11:46:50','',NULL),(4,'農(萬)民曆','assets/images/1_11-19.png','http://time.rootinfo.com.tw/','2016-06-08 11:46:50','2016-06-08 11:46:50','',NULL),(5,'氣象資訊','assets/images/1_11-22.png','http://www.cwb.gov.tw/','2016-06-08 11:46:50','2016-06-08 11:46:50','',NULL),(6,'高鐵資訊','assets/images/1_11-23.png','http://www.thsrc.com.tw/index.html?force=1','2016-06-08 11:46:50','2016-06-08 11:46:50','',NULL),(7,'電影資訊','assets/images/1_11-26.png','http://tw.movie.yahoo.com/','2016-06-08 11:46:50','2016-06-08 11:46:50','',NULL),(8,'股票資訊','assets/images/1_11-27.png','http://tw.stock.yahoo.com/','2016-06-08 11:46:50','2016-06-08 11:46:50','',NULL),(9,'十二星座','assets/images/1_11-30.png','http://yahoo.click108.com.tw/','2016-06-08 11:46:50','2016-06-08 11:46:50','',NULL),(10,'影音blog','assets/images/1_11-31.png','http://www.youtube.com/?gl=TW&amp;hl=zh-TW','2016-06-08 11:46:50','2016-06-08 11:46:50','',NULL);

--
-- Table structure for table `costs`
--

CREATE TABLE `costs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `doorplate_id` int NOT NULL COMMENT '門牌代號',
  `user_id` int NOT NULL COMMENT '使用者代號',
  `ym` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '年月',
  `fee_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '費用類別',
  `payment` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '是否繳費',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `amount` int NOT NULL COMMENT '金額',
  `payment_date` date NOT NULL COMMENT '繳費日期',
  `void_date` date NOT NULL COMMENT '作廢日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `costs`
--


--
-- Table structure for table `cron_tabs`
--

CREATE TABLE `cron_tabs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `data_id` int NOT NULL,
  `level` int NOT NULL,
  `status` int NOT NULL,
  `run_time` datetime NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cron_tabs`
--


--
-- Table structure for table `data_bas`
--

CREATE TABLE `data_bas` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `sender` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `json` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `file` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `data_bas`
--


--
-- Table structure for table `data_weemas`
--

CREATE TABLE `data_weemas` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `info` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ip` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `data_weemas`
--


--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `principal` int NOT NULL,
  `project` text COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `no` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `departments_principal_index` (`principal`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `departments`
--


--
-- Table structure for table `device_config`
--

CREATE TABLE `device_config` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `normal_mins` int NOT NULL,
  `normal_active` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `late_mins` int NOT NULL,
  `late_active` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `early_mins` int NOT NULL,
  `early_active` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `off_mins` int NOT NULL,
  `off_active` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `ng_user_mins` int NOT NULL,
  `ng_user_active` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `ng_location_active` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `ng_location_mins` int NOT NULL,
  `ng_time_active` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `modifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `api_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `device_config`
--


--
-- Table structure for table `device_contrasts`
--

CREATE TABLE `device_contrasts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `device` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `device_contrasts`
--


--
-- Table structure for table `device_event`
--

CREATE TABLE `device_event` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `event_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `event_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int NOT NULL,
  `modifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `device_event_event_code_index` (`event_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `device_event`
--


--
-- Table structure for table `device_format`
--

CREATE TABLE `device_format` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `card_no` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `event_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `modifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `device_format_card_no_index` (`card_no`),
  KEY `device_format_event_code_index` (`event_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `device_format`
--


--
-- Table structure for table `device_items`
--

CREATE TABLE `device_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `route_id` int NOT NULL,
  `device_time` time NOT NULL,
  `location_id` int NOT NULL,
  `duty` int NOT NULL,
  `modifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `device_items`
--


--
-- Table structure for table `device_location`
--

CREATE TABLE `device_location` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `location` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `location_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int NOT NULL,
  `modifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `device_location_location_code_index` (`location_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `device_location`
--


--
-- Table structure for table `device_log`
--

CREATE TABLE `device_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `device_time` datetime NOT NULL,
  `location_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `event_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `user_card_no` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `modifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `remark` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `error` tinyint NOT NULL,
  `status` int NOT NULL,
  `item_id` int NOT NULL,
  `route_id` int NOT NULL,
  `right_time` datetime NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `device_log_location_code_index` (`location_code`),
  KEY `device_log_event_code_index` (`event_code`),
  KEY `device_log_user_card_no_index` (`user_card_no`),
  KEY `device_log_item_id_index` (`item_id`),
  KEY `device_log_route_id_index` (`route_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `device_log`
--


--
-- Table structure for table `device_off_log`
--

CREATE TABLE `device_off_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `route_id` int NOT NULL,
  `modifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `remark` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `off_time` datetime NOT NULL,
  `item_id` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `device_off_log_route_id_index` (`route_id`),
  KEY `device_off_log_item_id_index` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `device_off_log`
--


--
-- Table structure for table `device_records`
--

CREATE TABLE `device_records` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` double NOT NULL COMMENT '數值',
  `power` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '發電量',
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '類別',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `device_records`
--


--
-- Table structure for table `device_route`
--

CREATE TABLE `device_route` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `item` int NOT NULL,
  `route_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `sat_inc` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `sun_inc` varchar(1) COLLATE utf8_unicode_ci NOT NULL,
  `modifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `line_id` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `device_route_line_id_index` (`line_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `device_route`
--


--
-- Table structure for table `disposal_item`
--

CREATE TABLE `disposal_item` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `function` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `item` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `scrapped` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `disposal_item`
--


--
-- Table structure for table `document_files`
--

CREATE TABLE `document_files` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `document_id` int unsigned NOT NULL,
  `file` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `document_files`
--


--
-- Table structure for table `document_folders`
--

CREATE TABLE `document_folders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `info` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `document_folders`
--


--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `folder_id` int NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `info` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` int NOT NULL,
  `cover_img` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `documents`
--


--
-- Table structure for table `doorplates`
--

CREATE TABLE `doorplates` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `doorplate` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `floor` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `household` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `family` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tenant` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `manage_fee` int NOT NULL COMMENT '管理費',
  `bank_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '銀行客戶編號',
  `bank_account` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '銀行虛擬帳號',
  `clean_fee` int NOT NULL COMMENT '清潔費',
  `car_clean_fee` int NOT NULL COMMENT '汽車清潔費',
  `moto_clean_fee` int NOT NULL COMMENT '機車清潔費',
  `parking_fee` int NOT NULL COMMENT '停車費',
  `car_parking_fee` int NOT NULL COMMENT '汽車停車費',
  `moto_parking_fee` int NOT NULL COMMENT '機車停車費',
  `other_fee` int NOT NULL COMMENT '其他費',
  `payer` int NOT NULL COMMENT '是否繳費人',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `elec_mail` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '綁定信箱卡機',
  `memo` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status_parking` tinyint(1) NOT NULL DEFAULT '1',
  `parking_space` tinyint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `doorplates`
--

INSERT INTO `doorplates` VALUES (1,'22','1','1','1','G','22-1-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(2,'26','1','1','1','G','26-1-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(3,'28','1','1','1','G','28-1-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(4,'30','1','1','1','G','30-1-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(5,'32','1','1','1','G','32-1-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(6,'22','2','1','1','G','22-2-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(7,'26','2','1','1','G','26-2-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(8,'28','2','1','1','G','28-2-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(9,'30','2','1','1','G','30-2-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(10,'38','2','1','1','G','38-2-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(11,'22','3','1','1','G','22-3-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(12,'26','3','1','1','G','26-3-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(13,'28','3','1','1','G','28-3-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(14,'30','3','1','1','G','30-3-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(15,'32','3','1','1','G','32-3-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(16,'36','3','1','1','G','36-3-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(17,'38','3','1','1','G','38-3-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(18,'22','4','1','1','G','22-4-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(19,'26','4','1','1','G','26-4-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(20,'28','4','1','1','G','28-4-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(21,'30','4','1','1','G','30-4-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(22,'32','4','1','1','G','32-4-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(23,'36','4','1','1','G','36-4-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(24,'38','4','1','1','G','38-4-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(25,'22','5','1','1','G','22-5-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(26,'26','5','1','1','G','26-5-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(27,'28','5','1','1','G','28-5-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(28,'30','5','1','1','G','30-5-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(29,'32','5','1','1','G','32-5-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(30,'36','5','1','1','G','36-5-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(31,'38','5','1','1','G','38-5-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(32,'22','6','1','1','G','22-6-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(33,'26','6','1','1','G','26-6-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(34,'28','6','1','1','G','28-6-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(35,'30','6','1','1','G','30-6-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(36,'32','6','1','1','G','32-6-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(37,'36','6','1','1','G','36-6-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(38,'38','6','1','1','G','38-6-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(39,'22','7','1','1','G','22-7-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(40,'26','7','1','1','G','26-7-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(41,'28','7','1','1','G','28-7-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(42,'30','7','1','1','G','30-7-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(43,'32','7','1','1','G','32-7-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(44,'36','7','1','1','G','36-7-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(45,'38','7','1','1','G','38-7-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(46,'22','8','1','1','G','22-8-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(47,'26','8','1','1','G','26-8-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(48,'28','8','1','1','G','28-8-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(49,'30','8','1','1','G','30-8-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(50,'32','8','1','1','G','32-8-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(51,'36','8','1','1','G','36-8-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(52,'38','8','1','1','G','38-8-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(53,'22','9','1','1','G','22-9-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(54,'26','9','1','1','G','26-9-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(55,'28','9','1','1','G','28-9-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(56,'30','9','1','1','G','30-9-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(57,'32','9','1','1','G','32-9-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(58,'36','9','1','1','G','36-9-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(59,'38','9','1','1','G','38-9-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(60,'22','10','1','1','G','22-10-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(61,'26','10','1','1','G','26-10-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(62,'28','10','1','1','G','28-10-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(63,'30','10','1','1','G','30-10-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(64,'32','10','1','1','G','32-10-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(65,'36','10','1','1','G','36-10-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(66,'38','10','1','1','G','38-10-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(67,'22','11','1','1','G','22-11-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(68,'26','11','1','1','G','26-11-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(69,'28','11','1','1','G','28-11-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(70,'30','11','1','1','G','30-11-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(71,'32','11','1','1','G','32-11-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(72,'36','11','1','1','G','36-11-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(73,'38','11','1','1','G','38-11-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(74,'22','12','1','1','G','22-12-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(75,'26','12','1','1','G','26-12-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(76,'28','12','1','1','G','28-12-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(77,'30','12','1','1','G','30-12-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(78,'32','12','1','1','G','32-12-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(79,'36','12','1','1','G','36-12-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(80,'38','12','1','1','G','38-12-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(81,'22','13','1','1','G','22-13-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(82,'38','13','1','1','G','38-13-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(83,'22','14','1','1','G','22-14-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(84,'26','14','1','1','G','26-14-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(85,'30','14','1','1','G','30-14-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(86,'38','14','1','1','G','38-14-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0),(87,'36','1','1','1','G','36-1-1-1-G',0,'','',0,0,0,0,0,0,0,0,'2021-09-11 18:50:16','2021-09-11 18:50:16',1,'','',1,0);

--
-- Table structure for table `dorm_bed_logs`
--

CREATE TABLE `dorm_bed_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `dorm_id` int NOT NULL COMMENT '房間ID',
  `user_id` int NOT NULL COMMENT '帳號ID',
  `mode` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '模式 1.一般入住 2.一般退宿 3.換宿(入) 4.換宿(退) 5.臨時(入) 6.臨時(退)',
  `date` date NOT NULL COMMENT '日期',
  `memo` text COLLATE utf8_unicode_ci NOT NULL COMMENT '備註',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dorm_bed_logs`
--


--
-- Table structure for table `dorm_bed_settings`
--

CREATE TABLE `dorm_bed_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `dorm_id` int NOT NULL COMMENT '宿舍ID',
  `user_id` int NOT NULL COMMENT '帳號ID',
  `date` date NOT NULL COMMENT '入住日期',
  `bed_number` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '床位號',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dorm_bed_settings`
--


--
-- Table structure for table `dorm_btu_mappings`
--

CREATE TABLE `dorm_btu_mappings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` int NOT NULL COMMENT '房間ID',
  `facility_list` text COLLATE utf8_unicode_ci NOT NULL COMMENT '設備清單',
  `name_list` text COLLATE utf8_unicode_ci NOT NULL COMMENT '設備名稱清單',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dorm_btu_mappings`
--


--
-- Table structure for table `dorm_ele_mappings`
--

CREATE TABLE `dorm_ele_mappings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` int NOT NULL COMMENT '房間ID',
  `facility_list` text COLLATE utf8_unicode_ci NOT NULL COMMENT '設備清單',
  `name_list` text COLLATE utf8_unicode_ci NOT NULL COMMENT '設備名稱清單',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dorm_ele_mappings`
--


--
-- Table structure for table `dorm_ele_prices`
--

CREATE TABLE `dorm_ele_prices` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `start_year` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '起始年',
  `start_month` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '起始月',
  `end_year` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '結束年',
  `end_month` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '結束月',
  `price` double(8,2) NOT NULL COMMENT '費用',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dorm_ele_prices`
--


--
-- Table structure for table `dorm_tenants`
--

CREATE TABLE `dorm_tenants` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `number` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '房號',
  `dorm_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '宿舍類型',
  `category` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '宿舍分類',
  `area` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '校區',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '宿舍名稱',
  `total` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '房間人數',
  `cost` int NOT NULL COMMENT '管理費',
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '狀態',
  `user_list` text COLLATE utf8_unicode_ci NOT NULL COMMENT '住宿對應的帳號',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dorm_tenants`
--


--
-- Table structure for table `dorm_water_mappings`
--

CREATE TABLE `dorm_water_mappings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tenant_id` int NOT NULL COMMENT '房間ID',
  `facility_list` text COLLATE utf8_unicode_ci NOT NULL COMMENT '設備清單',
  `name_list` text COLLATE utf8_unicode_ci NOT NULL COMMENT '設備名稱清單',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dorm_water_mappings`
--


--
-- Table structure for table `dormitory_electricities`
--

CREATE TABLE `dormitory_electricities` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `device_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '1',
  `room_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '1',
  `peak` double NOT NULL COMMENT '1',
  `semi_peak` double NOT NULL COMMENT '1',
  `off_peak` double NOT NULL COMMENT '1',
  `year` int NOT NULL COMMENT '1',
  `month` int NOT NULL COMMENT '1',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dormitory_electricities`
--


--
-- Table structure for table `e_tags`
--

CREATE TABLE `e_tags` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `doorplate_id` int NOT NULL,
  `class` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '車輛類型(car汽車、moto機車)',
  `tag_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'ETag號碼',
  `parking_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '車牌號碼',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `e_tags`
--


--
-- Table structure for table `ehr_location`
--

CREATE TABLE `ehr_location` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `location` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `location_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int NOT NULL,
  `modifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ehr_location_location_code_index` (`location_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ehr_location`
--


--
-- Table structure for table `ehr_log`
--

CREATE TABLE `ehr_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ehr_time` datetime NOT NULL,
  `user_card_no` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `modifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ehr_log_user_card_no_index` (`user_card_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ehr_log`
--


--
-- Table structure for table `ehr_schedule`
--

CREATE TABLE `ehr_schedule` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `shift_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `status` int NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `rest_start_time` datetime NOT NULL,
  `rest_end_time` datetime NOT NULL,
  `user_id` int NOT NULL,
  `ehr_date` date NOT NULL,
  `modifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `first_time` datetime NOT NULL,
  `last_time` datetime NOT NULL,
  `work_minutes` int NOT NULL,
  `late_minutes` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ehr_schedule_shift_code_index` (`shift_code`),
  KEY `ehr_schedule_user_id_index` (`user_id`),
  KEY `ehr_schedule_ehr_date_index` (`ehr_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ehr_schedule`
--


--
-- Table structure for table `ehr_shift`
--

CREATE TABLE `ehr_shift` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `start_time` time NOT NULL,
  `end_time` time NOT NULL,
  `name` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `shift_code` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `modifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `work_minutes` int NOT NULL,
  `rest_start_time` time NOT NULL,
  `rest_end_time` time NOT NULL,
  `late_minutes` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ehr_shift_shift_code_index` (`shift_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ehr_shift`
--


--
-- Table structure for table `electric_fees`
--

CREATE TABLE `electric_fees` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tag_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `peak` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `semi_peak` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `off_peak` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `basic_fee` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `float_fee` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `modify_fee` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `year` int NOT NULL,
  `month` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `breeze_fee` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '微風額外換算',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `electric_fees`
--


--
-- Table structure for table `electric_mails`
--

CREATE TABLE `electric_mails` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `mailtype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '郵件種類',
  `mailnumber` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '郵件號碼',
  `mail_source` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '郵件來源',
  `mailsenddate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '郵件登錄日期',
  `mailsend` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '同mail_source',
  `mailgetdate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '郵件被領日期',
  `mailget` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '領取人id',
  `mailstate` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' COMMENT '郵件狀態 0未領取 1已領取 2已註銷 3已退信',
  `sign_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sign_image2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sms_send` int NOT NULL DEFAULT '0',
  `sms_log_id` int NOT NULL DEFAULT '0',
  `before_user_id` int NOT NULL COMMENT '郵件登錄的經手人id',
  `after_user_id` int NOT NULL COMMENT '郵件領取的經手人id',
  `rfid_card_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `groupid` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '家庭群發則在此欄位寫入',
  `mailbackdate` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '退信日期',
  `mail_image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '郵件照片',
  `photo_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `cause` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `box_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `info` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `electric_mails`
--


--
-- Table structure for table `electric_xls_imports`
--

CREATE TABLE `electric_xls_imports` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `facility_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `peak` double(8,2) NOT NULL,
  `semi_peak` double(8,2) NOT NULL,
  `off_peak` double(8,2) NOT NULL,
  `year` int NOT NULL,
  `month` int NOT NULL,
  `last` double(8,2) DEFAULT NULL,
  `checked` tinyint NOT NULL,
  `import_id` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `electric_xls_imports`
--


--
-- Table structure for table `electricity`
--

CREATE TABLE `electricity` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `year` varchar(4) COLLATE utf8_unicode_ci NOT NULL,
  `month` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `level` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
  `cost` double(8,2) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `electricity`
--

INSERT INTO `electricity` VALUES (1,'2018','1','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(2,'2018','1','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(3,'2018','1','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(4,'2018','1','4',3.79,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(5,'2018','1','5',4.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(6,'2018','1','6',4.83,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(7,'2018','2','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(8,'2018','2','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(9,'2018','2','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(10,'2018','2','4',3.79,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(11,'2018','2','5',4.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(12,'2018','2','6',4.83,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(13,'2018','3','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(14,'2018','3','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(15,'2018','3','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(16,'2018','3','4',3.79,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(17,'2018','3','5',4.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(18,'2018','3','6',4.83,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(19,'2018','4','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(20,'2018','4','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(21,'2018','4','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(22,'2018','4','4',3.94,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(23,'2018','4','5',4.60,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(24,'2018','4','6',5.03,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(25,'2018','5','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(26,'2018','5','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(27,'2018','5','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(28,'2018','5','4',3.94,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(29,'2018','5','5',4.60,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(30,'2018','5','6',5.03,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(31,'2018','6','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(32,'2018','6','2',2.38,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(33,'2018','6','3',3.52,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(34,'2018','6','4',4.80,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(35,'2018','6','5',5.66,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(36,'2018','6','6',6.41,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(37,'2018','7','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(38,'2018','7','2',2.38,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(39,'2018','7','3',3.52,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(40,'2018','7','4',4.80,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(41,'2018','7','5',5.66,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(42,'2018','7','6',6.41,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(43,'2018','8','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(44,'2018','8','2',2.38,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(45,'2018','8','3',3.52,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(46,'2018','8','4',4.80,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(47,'2018','8','5',5.66,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(48,'2018','8','6',6.41,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(49,'2018','9','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(50,'2018','9','2',2.38,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(51,'2018','9','3',3.52,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(52,'2018','9','4',4.80,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(53,'2018','9','5',5.66,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(54,'2018','9','6',6.41,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(55,'2018','10','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(56,'2018','10','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(57,'2018','10','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(58,'2018','10','4',3.94,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(59,'2018','10','5',4.60,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(60,'2018','10','6',5.03,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(61,'2018','11','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(62,'2018','11','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(63,'2018','11','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(64,'2018','11','4',3.94,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(65,'2018','11','5',4.60,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(66,'2018','11','6',5.03,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(67,'2018','12','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(68,'2018','12','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(69,'2018','12','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(70,'2018','12','4',3.94,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(71,'2018','12','5',4.60,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(72,'2018','12','6',5.03,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(73,'2017','1','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(74,'2017','1','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(75,'2017','1','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(76,'2017','1','4',3.79,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(77,'2017','1','5',4.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(78,'2017','1','6',4.83,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(79,'2017','2','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(80,'2017','2','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(81,'2017','2','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(82,'2017','2','4',3.79,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(83,'2017','2','5',4.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(84,'2017','2','6',4.83,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(85,'2017','3','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(86,'2017','3','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(87,'2017','3','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(88,'2017','3','4',3.79,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(89,'2017','3','5',4.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(90,'2017','3','6',4.83,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(91,'2017','4','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(92,'2017','4','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(93,'2017','4','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(94,'2017','4','4',3.79,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(95,'2017','4','5',4.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(96,'2017','4','6',4.83,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(97,'2017','5','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(98,'2017','5','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(99,'2017','5','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(100,'2017','5','4',3.79,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(101,'2017','5','5',4.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(102,'2017','5','6',4.83,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(103,'2017','6','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(104,'2017','6','2',2.38,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(105,'2017','6','3',3.52,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(106,'2017','6','4',4.61,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(107,'2017','6','5',5.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(108,'2017','6','6',6.13,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(109,'2017','7','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(110,'2017','7','2',2.38,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(111,'2017','7','3',3.52,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(112,'2017','7','4',4.61,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(113,'2017','7','5',5.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(114,'2017','7','6',6.13,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(115,'2017','8','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(116,'2017','8','2',2.38,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(117,'2017','8','3',3.52,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(118,'2017','8','4',4.61,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(119,'2017','8','5',5.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(120,'2017','8','6',6.13,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(121,'2017','9','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(122,'2017','9','2',2.38,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(123,'2017','9','3',3.52,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(124,'2017','9','4',4.61,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(125,'2017','9','5',5.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(126,'2017','9','6',6.13,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(127,'2017','10','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(128,'2017','10','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(129,'2017','10','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(130,'2017','10','4',3.79,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(131,'2017','10','5',4.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(132,'2017','10','6',4.83,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(133,'2017','11','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(134,'2017','11','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(135,'2017','11','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(136,'2017','11','4',3.79,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(137,'2017','11','5',4.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(138,'2017','11','6',4.83,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(139,'2017','12','1',1.63,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(140,'2017','12','2',2.10,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(141,'2017','12','3',2.89,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(142,'2017','12','4',3.79,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(143,'2017','12','5',4.42,'2021-08-11 11:26:48','2021-08-11 11:26:48'),(144,'2017','12','6',4.83,'2021-08-11 11:26:48','2021-08-11 11:26:48');

--
-- Table structure for table `electricity_energies`
--

CREATE TABLE `electricity_energies` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `device_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '設備代號',
  `room_no` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '宿舍號碼',
  `date` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '日期',
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '數值',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `electricity_energies`
--


--
-- Table structure for table `electricity_prices`
--

CREATE TABLE `electricity_prices` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `peak` double(8,2) NOT NULL,
  `semipeak` double(8,2) NOT NULL,
  `offpeak` double(8,2) NOT NULL,
  `summer_peak` double(8,2) NOT NULL,
  `summer_semipeak` double(8,2) NOT NULL,
  `summer_offpeak` double(8,2) NOT NULL,
  `status` int NOT NULL,
  `year` int NOT NULL,
  `month` int NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `electricity_prices`
--


--
-- Table structure for table `electro_mechanical_checklist`
--

CREATE TABLE `electro_mechanical_checklist` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `class` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `place` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `cost` int NOT NULL,
  `end_date` date NOT NULL,
  `number` int NOT NULL,
  `upload_user_id` int NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `electro_mechanical_checklist`
--


--
-- Table structure for table `electro_mechanical_checklist_fixlist`
--

CREATE TABLE `electro_mechanical_checklist_fixlist` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` smallint NOT NULL,
  `check_list_id` smallint NOT NULL,
  `situation` text COLLATE utf8_unicode_ci NOT NULL,
  `process` text COLLATE utf8_unicode_ci NOT NULL,
  `material` text COLLATE utf8_unicode_ci NOT NULL,
  `note` text COLLATE utf8_unicode_ci NOT NULL,
  `image1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sign_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `electro_mechanical_checklist_fixlist`
--


--
-- Table structure for table `electro_mechanical_checklist_report_data`
--

CREATE TABLE `electro_mechanical_checklist_report_data` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `check_list_id` int NOT NULL,
  `check_report_list_id` int NOT NULL,
  `question_number` tinyint NOT NULL,
  `answer` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `electro_mechanical_checklist_report_data`
--


--
-- Table structure for table `electro_mechanical_checklist_report_list`
--

CREATE TABLE `electro_mechanical_checklist_report_list` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` smallint NOT NULL,
  `check_list_id` smallint NOT NULL,
  `patrol_id` smallint NOT NULL,
  `list_number` int NOT NULL,
  `image1` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image2` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image3` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image4` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `image5` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sign_image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `patrol_datetime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `electro_mechanical_checklist_report_list`
--


--
-- Table structure for table `electro_mechanical_detail`
--

CREATE TABLE `electro_mechanical_detail` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `check_list_id` int NOT NULL,
  `question_number` tinyint NOT NULL,
  `question` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `tags` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `option1` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `option2` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `option3` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `option4` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `option5` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `status1` tinyint NOT NULL,
  `status2` tinyint NOT NULL,
  `status3` tinyint NOT NULL,
  `status4` tinyint NOT NULL,
  `status5` tinyint NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
