Powerful user management system database structure

It takes nearly one day for users to Manage System databases.
The purpose of this system is to facilitate future projects, because I plan to open up as many interfaces as possible in this system, and also create supporting server controls, although I do not want to provide convenience for all projects as my own set of standards, I think it will be of great help for me to develop any system in the future, after all, you only need simple settings and interfaces to facilitate system integration with any open interfaces.

In addition, I plan to refer to the membership practice to create a database as needed when users use the controls we provide or enable this system.

The approximate function can be seen from the first configuration table. Simply put, it meets user functions such as dating, commerce, forums, and blogs.

Complete library interface analysis file download data library structure .rar

The following are the configuration tables and other table names I posted. You can approve them and modify them based on your suggestions.
========= System settings ==============================
System configuration information [thc_config]
Sysname system name
Systitle system title
Sysurl system address
Insertdir system installation directory
Syslogo System logo
Is register open for registration?
Pass_vali password verification expression (if it is null, it cannot be verified. It can be set to contain numbers, letters, or special characters)
Uid_vali registration ID verification expression (same as above)
Whether reg_Auditing must be approved
Auditing_wise review method (1-Manual by the Administrator, 2-Email verification code, 3-Other Verification codes). You can select multiple verification codes here.
Reg_role: the role to which the first registration belongs-must be enabled
Class_if whether to enable user group
Reg_class first registered user group
Type_if whether to enable user type
Type of the first registered user
Int_if whether to enable point management (if enabled, you must set point items and then set points Rules)
Validate_ply whether verification code is enabled
Validate_type verification code type (Chinese characters, numbers, letters, and mixture)
Can changQA change the password?
Getpass password retrieval method (1-email, 2-direct display, 3-set new password)
Whether changscs allow security code modification
Can changnamg modify the real name?
Img_storage profile picture storage method, 1 for address storage, 2 for binary code storage
Img_size image size limit
Img_type: saves data in gif, jpg, bmp, and png formats.
Interest_if enable interests
Ip_strategy access rules (1-only allowed, 2-not allowed) operate on IP addresses in the IP table
Commonly_ip reserved time for access records of common users (if this time is exceeded, all records other than the last three days will be deleted)
Role_ip enables access operation records for specific roles
Role_ip_clear the retention time of access records of a specific role (if this time is exceeded, all access records other than the last three days will be deleted)
Whether the User Friend function is enabled for friend_if
How many groups can a friend_group user create?
Sms_if whether to enable short message
Sms_num size of each inbox

========= User information ==============================
User Data Base table [thc_user_main]
User information Details table [thc_user_detail]
User contact address table [thc_user_address] -- set up for the E-commerce system
Interest category table [thc_user_interest_name]
User interests table [thc_user_interest]

========== Various points ============
Point name table [thc_integral_name]
User point table [thc_integral]
Point redemption policy [thc_int_exchange]
Daily integral operation policy [thc_int_daily]

======= Permission control ============================
User Group name [thc_user_class]
User Type name [thc_user_type]
Role permission table [thc_role]
Role-single-user permission table [thc_role_user]
Role-group permission table [thc_role_class]
Role-type permission table [thc_role_class

============================================
Ip address access restriction table [thc_ip]
Common user access record table [thc_commonly_ip]
User Access record of a specific role [thc_role_security]

====================================================
User Group defined by the member [thc_friend_group]
Friend table between members [thc_friend]

=============== Favorites =================================
Name of the favorites type [thc_favorite_name]
Favorite list [thc_favorite]

=============== Short Message ==================================

In order to be able to get more experts and give me some advice, I will go to the home page and withdraw it at noon tomorrow. I hope DUDU will be ready.
Let's make suggestions and try to make things that completely replace membership and are practical. Thank you.