| Table definitions |  |
| Table Definitions define a structure to the data. The table code and name are attributes of a table. A table is a collection of data, arranged in rows (records) and columns (fields). Table Data Example Fields, domains and indices A table has fields. Table fields store individual pieces of data such as a customer name, the quantity of an item ordered, or the date that a journal entry was made. Table fields are linked to domains. Domains are components that define common information about data such as: the data type, e.g. a character type for customer name, a number type for quantity, and a date type for journal date, valid ranges, or special characteristics such as capitalization rules. Domains insure consistent data types for similar table fields. Table Fields and Domains Example A table must have at least one index. An index consists of one or more table fields that are used to sort and search records in the table. The first index is always the Primary key, which is the unique identification for a record in a table. Related Tables and References The table may have a related table. A related table means that a field in the table will refer to the key field of another table. In this way, data can have relationships: customers can have orders; inventory stores items in warehouses; and employees work in a department. You can use a tool in the Enterprise Modeler to create diagrams from these defined relationships. To create table definitions You can create table definitions in the Table Definitions (ttadv4520m000) session. For details, refer to To create a data model. |