FMSContext.cs 191 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675367636773678367936803681368236833684368536863687368836893690369136923693369436953696369736983699370037013702370337043705370637073708370937103711371237133714371537163717371837193720372137223723372437253726372737283729373037313732373337343735373637373738373937403741374237433744374537463747374837493750375137523753375437553756375737583759376037613762376337643765376637673768376937703771377237733774377537763777377837793780378137823783378437853786378737883789379037913792379337943795379637973798379938003801380238033804380538063807380838093810381138123813381438153816381738183819382038213822382338243825382638273828382938303831383238333834383538363837383838393840384138423843384438453846384738483849385038513852385338543855385638573858385938603861386238633864386538663867386838693870387138723873387438753876387738783879388038813882388338843885388638873888
  1. using System;
  2. using System.Linq;
  3. using Microsoft.EntityFrameworkCore;
  4. using Microsoft.EntityFrameworkCore.Metadata;
  5. using FMSAdmin.Entities;
  6. using Microsoft.Extensions.Logging;
  7. namespace FMSAdmin.Data {
  8. public partial class FMSContext : DbContext {
  9. private readonly ILogger<FMSContext> _logger;
  10. public FMSContext(DbContextOptions<FMSContext> options, ILogger<FMSContext> logger = null) : base(options) {
  11. _logger = logger;
  12. }
  13. public virtual DbSet<BemsAlarmGroup> BemsAlarmGroup { get; set; }
  14. public virtual DbSet<BemsAlarmGroupUser> BemsAlarmGroupUser { get; set; }
  15. public virtual DbSet<BemsAlarmLog> BemsAlarmLog { get; set; }
  16. public virtual DbSet<BemsAlarmSetting> BemsAlarmSetting { get; set; }
  17. public virtual DbSet<BemsAnalysisType> BemsAnalysisType { get; set; }
  18. public virtual DbSet<BemsChartInfo> BemsChartInfo { get; set; }
  19. public virtual DbSet<BemsControlAhutempConfig> BemsControlAhutempConfig { get; set; }
  20. public virtual DbSet<BemsControlGroup> BemsControlGroup { get; set; }
  21. public virtual DbSet<BemsControlGroupHistory> BemsControlGroupHistory { get; set; }
  22. public virtual DbSet<BemsControlPointHistory> BemsControlPointHistory { get; set; }
  23. public virtual DbSet<BemsDevice> BemsDevice { get; set; }
  24. public virtual DbSet<BemsDeviceRunHistory> BemsDeviceRunHistory { get; set; }
  25. public virtual DbSet<BemsDeviceRunHourly> BemsDeviceRunHourly { get; set; }
  26. public virtual DbSet<BemsDeviceRunHourly2> BemsDeviceRunHourly2 { get; set; }
  27. public virtual DbSet<BemsDeviceRunHourlyCombine> BemsDeviceRunHourlyCombine { get; set; }
  28. public virtual DbSet<BemsDeviceRunHourlyCost> BemsDeviceRunHourlyCost { get; set; }
  29. public virtual DbSet<BemsDeviceType> BemsDeviceType { get; set; }
  30. public virtual DbSet<BemsDeviceTypeUsingEnergy> BemsDeviceTypeUsingEnergy { get; set; }
  31. public virtual DbSet<BemsEnergyConfigPercentMonth> BemsEnergyConfigPercentMonth { get; set; }
  32. public virtual DbSet<BemsEnergyConfigPercentWeek> BemsEnergyConfigPercentWeek { get; set; }
  33. public virtual DbSet<BemsEnergyCost> BemsEnergyCost { get; set; }
  34. public virtual DbSet<BemsEnergyDaily> BemsEnergyDaily { get; set; }
  35. public virtual DbSet<BemsEnergyDailyRegression> BemsEnergyDailyRegression { get; set; }
  36. public virtual DbSet<BemsEnergyDailyView> BemsEnergyDailyView { get; set; }
  37. public virtual DbSet<BemsEnergyGoalDaily> BemsEnergyGoalDaily { get; set; }
  38. public virtual DbSet<BemsFacilityType> BemsFacilityType { get; set; }
  39. public virtual DbSet<BemsFactorCo2> BemsFactorCo2 { get; set; }
  40. public virtual DbSet<BemsFactorToe> BemsFactorToe { get; set; }
  41. public virtual DbSet<BemsFaultDiagnosis> BemsFaultDiagnosis { get; set; }
  42. public virtual DbSet<BemsFaultServerityLevel> BemsFaultServerityLevel { get; set; }
  43. public virtual DbSet<BemsFaultType> BemsFaultType { get; set; }
  44. public virtual DbSet<BemsFloorPlan> BemsFloorPlan { get; set; }
  45. public virtual DbSet<BemsFloorStatus> BemsFloorStatus { get; set; }
  46. public virtual DbSet<BemsFormula> BemsFormula { get; set; }
  47. public virtual DbSet<BemsFormulaBase> BemsFormulaBase { get; set; }
  48. public virtual DbSet<BemsFormulaParameter> BemsFormulaParameter { get; set; }
  49. public virtual DbSet<BemsFormulaTable> BemsFormulaTable { get; set; }
  50. public virtual DbSet<BemsFormulaTableValue> BemsFormulaTableValue { get; set; }
  51. public virtual DbSet<BemsFuelType> BemsFuelType { get; set; }
  52. public virtual DbSet<BemsLoadsHourly> BemsLoadsHourly { get; set; }
  53. public virtual DbSet<BemsMeasureHistory> BemsMeasureHistory { get; set; }
  54. public virtual DbSet<BemsMeasureSchedule> BemsMeasureSchedule { get; set; }
  55. public virtual DbSet<BemsMeasureSchedulePoint> BemsMeasureSchedulePoint { get; set; }
  56. public virtual DbSet<BemsMonitoringPoint> BemsMonitoringPoint { get; set; }
  57. public virtual DbSet<BemsMonitoringPointBaseData> BemsMonitoringPointBaseData { get; set; }
  58. public virtual DbSet<BemsMonitoringPointConfig> BemsMonitoringPointConfig { get; set; }
  59. public virtual DbSet<BemsMonitoringPointHistory15min> BemsMonitoringPointHistory15min { get; set; }
  60. public virtual DbSet<BemsMonitoringPointHistory15minRawData> BemsMonitoringPointHistory15minRawData { get; set; }
  61. public virtual DbSet<BemsMonitoringPointHistoryDaily> BemsMonitoringPointHistoryDaily { get; set; }
  62. public virtual DbSet<BemsMonitoringPointHistoryHourly> BemsMonitoringPointHistoryHourly { get; set; }
  63. public virtual DbSet<BemsMonitoringPointToAnlaysisType> BemsMonitoringPointToAnlaysisType { get; set; }
  64. public virtual DbSet<BemsNoticePrice> BemsNoticePrice { get; set; }
  65. public virtual DbSet<BemsNoticePriceBase> BemsNoticePriceBase { get; set; }
  66. public virtual DbSet<BemsNoticePriceContractDataType> BemsNoticePriceContractDataType { get; set; }
  67. public virtual DbSet<BemsNoticePriceContractType> BemsNoticePriceContractType { get; set; }
  68. public virtual DbSet<BemsNoticePriceDetail> BemsNoticePriceDetail { get; set; }
  69. public virtual DbSet<BemsPeakFacility> BemsPeakFacility { get; set; }
  70. public virtual DbSet<BemsPeakHistory> BemsPeakHistory { get; set; }
  71. public virtual DbSet<BemsPeakHistoryDaily> BemsPeakHistoryDaily { get; set; }
  72. public virtual DbSet<BemsPeakInfo> BemsPeakInfo { get; set; }
  73. public virtual DbSet<BemsPeopleIncrease> BemsPeopleIncrease { get; set; }
  74. public virtual DbSet<BemsPriceCode> BemsPriceCode { get; set; }
  75. public virtual DbSet<BemsPriceFormula> BemsPriceFormula { get; set; }
  76. public virtual DbSet<BemsPriceMeta> BemsPriceMeta { get; set; }
  77. public virtual DbSet<BemsPriceType> BemsPriceType { get; set; }
  78. public virtual DbSet<BemsRentalRate> BemsRentalRate { get; set; }
  79. public virtual DbSet<BemsReportFormat> BemsReportFormat { get; set; }
  80. public virtual DbSet<BemsReportFormatContent> BemsReportFormatContent { get; set; }
  81. public virtual DbSet<BemsReportFormatToFacility> BemsReportFormatToFacility { get; set; }
  82. public virtual DbSet<BemsReportHistory> BemsReportHistory { get; set; }
  83. public virtual DbSet<BemsReportHistoryContent> BemsReportHistoryContent { get; set; }
  84. public virtual DbSet<BemsServiceType> BemsServiceType { get; set; }
  85. public virtual DbSet<BemsValueType> BemsValueType { get; set; }
  86. public virtual DbSet<BemsSitePrice> BemsSitePrice { get; set; }
  87. public virtual DbSet<BemsSitePriceHistory> BemsSitePriceHistory { get; set; }
  88. public virtual DbSet<BemsWeatherHourly> BemsWeatherHourly { get; set; }
  89. public virtual DbSet<BemsZone> BemsZone { get; set; }
  90. public virtual DbSet<BemsZoneActivate> BemsZoneActivate { get; set; }
  91. public virtual DbSet<BemsZoneActivateDaily> BemsZoneActivateDaily { get; set; }
  92. public virtual DbSet<CmAlarmAdmin> CmAlarmAdmin { get; set; }
  93. public virtual DbSet<CmAnnouncement> CmAnnouncement { get; set; }
  94. public virtual DbSet<CmBuilding> CmBuilding { get; set; }
  95. public virtual DbSet<CmBusinessField> CmBusinessField { get; set; }
  96. public virtual DbSet<CmCompany> CmCompany { get; set; }
  97. public virtual DbSet<CmCompanyType> CmCompanyType { get; set; }
  98. public virtual DbSet<CmDepartment> CmDepartment { get; set; }
  99. public virtual DbSet<CmFacility> CmFacility { get; set; }
  100. public virtual DbSet<CmFacilityFile> CmFacilityFile { get; set; }
  101. public virtual DbSet<CmFacilityTempSet> CmFacilityTempSet { get; set; }
  102. public virtual DbSet<CmFile> CmFile { get; set; }
  103. public virtual DbSet<CmFileCategory> CmFileCategory { get; set; }
  104. public virtual DbSet<CmFloor> CmFloor { get; set; }
  105. public virtual DbSet<CmFloorCode> CmFloorCode { get; set; }
  106. public virtual DbSet<CmGuideline> CmGuideline { get; set; }
  107. public virtual DbSet<CmHoliday> CmHoliday { get; set; }
  108. public virtual DbSet<CmHolidayCustom> CmHolidayCustom { get; set; }
  109. public virtual DbSet<CmHolidayWeekend> CmHolidayWeekend { get; set; }
  110. public virtual DbSet<CmMenu> CmMenu { get; set; }
  111. public virtual DbSet<CmPartner> CmPartner { get; set; }
  112. public virtual DbSet<CmPartnerType> CmPartnerType { get; set; }
  113. public virtual DbSet<CmPatrolCourse> CmPatrolCourse { get; set; }
  114. public virtual DbSet<CmPatrolCoursePos> CmPatrolCoursePos { get; set; }
  115. public virtual DbSet<CmPatrolGroup> CmPatrolGroup { get; set; }
  116. public virtual DbSet<CmPatrolGroupUser> CmPatrolGroupUser { get; set; }
  117. public virtual DbSet<CmPatrolHistory> CmPatrolHistory { get; set; }
  118. public virtual DbSet<CmPatrolHistoryPos> CmPatrolHistoryPos { get; set; }
  119. public virtual DbSet<CmPatrolPlan> CmPatrolPlan { get; set; }
  120. public virtual DbSet<CmPatrolPos> CmPatrolPos { get; set; }
  121. public virtual DbSet<CmPatrolSchedule> CmPatrolSchedule { get; set; }
  122. public virtual DbSet<CmPatrolType> CmPatrolType { get; set; }
  123. public virtual DbSet<CmPosition> CmPosition { get; set; }
  124. public virtual DbSet<CmServiceEnergyCalcDay> CmServiceEnergyCalcDay { get; set; }
  125. public virtual DbSet<CmServiceEnergyCalcMonth> CmServiceEnergyCalcMonth { get; set; }
  126. public virtual DbSet<CmSite> CmSite { get; set; }
  127. public virtual DbSet<CmSunrise> CmSunrise { get; set; }
  128. public virtual DbSet<CmSunriseSunset> CmSunriseSunset { get; set; }
  129. public virtual DbSet<CmUser> CmUser { get; set; }
  130. public virtual DbSet<CmUserGroup> CmUserGroup { get; set; }
  131. public virtual DbSet<CmUserGroupPermission> CmUserGroupPermission { get; set; }
  132. public virtual DbSet<CmUserLoginHistory> CmUserLoginHistory { get; set; }
  133. public virtual DbSet<CmUserToLicense> CmUserToLicense { get; set; }
  134. public virtual DbSet<CmZone> CmZone { get; set; }
  135. public virtual DbSet<CmZoneTempHumiSet> CmZoneTempHumiSet { get; set; }
  136. public virtual DbSet<Cols> Cols { get; set; }
  137. public virtual DbSet<FmsAccident> FmsAccident { get; set; }
  138. public virtual DbSet<FmsAccidentCodeType> FmsAccidentCodeType { get; set; }
  139. public virtual DbSet<FmsComplaints> FmsComplaints { get; set; }
  140. public virtual DbSet<FmsComplaintCodeType> FmsComplaintCodeType { get; set; }
  141. public virtual DbSet<FmsBudget> FmsBudget { get; set; }
  142. public virtual DbSet<FmsBudgetCodeClass> FmsBudgetCodeClass { get; set; }
  143. public virtual DbSet<FmsBudgetDetail> FmsBudgetDetail { get; set; }
  144. public virtual DbSet<FmsBudgetDetailExecution> FmsBudgetDetailExecution { get; set; }
  145. public virtual DbSet<FmsCompanyEstimationCodeClass> FmsCompanyEstimationCodeClass { get; set; }
  146. public virtual DbSet<FmsConstruction> FmsConstruction { get; set; }
  147. public virtual DbSet<FmsConstructionCodeProgress> FmsConstructionCodeProgress { get; set; }
  148. public virtual DbSet<FmsConstructionCodeType> FmsConstructionCodeType { get; set; }
  149. public virtual DbSet<FmsConstructionEstimation> FmsConstructionEstimation { get; set; }
  150. public virtual DbSet<FmsContract> FmsContract { get; set; }
  151. public virtual DbSet<FmsContractClass> FmsContractClass { get; set; }
  152. public virtual DbSet<FmsContractMethod> FmsContractMethod { get; set; }
  153. public virtual DbSet<FmsContractType> FmsContractType { get; set; }
  154. public virtual DbSet<FmsDailyCheckReport> FmsDailyCheckReport { get; set; }
  155. public virtual DbSet<FmsDailyReport> FmsDailyReport { get; set; }
  156. public virtual DbSet<FmsDailyStoredReleaseStatusView> FmsDailyStoredReleaseStatusView { get; set; }
  157. public virtual DbSet<FmsDrawing> FmsDrawing { get; set; }
  158. public virtual DbSet<FmsDrawingCodeGroup> FmsDrawingCodeGroup { get; set; }
  159. public virtual DbSet<FmsDrawingCodeType> FmsDrawingCodeType { get; set; }
  160. public virtual DbSet<FmsDrawingHistory> FmsDrawingHistory { get; set; }
  161. public virtual DbSet<FmsEnergyAnalysis> FmsEnergyAnalysis { get; set; }
  162. public virtual DbSet<FmsEquipment> FmsEquipment { get; set; }
  163. public virtual DbSet<FmsEquipmentCodeStateType> FmsEquipmentCodeStateType { get; set; }
  164. public virtual DbSet<FmsEquipmentCodeType> FmsEquipmentCodeType { get; set; }
  165. public virtual DbSet<FmsEquipmentHistory> FmsEquipmentHistory { get; set; }
  166. public virtual DbSet<FmsEquipmentRentInfo> FmsEquipmentRentInfo { get; set; }
  167. public virtual DbSet<FmsFacilityCheckItem> FmsFacilityCheckItem { get; set; }
  168. public virtual DbSet<FmsFacilityCodeClass> FmsFacilityCodeClass { get; set; }
  169. public virtual DbSet<FmsFacilityManual> FmsFacilityManual { get; set; }
  170. public virtual DbSet<FmsFacilityOperationItem> FmsFacilityOperationItem { get; set; }
  171. public virtual DbSet<FmsFacilityOperationReport> FmsFacilityOperationReport { get; set; }
  172. public virtual DbSet<FmsFacilityState> FmsFacilityState { get; set; }
  173. public virtual DbSet<FmsFacilityStateDetail> FmsFacilityStateDetail { get; set; }
  174. public virtual DbSet<CmSurvey> CmSurvey { get; set; }
  175. public virtual DbSet<FmsInvestmentCost> FmsInvestmentCost { get; set; }
  176. public virtual DbSet<FmsLicense> FmsLicense { get; set; }
  177. public virtual DbSet<FmsManual> FmsManual { get; set; }
  178. public virtual DbSet<FmsManualHistory> FmsManualHistory { get; set; }
  179. public virtual DbSet<FmsManualType> FmsManualType { get; set; }
  180. public virtual DbSet<FmsManualGroup> FmsManualGroup { get; set; }
  181. public virtual DbSet<FmsMaterial> FmsMaterial { get; set; }
  182. public virtual DbSet<FmsMaterialCarriedForward> FmsMaterialCarriedForward { get; set; }
  183. public virtual DbSet<FmsMaterialCodeAdjustmentType> FmsMaterialCodeAdjustmentType { get; set; }
  184. public virtual DbSet<FmsMaterialCodeClass> FmsMaterialCodeClass { get; set; }
  185. public virtual DbSet<FmsMaterialCodeLocation> FmsMaterialCodeLocation { get; set; }
  186. public virtual DbSet<FmsMaterialCodeProgress> FmsMaterialCodeProgress { get; set; }
  187. public virtual DbSet<FmsMaterialCodePurchaseType> FmsMaterialCodePurchaseType { get; set; }
  188. public virtual DbSet<FmsMaterialCodeReleaseType> FmsMaterialCodeReleaseType { get; set; }
  189. public virtual DbSet<FmsMaterialCodeType> FmsMaterialCodeType { get; set; }
  190. public virtual DbSet<FmsMaterialPurchaseOrder> FmsMaterialPurchaseOrder { get; set; }
  191. public virtual DbSet<FmsMaterialPurchaseOrderMaterial> FmsMaterialPurchaseOrderMaterial { get; set; }
  192. public virtual DbSet<FmsMaterialPurchaseRequest> FmsMaterialPurchaseRequest { get; set; }
  193. public virtual DbSet<FmsMaterialPurchaseRequestMaterial> FmsMaterialPurchaseRequestMaterial { get; set; }
  194. public virtual DbSet<FmsMaterialRelease> FmsMaterialRelease { get; set; }
  195. public virtual DbSet<FmsMaterialStored> FmsMaterialStored { get; set; }
  196. public virtual DbSet<FmsMaterialTradeCompany> FmsMaterialTradeCompany { get; set; }
  197. public virtual DbSet<FmsMaterialWarehouse> FmsMaterialWarehouse { get; set; }
  198. public virtual DbSet<FmsMonthlyReport> FmsMonthlyReport { get; set; }
  199. public virtual DbSet<FmsMonthKeyWork> FmsMonthKeyWork { get; set; }
  200. public virtual DbSet<FmsMonthlyStoredReleaseStatusView> FmsMonthlyStoredReleaseStatusView { get; set; }
  201. public virtual DbSet<FmsPaymentType> FmsPaymentType { get; set; }
  202. public virtual DbSet<FmsReport> FmsReport { get; set; }
  203. public virtual DbSet<FmsShortStockStatusView> FmsShortStockStatusView { get; set; }
  204. public virtual DbSet<FmsWeekKeyWork> FmsWeekKeyWork { get; set; }
  205. public virtual DbSet<FmsWorkCodeCauseClass> FmsWorkCodeCauseClass { get; set; }
  206. public virtual DbSet<FmsWorkCodeCycleUnit> FmsWorkCodeCycleUnit { get; set; }
  207. public virtual DbSet<FmsWorkCodeEmergency> FmsWorkCodeEmergency { get; set; }
  208. public virtual DbSet<FmsWorkCodeHolidayWorkType> FmsWorkCodeHolidayWorkType { get; set; }
  209. public virtual DbSet<FmsWorkCodeLegalInspectionAgency> FmsWorkCodeLegalInspectionAgency { get; set; }
  210. public virtual DbSet<FmsWorkCodeProgress> FmsWorkCodeProgress { get; set; }
  211. public virtual DbSet<FmsWorkCodeType> FmsWorkCodeType { get; set; }
  212. public virtual DbSet<FmsWorkOrder> FmsWorkOrder { get; set; }
  213. public virtual DbSet<FmsWorkOrderToFacility> FmsWorkOrderToFacility { get; set; }
  214. public virtual DbSet<FmsWorkRequest> FmsWorkRequest { get; set; }
  215. public virtual DbSet<FmsWorkRequestToFacility> FmsWorkRequestToFacility { get; set; }
  216. public virtual DbSet<FmsWorkResult> FmsWorkResult { get; set; }
  217. public virtual DbSet<FmsWorkResultCheckItem> FmsWorkResultCheckItem { get; set; }
  218. public virtual DbSet<FmsWorkResultCheckItemMaterial> FmsWorkResultCheckItemMaterial { get; set; }
  219. public virtual DbSet<FmsWorkResultFile> FmsWorkResultFile { get; set; }
  220. public virtual DbSet<FmsWorkResultLaw> FmsWorkResultLaw { get; set; }
  221. public virtual DbSet<FmsWorkResultToFacility> FmsWorkResultToFacility { get; set; }
  222. public virtual DbSet<FmsWorkSchedule> FmsWorkSchedule { get; set; }
  223. public virtual DbSet<FmsWorkScheduleToFacility> FmsWorkScheduleToFacility { get; set; }
  224. public virtual DbSet<WeatherDongNaeForecast> WeatherDongNaeForecast { get; set; }
  225. public virtual DbSet<WeatherDustSidoInfo> WeatherDustSidoInfo { get; set; }
  226. public virtual DbSet<WeatherShortTermForecast> WeatherShortTermForecast { get; set; }
  227. public virtual DbSet<WeatherShortTermNowValue> WeatherShortTermNowValue { get; set; }
  228. public virtual DbSet<Sitemap> Sitemap { get; set; }
  229. public virtual DbSet<SitemapAuth> SitemapAuth { get; set; }
  230. public virtual DbSet<SiteConfig> SiteConfig { get; set; }
  231. public virtual DbSet<CmTenant> CmTenant { get; set; }
  232. public virtual DbSet<FmsWorkCodeDetailType> FmsWorkCodeDetailType { get; set; }
  233. public virtual DbSet<FmsWorkRequestToAccident> FmsWorkRequestToAccident { get; set; }
  234. public virtual DbSet<FmsWorkRequestToComplaint> FmsWorkRequestToComplaint { get; set; }
  235. public virtual DbSet<FmsMaterialReleaseDetail> FmsMaterialReleaseDetail { get; set; }
  236. public virtual DbSet<SiteWeatherInfo> SiteWeatherInfo { get; set; }
  237. public virtual DbSet<WeatherRegionNxNy> WeatherRegionNxNy { get; set; }
  238. public virtual DbSet<FmsAlarmLog> FmsAlarmLog { get; set; }
  239. public virtual DbSet<FmsAlarmPoint> FmsAlarmPoint { get; set; }
  240. public virtual DbSet<MobileShortcut> MobileShortcut { get; set; }
  241. public virtual DbSet<CmRentalStatus> CmRentalStatus { get; set; }
  242. public virtual DbSet<CmOrganizationChartStatus> CmOrganizationChartStatus { get; set; }
  243. public virtual DbSet<CmCertificateStatus> CmCertificateStatus { get; set; }
  244. public virtual DbSet<CmLayout> CmLayout { get; set; }
  245. public virtual DbSet<CmInvestigation1> CmInvestigation1 { get; set; }
  246. public virtual DbSet<CmInvestigation2> CmInvestigation2 { get; set; }
  247. public virtual DbSet<CmInvestigation3> CmInvestigation3 { get; set; }
  248. public virtual DbSet<CmInvestigation1CodeGroup> CmInvestigation1CodeGroup { get; set; }
  249. public virtual DbSet<CmInvestigation1CodeType> CmInvestigation1CodeType { get; set; }
  250. public virtual DbSet<CmInvestigation2CodeGroup> CmInvestigation2CodeGroup { get; set; }
  251. public virtual DbSet<CmInvestigation2CodeType> CmInvestigation2CodeType { get; set; }
  252. public virtual DbSet<CmInvestigation3CodeGroup> CmInvestigation3CodeGroup { get; set; }
  253. public virtual DbSet<CmInvestigation3CodeType> CmInvestigation3CodeType { get; set; }
  254. public virtual DbSet<CmInvestigation1History> CmInvestigation1History { get; set; }
  255. public virtual DbSet<CmInvestigation2History> CmInvestigation2History { get; set; }
  256. public virtual DbSet<CmInvestigation3History> CmInvestigation3History { get; set; }
  257. protected override void OnModelCreating(ModelBuilder modelBuilder) {
  258. foreach (var foreignKey in modelBuilder.Model.GetEntityTypes().SelectMany(e => e.GetForeignKeys())) {
  259. foreignKey.DeleteBehavior = DeleteBehavior.Restrict;
  260. }
  261. modelBuilder.Entity<BemsAlarmGroup>(entity => {
  262. entity.HasKey(e => new { e.SiteId, e.AlarmGroupId })
  263. .HasName("PK__BemsAlar__9F06C6DFD20DDE73");
  264. entity.Property(e => e.AlarmGroupId).ValueGeneratedOnAdd();
  265. });
  266. modelBuilder.Entity<BemsAlarmGroupUser>(entity => {
  267. entity.HasKey(e => new { e.SiteId, e.AlarmGroupId, e.UserId });
  268. });
  269. modelBuilder.Entity<BemsAlarmLog>(entity => {
  270. entity.HasKey(e => new { e.SiteId, e.FacilityTypeId, e.FacilityCode, e.PropertyId, e.FormulaId, e.CreatedDateTime })
  271. .HasName("PK__BemsAlar__920ECD63CDC4C3D7");
  272. entity.HasOne(d => d.BemsAlarmSetting)
  273. .WithMany(p => p.BemsAlarmLog)
  274. .HasForeignKey(d => new { d.SiteId, d.FacilityTypeId, d.FacilityCode, d.PropertyId, d.FormulaId })
  275. .OnDelete(DeleteBehavior.ClientSetNull)
  276. .HasConstraintName("FK_BemsAlarmLog_BemsAlarmSetting");
  277. });
  278. modelBuilder.Entity<BemsAlarmSetting>(entity => {
  279. entity.HasKey(e => new { e.SiteId, e.FacilityTypeId, e.FacilityCode, e.PropertyId, e.FormulaId });
  280. entity.HasOne(d => d.FacilityType)
  281. .WithMany(p => p.BemsAlarmSetting)
  282. .HasForeignKey(d => d.FacilityTypeId)
  283. .OnDelete(DeleteBehavior.ClientSetNull)
  284. .HasConstraintName("FK_BemsAlarmSetting_BemsFacilityType");
  285. entity.HasOne(d => d.Site)
  286. .WithMany(p => p.BemsAlarmSetting)
  287. .HasForeignKey(d => d.SiteId)
  288. .OnDelete(DeleteBehavior.ClientSetNull)
  289. .HasConstraintName("FK_BemsAlarmSetting_CmSite1");
  290. entity.HasOne(d => d.CmFacility)
  291. .WithMany(p => p.BemsAlarmSetting)
  292. .HasForeignKey(d => new { d.SiteId, d.FacilityCode })
  293. .OnDelete(DeleteBehavior.ClientSetNull)
  294. .HasConstraintName("FK_BemsAlarmSetting_CmFacility");
  295. });
  296. modelBuilder.Entity<BemsAnalysisType>(entity => {
  297. entity.HasKey(e => new { e.SiteId, e.AnalysisType })
  298. .HasName("PK__BemsAnal__248F415B95955FC7");
  299. entity.Property(e => e.AnalysisType)
  300. .HasComment("고장 유형")
  301. .ValueGeneratedOnAdd();
  302. });
  303. modelBuilder.Entity<BemsChartInfo>(entity => {
  304. entity.HasKey(e => new { e.SiteId, e.FacilityTypeId, e.ChartId });
  305. entity.HasOne(d => d.FacilityType)
  306. .WithMany(p => p.BemsChartInfo)
  307. .HasForeignKey(d => d.FacilityTypeId)
  308. .OnDelete(DeleteBehavior.ClientSetNull)
  309. .HasConstraintName("FK_BemsChartInfo_BemsFacilityType");
  310. entity.HasOne(d => d.Site)
  311. .WithMany(p => p.BemsChartInfo)
  312. .HasForeignKey(d => d.SiteId)
  313. .OnDelete(DeleteBehavior.ClientSetNull)
  314. .HasConstraintName("FK_BemsChartInfo_CmSite");
  315. });
  316. modelBuilder.Entity<BemsControlAhutempConfig>(entity => {
  317. entity.HasKey(e => new { e.SiteId, e.FacilityTypeId, e.FacilityCode });
  318. });
  319. modelBuilder.Entity<BemsControlGroup>(entity => {
  320. entity.Property(e => e.GroupId)
  321. .HasComment("제어 그룸 ID")
  322. .ValueGeneratedNever();
  323. });
  324. modelBuilder.Entity<BemsControlGroupHistory>(entity => {
  325. entity.HasNoKey();
  326. });
  327. modelBuilder.Entity<BemsControlPointHistory>(entity => {
  328. entity.HasKey(e => new { e.SiteId, e.FacilityCode, e.PropertyId, e.CreateDateTime })
  329. .HasName("PK_BemsControlPointHistory_1");
  330. entity.HasOne(d => d.FacilityType)
  331. .WithMany(p => p.BemsControlPointHistory)
  332. .HasForeignKey(d => d.FacilityTypeId)
  333. .OnDelete(DeleteBehavior.ClientSetNull)
  334. .HasConstraintName("FK_BemsControlPointHistory_BemsFacilityType");
  335. entity.HasOne(d => d.BemsMonitoringPoint)
  336. .WithMany(p => p.BemsControlPointHistory)
  337. .HasForeignKey(d => new { d.SiteId, d.FacilityCode, d.PropertyId })
  338. .OnDelete(DeleteBehavior.ClientSetNull)
  339. .HasConstraintName("FK_BemsControlPointHistory_BemsMonitoringPoint");
  340. });
  341. modelBuilder.Entity<BemsDevice>(entity => {
  342. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.DeviceId })
  343. .HasName("PK__BemsDevi__FCD3649C85423C27");
  344. entity.Property(e => e.DeviceId)
  345. .HasComment("가동 설비고유번호")
  346. .ValueGeneratedOnAdd();
  347. entity.Property(e => e.Name)
  348. .IsUnicode(false)
  349. .HasComment("가동 설비명");
  350. entity.Property(e => e.Nickname)
  351. .IsUnicode(false)
  352. .HasComment("설비별칭");
  353. entity.HasOne(d => d.DeviceType)
  354. .WithMany(p => p.BemsDevice)
  355. .HasForeignKey(d => d.DeviceTypeId)
  356. .OnDelete(DeleteBehavior.ClientSetNull)
  357. .HasConstraintName("FK__BemsDevice__BemsDeviceType");
  358. entity.HasOne(d => d.CmBuilding)
  359. .WithMany(p => p.BemsDevice)
  360. .HasForeignKey(d => new { d.SiteId, d.BuildingId })
  361. .OnDelete(DeleteBehavior.ClientSetNull)
  362. .HasConstraintName("FK__BemsDevice__CmBuilding");
  363. entity.HasOne(d => d.BemsZone)
  364. .WithMany(p => p.BemsDevice)
  365. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.ZoneId })
  366. .HasConstraintName("FK__BemsDevice__BemsZone");
  367. });
  368. modelBuilder.Entity<BemsDeviceRunHistory>(entity => {
  369. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.DeviceId, e.ServiceTypeId, e.RunDate })
  370. .HasName("PK__BemsDevi__7A33A9ABC319DE68");
  371. entity.HasOne(d => d.ServiceType)
  372. .WithMany(p => p.BemsDeviceRunHistory)
  373. .HasForeignKey(d => d.ServiceTypeId)
  374. .OnDelete(DeleteBehavior.ClientSetNull)
  375. .HasConstraintName("FK__BemsDeviceRunHistory__BemsServiceType");
  376. entity.HasOne(d => d.BemsDevice)
  377. .WithMany(p => p.BemsDeviceRunHistory)
  378. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.DeviceId })
  379. .OnDelete(DeleteBehavior.ClientSetNull)
  380. .HasConstraintName("FK__BemsDeviceRunHistory__BemsDevice");
  381. });
  382. modelBuilder.Entity<BemsDeviceRunHourly>(entity => {
  383. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.ServiceTypeId, e.RunDate })
  384. .HasName("PK__BemsDevi__829656C703EED682");
  385. entity.HasOne(d => d.ServiceType)
  386. .WithMany(p => p.BemsDeviceRunHourly)
  387. .HasForeignKey(d => d.ServiceTypeId)
  388. .OnDelete(DeleteBehavior.ClientSetNull)
  389. .HasConstraintName("FK__BemsDeviceRunHourly__BemsServiceType");
  390. entity.HasOne(d => d.CmBuilding)
  391. .WithMany(p => p.BemsDeviceRunHourly)
  392. .HasForeignKey(d => new { d.SiteId, d.BuildingId })
  393. .OnDelete(DeleteBehavior.ClientSetNull)
  394. .HasConstraintName("FK__BemsDeviceRunHourly__CmBuilding");
  395. });
  396. modelBuilder.Entity<BemsDeviceRunHourly2>(entity => {
  397. entity.HasNoKey();
  398. });
  399. modelBuilder.Entity<BemsDeviceRunHourlyCombine>(entity => {
  400. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.ServiceTypeId, e.RunDate, e.DeviceId })
  401. .HasName("PK__BemsDevi__A1861F2637588945");
  402. entity.HasOne(d => d.BemsDevice)
  403. .WithMany(p => p.BemsDeviceRunHourlyCombine)
  404. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.DeviceId })
  405. .OnDelete(DeleteBehavior.ClientSetNull)
  406. .HasConstraintName("FK__BemsDeviceRunHourlyCombine__BemsDevice");
  407. entity.HasOne(d => d.BemsDeviceRunHourly)
  408. .WithMany(p => p.BemsDeviceRunHourlyCombine)
  409. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.ServiceTypeId, d.RunDate })
  410. .OnDelete(DeleteBehavior.ClientSetNull)
  411. .HasConstraintName("FK__BemsDeviceRunHourlyCombine__BemsDeviceRunHourly");
  412. });
  413. modelBuilder.Entity<BemsDeviceRunHourlyCost>(entity => {
  414. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.ServiceTypeId, e.RunDate, e.FuelTypeId })
  415. .HasName("PK__BemsDevi__6CA0524CFDB4ECBF");
  416. entity.HasOne(d => d.FuelType)
  417. .WithMany(p => p.BemsDeviceRunHourlyCost)
  418. .HasForeignKey(d => d.FuelTypeId)
  419. .OnDelete(DeleteBehavior.ClientSetNull)
  420. .HasConstraintName("FK__BemsDeviceRunHourlyCost__BemsFuelType");
  421. entity.HasOne(d => d.BemsDeviceRunHourly)
  422. .WithMany(p => p.BemsDeviceRunHourlyCost)
  423. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.ServiceTypeId, d.RunDate })
  424. .OnDelete(DeleteBehavior.ClientSetNull)
  425. .HasConstraintName("FK__BemsDeviceRunHourlyCost__BemsDeviceRunHourly");
  426. });
  427. modelBuilder.Entity<BemsDeviceType>(entity => {
  428. entity.HasKey(e => e.DeviceTypeId)
  429. .HasName("PK__BemsDevi__07A6C7F64A52ADBE");
  430. entity.Property(e => e.DeviceTypeId)
  431. .HasComment("가동 설비 타입")
  432. .ValueGeneratedNever();
  433. entity.Property(e => e.Name)
  434. .IsUnicode(false)
  435. .HasComment("설비 타입명");
  436. });
  437. modelBuilder.Entity<BemsDeviceTypeUsingEnergy>(entity => {
  438. entity.HasKey(e => new { e.DeviceTypeId, e.FuelTypeId })
  439. .HasName("PK__BemsDevi__67EE7915BB60B19E");
  440. entity.HasOne(d => d.DeviceType)
  441. .WithMany(p => p.BemsDeviceTypeUsingEnergy)
  442. .HasForeignKey(d => d.DeviceTypeId)
  443. .OnDelete(DeleteBehavior.ClientSetNull)
  444. .HasConstraintName("FK__BemsDeviceTypeUsingEnergy__BemsDeviceType");
  445. entity.HasOne(d => d.FuelType)
  446. .WithMany(p => p.BemsDeviceTypeUsingEnergy)
  447. .HasForeignKey(d => d.FuelTypeId)
  448. .OnDelete(DeleteBehavior.ClientSetNull)
  449. .HasConstraintName("FK__BemsDeviceTypeUsingEnergy__BemsFuelType");
  450. entity.HasOne(d => d.BemsNoticePriceContractType)
  451. .WithMany(p => p.BemsDeviceTypeUsingEnergy)
  452. .HasForeignKey(d => new { d.FuelTypeId, d.ContractType })
  453. .HasConstraintName("FK__BemsDeviceTypeUsingEnergy__BemsNoticePriceContractType");
  454. });
  455. modelBuilder.Entity<BemsEnergyConfigPercentMonth>(entity => {
  456. entity.HasKey(e => new { e.SiteId, e.Year, e.Month })
  457. .HasName("PK__BemsEner__966DFBC7F1C7E4FF");
  458. entity.HasOne(d => d.Site)
  459. .WithMany(p => p.BemsEnergyConfigPercentMonth)
  460. .HasForeignKey(d => d.SiteId)
  461. .OnDelete(DeleteBehavior.ClientSetNull)
  462. .HasConstraintName("FK__BemsEnerg__SiteI__7954A4F6");
  463. });
  464. modelBuilder.Entity<BemsEnergyConfigPercentWeek>(entity => {
  465. entity.HasKey(e => new { e.SiteId, e.Year, e.Week })
  466. .HasName("PK__BemsEner__38159A029BAEE931");
  467. entity.HasOne(d => d.Site)
  468. .WithMany(p => p.BemsEnergyConfigPercentWeek)
  469. .HasForeignKey(d => d.SiteId)
  470. .OnDelete(DeleteBehavior.ClientSetNull)
  471. .HasConstraintName("FK__BemsEnerg__SiteI__7C3111A1");
  472. });
  473. modelBuilder.Entity<BemsEnergyCost>(entity => {
  474. entity.HasKey(e => new { e.SiteId, e.FacilityCode })
  475. .HasName("PK__BemsEner__D352CDB4E650C6B7");
  476. entity.HasOne(d => d.CmFacility)
  477. .WithOne(p => p.BemsEnergyCost)
  478. .HasForeignKey<BemsEnergyCost>(d => new { d.SiteId, d.FacilityCode })
  479. .OnDelete(DeleteBehavior.ClientSetNull)
  480. .HasConstraintName("FK_BemsEnergyCost_CmFacility");
  481. });
  482. modelBuilder.Entity<BemsEnergyDaily>(entity => {
  483. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.ServiceTypeId, e.FuelTypeId, e.CreatedDate })
  484. .HasName("PK__BemsEner__0C04940E9A573633");
  485. entity.HasOne(d => d.FuelType)
  486. .WithMany(p => p.BemsEnergyDaily)
  487. .HasForeignKey(d => d.FuelTypeId)
  488. .OnDelete(DeleteBehavior.ClientSetNull)
  489. .HasConstraintName("FK__BemsEnergyDaily__BemsFuelType");
  490. entity.HasOne(d => d.ServiceType)
  491. .WithMany(p => p.BemsEnergyDaily)
  492. .HasForeignKey(d => d.ServiceTypeId)
  493. .OnDelete(DeleteBehavior.ClientSetNull)
  494. .HasConstraintName("FK__BemsEnergyDaily__BemsServiceType");
  495. entity.HasOne(d => d.CmBuilding)
  496. .WithMany(p => p.BemsEnergyDaily)
  497. .HasForeignKey(d => new { d.SiteId, d.BuildingId })
  498. .OnDelete(DeleteBehavior.ClientSetNull)
  499. .HasConstraintName("FK__BemsEnergyDaily__CmBuilding");
  500. });
  501. modelBuilder.Entity<BemsEnergyDailyRegression>(entity => {
  502. entity.HasKey(e => e.SiteId)
  503. .HasName("PK__BemsEner__B9DCB963A8B309FB");
  504. entity.Property(e => e.SiteId).ValueGeneratedNever();
  505. entity.HasOne(d => d.Site)
  506. .WithOne(p => p.BemsEnergyDailyRegression)
  507. .HasForeignKey<BemsEnergyDailyRegression>(d => d.SiteId)
  508. .OnDelete(DeleteBehavior.ClientSetNull)
  509. .HasConstraintName("FK_BemsEnergyDailyRegression_CmSite");
  510. });
  511. modelBuilder.Entity<BemsEnergyDailyView>(entity => {
  512. entity.HasNoKey();
  513. entity.ToView("BemsEnergyDailyView");
  514. });
  515. modelBuilder.Entity<BemsEnergyGoalDaily>(entity => {
  516. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.CreatedDate })
  517. .HasName("PK__BemsEner__981C20D13E559644");
  518. entity.HasOne(d => d.CmBuilding)
  519. .WithMany(p => p.BemsEnergyGoalDaily)
  520. .HasForeignKey(d => new { d.SiteId, d.BuildingId })
  521. .OnDelete(DeleteBehavior.ClientSetNull)
  522. .HasConstraintName("FK__BemsEnergyGoalDaily__CmBuilding");
  523. });
  524. modelBuilder.Entity<BemsFacilityType>(entity => {
  525. entity.Property(e => e.FacilityTypeId)
  526. .HasComment("설비유형 코드")
  527. .ValueGeneratedNever();
  528. });
  529. modelBuilder.Entity<BemsFactorCo2>(entity => {
  530. entity.HasKey(e => e.FuelTypeId)
  531. .HasName("PK__BemsFact__048BEE371B4225DA");
  532. entity.Property(e => e.FuelTypeId)
  533. .HasComment("연료 고유번호")
  534. .ValueGeneratedNever();
  535. entity.HasOne(d => d.FuelType)
  536. .WithOne(p => p.BemsFactorCo2)
  537. .HasForeignKey<BemsFactorCo2>(d => d.FuelTypeId)
  538. .OnDelete(DeleteBehavior.ClientSetNull)
  539. .HasConstraintName("FK__BemsFactorCo2__BemsFuelType");
  540. });
  541. modelBuilder.Entity<BemsFactorToe>(entity => {
  542. entity.HasKey(e => e.FuelTypeId)
  543. .HasName("PK__BemsFact__048BEE3796BD6F37");
  544. entity.Property(e => e.FuelTypeId)
  545. .HasComment("연료 고유번호")
  546. .ValueGeneratedNever();
  547. entity.HasOne(d => d.FuelType)
  548. .WithOne(p => p.BemsFactorToe)
  549. .HasForeignKey<BemsFactorToe>(d => d.FuelTypeId)
  550. .OnDelete(DeleteBehavior.ClientSetNull)
  551. .HasConstraintName("FK__BemsFactorToe__BemsFuelType");
  552. });
  553. modelBuilder.Entity<BemsFaultDiagnosis>(entity => {
  554. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.DeviceId, e.CreatedDate })
  555. .HasName("PK__BemsFaul__1B9B0ECA808FABBB");
  556. entity.HasOne(d => d.BemsFaultServerityLevel)
  557. .WithMany(p => p.BemsFaultDiagnosis)
  558. .HasForeignKey(d => new { d.FaultTypeId, d.ServerityLevel })
  559. .OnDelete(DeleteBehavior.ClientSetNull)
  560. .HasConstraintName("FK__BemsFaultDiagnosis__BemsFaultServerityLevel");
  561. entity.HasOne(d => d.BemsDevice)
  562. .WithMany(p => p.BemsFaultDiagnosis)
  563. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.DeviceId })
  564. .OnDelete(DeleteBehavior.ClientSetNull)
  565. .HasConstraintName("FK__BemsFaultDiagnosis__BemsDevice");
  566. });
  567. modelBuilder.Entity<BemsFaultServerityLevel>(entity => {
  568. entity.HasKey(e => new { e.FaultTypeId, e.ServerityLevel })
  569. .HasName("PK__BemsFaul__6687901F7A797D16");
  570. entity.Property(e => e.Comment)
  571. .IsUnicode(false)
  572. .HasComment("비고사항");
  573. entity.HasOne(d => d.FaultType)
  574. .WithMany(p => p.BemsFaultServerityLevel)
  575. .HasForeignKey(d => d.FaultTypeId)
  576. .OnDelete(DeleteBehavior.ClientSetNull)
  577. .HasConstraintName("FK__BemsFaultServerityLevel__BemsFaultType");
  578. });
  579. modelBuilder.Entity<BemsFaultType>(entity => {
  580. entity.HasKey(e => e.FaultTypeId)
  581. .HasName("PK__BemsFaul__D60B7902A43B1742");
  582. entity.Property(e => e.FaultTypeId)
  583. .HasComment("결함타입")
  584. .ValueGeneratedNever();
  585. entity.Property(e => e.Name)
  586. .IsUnicode(false)
  587. .HasComment("결함명");
  588. });
  589. modelBuilder.Entity<BemsFloorPlan>(entity => {
  590. entity.HasNoKey();
  591. });
  592. modelBuilder.Entity<BemsFloorStatus>(entity => {
  593. entity.HasKey(e => new { e.SiteId, e.FloorId, e.FloorName, e.ImageFileId, e.Xvalue, e.Yvalue, e.PropertyId });
  594. });
  595. modelBuilder.Entity<BemsFormula>(entity => {
  596. entity.HasKey(e => new { e.SiteId, e.FacilityTypeId, e.FacilityCode, e.FormulaId });
  597. });
  598. modelBuilder.Entity<BemsFormulaBase>(entity => {
  599. entity.HasKey(e => new { e.FacilityTypeId, e.FormulaId })
  600. .HasName("PK__BemsForm__4ADF8146EDF21B51");
  601. });
  602. modelBuilder.Entity<BemsFormulaParameter>(entity => {
  603. entity.HasKey(e => new { e.SiteId, e.FacilityCode, e.FormulaId, e.ParameterId })
  604. .HasName("PK__BemsForm__501F395B0EB3B9B3");
  605. entity.Property(e => e.ParameterId)
  606. .IsFixedLength()
  607. .HasComment("수식에 사용된 파라메터 고유번호");
  608. entity.HasOne(d => d.CmFacility)
  609. .WithMany(p => p.BemsFormulaParameter)
  610. .HasForeignKey(d => new { d.SiteId, d.FacilityCode })
  611. .OnDelete(DeleteBehavior.ClientSetNull)
  612. .HasConstraintName("FK_BemsFormulaParameter_CmFacility");
  613. entity.HasOne(d => d.BemsFormula)
  614. .WithMany(p => p.BemsFormulaParameter)
  615. .HasForeignKey(d => new { d.SiteId, d.FacilityTypeId, d.FacilityCode, d.FormulaId })
  616. .OnDelete(DeleteBehavior.ClientSetNull)
  617. .HasConstraintName("FK__BemsFormulaParameter__BemsFormula");
  618. });
  619. modelBuilder.Entity<BemsFormulaTable>(entity => {
  620. entity.HasKey(e => e.TableId)
  621. .HasName("PK__BemsForm__7D5F01EE8F24D18A");
  622. entity.Property(e => e.TableId)
  623. .HasComment("수식 테이블 고유번호")
  624. .ValueGeneratedNever();
  625. });
  626. modelBuilder.Entity<BemsFormulaTableValue>(entity => {
  627. entity.HasKey(e => new { e.TableId, e.XValue });
  628. entity.HasOne(d => d.Table)
  629. .WithMany(p => p.BemsFormulaTableValue)
  630. .HasForeignKey(d => d.TableId)
  631. .OnDelete(DeleteBehavior.ClientSetNull)
  632. .HasConstraintName("FK__BemsFormulaTableValue__BemsFormulaTable");
  633. });
  634. modelBuilder.Entity<BemsFuelType>(entity => {
  635. entity.HasKey(e => e.FuelTypeId)
  636. .HasName("PK__BemsFuel__2F4FDCEDAEA113DC");
  637. entity.Property(e => e.FuelTypeId)
  638. .HasComment("연료 고유번호")
  639. .ValueGeneratedNever();
  640. });
  641. modelBuilder.Entity<BemsLoadsHourly>(entity => {
  642. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.ServiceTypeId, e.CreatedDate })
  643. .HasName("PK__BemsLoad__66583043DDEFF303");
  644. entity.Property(e => e.RateOfWork)
  645. .HasDefaultValueSql("((1))")
  646. .HasComment("건물 가동율");
  647. entity.HasOne(d => d.ServiceType)
  648. .WithMany(p => p.BemsLoadsHourly)
  649. .HasForeignKey(d => d.ServiceTypeId)
  650. .OnDelete(DeleteBehavior.ClientSetNull)
  651. .HasConstraintName("FK__BemsLoadsHourly__BemsServiceType");
  652. entity.HasOne(d => d.CmBuilding)
  653. .WithMany(p => p.BemsLoadsHourly)
  654. .HasForeignKey(d => new { d.SiteId, d.BuildingId })
  655. .OnDelete(DeleteBehavior.ClientSetNull)
  656. .HasConstraintName("FK__BemsLoadsHourly__CmBuilding");
  657. });
  658. modelBuilder.Entity<BemsMeasureHistory>(entity => {
  659. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.DeviceId, e.FuelTypeId, e.CreatedDate })
  660. .HasName("PK__BemsMeas__71C7AA873DB3A288");
  661. entity.HasOne(d => d.FuelType)
  662. .WithMany(p => p.BemsMeasureHistory)
  663. .HasForeignKey(d => d.FuelTypeId)
  664. .OnDelete(DeleteBehavior.ClientSetNull)
  665. .HasConstraintName("FK__BemsMeasureHistory__BemsFuelType");
  666. entity.HasOne(d => d.BemsDevice)
  667. .WithMany(p => p.BemsMeasureHistory)
  668. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.DeviceId })
  669. .OnDelete(DeleteBehavior.ClientSetNull)
  670. .HasConstraintName("FK__BemsMeasureHistory__BemsDevice");
  671. });
  672. modelBuilder.Entity<BemsMeasureSchedule>(entity => {
  673. entity.HasKey(e => new { e.SiteId, e.ScheduleId })
  674. .HasName("PK__BemsMeas__30141CD753D97A6F");
  675. entity.Property(e => e.ScheduleId)
  676. .HasComment("검침계획번호")
  677. .ValueGeneratedOnAdd();
  678. entity.Property(e => e.Name)
  679. .IsUnicode(false)
  680. .HasComment("검침계획명");
  681. entity.HasOne(d => d.Site)
  682. .WithMany(p => p.BemsMeasureSchedule)
  683. .HasForeignKey(d => d.SiteId)
  684. .OnDelete(DeleteBehavior.ClientSetNull)
  685. .HasConstraintName("FK__BemsMeasureSchedule__CmSite");
  686. });
  687. modelBuilder.Entity<BemsMeasureSchedulePoint>(entity => {
  688. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.ScheduleId, e.DeviceId })
  689. .HasName("PK__BemsMeas__950291F6984BC09A");
  690. entity.HasOne(d => d.BemsDevice)
  691. .WithMany(p => p.BemsMeasureSchedulePoint)
  692. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.DeviceId })
  693. .OnDelete(DeleteBehavior.ClientSetNull)
  694. .HasConstraintName("FK__BemsMeasureSchedulePoint__BemsDevice");
  695. });
  696. modelBuilder.Entity<BemsMonitoringPoint>(entity => {
  697. entity.HasKey(e => new { e.SiteId, e.FacilityCode, e.PropertyId })
  698. .HasName("PK__BemsMoni__E72204137ACE99EE");
  699. entity.HasOne(d => d.FacilityType)
  700. .WithMany(p => p.BemsMonitoringPoint)
  701. .HasForeignKey(d => d.FacilityTypeId)
  702. .OnDelete(DeleteBehavior.ClientSetNull)
  703. .HasConstraintName("FK_BemsMonitoringPoint_BemsFacilityType");
  704. entity.HasOne(d => d.ValType)
  705. .WithMany(p => p.BemsMonitoringPoint)
  706. .HasForeignKey(d => d.ValueType)
  707. .HasConstraintName("FK_BemsMonitoringPoint_BemsValueType");
  708. entity.HasOne(d => d.FuelType)
  709. .WithMany(p => p.BemsMonitoringPoint)
  710. .HasForeignKey(d => d.FuelTypeId)
  711. .HasConstraintName("FK__BemsMonitoringPoint__BemsFuelType");
  712. entity.HasOne(d => d.ServiceType)
  713. .WithMany(p => p.BemsMonitoringPoint)
  714. .HasForeignKey(d => d.ServiceTypeId)
  715. .HasConstraintName("FK__BemsMonitoringPoint__BemsServiceType");
  716. entity.HasOne(d => d.CmBuilding)
  717. .WithMany(p => p.BemsMonitoringPoint)
  718. .HasForeignKey(d => new { d.SiteId, d.BuildingId })
  719. .HasConstraintName("FK__BemsMonitoringPoint__CmBuilding");
  720. entity.HasOne(d => d.CmFacility)
  721. .WithMany(p => p.BemsMonitoringPoint)
  722. .HasForeignKey(d => new { d.SiteId, d.FacilityCode })
  723. .OnDelete(DeleteBehavior.ClientSetNull)
  724. .HasConstraintName("FK_BemsMonitoringPoint_CmFacility");
  725. entity.HasOne(d => d.CmFloor)
  726. .WithMany(p => p.BemsMonitoringPoint)
  727. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.FloorId })
  728. .HasConstraintName("FK__BemsMonitoringPoint__CmFloor");
  729. entity.HasOne(d => d.CmZone)
  730. .WithMany(p => p.BemsMonitoringPoint)
  731. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.FloorId, d.ZoneId })
  732. .HasConstraintName("FK__BemsMonitoringPoint__CmZone");
  733. });
  734. modelBuilder.Entity<BemsMonitoringPointBaseData>(entity => {
  735. entity.HasKey(e => new { e.FacilityTypeId, e.PropertyId });
  736. entity.HasOne(d => d.FacilityType)
  737. .WithMany(p => p.BemsMonitoringPointBaseData)
  738. .HasForeignKey(d => d.FacilityTypeId)
  739. .OnDelete(DeleteBehavior.ClientSetNull)
  740. .HasConstraintName("FK__BemsMonitoringPointBaseData__BemsFacilityType");
  741. entity.HasOne(d => d.FuelType)
  742. .WithMany(p => p.BemsMonitoringPointBaseData)
  743. .HasForeignKey(d => d.FuelTypeId)
  744. .HasConstraintName("FK__BemsMonitoringPointBaseData__BemsFuelType");
  745. entity.HasOne(d => d.ServiceType)
  746. .WithMany(p => p.BemsMonitoringPointBaseData)
  747. .HasForeignKey(d => d.ServiceTypeId)
  748. .HasConstraintName("FK__BemsMonitoringPointBaseData__BemsServiceType");
  749. });
  750. modelBuilder.Entity<BemsMonitoringPointConfig>(entity => {
  751. entity.HasKey(e => new { e.SiteId, e.FacilityCode, e.PropertyId });
  752. entity.HasOne(d => d.FacilityType)
  753. .WithMany(p => p.BemsMonitoringPointConfig)
  754. .HasForeignKey(d => d.FacilityTypeId)
  755. .OnDelete(DeleteBehavior.ClientSetNull)
  756. .HasConstraintName("FK_BemsMonitoringPointConfig_BemsFacilityType1");
  757. entity.HasOne(d => d.BemsMonitoringPoint)
  758. .WithOne(p => p.BemsMonitoringPointConfig)
  759. .HasForeignKey<BemsMonitoringPointConfig>(d => new { d.SiteId, d.FacilityCode, d.PropertyId })
  760. .OnDelete(DeleteBehavior.ClientSetNull)
  761. .HasConstraintName("FK_BemsMonitoringPointConfig_BemsMonitoringPoint");
  762. });
  763. modelBuilder.Entity<BemsMonitoringPointHistory15min>(entity => {
  764. entity.HasKey(e => new { e.SiteId, e.FacilityCode, e.PropertyId, e.CreatedDateTime })
  765. .HasName("PK__BemsMoni__F1139AC41C6A2090");
  766. entity.HasOne(d => d.FacilityType)
  767. .WithMany(p => p.BemsMonitoringPointHistory15min)
  768. .HasForeignKey(d => d.FacilityTypeId)
  769. .OnDelete(DeleteBehavior.ClientSetNull)
  770. .HasConstraintName("FK__BemsMonitoringPointHistory15min__BemsFacilityType");
  771. entity.HasOne(d => d.BemsMonitoringPoint)
  772. .WithMany(p => p.BemsMonitoringPointHistory15min)
  773. .HasForeignKey(d => new { d.SiteId, d.FacilityCode, d.PropertyId })
  774. .OnDelete(DeleteBehavior.ClientSetNull)
  775. .HasConstraintName("FK__BemsMonitoringPointHistory15min__BemsMonitoringPoint");
  776. });
  777. modelBuilder.Entity<BemsMonitoringPointHistory15minRawData>(entity => {
  778. entity.HasKey(e => new { e.SiteId, e.FacilityCode, e.PropertyId, e.CreatedDateTime });
  779. entity.HasIndex(e => e.SiteId)
  780. .HasName("IX_BemsMonitoringPointHistory15minRawData");
  781. entity.HasOne(d => d.FacilityType)
  782. .WithMany(p => p.BemsMonitoringPointHistory15minRawData)
  783. .HasForeignKey(d => d.FacilityTypeId)
  784. .OnDelete(DeleteBehavior.ClientSetNull)
  785. .HasConstraintName("FK__BemsMonitoringPointHistory15minRawData__BemsFacilityType");
  786. entity.HasOne(d => d.BemsMonitoringPoint)
  787. .WithMany(p => p.BemsMonitoringPointHistory15minRawData)
  788. .HasForeignKey(d => new { d.SiteId, d.FacilityCode, d.PropertyId })
  789. .OnDelete(DeleteBehavior.ClientSetNull)
  790. .HasConstraintName("FK__BemsMonitoringPointHistory15minRawData__BemsMonitoringPoint");
  791. });
  792. modelBuilder.Entity<BemsMonitoringPointHistoryDaily>(entity => {
  793. entity.HasKey(e => new { e.SiteId, e.FacilityCode, e.PropertyId, e.CreatedDateTime })
  794. .HasName("PK__BemsMoni__F1139AC43CAC2FE3");
  795. entity.HasOne(d => d.FacilityType)
  796. .WithMany(p => p.BemsMonitoringPointHistoryDaily)
  797. .HasForeignKey(d => d.FacilityTypeId)
  798. .OnDelete(DeleteBehavior.ClientSetNull)
  799. .HasConstraintName("FK__BemsMonitoringPointHistoryDaily__BemsFacilityType");
  800. entity.HasOne(d => d.BemsMonitoringPoint)
  801. .WithMany(p => p.BemsMonitoringPointHistoryDaily)
  802. .HasForeignKey(d => new { d.SiteId, d.FacilityCode, d.PropertyId })
  803. .OnDelete(DeleteBehavior.ClientSetNull)
  804. .HasConstraintName("FK__BemsMonitoringPointHistoryDaily__BemsMonitoringPoint");
  805. });
  806. modelBuilder.Entity<BemsMonitoringPointHistoryHourly>(entity => {
  807. entity.HasKey(e => new { e.SiteId, e.FacilityCode, e.PropertyId, e.CreatedDateTime })
  808. .HasName("PK__BemsMoni__F1139AC470F7816A");
  809. entity.HasOne(d => d.FacilityType)
  810. .WithMany(p => p.BemsMonitoringPointHistoryHourly)
  811. .HasForeignKey(d => d.FacilityTypeId)
  812. .OnDelete(DeleteBehavior.ClientSetNull)
  813. .HasConstraintName("FK__BemsMonitoringPointHistoryHourly__BemsFacilityType");
  814. entity.HasOne(d => d.BemsMonitoringPoint)
  815. .WithMany(p => p.BemsMonitoringPointHistoryHourly)
  816. .HasForeignKey(d => new { d.SiteId, d.FacilityCode, d.PropertyId })
  817. .OnDelete(DeleteBehavior.ClientSetNull)
  818. .HasConstraintName("FK__BemsMonitoringPointHistoryHourly__BemsMonitoringPoint");
  819. });
  820. modelBuilder.Entity<BemsMonitoringPointToAnlaysisType>(entity => {
  821. entity.HasKey(e => new { e.SiteId, e.FacilityTypeId, e.FacilityCode, e.PropertyId, e.AnalysisType })
  822. .HasName("PK__BemsMoni__CFED929570D3FBE0");
  823. entity.HasOne(d => d.FacilityType)
  824. .WithMany(p => p.BemsMonitoringPointToAnlaysisType)
  825. .HasForeignKey(d => d.FacilityTypeId)
  826. .OnDelete(DeleteBehavior.ClientSetNull)
  827. .HasConstraintName("FK__BemsMonitoringPointToAnlaysisType__BemsFacilityType");
  828. entity.HasOne(d => d.BemsAnalysisType)
  829. .WithMany(p => p.BemsMonitoringPointToAnlaysisType)
  830. .HasForeignKey(d => new { d.SiteId, d.AnalysisType })
  831. .OnDelete(DeleteBehavior.ClientSetNull)
  832. .HasConstraintName("FK__BemsMonitoringPo__1372D2FE");
  833. entity.HasOne(d => d.BemsMonitoringPoint)
  834. .WithMany(p => p.BemsMonitoringPointToAnlaysisType)
  835. .HasForeignKey(d => new { d.SiteId, d.FacilityCode, d.PropertyId })
  836. .OnDelete(DeleteBehavior.ClientSetNull)
  837. .HasConstraintName("FK__BemsMonitoringPo__155B1B70");
  838. });
  839. modelBuilder.Entity<BemsNoticePrice>(entity => {
  840. entity.HasKey(e => new { e.SiteId, e.FuelTypeId, e.ApplyDate })
  841. .HasName("PK__BemsNoti__B3C075E75C0AE7A6");
  842. entity.HasOne(d => d.FuelType)
  843. .WithMany(p => p.BemsNoticePrice)
  844. .HasForeignKey(d => d.FuelTypeId)
  845. .OnDelete(DeleteBehavior.ClientSetNull)
  846. .HasConstraintName("FK__BemsNoticePrice__BemsFuelType");
  847. entity.HasOne(d => d.Site)
  848. .WithMany(p => p.BemsNoticePrice)
  849. .HasForeignKey(d => d.SiteId)
  850. .OnDelete(DeleteBehavior.ClientSetNull)
  851. .HasConstraintName("FK__BemsNoticePrice__CmSite");
  852. });
  853. modelBuilder.Entity<BemsNoticePriceBase>(entity => {
  854. entity.HasKey(e => new { e.SiteId, e.FuelTypeId, e.ApplyDate, e.ContractType })
  855. .HasName("PK__BemsNoti__CB7092514F385CDB");
  856. entity.HasOne(d => d.BemsNoticePriceContractType)
  857. .WithMany(p => p.BemsNoticePriceBase)
  858. .HasForeignKey(d => new { d.FuelTypeId, d.ContractType })
  859. .OnDelete(DeleteBehavior.ClientSetNull)
  860. .HasConstraintName("FK__BemsNoticePriceBase__BemsNoticePriceContractType");
  861. entity.HasOne(d => d.BemsNoticePrice)
  862. .WithMany(p => p.BemsNoticePriceBase)
  863. .HasForeignKey(d => new { d.SiteId, d.FuelTypeId, d.ApplyDate })
  864. .OnDelete(DeleteBehavior.ClientSetNull)
  865. .HasConstraintName("FK__BemsNoticePriceBase__BemsNoticePrice");
  866. });
  867. modelBuilder.Entity<BemsNoticePriceContractDataType>(entity => {
  868. entity.HasNoKey();
  869. entity.Property(e => e.Name)
  870. .IsUnicode(false)
  871. .HasComment("계약명");
  872. });
  873. modelBuilder.Entity<BemsNoticePriceContractType>(entity => {
  874. entity.HasKey(e => new { e.FuelTypeId, e.ContractType })
  875. .HasName("PK__BemsNoti__B46C584FEC1EA4CB");
  876. entity.Property(e => e.Name)
  877. .IsUnicode(false)
  878. .HasComment("계약명");
  879. entity.HasOne(d => d.FuelType)
  880. .WithMany(p => p.BemsNoticePriceContractType)
  881. .HasForeignKey(d => d.FuelTypeId)
  882. .OnDelete(DeleteBehavior.ClientSetNull)
  883. .HasConstraintName("FK__BemsNoticePriceContractType__BemsFuelType");
  884. });
  885. modelBuilder.Entity<BemsNoticePriceDetail>(entity => {
  886. entity.HasKey(e => new { e.SiteId, e.FuelTypeId, e.ApplyDate, e.ContractType, e.DataId })
  887. .HasName("PK__BemsNoti__FB4C0F54F0AD4487");
  888. entity.HasOne(d => d.BemsNoticePriceBase)
  889. .WithMany(p => p.BemsNoticePriceDetail)
  890. .HasForeignKey(d => new { d.SiteId, d.FuelTypeId, d.ApplyDate, d.ContractType })
  891. .OnDelete(DeleteBehavior.ClientSetNull)
  892. .HasConstraintName("FK__BemsNoticePriceDetail__BemsNoticePriceBase");
  893. });
  894. modelBuilder.Entity<BemsPeakFacility>(entity => {
  895. entity.HasKey(e => new { e.SiteId, e.MaxDateTime, e.FacilityCode })
  896. .HasName("PK.BemsPeakFacility");
  897. entity.HasOne(d => d.CmFacility)
  898. .WithMany(p => p.BemsPeakFacility)
  899. .HasForeignKey(d => new { d.SiteId, d.FacilityCode })
  900. .OnDelete(DeleteBehavior.ClientSetNull)
  901. .HasConstraintName("FK_BemsPeakFacility_CmFacility");
  902. });
  903. modelBuilder.Entity<BemsPeakHistory>(entity => {
  904. entity.HasKey(e => new { e.SiteId, e.CreatedDateTime })
  905. .HasName("PK_BemsPeakHIstory");
  906. entity.HasOne(d => d.Site)
  907. .WithMany(p => p.BemsPeakHistory)
  908. .HasForeignKey(d => d.SiteId)
  909. .OnDelete(DeleteBehavior.ClientSetNull)
  910. .HasConstraintName("FK_BemsPeakHIstory_CmSite");
  911. });
  912. modelBuilder.Entity<BemsPeakHistoryDaily>(entity => {
  913. entity.HasKey(e => new { e.SiteId, e.CreatedDateTime });
  914. });
  915. modelBuilder.Entity<BemsPeakInfo>(entity => {
  916. entity.Property(e => e.SiteId)
  917. .HasComment("현장 고유번호")
  918. .ValueGeneratedNever();
  919. entity.HasOne(d => d.Site)
  920. .WithOne(p => p.BemsPeakInfo)
  921. .HasForeignKey<BemsPeakInfo>(d => d.SiteId)
  922. .OnDelete(DeleteBehavior.ClientSetNull)
  923. .HasConstraintName("FK_BemsPeakInfo_CmSite");
  924. });
  925. modelBuilder.Entity<BemsPeopleIncrease>(entity => {
  926. entity.HasKey(e => new { e.Date, e.SiteId });
  927. entity.HasOne(d => d.Site)
  928. .WithMany(p => p.BemsPeopleIncrease)
  929. .HasForeignKey(d => d.SiteId)
  930. .OnDelete(DeleteBehavior.ClientSetNull)
  931. .HasConstraintName("FK_BemsPeopleIncrease_CmSite");
  932. });
  933. modelBuilder.Entity<BemsPriceCode>(entity => {
  934. entity.Property(e => e.PriceCode).IsUnicode(false);
  935. entity.Property(e => e.PriceCodeDesc).IsUnicode(false);
  936. entity.Property(e => e.Unit).IsUnicode(false);
  937. entity.HasOne(d => d.FuelType)
  938. .WithMany(p => p.BemsPriceCode)
  939. .HasForeignKey(d => d.FuelTypeId)
  940. .OnDelete(DeleteBehavior.ClientSetNull)
  941. .HasConstraintName("FK_BemsPriceCode_BemsFuelType");
  942. });
  943. modelBuilder.Entity<BemsPriceFormula>(entity => {
  944. entity.HasKey(e => new { e.SiteId, e.PriceTypeId, e.FacilityTypeId, e.FormulaId, e.FacilityCode });
  945. entity.HasOne(d => d.PriceType)
  946. .WithMany(p => p.BemsPriceFormula)
  947. .HasForeignKey(d => d.PriceTypeId)
  948. .OnDelete(DeleteBehavior.ClientSetNull)
  949. .HasConstraintName("FK_BemsPriceFormula_BemsPriceType");
  950. entity.HasOne(d => d.BemsFormula)
  951. .WithMany(p => p.BemsPriceFormula)
  952. .HasForeignKey(d => new { d.SiteId, d.FacilityTypeId, d.FacilityCode, d.FormulaId })
  953. .OnDelete(DeleteBehavior.ClientSetNull)
  954. .HasConstraintName("FK_BemsPriceFormula_BemsFormula");
  955. });
  956. modelBuilder.Entity<BemsPriceMeta>(entity => {
  957. entity.HasKey(e => new { e.PriceTypeId, e.PublishDate });
  958. entity.HasOne(d => d.PriceType)
  959. .WithMany(p => p.BemsPriceMeta)
  960. .HasForeignKey(d => d.PriceTypeId)
  961. .OnDelete(DeleteBehavior.ClientSetNull)
  962. .HasConstraintName("FK_BemsPriceMeta_BemsPriceType");
  963. });
  964. modelBuilder.Entity<BemsPriceType>(entity => {
  965. entity.HasKey(e => e.PriceTypeId)
  966. .HasName("PK_BemsPriceType_1");
  967. entity.HasIndex(e => e.PriceTypeId)
  968. .HasName("IX_BemsPriceType")
  969. .IsUnique();
  970. entity.Property(e => e.PriceTypeId).ValueGeneratedNever();
  971. entity.Property(e => e.PriceTypeIdDesc).IsUnicode(false);
  972. entity.HasOne(d => d.FuelType)
  973. .WithMany(p => p.BemsPriceType)
  974. .HasForeignKey(d => d.FuelTypeId)
  975. .OnDelete(DeleteBehavior.ClientSetNull)
  976. .HasConstraintName("FK_BemsPriceType_BemsFuelType1");
  977. });
  978. modelBuilder.Entity<BemsRentalRate>(entity => {
  979. entity.HasKey(e => new { e.Date, e.SiteId });
  980. entity.HasOne(d => d.Site)
  981. .WithMany(p => p.BemsRentalRate)
  982. .HasForeignKey(d => d.SiteId)
  983. .OnDelete(DeleteBehavior.ClientSetNull)
  984. .HasConstraintName("FK_BemsRentalRate_CmSite");
  985. });
  986. modelBuilder.Entity<BemsReportFormat>(entity => {
  987. entity.HasKey(e => new { e.SiteId, e.ReportFormatId });
  988. entity.HasOne(d => d.CmSite)
  989. .WithMany(p => p.BemsReportFormat)
  990. .HasForeignKey(d => d.SiteId)
  991. .OnDelete(DeleteBehavior.ClientSetNull)
  992. .HasConstraintName("FK_BemsReportFormat_CmSite");
  993. entity.HasOne(d => d.CmBusinessField)
  994. .WithMany(p => p.BemsReportFormat)
  995. .HasForeignKey(d => new { d.BusinessFieldId })
  996. .OnDelete(DeleteBehavior.ClientSetNull)
  997. .HasConstraintName("FK_BemsReportFormat_CmBusinessField");
  998. entity.Property(e => e.FormatName).IsUnicode(false);
  999. });
  1000. modelBuilder.Entity<BemsReportFormatContent>(entity => {
  1001. entity.HasKey(e => new {
  1002. e.SiteId,
  1003. e.ReportFormatId,
  1004. e.ContentId
  1005. });
  1006. entity.Property(e => e.Content).IsUnicode(false);
  1007. entity.HasOne(d => d.BemsReportFormat)
  1008. .WithMany(p => p.BemsReportFormatContent)
  1009. .HasForeignKey(d => new {
  1010. d.SiteId,
  1011. d.ReportFormatId
  1012. })
  1013. .OnDelete(DeleteBehavior.Cascade)
  1014. .HasConstraintName("FK_BemsReportFormatContent_BemsReportFormatContent");
  1015. });
  1016. modelBuilder.Entity<BemsReportFormatToFacility>(entity => {
  1017. entity.HasKey(e => new { e.SiteId, e.ReportFormatId, e.FacilityCode });
  1018. entity.HasOne(d => d.CmFacility)
  1019. .WithMany(p => p.BemsReportFormatToFacility)
  1020. .HasForeignKey(d => new { d.SiteId, d.FacilityCode })
  1021. .OnDelete(DeleteBehavior.ClientSetNull)
  1022. .HasConstraintName("FK_BemsReportFormatToFacility_CmFacility");
  1023. entity.HasOne(d => d.BemsReportFormat)
  1024. .WithMany(p => p.BemsReportFormatToFacility)
  1025. .HasForeignKey(d => new { d.SiteId, d.ReportFormatId })
  1026. .OnDelete(DeleteBehavior.ClientSetNull)
  1027. .HasConstraintName("FK_BemsReportFormatToFacility_BemsReportFormat");
  1028. });
  1029. modelBuilder.Entity<BemsReportHistory>(entity => {
  1030. entity.HasKey(e => new { e.SiteId, e.Seq });
  1031. entity.Property(e => e.Confirm1).IsUnicode(false);
  1032. entity.Property(e => e.Confirm2).IsUnicode(false);
  1033. entity.Property(e => e.FormatName).IsUnicode(false);
  1034. entity.Property(e => e.ReportName).IsUnicode(false);
  1035. entity.Property(e => e.Writer).IsUnicode(false);
  1036. entity.HasOne(d => d.CmFile)
  1037. .WithMany(p => p.BemsReportHistory)
  1038. .HasForeignKey(d => new { d.SiteId, d.FileId })
  1039. .HasConstraintName("FK_BemsReportHistory_CmFile");
  1040. });
  1041. modelBuilder.Entity<BemsReportHistoryContent>(entity => {
  1042. entity.HasKey(e => new { e.SiteId, e.Seq, e.ContentId });
  1043. entity.Property(e => e.Content).IsUnicode(false);
  1044. entity.HasOne(d => d.BemsReportHistory)
  1045. .WithMany(p => p.BemsReportHistoryContent)
  1046. .HasForeignKey(d => new { d.SiteId, d.Seq })
  1047. .OnDelete(DeleteBehavior.Cascade)
  1048. .HasConstraintName("FK_BemsReportHistoryContent_BemsReportHistory");
  1049. });
  1050. modelBuilder.Entity<BemsServiceType>(entity => {
  1051. entity.HasKey(e => e.ServiceTypeId)
  1052. .HasName("PK__BemsServ__0E5C2012D25A3DAA");
  1053. entity.Property(e => e.ServiceTypeId)
  1054. .HasComment("")
  1055. .ValueGeneratedNever();
  1056. });
  1057. modelBuilder.Entity<BemsSitePrice>(entity => {
  1058. entity.HasKey(e => new { e.SiteId, e.FuelTypeId, e.PriceTypeId, e.PriceCode });
  1059. entity.Property(e => e.PriceCode).IsUnicode(false);
  1060. entity.Property(e => e.UseYn).IsUnicode(false);
  1061. entity.HasOne(d => d.FuelType)
  1062. .WithMany(p => p.BemsSitePrice)
  1063. .HasForeignKey(d => d.FuelTypeId)
  1064. .OnDelete(DeleteBehavior.ClientSetNull)
  1065. .HasConstraintName("FK_BemsSitePrice_BemsFuelType");
  1066. entity.HasOne(d => d.PriceCodeNavigation)
  1067. .WithMany(p => p.BemsSitePrice)
  1068. .HasForeignKey(d => d.PriceCode)
  1069. .OnDelete(DeleteBehavior.ClientSetNull)
  1070. .HasConstraintName("FK_BemsSitePrice_BemsPriceCode");
  1071. entity.HasOne(d => d.PriceType)
  1072. .WithMany(p => p.BemsSitePrice)
  1073. .HasForeignKey(d => d.PriceTypeId)
  1074. .OnDelete(DeleteBehavior.ClientSetNull)
  1075. .HasConstraintName("FK_BemsSitePrice_BemsPriceType");
  1076. entity.HasOne(d => d.Site)
  1077. .WithMany(p => p.BemsSitePrice)
  1078. .HasForeignKey(d => d.SiteId)
  1079. .OnDelete(DeleteBehavior.ClientSetNull)
  1080. .HasConstraintName("FK_BemsSitePrice_CmSite1");
  1081. });
  1082. modelBuilder.Entity<BemsSitePriceHistory>(entity => {
  1083. entity.HasKey(e => new { e.SiteId, e.FuelTypeId, e.PriceTypeId, e.PriceCode, e.PayDate })
  1084. .HasName("PK_BemsSitePriceHistory_1");
  1085. entity.Property(e => e.PriceCode).IsUnicode(false);
  1086. entity.Property(e => e.PayDate).IsUnicode(false);
  1087. entity.Property(e => e.PayCharge).IsUnicode(false);
  1088. entity.Property(e => e.PriceValue).IsUnicode(false);
  1089. entity.HasOne(d => d.FuelType)
  1090. .WithMany(p => p.BemsSitePriceHistory)
  1091. .HasForeignKey(d => d.FuelTypeId)
  1092. .OnDelete(DeleteBehavior.ClientSetNull)
  1093. .HasConstraintName("FK_BemsSitePriceHistory_BemsFuelType");
  1094. entity.HasOne(d => d.PriceCodeNavigation)
  1095. .WithMany(p => p.BemsSitePriceHistory)
  1096. .HasForeignKey(d => d.PriceCode)
  1097. .OnDelete(DeleteBehavior.ClientSetNull)
  1098. .HasConstraintName("FK_BemsSitePriceHistory_BemsPriceCode");
  1099. entity.HasOne(d => d.PriceType)
  1100. .WithMany(p => p.BemsSitePriceHistory)
  1101. .HasForeignKey(d => d.PriceTypeId)
  1102. .OnDelete(DeleteBehavior.ClientSetNull)
  1103. .HasConstraintName("FK_BemsSitePriceHistory_BemsPriceType");
  1104. entity.HasOne(d => d.Site)
  1105. .WithMany(p => p.BemsSitePriceHistory)
  1106. .HasForeignKey(d => d.SiteId)
  1107. .OnDelete(DeleteBehavior.ClientSetNull)
  1108. .HasConstraintName("FK_BemsSitePriceHistory_CmSite");
  1109. });
  1110. modelBuilder.Entity<BemsWeatherHourly>(entity => {
  1111. entity.HasKey(e => new { e.SiteId, e.CreatedDate })
  1112. .HasName("PK__BemsWeat__F1B6EF84E39993F1");
  1113. entity.HasOne(d => d.Site)
  1114. .WithMany(p => p.BemsWeatherHourly)
  1115. .HasForeignKey(d => d.SiteId)
  1116. .OnDelete(DeleteBehavior.ClientSetNull)
  1117. .HasConstraintName("FK__BemsWeatherHourly__CmSite");
  1118. });
  1119. modelBuilder.Entity<BemsZone>(entity => {
  1120. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.ZoneId })
  1121. .HasName("PK__BemsZone__58FA93D82DF67563");
  1122. entity.Property(e => e.ZoneId)
  1123. .HasComment("존 번호")
  1124. .ValueGeneratedOnAdd();
  1125. entity.Property(e => e.Name)
  1126. .IsUnicode(false)
  1127. .HasComment("존 명");
  1128. entity.HasOne(d => d.CmBuilding)
  1129. .WithMany(p => p.BemsZone)
  1130. .HasForeignKey(d => new { d.SiteId, d.BuildingId })
  1131. .OnDelete(DeleteBehavior.ClientSetNull)
  1132. .HasConstraintName("FK__BemsZone__CmBuilding");
  1133. });
  1134. modelBuilder.Entity<BemsZoneActivate>(entity => {
  1135. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.ZoneId, e.ServiceTypeId })
  1136. .HasName("PK__BemsZone__FE223E228D7227B8");
  1137. entity.HasOne(d => d.ServiceType)
  1138. .WithMany(p => p.BemsZoneActivate)
  1139. .HasForeignKey(d => d.ServiceTypeId)
  1140. .OnDelete(DeleteBehavior.ClientSetNull)
  1141. .HasConstraintName("FK__BemsZoneActivate__BemsServiceType");
  1142. entity.HasOne(d => d.BemsZone)
  1143. .WithMany(p => p.BemsZoneActivate)
  1144. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.ZoneId })
  1145. .OnDelete(DeleteBehavior.ClientSetNull)
  1146. .HasConstraintName("FK__BemsZoneActivate__BemsZone");
  1147. });
  1148. modelBuilder.Entity<BemsZoneActivateDaily>(entity => {
  1149. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.ZoneId, e.ServiceTypeId, e.CreatedDate })
  1150. .HasName("PK__BemsZone__9056B8877CFE1068");
  1151. entity.HasOne(d => d.BemsZoneActivate)
  1152. .WithMany(p => p.BemsZoneActivateDaily)
  1153. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.ZoneId, d.ServiceTypeId })
  1154. .OnDelete(DeleteBehavior.ClientSetNull)
  1155. .HasConstraintName("FK__BemsZoneActivateDaily__BemsZoneActivate");
  1156. });
  1157. modelBuilder.Entity<CmAlarmAdmin>(entity => {
  1158. entity.HasKey(e => e.SiteId)
  1159. .HasName("PK__CmAlarmA__B9DCB9639249F478");
  1160. entity.Property(e => e.SiteId).ValueGeneratedNever();
  1161. });
  1162. modelBuilder.Entity<CmAnnouncement>(entity => {
  1163. entity.HasKey(e => new { e.SiteId, e.AnnouncementId });
  1164. entity.Property(e => e.AnnouncementId)
  1165. .HasComment("공지사항 고유 번호")
  1166. .ValueGeneratedOnAdd();
  1167. entity.HasOne(d => d.CmBusinessField)
  1168. .WithMany(p => p.CmAnnouncement)
  1169. .HasForeignKey(d => new { d.BusinessFieldId })
  1170. .OnDelete(DeleteBehavior.ClientSetNull)
  1171. .HasConstraintName("FK_CmAnnouncement_CmBusinessField");
  1172. entity.HasOne(d => d.CmFile)
  1173. .WithMany(p => p.CmAnnouncement)
  1174. .HasForeignKey(d => new { d.SiteId, d.FileId })
  1175. .HasConstraintName("FK_CmAnnouncement_CmFile");
  1176. entity.HasOne(d => d.CmUser)
  1177. .WithMany(p => p.CmAnnouncement)
  1178. .HasForeignKey(d => d.RegisterUserId)
  1179. .OnDelete(DeleteBehavior.ClientSetNull)
  1180. .HasConstraintName("FK_CmAnnouncement_CmUser");
  1181. });
  1182. modelBuilder.Entity<CmGuideline>(entity => {
  1183. entity.HasKey(e => new { e.SiteId, e.GuidelineId });
  1184. entity.Property(e => e.GuidelineId)
  1185. .HasComment("지침사항 고유 번호")
  1186. .ValueGeneratedOnAdd();
  1187. entity.HasOne(d => d.CmBusinessField)
  1188. .WithMany(p => p.CmGuideline)
  1189. .HasForeignKey(d => new { d.BusinessFieldId })
  1190. .OnDelete(DeleteBehavior.ClientSetNull)
  1191. .HasConstraintName("FK_CmGuideline_CmBusinessField");
  1192. entity.HasOne(d => d.CmFile)
  1193. .WithMany(p => p.CmGuideline)
  1194. .HasForeignKey(d => new { d.SiteId, d.FileId })
  1195. .HasConstraintName("FK_CmGuideline_CmFile");
  1196. entity.HasOne(d => d.CmUser)
  1197. .WithMany(p => p.CmGuideline)
  1198. .HasForeignKey(d => d.RegisterUserId)
  1199. .OnDelete(DeleteBehavior.ClientSetNull)
  1200. .HasConstraintName("FK_CmGuideline_CmUser");
  1201. });
  1202. modelBuilder.Entity<CmBuilding>(entity => {
  1203. entity.HasKey(e => new { e.SiteId, e.BuildingId });
  1204. entity.Property(e => e.BuildingId)
  1205. .HasComment("빌딩 고유번호")
  1206. .ValueGeneratedOnAdd();
  1207. });
  1208. modelBuilder.Entity<CmBusinessField>(entity => {
  1209. entity.HasKey(e => new { e.BusinessFieldId })
  1210. .HasName("PK__CmBusine__D557D6934E3BC926");
  1211. entity.Property(e => e.BusinessFieldId)
  1212. .HasComment("업무분야 고유번호")
  1213. .ValueGeneratedOnAdd();
  1214. });
  1215. modelBuilder.Entity<CmCompany>(entity => {
  1216. entity.HasKey(e => new { e.SiteId, e.CompanyId })
  1217. .HasName("PK__CmCompan__6B05C8A97624D3C7");
  1218. entity.Property(e => e.CompanyId)
  1219. .HasComment("회사 고유번호")
  1220. .ValueGeneratedOnAdd();
  1221. entity.Property(e => e.AddressZip1)
  1222. .IsFixedLength()
  1223. .HasComment("우편번호 앞자리");
  1224. entity.Property(e => e.AddressZip2)
  1225. .IsFixedLength()
  1226. .HasComment("우편번호 뒷자리");
  1227. entity.HasOne(d => d.Site)
  1228. .WithMany(p => p.CmCompany)
  1229. .HasForeignKey(d => d.SiteId)
  1230. .OnDelete(DeleteBehavior.ClientSetNull)
  1231. .HasConstraintName("FK__CmCompany__SiteI__336AA144");
  1232. entity.HasOne(d => d.CmCompanyType)
  1233. .WithMany(p => p.CmCompany)
  1234. .HasForeignKey(d => new { d.CompanyTypeId })
  1235. .OnDelete(DeleteBehavior.ClientSetNull)
  1236. .HasConstraintName("FK__CmCompany__345EC57D");
  1237. });
  1238. modelBuilder.Entity<CmCompanyType>(entity => {
  1239. entity.HasKey(e => new { e.CompanyTypeId })
  1240. .HasName("PK__CmCompan__FCCA4958BBE3B86E");
  1241. entity.Property(e => e.CompanyTypeId)
  1242. .HasComment("회사 유형번호")
  1243. .ValueGeneratedOnAdd();
  1244. });
  1245. modelBuilder.Entity<CmDepartment>(entity => {
  1246. entity.HasKey(e => new { e.SiteId, e.CompanyId, e.DepartmentId });
  1247. entity.Property(e => e.DepartmentId)
  1248. .ValueGeneratedOnAdd();
  1249. entity.HasOne(d => d.CmCompany)
  1250. .WithMany(p => p.CmDepartment)
  1251. .HasForeignKey(d => new { d.SiteId, d.CompanyId });
  1252. });
  1253. modelBuilder.Entity<CmFacility>(entity => {
  1254. entity.HasKey(e => new { e.SiteId, e.FacilityCode });
  1255. entity.Property(e => e.FacilityCode)
  1256. .ValueGeneratedOnAdd();
  1257. /*
  1258. entity.HasOne(d => d.CmFacilityNavigation)
  1259. .WithMany(p => p.InverseCmFacilityNavigation)
  1260. .HasForeignKey(d => new { d.SiteId, d.ParentFacilityCode });
  1261. */
  1262. });
  1263. modelBuilder.Entity<CmFacilityFile>(entity => {
  1264. entity.HasKey(e => new { e.SiteId, e.FileId });
  1265. entity.Property(e => e.FileId)
  1266. .ValueGeneratedOnAdd();
  1267. entity.HasOne(d => d.CmFacility)
  1268. .WithMany(p => p.CmFacilityFile)
  1269. .HasForeignKey(d => new { d.SiteId, d.FacilityCode })
  1270. .OnDelete(DeleteBehavior.ClientSetNull);
  1271. entity.HasOne(d => d.CmFile)
  1272. .WithOne(p => p.CmFacilityFile)
  1273. .HasForeignKey<CmFacilityFile>(d => new { d.SiteId, d.FileId })
  1274. .OnDelete(DeleteBehavior.ClientSetNull);
  1275. });
  1276. modelBuilder.Entity<CmFacilityTempSet>(entity => {
  1277. entity.HasKey(e => new { e.SiteId, e.FacilityCode });
  1278. entity.HasOne(d => d.Site)
  1279. .WithMany(p => p.CmFacilityTempSet)
  1280. .HasForeignKey(d => d.SiteId);
  1281. entity.HasOne(d => d.CmFacility)
  1282. .WithOne(p => p.CmFacilityTempSet)
  1283. .HasForeignKey<CmFacilityTempSet>(d => new { d.SiteId, d.FacilityCode });
  1284. });
  1285. modelBuilder.Entity<CmFile>(entity => {
  1286. entity.HasKey(e => new { e.SiteId, e.FileId });
  1287. entity.Property(e => e.FileId)
  1288. .HasComment("파일 고유번호")
  1289. .ValueGeneratedOnAdd();
  1290. entity.HasOne(d => d.FileCategory)
  1291. .WithMany(p => p.CmFile)
  1292. .HasForeignKey(d => d.FileCategoryId)
  1293. .OnDelete(DeleteBehavior.ClientSetNull)
  1294. .HasConstraintName("FK__CmFile__CmFileCategory");
  1295. entity.HasOne(d => d.Site)
  1296. .WithMany(p => p.CmFile)
  1297. .HasForeignKey(d => d.SiteId)
  1298. .OnDelete(DeleteBehavior.ClientSetNull)
  1299. .HasConstraintName("FK__CmFile__SiteId__2759D01A");
  1300. });
  1301. modelBuilder.Entity<CmFileCategory>(entity => {
  1302. entity.Property(e => e.FileCategoryId)
  1303. .HasComment("파일 분류 번호")
  1304. .ValueGeneratedNever();
  1305. });
  1306. modelBuilder.Entity<CmFloor>(entity => {
  1307. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.FloorId });
  1308. entity.Property(e => e.FloorId).ValueGeneratedOnAdd();
  1309. });
  1310. modelBuilder.Entity<CmFloorCode>(entity => {
  1311. entity.HasKey(e => new { e.FloorCode });
  1312. entity.Property(e => e.FloorCode).ValueGeneratedOnAdd();
  1313. });
  1314. modelBuilder.Entity<CmRentalStatus>(entity => {
  1315. entity.HasKey(e => new { e.SiteId, e.RentalStatusId });
  1316. entity.Property(e => e.RentalStatusId).ValueGeneratedOnAdd();
  1317. });
  1318. modelBuilder.Entity<CmOrganizationChartStatus>(entity => {
  1319. entity.HasKey(e => new { e.SiteId, e.OrganizationChartStatusId });
  1320. entity.Property(e => e.OrganizationChartStatusId).ValueGeneratedOnAdd();
  1321. });
  1322. modelBuilder.Entity<CmCertificateStatus>(entity => {
  1323. entity.HasKey(e => new { e.SiteId, e.CertificateStatusId });
  1324. entity.Property(e => e.CertificateStatusId).ValueGeneratedOnAdd();
  1325. });
  1326. modelBuilder.Entity<CmLayout>(entity => {
  1327. entity.HasKey(e => new { e.SiteId, e.LayoutId });
  1328. entity.Property(e => e.LayoutId).ValueGeneratedOnAdd();
  1329. });
  1330. modelBuilder.Entity<CmHoliday>(entity => {
  1331. entity.HasKey(e => new { e.SiteId, e.HolidayMonth, e.HolidayDay, e.IsLunar })
  1332. .HasName("PK__CmHolida__747A32C8CDCA1370");
  1333. entity.HasOne(d => d.Site)
  1334. .WithMany(p => p.CmHoliday)
  1335. .HasForeignKey(d => d.SiteId)
  1336. .OnDelete(DeleteBehavior.ClientSetNull)
  1337. .HasConstraintName("FK__CmHoliday__SiteI__0BB1B5A5");
  1338. });
  1339. modelBuilder.Entity<CmHolidayCustom>(entity => {
  1340. entity.HasKey(e => new { e.SiteId, e.HolidayDate })
  1341. .HasName("PK__CmHolida__A6C664FE51F67E3C");
  1342. entity.HasOne(d => d.Site)
  1343. .WithMany(p => p.CmHolidayCustom)
  1344. .HasForeignKey(d => d.SiteId)
  1345. .OnDelete(DeleteBehavior.ClientSetNull)
  1346. .HasConstraintName("FK__CmHoliday__SiteI__10766AC2");
  1347. });
  1348. modelBuilder.Entity<CmHolidayWeekend>(entity => {
  1349. entity.HasKey(e => e.SiteId)
  1350. .HasName("PK__CmHolida__B9DCB963785FEBFE");
  1351. entity.Property(e => e.SiteId)
  1352. .HasComment("현장 고유번호")
  1353. .ValueGeneratedNever();
  1354. entity.HasOne(d => d.Site)
  1355. .WithOne(p => p.CmHolidayWeekend)
  1356. .HasForeignKey<CmHolidayWeekend>(d => d.SiteId)
  1357. .OnDelete(DeleteBehavior.ClientSetNull)
  1358. .HasConstraintName("FK__CmHoliday__SiteI__0D99FE17");
  1359. });
  1360. modelBuilder.Entity<CmMenu>(entity => {
  1361. entity.HasKey(e => new { e.SiteId, e.MenuId });
  1362. entity.HasOne(d => d.Site)
  1363. .WithMany(p => p.CmMenu)
  1364. .HasForeignKey(d => d.SiteId)
  1365. .OnDelete(DeleteBehavior.ClientSetNull)
  1366. .HasConstraintName("FK_CmMenu_CmSite");
  1367. });
  1368. modelBuilder.Entity<CmPartner>(entity => {
  1369. entity.HasKey(e => new { e.SiteId, e.PartnerId });
  1370. entity.Property(e => e.PartnerId)
  1371. .HasComment("협력업체 고유번호")
  1372. .ValueGeneratedOnAdd();
  1373. entity.Property(e => e.AddressZip1)
  1374. .IsFixedLength()
  1375. .HasComment("우편번호1");
  1376. entity.Property(e => e.AddressZip2)
  1377. .IsFixedLength()
  1378. .HasComment("우편번호2");
  1379. entity.HasOne(d => d.PartnerType)
  1380. .WithMany(p => p.CmPartner)
  1381. .HasForeignKey(d => d.PartnerTypeId)
  1382. .OnDelete(DeleteBehavior.ClientSetNull)
  1383. .HasConstraintName("FK_CmPartnerType_CmPartner");
  1384. entity.HasOne(d => d.BusinessField)
  1385. .WithMany(p => p.CmPartner)
  1386. .HasForeignKey(d => new { d.BusinessFieldId })
  1387. .OnDelete(DeleteBehavior.ClientSetNull)
  1388. .HasConstraintName("FK_CmPartner_CmBusinessField");
  1389. });
  1390. modelBuilder.Entity<CmPartnerType>(entity => {
  1391. entity.HasKey(e => e.PartnerTypeId)
  1392. .HasName("PK_CmPartnerType_1");
  1393. });
  1394. modelBuilder.Entity<CmPatrolCourse>(entity => {
  1395. entity.HasKey(e => new { e.SiteId, e.PatrolCourseId });
  1396. entity.Property(e => e.PatrolCourseId)
  1397. .HasComment("순찰코스 고유번호")
  1398. .ValueGeneratedOnAdd();
  1399. entity.HasOne(d => d.Site)
  1400. .WithMany(p => p.CmPatrolCourse)
  1401. .HasForeignKey(d => d.SiteId)
  1402. .OnDelete(DeleteBehavior.ClientSetNull)
  1403. .HasConstraintName("FK_CmPatrolCourse_CmSite");
  1404. });
  1405. modelBuilder.Entity<CmPatrolCoursePos>(entity => {
  1406. entity.HasKey(e => new { e.SiteId, e.PatrolCourseId, e.BuildingId, e.FloorId, e.PosId });
  1407. entity.HasOne(d => d.Site)
  1408. .WithMany(p => p.CmPatrolCoursePos)
  1409. .HasForeignKey(d => d.SiteId)
  1410. .OnDelete(DeleteBehavior.ClientSetNull)
  1411. .HasConstraintName("FK_CmPatrolCoursePos_CmSite");
  1412. entity.HasOne(d => d.CmPatrolCourse)
  1413. .WithMany(p => p.CmPatrolCoursePos)
  1414. .HasForeignKey(d => new { d.SiteId, d.PatrolCourseId })
  1415. .OnDelete(DeleteBehavior.ClientSetNull)
  1416. .HasConstraintName("FK_CmPatrolCoursePos_CmPatrolCourse");
  1417. });
  1418. modelBuilder.Entity<CmPatrolGroup>(entity => {
  1419. entity.HasKey(e => new { e.SiteId, e.PatrolGroupId });
  1420. entity.Property(e => e.PatrolGroupId)
  1421. .HasComment("순찰 그룹번호")
  1422. .ValueGeneratedOnAdd();
  1423. entity.HasOne(d => d.Site)
  1424. .WithMany(p => p.CmPatrolGroup)
  1425. .HasForeignKey(d => d.SiteId)
  1426. .OnDelete(DeleteBehavior.ClientSetNull)
  1427. .HasConstraintName("FK_CmPatrolGroup_CmSite");
  1428. });
  1429. modelBuilder.Entity<CmPatrolGroupUser>(entity => {
  1430. entity.HasKey(e => new { e.SiteId, e.PatrolGroupId, e.UserId });
  1431. entity.HasOne(d => d.CmPatrolGroup)
  1432. .WithMany(p => p.CmPatrolGroupUser)
  1433. .HasForeignKey(d => new { d.SiteId, d.PatrolGroupId })
  1434. .OnDelete(DeleteBehavior.ClientSetNull)
  1435. .HasConstraintName("FK_CmPatrolGroupUser_CmPatrolGroup");
  1436. entity.HasOne(d => d.CmUser)
  1437. .WithMany(p => p.CmPatrolGroupUser)
  1438. .HasForeignKey(d => d.UserId)
  1439. .OnDelete(DeleteBehavior.ClientSetNull)
  1440. .HasConstraintName("FK_CmPatrolGroupUser_CmUser");
  1441. });
  1442. modelBuilder.Entity<CmPatrolHistory>(entity => {
  1443. entity.HasKey(e => e.PatrolHistoryId)
  1444. .HasName("PK_CmPatrolHistory_1");
  1445. entity.Property(e => e.ResultDesc)
  1446. .IsUnicode(false)
  1447. .HasComment("특이 사항");
  1448. entity.HasOne(d => d.Site)
  1449. .WithMany(p => p.CmPatrolHistory)
  1450. .HasForeignKey(d => d.SiteId)
  1451. .OnDelete(DeleteBehavior.ClientSetNull)
  1452. .HasConstraintName("FK_CmPatrolHistory_CmSite");
  1453. entity.HasOne(d => d.CmPatrolType)
  1454. .WithMany(p => p.CmPatrolHistory)
  1455. .HasForeignKey(d => new { d.SiteId, d.ResultTypeId })
  1456. .OnDelete(DeleteBehavior.ClientSetNull)
  1457. .HasConstraintName("FK_CmPatrolHistory_CmPatrolType");
  1458. entity.HasOne(d => d.S)
  1459. .WithMany(p => p.CmPatrolHistory)
  1460. .HasForeignKey(d => new { d.SiteId, d.ScheduleId })
  1461. .OnDelete(DeleteBehavior.ClientSetNull)
  1462. .HasConstraintName("FK_CmPatrolHistory_CmPatrolSchedule");
  1463. });
  1464. modelBuilder.Entity<CmPatrolHistoryPos>(entity => {
  1465. entity.HasKey(e => e.MId)
  1466. .HasName("PK_CmPatrolHistoryPos_1");
  1467. entity.HasOne(d => d.Site)
  1468. .WithMany(p => p.CmPatrolHistoryPos)
  1469. .HasForeignKey(d => d.SiteId)
  1470. .OnDelete(DeleteBehavior.ClientSetNull)
  1471. .HasConstraintName("FK_CmPatrolHistoryPos_CmSite");
  1472. entity.HasOne(d => d.CmPatrolPos)
  1473. .WithMany(p => p.CmPatrolHistoryPos)
  1474. .HasForeignKey(d => new { d.SiteId, d.PosId })
  1475. .OnDelete(DeleteBehavior.ClientSetNull)
  1476. .HasConstraintName("FK_CmPatrolHistoryPos_CmPatrolPos");
  1477. entity.HasOne(d => d.CmPatrolType)
  1478. .WithMany(p => p.CmPatrolHistoryPos)
  1479. .HasForeignKey(d => new { d.SiteId, d.ResultType })
  1480. .OnDelete(DeleteBehavior.ClientSetNull)
  1481. .HasConstraintName("FK_CmPatrolHistoryPos_CmPatrolType");
  1482. });
  1483. modelBuilder.Entity<CmPatrolPlan>(entity => {
  1484. entity.HasKey(e => new { e.SiteId, e.PatrolPlanId });
  1485. entity.Property(e => e.PatrolPlanId)
  1486. .HasComment("순찰 계획 고유번호")
  1487. .ValueGeneratedOnAdd();
  1488. entity.Property(e => e.Name)
  1489. .IsUnicode(false)
  1490. .HasComment("순찰계획 명");
  1491. entity.Property(e => e.PlanDesc)
  1492. .IsUnicode(false)
  1493. .HasComment("설명");
  1494. entity.HasOne(d => d.Site)
  1495. .WithMany(p => p.CmPatrolPlan)
  1496. .HasForeignKey(d => d.SiteId)
  1497. .OnDelete(DeleteBehavior.ClientSetNull)
  1498. .HasConstraintName("FK_CmPatrolPlan_CmSite");
  1499. entity.HasOne(d => d.CmPatrolCourse)
  1500. .WithMany(p => p.CmPatrolPlan)
  1501. .HasForeignKey(d => new { d.SiteId, d.CourseId })
  1502. .OnDelete(DeleteBehavior.ClientSetNull)
  1503. .HasConstraintName("FK_CmPatrolPlan_CmPatrolCourse");
  1504. entity.HasOne(d => d.CmPatrolGroup)
  1505. .WithMany(p => p.CmPatrolPlan)
  1506. .HasForeignKey(d => new { d.SiteId, d.GroupId })
  1507. .OnDelete(DeleteBehavior.ClientSetNull)
  1508. .HasConstraintName("FK_CmPatrolPlan_CmPatrolGroup");
  1509. });
  1510. modelBuilder.Entity<CmPatrolPos>(entity => {
  1511. entity.HasKey(e => new { e.SiteId, e.PosId })
  1512. .HasName("PK_CmPatrolPos_1");
  1513. entity.HasIndex(e => new { e.SiteId, e.BuildingId, e.FloorId, e.Name })
  1514. .HasName("UQ__CmPatrol__E9B4630E47C9E6E0")
  1515. .IsUnique();
  1516. entity.Property(e => e.PosId)
  1517. .HasComment("지점 ID")
  1518. .ValueGeneratedOnAdd();
  1519. entity.HasOne(d => d.Site)
  1520. .WithMany(p => p.CmPatrolPos)
  1521. .HasForeignKey(d => d.SiteId)
  1522. .OnDelete(DeleteBehavior.ClientSetNull)
  1523. .HasConstraintName("FK_CmPatrolPos_CmSite");
  1524. entity.HasOne(d => d.CmBuilding)
  1525. .WithMany(p => p.CmPatrolPos)
  1526. .HasForeignKey(d => new { d.SiteId, d.BuildingId })
  1527. .OnDelete(DeleteBehavior.ClientSetNull)
  1528. .HasConstraintName("FK_CmPatrolPos_CmBuilding");
  1529. entity.HasOne(d => d.CmFloor)
  1530. .WithMany(p => p.CmPatrolPos)
  1531. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.FloorId })
  1532. .OnDelete(DeleteBehavior.ClientSetNull)
  1533. .HasConstraintName("FK_CmPatrolPos_CmFloor");
  1534. });
  1535. modelBuilder.Entity<CmPatrolSchedule>(entity => {
  1536. entity.HasKey(e => new { e.SiteId, e.ScheduleId });
  1537. entity.Property(e => e.ScheduleId)
  1538. .HasComment("순찰 일정 고유번호 ")
  1539. .ValueGeneratedOnAdd();
  1540. entity.Property(e => e.Name)
  1541. .IsUnicode(false)
  1542. .HasComment("순찰 일정 명");
  1543. entity.Property(e => e.ScheduleDesc)
  1544. .IsUnicode(false)
  1545. .HasComment("설명");
  1546. entity.HasOne(d => d.Site)
  1547. .WithMany(p => p.CmPatrolSchedule)
  1548. .HasForeignKey(d => d.SiteId)
  1549. .OnDelete(DeleteBehavior.ClientSetNull)
  1550. .HasConstraintName("FK_CmPatrolSchedule_CmSite");
  1551. entity.HasOne(d => d.CmPatrolPlan)
  1552. .WithMany(p => p.CmPatrolSchedule)
  1553. .HasForeignKey(d => new { d.SiteId, d.PlanId })
  1554. .OnDelete(DeleteBehavior.ClientSetNull)
  1555. .HasConstraintName("FK_CmPatrolSchedule_CmPatrolPlan");
  1556. });
  1557. modelBuilder.Entity<CmPatrolType>(entity => {
  1558. entity.HasKey(e => new { e.SiteId, e.PatrolTypeId });
  1559. entity.HasIndex(e => new { e.SiteId, e.Name })
  1560. .HasName("UQ__CmPatrol__DEEBE12DD038AE1C")
  1561. .IsUnique();
  1562. entity.Property(e => e.PatrolTypeId)
  1563. .HasComment("순찰결과 코드")
  1564. .ValueGeneratedOnAdd();
  1565. entity.HasOne(d => d.Site)
  1566. .WithMany(p => p.CmPatrolType)
  1567. .HasForeignKey(d => d.SiteId)
  1568. .OnDelete(DeleteBehavior.ClientSetNull)
  1569. .HasConstraintName("FK_CmPatrolType_CmSite");
  1570. });
  1571. modelBuilder.Entity<CmPosition>(entity => {
  1572. entity.HasKey(e => new { e.PositionId })
  1573. .HasName("PK__CmUserPo__3FD700C45CBED7EA");
  1574. entity.Property(e => e.PositionId)
  1575. .HasComment("직급 코드")
  1576. .ValueGeneratedOnAdd();
  1577. });
  1578. modelBuilder.Entity<CmServiceEnergyCalcDay>(entity => {
  1579. entity.HasKey(e => new { e.SiteId, e.CalDate, e.ServiceTypeId });
  1580. });
  1581. modelBuilder.Entity<CmServiceEnergyCalcMonth>(entity => {
  1582. entity.HasKey(e => new { e.CalDate, e.ServiceTypeId, e.SiteId });
  1583. });
  1584. modelBuilder.Entity<CmSite>(entity => {
  1585. entity.HasKey(e => e.SiteId);
  1586. entity.Property(e => e.SiteId)
  1587. .ValueGeneratedOnAdd();
  1588. entity.Property(e => e.AddressZip1)
  1589. .IsFixedLength()
  1590. .HasComment("현장 주소 우편번호 1");
  1591. entity.Property(e => e.AddressZip2)
  1592. .IsFixedLength()
  1593. .HasComment("현장 주소 우편번호 2");
  1594. });
  1595. modelBuilder.Entity<CmSunrise>(entity => {
  1596. entity.HasNoKey();
  1597. });
  1598. modelBuilder.Entity<CmSunriseSunset>(entity => {
  1599. entity.HasNoKey();
  1600. });
  1601. modelBuilder.Entity<CmUser>(entity => {
  1602. entity.Property(e => e.HomeZip1)
  1603. .IsUnicode(false)
  1604. .IsFixedLength()
  1605. .HasComment("사용자 우편번호 1");
  1606. entity.Property(e => e.HomeZip2)
  1607. .IsUnicode(false)
  1608. .IsFixedLength()
  1609. .HasComment("사용자 우편번호 2");
  1610. entity.HasOne(d => d.CmBusinessField)
  1611. .WithMany(p => p.CmUser)
  1612. .HasForeignKey(d => new { d.BusinessFieldId })
  1613. .HasConstraintName("FK_CmUser_CmBusinessField");
  1614. entity.HasOne(d => d.CmCompany)
  1615. .WithMany(p => p.CmUser)
  1616. .HasForeignKey(d => new { d.SiteId, d.CompanyId })
  1617. .HasConstraintName("FK_CmUser_CmCompany");
  1618. entity.HasOne(d => d.CmPosition)
  1619. .WithMany(p => p.CmUser)
  1620. .HasForeignKey(d => new { d.PositionId })
  1621. .HasConstraintName("FK_CmUser_CmPosition");
  1622. entity.HasOne(d => d.CmUserGroup)
  1623. .WithMany(p => p.CmUser)
  1624. .HasForeignKey(d => new { d.SiteId, d.UserGroupId })
  1625. .HasConstraintName("FK_CmUser_CmUserGroup");
  1626. entity.HasOne(d => d.CmDepartment)
  1627. .WithMany(p => p.CmUser)
  1628. .HasForeignKey(d => new { d.SiteId, d.CompanyId, d.DepartmentId })
  1629. .HasConstraintName("FK_CmUser_CmDepartment");
  1630. });
  1631. modelBuilder.Entity<CmUserGroup>(entity => {
  1632. entity.HasKey(e => new { e.SiteId, e.UserGroupId })
  1633. .HasName("PK__CmUserGr__089516558C3D97B5");
  1634. entity.Property(e => e.UserGroupId)
  1635. .HasComment("사용자 그룹 고유번호")
  1636. .ValueGeneratedOnAdd();
  1637. entity.HasOne(d => d.Site)
  1638. .WithMany(p => p.CmUserGroup)
  1639. .HasForeignKey(d => d.SiteId)
  1640. .OnDelete(DeleteBehavior.ClientSetNull)
  1641. .HasConstraintName("FK__CmUserGro__SiteI__53D770D6");
  1642. });
  1643. modelBuilder.Entity<CmUserGroupPermission>(entity => {
  1644. entity.HasKey(e => new { e.SiteId, e.UserGroupId, e.MenuId })
  1645. .HasName("PK__CmUserGr__395C888790DBCBFC");
  1646. entity.HasOne(d => d.CmUserGroup)
  1647. .WithMany(p => p.CmUserGroupPermission)
  1648. .HasForeignKey(d => new { d.SiteId, d.UserGroupId })
  1649. .HasConstraintName("FK__CmUserGroupPermission__CmUserGroup");
  1650. });
  1651. modelBuilder.Entity<CmUserLoginHistory>(entity => {
  1652. entity.HasKey(e => e.LoginHistoryId)
  1653. .HasName("PK_CmUserLoginHistory_1");
  1654. entity.HasOne(d => d.CmUser)
  1655. .WithMany(p => p.CmUserLoginHistory)
  1656. .HasForeignKey(d => d.UserId)
  1657. .OnDelete(DeleteBehavior.ClientSetNull)
  1658. .HasConstraintName("FK_CmUserLoginHistory_CmUser");
  1659. });
  1660. modelBuilder.Entity<CmUserToLicense>(entity => {
  1661. entity.HasKey(e => new { e.SiteId, e.UserId, e.LicenseId })
  1662. .HasName("PK__CmUserTo__EBD6E3A7BBDAF8DE");
  1663. entity.HasOne(d => d.FmsLicense)
  1664. .WithMany(p => p.CmUserToLicense)
  1665. .HasForeignKey(d => new { d.SiteId, d.LicenseId })
  1666. .OnDelete(DeleteBehavior.ClientSetNull)
  1667. .HasConstraintName("FK__CmUserToLicense__FmsLicense");
  1668. entity.HasOne(d => d.CmUser)
  1669. .WithMany(p => p.CmUserToLicense)
  1670. .HasForeignKey(d => d.UserId)
  1671. .OnDelete(DeleteBehavior.ClientSetNull)
  1672. .HasConstraintName("FK__CmUserToLicense__CmUser");
  1673. });
  1674. modelBuilder.Entity<CmZone>(entity => {
  1675. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.FloorId, e.ZoneId });
  1676. entity.Property(e => e.ZoneId).ValueGeneratedOnAdd();
  1677. // entity.HasOne(d => d.CmBuilding)
  1678. // .WithMany(p => p.CmZone)
  1679. // .HasForeignKey(d => new { d.SiteId, d.BuildingId })
  1680. // .OnDelete(DeleteBehavior.ClientSetNull)
  1681. // .HasConstraintName("FK__CmZone__CmBuilding");
  1682. // entity.HasOne(d => d.CmFloor)
  1683. // .WithMany(p => p.CmZone)
  1684. // .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.FloorId })
  1685. // .OnDelete(DeleteBehavior.ClientSetNull)
  1686. // .HasConstraintName("FK__CmLocation__3DE82FB7");
  1687. });
  1688. modelBuilder.Entity<CmZoneTempHumiSet>(entity => {
  1689. entity.HasKey(e => new { e.SiteId, e.BuildingId, e.FloorId, e.ZoneId });
  1690. entity.HasOne(d => d.Site)
  1691. .WithMany(p => p.CmZoneTempHumiSet)
  1692. .HasForeignKey(d => d.SiteId)
  1693. .OnDelete(DeleteBehavior.ClientSetNull)
  1694. .HasConstraintName("FK_CmZoneTempHumiSet_CmSite");
  1695. entity.HasOne(d => d.CmBuilding)
  1696. .WithMany(p => p.CmZoneTempHumiSet)
  1697. .HasForeignKey(d => new { d.SiteId, d.BuildingId })
  1698. .OnDelete(DeleteBehavior.ClientSetNull)
  1699. .HasConstraintName("FK_CmZoneTempHumiSet_CmBuilding");
  1700. entity.HasOne(d => d.CmFloor)
  1701. .WithMany(p => p.CmZoneTempHumiSet)
  1702. .HasForeignKey(d => new { d.SiteId, d.BuildingId, d.FloorId })
  1703. .OnDelete(DeleteBehavior.ClientSetNull)
  1704. .HasConstraintName("FK_CmZoneTempHumiSet_CmFloor");
  1705. entity.HasOne(d => d.CmZone)
  1706. .WithOne(p => p.CmZoneTempHumiSet)
  1707. .HasForeignKey<CmZoneTempHumiSet>(d => new { d.SiteId, d.BuildingId, d.FloorId, d.ZoneId })
  1708. .OnDelete(DeleteBehavior.ClientSetNull)
  1709. .HasConstraintName("FK_CmZoneTempHumiSet_CmZone");
  1710. });
  1711. modelBuilder.Entity<Cols>(entity => {
  1712. entity.HasNoKey();
  1713. entity.ToView("Cols");
  1714. entity.Property(e => e.ColLen).IsUnicode(false);
  1715. entity.Property(e => e.ColTypeCode).IsUnicode(false);
  1716. entity.Property(e => e.ColumnDesc).IsUnicode(false);
  1717. entity.Property(e => e.ColumnName).IsUnicode(false);
  1718. entity.Property(e => e.IsPk).IsUnicode(false);
  1719. entity.Property(e => e.SystemDivision).IsUnicode(false);
  1720. entity.Property(e => e.TableDesc).IsUnicode(false);
  1721. entity.Property(e => e.TableName).IsUnicode(false);
  1722. entity.Property(e => e.TableOrder).IsUnicode(false);
  1723. });
  1724. modelBuilder.Entity<FmsAccident>(entity => {
  1725. entity.HasKey(e => new { e.SiteId, e.AccidentId });
  1726. entity.Property(e => e.AccidentId)
  1727. .HasComment("사고 고유번호")
  1728. .ValueGeneratedOnAdd();
  1729. });
  1730. modelBuilder.Entity<FmsAccidentCodeType>(entity => {
  1731. entity.HasKey(e => new { e.AccidentTypeId });
  1732. entity.Property(e => e.AccidentTypeId)
  1733. .HasComment("사고 코드")
  1734. .ValueGeneratedOnAdd();
  1735. entity.Property(e => e.IsUse)
  1736. .HasDefaultValueSql("((1))")
  1737. .HasComment("사용 유무");
  1738. });
  1739. modelBuilder.Entity<FmsComplaints>(entity => {
  1740. entity.HasKey(e => new { e.SiteId, e.ComplaintId });
  1741. entity.Property(e => e.ComplaintId)
  1742. .HasComment("민원 고유번호")
  1743. .ValueGeneratedOnAdd();
  1744. });
  1745. modelBuilder.Entity<FmsComplaintCodeType>(entity => {
  1746. entity.HasKey(e => new { e.ComplaintTypeId });
  1747. entity.Property(e => e.ComplaintTypeId)
  1748. .HasComment("민원 코드")
  1749. .ValueGeneratedOnAdd();
  1750. entity.Property(e => e.IsUse)
  1751. .HasDefaultValueSql("((1))")
  1752. .HasComment("사용 유무");
  1753. });
  1754. modelBuilder.Entity<FmsBudget>(entity => {
  1755. entity.HasKey(e => new { e.SiteId, e.Year })
  1756. .HasName("PK_FmsBudget_2");
  1757. });
  1758. modelBuilder.Entity<FmsBudgetCodeClass>(entity => {
  1759. entity.HasKey(e => new { e.SiteId, e.BudgetClassId });
  1760. entity.Property(e => e.BudgetClassId)
  1761. .HasComment("예산편성 분류 코드")
  1762. .ValueGeneratedOnAdd();
  1763. entity.Property(e => e.IsUse)
  1764. .HasDefaultValueSql("((1))")
  1765. .HasComment("사용유무");
  1766. });
  1767. modelBuilder.Entity<FmsBudgetDetail>(entity => {
  1768. entity.HasKey(e => new { e.SiteId, e.Year, e.BudgetClassId, e.ParentBudgetClassId })
  1769. .HasName("PK_FmsBudget");
  1770. entity.Property(e => e.IsUse)
  1771. .HasDefaultValueSql("((1))")
  1772. .HasComment("사용유무");
  1773. entity.HasOne(d => d.FmsBudgetCodeClass)
  1774. .WithMany(p => p.FmsBudgetDetail)
  1775. .HasForeignKey(d => new { d.SiteId, d.BudgetClassId })
  1776. .OnDelete(DeleteBehavior.ClientSetNull)
  1777. .HasConstraintName("FK_FmsBudgetDetail_FmsBudgetCodeClass");
  1778. entity.HasOne(d => d.FmsBudget)
  1779. .WithMany(p => p.FmsBudgetDetail)
  1780. .HasForeignKey(d => new { d.SiteId, d.Year })
  1781. .HasConstraintName("FK_FmsBudgetDetail_FmsBudget");
  1782. });
  1783. modelBuilder.Entity<FmsBudgetDetailExecution>(entity => {
  1784. entity.HasKey(e => new { e.SiteId, e.Year, e.BudgetClassId, e.ParentBudgetClassId, e.Month });
  1785. entity.HasOne(d => d.FmsBudgetDetail)
  1786. .WithMany(p => p.FmsBudgetDetailExecution)
  1787. .HasForeignKey(d => new { d.SiteId, d.Year, d.BudgetClassId, d.ParentBudgetClassId })
  1788. .OnDelete(DeleteBehavior.ClientSetNull)
  1789. .HasConstraintName("FK_FmsBudgetDetailExecution_FmsBudgetDetail");
  1790. });
  1791. modelBuilder.Entity<FmsCompanyEstimationCodeClass>(entity => {
  1792. entity.HasKey(e => new { e.SiteId, e.CompanyEstimationClassId });
  1793. entity.Property(e => e.CompanyEstimationClassId)
  1794. .HasComment("평가결과 코드")
  1795. .ValueGeneratedOnAdd();
  1796. });
  1797. modelBuilder.Entity<FmsConstruction>(entity => {
  1798. entity.HasKey(e => new { e.SiteId, e.ConstructionId });
  1799. entity.Property(e => e.ConstructionId)
  1800. .HasComment("공사 계약 고유번호")
  1801. .ValueGeneratedOnAdd();
  1802. entity.HasOne(d => d.Progress)
  1803. .WithMany(p => p.FmsConstruction)
  1804. .HasForeignKey(d => d.ProgressId)
  1805. .OnDelete(DeleteBehavior.ClientSetNull)
  1806. .HasConstraintName("FK_FmsConstruction_FmsConstructionCodeProgress");
  1807. entity.HasOne(d => d.FmsConstructionCodeType)
  1808. .WithMany(p => p.FmsConstruction)
  1809. .HasForeignKey(d => new { d.SiteId, d.ConstructionTypeId })
  1810. .OnDelete(DeleteBehavior.ClientSetNull)
  1811. .HasConstraintName("FK_FmsConstruction_FmsConstructionCodeType");
  1812. entity.HasOne(d => d.CmFile)
  1813. .WithMany(p => p.FmsConstructionCmFile)
  1814. .HasForeignKey(d => new { d.SiteId, d.FileId1 })
  1815. .HasConstraintName("FK_FmsConstruction_CmFile1");
  1816. entity.HasOne(d => d.CmFileNavigation)
  1817. .WithMany(p => p.FmsConstructionCmFileNavigation)
  1818. .HasForeignKey(d => new { d.SiteId, d.FileId2 })
  1819. .HasConstraintName("FK_FmsConstruction_CmFile2");
  1820. entity.HasOne(d => d.CmFile1)
  1821. .WithMany(p => p.FmsConstructionCmFile1)
  1822. .HasForeignKey(d => new { d.SiteId, d.FileId3 })
  1823. .HasConstraintName("FK_FmsConstruction_CmFile3");
  1824. entity.HasOne(d => d.CmPartner)
  1825. .WithMany(p => p.FmsConstruction)
  1826. .HasForeignKey(d => new { d.SiteId, d.PartnerId })
  1827. .OnDelete(DeleteBehavior.ClientSetNull)
  1828. .HasConstraintName("FK_FmsConstruction_CmPartner");
  1829. });
  1830. modelBuilder.Entity<FmsConstructionCodeProgress>(entity => {
  1831. entity.Property(e => e.ProgressId)
  1832. .HasComment("진행상태 코드")
  1833. .ValueGeneratedNever();
  1834. });
  1835. modelBuilder.Entity<FmsConstructionCodeType>(entity => {
  1836. entity.HasKey(e => new { e.SiteId, e.ConstructionTypeId });
  1837. entity.Property(e => e.ConstructionTypeId)
  1838. .HasComment("공사타입 코드")
  1839. .ValueGeneratedOnAdd();
  1840. });
  1841. modelBuilder.Entity<FmsConstructionEstimation>(entity => {
  1842. entity.HasKey(e => new { e.SiteId, e.ConstructionId })
  1843. .HasName("PK_FmsConstructionEstimation_1");
  1844. entity.HasOne(d => d.FmsConstruction)
  1845. .WithOne(p => p.FmsConstructionEstimation)
  1846. .HasForeignKey<FmsConstructionEstimation>(d => new { d.SiteId, d.ConstructionId })
  1847. .OnDelete(DeleteBehavior.ClientSetNull)
  1848. .HasConstraintName("FK_FmsConstructionEstimation_FmsConstruction");
  1849. entity.HasOne(d => d.CmUser)
  1850. .WithMany(p => p.FmsConstructionEstimation)
  1851. .HasForeignKey(d => d.EstimateUserId)
  1852. .OnDelete(DeleteBehavior.ClientSetNull)
  1853. .HasConstraintName("FK_FmsConstructionEstimation_CmUser");
  1854. });
  1855. modelBuilder.Entity<FmsContract>(entity => {
  1856. entity.HasKey(e => new { e.SiteId, e.ContractId });
  1857. entity.Property(e => e.ContractId)
  1858. .HasComment("계약체결 고유번호")
  1859. .ValueGeneratedOnAdd();
  1860. entity.HasOne(d => d.PartnerType)
  1861. .WithMany(p => p.FmsContract)
  1862. .HasForeignKey(d => d.PartnerTypeId)
  1863. .HasConstraintName("FK_FmsContract_CmPartnerType");
  1864. entity.HasOne(d => d.FmsContractClass)
  1865. .WithMany(p => p.FmsContract)
  1866. .HasForeignKey(d => new { d.ContractClassId })
  1867. .HasConstraintName("FK_FmsContract_FmsContractClass");
  1868. entity.HasOne(d => d.FmsContractMethod)
  1869. .WithMany(p => p.FmsContract)
  1870. .HasForeignKey(d => new { d.ContractMethodId })
  1871. .HasConstraintName("FK_FmsContract_FmsContractMethod");
  1872. entity.HasOne(d => d.FmsContractType)
  1873. .WithMany(p => p.FmsContract)
  1874. .HasForeignKey(d => new { d.ContractTypeId })
  1875. .HasConstraintName("FK_FmsContract_FmsContractType");
  1876. entity.HasOne(d => d.CmPartner)
  1877. .WithMany(p => p.FmsContract)
  1878. .HasForeignKey(d => new { d.SiteId, d.PartnerId })
  1879. .HasConstraintName("FK_FmsContract_CmPartner");
  1880. entity.HasOne(d => d.FmsPaymentType)
  1881. .WithMany(p => p.FmsContract)
  1882. .HasForeignKey(d => new { d.PaymentTypeId })
  1883. .HasConstraintName("FK_FmsContract_FmsPaymentType");
  1884. // entity.HasOne(d => d.CmFile)
  1885. // .WithMany(p => p.FmsContract)
  1886. // .HasForeignKey(d => new { d.SiteId, d.FileId })
  1887. // .HasConstraintName("FK_FmsContract_CmFile");
  1888. });
  1889. modelBuilder.Entity<FmsContractClass>(entity => {
  1890. entity.HasKey(e => new { e.ContractClassId });
  1891. entity.Property(e => e.ContractClassId)
  1892. .HasComment("근무형태 코드")
  1893. .ValueGeneratedOnAdd();
  1894. });
  1895. modelBuilder.Entity<FmsContractMethod>(entity => {
  1896. entity.HasKey(e => new { e.ContractMethodId });
  1897. entity.Property(e => e.ContractMethodId)
  1898. .HasComment("계약 방법 코드")
  1899. .ValueGeneratedOnAdd();
  1900. });
  1901. modelBuilder.Entity<FmsContractType>(entity => {
  1902. entity.HasKey(e => new { e.ContractTypeId });
  1903. entity.Property(e => e.ContractTypeId)
  1904. .HasComment("계약 종류 코드")
  1905. .ValueGeneratedOnAdd();
  1906. });
  1907. modelBuilder.Entity<FmsDailyCheckReport>(entity => {
  1908. entity.HasKey(e => new { e.SiteId, e.DailyCheckReportId });
  1909. entity.Property(e => e.DailyCheckReportId)
  1910. .HasComment("")
  1911. .ValueGeneratedOnAdd();
  1912. entity.HasOne(d => d.CmUser)
  1913. .WithMany(p => p.FmsDailyCheckReport)
  1914. .HasForeignKey(d => d.RegisterUserId)
  1915. .OnDelete(DeleteBehavior.ClientSetNull)
  1916. .HasConstraintName("FK_FmsDailyCheckReport_CmUser");
  1917. });
  1918. modelBuilder.Entity<FmsMonthlyReport>(entity => {
  1919. entity.HasKey(e => new { e.SiteId, e.AddDate, e.BusinessFieldId });
  1920. });
  1921. modelBuilder.Entity<FmsDailyReport>(entity => {
  1922. entity.HasKey(e => new { e.SiteId, e.AddDate, e.BusinessFieldId });
  1923. entity.Property(e => e.Datas)
  1924. .IsUnicode(false)
  1925. .HasComment("추가내용");
  1926. entity.HasOne(d => d.CmBusinessField)
  1927. .WithMany(p => p.FmsDailyReport)
  1928. .HasForeignKey(d => new { d.BusinessFieldId })
  1929. .OnDelete(DeleteBehavior.ClientSetNull)
  1930. .HasConstraintName("FK_FmsDailyReport_CmBusinessField");
  1931. entity.HasOne(d => d.CmUser)
  1932. .WithMany(p => p.FmsDailyReport)
  1933. .HasForeignKey(d => d.RegisterUserId)
  1934. .OnDelete(DeleteBehavior.ClientSetNull)
  1935. .HasConstraintName("FK_FmsDailyReport_CmUser");
  1936. });
  1937. modelBuilder.Entity<FmsDailyStoredReleaseStatusView>(entity => {
  1938. entity.HasNoKey();
  1939. entity.ToView("FmsDailyStoredReleaseStatusView");
  1940. });
  1941. modelBuilder.Entity<FmsDrawing>(entity => {
  1942. entity.HasKey(e => new { e.SiteId, e.DrawingId });
  1943. entity.Property(e => e.DrawingId)
  1944. .HasComment("도면 고유 번호")
  1945. .ValueGeneratedOnAdd();
  1946. });
  1947. modelBuilder.Entity<FmsDrawingCodeGroup>(entity => {
  1948. entity.HasKey(e => new { e.DrawingGroupId });
  1949. entity.Property(e => e.DrawingGroupId)
  1950. .HasComment("도면 그룹 고유번호")
  1951. .ValueGeneratedOnAdd();
  1952. });
  1953. modelBuilder.Entity<FmsDrawingCodeType>(entity => {
  1954. entity.HasKey(e => new { e.DrawingTypeId });
  1955. entity.Property(e => e.DrawingTypeId)
  1956. .HasComment("도면 유형 고유번호")
  1957. .ValueGeneratedOnAdd();
  1958. });
  1959. modelBuilder.Entity<FmsDrawingHistory>(entity => {
  1960. entity.HasKey(e => new { e.SiteId, e.DrawingId, e.HistoryId });
  1961. entity.Property(e => e.HistoryId)
  1962. .HasComment("설비 도면 수정 고유번호")
  1963. .ValueGeneratedOnAdd();
  1964. });
  1965. modelBuilder.Entity<FmsEquipment>(entity => {
  1966. entity.HasKey(e => new { e.SiteId, e.EquipmentId });
  1967. entity.Property(e => e.EquipmentId)
  1968. .HasComment("공기구 고유번호")
  1969. .ValueGeneratedOnAdd();
  1970. });
  1971. modelBuilder.Entity<FmsEquipmentCodeStateType>(entity => {
  1972. entity.Property(e => e.EquipmentStateTypeId)
  1973. .HasComment("공기구상태코드")
  1974. .ValueGeneratedNever();
  1975. });
  1976. modelBuilder.Entity<FmsEquipmentCodeType>(entity => {
  1977. entity.HasKey(e => new { e.EquipmentTypeId });
  1978. entity.Property(e => e.EquipmentTypeId)
  1979. .HasComment("공기구 유형 고유번호")
  1980. .ValueGeneratedOnAdd();
  1981. });
  1982. modelBuilder.Entity<FmsEquipmentHistory>(entity => {
  1983. entity.HasKey(e => new { e.SiteId, e.EquipmentHistoryId, e.EquipmentId });
  1984. entity.Property(e => e.EquipmentHistoryId)
  1985. .HasComment("공기구 사용이력 고유번호")
  1986. .ValueGeneratedOnAdd();
  1987. entity.Property(e => e.CurrentRentCount)
  1988. .HasDefaultValueSql("((0))")
  1989. .HasComment("현재 대여중인 수량");
  1990. entity.Property(e => e.CurrentStockCount)
  1991. .HasDefaultValueSql("((0))")
  1992. .HasComment("현재보유수량(byCase)");
  1993. entity.Property(e => e.LossCount)
  1994. .HasDefaultValueSql("((0))")
  1995. .HasComment("손망실수량(byCase)");
  1996. entity.Property(e => e.RentCount)
  1997. .HasDefaultValueSql("((0))")
  1998. .HasComment("대여수량(byCase)");
  1999. entity.Property(e => e.StoredCount)
  2000. .HasDefaultValueSql("((0))")
  2001. .HasComment("입고수량(byCase)");
  2002. entity.Property(e => e.TotalStockCount)
  2003. .HasDefaultValueSql("((0))")
  2004. .HasComment("전체수량(byCase)");
  2005. entity.HasOne(d => d.EquipmentStateType)
  2006. .WithMany(p => p.FmsEquipmentHistory)
  2007. .HasForeignKey(d => d.EquipmentStateTypeId)
  2008. .HasConstraintName("FK_FmsEquipmentHistory_FmsEquipmentCodeStateType");
  2009. entity.HasOne(d => d.FmsEquipment)
  2010. .WithMany(p => p.FmsEquipmentHistory)
  2011. .HasForeignKey(d => new { d.SiteId, d.EquipmentId })
  2012. .OnDelete(DeleteBehavior.ClientSetNull)
  2013. .HasConstraintName("FK_FmsEquipmentHistory_FmsEquipment");
  2014. entity.HasOne(d => d.FmsEquipmentRentInfo)
  2015. .WithMany(p => p.FmsEquipmentHistory)
  2016. .HasForeignKey(d => new { d.SiteId, d.EquipmentRentId })
  2017. .OnDelete(DeleteBehavior.Cascade)
  2018. .HasConstraintName("FK_FmsEquipmentHistory_FmsEquipmentRentInfo");
  2019. });
  2020. modelBuilder.Entity<FmsEquipmentRentInfo>(entity => {
  2021. entity.HasKey(e => new { e.SiteId, e.EquipmentRentId });
  2022. entity.Property(e => e.EquipmentRentId)
  2023. .HasComment("공기구 대여 고유번호")
  2024. .ValueGeneratedOnAdd();
  2025. entity.Property(e => e.RegisterDate)
  2026. .IsFixedLength()
  2027. .HasComment("등록일");
  2028. entity.HasOne(d => d.EquipmentStateType)
  2029. .WithMany(p => p.FmsEquipmentRentInfo)
  2030. .HasForeignKey(d => d.EquipmentStateTypeId)
  2031. .HasConstraintName("FK_FmsEquipmentRentInfo_FmsEquipmentCodeStateType");
  2032. });
  2033. modelBuilder.Entity<FmsFacilityCheckItem>(entity => {
  2034. entity.HasKey(e => new { e.SiteId, e.FacilityCode, e.CheckItemId });
  2035. entity.Property(e => e.CheckItemId)
  2036. .HasComment("")
  2037. .ValueGeneratedOnAdd();
  2038. entity.HasOne(d => d.WorkType)
  2039. .WithMany(p => p.FmsFacilityCheckItem)
  2040. .HasForeignKey(d => d.WorkTypeId)
  2041. .OnDelete(DeleteBehavior.ClientSetNull)
  2042. .HasConstraintName("FK__FmsFacilityCheckItem__FmsWorkCodeWorkType");
  2043. entity.HasOne(d => d.FmsWorkCodeCycleUnit)
  2044. .WithMany(p => p.FmsFacilityCheckItem)
  2045. .HasForeignKey(d => new { d.SiteId, d.CycleUnitId })
  2046. .OnDelete(DeleteBehavior.ClientSetNull)
  2047. .HasConstraintName("FK__FmsFacilityCheckItem__FmsWorkCodeCycleUnit");
  2048. });
  2049. modelBuilder.Entity<FmsFacilityCodeClass>(entity => {
  2050. entity.HasKey(e => new { e.FacilityClassId });
  2051. entity.Property(e => e.FacilityClassId)
  2052. .ValueGeneratedOnAdd();
  2053. });
  2054. modelBuilder.Entity<FmsFacilityManual>(entity => {
  2055. entity.HasKey(e => new { e.SiteId, e.FacilityCode, e.ManualId })
  2056. .HasName("PK__CmFacili__D40F16B497254F13");
  2057. entity.Property(e => e.ManualId)
  2058. .HasComment("매뉴얼 고유번호")
  2059. .ValueGeneratedOnAdd();
  2060. entity.HasOne(d => d.CmBusinessField)
  2061. .WithMany(p => p.FmsFacilityManual)
  2062. .HasForeignKey(d => new { d.BusinessFieldId })
  2063. .OnDelete(DeleteBehavior.ClientSetNull)
  2064. .HasConstraintName("FK__CmFacilityManual__7BE56230");
  2065. entity.HasOne(d => d.CmFacility)
  2066. .WithMany(p => p.FmsFacilityManual)
  2067. .HasForeignKey(d => new { d.SiteId, d.FacilityCode })
  2068. .OnDelete(DeleteBehavior.ClientSetNull)
  2069. .HasConstraintName("FK__CmFacilityManual__79FD19BE");
  2070. });
  2071. modelBuilder.Entity<FmsFacilityOperationItem>(entity => {
  2072. entity.HasKey(e => new { e.SiteId, e.ItemId })
  2073. .HasName("PK__FmsFacil__1EFB515B743CF743");
  2074. entity.Property(e => e.ItemId)
  2075. .HasComment("")
  2076. .ValueGeneratedOnAdd();
  2077. entity.HasOne(d => d.CmFacility)
  2078. .WithOne(p => p.FmsFacilityOperationItem)
  2079. .HasForeignKey<FmsFacilityOperationItem>(d => new { d.SiteId, d.ItemId })
  2080. .OnDelete(DeleteBehavior.ClientSetNull)
  2081. .HasConstraintName("FK__FmsFacilityOpera__725BF7F6");
  2082. });
  2083. modelBuilder.Entity<FmsFacilityOperationReport>(entity => {
  2084. entity.HasKey(e => new { e.SiteId, e.FacilityOperationReportId });
  2085. entity.Property(e => e.FacilityOperationReportId)
  2086. .HasComment("")
  2087. .ValueGeneratedOnAdd();
  2088. entity.HasOne(d => d.CmUser)
  2089. .WithMany(p => p.FmsFacilityOperationReport)
  2090. .HasForeignKey(d => d.RegisterUserId)
  2091. .OnDelete(DeleteBehavior.ClientSetNull)
  2092. .HasConstraintName("FK_FmsFacilityOperationReport_CmUser");
  2093. });
  2094. modelBuilder.Entity<FmsInvestmentCost>(entity => {
  2095. entity.HasKey(e => new { e.SiteId, e.InsvestmentCostId });
  2096. entity.Property(e => e.InsvestmentCostId)
  2097. .HasComment("투자비 항목 코드")
  2098. .ValueGeneratedOnAdd();
  2099. });
  2100. modelBuilder.Entity<FmsLicense>(entity => {
  2101. entity.HasKey(e => new { e.SiteId, e.LicenseId })
  2102. .HasName("PK__FmsLicen__8EF1D96BBE94D1BE");
  2103. entity.Property(e => e.LicenseId)
  2104. .HasComment("")
  2105. .ValueGeneratedOnAdd();
  2106. entity.HasOne(d => d.Site)
  2107. .WithMany(p => p.FmsLicense)
  2108. .HasForeignKey(d => d.SiteId)
  2109. .OnDelete(DeleteBehavior.ClientSetNull)
  2110. .HasConstraintName("FK__FmsLicense__CmSite");
  2111. entity.HasOne(d => d.CmBusinessField)
  2112. .WithMany(p => p.FmsLicense)
  2113. .HasForeignKey(d => new { d.BusinessFieldId })
  2114. .HasConstraintName("FK__FmsLicense__CmBusinessField");
  2115. });
  2116. modelBuilder.Entity<FmsManual>(entity => {
  2117. entity.HasKey(e => new { e.SiteId, e.ManualId });
  2118. entity.Property(e => e.ManualId)
  2119. .HasComment("매뉴얼 고유번호")
  2120. .ValueGeneratedOnAdd();
  2121. });
  2122. modelBuilder.Entity<FmsManualHistory>(entity => {
  2123. entity.HasKey(e => new { e.SiteId, e.ManualId, e.HistoryId });
  2124. entity.Property(e => e.HistoryId)
  2125. .HasComment("매뉴얼 이력 구분 번호")
  2126. .ValueGeneratedOnAdd();
  2127. });
  2128. modelBuilder.Entity<FmsManualType>(entity => {
  2129. entity.HasKey(e => new { e.ManualTypeId });
  2130. entity.Property(e => e.ManualTypeId)
  2131. .HasComment("매뉴얼 유형 코드")
  2132. .ValueGeneratedOnAdd();
  2133. });
  2134. modelBuilder.Entity<FmsManualGroup>(entity => {
  2135. entity.HasKey(e => new { e.ManualGroupId });
  2136. entity.Property(e => e.ManualGroupId)
  2137. .HasComment("매뉴얼 분류 코드")
  2138. .ValueGeneratedOnAdd();
  2139. });
  2140. modelBuilder.Entity<FmsMaterial>(entity => {
  2141. entity.HasKey(e => new { e.SiteId, e.MaterialId });
  2142. entity.Property(e => e.MaterialId)
  2143. .ValueGeneratedOnAdd();
  2144. /*
  2145. entity.HasOne(d => d.Site)
  2146. .WithMany(p => p.FmsMaterial)
  2147. .HasForeignKey(d => d.SiteId);
  2148. entity.HasOne(d => d.CmBusinessField)
  2149. .WithMany(p => p.FmsMaterial)
  2150. .HasForeignKey(d => new { d.BusinessFieldId });
  2151. entity.HasOne(d => d.CmFile)
  2152. .WithMany(p => p.FmsMaterial)
  2153. .HasForeignKey(d => new { d.SiteId, d.ImageFileId });
  2154. entity.HasOne(d => d.FmsMaterialCodeLocation)
  2155. .WithMany(p => p.FmsMaterial)
  2156. .HasForeignKey(d => new { d.SiteId, d.LocationId })
  2157. .HasConstraintName("FK_FmsMaterial_FmsMaterialCodeLocation");
  2158. entity.HasOne(d => d.FmsMaterialCodeType)
  2159. .WithMany(p => p.FmsMaterial)
  2160. .HasForeignKey(d => new { d.SiteId, d.MaterialTypeId });
  2161. entity.HasOne(d => d.FmsMaterialTradeCompany)
  2162. .WithMany(p => p.FmsMaterial)
  2163. .HasForeignKey(d => new { d.SiteId, d.TradeCompanyId });
  2164. entity.HasOne(d => d.FmsMaterialWarehouse)
  2165. .WithMany(p => p.FmsMaterial)
  2166. .HasForeignKey(d => new { d.SiteId, d.WarehouseId });
  2167. */
  2168. });
  2169. modelBuilder.Entity<FmsMaterialCarriedForward>(entity => {
  2170. entity.HasKey(e => new { e.SiteId, e.ClosedDate, e.BusinessFieldId, e.WarehouseId, e.MaterialId })
  2171. .HasName("PK__FmsMater__6ABE9B82E5F38B14");
  2172. entity.HasOne(d => d.Site)
  2173. .WithMany(p => p.FmsMaterialCarriedForward)
  2174. .HasForeignKey(d => d.SiteId)
  2175. .OnDelete(DeleteBehavior.ClientSetNull)
  2176. .HasConstraintName("FK__FmsMaterialCarriedForward__CmSite");
  2177. entity.HasOne(d => d.CmBusinessField)
  2178. .WithMany(p => p.FmsMaterialCarriedForward)
  2179. .HasForeignKey(d => new { d.BusinessFieldId })
  2180. .OnDelete(DeleteBehavior.ClientSetNull)
  2181. .HasConstraintName("FK__FmsMaterialCarriedForward__CmBusinessField");
  2182. });
  2183. modelBuilder.Entity<FmsMaterialCodeAdjustmentType>(entity => {
  2184. entity.Property(e => e.AdjustmentTypeId)
  2185. .HasComment("정산 코드")
  2186. .ValueGeneratedNever();
  2187. });
  2188. modelBuilder.Entity<FmsMaterialCodeClass>(entity => {
  2189. entity.HasKey(e => new { e.MaterialClassId });
  2190. entity.Property(e => e.MaterialClassId)
  2191. .ValueGeneratedOnAdd();
  2192. /*
  2193. entity.HasOne(d => d.Site)
  2194. .WithMany(p => p.FmsMaterialCodeClass)
  2195. .HasForeignKey(d => d.SiteId);
  2196. */
  2197. });
  2198. modelBuilder.Entity<FmsMaterialCodeLocation>(entity => {
  2199. entity.HasKey(e => new { e.SiteId, e.LocationId })
  2200. .HasName("PK__FmsMater__D7A3532AFDD365FE");
  2201. entity.Property(e => e.LocationId)
  2202. .HasComment("보관창고 코드")
  2203. .ValueGeneratedOnAdd();
  2204. entity.HasOne(d => d.Site)
  2205. .WithMany(p => p.FmsMaterialCodeLocation)
  2206. .HasForeignKey(d => d.SiteId)
  2207. .OnDelete(DeleteBehavior.ClientSetNull)
  2208. .HasConstraintName("FK__FmsMaterialCodeLocation__CmSite");
  2209. entity.HasOne(d => d.CmBusinessField)
  2210. .WithMany(p => p.FmsMaterialCodeLocation)
  2211. .HasForeignKey(d => new { d.BusinessFieldId })
  2212. .OnDelete(DeleteBehavior.ClientSetNull)
  2213. .HasConstraintName("FK__FmsMaterialCodeLocation__CmBusinessField");
  2214. });
  2215. modelBuilder.Entity<FmsMaterialCodeProgress>(entity => {
  2216. entity.HasKey(e => e.ProgressId)
  2217. .HasName("PK__FmsMater__1B39A956C02E6627");
  2218. entity.Property(e => e.ProgressId)
  2219. .HasComment("진행 상태 코드")
  2220. .ValueGeneratedNever();
  2221. });
  2222. modelBuilder.Entity<FmsMaterialCodePurchaseType>(entity => {
  2223. });
  2224. modelBuilder.Entity<FmsMaterialCodeReleaseType>(entity => {
  2225. entity.HasKey(e => e.ReleaseTypeId)
  2226. .HasName("PK__FmsMater__A0AD7C35E7E3B491");
  2227. entity.Property(e => e.ReleaseTypeId)
  2228. .HasComment("작업출고 코드")
  2229. .ValueGeneratedNever();
  2230. });
  2231. modelBuilder.Entity<FmsMaterialCodeType>(entity => {
  2232. entity.HasKey(e => new { e.MaterialTypeId })
  2233. .HasName("PK__FmsMater__58BEA2DE75682874");
  2234. entity.Property(e => e.MaterialTypeId)
  2235. .HasComment("자재구분 코드")
  2236. .ValueGeneratedOnAdd();
  2237. });
  2238. modelBuilder.Entity<FmsMaterialPurchaseOrder>(entity => {
  2239. entity.HasKey(e => new { e.SiteId, e.PurchaseOrderId })
  2240. .HasName("PK_FmsMaterialPurchaseOrder_1");
  2241. entity.Property(e => e.PurchaseOrderId)
  2242. .HasComment("자재발주 고유번호")
  2243. .ValueGeneratedOnAdd();
  2244. entity.HasOne(d => d.Site)
  2245. .WithMany(p => p.FmsMaterialPurchaseOrder)
  2246. .HasForeignKey(d => d.SiteId)
  2247. .OnDelete(DeleteBehavior.ClientSetNull)
  2248. .HasConstraintName("FK__FmsMaterialOrder__CmSite");
  2249. entity.HasOne(d => d.CmBusinessField)
  2250. .WithMany(p => p.FmsMaterialPurchaseOrder)
  2251. .HasForeignKey(d => new { d.BusinessFieldId })
  2252. .OnDelete(DeleteBehavior.ClientSetNull)
  2253. .HasConstraintName("FK__FmsMaterialOrder__CmBusinessField");
  2254. entity.HasOne(d => d.CmFile)
  2255. .WithMany(p => p.FmsMaterialPurchaseOrder)
  2256. .HasForeignKey(d => new { d.SiteId, d.FileId })
  2257. .HasConstraintName("FK__FmsMaterialPurchaseOrder__CmFile");
  2258. entity.HasOne(d => d.CmUser)
  2259. .WithMany(p => p.FmsMaterialPurchaseOrder)
  2260. .HasForeignKey(d => d.OrderUserId)
  2261. .OnDelete(DeleteBehavior.ClientSetNull)
  2262. .HasConstraintName("FK__FmsMaterialOrder__CmUser");
  2263. entity.HasOne(d => d.FmsMaterialPurchaseRequest)
  2264. .WithMany(p => p.FmsMaterialPurchaseOrder)
  2265. .HasForeignKey(d => new { d.SiteId, d.PurchaseRequestId })
  2266. .OnDelete(DeleteBehavior.ClientSetNull)
  2267. .HasConstraintName("FK_FmsMaterialPurchaseOrder_FmsMaterialPurchaseRequest");
  2268. entity.HasOne(d => d.FmsMaterialTradeCompany)
  2269. .WithMany(p => p.FmsMaterialPurchaseOrder)
  2270. .HasForeignKey(d => new { d.SiteId, d.TradeCompanyId })
  2271. .HasConstraintName("FK__FmsMaterialPurchaseOrder__FmsMaterialTradeCompany");
  2272. });
  2273. modelBuilder.Entity<FmsMaterialPurchaseOrderMaterial>(entity => {
  2274. entity.HasKey(e => new { e.SiteId, e.PurchaseOrderId, e.MaterialId })
  2275. .HasName("PK_FmsMaterialPurchaseOrderMaterial_1");
  2276. entity.HasOne(d => d.FmsMaterial)
  2277. .WithMany(p => p.FmsMaterialPurchaseOrderMaterial)
  2278. .HasForeignKey(d => new { d.SiteId, d.MaterialId })
  2279. .OnDelete(DeleteBehavior.ClientSetNull)
  2280. .HasConstraintName("FK_FmsMaterialPurchaseOrderMaterial_FmsMaterial");
  2281. entity.HasOne(d => d.FmsMaterialPurchaseOrder)
  2282. .WithMany(p => p.FmsMaterialPurchaseOrderMaterial)
  2283. .HasForeignKey(d => new { d.SiteId, d.PurchaseOrderId })
  2284. .HasConstraintName("FK_FmsMaterialPurchaseOrderMaterial_FmsMaterialPurchaseOrder");
  2285. });
  2286. modelBuilder.Entity<FmsMaterialPurchaseRequest>(entity => {
  2287. entity.HasKey(e => new { e.SiteId, e.PurchaseRequestId })
  2288. .HasName("PK_FmsMaterialPurchaseRequest_1");
  2289. entity.Property(e => e.PurchaseRequestId)
  2290. .HasComment("자재발주 요청 고유번호")
  2291. .ValueGeneratedOnAdd();
  2292. entity.HasOne(d => d.Progress)
  2293. .WithMany(p => p.FmsMaterialPurchaseRequest)
  2294. .HasForeignKey(d => d.ProgressId)
  2295. .OnDelete(DeleteBehavior.ClientSetNull)
  2296. .HasConstraintName("FK__FmsMaterialPurchasingRequest__FmsMaterialCodeProcess");
  2297. entity.HasOne(d => d.PurchaseType)
  2298. .WithMany(p => p.FmsMaterialPurchaseRequest)
  2299. .HasForeignKey(d => d.PurchaseTypeId)
  2300. .OnDelete(DeleteBehavior.ClientSetNull)
  2301. .HasConstraintName("FK_FmsMaterialPurchaseRequest_FmsMaterialCodePurchaseType");
  2302. entity.HasOne(d => d.Site)
  2303. .WithMany(p => p.FmsMaterialPurchaseRequest)
  2304. .HasForeignKey(d => d.SiteId)
  2305. .OnDelete(DeleteBehavior.ClientSetNull)
  2306. .HasConstraintName("FK__FmsMaterialPurchasingRequest__CmSite");
  2307. entity.HasOne(d => d.CmUser)
  2308. .WithMany(p => p.FmsMaterialPurchaseRequestCmUser)
  2309. .HasForeignKey(d => d.ApprovalUserId)
  2310. .HasConstraintName("FK__FmsMaterialPurchaseRequest__CmUser1_AsApprovalUserId");
  2311. entity.HasOne(d => d.CmBusinessField)
  2312. .WithMany(p => p.FmsMaterialPurchaseRequest)
  2313. .HasForeignKey(d => new { d.BusinessFieldId })
  2314. .OnDelete(DeleteBehavior.ClientSetNull)
  2315. .HasConstraintName("FK__FmsMaterialPurchasingRequest__CmBusinessField");
  2316. entity.HasOne(d => d.CmUserNavigation)
  2317. .WithMany(p => p.FmsMaterialPurchaseRequestCmUserNavigation)
  2318. .HasForeignKey(d => d.RequestUserId)
  2319. .OnDelete(DeleteBehavior.ClientSetNull)
  2320. .HasConstraintName("FK__FmsMaterialPurchaseRequest__CmUser_AsRequestUserId");
  2321. });
  2322. modelBuilder.Entity<FmsMaterialPurchaseRequestMaterial>(entity => {
  2323. entity.HasKey(e => new { e.SiteId, e.PurchaseRequestId, e.MaterialId });
  2324. entity.HasOne(d => d.FmsMaterial)
  2325. .WithMany(p => p.FmsMaterialPurchaseRequestMaterial)
  2326. .HasForeignKey(d => new { d.SiteId, d.MaterialId })
  2327. .OnDelete(DeleteBehavior.ClientSetNull)
  2328. .HasConstraintName("FK_FmsMaterialPurchaseRequestMaterial_FmsMaterial");
  2329. entity.HasOne(d => d.FmsMaterialPurchaseRequest)
  2330. .WithMany(p => p.FmsMaterialPurchaseRequestMaterial)
  2331. .HasForeignKey(d => new { d.SiteId, d.PurchaseRequestId })
  2332. .HasConstraintName("FK_FmsMaterialPurchaseRequestMaterial_FmsMaterialPurchaseRequest");
  2333. });
  2334. modelBuilder.Entity<FmsMaterialRelease>(entity => {
  2335. entity.HasKey(e => new { e.SiteId, e.MaterialReleaseId });
  2336. entity.Property(e => e.MaterialReleaseId)
  2337. .HasComment("출고 고유번호")
  2338. .ValueGeneratedOnAdd();
  2339. entity.HasOne(d => d.AdjustmentType)
  2340. .WithMany(p => p.FmsMaterialRelease)
  2341. .HasForeignKey(d => d.AdjustmentTypeId)
  2342. .OnDelete(DeleteBehavior.ClientSetNull)
  2343. .HasConstraintName("FK_FmsMaterialRelease_FmsMaterialCodeAdjustmentType");
  2344. entity.HasOne(d => d.ReleaseType)
  2345. .WithMany(p => p.FmsMaterialRelease)
  2346. .HasForeignKey(d => d.ReleaseTypeId)
  2347. .OnDelete(DeleteBehavior.ClientSetNull)
  2348. .HasConstraintName("FK_FmsMaterialRelease_FmsMaterialCodeReleaseType");
  2349. entity.HasOne(d => d.Site)
  2350. .WithMany(p => p.FmsMaterialRelease)
  2351. .HasForeignKey(d => d.SiteId)
  2352. .OnDelete(DeleteBehavior.ClientSetNull)
  2353. .HasConstraintName("FK_FmsMaterialRelease_CmSite");
  2354. entity.HasOne(d => d.CmUser)
  2355. .WithMany(p => p.FmsMaterialReleaseCmUser)
  2356. .HasForeignKey(d => d.AdjustmentUserId)
  2357. .HasConstraintName("FK_FmsMaterialRelease_CmUser1");
  2358. entity.HasOne(d => d.CmBusinessField)
  2359. .WithMany(p => p.FmsMaterialRelease)
  2360. .HasForeignKey(d => new { d.BusinessFieldId })
  2361. .OnDelete(DeleteBehavior.ClientSetNull)
  2362. .HasConstraintName("FK_FmsMaterialRelease_CmBusinessField");
  2363. entity.HasOne(d => d.CmUserNavigation)
  2364. .WithMany(p => p.FmsMaterialReleaseCmUserNavigation)
  2365. .HasForeignKey(d => d.ConfirmedUserId)
  2366. .HasConstraintName("FK_FmsMaterialRelease_CmUser");
  2367. entity.HasOne(d => d.FmsMaterial)
  2368. .WithMany(p => p.FmsMaterialRelease)
  2369. .HasForeignKey(d => new { d.SiteId, d.MaterialId })
  2370. .HasConstraintName("FK_FmsMaterialRelease_FmsMaterial");
  2371. entity.HasOne(d => d.FmsWorkResult)
  2372. .WithMany(p => p.FmsMaterialRelease)
  2373. .HasForeignKey(d => new { d.SiteId, d.WorkRequestId })
  2374. .HasConstraintName("FK_FmsMaterialRelease_FmsWorkResult");
  2375. entity.HasOne(d => d.FmsWorkResultCheckItemMaterial)
  2376. .WithMany(p => p.FmsMaterialRelease)
  2377. .HasForeignKey(d => new { d.CheckItemMaterialId })
  2378. .HasConstraintName("FK_FmsMaterialRelease_FmsWorkResultCheckItemMaterial");
  2379. });
  2380. modelBuilder.Entity<FmsMaterialStored>(entity => {
  2381. entity.HasKey(e => new { e.SiteId, e.MaterialStoredId })
  2382. .HasName("PK_FmsMaterialStored_1");
  2383. entity.Property(e => e.MaterialStoredId)
  2384. .HasComment("입고 자재 고유번호")
  2385. .ValueGeneratedOnAdd();
  2386. entity.HasOne(d => d.Site)
  2387. .WithMany(p => p.FmsMaterialStored)
  2388. .HasForeignKey(d => d.SiteId)
  2389. .OnDelete(DeleteBehavior.ClientSetNull)
  2390. .HasConstraintName("FK__FmsMaterialStored__CmSite");
  2391. entity.HasOne(d => d.CmUser)
  2392. .WithMany(p => p.FmsMaterialStoredCmUser)
  2393. .HasForeignKey(d => d.ApprovalUserId)
  2394. .HasConstraintName("FK__FmsMaterialStored__CmUser1_AsApprovalUserId");
  2395. entity.HasOne(d => d.CmBusinessField)
  2396. .WithMany(p => p.FmsMaterialStored)
  2397. .HasForeignKey(d => new { d.BusinessFieldId })
  2398. .OnDelete(DeleteBehavior.ClientSetNull)
  2399. .HasConstraintName("FK__FmsMaterialStored__CmBusinessField");
  2400. entity.HasOne(d => d.FmsMaterial)
  2401. .WithMany(p => p.FmsMaterialStored)
  2402. .HasForeignKey(d => new { d.SiteId, d.MaterialId })
  2403. .OnDelete(DeleteBehavior.ClientSetNull)
  2404. .HasConstraintName("FK_FmsMaterialStored_FmsMaterial");
  2405. entity.HasOne(d => d.FmsMaterialPurchaseOrder)
  2406. .WithMany(p => p.FmsMaterialStored)
  2407. .HasForeignKey(d => new { d.SiteId, d.PurchaseOrderId })
  2408. .HasConstraintName("FK_FmsMaterialStored_FmsMaterialPurchaseOrder");
  2409. entity.HasOne(d => d.S)
  2410. .WithMany(p => p.FmsMaterialStoredS)
  2411. .HasForeignKey(d => d.StoredUserId)
  2412. .OnDelete(DeleteBehavior.ClientSetNull)
  2413. .HasConstraintName("FK__FmsMaterialStored__CmUser_AsStoredUserId");
  2414. entity.HasOne(d => d.FmsMaterialWarehouse)
  2415. .WithMany(p => p.FmsMaterialStored)
  2416. .HasForeignKey(d => new { d.SiteId, d.WarehouseId })
  2417. .OnDelete(DeleteBehavior.ClientSetNull)
  2418. .HasConstraintName("FK_FmsMaterialStored_FmsMaterialWarehouse");
  2419. });
  2420. modelBuilder.Entity<FmsMaterialTradeCompany>(entity => {
  2421. entity.HasKey(e => new { e.SiteId, e.TradeCompanyId })
  2422. .HasName("PK__FmsMater__E1CDA95A8D3DA6AC");
  2423. entity.Property(e => e.TradeCompanyId)
  2424. .HasComment("자재구매 회사 고유번호")
  2425. .ValueGeneratedOnAdd();
  2426. entity.Property(e => e.AddressZip1)
  2427. .IsFixedLength()
  2428. .HasComment("회사 우편번호 1");
  2429. entity.Property(e => e.AddressZip2)
  2430. .IsFixedLength()
  2431. .HasComment("회사 우편번호 2");
  2432. entity.HasOne(d => d.Site)
  2433. .WithMany(p => p.FmsMaterialTradeCompany)
  2434. .HasForeignKey(d => d.SiteId)
  2435. .OnDelete(DeleteBehavior.ClientSetNull)
  2436. .HasConstraintName("FK__FmsMaterialTradeCompany__CmSite");
  2437. });
  2438. modelBuilder.Entity<FmsMaterialWarehouse>(entity => {
  2439. entity.HasKey(e => new { e.SiteId, e.WarehouseId })
  2440. .HasName("PK_FmsMaterialWarehouse_1");
  2441. entity.Property(e => e.WarehouseId)
  2442. .HasComment("자재창고 고유번호")
  2443. .ValueGeneratedOnAdd();
  2444. entity.HasOne(d => d.Site)
  2445. .WithMany(p => p.FmsMaterialWarehouse)
  2446. .HasForeignKey(d => d.SiteId)
  2447. .OnDelete(DeleteBehavior.ClientSetNull)
  2448. .HasConstraintName("FK__FmsMaterialWarehouse__CmSite");
  2449. entity.HasOne(d => d.CmBusinessField)
  2450. .WithMany(p => p.FmsMaterialWarehouse)
  2451. .HasForeignKey(d => new { d.BusinessFieldId })
  2452. .OnDelete(DeleteBehavior.ClientSetNull)
  2453. .HasConstraintName("FK__FmsMaterialWarehouse__CmBusinessField");
  2454. });
  2455. modelBuilder.Entity<FmsMonthlyStoredReleaseStatusView>(entity => {
  2456. entity.HasNoKey();
  2457. entity.ToView("FmsMonthlyStoredReleaseStatusView");
  2458. });
  2459. modelBuilder.Entity<FmsPaymentType>(entity => {
  2460. entity.HasKey(e => new { e.PaymentTypeId });
  2461. entity.Property(e => e.PaymentTypeId)
  2462. .HasComment("지급구분 코드")
  2463. .ValueGeneratedOnAdd();
  2464. });
  2465. modelBuilder.Entity<FmsReport>(entity => {
  2466. entity.HasKey(e => new { e.SiteId, e.Rid });
  2467. entity.Property(e => e.Rid)
  2468. .HasComment("레포트 고유번호")
  2469. .ValueGeneratedOnAdd();
  2470. entity.HasOne(d => d.Site)
  2471. .WithMany(p => p.FmsReport)
  2472. .HasForeignKey(d => d.SiteId)
  2473. .OnDelete(DeleteBehavior.ClientSetNull)
  2474. .HasConstraintName("FK_FmsReport_CmSite");
  2475. entity.HasOne(d => d.CmBusinessField)
  2476. .WithMany(p => p.FmsReport)
  2477. .HasForeignKey(d => new { d.BusinessFieldId })
  2478. .OnDelete(DeleteBehavior.ClientSetNull)
  2479. .HasConstraintName("FK_FmsReport_CmBusinessField");
  2480. entity.HasOne(d => d.CmUser)
  2481. .WithMany(p => p.FmsReportCmUser)
  2482. .HasForeignKey(d => d.ConfirmUserId1)
  2483. .HasConstraintName("FK_FmsReport_CmUser1");
  2484. entity.HasOne(d => d.CmUserNavigation)
  2485. .WithMany(p => p.FmsReportCmUserNavigation)
  2486. .HasForeignKey(d => d.ConfirmUserId2)
  2487. .HasConstraintName("FK_FmsReport_CmUser2");
  2488. entity.HasOne(d => d.CmFile)
  2489. .WithMany(p => p.FmsReport)
  2490. .HasForeignKey(d => new { d.SiteId, d.FileId })
  2491. .HasConstraintName("FK_FmsReport_CmFile");
  2492. entity.HasOne(d => d.CmUser1)
  2493. .WithMany(p => p.FmsReportCmUser1)
  2494. .HasForeignKey(d => d.RegisterUserId)
  2495. .HasConstraintName("FK_FmsReport_CmUser");
  2496. });
  2497. modelBuilder.Entity<FmsShortStockStatusView>(entity => {
  2498. entity.HasNoKey();
  2499. entity.ToView("FmsShortStockStatusView");
  2500. });
  2501. modelBuilder.Entity<FmsWorkCodeCauseClass>(entity => {
  2502. entity.HasKey(e => new { e.SiteId, e.CauseClassId })
  2503. .HasName("PK__FmsWorkC__41B36FA8A0A50888");
  2504. entity.Property(e => e.CauseClassId)
  2505. .HasComment("원인 종류 코드")
  2506. .ValueGeneratedOnAdd();
  2507. entity.HasOne(d => d.Site)
  2508. .WithMany(p => p.FmsWorkCodeCauseClass)
  2509. .HasForeignKey(d => d.SiteId)
  2510. .OnDelete(DeleteBehavior.ClientSetNull)
  2511. .HasConstraintName("FK__FmsWorkCodeCauseClass__CmSite");
  2512. });
  2513. modelBuilder.Entity<FmsWorkCodeCycleUnit>(entity => {
  2514. entity.HasKey(e => new { e.SiteId, e.CycleUnitId })
  2515. .HasName("PK__FmsFacil__FD93E7A8F9008927");
  2516. entity.HasOne(d => d.Site)
  2517. .WithMany(p => p.FmsWorkCodeCycleUnit)
  2518. .HasForeignKey(d => d.SiteId)
  2519. .OnDelete(DeleteBehavior.ClientSetNull)
  2520. .HasConstraintName("FK__FmsWorkCodeCycleUnit__CmSite");
  2521. });
  2522. modelBuilder.Entity<FmsWorkCodeEmergency>(entity => {
  2523. entity.HasKey(e => new { e.SiteId, e.EmergencyId })
  2524. .HasName("PK__FmsWorkC__9E69ED2E2DF97B9E");
  2525. entity.Property(e => e.EmergencyId)
  2526. .HasComment("긴급 작업 고유번호")
  2527. .ValueGeneratedOnAdd();
  2528. entity.HasOne(d => d.Site)
  2529. .WithMany(p => p.FmsWorkCodeEmergency)
  2530. .HasForeignKey(d => d.SiteId)
  2531. .OnDelete(DeleteBehavior.ClientSetNull)
  2532. .HasConstraintName("FK__FmsWorkCodeEmergency__CmSite");
  2533. });
  2534. modelBuilder.Entity<FmsWorkCodeHolidayWorkType>(entity => {
  2535. entity.HasKey(e => new { e.SiteId, e.HolidayWorkTypeId })
  2536. .HasName("PK__FmsWorkC__AADC648E16ABB84E");
  2537. entity.HasOne(d => d.Site)
  2538. .WithMany(p => p.FmsWorkCodeHolidayWorkType)
  2539. .HasForeignKey(d => d.SiteId)
  2540. .OnDelete(DeleteBehavior.ClientSetNull)
  2541. .HasConstraintName("FK__FmsWorkCodeHolidayWorkType__CmSite");
  2542. });
  2543. modelBuilder.Entity<FmsWorkCodeLegalInspectionAgency>(entity => {
  2544. entity.HasKey(e => new { e.SiteId, e.InspectionAgencyId })
  2545. .HasName("PK__FmsWorkC__C77D9EF75644DF2B");
  2546. entity.Property(e => e.InspectionAgencyId).ValueGeneratedOnAdd();
  2547. entity.HasOne(d => d.Site)
  2548. .WithMany(p => p.FmsWorkCodeLegalInspectionAgency)
  2549. .HasForeignKey(d => d.SiteId)
  2550. .OnDelete(DeleteBehavior.ClientSetNull)
  2551. .HasConstraintName("FK__FmsWorkCodeLegalInspectionAgency__CmSite");
  2552. });
  2553. modelBuilder.Entity<FmsWorkCodeProgress>(entity => {
  2554. entity.HasKey(e => e.WorkProgressId)
  2555. .HasName("PK__FmsWorkC__1ECF32EBC781395E");
  2556. entity.Property(e => e.WorkProgressId)
  2557. .HasComment("작업 진행상태 고유번호")
  2558. .ValueGeneratedNever();
  2559. });
  2560. modelBuilder.Entity<FmsWorkCodeType>(entity => {
  2561. entity.HasKey(e => e.WorkTypeId)
  2562. .HasName("PK__FmsWorkC__CCC06D20DC518AA2");
  2563. });
  2564. modelBuilder.Entity<FmsWorkOrder>(entity => {
  2565. entity.HasKey(e => new { e.SiteId, e.WorkRequestId });
  2566. entity.HasOne(d => d.Site)
  2567. .WithMany(p => p.FmsWorkOrder)
  2568. .HasForeignKey(d => d.SiteId)
  2569. .OnDelete(DeleteBehavior.ClientSetNull)
  2570. .HasConstraintName("FK__FmsWorkOrder__CmSite");
  2571. entity.HasOne(d => d.CmBusinessField)
  2572. .WithMany(p => p.FmsWorkOrder)
  2573. .HasForeignKey(d => new { d.BusinessFieldId })
  2574. .OnDelete(DeleteBehavior.ClientSetNull)
  2575. .HasConstraintName("FK__FmsWorkOrder__CmBusinessField");
  2576. entity.HasOne(d => d.FmsWorkCodeEmergency)
  2577. .WithMany(p => p.FmsWorkOrder)
  2578. .HasForeignKey(d => new { d.SiteId, d.EmergencyId })
  2579. .HasConstraintName("FK__FmsWorkOrder__FmsWorkCodeEmergency");
  2580. entity.HasOne(d => d.CmUser)
  2581. .WithMany(p => p.FmsWorkOrder)
  2582. .HasForeignKey(d => d.OrderUserId)
  2583. .OnDelete(DeleteBehavior.ClientSetNull)
  2584. .HasConstraintName("FK__FmsWorkOrder__CmUser");
  2585. entity.HasOne(d => d.FmsWorkRequest)
  2586. .WithOne(p => p.FmsWorkOrder)
  2587. .HasForeignKey<FmsWorkOrder>(d => new { d.SiteId, d.WorkRequestId })
  2588. .OnDelete(DeleteBehavior.ClientSetNull)
  2589. .HasConstraintName("FK__FmsWorkOrder__FmsWorkRequest");
  2590. });
  2591. modelBuilder.Entity<FmsWorkOrderToFacility>(entity => {
  2592. entity.HasKey(e => new { e.SiteId, e.WorkRequestId, e.FacilityCode })
  2593. .HasName("PK__FmsWorkO__85930B3FA02FC407");
  2594. entity.HasOne(d => d.CmFacility)
  2595. .WithMany(p => p.FmsWorkOrderToFacility)
  2596. .HasForeignKey(d => new { d.SiteId, d.FacilityCode })
  2597. .OnDelete(DeleteBehavior.ClientSetNull)
  2598. .HasConstraintName("FK_FmsWorkOrderToFacility_CmFacility");
  2599. entity.HasOne(d => d.FmsWorkOrder)
  2600. .WithMany(p => p.FmsWorkOrderToFacility)
  2601. .HasForeignKey(d => new { d.SiteId, d.WorkRequestId })
  2602. .HasConstraintName("FK__FmsWorkOrderToFacility__FmsWorkOrder");
  2603. });
  2604. modelBuilder.Entity<FmsWorkRequest>(entity => {
  2605. entity.HasKey(e => new { e.SiteId, e.WorkRequestId })
  2606. .HasName("PK__FmsWorkR__14C63A9A32B3A813");
  2607. entity.Property(e => e.WorkRequestId)
  2608. .HasComment("작업요청 고유번호")
  2609. .ValueGeneratedOnAdd();
  2610. entity.HasOne(d => d.Site)
  2611. .WithMany(p => p.FmsWorkRequest)
  2612. .HasForeignKey(d => d.SiteId)
  2613. .OnDelete(DeleteBehavior.ClientSetNull)
  2614. .HasConstraintName("FK__FmsWorkRequest__CmSite");
  2615. entity.HasOne(d => d.WorkProgress)
  2616. .WithMany(p => p.FmsWorkRequest)
  2617. .HasForeignKey(d => d.WorkProgressId)
  2618. .OnDelete(DeleteBehavior.ClientSetNull)
  2619. .HasConstraintName("FK__FmsWorkRequest__FmsWorkCodeProgress");
  2620. entity.HasOne(d => d.WorkType)
  2621. .WithMany(p => p.FmsWorkRequest)
  2622. .HasForeignKey(d => d.WorkTypeId)
  2623. .OnDelete(DeleteBehavior.ClientSetNull)
  2624. .HasConstraintName("FK__FmsWorkRequest__FmsWorkCodeWorkType");
  2625. entity.HasOne(d => d.WorkDetailType)
  2626. .WithMany()
  2627. .HasForeignKey(d => d.WorkDetailTypeId)
  2628. .OnDelete(DeleteBehavior.ClientSetNull)
  2629. .HasConstraintName("FK_FmsWorkRequest_FmsWorkCodeDetailType");
  2630. entity.HasOne(d => d.CmBusinessField)
  2631. .WithMany(p => p.FmsWorkRequest)
  2632. .HasForeignKey(d => new { d.BusinessFieldId })
  2633. .OnDelete(DeleteBehavior.ClientSetNull)
  2634. .HasConstraintName("FK__FmsWorkRequest__CmBusinessField");
  2635. entity.HasOne(d => d.WorkPartner)
  2636. .WithMany()
  2637. .HasForeignKey(d => new { d.SiteId, d.WorkPartnerId })
  2638. .HasConstraintName("FK_FmsWorkRequest_CmPartner_WorkPartner");
  2639. entity.HasOne(d => d.CmPartner)
  2640. .WithMany(p => p.FmsWorkRequest)
  2641. .HasForeignKey(d => new { d.SiteId, d.InspectionAgencyId })
  2642. .HasConstraintName("FK_FmsWorkRequest_CmPartner");
  2643. entity.HasOne(d => d.CmUser)
  2644. .WithMany(p => p.FmsWorkRequestCmUser)
  2645. .HasForeignKey(d => d.RejectUserId)
  2646. .HasConstraintName("FK__FmsWorkRequest__CmUser1_AsRejectUserId");
  2647. entity.HasOne(d => d.CmUserNavigation)
  2648. .WithMany(p => p.FmsWorkRequestCmUserNavigation)
  2649. .HasForeignKey(d => d.RequestUserId)
  2650. .HasConstraintName("FK__FmsWorkRequest__CmUser_AsRequestUserId");
  2651. entity.HasOne(d => d.FmsWorkSchedule)
  2652. .WithMany(p => p.FmsWorkRequest)
  2653. .HasForeignKey(d => new { d.SiteId, d.WorkScheduleId })
  2654. .HasConstraintName("FK__FmsWorkRequest__FmsWorkSchedule");
  2655. entity.HasOne(d => d.CmFile)
  2656. .WithMany(p => p.FmsWorkRequest)
  2657. .HasForeignKey(d => new { d.SiteId, d.FileId })
  2658. .HasConstraintName("FK_FmsWorkRequest_CmFile");
  2659. });
  2660. modelBuilder.Entity<FmsWorkRequestToFacility>(entity => {
  2661. entity.HasKey(e => new { e.SiteId, e.WorkRequestId, e.FacilityCode })
  2662. .HasName("PK__FmsWorkR__626EDDD7021403C4");
  2663. entity.HasOne(d => d.CmFacility)
  2664. .WithMany(p => p.FmsWorkRequestToFacility)
  2665. .HasForeignKey(d => new { d.SiteId, d.FacilityCode })
  2666. .OnDelete(DeleteBehavior.ClientSetNull)
  2667. .HasConstraintName("FK_FmsWorkRequestToFacility_CmFacility");
  2668. entity.HasOne(d => d.FmsWorkRequest)
  2669. .WithMany(p => p.FmsWorkRequestToFacility)
  2670. .HasForeignKey(d => new { d.SiteId, d.WorkRequestId })
  2671. .HasConstraintName("FK__FmsWorkRequestToFacility__FmsWorkRequest");
  2672. });
  2673. modelBuilder.Entity<FmsWorkResult>(entity => {
  2674. entity.HasKey(e => new { e.SiteId, e.WorkRequestId });
  2675. entity.HasOne(d => d.FmsWorkCodeCauseClass)
  2676. .WithMany(p => p.FmsWorkResult)
  2677. .HasForeignKey(d => new { d.SiteId, d.CauseClassId })
  2678. .HasConstraintName("FK__FmsWorkResult__FmsWorkCodeCauseClass");
  2679. entity.HasOne(d => d.CmUser)
  2680. .WithMany(p => p.FmsWorkResultCmUser)
  2681. .HasForeignKey(d => d.ConfirmedUserId)
  2682. .HasConstraintName("FK__FmsWorkResult__CmUser1_AsConfirmedUserId");
  2683. entity.HasOne(d => d.FmsWorkOrder)
  2684. .WithOne(p => p.FmsWorkResult)
  2685. .HasForeignKey<FmsWorkResult>(d => new { d.SiteId, d.WorkRequestId })
  2686. .OnDelete(DeleteBehavior.ClientSetNull)
  2687. .HasConstraintName("FK__FmsWorkResult__FmsWorkOrder");
  2688. entity.HasOne(d => d.FmsWorkRequest)
  2689. .WithOne(p => p.FmsWorkResult)
  2690. .HasForeignKey<FmsWorkResult>(d => new { d.SiteId, d.WorkRequestId })
  2691. .OnDelete(DeleteBehavior.ClientSetNull)
  2692. .HasConstraintName("FK__FmsWorkResult__FmsWorkRequest");
  2693. entity.HasOne(d => d.CmUserNavigation)
  2694. .WithMany(p => p.FmsWorkResultCmUserNavigation)
  2695. .HasForeignKey(d => d.WorkerUserId)
  2696. .OnDelete(DeleteBehavior.ClientSetNull)
  2697. .HasConstraintName("FK__FmsWorkResult__CmUser_AsWorkerUserId");
  2698. });
  2699. modelBuilder.Entity<FmsWorkResultCheckItem>(entity => {
  2700. entity.HasKey(e => e.CheckItemId)
  2701. .HasName("PK_FmsWorkResultCheckItem_1");
  2702. entity.Property(e => e.CheckItemId)
  2703. .HasComment("작업이력 고유번호")
  2704. .ValueGeneratedOnAdd();
  2705. entity.HasOne(d => d.CmFacility)
  2706. .WithMany(p => p.FmsWorkResultCheckItem)
  2707. .HasForeignKey(d => new { d.SiteId, d.FacilityCode })
  2708. .HasConstraintName("FK__FmsWorkResultCheckItem__CmFacility");
  2709. entity.HasOne(d => d.FmsWorkResult)
  2710. .WithMany(p => p.FmsWorkResultCheckItem)
  2711. .HasForeignKey(d => new { d.SiteId, d.WorkRequestId })
  2712. .HasConstraintName("FK__FmsWorkResultCheckItem__FmsWorkResult");
  2713. entity.HasOne(d => d.FmsFacilityCheckItem)
  2714. .WithMany(p => p.FmsWorkResultCheckItem)
  2715. .HasForeignKey(d => new { d.SiteId, d.FacilityCode, d.CheckItemId })
  2716. .HasConstraintName("FK__FmsWorkResultCheckItem__FmsFacilityCheckItem");
  2717. });
  2718. modelBuilder.Entity<FmsWorkResultCheckItemMaterial>(entity => {
  2719. entity.HasKey(e => e.CheckItemMaterialId)
  2720. .HasName("PK_FmsWorkResultCheckItemMaterial_1");
  2721. entity.HasOne(d => d.CheckItem)
  2722. .WithMany(p => p.FmsWorkResultCheckItemMaterial)
  2723. .HasForeignKey(d => d.CheckItemId)
  2724. .OnDelete(DeleteBehavior.ClientSetNull)
  2725. .HasConstraintName("FK_FmsWorkResultCheckItemMaterial_FmsWorkResultCheckItem");
  2726. entity.HasOne(d => d.FmsMaterial)
  2727. .WithMany(p => p.FmsWorkResultCheckItemMaterial)
  2728. .HasForeignKey(d => new { d.SiteId, d.MaterialId })
  2729. .OnDelete(DeleteBehavior.ClientSetNull)
  2730. .HasConstraintName("FK_FmsWorkResultCheckItemMaterial_FmsMaterial");
  2731. entity.HasOne(d => d.FmsWorkResult)
  2732. .WithMany(p => p.FmsWorkResultCheckItemMaterial)
  2733. .HasForeignKey(d => new { d.SiteId, d.WorkRequestId })
  2734. .OnDelete(DeleteBehavior.ClientSetNull)
  2735. .HasConstraintName("FK_FmsWorkResultCheckItemMaterial_FmsWorkResult");
  2736. });
  2737. modelBuilder.Entity<FmsWorkResultFile>(entity => {
  2738. entity.HasKey(e => new { e.SiteId, e.WorkRequestId })
  2739. .HasName("PK__FmsWorkR__F33BEC723A2A01CC");
  2740. entity.HasOne(d => d.CmFile)
  2741. .WithMany(p => p.FmsWorkResultFile)
  2742. .HasForeignKey(d => new { d.SiteId, d.FileId })
  2743. .OnDelete(DeleteBehavior.ClientSetNull)
  2744. .HasConstraintName("FK__FmsWorkResultFile__CmFile");
  2745. entity.HasOne(d => d.FmsWorkResult)
  2746. .WithOne(p => p.FmsWorkResultFile)
  2747. .HasForeignKey<FmsWorkResultFile>(d => new { d.SiteId, d.WorkRequestId })
  2748. .OnDelete(DeleteBehavior.ClientSetNull)
  2749. .HasConstraintName("FK__FmsWorkResultFile__FmsWorkResult");
  2750. });
  2751. modelBuilder.Entity<FmsWorkResultLaw>(entity => {
  2752. entity.HasKey(e => new { e.SiteId, e.WorkRequestId })
  2753. .HasName("PK__FmsWorkR__F33BEC72E18C69BB");
  2754. entity.HasOne(d => d.FmsWorkResult)
  2755. .WithOne(p => p.FmsWorkResultLaw)
  2756. .HasForeignKey<FmsWorkResultLaw>(d => new { d.SiteId, d.WorkRequestId })
  2757. .OnDelete(DeleteBehavior.ClientSetNull)
  2758. .HasConstraintName("FK__FmsWorkResultLaw__FmsWorkResult");
  2759. });
  2760. modelBuilder.Entity<FmsWorkResultToFacility>(entity => {
  2761. entity.HasKey(e => new { e.SiteId, e.WorkRequestId, e.FacilityCode })
  2762. .HasName("PK__FmsWorkR__85930B3F1D5F5DA3");
  2763. entity.HasOne(d => d.CmFacility)
  2764. .WithMany(p => p.FmsWorkResultToFacility)
  2765. .HasForeignKey(d => new { d.SiteId, d.FacilityCode })
  2766. .OnDelete(DeleteBehavior.ClientSetNull)
  2767. .HasConstraintName("FK__FmsWorkResultToFacility__CmFacility");
  2768. entity.HasOne(d => d.FmsWorkResult)
  2769. .WithMany(p => p.FmsWorkResultToFacility)
  2770. .HasForeignKey(d => new { d.SiteId, d.WorkRequestId })
  2771. .HasConstraintName("FK__FmsWorkResultToFacility__FmsWorkOrder");
  2772. });
  2773. modelBuilder.Entity<FmsWorkSchedule>(entity => {
  2774. entity.HasKey(e => new { e.SiteId, e.WorkScheduleId })
  2775. .HasName("PK__FmsWorkS__45B67F5033D5F129");
  2776. entity.Property(e => e.WorkScheduleId)
  2777. .HasComment("작업일정 고유번호")
  2778. .ValueGeneratedOnAdd();
  2779. entity.HasOne(d => d.WorkType)
  2780. .WithMany(p => p.FmsWorkSchedule)
  2781. .HasForeignKey(d => d.WorkTypeId)
  2782. .OnDelete(DeleteBehavior.ClientSetNull)
  2783. .HasConstraintName("FK__FmsWorkSchedule__FmsWorkCodeWorkType");
  2784. entity.HasOne(d => d.CmBusinessField)
  2785. .WithMany(p => p.FmsWorkSchedule)
  2786. .HasForeignKey(d => new { d.BusinessFieldId })
  2787. .OnDelete(DeleteBehavior.ClientSetNull)
  2788. .HasConstraintName("FK__FmsWorkSchedule__CmBusinessField");
  2789. entity.HasOne(d => d.FmsWorkCodeCycleUnit)
  2790. .WithMany(p => p.FmsWorkSchedule)
  2791. .HasForeignKey(d => new { d.SiteId, d.CycleUnitId })
  2792. .OnDelete(DeleteBehavior.ClientSetNull)
  2793. .HasConstraintName("FK__FmsWorkSchedule__FmsWorkCodeCycleUnit");
  2794. entity.HasOne(d => d.FmsWorkCodeHolidayWorkType)
  2795. .WithMany(p => p.FmsWorkSchedule)
  2796. .HasForeignKey(d => new { d.SiteId, d.HolidayWorkTypeId })
  2797. .OnDelete(DeleteBehavior.ClientSetNull)
  2798. .HasConstraintName("FK__FmsWorkSchedule__FmsWorkCodeHolidayWorkType");
  2799. entity.HasOne(d => d.CmPartner)
  2800. .WithMany(p => p.FmsWorkSchedule)
  2801. .HasForeignKey(d => new { d.SiteId, d.InspectionAgencyId })
  2802. .HasConstraintName("FK_FmsWorkSchedule_CmPartner");
  2803. entity.HasOne(d => d.CmUser)
  2804. .WithMany(p => p.FmsWorkSchedule)
  2805. .HasForeignKey(d => d.UpdateUserId)
  2806. .OnDelete(DeleteBehavior.ClientSetNull)
  2807. .HasConstraintName("FK__FmsWorkSchedule__CmUser");
  2808. entity.HasOne(d => d.CmFile)
  2809. .WithMany(p => p.FmsWorkSchedule)
  2810. .HasForeignKey(d => new { d.SiteId, d.FileId })
  2811. .HasConstraintName("FK_FmsWorkSchedule_CmFile");
  2812. });
  2813. modelBuilder.Entity<FmsWorkScheduleToFacility>(entity => {
  2814. entity.HasKey(e => new { e.SiteId, e.WorkScheduleId, e.FacilityCode })
  2815. .HasName("PK__FmsWorkS__331E981DC77EA20D");
  2816. entity.HasOne(d => d.CmFacility)
  2817. .WithMany(p => p.FmsWorkScheduleToFacility)
  2818. .HasForeignKey(d => new { d.SiteId, d.FacilityCode })
  2819. .OnDelete(DeleteBehavior.ClientSetNull)
  2820. .HasConstraintName("FK_FmsWorkScheduleToFacility_CmFacility");
  2821. entity.HasOne(d => d.FmsWorkSchedule)
  2822. .WithMany(p => p.FmsWorkScheduleToFacility)
  2823. .HasForeignKey(d => new { d.SiteId, d.WorkScheduleId })
  2824. .OnDelete(DeleteBehavior.ClientSetNull)
  2825. .HasConstraintName("FK__FmsWorkScheduleToFacility__FmsWorkSchedule");
  2826. });
  2827. modelBuilder.Entity<WeatherDongNaeForecast>(entity => {
  2828. entity.HasKey(e => new { e.BaseTime, e.ForecastTime });
  2829. });
  2830. modelBuilder.Entity<WeatherDustSidoInfo>(entity => {
  2831. entity.HasNoKey();
  2832. });
  2833. modelBuilder.Entity<WeatherShortTermForecast>(entity => {
  2834. entity.HasNoKey();
  2835. });
  2836. modelBuilder.Entity<WeatherShortTermNowValue>(entity => {
  2837. entity.HasNoKey();
  2838. });
  2839. modelBuilder.Entity<SitemapAuth>(entity => {
  2840. entity.Property(e => e.SitemapAuthId)
  2841. .HasDefaultValueSql("newid()");
  2842. });
  2843. modelBuilder.Entity<CmTenant>(entity => {
  2844. entity.HasKey(e => new { e.SiteId, e.TenantId });
  2845. entity.Property(e => e.TenantId)
  2846. .HasComment("입점업체 고유 번호")
  2847. .ValueGeneratedOnAdd();
  2848. });
  2849. modelBuilder.Entity<FmsWorkCodeDetailType>(entity => {
  2850. entity.HasKey(e => e.WorkDetailTypeId)
  2851. .HasName("PK_FmsWorkCodeDetailType");
  2852. entity.HasOne(d => d.FmsWorkCodeType)
  2853. .WithMany()
  2854. .HasForeignKey(d => new { d.WorkTypeId })
  2855. .OnDelete(DeleteBehavior.ClientSetNull)
  2856. .HasConstraintName("FK_FmsWorkCodeDetailType_FmsWorkCodeType");
  2857. });
  2858. modelBuilder.Entity<FmsWorkRequestToAccident>(entity => {
  2859. entity.HasKey(e => new { e.SiteId, e.WorkRequestId, e.AccidentId })
  2860. .HasName("PK_FmsWorkRequestToAccident");
  2861. entity.HasOne(d => d.FmsAccident)
  2862. .WithMany(p => p.FmsWorkRequestToAccident)
  2863. .HasForeignKey(d => new { d.SiteId, d.AccidentId })
  2864. .OnDelete(DeleteBehavior.Cascade)
  2865. .HasConstraintName("FK_FmsWorkRequestToAccident_FmsAccident");
  2866. entity.HasOne(d => d.FmsWorkRequest)
  2867. .WithMany(p => p.FmsWorkRequestToAccident)
  2868. .HasForeignKey(d => new { d.SiteId, d.WorkRequestId })
  2869. .HasConstraintName("FK_FmsWorkRequestToAccident_FmsWorkRequest");
  2870. });
  2871. modelBuilder.Entity<FmsWorkRequestToComplaint>(entity => {
  2872. entity.HasKey(e => new { e.SiteId, e.WorkRequestId, e.ComplaintId })
  2873. .HasName("PK_FmsWorkRequestToComplaint");
  2874. entity.HasOne(d => d.FmsComplaints)
  2875. .WithMany(p => p.FmsWorkRequestToComplaint)
  2876. .HasForeignKey(d => new { d.SiteId, d.ComplaintId })
  2877. .OnDelete(DeleteBehavior.Cascade)
  2878. .HasConstraintName("FK_FmsWorkRequestToComplaint_FmsComplaints");
  2879. entity.HasOne(d => d.FmsWorkRequest)
  2880. .WithMany(p => p.FmsWorkRequestToComplaint)
  2881. .HasForeignKey(d => new { d.SiteId, d.WorkRequestId })
  2882. .HasConstraintName("FK_FmsWorkRequestToComplaint_FmsWorkRequest");
  2883. });
  2884. modelBuilder.Entity<FmsMaterialReleaseDetail>(entity => {
  2885. entity.HasKey(e => new { e.MaterialReleaseDetailId });
  2886. entity.Property(e => e.MaterialReleaseDetailId)
  2887. .HasComment("출고상세 고유번호")
  2888. .ValueGeneratedOnAdd();
  2889. entity.HasOne(d => d.FmsMaterialRelease)
  2890. .WithMany(p => p.FmsMaterialReleaseDetail)
  2891. .HasForeignKey(d => new { d.SiteId, d.MaterialReleaseId })
  2892. .HasConstraintName("FK_FmsMaterialReleaseDetail_FmsMaterialRelease");
  2893. entity.HasOne(d => d.FmsMaterialStored)
  2894. .WithMany(p => p.FmsMaterialReleaseDetail)
  2895. .HasForeignKey(d => new { d.SiteId, d.MaterialStoredId })
  2896. .HasConstraintName("FK_FmsMaterialReleaseDetail_FmsMaterialStored");
  2897. });
  2898. modelBuilder.Entity<FmsAlarmPoint>(entity => {
  2899. entity.HasKey(e => new { e.SiteId, e.FacilityCode, e.PropertyId });
  2900. });
  2901. modelBuilder.Entity<FmsAlarmLog>(entity => {
  2902. entity.HasKey(e => new { e.SiteId, e.FacilityCode, e.PropertyId, e.CreatedDateTime });
  2903. });
  2904. modelBuilder.Entity<MobileShortcut>(entity => {
  2905. entity.Property(e => e.MobileShortcutId)
  2906. .HasComment("모바일 단축메뉴 고유번호")
  2907. .ValueGeneratedOnAdd();
  2908. entity.HasOne(d => d.CmUser)
  2909. .WithMany(p => p.MobileShortcuts)
  2910. .HasForeignKey(d => d.UserId)
  2911. .OnDelete(DeleteBehavior.Cascade)
  2912. .HasConstraintName("FK_MobileShortcut_CmUser");
  2913. entity.HasOne(d => d.Sitemap)
  2914. .WithMany(p => p.MobileShortcuts)
  2915. .HasForeignKey(d => d.SitemapId)
  2916. .OnDelete(DeleteBehavior.Cascade)
  2917. .HasConstraintName("FK_MobileShortcut_Sitemap");
  2918. });
  2919. modelBuilder.Entity<CmInvestigation1CodeGroup>(entity => {
  2920. entity.HasKey(e => new { e.InvestigationGroupId });
  2921. entity.Property(e => e.InvestigationGroupId)
  2922. .HasComment("정보조사 그룹 고유번호")
  2923. .ValueGeneratedOnAdd();
  2924. });
  2925. modelBuilder.Entity<CmInvestigation1CodeType>(entity => {
  2926. entity.HasKey(e => new { e.InvestigationTypeId });
  2927. entity.Property(e => e.InvestigationTypeId)
  2928. .HasComment("정보조사 유형 고유번호")
  2929. .ValueGeneratedOnAdd();
  2930. });
  2931. modelBuilder.Entity<CmInvestigation2CodeGroup>(entity => {
  2932. entity.HasKey(e => new { e.InvestigationGroupId });
  2933. entity.Property(e => e.InvestigationGroupId)
  2934. .HasComment("정보조사 그룹 고유번호")
  2935. .ValueGeneratedOnAdd();
  2936. });
  2937. modelBuilder.Entity<CmInvestigation2CodeType>(entity => {
  2938. entity.HasKey(e => new { e.InvestigationTypeId });
  2939. entity.Property(e => e.InvestigationTypeId)
  2940. .HasComment("정보조사 유형 고유번호")
  2941. .ValueGeneratedOnAdd();
  2942. });
  2943. modelBuilder.Entity<CmInvestigation3CodeGroup>(entity => {
  2944. entity.HasKey(e => new { e.InvestigationGroupId });
  2945. entity.Property(e => e.InvestigationGroupId)
  2946. .HasComment("정보조사 그룹 고유번호")
  2947. .ValueGeneratedOnAdd();
  2948. });
  2949. modelBuilder.Entity<CmInvestigation3CodeType>(entity => {
  2950. entity.HasKey(e => new { e.InvestigationTypeId });
  2951. entity.Property(e => e.InvestigationTypeId)
  2952. .HasComment("정보조사 유형 고유번호")
  2953. .ValueGeneratedOnAdd();
  2954. });
  2955. modelBuilder.Entity<CmInvestigation1>(entity => {
  2956. entity.HasKey(e => new { e.SiteId, e.InvestigationId });
  2957. entity.Property(e => e.InvestigationId)
  2958. .HasComment("정보조사 고유 번호")
  2959. .ValueGeneratedOnAdd();
  2960. });
  2961. modelBuilder.Entity<CmInvestigation1History>(entity => {
  2962. entity.HasKey(e => new { e.SiteId, e.InvestigationId, e.HistoryId });
  2963. entity.Property(e => e.HistoryId)
  2964. .HasComment("설비 정보조사 수정 고유번호")
  2965. .ValueGeneratedOnAdd();
  2966. });
  2967. modelBuilder.Entity<CmInvestigation2>(entity => {
  2968. entity.HasKey(e => new { e.SiteId, e.InvestigationId });
  2969. entity.Property(e => e.InvestigationId)
  2970. .HasComment("정보조사 고유 번호")
  2971. .ValueGeneratedOnAdd();
  2972. });
  2973. modelBuilder.Entity<CmInvestigation2History>(entity => {
  2974. entity.HasKey(e => new { e.SiteId, e.InvestigationId, e.HistoryId });
  2975. entity.Property(e => e.HistoryId)
  2976. .HasComment("설비 정보조사 수정 고유번호")
  2977. .ValueGeneratedOnAdd();
  2978. });
  2979. modelBuilder.Entity<CmInvestigation3>(entity => {
  2980. entity.HasKey(e => new { e.SiteId, e.InvestigationId });
  2981. entity.Property(e => e.InvestigationId)
  2982. .HasComment("정보조사 고유 번호")
  2983. .ValueGeneratedOnAdd();
  2984. });
  2985. modelBuilder.Entity<CmInvestigation3History>(entity => {
  2986. entity.HasKey(e => new { e.SiteId, e.InvestigationId, e.HistoryId });
  2987. entity.Property(e => e.HistoryId)
  2988. .HasComment("설비 정보조사 수정 고유번호")
  2989. .ValueGeneratedOnAdd();
  2990. });
  2991. modelBuilder.Entity<FmsFacilityState>(entity => {
  2992. entity.HasKey(e => new { e.FacilityStateId });
  2993. entity.Property(e => e.FacilityStateId)
  2994. .HasComment("주요 설비 현황 고유번호")
  2995. .ValueGeneratedOnAdd();
  2996. });
  2997. modelBuilder.Entity<FmsFacilityStateDetail>(entity => {
  2998. entity.HasKey(e => new { e.FacilityStateDetailId });
  2999. entity.Property(e => e.FacilityStateDetailId)
  3000. .HasComment("주요 설비 현황 상세 고유번호")
  3001. .ValueGeneratedOnAdd();
  3002. entity.HasOne(d => d.CmSite)
  3003. .WithMany(p => p.FmsFacilityStateDetail)
  3004. .HasForeignKey(d => d.SiteId)
  3005. .HasConstraintName("FK__FmsFacilityStateDetail__CmSite");
  3006. entity.HasOne(d => d.FmsFacilityState)
  3007. .WithMany(p => p.FmsFacilityStateDetail)
  3008. .HasForeignKey(d => d.FacilityStateId)
  3009. .HasConstraintName("FK_FmsFacilityStateDetail_FmsFacilityState");
  3010. });
  3011. modelBuilder.Entity<CmSurvey>(entity => {
  3012. entity.HasKey(e => new { e.SurveyId });
  3013. entity.Property(e => e.SurveyId)
  3014. .HasComment("설문지 고유번호")
  3015. .ValueGeneratedOnAdd();
  3016. });
  3017. modelBuilder.Entity<FmsEnergyAnalysis>(entity => {
  3018. entity.HasKey(e => new { e.SiteId, e.FuelTypeId, e.FuelPriceId, e.PriceTypeId, e.Year, e.Month })
  3019. .HasName("PK_FmsEnergyAnalysis");
  3020. entity.HasOne(d => d.CmSite)
  3021. .WithMany(p => p.FmsEnergyAnalysis)
  3022. .HasForeignKey(d => d.SiteId)
  3023. .OnDelete(DeleteBehavior.ClientSetNull)
  3024. .HasConstraintName("FK_FmsEnergyAnalysis__CmSite");
  3025. entity.HasOne(d => d.FuelType)
  3026. .WithMany(p => p.FmsEnergyAnalysis)
  3027. .HasForeignKey(d => d.FuelTypeId)
  3028. .OnDelete(DeleteBehavior.ClientSetNull)
  3029. .HasConstraintName("FK_FmsEnergyAnalysis__BemsFuelType");
  3030. entity.HasOne(d => d.PriceType)
  3031. .WithMany(p => p.FmsEnergyAnalysis)
  3032. .HasForeignKey(d => d.PriceTypeId)
  3033. .OnDelete(DeleteBehavior.ClientSetNull)
  3034. .HasConstraintName("FK_FmsEnergyAnalysis__BemsPriceType");
  3035. });
  3036. OnModelCreatingPartial(modelBuilder);
  3037. }
  3038. partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
  3039. }
  3040. }