Table sem5.dbo.ADMINUSER
A list of reporting administrators.

Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
USER_ID char 32
USER_NAME nvarchar 510 ('') User name of the admin
DOMAIN_ID char 32 ('') GUID representing currently logged in domain.
AUTOREFRESH int 4 ((0)) User-defined auto refresh value for all logs (events.php, alerts.php)
LASTCHANGE int 4 (CONVERT([int],getdate(),0)) Last time that the user accessed the console
LASTSPMTIME int 4 (CONVERT([int],getdate(),0)) Last time for successful keep alive to application server

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
USER_ID Primary key Asc PK_ADMINUSER