file_downloads
| Column Name | Type | Comment | Default | Null | Remark |
|---|---|---|---|---|---|
| id | bigint UNSIGNED | Primary Key ID | NO | Auto Increment | |
| file_id | bigint UNSIGNED | File ID | NO | Related field files->id | |
| file_type | tinyint UNSIGNED | File Type | 1 | NO | 1.Image / 2.Video / 3.Audio / 4.Document |
| account_id | bigint UNSIGNED | Downloader Account ID | NO | Related field accounts->id | |
| user_id | bigint UNSIGNED | Downloader User ID | YES | Related field users->id | |
| app_fskey | varchar(64) | Downloader Plugin | YES | Related field apps->fskey If downloaded in a plugin, then it is that plugin's fskey | |
| target_type | tinyint UNSIGNED | Download Source Type | 1 | NO | Content Type |
| target_id | bigint UNSIGNED | Source Target Primary Key ID | NO | ||
| created_at | timestamp | Download Time | useCurrent | NO | For example, MySQL defaults to CURRENT_TIMESTAMP |
| updated_at | timestamp | Update Time | YES | ||
| deleted_at | timestamp | Delete Time | YES |