using System;
using System.Linq;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

// <Auto-Generated>
// This is here so CodeMaid doesn't reorganize this document
// </Auto-Generated>

namespace GWMS.Data.DatabaseModels
{
    /// <summary>
    /// Tabella Ordini
    /// </summary>
    [Table("Order")]
    public class OrderModel
    {
        #region Public Properties

        [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int OrderId { get; set; }

        public DateTime DtOrder { get; set; } = DateTime.Now;

        public int PlantId { get; set; }

        public int SupplierId { get; set; }

        public int TransporterId { get; set; }

        [MaxLength(100)]
        public string OrderCode { get; set; } = "";

        [MaxLength(250)]
        public string OrderDesc { get; set; } = "";

        public double OrderQty { get; set; } = 0;

        public DateTime DtETA { get; set; }

        public DateTime DtExecStart { get; set; }

        public DateTime DtExecEnd { get; set; }

        public double ExecutionQty { get; set; } = 0;

        public double LevelStart { get; set; } = 0;

        public double LevelEnd { get; set; } = 1;

        [ForeignKey("PlantId")]
        public virtual PlantDetailModel Plant { get; set; }

        [ForeignKey("SupplierId")]
        public virtual SupplierModel Supplier { get; set; }

        [ForeignKey("TransporterId")]
        public virtual TransporterModel Transporter { get; set; }

        #endregion Public Properties
    }
}