tbl_albumphotohistory

-1 rows


Description

Module: HRMS Employee Engagement & Communication (Audit Log)
Purpose: Stores the historical, immutable audit log of all modifications, name changes, or deletions related to individual photos in the company albums.
Data: Contains a snapshot of the photo record at the time of the change, linking it back to the original photo and album.
Process Usage:
- Used for auditing and compliance to track who changed the name or removed a photo from an album and when.
- Provides a transparent history of media management within employee engagement features.
Key Points:
- Ensures accountability for media content management.
- The albumphotoid links the history record back to the current photo record.
Business Impact: Maintains a traceable record for all shared media content.

Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single historical event or action on a photo.
albumphotoid int8 19 √ null

FK: public.tbl_albumphoto.id
Meaning: The primary key of the master photo record that this history entry belongs to.
Dependency: Links the historical record back to its active photo record.
albumid int8 19 √ null

FK: Reference to a photo album master table
Meaning: The ID of the album to which the photo belonged at the time of this history event.
photoname varchar 100 √ null

A descriptive name or title given to the photo at the time of this history event.
Usage: Tracks changes to the photo’s title.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The user who performed the action (e.g., modified the name, deleted the photo) that created this history record.
createddate timestamp 29,6 √ null

Timestamp of when the historical record was created (i.e., when the modification or event occurred).
Format: Timestamp with timezone.
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The last user who modified the photo record before this history snapshot was taken (often same as createdby).
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the photo record before this history snapshot was taken.
Format: Timestamp with timezone.

Indexes

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

Relationships

Close relationships within degrees of separation