SQLite format 3@ V.c  p$7 Q#Mindexpermissions_name_guard_name_uniquepermissionsCREATE UNIQUE INDEX "permissions_name_guard_name_unique" on "permissions" ("name", "guard_name")U##qtablepermissionspermissionsCREATE TABLE "permissions" ("id" integer primary key autoincrement not null, "name" varchar not null, "guard_name" varchar not null, "created_at" datetime, "updated_at" datetime)v;#indexfailed_jobs_uuid_uniquefailed_jobsCREATE UNIQUE INDEX "failed_jobs_uuid_unique" on "failed_jobs" ("uuid")5e#oindexfailed_jobs_connection_queue_failed_at_indexfailed_jobsCREATE INDEX "failed_jobs_connection_queue_failed_at_index" on "failed_jobs" ("connection", "queue", "failed_at").###tablefailed_jobsfailed_jobsCREATE TABLE "failed_jobs" ("id" integer primary key autoincrement not null, "uuid" varchar not null, "connection" varchar not null, "queue" varchar not null, "payload" text not null, "exception" text not null, "failed_at" datetime not null default CURRENT_TIMESTAMP)`##tablejob_batchesjob_batchesCREATE TABLE "job_batches" ("id" varchar not null, "name" varchar not null, "total_jobs" integer not null, "pending_jobs" integer not null, "failed_jobs" integer not null, "failed_job_ids" text not null, "options" text, "cancelled_at" integer, "created_at" integer not null, "finished_at" integer, primary key ("id"))5I#indexsqlite_autoindex_job_batches_1job_batchesS-sindexjobs_queue_indexjobsCREATE INDEX "jobs_queue_index" on "jobs" ("queue")etablejobsjobsCREATE 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##indexcache_locks_expiration_indexcache_locksCREATE INDEX "cache_locks_expiration_index" on "cache_locks" ("expiration")$##tablecache_lockscache_locksCREATE TABLE "cache_locks" ("key" varchar not null, "owner" varchar not null, "expiration" integer not null, primary key ("key"))5I#indexsqlite_autoindex_cache_locks_1cache_locksg 9 indexcache_expiration_indexcacheCREATE INDEX "cache_expiration_index" on "cache" ("expiration") }tablecachecache CREATE TABLE "cache" ("key" varchar not null, "value" text not null, "expiration" integer not null, primary key ("key"))) =indexsqlite_autoindex_cache_1cache | 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")WtablesessionssessionsCREATE 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"))/Cindexsqlite_autoindex_sessions_1sessions >77tablepassword_reset_tokenspassword_reset_tokensCREATE TABLE "password_reset_tokens" ("email" varchar not null, "token" varchar not null, "created_at" datetime, primary key ("email"))I]7indexsqlite_autoindex_password_reset_tokens_1password_reset_tokensa1indexusers_email_uniqueusersCREATE UNIQUE INDEX "users_email_unique" on "users" ("email")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, "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 autoincrԁQÁB2& uxfiP[@H38*  `R!d8 `5m2026_06_16_040000_add_user_id_to_guardians_table: w2026_06_16_023402_create_personal_access_tokens_table6 o2026_06_16_030008_add_staff_fields_to_users_table+ Y2026_06_16_030007_create_extras_tables* W2026_06_16_030006_create_comms_tables- ]2026_06_16_030005_create_academic_tables,[2026_06_16_030004_create_finance_tables+Y2026_06_16_030003_create_school_tables1e2026_06_16_030002_create_fixed_assets_tables/a2026_06_16_030001_create_accounting_tables/a2026_06_16_020927_create_permission_tables'S 0001_01_01_000002_create_jobs_table(U 0001_01_01_000001_create_cache_table(U 0001_01_01_000000_create_users_table n|n__t guardians students+school_settings terms) academic_years accounts roles #permissions, users!migrations / osei@southend.edu ;}}i:14;a:4:{s:1:"a";i:15;s:1:"b";s:17:"fixed_assets.edit";s:1:"c";s:3:"web";s:1:"r";a:3:{i:0;i:1;i:1;i:2;i:2;i:3;}}i:15;a:4:{s:1:"a";i:16;s:1:"b";s:19:"fixed_assets.delete";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:16;a:4:{s:1:"a";i:17;s:1:"b";s:13:"academic.view";s:1:"c";s:3:"web";s:1:"r";a:7:{i:0;i:1;i:1;i:2;i:2;i:5;i:3;i:6;i:4;i:9;i:5;i:10;i:6;i:11;}}i:17;a:4:{s:1:"a";i:18;s:1:"b";s:15:"academic.create";s:1:"c";s:3:"web";s:1:"r";a:4:{i:0;i:1;i:1;i:2;i:2;i:5;i:3;i:6;}}i:18;a:4:{s:1:"a";i:19;s:1:"b";s:13:"academic.edit";s:1:"c";s:3:"web";s:1:"r";a:4:{i:0;i:1;i:1;i:2;i:2;i:5;i:3;i:6;}}i:19;a:4:{s:1:"a";i:20;s:1:"b";s:15:"academic.delete";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:20;a:4:{s:1:"a";i:21;s:1:"b";s:19:"communications.view";s:1:"c";s:3:"web";s:1:"r";a:9:{i:0;i:1;i:1;i:2;i:2;i:5;i:3;i:6;i:4;i:7;i:5;i:8;i:6;i:9;i:7;i:10;i:8;i:11;}}i:21;a:4:{s:1:"a";i:22;s:1:"b";s:21:"communications.create";s:1:"c";s:3:"web";s:1:"r";a:4:{i:0;i:1;i:1;i:2;i:2;i:5;i:3;i:8;}}i:22;a:4:{s:1:"a";i:23;s:1:"b";s:19:"communications.edit";s:1:"c";s:3:"web";s:1:"r";a:3:{i:0;i:1;i:1;i:2;i:2;i:8;}}i:23;a:4:{s:1:"a";i:24;s:1:"b";s:21:"communications.delete";s:1:"c";s:3:"web";s:1:"r";a:3:{i:0;i:1;i:1;i:2;i:2;i:8;}}i:24;a:4:{s:1:"a";i:25;s:1:"b";s:11:"extras.view";s:1:"c";s:3:"web";s:1:"r";a:4:{i:0;i:1;i:1;i:2;i:2;i:7;i:3;i:11;}}i:25;a:4:{s:1:"a";i:26;s:1:"b";s:13:"extras.create";s:1:"c";s:3:"web";s:1:"r";a:3:{i:0;i:1;i:1;i:2;i:2;i:7;}}i:26;a:4:{s:1:"a";i:27;s:1:"b";s:11:"extras.edit";s:1:"c";s:3:"web";s:1:"r";a:3:{i:0;i:1;i:1;i:2;i:2;i:7;}}i:27;a:4:{s:1:"a";i:28;s:1:"b";s:13:"extras.delete";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:28;a:4:{s:1:"a";i:29;s:1:"b";s:14:"analytics.view";s:1:"c";s:3:"web";s:1:"r";a:5:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:5;i:4;i:11;}}i:29;a:4:{s:1:"a";i:30;s:1:"b";s:16:"analytics.create";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:30;a:4:{s:1:"a";i:31;s:1:"b";s:14:"analytics.edit";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:31;a:4:{s:1:"a";i:32;s:1:"b";s:16:"analytics.delete";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:32;a:4:{s:1:"a";i:33;s:1:"b";s:13:"settings.view";s:1:"c";s:3:"web";s:1:"r";a:3:{i:0;i:1;i:1;i:2;i:2;i:11;}}i:33;a:4:{s:1:"a";i:34;s:1:"b";s:15:"settings.create";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:34;a:4:{s:1:"a";i:35;s:1:"b";s:13:"settings.edit";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:35;a:4:{s:1:"a";i:36;s:1:"b";s:15:"settings.delete";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:36;a:4:{s:1:"a";i:37;s:1:"b";s:10:"users.view";s:1:"c";s:3:"web";s:1:"r";a:3:{i:0;i:1;i:1;i:2;i:2;i:11;}}i:37;a:4:{s:1:"a";i:38;s:1:"b";s:12:"users.create";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:38;a:4:{s:1:"a";i:39;s:1:"b";s:10:"users.edit";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:39;a:4:{s:1:"a";i:40;s:1:"b";s:12:"users.delete";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:40;a:4:{s:1:"a";i:41;s:1:"b";s:12:"reports.view";s:1:"c";s:3:"web";s:1:"r";a:6:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:6;i:5;i:11;}}i:41;a:4:{s:1:"a";i:42;s:1:"b";s:14:"reports.create";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:42;a:4:{s:1:"a";i:43;s:1:"b";s:12:"reports.edit";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}i:43;a:4:{s:1:"a";i:44;s:1:"b";s:14:"reports.delete";s:1:"c";s:3:"web";s:1:"r";a:2:{i:0;i:1;i:1;i:2;}}}s:5:"roles";a:11:{i:0;a:3:{s:1:"a";i:1;s:1:"b";s:11:"Super Admin";s:1:"c";s:3:"web";}i:1;a:3:{s:1:"a";i:2;s:1:"b";s:13:"Administrator";s:1:"c";s:3:"web";}i:2;a:3:{s:1:"a";i:3;s:1:"b";s:6:"Bursar";s:1:"c";s:3:"web";}i:3;a:3:{s:1:"a";i:4;s:1:"b";s:10:"Accountant";s:1:"c";s:3:"web";}i:4;a:3:{s:1:"a";i:11;s:1:"b";s:7:"Auditor";s:1:"c";s:3:"web";}i:5;a:3:{s:1:"a";i:8;s:1:"b";s:10:"Front Desk";s:1:"c";s:3:"web";}i:6;a:3:{s:1:"a";i:9;s:1:"b";s:6:"Parent";s:1:"c";s:3:"web";}i:7;a:3:{s:1:"a";i:5;s:1:"b";s:7:"Teacher";s:1:"c";s:3:"web";}i:8;a:3:{s:1:"a";i:6;s:1:"b";s:9:"Registrar";s:1:"c";s:3:"web";}i:9;a:3:{s:1:"a";i:7;s:1:"b";s:9:"Librarian";s:1:"c";s:3:"web";}i:10;a:3:{s:1:"a";i:10;s:1:"b";s:7:"Student";s:1:"c";s:3:"web";}}}j2        gKsouthend-school-cache-spatie.permission.cachea:3:{s:5:"alias";a:3:{s:1:"a";s:2:"id";s:1:"b";s:4:"name";s:1:"c";s:10:"guard_name";}s:11:"permissions";a:44:{i:0;a:3:{s:1:"a";i:1;s:1:"b";s:15:"accounting.view";s:1:"c";s:3:"web";}i:1;a:3:{s:1:"a";i:2;s:1:"b";s:17:"accounting.create";s:1:"c";s:3:"web";}i:2;a:3:{s:1:"a";i:3;s:1:"b";s:15:"accounting.edit";s:1:"c";s:3:"web";}i:3;a:3:{s:1:"a";i:4;s:1:"b";s:17:"accounting.delete";s:1:"c";s:3:"web";}i:4;a:3:{s:1:"a";i:5;s:1:"b";s:12:"finance.view";s:1:"c";s:3:"web";}i:5;a:3:{s:1:"a";i:6;s:1:"b";s:14:"finance.create";s:1:"c";s:3:"web";}i:6;a:3:{s:1:"a";i:7;s:1:"b";s:12:"finance.edit";s:1:"c";s:3:"web";}i:7;a:3:{s:1:"a";i:8;s:1:"b";s:14:"finance.delete";s:1:"c";s:3:"web";}i:8;a:3:{s:1:"a";i:9;s:1:"b";s:11:"school.view";s:1:"c";s:3:"web";}i:9;a:3:{s:1:"a";i:10;s:1:"b";s:13:"school.create";s:1:"c";s:3:"web";}i:10;a:3:{s:1:"a";i:11;s:1:"b";s:11:"school.edit";s:1:"c";s:3:"web";}i:11;a:3:{s:1:"a";i:12;s:1:"b";s:13:"school.delete";s:1:"c";s:3:"web";}i:12;a:3:{s:1:"a";i:13;s:1:"b";s:17:"fixed_assets.view";s:1:"c";s:3:"web";}i:13;a:3:{s:1:"a";i:14;s:1:"b";s:19:"fixed_assets.create";s:1:"c";s:3:"web";}i:14;a:3:{s:1:"a";i:15;s:1:"b";s:17:"fixed_assets.edit";s:1:"c";s:3:"web";}i:15;a:3:{s:1:"a";i:16;s:1:"b";s:19:"fixed_assets.delete";s:1:"c";s:3:"web";}i:16;a:3:{s:1:"a";i:17;s:1:"b";s:13:"academic.view";s:1:"c";s:3:"web";}i:17;a:3:{s:1:"a";i:18;s:1:"b";s:15:"academic.create";s:1:"c";s:3:"web";}i:18;ggYsouthend-school-cache-spatie.permission.cachea:3:{s:5:"alias";a:4:{s:1:"a";s:2:"id";s:1:"b";s:4:"name";s:1:"c";s:10:"guard_name";s:1:"r";s:5:"roles";}s:11:"permissions";a:44:{i:0;a:4:{s:1:"a";i:1;s:1:"b";s:15:"accounting.view";s:1:"c";s:3:"web";s:1:"r";a:5:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:11;}}i:1;a:4:{s:1:"a";i:2;s:1:"b";s:17:"accounting.create";s:1:"c";s:3:"web";s:1:"r";a:4:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;}}i:2;a:4:{s:1:"a";i:3;s:1:"b";s:15:"accounting.edit";s:1:"c";s:3:"web";s:1:"r";a:4:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;}}i:3;a:4:{s:1:"a";i:4;s:1:"b";s:17:"accounting.delete";s:1:"c";s:3:"web";s:1:"r";a:4:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;}}i:4;a:4:{s:1:"a";i:5;s:1:"b";s:12:"finance.view";s:1:"c";s:3:"web";s:1:"r";a:7:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:8;i:5;i:9;i:6;i:11;}}i:5;a:4:{s:1:"a";i:6;s:1:"b";s:14:"finance.create";s:1:"c";s:3:"web";s:1:"r";a:5:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:8;}}i:6;a:4:{s:1:"a";i:7;s:1:"b";s:12:"finance.edit";s:1:"c";s:3:"web";s:1:"r";a:4:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;}}i:7;a:4:{s:1:"a";i:8;s:1:"b";s:14:"finance.delete";s:1:"c";s:3:"web";s:1:"r";a:3:{i:0;i:1;i:1;i:2;i:2;i:3;}}i:8;a:4:{s:1:"a";i:9;s:1:"b";s:11:"school.view";s:1:"c";s:3:"web";s:1:"r";a:10:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:5;i:4;i:6;i:5;i:7;i:6;i:8;i:7;i:9;i:8;i:10;i:9;i:11;}}i:9;a:4:{s:1:"a";i:10;s:1:"b";s:13:"school.create";s:1:"c";s:3:"web";s:1:"r";a:4:{i:0;i:1;i:1;i:2;i:2;i:6;i:3;i:8;}}i:10;a:4:{s:1:"a";i:11;s:1:"b";s:11:"school.edit";s:1:"c";s:3:"web";s:1:"r";a:4:{i:0;i:1;i:1;i:2;i:2;i:6;i:3;i:8;}}i:11;a:4:{s:1:"a";i:12;s:1:"b";s:13:"school.delete";s:1:"c";s:3:"web";s:1:"r";a:3:{i:0;i:1;i:1;i:2;i:2;i:6;}}i:12;a:4:{s:1:"a";i:13;s:1:"b";s:17:"fixed_assets.view";s:1:"c";s:3:"web";s:1:"r";a:5:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:11;}}i:13;a:4:{s:1:"a";i:14;s:1:"b";s:19:"fixed_assets.create";s:1:"c";s:3:"web";s:1:"r";a:3:{i:0;i:1;i:1;i:2;i:2 1southend-school-cache-spatie.permission.cache j2           ,~>C N  H  H  ~ : z > ADQ[=,)33reports.deleteweb2026-06-16 02:17:372026-06-16 02:17:37;+%33reports.editweb2026-06-16 02:17:372026-06-16 02:17:37=*)33reports.createweb2026-06-16 02:17:372026-06-16 02:17:37;)%33reports.viewweb2026-06-16 02:17:372026-06-16 02:17:37;(%33users.deleteweb2026-06-16 02:17:372026-06-16 02:17:379'!33users.editweb2026-06-16 02:17:372026-06-16 02:17:37;&%33users.createweb2026-06-16 02:17:372026-06-16 02:17:379%!33users.viewweb2026-06-16 02:17:372026-06-16 02:17:37>$+33settings.deleteweb2026-06-16 02:17:372026-06-16 02:17:37<#'33settings.editweb2026-06-16 02:17:372026-06-16 02:17:37>"+33settings.createweb2026-06-16 02:17:372026-06-16 02:17:37+33academic.deleteweb2026-06-16 02:17:372026-06-16 02:17:37<'33academic.editweb2026-06-16 02:17:372026-06-16 02:17:37>+33academic.createweb2026-06-16 02:17:372026-06-16 02:17:37<'33academic.viewweb2026-06-16 02:17:372026-06-16 02:17:37B333fixed_assets.deleteweb2026-06-16 02:17:372026-06-16 02:17:37@/33fixed_assets.editweb2026-06-16 02:17:372026-06-16 02:17:37B333fixed_assets.createweb2026-06-16 02:17:372026-06-16 02:17:37@ /33fixed_assets.viewweb2026-06-16 02:17:372026-06-16 02:17:37< '33school.deleteweb2026-06-16 02:17:372026-06-16 02:17:37: #33school.editweb2026-06-16 02:17:372026-06-16 02:17:37< '33school.createweb2026-06-16 02:17:372026-06-16 02:17:37: #33school.viewweb2026-06-16 02:17:372026-06-16 02:17:37=)33finance.deleteweb2026-06-16 02:17:372026-06-16 02:17:37;%33finance.editweb2026-06-16 02:17:372026-06-16 02:17:37=)33finance.createweb2026-06-16 02:17:372026-06-16 02:17:37;%33finance.viewweb2026-06-16 02:17:372026-06-16 02:17:37@/33accounting.deleteweb2026-06-16 02:17:372026-06-16 02:17:37>+33accounting.editweb2026-06-16 02:17:362026-06-16 02:17:36@/33accounting.createweb2026-06-16 02:17:362026-06-16 02:17:36>+33accounting.viewweb2026-06-16 02:17:362026-06-16 02:17:36 , W)Ao 1   J  a w qE\ )  @1 } U j )reports.deleteweb,%reports.editweb+)reports.createweb*%reports.viewweb)%users.deleteweb(!users.editweb'%users.createweb&!users.viewweb%+settings.deleteweb$'settings.editweb#+settings.createweb"'settings.viewweb!-analytics.deleteweb )analytics.editweb-analytics.createweb)analytics.viewweb'extras.deleteweb#extras.editweb'extras.createweb#extras.viewweb7communications.deleteweb3communications.editweb7communications.createweb3communications.viewweb+academic.deleteweb'academic.editweb+academic.createweb'academic.viewweb3fixed_assets.deleteweb/fixed_assets.editweb3fixed_assets.createweb/fixed_assets.viewweb 'school.deleteweb #school.editweb 'school.createweb #school.viewweb )finance.deleteweb%finance.editweb)finance.createweb%finance.viewweb/accounting.deleteweb+accounting.editweb/accounting.createweb+ accounting.viewweb Oh- 6 33Auditorweb2026-06-16 02:17:382026-06-16 02:17:386 33Studentweb2026-06-16 02:17:382026-06-16 02:17:385 33Parentweb2026-06-16 02:17:372026-06-16 02:17:379!33Front Deskweb2026-06-16 02:17:372026-06-16 02:17:37833Librarianweb2026-06-16 02:17:372026-06-16 02:17:37833Registrarweb2026-06-16 02:17:372026-06-16 02:17:37633Teacherweb2026-06-16 02:17:372026-06-16 02:17:379!33Accountantweb2026-06-16 02:17:372026-06-16 02:17:37533Bursarweb2026-06-16 02:17:372026-06-16 02:17:37<'33Administratorweb2026-06-16 02:17:372026-06-16 02:17:37:#33Super Adminweb2026-06-16 02:17:372026-06-16 02:17:37 Y z ; o I  Z _ (D $7q cetablerolesrolesCREATE TABLE "roles" ("id" inte *-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, "remember_token" varchar, "created_at" datetime, "updated_at" datetime, "staff_id" integer)U##qtablepermissionspermissionsCREATE TABLE "permissions" ("id" integer primary key autoincrement not null, "name" varchar not null, "guard_name" varchar not null, "created_at" datetime, "updated_at" datetime)v;#indexfailed_jobs_uuid_uniquefailed_jobsCREATE UNIQUE INDEX "failed_jobs_uuid_unique" on "failed_jobs" ("uuid")5e#oindexfailed_jobs_connection_queue_failed_at_indexfailed_jobsCREATE INDEX "failed_jobs_connection_queue_failed_at_index" on "failed_jobs" ("connection", "queue", "failed_at").###tablefailed_jobsfailed_jobsCREATE TABLE "failed_jobs" ("id" integer primary key autoincrement not null, "uuid" varchar not null, "connection" varchar not null, "queue" varchar not null, "payload" text not null, "exception" text not null, "failed_at" datetime not null default CURRENT_TIMESTAMP)5I#indexsqlite_autoindex_job_batches_1job_batches`##tablejob_batchesjob_batchesCREATE TABLE "job_batches" ("id" varchar not null, "name" varchar not null, "total_jobs" integer not null, "pending_jobs" integer not null, "failed_jobs" integer not null, "failed_job_ids" text not null, "options" text, "cancelled_at" integer, "created_at" integer not null, "finished_at" integer, primary key ("id"))S-sindexjobs_queue_indexjobsCREATE INDEX "jobs_queue_index" on "jobs" ("queue")etablejobsjobsCREATE 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##indexcache_locks_expiration_indexcache_locksCREATE INDEX "cache_locks_expiration_index" on "cache_locks" ("expiration")$##tablecache_lockscache_locksCREATE TABLE "cache_locks" ("key" varchar not null, "owner" varchar not null, "expiration" integer not null, primary key ("key"))5I#indexsqlite_autoindex_cache_locks_1cache_locksg 9 indexcache_expiration_indexcacheCREATE INDEX "cache_expiration_index" on "cache" ("expiration") }tablecachecache CREATE TABLE "cache" ("key" varchar not null, "value" text not null, "expiration" integer not null, primary key ("key"))) =indexsqlite_autoindex_cache_1cache | 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")WtablesessionssessionsCREATE 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"))/Cindexsqlite_autoindex_sessions_1sessions >77tablepassword_reset_tokenspassword_reset_tokensCREATE TABLE "password_reset_tokens" ("email" varchar not null, "token" varchar not null, "created_at" datetime, primary key ("email"))I]7indexsqlite_autoindex_password_reset_tokens_1password_reset_tokensa1indexusers_email_uniqueusersCREATE UNIQUE INDEX "users_email_unique" on "users" ("email")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, "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) ??n_OAuditorweb Studentweb Parentweb !Front DeskwebLibrarianwebRegistrarwebTeacherweb!AccountantwebBursarweb'Administratorweb# Super Adminweb L{6 #   z.] b3indexaccounts_name_indexaccounts(CREATE INDEX "accounts_name_index" on "accounts" ("name")I$etableaccountsaccounts'CREATE TABLE "accounts" E+#indexjournal_entries_status_indexjournal_entries1CREATE INDEX "jourA+indexjournal_entries_date_indexjournal_entries.CREATE INDEX "journal_entries_date_index" on "journal_entries" ("date")**[+[indexjournal_entries_reference_number_uniquejournal_entries-CREATE UNIQUE INDEX "journal_entries_reference_number_unique" on "journal_entries" ("reference_number")CetablerolesrolesCREATE TABLE "roles" ("id" integer primary key autoincrement not null, "name" varchar not null, "guard_name" varchar not null, "created_at" datetime, "updated_at" datetime)Q#Mindexpermissions_name_guard_name_uniquepermissionsCREATE UNIQUE INDEX "permissions_name_guard_name_unique" on "permissions" ("name", "guard_name")V)++ctablejournal_entriesjournal_entries,CREATE TABLE "journal_entries" ("id" integer primary key autoincrement not null, "reference_number" varchar not null, "date" date not null, "description" text, "source" varchar, "source_reference" varchar, "posted_by" integer, "posted_at" datetime, "status" varchar not null default 'draft', "void_reason" text, "created_at" datetime, "updated_at" datetime, foreign key("posted_by") references "users"("id") on delete set null)g(7indexaccounts_status_indexaccounts+CREATE INDEX "accounts_status_index" on "accounts" ("status")j'5indexaccounts_code_uniqueaccounts*CREATE UNIQUE INDEX "accounts_code_unique" on "accounts" ("code")m&;indexaccounts_category_indexaccounts)CREATE INDEX "accounts_category_index" on "accounts" ("category")`%3indexaccounts_name_indexaccounts(CREATE INDEX "accounts_name_index" on "accounts" ("name")I$etableaccountsaccounts'CREATE TABLE "accounts" ("id" integer primary key autoincrement not null, "code" varchar not null, "name" varchar not null, "category" varchar check ("category" in ('asset', 'liability', 'equity', 'revenue', 'expense')) not null, "account_type" varchar, "normal_balance_side" varchar check ("normal_balance_side" in ('debit', 'credit')) not null, "opening_balance" numeric not null default '0', "opening_balance_date" date, "status" varchar not null default 'active', "description" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime)G#[5indexsqlite_autoindex_role_has_permissions_1role_has_permissions&S"55Itablerole_has_permissionsrole_has_permissions%CREATE 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"))-!_+]indexmodel_has_roles_model_id_model_type_indexmodel_has_roles$CREATE INDEX "model_has_roles_model_id_model_type_index" on "model_has_roles" ("model_id", "model_type")= Q+indexsqlite_autoindex_model_has_roles_1model_has_roles#++gtablemodel_has_rolesmodel_has_roles"CREATE 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"))Ek7uindexmodel_has_permissions_model_id_model_type_indexmodel_has_permissions!CREATE INDEX "model_has_permissions_model_id_model_type_index" on "model_has_permissions" ("model_id", "model_type")I]7indexsqlite_autoindex_model_has_permissions_1model_has_permissions B77#tablemodel_has_permissionsmodel_has_permissionsCREATE 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"))E5indexroles_name_guard_name_uniquerolesCREATE UNIQUE INDEX "roles_name_guard_name_unique" on "roles" ("name", "guard_name")     + App\Models\User  + App\Models\User  + App\Models\User /|ung`YRKD=6/(!  wog_WOG?7/'  w o g _  w o e W O ^ V N F > 6 . G ? &     7 / ~ v n f ^ V N F > 6 . &     ))   )w,v+u*t)s(K ,J +I *H )G (F 'E &)>) =% <! ; : 9 8 7 6 5 4  3 2 1 0 / . - ,+*)('& % $ #"!             ~}|{zyx r'q&p%o$n#m"l!k jihgfedcba`_^]\[ZYX W V U T SRQPONML D %C $B #A "@ !? > = < ; : 9 8 7 6 5 4 3 2 1 0 / . - , + * ) ( ' & % $ # " !     g z ^  U  L  C q :  1  (~ ~ 6 hu u l l c cZ  _Q H ?y6 Z Vq- Qi$ HaY ?  MQ I A 9 - D1 $) !   ;    2    ) y  o  )) ),+*)( , + * ) ( ')) >% =! < ; : 9 8 7 6 5  4 3 2 1 0 / . -,+*)(' & % $#"!                '&%$#"!        &+ % $ # " !                                       $B \ w  * n >{Hw?h;335009Other Operating Expenseexpenseexpensedebitactive2026-06-16 02:17:482026-06-16 02:17:48e5335008Depreciation Expenseexpenseexpensedebitactive2026-06-16 02:17:482026-06-16 02:17:48lC335007IT & Communications Expenseexpenseexpensedebitactive2026-06-16 02:17:482026-06-16 02:17:48a-335006Catering Expenseexpenseexpensedebitactive2026-06-16 02:17:482026-06-16 02:17:48d3335005Maintenance Expenseexpenseexpensedebitactive2026-06-16 02:17:482026-06-16 02:17:48i=335004Transport & Fuel Expenseexpenseexpensedebitactive2026-06-16 02:17:482026-06-16 02:17:48j?335003Academic Supplies Expenseexpenseexpensedebitactive2026-06-16 02:17:482026-06-16 02:17:48b/335002Utilities Expenseexpenseexpensedebitactive2026-06-16 02:17:482026-06-16 02:17:48a-335001Salaries Expenseexpenseexpensedebitactive2026-06-16 02:17:482026-06-16 02:17:48]%334004Other Incomerevenueincomecreditactive2026-06-16 02:17:482026-06-16 02:17:48b/334003Hostel Fee Incomerevenueincomecreditactive2026-06-16 02:17:482026-06-16 02:17:48e5334002Transport Fee Incomerevenueincomecreditactive2026-06-16 02:17:482026-06-16 02:17:48_)334001Tuition Incomerevenueincomecreditactive2026-06-16 02:17:482026-06-16 02:17:48f9333099Opening Balance Equityequityequitycreditactive2026-06-16 02:17:482026-06-16 02:17:48a/333002Retained Earningsequityequitycreditactive2026-06-16 02:17:482026-06-16 02:17:48W333001Capitalequityequitycreditactive2026-06-16 02:17:482026-06-16 02:17:48 Y/332200Deferred Income (Fees Paid in Advance)liabilitycurrent_liabilitycreditactive2026-06-16 02:17:482026-06-16 02:17:48m +/332110Pension Payableliabilitycurrent_liabilitycreditactive2026-06-16 02:17:482026-06-16 02:17:48j %/332100PAYE Payableliabilitycurrent_liabilitycreditactive2026-06-16 02:17:482026-06-16 02:17:48z E/332001Accounts Payable (Suppliers)liabilitycurrent_liabilitycreditactive2026-06-16 02:17:482026-06-16 02:17:48m =%331900Accumulated Depreciationassetcontra_assetcreditactive2026-06-16 02:17:482026-06-16 02:17:48wU#331520Fixed Assets - Equipment & Furnitureassetfixed_assetdebitactive2026-06-16 02:17:482026-06-16 02:17:48j;#331510Fixed Assets - Vehiclesassetfixed_assetdebitactive2026-06-16 02:17:482026-06-16 02:17:48k=#331500Fixed Assets - Buildingsassetfixed_assetdebitactive2026-06-16 02:17:482026-06-16 02:17:48wQ'331100Accounts Receivable (Student Fees)assetcurrent_assetdebitactive2026-06-16 02:17:482026-06-16 02:17:48h3'331004Cash on Hand - Tillassetcurrent_assetdebitactive2026-06-16 02:17:482026-06-16 02:17:48vO'331003Cash at Bank - FDH Bank (Reserve)assetcurrent_assetdebitactive2026-06-16 02:17:482026-06-16 02:17:48qE'331002Cash at Bank - Standard Bankassetcurrent_assetdebitactive2026-06-16 02:17:482026-06-16 02:17:48g1'331001Cash at Bank - NBMassetcurrent_assetdebitactive2026-06-16 02:17:482026-06-16 02:17:48  dh Qt G+ 1 f7 R ~ $ ;Other Operating Expense5Depreciation ExpenseCIT & Communications Expense-Catering Expense3Maintenance Expense=Transport & Fuel Expense?Academic Supplies Expense/Utilities Expense-Salaries Expense%Other Income/Hostel Fee Income5Transport Fee Income)Tuition Income9Opening Balance Equity/Retained Earnings Capital*YDeferred Income (Fees Paid in Advance) +Pension Payable %PAYE Payable EAccounts Payable (Suppliers) =Accumulated Depreciation (UFixed Assets - Equipment & Furniture;Fixed Assets - Vehicles=Fixed Assets - Buildings&QAccounts Receivable (Student Fees)3Cash on Hand - Till%OCash at Bank - FDH Bank (Reserve) ECash at Bank - Standard Bank1 Cash at Bank - NBM dYN}oB6* expense expense expense expense expense expense expense expense expense revenue revenue revenue revenue equity equity equity liability liability liability liability asset asset asset asset asset asset asset asset asset zqh_VMD;2) 50095008500750065005500450035002500140044003400240013099300230012200 2110 2100 2001 1900 1520151015001100100410031002 1001 }rg\QF;0% active active active active active active active active active active active active active active active active active active active active active active active active active active active active  active        Jz F m_WJY55Utablebank_statement_linesbank_statement_lines>CO57indexbank_reconciliations_status_indexbank_reconciliations=CREATE INDEX "bank_reconciliations_status_index" on "bank_reconciliations" ("status")/8_5Windexbank_reconciliations_statement_date_indexbank_reconciliations))5tableacademic_yearsacademic_yearsCCREATE TABLE "academic_years" ("id" integer primary key autoincrement not null, "name" varchar not null, "code" varchar not null, "starts_on" date not null, "ends_on" date not null, "is_current" tinyint(1) not null default '0', "status" varchar not null default 'active', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime)#=W5Gindexbank_statement_lines_is_matched_indexbank_statement_linesBCREATE INDEX "bank_statement_lines_is_matched_index" on "bank_statement_lines" ("is_matched") <U5Cindexbank_statement_lines_reference_indexbank_statement_linesACREATE INDEX "bank_statement_lines_reference_index" on "bank_statement_lines" ("reference")5;c5_indexbank_statement_lines_transaction_date_indexbank_statement_lines?CREATE INDEX "bank_statement_lines_transaction_date_index" on "bank_statement_lines" ("transaction_date"):55Utablebank_statement_linesbank_statement_lines>CREATE TABLE "bank_statement_lines" ("id" integer primary key autoincrement not null, "bank_reconciliation_id" integer not null, "transaction_date" date not null, "description" varchar, "reference" varchar, "amount" numeric not null, "type" varchar check ("type" in ('debit', 'credit')) not null, "matched_journal_line_id" integer, "is_matched" tinyint(1) not null default '0', "created_at" datetime, "updated_at" datetime, foreign key("bank_reconciliation_id") references "bank_reconciliations"("id") on delete cascade, foreign key("matched_journal_line_id") references "journal_lines"("id") on delete set null)   k ;!! 332025/2026 Academic Year2025-20262025-09-012026-07-31active2026-06-16 02:17:492026-06-16 02:17:49   2025-2026    active S !! 33Term 22026-01-062026-04-10active2026-06-16 02:17:492026-06-16 02:17:49       active CF33currencyMWKfinancestring2026-06-16 02:17:492026-06-16 02:17:49M+33current_term_id1academicinteger2026-06-16 02:17:492026-06-16 02:17:49V=33current_academic_year_id1academicinteger2026-06-16 02:17:492026-06-16 02:17:49c#G33school_nameSouthend International Schoolgeneralstring2026-06-16 02:17:492026-06-16 02:17:49  currency+current_term_id=current_academic_year_id# school_name  finance academic academic  general m%!! 33SHS-2026-003AminaJuma2013-01-22female2025-09-01active2026-06-16 02:17:492026-06-16 02:17:49n%!! 33SHS-2026-002ChisomoPhiri2011-08-02male2025-09-01active2026-06-16 02:17:492026-06-16 02:17:49q%!! 33SHS-2026-001ThandiweBanda2012-03-14female2025-09-01active2026-06-16 02:17:492026-06-16 02:17:49 JumaAminaPhiriChisomo BandaThandiwe  \ EBy}ftableguardiansguardiansTCREATE TABLE "guardians" ("id" integer primary key autoincrement not null, "first_name" varchar not null, "last_name" varchar not null, "email" varchar, "phone" varchar, "occupation" varchar, "address" text, "relationship_type" varchar, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "user_id" integer)j[5indexsubjects_code_uniquesubjectsaCREATE UNIQUE INDEX "subjects_code_unique" on "subjects" ("code")4Z;tablesubjectssubjects`CREATE TABLE "subjects" ("id" integer primary key autoincrement not null, "code" varchar not null, "name" varchar not null, "department" varchar, "description" text, "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime)ZY1{indexstaff_status_indexstaff_CREATE INDEX "staff_status_index" on "staff" ("status")gX9 indexstaff_department_indexstaff^CREATE INDEX "staff_department_index" on "staff" ("department")dW7indexstaff_job_title_indexstaff]CREATE INDEX "staff_job_title_index" on "staff" ("job_title")aV1indexstaff_email_uniquestaff\CREATE UNIQUE INDEX "staff_email_unique" on "staff" ("email")vU?#indexstaff_staff_number_uniquestaff[CREATE UNIQUE INDEX "staff_staff_number_unique" on "staff" ("staff_number")TM9indexstaff_last_name_first_name_indexstaffZCREATE INDEX "staff_last_name_first_name_index" on "staff" ("last_name", "first_name")4SGtablestaffstaffYCREATE TABLE "staff" ("id" integer primary key autoincrement not null, "staff_number" varchar not null, "first_name" varchar not null, "last_name" varchar not null, "other_names" varchar, "email" varchar, "phone" varchar, "job_title" varchar, "department" varchar, "hire_date" date, "salary" numeric, "status" varchar not null default 'active', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime)CRi-}indexstudent_guardian_student_id_guardian_id_uniquestudent_guardianXCREATE UNIQUE INDEX "student_guardian_student_id_guardian_id_unique" on "student_guardian" ("student_id", "guardian_id")tQ--tablestudent_guardianstudent_guardianWCREATE TABLE "student_guardian" ("id" integer primary key autoincrement not null, "student_id" integer not null, "guardian_id" integer not null, "relationship" varchar, "is_primary" tinyint(1) not null default '0', "can_pick_up" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime, foreign key("student_id") references "students"("id") on delete cascade, foreign key("guardian_id") references "guardians"("id") on delete cascade)7indexguardians_phone_indexguardiansVCREATE INDEX "guardians_phone_index" on "guardians" ("phone")j7indexguardians_email_indexguardiansUCREATE INDEX "guardians_email_index" on "guardians" ("email")gM7indexstudents_status_indexstudentsSCREATE INDEX "students_status_index" on "students" ("status")dL5indexstudents_email_indexstudentsRCREATE INDEX "students_email_index" on "students" ("email")KM?indexstudents_admission_number_uniquestudentsQCREATE UNIQUE INDEX "students_admission_number_unique" on "students" ("admission_number")JSEindexstudents_last_name_first_name_indexstudentsOCREATE INDEX "students_last_name_first_name_index" on "students" ("last_name", "first_name")yIEtablestudentsstudentsNCREATE TABLE "students" ("id" integer primary key autoincrement not null, "admission_number" varchar not null, "first_name" varchar not null, "last_name" varchar not null, "other_names" varchar, "date_of_birth" date, "gender" varchar check ("gender" in ('male', 'female', 'other')), "email" varchar, "phone" varchar, "address" text, "admission_date" date, "academic_year_id" integer, "status" varchar not null default 'active', "medical_notes" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("academic_year_id") references "academic_years"("id") on delete set null) %SHS-2026-003%SHS-2026-002% SHS-2026-001   active active  active  UT                oo n M n@ia9# indexattendances_date_indexattendancesrCREATE INDEX "attendances_date_index" on "attendances" ("date")jM#Eindexattendances_class_id_date_uniqueattendancesqCREATE UNIQUE INDEX "attendances_class_id_date_unique" on "attendances" ("class_id", "date")s\?indexsubjects_department_indexsubjectsbCREATE INDEX "subjects_department_index" on "subjects" ("department")i##}tableattendancesattendancespCREATE TABLE "attendances" ("id" integer primary key autoincrement not null, "class_id" integer not null, "date" date not null, "recorded_by" integer, "term_id" integer, "status" varchar not null default 'open', "notes" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("class_id") references "classes"("id") on delete cascade, foreign key("recorded_by") references "staff"("id") on delete set null, foreign key("term_id") references "terms"("id") on delete set null)0ha+aindextimetable_slots_class_id_day_of_week_indextimetable_slotsoCREATE INDEX "timetable_slots_class_id_day_of_week_index" on "timetable_slots" ("class_id", "day_of_week")g++Gtabletimetable_slotstimetable_slotsnCREATE TABLE "timetable_slots" ("id" integer primary key autoincrement not null, "class_id" integer not null, "subject_id" integer not null, "staff_id" integer, "day_of_week" integer not null, "starts_at" time not null, "ends_at" time not null, "room" varchar, "term_id" integer, "created_at" datetime, "updated_at" datetime, foreign key("class_id") references "classes"("id") on delete cascade, foreign key("subject_id") references "subjects"("id") on delete cascade, foreign key("staff_id") references "staff"("id") on delete set null, foreign key("term_id") references "terms"("id") on delete set null){fA'indexclass_student_status_indexclass_studentmCREATE INDEX "class_student_status_index" on "class_student" ("status").e]'eindexclass_student_class_id_student_id_uniqueclass_studentlCREATE UNIQUE INDEX "class_student_class_id_student_id_unique" on "class_student" ("class_id", "student_id").d''tableclass_studentclass_studentkCREATE TABLE "class_student" ("id" integer primary key autoincrement not null, "class_id" integer not null, "student_id" integer not null, "enrolled_on" date, "status" varchar not null default 'active', "created_at" datetime, "updated_at" datetime, foreign key("class_id") references "classes"("id") on delete cascade, foreign key("student_id") references "students"("id") on delete cascade)cc5indexclasses_status_indexclassesjCREATE INDEX "classes_status_index" on "classes" ("status")_b3indexclasses_level_indexclassesiCREATE INDEX "classes_level_index" on "classes" ("level")fa3 indexclasses_code_uniqueclasseshCREATE UNIQUE INDEX "classes_code_unique" on "classes" ("code")`tableclassesclassesgCREATE TABLE "classes" ("id" integer primary key autoincrement not null, "name" varchar not null, "code" varchar not null, "academic_year_id" integer not null, "class_teacher_id" integer, "capacity" integer, "room" varchar, "level" varchar, "status" varchar not null default 'active', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("academic_year_id") references "academic_years"("id") on delete cascade, foreign key("class_teacher_id") references "staff"("id") on delete set null)._]'eindexstaff_subject_staff_id_subject_id_uniquestaff_subjecteCREATE UNIQUE INDEX "staff_subject_staff_id_subject_id_unique" on "staff_subject" ("staff_id", "subject_id")l^''tablestaff_subjectstaff_subjectdCREATE TABLE "staff_subject" ("id" integer primary key autoincrement not null, "staff_id" integer not null, "subject_id" integer not null, "created_at" datetime, "updated_at" datetime, foreign key("staff_id") references "staff"("id") on delete cascade, foreign key("subject_id") references "subjects"("id") on delete cascade)p]=indexsubjects_is_active_indexsubjectscCREATE INDEX "subjects_is_active_index" on "subjects" ("is_active")               {{  W  B\1? o{+tablesupplierssuppliersCREATE TABLE7indexsuppliers_code_uniquesuppliersCREATE UNIQUE INDEX "suppliers_code_unique" on "suppliers" ("code")o{+tablesupplierssuppliersCREATE TABLE "suppliers" ("id" integer primary key autoincrement not null<O57indexdisciplinary_records_status_indexdisciplinary_recordsCREATE INDEX "disciplinary_records_status_index" on "disciplinary_records" ("status")yS5?indexdisciplinary_records_category_indexdisciplinary_recordsCREATE INDEX "disciplinary_records_category_index" on "disciplinary_records" ("category")mk9# indexattendances_date_indexattendancesrCREATE INDEX "attendances_date_index" on "attendances" ("date")jM#Eindexattendances_class_id_date_uniqueattendancesqCREATE UNIQUE INDEX "attendances_class_id_date_unique" on "attendances" ("class_id", "date")-x]5Sindexdisciplinary_records_incident_date_indexdisciplinary_recordsCREATE INDEX "disciplinary_records_incident_date_index" on "disciplinary_records" ("incident_date")(w55stabledisciplinary_recordsdisciplinary_recordsCREATE TABLE "disciplinary_records" ("id" integer primary key autoincrement not null, "student_id" integer not null, "incident_date" date not null, "category" varchar, "description" text not null, "action_taken" varchar, "recorded_by" integer, "status" varchar not null default 'open', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("student_id") references "students"("id") on delete cascade, foreign key("recorded_by") references "staff"("id") on delete set null)ov;!indexbook_loans_status_indexbook_loans~CREATE INDEX "book_loans_status_index" on "book_loans" ("status")ru!!/tablebook_loansbook_loans}CREATE TABLE "book_loans" ("id" integer primary key autoincrement not null, "book_id" integer not null, "student_id" integer not null, "loaned_on" date not null, "due_on" date not null, "returned_on" date, "status" varchar not null default 'loaned', "fine_amount" numeric not null default '0', "issued_by" integer, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("book_id") references "books"("id") on delete cascade, foreign key("student_id") references "students"("id") on delete cascade, foreign key("issued_by") references "staff"("id") on delete set null)at5indexbooks_category_indexbooks|CREATE INDEX "books_category_index" on "books" ("category")Zs1{indexbooks_author_indexbooks{CREATE INDEX "books_author_index" on "books" ("author")Tr-sindexbooks_isbn_indexbookszCREATE INDEX "books_isbn_index" on "books" ("isbn")Wq/windexbooks_title_indexbooksyCREATE INDEX "books_title_index" on "books" ("title")jp3tablebooksbooksxCREATE TABLE "books" ("id" integer primary key autoincrement not null, "isbn" varchar, "title" varchar not null, "author" varchar, "category" varchar, "copies_total" integer not null default '1', "copies_available" integer not null default '1', "shelf_location" varchar, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime)oK1/indexattendance_records_status_indexattendance_recordswCREATE INDEX "attendance_records_status_index" on "attendance_records" ("status")Qnq1 indexattendance_records_attendance_id_student_id_uniqueattendance_recordsvCREATE UNIQUE INDEX "attendance_records_attendance_id_student_id_unique" on "attendance_records" ("attendance_id", "student_id")m115tableattendance_recordsattendance_recordstCREATE TABLE "attendance_records" ("id" integer primary key autoincrement not null, "attendance_id" integer not null, "student_id" integer not null, "status" varchar check ("status" in ('present', 'absent', 'late', 'excused')) not null default 'present', "remarks" text, "created_at" datetime, "updated_at" datetime, foreign key("attendance_id") references "attendances"("id") on delete cascade, foreign key("student_id") references "students"("id") on delete cascade)sl=#indexattendances_status_indexattendancessCREATE INDEX "attendances_status_index" on "attendances" ("status")                  > 8 Rjbz ?indexinvoices_issue_date_indexinvoicesCREATE INDEX "invoices_issue_date_index" on "in ''Stableinvoice_linesinvoice_linesCREATE TABLE "invoice_lines" ("id" integer primary key autoincrement not null, "invoice_id" integer not null, "description" varchar not null, "quantity" numeric not null default '1', "unit_price" numeric not null default '0', "line_total" numeric not null default '0', "account_id" integer, "created_at" datetime, "updated_at" datetime, foreign key("invoice_id") references "invoices"("id") on delete cascade, foreign key("account_id") references "accounts"("id") on delete set null)h7indexinvoices_status_indexinvoicesCREATE INDEX "invoices_status_index" on "invoices" ("status")zO57indexdisciplinary_records_status_indexdisciplinary_recordsCREATE INDEX "disciplinary_records_status_index" on "disciplinary_records" ("status")yS5?indexdisciplinary_records_category_indexdisciplinary_recordsCREATE INDEX "disciplinary_records_category_index" on "disciplinary_records" ("category")n;indexinvoices_due_date_indexinvoicesCREATE INDEX "invoices_due_date_index" on "invoices" ("due_date")t?indexinvoices_issue_date_indexinvoicesCREATE INDEX "invoices_issue_date_index" on "invoices" ("issue_date") I7indexinvoices_invoice_number_uniqueinvoicesCREATE UNIQUE INDEX "invoices_invoice_number_unique" on "invoices" ("invoice_number")w?tableinvoicesinvoicesCREATE TABLE "invoices" ("id" integer primary key autoincrement not null, "invoice_number" varchar not null, "student_id" integer not null, "issue_date" date not null, "due_date" date, "status" varchar not null default 'draft', "subtotal" numeric not null default '0', "tax_amount" numeric not null default '0', "total_amount" numeric not null default '0', "amount_paid" numeric not null default '0', "balance_due" numeric not null default '0', "notes" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("student_id") references "students"("id") on delete restrict)h7indexexpenses_status_indexexpensesCREATE INDEX "expenses_status_index" on "expenses" ("status")zCindexexpenses_expense_date_indexexpensesCREATE INDEX "expenses_expense_date_index" on "expenses" ("expense_date") I7indexexpenses_expense_number_uniqueexpensesCREATE UNIQUE INDEX "expenses_expense_number_unique" on "expenses" ("expense_number")gtableexpensesexpensesCREATE TABLE "expenses" ("id" integer primary key autoincrement not null, "expense_number" varchar not null, "supplier_id" integer, "account_id" integer not null, "amount" numeric not null, "expense_date" date not null, "description" text, "status" varchar not null default 'pending', "recorded_by" integer, "journal_entry_id" integer, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("supplier_id") references "suppliers"("id") on delete set null, foreign key("account_id") references "accounts"("id") on delete restrict, foreign key("recorded_by") references "users"("id") on delete set null, foreign key("journal_entry_id") references "journal_entries"("id") on delete set null)l9 indexsuppliers_status_indexsuppliersCREATE INDEX "suppliers_status_index" on "suppliers" ("status")x~Aindexsuppliers_tax_number_indexsuppliersCREATE INDEX "suppliers_tax_number_index" on "suppliers" ("tax_number")i}7indexsuppliers_email_indexsuppliersCREATE INDEX "suppliers_email_index" on "suppliers" ("email")o|7indexsuppliers_code_uniquesuppliersCREATE UNIQUE INDEX "suppliers_code_unique" on "suppliers" ("code")o{+tablesupplierssuppliersCREATE TABLE "suppliers" ("id" integer primary key autoincrement not null, "code" varchar not null, "name" varchar not null, "contact_person" varchar, "email" varchar, "phone" varchar, "address" text, "tax_number" varchar, "status" varchar not null default 'active', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime)                 8F| O 4q=indexpayments_reference_indexpaymentsCREATE INDEX "payments_reference_index" on "payments" ("reference")h7indexpayments_status_indexpaymentsCREATE INDEX "payments_status_index" on "payments" ("status")G'indexpayments_payment_method_indexpaymentsCREATE INDEX "payments_payment_method_index" on "payments" ("payment_method")zCindexpayments_payment_date_indexpaymentsCREATE INDEX "payments_payment_date_index" on "payments" ("payment_date") I7indexpayments_payment_number_uniquepaymentsCREATE UNIQUE INDEX "payments_payment_number_unique" on "payments" ("payment_number")zCindexreceipts_payment_date_indexreceiptsCREATE INDEX "receipts_payment_date_index" on "receipts" ("payment_date") I7indexreceipts_receipt_number_uniquereceiptsCREATE UNIQUE INDEX "receipts_receipt_number_unique" on "receipts" ("receipt_number")m+tablereceiptsreceiptsCREATE TABLE "receipts" ("id" integer primary key autoincrement not null, "receipt_number" varchar not null, "student_id" integer not null, "amount" numeric not null, "payment_date" date not null, "payment_method" varchar, "reference" varchar, "received_by" integer, "account_id" integer, "notes" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("student_id") references "students"("id") on delete restrict, foreign key("received_by") references "users"("id") on delete set null, foreign key("account_id") references "accounts"("id") on delete set null)7++#tablequotation_linesquotation_linesCREATE TABLE "quotation_lines" ("id" integer primary key autoincrement not null, "quotation_id" integer not null, "description" varchar not null, "quantity" numeric not null default '1', "unit_price" numeric not null default '0', "line_total" numeric not null default '0', "created_at" datetime, "updated_at" datetime, foreign key("quotation_id") references "quotations"("id") on delete cascade)p ;!indexquotations_status_indexquotationsCREATE INDEX "quotations_status_index" on "quotations" ("status")| C!indexquotations_issue_date_indexquotationsCREATE INDEX "quotations_issue_date_index" on "quotations" ("issue_date") Q!Gindexquotations_quotation_number_uniquequotationsCREATE UNIQUE INDEX "quotations_quotation_number_unique" on "quotations" ("quotation_number"): !!=tablequotationsquotationsCREATE TABLE "quotations" ("id" integer primary key autoincrement not null, "quotation_number" varchar not null, "student_id" integer, "customer_name" varchar, "issue_date" date not null, "valid_until" date, "status" varchar not null default 'draft', "subtotal" numeric not null default '0', "tax_amount" numeric not null default '0', "total_amount" numeric not null default '0', "notes" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("student_id") references "students"("id") on delete set null)>''Stableinvoice_linesinvoiczCindexpay5;tablepaymentspaymentsCREATE TABLE "payments" ("id" integer primary key autoincrement not null, "payment_number" varchar not null, "supplier_id" integer, "payee_name" varchar, "amount" numeric not null, "payment_date" date not null, "payment_method" varchar, "account_id" integer not null, "status" varchar not null default 'completed', "reference" varchar, "recorded_by" integer, "notes" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("supplier_id") references "suppliers"("id") on delete set null, foreign key("account_id") references "accounts"("id") on delete restrict, foreign key("recorded_by") references "users"("id") on delete set null)q=indexreceipts_reference_indexreceiptsCREATE INDEX "receipts_reference_index" on "receipts" ("reference")G'indexreceipts_payment_method_indexreceiptsCREATE INDEX "receipts_payment_method_index" on "receipts" ("payment_method")                |  H(O#7indexassessments_assessment_type_indexassessmentsCREATE INDEX "assessments_assessment_type_index" on "assessments" ("assessment_type")s&##+tableassessmentsassessmentsCREATE TABLE "assessments" ("id" integer primary key autoincrement not null, "title" varchar not null, "subject_id" integer not null, "class_id" integer not null, "term_id" integer, "assessment_type" varchar not null, "max_score" numeric not null default '100', "weight" numeric, "assessment_date" date, "created_by" integer, "status" varchar not null default 'draft', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("subject_id") references "subjects"("id") on delete cascade, foreign key("class_id") references "classes"("id") on delete cascade, foreign key("term_id") references "terms"("id") on delete set null, foreign key("created_by") references "staff"("id") on delete set null) %I)+indexgrading_scales_is_active_indexgrading_scalesCREATE INDEX "grading_scales_is_active_index" on "grading_scales" ("is_active")$A)'indexgrading_scales_code_uniquegrading_scalesCREATE UNIQUE INDEX "grading_scales_code_unique" on "grading_scales" ("code")!#)){tablegrading_scalesgrading_scalesCREATE TABLE "grading_scales" ("id" integer primary key autoincrement not null, "name" varchar not null, "code" varchar not null, "min_score" numeric not null, "max_score" numeric not null, "grade_letter" varchar not null, "grade_point" varchar, "remarks" text, "is_active" tinyint(1) not null default '1', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime)x"?%indexbudget_lines_period_indexbudget_linesCREATE INDEX "budget_lines_period_index" on "budget_lines" ("period")%![%Uindexbudget_lines_budget_id_account_id_indexbudget_linesCREATE INDEX "budget_lines_budget_id_account_id_index" on "budget_lines" ("budget_id", "account_id")* %%tablebudget_linesbudget_linesCREATE TABLE "budget_lines" ("id" integer primary key autoincrement not null, "budget_id" integer not null, "account_id" integer not null, "amount" numeric not null, "period" varchar, "notes" text, "created_at" datetime, "updated_at" datetime, foreign key("budget_id") references "budgets"("id") on delete cascade, foreign key("account_id") references "accounts"("id") on delete restrict)d5indexbudgets_status_indexbudgetsCREATE INDEX "budgets_status_index" on "budgets" ("status")s?indexbudgets_fiscal_year_indexbudgetsCREATE INDEX "budgets_fiscal_year_index" on "budgets" ("fiscal_year"){tablebudgetsbudgetsCREATE TABLE "budgets" ("id" integer primary key autoincrement not null, "name" varchar not null, "fiscal_year" varchar not null, "academic_year_id" integer, "status" varchar not null default 'draft', "description" text, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("academic_year_id") references "academic_years"("id") on delete set null)Dk3uindexpayment_allocations_receipt_id_invoice_id_indexpayment_allocationsCREATE INDEX "payment_allocations_receipt_id_invoice_id_index" on "payment_allocations" ("receipt_id", "invoice_id")Dk3uindexpayment_allocations_payment_id_invoice_id_indexpayment_allocationsCREATE INDEX "payment_allocations_payment_id_invoice_id_index" on "payment_allocations" ("payment_id", "invoice_id")Y33Wtablepayment_allocationspayment_allocationsCREATE TABLE "payment_allocations" ("id" integer primary key autoincrement not null, "payment_id" integer, "receipt_id" integer, "invoice_id" integer, "expense_id" integer, "allocated_amount" numeric not null, "created_at" datetime, "updated_at" datetime, foreign key("payment_id") references "payments"("id") on delete cascade, foreign key("receipt_id") references "receipts"("id") on delete cascade, foreign key("invoice_id") references "invoices"("id") on delete set null, foreign key("expense_id") references "expenses"("id") on delete set null)                ??#d  < 5'O#7indexassessments_assessment_type_indexassessmentsCREATE INDEX "assessments_assessment_type_index" on "assessments" ("assessment_type")l-5/indexresults_compilations_student_id_term_id_subject_id_uniqueresults_compilationsCREATE UNIQUE INDEX "results_compilations_student_id_term_id_subject_id_unique" on "results_compilations" ("student_id", "term_id", "subject_id")o,55tableresults_compilationsresults_compilationsCREATE TABLE "results_compilations" ("id" integer primary key autoincrement not null, "student_id" integer not null, "class_id" integer not null, "term_id" integer not null, "subject_id" integer not null, "total_score" numeric, "average_score" numeric, "grade_letter" varchar, "class_position" integer, "status" varchar not null default 'draft', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("student_id") references "students"("id") on delete cascade, foreign key("class_id") references "classes"("id") on delete cascade, foreign key("term_id") references "terms"("id") on delete cascade, foreign key("subject_id") references "subjects"("id") on delete cascade)N+o/ indexgradebook_entries_assessment_id_student_id_uniquegradebook_entriesCREATE UNIQUE INDEX "gradebook_entries_assessment_id_student_id_unique" on "gradebook_entries" ("assessment_id", "student_id")!*//otablegradebook_entriesgradebook_entriesCREATE TABLE "gradebook_entries" ("id" integer primary key autoincrement not null, "assessment_id" integer not null, "student_id" integer not null, "score" numeric, "grade_letter" varchar, "remarks" text, "recorded_by" integer, "created_at" datetime, "updated_at" datetime, foreign key("assessment_id") references "assessments"("id") on delete cascade, foreign key("student_id") references "students"("id") on delete cascade, foreign key("recorded_by") references "staff"("id") on delete set null)t)=#indexassessments_status_indexassessmentsCREATE INDEX "assessments_status_index" on "assessments" ("status")(O#7indexassessments_assessment_date_indexassessmentsCREATE INDEX "assessments_assessment_date_index" on "assessments" ("assessment_date") 5E'#indexannouncements_audience_indexannouncementsCREATE INDEX "announcements_audience_index" on "announcements" ("audience")N2''YtableannouncementsannouncementsCREATE TABLE "announcements" ("id" integer primary key autoincrement not null, "title" varchar not null, "body" text not null, "audience" varchar not null default 'all', "published_at" datetime, "expires_at" datetime, "created_by" integer, "status" varchar not null default 'draft', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("created_by") references "users"("id") on delete set null)x1?%indexreport_cards_status_indexreport_cardsCREATE INDEX "report_cards_status_index" on "report_cards" ("status")(0Y%]indexreport_cards_student_id_term_id_uniquereport_cardsCREATE UNIQUE INDEX "report_cards_student_id_term_id_unique" on "report_cards" ("student_id", "term_id")M'3indexannouncements_published_at_indexannouncementsCREATE INDEX "announcements_published_at_index" on "announcements" ("published_at"))/%%qtablereport_cardsreport_cardsCREATE TABLE "report_cards" ("id" integer primary key autoincrement not null, "student_id" integer not null, "class_id" integer not null, "term_id" integer not null, "overall_average" numeric, "overall_position" integer, "class_teacher_remarks" text, "head_teacher_remarks" text, "status" varchar not null default 'draft', "published_at" datetime, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("student_id") references "students"("id") on delete cascade, foreign key("class_id") references "classes"("id") on delete cascade, foreign key("term_id") references "terms"("id") on delete cascade).O57indexresults_compilations_status_indexresults_compilationsCREATE INDEX "results_compilations_status_index" on "results_compilations" ("status")               n'z q  t;' H`=%indexhostel_rooms_block_indexhostel_roomsCREATE INDEX "hostel_rooms_block_index" on "hostel_rooms" ("block") H7indextnu?%indexhostel_rooms_status_indexhostel_roomsCREATE INDEX "hostel_rooms_status_index" on~B%%=tablehostel_roomshostel_roomsCREATE TABLE "hostel_rooms" ("id" integer primary key autoincrement not null, "name" varchar not null, "code" varchar not null, "block" varchar, "capacity" integer not null default '1', "fee_amount" numeric not null default '0', "status" varchar not null default 'available', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime)4M'3indexannouncements_published_at_indexannouncementsCREATE INDEX "announcements_published_at_index" on "announcements" ("published_at")AQ7;indextransport_assignments_status_indextransport_assignmentsCREATE INDEX "transport_assignments_status_index" on "transport_assignments" ("status")d@7indextransport_assignments_transport_route_id_student_id_indextransport_assignmentsCREATE INDEX "transport_assignments_transport_route_id_student_id_index" on "transport_assignments" ("transport_route_id", "student_id"),?77utabletransport_assignmentstransport_assignmentsCREATE TABLE "transport_assignments" ("id" integer primary key autoincrement not null, "transport_route_id" integer not null, "student_id" integer not null, "assigned_from" date, "assigned_until" date, "pickup_point" varchar, "status" varchar not null default 'active', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("transport_route_id") references "transport_routes"("id") on delete cascade, foreign key("student_id") references "students"("id") on delete cascade)>G-'indextransport_routes_status_indextransport_routesCREATE INDEX "transport_routes_status_index" on "transport_routes" ("status") =E-/indextransport_routes_code_uniquetransport_routesCREATE UNIQUE INDEX "transport_routes_code_unique" on "transport_routes" ("code")b<--utabletransport_routestransport_routesCREATE TABLE "transport_routes" ("id" integer primary key autoincrement not null, "name" varchar not null, "code" varchar not null, "description" text, "fare_amount" numeric not null default '0', "status" varchar not null default 'active', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime);M13indexmessage_recipients_read_at_indexmessage_recipientsCREATE INDEX "message_recipients_read_at_index" on "message_recipients" ("read_at")O:o1 indexmessage_recipients_message_id_recipient_id_uniquemessage_recipientsCREATE UNIQUE INDEX "message_recipients_message_id_recipient_id_unique" on "message_recipients" ("message_id", "recipient_id")0911 tablemessage_recipientsmessage_recipientsCREATE TABLE "message_recipients" ("id" integer primary key autoincrement not null, "message_id" integer not null, "recipient_id" integer not null, "read_at" datetime, "archived_at" datetime, "created_at" datetime, "updated_at" datetime, foreign key("message_id") references "messages"("id") on delete cascade, foreign key("recipient_id") references "users"("id") on delete cascade)n8;indexmessages_priority_indexmessagesCREATE INDEX "messages_priority_index" on "messages" ("priority")k79 indexmessages_sent_at_indexmessagesCREATE INDEX "messages_sent_at_index" on "messages" ("sent_at")z6EtablemessagesmessagesCREATE TABLE "messages" ("id" integer primary key autoincrement not null, "sender_id" integer not null, "subject" varchar, "body" text not null, "sent_at" datetime, "priority" varchar not null default 'normal', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("sender_id") references "users"("id") on delete cascade)|5A'indexannouncements_status_indexannouncementsCREATE INDEX "announcements_status_index" on "announcements" ("status") M'3i3E'#indexannouncements_audience_indexannouncementsCREATE INDEX "announcements_audience_index" on "announcements" ("audience")                 ^k 7 a ^Uc 0A+'indexinventory_items_sku_uniqueinventory_itemsCREATE UNIQUE INDEX "inventory_items_sku_unique" on "inventory_items" ("sku")~SA+indexinventory_items_name_indexinventory_itemsCREATE INDEX "inventory_items_name_index" on "inventory_items" ("name")xR++%tablein;Qe'uindexpayroll_items_payroll_run_id_staff_id_uniquepayroll_itemsCREATE UNIQUE INDEX "payroll_items_payroll_run_id_staff_id_unique" on "payroll_items" ("payroll_run_id", "staff_id")P''Etablepayroll_itemspayroll_itemsCREATE TABLE "payroll_items" ("id" integer primary key autoincrement not null, "payroll_run_id" integer not null, "staff_id" integer not null, "gross_pay" numeric not null default '0', "deductions" numeric not null default '0', "net_pay" numeric not null default '0', "notes" text, "created_at" datetime, "updated_at" datetime, foreign key("payroll_run_id") references "payroll_runs"("id") on delete cascade, foreign key("staff_id") references "staff"("id") on delete cascade)xE?%indexhostel_rooms_status_indexhostel_roomsCREATE INDEX "hostel_rooms_status_index" on "hostel_rooms" ("status")uD=%indexhostel_rooms_block_indexhostel_roomsCREATE INDEX "hostel_rooms_block_index" on "hostel_rooms" ("block"){C=%indexhostel_rooms_code_uniquehostel_roomsCREATE UNIQUE INDEX "hostel_rooms_code_unique" on "hostel_rooms" ("code")y%%=tablehostel_roomshostel_roomsCREATE TABLE "hostel_rooms" ("id" integer primary key autoincrement not null, "xO?%indexpayroll_runs_status_indexpayroll_runsCREATE INDEX "payroll_runs_status_index" on "payroll_runs" ("status") NG%3indexpayroll_runs_reference_uniquepayroll_runsCREATE UNIQUE INDEX "payroll_runs_reference_unique" on "payroll_runs" ("reference")4M%%)tablepayroll_runspayroll_runsCREATE TABLE "payroll_runs" ("id" integer primary key autoincrement not null, "reference" varchar not null, "period_start" date not null, "period_end" date not null, "pay_date" date, "total_gross" numeric not null default '0', "total_deductions" numeric not null default '0', "total_net" numeric not null default '0', "status" varchar not null default 'draft', "processed_by" integer, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("processed_by") references "users"("id") on delete set null)_L3indexevents_status_indexeventsCREATE INDEX "events_status_index" on "events" ("status")fK7indexevents_audience_indexeventsCREATE INDEX "events_audience_index" on "events" ("audience")iJ9 indexevents_starts_at_indexeventsCREATE INDEX "events_starts_at_index" on "events" ("starts_at")RI}tableeventseventsCREATE TABLE "events" ("id" integer primary key autoincrement not null, "title" varchar not null, "description" text, "starts_at" datetime not null, "ends_at" datetime, "location" varchar, "audience" varchar not null default 'all', "created_by" integer, "status" varchar not null default 'scheduled', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("created_by") references "users"("id") on delete set null)HK1/indexhostel_assignments_status_indexhostel_assignmentsCREATE INDEX "hostel_assignments_status_index" on "hostel_assignments" ("status")LGq1indexhostel_assignments_hostel_room_id_student_id_indexhostel_assignmentsCREATE INDEX "hostel_assignments_hostel_room_id_student_id_index" on "hostel_assignments" ("hostel_room_id", "student_id")uF11tablehostel_assignmentshostel_assignmentsCREATE TABLE "hostel_assignments" ("id" integer primary key autoincrement not null, "hostel_room_id" integer not null, "student_id" integer not null, "check_in" date, "check_out" date, "status" varchar not null default 'active', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, foreign key("hostel_room_id") references "hostel_rooms"("id") on delete cascade, foreign key("student_id") references "students"("id") on delete cascade)                0R 4 +xRtlRP 9 &^S9Kindexpersonal_access_tokens_token_uniquepersonal_access_tokensCREATE UNIQUE INDEX "personal_access_tokens_token_unique" on "personal_access_tokens" ("token")t\99tablepersonal_access_tokenspersonal_access_tokensCREATE TABLE "personal_access_tokens" ("id" integer primary key autoincrement not null, "tokenable_type" varchar not null, "tokenable_id" integer not null, "name" text not null, "token" varchar not null, "abilities" text, "last_used_at" datetime, "expires_at" datetime, "created_at" datetime, "updated_at" datetime)Z}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, "remember_token" varchar, "created_at" datetime, "updated_at" datetime, "staff_id" integer, "phone" varchar, "avatar" varchar, foreign key("staff_id") references "staff"("id") on delete set null)a[1indexusers_email_uniqueusersCREATE UNIQUE INDEX "users_email_unique" on "users" ("email")b]}9indexpersonal_access_tokens_tokenable_type_tokenable_id_indexpersonal_access_tokensCREATE INDEX "personal_access_tokens_tokenable_type_tokenable_id_index" on "personal_access_tokens" ("tokenable_type", "tokenable_id")mY9! indexaudit_logs_event_indexaudit_logsCREATE INDEX "audit_logs_event_index" on "audit_logs" ("event")2Xe!iindexaudit_logs_auditable_type_auditable_id_indexaudit_logsCREATE INDEX "audit_logs_auditable_type_auditable_id_index" on "audit_logs" ("auditable_type", "auditable_id")W!!{tableaudit_logsaudit_logsCREATE TABLE "audit_logs" ("id" integer primary key autoincrement not null, "user_id" integer, "event" varchar not null, "auditable_type" varchar, "auditable_id" integer, "old_values" text, "new_values" text, "ip_address" varchar, "user_agent" text, "created_at" datetime not null default CURRENT_TIMESTAMP, foreign key("user_id") references "users"("id") on delete set null)VE+#indexinventory_items_status_indexinventory_itemsCREATE INDEX "inventory_items_status_index" on "inventory_items" ("status") UI++indexinventory_items_category_indexinventory_itemsCREATE INDEX "inventory_items_category_index" on "inventory_items" ("category")TA+'indexinventory_items_sku_uniqueinventory_itemsCREATE UNIQUE INDEX "inventory_items_sku_unique" on "inventory_items" ("sku")~SA+indexinventory_items_name_indexinventory_itemsCREATE INDEX "inventory_items_name_index" on "inventory_items" ("name")xR++%tableinventory_itemsinventory_itemsCREATE TABLE "inventory_items" ("id" integer primary key autoincrement not null, "sku" varchar not null, "name" varchar not null, "category" varchar, "unit" varchar not null default 'piece', "quantity_on_hand" integer not null default '0', "reorder_level" integer not null default '0', "unit_cost" numeric not null default '0', "location" varchar, "status" varchar not null default 'active', "created_at" datetime, "updated_at" datetime, "deleted_at" datetime)e'uindexpayroll_items_payroll_run_id_staff_id_uniquepayroll_itemsCREATE UNIQUE INDEX "payroll_items_payroll_run_id_staff_id_unique" on "payroll_itemhb7indexguardians_phone_indexguardiansUCREATE INDEX "guardians_phone_index" on "guardians" ("phone")ha7indexguardians_email_indexguardiansTCREATE INDEX "guardians_email_index" on "guardians" ("email")(`tableguardiansguardiansCREATE TABLE "guardians" ("id" integer primary key autoincrement not null, "first_name" varchar not null, "last_name" varchar not null, "email" varchar, "phone" varchar, "occupation" varchar, "address" text, "relationship_type" varchar, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "user_id" integer, foreign key("user_id") references "users"("id") on delete set null),_[9Oindexpersonal_access_tokens_expires_at_indexpersonal_access_tokensCREATE INDEX "personal_access_tokens_expires_at_index" on "personal_access_tokens" ("expires_at")     `` !/333Osei Adminosei@southend.edu2026-06-16 02:17:49$2y$12$NeAmTGlkWwiW/gAcUW5Ypu0j4Gn6xuPQcluD/urxu3D4i7BaWK/IK2026-06-16 02:17:492026-06-16 02:17:49