1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013 |
- using System;
- using Microsoft.EntityFrameworkCore;
- using Microsoft.EntityFrameworkCore.Metadata;
- namespace MySystem.JavaModels
- {
- public partial class WebCMSEntities : DbContext
- {
- public WebCMSEntities()
- {
- }
- public WebCMSEntities(DbContextOptions<WebCMSEntities> options)
- : base(options)
- {
- }
- public virtual DbSet<KxsActivityMarket> KxsActivityMarket { get; set; }
- public virtual DbSet<KxsActivityMenu> KxsActivityMenu { get; set; }
- public virtual DbSet<KxsAppModal> KxsAppModal { get; set; }
- public virtual DbSet<KxsBanner> KxsBanner { get; set; }
- public virtual DbSet<KxsBcqtTeam> KxsBcqtTeam { get; set; }
- public virtual DbSet<KxsBcqtTeamDetail> KxsBcqtTeamDetail { get; set; }
- public virtual DbSet<KxsCamp> KxsCamp { get; set; }
- public virtual DbSet<KxsCampBonusLog> KxsCampBonusLog { get; set; }
- public virtual DbSet<KxsCampUser> KxsCampUser { get; set; }
- public virtual DbSet<KxsCheckpoint> KxsCheckpoint { get; set; }
- public virtual DbSet<KxsDtsErrorLog> KxsDtsErrorLog { get; set; }
- public virtual DbSet<KxsDtsLog> KxsDtsLog { get; set; }
- public virtual DbSet<KxsFeedback> KxsFeedback { get; set; }
- public virtual DbSet<KxsFeedbackType> KxsFeedbackType { get; set; }
- public virtual DbSet<KxsMorning> KxsMorning { get; set; }
- public virtual DbSet<KxsMorningLog> KxsMorningLog { get; set; }
- public virtual DbSet<KxsOpenBank> KxsOpenBank { get; set; }
- public virtual DbSet<KxsRulemaking> KxsRulemaking { get; set; }
- public virtual DbSet<KxsSchoolMenu> KxsSchoolMenu { get; set; }
- public virtual DbSet<KxsSchoolStudy> KxsSchoolStudy { get; set; }
- public virtual DbSet<KxsServiceCenter> KxsServiceCenter { get; set; }
- public virtual DbSet<KxsServiceMenu> KxsServiceMenu { get; set; }
- public virtual DbSet<KxsSysMsg> KxsSysMsg { get; set; }
- public virtual DbSet<KxsSysMsgRead> KxsSysMsgRead { get; set; }
- public virtual DbSet<KxsUserMsg> KxsUserMsg { get; set; }
- public virtual DbSet<SysCity> SysCity { get; set; }
- public virtual DbSet<SysDept> SysDept { get; set; }
- public virtual DbSet<SysDict> SysDict { get; set; }
- public virtual DbSet<SysDictItem> SysDictItem { get; set; }
- public virtual DbSet<SysFile> SysFile { get; set; }
- public virtual DbSet<SysLog> SysLog { get; set; }
- public virtual DbSet<SysMenu> SysMenu { get; set; }
- public virtual DbSet<SysOauthClientDetails> SysOauthClientDetails { get; set; }
- public virtual DbSet<SysPost> SysPost { get; set; }
- public virtual DbSet<SysPublicParam> SysPublicParam { get; set; }
- public virtual DbSet<SysRole> SysRole { get; set; }
- public virtual DbSet<SysRoleMenu> SysRoleMenu { get; set; }
- public virtual DbSet<SysUser> SysUser { get; set; }
- public virtual DbSet<SysUserPost> SysUserPost { get; set; }
- public virtual DbSet<SysUserRole> SysUserRole { get; set; }
- public virtual DbSet<UndoLog> UndoLog { get; set; }
- protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
- {
- if (!optionsBuilder.IsConfigured)
- {
- optionsBuilder.UseMySql(Library.ConfigurationManager.AppSettings["JavaSqlConnStr"].ToString(), x => x.ServerVersion("5.7.17-mysql"));
- }
- }
- protected override void OnModelCreating(ModelBuilder modelBuilder)
- {
- modelBuilder.Entity<KxsActivityMarket>(entity =>
- {
- entity.ToTable("kxs_activity_market");
- entity.HasComment("市场活动信息表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.Contents)
- .HasColumnName("contents")
- .HasColumnType("longtext")
- .HasComment("详情描述")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.MenuId)
- .HasColumnName("menu_id")
- .HasComment("分类ID");
- entity.Property(e => e.PicPath)
- .HasColumnName("pic_path")
- .HasColumnType("varchar(255)")
- .HasComment("封面")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Sort)
- .HasColumnName("sort")
- .HasComment("排序");
- entity.Property(e => e.Status)
- .HasColumnName("status")
- .HasComment("状态 0下架 1上架");
- entity.Property(e => e.Title)
- .HasColumnName("title")
- .HasColumnType("varchar(255)")
- .HasComment("标题")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Url)
- .HasColumnName("url")
- .HasColumnType("varchar(500)")
- .HasComment("外链")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsActivityMenu>(entity =>
- {
- entity.ToTable("kxs_activity_menu");
- entity.HasComment("市场活动分类");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.Pid)
- .HasColumnName("pid")
- .HasComment("父级ID");
- entity.Property(e => e.Sort)
- .HasColumnName("sort")
- .HasComment("排序");
- entity.Property(e => e.Title)
- .HasColumnName("title")
- .HasColumnType("varchar(128)")
- .HasComment("分类名")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsAppModal>(entity =>
- {
- entity.ToTable("kxs_app_modal");
- entity.HasComment("APP弹窗管理表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.BgPic)
- .HasColumnName("bg_pic")
- .HasColumnType("varchar(255)")
- .HasComment("背景图片")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.BtnText)
- .HasColumnName("btn_text")
- .HasColumnType("varchar(18)")
- .HasComment("按钮文字")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Content)
- .HasColumnName("content")
- .HasColumnType("longtext")
- .HasComment("内容")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.EndTime)
- .HasColumnName("end_time")
- .HasColumnType("datetime")
- .HasComment("结束时间");
- entity.Property(e => e.IsAssign)
- .HasColumnName("is_assign")
- .HasComment("是否指定 0否 1是");
- entity.Property(e => e.IsWeekend)
- .HasColumnName("is_weekend")
- .HasComment("是否周末 0否 1是");
- entity.Property(e => e.MsgType)
- .HasColumnName("msg_type")
- .HasComment("消息分类 0文本 1图片 2动图");
- entity.Property(e => e.StartTime)
- .HasColumnName("start_time")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- entity.Property(e => e.Status)
- .HasColumnName("status")
- .HasComment("状态 0关闭 1开启");
- entity.Property(e => e.TimeByDay)
- .HasColumnName("time_by_day")
- .HasComment("每日推送次数");
- entity.Property(e => e.Title)
- .HasColumnName("title")
- .HasColumnType("varchar(255)")
- .HasComment("标题")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Url)
- .HasColumnName("url")
- .HasColumnType("varchar(255)")
- .HasComment("跳转url")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UrlParam)
- .HasColumnName("url_param")
- .HasColumnType("varchar(128)")
- .HasComment("跳转Url参数")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UserCodes)
- .HasColumnName("user_codes")
- .HasColumnType("longtext")
- .HasComment("指定用户编号")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsBanner>(entity =>
- {
- entity.ToTable("kxs_banner");
- entity.HasComment("首页广告管理表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.BanType)
- .HasColumnName("ban_type")
- .HasColumnType("varchar(128)")
- .HasComment("分类名称")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.PicUrl)
- .HasColumnName("pic_url")
- .HasColumnType("varchar(255)")
- .HasComment("封面图地址")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Remark)
- .HasColumnName("remark")
- .HasColumnType("varchar(255)")
- .HasComment("备注")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Status)
- .HasColumnName("status")
- .HasDefaultValueSql("'1'")
- .HasComment("状态 0下架 1上架");
- entity.Property(e => e.Title)
- .HasColumnName("title")
- .HasColumnType("varchar(255)")
- .HasComment("标题")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Url)
- .HasColumnName("url")
- .HasColumnType("varchar(255)")
- .HasComment("跳转链接")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsBcqtTeam>(entity =>
- {
- entity.ToTable("kxs_bcqt_team");
- entity.HasComment("百城千团团队表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.ActiviteType)
- .HasColumnName("activite_type")
- .HasDefaultValueSql("'1'")
- .HasComment("活动类型 1训练营");
- entity.Property(e => e.ActivityDate)
- .HasColumnName("activity_date")
- .HasComment("活动时长(单位:自然日)");
- entity.Property(e => e.CaptainId)
- .HasColumnName("captain_id")
- .HasComment("队长id");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasColumnType("varchar(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("删除标记,0未删除,1已删除")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.EndTime)
- .HasColumnName("end_time")
- .HasColumnType("datetime")
- .HasComment("活动结束时间");
- entity.Property(e => e.ReachStatus)
- .HasColumnName("reach_status")
- .HasComment("达标状态 0未达标 1已达标");
- entity.Property(e => e.StartTime)
- .HasColumnName("start_time")
- .HasColumnType("datetime")
- .HasComment("活动开始时间");
- entity.Property(e => e.Status)
- .HasColumnName("status")
- .HasComment("活动状态 0报名中 1已开始 2已结束");
- entity.Property(e => e.TeamName)
- .IsRequired()
- .HasColumnName("team_name")
- .HasColumnType("varchar(255)")
- .HasComment("团队名称")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.TeamNumber)
- .HasColumnName("team_number")
- .HasComment("团队人数");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Username)
- .HasColumnName("username")
- .HasColumnType("varchar(255)")
- .HasComment("队长姓名")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsBcqtTeamDetail>(entity =>
- {
- entity.ToTable("kxs_bcqt_team_detail");
- entity.HasComment("百城千团团队明细表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.CaptainStatus)
- .HasColumnName("captain_status")
- .HasComment("队长标识0非队长1队长");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasColumnType("varchar(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("删除标记,0未删除,1已删除")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.EndFlag)
- .HasColumnName("end_flag")
- .HasComment("结束标识0参与中 1已结束参与");
- entity.Property(e => e.GdActivateNumber)
- .HasColumnName("gd_activate_number")
- .HasComment("广电卡激活数");
- entity.Property(e => e.LkbActivateNumber)
- .HasColumnName("lkb_activate_number")
- .HasComment("来客吧激活数");
- entity.Property(e => e.PosActivateNumber)
- .HasColumnName("pos_activate_number")
- .HasComment("pos激活数");
- entity.Property(e => e.TeamId)
- .HasColumnName("team_id")
- .HasComment("团队id");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.UserCode)
- .HasColumnName("user_code")
- .HasColumnType("varchar(255)")
- .HasComment("用户编号")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UserId)
- .HasColumnName("user_id")
- .HasComment("用户id");
- entity.Property(e => e.Username)
- .HasColumnName("username")
- .HasColumnType("varchar(255)")
- .HasComment("用户名")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsCamp>(entity =>
- {
- entity.ToTable("kxs_camp");
- entity.HasComment("训练营");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.BonusPool)
- .HasColumnName("bonus_pool")
- .HasColumnType("decimal(18,2)")
- .HasComment("奖金池");
- entity.Property(e => e.CampNum)
- .HasColumnName("camp_num")
- .HasColumnType("varchar(32)")
- .HasComment("期数")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CampType)
- .HasColumnName("camp_type")
- .HasColumnType("varchar(128)")
- .HasComment("活动类型")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateBy)
- .HasColumnName("create_by")
- .HasColumnType("varchar(64)")
- .HasComment("创建人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateCode)
- .HasColumnName("create_code")
- .HasColumnType("varchar(32)")
- .HasComment("发起人编码")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.CreateUserId)
- .HasColumnName("create_user_id")
- .HasComment("发起人用户ID");
- entity.Property(e => e.CreateUsername)
- .HasColumnName("create_username")
- .HasColumnType("varchar(32)")
- .HasComment("发起人姓名")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.EndTime)
- .HasColumnName("end_time")
- .HasColumnType("datetime")
- .HasComment("结束时间");
- entity.Property(e => e.OpenNum)
- .HasColumnName("open_num")
- .HasComment("开机数");
- entity.Property(e => e.OrderNum)
- .HasColumnName("order_num")
- .HasComment("订单数");
- entity.Property(e => e.PicUrl)
- .HasColumnName("pic_url")
- .HasColumnType("varchar(500)")
- .HasComment("活动图片")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Remark)
- .HasColumnName("remark")
- .HasColumnType("varchar(255)")
- .HasComment("备注")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.StartTime)
- .HasColumnName("start_time")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- entity.Property(e => e.Status)
- .HasColumnName("status")
- .HasComment("状态 0未开始 进行中 2已结束");
- entity.Property(e => e.Title)
- .HasColumnName("title")
- .HasColumnType("varchar(255)")
- .HasComment("标题")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateBy)
- .HasColumnName("update_by")
- .HasColumnType("varchar(64)")
- .HasComment("更新人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.UserNum)
- .HasColumnName("user_num")
- .HasComment("参与人数");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsCampBonusLog>(entity =>
- {
- entity.ToTable("kxs_camp_bonus_log");
- entity.HasComment("训练营奖金池日志表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.AfterAmount)
- .HasColumnName("after_amount")
- .HasColumnType("decimal(18,2)")
- .HasComment("变动后金额");
- entity.Property(e => e.Amount)
- .HasColumnName("amount")
- .HasColumnType("decimal(18,2)")
- .HasComment("操作金额");
- entity.Property(e => e.BeforeAmount)
- .HasColumnName("before_amount")
- .HasColumnType("decimal(18,2)")
- .HasComment("变动前金额");
- entity.Property(e => e.CampId)
- .HasColumnName("camp_id")
- .HasComment("训练营ID");
- entity.Property(e => e.CreateBy)
- .HasColumnName("create_by")
- .HasColumnType("varchar(64)")
- .HasComment("操作人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.Kind)
- .HasColumnName("kind")
- .HasColumnType("varchar(6)")
- .HasComment("日志类型 add新增 sub减少")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.OrderId)
- .HasColumnName("order_id")
- .HasComment("进入奖金池的订单ID");
- entity.Property(e => e.PosSn)
- .HasColumnName("pos_sn")
- .HasColumnType("varchar(64)")
- .HasComment("进入开机累计的sn号")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Remark)
- .HasColumnName("remark")
- .HasColumnType("varchar(128)")
- .HasComment("备注")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.StageId)
- .HasColumnName("stage_id")
- .HasComment("分期大盟主的分期ID");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsCampUser>(entity =>
- {
- entity.ToTable("kxs_camp_user");
- entity.HasComment("训练营参与创客");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.CampId)
- .HasColumnName("camp_id")
- .HasComment("训练营ID");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.TeamBonusPool)
- .HasColumnName("team_bonus_pool")
- .HasColumnType("decimal(18,2)")
- .HasComment("创客奖金池");
- entity.Property(e => e.TeamLeaderNum)
- .HasColumnName("team_leader_num")
- .HasComment("团队下单大小盟主");
- entity.Property(e => e.TeamLeaderPool)
- .HasColumnName("team_leader_pool")
- .HasColumnType("decimal(18,2)")
- .HasComment("创客盟主下单奖金池");
- entity.Property(e => e.TeamOpenNum)
- .HasColumnName("team_open_num")
- .HasComment("团队开机总数");
- entity.Property(e => e.TeamOrderNum)
- .HasColumnName("team_order_num")
- .HasComment("团队下单数量");
- entity.Property(e => e.TeamOrderPool)
- .HasColumnName("team_order_pool")
- .HasColumnType("decimal(18,2)")
- .HasComment("创客订单奖金池");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.UserCode)
- .HasColumnName("user_code")
- .HasColumnType("varchar(16)")
- .HasComment("创客编号")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UserId)
- .HasColumnName("user_id")
- .HasComment("用户ID");
- entity.Property(e => e.Username)
- .HasColumnName("username")
- .HasColumnType("varchar(64)")
- .HasComment("用户姓名")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsCheckpoint>(entity =>
- {
- entity.ToTable("kxs_checkpoint");
- entity.HasComment("数据同步保存消费节点表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键");
- entity.Property(e => e.Checkpoint)
- .HasColumnName("checkpoint")
- .HasColumnType("varchar(2000)")
- .HasComment("消费节点")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.GroupId)
- .HasColumnName("group_id")
- .HasColumnType("varchar(64)")
- .HasComment("组ID")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime");
- });
- modelBuilder.Entity<KxsDtsErrorLog>(entity =>
- {
- entity.ToTable("kxs_dts_error_log");
- entity.HasComment("数据同步记录失败日志表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键");
- entity.Property(e => e.Content)
- .HasColumnName("content")
- .HasColumnType("longtext")
- .HasComment("原始数据")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.ErrorStr)
- .HasColumnName("error_str")
- .HasColumnType("longtext")
- .HasComment("错误信息")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Operation)
- .HasColumnName("operation")
- .HasColumnType("varchar(12)")
- .HasComment("操作类型")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.TableName)
- .HasColumnName("table_name")
- .HasColumnType("varchar(32)")
- .HasComment("表名")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- });
- modelBuilder.Entity<KxsDtsLog>(entity =>
- {
- entity.ToTable("kxs_dts_log");
- entity.HasComment("数据同步记录日志表");
- entity.HasIndex(e => e.DataId)
- .HasName("data-id")
- .IsUnique();
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键");
- entity.Property(e => e.Content)
- .HasColumnName("content")
- .HasColumnType("longtext")
- .HasComment("原始数据")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DataId)
- .HasColumnName("data_id")
- .HasComment("数据ID");
- entity.Property(e => e.Operation)
- .HasColumnName("operation")
- .HasColumnType("varchar(12)")
- .HasComment("操作类型")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.TableName)
- .HasColumnName("table_name")
- .HasColumnType("varchar(32)")
- .HasComment("表名")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- });
- modelBuilder.Entity<KxsFeedback>(entity =>
- {
- entity.ToTable("kxs_feedback");
- entity.HasComment("用户反馈信息");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.BackType)
- .HasColumnName("back_type")
- .HasColumnType("varchar(64)")
- .HasComment("反馈类型")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Content)
- .HasColumnName("content")
- .HasColumnType("varchar(1000)")
- .HasComment("内容")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.UserId)
- .HasColumnName("user_id")
- .HasComment("用户ID");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsFeedbackType>(entity =>
- {
- entity.ToTable("kxs_feedback_type");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.CreateBy)
- .IsRequired()
- .HasColumnName("create_by")
- .HasColumnType("varchar(50)")
- .HasDefaultValueSql("'0'")
- .HasComment(@"创建人
- ")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_0900_ai_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.TypeName)
- .HasColumnName("type_name")
- .HasColumnType("varchar(255)")
- .HasComment(@"反馈类型名称
- ")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_0900_ai_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsMorning>(entity =>
- {
- entity.ToTable("kxs_morning");
- entity.HasComment("商学院晨会表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.AppLink)
- .HasColumnName("app_link")
- .HasColumnType("varchar(500)")
- .HasComment("跳转APP链接")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.BannerPhoto)
- .HasColumnName("banner_photo")
- .HasColumnType("varchar(500)")
- .HasComment("推荐封面图")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.EndDate)
- .HasColumnName("end_date")
- .HasColumnType("datetime")
- .HasComment("结束时间");
- entity.Property(e => e.IsBanner)
- .HasColumnName("is_banner")
- .HasColumnType("bit(1)")
- .HasDefaultValueSql("b'0'")
- .HasComment("是否推荐");
- entity.Property(e => e.Lecturer)
- .HasColumnName("lecturer")
- .HasColumnType("varchar(32)")
- .HasComment("主讲人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.PageLink)
- .HasColumnName("page_link")
- .HasColumnType("varchar(500)")
- .HasComment("小程序链接")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Photo)
- .HasColumnName("photo")
- .HasColumnType("varchar(500)")
- .HasComment("晨会头像")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.StartDate)
- .HasColumnName("start_date")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- entity.Property(e => e.StudyPerson)
- .HasColumnName("study_person")
- .HasComment("学习人数");
- entity.Property(e => e.Title)
- .HasColumnName("title")
- .HasColumnType("varchar(255)")
- .HasComment("标题")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Url)
- .HasColumnName("url")
- .HasColumnType("varchar(500)")
- .HasComment("外链")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsMorningLog>(entity =>
- {
- entity.ToTable("kxs_morning_log");
- entity.HasComment("每日晨会日志表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("id");
- entity.Property(e => e.MorningId)
- .HasColumnName("morning_id")
- .HasComment("晨会ID");
- entity.Property(e => e.UserId)
- .HasColumnName("user_id")
- .HasComment("用户ID");
- });
- modelBuilder.Entity<KxsOpenBank>(entity =>
- {
- entity.ToTable("kxs_open_bank");
- entity.HasComment("银行开户行表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.BankCode)
- .HasColumnName("bank_code")
- .HasColumnType("varchar(32)")
- .HasComment("开户行编码")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.BankName)
- .HasColumnName("bank_name")
- .HasColumnType("varchar(128)")
- .HasComment("开户行名称")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsRulemaking>(entity =>
- {
- entity.ToTable("kxs_rulemaking");
- entity.HasComment("客小爽协议规则表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.Contents)
- .HasColumnName("contents")
- .HasColumnType("longtext")
- .HasComment("内容")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.RuleType)
- .HasColumnName("rule_type")
- .HasComment("类型 0注册协议 1服务协议 2创客守则 3提现规则");
- entity.Property(e => e.Title)
- .HasColumnName("title")
- .HasColumnType("varchar(255)")
- .HasComment("标题")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsSchoolMenu>(entity =>
- {
- entity.ToTable("kxs_school_menu");
- entity.HasComment("商学院创客学堂分类");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.ColDetail)
- .HasColumnName("col_detail")
- .HasColumnType("varchar(255)")
- .HasComment("分类描述")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.ColId)
- .HasColumnName("col_id")
- .HasColumnType("varchar(32)")
- .HasComment("分类ID")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.ColName)
- .HasColumnName("col_name")
- .HasColumnType("varchar(128)")
- .HasComment("分类名称")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.ColPicPath)
- .HasColumnName("col_pic_path")
- .HasColumnType("varchar(255)")
- .HasComment("分类封面图")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.IsOpen)
- .HasColumnName("is_open")
- .HasDefaultValueSql("'1'")
- .HasComment("是否开发 0否 1开放");
- entity.Property(e => e.Pid)
- .HasColumnName("pid")
- .HasComment("父级ID");
- entity.Property(e => e.Sort)
- .HasColumnName("sort")
- .HasComment("排序");
- entity.Property(e => e.StartAmount)
- .HasColumnName("start_amount")
- .HasColumnType("decimal(18,2)")
- .HasComment("起始交易额查看权限");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsSchoolStudy>(entity =>
- {
- entity.ToTable("kxs_school_study");
- entity.HasComment("商学院创客学堂");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.Detail)
- .HasColumnName("detail")
- .HasColumnType("varchar(255)")
- .HasComment("详情描述")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Lecturer)
- .HasColumnName("lecturer")
- .HasColumnType("varchar(32)")
- .HasComment("作者")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.ListPic)
- .HasColumnName("list_pic")
- .HasColumnType("varchar(255)")
- .HasComment("封面")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.MenuId)
- .IsRequired()
- .HasColumnName("menu_id")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("'0'")
- .HasComment("分类ID")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.StudyPerson)
- .HasColumnName("study_person")
- .HasComment("学习人数");
- entity.Property(e => e.Title)
- .HasColumnName("title")
- .HasColumnType("varchar(255)")
- .HasComment("标题")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Url)
- .HasColumnName("url")
- .HasColumnType("varchar(255)")
- .HasComment("外链")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsServiceCenter>(entity =>
- {
- entity.ToTable("kxs_service_center");
- entity.HasComment("服务中心");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.Content)
- .HasColumnName("content")
- .HasColumnType("longtext")
- .HasComment("内容")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateBy)
- .HasColumnName("create_by")
- .HasColumnType("varchar(32)")
- .HasComment("创建人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.MenuId)
- .HasColumnName("menu_id")
- .HasComment("分类ID");
- entity.Property(e => e.Sort)
- .HasColumnName("sort")
- .HasDefaultValueSql("'50'")
- .HasComment("排序");
- entity.Property(e => e.Title)
- .HasColumnName("title")
- .HasColumnType("varchar(255)")
- .HasComment("标题")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateBy)
- .HasColumnName("update_by")
- .HasColumnType("varchar(64)")
- .HasComment("修改人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsServiceMenu>(entity =>
- {
- entity.ToTable("kxs_service_menu");
- entity.HasComment("服务中心分类");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.Sort)
- .HasColumnName("sort")
- .HasDefaultValueSql("'50'")
- .HasComment("排序");
- entity.Property(e => e.Title)
- .HasColumnName("title")
- .HasColumnType("varchar(64)")
- .HasComment("分类名称")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsSysMsg>(entity =>
- {
- entity.ToTable("kxs_sys_msg");
- entity.HasComment("系统消息推送表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.BgPic)
- .HasColumnName("bg_pic")
- .HasColumnType("varchar(255)")
- .HasComment("背景图片")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Content)
- .HasColumnName("content")
- .HasColumnType("longtext")
- .HasComment("推送内容")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.EndTime)
- .HasColumnName("end_time")
- .HasColumnType("datetime")
- .HasComment("结束时间");
- entity.Property(e => e.MsgType)
- .HasColumnName("msg_type")
- .HasComment("消息类型 0html页面 1URL 2简单文字");
- entity.Property(e => e.PushTime)
- .HasColumnName("push_time")
- .HasColumnType("datetime")
- .HasComment("推送时间");
- entity.Property(e => e.PushType)
- .HasColumnName("push_type")
- .HasComment("推送类型 0不推送 1立即推送 2定时推送");
- entity.Property(e => e.StartTime)
- .HasColumnName("start_time")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- entity.Property(e => e.Summary)
- .HasColumnName("summary")
- .HasColumnType("varchar(255)")
- .HasComment("简介")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Title)
- .HasColumnName("title")
- .HasColumnType("varchar(255)")
- .HasComment("标题")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Url)
- .HasColumnName("url")
- .HasColumnType("varchar(255)")
- .HasComment("跳转地址")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<KxsSysMsgRead>(entity =>
- {
- entity.ToTable("kxs_sys_msg_read");
- entity.HasComment("系统消息已读表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("id");
- entity.Property(e => e.MsgId)
- .HasColumnName("msg_id")
- .HasComment("系统消息ID");
- entity.Property(e => e.UserId)
- .HasColumnName("user_id")
- .HasComment("用户ID");
- });
- modelBuilder.Entity<KxsUserMsg>(entity =>
- {
- entity.ToTable("kxs_user_msg");
- entity.HasComment("系统用户消息推送表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("主键ID");
- entity.Property(e => e.BgPic)
- .HasColumnName("bg_pic")
- .HasColumnType("varchar(255)")
- .HasComment("背景图片")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Content)
- .HasColumnName("content")
- .HasColumnType("longtext")
- .HasComment("推送内容")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("新增时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasComment("删除标记,0未删除,1已删除");
- entity.Property(e => e.EndTime)
- .HasColumnName("end_time")
- .HasColumnType("datetime")
- .HasComment("结束时间");
- entity.Property(e => e.MsgType)
- .HasColumnName("msg_type")
- .HasComment("消息类型 0html页面 1URL 2简单文字");
- entity.Property(e => e.PushTime)
- .HasColumnName("push_time")
- .HasColumnType("datetime")
- .HasComment("推送时间");
- entity.Property(e => e.PushType)
- .HasColumnName("push_type")
- .HasComment("推送类型 0不推送 1立即推送 2定时推送");
- entity.Property(e => e.ReadFlag)
- .HasColumnName("read_flag")
- .HasComment("0未读 1已读");
- entity.Property(e => e.StartTime)
- .HasColumnName("start_time")
- .HasColumnType("datetime")
- .HasComment("开始时间");
- entity.Property(e => e.Summary)
- .HasColumnName("summary")
- .HasColumnType("varchar(255)")
- .HasComment("简介")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Title)
- .HasColumnName("title")
- .HasColumnType("varchar(255)")
- .HasComment("标题")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.Url)
- .HasColumnName("url")
- .HasColumnType("varchar(255)")
- .HasComment("跳转地址")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UserId)
- .HasColumnName("user_id")
- .HasComment("用户ID");
- entity.Property(e => e.Version)
- .HasColumnName("version")
- .HasComment("版本");
- });
- modelBuilder.Entity<SysCity>(entity =>
- {
- entity.ToTable("sys_city");
- entity.HasComment("城市表");
- entity.HasIndex(e => e.CityId)
- .HasName("idx_city_id")
- .IsUnique();
- entity.Property(e => e.Id).HasColumnName("id");
- entity.Property(e => e.AreaCode)
- .IsRequired()
- .HasColumnName("area_code")
- .HasColumnType("varchar(30)")
- .HasDefaultValueSql("''")
- .HasComment("区号")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CityId)
- .HasColumnName("city_id")
- .HasComment("城市id");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("timestamp")
- .HasDefaultValueSql("CURRENT_TIMESTAMP")
- .HasComment("创建时间");
- entity.Property(e => e.IsShow)
- .IsRequired()
- .HasColumnName("is_show")
- .HasDefaultValueSql("'1'")
- .HasComment("是否展示");
- entity.Property(e => e.Lat)
- .IsRequired()
- .HasColumnName("lat")
- .HasColumnType("varchar(50)")
- .HasDefaultValueSql("''")
- .HasComment("纬度")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Level)
- .HasColumnName("level")
- .HasComment("省市级别");
- entity.Property(e => e.Lng)
- .IsRequired()
- .HasColumnName("lng")
- .HasColumnType("varchar(50)")
- .HasDefaultValueSql("''")
- .HasComment("经度")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.MergerName)
- .IsRequired()
- .HasColumnName("merger_name")
- .HasColumnType("varchar(255)")
- .HasDefaultValueSql("''")
- .HasComment("合并名称")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.Name)
- .IsRequired()
- .HasColumnName("name")
- .HasColumnType("varchar(100)")
- .HasDefaultValueSql("''")
- .HasComment("名称")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.ParentId)
- .HasColumnName("parent_id")
- .HasComment("父级id");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("timestamp")
- .HasDefaultValueSql("CURRENT_TIMESTAMP")
- .HasComment("更新时间")
- .ValueGeneratedOnAddOrUpdate();
- });
- modelBuilder.Entity<SysDept>(entity =>
- {
- entity.HasKey(e => e.DeptId)
- .HasName("PRIMARY");
- entity.ToTable("sys_dept");
- entity.HasComment("部门管理");
- entity.Property(e => e.DeptId)
- .HasColumnName("dept_id")
- .HasComment("部门ID");
- entity.Property(e => e.CreateBy)
- .IsRequired()
- .HasColumnName("create_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("创建人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("删除标志")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Name)
- .HasColumnName("name")
- .HasColumnType("varchar(50)")
- .HasComment("部门名称")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.ParentId)
- .HasColumnName("parent_id")
- .HasComment("父级部门ID");
- entity.Property(e => e.SortOrder)
- .HasColumnName("sort_order")
- .HasComment("排序");
- entity.Property(e => e.UpdateBy)
- .IsRequired()
- .HasColumnName("update_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("修改人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间");
- });
- modelBuilder.Entity<SysDict>(entity =>
- {
- entity.ToTable("sys_dict");
- entity.HasComment("字典表");
- entity.HasIndex(e => e.DelFlag)
- .HasName("sys_dict_del_flag");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("编号");
- entity.Property(e => e.CreateBy)
- .IsRequired()
- .HasColumnName("create_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("创建人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("删除标志")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Description)
- .HasColumnName("description")
- .HasColumnType("varchar(100)")
- .HasComment("描述")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.DictType)
- .HasColumnName("dict_type")
- .HasColumnType("varchar(100)")
- .HasComment("字典类型")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Remarks)
- .HasColumnName("remarks")
- .HasColumnType("varchar(255)")
- .HasComment("备注信息")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.SystemFlag)
- .HasColumnName("system_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("系统标志")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.UpdateBy)
- .IsRequired()
- .HasColumnName("update_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("修改人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- });
- modelBuilder.Entity<SysDictItem>(entity =>
- {
- entity.ToTable("sys_dict_item");
- entity.HasComment("字典项");
- entity.HasIndex(e => e.DelFlag)
- .HasName("sys_dict_item_del_flag");
- entity.HasIndex(e => e.ItemValue)
- .HasName("sys_dict_value");
- entity.HasIndex(e => e.Label)
- .HasName("sys_dict_label");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("编号");
- entity.Property(e => e.CreateBy)
- .IsRequired()
- .HasColumnName("create_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("创建人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("删除标志")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Description)
- .HasColumnName("description")
- .HasColumnType("varchar(100)")
- .HasComment("字典项描述")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.DictId)
- .HasColumnName("dict_id")
- .HasComment("字典ID");
- entity.Property(e => e.DictType)
- .HasColumnName("dict_type")
- .HasColumnType("varchar(100)")
- .HasComment("字典类型")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.ItemValue)
- .HasColumnName("item_value")
- .HasColumnType("varchar(100)")
- .HasComment("字典项值")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Label)
- .HasColumnName("label")
- .HasColumnType("varchar(100)")
- .HasComment("字典项名称")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Remarks)
- .HasColumnName("remarks")
- .HasColumnType("varchar(255)")
- .HasComment("备注信息")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.SortOrder)
- .HasColumnName("sort_order")
- .HasComment("排序(升序)");
- entity.Property(e => e.UpdateBy)
- .IsRequired()
- .HasColumnName("update_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("修改人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- });
- modelBuilder.Entity<SysFile>(entity =>
- {
- entity.ToTable("sys_file");
- entity.HasComment("文件管理表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("编号");
- entity.Property(e => e.BucketName)
- .HasColumnName("bucket_name")
- .HasColumnType("varchar(200)")
- .HasComment("文件存储桶名称")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.CreateBy)
- .IsRequired()
- .HasColumnName("create_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("创建人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("上传时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("删除标志")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.FileName)
- .HasColumnName("file_name")
- .HasColumnType("varchar(100)")
- .HasComment("文件名")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.FileSize)
- .HasColumnName("file_size")
- .HasComment("文件大小");
- entity.Property(e => e.Original)
- .HasColumnName("original")
- .HasColumnType("varchar(100)")
- .HasComment("原始文件名")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Type)
- .HasColumnName("type")
- .HasColumnType("varchar(50)")
- .HasComment("文件类型")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.UpdateBy)
- .IsRequired()
- .HasColumnName("update_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("修改人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- });
- modelBuilder.Entity<SysLog>(entity =>
- {
- entity.ToTable("sys_log");
- entity.HasComment("日志表");
- entity.HasIndex(e => e.CreateTime)
- .HasName("sys_log_create_date");
- entity.HasIndex(e => e.LogType)
- .HasName("sys_log_type");
- entity.HasIndex(e => e.RequestUri)
- .HasName("sys_log_request_uri");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("编号");
- entity.Property(e => e.CreateBy)
- .HasColumnName("create_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("创建人")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("删除标志")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Exception)
- .HasColumnName("exception")
- .HasColumnType("text")
- .HasComment("异常信息")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.LogType)
- .HasColumnName("log_type")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("日志类型")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Method)
- .HasColumnName("method")
- .HasColumnType("varchar(10)")
- .HasComment("请求方法")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Params)
- .HasColumnName("params")
- .HasColumnType("text")
- .HasComment("请求参数")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.RemoteAddr)
- .HasColumnName("remote_addr")
- .HasColumnType("varchar(255)")
- .HasComment("远程地址")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.RequestUri)
- .HasColumnName("request_uri")
- .HasColumnType("varchar(255)")
- .HasComment("请求URI")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.ServiceId)
- .HasColumnName("service_id")
- .HasColumnType("varchar(32)")
- .HasComment("服务ID")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Time)
- .HasColumnName("time")
- .HasComment("执行时间");
- entity.Property(e => e.Title)
- .HasColumnName("title")
- .HasColumnType("varchar(255)")
- .HasComment("日志标题")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.UpdateBy)
- .HasColumnName("update_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("修改人")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.UserAgent)
- .HasColumnName("user_agent")
- .HasColumnType("varchar(1000)")
- .HasComment("用户代理")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- });
- modelBuilder.Entity<SysMenu>(entity =>
- {
- entity.HasKey(e => e.MenuId)
- .HasName("PRIMARY");
- entity.ToTable("sys_menu");
- entity.HasComment("菜单权限表");
- entity.Property(e => e.MenuId)
- .HasColumnName("menu_id")
- .HasComment("菜单ID");
- entity.Property(e => e.CreateBy)
- .IsRequired()
- .HasColumnName("create_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("创建人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasDefaultValueSql("CURRENT_TIMESTAMP")
- .HasComment("创建时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("删除标志,0未删除,1已删除")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Embedded)
- .HasColumnName("embedded")
- .HasColumnType("char(1)")
- .HasComment("是否内嵌,0否,1是")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.EnName)
- .HasColumnName("en_name")
- .HasColumnType("varchar(128)")
- .HasComment("英文名称")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Icon)
- .HasColumnName("icon")
- .HasColumnType("varchar(64)")
- .HasComment("菜单图标")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.KeepAlive)
- .HasColumnName("keep_alive")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("是否缓存,0否,1是")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.MenuType)
- .HasColumnName("menu_type")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("菜单类型,0目录,1菜单,2按钮")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Name)
- .HasColumnName("name")
- .HasColumnType("varchar(32)")
- .HasComment("菜单名称")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.ParentId)
- .HasColumnName("parent_id")
- .HasComment("父菜单ID");
- entity.Property(e => e.Path)
- .HasColumnName("path")
- .HasColumnType("varchar(128)")
- .HasComment("路由路径")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Permission)
- .HasColumnName("permission")
- .HasColumnType("varchar(32)")
- .HasComment("权限标识")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.SortOrder)
- .HasColumnName("sort_order")
- .HasDefaultValueSql("'1'")
- .HasComment("排序值,越小越靠前");
- entity.Property(e => e.UpdateBy)
- .IsRequired()
- .HasColumnName("update_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("修改人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间")
- .ValueGeneratedOnAddOrUpdate();
- entity.Property(e => e.Visible)
- .HasColumnName("visible")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'1'")
- .HasComment("是否可见,0隐藏,1显示")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- });
- modelBuilder.Entity<SysOauthClientDetails>(entity =>
- {
- entity.ToTable("sys_oauth_client_details");
- entity.HasComment("终端信息表");
- entity.Property(e => e.Id)
- .HasColumnName("id")
- .HasComment("ID");
- entity.Property(e => e.AccessTokenValidity)
- .HasColumnName("access_token_validity")
- .HasComment("访问令牌有效期(秒)");
- entity.Property(e => e.AdditionalInformation)
- .HasColumnName("additional_information")
- .HasColumnType("varchar(4096)")
- .HasComment("附加信息")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Authorities)
- .HasColumnName("authorities")
- .HasColumnType("varchar(256)")
- .HasComment("权限集合")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.AuthorizedGrantTypes)
- .HasColumnName("authorized_grant_types")
- .HasColumnType("varchar(256)")
- .HasComment("授权类型")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Autoapprove)
- .HasColumnName("autoapprove")
- .HasColumnType("varchar(256)")
- .HasComment("自动授权")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.ClientId)
- .IsRequired()
- .HasColumnName("client_id")
- .HasColumnType("varchar(32)")
- .HasComment("客户端ID")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.ClientSecret)
- .HasColumnName("client_secret")
- .HasColumnType("varchar(256)")
- .HasComment("客户端秘钥")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.CreateBy)
- .IsRequired()
- .HasColumnName("create_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("创建人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("删除标记,0未删除,1已删除")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.RefreshTokenValidity)
- .HasColumnName("refresh_token_validity")
- .HasComment("刷新令牌有效期(秒)");
- entity.Property(e => e.ResourceIds)
- .HasColumnName("resource_ids")
- .HasColumnType("varchar(256)")
- .HasComment("资源ID集合")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Scope)
- .HasColumnName("scope")
- .HasColumnType("varchar(256)")
- .HasComment("授权范围")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.UpdateBy)
- .IsRequired()
- .HasColumnName("update_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("修改人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- entity.Property(e => e.WebServerRedirectUri)
- .HasColumnName("web_server_redirect_uri")
- .HasColumnType("varchar(256)")
- .HasComment("回调地址")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- });
- modelBuilder.Entity<SysPost>(entity =>
- {
- entity.HasKey(e => e.PostId)
- .HasName("PRIMARY");
- entity.ToTable("sys_post");
- entity.HasComment("岗位信息表");
- entity.Property(e => e.PostId)
- .HasColumnName("post_id")
- .HasComment("岗位ID");
- entity.Property(e => e.CreateBy)
- .IsRequired()
- .HasColumnName("create_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("''")
- .HasComment("创建人")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasComment("创建时间");
- entity.Property(e => e.DelFlag)
- .IsRequired()
- .HasColumnName("del_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("是否删除 -1:已删除 0:正常")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.PostCode)
- .IsRequired()
- .HasColumnName("post_code")
- .HasColumnType("varchar(64)")
- .HasComment("岗位编码")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.PostName)
- .IsRequired()
- .HasColumnName("post_name")
- .HasColumnType("varchar(50)")
- .HasComment("岗位名称")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.PostSort)
- .HasColumnName("post_sort")
- .HasComment("岗位排序");
- entity.Property(e => e.Remark)
- .HasColumnName("remark")
- .HasColumnType("varchar(500)")
- .HasComment("岗位描述")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.UpdateBy)
- .IsRequired()
- .HasColumnName("update_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("''")
- .HasComment("更新人")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间");
- });
- modelBuilder.Entity<SysPublicParam>(entity =>
- {
- entity.HasKey(e => e.PublicId)
- .HasName("PRIMARY");
- entity.ToTable("sys_public_param");
- entity.HasComment("公共参数配置表");
- entity.Property(e => e.PublicId)
- .HasColumnName("public_id")
- .HasComment("编号");
- entity.Property(e => e.CreateBy)
- .IsRequired()
- .HasColumnName("create_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("创建人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasDefaultValueSql("CURRENT_TIMESTAMP")
- .HasComment("创建时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("删除标记,0未删除,1已删除")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.PublicKey)
- .HasColumnName("public_key")
- .HasColumnType("varchar(128)")
- .HasComment("键")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.PublicName)
- .HasColumnName("public_name")
- .HasColumnType("varchar(128)")
- .HasComment("名称")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.PublicType)
- .HasColumnName("public_type")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("类型,0未知,1系统,2业务")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.PublicValue)
- .HasColumnName("public_value")
- .HasColumnType("varchar(128)")
- .HasComment("值")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Status)
- .HasColumnName("status")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("状态,0禁用,1启用")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.SystemFlag)
- .HasColumnName("system_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("系统标识,0非系统,1系统")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.UpdateBy)
- .IsRequired()
- .HasColumnName("update_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("修改人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间")
- .ValueGeneratedOnAddOrUpdate();
- entity.Property(e => e.ValidateCode)
- .HasColumnName("validate_code")
- .HasColumnType("varchar(64)")
- .HasComment("校验码")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- });
- modelBuilder.Entity<SysRole>(entity =>
- {
- entity.HasKey(e => e.RoleId)
- .HasName("PRIMARY");
- entity.ToTable("sys_role");
- entity.HasComment("系统角色表");
- entity.HasIndex(e => e.RoleCode)
- .HasName("role_idx1_role_code");
- entity.Property(e => e.RoleId)
- .HasColumnName("role_id")
- .HasComment("角色ID");
- entity.Property(e => e.CreateBy)
- .IsRequired()
- .HasColumnName("create_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("创建人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasDefaultValueSql("CURRENT_TIMESTAMP")
- .HasComment("创建时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("删除标记,0未删除,1已删除")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.RoleCode)
- .HasColumnName("role_code")
- .HasColumnType("varchar(64)")
- .HasComment("角色编码")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.RoleDesc)
- .HasColumnName("role_desc")
- .HasColumnType("varchar(255)")
- .HasComment("角色描述")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.RoleName)
- .HasColumnName("role_name")
- .HasColumnType("varchar(64)")
- .HasComment("角色名称")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.UpdateBy)
- .IsRequired()
- .HasColumnName("update_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("修改人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("更新时间")
- .ValueGeneratedOnAddOrUpdate();
- });
- modelBuilder.Entity<SysRoleMenu>(entity =>
- {
- entity.HasKey(e => new { e.RoleId, e.MenuId })
- .HasName("PRIMARY");
- entity.ToTable("sys_role_menu");
- entity.HasComment("角色菜单表");
- entity.Property(e => e.RoleId)
- .HasColumnName("role_id")
- .HasComment("角色ID");
- entity.Property(e => e.MenuId)
- .HasColumnName("menu_id")
- .HasComment("菜单ID");
- });
- modelBuilder.Entity<SysUser>(entity =>
- {
- entity.HasKey(e => e.UserId)
- .HasName("PRIMARY");
- entity.ToTable("sys_user");
- entity.HasComment("用户表");
- entity.HasIndex(e => e.QqOpenid)
- .HasName("user_qq_openid");
- entity.HasIndex(e => e.Username)
- .HasName("user_idx1_username");
- entity.HasIndex(e => e.WxOpenid)
- .HasName("user_wx_openid");
- entity.Property(e => e.UserId)
- .HasColumnName("user_id")
- .HasComment("用户ID");
- entity.Property(e => e.Avatar)
- .HasColumnName("avatar")
- .HasColumnType("varchar(255)")
- .HasComment("头像")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.CreateBy)
- .IsRequired()
- .HasColumnName("create_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("创建人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.CreateTime)
- .HasColumnName("create_time")
- .HasColumnType("datetime")
- .HasDefaultValueSql("CURRENT_TIMESTAMP")
- .HasComment("创建时间");
- entity.Property(e => e.DelFlag)
- .HasColumnName("del_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("删除标记,0未删除,1已删除")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.DeptId)
- .HasColumnName("dept_id")
- .HasComment("所属部门ID");
- entity.Property(e => e.Email)
- .HasColumnName("email")
- .HasColumnType("varchar(128)")
- .HasComment("邮箱地址")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.GiteeLogin)
- .HasColumnName("gitee_login")
- .HasColumnType("varchar(100)")
- .HasComment("码云标识")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.LockFlag)
- .HasColumnName("lock_flag")
- .HasColumnType("char(1)")
- .HasDefaultValueSql("'0'")
- .HasComment("锁定标记,0未锁定,9已锁定")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.MiniOpenid)
- .HasColumnName("mini_openid")
- .HasColumnType("varchar(32)")
- .HasComment("小程序openId")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Name)
- .HasColumnName("name")
- .HasColumnType("varchar(64)")
- .HasComment("姓名")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Nickname)
- .HasColumnName("nickname")
- .HasColumnType("varchar(64)")
- .HasComment("昵称")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.OscId)
- .HasColumnName("osc_id")
- .HasColumnType("varchar(100)")
- .HasComment("开源中国标识")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Password)
- .HasColumnName("password")
- .HasColumnType("varchar(255)")
- .HasComment("密码")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Phone)
- .HasColumnName("phone")
- .HasColumnType("varchar(20)")
- .HasComment("电话号码")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.QqOpenid)
- .HasColumnName("qq_openid")
- .HasColumnType("varchar(32)")
- .HasComment("QQ openId")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.Salt)
- .HasColumnName("salt")
- .HasColumnType("varchar(255)")
- .HasComment("盐值")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.UpdateBy)
- .IsRequired()
- .HasColumnName("update_by")
- .HasColumnType("varchar(64)")
- .HasDefaultValueSql("' '")
- .HasComment("修改人")
- .HasCharSet("utf8mb3")
- .HasCollation("utf8mb3_general_ci");
- entity.Property(e => e.UpdateTime)
- .HasColumnName("update_time")
- .HasColumnType("datetime")
- .HasComment("修改时间")
- .ValueGeneratedOnAddOrUpdate();
- entity.Property(e => e.Username)
- .HasColumnName("username")
- .HasColumnType("varchar(64)")
- .HasComment("用户名")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- entity.Property(e => e.WxOpenid)
- .HasColumnName("wx_openid")
- .HasColumnType("varchar(32)")
- .HasComment("微信登录openId")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_general_ci");
- });
- modelBuilder.Entity<SysUserPost>(entity =>
- {
- entity.HasKey(e => new { e.UserId, e.PostId })
- .HasName("PRIMARY");
- entity.ToTable("sys_user_post");
- entity.HasComment("用户与岗位关联表");
- entity.Property(e => e.UserId)
- .HasColumnName("user_id")
- .HasComment("用户ID");
- entity.Property(e => e.PostId)
- .HasColumnName("post_id")
- .HasComment("岗位ID");
- });
- modelBuilder.Entity<SysUserRole>(entity =>
- {
- entity.HasKey(e => new { e.UserId, e.RoleId })
- .HasName("PRIMARY");
- entity.ToTable("sys_user_role");
- entity.HasComment("用户角色表");
- entity.Property(e => e.UserId)
- .HasColumnName("user_id")
- .HasComment("用户ID");
- entity.Property(e => e.RoleId)
- .HasColumnName("role_id")
- .HasComment("角色ID");
- });
- modelBuilder.Entity<UndoLog>(entity =>
- {
- entity.HasNoKey();
- entity.ToTable("undo_log");
- entity.HasComment("AT transaction mode undo table");
- entity.HasIndex(e => e.LogCreated)
- .HasName("ix_log_created");
- entity.HasIndex(e => new { e.Xid, e.BranchId })
- .HasName("ux_undo_log")
- .IsUnique();
- entity.Property(e => e.BranchId)
- .HasColumnName("branch_id")
- .HasComment("branch transaction id");
- entity.Property(e => e.Context)
- .IsRequired()
- .HasColumnName("context")
- .HasColumnType("varchar(128)")
- .HasComment("undo_log context,such as serialization")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_0900_ai_ci");
- entity.Property(e => e.LogCreated)
- .HasColumnName("log_created")
- .HasComment("create datetime");
- entity.Property(e => e.LogModified)
- .HasColumnName("log_modified")
- .HasComment("modify datetime");
- entity.Property(e => e.LogStatus)
- .HasColumnName("log_status")
- .HasComment("0:normal status,1:defense status");
- entity.Property(e => e.RollbackInfo)
- .IsRequired()
- .HasColumnName("rollback_info")
- .HasComment("rollback info");
- entity.Property(e => e.Xid)
- .IsRequired()
- .HasColumnName("xid")
- .HasColumnType("varchar(128)")
- .HasComment("global transaction id")
- .HasCharSet("utf8mb4")
- .HasCollation("utf8mb4_0900_ai_ci");
- });
- OnModelCreatingPartial(modelBuilder);
- }
- partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
- }
- }
|