ai.surenasolutions.in / 127.0.0.1 / competitive_exam

There are no favorite tables.

New
aiskgl
competitive_exam
- competitive_exam
- competitive_exam_qa
edbroad
- ai
  - edbroad_ai
  - edbroad_ai_sumanth
- edbroad_phonepe_standard
fee_fay_india
information_schema
mysql
omr
- omr_platform
- omr_web
performance_schema
phpmyadmin
rajkamal_crm
- rajkamal_crm
- rajkamal_crm_schema_backup_20260919
scoobyai
sgm_crm
surena
- crm
  - surena_crm
  - surena_crm_control
- support
  - surena_support
  - surena_support_sjcebt
test
whatsapp_platform

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Untitled *

v		competitive_exam ce_attempts
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
test_id : bigint(20) unsigned
candidate_id : bigint(20) unsigned
student_id : bigint(20) unsigned
user_id : bigint(20) unsigned
academic_year_id : bigint(20) unsigned
class_id : bigint(20) unsigned
section_id : bigint(20) unsigned
batch_id : bigint(20) unsigned
eligibility_assignment_id : bigint(20) unsigned
attempt_no : int(10) unsigned
attempt_token : varchar(128)
status : varchar(30)
started_at : datetime
expires_at : datetime
last_activity_at : datetime
last_heartbeat_at : datetime
submitted_at : datetime
auto_submitted_at : datetime
locked_at : datetime
submit_reason : varchar(40)
resume_count : int(10) unsigned
client_ip : varchar(45)
user_agent : varchar(500)
device_identifier : varchar(180)
current_attempt_question_id : bigint(20) unsigned
total_time_seconds : int(10) unsigned
scoring_status : varchar(30)
created_at : datetime
updated_at : datetime

v		competitive_exam ce_attempt_answers
id : bigint(20) unsigned
attempt_id : bigint(20) unsigned
attempt_question_id : bigint(20) unsigned
test_id : bigint(20) unsigned
section_id : bigint(20) unsigned
question_id : bigint(20) unsigned
question_version_id : bigint(20) unsigned
selected_option_id : bigint(20) unsigned
selected_option_ids_json : longtext
answer_value : varchar(500)
answer_status : varchar(40)
is_marked_for_review : tinyint(1)
answered_at : datetime
first_saved_at : datetime
last_saved_at : datetime
answer_change_count : int(10) unsigned
answer_revision : int(10) unsigned
is_correct : tinyint(1)
marks_awarded : decimal(10,2)
evaluated_at : datetime
created_at : datetime
updated_at : datetime

v		competitive_exam ce_attempt_answer_history
id : bigint(20) unsigned
attempt_id : bigint(20) unsigned
attempt_question_id : bigint(20) unsigned
question_version_id : bigint(20) unsigned
answer_revision : int(10) unsigned
selected_option_id : bigint(20) unsigned
selected_option_ids_json : longtext
answer_value : varchar(500)
answer_status : varchar(40)
is_marked_for_review : tinyint(1)
saved_at : datetime

v		competitive_exam ce_attempt_events
id : bigint(20) unsigned
attempt_id : bigint(20) unsigned
test_id : bigint(20) unsigned
candidate_id : bigint(20) unsigned
attempt_question_id : bigint(20) unsigned
question_id : bigint(20) unsigned
event_type : varchar(60)
event_data : longtext
event_at : datetime
client_ip : varchar(45)
device_identifier : varchar(180)

v		competitive_exam ce_attempt_interventions
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
test_id : bigint(20) unsigned
attempt_id : bigint(20) unsigned
candidate_id : bigint(20) unsigned
intervention_type : varchar(40)
reason : varchar(1000)
previous_status : varchar(30)
new_status : varchar(30)
performed_by : bigint(20) unsigned
performed_at : datetime
client_ip : varchar(45)
user_agent : varchar(500)

v		competitive_exam ce_attempt_questions
id : bigint(20) unsigned
attempt_id : bigint(20) unsigned
test_id : bigint(20) unsigned
test_question_id : bigint(20) unsigned
section_id : bigint(20) unsigned
question_id : bigint(20) unsigned
question_version_id : bigint(20) unsigned
attempt_question_number : int(10) unsigned
section_question_number : int(10) unsigned
option_order_json : longtext
positive_marks : decimal(8,2)
negative_marks : decimal(8,2)
question_state : varchar(40)
is_marked_for_review : tinyint(1)
first_viewed_at : datetime
last_viewed_at : datetime
visit_count : int(10) unsigned
time_spent_seconds : int(10) unsigned
created_at : datetime
updated_at : datetime

v		competitive_exam ce_audit_logs
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
user_id : bigint(20) unsigned
module_name : varchar(80)
action_name : varchar(80)
entity_type : varchar(80)
entity_id : bigint(20) unsigned
old_data : longtext
new_data : longtext
client_ip : varchar(45)
user_agent : varchar(500)
created_at : datetime

v		competitive_exam ce_blueprints
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
exam_profile_id : bigint(20) unsigned
blueprint_code : varchar(80)
blueprint_name : varchar(180)
description : text
default_seed : varchar(80)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_blueprint_generations
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
blueprint_id : bigint(20) unsigned
test_id : bigint(20) unsigned
generation_token : varchar(64)
seed_value : varchar(80)
status : varchar(30)
total_questions : int(10) unsigned
total_marks : decimal(12,2)
validation_json : longtext
created_by : bigint(20) unsigned
applied_by : bigint(20) unsigned
created_at : datetime
applied_at : datetime
updated_at : datetime

v		competitive_exam ce_blueprint_generation_questions
id : bigint(20) unsigned
generation_id : bigint(20) unsigned
test_id : bigint(20) unsigned
section_id : bigint(20) unsigned
blueprint_rule_id : bigint(20) unsigned
question_id : bigint(20) unsigned
question_version_id : bigint(20) unsigned
sequence_no : int(10) unsigned
section_sequence_no : int(10) unsigned
positive_marks : decimal(8,2)
negative_marks : decimal(8,2)
created_at : datetime

v		competitive_exam ce_blueprint_rules
id : bigint(20) unsigned
blueprint_id : bigint(20) unsigned
subject_id : bigint(20) unsigned
chapter_id : bigint(20) unsigned
topic_id : bigint(20) unsigned
difficulty_level : varchar(20)
question_type : varchar(40)
question_source : varchar(40)
source_year_min : smallint(5) unsigned
source_year_max : smallint(5) unsigned
max_prior_usage : int(11)
min_days_since_used : int(11)
target_count : int(10) unsigned
priority_order : int(11)
is_active : tinyint(1)
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_candidates
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
student_id : bigint(20) unsigned
user_id : bigint(20) unsigned
academic_year_id : bigint(20) unsigned
class_id : bigint(20) unsigned
section_id : bigint(20) unsigned
batch_id : bigint(20) unsigned
candidate_code : varchar(80)
candidate_name : varchar(180)
mobile : varchar(30)
email : varchar(180)
source_type : varchar(40)
source_reference_id : varchar(120)
integration_key : varchar(190)
source_sync_hash : char(64)
source_updated_at : datetime
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_chapters
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
subject_id : bigint(20) unsigned
class_level : varchar(40)
syllabus_version : varchar(60)
chapter_code : varchar(80)
chapter_name : varchar(180)
display_order : int(11)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_exam_profiles
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
profile_code : varchar(60)
profile_name : varchar(150)
exam_family : varchar(60)
description : text
default_duration_minutes : int(10) unsigned
default_positive_marks : decimal(8,2)
default_negative_marks : decimal(8,2)
allow_question_navigation : tinyint(1)
allow_mark_for_review : tinyint(1)
allow_answer_change : tinyint(1)
randomize_questions : tinyint(1)
randomize_options : tinyint(1)
show_result_immediately : tinyint(1)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_exam_profile_rules
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
exam_profile_id : bigint(20) unsigned
rule_key : varchar(100)
rule_value : text
rule_type : varchar(30)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_exam_profile_subjects
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
exam_profile_id : bigint(20) unsigned
subject_id : bigint(20) unsigned
section_name : varchar(150)
question_count : int(10) unsigned
duration_minutes : int(10) unsigned
positive_marks : decimal(8,2)
negative_marks : decimal(8,2)
display_order : int(11)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_integration_sync_logs
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
entity_type : varchar(50)
source_id : bigint(20) unsigned
candidate_id : bigint(20) unsigned
sync_action : varchar(30)
sync_status : varchar(30)
message : varchar(500)
payload_hash : char(64)
performed_by : bigint(20) unsigned
created_at : datetime

v		competitive_exam ce_mt_academic_years
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
year_code : varchar(40)
year_name : varchar(100)
start_date : date
end_date : date
is_current : tinyint(1)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_mt_batches
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
academic_year_id : bigint(20) unsigned
batch_code : varchar(60)
batch_name : varchar(120)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_mt_branches
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_code : varchar(60)
branch_name : varchar(180)
email : varchar(180)
mobile : varchar(40)
address_text : varchar(500)
timezone : varchar(80)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_mt_classes
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
academic_year_id : bigint(20) unsigned
class_code : varchar(40)
class_name : varchar(100)
display_order : int(11)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_mt_companies
id : bigint(20) unsigned
company_code : varchar(60)
company_name : varchar(180)
legal_name : varchar(220)
email : varchar(180)
mobile : varchar(40)
timezone : varchar(80)
status : varchar(20)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_mt_login_audit
id : bigint(20) unsigned
user_id : bigint(20) unsigned
username_attempted : varchar(180)
event_type : varchar(40)
success : tinyint(1)
message : varchar(500)
client_ip : varchar(45)
user_agent : varchar(500)
created_at : datetime

v		competitive_exam ce_mt_password_reset_tokens
id : bigint(20) unsigned
user_id : bigint(20) unsigned
token_hash : char(64)
expires_at : datetime
used_at : datetime
requested_by : bigint(20) unsigned
created_at : datetime

v		competitive_exam ce_mt_permissions
id : bigint(20) unsigned
permission_key : varchar(120)
permission_name : varchar(180)
permission_group : varchar(80)
description : varchar(500)
is_system : tinyint(1)
display_order : int(11)
created_at : datetime

v		competitive_exam ce_mt_roles
id : bigint(20) unsigned
company_id : bigint(20) unsigned
role_code : varchar(60)
role_name : varchar(150)
description : varchar(500)
is_system : tinyint(1)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_mt_role_permissions
id : bigint(20) unsigned
role_id : bigint(20) unsigned
permission_key : varchar(120)
is_allowed : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime

v		competitive_exam ce_mt_sections
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
academic_year_id : bigint(20) unsigned
class_id : bigint(20) unsigned
section_code : varchar(40)
section_name : varchar(100)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_mt_units
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_code : varchar(60)
unit_name : varchar(180)
unit_type : varchar(60)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_mt_users
id : bigint(20) unsigned
username : varchar(100)
email : varchar(180)
mobile : varchar(40)
display_name : varchar(180)
password_hash : varchar(255)
user_type : varchar(30)
candidate_id : bigint(20) unsigned
is_active : tinyint(1)
failed_login_count : int(10) unsigned
locked_until : datetime
last_login_at : datetime
last_login_ip : varchar(45)
password_changed_at : datetime
must_change_password : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_mt_user_scopes
id : bigint(20) unsigned
user_id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
role_id : bigint(20) unsigned
is_default : tinyint(1)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_practice_sessions
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
candidate_id : bigint(20) unsigned
student_id : bigint(20) unsigned
exam_profile_id : bigint(20) unsigned
source_test_id : bigint(20) unsigned
practice_type : varchar(40)
session_token : varchar(128)
session_title : varchar(180)
subject_id : bigint(20) unsigned
chapter_id : bigint(20) unsigned
topic_id : bigint(20) unsigned
difficulty_filter : varchar(20)
requested_question_count : int(10) unsigned
total_questions : int(10) unsigned
attempted_count : int(10) unsigned
correct_count : int(10) unsigned
incorrect_count : int(10) unsigned
unattempted_count : int(10) unsigned
score : decimal(12,2)
maximum_marks : decimal(12,2)
accuracy_percentage : decimal(8,4)
current_sequence_no : int(10) unsigned
status : varchar(30)
started_at : datetime
last_activity_at : datetime
completed_at : datetime
created_at : datetime
updated_at : datetime

v		competitive_exam ce_practice_session_answers
id : bigint(20) unsigned
session_id : bigint(20) unsigned
session_question_id : bigint(20) unsigned
question_id : bigint(20) unsigned
question_version_id : bigint(20) unsigned
selected_option_id : bigint(20) unsigned
selected_option_ids_json : longtext
answer_value : varchar(500)
answer_revision : int(10) unsigned
answer_status : varchar(40)
is_correct : tinyint(1)
marks_awarded : decimal(10,2)
answered_at : datetime
evaluated_at : datetime
created_at : datetime
updated_at : datetime

v		competitive_exam ce_practice_session_questions
id : bigint(20) unsigned
session_id : bigint(20) unsigned
question_id : bigint(20) unsigned
question_version_id : bigint(20) unsigned
sequence_no : int(10) unsigned
subject_id : bigint(20) unsigned
chapter_id : bigint(20) unsigned
topic_id : bigint(20) unsigned
difficulty_level : varchar(20)
option_order_json : longtext
positive_marks : decimal(8,2)
negative_marks : decimal(8,2)
question_state : varchar(40)
first_viewed_at : datetime
last_viewed_at : datetime
visit_count : int(10) unsigned
time_spent_seconds : int(10) unsigned
created_at : datetime
updated_at : datetime

v		competitive_exam ce_questions
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
subject_id : bigint(20) unsigned
chapter_id : bigint(20) unsigned
topic_id : bigint(20) unsigned
question_code : varchar(80)
question_type : varchar(40)
difficulty_level : varchar(20)
language_code : varchar(20)
question_source : varchar(40)
source_name : varchar(180)
source_year : smallint(5) unsigned
current_version_no : int(10) unsigned
current_version_id : bigint(20) unsigned
workflow_status : varchar(30)
approved_by : bigint(20) unsigned
approved_at : datetime
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_question_bookmarks
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
candidate_id : bigint(20) unsigned
student_id : bigint(20) unsigned
question_id : bigint(20) unsigned
question_version_id : bigint(20) unsigned
note : varchar(500)
is_active : tinyint(1)
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_question_exam_map
id : bigint(20) unsigned
question_id : bigint(20) unsigned
exam_profile_id : bigint(20) unsigned
is_active : tinyint(1)
created_by : bigint(20) unsigned
created_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_question_import_batches
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
batch_code : varchar(80)
source_file_name : varchar(255)
source_file_size : bigint(20) unsigned
source_file_sha256 : char(64)
file_format : varchar(20)
batch_note : varchar(500)
status : varchar(30)
total_rows : int(10) unsigned
valid_rows : int(10) unsigned
error_rows : int(10) unsigned
warning_rows : int(10) unsigned
committed_rows : int(10) unsigned
created_by : bigint(20) unsigned
validated_at : datetime
committed_at : datetime
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_question_import_rows
id : bigint(20) unsigned
batch_id : bigint(20) unsigned
row_number : int(10) unsigned
question_code : varchar(80)
subject_code : varchar(60)
chapter_code : varchar(80)
topic_code : varchar(80)
profile_codes : varchar(500)
question_type : varchar(40)
difficulty_level : varchar(20)
content_fingerprint : char(64)
validation_status : varchar(20)
errors_json : longtext
warnings_json : longtext
raw_payload : longtext
normalized_payload : longtext
question_id : bigint(20) unsigned
committed_at : datetime
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_question_versions
id : bigint(20) unsigned
question_id : bigint(20) unsigned
version_no : int(10) unsigned
subject_id : bigint(20) unsigned
chapter_id : bigint(20) unsigned
topic_id : bigint(20) unsigned
question_type : varchar(40)
difficulty_level : varchar(20)
language_code : varchar(20)
question_source : varchar(40)
source_name : varchar(180)
source_year : smallint(5) unsigned
question_text : longtext
question_html : longtext
question_image_path : varchar(500)
positive_marks : decimal(8,2)
negative_marks : decimal(8,2)
explanation_text : longtext
explanation_html : longtext
explanation_image_path : varchar(500)
explanation_video_url : varchar(500)
answer_mode : varchar(40)
numeric_answer_min : decimal(20,8)
numeric_answer_max : decimal(20,8)
version_status : varchar(30)
change_note : varchar(500)
authored_by : bigint(20) unsigned
approved_by : bigint(20) unsigned
approved_at : datetime
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_question_version_options
id : bigint(20) unsigned
question_version_id : bigint(20) unsigned
option_key : varchar(20)
option_text : longtext
option_html : longtext
option_image_path : varchar(500)
is_correct : tinyint(1)
display_order : int(11)
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_rankings
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
test_id : bigint(20) unsigned
result_id : bigint(20) unsigned
candidate_id : bigint(20) unsigned
student_id : bigint(20) unsigned
score : decimal(12,2)
overall_rank : int(10) unsigned
branch_rank : int(10) unsigned
batch_rank : int(10) unsigned
class_rank : int(10) unsigned
percentile : decimal(8,4)
calculated_at : datetime

v		competitive_exam ce_results
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
test_id : bigint(20) unsigned
attempt_id : bigint(20) unsigned
candidate_id : bigint(20) unsigned
student_id : bigint(20) unsigned
total_questions : int(10) unsigned
attempted_count : int(10) unsigned
correct_count : int(10) unsigned
incorrect_count : int(10) unsigned
unattempted_count : int(10) unsigned
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) unsigned
branch_rank : int(10) unsigned
batch_rank : int(10) unsigned
class_rank : int(10) unsigned
accuracy_percentage : decimal(8,4)
total_time_seconds : int(10) unsigned
result_status : varchar(30)
calculated_at : datetime
published_at : datetime
created_at : datetime
updated_at : datetime

v		competitive_exam ce_result_adjustments
id : bigint(20) unsigned
result_id : bigint(20) unsigned
test_id : bigint(20) unsigned
candidate_id : bigint(20) unsigned
adjustment_type : varchar(40)
marks_delta : decimal(12,2)
reason : varchar(500)
approved_by : bigint(20) unsigned
approved_at : datetime
created_by : bigint(20) unsigned
created_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_result_chapters
id : bigint(20) unsigned
result_id : bigint(20) unsigned
test_id : bigint(20) unsigned
candidate_id : bigint(20) unsigned
subject_id : bigint(20) unsigned
chapter_id : bigint(20) unsigned
total_questions : int(10) unsigned
attempted_count : int(10) unsigned
correct_count : int(10) unsigned
incorrect_count : int(10) unsigned
unattempted_count : int(10) unsigned
score : decimal(12,2)
maximum_marks : decimal(12,2)
accuracy_percentage : decimal(8,4)
time_spent_seconds : int(10) unsigned
created_at : datetime

v		competitive_exam ce_result_subjects
id : bigint(20) unsigned
result_id : bigint(20) unsigned
test_id : bigint(20) unsigned
candidate_id : bigint(20) unsigned
subject_id : bigint(20) unsigned
total_questions : int(10) unsigned
attempted_count : int(10) unsigned
correct_count : int(10) unsigned
incorrect_count : int(10) unsigned
unattempted_count : int(10) unsigned
positive_marks : decimal(12,2)
negative_marks : decimal(12,2)
score : decimal(12,2)
maximum_marks : decimal(12,2)
percentage : decimal(8,4)
accuracy_percentage : decimal(8,4)
time_spent_seconds : int(10) unsigned
created_at : datetime
updated_at : datetime

v		competitive_exam ce_result_topics
id : bigint(20) unsigned
result_id : bigint(20) unsigned
test_id : bigint(20) unsigned
candidate_id : bigint(20) unsigned
subject_id : bigint(20) unsigned
chapter_id : bigint(20) unsigned
topic_id : bigint(20) unsigned
total_questions : int(10) unsigned
attempted_count : int(10) unsigned
correct_count : int(10) unsigned
incorrect_count : int(10) unsigned
unattempted_count : int(10) unsigned
score : decimal(12,2)
maximum_marks : decimal(12,2)
accuracy_percentage : decimal(8,4)
time_spent_seconds : int(10) unsigned
created_at : datetime

v		competitive_exam ce_subjects
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
subject_code : varchar(60)
subject_name : varchar(150)
short_name : varchar(40)
display_order : int(11)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_tests
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
academic_year_id : bigint(20) unsigned
exam_profile_id : bigint(20) unsigned
test_code : varchar(80)
test_name : varchar(180)
test_type : varchar(40)
description : text
instructions : longtext
start_datetime : datetime
end_datetime : datetime
duration_minutes : int(10) unsigned
total_questions : int(10) unsigned
total_marks : decimal(12,2)
max_attempts : int(10) unsigned
result_publish_mode : varchar(30)
result_publish_at : datetime
randomize_questions : tinyint(1)
randomize_options : tinyint(1)
allow_resume : tinyint(1)
status : varchar(30)
published_by : bigint(20) unsigned
published_at : datetime
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_test_assignments
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
test_id : bigint(20) unsigned
assignment_type : varchar(30)
assignment_key : varchar(180)
candidate_id : bigint(20) unsigned
student_id : bigint(20) unsigned
class_id : bigint(20) unsigned
section_id : bigint(20) unsigned
batch_id : bigint(20) unsigned
available_from : datetime
available_until : datetime
is_active : tinyint(1)
assigned_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_test_questions
id : bigint(20) unsigned
test_id : bigint(20) unsigned
section_id : bigint(20) unsigned
question_id : bigint(20) unsigned
question_version_id : bigint(20) unsigned
question_number : int(10) unsigned
section_question_number : int(10) unsigned
positive_marks : decimal(8,2)
negative_marks : decimal(8,2)
display_order : int(11)
is_mandatory : tinyint(1)
is_active : tinyint(1)
created_by : bigint(20) unsigned
blueprint_generation_id : bigint(20) unsigned
created_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_test_question_adjustments
id : bigint(20) unsigned
test_id : bigint(20) unsigned
test_question_id : bigint(20) unsigned
adjustment_type : varchar(40)
adjustment_value : decimal(10,2)
override_correct_options : longtext
reason : varchar(500)
is_active : tinyint(1)
applied_by : bigint(20) unsigned
applied_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_test_sections
id : bigint(20) unsigned
test_id : bigint(20) unsigned
subject_id : bigint(20) unsigned
section_code : varchar(60)
section_name : varchar(150)
question_count : int(10) unsigned
total_marks : decimal(12,2)
duration_minutes : int(10) unsigned
display_order : int(11)
is_active : tinyint(1)
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

v		competitive_exam ce_topics
id : bigint(20) unsigned
company_id : bigint(20) unsigned
branch_id : bigint(20) unsigned
unit_id : bigint(20) unsigned
subject_id : bigint(20) unsigned
chapter_id : bigint(20) unsigned
topic_code : varchar(80)
topic_name : varchar(180)
display_order : int(11)
is_active : tinyint(1)
created_by : bigint(20) unsigned
updated_by : bigint(20) unsigned
created_at : datetime
updated_at : datetime
delete_status : tinyint(1)

Create relationship
FOREIGN KEY
on delete
on update