Login Option

Defines the structure of the user’s login option table

Table

Name: user_login_options

Columns

id (Primary Key)

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

user_id (Foreign Key)

Description: The user’s login option
Data Type: Unsigned bigint
Nullable: No
Table: User

user_login_option_type

Description: The user’s login option type
Data Type: Unsigned tinyint
Nullable: No
Values:

• 1 - Capturit
• 2 - Google
• 3 - Facebook

user_login_option_unique_identifier

Description: The unique identifier of the third-party auth provider
Data Type: Varchar(255)
Nullable: Yes

Note

This is only used when the user_login_option_type value is not Capturit.

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