20240520183928_altrcity.Designer.cs 110 KB

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