Table Types Defined

Root > 3. Customisation

 

Table Types Defined



Table Types Defined
WiredContact Enterprise contains several different types of databasetables. The table design is intended to allow as much flexibility in database design as possible and still maintaining integrity and performance. The following is a list of possible table types-
 
Entity- Entity tables are the foundation for the database. These tables hold the core data and provide relationships for the other tables. In the default schema, Contact and Groups are considered Entity tables.
 
Peer- A Peer table is used to describe two or more Entity tables. These tables exist on the same level and are considered equal. In the default schema, Groups is a Peer to Contacts.
 
SubEntity- SubEntity tables contain additional information for the main Entity table entries. In the default schema, Activity and History are examples of SubEntity tables.
 
SubEntity Parent- A SubEntity Parent is used to describe a SubEntity table that also has a subtable with additional information. In the default schema, Sales is an example of a SubEntity Parent.
 
SubEntity Child- The SubEntity Child is used to describe a table that holds additional information relative to a SubEntity. In the default schema, Products is considered a SubEntity Child of Sales.
 
SubEntity LinkTo- These tables provide the primary keys to form the relationship between the main Entity table and the
 
SubEntity tables. The primary key is often the Unique ID field from both tables. In the default schema, the LinkTo tables is considered a SubEntity LinkTo.
 
Peer LinkTo- These tables provide the primary kes to form the relationship between two main Entity tables. The primary key is often the Unique ID field from both tables. In the default schema, Group Contacts is an example of a Peer LinkTo table.
 
Simple SubEntity- A Simple SubEntity table has a direct relationship to the main Entity table, bypassing any LinkTo tables. The relationship is often a direct link using the Unique ID field of the Entity. These tables are not as flexible as using regular
 
SubEntity tables along with supporting LinkTo tables. Previous users of WiredContact for ACT! used Simple SubEntity tables when linking external Access databases.
 
Reference- Reference tables are used by the application to define certain elements of the database. These tables do no have direct relationships with the entries saved to the other tables and are considered supporting tables. In the default schema,
 
Dropdowns is considered a Reference table.
Attached is a diagram displaying the default WiredContact Enterprise schema along with the table descriptions.

Regional details are also available at http://www.wiredcontact.co.uk
Click and drag to move


Regional details are also available at http://www.wiredcontact.co.uk

Add Feedback