fw_branches
This is an old revision of the document!
Table of Contents
Introduction
This table stores details about various branches associated with clients. A single client can have multiple branches. The table includes branch-specific information such as name, code, location, website, and branding elements like logos and invitation headers.
Table Structure
| Name | Type | Comments |
|---|---|---|
| id | Primary | Unique ID of the branch (auto-incremented). |
| clientid | Index | ID of the client this branch belongs to. A client can have multiple branches. |
| branchname | varchar(100) | Name of the branch. |
| branchcode | varchar(100) | Unique code assigned to the branch. |
| location | varchar(100) | Geographical location or identifier of the branch. |
| website | varchar(100) | Website URL of the branch. |
| questionnairelogo | blob | Logo used in questionnaires (recommended size: 110×100 pixels). |
| invitationheader | blob | Header image for invitations (recommended size: 120×32 pixels). |
Example Data
A single client can have multiple branches. Below is an example dataset showcasing different branches of a client.
| id | clientid | branchname | branchcode (Unique) | location | website | questionnairelogo | invitationheader |
|---|---|---|---|---|---|---|---|
| 5 | 1 | Swietelsky | 3 | ||||
| 3 | 1 | Zevenaar-Didam | 1 | ||||
| 4 | 1 | Groningen Spoorzone | 2 | ||||
| 6 | 1 | EdesPoort | 4 | ||||
| 7 | 1 | Leeuwarden | 4554 | ||||
| 8 | 1 | Maaslijn | 4848 |
fw_branches.1741068224.txt.gz · Last modified: 2025/03/04 06:03 by gloria