Database Table Types (Design Patterns)
We also have special tools that allow us to quickly (one-day turn-around) create inexpensive, custom data entry input web-application programs perfect for a Content Management System or for developers to use in their own projects. We can produce the three data entry table type utilities depending on the number of tables involved in your particular data relationship:
- Master Tables - Reference tables that define a set of attributes about a specific subject. For example a Contact table contains name, address, email, and phone information about people you've had contact with. Try this Master Table Demo
- Transaction Tables - Tables that store (sometimes time sensitive) recurring instances of a data relationship. For example, in an invoicing system with an Invoice master table which defines the primary attributes of an invoice (company name and contact info), the transaction table would store each of the invoice lines for each billing debit item as well as date sensitive credit payments against the master invoice. Try this Transaction Table Demo
- Junction Tables - Tables that contain common fields from two tables that have a many-to-many relationship. For example, a school might track students, classes, and which classes each student is enrolled in. Try this Junction Table Demo
*Ajax (Asynchronous JavaScript and XML) is a web development technique for creating interactive web applications. It is rapidly gaining in popularity for the seamless and responsive interactive experience it provides to users. Traditional client-server processing requires a barely-noticed, but annoying, refresh of the page, which can add confusion if your page position is shifted. AJAX allows instantaneous database updates, page updates, message boxes, etc., without ever leaving the current page and focus.
For us to create your data entry web application programs, all we need are the definitions (also called the "schema") of the tables you're working with. Just email us information that looks similar to that below. For example the table definition of our simple demo table looks like this:
| Field | Data Type |
|---|
| contid | int(11) |
| username | varchar(32) |
| email | varchar(32) |
| phone | varchar(32) |
| contype | int(11) |
| comments | text |
| listoptin | tinyint(1) |
| credtime | datetime |
| |
Try out all of our Data Entry Input Program Demos, the Master Table demo, the Transactional Table demo, or our Junction Table demo, They are all fully functional examples of data entry programs for finding, entering, navigating forward and backward through, and deleting fictional contact, invoice and school classes information.
Features
- Convenient access to data with multiple functions in a single interface
- Find records to edit by entering a partial key
- Target record is displayed in the middle of a list with similar neighbors above and below
- Select record to edit from list with a single mouse click
- List allows Next and Previous page scanning with buttons deactivated at maximum and minimum limits
- 'Add This' button automatically changes to 'Update' after add
- Main edit page displays record key number
- Main edit page allows Next and Previous record scanning with buttons deactivated at maximum and minimum limits
- Delete buttons prompt for delete confirmation
- Entry values are error checked for type for numerical and date types
- Drop down menus work for static values or values obtained from external relational tables
- 'Complex' programs integrate relational table data entry to primary table data entry
- Custom functions available, e.g. a summation function from line items - Amount Due in invoice example
- Custom button functionality available
- Image display functionality available
- Display label for key id from an external table
Please contact us for questions or more information about our custom data entry programs.