How to Use Quick-Add Column Templates (ID, Name, Email, etc.)

Designing database tables by hand can be tedious. The Nobregas MySQL Panel visual table builder includes Quick-Add Column Templates — pre-configured column buttons that add correctly-typed columns with a single click. This guide shows you how to use each one.

Accessing the Quick-Add Templates

1. Log in at mysql.nobregas.org and navigate to Databases.
2. Click Manage on the database where you want to create a table.
3. Click Create Table (either the top-right button or the inline builder).
4. Below the table name input, you will see a row of colorful Quick Add Columns buttons.

Available Templates

Each button is color-coded by category and adds a fully configured column instantly:

ID (Auto)

• Column name: id
• Type: INT
• Extras: Primary Key, Auto Increment
• Use for: Unique row identifier for every table. Add this first.

Name

• Column name: name
• Type: VARCHAR(255)
• Use for: User names, product names, category names — any short text label.

Email

• Column name: email
• Type: VARCHAR(255)
• Use for: Email address fields. Pair with a UNIQUE index for login systems.

Text

• Column name: content
• Type: TEXT
• Use for: Long-form content like blog posts, descriptions, or comments.

Number

• Column name: amount
• Type: INT, Default 0
• Use for: Quantities, counts, scores, or any whole number.

Decimal / Price

• Column name: price
• Type: DECIMAL(10,2), Default 0.00
• Use for: Financial values, prices, and monetary amounts. Avoids floating-point rounding errors.

Yes / No (Boolean)

• Column name: is_active
• Type: TINYINT(1), Default 0
• Use for: Boolean flags like active/inactive, published/draft, enabled/disabled.

Date

• Column name: date
• Type: DATE
• Use for: Dates without time (birthdays, due dates, event dates).

Date & Time

• Column name: datetime
• Type: DATETIME
• Use for: Dates with time (appointment times, scheduled events).

Timestamps

• Columns added: created_at + updated_at
• Type: TIMESTAMP
• Use for: Automatic time tracking. Records when a row was created and last modified.

Password

• Column name: password
• Type: VARCHAR(255)
• Use for: Storing hashed passwords (never store plain text passwords).

JSON

• Column name: data
• Type: JSON
• Use for: Flexible key-value data, settings, or nested objects.

Combining Templates

You can click multiple template buttons in sequence to build a complete table schema quickly. For example, to create a users table:

1. Click ID (Auto) — adds the id column
2. Click Name — adds the name column
3. Click Email — adds the email column
4. Click Password — adds the password column
5. Click Yes/No — adds the is_active column
6. Click Timestamps — adds created_at and updated_at

In six clicks, you have a fully structured users table ready to create.

Renaming Template Columns

After a template column is added, you can click on the column name field and rename it. For example, rename amount to quantity or content to bio.

Removing a Column

Each added column has a remove button (X icon) on the right. Click it to remove a column you do not need.