Assign Plugin Config Table Schema (assign_plugin_config)


Description

Config data for an instance of a plugin in an assignment.

assign_plugin_config table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
assignment BIGINT 19 0
assign.id assiplugconf_ass2_fk R
plugin VARCHAR 28
subtype VARCHAR 28
name VARCHAR 28
value LONGTEXT 2147483647 √ null

The value of the config setting. Stored as text but can be interpreted by the plugin however it likes.

Table contained -1 rows

assign_plugin_config table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
assiplugconf_ass_ix Performance Asc assignment
assiplugconf_nam_ix Performance Asc name
assiplugconf_plu_ix Performance Asc plugin
assiplugconf_sub_ix Performance Asc subtype

assign_plugin_config table relationships

Close relationships within degrees of separation