specifyuser

Table info.

Title Specify User
Description Specify User

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpecifyUserID int(11) PRI
TimestampCreated datetime Timestamp Created The timestamp the record was created.
TimestampModified datetime Timestamp Modified The timestamp the record was last modified.
Version int(11) Version version
AccumMinLoggedIn bigint(20) Accumulated Minutes Logged In accumMinLoggedIn
EMail varchar(64) Email email
IsLoggedIn bit(1) Is Logged In isLoggedIn
IsLoggedInReport bit(1) Is Logged In Report isLoggedInReport
LoginCollectionName varchar(64) Login Collection Name loginCollectionName
LoginDisciplineName varchar(64) Login Discipline Name loginDisciplineName
LoginOutTime datetime Login Out Time loginOutTime
Name varchar(64) UNI Name name
Password varchar(255) Password password
UserType varchar(32) User Group userType
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKD54E94AC5327F942 ModifiedByAgentID
FKD54E94AC7699B003 CreatedByAgentID
Name Name
PRIMARY SpecifyUserID

One-to-many relationships

Name Field Related table Related field
FK58743054BDD9E10 SpecifyUserID agent SpecifyUserID
FK8AF759237BF1F70B SpecifyUserID attachment VisibilitySetByID
FKFEB30F227BF1F70B SpecifyUserID collectingevent VisibilitySetByID
FKC1D4635D7BF1F70B SpecifyUserID collectionobject VisibilitySetByID
FK714BFD637BF1F70B SpecifyUserID locality VisibilitySetByID
notifications_mess_user_id_89f939e6_fk_specifyuser_specifyuserid SpecifyUserID notifications_message user_id
FK3B38A2714BDD9E10 SpecifyUserID recordset SpecifyUserID
FK96F9D2B24BDD9E10 SpecifyUserID spappresource SpecifyUserID
FK3A2F5C9B4BDD9E10 SpecifyUserID spappresourcedir SpecifyUserID
FK81E18B5E4BDD9E10 SpecifyUserID specifyuser_spprincipal SpecifyUserID
FK88FA7C8B4BDD9E10 SpecifyUserID spquery SpecifyUserID
FK972D69D14BDD9E10 SpecifyUserID spreport SpecifyUserID
FKF2333F2251039657 SpecifyUserID sptasksemaphore OwnerID
FK34BC5F0B4BDD9E10 SpecifyUserID spvisualquery SpecifyUserID
FK6908ECA7BF1F70B SpecifyUserID taxon VisibilitySetByID
FK41238DBF4BDD9E10 SpecifyUserID workbench SpecifyUserID
FK6F902B394BDD9E10 SpecifyUserID workbenchtemplate SpecifyUserID

Many-to-one relationships

Name Field Related table Related field
FKD54E94AC5327F942 ModifiedByAgentID agent AgentID
FKD54E94AC7699B003 CreatedByAgentID agent AgentID