Selecting tables and columns to create your user resource

After you connect to the database, 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. Select the table(s) you want to use to build your resource information. See Adding, editing, or deleting tables.

  3. In the Available Tables field, click the table you want to move. Click the arrow button to move it to the Selected tables field. You must select at least one table. Multiple tables may be selected.

  4. The primary table is indicated by a star icon. The primary table is the table to which all other tables must be joined. To change the primary table, select a different table and click the Primary Table button.

  5. You can give a table a display name. In the Selected tables field, click the Display Name of the table and type the new name. The new name is used as the display name in the user interface, and as a basis for forming the file names. The original name is used in querying data stores.

  6. Click the Columns tab.

  7. Select the column(s) representing resource attributes on which to base Personalization decisions. See Adding, editing, or deleting columns.

  8. In the Available columns field, click the column you want to move. Click the arrow button to move it to the Selected columns field. You must select at least one column. Multiple columns may be selected.

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

  10. You can give a column a display name. In the Selected columns field, click the Display Name of the column and type the new name. The new name is used as the display name in the user interface. The original name is used in querying data stores.


 

Back