fw_clients
Introduction:
This table outlines the detailed structure of the Clients table, which stores information about different clients, including their names, logos, and invitation settings.
| Name | Type | Comments | Example |
|---|---|---|---|
| id | Primary | Unique ID of the client (auto-incremented). | 1 |
| clientname | varchar(200) | Name of the client. | “People Pulse” |
| type | varchar(200) | Name of the vertical the client belongs to. | “KTO” |
| stopinvitations | int | 0 = Send invitations, 1 = Stop sending invitations. | 0 |
| clientlogo | blob | Logo of the client with size 120×32 pixels. | [BLOB - 12.5 KiB] |
| clientleftlogo | blob | Logo of the client with size 165×60 pixels. | |
| invitationheader | blob | If clientlogo and invitationheader logos are different, upload the invitation logo here; otherwise, the invitation logo will be fetched from clientlogo. | |
| appclientlogo | blob | Logo of the client with size 299×126 pixels for the app. | |
| status | int | Status of the client (1=active,0=inactive). |
fw_clients.txt · Last modified: 2025/03/04 05:48 by gloria
