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.

DatabaseContextModelSnapshot.cs 21KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595
  1. // <auto-generated />
  2. using System;
  3. using Diligent.WebAPI.Data;
  4. using Microsoft.EntityFrameworkCore;
  5. using Microsoft.EntityFrameworkCore.Infrastructure;
  6. using Microsoft.EntityFrameworkCore.Metadata;
  7. using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
  8. #nullable disable
  9. namespace Diligent.WebAPI.Data.Migrations
  10. {
  11. [DbContext(typeof(DatabaseContext))]
  12. partial class DatabaseContextModelSnapshot : ModelSnapshot
  13. {
  14. protected override void BuildModel(ModelBuilder modelBuilder)
  15. {
  16. #pragma warning disable 612, 618
  17. modelBuilder
  18. .HasAnnotation("ProductVersion", "6.0.10")
  19. .HasAnnotation("Relational:MaxIdentifierLength", 128);
  20. SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder, 1L, 1);
  21. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.AppRole", b =>
  22. {
  23. b.Property<int>("Id")
  24. .ValueGeneratedOnAdd()
  25. .HasColumnType("int");
  26. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
  27. b.Property<string>("ConcurrencyStamp")
  28. .IsConcurrencyToken()
  29. .HasColumnType("nvarchar(max)");
  30. b.Property<string>("Name")
  31. .HasMaxLength(256)
  32. .HasColumnType("nvarchar(256)");
  33. b.Property<string>("NormalizedName")
  34. .HasMaxLength(256)
  35. .HasColumnType("nvarchar(256)");
  36. b.HasKey("Id");
  37. b.HasIndex("NormalizedName")
  38. .IsUnique()
  39. .HasDatabaseName("RoleNameIndex")
  40. .HasFilter("[NormalizedName] IS NOT NULL");
  41. b.ToTable("AspNetRoles", (string)null);
  42. });
  43. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.InsuranceCompany", b =>
  44. {
  45. b.Property<long>("Id")
  46. .ValueGeneratedOnAdd()
  47. .HasColumnType("bigint");
  48. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"), 1L, 1);
  49. b.Property<string>("City")
  50. .IsRequired()
  51. .HasColumnType("nvarchar(max)");
  52. b.Property<string>("Country")
  53. .IsRequired()
  54. .HasColumnType("nvarchar(max)");
  55. b.Property<DateTime>("CreatedAtUtc")
  56. .HasColumnType("datetime2");
  57. b.Property<DateTime?>("DeletedAtUtc")
  58. .HasColumnType("datetime2");
  59. b.Property<string>("Fax")
  60. .IsRequired()
  61. .HasColumnType("nvarchar(max)");
  62. b.Property<string>("LegalAddress")
  63. .IsRequired()
  64. .HasColumnType("nvarchar(max)");
  65. b.Property<string>("LegalEmail")
  66. .IsRequired()
  67. .HasColumnType("nvarchar(max)");
  68. b.Property<string>("Name")
  69. .IsRequired()
  70. .HasColumnType("nvarchar(max)");
  71. b.Property<string>("PhoneNumber")
  72. .IsRequired()
  73. .HasColumnType("nvarchar(max)");
  74. b.Property<string>("PostalCode")
  75. .IsRequired()
  76. .HasColumnType("nvarchar(max)");
  77. b.Property<DateTime?>("UpdatedAtUtc")
  78. .HasColumnType("datetime2");
  79. b.HasKey("Id");
  80. b.ToTable("InsuranceCompanies");
  81. });
  82. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.InsurancePolicy", b =>
  83. {
  84. b.Property<long>("Id")
  85. .ValueGeneratedOnAdd()
  86. .HasColumnType("bigint");
  87. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"), 1L, 1);
  88. b.Property<DateTime>("CreatedAtUtc")
  89. .HasColumnType("datetime2");
  90. b.Property<DateTime?>("DeletedAtUtc")
  91. .HasColumnType("datetime2");
  92. b.Property<DateTime>("EndDate")
  93. .HasColumnType("datetime2");
  94. b.Property<long>("InsurerId")
  95. .HasColumnType("bigint");
  96. b.Property<decimal>("Premium")
  97. .HasColumnType("decimal(18,2)");
  98. b.Property<DateTime>("StartDate")
  99. .HasColumnType("datetime2");
  100. b.Property<string>("Type")
  101. .IsRequired()
  102. .HasColumnType("nvarchar(max)");
  103. b.Property<DateTime?>("UpdatedAtUtc")
  104. .HasColumnType("datetime2");
  105. b.HasKey("Id");
  106. b.HasIndex("InsurerId");
  107. b.ToTable("InsurancePolicies");
  108. });
  109. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.Insurer", b =>
  110. {
  111. b.Property<long>("Id")
  112. .ValueGeneratedOnAdd()
  113. .HasColumnType("bigint");
  114. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"), 1L, 1);
  115. b.Property<string>("Address")
  116. .IsRequired()
  117. .HasColumnType("nvarchar(max)");
  118. b.Property<string>("City")
  119. .IsRequired()
  120. .HasColumnType("nvarchar(max)");
  121. b.Property<string>("Country")
  122. .IsRequired()
  123. .HasColumnType("nvarchar(max)");
  124. b.Property<DateTime>("CreatedAtUtc")
  125. .HasColumnType("datetime2");
  126. b.Property<DateTime>("DateOfBirth")
  127. .HasColumnType("datetime2");
  128. b.Property<DateTime?>("DeletedAtUtc")
  129. .HasColumnType("datetime2");
  130. b.Property<string>("Email")
  131. .IsRequired()
  132. .HasColumnType("nvarchar(max)");
  133. b.Property<string>("FirstName")
  134. .IsRequired()
  135. .HasColumnType("nvarchar(max)");
  136. b.Property<long>("InsuranceCompanyId")
  137. .HasColumnType("bigint");
  138. b.Property<string>("LastName")
  139. .IsRequired()
  140. .HasColumnType("nvarchar(max)");
  141. b.Property<string>("PhoneNumber")
  142. .IsRequired()
  143. .HasColumnType("nvarchar(max)");
  144. b.Property<string>("PostalCode")
  145. .IsRequired()
  146. .HasColumnType("nvarchar(max)");
  147. b.Property<DateTime?>("UpdatedAtUtc")
  148. .HasColumnType("datetime2");
  149. b.HasKey("Id");
  150. b.HasIndex("InsuranceCompanyId");
  151. b.ToTable("Insurers");
  152. });
  153. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.RefreshToken", b =>
  154. {
  155. b.Property<int>("Id")
  156. .ValueGeneratedOnAdd()
  157. .HasColumnType("int");
  158. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
  159. b.Property<DateTime>("CreationDate")
  160. .HasColumnType("datetime2");
  161. b.Property<DateTime>("ExpiryDate")
  162. .HasColumnType("datetime2");
  163. b.Property<bool>("Invalidated")
  164. .HasColumnType("bit");
  165. b.Property<string>("JwtId")
  166. .IsRequired()
  167. .HasColumnType("nvarchar(max)");
  168. b.Property<string>("Token")
  169. .IsRequired()
  170. .HasColumnType("nvarchar(max)");
  171. b.Property<bool>("Used")
  172. .HasColumnType("bit");
  173. b.Property<int>("UserId")
  174. .HasColumnType("int");
  175. b.HasKey("Id");
  176. b.HasIndex("UserId");
  177. b.ToTable("RefreshTokens");
  178. });
  179. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.User", b =>
  180. {
  181. b.Property<int>("Id")
  182. .ValueGeneratedOnAdd()
  183. .HasColumnType("int");
  184. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
  185. b.Property<int>("AccessFailedCount")
  186. .HasColumnType("int");
  187. b.Property<string>("ConcurrencyStamp")
  188. .IsConcurrencyToken()
  189. .HasColumnType("nvarchar(max)");
  190. b.Property<string>("Email")
  191. .HasMaxLength(256)
  192. .HasColumnType("nvarchar(256)");
  193. b.Property<bool>("EmailConfirmed")
  194. .HasColumnType("bit");
  195. b.Property<string>("FirstName")
  196. .IsRequired()
  197. .HasColumnType("nvarchar(max)");
  198. b.Property<string>("LastName")
  199. .IsRequired()
  200. .HasColumnType("nvarchar(max)");
  201. b.Property<bool>("LockoutEnabled")
  202. .HasColumnType("bit");
  203. b.Property<DateTimeOffset?>("LockoutEnd")
  204. .HasColumnType("datetimeoffset");
  205. b.Property<string>("NormalizedEmail")
  206. .HasMaxLength(256)
  207. .HasColumnType("nvarchar(256)");
  208. b.Property<string>("NormalizedUserName")
  209. .HasMaxLength(256)
  210. .HasColumnType("nvarchar(256)");
  211. b.Property<string>("PasswordHash")
  212. .HasColumnType("nvarchar(max)");
  213. b.Property<string>("PhoneNumber")
  214. .HasColumnType("nvarchar(max)");
  215. b.Property<bool>("PhoneNumberConfirmed")
  216. .HasColumnType("bit");
  217. b.Property<string>("SecurityStamp")
  218. .HasColumnType("nvarchar(max)");
  219. b.Property<bool>("TwoFactorEnabled")
  220. .HasColumnType("bit");
  221. b.Property<string>("UserName")
  222. .HasMaxLength(256)
  223. .HasColumnType("nvarchar(256)");
  224. b.HasKey("Id");
  225. b.HasIndex("NormalizedEmail")
  226. .HasDatabaseName("EmailIndex");
  227. b.HasIndex("NormalizedUserName")
  228. .IsUnique()
  229. .HasDatabaseName("UserNameIndex")
  230. .HasFilter("[NormalizedUserName] IS NOT NULL");
  231. b.ToTable("AspNetUsers", (string)null);
  232. });
  233. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.WebhookDefinition", b =>
  234. {
  235. b.Property<long>("Id")
  236. .ValueGeneratedOnAdd()
  237. .HasColumnType("bigint");
  238. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"), 1L, 1);
  239. b.Property<DateTime>("CreatedAtUtc")
  240. .HasColumnType("datetime2");
  241. b.Property<DateTime?>("DeletedAtUtc")
  242. .HasColumnType("datetime2");
  243. b.Property<string>("Description")
  244. .IsRequired()
  245. .HasColumnType("nvarchar(max)");
  246. b.Property<string>("DisplayName")
  247. .IsRequired()
  248. .HasMaxLength(100)
  249. .HasColumnType("nvarchar(100)");
  250. b.Property<string>("Name")
  251. .IsRequired()
  252. .HasMaxLength(100)
  253. .HasColumnType("nvarchar(100)");
  254. b.Property<DateTime?>("UpdatedAtUtc")
  255. .HasColumnType("datetime2");
  256. b.HasKey("Id");
  257. b.ToTable("WebhookDefinitions");
  258. });
  259. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.WebhookSubscription", b =>
  260. {
  261. b.Property<long>("Id")
  262. .ValueGeneratedOnAdd()
  263. .HasColumnType("bigint");
  264. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"), 1L, 1);
  265. b.Property<DateTime>("CreatedAtUtc")
  266. .HasColumnType("datetime2");
  267. b.Property<DateTime?>("DeletedAtUtc")
  268. .HasColumnType("datetime2");
  269. b.Property<bool>("IsActive")
  270. .HasColumnType("bit");
  271. b.Property<DateTime?>("UpdatedAtUtc")
  272. .HasColumnType("datetime2");
  273. b.Property<long>("WebhookDefinitionId")
  274. .HasColumnType("bigint");
  275. b.Property<string>("WebhookURL")
  276. .IsRequired()
  277. .HasColumnType("nvarchar(max)");
  278. b.HasKey("Id");
  279. b.HasIndex("WebhookDefinitionId");
  280. b.ToTable("WebhookSubscriptions");
  281. });
  282. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<int>", b =>
  283. {
  284. b.Property<int>("Id")
  285. .ValueGeneratedOnAdd()
  286. .HasColumnType("int");
  287. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
  288. b.Property<string>("ClaimType")
  289. .HasColumnType("nvarchar(max)");
  290. b.Property<string>("ClaimValue")
  291. .HasColumnType("nvarchar(max)");
  292. b.Property<int>("RoleId")
  293. .HasColumnType("int");
  294. b.HasKey("Id");
  295. b.HasIndex("RoleId");
  296. b.ToTable("AspNetRoleClaims", (string)null);
  297. });
  298. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<int>", b =>
  299. {
  300. b.Property<int>("Id")
  301. .ValueGeneratedOnAdd()
  302. .HasColumnType("int");
  303. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"), 1L, 1);
  304. b.Property<string>("ClaimType")
  305. .HasColumnType("nvarchar(max)");
  306. b.Property<string>("ClaimValue")
  307. .HasColumnType("nvarchar(max)");
  308. b.Property<int>("UserId")
  309. .HasColumnType("int");
  310. b.HasKey("Id");
  311. b.HasIndex("UserId");
  312. b.ToTable("AspNetUserClaims", (string)null);
  313. });
  314. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<int>", b =>
  315. {
  316. b.Property<string>("LoginProvider")
  317. .HasColumnType("nvarchar(450)");
  318. b.Property<string>("ProviderKey")
  319. .HasColumnType("nvarchar(450)");
  320. b.Property<string>("ProviderDisplayName")
  321. .HasColumnType("nvarchar(max)");
  322. b.Property<int>("UserId")
  323. .HasColumnType("int");
  324. b.HasKey("LoginProvider", "ProviderKey");
  325. b.HasIndex("UserId");
  326. b.ToTable("AspNetUserLogins", (string)null);
  327. });
  328. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<int>", b =>
  329. {
  330. b.Property<int>("UserId")
  331. .HasColumnType("int");
  332. b.Property<int>("RoleId")
  333. .HasColumnType("int");
  334. b.HasKey("UserId", "RoleId");
  335. b.HasIndex("RoleId");
  336. b.ToTable("AspNetUserRoles", (string)null);
  337. });
  338. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<int>", b =>
  339. {
  340. b.Property<int>("UserId")
  341. .HasColumnType("int");
  342. b.Property<string>("LoginProvider")
  343. .HasColumnType("nvarchar(450)");
  344. b.Property<string>("Name")
  345. .HasColumnType("nvarchar(450)");
  346. b.Property<string>("Value")
  347. .HasColumnType("nvarchar(max)");
  348. b.HasKey("UserId", "LoginProvider", "Name");
  349. b.ToTable("AspNetUserTokens", (string)null);
  350. });
  351. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.InsurancePolicy", b =>
  352. {
  353. b.HasOne("Diligent.WebAPI.Data.Entities.Insurer", "Insurer")
  354. .WithMany()
  355. .HasForeignKey("InsurerId")
  356. .OnDelete(DeleteBehavior.Cascade)
  357. .IsRequired();
  358. b.Navigation("Insurer");
  359. });
  360. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.Insurer", b =>
  361. {
  362. b.HasOne("Diligent.WebAPI.Data.Entities.InsuranceCompany", "InsuranceCompany")
  363. .WithMany()
  364. .HasForeignKey("InsuranceCompanyId")
  365. .OnDelete(DeleteBehavior.Cascade)
  366. .IsRequired();
  367. b.Navigation("InsuranceCompany");
  368. });
  369. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.RefreshToken", b =>
  370. {
  371. b.HasOne("Diligent.WebAPI.Data.Entities.User", "User")
  372. .WithMany()
  373. .HasForeignKey("UserId")
  374. .OnDelete(DeleteBehavior.Cascade)
  375. .IsRequired();
  376. b.Navigation("User");
  377. });
  378. modelBuilder.Entity("Diligent.WebAPI.Data.Entities.WebhookSubscription", b =>
  379. {
  380. b.HasOne("Diligent.WebAPI.Data.Entities.WebhookDefinition", "WebhookDefinition")
  381. .WithMany()
  382. .HasForeignKey("WebhookDefinitionId")
  383. .OnDelete(DeleteBehavior.Cascade)
  384. .IsRequired();
  385. b.Navigation("WebhookDefinition");
  386. });
  387. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<int>", b =>
  388. {
  389. b.HasOne("Diligent.WebAPI.Data.Entities.AppRole", null)
  390. .WithMany()
  391. .HasForeignKey("RoleId")
  392. .OnDelete(DeleteBehavior.Cascade)
  393. .IsRequired();
  394. });
  395. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<int>", b =>
  396. {
  397. b.HasOne("Diligent.WebAPI.Data.Entities.User", null)
  398. .WithMany()
  399. .HasForeignKey("UserId")
  400. .OnDelete(DeleteBehavior.Cascade)
  401. .IsRequired();
  402. });
  403. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<int>", b =>
  404. {
  405. b.HasOne("Diligent.WebAPI.Data.Entities.User", null)
  406. .WithMany()
  407. .HasForeignKey("UserId")
  408. .OnDelete(DeleteBehavior.Cascade)
  409. .IsRequired();
  410. });
  411. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<int>", b =>
  412. {
  413. b.HasOne("Diligent.WebAPI.Data.Entities.AppRole", null)
  414. .WithMany()
  415. .HasForeignKey("RoleId")
  416. .OnDelete(DeleteBehavior.Cascade)
  417. .IsRequired();
  418. b.HasOne("Diligent.WebAPI.Data.Entities.User", null)
  419. .WithMany()
  420. .HasForeignKey("UserId")
  421. .OnDelete(DeleteBehavior.Cascade)
  422. .IsRequired();
  423. });
  424. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<int>", b =>
  425. {
  426. b.HasOne("Diligent.WebAPI.Data.Entities.User", null)
  427. .WithMany()
  428. .HasForeignKey("UserId")
  429. .OnDelete(DeleteBehavior.Cascade)
  430. .IsRequired();
  431. });
  432. #pragma warning restore 612, 618
  433. }
  434. }
  435. }