Table JiveCMR.public.jivedw_user Generated by
SchemaSpy
Legend: SourceForge.net
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 int8 19
jivedw_user_stage.user_id Implied Constraint R
firstname varchar 100  √  null
lastname varchar 100  √  null
name varchar 100  √  null
username varchar 100
userenabled int4 10
initlogin_ts timestamp 29,6  √  null
email varchar 100  √  null
creation_ts timestamp 29,6
modification_ts timestamp 29,6

Analyzed at Fri May 09 11:35 PDT 2014

Indexes:
Column(s) Type Sort Constraint Name
user_id Primary key Asc jivedw_user_pk
creation_ts Performance Asc jivedw_usr_cr_idx
modification_ts Performance Asc jivedw_usr_md_idx

Close relationships: