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

namespace EFCoreDatabase.Entities
{
    [Table("WH_CELL")]
    public class WH_CELL
    {
        [Column("CELL_ID")]
        [Key]
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        public int CELL_ID { get; set; }

        [Column("WAREHOUSE_ID")]
        public int WAREHOUSE_ID { get; set; }

        [Column("AREA_ID")]
        public int AREA_ID { get; set; }

        [Column("LOGIC_ID")]
        public int LOGIC_ID { get; set; }

        [Column("CELL_NAME")]
        public string CELL_NAME { get; set; }

        [Column("CELL_CODE")]
        public string CELL_CODE { get; set; }

        [Column("CELL_TYPE")]
        public string CELL_TYPE { get; set; }

        [Column("DEVICE_CODE")]
        public string DEVICE_CODE { get; set; }

        [Column("CELL_Z")]
        public int CELL_Z { get; set; }

        [Column("CELL_X")]
        public int CELL_X { get; set; }

        [Column("CELL_Y")]
        public int CELL_Y { get; set; }

        [Column("CELL_INOUT")]
        public string CELL_INOUT { get; set; }

        [Column("CELL_MODEL")]
        public string CELL_MODEL { get; set; }

        [Column("CELL_STATUS")]
        public string CELL_STATUS { get; set; }

        [Column("RUN_STATUS")]
        public string RUN_STATUS { get; set; }

        [Column("CELL_FORK_TYPE")]
        public string CELL_FORK_TYPE { get; set; }

        [Column("CELL_LOGICAL_NAME")]
        public string CELL_LOGICAL_NAME { get; set; }

        [Column("LANE_WAY")]
        public string LANE_WAY { get; set; }

        [Column("CELL_GROUP")]
        public string CELL_GROUP { get; set; }

        [Column("SHELF_TYPE")]
        public string SHELF_TYPE { get; set; }

        [Column("SHELF_NEIGHBOUR")]
        public string SHELF_NEIGHBOUR { get; set; }

        [Column("CELL_STORAGE_TYPE")]
        public string CELL_STORAGE_TYPE { get; set; }

        [Column("LOCK_DEVICE_CODE")]
        public string LOCK_DEVICE_CODE { get; set; }

        [Column("CELL_WIDTH")]
        public int CELL_WIDTH { get; set; }

        [Column("CELL_HEIGHT")]
        public int CELL_HEIGHT { get; set; }

        [Column("LOCK_CELL_ID")]
        public string LOCK_CELL_ID { get; set; }

        [Column("BELONG_AREA")]
        public string BELONG_AREA { get; set; }

        [Column("BELONG_ZCQ_ID")]
        public int BELONG_ZCQ_ID { get; set; }

        [Column("CELL_FLAG")]
        public string CELL_FLAG { get; set; }

        [Column("CELL_TRANS_FLAG")]
        public int CELL_TRANS_FLAG { get; set; }

        
    }
}