Table oc312.public.user_account 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 serial 10  √  nextval('user_account_user_id_seq'::regclass)
audit_user_login.user_account_id fk_audit_user_login_id R
crf.owner_id fk_crf_crf_user_user_acc R
crf_version.owner_id fk_crf_vers_crf_versi_user_acc R
dataset.owner_id fk_dataset_fk_datase_user_acc R
decision_condition.owner_id fk_decision_fk_decisi_user_acc R
discrepancy_note.assigned_user_id discrepancy_note_asn_u_id_fkey R
discrepancy_note.owner_id discrepancy_note_owner_id_fkey R
event_crf.owner_id fk_event_cr_fk_event__user_acc R
event_definition_crf.owner_id fk_event_de_study_crf_user_acc R
filter.owner_id fk_filter_fk_query__user_acc R
item.owner_id fk_item_fk_item_u_user_acc R
item_data.owner_id fk_item_dat_fk_item_d_user_acc R
item_group.owner_id fk_item_gro_fk_item_g_user_acc R
section.owner_id fk_section_fk_sectio_user_acc R
study.owner_id fk_study_fk_study__user_acc R
study_event.owner_id fk_study_ev_fk_study__user_acc R
study_event_definition.owner_id fk_study_ev_fk_studye_user_acc R
study_group_class.owner_id fk_study_gr_fk_study__user_acc R
study_subject.owner_id fk_study_su_fk_study__user_acc R
study_user_role.owner_id fk_study_us_study_use_user_acc R
subject.owner_id fk_subject_fk_subjec_user_acc R
subject_group_map.owner_id fk_subject__fk_sub_gr_user_acc R
user_account.owner_id fk_user_acc_fk_user_f_user_acc R
user_name varchar 64  √  null
passwd varchar 255  √  null
first_name varchar 50  √  null
last_name varchar 50  √  null
email varchar 120  √  null
active_study int4 10  √  null
institutional_affiliation varchar 255  √  null
status_id int4 10  √  null
status.status_id fk_user_acc_status_re_status R
owner_id int4 10  √  null
user_account.user_id fk_user_acc_fk_user_f_user_acc R
date_created date 13  √  null
date_updated date 13  √  null
date_lastvisit timestamptz 35,6  √  null
passwd_timestamp date 13  √  null
passwd_challenge_question varchar 64  √  null
passwd_challenge_answer varchar 255  √  null
phone varchar 64  √  null
user_type_id int4 10  √  null
user_type.user_type_id fk_user_acc_ref_user__user_typ R
update_id int4 10  √  null
enabled bool 1 true
account_non_locked bool 1 true
lock_counter int4 10 0
run_webservices bool 1 false

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
user_id Primary key Asc pk_user_account
user_name Performance Asc i_user_account_user_name

Close relationships  within of separation: