Maintenance fund multi-level account management method and system

Abstract

The invention relates to a maintenance fund multi-level account management method and a maintenance fund multi-level account management system, which are characterized in that a multi-level account database including an account table, a hierarchical structure table, a fund table and an association table is designed by taking level account opening and supporting a one-to-many relationship as purposes, and account management of multi-level structures such as units, communities, buildings, units, houses and the like is realized; a user carries out the steps of hierarchy selection, account information filling, individual account association, fund property selection, account opening determination and the like based on the multi-hierarchy account database, account opening is completed, and fund management and statistical analysis are carried out based on the multi-hierarchy account database. The account leveling gets rid of traditional upper and lower level limitation, supports independent account opening of any level and improves the service flexibility, the multi-level account database supports multiple fund properties and facilitates expansion of new services, and due to the one-to-many relation, funds with different purposes and properties can set different accounts in the system, and fine management is achieved.

Description

Technical Field

[0001] The present invention relates to the technical field of financial services, and in particular to a multi-level account management method and system for maintenance funds. Background Art

[0002] With the acceleration of urbanization, the complexity and sophistication of property management are becoming increasingly demanding. In particular, in terms of maintenance fund management, the traditional single account management model can no longer meet the needs of modern property management. Traditional maintenance fund management methods usually concentrate the funds of the entire community or building in one account, which is not flexible and efficient enough when facing complex structures such as large residential communities, multiple buildings, units and houses. Therefore, the industry urgently needs a maintenance fund management method that can support multi-level account structures and flexibly handle one-to-many relationships, so as to better track and manage maintenance funds at different levels.

[0003] In order to meet this challenge, for example, a Chinese patent with publication number CN107169754A discloses a maintenance fund management method, including: collecting information of residents in the community according to the property area and establishing a virtual account; when the bank deducts the money successfully, the receiving bank sends a maintenance fund update instruction, and the virtual account is updated according to the maintenance fund update instruction; when the collection is successful, the receiving bank sends a maintenance fund allocation instruction, and the virtual account is allocated according to the maintenance fund allocation instruction. The present invention ensures that the accounts in the virtual account are not bound to the bank, avoiding dependence on the bank to manage the virtual account, and can be closely associated with the bank's business, timely update and allocate the accounts in the virtual account, and can replace or increase bank cooperation at any time according to business development needs, thereby increasing business flexibility. However, the above invention is not flexible enough when dealing with complex property structures, does not support account management of one-to-many relationships, and cannot handle the situation where one sub-household corresponds to multiple accounts well; and is relatively simple in terms of detailed management of account information, mainly focusing on the update and allocation of funds, and fails to provide comprehensive account information management functions. Therefore, a flexible and efficient multi-level account management method for maintenance funds is urgently needed. Summary of the invention

[0004] In order to solve the above problems existing in the prior art, the present application provides a multi-level account management method and system for maintenance funds.

[0005] The technical solution of this application is as follows:

[0006] A maintenance fund multi-level account management method, the method comprising:

[0007] A multi-level account database is designed for the purpose of opening accounts at the same level and supporting one-to-many relationships. The multi-level account database includes an account table, a hierarchical structure table, a fund table and an association table, which are used to manage accounts in a multi-level structure, wherein the multi-level structure includes units, communities, buildings, units and houses; the account table is used to store basic information of accounts; the hierarchical structure table is used to record hierarchical relationships; the fund table is used to record fund properties and fund-related information; the association table is used to establish a one-to-many relationship and record the association between sub-accounts and accounts;

[0008] Based on the multi-level account database, an account opening process is designed; the user to open an account uses the account opening process to open an account, and performs fund management and statistical analysis on the account.

[0009] As a preferred implementation of the present invention, the basic information of the account includes the account number, account name, account subject and level corresponding code, and the fields of the account table include the account unique identifier account_id as the primary key, the account account_number, the account name account_name, the account subject account_owner and the level corresponding code account_code.

[0010] As a preferred embodiment of the present invention, the hierarchy includes unit level, community level, building level, unit level and house level, wherein the unit level is the highest level for managing maintenance funds; the community level is a sub-level under the unit; the building level is a sub-level under the community; the unit level is a sub-level under the building; the house level is a sub-level under the unit; the hierarchy levels are assigned from the highest level downward, the unit level is the first level, the community level is the second level, the building level is the third level, the unit level is the fourth level, and the house level is the fifth level;

[0011] The fields of the hierarchy table include the hierarchy unique identifier hierarchy_id as the primary key, the parent hierarchy IDparent_id as the foreign key, the hierarchy name hierarchy_name, and the hierarchy level hierarchy_level.

[0012] As a preferred embodiment of the present invention, the fund-related information includes a bank code, and the fields of the fund table include a fund record unique identifier fund_id as a primary key, account_id as a foreign key for associating an account table, fund nature fund_type, fund subject fund_owner, bank code bank_code, amount amount, and transaction date transaction_date.

[0013] As a preferred embodiment of the present invention, the fields of the association table include association_id, a unique identifier of the association record, as a primary key, and hierarchy_id and account_id, which are used as foreign keys to associate the hierarchy table with the account table.

[0014] As a preferred embodiment of the present invention, the account opening process includes selecting a level, filling in account information, associating sub-accounts, selecting the nature of funds, and confirming account opening, wherein:

[0015] The specific step of selecting a level is that the user enters the account opening interface, and the system displays a tree structure of the unit level, community level, building level, unit level and house level according to the multi-level account database. The user selects the corresponding level from the tree structure, and the system stores the unique identifier hierarchy_id of the level selected by the user into a temporary variable;

[0016] Filling in the account information specifically involves the system displaying an account information filling form according to the level selected by the user, and the user filling in the account number, account name, account subject and level corresponding code. The system verifies whether the filled in information is complete and valid. If the verification is passed, the system stores the information filled in by the user into a temporary variable;

[0017] Specifically, the associated sub-household is that the system displays a list of all sub-households of the level selected by the user, and the user selects an existing sub-household or creates a new sub-household. If the user selects an existing sub-household, the hierarchy_id, the unique identifier of the level corresponding to the selected existing sub-household, is stored in a temporary variable; if the user chooses to create a new sub-household, the user fills in the parent level ID parent_id, the level name hierarchy_name and the level hierarchy_level of the new sub-household, and stores them in a temporary variable;

[0018] The selection of fund nature is specifically that the system displays a fund nature selection form, and the user selects the corresponding fund information, including fund nature fund_type, fund subject fund_owner and bank code bank_code. The system records the fund information and associates it with the account table, and stores the fund information in a temporary variable;

[0019] To confirm account opening, the system summarizes and displays all the information filled in by the user for confirmation, and the user submits it after confirmation; the system executes the operation of updating the multi-level account database based on the information in the temporary variables.

[0020] As a preferred implementation of the present invention, the operation of updating the multi-level account database is specifically as follows:

[0021] The system inserts the account number, account name, account principal and level corresponding code filled in by the user into the account table and generates a new account_id;

[0022] If the user selects an existing sub-account, the system will associate the newly opened account with the existing sub-account in the hierarchy table according to the hierarchy unique identifier hierarchy_id corresponding to the selected existing sub-account; if the user chooses to create a new sub-account, the system will insert a new record in the hierarchy table, including the parent hierarchy ID, hierarchy name and hierarchy level corresponding to the new sub-account, and generate a new hierarchy_id;

[0023] The system inserts the new account_id, fund nature, fund subject and bank code into the fund table and generates a new fund_id;

[0024] If the user selects an existing sub-account, the system inserts the hierarchy_id and the new account_id of the selected sub-account into the association table and generates a new association_id; if the user chooses to create a new sub-account, the system inserts the new hierarchy_id and the new account_id into the association table and generates a new association_id;

[0025] The system updates the primary and foreign key relationships of all related tables in the multi-level account database.

[0026] The present invention also provides a multi-level account management system for maintenance funds, the system comprising a multi-level account database, an account opening process module, an account management module and a result display module, wherein:

[0027] The multi-level account database is used to store and manage account information of a multi-level structure, and the multi-level account database includes an account table, a hierarchical structure table, a fund table and an association table; the account table is used to store basic account information, including account number, account name, account subject and hierarchical corresponding code; the hierarchical structure table is used to record hierarchical relationships, and the hierarchies include unit level, community level, building level, unit level and house level; the fund table is used to record fund nature and bank code; the association table is used to establish a one-to-many relationship and record the association between sub-accounts and accounts;

[0028] The account opening process module is used to design and execute the account opening process, which includes selecting a level, filling in account information, associating sub-accounts, selecting the nature of funds, and confirming account opening;

[0029] The account management module is used to open accounts, manage funds and conduct statistical analysis based on the multi-level account database;

[0030] The result display module is used to display the results of account opening, fund management and statistical analysis.

[0031] The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, a maintenance fund multi-level account management method as described in any embodiment of the present invention is implemented.

[0032] The present invention also provides a computer-readable storage medium on which a computer program is stored. When the program is executed by a processor, a maintenance fund multi-level account management method as described in any embodiment of the present invention is implemented.

[0033] Compared with the prior art, the present invention has the following beneficial effects:

[0034] The present invention provides a multi-level account management method and system for maintenance funds. A multi-level account database is designed for the purpose of opening accounts at the same level and supporting one-to-many relationships. An account opening process is designed based on the multi-level account database. Users can flexibly select levels and sub-accounts through the account opening process, and the association of existing sub-accounts and the creation of new sub-accounts are supported. Account leveling gets rid of traditional upper and lower level restrictions, supports independent account opening at any level, and improves business flexibility. Fund management and statistical analysis are performed based on the multi-level account database. The fund table contained in the multi-level account database supports multiple fund properties, which is convenient for expanding new businesses. The one-to-many relationship enables funds of different purposes and properties to establish different accounts in the system, effectively manage maintenance funds, realize refined management, and improve management efficiency. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] Figure 1 It is a method flow chart of an embodiment of the present invention. DETAILED DESCRIPTION

[0036] The specific implementation modes of the present invention are described below so that those skilled in the art can understand the present invention. However, it should be clear that the present invention is not limited to the scope of the specific implementation modes. For those of ordinary skill in the art, as long as various changes are within the spirit and scope of the present invention as defined and determined by the attached claims, these changes are obvious, and all inventions and creations utilizing the concept of the present invention are protected.

[0037] The present invention provides the following technical solution: a maintenance fund multi-level account management method and system.

[0038] Embodiment 1:

[0039] like Figure 1 As shown, this embodiment provides a maintenance fund multi-level account management method, the method comprising:

[0040] S1. Design a multi-level account database for the purpose of opening accounts at the same level and supporting one-to-many relationships;

[0041] The multi-level account database includes an account table, a hierarchical structure table, a fund table and an association table, which are used to manage accounts in a multi-level structure; the multi-level structure includes units, communities, buildings, units and houses;

[0042] S11, Account table;

[0043] The account table is used to store basic information of the account;

[0044] The basic information of an account includes the account number, account name, account subject and level corresponding code. The fields of the account table include the account unique identifier account_id as the primary key, the account account account_number, the account name account_name, the account subject account_owner and the level corresponding code account_code;

[0045] The design of the account table is the basis for horizontal account opening. The account table stores the basic information of the account, including the account number, account name, account subject and level corresponding code. Each account is identified by a unique identifier account_id, which means that different accounts can coexist at the same level, realizing the horizontal relationship of accounts.

[0046] S12, hierarchical structure table;

[0047] The hierarchical structure table is used to record hierarchical relationships;

[0048] The levels include unit level, community level, building level, unit level and house level, wherein the unit level is the highest level for managing maintenance funds; the community level is a sub-level under the unit; the building level is a sub-level under the community; the unit level is a sub-level under the building; the house level is a sub-level under the unit; the level levels are assigned from the highest level downwards, the unit level is the first level, the community level is the second level, the building level is the third level, the unit level is the fourth level, and the house level is the fifth level;

[0049] The fields of the hierarchy table include the hierarchy unique identifier hierarchy_id as the primary key, the parent hierarchy IDparent_id as the foreign key, the hierarchy name hierarchy_name and the hierarchy level hierarchy_level;

[0050] The hierarchical structure table records the relationship between hierarchies. Through the parent_id field, a hierarchy (such as a community) can be associated with multiple sub-hierarchies (such as buildings) under it, realizing a one-to-many hierarchical relationship.

[0051] S13, Funds table;

[0052] The fund table is used to record the nature of funds and fund related information;

[0053] Fund-related information includes bank code. The fields of the fund table include fund_id, the unique identifier of fund records as the primary key, account_id, which is used as a foreign key to associate with the account table, fund nature fund_type, fund subject fund_owner, bank code bank_code, amount amount, and transaction date transaction_date;

[0054] Furthermore, the nature of the funds includes commercial housing maintenance funds, sold public housing maintenance funds, community public revenue funds and other types of funds, the bank code is the information of the handling bank, and the subject of the funds includes legal persons and individuals;

[0055] S14, association table;

[0056] The association table is used to establish a one-to-many relationship and record the association between sub-accounts and accounts;

[0057] The fields of the association table include association_id, the unique identifier of the association record, which is the primary key, and hierarchy_id and account_id, which are used as foreign keys to associate the hierarchy table and the account table. One sub-account can be associated with multiple accounts, thus realizing a one-to-many relationship between sub-accounts and accounts.

[0058] S2. Designing an account opening process based on the multi-level account database;

[0059] The account opening process includes selecting the level, filling in the account information, associating the sub-accounts, selecting the nature of funds and confirming the account opening, among which:

[0060] S21. Selecting a level specifically means that the user enters the account opening interface, and the system displays a tree structure of the unit level, community level, building level, unit level and house level according to the multi-level account database. The user selects the corresponding level from the tree structure, and the system stores the unique identifier hierarchy_id of the level selected by the user into a temporary variable. The level relationship between accounts is not involved in the level selection process, thereby ensuring the equal relationship between accounts;

[0061] S22. Fill in the account information. Specifically, the system displays an account information filling form according to the level selected by the user. The user fills in the account number, account name, account subject and level corresponding code. The system verifies whether the filled information is complete and valid. If the verification is passed, the system stores the information filled in by the user into a temporary variable. This information is stored in the account table, and each account is stored at the same level at the same level.

[0062] S23, the associated sub-household is specifically that the system displays a list of all sub-households of the level selected by the user, and the user selects an existing sub-household or creates a new sub-household. If the user selects an existing sub-household, the hierarchy_id corresponding to the selected existing sub-household is stored in a temporary variable; if the user chooses to create a new sub-household, the user fills in the parent level ID parent_id, the level name hierarchy_name and the level hierarchy_level of the new sub-household, and stores them in a temporary variable, thus realizing a one-to-many association relationship;

[0063] S24, the selection of fund nature is specifically that the system displays a fund nature selection form, and the user selects corresponding fund information, including fund nature fund_type, fund subject fund_owner and bank code bank_code. The system records the fund information and associates it with the account table, and stores the fund information in a temporary variable;

[0064] S25. Specifically, the system summarizes and displays all the information filled in by the user for confirmation, and the user submits the information after confirmation. The system updates the multi-level account database according to the information in the temporary variable.

[0065] S251. The system inserts the account number, account name, account subject and level corresponding code filled in by the user into the account table, and generates a new account_id;

[0066] S252. If the user selects an existing sub-account, the system associates the newly opened account with the existing sub-account in the hierarchy table according to the hierarchy unique identifier hierarchy_id corresponding to the selected existing sub-account; if the user chooses to create a new sub-account, the system inserts a new record in the hierarchy table, including the parent hierarchy ID, hierarchy name and hierarchy level corresponding to the new sub-account, and generates a new hierarchy_id, thus realizing a one-to-many hierarchical relationship;

[0067] S253. The system inserts a new account_id, fund nature, fund subject and bank code into the fund table, and generates a new fund_id;

[0068] S254. If the user selects an existing sub-account, the system inserts the hierarchy_id and the new account_id of the selected existing sub-account into the association table, and generates a new association_id; if the user chooses to create a new sub-account, the system inserts the new hierarchy_id and the new account_id into the association table, and generates a new association_id, thus realizing a one-to-many hierarchical relationship;

[0069] S255. The system updates the primary key and foreign key relationships of all related tables in the multi-level account database.

[0070] Embodiment 2:

[0071] This embodiment provides a multi-level account management system for maintenance funds, the system comprising a multi-level account database, an account opening process module, an account management module and a result display module, wherein:

[0072] The multi-level account database is used to store and manage account information of a multi-level structure, and the multi-level account database includes an account table, a hierarchical structure table, a fund table and an association table; the account table is used to store basic account information, including account number, account name, account subject and hierarchical corresponding code; the hierarchical structure table is used to record hierarchical relationships, and the hierarchies include unit level, community level, building level, unit level and house level; the fund table is used to record fund nature and bank code; the association table is used to establish a one-to-many relationship and record the association between sub-accounts and accounts;

[0073] The account opening process module is used to design and execute the account opening process, which includes selecting a level, filling in account information, associating sub-accounts, selecting the nature of funds, and confirming account opening;

[0074] The account management module is used to open accounts, manage funds and conduct statistical analysis based on the multi-level account database;

[0075] The result display module is used to display the results of account opening, fund management and statistical analysis.

[0076] Embodiment 3:

[0077] The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, a maintenance fund multi-level account management method as described in Embodiment 1 of the present invention is implemented;

[0078] Embodiment 4:

[0079] The present invention also provides a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements a multi-level account management method for maintenance funds as described in Embodiment 1 of the present invention.

[0080] The above descriptions are merely embodiments of the present invention and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention specification and drawings, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.

Claims

1. A maintenance fund multi-level account management method, characterized in that: The method comprises: A multi-level account database is designed for the purpose of opening accounts at the same level and supporting one-to-many relationships. The multi-level account database includes an account table, a hierarchical structure table, a fund table and an association table, which are used to manage accounts in a multi-level structure, wherein the multi-level structure includes units, communities, buildings, units and houses; the account table is used to store basic information of accounts; the hierarchical structure table is used to record hierarchical relationships; the fund table is used to record fund properties and fund-related information; the association table is used to establish a one-to-many relationship and record the association between sub-accounts and accounts; Based on the multi-level account database, an account opening process is designed; the user to open an account uses the account opening process to open an account, and performs fund management and statistical analysis on the account.

2. A maintenance fund multi-level account management method according to claim 1, characterized in that: The basic information of an account includes the account number, account name, account principal and level corresponding code. The fields of the account table include the account unique identifier account_id as the primary key, the account account account_number, the account name account_name, the account principal account_owner and the level corresponding code account_code.

3. A maintenance fund multi-level account management method according to claim 2, characterized in that: The levels include unit level, community level, building level, unit level and house level, wherein the unit level is the highest level for managing maintenance funds; the community level is a sub-level under the unit; the building level is a sub-level under the community; the unit level is a sub-level under the building; the house level is a sub-level under the unit; the level levels are assigned from the highest level downwards, the unit level is the first level, the community level is the second level, the building level is the third level, the unit level is the fourth level, and the house level is the fifth level; The fields of the hierarchy table include the hierarchy unique identifier hierarchy_id as the primary key, the parent hierarchy IDparent_id as the foreign key, the hierarchy name hierarchy_name, and the hierarchy level hierarchy_level.

4. A maintenance fund multi-level account management method according to claim 3, characterized in that: Fund-related information includes the bank code. The fields of the fund table include the fund record unique identifier fund_id as the primary key, account_id used as a foreign key to associate with the account table, fund nature fund_type, fund subject fund_owner, bank code bank_code, amount amount, and transaction date transaction_date.

5. A maintenance fund multi-level account management method according to claim 4, characterized in that: The fields of the association table include association_id, the unique identifier of the association record, as the primary key, and hierarchy_id and account_id, which are used as foreign keys to associate the hierarchy table with the account table.

6. A maintenance fund multi-level account management method according to claim 5, characterized in that: The account opening process includes selecting the level, filling in the account information, associating the sub-accounts, selecting the nature of funds and confirming the account opening, among which: The specific step of selecting a level is that the user enters the account opening interface, and the system displays a tree structure of the unit level, community level, building level, unit level and house level according to the multi-level account database. The user selects the corresponding level from the tree structure, and the system stores the unique identifier hierarchy_id of the level selected by the user into a temporary variable; Filling in the account information specifically involves the system displaying an account information filling form according to the level selected by the user, and the user filling in the account number, account name, account subject and level corresponding code. The system verifies whether the filled in information is complete and valid. If the verification is passed, the system stores the information filled in by the user into a temporary variable; Specifically, the associated sub-household is that the system displays a list of all sub-households of the level selected by the user, and the user selects an existing sub-household or creates a new sub-household. If the user selects an existing sub-household, the hierarchy_id, the unique identifier of the level corresponding to the selected existing sub-household, is stored in a temporary variable; if the user chooses to create a new sub-household, the user fills in the parent level ID parent_id, the level name hierarchy_name and the level hierarchy_level of the new sub-household, and stores them in a temporary variable; The selection of fund nature is specifically that the system displays a fund nature selection form, and the user selects the corresponding fund information, including fund nature fund_type, fund subject fund_owner and bank code bank_code. The system records the fund information and associates it with the account table, and stores the fund information in a temporary variable; To confirm account opening, the system summarizes and displays all the information filled in by the user for confirmation, and the user submits it after confirmation; the system executes the operation of updating the multi-level account database based on the information in the temporary variables.

7. A maintenance fund multi-level account management method according to claim 6, characterized in that: The operation of updating the multi-level account database is specifically as follows: The system inserts the account number, account name, account principal and level corresponding code filled in by the user into the account table and generates a new account_id; If the user selects an existing sub-account, the system will associate the newly opened account with the existing sub-account in the hierarchy table according to the hierarchy_id corresponding to the selected existing sub-account; If the user chooses to create a new sub-account, the system inserts a new record into the hierarchy table, including the parent hierarchy ID, hierarchy name and hierarchy level corresponding to the new sub-account, and generates a new hierarchy_id; The system inserts the new account_id, fund nature, fund subject and bank code into the fund table and generates a new fund_id; If the user selects an existing sub-account, the system inserts the hierarchy_id and the new account_id of the selected sub-account into the association table and generates a new association_id; if the user chooses to create a new sub-account, the system inserts the new hierarchy_id and the new account_id into the association table and generates a new association_id; The system updates the primary and foreign key relationships of all related tables in the multi-level account database.

8. A multi-level account management system for maintenance funds, characterized in that: The system includes a multi-level account database, an account opening process module, an account management module and a result display module, wherein: The multi-level account database is used to store and manage account information of a multi-level structure, and the multi-level account database includes an account table, a hierarchical structure table, a fund table and an association table; the account table is used to store basic account information, including account number, account name, account subject and hierarchical corresponding code; the hierarchical structure table is used to record hierarchical relationships, and the hierarchies include unit level, community level, building level, unit level and house level; the fund table is used to record fund nature and bank code; the association table is used to establish a one-to-many relationship and record the association between sub-accounts and accounts; The account opening process module is used to design and execute the account opening process, which includes selecting a level, filling in account information, associating sub-accounts, selecting the nature of funds, and confirming account opening; The account management module is used to open accounts, manage funds and conduct statistical analysis based on the multi-level account database; The result display module is used to display the results of account opening, fund management and statistical analysis.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the program, a maintenance fund multi-level account management method as described in any one of claims 1 to 7 is implemented.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the program is executed by a processor, a maintenance fund multi-level account management method as described in any one of claims 1 to 7 is implemented.

Images