Entity UserLogRec

Description of Entity UserLogRec

This entity would hold the record of each employee's login time stamp. With the login time, the master application administrator would know who accessed the application and will also tally with the audit trail or database log.


List of Attributes of the Entity UserLogRec

Name

Code

LogId ID

LogIdId

User Login ID

UserLoginId

UserLogin

UserLogin

UserLogout

UserLogout


Entity Attribute LogId ID of the Entity UserLogRec

Card of Attribute LogId ID of the Entity UserLogRec

Name

LogId ID

Code

LogIdId

Data Type

integer

Mandatory

Yes


Description of Attribute LogId ID of the Entity UserLogRec

This attribute holds the idenitity of the record. This attribute is a running number, therefore when a record is created, it would be inserted into a new record. It also holds the primary key for the UserLogRec table.


Entity Attribute User Login ID of the Entity UserLogRec

Card of Attribute User Login ID of the Entity UserLogRec

Name

User Login ID

Code

UserLoginId

Data Type

char(20)

Mandatory

No


Description of Attribute User Login ID of the Entity UserLogRec

This attribute would record the user identity for logging in to the application.


Entity Attribute UserLogin of the Entity UserLogRec

Card of Attribute UserLogin of the Entity UserLogRec

Name

UserLogin

Code

UserLogin

Data Type

timestamp

Mandatory

No


Description of Attribute UserLogin of the Entity UserLogRec

This attribute would record the time stamp that the user logs in to the application.


Entity Attribute UserLogout of the Entity UserLogRec

Card of Attribute UserLogout of the Entity UserLogRec

Name

UserLogout

Code

UserLogout

Data Type

timestamp

Mandatory

No


Description of Attribute UserLogout of the Entity UserLogRec

This attribute would record the timestamp of when the user logged out of the application.