DOCDESK

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¶

group_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)"