| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675367636773678367936803681368236833684368536863687368836893690369136923693369436953696369736983699370037013702370337043705370637073708370937103711371237133714371537163717371837193720372137223723372437253726372737283729373037313732373337343735373637373738373937403741374237433744374537463747374837493750375137523753375437553756375737583759376037613762376337643765376637673768376937703771377237733774377537763777377837793780378137823783378437853786378737883789379037913792379337943795379637973798379938003801380238033804380538063807380838093810381138123813381438153816381738183819382038213822382338243825382638273828382938303831383238333834383538363837383838393840384138423843384438453846384738483849385038513852385338543855385638573858385938603861386238633864386538663867386838693870387138723873387438753876387738783879388038813882388338843885388638873888388938903891389238933894389538963897389838993900390139023903390439053906390739083909391039113912391339143915391639173918391939203921392239233924392539263927392839293930393139323933393439353936393739383939394039413942394339443945394639473948394939503951395239533954395539563957395839593960396139623963396439653966396739683969397039713972397339743975397639773978397939803981398239833984398539863987398839893990399139923993399439953996399739983999400040014002400340044005400640074008400940104011401240134014401540164017401840194020402140224023402440254026402740284029403040314032403340344035403640374038403940404041404240434044404540464047404840494050405140524053405440554056405740584059406040614062406340644065406640674068406940704071407240734074407540764077407840794080408140824083408440854086408740884089409040914092409340944095409640974098409941004101410241034104410541064107410841094110411141124113411441154116411741184119412041214122412341244125412641274128412941304131413241334134413541364137413841394140414141424143414441454146414741484149415041514152415341544155415641574158415941604161416241634164416541664167416841694170417141724173417441754176417741784179418041814182418341844185418641874188418941904191419241934194419541964197419841994200420142024203420442054206420742084209421042114212421342144215421642174218421942204221422242234224422542264227422842294230423142324233423442354236423742384239424042414242424342444245424642474248424942504251425242534254425542564257425842594260426142624263426442654266426742684269427042714272427342744275427642774278427942804281428242834284428542864287428842894290429142924293429442954296429742984299430043014302430343044305430643074308430943104311431243134314431543164317431843194320432143224323432443254326432743284329433043314332433343344335433643374338433943404341434243434344434543464347434843494350435143524353435443554356435743584359436043614362436343644365436643674368436943704371437243734374437543764377437843794380438143824383438443854386438743884389439043914392439343944395439643974398439944004401440244034404440544064407440844094410441144124413441444154416441744184419442044214422442344244425442644274428442944304431443244334434443544364437443844394440444144424443444444454446444744484449445044514452445344544455445644574458445944604461446244634464446544664467446844694470447144724473447444754476447744784479448044814482448344844485448644874488448944904491449244934494449544964497449844994500450145024503450445054506450745084509451045114512451345144515451645174518451945204521452245234524452545264527452845294530453145324533453445354536453745384539454045414542454345444545454645474548454945504551455245534554455545564557455845594560456145624563456445654566456745684569457045714572457345744575457645774578457945804581458245834584458545864587458845894590459145924593459445954596459745984599460046014602460346044605460646074608460946104611461246134614461546164617461846194620462146224623462446254626462746284629463046314632463346344635463646374638463946404641464246434644464546464647464846494650465146524653465446554656465746584659466046614662466346644665466646674668466946704671467246734674467546764677467846794680468146824683468446854686468746884689469046914692469346944695469646974698469947004701470247034704470547064707470847094710471147124713471447154716471747184719472047214722472347244725472647274728472947304731473247334734473547364737473847394740474147424743474447454746474747484749475047514752475347544755475647574758475947604761476247634764476547664767476847694770477147724773477447754776477747784779478047814782478347844785478647874788478947904791479247934794479547964797479847994800480148024803480448054806480748084809481048114812481348144815481648174818481948204821482248234824482548264827482848294830483148324833483448354836483748384839484048414842484348444845484648474848484948504851485248534854485548564857485848594860486148624863486448654866486748684869487048714872487348744875487648774878487948804881488248834884488548864887488848894890489148924893489448954896489748984899490049014902490349044905490649074908490949104911491249134914491549164917491849194920492149224923492449254926492749284929493049314932493349344935493649374938493949404941494249434944494549464947494849494950495149524953495449554956495749584959496049614962496349644965496649674968496949704971497249734974497549764977497849794980498149824983498449854986498749884989499049914992499349944995499649974998499950005001500250035004500550065007500850095010501150125013501450155016501750185019502050215022502350245025502650275028502950305031503250335034503550365037503850395040504150425043504450455046504750485049505050515052505350545055505650575058505950605061506250635064506550665067506850695070507150725073507450755076507750785079508050815082508350845085508650875088508950905091509250935094509550965097509850995100510151025103510451055106510751085109511051115112511351145115511651175118511951205121512251235124512551265127512851295130513151325133513451355136513751385139514051415142514351445145514651475148514951505151515251535154515551565157515851595160516151625163516451655166516751685169517051715172517351745175517651775178517951805181518251835184518551865187518851895190519151925193519451955196519751985199520052015202520352045205520652075208520952105211521252135214521552165217521852195220522152225223522452255226522752285229523052315232523352345235523652375238523952405241524252435244524552465247524852495250525152525253525452555256525752585259526052615262526352645265526652675268526952705271527252735274527552765277527852795280528152825283528452855286528752885289529052915292529352945295529652975298529953005301530253035304530553065307530853095310531153125313531453155316531753185319532053215322532353245325532653275328532953305331533253335334533553365337533853395340534153425343534453455346534753485349535053515352535353545355535653575358535953605361536253635364536553665367536853695370537153725373537453755376537753785379538053815382538353845385538653875388538953905391539253935394539553965397539853995400540154025403540454055406540754085409541054115412541354145415541654175418541954205421542254235424542554265427542854295430543154325433543454355436543754385439544054415442544354445445544654475448544954505451545254535454545554565457545854595460546154625463546454655466546754685469547054715472547354745475547654775478547954805481548254835484548554865487548854895490549154925493549454955496549754985499550055015502550355045505550655075508550955105511551255135514551555165517551855195520552155225523552455255526552755285529553055315532553355345535553655375538553955405541554255435544554555465547554855495550555155525553555455555556555755585559556055615562556355645565556655675568556955705571557255735574557555765577557855795580558155825583558455855586558755885589559055915592559355945595559655975598559956005601560256035604560556065607560856095610561156125613561456155616561756185619562056215622562356245625562656275628562956305631563256335634563556365637563856395640564156425643564456455646564756485649565056515652565356545655565656575658565956605661566256635664566556665667566856695670567156725673567456755676567756785679568056815682568356845685568656875688568956905691569256935694569556965697569856995700570157025703570457055706570757085709571057115712571357145715571657175718571957205721572257235724572557265727572857295730573157325733573457355736573757385739574057415742574357445745574657475748574957505751575257535754575557565757575857595760576157625763576457655766576757685769577057715772577357745775577657775778577957805781578257835784578557865787578857895790579157925793579457955796579757985799580058015802580358045805580658075808580958105811581258135814581558165817581858195820582158225823582458255826582758285829583058315832583358345835583658375838583958405841584258435844584558465847584858495850585158525853585458555856585758585859586058615862586358645865586658675868586958705871587258735874587558765877587858795880588158825883588458855886588758885889589058915892589358945895589658975898589959005901590259035904590559065907590859095910591159125913591459155916591759185919592059215922592359245925592659275928592959305931593259335934593559365937593859395940594159425943594459455946594759485949595059515952595359545955595659575958595959605961596259635964596559665967596859695970597159725973597459755976597759785979598059815982598359845985598659875988598959905991599259935994599559965997599859996000600160026003600460056006600760086009601060116012601360146015601660176018601960206021602260236024602560266027602860296030603160326033603460356036603760386039604060416042604360446045604660476048604960506051605260536054605560566057605860596060606160626063606460656066606760686069607060716072607360746075607660776078607960806081608260836084608560866087608860896090609160926093609460956096609760986099610061016102610361046105610661076108610961106111611261136114611561166117611861196120612161226123612461256126612761286129613061316132613361346135613661376138613961406141614261436144614561466147614861496150615161526153615461556156615761586159616061616162616361646165616661676168616961706171617261736174617561766177617861796180618161826183618461856186618761886189619061916192619361946195619661976198619962006201620262036204620562066207620862096210621162126213621462156216621762186219622062216222622362246225622662276228622962306231623262336234623562366237623862396240624162426243624462456246624762486249625062516252625362546255625662576258625962606261626262636264626562666267626862696270627162726273627462756276627762786279628062816282628362846285628662876288628962906291629262936294629562966297629862996300630163026303630463056306630763086309631063116312631363146315631663176318631963206321632263236324632563266327632863296330633163326333633463356336633763386339634063416342634363446345634663476348634963506351635263536354635563566357635863596360636163626363636463656366636763686369637063716372637363746375637663776378637963806381638263836384638563866387638863896390639163926393639463956396639763986399640064016402640364046405640664076408640964106411641264136414641564166417641864196420642164226423642464256426642764286429643064316432643364346435643664376438643964406441644264436444644564466447644864496450645164526453645464556456645764586459646064616462646364646465646664676468646964706471647264736474647564766477647864796480648164826483648464856486648764886489649064916492649364946495649664976498649965006501650265036504650565066507650865096510651165126513651465156516651765186519652065216522652365246525652665276528652965306531653265336534653565366537653865396540654165426543654465456546654765486549655065516552655365546555655665576558655965606561656265636564656565666567656865696570657165726573657465756576657765786579658065816582658365846585658665876588658965906591659265936594659565966597659865996600660166026603660466056606660766086609661066116612661366146615661666176618661966206621662266236624662566266627662866296630663166326633663466356636663766386639664066416642664366446645664666476648664966506651665266536654665566566657665866596660666166626663666466656666666766686669667066716672667366746675667666776678667966806681668266836684668566866687668866896690669166926693669466956696669766986699670067016702670367046705670667076708670967106711671267136714671567166717671867196720672167226723672467256726672767286729673067316732673367346735673667376738673967406741674267436744674567466747674867496750675167526753675467556756675767586759676067616762676367646765676667676768676967706771677267736774677567766777677867796780678167826783678467856786678767886789679067916792679367946795679667976798679968006801680268036804680568066807680868096810681168126813681468156816681768186819682068216822682368246825682668276828682968306831683268336834683568366837683868396840684168426843684468456846684768486849685068516852685368546855685668576858685968606861686268636864686568666867686868696870687168726873687468756876687768786879688068816882688368846885688668876888688968906891689268936894689568966897689868996900690169026903690469056906690769086909691069116912691369146915691669176918691969206921692269236924692569266927692869296930693169326933693469356936693769386939694069416942694369446945694669476948694969506951695269536954695569566957695869596960696169626963696469656966696769686969697069716972697369746975697669776978697969806981698269836984698569866987698869896990699169926993699469956996699769986999700070017002700370047005700670077008700970107011701270137014701570167017701870197020702170227023702470257026702770287029703070317032703370347035703670377038703970407041704270437044704570467047704870497050705170527053705470557056705770587059706070617062706370647065706670677068706970707071707270737074707570767077707870797080708170827083708470857086708770887089709070917092709370947095709670977098709971007101710271037104710571067107710871097110711171127113711471157116711771187119712071217122712371247125712671277128712971307131713271337134713571367137713871397140714171427143714471457146714771487149715071517152715371547155715671577158715971607161716271637164716571667167716871697170717171727173717471757176717771787179718071817182718371847185718671877188718971907191719271937194719571967197719871997200720172027203720472057206720772087209721072117212721372147215721672177218721972207221722272237224722572267227722872297230723172327233723472357236723772387239724072417242724372447245724672477248724972507251725272537254725572567257725872597260726172627263726472657266726772687269727072717272727372747275727672777278727972807281728272837284728572867287728872897290729172927293729472957296729772987299730073017302730373047305730673077308730973107311731273137314731573167317731873197320732173227323732473257326732773287329733073317332733373347335733673377338733973407341734273437344734573467347734873497350735173527353735473557356735773587359736073617362736373647365736673677368736973707371737273737374737573767377737873797380738173827383738473857386738773887389739073917392739373947395739673977398739974007401740274037404740574067407740874097410741174127413741474157416741774187419742074217422742374247425742674277428742974307431743274337434743574367437743874397440744174427443744474457446744774487449745074517452745374547455745674577458745974607461746274637464746574667467746874697470747174727473747474757476747774787479748074817482748374847485748674877488748974907491749274937494749574967497749874997500750175027503750475057506750775087509751075117512751375147515751675177518751975207521752275237524752575267527752875297530753175327533753475357536753775387539754075417542754375447545754675477548754975507551755275537554755575567557755875597560756175627563756475657566756775687569757075717572757375747575757675777578757975807581758275837584758575867587758875897590759175927593759475957596759775987599760076017602760376047605760676077608760976107611761276137614761576167617761876197620762176227623762476257626762776287629763076317632763376347635763676377638763976407641764276437644764576467647764876497650765176527653765476557656765776587659766076617662766376647665766676677668766976707671767276737674767576767677767876797680768176827683768476857686768776887689769076917692769376947695769676977698769977007701770277037704770577067707770877097710771177127713771477157716771777187719772077217722772377247725772677277728772977307731773277337734773577367737773877397740774177427743774477457746774777487749775077517752775377547755775677577758775977607761776277637764776577667767776877697770777177727773777477757776777777787779778077817782778377847785778677877788778977907791779277937794779577967797779877997800780178027803780478057806780778087809781078117812781378147815781678177818781978207821782278237824782578267827782878297830783178327833783478357836783778387839784078417842784378447845784678477848784978507851785278537854785578567857785878597860786178627863786478657866786778687869787078717872787378747875787678777878787978807881788278837884788578867887788878897890789178927893789478957896789778987899790079017902790379047905790679077908790979107911791279137914791579167917791879197920792179227923792479257926792779287929793079317932793379347935793679377938793979407941794279437944794579467947794879497950795179527953795479557956795779587959796079617962796379647965796679677968796979707971797279737974797579767977797879797980798179827983798479857986798779887989799079917992799379947995799679977998799980008001800280038004800580068007800880098010801180128013801480158016801780188019802080218022802380248025802680278028802980308031803280338034803580368037803880398040804180428043804480458046804780488049805080518052805380548055805680578058805980608061806280638064806580668067806880698070807180728073807480758076807780788079808080818082808380848085808680878088808980908091809280938094809580968097809880998100810181028103810481058106810781088109811081118112811381148115811681178118811981208121812281238124812581268127812881298130813181328133813481358136813781388139814081418142814381448145814681478148814981508151815281538154815581568157815881598160816181628163816481658166816781688169817081718172817381748175817681778178817981808181818281838184818581868187818881898190819181928193819481958196819781988199820082018202820382048205820682078208820982108211821282138214821582168217821882198220822182228223822482258226822782288229823082318232823382348235823682378238823982408241824282438244824582468247824882498250825182528253825482558256825782588259826082618262826382648265826682678268826982708271827282738274827582768277827882798280828182828283828482858286828782888289829082918292829382948295829682978298829983008301830283038304830583068307830883098310831183128313831483158316831783188319832083218322832383248325832683278328832983308331833283338334833583368337833883398340834183428343834483458346834783488349835083518352835383548355835683578358835983608361836283638364836583668367836883698370837183728373837483758376837783788379838083818382838383848385838683878388838983908391839283938394839583968397839883998400840184028403840484058406840784088409841084118412841384148415841684178418841984208421842284238424842584268427842884298430843184328433843484358436843784388439844084418442844384448445844684478448844984508451845284538454845584568457845884598460846184628463846484658466846784688469847084718472847384748475847684778478847984808481848284838484848584868487848884898490849184928493849484958496849784988499850085018502850385048505850685078508850985108511851285138514851585168517851885198520852185228523852485258526852785288529853085318532853385348535853685378538853985408541854285438544854585468547854885498550855185528553855485558556855785588559856085618562856385648565856685678568856985708571857285738574857585768577857885798580858185828583858485858586858785888589859085918592859385948595859685978598859986008601860286038604860586068607860886098610861186128613861486158616861786188619862086218622862386248625862686278628862986308631863286338634863586368637863886398640864186428643864486458646864786488649865086518652865386548655865686578658865986608661866286638664866586668667866886698670867186728673867486758676867786788679868086818682868386848685868686878688868986908691869286938694869586968697869886998700870187028703870487058706870787088709871087118712871387148715871687178718871987208721872287238724872587268727872887298730873187328733873487358736873787388739874087418742874387448745874687478748874987508751875287538754875587568757875887598760876187628763876487658766876787688769877087718772877387748775877687778778877987808781878287838784878587868787878887898790879187928793879487958796879787988799880088018802880388048805880688078808880988108811881288138814881588168817881888198820882188228823882488258826882788288829883088318832883388348835883688378838883988408841884288438844884588468847884888498850885188528853885488558856885788588859886088618862886388648865886688678868886988708871887288738874887588768877887888798880888188828883888488858886888788888889889088918892889388948895889688978898889989008901890289038904890589068907890889098910891189128913891489158916891789188919892089218922892389248925892689278928892989308931893289338934893589368937893889398940894189428943894489458946894789488949895089518952895389548955895689578958895989608961896289638964896589668967896889698970897189728973897489758976897789788979898089818982898389848985898689878988898989908991899289938994899589968997899889999000900190029003900490059006900790089009901090119012901390149015901690179018901990209021902290239024902590269027902890299030903190329033903490359036903790389039904090419042904390449045904690479048904990509051905290539054905590569057905890599060906190629063906490659066906790689069907090719072907390749075907690779078907990809081908290839084908590869087908890899090909190929093909490959096909790989099910091019102910391049105910691079108910991109111911291139114911591169117911891199120912191229123912491259126912791289129913091319132913391349135913691379138913991409141914291439144914591469147914891499150915191529153915491559156915791589159916091619162916391649165916691679168916991709171917291739174917591769177917891799180918191829183918491859186918791889189919091919192919391949195919691979198 |
- // <auto-generated />
- using System;
- using Business.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore.Infrastructure;
- using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
- using Volo.Abp.EntityFrameworkCore;
- #nullable disable
- namespace Business.Migrations
- {
- [DbContext(typeof(BusinessMigrationDbContext))]
- partial class BusinessMigrationDbContextModelSnapshot : ModelSnapshot
- {
- protected override void BuildModel(ModelBuilder modelBuilder)
- {
- #pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("_Abp_DatabaseProvider", EfCoreDatabaseProvider.MySql)
- .HasAnnotation("ProductVersion", "6.0.5")
- .HasAnnotation("Relational:MaxIdentifierLength", 64);
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_bom", b =>
- {
- b.Property<long>("bom_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<DateTime?>("begin_day")
- .HasColumnType("datetime")
- .HasComment("生效日期");
- b.Property<string>("biller")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("图片");
- b.Property<int>("bom_num")
- .HasColumnType("int")
- .HasComment("序号");
- b.Property<string>("bom_number")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)")
- .HasComment("bom单编号");
- b.Property<string>("chartnumber")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("图表编号");
- b.Property<DateTime?>("check_date")
- .HasColumnType("datetime")
- .HasComment("检验时间");
- b.Property<string>("checker")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("检验人");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<DateTime?>("end_day")
- .HasColumnType("datetime")
- .HasComment("失效日期");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<int>("fse_status")
- .HasColumnType("int")
- .HasComment("使用状态");
- b.Property<long>("icitem_id")
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<string>("item_name")
- .HasMaxLength(200)
- .HasColumnType("varchar(200)")
- .HasComment("物料名称");
- b.Property<string>("item_number")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料代码");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("product_designer")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("产品设计员");
- b.Property<string>("product_principal")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("生产负责人");
- b.Property<long>("tech_id")
- .HasColumnType("bigint")
- .HasComment("工艺主键");
- b.Property<string>("tech_name")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)")
- .HasComment("工艺名称");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<string>("unit")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)")
- .HasComment("单位");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<DateTime?>("use_date")
- .HasColumnType("datetime")
- .HasComment("bom创建时间");
- b.Property<string>("user")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)")
- .HasComment("bom创建人");
- b.Property<string>("version")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("版本");
- b.HasKey("bom_id");
- b.ToTable("ic_bom", (string)null);
- b.HasComment("物料BOM");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_bom_child", b =>
- {
- b.Property<long>("bom_child_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<int>("backflush")
- .HasColumnType("int")
- .HasComment("是否倒冲");
- b.Property<DateTime?>("begin_day")
- .HasColumnType("datetime")
- .HasComment("生效日期");
- b.Property<long>("bom_id")
- .HasColumnType("bigint")
- .HasComment("bom主键");
- b.Property<string>("bom_number")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)")
- .HasComment("bom单编号");
- b.Property<int>("child_num")
- .HasColumnType("int")
- .HasComment("序号");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<DateTime?>("end_day")
- .HasColumnType("datetime")
- .HasComment("失效日期");
- b.Property<int>("entryid")
- .HasColumnType("int")
- .HasComment("顺序号");
- b.Property<int>("erp_cls")
- .HasColumnType("int")
- .HasComment("物料属性");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<int>("haveicsubs")
- .HasColumnType("int")
- .HasComment("存在替代关系");
- b.Property<long>("icitem_id")
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<string>("icitem_ids")
- .HasMaxLength(2000)
- .HasColumnType("varchar(2000)")
- .HasComment("组合模式");
- b.Property<int>("is_bom")
- .HasColumnType("int")
- .HasComment("是否是BOM");
- b.Property<int>("is_replace")
- .HasColumnType("int")
- .HasComment("是否群组替代");
- b.Property<int>("iskeyitem")
- .HasColumnType("int")
- .HasComment("是否关键件");
- b.Property<string>("item_name")
- .HasMaxLength(200)
- .HasColumnType("varchar(200)")
- .HasComment("物料名称");
- b.Property<string>("item_number")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料代码");
- b.Property<string>("note")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)")
- .HasComment("备注");
- b.Property<DateTime?>("op_time")
- .HasColumnType("datetime")
- .HasComment("操作时间");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<decimal?>("qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("用量");
- b.Property<decimal?>("scrap")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("损耗率");
- b.Property<string>("substitute_code")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)")
- .HasComment("群组代码");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<int>("type")
- .HasColumnType("int")
- .HasComment("物料类型");
- b.Property<string>("unit")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)")
- .HasComment("单位");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<int>("use_status")
- .HasColumnType("int")
- .HasComment("使用状态");
- b.HasKey("bom_child_id");
- b.ToTable("ic_bom_child", (string)null);
- b.HasComment("物料BOM明细");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_factory_details", b =>
- {
- b.Property<long>("icitem_dtl_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<int>("batch_manager")
- .HasColumnType("int")
- .HasComment("是否采用业务批次管理");
- b.Property<long>("cav_acct")
- .HasColumnType("bigint")
- .HasComment("标准成本调整差异科目代码");
- b.Property<decimal?>("check_cycle")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("盘点周期");
- b.Property<string>("check_cycunit")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("盘点周期单位");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<decimal?>("daily_consume")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("日消耗量");
- b.Property<int>("days_per")
- .HasColumnType("int")
- .HasComment("每周_月第天");
- b.Property<long>("default_chkloc")
- .HasColumnType("bigint")
- .HasComment("默认待检仓库");
- b.Property<long>("default_chksp")
- .HasColumnType("bigint")
- .HasComment("默认待检仓位");
- b.Property<long>("default_loc")
- .HasColumnType("bigint")
- .HasComment("默认仓库");
- b.Property<string>("default_manager")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("默认仓管员");
- b.Property<long>("default_sp")
- .HasColumnType("bigint")
- .HasComment("默认仓位");
- b.Property<string>("factory_fode")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("工厂编码");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<decimal?>("high_limit")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("最高存量");
- b.Property<long>("icitem_id")
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<string>("icitem_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料名称");
- b.Property<string>("item_shelve")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("货架信息");
- b.Property<DateTime?>("last_checkdate")
- .HasColumnType("datetime")
- .HasComment("上次盘点日期");
- b.Property<decimal?>("low_limit")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("最低存量");
- b.Property<decimal?>("mat_enter_days")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("原材料入库时间/天");
- b.Property<long>("mcv_acct")
- .HasColumnType("bigint")
- .HasComment("材料成本差异科目代码");
- b.Property<string>("note")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)")
- .HasComment("特殊备注");
- b.Property<decimal?>("ordissu_days")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("工单发料时间/天");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("pcv_acct")
- .HasColumnType("bigint")
- .HasComment("加工费差异科目代码");
- b.Property<long>("pick_type")
- .HasColumnType("bigint")
- .HasComment("领料类型");
- b.Property<decimal?>("prd_out_days")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("成品发货时间/天");
- b.Property<decimal?>("prdenter_days")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("成品入库时间/天");
- b.Property<string>("product_line")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("产品线");
- b.Property<decimal?>("qty_max")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("最大订货量");
- b.Property<decimal?>("raw_matreceiv_days")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("原材料收货处理时间/天");
- b.Property<long>("sl_acct")
- .HasColumnType("bigint")
- .HasComment("废品损失科目代码");
- b.Property<int>("stock_time")
- .HasColumnType("int")
- .HasComment("是否需要库龄管理");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<string>("warehouse_note")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)")
- .HasComment("库存备注");
- b.HasKey("icitem_dtl_id");
- b.ToTable("ic_factory_details", (string)null);
- b.HasComment("工厂物料明细表");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_item", b =>
- {
- b.Property<long>("icitem_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<int>("allowbatch")
- .HasColumnType("int")
- .HasComment("批号管理");
- b.Property<int>("allowmanu")
- .HasColumnType("int")
- .HasComment("允许生产");
- b.Property<int>("allowout")
- .HasColumnType("int")
- .HasComment("允许委外");
- b.Property<int>("allowpur")
- .HasColumnType("int")
- .HasComment("允许采购");
- b.Property<int>("allowsale")
- .HasColumnType("int")
- .HasComment("允许销售");
- b.Property<int>("allowserial")
- .HasColumnType("int")
- .HasComment("序列号管理");
- b.Property<string>("box_model")
- .HasMaxLength(200)
- .HasColumnType("varchar(200)")
- .HasComment("盒贴规格");
- b.Property<string>("chart_number")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("图号");
- b.Property<string>("check_bybarcode")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("严格进行二维码数量校验");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<string>("cubic_measure")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("长度单位");
- b.Property<int>("enable_warning")
- .HasColumnType("int")
- .HasComment("启用预警");
- b.Property<string>("erp_cls")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料属性");
- b.Property<string>("erp_oldnumber")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("erp旧料号");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("fms_number")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("fms旧料号");
- b.Property<string>("full_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("全名");
- b.Property<string>("fversion")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("版本号");
- b.Property<decimal?>("gross_weight")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("毛重");
- b.Property<long>("hb_level")
- .HasColumnType("bigint")
- .HasComment("环保等级");
- b.Property<decimal?>("height")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("高度");
- b.Property<int>("is_equipment")
- .HasColumnType("int")
- .HasComment("是否为设备");
- b.Property<int>("iskeyitem")
- .HasColumnType("int")
- .HasComment("是否关键件");
- b.Property<long>("item_level")
- .HasColumnType("bigint")
- .HasComment("物料等级");
- b.Property<decimal?>("length")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("长度");
- b.Property<long>("matatt")
- .HasColumnType("bigint")
- .HasComment("物料类别");
- b.Property<string>("maund")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("重量单位");
- b.Property<string>("model")
- .HasMaxLength(200)
- .HasColumnType("varchar(200)")
- .HasComment("规格型号");
- b.Property<string>("name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料名称");
- b.Property<decimal?>("net_weight")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("净重");
- b.Property<string>("number")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料编码");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("output_type_id")
- .HasColumnType("bigint")
- .HasComment("出库类型");
- b.Property<string>("photo")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("图片");
- b.Property<long>("picktype")
- .HasColumnType("bigint")
- .HasComment("领料类型");
- b.Property<decimal?>("size")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("体积");
- b.Property<string>("source")
- .HasMaxLength(200)
- .HasColumnType("varchar(200)")
- .HasComment("来源");
- b.Property<decimal?>("standard_manhour")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("单位标准工时_小时");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<decimal?>("unit_qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("单位包装数量");
- b.Property<decimal?>("unititem_amount")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("单位材料定额_元");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<decimal?>("width")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("宽度");
- b.HasKey("icitem_id");
- b.ToTable("ic_item", (string)null);
- b.HasComment("物料详情");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_item_ie", b =>
- {
- b.Property<long>("ic_item_ie_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("back_flush_sp")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("倒冲仓位");
- b.Property<string>("back_flush_stock")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("倒冲仓库");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long>("icitem_id")
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<string>("ir_note")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)")
- .HasComment("ie备注");
- b.Property<int>("isbackflush")
- .HasColumnType("int")
- .HasComment("是否倒冲");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("product_principal")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("生产负责人");
- b.Property<int>("put_integer")
- .HasColumnType("int")
- .HasComment("投料自动取整");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("ic_item_ie_id");
- b.ToTable("ic_item_ie", (string)null);
- b.HasComment("物料ie信息表");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_item_inventory", b =>
- {
- b.Property<long>("icitem_inventory_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<decimal?>("bal")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("金额");
- b.Property<string>("batch_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("批次号");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long>("icitem_stock_id")
- .HasColumnType("bigint")
- .HasComment("物料库存主键");
- b.Property<DateTime?>("kf_date")
- .HasColumnType("datetime")
- .HasComment("保质期时间");
- b.Property<decimal?>("kf_period")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("保质期时长");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<decimal?>("qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("数量");
- b.Property<decimal?>("qty_lock")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("锁定库存");
- b.Property<DateTime?>("rq")
- .HasColumnType("datetime")
- .HasComment("日期");
- b.Property<decimal?>("sec_qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("安全库存");
- b.Property<long>("stock_id")
- .HasColumnType("bigint")
- .HasComment("仓库id");
- b.Property<string>("stock_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("仓库名称");
- b.Property<string>("stock_place_code")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("库位编码");
- b.Property<long>("stock_place_id")
- .HasColumnType("bigint")
- .HasComment("库位id");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<string>("unit")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("单位");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("icitem_inventory_id");
- b.ToTable("ic_item_inventory", (string)null);
- b.HasComment("物料库存信息表");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_item_pur", b =>
- {
- b.Property<long>("icitem_pur_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long>("currency_type")
- .HasColumnType("bigint")
- .HasComment("币种");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long>("ic_plan_id")
- .HasColumnType("bigint")
- .HasComment("采购计划id");
- b.Property<long>("icitem_id")
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<string>("icitem_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料名称");
- b.Property<decimal?>("netpurchase_price")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("采购净价(不含税)");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("purchase_unit")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("采购计量单位");
- b.Property<string>("purcher")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("采购员");
- b.Property<string>("purchgroup")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("采购组");
- b.Property<long>("supplier_id")
- .HasColumnType("bigint")
- .HasComment("供应商id");
- b.Property<string>("supplier_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("供应商名称");
- b.Property<string>("supplier_number")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("供应商编码");
- b.Property<decimal?>("taxrate")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("税率");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("icitem_pur_id");
- b.ToTable("ic_item_pur", (string)null);
- b.HasComment("物料采购报价单");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_item_stock", b =>
- {
- b.Property<long>("icitem_stock_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<string>("factory_fode")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("工厂编码");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long>("icitem_id")
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<string>("icitem_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料名称");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<decimal?>("quantity_in_transit")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("调拨在途数量");
- b.Property<decimal?>("sqty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("物料库存量");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("icitem_stock_id");
- b.ToTable("ic_item_stock", (string)null);
- b.HasComment("物料库存表");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_metering_unit", b =>
- {
- b.Property<long>("ic_metering_unit_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long>("icitem_id")
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<string>("icitem_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料名称");
- b.Property<string>("order_unit")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("采购计量单位");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("product_unit")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("生产计量单位");
- b.Property<int>("qty_decimal")
- .HasColumnType("int")
- .HasComment("数量精度");
- b.Property<string>("sale_unit")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("销售计量单位");
- b.Property<string>("store_unit")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("库存计量单位");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<string>("unit")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("基本计量单位");
- b.Property<string>("unit_group")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("计量单位组");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("ic_metering_unit_id");
- b.ToTable("ic_metering_unit", (string)null);
- b.HasComment("物料计量表");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_plan", b =>
- {
- b.Property<long>("ic_plan_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<int>("aux_prop_plan")
- .HasColumnType("int")
- .HasComment("辅助属性参与计划运算");
- b.Property<decimal?>("bat_change_economy")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("变动提前期批量");
- b.Property<int>("book_plan")
- .HasColumnType("int")
- .HasComment("是否需要进行订补货计划的运算");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<string>("factory_code")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("工厂编码");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<decimal?>("fix_leadtime")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("固定提前期(天)");
- b.Property<long>("icitem_id")
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<string>("icitem_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料名称");
- b.Property<int>("isfixedreorder")
- .HasColumnType("int")
- .HasComment("设置为固定再订货点");
- b.Property<decimal?>("lead_time")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("变动提前期");
- b.Property<decimal?>("order_inter_val")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("订货间隔期_天");
- b.Property<string>("order_point")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("再订货点");
- b.Property<int>("order_trategy")
- .HasColumnType("int")
- .HasComment("订货策略");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<int>("plan_trategy")
- .HasColumnType("int")
- .HasComment("计划策略");
- b.Property<string>("planner_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("计划员");
- b.Property<string>("planner_num")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("计划员_工号");
- b.Property<string>("plannote")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)")
- .HasComment("计划备注");
- b.Property<decimal?>("secinv")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("安全库存数量");
- b.Property<decimal?>("secinv_ratio")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("安全库存触发采购比例");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<decimal?>("total_tqq")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("累计提前期");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("ic_plan_id");
- b.ToTable("ic_plan", (string)null);
- b.HasComment("物料采购计划表");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_substitute", b =>
- {
- b.Property<long>("substitute_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("substitute_code")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)")
- .HasComment("群组代码");
- b.Property<int>("substitute_type")
- .HasColumnType("int")
- .HasComment("替代类型");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("substitute_id");
- b.ToTable("ic_substitute", (string)null);
- b.HasComment("替代群组");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_substitute_all", b =>
- {
- b.Property<long>("substitute_allid")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<int>("order_num")
- .HasColumnType("int")
- .HasComment("排序");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("product_line")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("产品线");
- b.Property<string>("replace_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("替代名称");
- b.Property<string>("replace_relation")
- .HasMaxLength(2000)
- .HasColumnType("varchar(2000)")
- .HasComment("替代关系");
- b.Property<string>("replace_way")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("替代方式");
- b.Property<string>("substitute_code")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)")
- .HasComment("群组代码");
- b.Property<long>("substitute_id")
- .HasColumnType("bigint")
- .HasComment("群组主键");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<string>("use_model")
- .HasMaxLength(5000)
- .HasColumnType("varchar(5000)")
- .HasComment("使用机型");
- b.HasKey("substitute_allid");
- b.ToTable("ic_substitute_all", (string)null);
- b.HasComment("物料替代多群组");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_substitute_all_dtl", b =>
- {
- b.Property<long>("substitute_dtlid")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long>("icitem_id")
- .HasColumnType("bigint")
- .HasComment("物料主键");
- b.Property<int>("ismain")
- .HasColumnType("int")
- .HasComment("主/替");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<decimal?>("replace_amount")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("替代数量");
- b.Property<long>("substitute_allid")
- .HasColumnType("bigint")
- .HasComment("替代多群组主键");
- b.Property<string>("substitute_code")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)")
- .HasComment("群组代码");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<decimal?>("use_amount")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("使用数量");
- b.HasKey("substitute_dtlid");
- b.ToTable("ic_substitute_all_dtl", (string)null);
- b.HasComment("物料替代多群组明细");
- });
- modelBuilder.Entity("Bussiness.Model.Production.mes_moentry", b =>
- {
- b.Property<long>("moentry_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("生产工单子表id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("fbill_no")
- .IsRequired()
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("订单编号");
- b.Property<long>("fentry_id")
- .HasColumnType("bigint")
- .HasComment("订单行号");
- b.Property<long>("moentry_moid")
- .HasColumnType("bigint")
- .HasComment("工单主表id");
- b.Property<string>("moentry_mono")
- .IsRequired()
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("工单编号");
- b.Property<decimal?>("morder_production_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("工单生产数量(计划数量)");
- b.Property<decimal?>("need_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("需求数量");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<decimal?>("remaining_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("剩余可用数量");
- b.Property<long>("soentry_id")
- .HasColumnType("bigint")
- .HasComment("订单行id");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<string>("unit")
- .IsRequired()
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("单位");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("moentry_id");
- b.ToTable("mes_moentry", (string)null);
- b.HasComment("生成工单子表");
- });
- modelBuilder.Entity("Bussiness.Model.Production.mes_mooccupy", b =>
- {
- b.Property<long>("moo_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("工单占用ID");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("fbill_no")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("订单号");
- b.Property<long>("fentry_id")
- .HasColumnType("bigint")
- .HasComment("行号");
- b.Property<string>("fitem_name")
- .IsRequired()
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("物料名称");
- b.Property<string>("fitem_number")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("物料编码");
- b.Property<string>("fmodel")
- .IsRequired()
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("规格型号");
- b.Property<string>("moo_cbr")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("变更人");
- b.Property<string>("moo_creason")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("变更原因");
- b.Property<DateTime?>("moo_ctime")
- .HasColumnType("datetime")
- .HasComment("变更时间");
- b.Property<DateTime?>("moo_etime")
- .HasColumnType("datetime")
- .HasComment("结束时间");
- b.Property<long>("moo_id_billid")
- .HasColumnType("bigint")
- .HasComment("订单id");
- b.Property<string>("moo_id_type")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("类型--原始,分配");
- b.Property<string>("moo_mo")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("工单号");
- b.Property<long>("moo_moid")
- .HasColumnType("bigint")
- .HasComment("工单id");
- b.Property<decimal?>("moo_qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("占用量");
- b.Property<int>("moo_state")
- .HasColumnType("int")
- .HasComment("占用状态-1占用 默认0");
- b.Property<DateTime?>("moo_stime")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("moo_id");
- b.ToTable("mes_mooccupy", (string)null);
- b.HasComment("在制工单占用记录表");
- });
- modelBuilder.Entity("Bussiness.Model.Production.mes_morder", b =>
- {
- b.Property<long>("morder_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("生产工单id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("bom_number")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("bom编码");
- b.Property<DateTime?>("convey_date")
- .HasColumnType("datetime")
- .HasComment("下达日期");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("fmodel")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("规格型号");
- b.Property<string>("fms_number")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("fms旧料号");
- b.Property<decimal?>("inspection_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("报检数量");
- b.Property<decimal?>("inventory_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("入库数量");
- b.Property<DateTime?>("mat_end_date")
- .HasColumnType("datetime")
- .HasComment("基于物料结束时间");
- b.Property<DateTime?>("mat_start_date")
- .HasColumnType("datetime")
- .HasComment("基于物料开始时间");
- b.Property<DateTime?>("moentry_etime")
- .HasColumnType("datetime")
- .HasComment("生产工单结束日期");
- b.Property<long?>("moentry_prd")
- .HasColumnType("bigint")
- .HasComment("生产组织id");
- b.Property<string>("moentry_prdname")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("生产组织名称");
- b.Property<int?>("moentry_startup_status")
- .HasColumnType("int")
- .HasComment("启动状态");
- b.Property<DateTime?>("moentry_stime")
- .HasColumnType("datetime")
- .HasComment("生产工单开始日期");
- b.Property<DateTime?>("moentry_sys_etime")
- .HasColumnType("datetime")
- .HasComment("系统建议完工时间");
- b.Property<DateTime?>("moentry_sys_stime")
- .HasColumnType("datetime")
- .HasComment("系统建议开工时间");
- b.Property<long?>("moentry_wrkc")
- .HasColumnType("bigint")
- .HasComment("工作中心id");
- b.Property<string>("moentry_wrkcname")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("工作中心名称");
- b.Property<string>("morder_batchno")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("工单批号--(批号管理的物料出入库要使用)");
- b.Property<DateTime?>("morder_date")
- .HasColumnType("datetime")
- .HasComment("生产工单日期");
- b.Property<string>("morder_fstate")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("前状态--计划、下达、完成、关闭");
- b.Property<string>("morder_icitem_type")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("工单所属物料类型");
- b.Property<decimal?>("morder_need_time")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("工单所需工时");
- b.Property<string>("morder_no")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("生产工单编号");
- b.Property<string>("morder_progress")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)")
- .HasComment("工单进度");
- b.Property<string>("morder_state")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("生产工单状态(订单状态:初始,下达,暂停、完成)");
- b.Property<string>("morder_type")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("生产工单类型(类型:计划工单、销售工单、委外工单、预测工单)");
- b.Property<decimal?>("notice_qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("已开入库通知单数量");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("overdue_Remark")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("逾期原因备注");
- b.Property<long?>("parent_id")
- .HasColumnType("bigint")
- .HasComment("上级工单id");
- b.Property<DateTime?>("pause_time")
- .HasColumnType("datetime")
- .HasComment("最近暂停时间");
- b.Property<decimal?>("picking_qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("已领料数量");
- b.Property<DateTime?>("planner_end_date")
- .HasColumnType("datetime")
- .HasComment("计划员设定结束时间");
- b.Property<string>("planner_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("计划员名称");
- b.Property<string>("planner_num")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("计划员工号");
- b.Property<DateTime?>("planner_start_date")
- .HasColumnType("datetime")
- .HasComment("计划员设定开始时间");
- b.Property<string>("product_code")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("产品代码");
- b.Property<string>("product_name")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("产品名称");
- b.Property<string>("project_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("项目名称");
- b.Property<decimal?>("qualified_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("合格数量");
- b.Property<DateTime?>("reality_end_time")
- .HasColumnType("datetime")
- .HasComment("实际结束时间");
- b.Property<DateTime?>("reality_start_time")
- .HasColumnType("datetime")
- .HasComment("实际开始时间");
- b.Property<long?>("relation_moid")
- .HasColumnType("bigint")
- .HasComment("关联工单id");
- b.Property<string>("relation_mono")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("关联编号");
- b.Property<DateTime?>("restart_time")
- .HasColumnType("datetime")
- .HasComment("最近重启时间");
- b.Property<DateTime?>("start_time")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<decimal?>("work_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("报工数量");
- b.Property<string>("work_order_type")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("工单类型(类型:发货工单、试产工单、备库工单、常规工单、返工工单)");
- b.HasKey("morder_id");
- b.ToTable("mes_morder", (string)null);
- b.HasComment("工单主表");
- });
- modelBuilder.Entity("Bussiness.Model.Production.mes_morder_loss_time", b =>
- {
- b.Property<long>("id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("工单损失时间主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("card_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("用工卡号");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long>("dept_id")
- .HasColumnType("bigint")
- .HasComment("责任单位id");
- b.Property<string>("dept_name")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("责任单位名称");
- b.Property<string>("description")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("描述");
- b.Property<DateTime>("end_time")
- .HasColumnType("datetime")
- .HasComment("损失结束时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<int>("is_stop_production")
- .HasColumnType("int")
- .HasComment("是否停产(0未停产,1停产)");
- b.Property<decimal>("loss_work_hours")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("损失时间(用户输入)");
- b.Property<long>("morder_id")
- .HasColumnType("bigint")
- .HasComment("生产工单id");
- b.Property<string>("morder_no")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("生产工单编号");
- b.Property<int>("morder_no_row")
- .HasColumnType("int")
- .HasComment("生产工单编号");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("reason")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("损失时间原因");
- b.Property<long>("recorder_id")
- .HasColumnType("bigint")
- .HasComment("记录人id");
- b.Property<string>("recorder_name")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("记录人名称");
- b.Property<decimal>("staff_qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("人员数量");
- b.Property<DateTime>("start_time")
- .HasColumnType("datetime")
- .HasComment("损失开始时间");
- b.Property<decimal>("sys_loss_time")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("系统计算损失时间");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<long>("workc_id")
- .HasColumnType("bigint")
- .HasComment("工作中心id");
- b.Property<string>("workc_name")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("工作中心名称");
- b.HasKey("id");
- b.ToTable("mes_morder_loss_time", (string)null);
- b.HasComment("工单损失时间表");
- });
- modelBuilder.Entity("Bussiness.Model.Production.mes_oorder", b =>
- {
- b.Property<long>("oorder_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("委外订单id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("bom_number")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("bom编码");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("ffms_number")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("fms旧料号");
- b.Property<decimal?>("inspection_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("报检数量");
- b.Property<decimal?>("inventory_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("入库数量");
- b.Property<int?>("moentry_on")
- .HasColumnType("int")
- .HasComment("启动状态");
- b.Property<decimal?>("morder_production_number")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("工单生产数量(计划数量)");
- b.Property<string>("morder_progress")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("工单进度");
- b.Property<int?>("need_icitem_status")
- .HasColumnType("int")
- .HasComment("加工单位编码");
- b.Property<decimal?>("need_number")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("需求数量");
- b.Property<decimal?>("notice_qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("已开通知单数量");
- b.Property<DateTime?>("ooentry_etime")
- .HasColumnType("datetime")
- .HasComment("计划完工日期");
- b.Property<long?>("ooentry_prd")
- .HasColumnType("bigint")
- .HasComment("生产组织");
- b.Property<string>("ooentry_prdname")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("生产组织名称");
- b.Property<DateTime?>("ooentry_stime")
- .HasColumnType("datetime")
- .HasComment("计划开工日期");
- b.Property<long?>("ooentry_wrkc")
- .HasColumnType("bigint")
- .HasComment("工作中心id");
- b.Property<string>("ooentry_wrkcname")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("工作中心名称");
- b.Property<DateTime?>("oorder_date")
- .HasColumnType("datetime")
- .HasComment("委外订单日期");
- b.Property<string>("oorder_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("生产工单编号");
- b.Property<string>("oorder_state")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("订单状态");
- b.Property<string>("oorder_type")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("生产工单类型");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<DateTime?>("pause_time")
- .HasColumnType("datetime")
- .HasComment("最近暂停时间");
- b.Property<string>("planner_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("计划员名称");
- b.Property<string>("planner_num")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("计划员工号");
- b.Property<string>("product_code")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("产品代码");
- b.Property<string>("product_name")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("产品名称");
- b.Property<string>("production_unit")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("加工单位");
- b.Property<string>("production_unit_code")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)")
- .HasComment("加工单位编码");
- b.Property<string>("project_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("项目名称");
- b.Property<decimal?>("qualified_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("合格数量");
- b.Property<decimal?>("remaining_number")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("剩余可用数量");
- b.Property<DateTime?>("restart_time")
- .HasColumnType("datetime")
- .HasComment("最近重启时间");
- b.Property<int?>("sent_status")
- .HasColumnType("int")
- .HasComment("发料状态 1-待发料 2-已发料");
- b.Property<string>("specification_model")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("规格型号");
- b.Property<DateTime?>("start_time")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<string>("unit")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("单位");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<decimal?>("work_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("报工数量");
- b.HasKey("oorder_id");
- b.ToTable("mes_oorder", (string)null);
- b.HasComment("委外订单表");
- });
- modelBuilder.Entity("Bussiness.Model.Production.mes_schedule_occupy", b =>
- {
- b.Property<long>("id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("排程时间占用记录id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<DateTime?>("end_time")
- .HasColumnType("datetime")
- .HasComment("结束时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<int>("is_Locked")
- .HasColumnType("int")
- .HasComment("是否锁定 0-正常,1-锁定");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("prd_org_id")
- .HasColumnType("bigint")
- .HasComment("生产组织id");
- b.Property<DateTime?>("start_time")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- b.Property<int>("status")
- .HasColumnType("int")
- .HasComment("状态 0-待使用,1-已使用");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<long>("work_calendar_id")
- .HasColumnType("bigint")
- .HasComment("工作日历id");
- b.Property<long>("work_center_id")
- .HasColumnType("bigint")
- .HasComment("工作中心id");
- b.Property<decimal?>("working_minute")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("工作时长(h)");
- b.HasKey("id");
- b.ToTable("mes_schedule_occupy", (string)null);
- b.HasComment("排程时间占用记录表");
- });
- modelBuilder.Entity("Bussiness.Model.Production.mes_stockoccupy", b =>
- {
- b.Property<long>("soccupy_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("成品库存占用id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("fbill_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("订单编号");
- b.Property<long?>("fentry_id")
- .HasColumnType("bigint")
- .HasComment("订单行号");
- b.Property<string>("fitem_name")
- .HasMaxLength(200)
- .HasColumnType("varchar(200)")
- .HasComment("物料名称");
- b.Property<string>("fitem_number")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("物料编码");
- b.Property<string>("fmodel")
- .HasMaxLength(200)
- .HasColumnType("varchar(200)")
- .HasComment("规格型号");
- b.Property<decimal?>("occupyqty")
- .HasPrecision(20, 2)
- .HasColumnType("decimal(20,2)")
- .HasComment("占用量");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("soccupy_cby")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("变更人");
- b.Property<string>("soccupy_creason")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("变更原因");
- b.Property<DateTime?>("soccupy_ctime")
- .HasColumnType("datetime")
- .HasComment("变更时间");
- b.Property<DateTime?>("soccupy_etime")
- .HasColumnType("datetime")
- .HasComment("结束时间");
- b.Property<string>("soccupy_state")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("占用状态");
- b.Property<DateTime?>("soccupy_stime")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- b.Property<string>("soccupy_type")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("类型");
- b.Property<long?>("soentry_id")
- .HasColumnType("bigint")
- .HasComment("订单行id");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<long>("warehouse_id")
- .HasColumnType("bigint")
- .HasComment("仓库id");
- b.Property<string>("warehouse_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("仓库名称");
- b.Property<string>("warehouse_type")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("仓库类型");
- b.HasKey("soccupy_id");
- b.ToTable("mes_stockoccupy", (string)null);
- b.HasComment("成品库存占用表");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_loss_time_record", b =>
- {
- b.Property<long>("loss_time_record_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键ID");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("cause")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("原因");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<string>("desc")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("问题描述");
- b.Property<DateTime?>("end_time")
- .HasColumnType("datetime")
- .HasComment("损失结束时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<int>("isstop")
- .HasColumnType("int")
- .HasComment("是否停线");
- b.Property<long>("morder_id")
- .HasColumnType("bigint")
- .HasComment("工单id");
- b.Property<string>("morder_no")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("工单编号");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("product_line")
- .HasColumnType("bigint")
- .HasComment("生产产线");
- b.Property<long>("product_org")
- .HasColumnType("bigint")
- .HasComment("生产车间");
- b.Property<long>("record_id")
- .HasColumnType("bigint")
- .HasComment("记录人id");
- b.Property<string>("record_no")
- .IsRequired()
- .HasColumnType("longtext")
- .HasComment("记录人工号");
- b.Property<DateTime>("record_time")
- .HasColumnType("datetime")
- .HasComment("记录时间");
- b.Property<DateTime?>("start_time")
- .HasColumnType("datetime")
- .HasComment("损失开始时间");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("loss_time_record_id");
- b.ToTable("mes_loss_time_record", (string)null);
- b.HasComment("损失时间记录表");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_meaction", b =>
- {
- b.Property<long>("meaction_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("生产动作Id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long>("morder_id")
- .HasColumnType("bigint")
- .HasComment("生产工单id");
- b.Property<string>("morder_no")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("生产工单号");
- b.Property<long?>("oprby")
- .HasColumnType("bigint")
- .HasComment("操作人id");
- b.Property<string>("oprbyname")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("操作人名称");
- b.Property<string>("oprbyno")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("操作人工号");
- b.Property<DateTime?>("oprtime")
- .HasColumnType("datetime")
- .HasComment("操作时间");
- b.Property<string>("oprtype")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("操作类型");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("meaction_id");
- b.ToTable("mes_meaction", (string)null);
- b.HasComment("生产动作表");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_mebycard", b =>
- {
- b.Property<long>("mebycard_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("刷卡id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("mebycard_byno")
- .IsRequired()
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("刷卡人员卡号");
- b.Property<long>("mebycard_moid")
- .HasColumnType("bigint")
- .HasComment("生产工单号id");
- b.Property<string>("mebycard_mono")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("生产工单号");
- b.Property<long>("mebycard_pid")
- .HasColumnType("bigint")
- .HasComment("工序id");
- b.Property<string>("mebycard_pname")
- .IsRequired()
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("工序名称");
- b.Property<string>("mebycard_pno")
- .IsRequired()
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("工序编码");
- b.Property<DateTime>("mebycard_time")
- .HasColumnType("datetime")
- .HasComment("刷卡时间");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("mebycard_id");
- b.ToTable("mes_mebycard", (string)null);
- b.HasComment("产线刷卡记录");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_merecheck", b =>
- {
- b.Property<long>("merecheck_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("生产报检记录Id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long>("morder_id")
- .HasColumnType("bigint")
- .HasComment("生产工单id");
- b.Property<string>("morder_no")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("生产工单号");
- b.Property<long>("oprby")
- .HasColumnType("bigint")
- .HasComment("报检人id");
- b.Property<DateTime>("oprtime")
- .HasColumnType("datetime")
- .HasComment("报检时间");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<decimal>("qty")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("报检数量");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("merecheck_id");
- b.ToTable("mes_merecheck", (string)null);
- b.HasComment("生产报检记录");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_mereport", b =>
- {
- b.Property<long>("mereport_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("生产报工记录Id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<decimal>("instock_qty")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("报工数量");
- b.Property<long>("morder_id")
- .HasColumnType("bigint")
- .HasComment("生产工单id");
- b.Property<string>("morder_no")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("生产工单号");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<decimal>("qty")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("报工数量");
- b.Property<long>("report_by")
- .HasColumnType("bigint")
- .HasComment("报工人id");
- b.Property<string>("report_byno")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("报工人工号");
- b.Property<DateTime>("report_time")
- .HasColumnType("datetime")
- .HasComment("报工时间");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("mereport_id");
- b.ToTable("mes_mereport", (string)null);
- b.HasComment("生产报工记录");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_prd_sendmat", b =>
- {
- b.Property<long>("prdsm_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("发料单id");
- b.Property<string>("prdsm_by")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("制单人");
- b.Property<DateTime>("prdsm_date")
- .HasColumnType("datetime")
- .HasComment("单据日期");
- b.Property<DateTime?>("prdsm_ddate")
- .HasColumnType("datetime")
- .HasComment("配送日期");
- b.Property<long>("prdsm_moid")
- .HasColumnType("bigint")
- .HasComment("生产工单id");
- b.Property<string>("prdsm_mono")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("生产工单号");
- b.Property<string>("prdsm_no")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("单据编号");
- b.Property<string>("prdsm_note")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("备注");
- b.Property<string>("prdsm_po_no")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("关联委外po单号");
- b.Property<int?>("prdsm_po_row")
- .HasColumnType("int")
- .HasComment("关联委外po行号");
- b.Property<long>("prdsm_prdid")
- .HasColumnType("bigint")
- .HasComment("生产组织id");
- b.Property<decimal>("prdsm_qty")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("叫料数量");
- b.Property<string>("prdsm_reason")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("补料理由");
- b.Property<int?>("prdsm_state")
- .HasColumnType("int")
- .HasComment("状态");
- b.Property<string>("prdsm_type")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("单据类型 (发料、叫料、补料、退料)");
- b.Property<long>("prdsm_workcid")
- .HasColumnType("bigint")
- .HasComment("工作中心id");
- b.Property<int>("srcbill_state")
- .HasColumnType("int")
- .HasComment("源单状态");
- b.Property<int>("srcbill_type")
- .HasColumnType("int")
- .HasComment("原单类型");
- b.HasKey("prdsm_id");
- b.ToTable("mes_prd_sendmat", (string)null);
- b.HasComment("发料单");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_prd_sendmat_list", b =>
- {
- b.Property<long>("prdsml_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("发料单详情id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<int?>("fbackflush")
- .HasColumnType("int")
- .HasComment("是否倒冲");
- b.Property<decimal?>("fdiscard_aux_qty")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("报废数量");
- b.Property<string>("fisKey_item")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("子项属性");
- b.Property<string>("fitem_name")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("物料编码");
- b.Property<string>("fitem_number")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("物料编码");
- b.Property<string>("fmateriel_type")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("子项属性");
- b.Property<string>("fmodel")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("物料编码");
- b.Property<decimal?>("fqty_send_back")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("退料数量");
- b.Property<decimal?>("fqty_supply")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("补料数量");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("prdsm_breason")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("退料原因");
- b.Property<long>("prdsm_id")
- .HasColumnType("bigint")
- .HasComment("发料单id");
- b.Property<decimal?>("prdsml_cqtyper")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("确认单位数量");
- b.Property<string>("prdsml_procname")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("工序名称");
- b.Property<string>("prdsml_procno")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("工序编码");
- b.Property<decimal>("prdsml_qtyissued")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("已发数量");
- b.Property<decimal?>("prdsml_qtyper")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("单位数量");
- b.Property<decimal?>("prdsml_qtyplan")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("计划数量");
- b.Property<decimal?>("prdsml_qtyto")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("应发数量");
- b.Property<string>("prdsml_unit")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("计量单位");
- b.Property<long>("prdsml_whid")
- .HasColumnType("bigint")
- .HasComment("发料仓库id");
- b.Property<string>("prdsml_whname")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("发料仓库名称");
- b.Property<string>("prdsml_whno")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("发料仓库编码");
- b.Property<int?>("prsml_row")
- .HasColumnType("int")
- .HasComment("行号");
- b.Property<DateTime?>("send_date")
- .HasColumnType("datetime")
- .HasComment("计划发料日期");
- b.Property<string>("station")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("工位");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("prdsml_id");
- b.ToTable("mes_prd_sendmat_list", (string)null);
- b.HasComment("发料单详情");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_prdlog", b =>
- {
- b.Property<long>("prdlog_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("生产操作日志id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long?>("prdlog_by_id")
- .HasColumnType("bigint")
- .HasComment("执行人id");
- b.Property<string>("prdlog_by_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("执行人姓名");
- b.Property<int>("prdlog_entryid")
- .HasColumnType("int")
- .HasComment("行号");
- b.Property<string>("prdlog_no")
- .IsRequired()
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("业务类型");
- b.Property<string>("prdlog_note")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("内容");
- b.Property<DateTime?>("prdlog_time")
- .HasColumnType("datetime")
- .HasComment("执行时间");
- b.Property<string>("prdlog_type")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("业务类型");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("prdlog_id");
- b.ToTable("mes_prdlog", (string)null);
- b.HasComment("生产操作日志");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_product_work_time", b =>
- {
- b.Property<long>("id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("生产时间记录id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("card_no")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("卡号");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("product_line")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("产线");
- b.Property<DateTime?>("start")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- b.Property<DateTime?>("stop")
- .HasColumnType("datetime")
- .HasComment("结束时间");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<DateTime?>("work_date")
- .HasColumnType("datetime")
- .HasComment("生产时间记录id");
- b.HasKey("id");
- b.ToTable("mes_product_work_time", (string)null);
- b.HasComment("mo的生产时间记录");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_stock_enter", b =>
- {
- b.Property<long>("id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("入库单id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long>("eby")
- .HasColumnType("bigint")
- .HasComment("入库人id");
- b.Property<string>("ebyname")
- .IsRequired()
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("入库人姓名");
- b.Property<DateTime>("edate")
- .HasColumnType("datetime")
- .HasComment("入库日期");
- b.Property<int>("eqty")
- .HasColumnType("int")
- .HasComment("入库数量");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("ffull_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("全名");
- b.Property<string>("fitem_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("物料名称");
- b.Property<string>("fitem_number")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("物料编码");
- b.Property<string>("fmodel")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("规格型号");
- b.Property<string>("order_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("工单号");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("id");
- b.ToTable("mes_stock_enter", (string)null);
- b.HasComment("入库单");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_stock_out", b =>
- {
- b.Property<long>("id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("出库单Id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long>("eby")
- .HasColumnType("bigint")
- .HasComment("出库人id");
- b.Property<string>("eby_name")
- .IsRequired()
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("出库人姓名");
- b.Property<DateTime>("edate")
- .HasColumnType("datetime")
- .HasComment("出库日期");
- b.Property<int>("eqty")
- .HasColumnType("int")
- .HasComment("出库数量");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("ffull_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("全名");
- b.Property<string>("fitem_name")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("物料名称");
- b.Property<string>("fitem_number")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料编码");
- b.Property<string>("fmodel")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("规格型号");
- b.Property<string>("order_no")
- .IsRequired()
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("销售订单号");
- b.Property<int?>("order_number")
- .HasColumnType("int")
- .HasComment("订单行号");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("out_no")
- .IsRequired()
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("出库单号");
- b.Property<string>("shipn_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("发运通知单号");
- b.Property<string>("stock_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("仓库名称");
- b.Property<string>("stock_no")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("仓库编码");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<string>("unit")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("计量单位");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("id");
- b.ToTable("mes_stock_out", (string)null);
- b.HasComment("出库单");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_swipe_card", b =>
- {
- b.Property<long>("id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("mes打卡记录id");
- b.Property<string>("card_no")
- .IsRequired()
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("卡号");
- b.Property<DateTime?>("off_line_time")
- .HasColumnType("datetime")
- .HasComment("下线时间");
- b.Property<string>("order_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("工单编号");
- b.Property<string>("product_line")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("生产产线");
- b.Property<string>("product_org")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("生产车间");
- b.Property<DateTime>("swipe_date")
- .HasColumnType("datetime")
- .HasComment("刷卡日期");
- b.Property<int>("type")
- .HasColumnType("int")
- .HasComment("刷卡类型");
- b.Property<DateTime?>("up_line_time")
- .HasColumnType("datetime")
- .HasComment("上线时间");
- b.HasKey("id");
- b.ToTable("mes_swipe_card", (string)null);
- b.HasComment("mes打卡记录表");
- });
- modelBuilder.Entity("Bussiness.Model.SRM.srm_po_list", b =>
- {
- b.Property<long>("polist_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long>("currencytype")
- .HasColumnType("bigint")
- .HasComment("币别");
- b.Property<decimal?>("esqty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("已入库数量");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long>("icitem_id")
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<string>("icitem_name")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("物料名称");
- b.Property<decimal?>("netprice")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("净价");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<decimal?>("plan_qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("计划数量");
- b.Property<string>("po_billno")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("po单号");
- b.Property<long>("po_id")
- .HasColumnType("bigint")
- .HasComment("po单id");
- b.Property<string>("po_mono")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("关联工单号");
- b.Property<int>("polist_row")
- .HasColumnType("int")
- .HasComment("行号");
- b.Property<string>("pr_billno")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("pr申请单号");
- b.Property<long>("pr_id")
- .HasColumnType("bigint")
- .HasComment("pr申请单id");
- b.Property<long>("pr_purchase_id")
- .HasColumnType("bigint")
- .HasComment("供应商id");
- b.Property<string>("pr_purchase_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("供应商名称");
- b.Property<decimal?>("price")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("含税单价");
- b.Property<decimal?>("procurement_rarr_date")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("采购到货日期");
- b.Property<decimal?>("pur_affirmdate")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("采购确认到货日期");
- b.Property<decimal?>("purchase_date")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("供应商交期");
- b.Property<decimal?>("qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("订单数量");
- b.Property<DateTime?>("rarrdate")
- .HasColumnType("datetime")
- .HasComment("需求到货日期");
- b.Property<decimal?>("rate")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("税率");
- b.Property<int>("rnumber")
- .HasColumnType("int")
- .HasComment("评审次数");
- b.Property<decimal?>("rparrive_date")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("再计划到货日期");
- b.Property<decimal?>("rqty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("已收货数量");
- b.Property<int>("rstate")
- .HasColumnType("int")
- .HasComment("评审状态");
- b.Property<int>("state")
- .HasColumnType("int")
- .HasComment("数据状态标识");
- b.Property<long>("stock_id")
- .HasColumnType("bigint")
- .HasComment("收货仓库id");
- b.Property<string>("stock_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("收货仓库名称");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<decimal?>("total_price")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("总价");
- b.Property<long>("unit")
- .HasColumnType("bigint")
- .HasComment("单位");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("polist_id");
- b.ToTable("srm_po_list", (string)null);
- b.HasComment("采购订单明细详情");
- });
- modelBuilder.Entity("Bussiness.Model.SRM.srm_po_main", b =>
- {
- b.Property<long>("po_Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<int>("bill_type")
- .HasColumnType("int")
- .HasComment("金蝶单据类型值");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long>("currency")
- .HasColumnType("bigint")
- .HasComment("币别");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("po_billno")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("PO单号");
- b.Property<long>("po_delivery")
- .HasColumnType("bigint")
- .HasComment("交货方式");
- b.Property<int>("po_express")
- .HasColumnType("int")
- .HasComment("是否加急");
- b.Property<string>("po_note")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)")
- .HasComment("备注");
- b.Property<int>("po_order_type")
- .HasColumnType("int")
- .HasComment("单据类型");
- b.Property<long>("po_purchase_id")
- .HasColumnType("bigint")
- .HasComment("供应商id");
- b.Property<string>("po_purchase_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("供应商名称");
- b.Property<string>("po_purchaser")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("采购员");
- b.Property<string>("po_purchaser_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("采购员工号");
- b.Property<DateTime?>("po_ssend_date")
- .HasColumnType("datetime")
- .HasComment("下单日期");
- b.Property<decimal?>("po_tax_rate")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("税率");
- b.Property<decimal?>("po_total")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("订单总价");
- b.Property<DateTime?>("review_rtime")
- .HasColumnType("datetime")
- .HasComment("评审通过时间");
- b.Property<decimal?>("rnumber")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("评审次数");
- b.Property<int>("rstate")
- .HasColumnType("int")
- .HasComment("评审状态");
- b.Property<int>("state")
- .HasColumnType("int")
- .HasComment("数据状态");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("po_Id");
- b.ToTable("srm_po_main", (string)null);
- b.HasComment("采购订单");
- });
- modelBuilder.Entity("Bussiness.Model.SRM.srm_po_occupy", b =>
- {
- b.Property<long>("pooccupy_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long>("bill_no")
- .HasColumnType("bigint")
- .HasComment("客户订单id");
- b.Property<string>("cby")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("变更人");
- b.Property<string>("creason")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)")
- .HasComment("变更原因");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<DateTime?>("ctime")
- .HasColumnType("datetime")
- .HasComment("变更时间");
- b.Property<long>("eid")
- .HasColumnType("bigint")
- .HasComment("客户订单行id");
- b.Property<int>("entry_id")
- .HasColumnType("int")
- .HasComment("行号");
- b.Property<DateTime?>("etime")
- .HasColumnType("datetime")
- .HasComment("结束时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("polist_id")
- .HasColumnType("bigint")
- .HasComment("采购订单id");
- b.Property<int>("polist_row")
- .HasColumnType("int")
- .HasComment("采购订单行号");
- b.Property<decimal?>("qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("占用量");
- b.Property<int>("state")
- .HasColumnType("int")
- .HasComment("占用状态");
- b.Property<DateTime?>("stime")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<string>("type")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("类型");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("pooccupy_id");
- b.ToTable("srm_po_occupy", (string)null);
- b.HasComment("采购订单占用详情");
- });
- modelBuilder.Entity("Bussiness.Model.SRM.srm_pr_main", b =>
- {
- b.Property<long>("pr_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long>("currencytype")
- .HasColumnType("bigint")
- .HasComment("币种");
- b.Property<int>("entity_id")
- .HasColumnType("int")
- .HasComment("工单行号");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long>("icitem_id")
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<string>("icitem_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料名称");
- b.Property<decimal?>("old_apply_aqty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("已申请数量");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<decimal?>("pr_aqty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("申请数量");
- b.Property<string>("pr_billno")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("pr单号");
- b.Property<DateTime?>("pr_bsarrive_date")
- .HasColumnType("datetime")
- .HasComment("采购员建议到货日期");
- b.Property<string>("pr_mono")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("关联工单号");
- b.Property<DateTime?>("pr_oarrive_date")
- .HasColumnType("datetime")
- .HasComment("订单到货日期");
- b.Property<int>("pr_order_type")
- .HasColumnType("int")
- .HasComment("单据类型");
- b.Property<decimal?>("pr_orderprice")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("订单价格(含税)");
- b.Property<DateTime?>("pr_parrive_date")
- .HasColumnType("datetime")
- .HasComment("计划到达日期");
- b.Property<decimal?>("pr_price")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("采购净价(不含税)");
- b.Property<DateTime?>("pr_psend_date")
- .HasColumnType("datetime")
- .HasComment("计划下单日期");
- b.Property<DateTime?>("pr_pur_affirm_date")
- .HasColumnType("datetime")
- .HasComment("采购确认到货日期");
- b.Property<long>("pr_purchaseid")
- .HasColumnType("bigint")
- .HasComment("供应商id");
- b.Property<string>("pr_purchasename")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("供应商名称");
- b.Property<string>("pr_purchasenumber")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("供应商编码");
- b.Property<string>("pr_purchaser")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("采购员");
- b.Property<string>("pr_purchaser_num")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("采购员工号");
- b.Property<DateTime?>("pr_rarrive_date")
- .HasColumnType("datetime")
- .HasComment("需求到货日期");
- b.Property<decimal?>("pr_rate")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("税率");
- b.Property<DateTime?>("pr_rparrive_date")
- .HasColumnType("datetime")
- .HasComment("再计划到货日期");
- b.Property<decimal?>("pr_rqty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("需求数量");
- b.Property<string>("pr_rreason")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)")
- .HasComment("拒绝原因");
- b.Property<DateTime?>("pr_sarrive_date")
- .HasColumnType("datetime")
- .HasComment("系统建议到达日期");
- b.Property<decimal?>("pr_sqty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("建议数量");
- b.Property<DateTime?>("pr_ssend_date")
- .HasColumnType("datetime")
- .HasComment("系统建议下单日期");
- b.Property<decimal?>("pr_sysprice")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("系统价格(含税)");
- b.Property<int>("pr_type")
- .HasColumnType("int")
- .HasComment("申请类型");
- b.Property<string>("pr_unit")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)")
- .HasComment("单位");
- b.Property<string>("remark")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)")
- .HasComment("备注");
- b.Property<decimal?>("secInv_ratio")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("安全库存触发采购比例");
- b.Property<int>("state")
- .HasColumnType("int")
- .HasComment("状态");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("pr_id");
- b.ToTable("srm_pr_main", (string)null);
- b.HasComment("采购申请单");
- });
- modelBuilder.Entity("Bussiness.Model.SRM.srm_purchase", b =>
- {
- b.Property<long>("ic_purchase_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<decimal?>("batch_append_qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("批量增量");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<string>("factory_code")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("工厂编码");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long>("ic_plan_id")
- .HasColumnType("bigint")
- .HasComment("计划id");
- b.Property<long>("icitem_id")
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<string>("icitem_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料名称");
- b.Property<string>("order_dept")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("采购部门");
- b.Property<decimal?>("order_price")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("采购单价");
- b.Property<string>("order_rector_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("采购负责人");
- b.Property<string>("order_rector_num")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("采购负责人_工号");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("piv_acct")
- .HasColumnType("bigint")
- .HasComment("采购发票差异科目代码");
- b.Property<long>("pov_acct")
- .HasColumnType("bigint")
- .HasComment("采购订单差异科目代码");
- b.Property<decimal?>("qty_min")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("最小订货量");
- b.Property<decimal?>("sale_price")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("销售单价");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("ic_purchase_id");
- b.ToTable("srm_purchase", (string)null);
- b.HasComment("物料采购信息表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.crm_customer", b =>
- {
- b.Property<long>("customer_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("客户主键id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("address")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("地址");
- b.Property<int>("carrying_aos")
- .HasColumnType("int")
- .HasComment("默认运输提前期_天");
- b.Property<string>("city")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("城市");
- b.Property<string>("contact")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("联系人");
- b.Property<string>("corperate")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("法人代表");
- b.Property<string>("country")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("国别地区");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<string>("currency")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("结算币种");
- b.Property<string>("cust_group_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("客户分组名称");
- b.Property<string>("cust_group_number")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("客户分组编号");
- b.Property<string>("cust_type")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("客户类别");
- b.Property<string>("cust_type_number")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("客户类别编码");
- b.Property<string>("customer_level")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("客户级别");
- b.Property<string>("customer_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("客户名称");
- b.Property<string>("customer_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("客户编号");
- b.Property<string>("email")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("邮件地址");
- b.Property<string>("employee_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("专营业务员");
- b.Property<string>("employee_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("专营业务员_工号");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("mobile")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("手机号码");
- b.Property<DateTime?>("op_time")
- .HasColumnType("datetime")
- .HasComment("操作时间");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("post_code")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("邮政编码");
- b.Property<string>("province")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("省份");
- b.Property<string>("region")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("区");
- b.Property<string>("sale_mode")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("销售模式");
- b.Property<string>("short_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("客户简称");
- b.Property<string>("short_number")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("客户简码");
- b.Property<string>("state")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("状态");
- b.Property<string>("telephone")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("电话号码");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<decimal?>("value_add_rate")
- .HasPrecision(18, 10)
- .HasColumnType("decimal(18,10)")
- .HasComment("增值税率");
- b.HasKey("customer_id");
- b.ToTable("crm_customer", (string)null);
- b.HasComment("客户表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sim_base", b =>
- {
- b.Property<long>("sim_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<decimal?>("interval_days")
- .HasPrecision(10)
- .HasColumnType("decimal(10,0)")
- .HasComment("间隔天数");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<decimal?>("rise_cycle")
- .HasPrecision(10)
- .HasColumnType("decimal(10,0)")
- .HasComment("上升周期");
- b.Property<DateTime?>("rise_time")
- .HasColumnType("datetime")
- .HasComment("上升时间");
- b.Property<string>("sim_grade")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("sim等级");
- b.Property<int?>("sim_level")
- .HasColumnType("int")
- .HasComment("sim层级顺序");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("sim_id");
- b.ToTable("sim_base", (string)null);
- b.HasComment("sim基本表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sim_issue_type", b =>
- {
- b.Property<long>("issue_type_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("上升时间");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("app_scenario")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("应用场景");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("duty_dept")
- .HasColumnType("bigint")
- .HasComment("责任部门id");
- b.Property<string>("duty_person")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("责任人");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("issue_grade")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("问题等级");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<string>("type_code")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("类别代码");
- b.Property<string>("type_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("类别名称");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("issue_type_id");
- b.ToTable("sim_issue_type", (string)null);
- b.HasComment("sim事项类别表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sim_plant", b =>
- {
- b.Property<long>("plant_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("plant_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("事项名称");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("plant_id");
- b.ToTable("sim_plant", (string)null);
- b.HasComment("sim事项表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sim_user_relation", b =>
- {
- b.Property<long>("id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("sim_id")
- .HasColumnType("bigint")
- .HasComment("base_sim表ID");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<long>("user_id")
- .HasColumnType("bigint")
- .HasComment("用户id");
- b.HasKey("id");
- b.ToTable("sim_user_relation", (string)null);
- b.HasComment("sim用户关联表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.srm_supplier", b =>
- {
- b.Property<long>("supplier_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("供应商主键id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("addr_en")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("英文地址");
- b.Property<DateTime?>("approve_date")
- .HasColumnType("datetime")
- .HasComment("批准日期");
- b.Property<bool?>("auto_create_mr")
- .HasColumnType("tinyint(1)")
- .HasComment("交货自动生成收货单据");
- b.Property<bool?>("auto_validate_order")
- .HasColumnType("tinyint(1)")
- .HasComment("自动确认订单");
- b.Property<string>("bank")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("开户银行");
- b.Property<string>("bank_account")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("银行账号");
- b.Property<DateTime?>("begin_day")
- .HasColumnType("datetime")
- .HasComment("生效日期");
- b.Property<string>("branch_info")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("分支机构信息");
- b.Property<string>("checker")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("审核人");
- b.Property<string>("company_type")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("公司类别");
- b.Property<string>("contact")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("联系人");
- b.Property<string>("country")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("国别地区");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<string>("currency")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("结算币种");
- b.Property<string>("department")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("分管部门");
- b.Property<string>("email")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("邮件地址");
- b.Property<string>("employee_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("专营业务员");
- b.Property<string>("employee_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("专营业务员_工号");
- b.Property<DateTime?>("end_day")
- .HasColumnType("datetime")
- .HasComment("失效日期");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("fax")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("传真号码");
- b.Property<bool?>("isuse_supplier_portal")
- .HasColumnType("tinyint(1)")
- .HasComment("启用供应商门户");
- b.Property<string>("licence")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("营业执照");
- b.Property<string>("mobile")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("移动电话");
- b.Property<string>("name_en")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("英文名称");
- b.Property<DateTime?>("op_time")
- .HasColumnType("datetime")
- .HasComment("操作时间");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("po_mode")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("采购模式");
- b.Property<string>("post_code")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("邮政编码");
- b.Property<string>("region")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("区域");
- b.Property<string>("regmark")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("注册商标");
- b.Property<DateTime?>("regster_date")
- .HasColumnType("datetime")
- .HasComment("注册日期");
- b.Property<string>("settlement")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("结算方式");
- b.Property<string>("state")
- .HasColumnType("longtext")
- .HasComment("状态");
- b.Property<string>("stockid_assignee")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("受托代销虚仓");
- b.Property<string>("supplier_address")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("供应商地址");
- b.Property<string>("supplier_full_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("供应商全称");
- b.Property<string>("supplier_help_code")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("供应商助记码");
- b.Property<string>("supplier_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("供应商名称");
- b.Property<string>("supplier_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("供应商编号");
- b.Property<string>("supplier_short_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("供应商简称");
- b.Property<string>("supply_grade")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("供应商等级");
- b.Property<string>("supply_type")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("供应类别");
- b.Property<string>("taxid")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("税务登记号");
- b.Property<string>("telephone")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("联系电话");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<string>("trade")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("行业");
- b.Property<string>("type")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("供应商分类");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<decimal?>("value_add_rate")
- .HasPrecision(18, 10)
- .HasColumnType("decimal(18,10)")
- .HasComment("增值税率");
- b.Property<string>("vmi_stock")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("VMI仓");
- b.HasKey("supplier_id");
- b.ToTable("srm_supplier", (string)null);
- b.HasComment("供应商表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_code", b =>
- {
- b.Property<long>("sys_code_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键id");
- b.Property<string>("chinese_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("中文注释");
- b.Property<DateTime?>("code_date")
- .IsRequired()
- .HasColumnType("datetime")
- .HasComment("编码生成时间");
- b.Property<string>("code_name")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("编码生成名称");
- b.Property<string>("code_rule")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("编码生成规则");
- b.Property<long>("code_value")
- .HasColumnType("bigint")
- .HasComment("编码生成当前值");
- b.HasKey("sys_code_id");
- b.ToTable("sys_code", (string)null);
- b.HasComment("系统编码表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_code_pre", b =>
- {
- b.Property<long>("id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键id");
- b.Property<DateTime>("code_date")
- .HasColumnType("datetime")
- .HasComment("编码生成时间");
- b.Property<string>("code_name")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("编码生成名称");
- b.Property<long>("code_value")
- .HasColumnType("bigint")
- .HasComment("编码生成当前值");
- b.Property<string>("pre_name")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("编码生成前置名称");
- b.HasKey("id");
- b.ToTable("sys_code_pre", (string)null);
- b.HasComment("系统编码前置表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_config", b =>
- {
- b.Property<long>("config_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键id");
- b.Property<bool>("financeis_close")
- .HasColumnType("tinyint(1)")
- .HasComment("账务状态(0-关帐,1-开帐)");
- b.Property<bool>("is_show")
- .HasColumnType("tinyint(1)")
- .HasComment("是否显示(0不显示、1显示)");
- b.Property<DateTime?>("next_open_date")
- .HasColumnType("datetime")
- .HasComment("下一个开帐日期");
- b.Property<string>("type")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("配置类型");
- b.HasKey("config_id");
- b.ToTable("sys_config", (string)null);
- b.HasComment("系统配置表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_measure_unit", b =>
- {
- b.Property<long>("unit_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键id");
- b.Property<bool>("is_standard")
- .HasColumnType("tinyint(1)")
- .HasComment("是否是标准单位0-否,1是");
- b.Property<bool>("status")
- .HasColumnType("tinyint(1)")
- .HasComment("状态:0-无效,1-有效");
- b.Property<string>("unit_code")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("单位编码");
- b.Property<string>("unit_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("单位名称");
- b.HasKey("unit_id");
- b.ToTable("sys_measure_unit", (string)null);
- b.HasComment("计量单位表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_post", b =>
- {
- b.Property<long>("post_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("dept_id")
- .HasColumnType("bigint")
- .HasComment("部门id");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long?>("parent_id")
- .HasColumnType("bigint")
- .HasComment("上级岗位");
- b.Property<string>("post_code")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("岗位编码");
- b.Property<int?>("post_level")
- .HasColumnType("int")
- .HasComment("岗位级别");
- b.Property<string>("post_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("岗位名称");
- b.Property<string>("post_path")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("岗位路径");
- b.Property<string>("post_remark")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("岗位备注");
- b.Property<int?>("post_sort")
- .HasColumnType("int")
- .HasComment("岗位排序");
- b.Property<bool>("state")
- .HasMaxLength(255)
- .HasColumnType("tinyint(255)")
- .HasComment("数据状态标识 1启用 -1停用");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("post_id");
- b.ToTable("sys_post", (string)null);
- b.HasComment("岗位表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_post_staff", b =>
- {
- b.Property<long>("id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("post_id")
- .HasColumnType("bigint")
- .HasComment("岗位id");
- b.Property<long>("staff_id")
- .HasColumnType("bigint")
- .HasComment("员工id");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("id");
- b.ToTable("sys_post_staff", (string)null);
- b.HasComment("员工岗位关联表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_schedule", b =>
- {
- b.Property<long>("schedule_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("班次主键id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<bool>("is_across")
- .HasColumnType("tinyint(1)")
- .HasComment("是否跨天 1是 0否");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("remark")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("备注");
- b.Property<DateTime?>("schedule_end_time")
- .HasColumnType("datetime")
- .HasComment("结束工作时间");
- b.Property<string>("schedule_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("班次名称");
- b.Property<string>("schedule_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("班次编码");
- b.Property<DateTime?>("schedule_start_time")
- .HasColumnType("datetime")
- .HasComment("起始工作时间");
- b.Property<bool>("state")
- .HasColumnType("tinyint(1)")
- .HasComment("数据状态标识 1启用 0停用");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<int?>("validate_hours")
- .HasColumnType("int")
- .HasComment("有效时长");
- b.Property<int?>("work_hours")
- .HasColumnType("int")
- .HasComment("工作时长");
- b.HasKey("schedule_id");
- b.ToTable("sys_schedule", (string)null);
- b.HasComment("班次表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_shift", b =>
- {
- b.Property<long>("shift_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<bool>("is_across")
- .HasColumnType("tinyint(1)")
- .HasComment("岗位id");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("remark")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("备注");
- b.Property<string>("shift_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("班制名称");
- b.Property<string>("shift_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("班制编码");
- b.Property<bool>("state")
- .HasColumnType("tinyint(1)")
- .HasComment("数据状态标识 1启用 0停用");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<int?>("validate_hours")
- .HasColumnType("int")
- .HasComment("有效时长");
- b.HasKey("shift_id");
- b.ToTable("sys_shift", (string)null);
- b.HasComment("班制表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_shift_invalid_time", b =>
- {
- b.Property<long>("invalid_time_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("数据状态标识 1启用 0停用");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<DateTime>("end_time")
- .HasColumnType("datetime")
- .HasComment("结束时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("schedule_id")
- .HasColumnType("bigint")
- .HasComment("班次id");
- b.Property<DateTime>("start_time")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("invalid_time_id");
- b.ToTable("sys_shift_invalid_time", (string)null);
- b.HasComment("班次无效时间表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_shift_schedule", b =>
- {
- b.Property<long>("id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("schedule_id")
- .HasMaxLength(255)
- .HasColumnType("bigint")
- .HasComment("班次id");
- b.Property<long>("shift_id")
- .HasMaxLength(50)
- .HasColumnType("bigint")
- .HasComment("班制id");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("id");
- b.ToTable("sys_shift_schedule", (string)null);
- b.HasComment("班制班次关联表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_staff", b =>
- {
- b.Property<long>("staff_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<DateOnly?>("birthday")
- .HasColumnType("date")
- .HasComment("生日");
- b.Property<string>("card_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("卡号");
- b.Property<string>("chinese_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("中文名");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("dept_id")
- .HasColumnType("bigint")
- .HasComment("部门id");
- b.Property<string>("dept_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("部门名称");
- b.Property<string>("dept_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("部门编号");
- b.Property<string>("email")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("邮箱");
- b.Property<string>("emp_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("工号");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("id_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("身份证号");
- b.Property<string>("mobile")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("移动电话");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("org_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("组织名称");
- b.Property<string>("phone")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("电话");
- b.Property<string>("photo")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("照片");
- b.Property<string>("politics")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("政治面貌");
- b.Property<string>("sex")
- .HasMaxLength(1)
- .HasColumnType("varchar(1)")
- .HasComment("性别 1 男 2 女");
- b.Property<string>("staff_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("员工编码");
- b.Property<string>("staff_remark")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("备注");
- b.Property<bool>("state")
- .HasMaxLength(255)
- .HasColumnType("tinyint(255)")
- .HasComment("数据状态标识 1启用 0停用");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<long?>("user_id")
- .HasColumnType("bigint")
- .HasComment("用户id");
- b.Property<string>("user_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("用户名称");
- b.HasKey("staff_id");
- b.ToTable("sys_staff", (string)null);
- b.HasComment("员工表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_upload", b =>
- {
- b.Property<long>("upload_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键id");
- b.Property<string>("data_type")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("文件数据类型");
- b.Property<string>("file_type")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("文件后缀");
- b.Property<string>("file_url")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("文件存储路径");
- b.Property<string>("original_file_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("源文件名称");
- b.HasKey("upload_id");
- b.ToTable("sys_upload", (string)null);
- b.HasComment("文件上传表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.crm_seorder", b =>
- {
- b.Property<long>("seorder_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("销售订单id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<DateTime?>("audit_date")
- .HasColumnType("datetime")
- .HasComment("审核日期");
- b.Property<string>("auditor")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("审核人");
- b.Property<string>("bill_from")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("订单来源");
- b.Property<string>("bill_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("订单编号");
- b.Property<string>("biller")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("制单人");
- b.Property<bool>("closed")
- .HasColumnType("tinyint(1)")
- .HasComment("是否关闭1关闭0未关闭");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<long?>("create_dept")
- .HasColumnType("bigint")
- .HasComment("创建部门id");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<int?>("currency")
- .HasMaxLength(50)
- .HasColumnType("int")
- .HasComment("币种");
- b.Property<int?>("custom_id")
- .HasColumnType("int")
- .HasComment("客户id");
- b.Property<string>("custom_level")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("客户级别");
- b.Property<string>("custom_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("客户名称");
- b.Property<string>("custom_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("客户编码");
- b.Property<DateTime?>("date")
- .HasColumnType("datetime")
- .HasComment("签订日期");
- b.Property<string>("emp_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("业务员名称");
- b.Property<string>("emp_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("业务员工号");
- b.Property<decimal?>("exchange_rate")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("汇率");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<DateTime?>("op_time")
- .HasColumnType("datetime")
- .HasComment("操作时间");
- b.Property<int?>("order_type")
- .HasColumnType("int")
- .HasComment("订单类别(销售、计划)");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<int?>("out_stock_type")
- .HasColumnType("int")
- .HasComment("销售出库类型");
- b.Property<string>("project_code")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("项目编号");
- b.Property<string>("project_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("项目名称");
- b.Property<DateTime?>("rdate")
- .HasColumnType("datetime")
- .HasComment("采购下单日期");
- b.Property<string>("sale_dept_code")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("销售部门编号");
- b.Property<long?>("sale_dept_id")
- .HasColumnType("bigint")
- .HasComment("销售部门id");
- b.Property<string>("sale_dept_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("销售部门名称");
- b.Property<int?>("sale_style")
- .HasColumnType("int")
- .HasComment("销售订单类型");
- b.Property<string>("sale_style_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("销售订单类型编码");
- b.Property<int?>("status")
- .HasColumnType("int")
- .HasComment("订单状态");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<int?>("trade_type")
- .HasColumnType("int")
- .HasComment("贸易类型");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<int?>("urgent")
- .HasColumnType("int")
- .HasComment("加急级别");
- b.HasKey("seorder_id");
- b.ToTable("crm_seorder", (string)null);
- b.HasComment("销售订单");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.crm_seorderentry", b =>
- {
- b.Property<long>("seorderentry_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("销售订单明细表id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<DateTime?>("adjust_date")
- .HasColumnType("datetime")
- .HasComment("调整建议交期");
- b.Property<decimal?>("amount")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("金额");
- b.Property<decimal?>("aux_price_discount")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("实际含税单价");
- b.Property<string>("bill_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("销售订单编号");
- b.Property<string>("bom_number")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("BOM编号");
- b.Property<string>("contract_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("合同编号");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<long?>("create_dept")
- .HasColumnType("bigint")
- .HasComment("创建部门id");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<string>("custom_order_bill_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("客户订单号");
- b.Property<int?>("custom_order_entryid")
- .HasColumnType("int")
- .HasComment("客户订单行号");
- b.Property<string>("custom_order_itemno")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("客户料号");
- b.Property<DateTime?>("date")
- .HasColumnType("datetime")
- .HasComment("最终交货日期");
- b.Property<decimal?>("deliver_count")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("发货数量(已出库数量)");
- b.Property<decimal?>("deliver_notice_count")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("发货通知单数量");
- b.Property<decimal?>("discount_amount")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("折扣额");
- b.Property<decimal?>("discount_rate")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("折扣率");
- b.Property<int?>("entry_seq")
- .HasColumnType("int")
- .HasComment("行号");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("fms_number")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("FMS旧料号");
- b.Property<bool?>("is_checked")
- .HasColumnType("tinyint(1)")
- .HasComment("是否完成检测,0未完成,1完成");
- b.Property<string>("item_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("产品名称");
- b.Property<string>("item_number")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("产品代码");
- b.Property<string>("map_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("代码名称");
- b.Property<string>("map_number")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("对应代码");
- b.Property<bool?>("mrp_closed")
- .HasColumnType("tinyint(1)")
- .HasComment("mrp关闭");
- b.Property<DateTime?>("op_time")
- .HasColumnType("datetime")
- .HasComment("操作时间");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("out_stock_type")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("出库类型");
- b.Property<DateTime?>("plan_date")
- .HasColumnType("datetime")
- .HasComment("客户要求交期");
- b.Property<string>("planner_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("计划员");
- b.Property<string>("planner_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("计划员_工号");
- b.Property<decimal?>("price")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("单价");
- b.Property<string>("progress")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("订单进度");
- b.Property<decimal?>("qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("订单数量");
- b.Property<string>("remark")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("备注");
- b.Property<int?>("rnumber")
- .HasColumnType("int")
- .HasComment("评审次数");
- b.Property<int?>("rstate")
- .HasColumnType("int")
- .HasComment("评审状态");
- b.Property<string>("se_reject_reason")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("业务员工号");
- b.Property<long>("seorder_id")
- .HasColumnType("bigint")
- .HasComment("销售订单id");
- b.Property<string>("soure_bill_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("源单编号");
- b.Property<string>("specification")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("规格型号");
- b.Property<bool>("state")
- .HasColumnType("tinyint(1)")
- .HasComment("数据状态标识 0停用 1启用");
- b.Property<DateTime?>("sys_capacity_date")
- .HasColumnType("datetime")
- .HasComment("系统建议交期(产能)");
- b.Property<DateTime?>("sys_material_date")
- .HasColumnType("datetime")
- .HasComment("系统建议交期(物料)");
- b.Property<decimal?>("tax_amtount")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("销项税额");
- b.Property<decimal?>("tax_price")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("含税单价");
- b.Property<decimal?>("tax_rate")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("税率");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<decimal?>("total_amount")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("价税合计");
- b.Property<string>("unit")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("单位");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<int?>("urgent")
- .HasColumnType("int")
- .HasComment("加急级别");
- b.HasKey("seorderentry_id");
- b.ToTable("crm_seorderentry", (string)null);
- b.HasComment("销售订单明细表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.crm_seorderprog", b =>
- {
- b.Property<long>("seorderprog_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("销售订单进度表");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("bill_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("销售订单编号");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<long?>("create_dept")
- .HasColumnType("bigint")
- .HasComment("创建部门id");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<int?>("entry_seq")
- .HasColumnType("int")
- .HasComment("销售订单行号");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("seorder_id")
- .HasColumnType("bigint")
- .HasComment("销售订单id");
- b.Property<long?>("seprog_by_id")
- .HasColumnType("bigint")
- .HasComment("提交人id");
- b.Property<string>("seprog_by_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("提交人姓名");
- b.Property<DateTime?>("seprog_etime")
- .HasColumnType("datetime")
- .HasComment("完成时间");
- b.Property<string>("seprog_stage")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("进度阶段");
- b.Property<long?>("seprog_stage_id")
- .HasColumnType("bigint")
- .HasComment("进度阶段id");
- b.Property<DateTime?>("seprog_stime")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- b.Property<int?>("seprog_type")
- .HasColumnType("int")
- .HasComment("进度类型");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("seorderprog_id");
- b.ToTable("crm_seorderprog", (string)null);
- b.HasComment("销售订单进度表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.crm_seorderreview", b =>
- {
- b.Property<long>("review_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("销售订单评审id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("audit_procedure_id")
- .HasColumnType("bigint")
- .HasComment("当前审批步骤id");
- b.Property<string>("audit_procedure_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("当前审批步骤名称");
- b.Property<string>("bill_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("销售订单编号");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<int?>("entry_seq")
- .HasColumnType("int")
- .HasComment("销售订单行号");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("reject_reason")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("拒绝原因");
- b.Property<DateTime?>("review_adjust_time")
- .HasMaxLength(255)
- .HasColumnType("datetime")
- .HasComment("可接受交期");
- b.Property<long?>("review_by_id")
- .HasColumnType("bigint")
- .HasComment("提交人id");
- b.Property<string>("review_by_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("提交人姓名");
- b.Property<string>("review_reject_level")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("拒绝等级");
- b.Property<string>("review_reject_remark")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("拒绝备注");
- b.Property<string>("review_result")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("评审结果");
- b.Property<DateTime?>("review_stime")
- .HasColumnType("datetime")
- .HasComment("提交时间");
- b.Property<DateTime?>("review_time")
- .HasColumnType("datetime")
- .HasComment("评审时间");
- b.Property<string>("review_title")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("标题");
- b.Property<string>("review_type")
- .IsRequired()
- .HasColumnType("longtext")
- .HasComment("业务类型");
- b.Property<long?>("reviewer_id")
- .HasColumnType("bigint")
- .HasComment("评审人id");
- b.Property<string>("reviewer_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("评审人姓名");
- b.Property<long>("seorder_id")
- .HasColumnType("bigint")
- .HasComment("销售订单id");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("review_id");
- b.ToTable("crm_seorderreview", (string)null);
- b.HasComment("销售订单评审表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_process", b =>
- {
- b.Property<long>("proc_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("工序主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("long_desc")
- .HasMaxLength(2000)
- .HasColumnType("varchar(2000)")
- .HasComment("详细描述");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("proc_name")
- .IsRequired()
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("工序名称");
- b.Property<string>("short_desc")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("简述");
- b.Property<string>("subids")
- .HasMaxLength(2000)
- .HasColumnType("varchar(2000)")
- .HasComment("组合工序id");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("proc_id");
- b.ToTable("mes_process", (string)null);
- b.HasComment("工序表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_tech_proc_accessory", b =>
- {
- b.Property<long>("tech_proc_acc_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("治具主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long>("equip_id")
- .HasColumnType("bigint")
- .HasComment("工装id");
- b.Property<string>("equip_no")
- .IsRequired()
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("工装编号");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<int>("qty")
- .HasColumnType("int")
- .HasComment("数量");
- b.Property<long>("tech_proc_id")
- .HasColumnType("bigint")
- .HasComment("工艺工序主键");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("tech_proc_acc_id");
- b.ToTable("mes_tech_proc_accessory", (string)null);
- b.HasComment("治具表(工装表)");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_tech_proc_document", b =>
- {
- b.Property<long>("tech_proc_doc_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("工序作业指导书主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("name")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("作业指导书名称");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("tech_proc_id")
- .HasColumnType("bigint")
- .HasComment("工艺工序主键");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<long>("upload_id")
- .HasColumnType("bigint")
- .HasComment("作业指导书主键");
- b.HasKey("tech_proc_doc_id");
- b.ToTable("mes_tech_proc_document", (string)null);
- b.HasComment("工序作业指导书表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_tech_proc_equipment", b =>
- {
- b.Property<long>("tech_proc_equip_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long>("equip_id")
- .HasColumnType("bigint")
- .HasComment("设备id");
- b.Property<string>("equip_name")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("设备名称");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("tech_proc_id")
- .HasColumnType("bigint")
- .HasComment("工艺工序id");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<long?>("work_calendar_id")
- .HasColumnType("bigint")
- .HasComment("工作日历id");
- b.HasKey("tech_proc_equip_id");
- b.ToTable("mes_tech_proc_workshop_equipment", (string)null);
- b.HasComment("工艺路径关联设备表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_tech_proc_icitem", b =>
- {
- b.Property<long>("tech_proc_icitem_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long>("icitem_id")
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<int>("qty")
- .HasColumnType("int")
- .HasComment("数量");
- b.Property<long>("tech_proc_id")
- .HasColumnType("bigint")
- .HasComment("工艺工序id");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("tech_proc_icitem_id");
- b.ToTable("mes_tech_proc_workshop_icitem", (string)null);
- b.HasComment("发料到工位表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_tech_proc_workshop", b =>
- {
- b.Property<long>("tech_proc_workshop_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("工位表主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<int?>("serialno")
- .HasColumnType("int")
- .HasComment("序列号");
- b.Property<long>("tech_proc_id")
- .HasColumnType("bigint")
- .HasComment("工艺工序id");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<long>("workshop_id")
- .HasColumnType("bigint")
- .HasComment("工位id");
- b.HasKey("tech_proc_workshop_id");
- b.ToTable("mes_tech_proc_workshop", (string)null);
- b.HasComment("工艺路径关联工位表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_tech_proc_workshop_staff", b =>
- {
- b.Property<long>("tech_proc_workshop_equip_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("staff_id")
- .HasColumnType("bigint")
- .HasComment("员工id");
- b.Property<string>("staff_name")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("员工姓名");
- b.Property<long>("tech_proc_workshop_id")
- .HasColumnType("bigint")
- .HasComment("工艺工位id");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("tech_proc_workshop_equip_id");
- b.ToTable("mes_tech_proc_workshop_staff", (string)null);
- b.HasComment("工序工位员工信息表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_tech_process", b =>
- {
- b.Property<long>("tech_proc_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("工艺工序主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<decimal?>("ct")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("节拍时间");
- b.Property<decimal?>("effect_ratio")
- .HasPrecision(10, 4)
- .HasColumnType("decimal(10,4)")
- .HasComment("效率系数");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<int>("is_schedule")
- .HasColumnType("int")
- .HasComment("是否需要排产:1-是;0-否");
- b.Property<int>("level")
- .HasColumnType("int")
- .HasComment("组合层级");
- b.Property<int?>("maxworkshop")
- .HasColumnType("int")
- .HasComment("最大并行工位数");
- b.Property<int?>("mototrack")
- .HasColumnType("int")
- .HasComment("是否需要跟踪工序");
- b.Property<int?>("needqc")
- .HasColumnType("int")
- .HasComment("是否需要质检");
- b.Property<long?>("nextprocid")
- .HasColumnType("bigint")
- .HasComment("下一工序id");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long?>("parentprocid")
- .HasColumnType("bigint")
- .HasComment("父级工序id");
- b.Property<long>("proc_id")
- .HasColumnType("bigint")
- .HasComment("工序主键");
- b.Property<decimal?>("readytime")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("前置准备时间");
- b.Property<long>("tech_id")
- .HasColumnType("bigint")
- .HasComment("工艺主键");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<int>("type")
- .HasColumnType("int")
- .HasComment("效率计算类型 1-节拍时间;2-UPH");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<decimal?>("uph")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("UPH");
- b.HasKey("tech_proc_id");
- b.ToTable("mes_tech_process", (string)null);
- b.HasComment("工艺关联工序表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_technique", b =>
- {
- b.Property<long>("tech_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("工艺路径主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("bom")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("产品");
- b.Property<string>("bomver")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("产品版本");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<string>("desc")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("描述");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<int>("level")
- .HasColumnType("int")
- .HasComment("效率计算层级");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("tech_name")
- .IsRequired()
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("工艺路径名称");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("tech_id");
- b.ToTable("mes_technique", (string)null);
- b.HasComment("工艺路径表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_work_calendar", b =>
- {
- b.Property<long>("work_calendar_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("工作日历主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<int?>("calendar1")
- .HasColumnType("int")
- .HasComment("周1");
- b.Property<int?>("calendar2")
- .HasColumnType("int")
- .HasComment("周2");
- b.Property<int?>("calendar3")
- .HasColumnType("int")
- .HasComment("周3");
- b.Property<int?>("calendar4")
- .HasColumnType("int")
- .HasComment("周4");
- b.Property<int?>("calendar5")
- .HasColumnType("int")
- .HasComment("周5");
- b.Property<int?>("calendar6")
- .HasColumnType("int")
- .HasComment("周6");
- b.Property<int?>("calendar7")
- .HasColumnType("int")
- .HasComment("周7");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<DateTime?>("end_time")
- .HasColumnType("datetime")
- .HasComment("结束时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<int?>("rest_period")
- .HasColumnType("int")
- .HasComment("休息周期");
- b.Property<long?>("shift_id")
- .HasColumnType("bigint")
- .HasComment("班制id");
- b.Property<int?>("standard_period")
- .HasColumnType("int")
- .HasComment("标准周期");
- b.Property<DateTime?>("start_time")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<string>("work_calendar_name")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("工作日历名称");
- b.Property<string>("work_calendar_no")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("工作日历编码");
- b.Property<int?>("work_period")
- .HasColumnType("int")
- .HasComment("工作周期");
- b.HasKey("work_calendar_id");
- b.ToTable("work_calendar", (string)null);
- b.HasComment("工作日历表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_work_calendar_list", b =>
- {
- b.Property<long>("work_cal_list_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("工作日历明细主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<DateTime?>("work_cal_list_date")
- .HasColumnType("datetime")
- .HasComment("日期");
- b.Property<int?>("work_cal_list_num")
- .HasColumnType("int")
- .HasComment("班次数");
- b.Property<int?>("work_cal_list_times")
- .HasColumnType("int")
- .HasComment("工作时长(分钟)");
- b.Property<int?>("work_cal_list_type")
- .HasColumnType("int")
- .HasComment("类型:1-工作日;0-休息日");
- b.Property<long>("work_calendar_id")
- .HasColumnType("bigint")
- .HasComment("工作日历id");
- b.HasKey("work_cal_list_id");
- b.ToTable("work_calendar_list", (string)null);
- b.HasComment("工作日历明细表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_workshop", b =>
- {
- b.Property<long>("workshop_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("工位表主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("building")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("楼栋");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("floor")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("楼层");
- b.Property<string>("geoinfo")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("坐标");
- b.Property<string>("name")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("工位名称");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("subids")
- .HasMaxLength(2000)
- .HasColumnType("varchar(2000)")
- .HasComment("组合工位ids");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<long?>("work_calendar_id")
- .HasColumnType("bigint")
- .HasComment("工作日历id");
- b.Property<string>("zone")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("区域");
- b.HasKey("workshop_id");
- b.ToTable("mes_workshop", (string)null);
- b.HasComment("工位表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_workshop_shelf", b =>
- {
- b.Property<long>("workshop_shelf_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("geoinfo")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("坐标");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<int?>("serialno")
- .HasColumnType("int")
- .HasComment("线边仓序列号");
- b.Property<string>("sheifno")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("仓库编号");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.Property<long>("workshop_id")
- .HasColumnType("bigint")
- .HasComment("工位id");
- b.HasKey("workshop_shelf_id");
- b.ToTable("mes_workshop_shelf", (string)null);
- b.HasComment("工位关联线边仓表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.wms_prdprogress", b =>
- {
- b.Property<long>("progress_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("进度字典主键id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("prdprog_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("进度名称");
- b.Property<int>("prdprog_seq")
- .HasColumnType("int")
- .HasComment("进度顺序");
- b.Property<string>("prdprog_type")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("进度类型");
- b.Property<bool>("state")
- .HasColumnType("tinyint(1)")
- .HasComment("进度状态1启用0停用");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("progress_id");
- b.ToTable("wms_prdprogress", (string)null);
- b.HasComment("进度字典");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.wms_shipnotice", b =>
- {
- b.Property<long>("shipnotice_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("发运通知单主键id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("address")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("发运地址");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<DateTime>("shipnotice_date")
- .HasColumnType("datetime")
- .HasComment("发运时间");
- b.Property<string>("shipnotice_no")
- .IsRequired()
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("发运通知单号");
- b.Property<long>("shipplan_id")
- .HasColumnType("bigint")
- .HasComment("发货计划id");
- b.Property<string>("shipplan_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("发货计划号");
- b.Property<string>("state")
- .IsRequired()
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("状态");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("shipnotice_id");
- b.ToTable("wms_shipnotice", (string)null);
- b.HasComment("发货通知单");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.wms_shipnoticelist", b =>
- {
- b.Property<long>("shipnoticelist_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("发运通知单详情id");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("address")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("发运地址");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long?>("shipnotice_custid")
- .HasColumnType("bigint")
- .HasComment("客户id");
- b.Property<string>("shipnotice_custname")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("客户名称");
- b.Property<string>("shipnotice_custno")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("客户编号");
- b.Property<long>("shipnotice_id")
- .HasMaxLength(80)
- .HasColumnType("bigint")
- .HasComment("发货计划号");
- b.Property<decimal?>("shipplanl_fqty")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("实际发货数量");
- b.Property<decimal?>("shipplanl_iqty")
- .HasPrecision(20, 10)
- .HasColumnType("decimal(20,10)")
- .HasComment("计划发货数量");
- b.Property<int?>("shipplanl_soeid")
- .HasColumnType("int")
- .HasComment("销售单行号");
- b.Property<long?>("shipplanl_soid")
- .HasColumnType("bigint")
- .HasComment("销售单id");
- b.Property<string>("shipplanl_sono")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("销售单号");
- b.Property<long?>("shipplanlist_id")
- .HasColumnType("bigint")
- .HasComment("发货详情id");
- b.Property<string>("state")
- .IsRequired()
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("状态");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("shipnoticelist_id");
- b.ToTable("wms_shipnoticelist", (string)null);
- b.HasComment("发货通知单明细表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.wms_shipplan", b =>
- {
- b.Property<long>("shipplan_id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint")
- .HasComment("发货计划表主键");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("create_by")
- .HasColumnType("bigint")
- .HasComment("创建人id");
- b.Property<string>("create_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("创建人名称");
- b.Property<DateTime?>("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<DateTime?>("shipplan_date")
- .HasColumnType("datetime")
- .HasComment("发货计划时间");
- b.Property<string>("shipplan_no")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("发货计划编号");
- b.Property<string>("state")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("状态");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<long?>("update_by")
- .HasColumnType("bigint")
- .HasComment("修改人");
- b.Property<string>("update_by_name")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("修改人名称");
- b.Property<DateTime?>("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- b.HasKey("shipplan_id");
- b.ToTable("wms_shipplan", (string)null);
- b.HasComment("发货计划表");
- });
- modelBuilder.Entity("XCZ.FlowManagement.BaseFlow", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("char(36)");
- b.Property<string>("Code")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasMaxLength(40)
- .HasColumnType("varchar(40)")
- .HasColumnName("ConcurrencyStamp");
- b.Property<DateTime>("CreationTime")
- .HasColumnType("datetime")
- .HasColumnName("CreationTime");
- b.Property<Guid?>("CreatorId")
- .HasColumnType("char(36)")
- .HasColumnName("CreatorId");
- b.Property<string>("ExtraProperties")
- .HasColumnType("longtext")
- .HasColumnName("ExtraProperties");
- b.Property<Guid>("FormId")
- .HasColumnType("char(36)");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted");
- b.Property<DateTime?>("LastModificationTime")
- .HasColumnType("datetime")
- .HasColumnName("LastModificationTime");
- b.Property<Guid?>("LastModifierId")
- .HasColumnType("char(36)")
- .HasColumnName("LastModifierId");
- b.Property<int>("Level")
- .HasColumnType("int");
- b.Property<string>("Remark")
- .HasMaxLength(200)
- .HasColumnType("varchar(200)");
- b.Property<int>("Status")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasDefaultValue(0);
- b.Property<Guid?>("TenantId")
- .HasColumnType("char(36)")
- .HasColumnName("TenantId");
- b.Property<string>("Title")
- .IsRequired()
- .HasMaxLength(100)
- .HasColumnType("varchar(100)");
- b.Property<string>("UseDate")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.HasKey("Id");
- b.HasIndex("FormId");
- b.ToTable("base_flow", (string)null);
- });
- modelBuilder.Entity("XCZ.FlowManagement.FlowLine", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("char(36)");
- b.Property<Guid>("BaseFlowId")
- .HasColumnType("char(36)");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasMaxLength(40)
- .HasColumnType("varchar(40)")
- .HasColumnName("ConcurrencyStamp");
- b.Property<string>("ExtraProperties")
- .HasColumnType("longtext")
- .HasColumnName("ExtraProperties");
- b.Property<string>("From")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted");
- b.Property<string>("Label")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)");
- b.Property<string>("Remark")
- .HasMaxLength(200)
- .HasColumnType("varchar(200)");
- b.Property<Guid?>("TenantId")
- .HasColumnType("char(36)")
- .HasColumnName("TenantId");
- b.Property<string>("To")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.HasKey("Id");
- b.ToTable("base_flow_line", (string)null);
- });
- modelBuilder.Entity("XCZ.FlowManagement.FlowNode", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("char(36)");
- b.Property<Guid>("BaseFlowId")
- .HasColumnType("char(36)");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasMaxLength(40)
- .HasColumnType("varchar(40)")
- .HasColumnName("ConcurrencyStamp");
- b.Property<string>("Executor")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<string>("ExtraProperties")
- .HasColumnType("longtext")
- .HasColumnName("ExtraProperties");
- b.Property<string>("Ico")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted");
- b.Property<string>("Left")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<string>("Name")
- .IsRequired()
- .HasMaxLength(100)
- .HasColumnType("varchar(100)");
- b.Property<string>("NodeId")
- .IsRequired()
- .HasMaxLength(100)
- .HasColumnType("varchar(100)");
- b.Property<string>("Remark")
- .HasMaxLength(200)
- .HasColumnType("varchar(200)");
- b.Property<string>("Roles")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)");
- b.Property<string>("State")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<Guid?>("TenantId")
- .HasColumnType("char(36)")
- .HasColumnName("TenantId");
- b.Property<string>("Top")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<string>("Type")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<string>("Users")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)");
- b.HasKey("Id");
- b.ToTable("base_flow_node", (string)null);
- });
- modelBuilder.Entity("XCZ.FlowManagement.LineForm", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("char(36)");
- b.Property<Guid>("BaseFlowId")
- .HasColumnType("char(36)");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasMaxLength(40)
- .HasColumnType("varchar(40)")
- .HasColumnName("ConcurrencyStamp");
- b.Property<string>("Condition")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)");
- b.Property<string>("Content")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)");
- b.Property<string>("ExtraProperties")
- .HasColumnType("longtext")
- .HasColumnName("ExtraProperties");
- b.Property<Guid>("FieldId")
- .HasColumnType("char(36)");
- b.Property<string>("FieldName")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)");
- b.Property<string>("FieldType")
- .HasMaxLength(20)
- .HasColumnType("varchar(20)");
- b.Property<Guid>("FlowLineId")
- .HasColumnType("char(36)");
- b.Property<int>("IntContent")
- .HasColumnType("int");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted");
- b.Property<string>("Remark")
- .HasMaxLength(200)
- .HasColumnType("varchar(200)");
- b.Property<Guid?>("TenantId")
- .HasColumnType("char(36)")
- .HasColumnName("TenantId");
- b.HasKey("Id");
- b.ToTable("base_flow_line_form", (string)null);
- });
- modelBuilder.Entity("XCZ.FormManagement.Form", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("char(36)");
- b.Property<string>("Api")
- .IsRequired()
- .HasMaxLength(200)
- .HasColumnType("varchar(200)");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasMaxLength(40)
- .HasColumnType("varchar(40)")
- .HasColumnName("ConcurrencyStamp");
- b.Property<DateTime>("CreationTime")
- .HasColumnType("datetime")
- .HasColumnName("CreationTime");
- b.Property<Guid?>("CreatorId")
- .HasColumnType("char(36)")
- .HasColumnName("CreatorId");
- b.Property<string>("Description")
- .IsRequired()
- .HasMaxLength(200)
- .HasColumnType("varchar(200)");
- b.Property<bool>("Disabled")
- .HasColumnType("tinyint(1)");
- b.Property<string>("DisplayName")
- .IsRequired()
- .HasMaxLength(100)
- .HasColumnType("varchar(100)");
- b.Property<string>("EntityName")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<string>("ExtraProperties")
- .HasColumnType("longtext")
- .HasColumnName("ExtraProperties");
- b.Property<string>("FormName")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted");
- b.Property<DateTime?>("LastModificationTime")
- .HasColumnType("datetime")
- .HasColumnName("LastModificationTime");
- b.Property<Guid?>("LastModifierId")
- .HasColumnType("char(36)")
- .HasColumnName("LastModifierId");
- b.Property<string>("Namespace")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<string>("Remark")
- .HasMaxLength(200)
- .HasColumnType("varchar(200)");
- b.Property<string>("TableName")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<Guid?>("TenantId")
- .HasColumnType("char(36)")
- .HasColumnName("TenantId");
- b.HasKey("Id");
- b.ToTable("base_form", (string)null);
- });
- modelBuilder.Entity("XCZ.FormManagement.FormData", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("char(36)");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasMaxLength(40)
- .HasColumnType("varchar(40)")
- .HasColumnName("ConcurrencyStamp");
- b.Property<DateTime>("CreationTime")
- .HasColumnType("datetime")
- .HasColumnName("CreationTime");
- b.Property<Guid?>("CreatorId")
- .HasColumnType("char(36)")
- .HasColumnName("CreatorId");
- b.Property<string>("Data")
- .HasColumnType("longtext");
- b.Property<string>("ExtraProperties")
- .HasColumnType("longtext")
- .HasColumnName("ExtraProperties");
- b.Property<Guid>("FormId")
- .HasColumnType("char(36)");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted");
- b.Property<DateTime?>("LastModificationTime")
- .HasColumnType("datetime")
- .HasColumnName("LastModificationTime");
- b.Property<Guid?>("LastModifierId")
- .HasColumnType("char(36)")
- .HasColumnName("LastModifierId");
- b.Property<Guid?>("TenantId")
- .HasColumnType("char(36)")
- .HasColumnName("TenantId");
- b.HasKey("Id");
- b.ToTable("base_form_datas", (string)null);
- });
- modelBuilder.Entity("XCZ.FormManagement.FormField", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("char(36)");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasMaxLength(40)
- .HasColumnType("varchar(40)")
- .HasColumnName("ConcurrencyStamp");
- b.Property<string>("DataType")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<string>("DefaultValue")
- .HasMaxLength(256)
- .HasColumnType("varchar(256)");
- b.Property<bool>("Disabled")
- .HasColumnType("tinyint(1)");
- b.Property<string>("ExtraProperties")
- .HasColumnType("longtext")
- .HasColumnName("ExtraProperties");
- b.Property<string>("FieldName")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<int>("FieldOrder")
- .HasColumnType("int");
- b.Property<string>("FieldType")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<Guid>("FormId")
- .HasColumnType("char(36)");
- b.Property<string>("Icon")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<bool>("IsIndex")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false);
- b.Property<bool>("IsReadonly")
- .HasColumnType("tinyint(1)");
- b.Property<bool>("IsRequired")
- .HasColumnType("tinyint(1)");
- b.Property<bool>("IsSort")
- .HasColumnType("tinyint(1)");
- b.Property<string>("Label")
- .IsRequired()
- .HasMaxLength(128)
- .HasColumnType("varchar(128)");
- b.Property<int?>("Maxlength")
- .HasColumnType("int");
- b.Property<string>("Placeholder")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<string>("Regx")
- .HasColumnType("longtext");
- b.Property<int>("Span")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasDefaultValue(24);
- b.Property<Guid?>("TenantId")
- .HasColumnType("char(36)");
- b.HasKey("Id");
- b.ToTable("base_form_fields", (string)null);
- });
- modelBuilder.Entity("XCZ.FormManagement.FormFieldOption", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("char(36)");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasMaxLength(40)
- .HasColumnType("varchar(40)")
- .HasColumnName("ConcurrencyStamp");
- b.Property<string>("ExtraProperties")
- .HasColumnType("longtext")
- .HasColumnName("ExtraProperties");
- b.Property<Guid>("FormFieldId")
- .HasColumnType("char(36)");
- b.Property<Guid>("FormId")
- .HasColumnType("char(36)");
- b.Property<string>("Label")
- .IsRequired()
- .HasMaxLength(200)
- .HasColumnType("varchar(200)");
- b.Property<Guid?>("TenantId")
- .HasColumnType("char(36)");
- b.Property<string>("Value")
- .IsRequired()
- .HasMaxLength(200)
- .HasColumnType("varchar(200)");
- b.HasKey("Id");
- b.ToTable("base_form_fields_opts", (string)null);
- });
- modelBuilder.Entity("XCZ.WorkFlow.FormWorkFlow", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("char(36)");
- b.Property<Guid>("BaseFlowId")
- .HasColumnType("char(36)");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasMaxLength(40)
- .HasColumnType("varchar(40)")
- .HasColumnName("ConcurrencyStamp");
- b.Property<DateTime>("CreationTime")
- .HasColumnType("datetime")
- .HasColumnName("CreationTime");
- b.Property<Guid?>("CreatorId")
- .HasColumnType("char(36)")
- .HasColumnName("CreatorId");
- b.Property<Guid>("EntityId")
- .HasColumnType("char(36)");
- b.Property<string>("ExtraProperties")
- .HasColumnType("longtext")
- .HasColumnName("ExtraProperties");
- b.Property<Guid>("FormId")
- .HasColumnType("char(36)");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted");
- b.Property<DateTime?>("LastModificationTime")
- .HasColumnType("datetime")
- .HasColumnName("LastModificationTime");
- b.Property<Guid?>("LastModifierId")
- .HasColumnType("char(36)")
- .HasColumnName("LastModifierId");
- b.Property<string>("NodeId")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)");
- b.Property<int>("Status")
- .ValueGeneratedOnAdd()
- .HasColumnType("int")
- .HasDefaultValue(0);
- b.Property<Guid?>("TenantId")
- .HasColumnType("char(36)")
- .HasColumnName("TenantId");
- b.HasKey("Id");
- b.HasIndex("EntityId");
- b.HasIndex("NodeId");
- b.ToTable("base_form_workflow", (string)null);
- });
- #pragma warning restore 612, 618
- }
- }
- }
|