Differences

This shows you the differences between two versions of the page.

--- fw_branches [2025/03/06 04:55] – gloria
+++ fw_branches [2025/03/11 11:49] (current) – gloria
@@ Line 1: / Line 1: @@
-==== Introduction ====
+==== Purpose & Overview ====
-This table stores details about various branches associated with clients.
+The **fw_branches** table manages branch-related details for each client.
-Each **client** can have multiple **branches**, and this table captures essential branch-specific information such as:
+Since a **client** can have multiple **branches**, this table ensures:
-  * Branch **name** and **unique code**
+  * Organized tracking of **branch identity** (name, unique code).
-  * **Geographical location** and **website**
+  * Storage of **location & website** details (if applicable).
-  * **Branding elements** (logos, invitation headers)
+  * **Branding support** through logos & invitation headers.
-This structure ensures efficient data organization, making it easy to manage multiple branches under a single client.
-----
 ==== Table Structure ====
-^ **Column Name**          ^ **Data Type**    ^ **Description**                                                                ^
+^Sr. No.^ **Column Name**        ^ **Data Type**    ^ **Description**                                                                ^
-| **id**                 | Primary Key    | Unique identifier for each branch (auto-incremented).                          |
+|1| **id**                | Primary Key    | Unique identifier for each branch (auto-incremented).                          |
-| **clientid**           | Foreign Key    | References the **client** this branch belongs to (one client → many branches). |
+|2| **clientid**          | Foreign Key    | References the **fw_clients** table (one client → many branches).              |
-| **branchname**         | varchar(100)   | Name of the branch.                                                            |
+|3| **branchname**        | varchar(100)   | Name of the branch.                                                            |
-| **branchcode**         | varchar(100)   | Unique identifier/code assigned to the branch.                                 |
+|4| **branchcode**        | varchar(100)   | Unique identifier/code assigned to the branch (**must be unique**).            |
-| **location**           | varchar(100)   | Geographical location or address of the branch.                               |
+|5| **location**          | varchar(100)   | Geographical location or address of the branch.                               |
-| **website**            | varchar(100)   | Website URL of the branch (if applicable).                                    |
+|6| **website**           | varchar(100)   | Website URL of the branch (if applicable).                                    |
-| **questionnairelogo**  | BLOB           | Logo used in questionnaires (recommended size: **110x100 pixels**).            |
+|7| **questionnairelogo** | BLOB           | Logo used in questionnaires (**Recommended: 110x100 pixels**).                 |
-| **invitationheader**   | BLOB           | Header image for invitations (**recommended size: 120x32 pixels**).            |
+|8| **invitationheader**  | BLOB           | Header image for invitations (**Recommended: 120x32 pixels**).                 |
-----
-==== Example Data ====
-Below is an example dataset showcasing different branches under a single client:
-^ **id** ^ **clientid** ^ **branchname**           ^ **branchcode** (Unique) ^ **location** ^ **website** ^
-| 5      | 1           | Swietelsky                | 3                        | [Not Provided] | [Not Provided] |
-| 3      | 1           | Zevenaar-Didam            | 1                        | [Not Provided] | [Not Provided] |
-| 4      | 1           | Groningen Spoorzone       | 2                        | [Not Provided] | [Not Provided] |
-| 6      | 1           | EdesPoort                 | 4                        | [Not Provided] | [Not Provided] |
-| 7      | 1           | Leeuwarden                | 4554                     | [Not Provided] | [Not Provided] |
-| 8      | 1           | Maaslijn                  | 4848                     | [Not Provided] | [Not Provided] |
-----
-**Notes:**
-- Each **client** can have **multiple branches**.
-- Ensure **branchcode** remains **unique** for proper identification.
-- If a **website or location** is unavailable, it can be left **null**.