<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tt/EnterpriseStudio/onlinemanual/table_definitions" xml:lang="en" TopicType="Overview">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table definitions</Title>
		<Keyword ContextSensitive="No"><Level1>
                                    Infor ERP LN Development Tools
                                 </Level1>
			<Level2>table definition</Level2>
		</Keyword>
	</Header>
	<GeneralSection><Paragraph class="Default">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).</Paragraph>
		<Figure space-and-orientation="indented-estimated"><HTML:IMG height="266" width="472" SRC="../images/tr_screen_table_definitions1.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="tr_screen_table_definitions1.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/tr_screen_table_definitions1.gif" ID="IDAXA1AC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Table Data Example</FigCaption>
		</Figure>
	</GeneralSection>
	<GeneralSection><SectionTitle>Fields, domains and indices</SectionTitle>
		<Paragraph class="Default">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.</Paragraph>
		<List><ListIntro>Table fields are linked to domains. Domains are components that define common information about data such as:</ListIntro>
			<ListItem>the data type, e.g. a character type for customer name, a number type for quantity, and a date type for journal date,</ListItem>
			<ListItem>valid ranges, or</ListItem>
			<ListItem>special characteristics such as capitalization rules.</ListItem>
		</List>
		<Paragraph class="Default">Domains insure consistent data types for similar table fields.</Paragraph>
		<Figure space-and-orientation="indented-estimated"><HTML:IMG height="259" width="659" SRC="../images/tr_screen_table_definitions2.gif" path="/enterpriseserver/tools/tt/enterprisestudio/onlinemanual" btb-count="1" btb-count2="1" btb-image-name="tr_screen_table_definitions2.gif" btb-source-path="C:\SVN\docnl\Technology\EnterpriseServer~8.5\EnterpriseServer" btb-image-path="/enterpriseserver/tools/tt/enterprisestudio/images/tr_screen_table_definitions2.gif" ID="IDAIB1AC" alt="[...]" xmlns:HTML="http://www.w3.org/TR/REC-html40"/><FigCaption>Table Fields and Domains Example</FigCaption>
		</Figure>
		<Paragraph class="Default">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.</Paragraph>
	</GeneralSection>
	<GeneralSection><SectionTitle>Related Tables and References</SectionTitle>
		<Paragraph class="Default">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.</Paragraph>
	</GeneralSection>
	<GeneralSection><SectionTitle>To create table definitions</SectionTitle>
		<Paragraph class="Default">You can create table definitions in the <GUIRef href="" role="manual">Table Definitions (ttadv4520m000)</GUIRef> session.</Paragraph>
		<Paragraph class="Default">For details, refer to <Link href="/baanerp/tt/EnterpriseStudio/onlinemanual/to_create_a_data_model" role="manual">To create a data model</Link>.</Paragraph>
	</GeneralSection>
</ManualTopic>
