Table openpetra_trunk.public.s_login
Log file of all the log in attempts to the system

 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
s_user_id_c varchar 20  √  null This is the system user id. Each user of the system is allocated one.
s_login_tty_line_c varchar 16  √  null This is the tty line on which the terminal is located on computer.
s_login_time_i int4 10 0 The time a user logged in.
s_login_date_d date 13 The date a user logged in.
s_login_status_c varchar 50  √  null Description of the login attempt.
s_logout_time_i int4 10  √  0 The time a user logged out.
s_logout_date_d date 13  √  null The date a user logged out.
s_login_process_id_r int4 10 Petra process ID; this is a unique key
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c s_login_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c s_login_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 0 rows at Do Nov 10 18:00 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
s_login_process_id_r Primary key Asc s_login_pk
s_created_by_c Performance Asc inx_s_login_fkcr_key2
s_modified_by_c Performance Asc inx_s_login_fkmd_key3
s_login_process_id_r Must be unique Asc inx_s_login_pk0
s_user_id_c + s_login_date_d + s_login_time_i Must be unique Asc/Asc/Asc inx_s_login_uk1
s_logout_date_d Performance Asc s_login_date0
s_user_id_c + s_login_date_d + s_login_time_i Must be unique Asc/Asc/Asc s_login_uk
s_user_id_c Performance Asc s_login_user1

Close relationships  within of separation: