Table oc312.public.audit_user_login 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
id serial 10  √  nextval('audit_user_login_id_seq'::regclass)
study_module_status.id Implied Constraint R
user_name varchar 255  √  null
user_account_id int4 10  √  null
user_account.user_id fk_audit_user_login_id R
login_attempt_date timestamptz 35,6  √  null
login_status_code int4 10  √  null
version int4 10  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc pk_audit_user_login

Close relationships  within of separation: