The fw_branches table manages branch-related details for each client. Since a client can have multiple branches, this table ensures:
| 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: 110×100 pixels). |
| 8 | invitationheader | BLOB | Header image for invitations (Recommended: 120×32 pixels). |