| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454345534563457345834593460346134623463346434653466346734683469347034713472347334743475347634773478347934803481348234833484348534863487348834893490349134923493349434953496349734983499350035013502350335043505350635073508350935103511351235133514351535163517351835193520352135223523352435253526352735283529353035313532353335343535353635373538353935403541354235433544354535463547354835493550355135523553355435553556355735583559356035613562356335643565356635673568356935703571357235733574357535763577357835793580358135823583358435853586358735883589359035913592359335943595359635973598359936003601360236033604360536063607360836093610361136123613361436153616361736183619362036213622362336243625362636273628362936303631363236333634363536363637363836393640364136423643364436453646364736483649365036513652365336543655365636573658365936603661366236633664366536663667366836693670367136723673367436753676367736783679368036813682368336843685368636873688368936903691369236933694369536963697369836993700370137023703370437053706370737083709371037113712371337143715371637173718371937203721372237233724372537263727372837293730373137323733373437353736373737383739374037413742374337443745374637473748374937503751375237533754375537563757375837593760376137623763376437653766376737683769377037713772377337743775377637773778377937803781378237833784378537863787378837893790379137923793379437953796379737983799380038013802380338043805380638073808380938103811381238133814381538163817381838193820382138223823382438253826382738283829383038313832383338343835383638373838383938403841384238433844384538463847384838493850385138523853385438553856385738583859386038613862386338643865386638673868386938703871387238733874387538763877387838793880388138823883388438853886388738883889389038913892389338943895389638973898389939003901390239033904390539063907390839093910391139123913391439153916391739183919392039213922392339243925392639273928392939303931393239333934393539363937393839393940394139423943394439453946394739483949395039513952395339543955395639573958395939603961396239633964396539663967396839693970397139723973397439753976397739783979398039813982398339843985398639873988398939903991399239933994399539963997399839994000400140024003400440054006400740084009401040114012401340144015401640174018401940204021402240234024402540264027402840294030403140324033403440354036403740384039404040414042404340444045404640474048404940504051405240534054405540564057405840594060406140624063406440654066406740684069407040714072407340744075407640774078407940804081408240834084408540864087408840894090409140924093409440954096409740984099410041014102410341044105410641074108410941104111411241134114411541164117411841194120412141224123412441254126412741284129413041314132413341344135413641374138413941404141414241434144414541464147414841494150415141524153415441554156415741584159416041614162416341644165416641674168416941704171417241734174417541764177417841794180418141824183418441854186418741884189419041914192419341944195419641974198419942004201420242034204420542064207420842094210421142124213421442154216421742184219422042214222422342244225422642274228422942304231423242334234423542364237423842394240424142424243424442454246424742484249425042514252425342544255425642574258425942604261426242634264426542664267426842694270427142724273427442754276427742784279428042814282428342844285428642874288428942904291429242934294429542964297429842994300430143024303430443054306430743084309431043114312431343144315431643174318431943204321432243234324432543264327432843294330433143324333433443354336433743384339434043414342434343444345434643474348434943504351435243534354435543564357435843594360436143624363436443654366436743684369437043714372437343744375437643774378437943804381438243834384438543864387438843894390439143924393439443954396439743984399440044014402440344044405440644074408440944104411441244134414441544164417441844194420442144224423442444254426442744284429443044314432443344344435443644374438443944404441444244434444444544464447444844494450445144524453445444554456445744584459446044614462446344644465446644674468446944704471447244734474447544764477447844794480448144824483448444854486448744884489449044914492449344944495449644974498449945004501450245034504450545064507450845094510451145124513451445154516451745184519452045214522452345244525452645274528452945304531453245334534453545364537453845394540454145424543454445454546454745484549455045514552455345544555455645574558455945604561456245634564456545664567456845694570457145724573457445754576457745784579458045814582458345844585458645874588458945904591459245934594459545964597459845994600460146024603460446054606460746084609461046114612461346144615461646174618461946204621462246234624462546264627462846294630463146324633463446354636463746384639464046414642464346444645464646474648464946504651465246534654465546564657465846594660466146624663466446654666466746684669467046714672467346744675467646774678467946804681468246834684468546864687468846894690469146924693469446954696469746984699470047014702470347044705470647074708470947104711471247134714471547164717471847194720472147224723472447254726472747284729473047314732473347344735473647374738473947404741474247434744474547464747474847494750475147524753475447554756475747584759476047614762476347644765476647674768476947704771477247734774477547764777477847794780478147824783478447854786478747884789479047914792479347944795479647974798479948004801480248034804480548064807480848094810481148124813481448154816481748184819482048214822482348244825482648274828482948304831483248334834483548364837483848394840484148424843484448454846484748484849485048514852485348544855485648574858485948604861486248634864486548664867486848694870487148724873487448754876487748784879488048814882488348844885488648874888488948904891489248934894489548964897489848994900490149024903490449054906490749084909491049114912491349144915491649174918491949204921492249234924492549264927492849294930493149324933493449354936493749384939494049414942494349444945494649474948494949504951495249534954495549564957495849594960496149624963496449654966496749684969497049714972497349744975497649774978497949804981498249834984498549864987498849894990499149924993499449954996499749984999500050015002500350045005500650075008500950105011501250135014501550165017501850195020502150225023502450255026502750285029503050315032503350345035503650375038503950405041504250435044504550465047504850495050505150525053505450555056505750585059506050615062506350645065506650675068506950705071507250735074507550765077507850795080508150825083508450855086508750885089509050915092509350945095509650975098509951005101510251035104510551065107510851095110511151125113511451155116511751185119512051215122512351245125512651275128512951305131513251335134513551365137513851395140514151425143514451455146514751485149515051515152515351545155515651575158515951605161516251635164516551665167516851695170517151725173517451755176517751785179518051815182518351845185518651875188518951905191519251935194519551965197519851995200520152025203520452055206520752085209521052115212521352145215521652175218521952205221522252235224522552265227522852295230523152325233523452355236523752385239524052415242524352445245524652475248524952505251525252535254525552565257525852595260526152625263526452655266526752685269527052715272527352745275527652775278527952805281528252835284528552865287528852895290529152925293529452955296529752985299530053015302530353045305530653075308530953105311531253135314531553165317531853195320532153225323532453255326532753285329533053315332533353345335533653375338533953405341534253435344534553465347534853495350535153525353535453555356535753585359536053615362536353645365536653675368536953705371537253735374537553765377537853795380538153825383538453855386538753885389539053915392539353945395539653975398539954005401540254035404540554065407540854095410541154125413541454155416541754185419542054215422542354245425542654275428542954305431543254335434543554365437543854395440544154425443544454455446544754485449545054515452545354545455545654575458545954605461546254635464546554665467546854695470547154725473547454755476547754785479548054815482548354845485548654875488548954905491549254935494549554965497549854995500550155025503550455055506550755085509551055115512551355145515551655175518551955205521552255235524552555265527552855295530553155325533553455355536553755385539554055415542554355445545554655475548554955505551555255535554555555565557555855595560556155625563556455655566556755685569557055715572557355745575557655775578557955805581558255835584558555865587558855895590559155925593559455955596559755985599560056015602560356045605560656075608560956105611561256135614561556165617561856195620562156225623562456255626562756285629563056315632563356345635563656375638563956405641564256435644564556465647564856495650565156525653565456555656565756585659566056615662566356645665566656675668566956705671567256735674567556765677567856795680568156825683568456855686568756885689569056915692569356945695569656975698569957005701570257035704570557065707570857095710571157125713571457155716571757185719572057215722572357245725572657275728572957305731573257335734573557365737573857395740574157425743574457455746574757485749575057515752575357545755575657575758575957605761576257635764576557665767576857695770577157725773577457755776577757785779578057815782578357845785578657875788578957905791579257935794579557965797579857995800580158025803580458055806580758085809581058115812581358145815581658175818581958205821582258235824582558265827582858295830583158325833583458355836583758385839584058415842584358445845584658475848584958505851585258535854585558565857585858595860586158625863586458655866586758685869587058715872587358745875587658775878587958805881588258835884588558865887588858895890589158925893589458955896589758985899590059015902590359045905590659075908590959105911591259135914591559165917591859195920592159225923592459255926592759285929593059315932593359345935593659375938593959405941594259435944594559465947594859495950595159525953595459555956595759585959596059615962596359645965596659675968596959705971597259735974597559765977597859795980598159825983598459855986598759885989599059915992599359945995599659975998599960006001600260036004600560066007600860096010601160126013601460156016601760186019602060216022602360246025602660276028602960306031603260336034603560366037603860396040604160426043604460456046604760486049605060516052605360546055605660576058605960606061606260636064606560666067606860696070607160726073607460756076607760786079608060816082608360846085608660876088608960906091609260936094609560966097609860996100610161026103610461056106610761086109611061116112611361146115611661176118611961206121612261236124612561266127612861296130613161326133613461356136613761386139614061416142614361446145614661476148614961506151615261536154615561566157615861596160616161626163616461656166616761686169617061716172617361746175617661776178617961806181618261836184618561866187618861896190619161926193619461956196619761986199620062016202620362046205620662076208620962106211621262136214621562166217621862196220622162226223622462256226622762286229623062316232623362346235623662376238623962406241624262436244624562466247624862496250625162526253625462556256625762586259626062616262626362646265626662676268626962706271627262736274627562766277627862796280628162826283628462856286628762886289629062916292629362946295629662976298629963006301630263036304630563066307630863096310631163126313631463156316631763186319632063216322632363246325632663276328632963306331633263336334633563366337633863396340634163426343634463456346634763486349635063516352635363546355635663576358635963606361636263636364636563666367636863696370637163726373637463756376637763786379638063816382638363846385638663876388638963906391639263936394639563966397639863996400640164026403640464056406640764086409641064116412641364146415641664176418641964206421642264236424642564266427642864296430643164326433643464356436643764386439644064416442644364446445644664476448644964506451645264536454645564566457645864596460646164626463646464656466646764686469647064716472647364746475647664776478647964806481648264836484648564866487648864896490649164926493649464956496649764986499650065016502650365046505650665076508650965106511651265136514651565166517651865196520652165226523652465256526652765286529653065316532653365346535653665376538653965406541654265436544654565466547654865496550655165526553655465556556655765586559656065616562656365646565656665676568656965706571657265736574657565766577657865796580658165826583658465856586658765886589659065916592659365946595659665976598659966006601660266036604660566066607660866096610661166126613661466156616661766186619662066216622662366246625662666276628662966306631663266336634663566366637663866396640664166426643664466456646664766486649665066516652665366546655665666576658665966606661666266636664666566666667666866696670667166726673667466756676667766786679668066816682668366846685668666876688668966906691669266936694669566966697669866996700670167026703670467056706670767086709671067116712671367146715671667176718671967206721672267236724672567266727672867296730673167326733673467356736673767386739674067416742674367446745674667476748674967506751675267536754675567566757675867596760676167626763676467656766676767686769677067716772677367746775677667776778677967806781678267836784678567866787678867896790679167926793679467956796679767986799680068016802680368046805680668076808680968106811681268136814681568166817681868196820682168226823682468256826682768286829683068316832683368346835683668376838683968406841684268436844684568466847684868496850685168526853685468556856685768586859686068616862686368646865686668676868686968706871687268736874687568766877687868796880688168826883688468856886688768886889689068916892689368946895689668976898689969006901690269036904690569066907690869096910691169126913691469156916691769186919692069216922692369246925692669276928692969306931693269336934693569366937693869396940694169426943694469456946694769486949695069516952695369546955695669576958695969606961696269636964696569666967696869696970697169726973697469756976697769786979698069816982698369846985698669876988698969906991699269936994699569966997699869997000700170027003700470057006700770087009701070117012701370147015701670177018701970207021702270237024702570267027702870297030703170327033703470357036703770387039704070417042704370447045704670477048704970507051705270537054705570567057705870597060706170627063706470657066706770687069707070717072707370747075707670777078707970807081708270837084708570867087708870897090709170927093709470957096709770987099710071017102710371047105710671077108710971107111711271137114711571167117711871197120712171227123712471257126712771287129713071317132713371347135713671377138713971407141714271437144714571467147714871497150715171527153715471557156715771587159716071617162716371647165716671677168716971707171717271737174717571767177717871797180718171827183718471857186718771887189719071917192719371947195719671977198719972007201720272037204720572067207720872097210721172127213721472157216721772187219722072217222722372247225722672277228722972307231723272337234723572367237723872397240724172427243724472457246724772487249725072517252725372547255725672577258725972607261726272637264726572667267726872697270727172727273727472757276727772787279728072817282728372847285728672877288728972907291729272937294729572967297729872997300730173027303730473057306730773087309731073117312731373147315731673177318731973207321732273237324732573267327732873297330733173327333733473357336733773387339734073417342734373447345734673477348734973507351735273537354735573567357735873597360736173627363736473657366736773687369737073717372737373747375737673777378737973807381738273837384738573867387738873897390739173927393739473957396739773987399740074017402740374047405740674077408740974107411741274137414741574167417741874197420742174227423742474257426742774287429743074317432743374347435743674377438743974407441744274437444744574467447744874497450745174527453745474557456745774587459746074617462746374647465746674677468746974707471747274737474747574767477747874797480748174827483748474857486748774887489749074917492749374947495749674977498749975007501750275037504750575067507750875097510751175127513751475157516751775187519752075217522752375247525752675277528752975307531753275337534753575367537753875397540754175427543754475457546754775487549755075517552755375547555755675577558755975607561756275637564756575667567756875697570757175727573757475757576757775787579758075817582758375847585758675877588758975907591759275937594759575967597759875997600760176027603760476057606760776087609761076117612761376147615761676177618761976207621762276237624762576267627762876297630763176327633763476357636763776387639764076417642764376447645764676477648764976507651765276537654765576567657765876597660766176627663766476657666766776687669767076717672767376747675767676777678767976807681768276837684768576867687768876897690769176927693769476957696769776987699770077017702770377047705770677077708770977107711771277137714771577167717771877197720772177227723772477257726772777287729773077317732773377347735773677377738773977407741774277437744774577467747774877497750775177527753775477557756775777587759776077617762776377647765776677677768776977707771777277737774777577767777777877797780778177827783778477857786778777887789779077917792779377947795779677977798779978007801780278037804780578067807780878097810781178127813781478157816781778187819782078217822782378247825782678277828782978307831783278337834783578367837783878397840784178427843784478457846784778487849785078517852785378547855785678577858785978607861786278637864786578667867786878697870787178727873787478757876787778787879788078817882788378847885788678877888788978907891789278937894789578967897789878997900790179027903790479057906790779087909791079117912791379147915791679177918791979207921792279237924792579267927792879297930793179327933793479357936793779387939794079417942794379447945794679477948794979507951795279537954795579567957795879597960796179627963796479657966796779687969797079717972797379747975797679777978797979807981798279837984798579867987798879897990799179927993799479957996799779987999800080018002800380048005800680078008800980108011801280138014801580168017801880198020802180228023802480258026802780288029803080318032803380348035803680378038803980408041804280438044804580468047804880498050805180528053805480558056805780588059806080618062806380648065806680678068806980708071807280738074807580768077807880798080808180828083808480858086808780888089809080918092809380948095809680978098809981008101810281038104810581068107810881098110811181128113811481158116811781188119812081218122812381248125812681278128812981308131813281338134813581368137813881398140814181428143814481458146814781488149815081518152815381548155815681578158815981608161816281638164816581668167816881698170817181728173817481758176817781788179818081818182818381848185818681878188818981908191819281938194819581968197819881998200820182028203820482058206820782088209821082118212821382148215821682178218821982208221822282238224822582268227822882298230823182328233823482358236823782388239824082418242824382448245824682478248824982508251825282538254825582568257825882598260826182628263826482658266826782688269827082718272827382748275827682778278827982808281828282838284828582868287828882898290829182928293829482958296829782988299830083018302830383048305830683078308830983108311831283138314831583168317831883198320832183228323832483258326832783288329833083318332833383348335833683378338833983408341834283438344834583468347834883498350835183528353835483558356835783588359836083618362836383648365836683678368836983708371837283738374837583768377837883798380838183828383838483858386838783888389839083918392839383948395839683978398839984008401840284038404840584068407840884098410841184128413841484158416841784188419842084218422842384248425842684278428842984308431843284338434843584368437843884398440844184428443844484458446844784488449845084518452845384548455845684578458845984608461846284638464846584668467846884698470847184728473847484758476847784788479848084818482848384848485848684878488848984908491849284938494849584968497849884998500850185028503850485058506850785088509851085118512851385148515851685178518851985208521852285238524852585268527852885298530853185328533853485358536853785388539854085418542854385448545854685478548854985508551855285538554855585568557855885598560856185628563856485658566856785688569857085718572857385748575857685778578857985808581858285838584858585868587858885898590859185928593859485958596859785988599860086018602860386048605860686078608860986108611861286138614861586168617861886198620862186228623862486258626862786288629863086318632863386348635863686378638863986408641864286438644864586468647864886498650865186528653865486558656865786588659866086618662866386648665866686678668866986708671867286738674867586768677867886798680868186828683868486858686868786888689869086918692869386948695869686978698869987008701870287038704870587068707870887098710871187128713871487158716871787188719872087218722872387248725872687278728872987308731873287338734873587368737873887398740874187428743874487458746874787488749875087518752875387548755875687578758875987608761876287638764876587668767876887698770877187728773877487758776877787788779878087818782878387848785878687878788878987908791879287938794879587968797879887998800880188028803880488058806880788088809881088118812881388148815881688178818881988208821882288238824882588268827882888298830883188328833883488358836883788388839884088418842884388448845884688478848884988508851885288538854885588568857885888598860886188628863886488658866886788688869887088718872887388748875887688778878887988808881888288838884888588868887888888898890889188928893889488958896889788988899890089018902890389048905890689078908890989108911891289138914891589168917891889198920892189228923892489258926892789288929893089318932893389348935893689378938893989408941894289438944894589468947894889498950895189528953895489558956895789588959896089618962896389648965896689678968896989708971897289738974897589768977897889798980898189828983898489858986898789888989899089918992899389948995899689978998899990009001900290039004900590069007900890099010901190129013901490159016901790189019902090219022902390249025902690279028902990309031903290339034903590369037903890399040904190429043904490459046904790489049905090519052905390549055905690579058905990609061906290639064906590669067906890699070907190729073907490759076907790789079908090819082908390849085908690879088908990909091909290939094909590969097909890999100910191029103910491059106910791089109911091119112911391149115911691179118911991209121912291239124912591269127912891299130913191329133913491359136913791389139914091419142914391449145914691479148914991509151915291539154915591569157915891599160916191629163916491659166916791689169917091719172917391749175917691779178917991809181918291839184918591869187918891899190919191929193919491959196919791989199920092019202920392049205920692079208920992109211921292139214921592169217921892199220922192229223922492259226922792289229923092319232923392349235923692379238923992409241924292439244924592469247924892499250925192529253925492559256925792589259926092619262926392649265926692679268926992709271927292739274927592769277927892799280928192829283928492859286928792889289929092919292929392949295929692979298929993009301930293039304930593069307930893099310931193129313931493159316931793189319932093219322932393249325932693279328932993309331933293339334933593369337933893399340934193429343934493459346934793489349935093519352935393549355935693579358935993609361936293639364936593669367936893699370937193729373937493759376937793789379938093819382938393849385938693879388938993909391939293939394939593969397939893999400940194029403940494059406940794089409941094119412941394149415941694179418941994209421942294239424942594269427942894299430943194329433943494359436943794389439944094419442944394449445944694479448944994509451945294539454945594569457945894599460946194629463946494659466946794689469947094719472947394749475947694779478947994809481948294839484948594869487948894899490949194929493949494959496949794989499950095019502950395049505950695079508950995109511951295139514951595169517951895199520952195229523 |
- // <auto-generated />
- using System;
- using Business.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore.Infrastructure;
- using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
- using Volo.Abp.EntityFrameworkCore;
- #nullable disable
- namespace Business.Migrations
- {
- [DbContext(typeof(BusinessMigrationDbContext))]
- partial class BusinessMigrationDbContextModelSnapshot : ModelSnapshot
- {
- protected override void BuildModel(ModelBuilder modelBuilder)
- {
- #pragma warning disable 612, 618
- modelBuilder
- .HasAnnotation("_Abp_DatabaseProvider", EfCoreDatabaseProvider.MySql)
- .HasAnnotation("ProductVersion", "6.0.5")
- .HasAnnotation("Relational:MaxIdentifierLength", 64);
- modelBuilder.Entity("Business.Models.Book", 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(6)")
- .HasColumnName("CreationTime");
- b.Property<Guid?>("CreatorId")
- .HasColumnType("char(36)")
- .HasColumnName("CreatorId");
- b.Property<string>("Description")
- .HasColumnType("longtext");
- b.Property<string>("ExtraProperties")
- .HasColumnType("longtext")
- .HasColumnName("ExtraProperties");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted");
- b.Property<DateTime?>("LastModificationTime")
- .HasColumnType("datetime(6)")
- .HasColumnName("LastModificationTime");
- b.Property<Guid?>("LastModifierId")
- .HasColumnType("char(36)")
- .HasColumnName("LastModifierId");
- b.Property<string>("Name")
- .IsRequired()
- .HasColumnType("longtext");
- b.Property<int>("Price")
- .HasColumnType("int");
- b.Property<Guid?>("TenantId")
- .HasColumnType("char(36)")
- .HasColumnName("TenantId");
- b.HasKey("Id");
- b.ToTable("Book", (string)null);
- });
- modelBuilder.Entity("Business.Models.PrintTemplate", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("char(36)");
- b.Property<string>("ConcurrencyStamp")
- .IsConcurrencyToken()
- .HasMaxLength(40)
- .HasColumnType("varchar(40)")
- .HasColumnName("ConcurrencyStamp");
- b.Property<string>("Content")
- .HasColumnType("longtext");
- b.Property<DateTime>("CreationTime")
- .HasColumnType("datetime(6)")
- .HasColumnName("CreationTime");
- b.Property<Guid?>("CreatorId")
- .HasColumnType("char(36)")
- .HasColumnName("CreatorId");
- b.Property<string>("ExtraProperties")
- .HasColumnType("longtext")
- .HasColumnName("ExtraProperties");
- b.Property<bool>("IsDefault")
- .HasColumnType("tinyint(1)");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted");
- b.Property<DateTime?>("LastModificationTime")
- .HasColumnType("datetime(6)")
- .HasColumnName("LastModificationTime");
- b.Property<Guid?>("LastModifierId")
- .HasColumnType("char(36)")
- .HasColumnName("LastModifierId");
- b.Property<string>("Name")
- .IsRequired()
- .HasColumnType("longtext");
- b.Property<int?>("Orientation")
- .HasColumnType("int");
- b.Property<double?>("PaperHeight")
- .HasColumnType("double");
- b.Property<int?>("PaperKind")
- .HasColumnType("int");
- b.Property<double?>("PaperWidth")
- .HasColumnType("double");
- b.Property<string>("Remark")
- .HasColumnType("longtext");
- b.Property<int>("Sort")
- .HasColumnType("int");
- b.Property<int>("Status")
- .HasColumnType("int");
- b.Property<int>("TempType")
- .HasColumnType("int");
- b.Property<Guid?>("TenantId")
- .HasColumnType("char(36)")
- .HasColumnName("TenantId");
- b.HasKey("Id");
- b.ToTable("base_print_template", (string)null);
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_bom", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<DateTime?>("begin_day")
- .HasColumnType("datetime(6)")
- .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(6)")
- .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(6)")
- .HasComment("创建时间");
- b.Property<DateTime?>("end_day")
- .HasColumnType("datetime(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<DateTime?>("use_date")
- .HasColumnType("datetime(6)")
- .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("Id");
- b.ToTable("ic_bom", (string)null);
- b.HasComment("物料BOM");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_bom_child", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("创建时间");
- b.Property<DateTime?>("end_day")
- .HasColumnType("datetime(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<int>("use_status")
- .HasColumnType("int")
- .HasComment("使用状态");
- b.HasKey("Id");
- b.ToTable("ic_bom_child", (string)null);
- b.HasComment("物料BOM明细");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_factory_details", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- 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(6)")
- .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(6)")
- .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?>("order_leadtime")
- .IsRequired()
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .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?>("production_leadtime")
- .IsRequired()
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .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<decimal?>("stock_leadtime")
- .IsRequired()
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("仓库中提前期_天");
- b.Property<int>("stock_time")
- .HasColumnType("int")
- .HasComment("是否需要库龄管理");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<decimal?>("transportation_leadtime")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.Property<string>("warehouse_note")
- .HasMaxLength(1000)
- .HasColumnType("varchar(1000)")
- .HasComment("库存备注");
- b.HasKey("Id");
- b.ToTable("ic_factory_details", (string)null);
- b.HasComment("工厂物料明细表");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_item", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .HasComment("创建时间");
- b.Property<string>("cubic_measure")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("长度单位");
- b.Property<int>("enable_warning")
- .HasColumnType("int")
- .HasComment("启用预警");
- b.Property<int>("erp_cls")
- .HasColumnType("int")
- .HasComment("物料属性");
- b.Property<string>("erp_cls_name")
- .HasColumnType("longtext")
- .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<string>("unit")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("单位");
- 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(6)")
- .HasComment("修改时间");
- b.Property<decimal?>("width")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("宽度");
- b.HasKey("Id");
- b.ToTable("ic_item", (string)null);
- b.HasComment("物料详情");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_item_ie", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("ic_item_ie", (string)null);
- b.HasComment("物料ie信息表");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_item_inventory", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("ic_item_inventory", (string)null);
- b.HasComment("物料库存信息表");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_item_pur", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- 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(6)")
- .HasComment("创建时间");
- b.Property<long?>("currency_type")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("ic_item_pur", (string)null);
- b.HasComment("物料采购报价单");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_item_stock", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("ic_item_stock", (string)null);
- b.HasComment("物料库存表");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_metering_unit", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("ic_metering_unit", (string)null);
- b.HasComment("物料计量表");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_plan", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<int>("aux_prop_plan")
- .HasColumnType("int")
- .HasComment("辅助属性参与计划运算");
- b.Property<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("ic_plan", (string)null);
- b.HasComment("物料采购计划表");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_substitute", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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_mode")
- .HasColumnType("int")
- .HasComment("替代方式");
- b.Property<int?>("substitute_strategy")
- .HasColumnType("int")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("ic_substitute", (string)null);
- b.HasComment("替代群组");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_substitute_all", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<string>("use_model")
- .HasMaxLength(5000)
- .HasColumnType("varchar(5000)")
- .HasComment("使用机型");
- b.HasKey("Id");
- b.ToTable("ic_substitute_all", (string)null);
- b.HasComment("物料替代多群组");
- });
- modelBuilder.Entity("Bussiness.Model.MES.IC.ic_substitute_all_dtl", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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<int?>("num")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("ic_substitute_all_dtl", (string)null);
- b.HasComment("物料替代多群组明细");
- });
- modelBuilder.Entity("Bussiness.Model.Production.mes_moentry", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- 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(6)")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<string>("fbill_no")
- .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")
- .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")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_moentry", (string)null);
- b.HasComment("生成工单子表");
- });
- modelBuilder.Entity("Bussiness.Model.Production.mes_mooccupy", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- 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(6)")
- .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")
- .IsRequired()
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("物料名称");
- b.Property<string>("fitem_number")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("物料编码");
- b.Property<string>("fmodel")
- .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(6)")
- .HasComment("变更时间");
- b.Property<DateTime?>("moo_etime")
- .HasColumnType("datetime(6)")
- .HasComment("结束时间");
- b.Property<long?>("moo_id_billid")
- .HasColumnType("bigint")
- .HasComment("订单id");
- b.Property<string>("moo_id_type")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("类型--原始,分配");
- b.Property<string>("moo_mo")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_mooccupy", (string)null);
- b.HasComment("在制工单占用记录表");
- });
- modelBuilder.Entity("Bussiness.Model.Production.mes_morder", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- b.Property<string>("bom_number")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("bom编码");
- b.Property<DateTime?>("convey_date")
- .HasColumnType("datetime(6)")
- .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(6)")
- .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(6)")
- .HasComment("基于物料结束时间");
- b.Property<DateTime?>("mat_start_date")
- .HasColumnType("datetime(6)")
- .HasComment("基于物料开始时间");
- b.Property<DateTime?>("moentry_etime")
- .HasColumnType("datetime(6)")
- .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(6)")
- .HasComment("生产工单开始日期");
- b.Property<DateTime?>("moentry_sys_etime")
- .HasColumnType("datetime(6)")
- .HasComment("系统建议完工时间");
- b.Property<DateTime?>("moentry_sys_stime")
- .HasColumnType("datetime(6)")
- .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(6)")
- .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<decimal?>("morder_production_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .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?>("need_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .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(6)")
- .HasComment("最近暂停时间");
- b.Property<decimal?>("picking_qty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("已领料数量");
- b.Property<DateTime?>("planner_end_date")
- .HasColumnType("datetime(6)")
- .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(6)")
- .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(6)")
- .HasComment("实际结束时间");
- b.Property<DateTime?>("reality_start_time")
- .HasColumnType("datetime(6)")
- .HasComment("实际开始时间");
- b.Property<long?>("relation_moid")
- .HasColumnType("bigint")
- .HasComment("关联工单id");
- b.Property<string>("relation_mono")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("关联编号");
- b.Property<decimal?>("remaining_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("剩余可用数量");
- b.Property<DateTime?>("restart_time")
- .HasColumnType("datetime(6)")
- .HasComment("最近重启时间");
- b.Property<DateTime?>("start_time")
- .HasColumnType("datetime(6)")
- .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(6)")
- .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("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");
- 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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- 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(6)")
- .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("所需物料是否充足 1-充足 0-缺料");
- 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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<decimal?>("work_number")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("报工数量");
- b.HasKey("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");
- 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(6)")
- .HasComment("创建时间");
- b.Property<DateTime?>("end_time")
- .HasColumnType("datetime(6)")
- .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(6)")
- .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(6)")
- .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>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("变更时间");
- b.Property<DateTime?>("soccupy_etime")
- .HasColumnType("datetime(6)")
- .HasComment("结束时间");
- b.Property<string>("soccupy_state")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("占用状态");
- b.Property<DateTime?>("soccupy_stime")
- .HasColumnType("datetime(6)")
- .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(6)")
- .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("Id");
- b.ToTable("mes_stockoccupy", (string)null);
- b.HasComment("成品库存占用表");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_loss_time_record", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .HasComment("创建时间");
- b.Property<string>("desc")
- .HasMaxLength(500)
- .HasColumnType("varchar(500)")
- .HasComment("问题描述");
- b.Property<DateTime?>("end_time")
- .HasColumnType("datetime(6)")
- .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")
- .HasColumnType("longtext")
- .HasComment("记录人工号");
- b.Property<DateTime>("record_time")
- .HasColumnType("datetime(6)")
- .HasComment("记录时间");
- b.Property<DateTime?>("start_time")
- .HasColumnType("datetime(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_loss_time_record", (string)null);
- b.HasComment("损失时间记录表");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_meaction", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_meaction", (string)null);
- b.HasComment("生产动作表");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_mebycard", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_mebycard", (string)null);
- b.HasComment("产线刷卡记录");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_merecheck", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_merecheck", (string)null);
- b.HasComment("生产报检记录");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_mereport", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_mereport", (string)null);
- b.HasComment("生产报工记录");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_prd_sendmat", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<string>("prdsm_by")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("制单人");
- b.Property<DateTime>("prdsm_date")
- .HasColumnType("datetime(6)")
- .HasComment("单据日期");
- b.Property<DateTime?>("prdsm_ddate")
- .HasColumnType("datetime(6)")
- .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.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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_prd_sendmat", (string)null);
- b.HasComment("发料单");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_prd_sendmat_list", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_prd_sendmat_list", (string)null);
- b.HasComment("发料单详情");
- });
- modelBuilder.Entity("Bussiness.Model.ProductionProcess.mes_prdlog", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("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");
- 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(6)")
- .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(6)")
- .HasComment("开始时间");
- b.Property<DateTime?>("stop")
- .HasColumnType("datetime(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<DateTime?>("work_date")
- .HasColumnType("datetime(6)")
- .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");
- 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(6)")
- .HasComment("创建时间");
- b.Property<long>("eby")
- .HasColumnType("bigint")
- .HasComment("入库人id");
- b.Property<string>("ebyname")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("入库人姓名");
- b.Property<DateTime>("edate")
- .HasColumnType("datetime(6)")
- .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(6)")
- .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");
- 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(6)")
- .HasComment("创建时间");
- b.Property<long?>("eby")
- .HasColumnType("bigint")
- .HasComment("出库人id");
- b.Property<string>("eby_name")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("出库人姓名");
- b.Property<DateTime>("edate")
- .HasColumnType("datetime(6)")
- .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(80)
- .HasColumnType("varchar(80)")
- .HasComment("物料编码");
- b.Property<string>("fmodel")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("规格型号");
- b.Property<string>("order_no")
- .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")
- .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(6)")
- .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");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<string>("card_no")
- .IsRequired()
- .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(6)")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<DateTime?>("off_line_time")
- .HasColumnType("datetime(6)")
- .HasComment("下线时间");
- b.Property<string>("order_no")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("工单编号");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- 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(6)")
- .HasComment("刷卡日期");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<int>("type")
- .HasColumnType("int")
- .HasComment("刷卡类型");
- b.Property<DateTime?>("up_line_time")
- .HasColumnType("datetime(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_swipe_card", (string)null);
- b.HasComment("mes打卡记录表");
- });
- modelBuilder.Entity("Bussiness.Model.Sale.crm_seorder", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<DateTime?>("audit_date")
- .HasColumnType("datetime(6)")
- .HasComment("审核日期");
- b.Property<string>("auditor")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("审核人");
- b.Property<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- 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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<int?>("urgent")
- .HasColumnType("int")
- .HasComment("加急级别");
- b.HasKey("Id");
- b.ToTable("crm_seorder", (string)null);
- b.HasComment("销售订单");
- });
- modelBuilder.Entity("Bussiness.Model.Sale.crm_seorderentry", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<DateTime?>("adjust_date")
- .HasColumnType("datetime(6)")
- .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<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- 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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .HasComment("系统建议交期(产能)");
- b.Property<DateTime?>("sys_material_date")
- .HasColumnType("datetime(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<int?>("urgent")
- .HasColumnType("int")
- .HasComment("加急级别");
- b.HasKey("Id");
- b.ToTable("crm_seorderentry", (string)null);
- b.HasComment("销售订单明细表");
- });
- modelBuilder.Entity("Bussiness.Model.Sale.crm_seorderprog", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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")
- .IsRequired()
- .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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("crm_seorderprog", (string)null);
- b.HasComment("销售订单进度表");
- });
- modelBuilder.Entity("Bussiness.Model.Sale.crm_seorderreview", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .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(6)")
- .HasComment("提交时间");
- b.Property<DateTime?>("review_time")
- .HasColumnType("datetime(6)")
- .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")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("crm_seorderreview", (string)null);
- b.HasComment("销售订单评审表");
- });
- modelBuilder.Entity("Bussiness.Model.Sale.wms_prdprogress", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("wms_prdprogress", (string)null);
- b.HasComment("进度字典");
- });
- modelBuilder.Entity("Bussiness.Model.Sale.wms_shipnotice", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("发运时间");
- b.Property<string>("shipnotice_no")
- .IsRequired()
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("发运通知单号");
- b.Property<long?>("shipplan_id")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("wms_shipnotice", (string)null);
- b.HasComment("发货通知单");
- });
- modelBuilder.Entity("Bussiness.Model.Sale.wms_shipnoticelist", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("wms_shipnoticelist", (string)null);
- b.HasComment("发货通知单明细表");
- });
- modelBuilder.Entity("Bussiness.Model.Sale.wms_shipplan", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("wms_shipplan", (string)null);
- b.HasComment("发货计划表");
- });
- modelBuilder.Entity("Bussiness.Model.SIM.sim_base", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("sim_base", (string)null);
- b.HasComment("sim基本表");
- });
- modelBuilder.Entity("Bussiness.Model.SIM.sim_issue_type", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("sim_issue_type", (string)null);
- b.HasComment("sim事项类别表");
- });
- modelBuilder.Entity("Bussiness.Model.SIM.sim_plant", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("sim_plant", (string)null);
- b.HasComment("sim事项表");
- });
- modelBuilder.Entity("Bussiness.Model.SIM.sim_user_relation", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .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.SRM.srm_po_list", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- 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(6)")
- .HasComment("创建时间");
- b.Property<long?>("currencytype")
- .IsRequired()
- .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")
- .IsRequired()
- .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")
- .IsRequired()
- .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")
- .IsRequired()
- .HasColumnType("bigint")
- .HasComment("pr申请单id");
- b.Property<long?>("pr_purchase_id")
- .IsRequired()
- .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(6)")
- .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")
- .IsRequired()
- .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")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("srm_po_list", (string)null);
- b.HasComment("采购订单明细详情");
- });
- modelBuilder.Entity("Bussiness.Model.SRM.srm_po_main", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- 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(6)")
- .HasComment("创建时间");
- b.Property<long?>("currency")
- .IsRequired()
- .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")
- .IsRequired()
- .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")
- .IsRequired()
- .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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("srm_po_main", (string)null);
- b.HasComment("采购订单");
- });
- modelBuilder.Entity("Bussiness.Model.SRM.srm_po_occupy", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- b.Property<long?>("bill_no")
- .IsRequired()
- .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(6)")
- .HasComment("创建时间");
- b.Property<DateTime?>("ctime")
- .HasColumnType("datetime(6)")
- .HasComment("变更时间");
- b.Property<long?>("eid")
- .IsRequired()
- .HasColumnType("bigint")
- .HasComment("客户订单行id");
- b.Property<int>("entry_id")
- .HasColumnType("int")
- .HasComment("行号");
- b.Property<DateTime?>("etime")
- .HasColumnType("datetime(6)")
- .HasComment("结束时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long?>("polist_id")
- .IsRequired()
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("srm_po_occupy", (string)null);
- b.HasComment("采购订单占用详情");
- });
- modelBuilder.Entity("Bussiness.Model.SRM.srm_pr_main", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<bool>("IsDeleted")
- .ValueGeneratedOnAdd()
- .HasColumnType("tinyint(1)")
- .HasDefaultValue(false)
- .HasColumnName("IsDeleted")
- .HasComment("删除标识");
- b.Property<long?>("bang_id")
- .HasColumnType("bigint")
- .HasComment("计算id");
- 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(6)")
- .HasComment("创建时间");
- b.Property<long?>("currencytype")
- .IsRequired()
- .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")
- .IsRequired()
- .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(6)")
- .HasComment("采购员建议到货日期");
- b.Property<string>("pr_mono")
- .HasMaxLength(80)
- .HasColumnType("varchar(80)")
- .HasComment("关联工单号");
- b.Property<DateTime?>("pr_oarrive_date")
- .HasColumnType("datetime(6)")
- .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(6)")
- .HasComment("计划到达日期");
- b.Property<decimal?>("pr_price")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("采购净价(不含税)");
- b.Property<DateTime?>("pr_psend_date")
- .HasColumnType("datetime(6)")
- .HasComment("计划下单日期");
- b.Property<DateTime?>("pr_pur_affirm_date")
- .HasColumnType("datetime(6)")
- .HasComment("采购确认到货日期");
- b.Property<long?>("pr_purchaseid")
- .IsRequired()
- .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(6)")
- .HasComment("需求到货日期");
- b.Property<decimal?>("pr_rate")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("税率");
- b.Property<DateTime?>("pr_rparrive_date")
- .HasColumnType("datetime(6)")
- .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(6)")
- .HasComment("系统建议到达日期");
- b.Property<decimal?>("pr_sqty")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("建议数量");
- b.Property<DateTime?>("pr_ssend_date")
- .HasColumnType("datetime(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("srm_pr_main", (string)null);
- b.HasComment("采购申请单");
- });
- modelBuilder.Entity("Bussiness.Model.SRM.srm_purchase", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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")
- .IsRequired()
- .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")
- .IsRequired()
- .HasColumnType("bigint")
- .HasComment("采购发票差异科目代码");
- b.Property<long?>("pov_acct")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("srm_purchase", (string)null);
- b.HasComment("物料采购信息表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.crm_customer", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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")
- .IsRequired()
- .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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<decimal?>("value_add_rate")
- .HasPrecision(18, 10)
- .HasColumnType("decimal(18,10)")
- .HasComment("增值税率");
- b.HasKey("Id");
- b.ToTable("crm_customer", (string)null);
- b.HasComment("客户表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.srm_supplier", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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("Id");
- b.ToTable("srm_supplier", (string)null);
- b.HasComment("供应商表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_code", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- b.Property<string>("chinese_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("中文注释");
- b.Property<DateTime?>("code_date")
- .IsRequired()
- .HasColumnType("datetime(6)")
- .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")
- .IsRequired()
- .HasColumnType("bigint")
- .HasComment("编码生成当前值");
- b.HasKey("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");
- b.Property<DateTime>("code_date")
- .HasColumnType("datetime(6)")
- .HasComment("编码生成时间");
- b.Property<string>("code_name")
- .IsRequired()
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("编码生成名称");
- b.Property<long?>("code_value")
- .IsRequired()
- .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>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .HasComment("下一个开帐日期");
- b.Property<string>("type")
- .HasMaxLength(50)
- .HasColumnType("varchar(50)")
- .HasComment("配置类型");
- b.HasKey("Id");
- b.ToTable("sys_config", (string)null);
- b.HasComment("系统配置表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_measure_unit", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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("Id");
- b.ToTable("sys_measure_unit", (string)null);
- b.HasComment("计量单位表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_post", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("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");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("sys_post_staff", (string)null);
- b.HasComment("员工岗位关联表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_schedule", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<int?>("validate_hours")
- .HasColumnType("int")
- .HasComment("有效时长");
- b.Property<int?>("work_hours")
- .HasColumnType("int")
- .HasComment("工作时长");
- b.HasKey("Id");
- b.ToTable("sys_schedule", (string)null);
- b.HasComment("班次表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_shift", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<int?>("validate_hours")
- .HasColumnType("int")
- .HasComment("有效时长");
- b.HasKey("Id");
- b.ToTable("sys_shift", (string)null);
- b.HasComment("班制表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_shift_invalid_time", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .HasComment("创建时间");
- b.Property<DateTime>("end_time")
- .HasColumnType("datetime(6)")
- .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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("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");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("sys_shift_schedule", (string)null);
- b.HasComment("班制班次关联表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_staff", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<long?>("user_id")
- .HasColumnType("bigint")
- .HasComment("用户id");
- b.Property<string>("user_name")
- .HasMaxLength(255)
- .HasColumnType("varchar(255)")
- .HasComment("用户名称");
- b.HasKey("Id");
- b.ToTable("sys_staff", (string)null);
- b.HasComment("员工表");
- });
- modelBuilder.Entity("Bussiness.Model.SystemData.sys_upload", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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("Id");
- b.ToTable("sys_upload", (string)null);
- b.HasComment("文件上传表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_process", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_process", (string)null);
- b.HasComment("工序表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_tech_proc_accessory", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .HasComment("创建时间");
- b.Property<long?>("equip_id")
- .IsRequired()
- .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")
- .IsRequired()
- .HasColumnType("int")
- .HasComment("数量");
- b.Property<long?>("tech_proc_id")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_tech_proc_accessory", (string)null);
- b.HasComment("治具表(工装表)");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_tech_proc_document", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.Property<long?>("upload_id")
- .IsRequired()
- .HasColumnType("bigint")
- .HasComment("作业指导书主键");
- b.HasKey("Id");
- b.ToTable("mes_tech_proc_document", (string)null);
- b.HasComment("工序作业指导书表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_tech_proc_equipment", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .HasComment("创建时间");
- b.Property<long?>("equip_id")
- .IsRequired()
- .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")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.Property<long?>("work_calendar_id")
- .HasColumnType("bigint")
- .HasComment("工作日历id");
- b.HasKey("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>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("icitem_id")
- .IsRequired()
- .HasColumnType("bigint")
- .HasComment("物料id");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<int?>("qty")
- .IsRequired()
- .HasColumnType("int")
- .HasComment("数量");
- b.Property<long?>("tech_proc_id")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("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>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.Property<long?>("workshop_id")
- .IsRequired()
- .HasColumnType("bigint")
- .HasComment("工位id");
- b.HasKey("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>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .HasComment("创建时间");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<long?>("org_id")
- .HasColumnType("bigint")
- .HasComment("组织ID");
- b.Property<long?>("staff_id")
- .IsRequired()
- .HasColumnType("bigint")
- .HasComment("员工id");
- b.Property<string>("staff_name")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("员工姓名");
- b.Property<long?>("tech_proc_workshop_id")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_tech_proc_workshop_staff", (string)null);
- b.HasComment("工序工位员工信息表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_tech_process", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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")
- .IsRequired()
- .HasColumnType("int")
- .HasComment("是否需要排产:1-是;0-否");
- b.Property<int?>("level")
- .IsRequired()
- .HasColumnType("int")
- .HasComment("组合层级");
- b.Property<decimal?>("lq")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .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")
- .IsRequired()
- .HasColumnType("bigint")
- .HasComment("工序主键");
- b.Property<decimal?>("readytime")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("前置准备时间");
- b.Property<long?>("tech_id")
- .IsRequired()
- .HasColumnType("bigint")
- .HasComment("工艺主键");
- b.Property<long>("tenant_id")
- .HasColumnType("bigint")
- .HasComment("企业ID");
- b.Property<int?>("type")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.Property<decimal?>("upe")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("一次可加工数量");
- b.Property<decimal?>("uph")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("UPH");
- b.Property<decimal?>("upp")
- .HasPrecision(20, 8)
- .HasColumnType("decimal(20,8)")
- .HasComment("子工序加工数量");
- b.Property<int?>("wctype")
- .HasColumnType("int")
- .HasComment("工作中心类型");
- b.Property<int?>("wsinuse")
- .HasColumnType("int")
- .HasComment("实际运行工位数");
- b.HasKey("Id");
- b.ToTable("mes_tech_process", (string)null);
- b.HasComment("工艺关联工序表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_technique", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .HasComment("创建时间");
- b.Property<string>("desc")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("描述");
- b.Property<long?>("factory_id")
- .HasColumnType("bigint")
- .HasComment("工厂ID");
- b.Property<int?>("level")
- .IsRequired()
- .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(6)")
- .HasComment("修改时间");
- b.HasKey("Id");
- b.ToTable("mes_technique", (string)null);
- b.HasComment("工艺路径表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_work_calendar", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .HasComment("创建时间");
- b.Property<DateTime?>("end_time")
- .HasColumnType("datetime(6)")
- .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(6)")
- .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(6)")
- .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("Id");
- b.ToTable("mes_work_calendar", (string)null);
- b.HasComment("工作日历表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_work_calendar_list", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<DateTime?>("work_cal_list_date")
- .HasColumnType("datetime(6)")
- .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")
- .IsRequired()
- .HasColumnType("bigint")
- .HasComment("工作日历id");
- b.HasKey("Id");
- b.ToTable("mes_work_calendar_list", (string)null);
- b.HasComment("工作日历明细表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_workshop", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<long?>("work_calendar_id")
- .HasColumnType("bigint")
- .HasComment("工作日历id");
- b.Property<string>("zone")
- .HasMaxLength(100)
- .HasColumnType("varchar(100)")
- .HasComment("区域");
- b.HasKey("Id");
- b.ToTable("mes_workshop", (string)null);
- b.HasComment("工位表");
- });
- modelBuilder.Entity("Bussiness.Model.Tech.mes_workshop_shelf", b =>
- {
- b.Property<long>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("bigint");
- 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(6)")
- .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(6)")
- .HasComment("修改时间");
- b.Property<long?>("workshop_id")
- .IsRequired()
- .HasColumnType("bigint")
- .HasComment("工位id");
- b.HasKey("Id");
- b.ToTable("mes_workshop_shelf", (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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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(6)")
- .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
- }
- }
- }
|