tbl_albumphoto

-1 rows


Description

Module: HRMS Employee Engagement & Communication
Purpose: Stores the metadata and storage location (URL) for individual photos associated with different company albums (e.g., event photos, corporate gallery).
Data: Links each photo to its parent album and records descriptive information and audit timestamps.
Process Usage:
- Used by the employee self-service portal or internal social media feature to display image galleries.
- Provides the necessary data for rendering individual photos within a specific album context.
Key Points:
- Essential for internal communications and documenting company events.
- The photourl field points to the actual image file in cloud storage or a file server.
Business Impact: Enhances employee engagement and promotes a positive organizational culture through shared media.

Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single photo record.
albumid int8 19 √ null

FK: Reference to a photo album master table (e.g., tbl_albummaster)
Meaning: The ID of the album to which this photo belongs.
photoname varchar 100 √ null

A descriptive name or title given to the photo.
Format: Varchar/Text.
photourl varchar 100 √ null

The URL or file path where the actual image file is stored (e.g., S3 bucket link, internal server path).
Format: Varchar/Text.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The user who uploaded the photo.
createddate timestamp 29,6 √ null

Timestamp of when the photo record was created (i.e., when the photo was uploaded).
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 (e.g., changed the name).
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the photo record.
Format: Timestamp with timezone.

Indexes

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

Relationships

Close relationships within degrees of separation