tbl_usertrackerimage

-1 rows


Description

Module: Attendance - Captured Image Storage
Purpose: Stores images captured from an employee (typically via a webcam or mobile camera) during login, logout, or at random intervals as part of a system designed for remote work compliance and attendance verification.
Data: Captures the unique ID of the image record and the Base64 encoded string of the actual image data.
Process Usage:
- Verification: Used to visually confirm the identity and presence of the employee during clock-in/out or while marked as “working.”
- Auditing: Provides a visual audit trail for attendance logs and can be tied back to specific clock-in/out events (though the linkage ID is implicitly handled through a related table or the audit fields).
Key Points:
- Sensitive Data: Contains personally identifiable data (PII) and requires strict security and retention policies.
- Base64 Storage: The image is stored as a large text string for database compatibility and retrieval.
Business Impact: Supports compliance and ensures accountability for time worked, particularly in remote or non-office environments.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('tbl_usertrackerimage_id_seq'::regclass)

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific captured image record.
imagebase64 varchar 2147483647 √ null

A large text column containing the actual image file, encoded in a Base64 string format for storage.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_usertrackerimage_pk__tbl_user__3214ec07e2c41d2a Primary key Asc id

Relationships

Close relationships within degrees of separation