1915 lines
75 KiB
C#
1915 lines
75 KiB
C#
// <auto-generated />
|
|
using System;
|
|
using Microsoft.EntityFrameworkCore;
|
|
using Microsoft.EntityFrameworkCore.Infrastructure;
|
|
using Microsoft.EntityFrameworkCore.Metadata;
|
|
using Microsoft.EntityFrameworkCore.Migrations;
|
|
using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
|
|
using SIFinance.Shared.Entities;
|
|
|
|
#nullable disable
|
|
|
|
namespace SIFinance.Shared.Migrations
|
|
{
|
|
[DbContext(typeof(SIFinanceDbContext))]
|
|
[Migration("20260806131533_AddResponsableToUtilisateurs")]
|
|
partial class AddResponsableToUtilisateurs
|
|
{
|
|
/// <inheritdoc />
|
|
protected override void BuildTargetModel(ModelBuilder modelBuilder)
|
|
{
|
|
#pragma warning disable 612, 618
|
|
modelBuilder
|
|
.HasAnnotation("ProductVersion", "10.0.9")
|
|
.HasAnnotation("Relational:MaxIdentifierLength", 128);
|
|
|
|
SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder);
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Acompte", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("Commentaire")
|
|
.HasMaxLength(500)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(500)")
|
|
.HasColumnName("commentaire");
|
|
|
|
b.Property<DateTime?>("DateCreation")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_creation")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<DateOnly>("DatePrevue")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_prevue");
|
|
|
|
b.Property<DateOnly?>("DateVerse")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_verse");
|
|
|
|
b.Property<int>("FactureId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("facture_id");
|
|
|
|
b.Property<int?>("JustificatifId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("justificatif_id");
|
|
|
|
b.Property<decimal>("Montant")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant");
|
|
|
|
b.Property<int>("SaisieParId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("saisie_par_id");
|
|
|
|
b.Property<string>("Statut")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasDefaultValue("PREVU")
|
|
.HasColumnName("statut");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__acomptes__3213E83F0A5FDF52");
|
|
|
|
b.HasIndex(new[] { "FactureId" }, "IX_aco_facture");
|
|
|
|
b.HasIndex(new[] { "JustificatifId" }, "IX_aco_justif");
|
|
|
|
b.HasIndex(new[] { "SaisieParId" }, "IX_aco_saisie_par");
|
|
|
|
b.ToTable("acomptes", "fin");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.AffectationsAvoir", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<int>("AffecteParId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("affecte_par_id");
|
|
|
|
b.Property<int>("AvoirId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("avoir_id");
|
|
|
|
b.Property<DateTime?>("DateAffectation")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_affectation")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<int>("FactureId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("facture_id");
|
|
|
|
b.Property<decimal>("MontantAffecte")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant_affecte");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__affectat__3213E83FEA440C49");
|
|
|
|
b.HasIndex(new[] { "AffecteParId" }, "IX_aff_affecte_par");
|
|
|
|
b.HasIndex(new[] { "AvoirId" }, "IX_aff_avoir");
|
|
|
|
b.HasIndex(new[] { "FactureId" }, "IX_aff_facture");
|
|
|
|
b.ToTable("affectations_avoir", "fin");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Audit", b =>
|
|
{
|
|
b.Property<long>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("bigint")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
|
|
|
|
b.Property<string>("Action")
|
|
.IsRequired()
|
|
.HasMaxLength(50)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(50)")
|
|
.HasColumnName("action");
|
|
|
|
b.Property<DateTime>("DateAction")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_action")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<string>("DetailJson")
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(max)")
|
|
.HasColumnName("detail_json");
|
|
|
|
b.Property<int>("EntiteId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("entite_id");
|
|
|
|
b.Property<string>("EntiteType")
|
|
.IsRequired()
|
|
.HasMaxLength(30)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(30)")
|
|
.HasColumnName("entite_type");
|
|
|
|
b.Property<string>("IpAdresse")
|
|
.HasMaxLength(45)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(45)")
|
|
.HasColumnName("ip_adresse");
|
|
|
|
b.Property<int>("UtilisateurId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("utilisateur_id");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__audit__3213E83F12911979");
|
|
|
|
b.HasIndex(new[] { "EntiteType", "EntiteId" }, "IX_audit_entite");
|
|
|
|
b.HasIndex(new[] { "UtilisateurId" }, "IX_audit_utilisateur");
|
|
|
|
b.ToTable("audit", "core");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Avoir", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateOnly>("DateAvoir")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_avoir");
|
|
|
|
b.Property<DateTime?>("DateCreation")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_creation")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<int?>("FactureId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("facture_id");
|
|
|
|
b.Property<int>("FournisseurId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("fournisseur_id");
|
|
|
|
b.Property<int?>("JustificatifId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("justificatif_id");
|
|
|
|
b.Property<decimal>("MontantInitial")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant_initial");
|
|
|
|
b.Property<string>("NumeroAvoir")
|
|
.IsRequired()
|
|
.HasMaxLength(100)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(100)")
|
|
.HasColumnName("numero_avoir");
|
|
|
|
b.Property<int>("SaisieParId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("saisie_par_id");
|
|
|
|
b.Property<decimal>("SoldeDisponible")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("solde_disponible");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__avoirs__3213E83FA6ADF4CA");
|
|
|
|
b.HasIndex(new[] { "FactureId" }, "IX_avo_facture");
|
|
|
|
b.HasIndex(new[] { "FournisseurId" }, "IX_avo_fournisseur");
|
|
|
|
b.HasIndex(new[] { "JustificatifId" }, "IX_avo_justif");
|
|
|
|
b.HasIndex(new[] { "SaisieParId" }, "IX_avo_saisie_par");
|
|
|
|
b.ToTable("avoirs", "fin");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.ContratEcheance", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<int>("ContratId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("contrat_id");
|
|
|
|
b.Property<DateTime?>("DateCreation")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_creation")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<DateOnly>("DateEcheance")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_echeance");
|
|
|
|
b.Property<int?>("JustificatifId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("justificatif_id");
|
|
|
|
b.Property<decimal>("Montant")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant");
|
|
|
|
b.Property<string>("Statut")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasDefaultValue("A_VENIR")
|
|
.HasColumnName("statut");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__contrats_echeances");
|
|
|
|
b.HasIndex(new[] { "ContratId" }, "IX_cte_contrat");
|
|
|
|
b.HasIndex(new[] { "JustificatifId" }, "IX_cte_justif");
|
|
|
|
b.ToTable("contrats_echeances", "achats");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.ContratFournisseur", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTime?>("DateCreation")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_creation")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<DateOnly>("DateDebut")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_debut");
|
|
|
|
b.Property<DateTime?>("DateDerniereMaj")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_derniere_maj")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<DateOnly>("DateFin")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_fin");
|
|
|
|
b.Property<DateOnly?>("DateSignature")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_signature");
|
|
|
|
b.Property<int>("FournisseurId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("fournisseur_id");
|
|
|
|
b.Property<decimal>("MontantTotal")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant_total");
|
|
|
|
b.Property<string>("Objet")
|
|
.IsRequired()
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("objet");
|
|
|
|
b.Property<string>("Periodicite")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasDefaultValue("mensuelle")
|
|
.HasColumnName("periodicite");
|
|
|
|
b.Property<string>("Reference")
|
|
.HasMaxLength(50)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(50)")
|
|
.HasColumnName("reference");
|
|
|
|
b.Property<int>("SaisieParId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("saisie_par_id");
|
|
|
|
b.Property<string>("Statut")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasDefaultValue("ACTIF")
|
|
.HasColumnName("statut");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__contrats_fournisseurs");
|
|
|
|
b.HasIndex(new[] { "FournisseurId" }, "IX_ctf_fournisseur");
|
|
|
|
b.HasIndex(new[] { "SaisieParId" }, "IX_ctf_saisie_par");
|
|
|
|
b.ToTable("contrats_fournisseurs", "achats");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.ContratPrestataire", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTime?>("DateCreation")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_creation")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<DateOnly>("DateDebut")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_debut");
|
|
|
|
b.Property<DateOnly>("DateFin")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_fin");
|
|
|
|
b.Property<DateOnly?>("DateSignature")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_signature");
|
|
|
|
b.Property<decimal>("MontantTotal")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant_total");
|
|
|
|
b.Property<string>("Objet")
|
|
.IsRequired()
|
|
.HasMaxLength(255)
|
|
.HasColumnType("nvarchar(255)")
|
|
.HasColumnName("objet");
|
|
|
|
b.Property<int>("OrganismeId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("organisme_id");
|
|
|
|
b.Property<string>("Reference")
|
|
.IsRequired()
|
|
.HasMaxLength(50)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(50)")
|
|
.HasColumnName("reference");
|
|
|
|
b.Property<int>("SaisieParId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("saisie_par_id");
|
|
|
|
b.Property<string>("Statut")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasDefaultValue("ACTIF")
|
|
.HasColumnName("statut");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__contrats_prestataires");
|
|
|
|
b.HasIndex(new[] { "OrganismeId" }, "IX_ctp_organisme");
|
|
|
|
b.HasIndex(new[] { "SaisieParId" }, "IX_ctp_saisie_par");
|
|
|
|
b.HasIndex(new[] { "Reference" }, "UQ_ctp_reference")
|
|
.IsUnique();
|
|
|
|
b.ToTable("contrats_prestataires", "st");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.DemandesAchat", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("CategorieFournisseurLibre")
|
|
.HasMaxLength(100)
|
|
.HasColumnType("nvarchar(100)")
|
|
.HasColumnName("categorie_fournisseur_libre");
|
|
|
|
b.Property<DateTime?>("DateCreation")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_creation")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<DateTime?>("DateDerniereMaj")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_derniere_maj")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<DateOnly>("DatePrevisionnelle")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_previsionnelle");
|
|
|
|
b.Property<DateTime?>("DateSoumission")
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_soumission");
|
|
|
|
b.Property<int>("DemandeurId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("demandeur_id");
|
|
|
|
b.Property<string>("Description")
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(max)")
|
|
.HasColumnName("description");
|
|
|
|
b.Property<int?>("FournisseurId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("fournisseur_id");
|
|
|
|
b.Property<string>("FournisseurLibre")
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("fournisseur_libre");
|
|
|
|
b.Property<int>("ModePaiementId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("mode_paiement_id");
|
|
|
|
b.Property<decimal>("MontantHt")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant_ht");
|
|
|
|
b.Property<decimal>("MontantTtc")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant_ttc");
|
|
|
|
b.Property<decimal>("MontantTva")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant_tva");
|
|
|
|
b.Property<string>("Objet")
|
|
.IsRequired()
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("objet");
|
|
|
|
b.Property<string>("Reference")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasColumnName("reference");
|
|
|
|
b.Property<int>("ServiceId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("service_id");
|
|
|
|
b.Property<decimal>("SeuilApplicable")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("seuil_applicable");
|
|
|
|
b.Property<string>("Statut")
|
|
.IsRequired()
|
|
.HasMaxLength(30)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(30)")
|
|
.HasColumnName("statut");
|
|
|
|
b.Property<decimal>("TauxTva")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("decimal(5, 2)")
|
|
.HasDefaultValue(20m)
|
|
.HasColumnName("taux_tva");
|
|
|
|
b.Property<int>("TypeDepenseId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("type_depense_id");
|
|
|
|
b.Property<int?>("ValideurId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("valideur_id");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__demandes__3213E83FB1E63F22");
|
|
|
|
b.HasIndex(new[] { "DemandeurId" }, "IX_da_demandeur");
|
|
|
|
b.HasIndex(new[] { "FournisseurId" }, "IX_da_fournisseur");
|
|
|
|
b.HasIndex(new[] { "ModePaiementId" }, "IX_da_mode_paiement");
|
|
|
|
b.HasIndex(new[] { "ServiceId" }, "IX_da_service");
|
|
|
|
b.HasIndex(new[] { "Statut" }, "IX_da_statut");
|
|
|
|
b.HasIndex(new[] { "TypeDepenseId" }, "IX_da_type_depense");
|
|
|
|
b.HasIndex(new[] { "ValideurId" }, "IX_da_valideur");
|
|
|
|
b.HasIndex(new[] { "Reference" }, "UQ__demandes__FD90DA99FE701252")
|
|
.IsUnique();
|
|
|
|
b.ToTable("demandes_achat", "achats");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Facture", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<int?>("CategorieDepenseId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("categorie_depense_id");
|
|
|
|
b.Property<DateTime?>("DateCreation")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_creation")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<DateTime?>("DateDerniereMaj")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_derniere_maj")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<DateOnly>("DateEcheance")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_echeance");
|
|
|
|
b.Property<DateOnly>("DateFacture")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_facture");
|
|
|
|
b.Property<DateTime?>("DateValidationBap")
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_validation_bap");
|
|
|
|
b.Property<int?>("DemandeAchatId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("demande_achat_id");
|
|
|
|
b.Property<bool?>("EstDoublonSignale")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("bit")
|
|
.HasDefaultValue(false)
|
|
.HasColumnName("est_doublon_signale");
|
|
|
|
b.Property<int>("FournisseurId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("fournisseur_id");
|
|
|
|
b.Property<int>("ModePaiementId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("mode_paiement_id");
|
|
|
|
b.Property<decimal>("MontantHt")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant_ht");
|
|
|
|
b.Property<decimal>("MontantTtc")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant_ttc");
|
|
|
|
b.Property<decimal>("MontantTva")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant_tva");
|
|
|
|
b.Property<string>("NumeroFacture")
|
|
.IsRequired()
|
|
.HasMaxLength(100)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(100)")
|
|
.HasColumnName("numero_facture");
|
|
|
|
b.Property<int>("SaisieParId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("saisie_par_id");
|
|
|
|
b.Property<int>("ServiceId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("service_id");
|
|
|
|
b.Property<string>("SourceType")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasColumnName("source_type");
|
|
|
|
b.Property<string>("Statut")
|
|
.IsRequired()
|
|
.HasMaxLength(30)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(30)")
|
|
.HasColumnName("statut");
|
|
|
|
b.Property<decimal>("TauxTva")
|
|
.HasColumnType("decimal(5, 2)")
|
|
.HasColumnName("taux_tva");
|
|
|
|
b.Property<int?>("ValideBapParId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("valide_bap_par_id");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__factures__3213E83F68386F7E");
|
|
|
|
b.HasIndex(new[] { "CategorieDepenseId" }, "IX_fac_categorie");
|
|
|
|
b.HasIndex(new[] { "DemandeAchatId" }, "IX_fac_demande");
|
|
|
|
b.HasIndex(new[] { "FournisseurId" }, "IX_fac_fournisseur");
|
|
|
|
b.HasIndex(new[] { "ModePaiementId" }, "IX_fac_mode_paiement");
|
|
|
|
b.HasIndex(new[] { "SaisieParId" }, "IX_fac_saisie_par");
|
|
|
|
b.HasIndex(new[] { "ServiceId" }, "IX_fac_service");
|
|
|
|
b.HasIndex(new[] { "Statut" }, "IX_fac_statut");
|
|
|
|
b.HasIndex(new[] { "ValideBapParId" }, "IX_fac_valide_bap");
|
|
|
|
b.ToTable("factures", "fin");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.FichiersXml", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTime?>("DateGeneration")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_generation")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<int>("GenereParId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("genere_par_id");
|
|
|
|
b.Property<decimal>("MontantTotal")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant_total");
|
|
|
|
b.Property<string>("NomFichier")
|
|
.IsRequired()
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("nom_fichier");
|
|
|
|
b.Property<int>("NombreVirements")
|
|
.HasColumnType("int")
|
|
.HasColumnName("nombre_virements");
|
|
|
|
b.Property<string>("SharepointUrl")
|
|
.IsRequired()
|
|
.HasMaxLength(999)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(999)")
|
|
.HasColumnName("sharepoint_url");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__fichiers__3213E83FEE8C3E2D");
|
|
|
|
b.HasIndex(new[] { "GenereParId" }, "IX_xml_genere_par");
|
|
|
|
b.ToTable("fichiers_xml", "fin");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Fournisseur", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("Adresse")
|
|
.HasMaxLength(500)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(500)")
|
|
.HasColumnName("adresse");
|
|
|
|
b.Property<string>("Bic")
|
|
.HasMaxLength(11)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(11)")
|
|
.HasColumnName("bic");
|
|
|
|
b.Property<DateTime?>("DateCreation")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_creation")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<string>("Email")
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("email");
|
|
|
|
b.Property<byte[]>("IbanChiffre")
|
|
.HasMaxLength(256)
|
|
.HasColumnType("varbinary(256)")
|
|
.HasColumnName("iban_chiffre");
|
|
|
|
b.Property<string>("RaisonSociale")
|
|
.IsRequired()
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("raison_sociale");
|
|
|
|
b.Property<string>("Siret")
|
|
.HasMaxLength(14)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(14)")
|
|
.HasColumnName("siret");
|
|
|
|
b.Property<string>("Statut")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(10)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(10)")
|
|
.HasDefaultValue("ACTIF")
|
|
.HasColumnName("statut");
|
|
|
|
b.Property<string>("Telephone")
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasColumnName("telephone");
|
|
|
|
b.Property<string>("TitulaireCompte")
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("titulaire_compte");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__fourniss__3213E83F16CB24B1");
|
|
|
|
b.ToTable("fournisseurs", "ref");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.HistoriqueAction", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("Action")
|
|
.IsRequired()
|
|
.HasMaxLength(50)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(50)")
|
|
.HasColumnName("action");
|
|
|
|
b.Property<string>("AncienStatut")
|
|
.HasMaxLength(30)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(30)")
|
|
.HasColumnName("ancien_statut");
|
|
|
|
b.Property<string>("Commentaire")
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(max)")
|
|
.HasColumnName("commentaire");
|
|
|
|
b.Property<DateTime?>("DateAction")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_action")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<int>("EntiteId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("entite_id");
|
|
|
|
b.Property<string>("EntiteType")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasColumnName("entite_type");
|
|
|
|
b.Property<string>("NouveauStatut")
|
|
.HasMaxLength(30)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(30)")
|
|
.HasColumnName("nouveau_statut");
|
|
|
|
b.Property<int>("UtilisateurId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("utilisateur_id");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__historiq__3213E83FB787CC6E");
|
|
|
|
b.HasIndex(new[] { "EntiteType", "EntiteId" }, "IX_histo_entite");
|
|
|
|
b.HasIndex(new[] { "UtilisateurId" }, "IX_histo_utilisateur");
|
|
|
|
b.ToTable("historique_actions", "core");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.ModesPaiement", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<bool>("Actif")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("bit")
|
|
.HasDefaultValue(true)
|
|
.HasColumnName("actif");
|
|
|
|
b.Property<string>("Libelle")
|
|
.IsRequired()
|
|
.HasMaxLength(100)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(100)")
|
|
.HasColumnName("libelle");
|
|
|
|
b.Property<bool>("NecessiteXml")
|
|
.HasColumnType("bit")
|
|
.HasColumnName("necessite_xml");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__modes_pa__3213E83F2F37EC08");
|
|
|
|
b.ToTable("modes_paiement", "ref");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Organisme", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("Adresse")
|
|
.HasMaxLength(255)
|
|
.HasColumnType("nvarchar(255)")
|
|
.HasColumnName("adresse");
|
|
|
|
b.Property<DateTime?>("DateCreation")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_creation")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<string>("Email")
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("email");
|
|
|
|
b.Property<string>("RaisonSociale")
|
|
.IsRequired()
|
|
.HasMaxLength(255)
|
|
.HasColumnType("nvarchar(255)")
|
|
.HasColumnName("raison_sociale");
|
|
|
|
b.Property<string>("Siret")
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasColumnName("siret");
|
|
|
|
b.Property<string>("Statut")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasDefaultValue("ACTIF")
|
|
.HasColumnName("statut");
|
|
|
|
b.Property<string>("Telephone")
|
|
.HasMaxLength(30)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(30)")
|
|
.HasColumnName("telephone");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__organismes");
|
|
|
|
b.ToTable("organismes", "st");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Paiement", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateOnly>("DatePaiement")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_paiement");
|
|
|
|
b.Property<DateTime?>("DateSaisie")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_saisie")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<int>("EnregistreParId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("enregistre_par_id");
|
|
|
|
b.Property<int>("FactureId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("facture_id");
|
|
|
|
b.Property<int?>("FichierXmlId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("fichier_xml_id");
|
|
|
|
b.Property<int>("ModeReglementId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("mode_reglement_id");
|
|
|
|
b.Property<decimal>("MontantPaye")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant_paye");
|
|
|
|
b.Property<bool>("Rapproche")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("bit")
|
|
.HasDefaultValue(false)
|
|
.HasColumnName("rapproche");
|
|
|
|
b.Property<string>("ReferencePaiement")
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("reference_paiement");
|
|
|
|
b.Property<string>("Statut")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasDefaultValue("PROGRAMME")
|
|
.HasColumnName("statut");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__paiement__3213E83F4F594948");
|
|
|
|
b.HasIndex(new[] { "EnregistreParId" }, "IX_pai_enregistre_par");
|
|
|
|
b.HasIndex(new[] { "FactureId" }, "IX_pai_facture");
|
|
|
|
b.HasIndex(new[] { "ModeReglementId" }, "IX_pai_mode");
|
|
|
|
b.HasIndex(new[] { "FichierXmlId" }, "IX_pai_xml");
|
|
|
|
b.ToTable("paiements", "fin");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Parametre", b =>
|
|
{
|
|
b.Property<string>("Cle")
|
|
.HasMaxLength(100)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(100)")
|
|
.HasColumnName("cle");
|
|
|
|
b.Property<DateTime?>("DateModif")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_modif")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<string>("Description")
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("description");
|
|
|
|
b.Property<int?>("ModifiePar")
|
|
.HasColumnType("int")
|
|
.HasColumnName("modifie_par");
|
|
|
|
b.Property<string>("Valeur")
|
|
.IsRequired()
|
|
.HasMaxLength(500)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(500)")
|
|
.HasColumnName("valeur");
|
|
|
|
b.HasKey("Cle")
|
|
.HasName("PK__parametr__D837B8B8460C2DCC");
|
|
|
|
b.HasIndex(new[] { "ModifiePar" }, "IX_parametres_modifie_par");
|
|
|
|
b.ToTable("parametres", "core");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.PiecesJointe", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<DateTime?>("DateUpload")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_upload")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<int>("EntiteId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("entite_id");
|
|
|
|
b.Property<string>("EntiteType")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasColumnName("entite_type");
|
|
|
|
b.Property<string>("NomFichier")
|
|
.IsRequired()
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("nom_fichier");
|
|
|
|
b.Property<string>("SharepointItemId")
|
|
.IsRequired()
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("sharepoint_item_id");
|
|
|
|
b.Property<string>("SharepointUrl")
|
|
.IsRequired()
|
|
.HasMaxLength(999)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(999)")
|
|
.HasColumnName("sharepoint_url");
|
|
|
|
b.Property<long>("TailleOctets")
|
|
.HasColumnType("bigint")
|
|
.HasColumnName("taille_octets");
|
|
|
|
b.Property<string>("TypePiece")
|
|
.IsRequired()
|
|
.HasMaxLength(30)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(30)")
|
|
.HasColumnName("type_piece");
|
|
|
|
b.Property<int>("UploaderId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("uploader_id");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__pieces_j__3213E83F9643E6F1");
|
|
|
|
b.HasIndex(new[] { "EntiteType", "EntiteId" }, "IX_pj_entite");
|
|
|
|
b.HasIndex(new[] { "UploaderId" }, "IX_pj_uploader");
|
|
|
|
b.ToTable("pieces_jointes", "core");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Rapprochement", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<string>("Commentaire")
|
|
.HasMaxLength(500)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(500)")
|
|
.HasColumnName("commentaire");
|
|
|
|
b.Property<DateOnly>("DateOperationBanq")
|
|
.HasColumnType("date")
|
|
.HasColumnName("date_operation_banq");
|
|
|
|
b.Property<DateTime?>("DateTraitement")
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_traitement");
|
|
|
|
b.Property<string>("LibelleBanque")
|
|
.HasMaxLength(500)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(500)")
|
|
.HasColumnName("libelle_banque");
|
|
|
|
b.Property<decimal>("MontantBanque")
|
|
.HasColumnType("decimal(18, 2)")
|
|
.HasColumnName("montant_banque");
|
|
|
|
b.Property<int?>("PaiementId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("paiement_id");
|
|
|
|
b.Property<string>("ReferenceBancaire")
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("reference_bancaire");
|
|
|
|
b.Property<string>("Statut")
|
|
.IsRequired()
|
|
.ValueGeneratedOnAdd()
|
|
.HasMaxLength(30)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(30)")
|
|
.HasDefaultValue("A_RAPPROCHER")
|
|
.HasColumnName("statut");
|
|
|
|
b.Property<int?>("TraiteParId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("traite_par_id");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__rapproch__3213E83F92CAA2D1");
|
|
|
|
b.HasIndex(new[] { "PaiementId" }, "IX_rap_paiement");
|
|
|
|
b.HasIndex(new[] { "TraiteParId" }, "IX_rap_traite_par");
|
|
|
|
b.ToTable("rapprochement", "fin");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Service", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<bool>("Actif")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("bit")
|
|
.HasDefaultValue(true)
|
|
.HasColumnName("actif");
|
|
|
|
b.Property<string>("Libelle")
|
|
.IsRequired()
|
|
.HasMaxLength(100)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(100)")
|
|
.HasColumnName("libelle");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__services__3213E83FFB9EB51B");
|
|
|
|
b.ToTable("services", "ref");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.TypesDepense", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<bool>("Actif")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("bit")
|
|
.HasDefaultValue(true)
|
|
.HasColumnName("actif");
|
|
|
|
b.Property<string>("Libelle")
|
|
.IsRequired()
|
|
.HasMaxLength(100)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(100)")
|
|
.HasColumnName("libelle");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__types_de__3213E83FC8C79A18");
|
|
|
|
b.ToTable("types_depense", "ref");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Utilisateur", b =>
|
|
{
|
|
b.Property<int>("Id")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("int")
|
|
.HasColumnName("id");
|
|
|
|
SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
|
|
|
|
b.Property<bool>("Actif")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("bit")
|
|
.HasDefaultValue(true)
|
|
.HasColumnName("actif");
|
|
|
|
b.Property<string>("AzureOid")
|
|
.IsRequired()
|
|
.HasMaxLength(100)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(100)")
|
|
.HasColumnName("azure_oid");
|
|
|
|
b.Property<DateTime?>("DateCreation")
|
|
.ValueGeneratedOnAdd()
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_creation")
|
|
.HasDefaultValueSql("(getdate())");
|
|
|
|
b.Property<DateTime?>("DateDerniereConnexion")
|
|
.HasColumnType("datetime")
|
|
.HasColumnName("date_derniere_connexion");
|
|
|
|
b.Property<string>("Email")
|
|
.IsRequired()
|
|
.HasMaxLength(255)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(255)")
|
|
.HasColumnName("email");
|
|
|
|
b.Property<string>("Nom")
|
|
.IsRequired()
|
|
.HasMaxLength(100)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(100)")
|
|
.HasColumnName("nom");
|
|
|
|
b.Property<string>("Prenom")
|
|
.IsRequired()
|
|
.HasMaxLength(100)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(100)")
|
|
.HasColumnName("prenom");
|
|
|
|
b.Property<string>("Profil")
|
|
.IsRequired()
|
|
.HasMaxLength(20)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(20)")
|
|
.HasColumnName("profil");
|
|
|
|
b.Property<int?>("ResponsableId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("responsable_id");
|
|
|
|
b.Property<int?>("ServiceId")
|
|
.HasColumnType("int")
|
|
.HasColumnName("service_id");
|
|
|
|
b.HasKey("Id")
|
|
.HasName("PK__utilisat__3213E83F466D0E1A");
|
|
|
|
b.HasIndex("ResponsableId");
|
|
|
|
b.HasIndex(new[] { "ServiceId" }, "IX_utilisateurs_service");
|
|
|
|
b.HasIndex(new[] { "AzureOid" }, "UQ__utilisat__2C305FD1B8914BF0")
|
|
.IsUnique();
|
|
|
|
b.ToTable("utilisateurs", "core");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.UtilisateurRole", b =>
|
|
{
|
|
b.Property<string>("AzureOid")
|
|
.HasMaxLength(100)
|
|
.IsUnicode(false)
|
|
.HasColumnType("varchar(100)")
|
|
.HasColumnName("azure_oid");
|
|
|
|
b.Property<string>("Role")
|
|
.HasMaxLength(50)
|
|
.HasColumnType("nvarchar(50)")
|
|
.HasColumnName("role");
|
|
|
|
b.HasKey("AzureOid", "Role")
|
|
.HasName("PK_utilisateur_roles");
|
|
|
|
b.ToTable("utilisateur_roles", "core");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Acompte", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Facture", "Facture")
|
|
.WithMany("Acomptes")
|
|
.HasForeignKey("FactureId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__acomptes__factur__01142BA1");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.PiecesJointe", "Justificatif")
|
|
.WithMany("Acomptes")
|
|
.HasForeignKey("JustificatifId")
|
|
.HasConstraintName("FK__acomptes__justif__02084FDA");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "SaisiePar")
|
|
.WithMany("Acomptes")
|
|
.HasForeignKey("SaisieParId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__acomptes__saisie__02FC7413");
|
|
|
|
b.Navigation("Facture");
|
|
|
|
b.Navigation("Justificatif");
|
|
|
|
b.Navigation("SaisiePar");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.AffectationsAvoir", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "AffectePar")
|
|
.WithMany("AffectationsAvoirs")
|
|
.HasForeignKey("AffecteParId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__affectati__affec__09A971A2");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Avoir", "Avoir")
|
|
.WithMany("AffectationsAvoirs")
|
|
.HasForeignKey("AvoirId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__affectati__avoir__07C12930");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Facture", "Facture")
|
|
.WithMany("AffectationsAvoirs")
|
|
.HasForeignKey("FactureId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__affectati__factu__08B54D69");
|
|
|
|
b.Navigation("AffectePar");
|
|
|
|
b.Navigation("Avoir");
|
|
|
|
b.Navigation("Facture");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Audit", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "Utilisateur")
|
|
.WithMany("Audits")
|
|
.HasForeignKey("UtilisateurId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__audit__utilisate__71D1E811");
|
|
|
|
b.Navigation("Utilisateur");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Avoir", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Facture", "Facture")
|
|
.WithMany("Avoirs")
|
|
.HasForeignKey("FactureId")
|
|
.HasConstraintName("FK__avoirs__facture___04E4BC85");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Fournisseur", "Fournisseur")
|
|
.WithMany("Avoirs")
|
|
.HasForeignKey("FournisseurId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__avoirs__fourniss__03F0984C");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.PiecesJointe", "Justificatif")
|
|
.WithMany("Avoirs")
|
|
.HasForeignKey("JustificatifId")
|
|
.HasConstraintName("FK__avoirs__justific__05D8E0BE");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "SaisiePar")
|
|
.WithMany("Avoirs")
|
|
.HasForeignKey("SaisieParId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__avoirs__saisie_p__06CD04F7");
|
|
|
|
b.Navigation("Facture");
|
|
|
|
b.Navigation("Fournisseur");
|
|
|
|
b.Navigation("Justificatif");
|
|
|
|
b.Navigation("SaisiePar");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.ContratEcheance", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.ContratFournisseur", "Contrat")
|
|
.WithMany("Echeances")
|
|
.HasForeignKey("ContratId")
|
|
.OnDelete(DeleteBehavior.Cascade)
|
|
.IsRequired()
|
|
.HasConstraintName("FK__contrats_echeances__contrat");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.PiecesJointe", "Justificatif")
|
|
.WithMany("ContratEcheances")
|
|
.HasForeignKey("JustificatifId")
|
|
.HasConstraintName("FK__contrats_echeances__justificatif");
|
|
|
|
b.Navigation("Contrat");
|
|
|
|
b.Navigation("Justificatif");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.ContratFournisseur", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Fournisseur", "Fournisseur")
|
|
.WithMany("ContratsFournisseurs")
|
|
.HasForeignKey("FournisseurId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__contrats_fournisseurs__fournisseur");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "SaisiePar")
|
|
.WithMany("ContratsFournisseurs")
|
|
.HasForeignKey("SaisieParId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__contrats_fournisseurs__saisie_par");
|
|
|
|
b.Navigation("Fournisseur");
|
|
|
|
b.Navigation("SaisiePar");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.ContratPrestataire", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Organisme", "Organisme")
|
|
.WithMany("ContratsPrestataires")
|
|
.HasForeignKey("OrganismeId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__contrats_prestataires__organisme");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "SaisiePar")
|
|
.WithMany("ContratsPrestataires")
|
|
.HasForeignKey("SaisieParId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__contrats_prestataires__saisie_par");
|
|
|
|
b.Navigation("Organisme");
|
|
|
|
b.Navigation("SaisiePar");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.DemandesAchat", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "Demandeur")
|
|
.WithMany("DemandesAchatDemandeurs")
|
|
.HasForeignKey("DemandeurId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__demandes___deman__787EE5A0");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Fournisseur", "Fournisseur")
|
|
.WithMany("DemandesAchats")
|
|
.HasForeignKey("FournisseurId")
|
|
.HasConstraintName("FK__demandes___fourn__75A278F5");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.ModesPaiement", "ModePaiement")
|
|
.WithMany("DemandesAchats")
|
|
.HasForeignKey("ModePaiementId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__demandes___mode___778AC167");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Service", "Service")
|
|
.WithMany("DemandesAchats")
|
|
.HasForeignKey("ServiceId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__demandes___servi__74AE54BC");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.TypesDepense", "TypeDepense")
|
|
.WithMany("DemandesAchats")
|
|
.HasForeignKey("TypeDepenseId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__demandes___type___76969D2E");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "Valideur")
|
|
.WithMany("DemandesAchatValideurs")
|
|
.HasForeignKey("ValideurId")
|
|
.HasConstraintName("FK__demandes___valid__797309D9");
|
|
|
|
b.Navigation("Demandeur");
|
|
|
|
b.Navigation("Fournisseur");
|
|
|
|
b.Navigation("ModePaiement");
|
|
|
|
b.Navigation("Service");
|
|
|
|
b.Navigation("TypeDepense");
|
|
|
|
b.Navigation("Valideur");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Facture", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.TypesDepense", "CategorieDepense")
|
|
.WithMany("Factures")
|
|
.HasForeignKey("CategorieDepenseId")
|
|
.HasConstraintName("FK__factures__catego__7C4F7684");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.DemandesAchat", "DemandeAchat")
|
|
.WithMany("Factures")
|
|
.HasForeignKey("DemandeAchatId")
|
|
.HasConstraintName("FK__factures__demand__7A672E12");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Fournisseur", "Fournisseur")
|
|
.WithMany("Factures")
|
|
.HasForeignKey("FournisseurId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__factures__fourni__7B5B524B");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.ModesPaiement", "ModePaiement")
|
|
.WithMany("Factures")
|
|
.HasForeignKey("ModePaiementId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__factures__mode_p__7E37BEF6");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "SaisiePar")
|
|
.WithMany("FactureSaisiePars")
|
|
.HasForeignKey("SaisieParId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__factures__saisie__7F2BE32F");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Service", "Service")
|
|
.WithMany("Factures")
|
|
.HasForeignKey("ServiceId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__factures__servic__7D439ABD");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "ValideBapPar")
|
|
.WithMany("FactureValideBapPars")
|
|
.HasForeignKey("ValideBapParId")
|
|
.HasConstraintName("FK__factures__valide__00200768");
|
|
|
|
b.Navigation("CategorieDepense");
|
|
|
|
b.Navigation("DemandeAchat");
|
|
|
|
b.Navigation("Fournisseur");
|
|
|
|
b.Navigation("ModePaiement");
|
|
|
|
b.Navigation("SaisiePar");
|
|
|
|
b.Navigation("Service");
|
|
|
|
b.Navigation("ValideBapPar");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.FichiersXml", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "GenerePar")
|
|
.WithMany("FichiersXmls")
|
|
.HasForeignKey("GenereParId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__fichiers___gener__0A9D95DB");
|
|
|
|
b.Navigation("GenerePar");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.HistoriqueAction", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "Utilisateur")
|
|
.WithMany("HistoriqueActions")
|
|
.HasForeignKey("UtilisateurId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__historiqu__utili__73BA3083");
|
|
|
|
b.Navigation("Utilisateur");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Paiement", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "EnregistrePar")
|
|
.WithMany("Paiements")
|
|
.HasForeignKey("EnregistreParId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__paiements__enreg__0E6E26BF");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Facture", "Facture")
|
|
.WithMany("Paiements")
|
|
.HasForeignKey("FactureId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__paiements__factu__0B91BA14");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.FichiersXml", "FichierXml")
|
|
.WithMany("Paiements")
|
|
.HasForeignKey("FichierXmlId")
|
|
.HasConstraintName("FK__paiements__fichi__0D7A0286");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.ModesPaiement", "ModeReglement")
|
|
.WithMany("Paiements")
|
|
.HasForeignKey("ModeReglementId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__paiements__mode___0C85DE4D");
|
|
|
|
b.Navigation("EnregistrePar");
|
|
|
|
b.Navigation("Facture");
|
|
|
|
b.Navigation("FichierXml");
|
|
|
|
b.Navigation("ModeReglement");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Parametre", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "ModifieParNavigation")
|
|
.WithMany("Parametres")
|
|
.HasForeignKey("ModifiePar")
|
|
.HasConstraintName("FK__parametre__modif__70DDC3D8");
|
|
|
|
b.Navigation("ModifieParNavigation");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.PiecesJointe", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "Uploader")
|
|
.WithMany("PiecesJointes")
|
|
.HasForeignKey("UploaderId")
|
|
.IsRequired()
|
|
.HasConstraintName("FK__pieces_jo__uploa__72C60C4A");
|
|
|
|
b.Navigation("Uploader");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Rapprochement", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Paiement", "Paiement")
|
|
.WithMany("Rapprochements")
|
|
.HasForeignKey("PaiementId")
|
|
.HasConstraintName("FK__rapproche__paiem__0F624AF8");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "TraitePar")
|
|
.WithMany("Rapprochements")
|
|
.HasForeignKey("TraiteParId")
|
|
.HasConstraintName("FK__rapproche__trait__10566F31");
|
|
|
|
b.Navigation("Paiement");
|
|
|
|
b.Navigation("TraitePar");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Utilisateur", b =>
|
|
{
|
|
b.HasOne("SIFinance.Shared.Entities.Utilisateur", "Responsable")
|
|
.WithMany("Collaborateurs")
|
|
.HasForeignKey("ResponsableId")
|
|
.HasConstraintName("FK__utilisateurs__responsable");
|
|
|
|
b.HasOne("SIFinance.Shared.Entities.Service", "Service")
|
|
.WithMany("Utilisateurs")
|
|
.HasForeignKey("ServiceId")
|
|
.HasConstraintName("FK__utilisate__servi__6FE99F9F");
|
|
|
|
b.Navigation("Responsable");
|
|
|
|
b.Navigation("Service");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Avoir", b =>
|
|
{
|
|
b.Navigation("AffectationsAvoirs");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.ContratFournisseur", b =>
|
|
{
|
|
b.Navigation("Echeances");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.DemandesAchat", b =>
|
|
{
|
|
b.Navigation("Factures");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Facture", b =>
|
|
{
|
|
b.Navigation("Acomptes");
|
|
|
|
b.Navigation("AffectationsAvoirs");
|
|
|
|
b.Navigation("Avoirs");
|
|
|
|
b.Navigation("Paiements");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.FichiersXml", b =>
|
|
{
|
|
b.Navigation("Paiements");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Fournisseur", b =>
|
|
{
|
|
b.Navigation("Avoirs");
|
|
|
|
b.Navigation("ContratsFournisseurs");
|
|
|
|
b.Navigation("DemandesAchats");
|
|
|
|
b.Navigation("Factures");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.ModesPaiement", b =>
|
|
{
|
|
b.Navigation("DemandesAchats");
|
|
|
|
b.Navigation("Factures");
|
|
|
|
b.Navigation("Paiements");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Organisme", b =>
|
|
{
|
|
b.Navigation("ContratsPrestataires");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Paiement", b =>
|
|
{
|
|
b.Navigation("Rapprochements");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.PiecesJointe", b =>
|
|
{
|
|
b.Navigation("Acomptes");
|
|
|
|
b.Navigation("Avoirs");
|
|
|
|
b.Navigation("ContratEcheances");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Service", b =>
|
|
{
|
|
b.Navigation("DemandesAchats");
|
|
|
|
b.Navigation("Factures");
|
|
|
|
b.Navigation("Utilisateurs");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.TypesDepense", b =>
|
|
{
|
|
b.Navigation("DemandesAchats");
|
|
|
|
b.Navigation("Factures");
|
|
});
|
|
|
|
modelBuilder.Entity("SIFinance.Shared.Entities.Utilisateur", b =>
|
|
{
|
|
b.Navigation("Acomptes");
|
|
|
|
b.Navigation("AffectationsAvoirs");
|
|
|
|
b.Navigation("Audits");
|
|
|
|
b.Navigation("Avoirs");
|
|
|
|
b.Navigation("Collaborateurs");
|
|
|
|
b.Navigation("ContratsFournisseurs");
|
|
|
|
b.Navigation("ContratsPrestataires");
|
|
|
|
b.Navigation("DemandesAchatDemandeurs");
|
|
|
|
b.Navigation("DemandesAchatValideurs");
|
|
|
|
b.Navigation("FactureSaisiePars");
|
|
|
|
b.Navigation("FactureValideBapPars");
|
|
|
|
b.Navigation("FichiersXmls");
|
|
|
|
b.Navigation("HistoriqueActions");
|
|
|
|
b.Navigation("Paiements");
|
|
|
|
b.Navigation("Parametres");
|
|
|
|
b.Navigation("PiecesJointes");
|
|
|
|
b.Navigation("Rapprochements");
|
|
});
|
|
#pragma warning restore 612, 618
|
|
}
|
|
}
|
|
}
|