admin_logs

Access and action events for administrators. Append-only.

• ETL strategy: append
• PK: id

Columns

Column	Type	Description
id	BIGINT	PK.
id_tenant	BIGINT	FK → tenants.id.
id_admin	BIGINT	FK → admins.id.
reference	TEXT	Event type. Enum — see below.
ip	TEXT
user_agent	TEXT
created_at	TIMESTAMPTZ

Enum · reference

Same value set as user_logs.reference.

Value	Meaning
first_access	First-ever access on the platform.
session_active	Active-session heartbeat (logged in).
platform_consent	Platform terms accepted.
product_consent	Product terms accepted.
certificate	Certificate generated or downloaded.
password_reset	"Forgot password" — request or completion.

Unmapped values (rare) are preserved unchanged.