Project

General

Profile

Task #136

Updated by Varsha N 10 days ago

Task: Implement Specialization Parameters  
 Task Objective: 
 Create a configuration module that allows defining custom parameters per specialization, so that each doctor specialization can have its own dynamic fields in the consultation page. 

 Scope 
 Admin should be able to: 
 Add parameters for a selected specialization 
 Define input type 
 Save and manage them 

 specialization_parameter_groups Table: specialization_parameters 
 ------------------------------- Required Fields 
 group_id id (PK) 
 hospital_id (FK) 
 specialization_id (FK → specialization_master.id) 
 group_name VARCHAR(150) 
 is_active BOOLEAN DEFAULT TRUE 
 created_at DATETIME 
 updated_at DATETIME 

 specialization_parameters 
 —————————————- 
 parameters_id (PK) 
 hospital_id (FK) 
 specialization_id (FK→specialization_master.id) 
 group_id (FK) 
 parameter_name (varchar) 
 parameter_key (varchar, unique per specialization) 
 parameter_type (ENUM: textbox, number, textarea, checkbox, radio, select) 
 parameter_values (JSON, nullable – required only for select/radio/checkbox) 
 is_active (boolean) 
 created_at (datetime) 
 updated_at (datetime) 

 Features to Implement: 
 Admin selects specialization 
 Add a parameter 
 Add new parameter 
 Define input type 
 Add options (if select/radio/checkbox) 
 Edit parameter 
 -Activate / Deactivate parameter 
 Load parameters specialization-wise 

 Validations 
 Parameter name required 
 Parameter key unique per specialization 
 parameter_values required only for select/radio/checkbox 
 Hospital-level filtering enforced 

 "FOR REFERANCE:  
 specialization_master: 

 specialization_id (PK) 
 hospital_id (FK → hospital_reg_table.id) 
 name (varchar) 
 description (varchar, optional) 
 is_active (boolean) 
 created_at (datetime) 
 updated_at (datetime)" 


Back