Linux server1.signalhg.team 4.18.0-553.134.1.el8_10.x86_64 #1 SMP Tue Jun 16 16:05:57 EDT 2026 x86_64
Apache
: 209.74.80.147 | : 216.73.217.69
150 Domain
8.1.34
signgwph
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
README
+ Create Folder
+ Create File
/
home /
signgwph /
signaltechdemo10.com /
database /
[ HOME SHELL ]
Name
Size
Permission
Action
factories
[ DIR ]
drwxr-xr-x
migrations
[ DIR ]
drwxr-xr-x
seeders
[ DIR ]
drwxr-xr-x
.htaccess
127
B
-r--r--r--
database.sqlite.bak
516
KB
-rw-rw-rw-
Delete
Unzip
Zip
${this.title}
Close
Code Editor : database.sqlite.bak
SQLite format 3 @ � � � � .,P � y�������� ����h�qJ��' � �I �7indexstudents_student_number_uniquestudentsCREATE UNIQUE INDEX "students_student_number_unique" on "students" ("student_number")s; �indexstudents_user_id_uniquestudentsCREATE UNIQUE INDEX "students_user_id_unique" on "students" ("user_id")�? �QtablestudentsstudentsCREATE TABLE "students" ("id" integer primary key autoincrement not null, "user_id" integer not null, "program_id" integer not null, "student_number" varchar not null, "admission_date" date, "status" varchar not null default 'applicant', "cgpa" numeric not null default '0', "total_credits_earned" integer not null default '0', "national_id" varchar not null, "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade, foreign key("program_id") references "programs"("id") on delete restrict)j5 �indexprograms_code_uniqueprogramsCREATE UNIQUE INDEX "programs_code_unique" on "programs" ("code")�$ �tableprogramsprogramsCREATE TABLE "programs" ("id" integer primary key autoincrement not null, "department_id" integer not null, "name" varchar not null, "code" varchar not null, "total_credits" integer not null default '120', "duration_terms" integer not null default '8', "max_credits_per_term" integer not null default '21', "currency" varchar not null default 'BDT', "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime, foreign key("department_id") references "departments"("id") on delete cascade)v;#�indexdepartments_code_uniquedepartmentsCREATE UNIQUE INDEX "departments_code_unique" on "departments" ("code")�j##�tabledepartmentsdepartmentsCREATE TABLE "departments" ("id" integer primary key autoincrement not null, "name" varchar not null, "code" varchar not null, "head_teacher_id" integer, "created_at" datetime, "updated_at" datetime)��}tablecachecacheCREATE TABLE "cache" ("key" varchar not null, "value" text not null, "expiration" integer not null, primary key ("key")))= indexsqlite_autoindex_cache_1cacheS -sindexjobs_queue_indexjobsCREATE INDEX "jobs_queue_index" on "jobs" ("queue")� �etablejobsjobs CREATE TABLE "jobs" ("id" integer primary key autoincrement not null, "queue" varchar not null, "payload" text not null, "attempts" integer not null, "reserved_at" integer, "available_at" integer not null, "created_at" integer not null)| E �#indexsessions_last_activity_indexsessions CREATE INDEX "sessions_last_activity_index" on "sessions" ("last_activity")j 9 � indexsessions_user_id_indexsessions CREATE INDEX "sessions_user_id_index" on "sessions" ("user_id")�W �tablesessionssessions CREATE TABLE "sessions" ("id" varchar not null, "user_id" integer, "ip_address" varchar, "user_agent" text, "payload" text not null, "last_activity" integer not null, primary key ("id"))/ C indexsqlite_autoindex_sessions_1sessions �>77�tablepassword_reset_tokenspassword_reset_tokensCREATE TABLE "password_reset_tokens" ("email" varchar not null, "token" varchar not null, "created_at" datetime, primary key ("email"))I]7 indexsqlite_autoindex_password_reset_tokens_1password_reset_tokens Z1{indexusers_status_indexusersCREATE INDEX "users_status_index" on "users" ("status")a1�indexusers_email_uniqueusersCREATE UNIQUE INDEX "users_email_unique" on "users" ("email")�P�tableusersusersCREATE TABLE "users" ("id" integer primary key autoincrement not null, "name" varchar not null, "email" varchar not null, "email_verified_at" datetime, "password" varchar not null, "phone" varchar, "status" varchar not null default 'active', "remember_token" varchar, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�$!!�tablemigrationsmigrationsCREATE TABLE "migrations" ("id" integer primary key autoincrement not null, "migration" var lm __ US /, GD ;7 � ��p:��p7 � � � ] + � B � 2026_07_10_000014_create_home_page_content_and_modules_tables0 e 2026_07_10_000013_create_home_features_table; { 2026_07_10_000012_add_default_currency_to_site_settings. a 2026_07_10_000011_create_media_items_table, ] 2026_07_10_000010_create_site_cms_tables= 2026_07_10_000009_create_events_library_storefront_tables7 s 2026_07_10_000008_create_grading_and_payroll_tables0 e 2026_07_10_000007_create_academic_ops_tables4 m 2026_07_10_000006_create_student_documents_table* Y 2026_07_10_000005_create_hostel_tables4 m 2026_07_10_000004_create_student_transfers_table4 m 2026_07_10_000003_add_profile_fields_to_students. a 2026_07_10_000002_create_permission_tables, ] 2026_07_10_000001_create_ums_core_schema0 e 2026_07_10_000000_create_laravel_base_tables 4 �������|oe[NA4 invoices students teachers staff terms programs# departments roles users' site_settings%home_modules1 home_page_contents'home_features!migrations c� � #- �) 33Samir Ahmedstudent@ums.test$2y$12$7os7PbTjKLnbivqnDOi5T.v4Jgp2an5EHHKLVCWZjMI4pIZKwQRY.+8801000000003active2026-07-11 00:47:172026-07-11 00:47:17�' 7- �) 33Dr. Farhana Chowdhuryteacher@ums.test$2y$12$nVzAMOtJU/2J10lUy8qX/uYjRG04HZ.qorYK4uEkXRyc/3oAt7TvK+8801000000001active2026-07-11 00:47:172026-07-11 00:47:17� !) �) 33Admin Useradmin@mail.com$2y$12$vLJfB2ESyTXh7XnEjVPQDuUqgzSnpg/AgS/g60xs2yay.J7O/.mYC+8801000000002active2026-07-11 00:47:172026-07-11 00:47:17 � ��� -student@ums.test-teacher@ums.test) admin@mail.com � ��� active active active � � � � �� �p �e ] '�k�uTrvOVUwosctaAyPozlJZBphf55lZMaUyxkmUv6n7103.15.42.196Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/149.0.0.0 Safari/537.36YTozOntzOjY6Il90b2tlbiI7czo0MDoiRExxSGNFR3N4ZUFXMnNXdHA1WFlOdG1VbFhIeFVpdnlJTERpQXBhRyI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6NDA6Imh0dHBzOi8vc2lnbmFsdGVjaGRlbW8xMC5jb20vYWRtaW4vbG9naW4iO3M6NToicm91dGUiO3M6MTE6ImFkbWluLmxvZ2luIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==jQ>8 �1 ] '�k� RLKYFLw6W9gh964pEJ4pPoy5keVYMCsGrQmr7OiY157.20.150.11Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/150.0.0.0 Safari/537.36YTo1OntzOjY6Il90b2tlbiI7czo0MDoiV1AxNFpJVVAyU3JvTlE4dFFwVDc4WEZBSHV6TXlTdzIxYVZrM0ZOVCI7czo5OiJfcHJldmlvdXMiO2E6Mjp7czozOiJ1cmwiO3M6Mjg6Imh0dHBzOi8vc2lnbmFsdGVjaGRlbW8xMC5jb20iO3M6NToicm91dGUiO3M6NDoiaG9tZSI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6MzoidXJsIjthOjA6e31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aToxO30=jQ>� � �� ,]TrvOVUwosctaAyPozlJZBphf55lZMaUyxkmUv6n7+] RLKYFLw6W9gh964pEJ4pPoy5keVYMCsGrQmr7OiY � �� � �� jQ>8 jQ>� � � @ - 33Computer ScienceCSE2026-07-11 00:47:172026-07-11 00:47:17 � � CSE � � X 5 33 BSc Computer ScienceBSC-CSE �BDT2026-07-11 00:47:172026-07-11 00:47:17 � � BSC-CSE � � t !3 !33 UMS-2600412026-07-10 00:00:00enrolledNID-2600412026-07-11 00:47:172026-07-11 00:47:17 � � � � ! UMS-260041 � � enrolled R 0 Y � Q � 4 � � r ��� ��y0� Jq �0 �3ta� �tablestudentsstudentsCREATE TABLE "students" ("id" integer primary key autoincrement not null, "user_id" integer not null, "program_id" integer not null, "student_number" varchar not null, "admission_date" date, "status�3 �9tableprogramsprogramsCREATE TABLE "programs" ("id" integer primary key autoincrement not null, "department_id" integer not null, "name" varchar not null, "code" varchar not null, "total_credits" integer not null default '120', "duration_terms" integer not null default '8', "max_credits_per_term" integer not null default '21', "currency" varchar not null default 'BDT', "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime, "list_price_minor" integer not null default '0', "is_publicly_listed" tinyint(1) not null default '0', "summary" varchar, "image_url" varchar, foreign key("department_id") references "departments"("id") on delete cascade)j5 �indexprograms_code_uniqueprogramsCREATE UNIQUE INDEX "programs_code_unique" on "programs" ("code") ' �tableprogramsprogramsCREATE TABLE "programs" ("id" integer primary key autoincrement not null, "department_id" integer not null, "name" varchar not null, "code" varchar not null, "total_credits" integer not null default '120', "duration_terms" integer not null default '8', "max_credits_per_term" integer not null default '21', "currency" varchar not null default 'BDT', "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime, foreign key("department_id") references "departments"("id") on delete cascade)v;#�indexdepartments_code_uniquedepartmentsCREATE UNIQUE INDEX "departments_code_unique" on "departments" ("code")�j##�tabledepartmentsdepartmentsCREATE TABLE "departments" ("id" integer primary key autoincrement not null, "name" varchar not null, "code" varchar not null, "head_teacher_id" integer, "created_at" datetime, "updated_at" datetime))= indexsqlite_autoindex_cache_1cache��}tablecachecacheCREATE TABLE "cache" ("key" varchar not null, "value" text not null, "expiration" integer not null, primary key ("key"))S -sindexjobs_queue_indexjobsCREATE INDEX "jobs_queue_index" on "jobs" ("queue")� �etablejobsjobs CREATE TABLE "jobs" ("id" integer primary key autoincrement not null, "queue" varchar not null, "payload" text not null, "attempts" integer not null, "reserved_at" integer, "available_at" integer not null, "created_at" integer not null)| E �#indexsessions_last_activity_indexsessions CREATE INDEX "sessions_last_activity_index" on "sessions" ("last_activity")j 9 � indexsessions_user_id_indexsessions CREATE INDEX "sessions_user_id_index" on "sessions" ("user_id")/ C indexsqlite_autoindex_sessions_1sessions �W �tablesessionssessions CREATE TABLE "sessions" ("id" varchar not null, "user_id" integer, "ip_address" varchar, "user_agent" text, "payload" text not null, "last_activity" integer not null, primary key ("id"))I]7 indexsqlite_autoindex_password_reset_tokens_1password_reset_tokens�>77�tablepassword_reset_tokenspassword_reset_tokensCREATE TABLE "password_reset_tokens" ("email" varchar not null, "token" varchar not null, "created_at" datetime, primary key ("email"))Z1{indexusers_status_indexusersCREATE INDEX "users_status_index" on "users" ("status")a1�indexusers_email_uniqueusersCREATE UNIQUE INDEX "users_email_unique" on "users" ("email")�P�tableusersusersCREATE TABLE "users" ("id" integer primary key autoincrement not null, "name" varchar not null, "email" varchar not null, "email_verified_at" datetime, "password" varchar not null, "phone" varchar, "status" varchar not null default 'active', "remember_token" varchar, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�$!!�tablemigrationsmigrationsCREATE TABLE "migrations" ("id" integer primary key autoincrement not null, "migration" varchar not null, "batch" integer not null) � � ! NID-260041 E � �� � � � �[� �< �Ktableteachersteachers CREATE TABLE "teachers" ("id" integer primary key autoincrement not null, "user_id" integer not null, "department_id" integer not null, "employee_number" varchar not null, "hire_date" date, "employment_type" varchar not null default 'full_time', "max_hours_per_term" integer not null default '18', "created_at" datetime, "updated_at" datetime, "monthly_salary_minor" integer not null default '0', foreign key("user_id") references "users"("id") on delete cascade, foreign key("department_id") references "departments"("id") on delete restrict)�l �+tablestudentsstudentsCREATE TABLE "students" ("id" integer primary key autoincrement not null, "user_id" integer not null, "program_id" integer not null, "student_number" varchar not null, "admission_date" date, "status" varchar not null default 'applicant', "cgpa" numeric not null default '0', "total_credits_earned" integer not null default '0', "national_id" varchar not null, "created_at" datetime, "updated_at" datetime, "first_name" varchar, "last_name" varchar, "gender" varchar, "dob" date, "phone" varchar, "emergency_phone" varchar, "father_name" varchar, "father_occupation" varchar, "mother_name" varchar, "mother_occupation" varchar, "religion" varchar, "marital_status" varchar, "blood_group" varchar, "present_address" varchar, "permanent_address" varchar, "previous_school" varchar, "previous_qualification" varchar, "photo_path" varchar, foreign key("user_id") references "users"("id") on delete cascade, foreign key("program_id") references "programs"("id") on delete restrict)� �tablesubjectssubjects"CREATE TABLE "subjects" ("id" integer primary key autoincrement not null, "department_id" integer not null, "code" varchar not null, "title" varchar not null, "credits" integer not null, "description" text, "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime, foreign key("department_id") references "departments"("id") on delete restrict) E�/indexstaff_employee_number_uniquestaff!CREATE UNIQUE INDEX "staff_employee_number_unique" on "staff" ("employee_number")g 5�indexstaff_user_id_uniquestaff CREATE UNIQUE INDEX "staff_user_id_unique" on "staff" ("user_id") ��atablestaffstaff CREATE TABLE "staff" ("id" integer primary key autoincrement not null, "user_id" integer not null, "department_id" integer, "employee_number" varchar not null, "job_title" varchar not null, "status" varchar not null default 'active', "created_at" datetime, "updated_at" datetime, foreign key("user_id") references "users"("id") on delete cascade, foreign key("department_id") references "departments"("id") on delete set null)� K �;indexteachers_employee_number_uniqueteachers CREATE UNIQUE INDEX "teachers_employee_number_unique" on "teachers" ("employee_number")s; �indexteachers_user_id_uniqueteachers CREATE UNIQUE INDEX "teachers_user_id_unique" on "teachers" ("user_id") �atablete�v �Ktablestaffstaff CREATE TABLE "staff" ("id" integer primary key autoincrement not null, "user_id" integer not null, "department_id" integer, "employee_number" varchar not null, "job_title" varchar not null, "status" varchar not null default 'active', "created_at" datetime, "updated_at" datetime, "monthly_salary_minor" integer not null default '0', foreign key("user_id") references "users"("id") on delete cascade, foreign key("department_id") references "departments"("id") on delete set null)C �+indexstudents_national_id_uniquestudentsCREATE UNIQUE INDEX "students_national_id_unique" on "students" ("national_id")g7 �indexstudents_status_indexstudentsCREATE INDEX "students_status_index" on "students" ("status")�I �7indexstudents_student_number_uniquestudentsCREATE UNIQUE INDEX "students_student_number_unique" on "students" ("student_number")s; �indexstudents_user_id_uniquestudentsCREATE UNIQUE INDEX "students_user_id_unique" on "students" ("user_id") � � W 3 33T-2600012024-01-01 00:00:00full_time2026-07-11 00:47:172026-07-11 00:47:17 � � � � T-260001 � � G 33S-260001Registraractive2026-07-11 00:47:172026-07-11 00:47:17 � � � � S-260001 k k � 3333% 33Fall 20262026-09-01 00:00:002026-12-20 00:00:002026-07-15 00:00:002026-08-22 23:59:59registration2026-07-11 00:47:172026-07-11 00:47:17 � � Fall 2026 � � % registration � � T � 7�l%�q���k � � � 4�tablegradesgrades8CREATE TABLE "grades" ("id" integer primary key autoincrement not null, "enrollment_id" integer not null, "assessment_component_id" integer not null, "score" numeric not null, "entered_by" integer, "entered_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("enrollment_id") references "enrollments"(Z'1{indexterms_status_indexterms*CREATE INDEX "terms_status_index" on "terms" ("status")d(7�indexterms_is_active_indexterms+CREATE INDEX "terms_is_active_index" on "terms" ("is_active") �77�Itableassessment_componentsassessment_components7CREATE TABLE "assessment_components" ("id" integer primary key autoincrement not null, "class_section_id" integer not null, "name" varchar not null, "max_score" integer not null default '100', "weight" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("class_section_id") references "class_sections"("id") on delete cascade)�;2g#�yindexattendances_enrollment_id_session_date_uniqueattendances6CREATE UNIQUE INDEX "attendances_enrollment_id_session_date_unique" on "attendances" ("enrollment_id", "session_date")�81##�7tableattendancesattendances5CREATE TABLE "attendances" ("id" integer primary key autoincremen^&/�indexterms_name_uniqueterms)CREATE UNIQUE INDEX "terms_name_unique" on "terms" ("name")�r%�Ctabletermsterms(CREATE TABLE "terms" ("id" integer primary key autoincrement not null, "name" varchar not null, "start_date" date not null, "end_date" date not null, "reg_open" datetime not null, "reg_close" datetime not null, "status" varchar not null default 'planning', "is_active" tinyint(1) not null default '0', "created_at" datetime, "updated_at" datetime)=$Q+ indexsqlite_autoindex_subject_teacher_1subject_teacher'�D#++�?tablesubject_teachersubject_teacher&CREATE TABLE "subject_teacher" ("subject_id" integer not null, "teacher_id" integer not null, foreign key("subject_id") references "subjects"("id") on delete cascade, foreign key("teacher_id") references "teachers"("id") on delete cascade, primary key ("subject_id", "teacher_id"))I"]7 indexsqlite_autoindex_subject_prerequisites_1subject_prerequisites%�}!77�tablesubject_prerequisitessubject_prerequisites$CREATE TABLE "subject_prerequisites" ("subject_id" integer not null, "prerequisite_subject_id" integer not null, foreign key("subject_id") references "subjects"("id") on delete cascade, foreign key("prerequisite_subject_id") references "subjects"("id") on delete cascade, primary key ("subject_id", "prerequisite_subject_id"))j 5 �indexsubjects_code_uniquesubjects#CREATE UNIQUE INDEX "subjects_code_unique" on "subjects" ("code")�Y,w)� indexclass_sections_subject_id_term_id_section_code_uniqueclass_sections0CREATE UNIQUE INDEX "class_sections_subject_id_term_id_section_code_unique" on "class_sections" ("subject_id", "term_id", "section_code")�i+))� tableclass_sectionsclass_sections.CREATE TABLE "class_sections" ("id" integer primary key autoincrement not null, "subject_id" integer not null, "teacher_id" integer not null, "term_id" integer not null, "room_id" integer not null, "section_code" varchar not null, "schedule" text not null, "capacity" integer not null, "enrolled_count" integer not null default '0', "status" varchar not null default 'open', "created_at" datetime, "updated_at" datetime, foreign key("subject_id") references "subjects"("id") on delete restrict, foreign key("teacher_id") references "teachers"("id") on delete restrict, foreign key("term_id") references "terms"("id") on delete restrict, foreign key("room_id") references "rooms"("id") on delete restrict)�*E�5indexrooms_building_number_uniquerooms-CREATE UNIQUE INDEX "rooms_building_number_unique" on "rooms" ("building", "number")� )�ytableroomsrooms,CREATE TABLE "rooms" ("id" integer primary key autoincrement not null, "building" varchar not null, "number" varchar not null, "capacity" integer not null, "type" varchar not null default 'classroom', "created_at" datetime, "updated_at" datetime) � � 7 � I���� � �\7 � tableinvoicesinvoices<CREATE TABLE "invoices" ("id" integer primary key autoincrement not null, "student_id" integer not null, "term_id" integer not null, "invoice_number" varchar not null, "currency" varchar not null default 'BDT', "subtotal_minor" integer not null default '0', "amount_paid_minor" integer not null default '0', "status" varchar not null default 'draft', "due_date" date, "issued_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("student_id") references "students"("id") on delete cascade, foreign key("term_id") references "terms"("id") on delete cascade)�\6))�stablefee_structuresfee_structures:CREATE TABLE "fee_structures" ("id" integer primary key autoincrement not null, "program_id" integer not null, "term_id" integer not null, "fee_type" varchar not null, "amount_minor" integer not null, "is_per_credit" tinyint(1) not null default '0', "created_at" datetime, "updated_at" datetime, foreign key("program_id") references "programs"("id") on delete cascade, foreign key("term_id") references "terms"("id") on delete cascade)�H5s�indexgrades_enrollment_id_assessment_component_id_uniquegrades9CREATE UNIQUE INDEX "grades_enrollment_id_assessment_component_id_unique" on "grades" ("enrollment_id", "assessment_component_id")� 4�tablegradesgrades8CREATE TABLE "grades" ("id" integer primary key autoincrement not null, "enrollment_id" integer not null, "assessment_component_id" integer not null, "score" numeric not null, "entered_by" integer, "entered_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("enrollment_id") references "enrollments"("id") on delete cascade, foreign key("assessment_component_id") references "assessment_components"("id") on delete cascade, foreign key("entered_by") references "users"("id") on delete set null)�377�Itableassessment_componentsassessment_components7CREATE TABLE "assessment_components" ("id" integer primary key autoincrement not null, "class_section_id" integer not null, "name" varchar not null, "max_score" integer not null default '100', "weight" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("class_section_id") references "class_sections"("id") on delete cascade)�;2g#�yindexattendances_enrollment_id_session_date_uniqueattendances6CREATE UNIQUE INDEX "attendances_enrollment_id_session_date_unique" on "attendances" ("enrollment_id", "session_date")�81##�7tableattendancesattendances5CREATE TABLE "attendances" ("id" integer primary key autoincrement not null, "enrollment_id" integer not null, "session_date" date not null, "status" varchar not null, "marked_by" integer, "marked_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("enrollment_id") references "enrollments"("id") on delete cascade, foreign key("marked_by") references "users"("id") on delete set null)s0=#�indexenrollments_status_indexenrollments4CREATE INDEX "enrollments_status_index" on "enrollments" ("status")�>/i#�}indexenrollments_student_id_class_section_id_uniqueenrollments3CREATE UNIQUE INDEX "enrollments_student_id_class_section_id_unique" on "enrollments" ("student_id", "class_section_id")�.##�Otableenrollmentsenrollments2CREATE TABLE "enrollments" ("id" integer primary key autoincrement not null, "student_id" integer not null, "class_section_id" integer not null, "term_id" integer not null, "status" varchar not null default 'enrolled', "final_score" numeric, "letter_grade" varchar, "grade_points" numeric, "published_at" datetime, "enrolled_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("student_id") references "students"("id") on delete cascade, foreign key("class_section_id") references "class_sections"("id") on delete cascade, foreign key("term_id") references "terms"("id") on delete cascade)-C)� indexclass_sections_status_indexclass_sections1CREATE INDEX "class_sections_status_index" on "class_sections" ("status") � � u +3333INV-FALL26-0001BDT �B�issued2026-08-15 00:00:002026-07-11 00:47:172026-07-11 00:47:172026-07-11 00:47:17 � � + INV-FALL26-0001 � � issued c � �oE� � V � _ � e�c� �< �qtablepaymentspaymentsACREATE TABLE "payments" ("id" integer primary key autoincrement not null, "invoice_id" integer not null, "gateway" varchar not null, "gateway_txn_id" varchar, "idempotency_key" varchar not null, "amount_minor" integer not null, "currency" varchar not null default 'BDT', "status" varchar not null default 'pending', "raw_payload" text, "paid_at" datetime, "refunded_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("invoice_id") references "invoices"("id") on delete cascade)�%;55�mtableinvoice_installmentsinvoice_installments@CREATE TABLE "invoice_installments" ("id" integer primary key autoincrement not null, "invoice_id" integer not null, "sequence" integer not null, "amount_minor" integer not null, "due_date" date not null, "status" varchar not null default 'pending', "created_at" datetime, "updated_at" datetime, foreign key("invoice_id") references "invoices"("id") on delete cascade)�':''� tableinvoice_itemsinvoice_items?CREATE TABLE "invoice_items" ("id" integer primary key autoincrement not null, "invoice_id" integer not null, "enrollment_id" integer, "fee_structure_id" integer, "description" varchar not null, "amount_minor" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("invoice_id") references "invoices"("id") on delete cascade, foreign key("enrollment_id") references "enrollments"("id") on delete set null, foreign key("fee_structure_id") references "fee_structures"("id") on delete set null)g97 �indexinvoices_status_indexinvoices>CREATE INDEX "invoices_status_index" on "invoices" ("status")�8I �7indexinvoices_invoice_number_uniqueinvoices=CREATE UNIQUE INDEX "invoices_invoice_number_unique" on "invoices" ("invoice_number") � * � tableinvoicesinvoices<CREATE TAB�UC##�qtablepermissionspermissionsICREATE TABLE "permissions" ("id" integer primary key autoincrement not null, "name" varchar not null, "guard_name" varchar not null, "created_at" datetime, "updated_at" datetime)�1Be!�iindexaudit_logs_auditable_type_auditable_id_indexaudit_logsHCREATE INDEX "audit_logs_auditable_type_auditable_id_index" on "audit_logs" ("auditable_type", "auditable_id")�A!!�}tableaudit_logsaudit_logsFCREATE TABLE "audit_logs" ("id" integer primary key autoincrement not null, "auditable_type" varchar not null, "auditable_id" integer not null, "action" varchar not null, "old_values" text, "new_values" text, "actor_id" integer, "ip" varchar, "user_agent" text, "created_at" datetime, "updated_at" datetime, foreign key("actor_id") references "users"("id") on delete set null)�'@''� tableannouncementsannouncementsECREATE TABLE "announcements" ("id" integer primary key autoincrement not null, "title" varchar not null, "body" text not null, "audience_type" varchar not null default 'all', "audience_id" integer, "published_at" datetime, "expires_at" datetime, "created_by" integer, "created_at" datetime, "updated_at" datetime, foreign key("created_by") references "users"("id") on delete set null)g?7 �indexpayments_status_indexpaymentsDCREATE INDEX "payments_status_index" on "payments" ("status")� >K �;indexpayments_idempotency_key_uniquepaymentsCCREATE UNIQUE INDEX "payments_idempotency_key_unique" on "payments" ("idempotency_key")�=I �7indexpayments_gateway_txn_id_uniquepaymentsBCREATE UNIQUE INDEX "payments_gateway_txn_id_unique" on "payments" ("gateway_txn_id") ��tablegradesgrades8CREATE TABLE "grades" ("id"�FE�5indexroles_name_guard_name_uniquerolesLCREATE UNIQUE INDEX "roles_name_guard_name_unique" on "roles" ("name", "guard_name")�CE�etablerolesrolesKCREATE TABLE "roles" ("id" integer primary key autoincrement not null, "name" varchar not null, "guard_name" varchar not null, "created_at" datetime, "updated_at" datetime)�DQ#�Mindexpermissions_name_guard_name_uniquepermissionsJCREATE UNIQUE INDEX "permissions_name_guard_name_unique" on "permissions" ("name", "guard_name") Z ��Z 6 33studentweb2026-07-11 00:47:172026-07-11 00:47:176 33teacherweb2026-07-11 00:47:172026-07-11 00:47:174 33adminweb2026-07-11 00:47:172026-07-11 00:47:17 � ��� studentwebteacherweb adminweb � ��� +App\Models\User+App\Models\User + App\Models\User � ��� +App\Models\User+App\Models\User + App\Models\User � ��� +App\Models\User+App\Models\User + App\Models\User � � �i��Gb��N � � d 4 � � �$VW%�Yindexhostel_rooms_hostel_id_room_no_uniquehostel_rooms]CREATE UNIQUE INDEX "hostel_rooms_hostel_id_room_no_unique" on "hostel_rooms" ("hostel_id", "room_no")�pO//�tablestudent_documentsstudent_documentsVCREATE TABLE "student_documents" ("id" integer primary key autoincrement not null, "student_id" integer not null, "type" varchar not null, "original_name" varchar not null, "file_path" varchar not null, "created_at" datetime, "updated_at" datetime, foreign key("student_id") references "students"("id") on delete cascade)GN[5 indexsqlite_autoindex_role_has_permissions_1role_has_permissionsT�-L_+�]indexmodel_has_roles_model_id_model_type_indexmodel_has_rolesRCREATE INDEX "model_has_roles_model_id_model_type_index" on "model_has_roles" ("model_id", "model_type")�J++�gtablemodel_has_rolesmodel_has_rolesPCREATE TABLE "model_has_roles" ("role_id" integer not null, "model_type" varchar not null, "model_id" integer not null, foreign key("role_id") references "roles"("id") on delete cascade, primary key ("role_id", "model_id", "model_type"))=KQ+ indexsqlite_autoindex_model_has_roles_1model_has_rolesQ�EIk7�uindexmodel_has_permissions_model_id_model_type_indexmodel_has_permissionsOCREATE INDEX "model_has_permissions_model_id_model_type_index" on "model_has_permissions" ("model_id", "model_type")�BG77�#tablemodel_has_permissionsmodel_has_permissionsMCREATE TABLE "model_has_permissions" ("permission_id" integer not null, "model_type" varchar not null, "model_id" integer not null, foreign key("permission_id") references "permissions"("id") on delete cascade, primary key ("permission_id", "model_id", "model_type"))IH]7 indexsqlite_autoindex_model_has_permissions_1model_has_permissionsN ��E�5indexroles_name_guard_name_uniquerolesLCREATE UNIQUE INDEX "roles_n�U%%�Itablehostel_roomshostel_rooms\CREATE TABLE "hostel_rooms" ("id" integer primary key autoincrement not null, "hostel_id" integer not null, "room_no" varchar not null, "floor" integer not null, "type" varchar check ("type" in ('single', 'double', 'dorm')) not null, "capacity" integer not null, "occupied_co�FE�5indexroles_name_guard_name_uniquerolesLCREATE UNIQUE INDEX "roles_name_guard_name_unique" on "roles" ("name", "guard_name")�CE�etablerolesrolesKCREATE TABLE "roles" ("id" integer primary key autoincrement not null, "name" varchar not null, "guard_name" varchar not null, "created_at" datetime, "updated_at" datetime) h3� indexhostels_name_uniquehostels[CREATE UNIQUE INDEX "hostels_name_unique" on "hostels" ("name")�-S�1tablehostelshostelsZCREATE TABLE "hostels" ("id" integer primary key autoincrement not null, "name" varchar not null, "type" varchar check ("type" in ('boys', 'girls', 'coed')) not null, "address" varchar, "description" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime)�&RW/�Sindexstudent_transfers_transfer_ref_uniquestudent_transfersYCREATE UNIQUE INDEX "student_transfers_transfer_ref_unique" on "student_transfers" ("transfer_ref")�QO/�7indexstudent_transfers_direction_indexstudent_transfersXCREATE INDEX "student_transfers_direction_index" on "student_transfers" ("direction")�P//�5tablestudent_transfersstudent_transfersWCREATE TABLE "student_transfers" ("id" integer primary key autoincrement not null, "student_id" integer not null, "direction" varchar not null, "transfer_ref" varchar not null, "university_name" varchar not null, "transfer_date" date not null, "note" text, "created_by" integer, "created_at" datetime, "updated_at" datetime, foreign key("student_id") references "students"("id") on delete cascade, foreign key("created_by") references "users"("id") on delete set null)�SM55�Itablerole_has_permissionsrole_has_permissionsSCREATE TABLE "role_has_permissions" ("permission_id" integer not null, "role_id" integer not null, foreign key("permission_id") references "permissions"("id") on delete cascade, foreign key("role_id") references "roles"("id") on delete cascade, primary key ("permission_id", "role_id")) � z e �-k��� yL � . �'b �!tablepayrollspayrollsjCREATE TABLE "payrolls" ("id" integer primary key autoincrement not null, "p�/_ �1tablevehiclesvehiclesgCREATE TABLE "vehicles" ("id" integer primary key autoincrement not null, "transport_route_id" integer, "registration_no" varchar not null, "type" varchar not null default 'bus', "capacity" integer not null default '0', "driver_name" varchar, "driver_phone" varchar, "created_at" datetime, "updated_at" datetime, foreign key("transport_route_id") references "transport_routes"("id") on delete set null)� ^E-�/indextransport_routes_name_uniquetransport_routesfCREATE UNIQUE INDEX "transport_routes_name_unique" on "transport_routes" ("name")�L\##�_tableassignmentsassignmentsdCREATE TABLE "assignments" ("id" integer primary key autoincrement not null, "class_section_id" integer not null, "title" varchar not null, "description" text, "due_date" date, "published_at" datetime, "created_by" integer, "created_at" datetime, "updated_at" datetime, foreign key("class_section_id") references "class_sections"("id") on delete cascade, foreign key("created_by") references "users"("id") on delete set null)�.[##�#tablefee_waiversfee_waiverscCREATE TABLE "fee_waivers" ("id" integer primary key autoincrement not null, "student_id" integer not null, "term_id" integer, "fee_type" varchar, "discount_type" varchar not null default 'percent', "amount" integer not null, "reason" varchar, "created_by" integer, "created_at" datetime, "updated_at" datetime, foreign key("student_id") references "students"("id") on delete cascade, foreign key("term_id") references "terms"("id") on delete set null, foreign key("created_by") references "users"("id") on delete set null)�ZK1�/indexhostel_assignments_status_indexhostel_assignmentsbCREATE INDEX "hostel_assignments_status_index" on "hostel_assignments" ("status")�?Ye1�uindexhostel_assignments_student_id_term_id_uniquehostel_assignmentsaCREATE UNIQUE INDEX "hostel_assignments_student_id_term_id_unique" on "hostel_assignments" ("student_id", "term_id")�X11�_tablehostel_assignmentshostel_assignments`CREATE TABLE "hostel_assignments" ("id" integer primary key autoincrement not null, "student_id" integer not null, "hostel_room_id" integer not null, "term_id" integer not null, "assigned_at" date not null, "vacant_at" date, "status" varchar check ("status" in ('active', 'completed', 'cancelled')) not null default 'active', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("student_id") references "students"("id") on delete restrict, foreign key("hostel_room_id") references "hostel_rooms"("id") on delete cascade, foreign key("term_id") references "terms"("id") on delete restrict)�WS%�Eindexhostel_rooms_gender_is_active_indexhostel_rooms^CREATE INDEX "hostel_rooms_gender_is_active_index" on "hostel_rooms" ("gender", "is_active")�$VW%�Yindexhostel_rooms_hostel_id_room_no_uniquehostel_rooms]CREATE UNIQUE INDEX "hostel_rooms_hostel_id_room_no_unique" on "hostel_rooms" ("hostel_id", "room_no") fT3� indexhostels_name_uniquehostels[CREATE UNIQUE INDEX "hostels_name_unique" on "hostels" ("name")�~]--�/tabletransport_routestransport_routeseCREATE TABLE "transport_routes" ("id" integer primary key autoincrement not null, "name" varchar not null, "stops" text, "fare_minor" integer not null default '0', "created_at" datetime, "updated_at" datetime)�U%%�Itablehostel_roomshostel_rooms\CREATE TABLE "hostel_rooms" ("id" integer primary key autoincrement not null, "hostel_id" integer not null, "room_no" varchar not null, "floor" integer not null, "type" varchar check ("type" in ('single', 'double', 'dorm')) not null, "capacity" integer not null, "occupied_count" integer not null default '0', "monthly_rent_minor" integer not null, "gender" varchar check ("gender" in ('male', 'female', 'any')) not null, "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("hostel_id") references "hostels"("id") on delete cascade) ~ [ � � j �I� ���� [ Q I o � n �c�um''�)tableslider_imagesslider_imagesvCREATE TABLE "slider_images" ("id" integer primary key autoincrement not null, "image_path" varchar not null, "headline" varchar, "subheading" varchar, "button_text" varchar, "button_link" varchar, "sort_order" integer not null default '0', "is_published" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime)�7j''�-tablecourse_orderscourse_orderssCREATE TABLE "course_orders" ("id" integer primary key autoincrement not null, "program_id" integer not null, "order_no" varchar not null, "customer_name" varchar not null, "customer_email" varchar not null, "customer_phone" varchar, "amount_minor" integer not null, "currency" varchar not null default 'BDT', "payment_method" varchar not null, "status" varchar not null default 'pending', "paid_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("program_id") references "programs"("id") on delete cascade)�Yh##�ytablebook_issuesbook_issuesqCREATE TABLE "book_issues" ("id" integer primary key autoincrement not null, "book_id" integer not null, "student_id" integer not null, "issued_at" date not null, "due_date" date not null, "returned_at" date, "status" varchar not null default 'issued', "created_at" datetime, "updated_at" datetime, foreign key("book_id") references "books"("id") on delete cascade, foreign key("student_id") references "students"("id") on delete cascade)^g/�indexbooks_isbn_uniquebookspCREATE UNIQUE INDEX "books_isbn_unique" on "books" ("isbn")�9f�QtablebooksbooksoCREATE TABLE "books" ("id" integer primary key autoincrement not null, "title" varchar not null, "author" varchar, "isbn" varchar, "category" varchar, "total_copies" integer not null default '1', "available_copies" integer not null default '1', "created_at" datetime, "updated_at" datetime)�ye�MtableeventseventsnCREATE TABLE "events" ("id" integer primary key autoincrement not null, "title" varchar not null, "description" text, "location" varchar, "starts_at" datetime not null, "ends_at" datetime, "published_at" datetime, "created_by" integer, "created_at" datetime, "updated_at" datetime, foreign key("created_by") references "users"("id") on delete set null)gd7 �indexpayrolls_status_indexpayrollsmCREATE INDEX "payrolls_status_index" on "payrolls" ("status")�2ca �sindexpayrolls_payee_type_payee_id_period_uniquepayrollskCREATE UNIQUE INDEX "payrolls_payee_type_payee_id_period_unique" on "payrolls" ("payee_type", "payee_id", "period")�'b �!tablepayrollspayrollsjCREATE TABLE "payrolls" ("id" integer primary key autoincrement not null, "payee_type" varchar not null, "payee_id" integer not null, "period" date not null, "amount_minor" integer not null, "status" varchar not null default 'pending', "paid_at" datetime, "created_by" integer, "created_at" datetime, "updated_at" datetime, foreign key("created_by") references "users"("id") on delete set null)�$a))�tablegrading_scalesgrading_scalesiCREATE TABLE "grading_scales" ("id" integer primary key autoincrement not null, "min_score" numeric not null, "max_score" numeric not null, "letter_grade" varchar not null, "grade_points" numeric not null, "created_at" datetime, "updated_at" datetime)� `K �;indexvehicles_registration_no_uniquevehicleshCREATE UNIQUE INDEX "vehicles_registration_no_unique" on "vehicles" ("registration_no") ''�)tableslider_imagesslider_imagesvCREATE TABLE "slider_imag�/_ �1tablevehiclesvehiclesgCREATE TABLE "vehicles" ("id" integer primary key autoincrement not null, "transport_route_id" integer, "registration_no" varchar not null, "type" varchar not n{lA'�indexcourse_orders_status_indexcourse_ordersuCREATE INDEX "course_orders_status_index" on "course_orders" ("status")� kG'�3indexcourse_orders_order_no_uniquecourse_orderstCREATE UNIQUE INDEX "course_orders_order_no_unique" on "course_orders" ("order_no")si=#�indexbook_issues_status_indexbook_issuesrCREATE INDEX "book_issues_status_index" on "book_issues" ("status") � 0 ��/��<0 � � ( v �^u''�{tablehome_featureshome_featuresCREATE TABLE "home_features" ("id" integer primary key autoincrement not null, "title" varchar not null, "description" text not null, "theme" varchar not null default 'teal', "sort_order" integer not null default '0', "is_published" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime)�(r''�tablesite_settingssite_settings|CREATE TABLE "site_settings" ("id" integer primary key autoincrement not null, "site_name" varchar not null default 'HiTech University', "tagline" varchar, "logo_path" varchar, "favicon_path" varchar, "phone" varchar, "email" varchar, "address" varchar, "facebook_url" varchar, "twitter_url" varchar, "linkedin_url" varchar, "paypal_client_id" varchar, "paypal_client_secret" varchar, "paypal_mode" varchar not null default 'sandbox', "stripe_publishable_key" varchar, "stripe_secret_key" varchar, "stripe_mode" varchar not null default 'test', "created_at" datetime, "updated_at" datetime, "default_currency" varchar not null default 'BDT')�/tc#�eindexmedia_items_mediable_type_mediable_id_indexmedia_items~CREATE INDEX "media_items_mediable_type_mediable_id_index" on "media_items" ("mediable_type", "mediable_id")�#s##� tablemedia_itemsmedia_items}CREATE TABLE "media_items" ("id" integer primary key autoincrement not null, "mediable_type" varchar not null, "mediable_id" integer not null, "path" varchar not null, "sort_order" integer not null default '0', "created_at" datetime, "updated_at" datetime)�q�tablefaqsfaqs{CREATE TABLE "faqs" ("id" integer primary key autoincrement not null, "question" varchar not null, "answer" text not null, "sort_order" integer not null default '0', "is_published" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime)rp9!�indexnews_posts_slug_uniquenews_postszCREATE UNIQUE INDEX "news_posts_slug_unique" on "news_posts" ("slug")� o!!�tablenews_postsnews_postsxCREATE TABLE "news_posts" ("id" integer primary key autoincrement not null, "title" varchar not null, "slug" varchar not null, "summary" varchar, "body" text, "image_path" varchar, "published_at" datetime, "created_at" datetime, "updated_at" datetime)� n �ctablegalleriesgallerieswCREATE TABLE "galleries" ("id" integer primary key autoincrement not null, "image_path" varchar not null, "caption" varchar, "album" varchar, "is_published" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime) �:w%%�5tablehome_moduleshome_modules �CREATE TABLE "home_modules" ("id" integer primary key autoincrement not null, "eyebrow" varchar not null, "title" varchar not null, "description" text not null, "button_text" varchar not null, "button_link" varchar not null, "image_path" varchar, "image_url" varchar, "sort_order" integer not null default '0', "is_published" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime)�mv11�tablehome_page_contentshome_page_contents �CREATE TABLE "home_page_contents" ("id" integer primary key autoincrement not null, "about_kicker" varchar not null default 'About Our University', "about_heading" varchar not null default 'A Few Words About the University', "about_body" text not null, "mission_title" varchar not null default 'Our Mission', "mission_body" text not null, "vision_title" varchar not null default 'Our Vision', "vision_body" text not null, "about_image_one_path" varchar, "about_image_one_url" varchar, "about_image_two_path" varchar, "about_image_two_url" varchar, "about_image_three_path" varchar, "about_image_three_url" varchar, "modules_kicker" varchar not null default 'What does it offer for academic management?', "modules_heading" varchar not null default 'Complete University ERP Modules', "created_at" datetime, "updated_at" datetime) n n � / w 33HiTech Universitybranding/rMWVEtm0GOH8x5GwLBS2eNABmwuwr4AKKuu7kUap.pngsandboxtest2026-07-11 00:46:522026-07-11 00:47:59BDT 6 h�6 � ;�# 33Bachelor's and Master'sCourse catalog, teacher assignment, fee collection, and academic reporting.teal2026-07-10 22:33:212026-07-10 22:33:21� 1�' 33International HubsPublic web, events, gallery, news, applicant tracking, and program discovery.coral2026-07-10 22:33:212026-07-10 22:33:21� 1�+ 33Education ServicesAdmission, students, classes, grades, attendance, and transcripts in one place.teal2026-07-10 22:33:212026-07-10 22:33:21 ( ( �U 5M�9#�i!�i �E �E �?cK33About Our UniversityA Few Words About the UniversityOur university platform brings the public website, admission, academics, students, teachers, finance, gallery, events, news, and reports into one clean digital experience. Students can apply and log in easily while staff manage the full university operation from the admin side.Our MissionDeliver simple digital services for admission, learning, billing, attendance, examinations, and communication.Our VisionBuild a modern university management system where every department works with accurate, connected information.https://images.unsplash.com/photo-1498243691581-b145c3f54a5a?auto=format&fit=crop&w=700&q=80https://images.unsplash.com/photo-1503676260728-1c00da094a0b?auto=format&fit=crop&w=650&q=80https://images.unsplash.com/photo-1562774053-701939374585?auto=format&fit=crop&w=650&q=80What does it offer for academic management?Complete University ERP Modules2026-07-10 22:33:212026-07-10 22:33:21 � � � � � 3�'1) �? 33FinanceFinance and ReportsInvoices, bKash, Stripe, PayPal, salary, income, expense, and reconciliation.Student Billing ->/student/loginhttps://images.unsplash.com/photo-1554224155-6726b3ff858f?auto=format&fit=crop&w=900&q=802026-07-10 22:33:212026-07-10 22:33:21� 1�3+ �E 33AcademicsAcademic DashboardClasses, subjects, routines, examinations, attendance, study materials, and grades.View Courses ->/coursehttps://images.unsplash.com/photo-1522202176988-66273c2fd55f?auto=format&fit=crop&w=900&q=802026-07-10 22:33:212026-07-10 22:33:21� !-�5/! �E 33AdmissionsOnline AdmissionApplication, documents, registrar review, acceptance, and student number generation.Open Admission ->/admissionhttps://images.unsplash.com/photo-1523580846011-d3a5bc25702b?auto=format&fit=crop&w=900&q=802026-07-10 22:33:212026-07-10 22:33:21
Close
