| id |
int(11)
|
|
|
|
| user_id |
int(11)
|
|
|
|
| id_front |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| id_back |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| selfie |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| card_photo |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| status |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| admin_note |
text
|
utf8mb4_general_ci
|
|
|
| rejected_fields |
longtext
|
utf8mb4_bin
|
|
|
| reviewed_by |
int(11)
|
|
|
|
| reviewed_at |
datetime
|
|
|
|
| expires_at |
datetime
|
|
|
|
| deposit_id |
int(11)
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| ai_similarity |
decimal(5,2)
|
|
|
|
| ai_decision |
enum('approve', 'review', 'reject')
|
utf8mb4_general_ci
|
|
|
| ai_reason |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| ai_checked_at |
datetime
|
|
|
|
| id_full_name |
varchar(200)
|
utf8mb4_general_ci
|
|
|
| id_dob |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| id_number |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| id_number_hash |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| id_number_last4 |
varchar(4)
|
utf8mb4_general_ci
|
|
|
| id_expiry |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| id_doc_type |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| id_name_match |
tinyint(1)
|
|
|
|
| id_not_expired |
tinyint(1)
|
|
|
|
| id_warnings |
text
|
utf8mb4_general_ci
|
|
|
| is_voluntary |
tinyint(1)
|
|
|
|
