problempropertytypes

The problempropertytypes table manages the dictionary of available property types for which values are managed in the problemproperties table.

Table Schema

Name Type Description
id INTEGER

Surrogate key. Primary key for the problempropertytypes table.

name VARCHAR

The name of the property.

inserteddate TIMESTAMP

Timestamp (UTC) indicating the date the row was first inserted into HIEBus.

insertedbyapplication_id SMALLINT

The application that first inserted the row into HIEBus. Foreign key reference to applications.id.

insertedbyuser_id VARCHAR

The user associated with the process that first inserted the row into HIEBus. Foreign key reference to users.id.

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id


Back to Tables