Table JiveAnalytics800.public.jivedw_user_stage 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_activity_agg_day.user_id Implied Constraint R
jivedw_activity_agg_month.user_id Implied Constraint R
jivedw_activity_agg_week.user_id Implied Constraint R
jivedw_activity_fact.user_id Implied Constraint R
jivedw_activity_stage.user_id Implied Constraint R
jivedw_activity_summary.user_id Implied Constraint R
jivedw_adoption_glb_summary.user_id Implied Constraint R
jivedw_adoption_grp_summary.user_id Implied Constraint R
jivedw_adoption_spc_summary.user_id Implied Constraint R
jivedw_answer.user_id Implied Constraint R
jivedw_answer_stage.user_id Implied Constraint R
jivedw_avatar_user.user_id Implied Constraint R
jivedw_avatar_user_stage.user_id Implied Constraint R
jivedw_blogpost_stats_stage.user_id Implied Constraint R
jivedw_comment.user_id Implied Constraint R
jivedw_comment_stage.user_id Implied Constraint R
jivedw_content.user_id Implied Constraint R
jivedw_content_glb_summary.user_id Implied Constraint R
jivedw_content_grp_summary.user_id Implied Constraint R
jivedw_content_spc_summary.user_id Implied Constraint R
jivedw_content_stage.user_id Implied Constraint R
jivedw_content_summary.user_id Implied Constraint R
jivedw_daily_glb_summary.user_id Implied Constraint R
jivedw_daily_grp_summary.user_id Implied Constraint R
jivedw_daily_spc_summary.user_id Implied Constraint R
jivedw_document_stats_stage.user_id Implied Constraint R
jivedw_groupuserhst.user_id Implied Constraint R
jivedw_groupuserhst_stage.user_id Implied Constraint R
jivedw_idea.user_id Implied Constraint R
jivedw_idea_stage.user_id Implied Constraint R
jivedw_invite.user_id Implied Constraint R
jivedw_invite_stage.user_id Implied Constraint R
jivedw_object_user.user_id Implied Constraint R
jivedw_object_user_stage.user_id Implied Constraint R
jivedw_places_summary.user_id Implied Constraint R
jivedw_poll.user_id Implied Constraint R
jivedw_poll_stage.user_id Implied Constraint R
jivedw_project.user_id Implied Constraint R
jivedw_project_stage.user_id Implied Constraint R
jivedw_question.user_id Implied Constraint R
jivedw_question_stage.user_id Implied Constraint R
jivedw_question_summary.user_id Implied Constraint R
jivedw_statuslevelpnt.user_id Implied Constraint R
jivedw_statuslevelpnt_stage.user_id Implied Constraint R
jivedw_temp_user.user_id Implied Constraint R
jivedw_user.user_id Implied Constraint R
jivedw_user_init_summary.user_id Implied Constraint R
jivedw_user_points_summary.user_id Implied Constraint R
jivedw_user_rel.user_id Implied Constraint R
jivedw_user_rel_stage.user_id Implied Constraint R
jivedw_user_status.user_id Implied Constraint R
jivedw_user_status_stage.user_id Implied Constraint R
jivedw_user_summary.user_id Implied Constraint R
jivedw_user_type.user_id Implied Constraint R
jivedw_user_type_stage.user_id Implied Constraint R
jivedw_userprofile.user_id Implied Constraint R
jivedw_userprofile_clear_stage.user_id Implied Constraint R
jivedw_userprofile_stage.user_id Implied Constraint R
jivedw_users_glb_summary.user_id Implied Constraint R
jivedw_users_grp_summary.user_id Implied Constraint R
jivedw_users_spc_summary.user_id Implied Constraint R
jivedw_video.user_id Implied Constraint R
jivedw_video_stage.user_id Implied Constraint R
firstname varchar 100  √  null
lastname varchar 100  √  null
name varchar 100  √  null
username varchar 100
userenabled int4 10
email varchar 100  √  null
creation_ts timestamp 29,6
modification_ts timestamp 29,6
last_logged_in timestamp 29,6

Analyzed at Mon Apr 27 15:39 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
user_id Primary key Asc jivedw_user_stg_pk

Close relationships: