IntervalType Table

IntervalType stroes the types of interval used by schedules and by terms and conditions.

Table 1. Database columns for IntervalType table

Database Column

Details
IntervalTypeID

Type: integer. Key. Generated ID

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

  • 1 = Day
  • 2 = Week
  • 3 = Month.
ResourceName

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing an interval type. Foreign key to the ComplianceResourceString table.
DefaultValue

Type: text (max 100 characters)

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