Event

Defines the structure of the event table

Table

Name: events

Columns

id (Primary Key)

Description: The event unique identifier
Data Type: Unsigned bigint
Nullable: No

event_name

Description: The event’s name
Data Type: Varchar(255)
Nullable: No

event_cover_url

Description: The event’s cover image path
Data Type: Varchar(255)
Nullable: No

event_cover_preview_url

Description: The event’s cover preview image path
Data Type: Varchar(255)
Nullable: No

event_cover_total_size

Description: The event’s cover total size (mb)
Data Type: Decimal(8,2)
Nullable: No

event_cover_stored_locally

Description: The event cover is stored in the server storage
Data Type: Tinyint(1)
Nullable: No

Note

The images are stored in the server’s storage to cache them.

event_cover_uploaded_r2

Description: The event cover is uploaded in the CloudFlare R2 storage
Data Type: Tinyint(1)
Nullable: No

event_cover_last_access

Description: The event cover was last access
Data Type: Timestamp
Nullable: Yes

Note

This is used to clean up the server storage.

event_cover_preview_stored_locally

Description: The event cover preview is stored in the server storage
Data Type: Tinyint(1)
Nullable: No

Note

The images are stored in the server’s storage to cache them.

event_cover_preview_uploaded_r2

Description: The event cover preview is uploaded in the CloudFlare R2 storage
Data Type: Tinyint(1)
Nullable: No

event_cover_preview_last_access

Description: The event cover preview was last access
Data Type: Timestamp
Nullable: Yes

Note

This is used to clean up the server storage.

event_location

Description: The event’s location
Data Type: Varchar(255)
Nullable: No

event_location_longitude

Description: The longitude of the event’s location
Data Type: Varchar(100)
Nullable: Yes

event_location_latitude

Description: The latitude of the event’s location
Data Type: Varchar(100)
Nullable: Yes

event_start

Description: The start time of the event
Data Type: Timestamp
Nullable: Yes

event_end

Description: The end time of the event
Data Type: Timestamp
Nullable: Yes

event_details

Description: The description of the event
Data Type: Text
Nullable: No

event_photos_per_guest

Description: The number of photos that can be uploaded by the user to the event album
Data Type: Unsigned smallint
Nullable: Yes

event_media_reveal

Description: The condition when will the gallery will be revealed to the guests
Data Type: Unsigned tinyint
Nullable: No
Values:

• During - 1
• After - 2
• Hidden - 3

event_media_reveal_at

Description: The date and time on when the gallery will be revealed. This is required when the event_media_reveal value is After(2)
Data Type: Timestamp
Nullable: Yes

event_deleted_on

Description: The date and time on when the event will be deleted
Data Type: Timestamp
Nullable: Yes

event_cover_version

Description: The version of the event’s cover - Default: 1
Data Type: Integer
Nullable: No

event_visibility

Description: The visibility of the event
Data Type: Tinyint
Nullable: No
Value:

• Public - 1
• Private - 2

event_likes_count

Description: The count of users who like the event - Default: 0
Data Type: Unsigned integer
Nullable: No

event_og_version

Description: The version of the event information - Default: 1
Data Type: Unsigned integer
Nullable: No

Note

This is used to prevent the Open Graph image for sharing events from regenerating multiple times when the event name, address, start time, and end time are updated.

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