This article lists available GUI tools for tables, fields and rows
Tables (metas)
Location | Description |
---|---|
![]() |
Adding and deleting a table |
Reorder tables. Tool reorders tables by changing their physical indexes | |
Convert ROW to NESTED. Available only for ROW tables. Convert ROW tables to NESTED tables while keeping all IDs intact | |
Convert NESTED to ROW. Available only for NESTED tables. Convert NESTED tables to ROW tables while keeping all IDs intact | |
Clear entity names. Clear all values for the name field | |
Duplicate. Creates a copy of the table, optionally copies all the rows as well | |
Data extraction wizard. Retrieves the fields from C# class/struct and add them to the table |
Fields (columns)
Location | Description |
---|---|
Add a field | |
Delete a field | |
![]() |
Copy id to clipboard. Alternatives- click on id button or press Ctrl while hovering over "M" button |
Change field type. For most of the fields, the values will be lost | |
Assign a custom formatter. Custom formatter is a C# class, providing a string value for the field while exporting/importing to string-based formats, like Excel/Google Sheets, CSV and JSON. The formatter should implement BGStringFormatter<T> interface, where T is field type. For JSON format there is an additional setting "Use custom formatters for JSON format", which must be turned on under Settings addon | |
Assign a custom button text provider. Button text provider is a C# class, providing a custom string for the button text for the fields, which uses a button to display its value(relations primarily). For more information, read this article | |
Field's settings. Some fields, like enum or Unity asset fields have additional settings, which can be access via gear icon | |
![]() |
Reorder fields. Select fields by using "S" column, then move them up or down using up and down arrows under "Selected" button groups |
![]() |
Change field type for all selected rows |
Delete selected fields. Delete several selected fields |
Entities (rows)
Location | Description |
---|---|
![]() |
Add a row |
![]() |
Delete a row |
![]() |
Batch insert: Add several rows |
Batch delete: Delete several rows | |
Batch update: Modify single field values for multiple rows | |
Batch copy: Copy values from one field to another field for multiple rows | |
Sort rows: Sort rows by field(s) values | |
Assets to row: Scans Unity assets with provided type under Resources folder, create a row for each asset and assign unity asset field value to existing asset | |
Clear field value: clear one single field values for all/selected rows | |
Copy/move rows between tables: copy or move all/selected rows from one table to another | |
Prefabs tools/Manage database components: iterate database rows and for selected prefab field adds/removes database component (BGEntityGo or generated class) to referenced prefabs | |
Prefabs tools/Scan opened scene prefabs: scans all prefabs in opened scene and adds database row (if it does not exist already) for each such prefab and assigns prefab field value to existing prefab | |
Scan scriptable objects: Scans scriptable objects with BGDatabaseEntityId field and add database rows for each scriptable object | |
![]() |
Columns presets: manage hidden/pinned columns and columns order |
![]() |
Advanced filter: tree-based filter for filtering rows out |
![]() |
Copy id: Copy id value to clipboard. Alternatives- click on id button or press Ctrl while hovering over "M" button |
Edit in popup window: opens separate window to edit row's values | |
Insert before/after: insert new row before or after current row | |
Move up/down, move/swap : change row's physical index | |
Copy/paste a row: copy current row and paste it as new row | |
Duplicate a row: duplicate current row | |
Add BGEntityGo component: Add BGEntityGo component to selected Game Objects and assign BGEntityGo.Entity property to the current row | |
Add BGDataBinderGo component: Add BGDataBinderGo component to selected Game Objects and assign BGDataBinderGo.Entity property to the current row | |
Add generated MonoBehaviour component: Add generated MonoBehaviour component to selected Game Objects and assign BGEntityGo.Entity property to the current row |
Custom tools
in most cases, the database works in Unity Editor the same way as it works in runtime, so you can create your own custom tools. Read more about creating your own tools. You can put your tools in database GUI if you want to.