ai_action_register

0 rows


Description

Stores information about processed ai actions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
actionname VARCHAR 100

Name of the action

actionid BIGINT 19 null

ID in related action table with more details about the action

success BIT 1 0

Was the action successful when run

userid BIGINT 19 null
user.id aiactiregi_use2_fkR

The user who made the request to run the action

contextid BIGINT 19 null
context.id Implied ConstraintR

The id of the context the action request was made in

provider VARCHAR 100

The provider plugin name that processed the action

errorcode SMALLINT 5 null

If there was an error this was the error code

errormessage LONGTEXT 2147483647 null

If there was an error this was the message

timecreated BIGINT 19 null

Timestamp of when the action was created

timecompleted BIGINT 19 null

Timestamp of when the action was completed, as recorded by the manager

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
aiactiregi_actact_uix Must be unique Asc/Asc actionname + actionid
aiactiregi_actpro_ix Performance Asc/Asc actionname + provider
aiactiregi_use_ix Performance Asc userid

Relationships