Database Tables
Database Tables provides a view into the database structure and data for troubleshooting.
⚠️ Developer Access Only
This page is only accessible to users with developer privileges.
⚠️ Warning
This is a read-only view. Direct database modifications should be done through proper channels.
Overview
View database tables, their structure, and data for debugging and verification purposes.
Page Layout
- Table List - All database tables
- Table Details - Selected table info
- Data Browser - View table data
- Query Builder - Build simple queries
Table Information
For each table:
| Info | Description |
|---|---|
| Table Name | Name of the table |
| Columns | Column definitions |
| Row Count | Number of records |
| Size | Table size |
| Indexes | Index information |
Common Tasks
Viewing Table Structure
- Go to Developer → Tools → Database Tables
- Select table from list
- View:
- Column names
- Data types
- Constraints
- Indexes
Browsing Table Data
- Select table
- Click Browse Data
- View records
- Use pagination for large tables
- Search/filter as needed
Exporting Data
- Select table
- Apply filters if needed
- Click Export
- Choose format
- Download file
Data Types
Common column types:
| Type | Description |
|---|---|
| VARCHAR | Text strings |
| INTEGER | Whole numbers |
| DECIMAL | Decimal numbers |
| TIMESTAMP | Date and time |
| BOOLEAN | True/false |
| JSON | JSON data |
Search and Filter
- Search by column value
- Filter by conditions
- Sort by any column
- Limit result count
Tips
- Read Only - Don't attempt writes
- Performance - Be careful with large tables
- Sensitive Data - Respect data privacy
- Document Queries - Save useful queries
- Use Indexes - Query indexed columns
Related Pages
- Developer Scripts - Run scripts
- Deletion Logs - Deleted records
💡 Note: This is for viewing only. Data modifications should go through the application.