Table

Differences with/without schema

In BACKND, there are two ways of creating a table: A table with a defined schema and a table without a defined schema.
For details, please refer to Differences with/without schema.

Public/Private table

Backend offers two types of tables. The following differences exist when requesting information in the Backend SDK.

• Public table: Returns all gamer information
• Private table: Returns only AccessToken's gamer information

	Public Table		Private Table
	Read	Write	Read	Write
Self	O	O	O	O
Others	O	O	X	X

The Write function includes the creation, modification, and deletion of game information.
As for other users' public tables, they can only be modified when using SDK 5.4.0 or later.
You cannot modify other people's public tables in versions below SDK 5.4.0.

Manage tables

You can manage tables via the BACKND Console → BACKND Base -> Game Information Management → Table menu.
You can check the list of tables, public/private categorization, schema availability, and active/inactive state of tables.
Inactive tables cannot be looked up in the game (BACKND SDK).

You can check the data in the table by clicking the table's name.

Filtering

Use the selection box on the upper side of the page to filter public/private and schema-defined/schema-undefined tables.

Search

You can use the search bar on the upper side of the page to search tables by names.

Create tables

You can create a button by clicking the Create Table button on the upper side of the page.

• You can create up to 100 tables.
• You cannot redefine the schema of a table once it is created.

Table name

• The table name must be a combination of 'uppercase/lowercase letters', 'numbers,' and ‘_'. It must be no more than 32 characters, and the starting character must be a letter.
• The table name cannot be changed after creation.

Create schema-undefined tables

To use a schema-undefined table, set the schema definition to Disable.

Create schema-defined tables

To use a schema-defined table, you must set the schema definition to Enable and then Create Column.
You can use the following data types as a column:

• datetime
• string
• list
• map (xls, xlsx, and csv are supported for the key file used to create a map type column.) (In the key file, the key values equal to the key limit must be divided in rows, and the file must be saved and uploaded in that state.)
• bool
• int
• float
• double

Modify tables

You can edit a table by clicking the edit icon on the right side of the table.

• You can edit Public/Private table types, table descriptions, and schema definitions.

Caution

If a table registered to a ranking is changed to Public, 400 bad public Table error will occur and data will not be updated.
As such, we advise you to not change a registered table's status to Public.

Modify/delete schema-defined table

If null permission is set to Not Allowed, the column cannot be deleted.

Delete tables

You can delete a table by pressing the Delete button on the upper side of the page.

• If you delete a table, all game information belonging to the table will be deleted.