This is an old revision of the document!

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 or industry the client belongs to.	“KTO”
stopinvitations	int	Defines whether invitations should be stopped. 0 = Send invitations, 1 = Stop sending.	0
clientlogo	blob	Logo of the client (size: 120×32 pixels).	[BLOB - 12.5 KiB]
clientleftlogo	blob	Left-side logo of the client (size: 165×60 pixels).	[Binary Data]
invitationheader	blob	If different from clientlogo, upload a specific invitation logo here; otherwise, it defaults to clientlogo.	[Binary Data]
appclientlogo	blob	Logo of the client for the app (size: 299×126 pixels).	[Binary Data]
status	int	Status of the client. Typically used for active/inactive control.	1