TcaplusDB OMS Console - Create a Table
1. Function Descriptions
After Create a Game Zone/01Createa_Game_Zone[Table_Group].md), you can create tables under the game zone.
Each table has at least one shard (occupying one shard resource), and the number of shards can be increased or decreased as the amount of data increases or decreases.
Note: At present, the system DBA is responsible for the expansion of data shards. After the user creates a table, if it is estimated that the table data and access volume may increase rapidly in a short time, the user needs to contact the system DBA in advance for capacity expansion. The capacity expansion and shrinkage are lossless and have no impact on the user's normal data reading and writing.
2. Operation Entry
App Management > Table Management > Table Add > Select the corresponding game zone
Enter the table adding page, and you can select local xml to add (for example, if the app is proto or mixed type, you can add pb tables), or select uploaded files to add
3. Notations
If Auto Review Auto Execute is not checked, you need to review and execute it by yourself after submitting it.
Table shards can be allocated manually.
The maximum length of table name is 32 characters.
The maximum number of fields in the Generic table is 256. When the number reaches 110, there will be a warning prompt. The maximum number of fields in the List table is 255 (one is occupied by the built-in index field).
If count is defined for a field in the table, but refer is not defined, the table cannot be added unless it is added to the whitelist. When adding a table, there will be a prompt and you can add it with one click.
First-level string fields are not allowed to define count and refer, and tables are not allowed to be added if they do.
Table Type does not need to be defined in OMS page, but it needs to be defined in Tencent Cloud.
4. Related Documents
In addition to creating a table through the OMS console, users can also create a table by calling the WebService API. The WebService API is mainly used in scenarios where the table needs to be created automatically through code.