| id |
bigint(20)
|
|
|
|
| company_id |
bigint(20)
|
|
|
|
| branch_id |
bigint(20)
|
|
|
|
| unit_id |
bigint(20)
|
|
|
|
| test_id |
bigint(20)
|
|
|
|
| attempt_id |
bigint(20)
|
|
|
|
| candidate_id |
bigint(20)
|
|
|
|
| student_id |
bigint(20)
|
|
|
|
| total_questions |
int(10)
|
|
|
|
| attempted_count |
int(10)
|
|
|
|
| correct_count |
int(10)
|
|
|
|
| incorrect_count |
int(10)
|
|
|
|
| unattempted_count |
int(10)
|
|
|
|
| positive_marks |
decimal(12,2)
|
|
|
|
| negative_marks |
decimal(12,2)
|
|
|
|
| bonus_adjustment |
decimal(12,2)
|
|
|
|
| score |
decimal(12,2)
|
|
|
|
| maximum_marks |
decimal(12,2)
|
|
|
|
| percentage |
decimal(8,4)
|
|
|
|
| percentile |
decimal(8,4)
|
|
|
|
| overall_rank |
int(10)
|
|
|
|
| branch_rank |
int(10)
|
|
|
|
| batch_rank |
int(10)
|
|
|
|
| class_rank |
int(10)
|
|
|
|
| accuracy_percentage |
decimal(8,4)
|
|
|
|
| total_time_seconds |
int(10)
|
|
|
|
| result_status |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| calculated_at |
datetime
|
|
|
|
| published_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|