Column | TDV JDBC Data Type | Nullable | Description |
RESOURCE_ID | INTEGER | The trigger’s resource ID. | |
RESOURCE_NAME | VARCHAR(255) | The trigger’s resource name. | |
OWNER_ID | INTEGER | The trigger resource owner ID. | |
OWNER | VARCHAR(255) | The trigger resource owner name. | |
PARENT_PATH | VARCHAR(65535) | The path of the trigger resource. Field length: 65535. | |
PARENT_TYPE | VARCHAR(255) | The type of the trigger’s parent resource. | |
CONDITION_TYPE | VARCHAR(60) | The trigger’s condition type. For example, TIMER. | |
ACTION_TYPE | VARCHAR(60) | The trigger’s action type. For example, PROCEDURE. | |
STATUS | VARCHAR(20) | The trigger’s current status: DISABLED—The trigger is disabled. ACTIVE—The trigger is enabled. | |
LAST_TIME | TIMESTAMP | The most recent time the trigger fired. | |
LAST_SUCCESS | TIMESTAMP | The most recent time the trigger succeeded. | |
LAST_FAIL | TIMESTAMP | The most recent time the trigger failed. | |
NUM_TOTAL | INTEGER | The number of times the trigger has fired. | |
NUM_SUCCESS | INTEGER | The number of times the trigger has succeeded. | |
NUM_FAIL | INTEGER | The number of times the trigger has failed. | |
INITAL_TIME | TIMESTAMP | Yes | The time the trigger was configured to first start. NULL if not condition type TIMER. |
NEXT_TIME | TIMESTAMP | Yes | The time the trigger will next fire. NULL if not condition type TIMER. |
FREQUENCY | VARCHAR(255) | Yes | Human-readable description of the frequency of the trigger. NULL if not condition type TIMER. |
MESSAGE | VARCHAR(65535) | Yes | A message about the trigger status that is often set on failure. NULL if no message is available. Field length: 65535. |