| id |
int(11)
|
|
|
|
| name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| username |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| password |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| phone |
varchar(15)
|
utf8mb4_general_ci
|
|
|
| dob |
date
|
|
|
|
| address |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| pan_no |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| aadhar_no |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| profile_pic |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| aadhar_pic |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| token |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| user_type |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| status |
enum('ACTIVE', 'INACTIVE', 'LOGOUT', 'AUTO', 'BLOCKED', 'DELETED')
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| created_by |
int(11)
|
|
|
|
| updated_at |
timestamp
|
|
|
|
| updated_by |
int(11)
|
|
|
|