{"schemaVersion":"1","contentVersion":"2026-10-18.1","slug":"controls-database-tables","title":"Table browser and diagram controls","summary":"Inspect table structure, distinguish real records from example previews, and navigate relationships between tables.","category":"Control reference","minutes":7,"prerequisites":["Open the named screen in Rumata. Available controls may depend on your account, permissions, and resource state."],"sections":[{"id":"table-browser","title":"Find and inspect a table","blocks":[{"type":"paragraph","text":"Open [Database](/guides/controls-database-tables#table-browser) → Tables. If the schema cannot load, the empty browser does not prove your database is empty. Check the error banner and [Operations](/guides/controls-database-operations#operations) first."},{"type":"table","headers":["Control","What it does"],"rows":[["Search tables","Filter table names in [List View](/guides/controls-database-tables#table-browser). Clear the search to see the full list."],["List View / Diagram","Switch between a table list and a visual map of table relationships."],["View","Open a table inspection dialog with Structure, [Data Preview](/guides/controls-database-tables#table-browser), and, where applicable, Relationships."],["Structure","Inspect column names, types, whether blank values are allowed, and primary or foreign keys."],["Data Preview","Show available sample rows. If Rumata has no real sample rows, this view displays generated examples labeled Random Sample Data. Use [SQL Editor](/guides/controls-database#editor) → Run for actual query results."],["Data Preview grid controls","Sort, filter, resize columns, or page through the preview. The preview is not an editor."],["Relationships","Show columns that reference another table. This tab appears only when the table has foreign keys."],["Close","Dismiss table inspection and return to the browser."],["Diagram beside a table","Switch to the [diagram](/guides/controls-database-tables#diagram) and highlight that table."],["Edit","Open Table Designer. The current interface has local field controls but no available Save action. Use an explicit [SQL](/guides/controls-database#editor) change or the Rumata agent to make a persistent schema change."]]}]},{"id":"diagram","title":"Navigate the database diagram","blocks":[{"type":"paragraph","text":"The [diagram](/guides/controls-database-tables#diagram) visualizes tables and existing relationships. Moving around the [diagram](/guides/controls-database-tables#diagram) does not change the database."},{"type":"table","headers":["Control","What it does"],"rows":[["Zoom in / zoom out","Adjust the scale of the [diagram](/guides/controls-database-tables#diagram)."],["Fit view","Bring the table map into view."],["Canvas / mini-map","Pan through a large schema. The mini-map also supports zooming."],["Relationship line","Highlight a connection between related columns. Click empty canvas to clear the selection."],["Legend / close legend","Show or hide explanations of primary keys, foreign keys, uniqueness, required fields, defaults, and data-type icons."],["Table edit icon","Open the selected table in Table Designer, with the same current saving limitation as the list’s Edit action."]]}]},{"id":"designer","title":"Table Designer fields","blocks":[{"type":"paragraph","text":"These controls describe a local draft of the table structure. In the current application, Add Column and Save are not available. Do not assume changes made here have reached the database."},{"type":"table","headers":["Control","What it does"],"rows":[["Table Name","Change the name in the local draft."],["Column row","Select a column and display its properties."],["Up / down arrows","Move a column in the local list."],["Trash icon on a column","Remove it from the local draft. This screen currently has no available Save action to apply that removal."],["Column Name / Data Type","Edit the field name and the kind of value it accepts, such as text, a number, or a date."],["Length / Precision","Set the additional size or precision field shown for supported data types."],["Primary Key","Mark the field as an identifier for records."],["Nullable","Allow the field to contain no value."],["Foreign Key","Show the settings for linking this field to another table."],["References Table / References Column","Choose the target of a relationship. Choose a table before selecting its column."],["Default Value","Enter a default for the draft field."],["Close","Leave the designer."]]}]}],"technical":[],"related":["controls-database","system-explorer-database","controls-database-operations"],"sources":["components/window/explorer/database/TableView.tsx","components/window/explorer/database/TableDesigner.tsx","components/window/explorer/database/DatabaseDiagram.tsx","components/window/explorer/database/components/TablePreviewDialog.tsx"],"updated":"2026-09-06","audience":"general","media":[{"src":"https://docs.rumata.dev/media/manual/database.jpg","width":1662,"height":789,"alt":"Sabai Talk Thai Database Studio Tables tab with lesson and progress tables.","caption":"Reference capture from the separate Sabai Talk Thai application (September 8, 2026). The [Tables](/guides/controls-database-tables#table-browser) tab shows the structures created for this learning site. Opening a table is a separate action; this view does not display customer records.","sectionId":"table-browser"}],"video":null,"url":"https://docs.rumata.dev/guides/controls-database-tables"}