{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["日志表","用户表","密码表","角色表"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"日志表","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["TblLogrecords"]
["字段显示名称","字段代号","字段类型","字段长度","必填","主键","备注"]
["ID","Id","int",null,"Y","Y","数据库自增"]
["日志日期","LogDate","datetime",null,"Y"]
["日志等级","LogLevel","nvarchar",50,"Y"]
["记录器","Logger","nvarchar",256,"Y"]
["信息","Message","nvarchar","max"]
["异常","Exception","nvarchar","max"]
["机器名","MachineName","nvarchar",50]
["机器ip地址","MachineIp","nvarchar",50]
["请求方法","NetRequestMethod","nvarchar",10]
["请求url","NetRequestUrl","nvarchar",500]
["用户是否认证","NetUserIsauthenticated","int",null,null,null,"0-未认证，1-认证"]
["用户认证类型","NetUserAuthtype","nvarchar",50]
["用户ID","NetUserIdentity","nvarchar",50]

{"sheet":"用户表","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["TblUsers"]
["字段显示名称","字段代号","字段类型","字段长度","必填","主键","备注"]
["ID","Id","long",null,"Y","Y"]
["账号","Account","nvarchar",16,"Y",null,"索引不可更改，长度在4-16之间，只能包含字符、数字和下划线"]
["姓名","Name","nvarchar",50,"Y"]
["邮箱","Email","nvarchar",100]
["电话","Phone","nvarchar",25]
["角色","RoleId","int",null,"Y",null,"角色表外键，由导航属性决定"]
["状态码","StatusCode","bit",null,"Y"]
["创建者","Creator","long",null,"Y"]
["创建时间","CreateTime","datetime",null,"Y"]
["修改者","Modifier","long"]
["修改时间","ModifyTime","datetime"]

{"sheet":"密码表","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["TblUserLogins"]
["字段显示名称","字段代号","字段类型","字段长度","必填","主键","备注"]
["账号","Account","nvarchar",16,"Y","Y"]
["用户ID","UserId","long",null,"Y",null,"用户表外键由导航属性决定"]
["哈希密码","HashedPassword","nvarchar",256,"Y",null,"密码长度不超过16位"]
["最后登录时间","LastLoginTime","datetime"]
["登录失败次数","AccessFailedCount","int",null,"Y",null,"默认0"]
["是否锁定","IsLocked","bit",null,"Y",null,"映射该账号是否被锁定，例如账号异常、登录失败次数过多"]
["锁定时间","LockedTime","datetime"]

{"sheet":"角色表","index":3,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["TblRoles"]
["字段显示名称","字段代号","字段类型","字段长度","必填","主键","备注"]
["ID","Id","long",null,"Y","Y"]
["角色名称","Name","nvarchar",16,"Y",null,"索引不可更改，长度在4-16之间，只能包含字符、数字和下划线"]
["显示名称","DisplayName","nvarchar",50,"Y",null,"显示出来的名称"]
["备注","Remark","nvarchar",4000]
["状态码","StatusCode","bit",null,"Y"]
["创建者","Creator","long",null,"Y"]
["创建时间","CreateTime","datetime",null,"Y"]
["修改者","Modifier","long"]
["修改时间","ModifyTime","datetime"]