User

Defines the structure of the user’s table

Table

Name: user

Columns

id (Primary Key)

Description: The user’s unique identifier
Data Type: Unsigned bigint
Nullable: No

subscription_plan_id (Foreign Key)

Description: The current subscription plan of the user
Data Type: Unsigned bigint
Nullable: No
Table: Subscription Plan

user_username

Description: The user’s username
Data Type: Varchar(255)
Nullable: No

Note

The username is nullable because it was added later, but it is now required for new registrations.

Caution

The username can only be updated 60 days after the last change.

user_username_updated_at

Description: The username was last updated
Data Type: Timestamp
Nullable: Yes

user_email

Description: The user’s email
Data Type: Varchar(255)
Nullable: No

user_password

Description: The user’s password (encrypted)
Data Type: Varchar(255)
Nullable: Yes

remember_token

Description: Remember Token
Data Type: Varchar(100)
Nullable: Yes

Note

This is a default column added by Laravel, but it is not currently in use.

user_first_name

Description: The user’s first name
Data Type: Varchar(100)
Nullable: Yes

user_middle_name

Description: The user’s middle name
Data Type: Varchar(100)
Nullable: Yes

Note

This is not used in the current build of the application.

user_last_name

Description: The user’s last name
Data Type: Varchar(100)
Nullable: Yes

user_avatar_url

Description: The image path of the user’s avatar
Data Type: Varchar(255)
Nullable: Yes

user_avatar_size

Description: The user’s avatar size in mb
Data Type: Decimal(8,2) - Default: 0.00
Nullable: No

user_avatar_stored_locally

Description: The user’s avatar is stored locally on the server
Data Type: Tinyint(1) - Default: 0
Nullable: No

user_avatar_uploaded_r2

Description: The user’s avatar is uploaded in the CloudFlare R2 storage
Data Type: Tinyint(1) - Default: 0
Nullable: No

user_avatar_last_access

Description: The timestamp of the user’s last avatar access in server storage
Data Type: Timestamp
Nullable: Yes

user_email_verified_at

Description: The timestamp when the user’s email was verified
Data Type: Timestamp
Nullable: Yes

Note

This is a default column added by Laravel, but it is not currently in use.

user_status

Description: The user’s account status
Data Type: Unsigned tinyint - Default: 1
Nullable: No
Value:

• 1 - Active

Note

This column is not currently in use. It may be utilized if account deactivation functionality is implemented in the future.

user_avatar_version

Description: The version of the user avatar
Data Type: Integer - Default: 1
Nullable: No

Note

This is used for versioning the image to enable refetching it when caching occurs.

user_notification_count

Description: The total count of unread notifications for the user
Data Type: Integer - Default: 0
Nullable: No

user_visible

Description: Indicates whether the user’s account is publicly visible
Data Type: boolean - Default: 1
Nullable: No

user_timezone

Description: The user’s timezone
Data Type: Integer - Default: Etc/UTC
Nullable: No

user_pinged

Description: The timestamp of the user’s last ping using the PUT ably/ping endpoint
Data Type: Integer
Nullable: Yes

user_og_version

Description: The version of the user account
Data Type: Integer - Default: 1
Nullable: No

Note

This is used to check for updates to the Open Graph images used for sharing event and gallery images. Currently, it is utilized by a job to prevent multiple image regenerations.

user_deleted_on

Description: The timestamp indicating when the account will be deleted
Data Type: Timestamp
Nullable: Yes

Note

This is typically set 1 month prior to the account deletion.

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