//-----------------------------------------------------------------------
// <copyright file=" sys_task.cs">
// * FileName: .cs 
// </copyright>
//-----------------------------------------------------------------------
using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace Performance.EntityModels
{
    /// <summary>
    /// 
    /// </summary>
    [Table("sys_task")]
    public class sys_task
    {
        /// <summary>
        /// 
        /// </summary>
        [Key]
        public int id { get; set; }

        /// <summary>
        /// 1 标准库 2 绩效库
        /// </summary>
        public Nullable<int> type { get; set; }

        /// <summary>
        /// 表名
        /// </summary>
        public string table_name { get; set; }

        /// <summary>
        /// 导入csv
        /// </summary>
        public string upload_sql { get; set; }

        /// <summary>
        /// 创建临时表
        /// </summary>
        public string exec_sql { get; set; }

        /// <summary>
        /// bcp导入csv
        /// </summary>
        public string export_sql { get; set; }

        /// <summary>
        /// 删除历史数据
        /// </summary>
        public string delete_sql { get; set; }

        /// <summary>
        /// 删除临时表
        /// </summary>
        public string end_sql { get; set; }

        /// <summary>
        /// 是否有效 1 有效 0 无效
        /// </summary>
        public Nullable<int> is_enable { get; set; }
    }
}
