View SIEM.public.users_rpt_v
The list of Sentinel users

 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
usr_id int4 10  √  null
users.usr_id Implied Constraint R
Id of the user 1-Admin
name varchar 64  √  null Short name
stt_id int4 10  √  null
states.stt_id Implied Constraint R
Ref ID of the Status Indicator of the user
description varchar 512  √  null Comments
date_created timestamptz 35,6  √  null Date the entry was created
date_modified timestamptz 35,6  √  null Date the entry was modified
created_by int4 10  √  null User who created object
modified_by int4 10  √  null User who last modified object
upper_name varchar 64  √  null User's Name in capital letter
auth_source varchar 32  √  null Authentication source
auth_dn varchar 256  √  null Authentication domain
system_user bool 1  √  null True if the user is system user
given_name varchar 64  √  null Entered user name
surname varchar 64  √  null Surname of the user
title varchar 128  √  null Title of the user
department varchar 128  √  null Department that user belongs to
phone varchar 64  √  null Contact number of the user
email varchar 255  √  null Emailid of the user
other varchar 64  √  null Any extra information of the user
cell varchar 64  √  null Mobile number of the user contact

Analyzed at Mon Mar 26 23:24 EDT 2012


Close relationships: