Selecting tables and columns to create your user resource

The Construct a Web Content Resource window displays the following six tabs: Tables, Columns, Joins, User Preferences, Mappings, and Deployment. You are required to complete the Tables, Columns, and Deployment sections. Use the Joins tab if you have included more than one table. Setting User Preferences and creating Mappings are optional.

  1. Click the Tables tab.

  2. Click the Create Table button.

  3. Enter the Table name as well as the Display name for the new table. The Table name is used in querying data stores. The Display name is used on the user interface, and is the basis for forming the file names. You must create at least one table. Multiple tables may be created. See Adding, editing, or deleting tables for more information.

  4. Click the arrow buttons to move tables to the Available Tables and Selected tables fields. You must have at least one table in the Selected tables field. Multiple tables may be selected.

  5. Choose the primary table by selecting a table and clicking the Primary Table button. The primary table is the table to which all other tables must be joined. The primary table is indicated by a star icon.

  6. You can edit the Table name and Display name by right-clicking the appropriate table information in the Selected tables field.

  7. Click the Columns tab.

  8. Click the Create Column button to create the column(s) that will represent resource attributes on which to base Personalization decisions. See Adding, editing, or deleting columns for more information.

  9. Click the arrow buttons to move columns to the Available columns and Selected columns fields. You must have at least one column in the Selected columns field. Multiple columns may be selected.

  10. To select the primary key, choose a column and click the Primary Key button. The primary key for each table is indicated by a key icon. See Management of Nested Resources for more information on selecting a primary key for a table.

  11. You can edit the Column name and Display name by right-clicking the appropriate column information in the Selected columns field.


 

Back