Customize Template
Customize Template allows you to modify an imported database template to fit your application’s specific requirements.
After importing a template, you are free to adjust its structure, relationships, and database objects. The imported template becomes part of your project and behaves like any other Database Schema.
Customizing templates helps you reuse existing database designs while adapting them to your business needs.
Before you begin
Before customizing a template, ensure that you have:
- Imported a database template
- Permission to edit the Database Schema
[!NOTE] Customizing a template affects only the imported Database Schema in your project. The original template remains unchanged.
What can you customize?
After importing a template, you can modify:
- Tables
- Columns
- Data Types
- Primary Keys
- Foreign Keys
- Relationships
- Constraints
- Table names
- Column names
All supported database objects can be edited using the Visual Modeling tools.
Customization workflow
Import Template
│
▼
Open Database Schema
│
▼
Modify Database Structure
│
▼
Validate Changes
│
▼
Save Database SchemaCustomize a template
To customize an imported template:
- Open your Project.
- Open the imported Database Schema.
- Edit the required database objects.
- Validate the updated schema.
- Save your changes.
The customized schema is now part of your project.
Common customizations
Typical modifications include:
| Customization | Purpose |
|---|---|
| Rename tables | Match business terminology |
| Add new tables | Extend the database model |
| Remove unused tables | Simplify the schema |
| Add new columns | Store additional information |
| Update relationships | Reflect business rules |
| Modify constraints | Improve data integrity |
Continue working
After customizing the template, you can continue using all Qubase features, including:
- Visual Modeling
- Database Engineering
- AI Engineering
- Collaboration
- SQL Generation
- DBML Generation
The customized schema integrates seamlessly with the rest of your project.
Benefits
Customizing templates helps you:
- Adapt templates to your application
- Reduce repetitive work
- Maintain flexibility
- Improve database design
- Accelerate development
Best practices
- Review the imported template before editing.
- Rename objects using consistent naming conventions.
- Remove unnecessary database objects.
- Validate the schema after major changes.
- Review relationships before generating SQL.
[!TIP] Templates are designed to provide a strong starting point. Customize them to reflect your application’s real business requirements.