model

package
v0.0.0-...-7444d27 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Jun 4, 2024 License: Apache-2.0 Imports: 2 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type GenConfig 

type GenConfig struct {
	TableName          string `xorm:"not null pk comment('表名称') VARCHAR(64)"`
	ModuleName         string `xorm:"not null comment('模块名称') VARCHAR(60)"`
	PackageName        string `xorm:"not null comment('包名称') VARCHAR(60)"`
	BusinessName       string `xorm:"not null comment('业务名称') VARCHAR(50)"`
	Author             string `xorm:"not null comment('作者') VARCHAR(100)"`
	TablePrefix        string `xorm:"comment('表前缀') VARCHAR(20)"`
	IsOverride         int    `xorm:"not null default b'0' comment('是否覆盖') BIT(1)"`
	base.BaseTimeModel `xorm:"extends"`
}

GenConfig 生成配置表

type GenFieldConfig 

type GenFieldConfig struct {
	TableName          string `xorm:"not null comment('表名称') index VARCHAR(64)"`
	ColumnName         string `xorm:"not null comment('列名称') VARCHAR(64)"`
	ColumnType         string `xorm:"not null comment('列类型') VARCHAR(25)"`
	ColumnSize         int64  `xorm:"comment('列大小') BIGINT"`
	FieldName          string `xorm:"not null comment('字段名称') VARCHAR(64)"`
	FieldType          string `xorm:"not null comment('字段类型') VARCHAR(25)"`
	FieldSort          int    `xorm:"not null default 999 comment('字段排序') INT"`
	Comment            string `xorm:"comment('注释') VARCHAR(512)"`
	IsRequired         int    `xorm:"not null default b'1' comment('是否必填') BIT(1)"`
	ShowInList         int    `xorm:"not null default b'1' comment('是否在列表中显示') BIT(1)"`
	ShowInForm         int    `xorm:"not null default b'1' comment('是否在表单中显示') BIT(1)"`
	ShowInQuery        int    `xorm:"not null default b'1' comment('是否在查询中显示') BIT(1)"`
	FormType           uint   `xorm:"comment('表单类型') UNSIGNED TINYINT"`
	QueryType          uint   `xorm:"comment('查询方式') UNSIGNED TINYINT"`
	base.BaseTimeModel `xorm:"extends"`
}

GenFieldConfig 字段配置表

type SysAnnouncement 

type SysAnnouncement struct {
	Id                 int64     `xorm:"pk autoincr comment('ID') BIGINT"`
	Title              string    `xorm:"not null comment('标题') VARCHAR(150)"`
	Content            string    `xorm:"not null comment('内容') MEDIUMTEXT(16777215)"`
	Type               string    `xorm:"not null comment('类型') VARCHAR(30)"`
	EffectiveTime      time.Time `xorm:"comment('生效时间') DATETIME"`
	TerminateTime      time.Time `xorm:"comment('终止时间') DATETIME"`
	Sort               int       `xorm:"not null default 999 comment('排序') INT"`
	CreateUser         int64     `xorm:"not null comment('创建人') index BIGINT"`
	UpdateUser         int64     `xorm:"comment('修改人') index BIGINT"`
	base.BaseTimeModel `xorm:"extends"`
}

SysAnnouncement 公告表

type SysDept 

type SysDept struct {
	Id                 int64  `xorm:"pk autoincr comment('ID') BIGINT"`
	Name               string `xorm:"not null comment('名称') unique(uk_name_parent_id) VARCHAR(30)"`
	ParentId           int64  `xorm:"not null default 0 comment('上级部门ID') index unique(uk_name_parent_id) BIGINT"`
	Ancestors          string `xorm:"not null default '' comment('祖级列表') VARCHAR(512)"`
	Description        string `xorm:"comment('描述') VARCHAR(200)"`
	Sort               int    `xorm:"not null default 999 comment('排序') INT"`
	Status             uint   `xorm:"not null default 1 comment('状态（1：启用；2：禁用）') UNSIGNED TINYINT"`
	IsSystem           int    `xorm:"not null default b'0' comment('是否为系统内置数据') BIT(1)"`
	CreateUser         int64  `xorm:"not null comment('创建人') index BIGINT"`
	UpdateUser         int64  `xorm:"comment('修改人') index BIGINT"`
	base.BaseTimeModel `xorm:"extends"`
}

SysDept 部门表

type SysDict 

type SysDict struct {
	Id                 int64  `xorm:"pk autoincr comment('ID') BIGINT"`
	Name               string `xorm:"not null comment('名称') unique VARCHAR(30)"`
	Code               string `xorm:"not null comment('编码') unique VARCHAR(30)"`
	Description        string `xorm:"comment('描述') VARCHAR(200)"`
	IsSystem           int    `xorm:"not null default b'0' comment('是否为系统内置数据') BIT(1)"`
	CreateUser         int64  `xorm:"not null comment('创建人') BIGINT"`
	UpdateUser         int64  `xorm:"comment('修改人') BIGINT"`
	base.BaseTimeModel `xorm:"extends"`
}

SysDict 字典表

type SysDictItem 

type SysDictItem struct {
	Id                 int64  `xorm:"pk autoincr comment('ID') BIGINT"`
	Label              string `xorm:"not null comment('标签') VARCHAR(30)"`
	Value              string `xorm:"not null comment('值') unique(uk_value_dict_id) VARCHAR(30)"`
	Color              string `xorm:"comment('标签颜色') VARCHAR(30)"`
	Sort               int    `xorm:"not null default 999 comment('排序') INT"`
	Description        string `xorm:"comment('描述') VARCHAR(200)"`
	DictId             int64  `xorm:"not null comment('字典ID') index unique(uk_value_dict_id) BIGINT"`
	CreateUser         int64  `xorm:"not null comment('创建人') index BIGINT"`
	UpdateUser         int64  `xorm:"comment('修改人') index BIGINT"`
	base.BaseTimeModel `xorm:"extends"`
}

SysDictItem 字典项表

type SysFile 

type SysFile struct {
	Id                 int64  `xorm:"pk autoincr comment('ID') BIGINT"`
	Name               string `xorm:"not null comment('名称') VARCHAR(255)"`
	Size               int64  `xorm:"not null comment('大小（字节）') BIGINT"`
	Url                string `xorm:"not null comment('URL') index VARCHAR(512)"`
	Extension          string `xorm:"comment('扩展名') VARCHAR(100)"`
	Type               uint   `` /* 134-byte string literal not displayed */
	StorageId          int64  `xorm:"not null comment('存储库ID') BIGINT"`
	CreateUser         int64  `xorm:"not null comment('创建人') index BIGINT"`
	UpdateUser         int64  `xorm:"not null comment('修改人') index BIGINT"`
	base.BaseTimeModel `xorm:"extends"`
}

SysFile 文件

type SysLog 

type SysLog struct {
	Id                 int64  `xorm:"pk autoincr comment('ID') BIGINT"`
	TraceId            string `xorm:"comment('链路ID') VARCHAR(255)"`
	Description        string `xorm:"not null comment('日志描述') VARCHAR(255)"`
	Module             string `xorm:"not null comment('所属模块') index VARCHAR(50)"`
	RequestUrl         string `xorm:"not null comment('请求URL') VARCHAR(512)"`
	RequestMethod      string `xorm:"not null comment('请求方式') VARCHAR(10)"`
	RequestHeaders     string `xorm:"comment('请求头') TEXT(65535)"`
	RequestBody        string `xorm:"comment('请求体') TEXT(65535)"`
	StatusCode         int    `xorm:"not null comment('状态码') INT"`
	ResponseHeaders    string `xorm:"comment('响应头') TEXT(65535)"`
	ResponseBody       string `xorm:"comment('响应体') MEDIUMTEXT(16777215)"`
	TimeTaken          int64  `xorm:"not null comment('耗时（ms）') BIGINT"`
	Ip                 string `xorm:"comment('IP') index VARCHAR(100)"`
	Address            string `xorm:"comment('IP归属地') VARCHAR(255)"`
	Browser            string `xorm:"comment('浏览器') VARCHAR(100)"`
	Os                 string `xorm:"comment('操作系统') VARCHAR(100)"`
	Status             uint   `xorm:"not null default 1 comment('状态（1：成功；2：失败）') UNSIGNED TINYINT"`
	ErrorMsg           string `xorm:"comment('错误信息') TEXT(65535)"`
	CreateUser         int64  `xorm:"comment('创建人') BIGINT"`
	base.BaseTimeModel `xorm:"extends"`
}

SysLog 系统日志

type SysMenu 

type SysMenu struct {
	Id                 int64  `xorm:"pk autoincr comment('ID') BIGINT"`
	Title              string `xorm:"not null comment('标题') unique(uk_title_parent_id) VARCHAR(30)"`
	ParentId           int64  `xorm:"not null default 0 comment('上级菜单ID') index unique(uk_title_parent_id) BIGINT"`
	Type               uint   `xorm:"not null default 1 comment('类型（1：目录；2：菜单；3：按钮）') UNSIGNED TINYINT"`
	Path               string `xorm:"comment('路由地址') VARCHAR(255)"`
	Name               string `xorm:"comment('组件名称') VARCHAR(50)"`
	Component          string `xorm:"comment('组件路径') VARCHAR(255)"`
	Icon               string `xorm:"comment('图标') VARCHAR(50)"`
	IsExternal         int    `xorm:"not null default b'0' comment('是否外链') BIT(1)"`
	IsCache            int    `xorm:"not null default b'0' comment('是否缓存') BIT(1)"`
	IsHidden           int    `xorm:"not null default b'0' comment('是否隐藏') BIT(1)"`
	Permission         string `xorm:"comment('权限标识') VARCHAR(100)"`
	Sort               int    `xorm:"not null default 999 comment('排序') INT"`
	Status             uint   `xorm:"not null default 1 comment('状态（1：启用；2：禁用）') UNSIGNED TINYINT"`
	CreateUser         int64  `xorm:"not null comment('创建人') index BIGINT"`
	UpdateUser         int64  `xorm:"comment('修改人') index BIGINT"`
	base.BaseTimeModel `xorm:"extends"`
}

SysMenu 菜单表

type SysMessage 

type SysMessage struct {
	Id                 int64  `xorm:"pk autoincr comment('ID') BIGINT"`
	Title              string `xorm:"not null comment('标题') VARCHAR(50)"`
	Content            string `xorm:"comment('内容') VARCHAR(255)"`
	Type               uint   `xorm:"not null default 1 comment('类型（1：系统消息）') UNSIGNED TINYINT"`
	CreateUser         int64  `xorm:"comment('创建人') BIGINT"`
	base.BaseTimeModel `xorm:"extends"`
}

SysMessage 消息表

type SysMessageUser 

type SysMessageUser struct {
	MessageId int64     `xorm:"not null pk comment('消息ID') BIGINT"`
	UserId    int64     `xorm:"not null pk comment('用户ID') BIGINT"`
	IsRead    int       `xorm:"not null default b'0' comment('是否已读') BIT(1)"`
	ReadTime  time.Time `xorm:"comment('读取时间') DATETIME"`
}

SysMessageUser 消息用户关联表

type SysOption 

type SysOption struct {
	Name         string    `xorm:"not null comment('名称') VARCHAR(50)"`
	Code         string    `xorm:"not null pk comment('键') VARCHAR(100)"`
	Value        string    `xorm:"comment('值') TEXT(65535)"`
	DefaultValue string    `xorm:"comment('默认值') TEXT(65535)"`
	Description  string    `xorm:"comment('描述') VARCHAR(200)"`
	UpdateUser   int64     `xorm:"comment('修改人') BIGINT"`
	UpdateTime   time.Time `xorm:"updated comment('修改时间')"` // 更新时间

}

SysOption 系统配置表

type SysRole 

type SysRole struct {
	Id                 int64  `xorm:"pk autoincr comment('ID') BIGINT"`
	Name               string `xorm:"not null comment('名称') unique VARCHAR(30)"`
	Code               string `xorm:"not null comment('编码') unique VARCHAR(30)"`
	DataScope          int    `` /* 209-byte string literal not displayed */
	Description        string `xorm:"comment('描述') VARCHAR(200)"`
	Sort               int    `xorm:"not null default 999 comment('排序') INT"`
	Status             uint   `xorm:"not null default 1 comment('状态（1：启用；2：禁用）') UNSIGNED TINYINT"`
	IsSystem           int    `xorm:"not null default b'0' comment('是否为系统内置数据') BIT(1)"`
	CreateUser         int64  `xorm:"not null comment('创建人') index BIGINT"`
	UpdateUser         int64  `xorm:"comment('修改人') index BIGINT"`
	base.BaseTimeModel `xorm:"extends"`
}

SysRole 角色表

type SysRoleDept 

type SysRoleDept struct {
	RoleId int64 `xorm:"not null pk comment('角色ID') BIGINT"`
	DeptId int64 `xorm:"not null pk comment('部门ID') BIGINT"`
}

SysRoleDept 角色部门关联表

type SysRoleMenu 

type SysRoleMenu struct {
	RoleId int64 `xorm:"not null pk comment('角色ID') BIGINT"`
	MenuId int64 `xorm:"not null pk comment('菜单ID') BIGINT"`
}

SysRoleMenu 角色菜单关联表

type SysStorage 

type SysStorage struct {
	Id                 int64  `xorm:"pk autoincr comment('ID') BIGINT"`
	Name               string `xorm:"not null comment('名称') VARCHAR(100)"`
	Code               string `xorm:"not null comment('编码') unique VARCHAR(30)"`
	Type               uint   `xorm:"not null default 1 comment('类型（1：兼容S3协议存储；2：本地存储）') UNSIGNED TINYINT"`
	AccessKey          string `xorm:"comment('Access Key（访问密钥）') VARCHAR(255)"`
	SecretKey          string `xorm:"comment('Secret Key（私有密钥）') VARCHAR(255)"`
	Endpoint           string `xorm:"comment('Endpoint（终端节点）') VARCHAR(255)"`
	BucketName         string `xorm:"comment('桶名称') VARCHAR(255)"`
	Domain             string `xorm:"not null default '' comment('自定义域名') VARCHAR(255)"`
	Description        string `xorm:"comment('描述') VARCHAR(200)"`
	IsDefault          int    `xorm:"not null default b'0' comment('是否为默认存储') BIT(1)"`
	Sort               int    `xorm:"not null default 999 comment('排序') INT"`
	Status             uint   `xorm:"not null default 1 comment('状态（1：启用；2：禁用）') UNSIGNED TINYINT"`
	CreateUser         int64  `xorm:"not null comment('创建人') index BIGINT"`
	UpdateUser         int64  `xorm:"comment('修改人') index BIGINT"`
	base.BaseTimeModel `xorm:"extends"`
}

SysStorage 系统存储表

type SysUser 

type SysUser struct {
	Id                 int64     `xorm:"pk autoincr comment('ID') BIGINT"`
	Username           string    `xorm:"not null comment('用户名') unique VARCHAR(64)"`
	Nickname           string    `xorm:"not null comment('昵称') VARCHAR(30)"`
	Password           string    `xorm:"comment('密码') VARCHAR(255)"`
	Gender             uint      `xorm:"not null default 0 comment('性别（0：未知；1：男；2：女）') UNSIGNED TINYINT"`
	Email              string    `xorm:"comment('邮箱') unique VARCHAR(255)"`
	Phone              string    `xorm:"comment('手机号码') unique VARCHAR(255)"`
	Avatar             string    `xorm:"comment('头像地址') VARCHAR(255)"`
	Description        string    `xorm:"comment('描述') VARCHAR(200)"`
	Status             uint      `xorm:"not null default 1 comment('状态（1：启用；2：禁用）') UNSIGNED TINYINT"`
	IsSystem           int       `xorm:"not null default b'0' comment('是否为系统内置数据') BIT(1)"`
	PwdResetTime       time.Time `xorm:"comment('最后一次修改密码时间') DATETIME"`
	DeptId             int64     `xorm:"not null comment('部门ID') index BIGINT"`
	CreateUser         int64     `xorm:"comment('创建人') index BIGINT"`
	UpdateUser         int64     `xorm:"comment('修改人') index BIGINT"`
	base.BaseTimeModel `xorm:"extends"`
}

SysUser 系统用户表

type SysUserRole 

type SysUserRole struct {
	UserId int64 `xorm:"not null pk comment('用户ID') BIGINT"`
	RoleId int64 `xorm:"not null pk comment('角色ID') BIGINT"`
}

SysUserRole 用户角色关联表

type SysUserSocial 

type SysUserSocial struct {
	Source        string    `xorm:"not null pk comment('来源') unique(uk_source_open_id) VARCHAR(255)"`
	OpenId        string    `xorm:"not null pk comment('开放ID') unique(uk_source_open_id) VARCHAR(255)"`
	UserId        int64     `xorm:"not null comment('用户ID') BIGINT"`
	MetaJson      string    `xorm:"comment('附加信息') TEXT(65535)"`
	LastLoginTime time.Time `xorm:"comment('最后登录时间') DATETIME"`
	CreateTime    time.Time `xorm:"not null comment('创建时间') DATETIME"`
}

SysUserSocial 用户社交关联表

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.