fw_branches
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: 110×100 pixels). |
| 8 | invitationheader | BLOB | Header image for invitations (Recommended: 120×32 pixels). |
fw_branches.txt · Last modified: 2025/03/11 11:49 by gloria