| | | 1 | | using Syki.Back.Domain.Identity; |
| | | 2 | | |
| | | 3 | | namespace Syki.Back.Database.Identity; |
| | | 4 | | |
| | | 5 | | public class SykiUserRoleDbConfig : IEntityTypeConfiguration<SykiUserRole> |
| | | 6 | | { |
| | | 7 | | public void Configure(EntityTypeBuilder<SykiUserRole> entity) |
| | | 8 | | { |
| | 4 | 9 | | entity.ToTable("user_roles", DbSchemas.Syki); |
| | | 10 | | |
| | 4 | 11 | | entity.HasKey(e => new { e.InstitutionId, e.UserId, e.RoleId }); |
| | | 12 | | |
| | 4 | 13 | | entity.Property(e => e.InstitutionId).ValueGeneratedNever(); |
| | 4 | 14 | | entity.Property(e => e.UserId).ValueGeneratedNever(); |
| | 4 | 15 | | entity.Property(e => e.RoleId).ValueGeneratedNever(); |
| | | 16 | | |
| | 4 | 17 | | entity.HasOne(e => e.Institution) |
| | 4 | 18 | | .WithMany() |
| | 4 | 19 | | .HasPrincipalKey(c => c.Id) |
| | 4 | 20 | | .HasForeignKey(e => e.InstitutionId); |
| | | 21 | | |
| | 4 | 22 | | entity.HasOne(e => e.User) |
| | 4 | 23 | | .WithMany() |
| | 4 | 24 | | .HasPrincipalKey(c => c.Id) |
| | 4 | 25 | | .HasForeignKey(e => e.UserId); |
| | | 26 | | |
| | 4 | 27 | | entity.HasOne(e => e.Role) |
| | 4 | 28 | | .WithMany() |
| | 4 | 29 | | .HasPrincipalKey(u => u.Id) |
| | 4 | 30 | | .HasForeignKey(e => e.RoleId); |
| | | 31 | | |
| | | 32 | | // Garante que cada usuário vai ter apenas uma role em cada instituição |
| | 4 | 33 | | entity.HasIndex(e => new { e.InstitutionId, e.UserId }) |
| | 4 | 34 | | .IsUnique(); |
| | 4 | 35 | | } |
| | | 36 | | } |