Recent
`performance_schema`.`socket_instances`
`citi_global_inventory`.`transactions`
`dbias_master2`.`dbias_sections`
`information_schema`.`USER_PRIVILEGES`
`dbias_master`.`librecords`
`information_schema`.`GLOBAL_STATUS`
`dbias_master`.`high_curri`
`dbias_master`.`cashiernote`
`teacher_scheduler_db`.`school_years`
`dbias_master2`.`voided_payments`
Favorites
There are no favorite tables.
New
campushub_docs
cashier_activity_logs
cgc_mailer
citi_global_inventory
dbias
dbias_master
dbias_master2
debate_tabulation
hr_portal_db
information_schema
kanta1
kanta2
laptop_borrowing_system
mis_bsais
mysql
performance_schema
phpmyadmin
sayaw
shspayment
shs_activity_logs
tabulation
tabulation_db
tabulation_db2
tabulation_db3
tabulation_db4
teacher_scheduler_db
test
tradition
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
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
).
main
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.
Navigation tree
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
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
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
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: dbias_master2
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
Press Ctrl+Enter to execute query
Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse
Expand
Show trace
Hide trace
Count :
Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Label:
Target database:
Share this bookmark
OK
Options
Set default
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 :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Switch to
visual builder
Saved bookmarked search:
New bookmark
Column:
`accessories_senior`.*
`accessories_senior`.`id`
`accessories_senior`.`student_id`
`accessories_senior`.`id_card`
`accessories_senior`.`id_lace`
`accessories_senior`.`pe_uniform`
`accessories_senior`.`school_uniform`
`active_sessions`.*
`active_sessions`.`id`
`active_sessions`.`user_id`
`active_sessions`.`username`
`active_sessions`.`role`
`active_sessions`.`ip_address`
`active_sessions`.`page_url`
`active_sessions`.`user_agent`
`active_sessions`.`login_time`
`active_sessions`.`last_activity`
`cashier`.*
`cashier`.`id`
`cashier`.`username`
`cashier`.`email`
`cashier`.`password_hash`
`cashier`.`created_at`
`cashier`.`status`
`cashier`.`role`
`chat_messages`.*
`chat_messages`.`id`
`chat_messages`.`sender_id`
`chat_messages`.`sender_name`
`chat_messages`.`receiver_id`
`chat_messages`.`message`
`chat_messages`.`is_read`
`chat_messages`.`created_at`
`dbias_sections`.*
`dbias_sections`.`section_id`
`dbias_sections`.`section_name`
`dbias_sections`.`strand_id`
`dbias_sections`.`semester`
`dbias_sections`.`grade_level`
`dbias_sections_junior`.*
`dbias_sections_junior`.`section_id`
`dbias_sections_junior`.`section_name`
`dbias_sections_junior`.`grade_level`
`dbias_strands`.*
`dbias_strands`.`strand_id`
`dbias_strands`.`strand_name`
`dropped_junior`.*
`dropped_junior`.`id`
`dropped_junior`.`school_year`
`dropped_junior`.`place_birth`
`dropped_junior`.`lrn`
`dropped_junior`.`last_name`
`dropped_junior`.`first_name`
`dropped_junior`.`middle_name`
`dropped_junior`.`grade_6_school`
`dropped_junior`.`birthday`
`dropped_junior`.`address`
`dropped_junior`.`guardian_contact`
`dropped_junior`.`guardian_name`
`dropped_junior`.`father_name`
`dropped_junior`.`mother_name`
`dropped_junior`.`father_contact`
`dropped_junior`.`mother_contact`
`dropped_junior`.`cashier_status`
`dropped_junior`.`account_status`
`dropped_junior`.`tuition_fee`
`dropped_junior`.`remaining_balance`
`dropped_junior`.`date_enrolled`
`dropped_junior`.`birth_certificate`
`dropped_junior`.`form_138`
`dropped_junior`.`good_moral`
`dropped_junior`.`pic_1x1`
`dropped_junior`.`pic_2x2`
`dropped_junior`.`form_137`
`dropped_junior`.`civil_status`
`dropped_junior`.`sex`
`dropped_junior`.`grade_level`
`dropped_junior`.`section_id`
`dropped_junior`.`student_number`
`dropped_junior`.`student_contact`
`dropped_junior`.`remarks`
`dropped_students`.*
`dropped_students`.`id`
`dropped_students`.`school_year`
`dropped_students`.`student_number`
`dropped_students`.`grade_10_section`
`dropped_students`.`section`
`dropped_students`.`lrn`
`dropped_students`.`last_name`
`dropped_students`.`first_name`
`dropped_students`.`middle_name`
`dropped_students`.`grade_10_school`
`dropped_students`.`birthday`
`dropped_students`.`address`
`dropped_students`.`student_contact`
`dropped_students`.`guardian_contact`
`dropped_students`.`guardian_name`
`dropped_students`.`four_ps`
`dropped_students`.`account_status`
`dropped_students`.`tuition_fee`
`dropped_students`.`remaining_balance`
`dropped_students`.`date_enrolled`
`dropped_students`.`referred_by`
`dropped_students`.`birth_certificate`
`dropped_students`.`form_138`
`dropped_students`.`good_moral`
`dropped_students`.`pic_1x1`
`dropped_students`.`pic_2x2`
`dropped_students`.`form_137`
`dropped_students`.`remarks`
`dropped_students`.`file_birth_certificate`
`dropped_students`.`file_form_138`
`dropped_students`.`file_good_moral`
`dropped_students`.`file_pic_1x1`
`dropped_students`.`file_pic_2x2`
`dropped_students`.`file_form_137`
`dropped_students`.`graduation_fee`
`dropped_students`.`remaining_graduation_balance`
`dropped_students`.`email_address`
`dropped_students`.`civil_status`
`dropped_students`.`sex`
`dropped_students`.`grade_level`
`dropped_students`.`semester`
`dropped_students`.`strand`
`dropped_students`.`strand_id`
`dropped_students`.`section_id`
`dropped_students`.`father_name`
`dropped_students`.`mother_name`
`dropped_students`.`referral_status`
`dropped_students`.`status`
`dropped_students`.`remark`
`dropped_students`.`was_transferee`
`dropped_students`.`total_paid`
`dropped_students`.`grade11_original_tuition`
`dropped_students`.`is_repeater`
`dropped_students`.`repeater_duration`
`dropped_students`.`curriculum_version`
`enrolled_junior`.*
`enrolled_junior`.`id`
`enrolled_junior`.`school_year`
`enrolled_junior`.`place_birth`
`enrolled_junior`.`lrn`
`enrolled_junior`.`last_name`
`enrolled_junior`.`first_name`
`enrolled_junior`.`middle_name`
`enrolled_junior`.`grade_6_school`
`enrolled_junior`.`birthday`
`enrolled_junior`.`address`
`enrolled_junior`.`guardian_contact`
`enrolled_junior`.`guardian_name`
`enrolled_junior`.`father_name`
`enrolled_junior`.`mother_name`
`enrolled_junior`.`father_contact`
`enrolled_junior`.`mother_contact`
`enrolled_junior`.`cashier_status`
`enrolled_junior`.`account_status`
`enrolled_junior`.`tuition_fee`
`enrolled_junior`.`remaining_balance`
`enrolled_junior`.`graduation_fee`
`enrolled_junior`.`remaining_graduation_balance`
`enrolled_junior`.`date_enrolled`
`enrolled_junior`.`birth_certificate`
`enrolled_junior`.`form_138`
`enrolled_junior`.`good_moral`
`enrolled_junior`.`pic_1x1`
`enrolled_junior`.`pic_2x2`
`enrolled_junior`.`form_137`
`enrolled_junior`.`civil_status`
`enrolled_junior`.`sex`
`enrolled_junior`.`grade_level`
`enrolled_junior`.`section_id`
`enrolled_junior`.`student_number`
`enrolled_junior`.`student_contact`
`enrolled_students`.*
`enrolled_students`.`id`
`enrolled_students`.`school_year`
`enrolled_students`.`student_number`
`enrolled_students`.`grade_10_section`
`enrolled_students`.`section`
`enrolled_students`.`lrn`
`enrolled_students`.`last_name`
`enrolled_students`.`first_name`
`enrolled_students`.`middle_name`
`enrolled_students`.`grade_10_school`
`enrolled_students`.`birthday`
`enrolled_students`.`address`
`enrolled_students`.`student_contact`
`enrolled_students`.`guardian_contact`
`enrolled_students`.`guardian_name`
`enrolled_students`.`four_ps`
`enrolled_students`.`account_status`
`enrolled_students`.`tuition_fee`
`enrolled_students`.`remaining_balance`
`enrolled_students`.`date_enrolled`
`enrolled_students`.`referred_by`
`enrolled_students`.`birth_certificate`
`enrolled_students`.`form_138`
`enrolled_students`.`good_moral`
`enrolled_students`.`pic_1x1`
`enrolled_students`.`pic_2x2`
`enrolled_students`.`form_137`
`enrolled_students`.`remarks`
`enrolled_students`.`file_birth_certificate`
`enrolled_students`.`file_form_138`
`enrolled_students`.`file_good_moral`
`enrolled_students`.`file_pic_1x1`
`enrolled_students`.`file_pic_2x2`
`enrolled_students`.`file_form_137`
`enrolled_students`.`graduation_fee`
`enrolled_students`.`remaining_graduation_balance`
`enrolled_students`.`email_address`
`enrolled_students`.`civil_status`
`enrolled_students`.`sex`
`enrolled_students`.`grade_level`
`enrolled_students`.`semester`
`enrolled_students`.`strand`
`enrolled_students`.`strand_id`
`enrolled_students`.`section_id`
`enrolled_students`.`father_name`
`enrolled_students`.`mother_name`
`enrolled_students`.`referral_status`
`enrolled_students`.`status`
`enrolled_students`.`remark`
`enrolled_students`.`was_transferee`
`enrolled_students`.`total_paid`
`enrolled_students`.`grade11_original_tuition`
`enrolled_students`.`is_repeater`
`enrolled_students`.`repeater_duration`
`enrolled_students`.`curriculum_version`
`enrolling_junior`.*
`enrolling_junior`.`id`
`enrolling_junior`.`school_year`
`enrolling_junior`.`place_birth`
`enrolling_junior`.`lrn`
`enrolling_junior`.`last_name`
`enrolling_junior`.`first_name`
`enrolling_junior`.`middle_name`
`enrolling_junior`.`grade_6_school`
`enrolling_junior`.`birthday`
`enrolling_junior`.`address`
`enrolling_junior`.`guardian_contact`
`enrolling_junior`.`guardian_name`
`enrolling_junior`.`father_name`
`enrolling_junior`.`mother_name`
`enrolling_junior`.`father_contact`
`enrolling_junior`.`mother_contact`
`enrolling_junior`.`cashier_status`
`enrolling_junior`.`account_status`
`enrolling_junior`.`tuition_fee`
`enrolling_junior`.`remaining_balance`
`enrolling_junior`.`date_enrolled`
`enrolling_junior`.`birth_certificate`
`enrolling_junior`.`form_138`
`enrolling_junior`.`good_moral`
`enrolling_junior`.`pic_1x1`
`enrolling_junior`.`pic_2x2`
`enrolling_junior`.`form_137`
`enrolling_junior`.`civil_status`
`enrolling_junior`.`sex`
`enrolling_junior`.`grade_level`
`enrolling_junior`.`section_id`
`enrolling_junior`.`student_number`
`enrolling_junior`.`student_contact`
`enrolling_students`.*
`enrolling_students`.`id`
`enrolling_students`.`school_year`
`enrolling_students`.`student_number`
`enrolling_students`.`grade_10_section`
`enrolling_students`.`section`
`enrolling_students`.`lrn`
`enrolling_students`.`last_name`
`enrolling_students`.`first_name`
`enrolling_students`.`middle_name`
`enrolling_students`.`grade_10_school`
`enrolling_students`.`birthday`
`enrolling_students`.`address`
`enrolling_students`.`student_contact`
`enrolling_students`.`guardian_contact`
`enrolling_students`.`guardian_name`
`enrolling_students`.`four_ps`
`enrolling_students`.`account_status`
`enrolling_students`.`cashier_status`
`enrolling_students`.`tuition_fee`
`enrolling_students`.`remaining_balance`
`enrolling_students`.`date_enrolled`
`enrolling_students`.`referred_by`
`enrolling_students`.`birth_certificate`
`enrolling_students`.`form_138`
`enrolling_students`.`good_moral`
`enrolling_students`.`pic_1x1`
`enrolling_students`.`pic_2x2`
`enrolling_students`.`form_137`
`enrolling_students`.`remarks`
`enrolling_students`.`email_address`
`enrolling_students`.`civil_status`
`enrolling_students`.`sex`
`enrolling_students`.`grade_level`
`enrolling_students`.`semester`
`enrolling_students`.`strand`
`enrolling_students`.`strand_id`
`enrolling_students`.`section_id`
`enrolling_students`.`father_name`
`enrolling_students`.`mother_name`
`enrolling_students`.`curriculum_version`
`expense_particulars`.*
`expense_particulars`.`id`
`expense_particulars`.`name`
`expense_photos`.*
`expense_photos`.`id`
`expense_photos`.`expense_id`
`expense_photos`.`file_name`
`expense_photos`.`uploaded_at`
`expenses_audit`.*
`expenses_audit`.`id`
`expenses_audit`.`month_name`
`expenses_audit`.`expense_date`
`expenses_audit`.`ref_number`
`expenses_audit`.`tin`
`expenses_audit`.`supplier_name`
`expenses_audit`.`particulars`
`expenses_audit`.`address`
`expenses_audit`.`amount`
`expenses_audit`.`remarks`
`expenses_audit`.`receipt_image`
`expenses_audit`.`created_at`
`graduate_senior`.*
`graduate_senior`.`id`
`graduate_senior`.`school_year`
`graduate_senior`.`student_number`
`graduate_senior`.`grade_10_section`
`graduate_senior`.`section`
`graduate_senior`.`lrn`
`graduate_senior`.`last_name`
`graduate_senior`.`first_name`
`graduate_senior`.`middle_name`
`graduate_senior`.`grade_10_school`
`graduate_senior`.`birthday`
`graduate_senior`.`address`
`graduate_senior`.`student_contact`
`graduate_senior`.`guardian_contact`
`graduate_senior`.`guardian_name`
`graduate_senior`.`four_ps`
`graduate_senior`.`account_status`
`graduate_senior`.`tuition_fee`
`graduate_senior`.`remaining_balance`
`graduate_senior`.`date_enrolled`
`graduate_senior`.`referred_by`
`graduate_senior`.`birth_certificate`
`graduate_senior`.`form_138`
`graduate_senior`.`good_moral`
`graduate_senior`.`pic_1x1`
`graduate_senior`.`pic_2x2`
`graduate_senior`.`form_137`
`graduate_senior`.`remarks`
`graduate_senior`.`graduation_fee`
`graduate_senior`.`remaining_graduation_balance`
`graduate_senior`.`email_address`
`graduate_senior`.`civil_status`
`graduate_senior`.`sex`
`graduate_senior`.`grade_level`
`graduate_senior`.`semester`
`graduate_senior`.`strand`
`graduate_senior`.`strand_id`
`graduate_senior`.`section_id`
`graduate_senior`.`father_name`
`graduate_senior`.`mother_name`
`graduate_senior`.`referral_status`
`graduate_senior`.`status`
`graduate_senior`.`remark`
`graduate_senior`.`was_transferee`
`graduate_senior`.`total_paid`
`graduate_senior`.`grade11_original_tuition`
`graduate_senior`.`is_repeater`
`graduate_senior`.`repeater_duration`
`graduate_senior`.`curriculum_version`
`graduation_junior`.*
`graduation_junior`.`payment_id`
`graduation_junior`.`student_id`
`graduation_junior`.`or_number`
`graduation_junior`.`amount_paid`
`graduation_junior`.`payment_date`
`graduation_junior`.`remarks`
`graduation_payments`.*
`graduation_payments`.`payment_id`
`graduation_payments`.`student_id`
`graduation_payments`.`or_number`
`graduation_payments`.`amount_paid`
`graduation_payments`.`payment_date`
`graduation_payments`.`remarks`
`graduation_payments2`.*
`graduation_payments2`.`id`
`graduation_payments2`.`student_id`
`graduation_payments2`.`or_number`
`graduation_payments2`.`payment_date`
`graduation_payments2`.`amount`
`graduation_payments2`.`remarks`
`graduation_payments2`.`created_at`
`graduation_students2`.*
`graduation_students2`.`id`
`graduation_students2`.`school_year`
`graduation_students2`.`student_name`
`graduation_students2`.`year_level`
`graduation_students2`.`strand`
`graduation_students2`.`semester`
`graduation_students2`.`graduation_fee`
`graduation_students2`.`created_at`
`graduation_students2`.`branch`
`inventory_items`.*
`inventory_items`.`id`
`inventory_items`.`category`
`inventory_items`.`department`
`inventory_items`.`item_name`
`inventory_items`.`item_type`
`inventory_items`.`price`
`inventory_items`.`stock_quantity`
`inventory_items`.`created_at`
`inventory_logs`.*
`inventory_logs`.`id`
`inventory_logs`.`item_id`
`inventory_logs`.`user_id`
`inventory_logs`.`action`
`inventory_logs`.`quantity_changed`
`inventory_logs`.`remarks`
`inventory_logs`.`log_date`
`inventory_logs`.`log_time`
`junior_subjects`.*
`junior_subjects`.`subject_id`
`junior_subjects`.`grade_level`
`junior_subjects`.`subject_name`
`login_history`.*
`login_history`.`id`
`login_history`.`user_id`
`login_history`.`username`
`login_history`.`role`
`login_history`.`ip_address`
`login_history`.`user_agent`
`login_history`.`status`
`login_history`.`attempt_time`
`login_history`.`logout_time`
`login_history`.`session_duration`
`login_history`.`failure_reason`
`miscellaneous_fees`.*
`miscellaneous_fees`.`id`
`miscellaneous_fees`.`title`
`miscellaneous_fees`.`school_year`
`miscellaneous_fees`.`target_grade_11`
`miscellaneous_fees`.`target_grade_12`
`miscellaneous_fees`.`amount`
`miscellaneous_fees`.`created_at`
`miscellaneous_fees`.`status`
`miscellaneous_fees`.`semester`
`miscellaneous_payment_history`.*
`miscellaneous_payment_history`.`id`
`miscellaneous_payment_history`.`student_misc_id`
`miscellaneous_payment_history`.`payment_date`
`miscellaneous_payment_history`.`or_number`
`miscellaneous_payment_history`.`amount_paid`
`miscellaneous_payment_history`.`remarks`
`miscellaneous_payment_history`.`created_at`
`not_graduate_senior`.*
`not_graduate_senior`.`id`
`not_graduate_senior`.`school_year`
`not_graduate_senior`.`student_number`
`not_graduate_senior`.`grade_10_section`
`not_graduate_senior`.`section`
`not_graduate_senior`.`lrn`
`not_graduate_senior`.`last_name`
`not_graduate_senior`.`first_name`
`not_graduate_senior`.`middle_name`
`not_graduate_senior`.`grade_10_school`
`not_graduate_senior`.`birthday`
`not_graduate_senior`.`address`
`not_graduate_senior`.`student_contact`
`not_graduate_senior`.`guardian_contact`
`not_graduate_senior`.`guardian_name`
`not_graduate_senior`.`four_ps`
`not_graduate_senior`.`account_status`
`not_graduate_senior`.`tuition_fee`
`not_graduate_senior`.`remaining_balance`
`not_graduate_senior`.`date_enrolled`
`not_graduate_senior`.`referred_by`
`not_graduate_senior`.`birth_certificate`
`not_graduate_senior`.`form_138`
`not_graduate_senior`.`good_moral`
`not_graduate_senior`.`pic_1x1`
`not_graduate_senior`.`pic_2x2`
`not_graduate_senior`.`form_137`
`not_graduate_senior`.`remarks`
`not_graduate_senior`.`file_birth_certificate`
`not_graduate_senior`.`file_form_138`
`not_graduate_senior`.`file_good_moral`
`not_graduate_senior`.`file_pic_1x1`
`not_graduate_senior`.`file_pic_2x2`
`not_graduate_senior`.`file_form_137`
`not_graduate_senior`.`graduation_fee`
`not_graduate_senior`.`remaining_graduation_balance`
`not_graduate_senior`.`email_address`
`not_graduate_senior`.`civil_status`
`not_graduate_senior`.`sex`
`not_graduate_senior`.`grade_level`
`not_graduate_senior`.`semester`
`not_graduate_senior`.`strand`
`not_graduate_senior`.`strand_id`
`not_graduate_senior`.`section_id`
`not_graduate_senior`.`father_name`
`not_graduate_senior`.`mother_name`
`not_graduate_senior`.`referral_status`
`not_graduate_senior`.`status`
`not_graduate_senior`.`remark`
`not_graduate_senior`.`was_transferee`
`not_graduate_senior`.`total_paid`
`not_graduate_senior`.`grade11_original_tuition`
`not_graduate_senior`.`is_repeater`
`not_graduate_senior`.`repeater_duration`
`not_graduate_senior`.`curriculum_version`
`password_reset_logs`.*
`password_reset_logs`.`id`
`password_reset_logs`.`user_id`
`password_reset_logs`.`reset_by`
`password_reset_logs`.`reset_at`
`referral_claims`.*
`referral_claims`.`id`
`referral_claims`.`referrer_name`
`referral_claims`.`student_id`
`referral_claims`.`amount`
`referral_claims`.`part`
`referral_claims`.`claimed_at`
`referrals`.*
`referrals`.`id`
`referrals`.`referrer_name`
`referrals`.`total_referrals`
`referrals`.`total_earnings`
`referrals`.`claimed_earnings`
`referrals`.`created_at`
`registrar`.*
`registrar`.`id`
`registrar`.`username`
`registrar`.`email`
`registrar`.`password_hash`
`registrar`.`created_at`
`registrar`.`status`
`registrar`.`role`
`service_invoice_audit`.*
`service_invoice_audit`.`id`
`service_invoice_audit`.`or_number`
`service_invoice_audit`.`invoice_date`
`service_invoice_audit`.`amount`
`service_invoice_audit`.`student_name`
`service_invoice_audit`.`branch`
`service_invoice_audit`.`created_at`
`strand_subjects`.*
`strand_subjects`.`subject_id`
`strand_subjects`.`strand_id`
`strand_subjects`.`grade_level`
`strand_subjects`.`semester`
`strand_subjects`.`subject_name`
`strand_subjects`.`subject_type`
`strand_subjects`.`curriculum_version`
`student_allowances`.*
`student_allowances`.`id`
`student_allowances`.`student_id`
`student_allowances`.`school_supplies_claimed`
`student_allowances`.`transportation_claimed`
`student_allowances`.`school_supplies_claimed_at`
`student_allowances`.`transportation_claimed_at`
`student_allowances`.`school_supplies_amount`
`student_allowances`.`transportation_amount`
`student_miscellaneous`.*
`student_miscellaneous`.`id`
`student_miscellaneous`.`student_number`
`student_miscellaneous`.`misc_fee_id`
`student_miscellaneous`.`amount_due`
`student_miscellaneous`.`amount_paid`
`student_miscellaneous`.`status`
`student_payments`.*
`student_payments`.`payment_id`
`student_payments`.`payment_date`
`student_payments`.`or_number`
`student_payments`.`amount_paid`
`student_payments`.`remarks`
`student_payments`.`student_number`
`student_payments`.`school_year`
`student_payments`.`grade_level`
`student_payments`.`payment_for`
`student_payments`.`semester`
`student_payments`.`grade`
`student_payments_junior`.*
`student_payments_junior`.`payment_id`
`student_payments_junior`.`payment_date`
`student_payments_junior`.`or_number`
`student_payments_junior`.`amount_paid`
`student_payments_junior`.`remarks`
`student_payments_junior`.`lrn`
`student_payments_junior`.`school_year`
`student_payments_junior`.`student_number`
`student_payments_junior`.`payment_for`
`student_subjects`.*
`student_subjects`.`student_subject_id`
`student_subjects`.`enrolled_student_id`
`student_subjects`.`subject_name`
`system_logs`.*
`system_logs`.`id`
`system_logs`.`user_id`
`system_logs`.`username`
`system_logs`.`user_role`
`system_logs`.`log_type`
`system_logs`.`module`
`system_logs`.`action`
`system_logs`.`record_id`
`system_logs`.`ip_address`
`system_logs`.`user_agent`
`system_logs`.`message`
`system_logs`.`details`
`system_logs`.`severity`
`system_logs`.`file_path`
`system_logs`.`line_number`
`system_logs`.`execution_time`
`system_logs`.`memory_usage`
`system_logs`.`timestamp`
`system_update_logs`.*
`system_update_logs`.`id`
`system_update_logs`.`version`
`system_update_logs`.`title`
`system_update_logs`.`description`
`system_update_logs`.`created_by`
`system_update_logs`.`created_at`
`system_updates`.*
`system_updates`.`id`
`system_updates`.`version`
`system_updates`.`title`
`system_updates`.`description`
`system_updates`.`created_at`
`transferred_out`.*
`transferred_out`.`id`
`transferred_out`.`school_year`
`transferred_out`.`student_number`
`transferred_out`.`grade_10_section`
`transferred_out`.`section`
`transferred_out`.`lrn`
`transferred_out`.`last_name`
`transferred_out`.`first_name`
`transferred_out`.`middle_name`
`transferred_out`.`grade_10_school`
`transferred_out`.`birthday`
`transferred_out`.`address`
`transferred_out`.`student_contact`
`transferred_out`.`guardian_contact`
`transferred_out`.`guardian_name`
`transferred_out`.`four_ps`
`transferred_out`.`account_status`
`transferred_out`.`tuition_fee`
`transferred_out`.`remaining_balance`
`transferred_out`.`date_enrolled`
`transferred_out`.`referred_by`
`transferred_out`.`birth_certificate`
`transferred_out`.`form_138`
`transferred_out`.`good_moral`
`transferred_out`.`pic_1x1`
`transferred_out`.`pic_2x2`
`transferred_out`.`form_137`
`transferred_out`.`remarks`
`transferred_out`.`file_birth_certificate`
`transferred_out`.`file_form_138`
`transferred_out`.`file_good_moral`
`transferred_out`.`file_pic_1x1`
`transferred_out`.`file_pic_2x2`
`transferred_out`.`file_form_137`
`transferred_out`.`graduation_fee`
`transferred_out`.`remaining_graduation_balance`
`transferred_out`.`email_address`
`transferred_out`.`civil_status`
`transferred_out`.`sex`
`transferred_out`.`grade_level`
`transferred_out`.`semester`
`transferred_out`.`strand`
`transferred_out`.`strand_id`
`transferred_out`.`section_id`
`transferred_out`.`father_name`
`transferred_out`.`mother_name`
`transferred_out`.`referral_status`
`transferred_out`.`status`
`transferred_out`.`remark`
`transferred_out`.`was_transferee`
`transferred_out`.`total_paid`
`transferred_out`.`grade11_original_tuition`
`transferred_out`.`is_repeater`
`transferred_out`.`repeater_duration`
`transferred_out`.`curriculum_version`
`users`.*
`users`.`id`
`users`.`username`
`users`.`full_name`
`users`.`email`
`users`.`password_hash`
`users`.`created_at`
`users`.`last_login`
`users`.`status`
`users`.`role`
`users`.`department`
`users`.`last_active`
`users`.`google_auth_secret`
`voided_payments`.*
`voided_payments`.`id`
`voided_payments`.`original_id`
`voided_payments`.`student_id`
`voided_payments`.`or_number`
`voided_payments`.`amount`
`voided_payments`.`payment_date`
`voided_payments`.`original_remarks`
`voided_payments`.`void_reason`
`voided_payments`.`voided_by`
`voided_payments`.`date_voided`
`accessories_senior`.*
`accessories_senior`.`id`
`accessories_senior`.`student_id`
`accessories_senior`.`id_card`
`accessories_senior`.`id_lace`
`accessories_senior`.`pe_uniform`
`accessories_senior`.`school_uniform`
`active_sessions`.*
`active_sessions`.`id`
`active_sessions`.`user_id`
`active_sessions`.`username`
`active_sessions`.`role`
`active_sessions`.`ip_address`
`active_sessions`.`page_url`
`active_sessions`.`user_agent`
`active_sessions`.`login_time`
`active_sessions`.`last_activity`
`cashier`.*
`cashier`.`id`
`cashier`.`username`
`cashier`.`email`
`cashier`.`password_hash`
`cashier`.`created_at`
`cashier`.`status`
`cashier`.`role`
`chat_messages`.*
`chat_messages`.`id`
`chat_messages`.`sender_id`
`chat_messages`.`sender_name`
`chat_messages`.`receiver_id`
`chat_messages`.`message`
`chat_messages`.`is_read`
`chat_messages`.`created_at`
`dbias_sections`.*
`dbias_sections`.`section_id`
`dbias_sections`.`section_name`
`dbias_sections`.`strand_id`
`dbias_sections`.`semester`
`dbias_sections`.`grade_level`
`dbias_sections_junior`.*
`dbias_sections_junior`.`section_id`
`dbias_sections_junior`.`section_name`
`dbias_sections_junior`.`grade_level`
`dbias_strands`.*
`dbias_strands`.`strand_id`
`dbias_strands`.`strand_name`
`dropped_junior`.*
`dropped_junior`.`id`
`dropped_junior`.`school_year`
`dropped_junior`.`place_birth`
`dropped_junior`.`lrn`
`dropped_junior`.`last_name`
`dropped_junior`.`first_name`
`dropped_junior`.`middle_name`
`dropped_junior`.`grade_6_school`
`dropped_junior`.`birthday`
`dropped_junior`.`address`
`dropped_junior`.`guardian_contact`
`dropped_junior`.`guardian_name`
`dropped_junior`.`father_name`
`dropped_junior`.`mother_name`
`dropped_junior`.`father_contact`
`dropped_junior`.`mother_contact`
`dropped_junior`.`cashier_status`
`dropped_junior`.`account_status`
`dropped_junior`.`tuition_fee`
`dropped_junior`.`remaining_balance`
`dropped_junior`.`date_enrolled`
`dropped_junior`.`birth_certificate`
`dropped_junior`.`form_138`
`dropped_junior`.`good_moral`
`dropped_junior`.`pic_1x1`
`dropped_junior`.`pic_2x2`
`dropped_junior`.`form_137`
`dropped_junior`.`civil_status`
`dropped_junior`.`sex`
`dropped_junior`.`grade_level`
`dropped_junior`.`section_id`
`dropped_junior`.`student_number`
`dropped_junior`.`student_contact`
`dropped_junior`.`remarks`
`dropped_students`.*
`dropped_students`.`id`
`dropped_students`.`school_year`
`dropped_students`.`student_number`
`dropped_students`.`grade_10_section`
`dropped_students`.`section`
`dropped_students`.`lrn`
`dropped_students`.`last_name`
`dropped_students`.`first_name`
`dropped_students`.`middle_name`
`dropped_students`.`grade_10_school`
`dropped_students`.`birthday`
`dropped_students`.`address`
`dropped_students`.`student_contact`
`dropped_students`.`guardian_contact`
`dropped_students`.`guardian_name`
`dropped_students`.`four_ps`
`dropped_students`.`account_status`
`dropped_students`.`tuition_fee`
`dropped_students`.`remaining_balance`
`dropped_students`.`date_enrolled`
`dropped_students`.`referred_by`
`dropped_students`.`birth_certificate`
`dropped_students`.`form_138`
`dropped_students`.`good_moral`
`dropped_students`.`pic_1x1`
`dropped_students`.`pic_2x2`
`dropped_students`.`form_137`
`dropped_students`.`remarks`
`dropped_students`.`file_birth_certificate`
`dropped_students`.`file_form_138`
`dropped_students`.`file_good_moral`
`dropped_students`.`file_pic_1x1`
`dropped_students`.`file_pic_2x2`
`dropped_students`.`file_form_137`
`dropped_students`.`graduation_fee`
`dropped_students`.`remaining_graduation_balance`
`dropped_students`.`email_address`
`dropped_students`.`civil_status`
`dropped_students`.`sex`
`dropped_students`.`grade_level`
`dropped_students`.`semester`
`dropped_students`.`strand`
`dropped_students`.`strand_id`
`dropped_students`.`section_id`
`dropped_students`.`father_name`
`dropped_students`.`mother_name`
`dropped_students`.`referral_status`
`dropped_students`.`status`
`dropped_students`.`remark`
`dropped_students`.`was_transferee`
`dropped_students`.`total_paid`
`dropped_students`.`grade11_original_tuition`
`dropped_students`.`is_repeater`
`dropped_students`.`repeater_duration`
`dropped_students`.`curriculum_version`
`enrolled_junior`.*
`enrolled_junior`.`id`
`enrolled_junior`.`school_year`
`enrolled_junior`.`place_birth`
`enrolled_junior`.`lrn`
`enrolled_junior`.`last_name`
`enrolled_junior`.`first_name`
`enrolled_junior`.`middle_name`
`enrolled_junior`.`grade_6_school`
`enrolled_junior`.`birthday`
`enrolled_junior`.`address`
`enrolled_junior`.`guardian_contact`
`enrolled_junior`.`guardian_name`
`enrolled_junior`.`father_name`
`enrolled_junior`.`mother_name`
`enrolled_junior`.`father_contact`
`enrolled_junior`.`mother_contact`
`enrolled_junior`.`cashier_status`
`enrolled_junior`.`account_status`
`enrolled_junior`.`tuition_fee`
`enrolled_junior`.`remaining_balance`
`enrolled_junior`.`graduation_fee`
`enrolled_junior`.`remaining_graduation_balance`
`enrolled_junior`.`date_enrolled`
`enrolled_junior`.`birth_certificate`
`enrolled_junior`.`form_138`
`enrolled_junior`.`good_moral`
`enrolled_junior`.`pic_1x1`
`enrolled_junior`.`pic_2x2`
`enrolled_junior`.`form_137`
`enrolled_junior`.`civil_status`
`enrolled_junior`.`sex`
`enrolled_junior`.`grade_level`
`enrolled_junior`.`section_id`
`enrolled_junior`.`student_number`
`enrolled_junior`.`student_contact`
`enrolled_students`.*
`enrolled_students`.`id`
`enrolled_students`.`school_year`
`enrolled_students`.`student_number`
`enrolled_students`.`grade_10_section`
`enrolled_students`.`section`
`enrolled_students`.`lrn`
`enrolled_students`.`last_name`
`enrolled_students`.`first_name`
`enrolled_students`.`middle_name`
`enrolled_students`.`grade_10_school`
`enrolled_students`.`birthday`
`enrolled_students`.`address`
`enrolled_students`.`student_contact`
`enrolled_students`.`guardian_contact`
`enrolled_students`.`guardian_name`
`enrolled_students`.`four_ps`
`enrolled_students`.`account_status`
`enrolled_students`.`tuition_fee`
`enrolled_students`.`remaining_balance`
`enrolled_students`.`date_enrolled`
`enrolled_students`.`referred_by`
`enrolled_students`.`birth_certificate`
`enrolled_students`.`form_138`
`enrolled_students`.`good_moral`
`enrolled_students`.`pic_1x1`
`enrolled_students`.`pic_2x2`
`enrolled_students`.`form_137`
`enrolled_students`.`remarks`
`enrolled_students`.`file_birth_certificate`
`enrolled_students`.`file_form_138`
`enrolled_students`.`file_good_moral`
`enrolled_students`.`file_pic_1x1`
`enrolled_students`.`file_pic_2x2`
`enrolled_students`.`file_form_137`
`enrolled_students`.`graduation_fee`
`enrolled_students`.`remaining_graduation_balance`
`enrolled_students`.`email_address`
`enrolled_students`.`civil_status`
`enrolled_students`.`sex`
`enrolled_students`.`grade_level`
`enrolled_students`.`semester`
`enrolled_students`.`strand`
`enrolled_students`.`strand_id`
`enrolled_students`.`section_id`
`enrolled_students`.`father_name`
`enrolled_students`.`mother_name`
`enrolled_students`.`referral_status`
`enrolled_students`.`status`
`enrolled_students`.`remark`
`enrolled_students`.`was_transferee`
`enrolled_students`.`total_paid`
`enrolled_students`.`grade11_original_tuition`
`enrolled_students`.`is_repeater`
`enrolled_students`.`repeater_duration`
`enrolled_students`.`curriculum_version`
`enrolling_junior`.*
`enrolling_junior`.`id`
`enrolling_junior`.`school_year`
`enrolling_junior`.`place_birth`
`enrolling_junior`.`lrn`
`enrolling_junior`.`last_name`
`enrolling_junior`.`first_name`
`enrolling_junior`.`middle_name`
`enrolling_junior`.`grade_6_school`
`enrolling_junior`.`birthday`
`enrolling_junior`.`address`
`enrolling_junior`.`guardian_contact`
`enrolling_junior`.`guardian_name`
`enrolling_junior`.`father_name`
`enrolling_junior`.`mother_name`
`enrolling_junior`.`father_contact`
`enrolling_junior`.`mother_contact`
`enrolling_junior`.`cashier_status`
`enrolling_junior`.`account_status`
`enrolling_junior`.`tuition_fee`
`enrolling_junior`.`remaining_balance`
`enrolling_junior`.`date_enrolled`
`enrolling_junior`.`birth_certificate`
`enrolling_junior`.`form_138`
`enrolling_junior`.`good_moral`
`enrolling_junior`.`pic_1x1`
`enrolling_junior`.`pic_2x2`
`enrolling_junior`.`form_137`
`enrolling_junior`.`civil_status`
`enrolling_junior`.`sex`
`enrolling_junior`.`grade_level`
`enrolling_junior`.`section_id`
`enrolling_junior`.`student_number`
`enrolling_junior`.`student_contact`
`enrolling_students`.*
`enrolling_students`.`id`
`enrolling_students`.`school_year`
`enrolling_students`.`student_number`
`enrolling_students`.`grade_10_section`
`enrolling_students`.`section`
`enrolling_students`.`lrn`
`enrolling_students`.`last_name`
`enrolling_students`.`first_name`
`enrolling_students`.`middle_name`
`enrolling_students`.`grade_10_school`
`enrolling_students`.`birthday`
`enrolling_students`.`address`
`enrolling_students`.`student_contact`
`enrolling_students`.`guardian_contact`
`enrolling_students`.`guardian_name`
`enrolling_students`.`four_ps`
`enrolling_students`.`account_status`
`enrolling_students`.`cashier_status`
`enrolling_students`.`tuition_fee`
`enrolling_students`.`remaining_balance`
`enrolling_students`.`date_enrolled`
`enrolling_students`.`referred_by`
`enrolling_students`.`birth_certificate`
`enrolling_students`.`form_138`
`enrolling_students`.`good_moral`
`enrolling_students`.`pic_1x1`
`enrolling_students`.`pic_2x2`
`enrolling_students`.`form_137`
`enrolling_students`.`remarks`
`enrolling_students`.`email_address`
`enrolling_students`.`civil_status`
`enrolling_students`.`sex`
`enrolling_students`.`grade_level`
`enrolling_students`.`semester`
`enrolling_students`.`strand`
`enrolling_students`.`strand_id`
`enrolling_students`.`section_id`
`enrolling_students`.`father_name`
`enrolling_students`.`mother_name`
`enrolling_students`.`curriculum_version`
`expense_particulars`.*
`expense_particulars`.`id`
`expense_particulars`.`name`
`expense_photos`.*
`expense_photos`.`id`
`expense_photos`.`expense_id`
`expense_photos`.`file_name`
`expense_photos`.`uploaded_at`
`expenses_audit`.*
`expenses_audit`.`id`
`expenses_audit`.`month_name`
`expenses_audit`.`expense_date`
`expenses_audit`.`ref_number`
`expenses_audit`.`tin`
`expenses_audit`.`supplier_name`
`expenses_audit`.`particulars`
`expenses_audit`.`address`
`expenses_audit`.`amount`
`expenses_audit`.`remarks`
`expenses_audit`.`receipt_image`
`expenses_audit`.`created_at`
`graduate_senior`.*
`graduate_senior`.`id`
`graduate_senior`.`school_year`
`graduate_senior`.`student_number`
`graduate_senior`.`grade_10_section`
`graduate_senior`.`section`
`graduate_senior`.`lrn`
`graduate_senior`.`last_name`
`graduate_senior`.`first_name`
`graduate_senior`.`middle_name`
`graduate_senior`.`grade_10_school`
`graduate_senior`.`birthday`
`graduate_senior`.`address`
`graduate_senior`.`student_contact`
`graduate_senior`.`guardian_contact`
`graduate_senior`.`guardian_name`
`graduate_senior`.`four_ps`
`graduate_senior`.`account_status`
`graduate_senior`.`tuition_fee`
`graduate_senior`.`remaining_balance`
`graduate_senior`.`date_enrolled`
`graduate_senior`.`referred_by`
`graduate_senior`.`birth_certificate`
`graduate_senior`.`form_138`
`graduate_senior`.`good_moral`
`graduate_senior`.`pic_1x1`
`graduate_senior`.`pic_2x2`
`graduate_senior`.`form_137`
`graduate_senior`.`remarks`
`graduate_senior`.`graduation_fee`
`graduate_senior`.`remaining_graduation_balance`
`graduate_senior`.`email_address`
`graduate_senior`.`civil_status`
`graduate_senior`.`sex`
`graduate_senior`.`grade_level`
`graduate_senior`.`semester`
`graduate_senior`.`strand`
`graduate_senior`.`strand_id`
`graduate_senior`.`section_id`
`graduate_senior`.`father_name`
`graduate_senior`.`mother_name`
`graduate_senior`.`referral_status`
`graduate_senior`.`status`
`graduate_senior`.`remark`
`graduate_senior`.`was_transferee`
`graduate_senior`.`total_paid`
`graduate_senior`.`grade11_original_tuition`
`graduate_senior`.`is_repeater`
`graduate_senior`.`repeater_duration`
`graduate_senior`.`curriculum_version`
`graduation_junior`.*
`graduation_junior`.`payment_id`
`graduation_junior`.`student_id`
`graduation_junior`.`or_number`
`graduation_junior`.`amount_paid`
`graduation_junior`.`payment_date`
`graduation_junior`.`remarks`
`graduation_payments`.*
`graduation_payments`.`payment_id`
`graduation_payments`.`student_id`
`graduation_payments`.`or_number`
`graduation_payments`.`amount_paid`
`graduation_payments`.`payment_date`
`graduation_payments`.`remarks`
`graduation_payments2`.*
`graduation_payments2`.`id`
`graduation_payments2`.`student_id`
`graduation_payments2`.`or_number`
`graduation_payments2`.`payment_date`
`graduation_payments2`.`amount`
`graduation_payments2`.`remarks`
`graduation_payments2`.`created_at`
`graduation_students2`.*
`graduation_students2`.`id`
`graduation_students2`.`school_year`
`graduation_students2`.`student_name`
`graduation_students2`.`year_level`
`graduation_students2`.`strand`
`graduation_students2`.`semester`
`graduation_students2`.`graduation_fee`
`graduation_students2`.`created_at`
`graduation_students2`.`branch`
`inventory_items`.*
`inventory_items`.`id`
`inventory_items`.`category`
`inventory_items`.`department`
`inventory_items`.`item_name`
`inventory_items`.`item_type`
`inventory_items`.`price`
`inventory_items`.`stock_quantity`
`inventory_items`.`created_at`
`inventory_logs`.*
`inventory_logs`.`id`
`inventory_logs`.`item_id`
`inventory_logs`.`user_id`
`inventory_logs`.`action`
`inventory_logs`.`quantity_changed`
`inventory_logs`.`remarks`
`inventory_logs`.`log_date`
`inventory_logs`.`log_time`
`junior_subjects`.*
`junior_subjects`.`subject_id`
`junior_subjects`.`grade_level`
`junior_subjects`.`subject_name`
`login_history`.*
`login_history`.`id`
`login_history`.`user_id`
`login_history`.`username`
`login_history`.`role`
`login_history`.`ip_address`
`login_history`.`user_agent`
`login_history`.`status`
`login_history`.`attempt_time`
`login_history`.`logout_time`
`login_history`.`session_duration`
`login_history`.`failure_reason`
`miscellaneous_fees`.*
`miscellaneous_fees`.`id`
`miscellaneous_fees`.`title`
`miscellaneous_fees`.`school_year`
`miscellaneous_fees`.`target_grade_11`
`miscellaneous_fees`.`target_grade_12`
`miscellaneous_fees`.`amount`
`miscellaneous_fees`.`created_at`
`miscellaneous_fees`.`status`
`miscellaneous_fees`.`semester`
`miscellaneous_payment_history`.*
`miscellaneous_payment_history`.`id`
`miscellaneous_payment_history`.`student_misc_id`
`miscellaneous_payment_history`.`payment_date`
`miscellaneous_payment_history`.`or_number`
`miscellaneous_payment_history`.`amount_paid`
`miscellaneous_payment_history`.`remarks`
`miscellaneous_payment_history`.`created_at`
`not_graduate_senior`.*
`not_graduate_senior`.`id`
`not_graduate_senior`.`school_year`
`not_graduate_senior`.`student_number`
`not_graduate_senior`.`grade_10_section`
`not_graduate_senior`.`section`
`not_graduate_senior`.`lrn`
`not_graduate_senior`.`last_name`
`not_graduate_senior`.`first_name`
`not_graduate_senior`.`middle_name`
`not_graduate_senior`.`grade_10_school`
`not_graduate_senior`.`birthday`
`not_graduate_senior`.`address`
`not_graduate_senior`.`student_contact`
`not_graduate_senior`.`guardian_contact`
`not_graduate_senior`.`guardian_name`
`not_graduate_senior`.`four_ps`
`not_graduate_senior`.`account_status`
`not_graduate_senior`.`tuition_fee`
`not_graduate_senior`.`remaining_balance`
`not_graduate_senior`.`date_enrolled`
`not_graduate_senior`.`referred_by`
`not_graduate_senior`.`birth_certificate`
`not_graduate_senior`.`form_138`
`not_graduate_senior`.`good_moral`
`not_graduate_senior`.`pic_1x1`
`not_graduate_senior`.`pic_2x2`
`not_graduate_senior`.`form_137`
`not_graduate_senior`.`remarks`
`not_graduate_senior`.`file_birth_certificate`
`not_graduate_senior`.`file_form_138`
`not_graduate_senior`.`file_good_moral`
`not_graduate_senior`.`file_pic_1x1`
`not_graduate_senior`.`file_pic_2x2`
`not_graduate_senior`.`file_form_137`
`not_graduate_senior`.`graduation_fee`
`not_graduate_senior`.`remaining_graduation_balance`
`not_graduate_senior`.`email_address`
`not_graduate_senior`.`civil_status`
`not_graduate_senior`.`sex`
`not_graduate_senior`.`grade_level`
`not_graduate_senior`.`semester`
`not_graduate_senior`.`strand`
`not_graduate_senior`.`strand_id`
`not_graduate_senior`.`section_id`
`not_graduate_senior`.`father_name`
`not_graduate_senior`.`mother_name`
`not_graduate_senior`.`referral_status`
`not_graduate_senior`.`status`
`not_graduate_senior`.`remark`
`not_graduate_senior`.`was_transferee`
`not_graduate_senior`.`total_paid`
`not_graduate_senior`.`grade11_original_tuition`
`not_graduate_senior`.`is_repeater`
`not_graduate_senior`.`repeater_duration`
`not_graduate_senior`.`curriculum_version`
`password_reset_logs`.*
`password_reset_logs`.`id`
`password_reset_logs`.`user_id`
`password_reset_logs`.`reset_by`
`password_reset_logs`.`reset_at`
`referral_claims`.*
`referral_claims`.`id`
`referral_claims`.`referrer_name`
`referral_claims`.`student_id`
`referral_claims`.`amount`
`referral_claims`.`part`
`referral_claims`.`claimed_at`
`referrals`.*
`referrals`.`id`
`referrals`.`referrer_name`
`referrals`.`total_referrals`
`referrals`.`total_earnings`
`referrals`.`claimed_earnings`
`referrals`.`created_at`
`registrar`.*
`registrar`.`id`
`registrar`.`username`
`registrar`.`email`
`registrar`.`password_hash`
`registrar`.`created_at`
`registrar`.`status`
`registrar`.`role`
`service_invoice_audit`.*
`service_invoice_audit`.`id`
`service_invoice_audit`.`or_number`
`service_invoice_audit`.`invoice_date`
`service_invoice_audit`.`amount`
`service_invoice_audit`.`student_name`
`service_invoice_audit`.`branch`
`service_invoice_audit`.`created_at`
`strand_subjects`.*
`strand_subjects`.`subject_id`
`strand_subjects`.`strand_id`
`strand_subjects`.`grade_level`
`strand_subjects`.`semester`
`strand_subjects`.`subject_name`
`strand_subjects`.`subject_type`
`strand_subjects`.`curriculum_version`
`student_allowances`.*
`student_allowances`.`id`
`student_allowances`.`student_id`
`student_allowances`.`school_supplies_claimed`
`student_allowances`.`transportation_claimed`
`student_allowances`.`school_supplies_claimed_at`
`student_allowances`.`transportation_claimed_at`
`student_allowances`.`school_supplies_amount`
`student_allowances`.`transportation_amount`
`student_miscellaneous`.*
`student_miscellaneous`.`id`
`student_miscellaneous`.`student_number`
`student_miscellaneous`.`misc_fee_id`
`student_miscellaneous`.`amount_due`
`student_miscellaneous`.`amount_paid`
`student_miscellaneous`.`status`
`student_payments`.*
`student_payments`.`payment_id`
`student_payments`.`payment_date`
`student_payments`.`or_number`
`student_payments`.`amount_paid`
`student_payments`.`remarks`
`student_payments`.`student_number`
`student_payments`.`school_year`
`student_payments`.`grade_level`
`student_payments`.`payment_for`
`student_payments`.`semester`
`student_payments`.`grade`
`student_payments_junior`.*
`student_payments_junior`.`payment_id`
`student_payments_junior`.`payment_date`
`student_payments_junior`.`or_number`
`student_payments_junior`.`amount_paid`
`student_payments_junior`.`remarks`
`student_payments_junior`.`lrn`
`student_payments_junior`.`school_year`
`student_payments_junior`.`student_number`
`student_payments_junior`.`payment_for`
`student_subjects`.*
`student_subjects`.`student_subject_id`
`student_subjects`.`enrolled_student_id`
`student_subjects`.`subject_name`
`system_logs`.*
`system_logs`.`id`
`system_logs`.`user_id`
`system_logs`.`username`
`system_logs`.`user_role`
`system_logs`.`log_type`
`system_logs`.`module`
`system_logs`.`action`
`system_logs`.`record_id`
`system_logs`.`ip_address`
`system_logs`.`user_agent`
`system_logs`.`message`
`system_logs`.`details`
`system_logs`.`severity`
`system_logs`.`file_path`
`system_logs`.`line_number`
`system_logs`.`execution_time`
`system_logs`.`memory_usage`
`system_logs`.`timestamp`
`system_update_logs`.*
`system_update_logs`.`id`
`system_update_logs`.`version`
`system_update_logs`.`title`
`system_update_logs`.`description`
`system_update_logs`.`created_by`
`system_update_logs`.`created_at`
`system_updates`.*
`system_updates`.`id`
`system_updates`.`version`
`system_updates`.`title`
`system_updates`.`description`
`system_updates`.`created_at`
`transferred_out`.*
`transferred_out`.`id`
`transferred_out`.`school_year`
`transferred_out`.`student_number`
`transferred_out`.`grade_10_section`
`transferred_out`.`section`
`transferred_out`.`lrn`
`transferred_out`.`last_name`
`transferred_out`.`first_name`
`transferred_out`.`middle_name`
`transferred_out`.`grade_10_school`
`transferred_out`.`birthday`
`transferred_out`.`address`
`transferred_out`.`student_contact`
`transferred_out`.`guardian_contact`
`transferred_out`.`guardian_name`
`transferred_out`.`four_ps`
`transferred_out`.`account_status`
`transferred_out`.`tuition_fee`
`transferred_out`.`remaining_balance`
`transferred_out`.`date_enrolled`
`transferred_out`.`referred_by`
`transferred_out`.`birth_certificate`
`transferred_out`.`form_138`
`transferred_out`.`good_moral`
`transferred_out`.`pic_1x1`
`transferred_out`.`pic_2x2`
`transferred_out`.`form_137`
`transferred_out`.`remarks`
`transferred_out`.`file_birth_certificate`
`transferred_out`.`file_form_138`
`transferred_out`.`file_good_moral`
`transferred_out`.`file_pic_1x1`
`transferred_out`.`file_pic_2x2`
`transferred_out`.`file_form_137`
`transferred_out`.`graduation_fee`
`transferred_out`.`remaining_graduation_balance`
`transferred_out`.`email_address`
`transferred_out`.`civil_status`
`transferred_out`.`sex`
`transferred_out`.`grade_level`
`transferred_out`.`semester`
`transferred_out`.`strand`
`transferred_out`.`strand_id`
`transferred_out`.`section_id`
`transferred_out`.`father_name`
`transferred_out`.`mother_name`
`transferred_out`.`referral_status`
`transferred_out`.`status`
`transferred_out`.`remark`
`transferred_out`.`was_transferee`
`transferred_out`.`total_paid`
`transferred_out`.`grade11_original_tuition`
`transferred_out`.`is_repeater`
`transferred_out`.`repeater_duration`
`transferred_out`.`curriculum_version`
`users`.*
`users`.`id`
`users`.`username`
`users`.`full_name`
`users`.`email`
`users`.`password_hash`
`users`.`created_at`
`users`.`last_login`
`users`.`status`
`users`.`role`
`users`.`department`
`users`.`last_active`
`users`.`google_auth_secret`
`voided_payments`.*
`voided_payments`.`id`
`voided_payments`.`original_id`
`voided_payments`.`student_id`
`voided_payments`.`or_number`
`voided_payments`.`amount`
`voided_payments`.`payment_date`
`voided_payments`.`original_remarks`
`voided_payments`.`void_reason`
`voided_payments`.`voided_by`
`voided_payments`.`date_voided`
`accessories_senior`.*
`accessories_senior`.`id`
`accessories_senior`.`student_id`
`accessories_senior`.`id_card`
`accessories_senior`.`id_lace`
`accessories_senior`.`pe_uniform`
`accessories_senior`.`school_uniform`
`active_sessions`.*
`active_sessions`.`id`
`active_sessions`.`user_id`
`active_sessions`.`username`
`active_sessions`.`role`
`active_sessions`.`ip_address`
`active_sessions`.`page_url`
`active_sessions`.`user_agent`
`active_sessions`.`login_time`
`active_sessions`.`last_activity`
`cashier`.*
`cashier`.`id`
`cashier`.`username`
`cashier`.`email`
`cashier`.`password_hash`
`cashier`.`created_at`
`cashier`.`status`
`cashier`.`role`
`chat_messages`.*
`chat_messages`.`id`
`chat_messages`.`sender_id`
`chat_messages`.`sender_name`
`chat_messages`.`receiver_id`
`chat_messages`.`message`
`chat_messages`.`is_read`
`chat_messages`.`created_at`
`dbias_sections`.*
`dbias_sections`.`section_id`
`dbias_sections`.`section_name`
`dbias_sections`.`strand_id`
`dbias_sections`.`semester`
`dbias_sections`.`grade_level`
`dbias_sections_junior`.*
`dbias_sections_junior`.`section_id`
`dbias_sections_junior`.`section_name`
`dbias_sections_junior`.`grade_level`
`dbias_strands`.*
`dbias_strands`.`strand_id`
`dbias_strands`.`strand_name`
`dropped_junior`.*
`dropped_junior`.`id`
`dropped_junior`.`school_year`
`dropped_junior`.`place_birth`
`dropped_junior`.`lrn`
`dropped_junior`.`last_name`
`dropped_junior`.`first_name`
`dropped_junior`.`middle_name`
`dropped_junior`.`grade_6_school`
`dropped_junior`.`birthday`
`dropped_junior`.`address`
`dropped_junior`.`guardian_contact`
`dropped_junior`.`guardian_name`
`dropped_junior`.`father_name`
`dropped_junior`.`mother_name`
`dropped_junior`.`father_contact`
`dropped_junior`.`mother_contact`
`dropped_junior`.`cashier_status`
`dropped_junior`.`account_status`
`dropped_junior`.`tuition_fee`
`dropped_junior`.`remaining_balance`
`dropped_junior`.`date_enrolled`
`dropped_junior`.`birth_certificate`
`dropped_junior`.`form_138`
`dropped_junior`.`good_moral`
`dropped_junior`.`pic_1x1`
`dropped_junior`.`pic_2x2`
`dropped_junior`.`form_137`
`dropped_junior`.`civil_status`
`dropped_junior`.`sex`
`dropped_junior`.`grade_level`
`dropped_junior`.`section_id`
`dropped_junior`.`student_number`
`dropped_junior`.`student_contact`
`dropped_junior`.`remarks`
`dropped_students`.*
`dropped_students`.`id`
`dropped_students`.`school_year`
`dropped_students`.`student_number`
`dropped_students`.`grade_10_section`
`dropped_students`.`section`
`dropped_students`.`lrn`
`dropped_students`.`last_name`
`dropped_students`.`first_name`
`dropped_students`.`middle_name`
`dropped_students`.`grade_10_school`
`dropped_students`.`birthday`
`dropped_students`.`address`
`dropped_students`.`student_contact`
`dropped_students`.`guardian_contact`
`dropped_students`.`guardian_name`
`dropped_students`.`four_ps`
`dropped_students`.`account_status`
`dropped_students`.`tuition_fee`
`dropped_students`.`remaining_balance`
`dropped_students`.`date_enrolled`
`dropped_students`.`referred_by`
`dropped_students`.`birth_certificate`
`dropped_students`.`form_138`
`dropped_students`.`good_moral`
`dropped_students`.`pic_1x1`
`dropped_students`.`pic_2x2`
`dropped_students`.`form_137`
`dropped_students`.`remarks`
`dropped_students`.`file_birth_certificate`
`dropped_students`.`file_form_138`
`dropped_students`.`file_good_moral`
`dropped_students`.`file_pic_1x1`
`dropped_students`.`file_pic_2x2`
`dropped_students`.`file_form_137`
`dropped_students`.`graduation_fee`
`dropped_students`.`remaining_graduation_balance`
`dropped_students`.`email_address`
`dropped_students`.`civil_status`
`dropped_students`.`sex`
`dropped_students`.`grade_level`
`dropped_students`.`semester`
`dropped_students`.`strand`
`dropped_students`.`strand_id`
`dropped_students`.`section_id`
`dropped_students`.`father_name`
`dropped_students`.`mother_name`
`dropped_students`.`referral_status`
`dropped_students`.`status`
`dropped_students`.`remark`
`dropped_students`.`was_transferee`
`dropped_students`.`total_paid`
`dropped_students`.`grade11_original_tuition`
`dropped_students`.`is_repeater`
`dropped_students`.`repeater_duration`
`dropped_students`.`curriculum_version`
`enrolled_junior`.*
`enrolled_junior`.`id`
`enrolled_junior`.`school_year`
`enrolled_junior`.`place_birth`
`enrolled_junior`.`lrn`
`enrolled_junior`.`last_name`
`enrolled_junior`.`first_name`
`enrolled_junior`.`middle_name`
`enrolled_junior`.`grade_6_school`
`enrolled_junior`.`birthday`
`enrolled_junior`.`address`
`enrolled_junior`.`guardian_contact`
`enrolled_junior`.`guardian_name`
`enrolled_junior`.`father_name`
`enrolled_junior`.`mother_name`
`enrolled_junior`.`father_contact`
`enrolled_junior`.`mother_contact`
`enrolled_junior`.`cashier_status`
`enrolled_junior`.`account_status`
`enrolled_junior`.`tuition_fee`
`enrolled_junior`.`remaining_balance`
`enrolled_junior`.`graduation_fee`
`enrolled_junior`.`remaining_graduation_balance`
`enrolled_junior`.`date_enrolled`
`enrolled_junior`.`birth_certificate`
`enrolled_junior`.`form_138`
`enrolled_junior`.`good_moral`
`enrolled_junior`.`pic_1x1`
`enrolled_junior`.`pic_2x2`
`enrolled_junior`.`form_137`
`enrolled_junior`.`civil_status`
`enrolled_junior`.`sex`
`enrolled_junior`.`grade_level`
`enrolled_junior`.`section_id`
`enrolled_junior`.`student_number`
`enrolled_junior`.`student_contact`
`enrolled_students`.*
`enrolled_students`.`id`
`enrolled_students`.`school_year`
`enrolled_students`.`student_number`
`enrolled_students`.`grade_10_section`
`enrolled_students`.`section`
`enrolled_students`.`lrn`
`enrolled_students`.`last_name`
`enrolled_students`.`first_name`
`enrolled_students`.`middle_name`
`enrolled_students`.`grade_10_school`
`enrolled_students`.`birthday`
`enrolled_students`.`address`
`enrolled_students`.`student_contact`
`enrolled_students`.`guardian_contact`
`enrolled_students`.`guardian_name`
`enrolled_students`.`four_ps`
`enrolled_students`.`account_status`
`enrolled_students`.`tuition_fee`
`enrolled_students`.`remaining_balance`
`enrolled_students`.`date_enrolled`
`enrolled_students`.`referred_by`
`enrolled_students`.`birth_certificate`
`enrolled_students`.`form_138`
`enrolled_students`.`good_moral`
`enrolled_students`.`pic_1x1`
`enrolled_students`.`pic_2x2`
`enrolled_students`.`form_137`
`enrolled_students`.`remarks`
`enrolled_students`.`file_birth_certificate`
`enrolled_students`.`file_form_138`
`enrolled_students`.`file_good_moral`
`enrolled_students`.`file_pic_1x1`
`enrolled_students`.`file_pic_2x2`
`enrolled_students`.`file_form_137`
`enrolled_students`.`graduation_fee`
`enrolled_students`.`remaining_graduation_balance`
`enrolled_students`.`email_address`
`enrolled_students`.`civil_status`
`enrolled_students`.`sex`
`enrolled_students`.`grade_level`
`enrolled_students`.`semester`
`enrolled_students`.`strand`
`enrolled_students`.`strand_id`
`enrolled_students`.`section_id`
`enrolled_students`.`father_name`
`enrolled_students`.`mother_name`
`enrolled_students`.`referral_status`
`enrolled_students`.`status`
`enrolled_students`.`remark`
`enrolled_students`.`was_transferee`
`enrolled_students`.`total_paid`
`enrolled_students`.`grade11_original_tuition`
`enrolled_students`.`is_repeater`
`enrolled_students`.`repeater_duration`
`enrolled_students`.`curriculum_version`
`enrolling_junior`.*
`enrolling_junior`.`id`
`enrolling_junior`.`school_year`
`enrolling_junior`.`place_birth`
`enrolling_junior`.`lrn`
`enrolling_junior`.`last_name`
`enrolling_junior`.`first_name`
`enrolling_junior`.`middle_name`
`enrolling_junior`.`grade_6_school`
`enrolling_junior`.`birthday`
`enrolling_junior`.`address`
`enrolling_junior`.`guardian_contact`
`enrolling_junior`.`guardian_name`
`enrolling_junior`.`father_name`
`enrolling_junior`.`mother_name`
`enrolling_junior`.`father_contact`
`enrolling_junior`.`mother_contact`
`enrolling_junior`.`cashier_status`
`enrolling_junior`.`account_status`
`enrolling_junior`.`tuition_fee`
`enrolling_junior`.`remaining_balance`
`enrolling_junior`.`date_enrolled`
`enrolling_junior`.`birth_certificate`
`enrolling_junior`.`form_138`
`enrolling_junior`.`good_moral`
`enrolling_junior`.`pic_1x1`
`enrolling_junior`.`pic_2x2`
`enrolling_junior`.`form_137`
`enrolling_junior`.`civil_status`
`enrolling_junior`.`sex`
`enrolling_junior`.`grade_level`
`enrolling_junior`.`section_id`
`enrolling_junior`.`student_number`
`enrolling_junior`.`student_contact`
`enrolling_students`.*
`enrolling_students`.`id`
`enrolling_students`.`school_year`
`enrolling_students`.`student_number`
`enrolling_students`.`grade_10_section`
`enrolling_students`.`section`
`enrolling_students`.`lrn`
`enrolling_students`.`last_name`
`enrolling_students`.`first_name`
`enrolling_students`.`middle_name`
`enrolling_students`.`grade_10_school`
`enrolling_students`.`birthday`
`enrolling_students`.`address`
`enrolling_students`.`student_contact`
`enrolling_students`.`guardian_contact`
`enrolling_students`.`guardian_name`
`enrolling_students`.`four_ps`
`enrolling_students`.`account_status`
`enrolling_students`.`cashier_status`
`enrolling_students`.`tuition_fee`
`enrolling_students`.`remaining_balance`
`enrolling_students`.`date_enrolled`
`enrolling_students`.`referred_by`
`enrolling_students`.`birth_certificate`
`enrolling_students`.`form_138`
`enrolling_students`.`good_moral`
`enrolling_students`.`pic_1x1`
`enrolling_students`.`pic_2x2`
`enrolling_students`.`form_137`
`enrolling_students`.`remarks`
`enrolling_students`.`email_address`
`enrolling_students`.`civil_status`
`enrolling_students`.`sex`
`enrolling_students`.`grade_level`
`enrolling_students`.`semester`
`enrolling_students`.`strand`
`enrolling_students`.`strand_id`
`enrolling_students`.`section_id`
`enrolling_students`.`father_name`
`enrolling_students`.`mother_name`
`enrolling_students`.`curriculum_version`
`expense_particulars`.*
`expense_particulars`.`id`
`expense_particulars`.`name`
`expense_photos`.*
`expense_photos`.`id`
`expense_photos`.`expense_id`
`expense_photos`.`file_name`
`expense_photos`.`uploaded_at`
`expenses_audit`.*
`expenses_audit`.`id`
`expenses_audit`.`month_name`
`expenses_audit`.`expense_date`
`expenses_audit`.`ref_number`
`expenses_audit`.`tin`
`expenses_audit`.`supplier_name`
`expenses_audit`.`particulars`
`expenses_audit`.`address`
`expenses_audit`.`amount`
`expenses_audit`.`remarks`
`expenses_audit`.`receipt_image`
`expenses_audit`.`created_at`
`graduate_senior`.*
`graduate_senior`.`id`
`graduate_senior`.`school_year`
`graduate_senior`.`student_number`
`graduate_senior`.`grade_10_section`
`graduate_senior`.`section`
`graduate_senior`.`lrn`
`graduate_senior`.`last_name`
`graduate_senior`.`first_name`
`graduate_senior`.`middle_name`
`graduate_senior`.`grade_10_school`
`graduate_senior`.`birthday`
`graduate_senior`.`address`
`graduate_senior`.`student_contact`
`graduate_senior`.`guardian_contact`
`graduate_senior`.`guardian_name`
`graduate_senior`.`four_ps`
`graduate_senior`.`account_status`
`graduate_senior`.`tuition_fee`
`graduate_senior`.`remaining_balance`
`graduate_senior`.`date_enrolled`
`graduate_senior`.`referred_by`
`graduate_senior`.`birth_certificate`
`graduate_senior`.`form_138`
`graduate_senior`.`good_moral`
`graduate_senior`.`pic_1x1`
`graduate_senior`.`pic_2x2`
`graduate_senior`.`form_137`
`graduate_senior`.`remarks`
`graduate_senior`.`graduation_fee`
`graduate_senior`.`remaining_graduation_balance`
`graduate_senior`.`email_address`
`graduate_senior`.`civil_status`
`graduate_senior`.`sex`
`graduate_senior`.`grade_level`
`graduate_senior`.`semester`
`graduate_senior`.`strand`
`graduate_senior`.`strand_id`
`graduate_senior`.`section_id`
`graduate_senior`.`father_name`
`graduate_senior`.`mother_name`
`graduate_senior`.`referral_status`
`graduate_senior`.`status`
`graduate_senior`.`remark`
`graduate_senior`.`was_transferee`
`graduate_senior`.`total_paid`
`graduate_senior`.`grade11_original_tuition`
`graduate_senior`.`is_repeater`
`graduate_senior`.`repeater_duration`
`graduate_senior`.`curriculum_version`
`graduation_junior`.*
`graduation_junior`.`payment_id`
`graduation_junior`.`student_id`
`graduation_junior`.`or_number`
`graduation_junior`.`amount_paid`
`graduation_junior`.`payment_date`
`graduation_junior`.`remarks`
`graduation_payments`.*
`graduation_payments`.`payment_id`
`graduation_payments`.`student_id`
`graduation_payments`.`or_number`
`graduation_payments`.`amount_paid`
`graduation_payments`.`payment_date`
`graduation_payments`.`remarks`
`graduation_payments2`.*
`graduation_payments2`.`id`
`graduation_payments2`.`student_id`
`graduation_payments2`.`or_number`
`graduation_payments2`.`payment_date`
`graduation_payments2`.`amount`
`graduation_payments2`.`remarks`
`graduation_payments2`.`created_at`
`graduation_students2`.*
`graduation_students2`.`id`
`graduation_students2`.`school_year`
`graduation_students2`.`student_name`
`graduation_students2`.`year_level`
`graduation_students2`.`strand`
`graduation_students2`.`semester`
`graduation_students2`.`graduation_fee`
`graduation_students2`.`created_at`
`graduation_students2`.`branch`
`inventory_items`.*
`inventory_items`.`id`
`inventory_items`.`category`
`inventory_items`.`department`
`inventory_items`.`item_name`
`inventory_items`.`item_type`
`inventory_items`.`price`
`inventory_items`.`stock_quantity`
`inventory_items`.`created_at`
`inventory_logs`.*
`inventory_logs`.`id`
`inventory_logs`.`item_id`
`inventory_logs`.`user_id`
`inventory_logs`.`action`
`inventory_logs`.`quantity_changed`
`inventory_logs`.`remarks`
`inventory_logs`.`log_date`
`inventory_logs`.`log_time`
`junior_subjects`.*
`junior_subjects`.`subject_id`
`junior_subjects`.`grade_level`
`junior_subjects`.`subject_name`
`login_history`.*
`login_history`.`id`
`login_history`.`user_id`
`login_history`.`username`
`login_history`.`role`
`login_history`.`ip_address`
`login_history`.`user_agent`
`login_history`.`status`
`login_history`.`attempt_time`
`login_history`.`logout_time`
`login_history`.`session_duration`
`login_history`.`failure_reason`
`miscellaneous_fees`.*
`miscellaneous_fees`.`id`
`miscellaneous_fees`.`title`
`miscellaneous_fees`.`school_year`
`miscellaneous_fees`.`target_grade_11`
`miscellaneous_fees`.`target_grade_12`
`miscellaneous_fees`.`amount`
`miscellaneous_fees`.`created_at`
`miscellaneous_fees`.`status`
`miscellaneous_fees`.`semester`
`miscellaneous_payment_history`.*
`miscellaneous_payment_history`.`id`
`miscellaneous_payment_history`.`student_misc_id`
`miscellaneous_payment_history`.`payment_date`
`miscellaneous_payment_history`.`or_number`
`miscellaneous_payment_history`.`amount_paid`
`miscellaneous_payment_history`.`remarks`
`miscellaneous_payment_history`.`created_at`
`not_graduate_senior`.*
`not_graduate_senior`.`id`
`not_graduate_senior`.`school_year`
`not_graduate_senior`.`student_number`
`not_graduate_senior`.`grade_10_section`
`not_graduate_senior`.`section`
`not_graduate_senior`.`lrn`
`not_graduate_senior`.`last_name`
`not_graduate_senior`.`first_name`
`not_graduate_senior`.`middle_name`
`not_graduate_senior`.`grade_10_school`
`not_graduate_senior`.`birthday`
`not_graduate_senior`.`address`
`not_graduate_senior`.`student_contact`
`not_graduate_senior`.`guardian_contact`
`not_graduate_senior`.`guardian_name`
`not_graduate_senior`.`four_ps`
`not_graduate_senior`.`account_status`
`not_graduate_senior`.`tuition_fee`
`not_graduate_senior`.`remaining_balance`
`not_graduate_senior`.`date_enrolled`
`not_graduate_senior`.`referred_by`
`not_graduate_senior`.`birth_certificate`
`not_graduate_senior`.`form_138`
`not_graduate_senior`.`good_moral`
`not_graduate_senior`.`pic_1x1`
`not_graduate_senior`.`pic_2x2`
`not_graduate_senior`.`form_137`
`not_graduate_senior`.`remarks`
`not_graduate_senior`.`file_birth_certificate`
`not_graduate_senior`.`file_form_138`
`not_graduate_senior`.`file_good_moral`
`not_graduate_senior`.`file_pic_1x1`
`not_graduate_senior`.`file_pic_2x2`
`not_graduate_senior`.`file_form_137`
`not_graduate_senior`.`graduation_fee`
`not_graduate_senior`.`remaining_graduation_balance`
`not_graduate_senior`.`email_address`
`not_graduate_senior`.`civil_status`
`not_graduate_senior`.`sex`
`not_graduate_senior`.`grade_level`
`not_graduate_senior`.`semester`
`not_graduate_senior`.`strand`
`not_graduate_senior`.`strand_id`
`not_graduate_senior`.`section_id`
`not_graduate_senior`.`father_name`
`not_graduate_senior`.`mother_name`
`not_graduate_senior`.`referral_status`
`not_graduate_senior`.`status`
`not_graduate_senior`.`remark`
`not_graduate_senior`.`was_transferee`
`not_graduate_senior`.`total_paid`
`not_graduate_senior`.`grade11_original_tuition`
`not_graduate_senior`.`is_repeater`
`not_graduate_senior`.`repeater_duration`
`not_graduate_senior`.`curriculum_version`
`password_reset_logs`.*
`password_reset_logs`.`id`
`password_reset_logs`.`user_id`
`password_reset_logs`.`reset_by`
`password_reset_logs`.`reset_at`
`referral_claims`.*
`referral_claims`.`id`
`referral_claims`.`referrer_name`
`referral_claims`.`student_id`
`referral_claims`.`amount`
`referral_claims`.`part`
`referral_claims`.`claimed_at`
`referrals`.*
`referrals`.`id`
`referrals`.`referrer_name`
`referrals`.`total_referrals`
`referrals`.`total_earnings`
`referrals`.`claimed_earnings`
`referrals`.`created_at`
`registrar`.*
`registrar`.`id`
`registrar`.`username`
`registrar`.`email`
`registrar`.`password_hash`
`registrar`.`created_at`
`registrar`.`status`
`registrar`.`role`
`service_invoice_audit`.*
`service_invoice_audit`.`id`
`service_invoice_audit`.`or_number`
`service_invoice_audit`.`invoice_date`
`service_invoice_audit`.`amount`
`service_invoice_audit`.`student_name`
`service_invoice_audit`.`branch`
`service_invoice_audit`.`created_at`
`strand_subjects`.*
`strand_subjects`.`subject_id`
`strand_subjects`.`strand_id`
`strand_subjects`.`grade_level`
`strand_subjects`.`semester`
`strand_subjects`.`subject_name`
`strand_subjects`.`subject_type`
`strand_subjects`.`curriculum_version`
`student_allowances`.*
`student_allowances`.`id`
`student_allowances`.`student_id`
`student_allowances`.`school_supplies_claimed`
`student_allowances`.`transportation_claimed`
`student_allowances`.`school_supplies_claimed_at`
`student_allowances`.`transportation_claimed_at`
`student_allowances`.`school_supplies_amount`
`student_allowances`.`transportation_amount`
`student_miscellaneous`.*
`student_miscellaneous`.`id`
`student_miscellaneous`.`student_number`
`student_miscellaneous`.`misc_fee_id`
`student_miscellaneous`.`amount_due`
`student_miscellaneous`.`amount_paid`
`student_miscellaneous`.`status`
`student_payments`.*
`student_payments`.`payment_id`
`student_payments`.`payment_date`
`student_payments`.`or_number`
`student_payments`.`amount_paid`
`student_payments`.`remarks`
`student_payments`.`student_number`
`student_payments`.`school_year`
`student_payments`.`grade_level`
`student_payments`.`payment_for`
`student_payments`.`semester`
`student_payments`.`grade`
`student_payments_junior`.*
`student_payments_junior`.`payment_id`
`student_payments_junior`.`payment_date`
`student_payments_junior`.`or_number`
`student_payments_junior`.`amount_paid`
`student_payments_junior`.`remarks`
`student_payments_junior`.`lrn`
`student_payments_junior`.`school_year`
`student_payments_junior`.`student_number`
`student_payments_junior`.`payment_for`
`student_subjects`.*
`student_subjects`.`student_subject_id`
`student_subjects`.`enrolled_student_id`
`student_subjects`.`subject_name`
`system_logs`.*
`system_logs`.`id`
`system_logs`.`user_id`
`system_logs`.`username`
`system_logs`.`user_role`
`system_logs`.`log_type`
`system_logs`.`module`
`system_logs`.`action`
`system_logs`.`record_id`
`system_logs`.`ip_address`
`system_logs`.`user_agent`
`system_logs`.`message`
`system_logs`.`details`
`system_logs`.`severity`
`system_logs`.`file_path`
`system_logs`.`line_number`
`system_logs`.`execution_time`
`system_logs`.`memory_usage`
`system_logs`.`timestamp`
`system_update_logs`.*
`system_update_logs`.`id`
`system_update_logs`.`version`
`system_update_logs`.`title`
`system_update_logs`.`description`
`system_update_logs`.`created_by`
`system_update_logs`.`created_at`
`system_updates`.*
`system_updates`.`id`
`system_updates`.`version`
`system_updates`.`title`
`system_updates`.`description`
`system_updates`.`created_at`
`transferred_out`.*
`transferred_out`.`id`
`transferred_out`.`school_year`
`transferred_out`.`student_number`
`transferred_out`.`grade_10_section`
`transferred_out`.`section`
`transferred_out`.`lrn`
`transferred_out`.`last_name`
`transferred_out`.`first_name`
`transferred_out`.`middle_name`
`transferred_out`.`grade_10_school`
`transferred_out`.`birthday`
`transferred_out`.`address`
`transferred_out`.`student_contact`
`transferred_out`.`guardian_contact`
`transferred_out`.`guardian_name`
`transferred_out`.`four_ps`
`transferred_out`.`account_status`
`transferred_out`.`tuition_fee`
`transferred_out`.`remaining_balance`
`transferred_out`.`date_enrolled`
`transferred_out`.`referred_by`
`transferred_out`.`birth_certificate`
`transferred_out`.`form_138`
`transferred_out`.`good_moral`
`transferred_out`.`pic_1x1`
`transferred_out`.`pic_2x2`
`transferred_out`.`form_137`
`transferred_out`.`remarks`
`transferred_out`.`file_birth_certificate`
`transferred_out`.`file_form_138`
`transferred_out`.`file_good_moral`
`transferred_out`.`file_pic_1x1`
`transferred_out`.`file_pic_2x2`
`transferred_out`.`file_form_137`
`transferred_out`.`graduation_fee`
`transferred_out`.`remaining_graduation_balance`
`transferred_out`.`email_address`
`transferred_out`.`civil_status`
`transferred_out`.`sex`
`transferred_out`.`grade_level`
`transferred_out`.`semester`
`transferred_out`.`strand`
`transferred_out`.`strand_id`
`transferred_out`.`section_id`
`transferred_out`.`father_name`
`transferred_out`.`mother_name`
`transferred_out`.`referral_status`
`transferred_out`.`status`
`transferred_out`.`remark`
`transferred_out`.`was_transferee`
`transferred_out`.`total_paid`
`transferred_out`.`grade11_original_tuition`
`transferred_out`.`is_repeater`
`transferred_out`.`repeater_duration`
`transferred_out`.`curriculum_version`
`users`.*
`users`.`id`
`users`.`username`
`users`.`full_name`
`users`.`email`
`users`.`password_hash`
`users`.`created_at`
`users`.`last_login`
`users`.`status`
`users`.`role`
`users`.`department`
`users`.`last_active`
`users`.`google_auth_secret`
`voided_payments`.*
`voided_payments`.`id`
`voided_payments`.`original_id`
`voided_payments`.`student_id`
`voided_payments`.`or_number`
`voided_payments`.`amount`
`voided_payments`.`payment_date`
`voided_payments`.`original_remarks`
`voided_payments`.`void_reason`
`voided_payments`.`voided_by`
`voided_payments`.`date_voided`
Alias:
Show:
Sort:
Ascending
Descending
Ascending
Descending
Ascending
Descending
Sort order:
1
2
3
1
2
3
1
2
3
Criteria:
Ins:
And:
Del:
Or:
Modify:
Or:
And:
Ins
Del
Or:
And:
Ins
Del
Ins
Del
Add/Delete criteria rows:
-3
-2
-1
0
1
2
3
Add/Delete columns:
-3
-2
-1
0
1
2
3
Use tables
accessories_senior
active_sessions
cashier
chat_messages
dbias_sections
dbias_sections_junior
dbias_strands
dropped_junior
dropped_students
enrolled_junior
enrolled_students
enrolling_junior
enrolling_students
expense_particulars
expense_photos
expenses_audit
graduate_senior
graduation_junior
graduation_payments
graduation_payments2
graduation_students2
inventory_items
inventory_logs
junior_subjects
login_history
miscellaneous_fees
miscellaneous_payment_history
not_graduate_senior
password_reset_logs
referral_claims
referrals
registrar
service_invoice_audit
strand_subjects
student_allowances
student_miscellaneous
student_payments
student_payments_junior
student_subjects
system_logs
system_update_logs
system_updates
transferred_out
users
voided_payments
SQL query on database
dbias_master2
: