DroidDB FAQ
DroidDB® Most Common FAQ
What's a database, table, form, and application and how do they all relate to each other?
With DroidDB there are "tables," "databases," "forms," and "applications."
A "table" is what you expect it to be: a set of rows and columns that contain data. Each row in the table represents some real-world entity, each column represents some characteristic of that entity. For example, a CUSTOMER table has a row for each CUSTOMER. The columns of the CUSTOMER table may be the CUSTOMER_NUMBER, a CUSTOMER_NAME, an ADDRESS, etc. In DroidDB, a table is stored in a "database."
A "database" is a set of related tables. If two tables are related to each other, they both have a column with the same name and datatype that contains the same value. For example, there may be an ORDERS table with the columns ORDER_ID, ORDER_DATE, and CUSTOMER_NUMBER. In this case the
ORDERS table is related to the CUSTOMERS table. Order records with
CUSTOMER_NUMBER 123 are related to the CUSTOMER record with a CUSTOMER_NUMBER of 123. In DroidDB, a database is stored in a file with a .DB extension.
A "form" is program that takes data out of a table and displays it on the screen. Regardless of whether the table has one record or 100 records, the form is exactly the same. The form does not store any data, it is just instructions on how to display the data. In DroidDB, a form is stored in a file with a .DDB extension.
An "application" is just a bundle that contains a database (with tables in it) and forms over those tables. In DroidDB, an application is a top level folder that resides on the SD card of your device (and apears as a mapped drive on the desktop, for example the E: drive). The .db database file and .ddb forms reside in that folder.