cms_thermo_active/Thermo.Active.Model/DatabaseModels/MachineUserModel.cs

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

namespace Thermo.Active.Model.DatabaseModels
{
    [Table("machine_user")]
    public class MachineUserModel
    {
        [Key]
        [Column("id")]
        public int MachineUserId { get; set; }

        [Index("unique_machine_user", IsClustered = true, IsUnique = true, Order = 1)]
        [Column(name: "machine_id")]
        public int MachineId { get; set; }

        [ForeignKey("MachineId")]
        public MachineModel Machine { get; set; }

        [Index("unique_machine_user", IsClustered = true, IsUnique = true, Order = 2)]
        [Column(name: "user_id")]
        public int UserId { get; set; }

        [ForeignKey("UserId")]
        public UserModel User { get; set; }

        [Column(name: "role_id")]
        public int RoleId { get; set; }

        [ForeignKey("RoleId")]
        public RoleModel Role { get; set; }
    }
}