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 3 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

model VARCHAR 50 √ NULL

The model used to generate the response

prompttokens BIGINT 19 √ NULL

Number of tokens in the prompt.

completiontokens BIGINT 19 √ NULL

Number of tokens in the generated completion.

courseid BIGINT 19 0
course.id aiactiregi_cou2_fkR

The id of the course the action's context resolves to; -1 if the context does not resolve to a course; 0 is the not-yet-backfilled default for rows created before this column existed

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_cou_ix Performance Asc courseid
aiactiregi_use_ix Performance Asc userid

Relationships