UserSuffix Table

UserSuffix is a static table listing possible name suffixes for end-users.

Table 1. Database columns for UserSuffix table

Database Column

Details
UserSuffixID

Type: integer. Key. Generated ID

A unique identifier for each UserSuffix. Possible values and the corresponding default strings are:

  • 1 = Jr.
  • 2 = Sr.
  • 3 = I
  • 4 = II
  • 5 = III.
ResourceString

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing an end-user name suffix. Foreign key to the ComplianceResourceString table.
DefaultString

Type: text (max 100 characters)

The text to display if the suffix resource string has no translation.