| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146314731483149315031513152315331543155315631573158315931603161316231633164316531663167316831693170317131723173317431753176317731783179318031813182318331843185318631873188318931903191319231933194319531963197319831993200320132023203320432053206320732083209321032113212321332143215321632173218321932203221322232233224322532263227322832293230323132323233323432353236323732383239324032413242324332443245324632473248324932503251325232533254325532563257325832593260326132623263326432653266326732683269327032713272327332743275327632773278327932803281328232833284328532863287328832893290329132923293329432953296329732983299330033013302330333043305330633073308330933103311331233133314331533163317331833193320332133223323332433253326332733283329333033313332333333343335333633373338333933403341334233433344334533463347334833493350335133523353335433553356335733583359336033613362336333643365336633673368336933703371337233733374337533763377337833793380338133823383338433853386338733883389339033913392339333943395339633973398339934003401340234033404340534063407340834093410341134123413341434153416341734183419342034213422342334243425342634273428342934303431343234333434343534363437343834393440344134423443344434453446344734483449345034513452345334543455345634573458345934603461346234633464346534663467346834693470347134723473347434753476347734783479348034813482348334843485348634873488348934903491349234933494349534963497349834993500350135023503350435053506350735083509351035113512351335143515351635173518351935203521352235233524352535263527352835293530353135323533353435353536353735383539354035413542354335443545354635473548354935503551355235533554355535563557355835593560356135623563356435653566356735683569357035713572357335743575357635773578357935803581358235833584358535863587358835893590359135923593359435953596359735983599360036013602360336043605360636073608360936103611361236133614361536163617361836193620362136223623362436253626362736283629363036313632363336343635363636373638363936403641364236433644364536463647364836493650365136523653365436553656365736583659366036613662366336643665366636673668366936703671367236733674367536763677367836793680368136823683368436853686368736883689369036913692369336943695369636973698369937003701370237033704370537063707370837093710371137123713371437153716371737183719372037213722372337243725372637273728372937303731373237333734373537363737373837393740374137423743374437453746374737483749375037513752375337543755375637573758375937603761376237633764376537663767376837693770377137723773377437753776377737783779378037813782378337843785378637873788378937903791379237933794379537963797379837993800380138023803380438053806380738083809381038113812381338143815381638173818381938203821382238233824382538263827382838293830383138323833383438353836383738383839384038413842384338443845384638473848384938503851385238533854385538563857385838593860386138623863386438653866386738683869387038713872387338743875387638773878387938803881388238833884388538863887388838893890389138923893389438953896389738983899390039013902390339043905390639073908390939103911391239133914391539163917391839193920392139223923392439253926392739283929393039313932393339343935393639373938393939403941394239433944394539463947394839493950395139523953395439553956395739583959396039613962396339643965396639673968396939703971397239733974397539763977397839793980398139823983398439853986398739883989399039913992399339943995399639973998399940004001400240034004400540064007400840094010401140124013401440154016401740184019402040214022402340244025402640274028402940304031403240334034403540364037403840394040404140424043404440454046404740484049405040514052405340544055405640574058405940604061406240634064406540664067406840694070407140724073407440754076407740784079408040814082408340844085408640874088408940904091409240934094409540964097409840994100410141024103410441054106410741084109411041114112411341144115411641174118411941204121412241234124412541264127412841294130413141324133413441354136413741384139414041414142414341444145414641474148414941504151415241534154415541564157415841594160416141624163416441654166416741684169417041714172417341744175417641774178417941804181418241834184418541864187418841894190419141924193419441954196419741984199420042014202420342044205420642074208420942104211421242134214421542164217421842194220422142224223422442254226422742284229423042314232423342344235423642374238423942404241424242434244424542464247424842494250425142524253425442554256425742584259426042614262426342644265426642674268426942704271427242734274427542764277427842794280428142824283428442854286428742884289429042914292429342944295429642974298429943004301430243034304430543064307430843094310431143124313431443154316431743184319432043214322432343244325432643274328432943304331433243334334433543364337433843394340434143424343434443454346434743484349435043514352435343544355435643574358435943604361436243634364436543664367436843694370437143724373437443754376437743784379438043814382438343844385438643874388438943904391439243934394439543964397439843994400440144024403440444054406440744084409441044114412441344144415441644174418441944204421442244234424442544264427442844294430443144324433443444354436443744384439444044414442444344444445444644474448444944504451445244534454445544564457445844594460446144624463446444654466446744684469447044714472447344744475447644774478447944804481448244834484448544864487448844894490449144924493449444954496449744984499450045014502450345044505450645074508450945104511451245134514451545164517451845194520452145224523452445254526452745284529453045314532453345344535453645374538453945404541454245434544454545464547454845494550455145524553455445554556455745584559456045614562456345644565456645674568456945704571457245734574457545764577457845794580458145824583458445854586458745884589459045914592459345944595459645974598459946004601460246034604460546064607460846094610461146124613461446154616461746184619462046214622462346244625462646274628462946304631463246334634463546364637463846394640464146424643464446454646464746484649465046514652465346544655465646574658465946604661466246634664466546664667466846694670467146724673467446754676467746784679468046814682468346844685468646874688468946904691469246934694469546964697469846994700470147024703470447054706470747084709471047114712471347144715471647174718471947204721472247234724472547264727472847294730473147324733473447354736473747384739474047414742474347444745474647474748474947504751475247534754475547564757475847594760476147624763476447654766476747684769477047714772477347744775477647774778477947804781478247834784478547864787478847894790479147924793479447954796479747984799480048014802480348044805480648074808480948104811481248134814481548164817481848194820482148224823482448254826482748284829483048314832483348344835483648374838483948404841484248434844484548464847484848494850485148524853485448554856485748584859486048614862486348644865486648674868486948704871487248734874487548764877487848794880488148824883488448854886488748884889489048914892489348944895489648974898489949004901490249034904490549064907490849094910491149124913491449154916491749184919492049214922492349244925492649274928492949304931493249334934493549364937493849394940494149424943494449454946494749484949495049514952495349544955495649574958495949604961496249634964496549664967496849694970497149724973497449754976497749784979498049814982498349844985498649874988498949904991499249934994499549964997499849995000500150025003500450055006500750085009501050115012501350145015501650175018501950205021502250235024502550265027502850295030503150325033503450355036503750385039504050415042504350445045504650475048504950505051505250535054505550565057505850595060506150625063506450655066506750685069507050715072507350745075507650775078507950805081508250835084508550865087508850895090509150925093509450955096509750985099510051015102510351045105510651075108510951105111511251135114511551165117511851195120512151225123512451255126512751285129513051315132513351345135513651375138513951405141514251435144514551465147514851495150515151525153515451555156515751585159516051615162516351645165516651675168516951705171517251735174517551765177517851795180518151825183518451855186518751885189519051915192519351945195519651975198519952005201520252035204520552065207520852095210521152125213521452155216521752185219522052215222522352245225522652275228522952305231523252335234523552365237523852395240524152425243524452455246524752485249525052515252525352545255525652575258525952605261526252635264526552665267526852695270527152725273527452755276527752785279528052815282528352845285528652875288528952905291529252935294529552965297529852995300530153025303530453055306530753085309531053115312531353145315531653175318531953205321532253235324532553265327532853295330533153325333533453355336533753385339534053415342534353445345534653475348534953505351535253535354535553565357535853595360536153625363536453655366536753685369537053715372537353745375537653775378537953805381538253835384538553865387538853895390539153925393539453955396539753985399540054015402540354045405540654075408540954105411541254135414541554165417541854195420542154225423542454255426542754285429543054315432543354345435543654375438543954405441544254435444544554465447544854495450545154525453545454555456545754585459546054615462546354645465546654675468546954705471547254735474547554765477547854795480548154825483548454855486548754885489549054915492549354945495549654975498549955005501550255035504550555065507550855095510551155125513551455155516551755185519552055215522552355245525552655275528552955305531553255335534553555365537553855395540554155425543554455455546554755485549555055515552555355545555555655575558555955605561556255635564556555665567556855695570557155725573557455755576557755785579558055815582558355845585558655875588558955905591559255935594559555965597559855995600560156025603560456055606560756085609561056115612561356145615561656175618561956205621562256235624562556265627562856295630563156325633563456355636563756385639564056415642564356445645564656475648564956505651565256535654565556565657565856595660566156625663566456655666566756685669567056715672567356745675567656775678567956805681568256835684568556865687568856895690569156925693569456955696569756985699570057015702570357045705570657075708570957105711571257135714571557165717571857195720572157225723572457255726572757285729573057315732573357345735573657375738573957405741574257435744574557465747574857495750575157525753575457555756575757585759576057615762576357645765576657675768576957705771577257735774577557765777577857795780578157825783578457855786578757885789579057915792579357945795579657975798579958005801580258035804580558065807580858095810581158125813581458155816581758185819582058215822582358245825582658275828582958305831583258335834583558365837583858395840584158425843584458455846584758485849585058515852585358545855585658575858585958605861586258635864586558665867586858695870587158725873587458755876587758785879588058815882588358845885588658875888588958905891589258935894589558965897589858995900590159025903590459055906590759085909591059115912591359145915591659175918591959205921592259235924592559265927592859295930593159325933593459355936593759385939594059415942594359445945594659475948594959505951595259535954595559565957595859595960596159625963596459655966596759685969597059715972597359745975597659775978597959805981598259835984598559865987598859895990599159925993599459955996599759985999600060016002600360046005600660076008600960106011601260136014601560166017601860196020602160226023602460256026602760286029603060316032603360346035603660376038603960406041604260436044604560466047604860496050605160526053605460556056605760586059606060616062606360646065606660676068606960706071607260736074607560766077607860796080608160826083608460856086608760886089609060916092609360946095609660976098609961006101610261036104610561066107610861096110611161126113611461156116611761186119612061216122612361246125612661276128612961306131613261336134613561366137613861396140614161426143614461456146614761486149615061516152615361546155615661576158615961606161616261636164616561666167616861696170617161726173617461756176617761786179618061816182618361846185618661876188618961906191619261936194619561966197619861996200620162026203620462056206620762086209621062116212621362146215621662176218621962206221622262236224622562266227622862296230623162326233623462356236623762386239624062416242624362446245624662476248624962506251625262536254625562566257625862596260626162626263626462656266626762686269627062716272627362746275627662776278627962806281628262836284628562866287628862896290629162926293629462956296629762986299630063016302630363046305630663076308630963106311631263136314631563166317631863196320632163226323632463256326632763286329633063316332633363346335633663376338633963406341634263436344634563466347634863496350635163526353635463556356635763586359636063616362636363646365636663676368636963706371637263736374637563766377637863796380638163826383638463856386638763886389639063916392639363946395639663976398639964006401640264036404640564066407640864096410641164126413641464156416641764186419642064216422642364246425642664276428642964306431643264336434643564366437643864396440644164426443644464456446644764486449645064516452645364546455645664576458645964606461646264636464646564666467646864696470647164726473647464756476647764786479648064816482648364846485648664876488648964906491649264936494649564966497649864996500650165026503650465056506650765086509651065116512651365146515651665176518651965206521652265236524652565266527652865296530653165326533653465356536653765386539654065416542654365446545654665476548654965506551655265536554655565566557655865596560656165626563656465656566656765686569657065716572657365746575657665776578657965806581658265836584658565866587658865896590659165926593659465956596659765986599660066016602660366046605660666076608660966106611661266136614661566166617661866196620662166226623662466256626662766286629663066316632663366346635663666376638663966406641664266436644664566466647664866496650665166526653665466556656665766586659666066616662666366646665666666676668666966706671667266736674667566766677667866796680668166826683668466856686668766886689669066916692669366946695669666976698669967006701670267036704670567066707670867096710671167126713671467156716671767186719672067216722672367246725672667276728672967306731673267336734673567366737673867396740674167426743674467456746674767486749675067516752675367546755675667576758675967606761676267636764676567666767676867696770677167726773677467756776677767786779678067816782678367846785678667876788678967906791679267936794679567966797679867996800680168026803680468056806680768086809681068116812681368146815681668176818681968206821682268236824682568266827682868296830683168326833683468356836683768386839684068416842684368446845684668476848684968506851685268536854685568566857685868596860686168626863686468656866686768686869687068716872687368746875687668776878687968806881688268836884688568866887688868896890689168926893689468956896689768986899690069016902690369046905690669076908690969106911691269136914691569166917691869196920692169226923692469256926692769286929693069316932693369346935693669376938693969406941694269436944694569466947694869496950695169526953695469556956695769586959696069616962696369646965696669676968696969706971697269736974697569766977697869796980698169826983698469856986698769886989699069916992699369946995699669976998699970007001700270037004700570067007700870097010701170127013701470157016701770187019702070217022702370247025702670277028702970307031703270337034703570367037703870397040704170427043704470457046704770487049705070517052705370547055705670577058705970607061706270637064706570667067706870697070707170727073707470757076707770787079708070817082708370847085708670877088708970907091709270937094709570967097709870997100710171027103710471057106710771087109711071117112711371147115711671177118711971207121712271237124712571267127712871297130713171327133713471357136713771387139714071417142714371447145714671477148714971507151715271537154715571567157715871597160716171627163716471657166716771687169717071717172717371747175717671777178717971807181718271837184718571867187718871897190719171927193719471957196719771987199720072017202720372047205720672077208720972107211721272137214721572167217721872197220722172227223722472257226722772287229723072317232723372347235723672377238723972407241724272437244724572467247724872497250725172527253725472557256725772587259726072617262726372647265726672677268726972707271727272737274727572767277727872797280728172827283728472857286728772887289729072917292729372947295729672977298729973007301730273037304730573067307730873097310731173127313731473157316731773187319732073217322732373247325732673277328732973307331733273337334733573367337733873397340734173427343734473457346734773487349735073517352735373547355735673577358735973607361736273637364736573667367736873697370737173727373737473757376737773787379738073817382738373847385738673877388738973907391739273937394739573967397739873997400740174027403740474057406740774087409741074117412741374147415741674177418741974207421742274237424742574267427742874297430743174327433743474357436743774387439744074417442744374447445744674477448744974507451745274537454745574567457745874597460746174627463746474657466746774687469747074717472747374747475747674777478747974807481748274837484748574867487748874897490749174927493749474957496749774987499750075017502750375047505750675077508750975107511751275137514751575167517751875197520752175227523752475257526752775287529753075317532753375347535753675377538753975407541754275437544754575467547754875497550755175527553755475557556755775587559756075617562756375647565756675677568756975707571757275737574757575767577757875797580758175827583758475857586758775887589759075917592759375947595759675977598759976007601760276037604760576067607760876097610761176127613761476157616761776187619762076217622762376247625762676277628762976307631763276337634763576367637763876397640764176427643764476457646764776487649765076517652765376547655765676577658765976607661766276637664766576667667766876697670767176727673767476757676767776787679768076817682768376847685768676877688768976907691769276937694769576967697769876997700770177027703770477057706770777087709771077117712771377147715771677177718771977207721772277237724772577267727772877297730773177327733773477357736773777387739774077417742774377447745774677477748774977507751775277537754775577567757775877597760776177627763776477657766776777687769777077717772777377747775777677777778777977807781778277837784778577867787778877897790779177927793779477957796779777987799780078017802780378047805780678077808780978107811781278137814781578167817781878197820782178227823782478257826782778287829783078317832783378347835783678377838783978407841784278437844784578467847784878497850785178527853785478557856785778587859786078617862786378647865786678677868786978707871787278737874787578767877787878797880788178827883788478857886788778887889789078917892789378947895789678977898789979007901790279037904790579067907790879097910791179127913791479157916791779187919792079217922792379247925792679277928792979307931793279337934793579367937793879397940794179427943794479457946794779487949795079517952795379547955795679577958795979607961796279637964796579667967796879697970797179727973797479757976797779787979798079817982798379847985798679877988798979907991799279937994799579967997799879998000800180028003800480058006800780088009801080118012801380148015801680178018801980208021802280238024802580268027802880298030803180328033803480358036803780388039804080418042804380448045804680478048804980508051805280538054805580568057805880598060806180628063806480658066806780688069807080718072807380748075807680778078807980808081808280838084808580868087808880898090809180928093809480958096809780988099810081018102810381048105810681078108810981108111811281138114811581168117811881198120812181228123812481258126812781288129813081318132813381348135813681378138813981408141814281438144814581468147814881498150815181528153815481558156815781588159816081618162816381648165816681678168816981708171817281738174817581768177817881798180818181828183818481858186818781888189819081918192819381948195819681978198819982008201820282038204820582068207820882098210821182128213821482158216821782188219822082218222822382248225822682278228822982308231823282338234823582368237823882398240824182428243824482458246824782488249825082518252825382548255825682578258825982608261826282638264826582668267826882698270827182728273827482758276827782788279828082818282828382848285828682878288828982908291829282938294829582968297829882998300830183028303830483058306830783088309831083118312831383148315831683178318831983208321832283238324832583268327832883298330833183328333833483358336833783388339834083418342834383448345834683478348834983508351835283538354835583568357835883598360836183628363836483658366836783688369837083718372837383748375837683778378837983808381838283838384838583868387838883898390839183928393839483958396839783988399840084018402840384048405840684078408840984108411841284138414841584168417841884198420842184228423842484258426842784288429843084318432843384348435843684378438843984408441844284438444844584468447844884498450845184528453845484558456845784588459846084618462846384648465846684678468846984708471847284738474847584768477847884798480848184828483848484858486848784888489849084918492849384948495849684978498849985008501850285038504850585068507850885098510851185128513851485158516851785188519852085218522852385248525852685278528852985308531853285338534853585368537853885398540854185428543854485458546854785488549855085518552855385548555855685578558855985608561856285638564856585668567856885698570857185728573857485758576857785788579858085818582858385848585858685878588858985908591859285938594859585968597859885998600860186028603860486058606860786088609861086118612861386148615861686178618861986208621862286238624862586268627862886298630863186328633863486358636863786388639864086418642864386448645864686478648864986508651865286538654865586568657865886598660866186628663866486658666866786688669867086718672867386748675867686778678867986808681868286838684868586868687868886898690869186928693869486958696869786988699870087018702870387048705870687078708870987108711871287138714871587168717871887198720872187228723872487258726872787288729873087318732873387348735873687378738873987408741874287438744874587468747874887498750875187528753875487558756875787588759876087618762876387648765876687678768876987708771877287738774877587768777877887798780878187828783878487858786878787888789879087918792879387948795879687978798879988008801880288038804880588068807880888098810881188128813881488158816881788188819882088218822882388248825882688278828882988308831883288338834883588368837883888398840884188428843884488458846884788488849885088518852885388548855885688578858885988608861886288638864886588668867886888698870887188728873887488758876887788788879888088818882888388848885888688878888888988908891889288938894889588968897889888998900890189028903890489058906890789088909891089118912891389148915891689178918891989208921892289238924892589268927892889298930893189328933893489358936893789388939894089418942894389448945894689478948894989508951895289538954895589568957895889598960896189628963896489658966896789688969897089718972897389748975897689778978897989808981898289838984898589868987898889898990899189928993899489958996899789988999900090019002900390049005900690079008900990109011901290139014901590169017901890199020902190229023902490259026902790289029903090319032903390349035903690379038903990409041904290439044904590469047904890499050905190529053905490559056905790589059906090619062906390649065906690679068906990709071907290739074907590769077907890799080908190829083908490859086908790889089909090919092909390949095909690979098909991009101910291039104910591069107910891099110911191129113911491159116911791189119912091219122912391249125912691279128912991309131913291339134913591369137913891399140914191429143914491459146914791489149915091519152915391549155915691579158915991609161916291639164916591669167916891699170917191729173917491759176917791789179918091819182918391849185918691879188918991909191919291939194919591969197919891999200 |
- // <auto-generated />
- using System;
- using Business.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore.Infrastructure;
- using Microsoft.EntityFrameworkCore.Migrations;
- using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
- using Volo.Abp.EntityFrameworkCore;
- #nullable disable
- namespace Business.Migrations
- {
- [DbContext(typeof(BusinessMigrationDbContext))]
- [Migration("20230131062801_init")]
- partial class init
- {
- protected override void BuildTargetModel(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
- }
- }
- }
|