Table: password_resets

Password reset tokens (single-use).

Purpose

Describe why this table exists and what it stores.

Relationships

List foreign keys and key joins (if any).

Columns

Column	Definition
`id`	`int NOT NULL`
`email`	`varchar(100) NOT NULL`
`token`	`char(64) NOT NULL`
`expires`	`datetime NOT NULL`
`attempt_count`	`int NOT NULL DEFAULT '0'`
`last_attempt`	`datetime DEFAULT NULL`

Indexes

List primary key and secondary indexes (if any).

Constraints

List foreign keys and other constraints (if any).

Operational notes / invariants

Rules such as “no deletes”, “append-only”, “unique per church/FY”, etc.

DDL

CREATE TABLE `password_resets` (
  `id` int NOT NULL,
  `email` varchar(100) NOT NULL,
  `token` char(64) NOT NULL,
  `expires` datetime NOT NULL,
  `attempt_count` int NOT NULL DEFAULT '0',
  `last_attempt` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;