archive_usages
| Column Name | Type | Comment | Default | Null | Remark |
|---|---|---|---|---|---|
| id | bigint UNSIGNED | Primary Key ID | NO | Auto Increment | |
| usage_type | tinyint UNSIGNED | Type of target | NO | ||
| usage_id | bigint UNSIGNED | Target primary key ID | NO | ||
| archive_id | int UNSIGNED | Parameter ID | NO | Related field archives->id | |
| archive_value | text | Parameter value | YES | ||
| is_private | tinyint UNSIGNED | Is private | 0 | NO | 0.No / 1.Yes |
| plugin_fskey | varchar(64) | Related plugin | YES | Related field plugins->fskey Which plugin is associated with | |
| created_at | timestamp | Create Time | CURRENT_TIMESTAMP | NO | |
| updated_at | timestamp | Update Time | YES | ||
| deleted_at | timestamp | Delete Time | YES |
Introduction to using target associations
usage_typeType of target1User2Group3Hashtag4Post5Comment6Post Log7Comment Log
usage_idTarget primary key ID1Related field users->id2Related field groups->id3Related field hashtags->id4Related field posts->id5Related field comments->id6Related field post_logs->id7Related field comment_logs->id
API output example
json
{
"archives": [
{
"code": "String / Code",
"name": "String / Name",
"description": "String / Description",
"value": "String / Parameter value",
}
]
}