tbl_logindetail

24 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
loginid bigserial 19 √ nextval('tbl_logindetail_loginid_seq'::regclass)

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single login or user-related activity record.
username varchar 250 √ null

The username or ID used to attempt login.
Format: Varchar/Text
Usage: Stored for auditing login attempts, even if unsuccessful.
logintype varchar 50 √ null

The method or system used for login.
Format: Varchar/Lookup Key
Example: Web, MobileApp, SSO, API.
logindate timestamp 29,6 √ null

Timestamp of when the login attempt or activity occurred.
Stored as: UTC
Format: YYYY-MM-DDTHH:MM:SSZ
status bool 1 √ false

The outcome of the login attempt.
Format: Varchar/Lookup Key
Example: Success, Failure, Locked, ExpiredPassword.
component1 varchar 2147483647 √ null

Custom/Contextual Field 1
Usage: May store the IP Address of the user.
component2 varchar 2147483647 √ null

Custom/Contextual Field 2
Usage: May store the browser/user agent string.
component3 varchar 2147483647 √ null

Custom/Contextual Field 3
Usage: May store the city/region derived from the IP address.
component4 varchar 2147483647 √ null

Custom/Contextual Field 4
Usage: Generic usage field, possibly related to session ID or device type.
component5 varchar 2147483647 √ null

Custom/Contextual Field 5
Usage: Generic usage field, possibly related to two-factor authentication (2FA) status.
employeeid varchar 50 √ null

FK: public.tbl_employee.employeeid or similar
Meaning: The employee ID associated with the successful login attempt.
Logic: Null if the login failed or if the user is not an employee (e.g., a candidate).
datajson text 2147483647 √ null

Extended Audit Data
Format: JSONB/JSON
Usage: Flexible storage for non-standard login details, security tokens, or error messages in case of failure.

Indexes

Constraint Name Type Sort Column(s)
tbl_logindetail_pk_tbl_logindetail Primary key Asc loginid

Relationships

Close relationships within degrees of separation