Phase 1: enquiries, registrations, fees, students, faculties, courses, batches, branches, staff Phase 2: fees, students, faculties, courses, batches, branches, staff Steps: Operations: GET_DATA, ADD, FETCH, UPDATE, DELETE Menu Items: Institute Management - 1. Dashboard 2. Courses 3. Enquiries 4. Faculties 5. Students 6. Fees 7. Administrators 8. Settings Step 1: Capabilities - 1. wlim_dashboard 2. wlim_courses 3. wlim_faculties 4. wlim_enquiries 5. wlim_students 6. wlim_fees 7. wlim_administrators 8. wlim_settings Step 2: Administrators 1. Administrators -> Add New Admin - select capabilities for pages (ADD) - edit capabilities for admins (FETCH AND UPDATE) - list all admins with capabilities (GET_DATA) Step 3: Create all Menus with capabilities and dedicated controllers Step 4: Courses -> Create courses table - GET_DATA, ADD, FETCH, UPDATE, DELETE (deleted_date) id (unique, int(11)) course_code (unique, varchar(255)) course_name (varchar(255)) course_detail (text) duration_days (int(11)) fees (decimal(12,2)) is_active (tinyint(1)) added_by (int(11), ON DELETE SET NULL) created_at (timestamp, DEFAULT CURRENT_TIMESTAMP) updated_at (timestamp, DEFAULT CURRENT_TIMESTAMP) deleted_at (timestamp, DEFAULT NULL) --- Step 4: Courses -> Create subjects table - add multiple subjects for a course and save them to subjects table with course_id --- Step 4: Courses -> Add batches for this course table - add multiple batches for a course and save them to batches table with course_id Step 5: Enquiries -> Create enquiries table - GET_DATA, ADD, FETCH, UPDATE, DELETE (deleted_date) id (unique, int(11)) enquiry_id (unique, varchar(255)) - auto generated course_id (int(11)) name (varchar(255)) phone (varchar(255)) email (varchar(255)) message (varchar(255)) added_by (int(11), ON DELETE SET NULL) created_at (timestamp, DEFAULT CURRENT_TIMESTAMP) updated_at (timestamp, DEFAULT CURRENT_TIMESTAMP) deleted_at (timestamp, DEFAULT NULL) Step 6: Enquiries -> Shortcode of enquiry form - ADD --- Step 8: Faculties -> Create faculties table - GET_DATA, ADD, FETCH, UPDATE, DELETE (deleted_date) id (unique, int(11)) faculty_code (unique, varchar(255)) name (varchar(255)) address (text) phone (varchar(255)) email (varchar(255)) detail (text) is_active (tinyint(1)) added_by (int(11), ON DELETE SET NULL) created_at (timestamp, DEFAULT CURRENT_TIMESTAMP) updated_at (timestamp, DEFAULT CURRENT_TIMESTAMP) deleted_at (timestamp, DEFAULT NULL) Step 9: Faculties -> Create faculty_subject table Assign subjects to faculties Step 9: Students -> Add New Registration either from list of enquiries or directly add fees_paid for a course till now add course_completed date default to null assign batch from listing enrollment_id (unique) father_mobile mother_mobile status installments table installment_student table 1. Add New Staff 2. Permissions 2. course_student students table - courses, name, phone, email, status, is_active, created_at, updated_at