其实不要那么多表的--简洁利器

select table_name,COLUMN_NAME from information_schema.columns where table_schema='miniyun';
+----------------------------+------------------+
| table_name                 | COLUMN_NAME      |
+----------------------------+------------------+
| miniyun_access_logs        | id               |
| miniyun_access_logs        | namespace        |
| miniyun_access_logs        | start_time       |
| miniyun_access_logs        | end_time         |
| miniyun_access_logs        | appliction_id    |
| miniyun_access_logs        | use_time         |
| miniyun_access_logs        | created_at       |
| miniyun_access_logs        | updated_at       |
| miniyun_auth_codes         | code             |
| miniyun_auth_codes         | client_id        |
| miniyun_auth_codes         | redirect_uri     |
| miniyun_auth_codes         | expires          |
| miniyun_auth_codes         | scope            |
| miniyun_auth_codes         | created_at       |
| miniyun_auth_codes         | updated_at       |
| miniyun_clients            | id               |
| miniyun_clients            | user_id          |
| miniyun_clients            | client_name      |
| miniyun_clients            | client_id        |
| miniyun_clients            | client_secret    |
| miniyun_clients            | redirect_uri     |
| miniyun_clients            | enabled          |
| miniyun_clients            | description      |
| miniyun_clients            | created_at       |
| miniyun_clients            | updated_at       |
| miniyun_error_logs         | id               |
| miniyun_error_logs         | namespace        |
| miniyun_error_logs         | memo             |
| miniyun_error_logs         | appliction_id    |
| miniyun_error_logs         | created_at       |
| miniyun_error_logs         | updated_at       |
| miniyun_events             | id               |
| miniyun_events             | user_id          |
| miniyun_events             | user_device_id   |
| miniyun_events             | action           |
| miniyun_events             | file_path        |
| miniyun_events             | context          |
| miniyun_events             | event_uuid       |
| miniyun_events             | created_at       |
| miniyun_events             | updated_at       |
| miniyun_events             | type             |
| miniyun_file_exifs         | id               |
| miniyun_file_exifs         | version_id       |
| miniyun_file_exifs         | latitude         |
| miniyun_file_exifs         | longtitude       |
| miniyun_file_exifs         | exif             |
| miniyun_file_exifs         | created_at       |
| miniyun_file_exifs         | updated_at       |
| miniyun_file_metas         | id               |
| miniyun_file_metas         | file_path        |
| miniyun_file_metas         | meta_key         |
| miniyun_file_metas         | meta_value       |
| miniyun_file_metas         | created_at       |
| miniyun_file_metas         | updated_at       |
| miniyun_file_star          | id               |
| miniyun_file_star          | user_id          |
| miniyun_file_star          | file_id          |
| miniyun_file_star          | created_at       |
| miniyun_file_star          | updated_at       |
| miniyun_file_tags          | id               |
| miniyun_file_tags          | file_id          |
| miniyun_file_tags          | tag_id           |
| miniyun_file_version_metas | id               |
| miniyun_file_version_metas | version_id       |
| miniyun_file_version_metas | meta_key         |
| miniyun_file_version_metas | meta_value       |
| miniyun_file_version_metas | created_at       |
| miniyun_file_version_metas | updated_at       |
| miniyun_file_versions      | id               |
| miniyun_file_versions      | file_signature   |
| miniyun_file_versions      | file_size        |
| miniyun_file_versions      | block_ids        |
| miniyun_file_versions      | ref_count        |
| miniyun_file_versions      | mime_type        |
| miniyun_file_versions      | created_at       |
| miniyun_file_versions      | updated_at       |
| miniyun_files              | id               |
| miniyun_files              | user_id          |
| miniyun_files              | file_type        |
| miniyun_files              | parent_file_id   |
| miniyun_files              | file_create_time |
| miniyun_files              | file_update_time |
| miniyun_files              | file_name        |
| miniyun_files              | version_id       |
| miniyun_files              | file_size        |
| miniyun_files              | file_path        |
| miniyun_files              | event_uuid       |
| miniyun_files              | is_deleted       |
| miniyun_files              | mime_type        |
| miniyun_files              | created_at       |
| miniyun_files              | updated_at       |
| miniyun_files              | sort             |
| miniyun_migration          | version          |
| miniyun_migration          | apply_time       |
| miniyun_migration          | module           |
| miniyun_migration          | created_at       |
| miniyun_migration          | updated_at       |
| miniyun_online_devices     | id               |
| miniyun_online_devices     | user_id          |
| miniyun_online_devices     | device_id        |
| miniyun_online_devices     | application_id   |
| miniyun_online_devices     | created_at       |
| miniyun_online_devices     | updated_at       |
| miniyun_options            | option_id        |
| miniyun_options            | option_name      |
| miniyun_options            | option_value     |
| miniyun_options            | created_at       |
| miniyun_options            | updated_at       |
| miniyun_pv                 | id               |
| miniyun_pv                 | current_date     |
| miniyun_pv                 | application_id   |
| miniyun_pv                 | hour_period      |
| miniyun_pv                 | namespace        |
| miniyun_pv                 | use_count        |
| miniyun_pv                 | use_time         |
| miniyun_pv                 | created_at       |
| miniyun_pv                 | updated_at       |
| miniyun_refresh_token      | client_id        |
| miniyun_refresh_token      | oauth_token      ------------------------------|
| miniyun_refresh_token      | refresh_token    |
| miniyun_refresh_token      | expires          |
| miniyun_refresh_token      | created_at       |
| miniyun_refresh_token      | updated_at       |
| miniyun_share_files        | id               |
| miniyun_share_files        | share_key        |
| miniyun_share_files        | file_id          |
| miniyun_share_files        | expires          |
| miniyun_share_files        | password         |
| miniyun_share_files        | down_count       |
| miniyun_share_files        | created_at       |
| miniyun_share_files        | updated_at       |
| miniyun_stor_logs          | id               |
| miniyun_stor_logs          | stor_id          |
| miniyun_stor_logs          | content          |
| miniyun_stor_logs          | created_at       |
| miniyun_stor_logs          | updated_at       |
| miniyun_stors              | id               |
| miniyun_stors              | name             |
| miniyun_stors              | status           |
| miniyun_stors              | run_status       |
| miniyun_stors              | ip               |
| miniyun_stors              | port             |
| miniyun_stors              | load             |
| miniyun_stors              | weight           |
| miniyun_stors              | path             |
| miniyun_stors              | token            |
| miniyun_stors              | last_event       |
| miniyun_stors              | last_time        |
| miniyun_stors              | created_at       |
| miniyun_stors              | updated_at       |
| miniyun_system_upgrades    | id               |
| miniyun_system_upgrades    | version          |
| miniyun_system_upgrades    | name             |
| miniyun_system_upgrades    | client_type      |
| miniyun_system_upgrades    | signature        |
| miniyun_system_upgrades    | size             |
| miniyun_system_upgrades    | path             |
| miniyun_system_upgrades    | files_count      |
| miniyun_system_upgrades    | logs             |
| miniyun_system_upgrades    | extensions       |
| miniyun_system_upgrades    | created_at       |
| miniyun_system_upgrades    | updated_at       |
| miniyun_tags               | id               |
| miniyun_tags               | user_id          |
| miniyun_tags               | name             |
| miniyun_tokens             | oauth_token  ----------------------------    |
| miniyun_tokens             | client_id        |
| miniyun_tokens             | device_id        |
| miniyun_tokens             | expires          |
| miniyun_tokens             | scope            |
| miniyun_tokens             | created_at       |
| miniyun_tokens             | updated_at       |
| miniyun_user_devices       | id               |
| miniyun_user_devices       | user_device_uuid |
| miniyun_user_devices       | user_id          |
| miniyun_user_devices       | user_device_type |
| miniyun_user_devices       | user_device_name |
| miniyun_user_devices       | user_device_info |
| miniyun_user_devices       | created_at       |
| miniyun_user_devices       | updated_at       |
| miniyun_user_devices_metas | id               |
| miniyun_user_devices_metas | user_id          |
| miniyun_user_devices_metas | device_id        |
| miniyun_user_devices_metas | meta_name        |
| miniyun_user_devices_metas | meta_value       |
| miniyun_user_devices_metas | created_at       |
| miniyun_user_devices_metas | updated_at       |
| miniyun_user_metas         | id               |
| miniyun_user_metas         | user_id          |
| miniyun_user_metas         | meta_key         |
| miniyun_user_metas         | meta_value       |
| miniyun_user_metas         | created_at       |
| miniyun_user_metas         | updated_at       |
| miniyun_user_privilege     | id               |
| miniyun_user_privilege     | user_id          |
| miniyun_user_privilege     | file_path        |
| miniyun_user_privilege     | permission       |
| miniyun_user_privilege     | created_at       |
| miniyun_user_privilege     | updated_at       |
|
  miniyun_users              | id               |
| miniyun_users              | user_uuid        |
| miniyun_users              | user_name        |
| miniyun_users              | user_pass        |
| miniyun_users              | user_status      |
| miniyun_users              | salt             |
| miniyun_users              | created_at       |
| miniyun_users              | updated_at       |
| miniyun_versions           | id               |
| miniyun_versions           | app_type         |
| miniyun_versions           | previous_version |
| miniyun_versions           | last_version     |
| miniyun_versions           | packages         |
| miniyun_versions           | requirements     |
| miniyun_versions           | upgrade_info     |
| miniyun_versions           | release_at       |
| miniyun_versions           | created_at       |
| miniyun_versions           | updated_at       |
+----------------------------+------------------+