| Table s_login |
|
Description: Log file of all the log in attempts to the system |
| PRIMARY KEY | ||
|
s_login_process_id_r
integer NOT NULL | Petra process ID; this is a unique key | |
| UNIQUE KEY | ||
|
s_user_id_c
varchar (20) NOT NULL | This is the system user id. Each user of the system is allocated one. | |
|
s_login_time_i
integer default: 0 NOT NULL | The time a user logged in. | |
|
s_login_date_d
date NOT NULL | The date a user logged in. | |
|
s_login_tty_line_c
varchar (16) | This is the tty line on which the terminal is located on computer. | |
|
s_login_status_c
varchar (50) | Description of the login attempt. | |
|
s_logout_time_i
integer default: 0 | The time a user logged out. | |
|
s_logout_date_d
date | The date a user logged out. | |
|
s_date_created_d
date default: CURRENT_DATE | The date the record was created. | |
|
s_created_by_c
varchar (20) | User ID of who created this record. | s_user |
|
s_date_modified_d
date | The date the record was modified. | |
|
s_modified_by_c
varchar (20) | User ID of who last modified this record. | s_user |
|
s_modification_id_t
timestamp | This identifies the current version of the record. | |
FOREIGN KEY s_login_fkcr: s_created_by_c => s_user s_login_fkmd: s_modified_by_c => s_user | ||