using System;
using System.ComponentModel.DataAnnotations.Schema;
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Metadata;

#nullable disable

namespace Teso_API.Models
{
    public partial class TESOContext : DbContext
    {
        public TESOContext(DbContextOptions<TESOContext> options)
            : base(options)
        {
        }


        public virtual DbSet<ActivationCodes> ActivationCodes { get; set; }
        public virtual DbSet<BusinessCategory> BusinessCategories { get; set; }
        public virtual DbSet<ResetPasswords> ResetPasswords { get; set; }
        public virtual DbSet<Relations> Relationships { get; set; }
        public virtual DbSet<RelationsDetail> RelationsDetails { get; set; }
        public virtual DbSet<RelationType> RelationTypes { get; set; }
        public virtual DbSet<AccountType> AccountTypes { get; set; }
        public virtual DbSet<CoinType> CoinTypes { get; set; }
        public virtual DbSet<CampAd> CampAds { get; set; }
        public virtual DbSet<CommentsPost> CommentsPosts { get; set; }
        public virtual DbSet<Campaign> Campaigns { get; set; }
        public virtual DbSet<CampaignFund> CampaignFunds { get; set; }
        public virtual DbSet<CouponCondition> CouponConditions { get; set; }
        public virtual DbSet<TesoUserDetail> TesoUserDetails { get; set; }
        public virtual DbSet<TransactionType> TransactionTypes { get; set; }
        public virtual DbSet<UserAuth> UserAuths { get; set; }
        public virtual DbSet<UserFinance> UserFinances { get; set; }
        public virtual DbSet<UserFavCategory> UserFavCategories { get; set; }
        public virtual DbSet<ProductCategory> ProductCategories { get; set; }
        public virtual DbSet<UserTransaction> UserTransactions { get; set; }
        public virtual DbSet<CouponType> CouponTypes { get; set; }
        public virtual DbSet<CouponAcquisition> CouponAcquisitions { get; set; }
        public virtual DbSet<CouponsHead> CouponsHeads { get; set; }
        public virtual DbSet<CouponsDeclined> CouponsDeclineds { get; set; }
        public virtual DbSet<Post> Posts { get; set; }
        public virtual DbSet<PostFav> PostFavs { get; set; }
        public virtual DbSet<Product> Products { get; set; }
        public virtual DbSet<UserCouponBank> UserCouponBanks { get; set; }
        public virtual DbSet<TesoBusinessDetail> TesoBusinessDetails { get; set; }
        public virtual DbSet<DesireDetail> DesireDetails { get; set; }
        public virtual DbSet<DesireHead> DesireHeads { get; set; }
        public virtual DbSet<PendingDeleteFile> PendingDeleteFiles { get; set; }
        public virtual DbSet<TrendingProduct> TrendingProducts { get; set; }
        public virtual DbSet<SilverBank> SilverBanks { get; set; }
        public virtual DbSet<CouponRedemption> CouponRedemptions { get; set; }
        public virtual DbSet<DailyVisit> DailyVisits { get; set; }
        public virtual DbSet<DeletedProduct> DeletedProducts { get; set; }
        public virtual DbSet<PostView> PostViews { get; set; }
        public virtual DbSet<Referral> Referrals { get; set; }
        public virtual DbSet<CoinPurchase> CoinPurchases { get; set; }
        public virtual DbSet<Report> Reports { get; set; }
        public virtual DbSet<ReportedContent> ReportedContents { get; set; }
        public virtual DbSet<BlockedUser> BlockedUsers { get; set; }
        public virtual DbSet<ProductImages> ProductImaging { get; set; }
        public virtual DbSet<CouponsSpecial> CouponsSpecials { get; set; }

        #region unmapped Entites
        //unmapped Entites
        [NotMapped]
        public virtual DbSet<CouponDetails> Details { get; set; }
        [NotMapped]
        public virtual DbSet<ProximityCoupon> ProximityCoupons { get; set; }
        [NotMapped]
        public virtual DbSet<DesiredItem> Desires { get; set; }
       
        #endregion

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.HasAnnotation("Relational:Collation", "SQL_Latin1_General_CP1_CI_AS");

            modelBuilder.Entity<AccountType>(entity =>
            {
                entity.HasKey(e => e.TypeCode);

                entity.Property(e => e.TypeCode)
                    .HasMaxLength(10)
                    .IsUnicode(false)
                    .HasColumnName("typeCode");

                entity.Property(e => e.TypeName)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("typeName");
            });

            modelBuilder.Entity<Relations>(entity =>
            {
                entity.ToTable("Relations");
                entity.HasKey(e => e.CountId);

                entity.Property(e => e.CountId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("countID");

                entity.Property(e => e.RelationId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("relation_id");

                entity.Property(e => e.UserGuid)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("userGuid");
            });
            
            modelBuilder.Entity<CampaignFund>(entity =>
            {
                entity.HasKey(e => e.CampaignId);

                entity.Property(e => e.BusinessId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("businessID");

                entity.Property(e => e.CampaignId)
                    .IsRequired()
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("campaignID");

                entity.Property(e => e.CoinsAvailable).HasColumnName("coinsAvailable");
            });
            modelBuilder.Entity<Referral>(entity =>
            {
                entity.HasKey(e => e.CountId);

                entity.Property(e => e.CountId).HasColumnName("countID");

                entity.Property(e => e.Datejoined).HasColumnName("datejoined");

                entity.Property(e => e.Referred)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("referred");

                entity.Property(e => e.Referrer)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("referrer");

                entity.Property(e => e.Rewarded).HasColumnName("rewarded");
            });
            modelBuilder.Entity<RelationType>(entity =>
            {
                entity.HasKey(e => e.TypeCode);

                entity.ToTable("RelationType");

                entity.Property(e => e.TypeCode)
                    .HasMaxLength(5)
                    .IsUnicode(false)
                    .HasColumnName("typeCode");

                entity.Property(e => e.TypeName)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("typeName");
            });

            modelBuilder.Entity<RelationsDetail>(entity =>
            {
                entity.HasKey(e => e.RelationId);

                entity.ToTable("RelationsDetail");

                entity.Property(e => e.RelationId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("relation_id");

                entity.Property(e => e.ApprovalDate).HasColumnName("approval_date");

                entity.Property(e => e.BeneficiaryRecipient)
                    .IsRequired()
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("beneficiary_recipient");

                entity.Property(e => e.BeneficiaryRequester)
                    .IsRequired()
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("beneficiary_requester");

                entity.Property(e => e.RelationType)
                    .IsRequired()
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("relation_type");

                entity.Property(e => e.RequestDate).HasColumnName("request_date");

                entity.Property(e => e.Status)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("status");
            });

            modelBuilder.Entity<CoinType>(entity =>
            {
                entity.HasKey(e => e.TypeCode);

                entity.Property(e => e.TypeCode)
                    .HasMaxLength(8)
                    .IsUnicode(false)
                    .HasColumnName("typeCode");

                entity.Property(e => e.TypeName)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("typeName");
            });

            modelBuilder.Entity<TesoBusinessDetail>(entity =>
            {
                entity.HasKey(e => e.BusinessId);
                entity.ToTable("TesoBusinessDetail");

                entity.Property(e => e.BusinessId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("businessID");

                entity.Property(e => e.BusinessAddress)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("businessAddress");

                entity.Property(e => e.BusinessCategory)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("businessCategory");

                entity.Property(e => e.BusinessContact)
                    .HasMaxLength(15)
                    .IsUnicode(false)
                    .HasColumnName("businessContact");

                entity.Property(e => e.BusinessDescription)
                    .HasMaxLength(200)
                    .IsUnicode(false)
                    .HasColumnName("businessDescription");

                entity.Property(e => e.BusinessEmail)
                    .HasMaxLength(200)
                    .IsUnicode(false)
                    .HasColumnName("businessEmail");

                entity.Property(e => e.BusinessLat)
                    .HasMaxLength(100)
                    .IsUnicode(false)
                    .HasColumnName("businessLAT");

                entity.Property(e => e.BusinessLng)
                    .HasMaxLength(100)
                    .IsUnicode(false)
                    .HasColumnName("businessLNG");

                entity.Property(e => e.BusinessLogo)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("businessLogo");

                entity.Property(e => e.BusinessName)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("businessName");

                entity.Property(e => e.BusinessTin)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("businessTIN");

                entity.Property(e => e.DateOfEst)
                    .HasColumnType("date")
                    .HasColumnName("dateOfEst");

                entity.Property(e => e.Handle)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("handle");
            });

            modelBuilder.Entity<TransactionType>(entity =>
            {
                entity.HasKey(e => e.TypeCode);

                entity.Property(e => e.TypeCode)
                    .HasMaxLength(10)
                    .IsUnicode(false)
                    .HasColumnName("typeCode");

                entity.Property(e => e.TypeName)
                    .HasMaxLength(30)
                    .IsUnicode(false)
                    .HasColumnName("typeName");
            });

            modelBuilder.Entity<ActivationCodes>(entity =>
            {
                entity.HasKey(e => e.CodeGuid);

                entity.ToTable("ActivationCodes");

                entity.Property(e => e.CodeGuid)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("codeGUID");

                entity.Property(e => e.UserGuid)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("userGuid");

                entity.Property(e => e.Code)
                    .HasColumnName("code");

                entity.Property(e => e.DateGenerated)
                    .IsUnicode(false)
                    .HasColumnName("dateGenerated");

            });
      
            modelBuilder.Entity<ResetPasswords>(entity =>
            {
                entity.HasKey(e => e.ResetGuid);

                entity.ToTable("PasswordResetCodes");

                entity.Property(e => e.ResetGuid)
                    .IsUnicode(false)
                    .HasColumnName("resetGUID");

                entity.Property(e => e.UserGuid)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("userGUID");

                entity.Property(e => e.ResetCode)
                    .HasColumnName("resetCode");

                entity.Property(e => e.DateGenerated)
                    .IsUnicode(false)
                    .HasColumnName("dateGenerated");

            });
           
            modelBuilder.Entity<UserAuth>(entity =>
            {
                entity.HasKey(e => e.Username);

                entity.ToTable("UserAuth");

                entity.Property(e => e.UserGUID)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("userGUID");

                entity.Property(e => e.Username)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("username");

                entity.Property(e => e.AccountType)
                    .HasMaxLength(10)
                    .IsUnicode(false)
                    .HasColumnName("accountType");

                entity.Property(e => e.DeviceToken)
                    .IsUnicode(false)
                    .HasColumnName("device_token");

                entity.Property(e => e.Password)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("password");

                entity.Property(e => e.Status)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("status");
            });

            modelBuilder.Entity<UserFinance>(entity =>
            {
                entity.HasKey(e => e.UserGUID);

                entity.ToTable("UserFinance");

                entity.Property(e => e.UserGUID)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("userGUID");

                entity.Property(e => e.Gold).HasColumnName("gold");

                entity.Property(e => e.Silver).HasColumnName("silver");
            });

            modelBuilder.Entity<UserTransaction>(entity =>
            {
                entity.HasKey(e => e.TransactionID);

                entity.Property(e => e.UserGUID)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("userGUID");

                entity.Property(e => e.CoinAmount).HasColumnName("coinAmount");

                entity.Property(e => e.CoinType)
                    .HasMaxLength(8)
                    .IsUnicode(false)
                    .HasColumnName("coinType");

                entity.Property(e => e.Comments)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("comments");

                entity.Property(e => e.RealCash)
                    .HasColumnType("decimal(19, 2)")
                    .HasColumnName("realCash");

                entity.Property(e => e.TransactionType)
                    .HasMaxLength(10)
                    .IsUnicode(false)
                    .HasColumnName("transactionType");

                entity.Property(e => e.Timestamp).HasColumnName("timestamp");

                entity.Property(e => e.TransactionID)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("transactionID");
            });

            modelBuilder.Entity<ProductCategory>(entity =>
            {
                entity.HasNoKey();

                entity.Property(e => e.CatCode)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("catCode");

                entity.Property(e => e.CatName)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("catName");
            });
           
            modelBuilder.Entity<UserFavCategory>(entity =>
            {
                entity.HasKey(e => e.CountId);

                entity.ToTable("UserFavCategory");

                entity.Property(e => e.CountId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("countID");

                entity.Property(e => e.CatCode)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("catCode");

                entity.Property(e => e.UserGuid)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("userGUID");
            });

            modelBuilder.Entity<CouponAcquisition>(entity =>
            {
                entity.HasKey(e => e.CountId);

                entity.ToTable("CouponAcquisition");

                entity.Property(e => e.CountId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("countID");

                entity.Property(e => e.CouponId)
                    .IsRequired()
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("couponID");

                entity.Property(e => e.Dateacquired).HasColumnName("dateacquired");
                entity.Property(e => e.Expiration).HasColumnName("expiration");

                entity.Property(e => e.Mode)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("mode");

                entity.Property(e => e.SilverCost).HasColumnName("silverCost");

                entity.Property(e => e.UserGuid)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("userGuid");

                entity.Property(e => e.Worth).HasColumnName("worth");
            });

            modelBuilder.Entity<CouponType>(entity =>
            {
                entity.HasKey(e => e.TypeCode);

                entity.Property(e => e.TypeCode)
                    .HasMaxLength(10)
                    .IsUnicode(false)
                    .HasColumnName("typeCode");

                entity.Property(e => e.TypeName)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("typeName");
            });

            modelBuilder.Entity<CouponsHead>(entity =>
            {
                entity.HasKey(e => e.CouponId);

                entity.ToTable("CouponsHead");

                entity.Property(e => e.CouponId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("couponID");

                entity.Property(e => e.BusinessId)
                    .IsRequired()
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("businessID");

                entity.Property(e => e.Expiration).HasColumnName("expiration");

                entity.Property(e => e.Generated).HasColumnName("generated");

                entity.Property(e => e.LowerLimit).HasColumnName("lowerLimit");
                entity.Property(e => e.UpperLimit).HasColumnName("upperLimit");

                entity.Property(e => e.Quantity).HasColumnName("quantity");

                entity.Property(e => e.State)
                    .HasMaxLength(12)
                    .IsUnicode(false)
                    .HasColumnName("state");

                entity.Property(e => e.TargetProduct)
                    .IsRequired()
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("productID");

                entity.Property(e => e.Type)
                    .HasMaxLength(10)
                    .IsUnicode(false)
                    .HasColumnName("type");
            });

            modelBuilder.Entity<Product>(entity =>
            {
                entity.Property(e => e.ProductId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("productID");

                entity.Property(e => e.BusinessId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("businessID");

                entity.Property(e => e.Category)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("category");

                entity.Property(e => e.Description)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("pdescription");

                entity.Property(e => e.Name)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("pname");

                entity.Property(e => e.ProductImage)
                    .HasMaxLength(200)
                    .IsUnicode(false)
                    .HasColumnName("productImage");

                entity.Property(e => e.UnitPrice)
                    .HasColumnType("decimal(19, 2)")
                    .HasColumnName("unitPrice");

            });

            modelBuilder.Entity<UserCouponBank>(entity =>
            {
                entity.HasKey(e => e.CountId);

                entity.ToTable("UserCouponBank");

                entity.Property(e => e.CountId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("countID");

                entity.Property(e => e.CouponId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("couponID");

                entity.Property(e => e.UserGuid)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("userGuid");

                entity.Property(e => e.Worth).HasColumnName("worth");
                entity.Property(e => e.Expiration).HasColumnName("expiration");
            });

            modelBuilder.Entity<CouponsDeclined>(entity =>
            {
                entity.HasKey(e => e.CountId);

                entity.ToTable("CouponsDeclined");

                entity.Property(e => e.CountId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("countID");

                entity.Property(e => e.CouponId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("couponID");

                entity.Property(e => e.DateDeclined).HasColumnName("dateDeclined");

                entity.Property(e => e.UserGuid)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("userGUID");
            });

            modelBuilder.Entity<TesoUserDetail>(entity =>
            {
                entity.HasKey(e => e.UserGUID);

                entity.Property(e => e.UserGUID)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("userGUID");

                entity.Property(e => e.Address)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("address");

                entity.Property(e => e.Country)
                    .HasMaxLength(5)
                    .IsUnicode(false)
                    .HasColumnName("country");

                entity.Property(e => e.DateOfBirth)
                    .HasColumnType("date")
                    .HasColumnName("dateOfBirth");

                entity.Property(e => e.Description)
                    .IsRequired()
                    .HasMaxLength(120)
                    .IsUnicode(false)
                    .HasColumnName("description")
                    .HasDefaultValueSql("('Hey there, a new on Teso !!!')");

                entity.Property(e => e.Email)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("email");

                entity.Property(e => e.Firstname)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("firstname");

                entity.Property(e => e.Gender)
                    .HasMaxLength(6)
                    .IsUnicode(false)
                    .HasColumnName("gender");

                entity.Property(e => e.Phonenumber).HasColumnName("phonenumber");

                entity.Property(e => e.Surname)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("surname");

                entity.Property(e => e.ThumbnailDp)
                    .IsUnicode(false)
                    .HasColumnName("thumbnail_dp");

                entity.Property(e => e.Username)
                    .IsRequired()
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("username");
            });

            modelBuilder.Entity<CouponDetails>(entity =>
            {
                entity.HasKey(e => e.CouponId);

            });

            modelBuilder.Entity<ProximityCoupon>(entity =>
            {
                entity.HasKey(e => e.CouponId);
                entity.Property(e => e.targetCost)
                    .HasColumnType("decimal(19,2)");

            });

            modelBuilder.Entity<DesiredItem>(entity =>
            {
                entity.HasKey(e => e.productID);

            });

            modelBuilder.Entity<DesireDetail>(entity =>
            {
                entity.HasKey(e => e.CountId);

                entity.Property(e => e.CountId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("countID");

                entity.Property(e => e.Category)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("category");

                entity.Property(e => e.DesireGuid)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("desireGUID");

                entity.Property(e => e.Enlisted).HasColumnName("enlisted");

                entity.Property(e => e.ProductId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("productID");
            });

            modelBuilder.Entity<DesireHead>(entity =>
            {
                entity.HasKey(e => e.DesireGuid);

                entity.ToTable("DesireHead");

                entity.Property(e => e.DesireGuid)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("desireGUID");

                entity.Property(e => e.Month)
                    .HasColumnType("date")
                    .HasColumnName("month");

                entity.Property(e => e.UserGuid)
                    .IsRequired()
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("userGUID");
            });

            modelBuilder.Entity<Campaign>(entity =>
            {
                entity.ToTable("Campaigns");
                entity.Property(e => e.CampaignId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("campaignID");

                entity.Property(e => e.BusinessId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("businessID");

                entity.Property(e => e.Description)
                    .HasMaxLength(200)
                    .IsUnicode(false)
                    .HasColumnName("description");

                entity.Property(e => e.Rewards).HasColumnName("rewards");

                entity.Property(e => e.StartDate).HasColumnName("startDate");

                entity.Property(e => e.EndDate).HasColumnName("endDate");

                entity.Property(e => e.Status)
                    .HasMaxLength(10)
                    .IsUnicode(false)
                    .HasColumnName("status");

                entity.Property(e => e.TargetProduct)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("targetProduct");

                entity.Property(e => e.Title)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("title");
            });

            modelBuilder.Entity<BusinessCategory>(entity =>
            {
                entity.HasKey(e => e.CategoryCode);

                entity.ToTable("BusinessCategory");

                entity.Property(e => e.CategoryCode)
                    .HasMaxLength(10)
                    .IsUnicode(false)
                    .HasColumnName("categoryCode");

                entity.Property(e => e.CategoryName)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("categoryName");
            });

            modelBuilder.Entity<CouponCondition>(entity =>
            {
                entity.HasKey(e => e.CouponId);

                entity.ToTable("CouponCondition");

                entity.Property(e => e.CouponId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("couponID");

                entity.Property(e => e.Condition)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("condition");
            });

            modelBuilder.Entity<CampAd>(entity =>
            {
                entity.HasKey(e => e.PostId);

                entity.Property(e => e.PostId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("postID");

                entity.Property(e => e.Approved).HasColumnName("approved");

                entity.Property(e => e.Date_Processed).HasColumnName("date_processed");

                entity.Property(e => e.CampaignId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("campaignID");
            });

            modelBuilder.Entity<CommentsPost>(entity =>
            {
                entity.HasKey(e => e.CommentId);

                entity.ToTable("CommentsPost");

                entity.Property(e => e.CommentId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("commentID");

                entity.Property(e => e.Comment).HasColumnName("comment");

                entity.Property(e => e.CommenterId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("commenterID");

                entity.Property(e => e.PostId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("postID");

                entity.Property(e => e.Timestamp).HasColumnName("timestamp");
            });

            modelBuilder.Entity<Post>(entity =>
            {
                entity.Property(e => e.PostId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("postID");

                entity.Property(e => e.PlaybackID)
                    .IsUnicode(false)
                    .HasColumnName("playbackID");

                entity.Property(e => e.PublisherId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("publisherID");

                entity.Property(e => e.Aspect)
                   .HasMaxLength(50)
                   .IsUnicode(false)
                   .HasColumnName("aspect");

                entity.Property(e => e.Title)
                    .HasColumnName("title");

                entity.Property(e => e.AssetID)
                    .HasColumnName("assetID");
                entity.Property(e => e.Rendition)
                    .HasColumnName("static_rendition");
                entity.Property(e => e.Timestamp).HasColumnName("timestamp");
            });

            modelBuilder.Entity<PostFav>(entity =>
            {
                entity.HasKey(e => e.CountId);

                entity.Property(e => e.CountId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("countID");

                entity.Property(e => e.AdmirerId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("admirerID");

                entity.Property(e => e.PostId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("postID");

                entity.Property(e => e.Timestamp).HasColumnName("timestamp");
            });

            modelBuilder.Entity<PendingDeleteFile>(entity =>
            {
                entity.HasKey(e => e.CountId);

                entity.Property(e => e.CountId)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("countID");

                entity.Property(e => e.DateDeleted).HasColumnName("dateDeleted");

                entity.Property(e => e.Filename)
                    .IsUnicode(false)
                    .HasColumnName("filename");
            });

            modelBuilder.Entity<TrendingProduct>(entity =>
            {
                entity.HasKey(e => e.ProductId);

                entity.Property(e => e.ProductId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("productID");

                entity.Property(e => e.Views).HasColumnName("views");
            });

            modelBuilder.Entity<SilverBank>(entity =>
            {
                entity.HasKey(e => e.TransactionId);

                entity.ToTable("@SilverBank");

                entity.Property(e => e.TransactionId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("transactionID");

                entity.Property(e => e.Amount).HasColumnName("amount");
                entity.Property(e => e.Balance).HasColumnName("balance");

                entity.Property(e => e.Timestamp).HasColumnName("timestamp");

                entity.Property(e => e.TransactionType)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("transactionType");
            });

            modelBuilder.Entity<DailyVisit>(entity =>
            {
                entity.HasKey(e => e.CountId);

                entity.Property(e => e.CountId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("countID");

                entity.Property(e => e.BusinessId)
                    .HasMaxLength(120)
                    .IsUnicode(false)
                    .HasColumnName("businessID");

                entity.Property(e => e.Timestamp).HasColumnName("timestamp");

                entity.Property(e => e.UserGuid)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("userGUID");
            });

            modelBuilder.Entity<PostView>(entity =>
            {
                entity.HasKey(e => e.CountId);
                entity.Property(e => e.Timestamp).HasColumnName("timestamp");
                entity.Property(e => e.CountId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("countID");

                entity.Property(e => e.PostId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("postID");

                entity.Property(e => e.UserGuid)
                    .HasMaxLength(120)
                    .IsUnicode(false)
                    .HasColumnName("userGUID");
            });

            modelBuilder.Entity<CouponRedemption>(entity =>
            {
                entity.HasKey(e => e.CountId);

                entity.ToTable("CouponRedemption");

                entity.Property(e => e.CountId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("countID");

                entity.Property(e => e.CouponId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("couponID");

                entity.Property(e => e.Discount).HasColumnName("discount");

                entity.Property(e => e.Timestamp).HasColumnName("timestamp");

                entity.Property(e => e.UserGuid)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("userGUID");

                entity.Property(e => e.Worth)
                    .HasColumnType("decimal(19, 2)")
                    .HasColumnName("worth");
            });

            modelBuilder.Entity<DeletedProduct>(entity =>
            {
                entity.HasKey(e => e.ProductID);

                entity.ToTable("DeleteProducts");

                entity.Property(e => e.ProductID)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("productID");

                entity.Property(e => e.CategoryID)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("category");

                entity.Property(e => e.ProductDesc)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("pdescription");

                entity.Property(e => e.ProductName)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("pname");

                entity.Property(e => e.BusinessID)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("businessID");

                entity.Property(e => e.ProductImage)
                    .HasMaxLength(200)
                    .IsUnicode(false)
                    .HasColumnName("productImage");

                entity.Property(e => e.UnitPrice)
                    .HasColumnType("decimal(19, 2)")
                    .HasColumnName("unitPrice");
            });
            modelBuilder.Entity<CoinPurchase>(entity =>
            {
                entity.HasKey(e => e.OrderId);

                entity.ToTable("CoinPurchase");

                entity.Property(e => e.OrderId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("orderID");

                entity.Property(e => e.Amountcash)
                    .HasColumnType("decimal(19, 2)")
                    .HasColumnName("amountcash");

                entity.Property(e => e.Coins).HasColumnName("coins");

                entity.Property(e => e.Cointype)
                    .IsRequired()
                    .HasMaxLength(10)
                    .IsUnicode(false)
                    .HasColumnName("cointype");

                entity.Property(e => e.Customerid)
                    .IsRequired()
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("customerid");

                entity.Property(e => e.ExpresspayTransId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("expresspay_transID");

                entity.Property(e => e.Status).HasColumnName("status");

                entity.Property(e => e.TokenId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("tokenID");

                entity.Property(e => e.TransactionDate).HasColumnName("transaction_date");
            });
            modelBuilder.Entity<Report>(entity =>
            {
                entity.Property(e => e.Id).HasColumnName("id");

                entity.Property(e => e.Description)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("description");
            });

            modelBuilder.Entity<ReportedContent>(entity =>
            {
                entity.HasKey(e => new { e.UserGuid, e.PostId });

                entity.ToTable("ReportedContent");

                entity.Property(e => e.UserGuid)
                    .HasMaxLength(250)
                    .IsUnicode(false)
                    .HasColumnName("userGUID");

                entity.Property(e => e.PostId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("postID");

                entity.Property(e => e.PublisherId)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("publisherID");

                entity.Property(e => e.Report).HasColumnName("report");

                entity.Property(e => e.Timestamp).HasColumnName("timestamp");

                entity.HasOne(d => d.ReportNavigation)
                    .WithMany(p => p.ReportedContents)
                    .HasForeignKey(d => d.Report)
                    .HasConstraintName("FK_ReportedContent_Report");
            });

            modelBuilder.Entity<BlockedUser>(entity =>
            {
                entity.HasKey(e => new { e.Initiator, e.Timestamp, e.Target });

                entity.ToTable("BlockedUser");

                entity.Property(e => e.Initiator)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("initiator");

                entity.Property(e => e.Timestamp).HasColumnName("timestamp");

                entity.Property(e => e.Target)
                    .HasMaxLength(150)
                    .IsUnicode(false)
                    .HasColumnName("target");
            }); ;
            modelBuilder.Entity<CouponsSpecial>(entity =>
            {
                entity.HasKey(e => new { e.CouponId, e.BusinessId });

                entity.ToTable("CouponsSpecial");

                entity.Property(e => e.CouponId)
                    .HasMaxLength(250)
                    .IsUnicode(false)
                    .HasColumnName("couponID");

                entity.Property(e => e.BusinessId)
                    .HasMaxLength(250)
                    .IsUnicode(false)
                    .HasColumnName("businessID");

                entity.Property(e => e.BusinessAddress)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("businessAddress");

                entity.Property(e => e.BusinessCategory)
                    .HasMaxLength(20)
                    .IsUnicode(false)
                    .HasColumnName("businessCategory");

                entity.Property(e => e.BusinessContact)
                    .HasMaxLength(15)
                    .IsUnicode(false)
                    .HasColumnName("businessContact")
                    .HasDefaultValueSql("((0))");

                entity.Property(e => e.BusinessDescription)
                    .IsRequired()
                    .IsUnicode(false)
                    .HasColumnName("businessDescription")
                    .HasDefaultValueSql("('Registered Teso Business')");

                entity.Property(e => e.BusinessDigitalAddress)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("businessDigitalAddress");

                entity.Property(e => e.BusinessEmail)
                    .HasMaxLength(200)
                    .IsUnicode(false)
                    .HasColumnName("businessEmail");

                entity.Property(e => e.BusinessLat)
                    .HasMaxLength(100)
                    .IsUnicode(false)
                    .HasColumnName("businessLAT");

                entity.Property(e => e.BusinessLng)
                    .HasMaxLength(100)
                    .IsUnicode(false)
                    .HasColumnName("businessLNG");

                entity.Property(e => e.BusinessLogo)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("businessLogo");

                entity.Property(e => e.BusinessName)
                    .HasMaxLength(50)
                    .IsUnicode(false)
                    .HasColumnName("businessName");

                entity.Property(e => e.DateOfEst)
                    .HasColumnType("date")
                    .HasColumnName("dateOfEst")
                    .HasDefaultValueSql("('2021-01-01')");
            });

            modelBuilder.Entity<ProductImages>(entity =>
            {
                entity.HasKey(e => new { e.Id });

                entity.ToTable("ProductImages");

                entity.Property(e => e.Id)
                    .HasColumnName("id");

                entity.Property(e => e.ProductID)
                    .HasMaxLength(250)
                    .IsUnicode(false)
                    .HasColumnName("productID");


            });

            OnModelCreatingPartial(modelBuilder);
        }

        partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
    }
}