namespace iWare_SCADA_Model
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    [Table("WorkPieceInfo")]
    public partial class WorkPieceInfo
    {
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public long Id { get; set; }

        [Required]
        [StringLength(32)]
        public string WorkPieceID { get; set; }

        public int WorkPieceState { get; set; }

        public int WorkPieceCurrentPositionOrder { get; set; }

        [StringLength(255)]
        public string WorkPieceCurrentPosition { get; set; }

        [StringLength(32)]
        public string EquipmentID { get; set; }

        [StringLength(255)]
        public string WorkingProcedureCompleted { get; set; }

        [StringLength(255)]
        public string WorkingProcedurePlan { get; set; }

        [StringLength(32)]
        public string WorkingProcedureCurrent { get; set; }

        [Column(TypeName = "datetime2")]
        public DateTime WorkingProcedureStartTime { get; set; }

        public int ProcessingDurationForCurrent { get; set; }

        public int ProcessingDurationTotal { get; set; }

        [Column(TypeName = "datetime2")]
        public DateTime WorkPieceinitOnlineTime { get; set; }

        public int Number { get; set; }

        [StringLength(2)]
        public string WorkPieceIDTo1 { get; set; }

        [StringLength(4)]
        public string WorkPieceIDTo2 { get; set; }

        [StringLength(6)]
        public string WorkPieceIDTo3 { get; set; }

        [StringLength(2)]
        public string WorkPieceIDTo4 { get; set; }

        [StringLength(4)]
        public string WorkPieceIDTo5 { get; set; }

        [StringLength(2)]
        public string WorkPieceIDTo6 { get; set; }

        [StringLength(2)]
        public string WorkPieceIDTo7 { get; set; }

        public int QualityState { get; set; }

        [StringLength(32)]
        public string QualityStateUpdateUser { get; set; }

        [Column(TypeName = "datetime2")]
        public DateTime QualityStateUpdateTime { get; set; }

        [StringLength(32)]
        public string QualityStateUpdateMode { get; set; }

        public int AlertType { get; set; }

        [StringLength(255)]
        public string AlertMsg { get; set; }

        [StringLength(255)]
        public string Remarks { get; set; }

        [Column(TypeName = "datetime2")]
        public DateTime LogAddTime { get; set; }

        [StringLength(255)]
        public string LogAddRemark { get; set; }

        public DateTimeOffset? CreatedTime { get; set; }

        public DateTimeOffset? UpdatedTime { get; set; }

        public long? CreatedUserId { get; set; }

        [StringLength(50)]
        public string CreatedUserName { get; set; }

        public long? UpdatedUserId { get; set; }

        [StringLength(50)]
        public string UpdatedUserName { get; set; }

        public bool IsDeleted { get; set; }
    }
}