Event Photo

Defines the structure of the event photo table

Note

To avoid refactoring the entire codebase and the tables, the event_photos table includes video files, which can be identified using the event_photo_media_type field.

• The event_photo_url field contains the path to the media file. The file can be either an image or a video.
• The event_photo_preview_url field contains a preview of the image or a thumbnail of the video.

Table

Name: event_photos

Columns

id (Primary Key)

Description: The unique identifier for the event_photos table
Data Type: Unsigned bigint
Nullable: No

user_id (Foreign Key)

Description: The user unique identifier
Data Type: Unsigned bigint
Nullable: No
Table: User

event_photo_url

Description: The file path or URL of the gallery image or video
Data Type: Varchar(255)
Nullable: No

event_photo_preview_url

Description: The file path or URL of the gallery preview image or video thumbnail
Data Type: Varchar(255)
Nullable: No

event_photo_media_type

Description: Indicates the media file type
Data Type: Unsigned tinyint
Nullable: No
Values:

• Image - 1
• Video - 2

event_photo_total_size

Description: The size of the gallery image, measured in megabytes (MB)
Data Type: Decimal(8,2)
Nullable: No

event_photo_stored_locally

Description: Indicates whether the gallery image is stored locally on the server
Data Type: Tinyint(1) - Default: 0
Nullable: No

event_photo_uploaded_r2

Description: Indicates whether the gallery image is uploaded to Cloudflare R2
Data Type: Tinyint(1) - Default: 0
Nullable: No

event_photo_last_access

Description: The date and time when the gallery photo was last accessed
Data Type: Timestamp
Nullable: Yes

Note

Used to determine when to clean up images from the server.

event_photo_preview_stored_locally

Description: Indicates whether the gallery preview image is stored locally on the server
Data Type: Tinyint(1) - Default: 0
Nullable: No

event_photo_preview_uploaded_r2

Description: Indicates whether the gallery preview image is uploaded to Cloudflare R2
Data Type: Tinyint(1) - Default: 0
Nullable: No

event_photo_preview_last_access

Description: The date and time when the gallery preview photo was last accessed
Data Type: Timestamp
Nullable: Yes

Note

Used to determine when to clean up images from the server.

event_photo_likes_count

Description: The total number of likes on the photo
Data Type: Integer - Default: 0
Nullable: No

event_photo_comments_count

Description: The total number of comments on the photo
Data Type: Integer - Default: 0
Nullable: No

created_at

Description: The timestamp when the record is created
Data Type: Timestamp
Nullable: Yes

updated_at

Description: The timestamp when the record is updated
Data Type: Timestamp
Nullable: Yes