Branch Management

CREATE TABLE branches (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    address VARCHAR(255),
    icon VARCHAR(50),
    status ENUM('active', 'inactive') DEFAULT 'active',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE users (
    -- ...
    branch_id INT,
    FOREIGN KEY (branch_id) REFERENCES branches(id) ON DELETE SET NULL
);

CREATE TABLE doctor_branches (
    doctor_id INT NOT NULL,
    branch_id INT NOT NULL,
    PRIMARY KEY (doctor_id, branch_id),
    FOREIGN KEY (doctor_id) REFERENCES doctors(id) ON DELETE CASCADE,
    FOREIGN KEY (branch_id) REFERENCES branches(id) ON DELETE CASCADE
);

CREATE TABLE patients (
    -- ...
    branch_id INT,
    FOREIGN KEY (branch_id) REFERENCES branches(id) ON DELETE SET NULL
);

CREATE TABLE appointments (
    -- ...
    branch_id INT NOT NULL,
    FOREIGN KEY (branch_id) REFERENCES branches(id) ON DELETE CASCADE
);

POST /api/branches
Content-Type: application/json

{
  "name": "Sucursal Norte",
  "address": "Av. Recoleta 456, Santiago",
  "icon": "🏢"
}

CALL sp_create_branch(name, address, icon);

{
  "success": true,
  "id": 4
}

PATCH /api/branches
Content-Type: application/json

{
  "id": 2,
  "name": "Sucursal Norte - Renovada",
  "address": "Av. Recoleta 456, Piso 2, Santiago",
  "icon": "🏥",
  "status": "active"
}

CALL sp_update_branch(id, name, address, icon, status);

DELETE /api/branches?id=3

CALL sp_delete_branch(id);

{
  id: user.id,
  name: user.name,
  branch: user.branch_name || "Todas las sucursales",
  // ...
}

<SelectInput
  id="branch-select"
  icon="🏢"
  label="Sucursal"
  bind:value={formData.branch_id}
  options={[
    { value: "", label: "Sin sucursal" },
    ...branches.map(b => ({ value: b.id, label: b.name }))
  ]}
/>

CALL sp_list_branches(include_inactive);

CALL sp_list_branches(true);  -- Include inactive branches
CALL sp_list_branches(false); -- Active branches only

CALL sp_create_branch(name, address, icon);

CALL sp_update_branch(id, name, address, icon, status);

CALL sp_delete_branch(id);

if (!(await checkPermission(locals, "MANAGE_BRANCHES"))) {
  return forbiddenResponse();
}

INSERT INTO doctor_branches (doctor_id, branch_id) VALUES 
  (1, 1),  -- Central
  (1, 2);  -- Norte

UPDATE patients 
SET branch_id = 3 
WHERE id = 260001;

UPDATE branches 
SET status = 'inactive' 
WHERE id = 2;