Table ana6a.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_adoption_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_content.user_id Implied Constraint R
jivedw_content_stage.user_id Implied Constraint R
jivedw_content_summary.user_id Implied Constraint R
jivedw_external_user.user_id Implied Constraint R
jivedw_external_user_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_non_visible_user.user_id Implied Constraint R
jivedw_non_visible_user_stage.user_id Implied Constraint R
jivedw_object_user.user_id Implied Constraint R
jivedw_object_user_stage.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_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_views_summary.user_id Implied Constraint R
jivedw_userprofile.user_id Implied Constraint R
jivedw_userprofile_stage.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

Table contained 0 rows at Fri Aug 24 10:19 PDT 2012

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

Close relationships: