20240528094815_altrUserByCompanyId.Designer.cs 120 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265
  1. // <auto-generated />
  2. using System;
  3. using MTWorkHR.Infrastructure.DBContext;
  4. using Microsoft.EntityFrameworkCore;
  5. using Microsoft.EntityFrameworkCore.Infrastructure;
  6. using Microsoft.EntityFrameworkCore.Metadata;
  7. using Microsoft.EntityFrameworkCore.Migrations;
  8. using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
  9. #nullable disable
  10. namespace MTWorkHR.Infrastructure.Migrations
  11. {
  12. [DbContext(typeof(HRDataContext))]
  13. [Migration("20240528094815_altrUserByCompanyId")]
  14. partial class altrUserByCompanyId
  15. {
  16. /// <inheritdoc />
  17. protected override void BuildTargetModel(ModelBuilder modelBuilder)
  18. {
  19. #pragma warning disable 612, 618
  20. modelBuilder
  21. .HasAnnotation("ProductVersion", "8.0.1")
  22. .HasAnnotation("Relational:MaxIdentifierLength", 128);
  23. SqlServerModelBuilderExtensions.UseIdentityColumns(modelBuilder);
  24. modelBuilder.Entity("ApplicationRoleApplicationUser", b =>
  25. {
  26. b.Property<string>("UserRolesId")
  27. .HasColumnType("nvarchar(450)");
  28. b.Property<string>("UsersId")
  29. .HasColumnType("nvarchar(450)");
  30. b.HasKey("UserRolesId", "UsersId");
  31. b.HasIndex("UsersId");
  32. b.ToTable("ApplicationRoleApplicationUser");
  33. });
  34. modelBuilder.Entity("MTWorkHR.Core.Entities.Attendance", b =>
  35. {
  36. b.Property<long>("Id")
  37. .ValueGeneratedOnAdd()
  38. .HasColumnType("bigint")
  39. .HasColumnOrder(0);
  40. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  41. b.Property<DateTime>("AttendanceDate")
  42. .HasColumnType("datetime2");
  43. b.Property<DateTime?>("CheckInTime")
  44. .HasColumnType("datetime2");
  45. b.Property<DateTime?>("CheckOutTime")
  46. .HasColumnType("datetime2");
  47. b.Property<DateTime>("CreateDate")
  48. .HasColumnType("datetime2")
  49. .HasColumnOrder(3);
  50. b.Property<string>("CreateUser")
  51. .HasMaxLength(450)
  52. .HasColumnType("nvarchar(450)")
  53. .HasColumnOrder(1);
  54. b.Property<string>("DeleteUserId")
  55. .HasMaxLength(450)
  56. .HasColumnType("nvarchar(450)")
  57. .HasColumnOrder(8);
  58. b.Property<bool>("IsDeleted")
  59. .HasColumnType("bit")
  60. .HasColumnOrder(7);
  61. b.Property<string>("LeaveReason")
  62. .HasMaxLength(250)
  63. .HasColumnType("nvarchar(250)");
  64. b.Property<int>("LeaveType")
  65. .HasColumnType("int");
  66. b.Property<DateTime?>("UpdateDate")
  67. .HasColumnType("datetime2")
  68. .HasColumnOrder(4);
  69. b.Property<string>("UpdateUser")
  70. .HasMaxLength(450)
  71. .HasColumnType("nvarchar(450)")
  72. .HasColumnOrder(2);
  73. b.Property<string>("UserId")
  74. .IsRequired()
  75. .HasColumnType("nvarchar(max)");
  76. b.Property<string>("UserName")
  77. .HasColumnType("nvarchar(max)");
  78. b.HasKey("Id");
  79. b.ToTable("Attendances");
  80. });
  81. modelBuilder.Entity("MTWorkHR.Core.Entities.AttendanceLog", b =>
  82. {
  83. b.Property<long>("Id")
  84. .ValueGeneratedOnAdd()
  85. .HasColumnType("bigint")
  86. .HasColumnOrder(0);
  87. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  88. b.Property<string>("Channel")
  89. .HasColumnType("nvarchar(max)");
  90. b.Property<DateTime>("CreateDate")
  91. .HasColumnType("datetime2");
  92. b.Property<string>("CreateUser")
  93. .IsRequired()
  94. .HasColumnType("nvarchar(max)");
  95. b.Property<string>("ErrorCode")
  96. .IsRequired()
  97. .HasColumnType("nvarchar(max)");
  98. b.Property<string>("ErrorDescription")
  99. .IsRequired()
  100. .HasColumnType("nvarchar(max)");
  101. b.Property<string>("InnerException")
  102. .HasColumnType("nvarchar(max)");
  103. b.Property<string>("Input")
  104. .HasColumnType("nvarchar(max)");
  105. b.Property<string>("Method")
  106. .IsRequired()
  107. .HasColumnType("nvarchar(max)");
  108. b.Property<string>("QueryString")
  109. .HasColumnType("nvarchar(max)");
  110. b.Property<string>("ServerIP")
  111. .HasColumnType("nvarchar(max)");
  112. b.Property<string>("ServiceResponseTimeInSeconds")
  113. .IsRequired()
  114. .HasColumnType("nvarchar(max)");
  115. b.Property<string>("UserIP")
  116. .HasColumnType("nvarchar(max)");
  117. b.Property<string>("userAgent")
  118. .HasColumnType("nvarchar(max)");
  119. b.HasKey("Id");
  120. b.ToTable("AttendanceLogs");
  121. });
  122. modelBuilder.Entity("MTWorkHR.Core.Entities.AuthLog", b =>
  123. {
  124. b.Property<long>("Id")
  125. .ValueGeneratedOnAdd()
  126. .HasColumnType("bigint")
  127. .HasColumnOrder(0);
  128. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  129. b.Property<string>("Channel")
  130. .HasColumnType("nvarchar(max)");
  131. b.Property<DateTime>("CreateDate")
  132. .HasColumnType("datetime2");
  133. b.Property<string>("CreateUser")
  134. .IsRequired()
  135. .HasColumnType("nvarchar(max)");
  136. b.Property<string>("ErrorCode")
  137. .IsRequired()
  138. .HasColumnType("nvarchar(max)");
  139. b.Property<string>("ErrorDescription")
  140. .IsRequired()
  141. .HasColumnType("nvarchar(max)");
  142. b.Property<string>("InnerException")
  143. .HasColumnType("nvarchar(max)");
  144. b.Property<string>("Input")
  145. .HasColumnType("nvarchar(max)");
  146. b.Property<string>("Method")
  147. .IsRequired()
  148. .HasColumnType("nvarchar(max)");
  149. b.Property<string>("QueryString")
  150. .HasColumnType("nvarchar(max)");
  151. b.Property<string>("ServerIP")
  152. .HasColumnType("nvarchar(max)");
  153. b.Property<string>("ServiceResponseTimeInSeconds")
  154. .IsRequired()
  155. .HasColumnType("nvarchar(max)");
  156. b.Property<string>("UserIP")
  157. .HasColumnType("nvarchar(max)");
  158. b.Property<string>("userAgent")
  159. .HasColumnType("nvarchar(max)");
  160. b.HasKey("Id");
  161. b.ToTable("AuthLogs");
  162. });
  163. modelBuilder.Entity("MTWorkHR.Core.Entities.Base.AttachmentType", b =>
  164. {
  165. b.Property<long>("Id")
  166. .ValueGeneratedOnAdd()
  167. .HasColumnType("bigint")
  168. .HasColumnOrder(0);
  169. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  170. b.Property<bool>("IsRequired")
  171. .HasColumnType("bit");
  172. b.Property<string>("NameAr")
  173. .IsRequired()
  174. .HasMaxLength(250)
  175. .HasColumnType("nvarchar(250)");
  176. b.Property<string>("NameEn")
  177. .IsRequired()
  178. .HasMaxLength(250)
  179. .HasColumnType("nvarchar(250)");
  180. b.HasKey("Id");
  181. b.ToTable("AttachmentTypes");
  182. b.HasData(
  183. new
  184. {
  185. Id = 1L,
  186. IsRequired = false,
  187. NameAr = "السيرة الذاتية",
  188. NameEn = "CV"
  189. },
  190. new
  191. {
  192. Id = 2L,
  193. IsRequired = false,
  194. NameAr = "جواز السفر",
  195. NameEn = "Passport"
  196. },
  197. new
  198. {
  199. Id = 3L,
  200. IsRequired = false,
  201. NameAr = "شهادة التعليم",
  202. NameEn = "Education Certification"
  203. },
  204. new
  205. {
  206. Id = 4L,
  207. IsRequired = false,
  208. NameAr = "شهادة الخبرة",
  209. NameEn = "Experience Certification"
  210. },
  211. new
  212. {
  213. Id = 5L,
  214. IsRequired = false,
  215. NameAr = "شهادة الاحتراف",
  216. NameEn = "Professional Certification"
  217. },
  218. new
  219. {
  220. Id = 6L,
  221. IsRequired = false,
  222. NameAr = "شهادة الاحتراف",
  223. NameEn = "Commercial Regestration"
  224. },
  225. new
  226. {
  227. Id = 7L,
  228. IsRequired = false,
  229. NameAr = "البطاقة الضريبية",
  230. NameEn = "Tax Declaration"
  231. },
  232. new
  233. {
  234. Id = 8L,
  235. IsRequired = false,
  236. NameAr = "الهوية",
  237. NameEn = "Identification"
  238. });
  239. });
  240. modelBuilder.Entity("MTWorkHR.Core.Entities.City", b =>
  241. {
  242. b.Property<long>("Id")
  243. .ValueGeneratedOnAdd()
  244. .HasColumnType("bigint")
  245. .HasColumnOrder(0);
  246. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  247. b.Property<string>("Code")
  248. .IsRequired()
  249. .HasColumnType("nvarchar(max)");
  250. b.Property<long>("CountryId")
  251. .HasColumnType("bigint");
  252. b.Property<string>("NameAr")
  253. .IsRequired()
  254. .HasMaxLength(250)
  255. .HasColumnType("nvarchar(250)");
  256. b.Property<string>("NameEn")
  257. .IsRequired()
  258. .HasMaxLength(250)
  259. .HasColumnType("nvarchar(250)");
  260. b.Property<string>("NameFr")
  261. .IsRequired()
  262. .HasColumnType("nvarchar(max)");
  263. b.HasKey("Id");
  264. b.HasIndex("CountryId");
  265. b.ToTable("Cities");
  266. });
  267. modelBuilder.Entity("MTWorkHR.Core.Entities.Company", b =>
  268. {
  269. b.Property<long>("Id")
  270. .ValueGeneratedOnAdd()
  271. .HasColumnType("bigint")
  272. .HasColumnOrder(0);
  273. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  274. b.Property<string>("CRNumber")
  275. .IsRequired()
  276. .HasColumnType("nvarchar(max)");
  277. b.Property<string>("CompanyName")
  278. .IsRequired()
  279. .HasColumnType("nvarchar(max)");
  280. b.Property<DateTime>("CreateDate")
  281. .HasColumnType("datetime2")
  282. .HasColumnOrder(3);
  283. b.Property<string>("CreateUser")
  284. .HasMaxLength(450)
  285. .HasColumnType("nvarchar(450)")
  286. .HasColumnOrder(1);
  287. b.Property<string>("DeleteUserId")
  288. .HasMaxLength(450)
  289. .HasColumnType("nvarchar(450)")
  290. .HasColumnOrder(8);
  291. b.Property<bool>("IsDeleted")
  292. .HasColumnType("bit")
  293. .HasColumnOrder(7);
  294. b.Property<int>("TaxNumber")
  295. .HasColumnType("int");
  296. b.Property<DateTime?>("UpdateDate")
  297. .HasColumnType("datetime2")
  298. .HasColumnOrder(4);
  299. b.Property<string>("UpdateUser")
  300. .HasMaxLength(450)
  301. .HasColumnType("nvarchar(450)")
  302. .HasColumnOrder(2);
  303. b.Property<string>("UserId")
  304. .IsRequired()
  305. .HasColumnType("nvarchar(max)");
  306. b.HasKey("Id");
  307. b.ToTable("Companies");
  308. });
  309. modelBuilder.Entity("MTWorkHR.Core.Entities.CountryLookup", b =>
  310. {
  311. b.Property<long>("Id")
  312. .ValueGeneratedOnAdd()
  313. .HasColumnType("bigint")
  314. .HasColumnOrder(0);
  315. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  316. b.Property<string>("Code")
  317. .IsRequired()
  318. .HasColumnType("nvarchar(max)");
  319. b.Property<string>("NameAr")
  320. .IsRequired()
  321. .HasMaxLength(250)
  322. .HasColumnType("nvarchar(250)");
  323. b.Property<string>("NameEn")
  324. .IsRequired()
  325. .HasMaxLength(250)
  326. .HasColumnType("nvarchar(250)");
  327. b.Property<string>("NameFr")
  328. .IsRequired()
  329. .HasColumnType("nvarchar(max)");
  330. b.HasKey("Id");
  331. b.ToTable("CountryLookups");
  332. });
  333. modelBuilder.Entity("MTWorkHR.Core.Entities.FileLog", b =>
  334. {
  335. b.Property<long>("Id")
  336. .ValueGeneratedOnAdd()
  337. .HasColumnType("bigint")
  338. .HasColumnOrder(0);
  339. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  340. b.Property<string>("Channel")
  341. .HasColumnType("nvarchar(max)");
  342. b.Property<DateTime>("CreateDate")
  343. .HasColumnType("datetime2");
  344. b.Property<string>("CreateUser")
  345. .IsRequired()
  346. .HasColumnType("nvarchar(max)");
  347. b.Property<string>("ErrorCode")
  348. .IsRequired()
  349. .HasColumnType("nvarchar(max)");
  350. b.Property<string>("ErrorDescription")
  351. .IsRequired()
  352. .HasColumnType("nvarchar(max)");
  353. b.Property<string>("InnerException")
  354. .HasColumnType("nvarchar(max)");
  355. b.Property<string>("Input")
  356. .HasColumnType("nvarchar(max)");
  357. b.Property<string>("Method")
  358. .IsRequired()
  359. .HasColumnType("nvarchar(max)");
  360. b.Property<string>("QueryString")
  361. .HasColumnType("nvarchar(max)");
  362. b.Property<string>("ServerIP")
  363. .HasColumnType("nvarchar(max)");
  364. b.Property<string>("ServiceResponseTimeInSeconds")
  365. .IsRequired()
  366. .HasColumnType("nvarchar(max)");
  367. b.Property<string>("UserIP")
  368. .HasColumnType("nvarchar(max)");
  369. b.Property<string>("userAgent")
  370. .HasColumnType("nvarchar(max)");
  371. b.HasKey("Id");
  372. b.ToTable("FileLogs");
  373. });
  374. modelBuilder.Entity("MTWorkHR.Core.Entities.Industry", b =>
  375. {
  376. b.Property<long>("Id")
  377. .ValueGeneratedOnAdd()
  378. .HasColumnType("bigint")
  379. .HasColumnOrder(0);
  380. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  381. b.Property<string>("NameAr")
  382. .IsRequired()
  383. .HasMaxLength(250)
  384. .HasColumnType("nvarchar(250)");
  385. b.Property<string>("NameEn")
  386. .IsRequired()
  387. .HasMaxLength(250)
  388. .HasColumnType("nvarchar(250)");
  389. b.HasKey("Id");
  390. b.ToTable("Industries");
  391. b.HasData(
  392. new
  393. {
  394. Id = 1L,
  395. NameAr = "صناعة الطيران والفضاء",
  396. NameEn = "Aerospace industry"
  397. },
  398. new
  399. {
  400. Id = 2L,
  401. NameAr = "صناعة الزراعة",
  402. NameEn = "Agricultural industry"
  403. },
  404. new
  405. {
  406. Id = 3L,
  407. NameAr = "صناعة السيارات",
  408. NameEn = "Automotive industry"
  409. },
  410. new
  411. {
  412. Id = 4L,
  413. NameAr = "صناعة المعادن الأساسية",
  414. NameEn = "Basic metal"
  415. },
  416. new
  417. {
  418. Id = 5L,
  419. NameAr = "صناعة الكيماويات",
  420. NameEn = "Chemical industry"
  421. },
  422. new
  423. {
  424. Id = 6L,
  425. NameAr = "صناعة الحواسيب",
  426. NameEn = "Computer industry"
  427. },
  428. new
  429. {
  430. Id = 7L,
  431. NameAr = "صناعة البناء",
  432. NameEn = "Construction industry"
  433. },
  434. new
  435. {
  436. Id = 8L,
  437. NameAr = "صناعة الإبداعية",
  438. NameEn = "Creative industry"
  439. },
  440. new
  441. {
  442. Id = 9L,
  443. NameAr = "صناعة الثقافة",
  444. NameEn = "Cultural industry"
  445. },
  446. new
  447. {
  448. Id = 10L,
  449. NameAr = "صناعة الدفاع",
  450. NameEn = "Defense industry"
  451. },
  452. new
  453. {
  454. Id = 11L,
  455. NameAr = "صناعة التعليم",
  456. NameEn = "Education industry"
  457. },
  458. new
  459. {
  460. Id = 12L,
  461. NameAr = "صناعة الطاقة الكهربائية",
  462. NameEn = "Electric power"
  463. },
  464. new
  465. {
  466. Id = 13L,
  467. NameAr = "صناعة الإلكترونيات",
  468. NameEn = "Electronics industry"
  469. },
  470. new
  471. {
  472. Id = 14L,
  473. NameAr = "صناعة الطاقة",
  474. NameEn = "Energy industry"
  475. },
  476. new
  477. {
  478. Id = 15L,
  479. NameAr = "صناعة الهندسة",
  480. NameEn = "Engineering industry"
  481. },
  482. new
  483. {
  484. Id = 16L,
  485. NameAr = "صناعة الترفيه",
  486. NameEn = "Entertainment industry"
  487. },
  488. new
  489. {
  490. Id = 17L,
  491. NameAr = "صناعة الزراعة",
  492. NameEn = "Farming industry"
  493. },
  494. new
  495. {
  496. Id = 18L,
  497. NameAr = "صناعة الموضة",
  498. NameEn = "Fashion industry"
  499. },
  500. new
  501. {
  502. Id = 19L,
  503. NameAr = "صناعة السينما",
  504. NameEn = "Film industry"
  505. },
  506. new
  507. {
  508. Id = 20L,
  509. NameAr = "صناعة الخدمات المالية",
  510. NameEn = "Financial services"
  511. },
  512. new
  513. {
  514. Id = 21L,
  515. NameAr = "صناعة الصيد",
  516. NameEn = "Fishing industry"
  517. },
  518. new
  519. {
  520. Id = 22L,
  521. NameAr = "صناعة الأغذية",
  522. NameEn = "Food industry"
  523. },
  524. new
  525. {
  526. Id = 23L,
  527. NameAr = "صناعة الغابات",
  528. NameEn = "Forestry industry"
  529. },
  530. new
  531. {
  532. Id = 24L,
  533. NameAr = "صناعة القمار",
  534. NameEn = "Gambling industry"
  535. },
  536. new
  537. {
  538. Id = 25L,
  539. NameAr = "صناعة الغاز",
  540. NameEn = "Gas industry"
  541. },
  542. new
  543. {
  544. Id = 26L,
  545. NameAr = "صناعة البيئة",
  546. NameEn = "Green industry"
  547. },
  548. new
  549. {
  550. Id = 27L,
  551. NameAr = "صناعة الخدمات الصحية",
  552. NameEn = "Health services industry"
  553. },
  554. new
  555. {
  556. Id = 28L,
  557. NameAr = "صناعة الضيافة",
  558. NameEn = "Hospitality industry"
  559. },
  560. new
  561. {
  562. Id = 29L,
  563. NameAr = "صناعة الفنادق",
  564. NameEn = "Hotels industry"
  565. },
  566. new
  567. {
  568. Id = 30L,
  569. NameAr = "صناعة الروبوتات الصناعية",
  570. NameEn = "Industrial robot"
  571. },
  572. new
  573. {
  574. Id = 31L,
  575. NameAr = "صناعة المعلومات",
  576. NameEn = "Information industry"
  577. },
  578. new
  579. {
  580. Id = 32L,
  581. NameAr = "صناعة تكنولوجيا المعلومات",
  582. NameEn = "Information technology"
  583. },
  584. new
  585. {
  586. Id = 33L,
  587. NameAr = "صناعة البنية التحتية",
  588. NameEn = "Infrastructure industry"
  589. },
  590. new
  591. {
  592. Id = 34L,
  593. NameAr = "صناعة التأمين",
  594. NameEn = "Insurance industry"
  595. },
  596. new
  597. {
  598. Id = 35L,
  599. NameAr = "صناعة الترفيه",
  600. NameEn = "Leisure industry"
  601. },
  602. new
  603. {
  604. Id = 36L,
  605. NameAr = "صناعة التكنولوجيا المنخفضة",
  606. NameEn = "Low technology"
  607. },
  608. new
  609. {
  610. Id = 37L,
  611. NameAr = "صناعة التصنيع",
  612. NameEn = "Manufacturing industry"
  613. },
  614. new
  615. {
  616. Id = 38L,
  617. NameAr = "صناعة اللحوم",
  618. NameEn = "Meat industry"
  619. },
  620. new
  621. {
  622. Id = 39L,
  623. NameAr = "صناعة الإعلام",
  624. NameEn = "Media industry"
  625. },
  626. new
  627. {
  628. Id = 40L,
  629. NameAr = "صناعة التجارة",
  630. NameEn = "Merchandising industry"
  631. },
  632. new
  633. {
  634. Id = 41L,
  635. NameAr = "صناعة التعدين",
  636. NameEn = "Mining industry"
  637. },
  638. new
  639. {
  640. Id = 42L,
  641. NameAr = "صناعة الموسيقى",
  642. NameEn = "Music industry"
  643. },
  644. new
  645. {
  646. Id = 43L,
  647. NameAr = "صناعة وسائل الإعلام",
  648. NameEn = "News media"
  649. },
  650. new
  651. {
  652. Id = 44L,
  653. NameAr = "صناعة النفط والغاز",
  654. NameEn = "Oil and gas industry"
  655. },
  656. new
  657. {
  658. Id = 45L,
  659. NameAr = "صناعة الأدوية",
  660. NameEn = "Pharmaceutical industry"
  661. },
  662. new
  663. {
  664. Id = 46L,
  665. NameAr = "صناعة المهنية",
  666. NameEn = "Professional industry"
  667. },
  668. new
  669. {
  670. Id = 47L,
  671. NameAr = "صناعة النشر",
  672. NameEn = "Publishing industry"
  673. },
  674. new
  675. {
  676. Id = 48L,
  677. NameAr = "صناعة الورق واللب",
  678. NameEn = "Pulp and paper industry"
  679. },
  680. new
  681. {
  682. Id = 49L,
  683. NameAr = "صناعة السكك الحديدية",
  684. NameEn = "Railway industry"
  685. },
  686. new
  687. {
  688. Id = 50L,
  689. NameAr = "الانشاءات",
  690. NameEn = "Real estate"
  691. });
  692. });
  693. modelBuilder.Entity("MTWorkHR.Core.Entities.JobTitle", b =>
  694. {
  695. b.Property<long>("Id")
  696. .ValueGeneratedOnAdd()
  697. .HasColumnType("bigint")
  698. .HasColumnOrder(0);
  699. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  700. b.Property<string>("NameAr")
  701. .IsRequired()
  702. .HasMaxLength(250)
  703. .HasColumnType("nvarchar(250)");
  704. b.Property<string>("NameEn")
  705. .IsRequired()
  706. .HasMaxLength(250)
  707. .HasColumnType("nvarchar(250)");
  708. b.HasKey("Id");
  709. b.ToTable("JobTitles");
  710. b.HasData(
  711. new
  712. {
  713. Id = 1L,
  714. NameAr = "مساعد ادارى",
  715. NameEn = "Administrative Assistant"
  716. },
  717. new
  718. {
  719. Id = 2L,
  720. NameAr = "موظف استقبال",
  721. NameEn = "Receptionist"
  722. },
  723. new
  724. {
  725. Id = 3L,
  726. NameAr = "مدير مكتب",
  727. NameEn = "Office Manager"
  728. },
  729. new
  730. {
  731. Id = 4L,
  732. NameAr = "مدقق محتوى",
  733. NameEn = "Auditing Clerk"
  734. },
  735. new
  736. {
  737. Id = 5L,
  738. NameAr = "محاسب",
  739. NameEn = "Bookkeeper"
  740. },
  741. new
  742. {
  743. Id = 6L,
  744. NameAr = "مدير تنفيذى",
  745. NameEn = "Account Executive"
  746. },
  747. new
  748. {
  749. Id = 7L,
  750. NameAr = "مدير فرع",
  751. NameEn = "Branch Manager"
  752. },
  753. new
  754. {
  755. Id = 8L,
  756. NameAr = "مدير",
  757. NameEn = "Business Manager"
  758. },
  759. new
  760. {
  761. Id = 9L,
  762. NameAr = "مسؤول الجودة",
  763. NameEn = "Quality Control Coordinator"
  764. },
  765. new
  766. {
  767. Id = 10L,
  768. NameAr = "مدير ادارى",
  769. NameEn = "Administrative Manager"
  770. },
  771. new
  772. {
  773. Id = 11L,
  774. NameAr = "الرئيس التنفيذي",
  775. NameEn = "Chief Executive Officer"
  776. },
  777. new
  778. {
  779. Id = 12L,
  780. NameAr = "محلل",
  781. NameEn = "Business Analyst"
  782. },
  783. new
  784. {
  785. Id = 13L,
  786. NameAr = "مدير المخاطر",
  787. NameEn = "Risk Manager"
  788. },
  789. new
  790. {
  791. Id = 14L,
  792. NameAr = "موارد بشرية",
  793. NameEn = "Human Resources"
  794. },
  795. new
  796. {
  797. Id = 15L,
  798. NameAr = "مساعد مكتب",
  799. NameEn = "Office Assistant"
  800. },
  801. new
  802. {
  803. Id = 16L,
  804. NameAr = "السكرتارية",
  805. NameEn = "Secretary"
  806. },
  807. new
  808. {
  809. Id = 17L,
  810. NameAr = "موظف مكتب",
  811. NameEn = "Office Clerk"
  812. },
  813. new
  814. {
  815. Id = 18L,
  816. NameAr = "جامع الحسابات",
  817. NameEn = "Account Collector"
  818. },
  819. new
  820. {
  821. Id = 19L,
  822. NameAr = "أخصائي إداري",
  823. NameEn = "Administrative Specialist"
  824. },
  825. new
  826. {
  827. Id = 20L,
  828. NameAr = "مساعد تنفيذي",
  829. NameEn = "Executive Assistant"
  830. },
  831. new
  832. {
  833. Id = 21L,
  834. NameAr = "مسؤل البرنامج",
  835. NameEn = "Program Administrator"
  836. },
  837. new
  838. {
  839. Id = 22L,
  840. NameAr = "مدير البرنامج",
  841. NameEn = "Program Manager"
  842. },
  843. new
  844. {
  845. Id = 23L,
  846. NameAr = "محلل إداري",
  847. NameEn = "Administrative Analyst"
  848. },
  849. new
  850. {
  851. Id = 24L,
  852. NameAr = "مدخل بيانات",
  853. NameEn = "Data Entry"
  854. });
  855. });
  856. modelBuilder.Entity("MTWorkHR.Core.Entities.LeaveType", b =>
  857. {
  858. b.Property<long>("Id")
  859. .ValueGeneratedOnAdd()
  860. .HasColumnType("bigint")
  861. .HasColumnOrder(0);
  862. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  863. b.Property<int>("DefaultDays")
  864. .HasColumnType("int");
  865. b.Property<string>("NameAr")
  866. .IsRequired()
  867. .HasColumnType("nvarchar(max)");
  868. b.Property<string>("NameEn")
  869. .IsRequired()
  870. .HasColumnType("nvarchar(max)");
  871. b.HasKey("Id");
  872. b.ToTable("LeaveTypes");
  873. b.HasData(
  874. new
  875. {
  876. Id = 1L,
  877. DefaultDays = 21,
  878. NameAr = "أجازة سنوية",
  879. NameEn = "Annual Leave"
  880. },
  881. new
  882. {
  883. Id = 2L,
  884. DefaultDays = 15,
  885. NameAr = "أجازة مرضية",
  886. NameEn = "Sick Leave"
  887. },
  888. new
  889. {
  890. Id = 3L,
  891. DefaultDays = 20,
  892. NameAr = "أجازة زواج",
  893. NameEn = "Marriage Leave"
  894. },
  895. new
  896. {
  897. Id = 4L,
  898. DefaultDays = 10,
  899. NameAr = "أجازة وضع",
  900. NameEn = "Paternity leave"
  901. },
  902. new
  903. {
  904. Id = 5L,
  905. DefaultDays = 10,
  906. NameAr = "أجازة طارئة",
  907. NameEn = "Emergency leave"
  908. });
  909. });
  910. modelBuilder.Entity("MTWorkHR.Core.Entities.LoginOTP", b =>
  911. {
  912. b.Property<long>("Id")
  913. .ValueGeneratedOnAdd()
  914. .HasColumnType("bigint")
  915. .HasColumnOrder(0);
  916. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  917. b.Property<DateTime>("CreateDate")
  918. .HasColumnType("datetime2");
  919. b.Property<DateTime>("ExpireDate")
  920. .HasColumnType("datetime2");
  921. b.Property<string>("OTP")
  922. .IsRequired()
  923. .HasColumnType("nvarchar(max)");
  924. b.Property<string>("UserId")
  925. .IsRequired()
  926. .HasColumnType("nvarchar(max)");
  927. b.HasKey("Id");
  928. b.ToTable("LoginOTPs");
  929. });
  930. modelBuilder.Entity("MTWorkHR.Core.Entities.Meeting", b =>
  931. {
  932. b.Property<long>("Id")
  933. .ValueGeneratedOnAdd()
  934. .HasColumnType("bigint")
  935. .HasColumnOrder(0);
  936. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  937. b.Property<DateTime>("CreateDate")
  938. .HasColumnType("datetime2")
  939. .HasColumnOrder(3);
  940. b.Property<string>("CreateUser")
  941. .HasMaxLength(450)
  942. .HasColumnType("nvarchar(450)")
  943. .HasColumnOrder(1);
  944. b.Property<string>("DeleteUserId")
  945. .HasMaxLength(450)
  946. .HasColumnType("nvarchar(450)")
  947. .HasColumnOrder(8);
  948. b.Property<string>("Description")
  949. .HasMaxLength(500)
  950. .HasColumnType("nvarchar(500)");
  951. b.Property<DateTime>("EndDate")
  952. .HasColumnType("datetime2");
  953. b.Property<bool>("IsDeleted")
  954. .HasColumnType("bit")
  955. .HasColumnOrder(7);
  956. b.Property<string>("Location")
  957. .HasMaxLength(250)
  958. .HasColumnType("nvarchar(250)");
  959. b.Property<string>("MeetingLink")
  960. .HasMaxLength(250)
  961. .HasColumnType("nvarchar(250)");
  962. b.Property<DateTime>("StartDate")
  963. .HasColumnType("datetime2");
  964. b.Property<string>("Title")
  965. .IsRequired()
  966. .HasMaxLength(250)
  967. .HasColumnType("nvarchar(250)");
  968. b.Property<DateTime?>("UpdateDate")
  969. .HasColumnType("datetime2")
  970. .HasColumnOrder(4);
  971. b.Property<string>("UpdateUser")
  972. .HasMaxLength(450)
  973. .HasColumnType("nvarchar(450)")
  974. .HasColumnOrder(2);
  975. b.HasKey("Id");
  976. b.ToTable("Meetings");
  977. });
  978. modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingLog", b =>
  979. {
  980. b.Property<long>("Id")
  981. .ValueGeneratedOnAdd()
  982. .HasColumnType("bigint")
  983. .HasColumnOrder(0);
  984. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  985. b.Property<string>("Channel")
  986. .HasColumnType("nvarchar(max)");
  987. b.Property<DateTime>("CreateDate")
  988. .HasColumnType("datetime2");
  989. b.Property<string>("CreateUser")
  990. .IsRequired()
  991. .HasColumnType("nvarchar(max)");
  992. b.Property<string>("ErrorCode")
  993. .IsRequired()
  994. .HasColumnType("nvarchar(max)");
  995. b.Property<string>("ErrorDescription")
  996. .IsRequired()
  997. .HasColumnType("nvarchar(max)");
  998. b.Property<string>("InnerException")
  999. .HasColumnType("nvarchar(max)");
  1000. b.Property<string>("Input")
  1001. .HasColumnType("nvarchar(max)");
  1002. b.Property<string>("Method")
  1003. .IsRequired()
  1004. .HasColumnType("nvarchar(max)");
  1005. b.Property<string>("QueryString")
  1006. .HasColumnType("nvarchar(max)");
  1007. b.Property<string>("ServerIP")
  1008. .HasColumnType("nvarchar(max)");
  1009. b.Property<string>("ServiceResponseTimeInSeconds")
  1010. .IsRequired()
  1011. .HasColumnType("nvarchar(max)");
  1012. b.Property<string>("UserIP")
  1013. .HasColumnType("nvarchar(max)");
  1014. b.Property<string>("userAgent")
  1015. .HasColumnType("nvarchar(max)");
  1016. b.HasKey("Id");
  1017. b.ToTable("MeetingLogs");
  1018. });
  1019. modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingUser", b =>
  1020. {
  1021. b.Property<long>("Id")
  1022. .ValueGeneratedOnAdd()
  1023. .HasColumnType("bigint")
  1024. .HasColumnOrder(0);
  1025. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1026. b.Property<string>("AssignedUserId")
  1027. .IsRequired()
  1028. .HasColumnType("nvarchar(max)");
  1029. b.Property<DateTime>("CreateDate")
  1030. .HasColumnType("datetime2")
  1031. .HasColumnOrder(3);
  1032. b.Property<string>("CreateUser")
  1033. .HasMaxLength(450)
  1034. .HasColumnType("nvarchar(450)")
  1035. .HasColumnOrder(1);
  1036. b.Property<long>("MeetingId")
  1037. .HasColumnType("bigint");
  1038. b.Property<DateTime?>("UpdateDate")
  1039. .HasColumnType("datetime2")
  1040. .HasColumnOrder(4);
  1041. b.Property<string>("UpdateUser")
  1042. .HasMaxLength(450)
  1043. .HasColumnType("nvarchar(450)")
  1044. .HasColumnOrder(2);
  1045. b.HasKey("Id");
  1046. b.HasIndex("MeetingId");
  1047. b.ToTable("MeetingUser");
  1048. });
  1049. modelBuilder.Entity("MTWorkHR.Core.Entities.OrderAllocation", b =>
  1050. {
  1051. b.Property<long>("Id")
  1052. .ValueGeneratedOnAdd()
  1053. .HasColumnType("bigint")
  1054. .HasColumnOrder(0);
  1055. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1056. b.Property<DateTime>("CreateDate")
  1057. .HasColumnType("datetime2")
  1058. .HasColumnOrder(3);
  1059. b.Property<string>("CreateUser")
  1060. .HasMaxLength(450)
  1061. .HasColumnType("nvarchar(450)")
  1062. .HasColumnOrder(1);
  1063. b.Property<string>("EmployeeId")
  1064. .IsRequired()
  1065. .HasColumnType("nvarchar(max)");
  1066. b.Property<long?>("LeaveTypeId")
  1067. .HasColumnType("bigint");
  1068. b.Property<int>("NumberOfDays")
  1069. .HasColumnType("int");
  1070. b.Property<long>("OrderTypeId")
  1071. .HasColumnType("bigint");
  1072. b.Property<int>("Period")
  1073. .HasColumnType("int");
  1074. b.Property<DateTime?>("UpdateDate")
  1075. .HasColumnType("datetime2")
  1076. .HasColumnOrder(4);
  1077. b.Property<string>("UpdateUser")
  1078. .HasMaxLength(450)
  1079. .HasColumnType("nvarchar(450)")
  1080. .HasColumnOrder(2);
  1081. b.HasKey("Id");
  1082. b.HasIndex("LeaveTypeId");
  1083. b.HasIndex("OrderTypeId");
  1084. b.ToTable("OrderAllocations");
  1085. });
  1086. modelBuilder.Entity("MTWorkHR.Core.Entities.OrderType", b =>
  1087. {
  1088. b.Property<long>("Id")
  1089. .ValueGeneratedOnAdd()
  1090. .HasColumnType("bigint")
  1091. .HasColumnOrder(0);
  1092. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1093. b.Property<int>("DefaultDays")
  1094. .HasColumnType("int");
  1095. b.Property<string>("NameAr")
  1096. .IsRequired()
  1097. .HasColumnType("nvarchar(max)");
  1098. b.Property<string>("NameEn")
  1099. .IsRequired()
  1100. .HasColumnType("nvarchar(max)");
  1101. b.HasKey("Id");
  1102. b.ToTable("OrderTypes");
  1103. b.HasData(
  1104. new
  1105. {
  1106. Id = 1L,
  1107. DefaultDays = 2,
  1108. NameAr = "إذن",
  1109. NameEn = "Leave"
  1110. },
  1111. new
  1112. {
  1113. Id = 2L,
  1114. DefaultDays = 15,
  1115. NameAr = "طبية",
  1116. NameEn = "Medical"
  1117. },
  1118. new
  1119. {
  1120. Id = 3L,
  1121. DefaultDays = 20,
  1122. NameAr = "وقت إضافي",
  1123. NameEn = "Overtime"
  1124. },
  1125. new
  1126. {
  1127. Id = 4L,
  1128. DefaultDays = 0,
  1129. NameAr = "رحلة عمل",
  1130. NameEn = "Business trip"
  1131. },
  1132. new
  1133. {
  1134. Id = 5L,
  1135. DefaultDays = 0,
  1136. NameAr = "دورة تدريبية",
  1137. NameEn = "Course"
  1138. });
  1139. });
  1140. modelBuilder.Entity("MTWorkHR.Core.Entities.Permission", b =>
  1141. {
  1142. b.Property<long>("Id")
  1143. .ValueGeneratedOnAdd()
  1144. .HasColumnType("bigint")
  1145. .HasColumnOrder(0);
  1146. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1147. b.Property<string>("CategoryName")
  1148. .IsRequired()
  1149. .HasMaxLength(150)
  1150. .HasColumnType("nvarchar(150)");
  1151. b.Property<string>("Desc")
  1152. .IsRequired()
  1153. .HasMaxLength(250)
  1154. .HasColumnType("nvarchar(250)");
  1155. b.Property<string>("Name")
  1156. .IsRequired()
  1157. .HasMaxLength(250)
  1158. .HasColumnType("nvarchar(250)");
  1159. b.Property<bool>("Show")
  1160. .HasColumnType("bit");
  1161. b.HasKey("Id");
  1162. b.ToTable("Permissions");
  1163. b.HasData(
  1164. new
  1165. {
  1166. Id = 1L,
  1167. CategoryName = "User",
  1168. Desc = "Project",
  1169. Name = "Project",
  1170. Show = true
  1171. },
  1172. new
  1173. {
  1174. Id = 2L,
  1175. CategoryName = "User",
  1176. Desc = "Project.Create",
  1177. Name = "Project.Create",
  1178. Show = false
  1179. },
  1180. new
  1181. {
  1182. Id = 3L,
  1183. CategoryName = "User",
  1184. Desc = "Project.Update",
  1185. Name = "Project.Update",
  1186. Show = false
  1187. },
  1188. new
  1189. {
  1190. Id = 4L,
  1191. CategoryName = "User",
  1192. Desc = "Project.Delete",
  1193. Name = "Project.Delete",
  1194. Show = false
  1195. },
  1196. new
  1197. {
  1198. Id = 5L,
  1199. CategoryName = "User",
  1200. Desc = "Meeting",
  1201. Name = "Meeting",
  1202. Show = true
  1203. },
  1204. new
  1205. {
  1206. Id = 6L,
  1207. CategoryName = "User",
  1208. Desc = "Meeting.Create",
  1209. Name = "Meeting.Create",
  1210. Show = false
  1211. },
  1212. new
  1213. {
  1214. Id = 7L,
  1215. CategoryName = "User",
  1216. Desc = "Meeting.Update",
  1217. Name = "Meeting.Update",
  1218. Show = false
  1219. },
  1220. new
  1221. {
  1222. Id = 8L,
  1223. CategoryName = "User",
  1224. Desc = "Meeting.Delete",
  1225. Name = "Meeting.Delete",
  1226. Show = false
  1227. },
  1228. new
  1229. {
  1230. Id = 9L,
  1231. CategoryName = "User",
  1232. Desc = "Team",
  1233. Name = "Team",
  1234. Show = true
  1235. },
  1236. new
  1237. {
  1238. Id = 10L,
  1239. CategoryName = "User",
  1240. Desc = "Team.Create",
  1241. Name = "Team.Create",
  1242. Show = false
  1243. },
  1244. new
  1245. {
  1246. Id = 11L,
  1247. CategoryName = "User",
  1248. Desc = "Team.Update",
  1249. Name = "Team.Update",
  1250. Show = false
  1251. },
  1252. new
  1253. {
  1254. Id = 12L,
  1255. CategoryName = "User",
  1256. Desc = "Team.Delete",
  1257. Name = "Team.Delete",
  1258. Show = false
  1259. },
  1260. new
  1261. {
  1262. Id = 13L,
  1263. CategoryName = "Sales",
  1264. Desc = "UserTask",
  1265. Name = "UserTask",
  1266. Show = true
  1267. },
  1268. new
  1269. {
  1270. Id = 14L,
  1271. CategoryName = "Sales",
  1272. Desc = "UserTask.Create",
  1273. Name = "UserTask.Create",
  1274. Show = false
  1275. },
  1276. new
  1277. {
  1278. Id = 15L,
  1279. CategoryName = "Sales",
  1280. Desc = "UserTask.Update",
  1281. Name = "UserTask.Update",
  1282. Show = false
  1283. },
  1284. new
  1285. {
  1286. Id = 16L,
  1287. CategoryName = "User",
  1288. Desc = "UserTask.Delete",
  1289. Name = "UserTask.Delete",
  1290. Show = false
  1291. },
  1292. new
  1293. {
  1294. Id = 17L,
  1295. CategoryName = "User",
  1296. Desc = "Company",
  1297. Name = "Company",
  1298. Show = true
  1299. },
  1300. new
  1301. {
  1302. Id = 18L,
  1303. CategoryName = "User",
  1304. Desc = "Company.Create",
  1305. Name = "Company.Create",
  1306. Show = false
  1307. },
  1308. new
  1309. {
  1310. Id = 19L,
  1311. CategoryName = "User",
  1312. Desc = "Company.Update",
  1313. Name = "Company.Update",
  1314. Show = false
  1315. },
  1316. new
  1317. {
  1318. Id = 20L,
  1319. CategoryName = "User",
  1320. Desc = "Company.Delete",
  1321. Name = "Company.Delete",
  1322. Show = false
  1323. },
  1324. new
  1325. {
  1326. Id = 21L,
  1327. CategoryName = "Adminstration",
  1328. Desc = "User",
  1329. Name = "User",
  1330. Show = true
  1331. },
  1332. new
  1333. {
  1334. Id = 22L,
  1335. CategoryName = "Adminstration",
  1336. Desc = "User.Create",
  1337. Name = "User.Create",
  1338. Show = false
  1339. },
  1340. new
  1341. {
  1342. Id = 23L,
  1343. CategoryName = "Adminstration",
  1344. Desc = "User.Update",
  1345. Name = "User.Update",
  1346. Show = false
  1347. },
  1348. new
  1349. {
  1350. Id = 24L,
  1351. CategoryName = "Adminstration",
  1352. Desc = "User.Delete",
  1353. Name = "User.Delete",
  1354. Show = false
  1355. },
  1356. new
  1357. {
  1358. Id = 25L,
  1359. CategoryName = "Adminstration",
  1360. Desc = "Role",
  1361. Name = "Role",
  1362. Show = true
  1363. },
  1364. new
  1365. {
  1366. Id = 26L,
  1367. CategoryName = "Adminstration",
  1368. Desc = "Role.Create",
  1369. Name = "Role.Create",
  1370. Show = false
  1371. },
  1372. new
  1373. {
  1374. Id = 27L,
  1375. CategoryName = "Adminstration",
  1376. Desc = "Role.Update",
  1377. Name = "Role.Update",
  1378. Show = false
  1379. },
  1380. new
  1381. {
  1382. Id = 28L,
  1383. CategoryName = "Adminstration",
  1384. Desc = "Role.Delete",
  1385. Name = "Role.Delete",
  1386. Show = false
  1387. });
  1388. });
  1389. modelBuilder.Entity("MTWorkHR.Core.Entities.Project", b =>
  1390. {
  1391. b.Property<long>("Id")
  1392. .ValueGeneratedOnAdd()
  1393. .HasColumnType("bigint")
  1394. .HasColumnOrder(0);
  1395. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1396. b.Property<DateTime>("CreateDate")
  1397. .HasColumnType("datetime2")
  1398. .HasColumnOrder(3);
  1399. b.Property<string>("CreateUser")
  1400. .HasMaxLength(450)
  1401. .HasColumnType("nvarchar(450)")
  1402. .HasColumnOrder(1);
  1403. b.Property<string>("DeleteUserId")
  1404. .HasMaxLength(450)
  1405. .HasColumnType("nvarchar(450)")
  1406. .HasColumnOrder(8);
  1407. b.Property<bool>("IsDeleted")
  1408. .HasColumnType("bit")
  1409. .HasColumnOrder(7);
  1410. b.Property<string>("NameAr")
  1411. .IsRequired()
  1412. .HasMaxLength(250)
  1413. .HasColumnType("nvarchar(250)");
  1414. b.Property<string>("NameEn")
  1415. .IsRequired()
  1416. .HasMaxLength(250)
  1417. .HasColumnType("nvarchar(250)");
  1418. b.Property<DateTime?>("UpdateDate")
  1419. .HasColumnType("datetime2")
  1420. .HasColumnOrder(4);
  1421. b.Property<string>("UpdateUser")
  1422. .HasMaxLength(450)
  1423. .HasColumnType("nvarchar(450)")
  1424. .HasColumnOrder(2);
  1425. b.HasKey("Id");
  1426. b.ToTable("Projects");
  1427. });
  1428. modelBuilder.Entity("MTWorkHR.Core.Entities.Qualification", b =>
  1429. {
  1430. b.Property<long>("Id")
  1431. .ValueGeneratedOnAdd()
  1432. .HasColumnType("bigint")
  1433. .HasColumnOrder(0);
  1434. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1435. b.Property<string>("NameAr")
  1436. .IsRequired()
  1437. .HasMaxLength(250)
  1438. .HasColumnType("nvarchar(250)");
  1439. b.Property<string>("NameEn")
  1440. .IsRequired()
  1441. .HasMaxLength(250)
  1442. .HasColumnType("nvarchar(250)");
  1443. b.HasKey("Id");
  1444. b.ToTable("Qualifications");
  1445. b.HasData(
  1446. new
  1447. {
  1448. Id = 1L,
  1449. NameAr = "بكالوريوس",
  1450. NameEn = "BSC"
  1451. },
  1452. new
  1453. {
  1454. Id = 2L,
  1455. NameAr = "درجة الماجيستير",
  1456. NameEn = "Master"
  1457. },
  1458. new
  1459. {
  1460. Id = 3L,
  1461. NameAr = "درحة الدكتوراه",
  1462. NameEn = "Doctor"
  1463. });
  1464. });
  1465. modelBuilder.Entity("MTWorkHR.Core.Entities.RoleLog", b =>
  1466. {
  1467. b.Property<long>("Id")
  1468. .ValueGeneratedOnAdd()
  1469. .HasColumnType("bigint")
  1470. .HasColumnOrder(0);
  1471. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1472. b.Property<string>("Channel")
  1473. .HasColumnType("nvarchar(max)");
  1474. b.Property<DateTime>("CreateDate")
  1475. .HasColumnType("datetime2");
  1476. b.Property<string>("CreateUser")
  1477. .IsRequired()
  1478. .HasColumnType("nvarchar(max)");
  1479. b.Property<string>("ErrorCode")
  1480. .IsRequired()
  1481. .HasColumnType("nvarchar(max)");
  1482. b.Property<string>("ErrorDescription")
  1483. .IsRequired()
  1484. .HasColumnType("nvarchar(max)");
  1485. b.Property<string>("InnerException")
  1486. .HasColumnType("nvarchar(max)");
  1487. b.Property<string>("Input")
  1488. .HasColumnType("nvarchar(max)");
  1489. b.Property<string>("Method")
  1490. .IsRequired()
  1491. .HasColumnType("nvarchar(max)");
  1492. b.Property<string>("QueryString")
  1493. .HasColumnType("nvarchar(max)");
  1494. b.Property<string>("ServerIP")
  1495. .HasColumnType("nvarchar(max)");
  1496. b.Property<string>("ServiceResponseTimeInSeconds")
  1497. .IsRequired()
  1498. .HasColumnType("nvarchar(max)");
  1499. b.Property<string>("UserIP")
  1500. .HasColumnType("nvarchar(max)");
  1501. b.Property<string>("userAgent")
  1502. .HasColumnType("nvarchar(max)");
  1503. b.HasKey("Id");
  1504. b.ToTable("RoleLogs");
  1505. });
  1506. modelBuilder.Entity("MTWorkHR.Core.Entities.SettingLog", b =>
  1507. {
  1508. b.Property<long>("Id")
  1509. .ValueGeneratedOnAdd()
  1510. .HasColumnType("bigint")
  1511. .HasColumnOrder(0);
  1512. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1513. b.Property<string>("Channel")
  1514. .HasColumnType("nvarchar(max)");
  1515. b.Property<DateTime>("CreateDate")
  1516. .HasColumnType("datetime2");
  1517. b.Property<string>("CreateUser")
  1518. .IsRequired()
  1519. .HasColumnType("nvarchar(max)");
  1520. b.Property<string>("ErrorCode")
  1521. .IsRequired()
  1522. .HasColumnType("nvarchar(max)");
  1523. b.Property<string>("ErrorDescription")
  1524. .IsRequired()
  1525. .HasColumnType("nvarchar(max)");
  1526. b.Property<string>("InnerException")
  1527. .HasColumnType("nvarchar(max)");
  1528. b.Property<string>("Input")
  1529. .HasColumnType("nvarchar(max)");
  1530. b.Property<string>("Method")
  1531. .IsRequired()
  1532. .HasColumnType("nvarchar(max)");
  1533. b.Property<string>("QueryString")
  1534. .HasColumnType("nvarchar(max)");
  1535. b.Property<string>("ServerIP")
  1536. .HasColumnType("nvarchar(max)");
  1537. b.Property<string>("ServiceResponseTimeInSeconds")
  1538. .IsRequired()
  1539. .HasColumnType("nvarchar(max)");
  1540. b.Property<string>("UserIP")
  1541. .HasColumnType("nvarchar(max)");
  1542. b.Property<string>("userAgent")
  1543. .HasColumnType("nvarchar(max)");
  1544. b.HasKey("Id");
  1545. b.ToTable("SettingLogs");
  1546. });
  1547. modelBuilder.Entity("MTWorkHR.Core.Entities.Team", b =>
  1548. {
  1549. b.Property<long>("Id")
  1550. .ValueGeneratedOnAdd()
  1551. .HasColumnType("bigint")
  1552. .HasColumnOrder(0);
  1553. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1554. b.Property<DateTime>("CreateDate")
  1555. .HasColumnType("datetime2")
  1556. .HasColumnOrder(3);
  1557. b.Property<string>("CreateUser")
  1558. .HasMaxLength(450)
  1559. .HasColumnType("nvarchar(450)")
  1560. .HasColumnOrder(1);
  1561. b.Property<string>("DeleteUserId")
  1562. .HasMaxLength(450)
  1563. .HasColumnType("nvarchar(450)")
  1564. .HasColumnOrder(8);
  1565. b.Property<bool>("IsDeleted")
  1566. .HasColumnType("bit")
  1567. .HasColumnOrder(7);
  1568. b.Property<string>("NameAr")
  1569. .IsRequired()
  1570. .HasMaxLength(250)
  1571. .HasColumnType("nvarchar(250)");
  1572. b.Property<string>("NameEn")
  1573. .IsRequired()
  1574. .HasMaxLength(250)
  1575. .HasColumnType("nvarchar(250)");
  1576. b.Property<DateTime?>("UpdateDate")
  1577. .HasColumnType("datetime2")
  1578. .HasColumnOrder(4);
  1579. b.Property<string>("UpdateUser")
  1580. .HasMaxLength(450)
  1581. .HasColumnType("nvarchar(450)")
  1582. .HasColumnOrder(2);
  1583. b.HasKey("Id");
  1584. b.ToTable("Teams");
  1585. });
  1586. modelBuilder.Entity("MTWorkHR.Core.Entities.TeamLog", b =>
  1587. {
  1588. b.Property<long>("Id")
  1589. .ValueGeneratedOnAdd()
  1590. .HasColumnType("bigint")
  1591. .HasColumnOrder(0);
  1592. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1593. b.Property<string>("Channel")
  1594. .HasColumnType("nvarchar(max)");
  1595. b.Property<DateTime>("CreateDate")
  1596. .HasColumnType("datetime2");
  1597. b.Property<string>("CreateUser")
  1598. .IsRequired()
  1599. .HasColumnType("nvarchar(max)");
  1600. b.Property<string>("ErrorCode")
  1601. .IsRequired()
  1602. .HasColumnType("nvarchar(max)");
  1603. b.Property<string>("ErrorDescription")
  1604. .IsRequired()
  1605. .HasColumnType("nvarchar(max)");
  1606. b.Property<string>("InnerException")
  1607. .HasColumnType("nvarchar(max)");
  1608. b.Property<string>("Input")
  1609. .HasColumnType("nvarchar(max)");
  1610. b.Property<string>("Method")
  1611. .IsRequired()
  1612. .HasColumnType("nvarchar(max)");
  1613. b.Property<string>("QueryString")
  1614. .HasColumnType("nvarchar(max)");
  1615. b.Property<string>("ServerIP")
  1616. .HasColumnType("nvarchar(max)");
  1617. b.Property<string>("ServiceResponseTimeInSeconds")
  1618. .IsRequired()
  1619. .HasColumnType("nvarchar(max)");
  1620. b.Property<string>("UserIP")
  1621. .HasColumnType("nvarchar(max)");
  1622. b.Property<string>("userAgent")
  1623. .HasColumnType("nvarchar(max)");
  1624. b.HasKey("Id");
  1625. b.ToTable("TeamLogs");
  1626. });
  1627. modelBuilder.Entity("MTWorkHR.Core.Entities.TeamUser", b =>
  1628. {
  1629. b.Property<long>("Id")
  1630. .ValueGeneratedOnAdd()
  1631. .HasColumnType("bigint")
  1632. .HasColumnOrder(0);
  1633. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1634. b.Property<string>("AssignedUserId")
  1635. .IsRequired()
  1636. .HasColumnType("nvarchar(max)");
  1637. b.Property<DateTime>("CreateDate")
  1638. .HasColumnType("datetime2")
  1639. .HasColumnOrder(3);
  1640. b.Property<string>("CreateUser")
  1641. .HasMaxLength(450)
  1642. .HasColumnType("nvarchar(450)")
  1643. .HasColumnOrder(1);
  1644. b.Property<bool>("IsAdmin")
  1645. .HasColumnType("bit");
  1646. b.Property<long>("TeamId")
  1647. .HasColumnType("bigint");
  1648. b.Property<DateTime?>("UpdateDate")
  1649. .HasColumnType("datetime2")
  1650. .HasColumnOrder(4);
  1651. b.Property<string>("UpdateUser")
  1652. .HasMaxLength(450)
  1653. .HasColumnType("nvarchar(450)")
  1654. .HasColumnOrder(2);
  1655. b.HasKey("Id");
  1656. b.HasIndex("TeamId");
  1657. b.ToTable("TeamUser");
  1658. });
  1659. modelBuilder.Entity("MTWorkHR.Core.Entities.University", b =>
  1660. {
  1661. b.Property<long>("Id")
  1662. .ValueGeneratedOnAdd()
  1663. .HasColumnType("bigint")
  1664. .HasColumnOrder(0);
  1665. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1666. b.Property<string>("NameAr")
  1667. .IsRequired()
  1668. .HasMaxLength(250)
  1669. .HasColumnType("nvarchar(250)");
  1670. b.Property<string>("NameEn")
  1671. .IsRequired()
  1672. .HasMaxLength(250)
  1673. .HasColumnType("nvarchar(250)");
  1674. b.HasKey("Id");
  1675. b.ToTable("Universities");
  1676. b.HasData(
  1677. new
  1678. {
  1679. Id = 1L,
  1680. NameAr = "جامعة الملك فهد",
  1681. NameEn = "Fahd Univ"
  1682. },
  1683. new
  1684. {
  1685. Id = 2L,
  1686. NameAr = "جامعة الرياض",
  1687. NameEn = "Riydh Univ"
  1688. },
  1689. new
  1690. {
  1691. Id = 3L,
  1692. NameAr = "جامعة جدة",
  1693. NameEn = "Geda Univ"
  1694. });
  1695. });
  1696. modelBuilder.Entity("MTWorkHR.Core.Entities.User.OrderRequest", b =>
  1697. {
  1698. b.Property<long>("Id")
  1699. .ValueGeneratedOnAdd()
  1700. .HasColumnType("bigint")
  1701. .HasColumnOrder(0);
  1702. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1703. b.Property<int?>("CityId")
  1704. .HasColumnType("int");
  1705. b.Property<int?>("CountryId")
  1706. .HasColumnType("int");
  1707. b.Property<DateTime>("CreateDate")
  1708. .HasColumnType("datetime2")
  1709. .HasColumnOrder(3);
  1710. b.Property<string>("CreateUser")
  1711. .HasMaxLength(450)
  1712. .HasColumnType("nvarchar(450)")
  1713. .HasColumnOrder(1);
  1714. b.Property<string>("DeleteUserId")
  1715. .HasMaxLength(450)
  1716. .HasColumnType("nvarchar(450)")
  1717. .HasColumnOrder(8);
  1718. b.Property<DateTime?>("EndDate")
  1719. .HasColumnType("datetime2");
  1720. b.Property<bool>("IsDeleted")
  1721. .HasColumnType("bit")
  1722. .HasColumnOrder(7);
  1723. b.Property<long?>("LeaveTypeId")
  1724. .HasColumnType("bigint");
  1725. b.Property<int?>("OrderStatus")
  1726. .HasColumnType("int");
  1727. b.Property<long>("OrderTypeId")
  1728. .HasColumnType("bigint");
  1729. b.Property<string>("RequestComments")
  1730. .HasColumnType("nvarchar(max)");
  1731. b.Property<string>("RequestingEmployeeId")
  1732. .IsRequired()
  1733. .HasColumnType("nvarchar(max)");
  1734. b.Property<DateTime>("StartDate")
  1735. .HasColumnType("datetime2");
  1736. b.Property<DateTime?>("UpdateDate")
  1737. .HasColumnType("datetime2")
  1738. .HasColumnOrder(4);
  1739. b.Property<string>("UpdateUser")
  1740. .HasMaxLength(450)
  1741. .HasColumnType("nvarchar(450)")
  1742. .HasColumnOrder(2);
  1743. b.HasKey("Id");
  1744. b.HasIndex("LeaveTypeId");
  1745. b.HasIndex("OrderTypeId");
  1746. b.ToTable("OrderRequests");
  1747. });
  1748. modelBuilder.Entity("MTWorkHR.Core.Entities.UserLog", b =>
  1749. {
  1750. b.Property<long>("Id")
  1751. .ValueGeneratedOnAdd()
  1752. .HasColumnType("bigint")
  1753. .HasColumnOrder(0);
  1754. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1755. b.Property<string>("Channel")
  1756. .HasColumnType("nvarchar(max)");
  1757. b.Property<DateTime>("CreateDate")
  1758. .HasColumnType("datetime2");
  1759. b.Property<string>("CreateUser")
  1760. .IsRequired()
  1761. .HasColumnType("nvarchar(max)");
  1762. b.Property<string>("ErrorCode")
  1763. .IsRequired()
  1764. .HasColumnType("nvarchar(max)");
  1765. b.Property<string>("ErrorDescription")
  1766. .IsRequired()
  1767. .HasColumnType("nvarchar(max)");
  1768. b.Property<string>("InnerException")
  1769. .HasColumnType("nvarchar(max)");
  1770. b.Property<string>("Input")
  1771. .HasColumnType("nvarchar(max)");
  1772. b.Property<string>("Method")
  1773. .IsRequired()
  1774. .HasColumnType("nvarchar(max)");
  1775. b.Property<string>("QueryString")
  1776. .HasColumnType("nvarchar(max)");
  1777. b.Property<string>("ServerIP")
  1778. .HasColumnType("nvarchar(max)");
  1779. b.Property<string>("ServiceResponseTimeInSeconds")
  1780. .IsRequired()
  1781. .HasColumnType("nvarchar(max)");
  1782. b.Property<string>("UserIP")
  1783. .HasColumnType("nvarchar(max)");
  1784. b.Property<string>("userAgent")
  1785. .HasColumnType("nvarchar(max)");
  1786. b.HasKey("Id");
  1787. b.ToTable("UserLogs");
  1788. });
  1789. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b =>
  1790. {
  1791. b.Property<long>("Id")
  1792. .ValueGeneratedOnAdd()
  1793. .HasColumnType("bigint")
  1794. .HasColumnOrder(0);
  1795. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1796. b.Property<long>("AssignedUserId")
  1797. .HasColumnType("bigint");
  1798. b.Property<DateTime>("CreateDate")
  1799. .HasColumnType("datetime2")
  1800. .HasColumnOrder(3);
  1801. b.Property<string>("CreateUser")
  1802. .HasMaxLength(450)
  1803. .HasColumnType("nvarchar(450)")
  1804. .HasColumnOrder(1);
  1805. b.Property<string>("DeleteUserId")
  1806. .HasMaxLength(450)
  1807. .HasColumnType("nvarchar(450)")
  1808. .HasColumnOrder(8);
  1809. b.Property<string>("Description")
  1810. .IsRequired()
  1811. .HasColumnType("nvarchar(max)");
  1812. b.Property<DateTime>("DueDate")
  1813. .HasColumnType("datetime2");
  1814. b.Property<bool>("IsDeleted")
  1815. .HasColumnType("bit")
  1816. .HasColumnOrder(7);
  1817. b.Property<int>("Priority")
  1818. .HasColumnType("int");
  1819. b.Property<long>("ProjectId")
  1820. .HasColumnType("bigint");
  1821. b.Property<long>("StatusId")
  1822. .HasColumnType("bigint");
  1823. b.Property<string>("Title")
  1824. .IsRequired()
  1825. .HasColumnType("nvarchar(max)");
  1826. b.Property<DateTime?>("UpdateDate")
  1827. .HasColumnType("datetime2")
  1828. .HasColumnOrder(4);
  1829. b.Property<string>("UpdateUser")
  1830. .HasMaxLength(450)
  1831. .HasColumnType("nvarchar(450)")
  1832. .HasColumnOrder(2);
  1833. b.HasKey("Id");
  1834. b.HasIndex("ProjectId");
  1835. b.HasIndex("StatusId");
  1836. b.ToTable("UserTasks");
  1837. });
  1838. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskAttachment", b =>
  1839. {
  1840. b.Property<long>("Id")
  1841. .ValueGeneratedOnAdd()
  1842. .HasColumnType("bigint")
  1843. .HasColumnOrder(0);
  1844. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1845. b.Property<long?>("AttachmentTypeId")
  1846. .HasColumnType("bigint");
  1847. b.Property<DateTime>("CreateDate")
  1848. .HasColumnType("datetime2")
  1849. .HasColumnOrder(3);
  1850. b.Property<string>("CreateUser")
  1851. .HasMaxLength(450)
  1852. .HasColumnType("nvarchar(450)")
  1853. .HasColumnOrder(1);
  1854. b.Property<string>("FileName")
  1855. .HasMaxLength(250)
  1856. .HasColumnType("nvarchar(250)");
  1857. b.Property<string>("OriginalName")
  1858. .HasMaxLength(250)
  1859. .HasColumnType("nvarchar(250)");
  1860. b.Property<long>("TaskId")
  1861. .HasColumnType("bigint");
  1862. b.Property<DateTime?>("UpdateDate")
  1863. .HasColumnType("datetime2")
  1864. .HasColumnOrder(4);
  1865. b.Property<string>("UpdateUser")
  1866. .HasMaxLength(450)
  1867. .HasColumnType("nvarchar(450)")
  1868. .HasColumnOrder(2);
  1869. b.HasKey("Id");
  1870. b.HasIndex("AttachmentTypeId");
  1871. b.HasIndex("TaskId");
  1872. b.ToTable("UserTaskAttachments");
  1873. });
  1874. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskHistory", b =>
  1875. {
  1876. b.Property<long>("Id")
  1877. .ValueGeneratedOnAdd()
  1878. .HasColumnType("bigint")
  1879. .HasColumnOrder(0);
  1880. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1881. b.Property<long>("AssignedToUserId")
  1882. .HasColumnType("bigint");
  1883. b.Property<string>("Comment")
  1884. .HasMaxLength(500)
  1885. .HasColumnType("nvarchar(500)");
  1886. b.Property<DateTime>("CreateDate")
  1887. .HasColumnType("datetime2")
  1888. .HasColumnOrder(3);
  1889. b.Property<string>("CreateUser")
  1890. .HasMaxLength(450)
  1891. .HasColumnType("nvarchar(450)")
  1892. .HasColumnOrder(1);
  1893. b.Property<long>("CurrentStatusId")
  1894. .HasColumnType("bigint");
  1895. b.Property<bool>("IsDeleted")
  1896. .HasColumnType("bit");
  1897. b.Property<long>("TaskId")
  1898. .HasColumnType("bigint");
  1899. b.Property<DateTime?>("UpdateDate")
  1900. .HasColumnType("datetime2")
  1901. .HasColumnOrder(4);
  1902. b.Property<string>("UpdateUser")
  1903. .HasMaxLength(450)
  1904. .HasColumnType("nvarchar(450)")
  1905. .HasColumnOrder(2);
  1906. b.Property<long?>("UserTaskId")
  1907. .HasColumnType("bigint");
  1908. b.HasKey("Id");
  1909. b.HasIndex("CurrentStatusId");
  1910. b.HasIndex("UserTaskId");
  1911. b.ToTable("UserTaskHistories");
  1912. });
  1913. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskLog", b =>
  1914. {
  1915. b.Property<long>("Id")
  1916. .ValueGeneratedOnAdd()
  1917. .HasColumnType("bigint")
  1918. .HasColumnOrder(0);
  1919. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1920. b.Property<string>("Channel")
  1921. .HasColumnType("nvarchar(max)");
  1922. b.Property<DateTime>("CreateDate")
  1923. .HasColumnType("datetime2");
  1924. b.Property<string>("CreateUser")
  1925. .IsRequired()
  1926. .HasColumnType("nvarchar(max)");
  1927. b.Property<string>("ErrorCode")
  1928. .IsRequired()
  1929. .HasColumnType("nvarchar(max)");
  1930. b.Property<string>("ErrorDescription")
  1931. .IsRequired()
  1932. .HasColumnType("nvarchar(max)");
  1933. b.Property<string>("InnerException")
  1934. .HasColumnType("nvarchar(max)");
  1935. b.Property<string>("Input")
  1936. .HasColumnType("nvarchar(max)");
  1937. b.Property<string>("Method")
  1938. .IsRequired()
  1939. .HasColumnType("nvarchar(max)");
  1940. b.Property<string>("QueryString")
  1941. .HasColumnType("nvarchar(max)");
  1942. b.Property<string>("ServerIP")
  1943. .HasColumnType("nvarchar(max)");
  1944. b.Property<string>("ServiceResponseTimeInSeconds")
  1945. .IsRequired()
  1946. .HasColumnType("nvarchar(max)");
  1947. b.Property<string>("UserIP")
  1948. .HasColumnType("nvarchar(max)");
  1949. b.Property<string>("userAgent")
  1950. .HasColumnType("nvarchar(max)");
  1951. b.HasKey("Id");
  1952. b.ToTable("UserTaskLogs");
  1953. });
  1954. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskStatus", b =>
  1955. {
  1956. b.Property<long>("Id")
  1957. .ValueGeneratedOnAdd()
  1958. .HasColumnType("bigint")
  1959. .HasColumnOrder(0);
  1960. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  1961. b.Property<string>("NameAr")
  1962. .IsRequired()
  1963. .HasMaxLength(250)
  1964. .HasColumnType("nvarchar(250)");
  1965. b.Property<string>("NameEn")
  1966. .IsRequired()
  1967. .HasMaxLength(250)
  1968. .HasColumnType("nvarchar(250)");
  1969. b.HasKey("Id");
  1970. b.ToTable("UserTaskStatuses");
  1971. b.HasData(
  1972. new
  1973. {
  1974. Id = 1L,
  1975. NameAr = "جديدة",
  1976. NameEn = "New"
  1977. },
  1978. new
  1979. {
  1980. Id = 2L,
  1981. NameAr = "قيد العمل",
  1982. NameEn = "Under progress"
  1983. },
  1984. new
  1985. {
  1986. Id = 3L,
  1987. NameAr = "أغلقت",
  1988. NameEn = "Closed"
  1989. },
  1990. new
  1991. {
  1992. Id = 4L,
  1993. NameAr = "تمت",
  1994. NameEn = "Completed"
  1995. },
  1996. new
  1997. {
  1998. Id = 5L,
  1999. NameAr = "مؤجلة",
  2000. NameEn = "Delayed"
  2001. });
  2002. });
  2003. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationRole", b =>
  2004. {
  2005. b.Property<string>("Id")
  2006. .HasColumnType("nvarchar(450)");
  2007. b.Property<string>("ConcurrencyStamp")
  2008. .IsConcurrencyToken()
  2009. .HasColumnType("nvarchar(max)");
  2010. b.Property<DateTime>("CreateDate")
  2011. .HasColumnType("datetime2");
  2012. b.Property<string>("CreateUser")
  2013. .HasColumnType("nvarchar(max)");
  2014. b.Property<string>("DeleteUserId")
  2015. .HasColumnType("nvarchar(max)");
  2016. b.Property<bool?>("IsAdmin")
  2017. .HasColumnType("bit");
  2018. b.Property<bool>("IsDeleted")
  2019. .HasColumnType("bit");
  2020. b.Property<string>("Name")
  2021. .HasMaxLength(256)
  2022. .HasColumnType("nvarchar(256)");
  2023. b.Property<string>("NormalizedName")
  2024. .HasMaxLength(256)
  2025. .HasColumnType("nvarchar(256)");
  2026. b.Property<DateTime?>("UpdateDate")
  2027. .HasColumnType("datetime2");
  2028. b.Property<string>("UpdateUser")
  2029. .HasColumnType("nvarchar(max)");
  2030. b.HasKey("Id");
  2031. b.HasIndex("NormalizedName")
  2032. .IsUnique()
  2033. .HasDatabaseName("RoleNameIndex")
  2034. .HasFilter("[NormalizedName] IS NOT NULL");
  2035. b.ToTable("AspNetRoles", (string)null);
  2036. b.HasData(
  2037. new
  2038. {
  2039. Id = "AD5B3B92-2311-48F8-9DEC-F9FAEF1F211A",
  2040. CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
  2041. IsAdmin = true,
  2042. IsDeleted = false,
  2043. Name = "Admin",
  2044. NormalizedName = "ADMIN"
  2045. },
  2046. new
  2047. {
  2048. Id = "EM5B3B92-2311-48F8-9DEC-F9FAEF1F211E",
  2049. CreateDate = new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified),
  2050. IsAdmin = false,
  2051. IsDeleted = false,
  2052. Name = "Employee",
  2053. NormalizedName = "EMPLOYEE"
  2054. });
  2055. });
  2056. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b =>
  2057. {
  2058. b.Property<string>("Id")
  2059. .HasColumnType("nvarchar(450)");
  2060. b.Property<int>("AccessFailedCount")
  2061. .HasColumnType("int");
  2062. b.Property<long?>("CompanyId")
  2063. .HasColumnType("bigint");
  2064. b.Property<string>("ConcurrencyStamp")
  2065. .IsConcurrencyToken()
  2066. .HasColumnType("nvarchar(max)");
  2067. b.Property<long?>("CountryId")
  2068. .HasColumnType("bigint");
  2069. b.Property<string>("CreateUser")
  2070. .HasColumnType("nvarchar(max)");
  2071. b.Property<DateTime>("DateOfBirth")
  2072. .HasColumnType("datetime2");
  2073. b.Property<string>("DeleteUserId")
  2074. .HasColumnType("nvarchar(max)");
  2075. b.Property<string>("Email")
  2076. .HasMaxLength(256)
  2077. .HasColumnType("nvarchar(256)");
  2078. b.Property<bool>("EmailConfirmed")
  2079. .HasColumnType("bit");
  2080. b.Property<string>("FavoriteName")
  2081. .HasColumnType("nvarchar(max)");
  2082. b.Property<string>("FirstName")
  2083. .IsRequired()
  2084. .HasColumnType("nvarchar(max)");
  2085. b.Property<string>("IdNumber")
  2086. .IsRequired()
  2087. .HasColumnType("nvarchar(max)");
  2088. b.Property<decimal?>("IncomeTaxValue")
  2089. .HasColumnType("decimal(18,2)");
  2090. b.Property<long?>("IndustryId")
  2091. .HasColumnType("bigint");
  2092. b.Property<bool>("IsDeleted")
  2093. .HasColumnType("bit");
  2094. b.Property<bool>("IsStopped")
  2095. .HasColumnType("bit");
  2096. b.Property<long?>("JobTitleId")
  2097. .HasColumnType("bigint");
  2098. b.Property<string>("LastName")
  2099. .IsRequired()
  2100. .HasColumnType("nvarchar(max)");
  2101. b.Property<string>("LinkedInLink")
  2102. .HasColumnType("nvarchar(max)");
  2103. b.Property<bool>("LockoutEnabled")
  2104. .HasColumnType("bit");
  2105. b.Property<DateTimeOffset?>("LockoutEnd")
  2106. .HasColumnType("datetimeoffset");
  2107. b.Property<string>("ManagerId")
  2108. .HasColumnType("nvarchar(450)");
  2109. b.Property<string>("NormalizedEmail")
  2110. .HasMaxLength(256)
  2111. .HasColumnType("nvarchar(256)");
  2112. b.Property<string>("NormalizedUserName")
  2113. .HasMaxLength(256)
  2114. .HasColumnType("nvarchar(256)");
  2115. b.Property<string>("PassportNumber")
  2116. .IsRequired()
  2117. .HasColumnType("nvarchar(max)");
  2118. b.Property<string>("PasswordHash")
  2119. .HasColumnType("nvarchar(max)");
  2120. b.Property<string>("PhoneNumber")
  2121. .HasColumnType("nvarchar(max)");
  2122. b.Property<bool>("PhoneNumberConfirmed")
  2123. .HasColumnType("bit");
  2124. b.Property<long?>("QualificationId")
  2125. .HasColumnType("bigint");
  2126. b.Property<string>("SecurityStamp")
  2127. .HasColumnType("nvarchar(max)");
  2128. b.Property<decimal?>("TaxNumber")
  2129. .HasColumnType("decimal(18,2)");
  2130. b.Property<bool>("TwoFactorEnabled")
  2131. .HasColumnType("bit");
  2132. b.Property<long?>("UniversityId")
  2133. .HasColumnType("bigint");
  2134. b.Property<string>("UpdateUser")
  2135. .HasColumnType("nvarchar(max)");
  2136. b.Property<string>("UserName")
  2137. .HasMaxLength(256)
  2138. .HasColumnType("nvarchar(256)");
  2139. b.Property<int>("UserType")
  2140. .HasColumnType("int");
  2141. b.HasKey("Id");
  2142. b.HasIndex("CountryId");
  2143. b.HasIndex("IndustryId");
  2144. b.HasIndex("JobTitleId");
  2145. b.HasIndex("ManagerId");
  2146. b.HasIndex("NormalizedEmail")
  2147. .HasDatabaseName("EmailIndex");
  2148. b.HasIndex("NormalizedUserName")
  2149. .IsUnique()
  2150. .HasDatabaseName("UserNameIndex")
  2151. .HasFilter("[NormalizedUserName] IS NOT NULL");
  2152. b.HasIndex("QualificationId");
  2153. b.HasIndex("UniversityId");
  2154. b.ToTable("AspNetUsers", (string)null);
  2155. b.HasData(
  2156. new
  2157. {
  2158. Id = "ADMB3B92-2311-48F8-9DEC-F9FAEF1F21UA",
  2159. AccessFailedCount = 0,
  2160. ConcurrencyStamp = "7cc87689-9eab-4280-b8e3-1834080783a5",
  2161. DateOfBirth = new DateTime(2000, 2, 10, 0, 0, 0, 0, DateTimeKind.Unspecified),
  2162. Email = "a@b.com",
  2163. EmailConfirmed = true,
  2164. FirstName = "Zinab",
  2165. IdNumber = "123",
  2166. IncomeTaxValue = 1m,
  2167. IsDeleted = false,
  2168. IsStopped = false,
  2169. LastName = "Elgendy",
  2170. LockoutEnabled = false,
  2171. NormalizedEmail = "A@B.COM",
  2172. NormalizedUserName = "ADMIN",
  2173. PassportNumber = "1234567",
  2174. PasswordHash = "AQAAAAIAAYagAAAAEPg+ASbciPFxtyxQq8Wx5ilBUQ0RbAoITXXkOQm1PzC5BzySX0sn/wUmOjBKPDGV9w==",
  2175. PhoneNumber = "1234567890",
  2176. PhoneNumberConfirmed = true,
  2177. SecurityStamp = "49bb16c3-4704-4c60-908d-dc8506950acc",
  2178. TaxNumber = 111m,
  2179. TwoFactorEnabled = false,
  2180. UserName = "Admin",
  2181. UserType = 1
  2182. },
  2183. new
  2184. {
  2185. Id = "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB",
  2186. AccessFailedCount = 0,
  2187. ConcurrencyStamp = "4af7b4cf-802a-455b-b598-997e167745b3",
  2188. DateOfBirth = new DateTime(2001, 5, 13, 0, 0, 0, 0, DateTimeKind.Unspecified),
  2189. Email = "ali@b.com",
  2190. EmailConfirmed = true,
  2191. FirstName = "Ali",
  2192. IdNumber = "343434",
  2193. IncomeTaxValue = 100m,
  2194. IsDeleted = false,
  2195. IsStopped = false,
  2196. LastName = "Farok",
  2197. LockoutEnabled = false,
  2198. NormalizedEmail = "ALI@B.COM",
  2199. NormalizedUserName = "ALI",
  2200. PassportNumber = "7654321001010",
  2201. PasswordHash = "AQAAAAIAAYagAAAAEI3QJkcZjCH4Y8Db4rEgL8Mmll5oCvYcWiXZjQSN9bGW4SMcjHe3ZPMnkN/l9DmJeQ==",
  2202. PhoneNumber = "1234567888",
  2203. PhoneNumberConfirmed = true,
  2204. SecurityStamp = "62549056-1b9d-46d4-84f8-adea3e4d8b68",
  2205. TaxNumber = 222m,
  2206. TwoFactorEnabled = false,
  2207. UserName = "ali",
  2208. UserType = 1
  2209. });
  2210. });
  2211. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.RolePermission", b =>
  2212. {
  2213. b.Property<long>("Id")
  2214. .ValueGeneratedOnAdd()
  2215. .HasColumnType("bigint")
  2216. .HasColumnOrder(0);
  2217. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  2218. b.Property<long>("PermissionId")
  2219. .HasColumnType("bigint");
  2220. b.Property<string>("PermissionName")
  2221. .IsRequired()
  2222. .HasColumnType("nvarchar(max)");
  2223. b.Property<string>("RoleId")
  2224. .IsRequired()
  2225. .HasColumnType("nvarchar(450)");
  2226. b.HasKey("Id");
  2227. b.HasIndex("PermissionId");
  2228. b.HasIndex("RoleId");
  2229. b.ToTable("RolePermissions");
  2230. });
  2231. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAddress", b =>
  2232. {
  2233. b.Property<long>("Id")
  2234. .ValueGeneratedOnAdd()
  2235. .HasColumnType("bigint")
  2236. .HasColumnOrder(0);
  2237. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  2238. b.Property<string>("AddressDesc")
  2239. .HasColumnType("nvarchar(max)");
  2240. b.Property<string>("City")
  2241. .HasColumnType("nvarchar(max)");
  2242. b.Property<int?>("CountryId")
  2243. .HasColumnType("int");
  2244. b.Property<DateTime>("CreateDate")
  2245. .HasColumnType("datetime2")
  2246. .HasColumnOrder(3);
  2247. b.Property<string>("CreateUser")
  2248. .HasMaxLength(450)
  2249. .HasColumnType("nvarchar(450)")
  2250. .HasColumnOrder(1);
  2251. b.Property<string>("PostalCode")
  2252. .HasColumnType("nvarchar(max)");
  2253. b.Property<DateTime?>("UpdateDate")
  2254. .HasColumnType("datetime2")
  2255. .HasColumnOrder(4);
  2256. b.Property<string>("UpdateUser")
  2257. .HasMaxLength(450)
  2258. .HasColumnType("nvarchar(450)")
  2259. .HasColumnOrder(2);
  2260. b.Property<string>("UserId")
  2261. .IsRequired()
  2262. .HasColumnType("nvarchar(450)");
  2263. b.HasKey("Id");
  2264. b.HasIndex("UserId")
  2265. .IsUnique();
  2266. b.ToTable("UserAddress");
  2267. });
  2268. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAttachment", b =>
  2269. {
  2270. b.Property<long>("Id")
  2271. .ValueGeneratedOnAdd()
  2272. .HasColumnType("bigint")
  2273. .HasColumnOrder(0);
  2274. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<long>("Id"));
  2275. b.Property<long>("AttachmentTypeId")
  2276. .HasColumnType("bigint");
  2277. b.Property<DateTime>("CreateDate")
  2278. .HasColumnType("datetime2")
  2279. .HasColumnOrder(3);
  2280. b.Property<string>("CreateUser")
  2281. .HasMaxLength(450)
  2282. .HasColumnType("nvarchar(450)")
  2283. .HasColumnOrder(1);
  2284. b.Property<string>("FileName")
  2285. .IsRequired()
  2286. .HasMaxLength(250)
  2287. .HasColumnType("nvarchar(250)");
  2288. b.Property<string>("OriginalName")
  2289. .IsRequired()
  2290. .HasMaxLength(250)
  2291. .HasColumnType("nvarchar(250)");
  2292. b.Property<DateTime?>("UpdateDate")
  2293. .HasColumnType("datetime2")
  2294. .HasColumnOrder(4);
  2295. b.Property<string>("UpdateUser")
  2296. .HasMaxLength(450)
  2297. .HasColumnType("nvarchar(450)")
  2298. .HasColumnOrder(2);
  2299. b.Property<string>("UserId")
  2300. .IsRequired()
  2301. .HasColumnType("nvarchar(450)");
  2302. b.HasKey("Id");
  2303. b.HasIndex("AttachmentTypeId");
  2304. b.HasIndex("UserId");
  2305. b.ToTable("UserAttachments");
  2306. });
  2307. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
  2308. {
  2309. b.Property<int>("Id")
  2310. .ValueGeneratedOnAdd()
  2311. .HasColumnType("int");
  2312. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  2313. b.Property<string>("ClaimType")
  2314. .HasColumnType("nvarchar(max)");
  2315. b.Property<string>("ClaimValue")
  2316. .HasColumnType("nvarchar(max)");
  2317. b.Property<string>("RoleId")
  2318. .IsRequired()
  2319. .HasColumnType("nvarchar(450)");
  2320. b.HasKey("Id");
  2321. b.HasIndex("RoleId");
  2322. b.ToTable("AspNetRoleClaims", (string)null);
  2323. });
  2324. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
  2325. {
  2326. b.Property<int>("Id")
  2327. .ValueGeneratedOnAdd()
  2328. .HasColumnType("int");
  2329. SqlServerPropertyBuilderExtensions.UseIdentityColumn(b.Property<int>("Id"));
  2330. b.Property<string>("ClaimType")
  2331. .HasColumnType("nvarchar(max)");
  2332. b.Property<string>("ClaimValue")
  2333. .HasColumnType("nvarchar(max)");
  2334. b.Property<string>("UserId")
  2335. .IsRequired()
  2336. .HasColumnType("nvarchar(450)");
  2337. b.HasKey("Id");
  2338. b.HasIndex("UserId");
  2339. b.ToTable("AspNetUserClaims", (string)null);
  2340. });
  2341. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
  2342. {
  2343. b.Property<string>("LoginProvider")
  2344. .HasColumnType("nvarchar(450)");
  2345. b.Property<string>("ProviderKey")
  2346. .HasColumnType("nvarchar(450)");
  2347. b.Property<string>("ProviderDisplayName")
  2348. .HasColumnType("nvarchar(max)");
  2349. b.Property<string>("UserId")
  2350. .IsRequired()
  2351. .HasColumnType("nvarchar(450)");
  2352. b.HasKey("LoginProvider", "ProviderKey");
  2353. b.HasIndex("UserId");
  2354. b.ToTable("AspNetUserLogins", (string)null);
  2355. });
  2356. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
  2357. {
  2358. b.Property<string>("UserId")
  2359. .HasColumnType("nvarchar(450)");
  2360. b.Property<string>("RoleId")
  2361. .HasColumnType("nvarchar(450)");
  2362. b.HasKey("UserId", "RoleId");
  2363. b.HasIndex("RoleId");
  2364. b.ToTable("AspNetUserRoles", (string)null);
  2365. b.HasData(
  2366. new
  2367. {
  2368. UserId = "ADMB3B92-2311-48F8-9DEC-F9FAEF1F21UA",
  2369. RoleId = "AD5B3B92-2311-48F8-9DEC-F9FAEF1F211A"
  2370. },
  2371. new
  2372. {
  2373. UserId = "AL5B3B92-2311-48F8-9DEC-F9FAEF1F21UB",
  2374. RoleId = "EM5B3B92-2311-48F8-9DEC-F9FAEF1F211E"
  2375. });
  2376. });
  2377. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
  2378. {
  2379. b.Property<string>("UserId")
  2380. .HasColumnType("nvarchar(450)");
  2381. b.Property<string>("LoginProvider")
  2382. .HasColumnType("nvarchar(450)");
  2383. b.Property<string>("Name")
  2384. .HasColumnType("nvarchar(450)");
  2385. b.Property<string>("Value")
  2386. .HasColumnType("nvarchar(max)");
  2387. b.HasKey("UserId", "LoginProvider", "Name");
  2388. b.ToTable("AspNetUserTokens", (string)null);
  2389. });
  2390. modelBuilder.Entity("ApplicationRoleApplicationUser", b =>
  2391. {
  2392. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null)
  2393. .WithMany()
  2394. .HasForeignKey("UserRolesId")
  2395. .OnDelete(DeleteBehavior.Cascade)
  2396. .IsRequired();
  2397. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
  2398. .WithMany()
  2399. .HasForeignKey("UsersId")
  2400. .OnDelete(DeleteBehavior.Cascade)
  2401. .IsRequired();
  2402. });
  2403. modelBuilder.Entity("MTWorkHR.Core.Entities.City", b =>
  2404. {
  2405. b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country")
  2406. .WithMany()
  2407. .HasForeignKey("CountryId")
  2408. .OnDelete(DeleteBehavior.Cascade)
  2409. .IsRequired();
  2410. b.Navigation("Country");
  2411. });
  2412. modelBuilder.Entity("MTWorkHR.Core.Entities.MeetingUser", b =>
  2413. {
  2414. b.HasOne("MTWorkHR.Core.Entities.Meeting", "Meeting")
  2415. .WithMany("MeetingUsers")
  2416. .HasForeignKey("MeetingId")
  2417. .OnDelete(DeleteBehavior.Cascade)
  2418. .IsRequired();
  2419. b.Navigation("Meeting");
  2420. });
  2421. modelBuilder.Entity("MTWorkHR.Core.Entities.OrderAllocation", b =>
  2422. {
  2423. b.HasOne("MTWorkHR.Core.Entities.LeaveType", "LeaveType")
  2424. .WithMany()
  2425. .HasForeignKey("LeaveTypeId");
  2426. b.HasOne("MTWorkHR.Core.Entities.OrderType", "OrderType")
  2427. .WithMany()
  2428. .HasForeignKey("OrderTypeId")
  2429. .OnDelete(DeleteBehavior.Cascade)
  2430. .IsRequired();
  2431. b.Navigation("LeaveType");
  2432. b.Navigation("OrderType");
  2433. });
  2434. modelBuilder.Entity("MTWorkHR.Core.Entities.TeamUser", b =>
  2435. {
  2436. b.HasOne("MTWorkHR.Core.Entities.Team", "Team")
  2437. .WithMany("TeamUsers")
  2438. .HasForeignKey("TeamId")
  2439. .OnDelete(DeleteBehavior.Cascade)
  2440. .IsRequired();
  2441. b.Navigation("Team");
  2442. });
  2443. modelBuilder.Entity("MTWorkHR.Core.Entities.User.OrderRequest", b =>
  2444. {
  2445. b.HasOne("MTWorkHR.Core.Entities.LeaveType", "LeaveType")
  2446. .WithMany()
  2447. .HasForeignKey("LeaveTypeId");
  2448. b.HasOne("MTWorkHR.Core.Entities.OrderType", "OrderType")
  2449. .WithMany()
  2450. .HasForeignKey("OrderTypeId")
  2451. .OnDelete(DeleteBehavior.Cascade)
  2452. .IsRequired();
  2453. b.Navigation("LeaveType");
  2454. b.Navigation("OrderType");
  2455. });
  2456. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b =>
  2457. {
  2458. b.HasOne("MTWorkHR.Core.Entities.Project", "Project")
  2459. .WithMany()
  2460. .HasForeignKey("ProjectId")
  2461. .OnDelete(DeleteBehavior.Cascade)
  2462. .IsRequired();
  2463. b.HasOne("MTWorkHR.Core.Entities.UserTaskStatus", "TaskStatus")
  2464. .WithMany()
  2465. .HasForeignKey("StatusId")
  2466. .OnDelete(DeleteBehavior.Cascade)
  2467. .IsRequired();
  2468. b.Navigation("Project");
  2469. b.Navigation("TaskStatus");
  2470. });
  2471. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskAttachment", b =>
  2472. {
  2473. b.HasOne("MTWorkHR.Core.Entities.Base.AttachmentType", "AttachmentType")
  2474. .WithMany()
  2475. .HasForeignKey("AttachmentTypeId");
  2476. b.HasOne("MTWorkHR.Core.Entities.UserTask", "UserTask")
  2477. .WithMany("TaskAttachments")
  2478. .HasForeignKey("TaskId")
  2479. .OnDelete(DeleteBehavior.Cascade)
  2480. .IsRequired();
  2481. b.Navigation("AttachmentType");
  2482. b.Navigation("UserTask");
  2483. });
  2484. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTaskHistory", b =>
  2485. {
  2486. b.HasOne("MTWorkHR.Core.Entities.UserTaskStatus", "TaskStatus")
  2487. .WithMany()
  2488. .HasForeignKey("CurrentStatusId")
  2489. .OnDelete(DeleteBehavior.Cascade)
  2490. .IsRequired();
  2491. b.HasOne("MTWorkHR.Core.Entities.UserTask", null)
  2492. .WithMany("UserTaskHistories")
  2493. .HasForeignKey("UserTaskId");
  2494. b.Navigation("TaskStatus");
  2495. });
  2496. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b =>
  2497. {
  2498. b.HasOne("MTWorkHR.Core.Entities.CountryLookup", "Country")
  2499. .WithMany()
  2500. .HasForeignKey("CountryId");
  2501. b.HasOne("MTWorkHR.Core.Entities.Industry", "Industry")
  2502. .WithMany()
  2503. .HasForeignKey("IndustryId");
  2504. b.HasOne("MTWorkHR.Core.Entities.JobTitle", "JobTitle")
  2505. .WithMany()
  2506. .HasForeignKey("JobTitleId");
  2507. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", "Manager")
  2508. .WithMany()
  2509. .HasForeignKey("ManagerId");
  2510. b.HasOne("MTWorkHR.Core.Entities.Qualification", "Qualification")
  2511. .WithMany()
  2512. .HasForeignKey("QualificationId");
  2513. b.HasOne("MTWorkHR.Core.Entities.University", "University")
  2514. .WithMany()
  2515. .HasForeignKey("UniversityId");
  2516. b.Navigation("Country");
  2517. b.Navigation("Industry");
  2518. b.Navigation("JobTitle");
  2519. b.Navigation("Manager");
  2520. b.Navigation("Qualification");
  2521. b.Navigation("University");
  2522. });
  2523. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.RolePermission", b =>
  2524. {
  2525. b.HasOne("MTWorkHR.Core.Entities.Permission", "Permission")
  2526. .WithMany()
  2527. .HasForeignKey("PermissionId")
  2528. .OnDelete(DeleteBehavior.Cascade)
  2529. .IsRequired();
  2530. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", "Role")
  2531. .WithMany("RolePermissions")
  2532. .HasForeignKey("RoleId")
  2533. .OnDelete(DeleteBehavior.Cascade)
  2534. .IsRequired();
  2535. b.Navigation("Permission");
  2536. b.Navigation("Role");
  2537. });
  2538. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAddress", b =>
  2539. {
  2540. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", "User")
  2541. .WithOne("UserAddress")
  2542. .HasForeignKey("MTWorkHR.Infrastructure.Entities.UserAddress", "UserId")
  2543. .OnDelete(DeleteBehavior.Cascade)
  2544. .IsRequired();
  2545. b.Navigation("User");
  2546. });
  2547. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.UserAttachment", b =>
  2548. {
  2549. b.HasOne("MTWorkHR.Core.Entities.Base.AttachmentType", "AttachmentType")
  2550. .WithMany()
  2551. .HasForeignKey("AttachmentTypeId")
  2552. .OnDelete(DeleteBehavior.Cascade)
  2553. .IsRequired();
  2554. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", "User")
  2555. .WithMany("UserAttachments")
  2556. .HasForeignKey("UserId")
  2557. .OnDelete(DeleteBehavior.Cascade)
  2558. .IsRequired();
  2559. b.Navigation("AttachmentType");
  2560. b.Navigation("User");
  2561. });
  2562. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityRoleClaim<string>", b =>
  2563. {
  2564. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null)
  2565. .WithMany()
  2566. .HasForeignKey("RoleId")
  2567. .OnDelete(DeleteBehavior.Cascade)
  2568. .IsRequired();
  2569. });
  2570. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserClaim<string>", b =>
  2571. {
  2572. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
  2573. .WithMany()
  2574. .HasForeignKey("UserId")
  2575. .OnDelete(DeleteBehavior.Cascade)
  2576. .IsRequired();
  2577. });
  2578. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserLogin<string>", b =>
  2579. {
  2580. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
  2581. .WithMany()
  2582. .HasForeignKey("UserId")
  2583. .OnDelete(DeleteBehavior.Cascade)
  2584. .IsRequired();
  2585. });
  2586. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserRole<string>", b =>
  2587. {
  2588. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationRole", null)
  2589. .WithMany()
  2590. .HasForeignKey("RoleId")
  2591. .OnDelete(DeleteBehavior.Cascade)
  2592. .IsRequired();
  2593. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
  2594. .WithMany()
  2595. .HasForeignKey("UserId")
  2596. .OnDelete(DeleteBehavior.Cascade)
  2597. .IsRequired();
  2598. });
  2599. modelBuilder.Entity("Microsoft.AspNetCore.Identity.IdentityUserToken<string>", b =>
  2600. {
  2601. b.HasOne("MTWorkHR.Infrastructure.Entities.ApplicationUser", null)
  2602. .WithMany()
  2603. .HasForeignKey("UserId")
  2604. .OnDelete(DeleteBehavior.Cascade)
  2605. .IsRequired();
  2606. });
  2607. modelBuilder.Entity("MTWorkHR.Core.Entities.Meeting", b =>
  2608. {
  2609. b.Navigation("MeetingUsers");
  2610. });
  2611. modelBuilder.Entity("MTWorkHR.Core.Entities.Team", b =>
  2612. {
  2613. b.Navigation("TeamUsers");
  2614. });
  2615. modelBuilder.Entity("MTWorkHR.Core.Entities.UserTask", b =>
  2616. {
  2617. b.Navigation("TaskAttachments");
  2618. b.Navigation("UserTaskHistories");
  2619. });
  2620. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationRole", b =>
  2621. {
  2622. b.Navigation("RolePermissions");
  2623. });
  2624. modelBuilder.Entity("MTWorkHR.Infrastructure.Entities.ApplicationUser", b =>
  2625. {
  2626. b.Navigation("UserAddress")
  2627. .IsRequired();
  2628. b.Navigation("UserAttachments");
  2629. });
  2630. #pragma warning restore 612, 618
  2631. }
  2632. }
  2633. }