Partners

partners

• Schema: public
• PK: partner_id (varchar)

Columns

Column	Type	Nullable	Default	Notes
partner_id	varchar	NO		PK
partner_name	varchar	NO
is_active	bool	YES	true
sso_enabled	bool	YES	false
auth0_connection_name	varchar	YES		Auth0 enterprise connection
auth0_connection_id	varchar	YES
idp_domain_aliases	text[]	YES		Email domains for SSO matching
idp_sign_in_url	text	YES		SAML/OIDC sign-in URL
encrypted_idp_signing_cert	text	YES		Encrypted IDP certificate
branding	jsonb	YES	{}	Logo, colors, etc.
created_time	timestamp	YES	now()
created_by	int4	YES
options	jsonb	YES	{}
hashed_partner_api_key	varchar	YES		Hashed key for partner API
auth0_client_id	varchar	YES		Dedicated Auth0 application

Key indexes

• partners_pkey on (partner_id)

Notes

• White-label / reseller partner configuration.
• SSO is configured via Auth0 enterprise connections; idp_domain_aliases controls automatic routing.

---