Users

users

• Schema: public
• PK: user_id (bigint, serial)

Columns

Column	Type	Nullable	Default	Notes
user_id	bigint	NO	serial	PK
firstname	varchar	YES
lastname	varchar	YES
email	varchar	NO
auth0_id	varchar	NO		Auth0 subject identifier
created_time	timestamp	YES	now()
country	text	YES
phone_number	text	YES
metadata	jsonb	YES	{"requested_access": []}	Arbitrary user metadata
company_credits	float8	YES	0.0
cash_credits	float8	YES	0.0
api_key	varchar	YES		Personal API key
options	jsonb	NO	{}

Key indexes

• users_pk on (user_id)

Notes

• One row per authenticated user across all workspaces.
• Credits are tracked at both user and workspace level.

---