Qin Zhe data table description-several important tables (2)

When we enter the qinzhe console, we will find a series of functions. The basic function of the qinzhe console is the core function of the system, and the system is maintained through a series of background services. This document briefly introduces several tables of system data and lists the fields used. Some fields are not commonly used by the system, and some of them do not know what to do for the time being. Please forgive me.

	Administrative ments
	Field	Description
	Deptname	Organization Department name
	Superdept	Superior department
	Path	Full path: record the full path of the Department ID
	Fullname	Full name
	Isorg	Whether it is an organizational unit
	Isouter	Whether it is an external organization
	Deptno	Department ID, root directory: _ root, external organization: _ out
	Deptid	Department ID
	Roles
	Field	Description
	Roleid	Automatic ID
	Rolename	Role name
	Roledesc	Role description
	Rolespec	This information is used by administrators report designer.
	Builtin	1: System Custom 0: User-defined role
	Creuid	Created
	Creuname	Creator name
	Createtime	Creation Time
	Upduid	Updated by ID
	Upduname	Updated by name
	Updtime	Update Time
	Othercanupd	Do other users have the permission to modify roles?
	Users
	Field	Description
	Userid	Unique User ID
	Deptid	Department ID
	Username	Unique User Name
	Userlogin	Unique User Login Name
	Userpwd	User Password
	Mobilephone	Mobile number
	Email	User email
	Lstlogin	Last login
	Isabstract
	Isrole
	Userdesc
	Usesms
	Usekey
	Defaultwin
	Movedirect
	Pwddate
	Accstate
	Lockdate
	Lgts
	Utype
	Domain
	Usertoken
	Isouter
	Company
	Address
	Zipcode
	Telephone
	Usedateobj
	Timeonwork
	Timeonreport
	Timeonreport
	Showfield
	Usetreeobj
	RTID
	Ldsname
	Lddn
	Iplist	Only logon IP addresses are allowed.
	Synlogin	1 indicates that multiple machines are allowed to log on at the same time. 0 indicates not allowed.