Concepts

Glom is easy to use, but you must understand the following basic concepts.

  1. Database: Each Glom document allows access to one database.

  2. Table: Each database contains several tables, such as "Customers" and "Invoices" tables.

  3. Field: Each table has several fields, such as "Customer ID", "First Name", and "Date of Birth" fields. In other documents and applications, fields are sometimes called "Columns"

  4. Records: Each table contains several records, each of which has values for each of the fields. For instance, the "Customers" table will have a record for each customer. In other documents and applications, records are sometimes called Rows.

  5. Relationships: Each table might be related to other tables, via fields in both tables. For instance, a "Customers" table could have a relationship to the "Invoices" table, so that people could see all the invoices for that customer. Only developers need to understand this concept. In other documents and applications, relationships are sometimes called "Joins".