| id |
bigint(20)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| username |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| password |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| profile_image |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| balance |
decimal(10,2)
|
|
|
|
| role |
enum('ADMIN', 'MEMBER', 'MODERATOR', 'RESELLER')
|
utf8mb4_unicode_ci
|
|
|
| status |
enum('ACTIVE', 'INACTIVE')
|
utf8mb4_unicode_ci
|
|
|
| mobile_number |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| sms_otp_phone |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| line_id |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| remember_token |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| permissions |
longtext
|
utf8mb4_bin
|
|
|
| position_id |
int(11)
|
|
|
|
| two_factor_secret |
longtext
|
utf8mb4_unicode_ci
|
|
|
| two_factor_recovery_codes |
longtext
|
utf8mb4_unicode_ci
|
|
|
| two_factor_confirmed_at |
timestamp
|
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|