WebCMSEntities.cs 41 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071
  1. using System;
  2. using Microsoft.EntityFrameworkCore;
  3. using Microsoft.EntityFrameworkCore.Metadata;
  4. namespace MySystem.CashModels
  5. {
  6. public partial class WebCMSEntities : DbContext
  7. {
  8. public WebCMSEntities()
  9. {
  10. }
  11. public WebCMSEntities(DbContextOptions<WebCMSEntities> options)
  12. : base(options)
  13. {
  14. }
  15. public virtual DbSet<ChannelBank> ChannelBank { get; set; }
  16. public virtual DbSet<ChannelSet> ChannelSet { get; set; }
  17. public virtual DbSet<PlatAccount> PlatAccount { get; set; }
  18. public virtual DbSet<PlatAccountBalance> PlatAccountBalance { get; set; }
  19. public virtual DbSet<RecNoForWithdrawRecord> RecNoForWithdrawRecord { get; set; }
  20. public virtual DbSet<RightDic> RightDic { get; set; }
  21. public virtual DbSet<SysLog> SysLog { get; set; }
  22. public virtual DbSet<UserIdentity> UserIdentity { get; set; }
  23. public virtual DbSet<UserTaxSign> UserTaxSign { get; set; }
  24. public virtual DbSet<WithdrawBlackList> WithdrawBlackList { get; set; }
  25. public virtual DbSet<WithdrawConfig> WithdrawConfig { get; set; }
  26. public virtual DbSet<WithdrawRecord> WithdrawRecord { get; set; }
  27. protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
  28. {
  29. if (!optionsBuilder.IsConfigured)
  30. {
  31. optionsBuilder.UseMySql(Library.ConfigurationManager.AppSettings["CashSqlConnStr"].ToString(), x => x.ServerVersion("5.7.17-mysql"));
  32. }
  33. }
  34. protected override void OnModelCreating(ModelBuilder modelBuilder)
  35. {
  36. modelBuilder.Entity<ChannelBank>(entity =>
  37. {
  38. entity.Property(e => e.Id).HasColumnType("int(11)");
  39. entity.Property(e => e.BankCode)
  40. .HasColumnType("varchar(16)")
  41. .HasCharSet("utf8")
  42. .HasCollation("utf8_general_ci");
  43. entity.Property(e => e.BankName)
  44. .HasColumnType("varchar(64)")
  45. .HasCharSet("utf8")
  46. .HasCollation("utf8_general_ci");
  47. entity.Property(e => e.ChannelCode)
  48. .HasColumnType("varchar(16)")
  49. .HasCharSet("utf8")
  50. .HasCollation("utf8_general_ci");
  51. entity.Property(e => e.ChannelName)
  52. .HasColumnType("varchar(32)")
  53. .HasCharSet("utf8")
  54. .HasCollation("utf8_general_ci");
  55. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  56. entity.Property(e => e.CreateMan)
  57. .HasColumnType("varchar(50)")
  58. .HasCharSet("utf8")
  59. .HasCollation("utf8_general_ci");
  60. entity.Property(e => e.PicUrl)
  61. .HasColumnType("varchar(256)")
  62. .HasCharSet("utf8")
  63. .HasCollation("utf8_general_ci");
  64. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  65. entity.Property(e => e.SeoDescription)
  66. .HasColumnType("varchar(500)")
  67. .HasCharSet("utf8")
  68. .HasCollation("utf8_general_ci");
  69. entity.Property(e => e.SeoKeyword)
  70. .HasColumnType("varchar(200)")
  71. .HasCharSet("utf8")
  72. .HasCollation("utf8_general_ci");
  73. entity.Property(e => e.SeoTitle)
  74. .HasColumnType("varchar(100)")
  75. .HasCharSet("utf8")
  76. .HasCollation("utf8_general_ci");
  77. entity.Property(e => e.Sort).HasColumnType("int(11)");
  78. entity.Property(e => e.Status).HasColumnType("int(11)");
  79. entity.Property(e => e.UnitedBankNo)
  80. .HasColumnType("varchar(16)")
  81. .HasCharSet("utf8")
  82. .HasCollation("utf8_general_ci");
  83. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  84. entity.Property(e => e.UpdateMan)
  85. .HasColumnType("varchar(50)")
  86. .HasCharSet("utf8")
  87. .HasCollation("utf8_general_ci");
  88. entity.Property(e => e.Version).HasColumnType("int(11)");
  89. });
  90. modelBuilder.Entity<ChannelSet>(entity =>
  91. {
  92. entity.Property(e => e.Id).HasColumnType("int(11)");
  93. entity.Property(e => e.ChannelCapFee).HasColumnType("decimal(18,2)");
  94. entity.Property(e => e.ChannelCapMoney).HasColumnType("decimal(18,2)");
  95. entity.Property(e => e.ChannelCode)
  96. .HasColumnType("varchar(16)")
  97. .HasCharSet("utf8")
  98. .HasCollation("utf8_general_ci");
  99. entity.Property(e => e.ChannelFee).HasColumnType("decimal(18,2)");
  100. entity.Property(e => e.ChannelMerchantNo)
  101. .HasColumnType("varchar(128)")
  102. .HasCharSet("utf8")
  103. .HasCollation("utf8_general_ci");
  104. entity.Property(e => e.ChannelName)
  105. .HasColumnType("varchar(32)")
  106. .HasCharSet("utf8")
  107. .HasCollation("utf8_general_ci");
  108. entity.Property(e => e.ChannelRate).HasColumnType("decimal(18,2)");
  109. entity.Property(e => e.ChannelStatus).HasColumnType("int(11)");
  110. entity.Property(e => e.ChannelType).HasColumnType("int(11)");
  111. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  112. entity.Property(e => e.CreateMan)
  113. .HasColumnType("varchar(50)")
  114. .HasCharSet("utf8")
  115. .HasCollation("utf8_general_ci");
  116. entity.Property(e => e.DayLimitMoney).HasColumnType("decimal(18,2)");
  117. entity.Property(e => e.MaxTradeMoney).HasColumnType("decimal(18,2)");
  118. entity.Property(e => e.MerchantCapFee).HasColumnType("decimal(18,2)");
  119. entity.Property(e => e.MerchantCapMoney).HasColumnType("decimal(18,2)");
  120. entity.Property(e => e.MerchantFee).HasColumnType("decimal(18,2)");
  121. entity.Property(e => e.MerchantIp)
  122. .HasColumnType("varchar(256)")
  123. .HasCharSet("utf8")
  124. .HasCollation("utf8_general_ci");
  125. entity.Property(e => e.MerchantRate).HasColumnType("decimal(18,2)");
  126. entity.Property(e => e.MinTradeMoney).HasColumnType("decimal(18,2)");
  127. entity.Property(e => e.NotifyUrl)
  128. .HasColumnType("varchar(256)")
  129. .HasCharSet("utf8")
  130. .HasCollation("utf8_general_ci");
  131. entity.Property(e => e.PayUrl)
  132. .HasColumnType("varchar(256)")
  133. .HasCharSet("utf8")
  134. .HasCollation("utf8_general_ci");
  135. entity.Property(e => e.PaymentFlowType).HasColumnType("int(11)");
  136. entity.Property(e => e.PrivateKey)
  137. .HasColumnType("varchar(2048)")
  138. .HasCharSet("utf8")
  139. .HasCollation("utf8_general_ci");
  140. entity.Property(e => e.PrivatePemKey)
  141. .HasColumnType("varchar(2048)")
  142. .HasCharSet("utf8")
  143. .HasCollation("utf8_general_ci");
  144. entity.Property(e => e.PublicKey)
  145. .HasColumnType("varchar(2048)")
  146. .HasCharSet("utf8")
  147. .HasCollation("utf8_general_ci");
  148. entity.Property(e => e.PublicPemKey)
  149. .HasColumnType("varchar(2048)")
  150. .HasCharSet("utf8")
  151. .HasCollation("utf8_general_ci");
  152. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  153. entity.Property(e => e.QueryUrl)
  154. .HasColumnType("varchar(256)")
  155. .HasCharSet("utf8")
  156. .HasCollation("utf8_general_ci");
  157. entity.Property(e => e.Remark)
  158. .HasColumnType("varchar(64)")
  159. .HasCharSet("utf8")
  160. .HasCollation("utf8_general_ci");
  161. entity.Property(e => e.ReturnUrl)
  162. .HasColumnType("varchar(256)")
  163. .HasCharSet("utf8")
  164. .HasCollation("utf8_general_ci");
  165. entity.Property(e => e.SeoDescription)
  166. .HasColumnType("varchar(500)")
  167. .HasCharSet("utf8")
  168. .HasCollation("utf8_general_ci");
  169. entity.Property(e => e.SeoKeyword)
  170. .HasColumnType("varchar(200)")
  171. .HasCharSet("utf8")
  172. .HasCollation("utf8_general_ci");
  173. entity.Property(e => e.SeoTitle)
  174. .HasColumnType("varchar(100)")
  175. .HasCharSet("utf8")
  176. .HasCollation("utf8_general_ci");
  177. entity.Property(e => e.SettleType).HasColumnType("int(11)");
  178. entity.Property(e => e.SingleCardDayLimit).HasColumnType("decimal(18,2)");
  179. entity.Property(e => e.Sort).HasColumnType("int(11)");
  180. entity.Property(e => e.Status).HasColumnType("int(11)");
  181. entity.Property(e => e.TradeEndTime)
  182. .HasColumnType("varchar(6)")
  183. .HasCharSet("utf8")
  184. .HasCollation("utf8_general_ci");
  185. entity.Property(e => e.TradeStartTime)
  186. .HasColumnType("varchar(6)")
  187. .HasCharSet("utf8")
  188. .HasCollation("utf8_general_ci");
  189. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  190. entity.Property(e => e.UpdateMan)
  191. .HasColumnType("varchar(50)")
  192. .HasCharSet("utf8")
  193. .HasCollation("utf8_general_ci");
  194. entity.Property(e => e.Version).HasColumnType("int(11)");
  195. });
  196. modelBuilder.Entity<PlatAccount>(entity =>
  197. {
  198. entity.Property(e => e.Id).HasColumnType("int(11)");
  199. entity.Property(e => e.AccountStatus).HasColumnType("int(11)");
  200. entity.Property(e => e.AccountType).HasColumnType("int(11)");
  201. entity.Property(e => e.ChanAccountIdentity)
  202. .HasColumnType("varchar(128)")
  203. .HasCharSet("utf8")
  204. .HasCollation("utf8_general_ci");
  205. entity.Property(e => e.ChannelCode)
  206. .HasColumnType("varchar(16)")
  207. .HasCharSet("utf8")
  208. .HasCollation("utf8_general_ci");
  209. entity.Property(e => e.ChannelName)
  210. .HasColumnType("varchar(32)")
  211. .HasCharSet("utf8")
  212. .HasCollation("utf8_general_ci");
  213. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  214. entity.Property(e => e.CreateMan)
  215. .HasColumnType("varchar(50)")
  216. .HasCharSet("utf8")
  217. .HasCollation("utf8_general_ci");
  218. entity.Property(e => e.FeeAmount).HasColumnType("decimal(18,2)");
  219. entity.Property(e => e.ManageFeeAmount).HasColumnType("decimal(18,2)");
  220. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  221. entity.Property(e => e.SeoDescription)
  222. .HasColumnType("varchar(500)")
  223. .HasCharSet("utf8")
  224. .HasCollation("utf8_general_ci");
  225. entity.Property(e => e.SeoKeyword)
  226. .HasColumnType("varchar(200)")
  227. .HasCharSet("utf8")
  228. .HasCollation("utf8_general_ci");
  229. entity.Property(e => e.SeoTitle)
  230. .HasColumnType("varchar(100)")
  231. .HasCharSet("utf8")
  232. .HasCollation("utf8_general_ci");
  233. entity.Property(e => e.Sort).HasColumnType("int(11)");
  234. entity.Property(e => e.Status).HasColumnType("int(11)");
  235. entity.Property(e => e.TotalAmount).HasColumnType("decimal(18,2)");
  236. entity.Property(e => e.TradeAmount).HasColumnType("decimal(18,2)");
  237. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  238. entity.Property(e => e.UpdateMan)
  239. .HasColumnType("varchar(50)")
  240. .HasCharSet("utf8")
  241. .HasCollation("utf8_general_ci");
  242. entity.Property(e => e.Version).HasColumnType("int(11)");
  243. });
  244. modelBuilder.Entity<PlatAccountBalance>(entity =>
  245. {
  246. entity.Property(e => e.Id).HasColumnType("int(11)");
  247. entity.Property(e => e.AccountType).HasColumnType("int(11)");
  248. entity.Property(e => e.ChanAccountIdentity)
  249. .HasColumnType("varchar(128)")
  250. .HasCharSet("utf8")
  251. .HasCollation("utf8_general_ci");
  252. entity.Property(e => e.ChannelCode)
  253. .HasColumnType("varchar(16)")
  254. .HasCharSet("utf8")
  255. .HasCollation("utf8_general_ci");
  256. entity.Property(e => e.ChannelName)
  257. .HasColumnType("varchar(32)")
  258. .HasCharSet("utf8")
  259. .HasCollation("utf8_general_ci");
  260. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  261. entity.Property(e => e.CreateMan)
  262. .HasColumnType("varchar(50)")
  263. .HasCharSet("utf8")
  264. .HasCollation("utf8_general_ci");
  265. entity.Property(e => e.FeeAmount).HasColumnType("decimal(18,2)");
  266. entity.Property(e => e.ManageFeeAmount).HasColumnType("decimal(18,2)");
  267. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  268. entity.Property(e => e.SeoDescription)
  269. .HasColumnType("varchar(500)")
  270. .HasCharSet("utf8")
  271. .HasCollation("utf8_general_ci");
  272. entity.Property(e => e.SeoKeyword)
  273. .HasColumnType("varchar(200)")
  274. .HasCharSet("utf8")
  275. .HasCollation("utf8_general_ci");
  276. entity.Property(e => e.SeoTitle)
  277. .HasColumnType("varchar(100)")
  278. .HasCharSet("utf8")
  279. .HasCollation("utf8_general_ci");
  280. entity.Property(e => e.Sort).HasColumnType("int(11)");
  281. entity.Property(e => e.Status).HasColumnType("int(11)");
  282. entity.Property(e => e.TradeAmount).HasColumnType("decimal(18,2)");
  283. entity.Property(e => e.TradeDate).HasColumnType("datetime");
  284. entity.Property(e => e.TransName)
  285. .HasColumnType("varchar(32)")
  286. .HasCharSet("utf8")
  287. .HasCollation("utf8_general_ci");
  288. entity.Property(e => e.TransRecordNo)
  289. .HasColumnType("varchar(32)")
  290. .HasCharSet("utf8")
  291. .HasCollation("utf8_general_ci");
  292. entity.Property(e => e.TransType).HasColumnType("int(11)");
  293. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  294. entity.Property(e => e.UpdateMan)
  295. .HasColumnType("varchar(50)")
  296. .HasCharSet("utf8")
  297. .HasCollation("utf8_general_ci");
  298. entity.Property(e => e.UserId).HasColumnType("int(11)");
  299. entity.Property(e => e.Version).HasColumnType("int(11)");
  300. });
  301. modelBuilder.Entity<RecNoForWithdrawRecord>(entity =>
  302. {
  303. entity.HasKey(e => e.CashRecNo)
  304. .HasName("PRIMARY");
  305. entity.Property(e => e.CashRecNo)
  306. .HasColumnType("varchar(50)")
  307. .HasCharSet("utf8")
  308. .HasCollation("utf8_general_ci");
  309. entity.Property(e => e.WithdrawRecordId).HasColumnType("int(11)");
  310. });
  311. modelBuilder.Entity<RightDic>(entity =>
  312. {
  313. entity.Property(e => e.Id)
  314. .HasColumnName("ID")
  315. .HasColumnType("varchar(50)")
  316. .HasCharSet("utf8")
  317. .HasCollation("utf8_general_ci");
  318. entity.Property(e => e.Icon)
  319. .HasColumnType("varchar(50)")
  320. .HasCharSet("utf8")
  321. .HasCollation("utf8_general_ci");
  322. entity.Property(e => e.MainDataList)
  323. .HasColumnType("bit(1)")
  324. .HasDefaultValueSql("b'0'");
  325. entity.Property(e => e.MainMenu)
  326. .HasColumnType("bit(1)")
  327. .HasDefaultValueSql("b'0'");
  328. entity.Property(e => e.MainStat)
  329. .HasColumnType("bit(1)")
  330. .HasDefaultValueSql("b'0'");
  331. entity.Property(e => e.Name)
  332. .HasColumnType("varchar(50)")
  333. .HasCharSet("utf8")
  334. .HasCollation("utf8_general_ci");
  335. entity.Property(e => e.RightLevel).HasColumnType("int(11)");
  336. entity.Property(e => e.Sort).HasColumnType("int(11)");
  337. entity.Property(e => e.Url)
  338. .HasColumnType("varchar(200)")
  339. .HasCharSet("utf8")
  340. .HasCollation("utf8_general_ci");
  341. });
  342. modelBuilder.Entity<SysLog>(entity =>
  343. {
  344. entity.Property(e => e.Id).HasColumnType("int(11)");
  345. entity.Property(e => e.Contents)
  346. .HasColumnType("varchar(200)")
  347. .HasCharSet("utf8")
  348. .HasCollation("utf8_general_ci");
  349. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  350. entity.Property(e => e.CreateMan)
  351. .HasColumnType("varchar(50)")
  352. .HasCharSet("utf8")
  353. .HasCollation("utf8_general_ci");
  354. });
  355. modelBuilder.Entity<UserIdentity>(entity =>
  356. {
  357. entity.Property(e => e.Id).HasColumnType("int(11)");
  358. entity.Property(e => e.BankCardNo)
  359. .HasColumnType("varchar(32)")
  360. .HasCharSet("utf8")
  361. .HasCollation("utf8_general_ci");
  362. entity.Property(e => e.BuddyName)
  363. .HasColumnType("varchar(16)")
  364. .HasCharSet("utf8")
  365. .HasCollation("utf8_general_ci");
  366. entity.Property(e => e.BuddyNo)
  367. .HasColumnType("varchar(16)")
  368. .HasCharSet("utf8")
  369. .HasCollation("utf8_general_ci");
  370. entity.Property(e => e.CertFrontImage)
  371. .HasColumnType("varchar(256)")
  372. .HasCharSet("utf8")
  373. .HasCollation("utf8_general_ci");
  374. entity.Property(e => e.CertReverseImage)
  375. .HasColumnType("varchar(256)")
  376. .HasCharSet("utf8")
  377. .HasCollation("utf8_general_ci");
  378. entity.Property(e => e.CheckStatus).HasColumnType("int(11)");
  379. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  380. entity.Property(e => e.CreateMan)
  381. .HasColumnType("varchar(50)")
  382. .HasCharSet("utf8")
  383. .HasCollation("utf8_general_ci");
  384. entity.Property(e => e.FaceVideo)
  385. .HasColumnType("longtext")
  386. .HasCharSet("utf8")
  387. .HasCollation("utf8_general_ci");
  388. entity.Property(e => e.IdCardNo)
  389. .HasColumnType("varchar(18)")
  390. .HasCharSet("utf8")
  391. .HasCollation("utf8_general_ci");
  392. entity.Property(e => e.LivingImage)
  393. .HasColumnType("varchar(256)")
  394. .HasCharSet("utf8")
  395. .HasCollation("utf8_general_ci");
  396. entity.Property(e => e.LivingScore).HasColumnType("int(11)");
  397. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  398. entity.Property(e => e.Remark)
  399. .HasColumnType("varchar(64)")
  400. .HasCharSet("utf8")
  401. .HasCollation("utf8_general_ci");
  402. entity.Property(e => e.SeoDescription)
  403. .HasColumnType("varchar(500)")
  404. .HasCharSet("utf8")
  405. .HasCollation("utf8_general_ci");
  406. entity.Property(e => e.SeoKeyword)
  407. .HasColumnType("varchar(200)")
  408. .HasCharSet("utf8")
  409. .HasCollation("utf8_general_ci");
  410. entity.Property(e => e.SeoTitle)
  411. .HasColumnType("varchar(100)")
  412. .HasCharSet("utf8")
  413. .HasCollation("utf8_general_ci");
  414. entity.Property(e => e.SignImageUrl)
  415. .HasColumnType("varchar(256)")
  416. .HasCharSet("utf8")
  417. .HasCollation("utf8_general_ci");
  418. entity.Property(e => e.Sort).HasColumnType("int(11)");
  419. entity.Property(e => e.Status).HasColumnType("int(11)");
  420. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  421. entity.Property(e => e.UpdateMan)
  422. .HasColumnType("varchar(50)")
  423. .HasCharSet("utf8")
  424. .HasCollation("utf8_general_ci");
  425. entity.Property(e => e.UserMobile)
  426. .HasColumnType("varchar(11)")
  427. .HasCharSet("utf8")
  428. .HasCollation("utf8_general_ci");
  429. entity.Property(e => e.Version).HasColumnType("int(11)");
  430. });
  431. modelBuilder.Entity<UserTaxSign>(entity =>
  432. {
  433. entity.Property(e => e.Id).HasColumnType("int(11)");
  434. entity.Property(e => e.BankCardNo)
  435. .HasColumnType("varchar(32)")
  436. .HasCharSet("utf8")
  437. .HasCollation("utf8_general_ci");
  438. entity.Property(e => e.CertFrontImage)
  439. .HasColumnType("varchar(256)")
  440. .HasCharSet("utf8")
  441. .HasCollation("utf8_general_ci");
  442. entity.Property(e => e.CertReverseImage)
  443. .HasColumnType("varchar(256)")
  444. .HasCharSet("utf8")
  445. .HasCollation("utf8_general_ci");
  446. entity.Property(e => e.ChannelCode)
  447. .HasColumnType("varchar(16)")
  448. .HasCharSet("utf8")
  449. .HasCollation("utf8_general_ci");
  450. entity.Property(e => e.ChannelName)
  451. .HasColumnType("varchar(32)")
  452. .HasCharSet("utf8")
  453. .HasCollation("utf8_general_ci");
  454. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  455. entity.Property(e => e.CreateMan)
  456. .HasColumnType("varchar(50)")
  457. .HasCharSet("utf8")
  458. .HasCollation("utf8_general_ci");
  459. entity.Property(e => e.FaceVideo)
  460. .HasColumnType("longtext")
  461. .HasCharSet("utf8")
  462. .HasCollation("utf8_general_ci");
  463. entity.Property(e => e.IdCardNo)
  464. .HasColumnType("varchar(18)")
  465. .HasCharSet("utf8")
  466. .HasCollation("utf8_general_ci");
  467. entity.Property(e => e.LivingImage)
  468. .HasColumnType("varchar(256)")
  469. .HasCharSet("utf8")
  470. .HasCollation("utf8_general_ci");
  471. entity.Property(e => e.LivingScore).HasColumnType("int(11)");
  472. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  473. entity.Property(e => e.RealName)
  474. .HasColumnType("varchar(20)")
  475. .HasCharSet("utf8")
  476. .HasCollation("utf8_general_ci");
  477. entity.Property(e => e.ReqData)
  478. .HasColumnType("longtext")
  479. .HasCharSet("utf8")
  480. .HasCollation("utf8_general_ci");
  481. entity.Property(e => e.RespData)
  482. .HasColumnType("longtext")
  483. .HasCharSet("utf8")
  484. .HasCollation("utf8_general_ci");
  485. entity.Property(e => e.SeoDescription)
  486. .HasColumnType("varchar(500)")
  487. .HasCharSet("utf8")
  488. .HasCollation("utf8_general_ci");
  489. entity.Property(e => e.SeoKeyword)
  490. .HasColumnType("varchar(200)")
  491. .HasCharSet("utf8")
  492. .HasCollation("utf8_general_ci");
  493. entity.Property(e => e.SeoTitle)
  494. .HasColumnType("varchar(100)")
  495. .HasCharSet("utf8")
  496. .HasCollation("utf8_general_ci");
  497. entity.Property(e => e.SignImageUrl)
  498. .HasColumnType("varchar(256)")
  499. .HasCharSet("utf8")
  500. .HasCollation("utf8_general_ci");
  501. entity.Property(e => e.Sort).HasColumnType("int(11)");
  502. entity.Property(e => e.Status).HasColumnType("int(11)");
  503. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  504. entity.Property(e => e.UpdateMan)
  505. .HasColumnType("varchar(50)")
  506. .HasCharSet("utf8")
  507. .HasCollation("utf8_general_ci");
  508. entity.Property(e => e.UserMobile)
  509. .HasColumnType("varchar(11)")
  510. .HasCharSet("utf8")
  511. .HasCollation("utf8_general_ci");
  512. entity.Property(e => e.UserNo)
  513. .HasColumnType("varchar(16)")
  514. .HasCharSet("utf8")
  515. .HasCollation("utf8_general_ci");
  516. entity.Property(e => e.Version).HasColumnType("int(11)");
  517. });
  518. modelBuilder.Entity<WithdrawBlackList>(entity =>
  519. {
  520. entity.Property(e => e.Id).HasColumnType("int(11)");
  521. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  522. entity.Property(e => e.CreateMan)
  523. .HasColumnType("varchar(50)")
  524. .HasCharSet("utf8")
  525. .HasCollation("utf8_general_ci");
  526. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  527. entity.Property(e => e.Reason)
  528. .HasColumnType("varchar(128)")
  529. .HasCharSet("utf8")
  530. .HasCollation("utf8_general_ci");
  531. entity.Property(e => e.Remark)
  532. .HasColumnType("varchar(128)")
  533. .HasCharSet("utf8")
  534. .HasCollation("utf8_general_ci");
  535. entity.Property(e => e.SeoDescription)
  536. .HasColumnType("varchar(500)")
  537. .HasCharSet("utf8")
  538. .HasCollation("utf8_general_ci");
  539. entity.Property(e => e.SeoKeyword)
  540. .HasColumnType("varchar(200)")
  541. .HasCharSet("utf8")
  542. .HasCollation("utf8_general_ci");
  543. entity.Property(e => e.SeoTitle)
  544. .HasColumnType("varchar(100)")
  545. .HasCharSet("utf8")
  546. .HasCollation("utf8_general_ci");
  547. entity.Property(e => e.Sort).HasColumnType("int(11)");
  548. entity.Property(e => e.Status).HasColumnType("int(11)");
  549. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  550. entity.Property(e => e.UpdateMan)
  551. .HasColumnType("varchar(50)")
  552. .HasCharSet("utf8")
  553. .HasCollation("utf8_general_ci");
  554. entity.Property(e => e.UserId).HasColumnType("int(11)");
  555. entity.Property(e => e.Version).HasColumnType("int(11)");
  556. });
  557. modelBuilder.Entity<WithdrawConfig>(entity =>
  558. {
  559. entity.Property(e => e.Id).HasColumnType("int(11)");
  560. entity.Property(e => e.AlarmCashErrors).HasColumnType("int(11)");
  561. entity.Property(e => e.AlarmMobile)
  562. .HasColumnType("varchar(256)")
  563. .HasCharSet("utf8")
  564. .HasCollation("utf8_general_ci");
  565. entity.Property(e => e.AuditOutSwitchType).HasColumnType("int(11)");
  566. entity.Property(e => e.AuditOutSwitchValue)
  567. .HasColumnType("varchar(1024)")
  568. .HasCharSet("utf8")
  569. .HasCollation("utf8_general_ci");
  570. entity.Property(e => e.AutoAuditOutSwitch)
  571. .HasColumnType("varchar(5)")
  572. .HasCharSet("utf8")
  573. .HasCollation("utf8_general_ci");
  574. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  575. entity.Property(e => e.CreateMan)
  576. .HasColumnType("varchar(50)")
  577. .HasCharSet("utf8")
  578. .HasCollation("utf8_general_ci");
  579. entity.Property(e => e.CurCashErrors).HasColumnType("int(11)");
  580. entity.Property(e => e.OutDayAmountLimit).HasColumnType("decimal(18,2)");
  581. entity.Property(e => e.OutDayTimesLimit).HasColumnType("int(11)");
  582. entity.Property(e => e.OutMonthAmountLimit).HasColumnType("decimal(18,2)");
  583. entity.Property(e => e.OutMonthTimesLimit).HasColumnType("int(11)");
  584. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  585. entity.Property(e => e.Remark)
  586. .HasColumnType("varchar(64)")
  587. .HasCharSet("utf8")
  588. .HasCollation("utf8_general_ci");
  589. entity.Property(e => e.RuleCheckSwitch).HasColumnType("int(11)");
  590. entity.Property(e => e.SeoDescription)
  591. .HasColumnType("varchar(500)")
  592. .HasCharSet("utf8")
  593. .HasCollation("utf8_general_ci");
  594. entity.Property(e => e.SeoKeyword)
  595. .HasColumnType("varchar(200)")
  596. .HasCharSet("utf8")
  597. .HasCollation("utf8_general_ci");
  598. entity.Property(e => e.SeoTitle)
  599. .HasColumnType("varchar(100)")
  600. .HasCharSet("utf8")
  601. .HasCollation("utf8_general_ci");
  602. entity.Property(e => e.Sort).HasColumnType("int(11)");
  603. entity.Property(e => e.Status).HasColumnType("int(11)");
  604. entity.Property(e => e.TaskExecutionTime)
  605. .HasColumnType("varchar(20)")
  606. .HasCharSet("utf8")
  607. .HasCollation("utf8_general_ci");
  608. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  609. entity.Property(e => e.UpdateMan)
  610. .HasColumnType("varchar(50)")
  611. .HasCharSet("utf8")
  612. .HasCollation("utf8_general_ci");
  613. entity.Property(e => e.UserOutAmountLimit).HasColumnType("decimal(18,2)");
  614. entity.Property(e => e.UserOutAmountMinLimit).HasColumnType("decimal(18,2)");
  615. entity.Property(e => e.UserOutDayAmountLimit).HasColumnType("decimal(18,2)");
  616. entity.Property(e => e.UserOutDayTimesLimit).HasColumnType("int(11)");
  617. entity.Property(e => e.UserOutMonthAmountLimit).HasColumnType("decimal(18,2)");
  618. entity.Property(e => e.UserOutMonthTimesLimit).HasColumnType("int(11)");
  619. entity.Property(e => e.Version).HasColumnType("int(11)");
  620. });
  621. modelBuilder.Entity<WithdrawRecord>(entity =>
  622. {
  623. entity.Property(e => e.Id).HasColumnType("int(11)");
  624. entity.Property(e => e.ActualTradeAmount).HasColumnType("decimal(18,2)");
  625. entity.Property(e => e.ArrivedTime).HasColumnType("datetime");
  626. entity.Property(e => e.AuditBy)
  627. .HasColumnType("varchar(32)")
  628. .HasCharSet("utf8")
  629. .HasCollation("utf8_general_ci");
  630. entity.Property(e => e.AuditRemark)
  631. .HasColumnType("varchar(128)")
  632. .HasCharSet("utf8")
  633. .HasCollation("utf8_general_ci");
  634. entity.Property(e => e.AuditResult).HasColumnType("int(11)");
  635. entity.Property(e => e.AuditTime).HasColumnType("datetime");
  636. entity.Property(e => e.AuditType).HasColumnType("int(11)");
  637. entity.Property(e => e.BankCardName)
  638. .HasColumnType("varchar(32)")
  639. .HasCharSet("utf8")
  640. .HasCollation("utf8_general_ci");
  641. entity.Property(e => e.BankCardNo)
  642. .HasColumnType("varchar(32)")
  643. .HasCharSet("utf8")
  644. .HasCollation("utf8_general_ci");
  645. entity.Property(e => e.BankCode)
  646. .HasColumnType("varchar(16)")
  647. .HasCharSet("utf8")
  648. .HasCollation("utf8_general_ci");
  649. entity.Property(e => e.BankName)
  650. .HasColumnType("varchar(32)")
  651. .HasCharSet("utf8")
  652. .HasCollation("utf8_general_ci");
  653. entity.Property(e => e.BizName)
  654. .HasColumnType("varchar(32)")
  655. .HasCharSet("utf8")
  656. .HasCollation("utf8_general_ci");
  657. entity.Property(e => e.BizTime).HasColumnType("datetime");
  658. entity.Property(e => e.CashChannel)
  659. .HasColumnType("varchar(20)")
  660. .HasCharSet("utf8")
  661. .HasCollation("utf8_general_ci");
  662. entity.Property(e => e.CashRecNo)
  663. .HasColumnType("varchar(20)")
  664. .HasCharSet("utf8")
  665. .HasCollation("utf8_general_ci");
  666. entity.Property(e => e.CashTime).HasColumnType("datetime");
  667. entity.Property(e => e.ChannelActualAmount).HasColumnType("decimal(18,2)");
  668. entity.Property(e => e.ChannelCode)
  669. .HasColumnType("varchar(16)")
  670. .HasCharSet("utf8")
  671. .HasCollation("utf8_general_ci");
  672. entity.Property(e => e.ChannelName)
  673. .HasColumnType("varchar(32)")
  674. .HasCharSet("utf8")
  675. .HasCollation("utf8_general_ci");
  676. entity.Property(e => e.ChannelTradeNo)
  677. .HasColumnType("varchar(32)")
  678. .HasCharSet("utf8")
  679. .HasCollation("utf8_general_ci");
  680. entity.Property(e => e.CreateDate).HasColumnType("datetime");
  681. entity.Property(e => e.CreateMan)
  682. .HasColumnType("varchar(50)")
  683. .HasCharSet("utf8")
  684. .HasCollation("utf8_general_ci");
  685. entity.Property(e => e.IdcardNo)
  686. .HasColumnType("varchar(18)")
  687. .HasCharSet("utf8")
  688. .HasCollation("utf8_general_ci");
  689. entity.Property(e => e.IdcardType)
  690. .HasColumnType("varchar(2)")
  691. .HasCharSet("utf8")
  692. .HasCollation("utf8_general_ci");
  693. entity.Property(e => e.Ip地址)
  694. .HasColumnName("IP地址")
  695. .HasColumnType("varchar(32)")
  696. .HasCharSet("utf8")
  697. .HasCollation("utf8_general_ci");
  698. entity.Property(e => e.ManageFee).HasColumnType("decimal(18,2)");
  699. entity.Property(e => e.MediaSource)
  700. .HasColumnType("varchar(16)")
  701. .HasCharSet("utf8")
  702. .HasCollation("utf8_general_ci");
  703. entity.Property(e => e.OperateBy)
  704. .HasColumnType("varchar(16)")
  705. .HasCharSet("utf8")
  706. .HasCollation("utf8_general_ci");
  707. entity.Property(e => e.OperateDate).HasColumnType("datetime");
  708. entity.Property(e => e.PartnerTradeNo)
  709. .HasColumnType("varchar(32)")
  710. .HasCharSet("utf8")
  711. .HasCollation("utf8_general_ci");
  712. entity.Property(e => e.QueryCount).HasColumnType("int(11)");
  713. entity.Property(e => e.Remark)
  714. .HasColumnType("varchar(64)")
  715. .HasCharSet("utf8")
  716. .HasCollation("utf8_general_ci");
  717. entity.Property(e => e.ReqChannelNo)
  718. .HasColumnType("varchar(32)")
  719. .HasCharSet("utf8")
  720. .HasCollation("utf8_general_ci");
  721. entity.Property(e => e.ReqChannelSeq)
  722. .HasColumnType("varchar(32)")
  723. .HasCharSet("utf8")
  724. .HasCollation("utf8_general_ci");
  725. entity.Property(e => e.ReqData)
  726. .HasColumnType("varchar(2048)")
  727. .HasCharSet("utf8")
  728. .HasCollation("utf8_general_ci");
  729. entity.Property(e => e.ResData)
  730. .HasColumnType("varchar(2048)")
  731. .HasCharSet("utf8")
  732. .HasCollation("utf8_general_ci");
  733. entity.Property(e => e.ReturnCode)
  734. .HasColumnType("varchar(32)")
  735. .HasCharSet("utf8")
  736. .HasCollation("utf8_general_ci");
  737. entity.Property(e => e.ReturnMsg)
  738. .HasColumnType("varchar(128)")
  739. .HasCharSet("utf8")
  740. .HasCollation("utf8_general_ci");
  741. entity.Property(e => e.SeoDescription)
  742. .HasColumnType("varchar(500)")
  743. .HasCharSet("utf8")
  744. .HasCollation("utf8_general_ci");
  745. entity.Property(e => e.SeoKeyword)
  746. .HasColumnType("varchar(200)")
  747. .HasCharSet("utf8")
  748. .HasCollation("utf8_general_ci");
  749. entity.Property(e => e.SeoTitle)
  750. .HasColumnType("varchar(100)")
  751. .HasCharSet("utf8")
  752. .HasCollation("utf8_general_ci");
  753. entity.Property(e => e.Sort).HasColumnType("int(11)");
  754. entity.Property(e => e.Status).HasColumnType("int(11)");
  755. entity.Property(e => e.TradeAmount).HasColumnType("decimal(18,2)");
  756. entity.Property(e => e.TradeFee).HasColumnType("decimal(18,2)");
  757. entity.Property(e => e.TradeStatus).HasColumnType("int(11)");
  758. entity.Property(e => e.TradeType).HasColumnType("int(11)");
  759. entity.Property(e => e.TransCompleteTime).HasColumnType("datetime");
  760. entity.Property(e => e.UnitedBankNo)
  761. .HasColumnType("varchar(16)")
  762. .HasCharSet("utf8")
  763. .HasCollation("utf8_general_ci");
  764. entity.Property(e => e.UpdateDate).HasColumnType("datetime");
  765. entity.Property(e => e.UpdateMan)
  766. .HasColumnType("varchar(50)")
  767. .HasCharSet("utf8")
  768. .HasCollation("utf8_general_ci");
  769. entity.Property(e => e.UserBankMobile)
  770. .HasColumnType("varchar(11)")
  771. .HasCharSet("utf8")
  772. .HasCollation("utf8_general_ci");
  773. entity.Property(e => e.UserId).HasColumnType("int(11)");
  774. entity.Property(e => e.UserMobile)
  775. .HasColumnType("varchar(11)")
  776. .HasCharSet("utf8")
  777. .HasCollation("utf8_general_ci");
  778. entity.Property(e => e.UserName)
  779. .HasColumnType("varchar(32)")
  780. .HasCharSet("utf8")
  781. .HasCollation("utf8_general_ci");
  782. entity.Property(e => e.Version).HasColumnType("int(11)");
  783. });
  784. OnModelCreatingPartial(modelBuilder);
  785. }
  786. partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
  787. }
  788. }