A codeless platform database physical table mapping management method and system

Abstract

The application discloses a code-free platform database physical table mapping management method and system, and relates to the technical field of database management in a code-free development platform.The method comprises the following steps: establishing four-layer mapping relationships of a workspace to a database, a database to a schema, a data table to a physical table, and a field to a physical column; creating a physical table by taking a data table unique identifier as a physical table name when a data table is created, and recording the mapping of a user visible name and a physical table name; adding a column by taking a field unique identifier as a physical column name when a field is created, and recording the mapping of a user visible name and a physical column name; only updating the user visible name in metadata when a user renames; constructing a query statement according to the mapping relationship and returning the result after remapping the physical column name in the result to a field unique identifier when querying.The application realizes that a user table is a real physical table, renaming does not trigger database structure changes, there is multi-level physical isolation, metadata and physical data are decoupled, and safe SQL access is realized, and the performance, safety and flexibility of code-free platform database management are significantly improved.