Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||
| channelId | VARCHAR | 255 | null |
|
|
|||
| groupId | INT | 10 | null |
|
|
|||
| info | JSON | 1073741824 | √ | null |
|
|
||
| plugin | VARCHAR | 255 | null |
|
|
|||
| recordId | INT | 10 | null |
|
|
|||
| tableName | VARCHAR | 255 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| idx_plugin_channelId | Performance | Asc | channelId |
| idx_plugin_groupId | Performance | Asc | groupId |
| idx_plugin_info_pluginName | Performance | Asc | plugin |
| idx_plugin_info_tableName | Performance | Asc | tableName |
| idx_plugin_recordId | Performance | Asc | recordId |
| UKl2pxiu9plshe3uuu9tw7kbl9l | Must be unique | Asc/Asc/Asc/Asc/Asc | plugin + tableName + recordId + groupId + channelId |