Understanding your table structure is essential for writing correct queries and designing efficient databases. The Nobregas MySQL Panel provides a detailed Structure view that shows every column's configuration, keys, and indexes at a glance.
Accessing the Structure View
- Log in at mysql.nobregas.org.
- Navigate to Databases > click Manage on your database.
- Click a table name or the Browse button to open the Table Browse page.
- Click the Structure tab at the top of the page.
Reading the Column Information Table
The Structure tab displays a table with the following columns for each field:
Column Name
The name of the column as defined in the schema (e.g., id, email, created_at).
Data Type
The MySQL data type and length (e.g., int(11), varchar(255), text, decimal(10,2), timestamp).
Null
Shows whether the column accepts NULL values:
- YES — The column can be empty (NULL).
- NO — The column requires a value.
Key
Indicates if the column is part of a key:
- PRI — Primary key (unique identifier for each row).
- UNI — Unique key (values must be unique across all rows).
- MUL — Index (used to speed up searches and joins).
These are displayed as colored badges for easy identification.
Default
The default value assigned to the column when a new row is inserted without specifying this column. Shows NULL, a specific value, or CURRENT_TIMESTAMP.
Extra
Additional properties:
- auto_increment — The value is automatically generated sequentially.
- on update CURRENT_TIMESTAMP — The timestamp updates automatically when the row is modified.
Why This Matters
Understanding your table structure helps you:
- Write accurate queries — Know column names and types before writing SQL.
- Optimize performance — Identify columns that may benefit from indexes on WHERE, JOIN, or ORDER BY clauses.
- Debug issues — Spot nullable columns causing unexpected NULLs, or missing auto_increment on ID fields.
- Plan schema changes — Understand the current structure before adding or altering columns.
Switching Between Data and Structure
Toggle freely between the Data and Structure tabs anytime. The Data tab shows the actual content; the Structure tab shows the design.
