Designing Your Database
SpeedBase allows you to design your database from scratch and/or modify your existing design as much as and any time you want.
A well designed database can save you time, speeds up your work flow and organizes your information more efficiently.
In order to achieve a well designed database, you are recommended to make some paperwork to clarify what information types
you need and their relationships.
Sample Design Outline
An example of outline for a simple database design is given below. You can sketch your own design by replacing the names,
adding other required fields or removing unnecessary ones.
Major categories of information (catalogs): Contacts, Appointments.
For Contacts catalog, I need:
- Name - text
- Email - text link
- Birth Day - date d/m/y
- Contact type - selection box containing "vendor", "business partner", "staff", "customer"
- Notes - multiline text
- History of appointments - should show the list of all appointments assigned to this contact
For Appointments catalog, I need:
- Subject - text
- Start time - date & time
- Total time in hours - numeric
- Estimated sale value - monetary
- Contact Name - select from a list of existing contacts
Relationship Notes:
- Each contact person can have any number of appointments.
- Each appointment record is related to a single contact.
Notes about Business Flow:
- We need to track contacts and history of appointments scheduled to them.
- Every day we schedule a number of appointments between a customer and one of our staff.
- Upcoming and past appointments should be easily filtered out and upcoming ones
should notify the assigned user before 2 hours.