r_file:檔案業務表
{
"id":檔案唯一主鍵id,
"biz_id":"業務主鍵id",
"biz_type":"檔案業務類型,哪個業務的檔案",
"submitted_file_name":"檔案原始名",
"file_common_id":"對應的檔案公共資訊id",
"uuid":"檔案唯一辨別,可以根據uuid和匿名進行檔案查詢、避免通過id查詢"
}
r_file_common 檔案公共資訊
{
"id":"檔案公共資訊主鍵id",
"data_type":"資料類型DIR:目錄;IMAGE:圖檔;VIDEO:視訊;AUDIO:音頻;DOC:文檔;OTHER:其他",
"relative_path":"檔案相對路徑",
"url":"檔案通路連結 需要通過nginx配置路由,才能通路",
"file_md5":"檔案md5值",
"submitted_file_name":"原始檔案名",
"filename":"唯一檔案名",
"ext":"檔案字尾",
"size":"檔案大小",
"transcoding_path":"檔案轉碼位址",
"transcoding_size":"轉碼檔案大小位元組",
"transcoding_status":"檔案轉碼狀态:0 尚未轉碼 1 轉碼中,2 轉碼成功 3 轉碼失敗",
"duration":"時長(秒),視訊檔案才有",
"thumbnail_path":"縮略圖檔案位址",
"thumbnail_size":"縮略圖檔案大小位元組",
"thumbnail_status":"縮略圖轉碼狀态:0 尚未轉碼 1 轉碼中,2 轉碼成功 3 轉碼失敗",
"can_preview":"是否可以預覽",
"storage_source":"檔案上傳伺服器,0為紫光雲,1為阿裡雲"
}
r_file_relation_ext 檔案字尾、圖示、類型關聯表
{
"id":"主鍵id",
"ext":"字尾名",
"icon":"檔案圖示",
"data_type":"檔案類型",
"can_preview":"是否是預覽類型,1可以預覽,0不可以預覽,預設可以預覽'",
"need_scan":"是否需要掃描,1需要掃描 0不需要掃描 内容監管"
}
r_file_transtask 檔案轉碼任務表(定時任務)
{
"id":"主鍵id",
"file_common_id":"檔案id",
"trans_type":"轉碼類型",
"trans_status":"0 尚未轉碼 1 轉碼中,2 轉碼成功 3 轉碼失敗"
}
内容監管檔案掃描表
{
"id":"主鍵id",
"file_common_id":"檔案id",
"scan_status":"掃描狀态 0無需掃描 1未掃描 2掃描中 3掃描完成",
"capture_frame_status":"截取關鍵幀狀态,0未截取,1截取中,2截取成功,3截取失敗 視訊需要截取為關鍵幀、其它類型需要根據轉碼狀态"
"data_type":"檔案類型"
}
r_file_common_replace_log 檔案替換還原記錄表
{
"id":"主鍵id",
"file_common_id":"檔案id",
"replace_url":"替換url位址",
"replace_transcoding_path":"替換轉碼檔案位址",
"replace_thumbnail_path","替換縮略圖檔案位址",
"operate_type":"replace:替換 restore:還原"
}