tbl_album

5 rows


Description

Module: HRMS General (Communications/Internal)
Purpose: Stores configuration for photo albums used in internal portals (e.g., employee intranet, news/gallery section).
Data: Each row defines a photo album, including its display criteria, photo limits, and cover image.
Process Usage: - Used by the front-end application to display image galleries to employees.
- Criteria control who sees the album (e.g., specific departments, locations).
Key Points: - Centralizes management of internal media and communications.
- Controls display duration and visibility.
Business Impact: Enhances internal communication and employee engagement through visual content.

Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single master album record.
albumname varchar 50 √ null

The user-friendly name of the photo album (e.g., “Annual Gala,” “Team Outing 2025”).
Format: Varchar/Text.
photocount numeric 0 √ '20'::numeric

The total number of photos currently contained within the album.
Format: Integer.
displaystartdate date 13 √ null

The date from which the album should become visible/accessible to employees.
Format: Date.
displayenddate date 13 √ null

The date on which the album should automatically stop being displayed (expire).
Format: Date.
displayrotation numeric 0 √ null

Configuration setting for how photos within the album should rotate or be displayed (e.g., slide show speed).
Format: Varchar/Text.
albumdescription varchar 500 √ null

A detailed description or narrative about the event or purpose of the album.
Format: Text.
applicablecriteria varchar 2147483647 √ null

JSON or Text rule defining which employees or groups have permission to view this album (e.g., “Only employees in the Marketing Department”).
Format: JSONB/Text.
albumcoverphoto varchar 100 √ null

The ID or URL of the specific photo designated as the album cover/thumbnail.
Format: Varchar/Integer.
albummaxphoto numeric 0 √ '20'::numeric

The maximum number of photos allowed to be stored in this album.
Format: Integer.
status bool 1 √ null

The current lifecycle status of the album (e.g., Draft, Published, Archived).
Format: Varchar/Text.
createdby varchar 50 √ null

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

Timestamp of when the album record was created.
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 album record.
modifieddate timestamp 29,6 √ null

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

Indexes

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

Relationships

Close relationships within degrees of separation