298 lines
11 KiB
C#
298 lines
11 KiB
C#
|
using System;
|
|||
|
|
using System.Collections.Generic;
|
|||
|
|
using Microsoft.EntityFrameworkCore;
|
|||
|
|
|
|||
|
|
namespace demo4_true.Models;
|
|||
|
|
|
|||
|
|
public partial class Demo4Context : DbContext
|
|||
|
|
{
|
|||
|
|
public Demo4Context()
|
|||
|
|
{
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public Demo4Context(DbContextOptions<Demo4Context> options)
|
|||
|
|
: base(options)
|
|||
|
|
{
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
public virtual DbSet<Activity> Activities { get; set; }
|
|||
|
|
|
|||
|
|
public virtual DbSet<City> Cities { get; set; }
|
|||
|
|
|
|||
|
|
public virtual DbSet<Client> Clients { get; set; }
|
|||
|
|
|
|||
|
|
public virtual DbSet<Country> Countries { get; set; }
|
|||
|
|
|
|||
|
|
public virtual DbSet<Direction> Directions { get; set; }
|
|||
|
|
|
|||
|
|
public virtual DbSet<Event> Events { get; set; }
|
|||
|
|
|
|||
|
|
public virtual DbSet<Eventactivity> Eventactivities { get; set; }
|
|||
|
|
|
|||
|
|
public virtual DbSet<Jhuriactivity> Jhuriactivities { get; set; }
|
|||
|
|
|
|||
|
|
public virtual DbSet<Role> Roles { get; set; }
|
|||
|
|
|
|||
|
|
public virtual DbSet<ValidActivityJhuri> ValidActivityJhuris { get; set; }
|
|||
|
|
|
|||
|
|
public virtual DbSet<ValidActivityModerator> ValidActivityModerators { get; set; }
|
|||
|
|
|
|||
|
|
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
|
|||
|
|
#warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see https://go.microsoft.com/fwlink/?LinkId=723263.
|
|||
|
|
=> optionsBuilder.UseNpgsql("Host=212.67.10.54;Database=demo4;Username=myuser;Password=mypassword;Port=5433");
|
|||
|
|
|
|||
|
|
protected override void OnModelCreating(ModelBuilder modelBuilder)
|
|||
|
|
{
|
|||
|
|
modelBuilder.Entity<Activity>(entity =>
|
|||
|
|
{
|
|||
|
|
entity.HasKey(e => e.Id).HasName("activity_pkey");
|
|||
|
|
|
|||
|
|
entity.ToTable("activity");
|
|||
|
|
|
|||
|
|
entity.Property(e => e.Id).HasColumnName("id");
|
|||
|
|
entity.Property(e => e.Name)
|
|||
|
|
.HasMaxLength(100)
|
|||
|
|
.HasColumnName("name");
|
|||
|
|
|
|||
|
|
entity.HasMany(d => d.Moderators).WithMany(p => p.Activities)
|
|||
|
|
.UsingEntity<Dictionary<string, object>>(
|
|||
|
|
"Activitymoderator",
|
|||
|
|
r => r.HasOne<Client>().WithMany()
|
|||
|
|
.HasForeignKey("Moderatorid")
|
|||
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|||
|
|
.HasConstraintName("fk_moderator"),
|
|||
|
|
l => l.HasOne<Activity>().WithMany()
|
|||
|
|
.HasForeignKey("Activityid")
|
|||
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|||
|
|
.HasConstraintName("fk_activity"),
|
|||
|
|
j =>
|
|||
|
|
{
|
|||
|
|
j.HasKey("Activityid", "Moderatorid").HasName("activitymoderator_pkey");
|
|||
|
|
j.ToTable("activitymoderator");
|
|||
|
|
j.IndexerProperty<int>("Activityid").HasColumnName("activityid");
|
|||
|
|
j.IndexerProperty<int>("Moderatorid").HasColumnName("moderatorid");
|
|||
|
|
});
|
|||
|
|
});
|
|||
|
|
|
|||
|
|
modelBuilder.Entity<City>(entity =>
|
|||
|
|
{
|
|||
|
|
entity.HasKey(e => e.Id).HasName("city_pkey");
|
|||
|
|
|
|||
|
|
entity.ToTable("city");
|
|||
|
|
|
|||
|
|
entity.Property(e => e.Id).HasColumnName("id");
|
|||
|
|
entity.Property(e => e.Name)
|
|||
|
|
.HasMaxLength(100)
|
|||
|
|
.HasColumnName("name");
|
|||
|
|
});
|
|||
|
|
|
|||
|
|
modelBuilder.Entity<Client>(entity =>
|
|||
|
|
{
|
|||
|
|
entity.HasKey(e => e.Id).HasName("clients_pkey");
|
|||
|
|
|
|||
|
|
entity.ToTable("clients");
|
|||
|
|
|
|||
|
|
entity.Property(e => e.Id).HasColumnName("id");
|
|||
|
|
entity.Property(e => e.Country).HasColumnName("country");
|
|||
|
|
entity.Property(e => e.Date)
|
|||
|
|
.HasColumnType("timestamp(6) without time zone")
|
|||
|
|
.HasColumnName("date");
|
|||
|
|
entity.Property(e => e.Email)
|
|||
|
|
.HasMaxLength(100)
|
|||
|
|
.HasColumnName("email");
|
|||
|
|
entity.Property(e => e.Fio)
|
|||
|
|
.HasMaxLength(200)
|
|||
|
|
.HasColumnName("fio");
|
|||
|
|
entity.Property(e => e.Gender)
|
|||
|
|
.HasMaxLength(1)
|
|||
|
|
.HasColumnName("gender");
|
|||
|
|
entity.Property(e => e.Meropriyatie)
|
|||
|
|
.HasMaxLength(50)
|
|||
|
|
.HasColumnName("meropriyatie");
|
|||
|
|
entity.Property(e => e.Password)
|
|||
|
|
.HasMaxLength(50)
|
|||
|
|
.HasColumnName("password");
|
|||
|
|
entity.Property(e => e.Phone)
|
|||
|
|
.HasMaxLength(20)
|
|||
|
|
.HasColumnName("phone");
|
|||
|
|
entity.Property(e => e.Photopath)
|
|||
|
|
.HasMaxLength(100)
|
|||
|
|
.HasColumnName("photopath");
|
|||
|
|
entity.Property(e => e.Role).HasColumnName("role");
|
|||
|
|
entity.Property(e => e.Spec)
|
|||
|
|
.HasMaxLength(50)
|
|||
|
|
.HasColumnName("spec");
|
|||
|
|
|
|||
|
|
entity.HasOne(d => d.CountryNavigation).WithMany(p => p.Clients)
|
|||
|
|
.HasForeignKey(d => d.Country)
|
|||
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|||
|
|
.HasConstraintName("fk_country");
|
|||
|
|
|
|||
|
|
entity.HasOne(d => d.RoleNavigation).WithMany(p => p.Clients)
|
|||
|
|
.HasForeignKey(d => d.Role)
|
|||
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|||
|
|
.HasConstraintName("fk_role");
|
|||
|
|
});
|
|||
|
|
|
|||
|
|
modelBuilder.Entity<Country>(entity =>
|
|||
|
|
{
|
|||
|
|
entity.HasKey(e => e.Id).HasName("country_pkey");
|
|||
|
|
|
|||
|
|
entity.ToTable("country");
|
|||
|
|
|
|||
|
|
entity.HasIndex(e => e.Code2, "country_code2_key").IsUnique();
|
|||
|
|
|
|||
|
|
entity.Property(e => e.Id).HasColumnName("id");
|
|||
|
|
entity.Property(e => e.Code)
|
|||
|
|
.HasMaxLength(5)
|
|||
|
|
.HasColumnName("code");
|
|||
|
|
entity.Property(e => e.Code2).HasColumnName("code2");
|
|||
|
|
entity.Property(e => e.EnName)
|
|||
|
|
.HasMaxLength(100)
|
|||
|
|
.HasColumnName("en_name");
|
|||
|
|
entity.Property(e => e.Name)
|
|||
|
|
.HasMaxLength(100)
|
|||
|
|
.HasColumnName("name");
|
|||
|
|
});
|
|||
|
|
|
|||
|
|
modelBuilder.Entity<Direction>(entity =>
|
|||
|
|
{
|
|||
|
|
entity.HasKey(e => e.Id).HasName("direction_pkey");
|
|||
|
|
|
|||
|
|
entity.ToTable("direction");
|
|||
|
|
|
|||
|
|
entity.Property(e => e.Id).HasColumnName("id");
|
|||
|
|
entity.Property(e => e.Name)
|
|||
|
|
.HasMaxLength(255)
|
|||
|
|
.HasColumnName("name");
|
|||
|
|
});
|
|||
|
|
|
|||
|
|
modelBuilder.Entity<Event>(entity =>
|
|||
|
|
{
|
|||
|
|
entity.HasKey(e => e.Id).HasName("event_pkey");
|
|||
|
|
|
|||
|
|
entity.ToTable("event");
|
|||
|
|
|
|||
|
|
entity.HasIndex(e => e.Date, "event_date_key").IsUnique();
|
|||
|
|
|
|||
|
|
entity.Property(e => e.Id).HasColumnName("id");
|
|||
|
|
entity.Property(e => e.City).HasColumnName("city");
|
|||
|
|
entity.Property(e => e.Date)
|
|||
|
|
.HasColumnType("timestamp(6) without time zone")
|
|||
|
|
.HasColumnName("date");
|
|||
|
|
entity.Property(e => e.Days).HasColumnName("days");
|
|||
|
|
entity.Property(e => e.DirectionId).HasColumnName("direction_id");
|
|||
|
|
entity.Property(e => e.Photopath)
|
|||
|
|
.HasMaxLength(255)
|
|||
|
|
.HasColumnName("photopath");
|
|||
|
|
entity.Property(e => e.Sobitie)
|
|||
|
|
.HasMaxLength(200)
|
|||
|
|
.HasColumnName("sobitie");
|
|||
|
|
|
|||
|
|
entity.HasOne(d => d.CityNavigation).WithMany(p => p.Events)
|
|||
|
|
.HasForeignKey(d => d.City)
|
|||
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|||
|
|
.HasConstraintName("fk_city");
|
|||
|
|
|
|||
|
|
entity.HasOne(d => d.Direction).WithMany(p => p.Events)
|
|||
|
|
.HasForeignKey(d => d.DirectionId)
|
|||
|
|
.OnDelete(DeleteBehavior.SetNull)
|
|||
|
|
.HasConstraintName("fk_event_direction");
|
|||
|
|
|
|||
|
|
entity.HasMany(d => d.Winners).WithMany(p => p.Events)
|
|||
|
|
.UsingEntity<Dictionary<string, object>>(
|
|||
|
|
"Eventwinner",
|
|||
|
|
r => r.HasOne<Client>().WithMany()
|
|||
|
|
.HasForeignKey("Winnerid")
|
|||
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|||
|
|
.HasConstraintName("fk_moderator"),
|
|||
|
|
l => l.HasOne<Event>().WithMany()
|
|||
|
|
.HasForeignKey("Eventid")
|
|||
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|||
|
|
.HasConstraintName("fk_event"),
|
|||
|
|
j =>
|
|||
|
|
{
|
|||
|
|
j.HasKey("Eventid", "Winnerid").HasName("eventwinner_pkey");
|
|||
|
|
j.ToTable("eventwinner");
|
|||
|
|
j.IndexerProperty<int>("Eventid").HasColumnName("eventid");
|
|||
|
|
j.IndexerProperty<int>("Winnerid").HasColumnName("winnerid");
|
|||
|
|
});
|
|||
|
|
});
|
|||
|
|
|
|||
|
|
modelBuilder.Entity<Eventactivity>(entity =>
|
|||
|
|
{
|
|||
|
|
entity
|
|||
|
|
.HasNoKey()
|
|||
|
|
.ToTable("eventactivity");
|
|||
|
|
|
|||
|
|
entity.Property(e => e.Activityid).HasColumnName("activityid");
|
|||
|
|
entity.Property(e => e.Eventid).HasColumnName("eventid");
|
|||
|
|
|
|||
|
|
entity.HasOne(d => d.Activity).WithMany()
|
|||
|
|
.HasForeignKey(d => d.Activityid)
|
|||
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|||
|
|
.HasConstraintName("fk_activity");
|
|||
|
|
|
|||
|
|
entity.HasOne(d => d.Event).WithMany()
|
|||
|
|
.HasForeignKey(d => d.Eventid)
|
|||
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|||
|
|
.HasConstraintName("fk_event");
|
|||
|
|
});
|
|||
|
|
|
|||
|
|
modelBuilder.Entity<Jhuriactivity>(entity =>
|
|||
|
|
{
|
|||
|
|
entity
|
|||
|
|
.HasNoKey()
|
|||
|
|
.ToTable("jhuriactivity");
|
|||
|
|
|
|||
|
|
entity.Property(e => e.Activityid).HasColumnName("activityid");
|
|||
|
|
entity.Property(e => e.Jhuriid).HasColumnName("jhuriid");
|
|||
|
|
|
|||
|
|
entity.HasOne(d => d.Activity).WithMany()
|
|||
|
|
.HasForeignKey(d => d.Activityid)
|
|||
|
|
.OnDelete(DeleteBehavior.ClientSetNull)
|
|||
|
|
.HasConstraintName("fk_activity");
|
|||
|
|
|
|||
|
|
entity.HasOne(d => d.Jhuri).WithMany()
|
|||
|
|
.HasForeignKey(d => d.Jhuriid)
|
|||
|
|
.HasConstraintName("fk_moderator");
|
|||
|
|
});
|
|||
|
|
|
|||
|
|
modelBuilder.Entity<Role>(entity =>
|
|||
|
|
{
|
|||
|
|
entity.HasKey(e => e.Id).HasName("roles_pkey");
|
|||
|
|
|
|||
|
|
entity.ToTable("roles");
|
|||
|
|
|
|||
|
|
entity.Property(e => e.Id).HasColumnName("id");
|
|||
|
|
entity.Property(e => e.Name)
|
|||
|
|
.HasMaxLength(20)
|
|||
|
|
.HasColumnName("name");
|
|||
|
|
});
|
|||
|
|
|
|||
|
|
modelBuilder.Entity<ValidActivityJhuri>(entity =>
|
|||
|
|
{
|
|||
|
|
entity
|
|||
|
|
.HasNoKey()
|
|||
|
|
.ToView("valid_activity_jhuri");
|
|||
|
|
|
|||
|
|
entity.Property(e => e.Activityid).HasColumnName("activityid");
|
|||
|
|
entity.Property(e => e.Jhuriid).HasColumnName("jhuriid");
|
|||
|
|
});
|
|||
|
|
|
|||
|
|
modelBuilder.Entity<ValidActivityModerator>(entity =>
|
|||
|
|
{
|
|||
|
|
entity
|
|||
|
|
.HasNoKey()
|
|||
|
|
.ToView("valid_activity_moderators");
|
|||
|
|
|
|||
|
|
entity.Property(e => e.Activityid).HasColumnName("activityid");
|
|||
|
|
entity.Property(e => e.Moderatorid).HasColumnName("moderatorid");
|
|||
|
|
});
|
|||
|
|
|
|||
|
|
OnModelCreatingPartial(modelBuilder);
|
|||
|
|
}
|
|||
|
|
|
|||
|
|
partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
|
|||
|
|
}
|