Performitor

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
==== Purpose & Overview ====  
The **fw_branches** table manages branch-related details for each client.  
Since a **client** can have multiple **branches**, this table ensures:  
  * Organized tracking of **branch identity** (name, unique code).  
  * Storage of **location & website** details (if applicable).  
  * **Branding support** through logos & invitation headers.  



==== Table Structure ====  

^Sr. No.^ **Column Name**        ^ **Data Type**    ^ **Description**                                                                ^  
|1| **id**                | Primary Key    | Unique identifier for each branch (auto-incremented).                          |  
|2| **clientid**          | Foreign Key    | References the **fw_clients** table (one client → many branches).              |  
|3| **branchname**        | varchar(100)   | Name of the branch.                                                            |  
|4| **branchcode**        | varchar(100)   | Unique identifier/code assigned to the branch (**must be unique**).            |  
|5| **location**          | varchar(100)   | Geographical location or address of the branch.                               |  
|6| **website**           | varchar(100)   | Website URL of the branch (if applicable).                                    |  
|7| **questionnairelogo** | BLOB           | Logo used in questionnaires (**Recommended: 110x100 pixels**).                 |  
|8| **invitationheader**  | BLOB           | Header image for invitations (**Recommended: 120x32 pixels**).                 |