Database

Manage DB

Browse collections and tables, and watch the CQRS timing pipeline.

← Overview•Access & StaffingBetter Auth Login

Users`users`

💡

Operational Purpose & Edge Invariants

A user is a way to sign in (password, email code, passkey, Google). The human behind it is the linked people record. `role` is the platform-wide role from the Better Auth admin plugin ('admin' for ChekkPoint staff); organization and event roles live elsewhere.

Relational Connections (2)

↓ Has ManyuserId

people →

Person record claimed by this login (at most one).

↓ Has ManyuserId

organizationMembers →

Organizations this user belongs to.

Table Columns & Types (11)

users

Column	PostgreSQL Type	Constraints	Default	Documentation
id	uuid	NOT NULLPK	gen_random_uuid()	Unique user identifier.
name	text	NOT NULL	—	Display name.
email	text	NOT NULLUnique	—	Sign-in email.
emailVerified	boolean	NOT NULL	false	True once the user proved mailbox ownership; gates claiming a person record.
image	text	nullable	—	Avatar URL.
role	text	nullable	—	Platform role from the admin plugin ('user' or 'admin').
banned	boolean	nullable	false	Banned by a platform admin.
banReason	text	nullable	—	Reason given for the ban.
banExpires	timestamp with time zone	nullable	—	When the ban lifts.
createdAt	timestamp with time zone	NOT NULL	now()	Creation timestamp.
updatedAt	timestamp with time zone	NOT NULL	now()	Last modification timestamp.

Database Indexes (1)