gambia.feste-ip.net / 127.0.0.1 / school_management

There are no favorite tables.

New
axiuss40_africa
car_program
- car_program
- car_program_staging
illness_checker
- illness_checker
- illness_checker_staging
information_schema
mysql
performance_schema
school_management
task_manager
test

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 :

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 Query failed Database : Queried time :

Untitled *

v		school_management academic_periods
id : bigint(20) unsigned
academic_year_id : bigint(20) unsigned
name : varchar(255)
sequence : tinyint(3) unsigned
starts_on : date
ends_on : date
standard_fee : decimal(12,2)
created_at : timestamp
updated_at : timestamp

v		school_management academic_years
id : bigint(20) unsigned
name : varchar(255)
starts_on : date
ends_on : date
period_type : varchar(20)
is_closed : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		school_management activity_logs
id : bigint(20) unsigned
user_id : bigint(20) unsigned
action : varchar(40)
subject_type : varchar(100)
subject_id : bigint(20) unsigned
before : longtext
after : longtext
ip_address : varchar(45)
created_at : timestamp
updated_at : timestamp

v		school_management cache
key : varchar(255)
value : mediumtext
expiration : int(11)

v		school_management cache_locks
key : varchar(255)
owner : varchar(255)
expiration : int(11)

v		school_management class_teacher_assignments
id : bigint(20) unsigned
school_class_id : bigint(20) unsigned
teacher_id : bigint(20) unsigned
role : varchar(30)
valid_from : date
valid_until : date
created_at : timestamp
updated_at : timestamp

v		school_management contact_people
id : bigint(20) unsigned
first_name : varchar(255)
last_name : varchar(255)
residence_id : bigint(20) unsigned
email : varchar(255)
phone_1 : varchar(40)
phone_1_whatsapp : tinyint(1)
phone_2 : varchar(40)
phone_2_whatsapp : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		school_management contact_person_student
id : bigint(20) unsigned
student_id : bigint(20) unsigned
contact_person_id : bigint(20) unsigned
relationship_id : bigint(20) unsigned
priority : tinyint(3) unsigned
created_at : timestamp
updated_at : timestamp

v		school_management data_migration_issues
id : bigint(20) unsigned
migration_name : varchar(255)
table_name : varchar(255)
record_id : bigint(20) unsigned
issue_code : varchar(255)
details : longtext
resolved_at : timestamp
resolved_by : bigint(20) unsigned
resolution_note : varchar(500)
created_at : timestamp
updated_at : timestamp

v		school_management edit_locks
id : bigint(20) unsigned
resource_type : varchar(80)
resource_id : bigint(20) unsigned
user_id : bigint(20) unsigned
expires_at : timestamp
created_at : timestamp
updated_at : timestamp

v		school_management fee_payments
id : bigint(20) unsigned
student_period_fee_id : bigint(20) unsigned
amount : decimal(12,2)
paid_on : date
payment_method : varchar(30)
receipt_number : varchar(255)
note : text
reversed_at : timestamp
reversed_by : bigint(20) unsigned
reversal_reason : varchar(500)
recorded_by : bigint(20) unsigned
created_at : timestamp
updated_at : timestamp

v		school_management grade_levels
id : bigint(20) unsigned
name : varchar(255)
sequence : smallint(5) unsigned
valid_from : date
valid_until : date
created_at : timestamp
updated_at : timestamp

v		school_management migrations
id : int(10) unsigned
migration : varchar(255)
batch : int(11)

v		school_management password_reset_tokens
email : varchar(255)
token : varchar(255)
created_at : timestamp

v		school_management reference_values
id : bigint(20) unsigned
type : varchar(40)
name : varchar(255)
valid_from : date
valid_until : date
created_at : timestamp
updated_at : timestamp

v		school_management school_classes
id : bigint(20) unsigned
academic_year_id : bigint(20) unsigned
grade_level_id : bigint(20) unsigned
name : varchar(255)
capacity : smallint(5) unsigned
valid_from : date
valid_until : date
created_at : timestamp
updated_at : timestamp

v		school_management school_settings
id : bigint(20) unsigned
school_name : varchar(255)
address : text
emails : longtext
phone_numbers : longtext
currency_code : char(3)
logo_path : varchar(255)
grade_level_count : smallint(5) unsigned
updated_by : bigint(20) unsigned
created_at : timestamp
updated_at : timestamp

v		school_management sessions
id : varchar(255)
user_id : bigint(20) unsigned
ip_address : varchar(45)
user_agent : text
payload : longtext
last_activity : int(11)

v		school_management setting_histories
id : bigint(20) unsigned
school_setting_id : bigint(20) unsigned
snapshot : longtext
valid_from : datetime
valid_until : datetime
changed_by : bigint(20) unsigned
created_at : timestamp
updated_at : timestamp

v		school_management students
id : bigint(20) unsigned
student_number : varchar(255)
first_name : varchar(255)
last_name : varchar(255)
gender : varchar(10)
date_of_birth : date
nationality_id : bigint(20) unsigned
religion_id : bigint(20) unsigned
residence_id : bigint(20) unsigned
photo_path : varchar(255)
status : varchar(20)
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		school_management student_class_enrolments
id : bigint(20) unsigned
student_id : bigint(20) unsigned
school_class_id : bigint(20) unsigned
valid_from : date
valid_until : date
created_at : timestamp
updated_at : timestamp

v		school_management student_period_fees
id : bigint(20) unsigned
student_id : bigint(20) unsigned
academic_period_id : bigint(20) unsigned
amount_due : decimal(12,2)
is_custom_amount : tinyint(1)
amount_paid : decimal(12,2)
status : varchar(20)
due_on : date
created_at : timestamp
updated_at : timestamp

v		school_management subjects
id : bigint(20) unsigned
name : varchar(255)
code : varchar(20)
valid_from : date
valid_until : date
created_at : timestamp
updated_at : timestamp

v		school_management subject_assignments
id : bigint(20) unsigned
subject_id : bigint(20) unsigned
grade_level_id : bigint(20) unsigned
school_class_id : bigint(20) unsigned
valid_from : date
valid_until : date
created_at : timestamp
updated_at : timestamp

v		school_management teachers
id : bigint(20) unsigned
first_name : varchar(255)
last_name : varchar(255)
gender : varchar(10)
date_of_birth : date
nationality_id : bigint(20) unsigned
religion_id : bigint(20) unsigned
job_title_id : bigint(20) unsigned
residence_id : bigint(20) unsigned
email : varchar(255)
phone_1 : varchar(40)
phone_1_whatsapp : tinyint(1)
phone_2 : varchar(40)
phone_2_whatsapp : tinyint(1)
employment_started_on : date
employment_ended_on : date
created_at : timestamp
updated_at : timestamp
deleted_at : timestamp

v		school_management teacher_roles
id : bigint(20) unsigned
teacher_id : bigint(20) unsigned
role : varchar(30)
grade_level_id : bigint(20) unsigned
school_class_id : bigint(20) unsigned
valid_from : date
valid_until : date
created_at : timestamp
updated_at : timestamp

v		school_management teacher_subject_capabilities
id : bigint(20) unsigned
teacher_id : bigint(20) unsigned
subject_id : bigint(20) unsigned
grade_level_id : bigint(20) unsigned
valid_from : date
valid_until : date
created_at : timestamp
updated_at : timestamp

v		school_management timetable_periods
id : bigint(20) unsigned
timetable_structure_id : bigint(20) unsigned
lesson_number : tinyint(3) unsigned
starts_at : time
ends_at : time
created_at : timestamp
updated_at : timestamp

v		school_management timetable_structures
id : bigint(20) unsigned
scope_type : varchar(20)
grade_level_id : bigint(20) unsigned
school_class_id : bigint(20) unsigned
weekday : tinyint(3) unsigned
valid_from : date
valid_until : date
created_at : timestamp
updated_at : timestamp

v		school_management users
id : bigint(20) unsigned
name : varchar(255)
email : varchar(255)
email_verified_at : timestamp
password : varchar(255)
role : varchar(20)
locale : varchar(5)
must_change_password : tinyint(1)
is_active : tinyint(1)
remember_token : varchar(100)
created_at : timestamp
updated_at : timestamp

v		school_management validity_change_batches
id : bigint(20) unsigned
grade_level_id : bigint(20) unsigned
previous_grade_valid_until : date
new_grade_valid_until : date
changed_by : bigint(20) unsigned
reverted_at : timestamp
reverted_by : bigint(20) unsigned
dismissed_at : timestamp
dismissed_by : bigint(20) unsigned
created_at : timestamp
updated_at : timestamp

v		school_management validity_change_items
id : bigint(20) unsigned
validity_change_batch_id : bigint(20) unsigned
subject_type : varchar(255)
subject_id : bigint(20) unsigned
previous_valid_until : date
new_valid_until : date
created_at : timestamp
updated_at : timestamp

Create relationship
FOREIGN KEY
on delete
on update