@existingProcessRnD.md we did an analysis of the existing process
  which is in this file, as the current structure is very complex we
  want to rewamp the whole architeture of marks add process,

  So I want you to create a new md file for the new plan 

  `
  First we will have unified schema for all classes and boards which will look like

{

Base info,
Timestamp,
sumbject_marks:{
[id]:{
name,
subtitles:{
[subtitleid]:{
name,
max_marks,
marks

}

}

}

}

}
`
For the calculation  ad peridiocs

we  store this fields as specials rows in the subtitle table for each subject 


peridioc marks is already stored as a row from 2024-25 session, but it was handled with complex logic , we have table_field_name which value like "pmt_[subid]" based on this we get the marks of the subtitle from premidterm for half yearly and post mid term for final 

will make the process more scalable 


will add some new columns to identify this fields 

calclutionOn(event -- enum (beforeMarksAdd,afterMarksAdd)) -- like periodic marks need to calutated before as they are shown to the teacher


calFunction -Varchar that will have name of the precreated function (
  
(
 this function will be created by admin ,
 the funtion will have access to some variables 
    - all fields of the row
    - variables to get the marks of of other subtitle of the subject like (_marks, m2_marks)
    - variables to get the marks of other subtitle of of the other sub

the function will always gonna adjust the 
)

hidden (booleen)



will create two new tables

INSERT INTO master_subject (name, slug) VALUES
('English','english'),
('Punjabi','punjabi'),
('Hindi','hindi'),
('Mathematics','mathematics'),
('EVS','evs'),
('Science','science'),


and 

Master Subtitle table
INSERT INTO master_sub_title (name, slug) VALUES
('Theory','theory'),
('Practical','practical'),
('Internal Assessment','internal_assessment'),
('Multiple Assessment','multiple_assessment'),
('Subject Enrichment','subject_enrichment'),
('Portfolio / Notebook','portfolio'),


this tables will mapped to existing subject and subtitle to make varianle extraction easy

we also need to create a table for  result types
which will have {
id,
name, 
slug,
class_from,
class_to,
board
}

There is one more process taht we need to think of in this plan ad that is marks moderation you can check the logic in the marks moderation class we need make this logic also sclable