Database Designer

Note.pngTMA Resources recommends that only advanced users use the Database Designer.

The Database Designer lets you work with both Personify base tables and user-defined tables. Using the Database Designer, you can add, remove, or edit these tables thereby extending the Personify data structure to meet your needs. Database Designer allows you to create three types of tables:

·            One-to-one tables

·            One-to-many tables

·            Stand-alone tables

 

You can also create new database columns using the Database Designer for both user-defined and Personify tables. The Database Designer allows you to edit any user-defined columns. You can also remove any user-defined tables and columns. However, you cannot modify or delete the Personify database.

Note.pngYou cannot extend base views using the Database Designer.

As of the 7.2.1 release, Personify supports Unicode values for new user-defined columns and tables. You can enter Unicode values for the NCHAR and NVARCHAR data types. Using the Application Designer, you can create new forms that use the Unicode data stored in the Personify database. The labels and descriptive text of the form can be persisted in the form’s XML definition in Unicode languages. Please see Application Designer for more information on creating new forms.

Note.pngUnicode characters are not supported in base Personify tables, forms, triggers, stored procedures, validation messages, BusinessObjects universes, or Webi reports.

You can generate user-generated layer API code that automatically identifies database columns defined as NCHAR or NVARCHAR and set the Unicode properties to “True” in the generated API code base.

Note.pngTMA Resources recommends you do not add Unicode-supported user-defined columns to the existing Personify tables to minimize the impact on existing processes and functions.

Using Unicode, Notification Services can be set up in multi-byte languages using the Alternate Templates. You can send the notifications to members if Notification Services is set up for foreign languages.