.. role:: strike :class: strike :strike:`dataImportRecord 数据导入记录表` ==================================================== 导入结束后生成记录 字段 --------------------------- +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ | 列名 | 类型 | 是否非空 | 默认值 | 备注 | +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ | id | int | not null | null | 自增ID | +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ | task_id | int | not null | null | 所属任务ID | +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ | source | varchar(300) | not null | null | 数据源:hdfs文件路径或本地上传文件路径 | +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ | status | int | not null | null | 状态:0:成功,1:失败。成功即生成了data_id,有数据导入进来,失败即未生成data_id,无数据导入 | +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ | data_id | int | not null | null | 导入后生成的数据编号 | +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ | total_count | int | not null | null | 待导入数据条数 | +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ | success_count | int | not null | null | 导入成功数据条数 | +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ | error_log | varchar(300) | not null | null | 错误日志URL,导出完成后返回 | +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ | creator_id | int | not null | null | 创建用户id | +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ | createtime | datetime | nullable | CurrentDateTime | 创建时间 | +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ | updatetime | datetime | nullable | CurrentDateTime | 更新时间 | +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ | deletetime | datetime | nullable | CurrentDateTime | 删除时间 | +---------------+--------------+----------+-----------------+----------------------------------------------------------------------------------------------+ 索引 ---------------------- +------+----------+----------+------+ | 字段 | 是否唯一 | 索引方法 | 备注 | +------+----------+----------+------+ | 无 | | | | +------+----------+----------+------+ 说明 ---------------------- 建表语句 ----------------------