You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1329 lines
46 KiB
1329 lines
46 KiB
3 months ago
|
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);
|
||
|
|
}
|
||
|
|
}
|