Model

public class Member
    {
       
        [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
        [Key]
        public Guid MemberId { get; set; }
        

        [MaxLength(10)]
        [Column(TypeName = "nvarchar")]
        public string MemberNumberPrefix { get; set; }


        public int? MemberNumber { get; set; }
        

        public int? MemberNumberSuffix { get; set; }

        public bool PotentialClient { get; set; }

        [MaxLength(50)]
        [Column(TypeName = "nvarchar")]
        public string UNHCRNumber { get; set; }

        public RelationshipDD Relationship { get; set; }


        [MaxLength(100)]
        [Column(TypeName = "nvarchar")]
        public string FirstName { get; set; }

        [MaxLength(80)]
        [Column(TypeName = "nvarchar")]
        public string MiddleName { get; set; }

        [MaxLength(100)]
        [Column(TypeName = "nvarchar")]
        public string LastName { get; set; }


        [MaxLength(256)]
        [Column(TypeName = "nvarchar")]
        public string OtherName { get; set; }


        public GenderDD Gender { get; set; }


        public SystemNrDD SystemNr { get; set; }


        public int? BirthDay { get; set; }


        
        public MonthDD BirthMonth { get; set; }


        public int? BirthYear { get; set; }

        public bool DOBEstimated { get; set; }

        
        public CountryDD BirthCountry { get; set; }

        
        public CityDD BirthCity { get; set; }


        [MaxLength(100)]
        [Column(TypeName = "nvarchar")]
        public string BirthTown { get; set; }

        
        public ProvinceDD BirthProvince { get; set; }

        public StateDD BirthState { get; set; }

        

        public MaritalStatusDD MaritalStatus { get; set; }
        

        public CountryDD CurrentCountry { get; set; }


        public CityDD CurrentCity { get; set; }


        public bool Deceased { get; set; }


        public NationalityDD Nationality { get; set; }

       

        public EthnicityDD Ethnicity { get; set; }


        [MaxLength(100)]
        [Column(TypeName = "nvarchar")]
        public string EthnicTribe { get; set; }


        [MaxLength(100)]
        [Column(TypeName = "nvarchar")]
        public string SubClan { get; set; }


        public ReligionDD Religion { get; set; }


        public bool? LivingTogether { get; set; }

        public bool? IntakeCompleted { get; set; }
        public bool Visible { get; set; }

        
        public int? ArrivalDayCountry { get; set; }


        public MonthDD ArrivalMonthCountry { get; set; }

        
        public int? ArrivalYearCountry { get; set; }

        public bool ArrivalDateCountryEstimated { get; set; }

        
        public int? ArrivalDayCity { get; set; }


        public MonthDD ArrivalMonthCity { get; set; }


        public int? ArrivalYearCity { get; set; }

        public bool ArrivalDateCityEstimated { get; set; }


        [Column(TypeName = "datetime")]
        public DateTime? RegistrationDate { get; set; }

        
        public LegalStatusDD LegalStatus { get; set; }


        [Column(TypeName = "datetime")]
        public DateTime? ToPotentialClientDate { get; set; }


        [MaxLength(100)]
        [Column(TypeName = "nvarchar")]
        public string UserCreatedPotentialClient { get; set; }



        [MaxLength(3)]
        [Column(TypeName = "nvarchar")]
        public string CreatedInOffice { get; set; }

        
        public bool Completed { get; set; }
        public bool Deleted { get; set; }

        [MaxLength(100)]
        [Column(TypeName = "nvarchar")]
        public string CreatedBy { get; set; }
       

        [Column(TypeName = "datetime")]
        public DateTime? CreateDate { get; set; }

        [MaxLength(100)]
        [Column(TypeName = "nvarchar")]
        public string UpdatedBy { get; set; }

        
        [Column(TypeName = "datetime")]
        public DateTime? UpdateDate { get; set; }


        public Guid CaseId { get; set; }
        public Case Case { get; set; }
		    }
}