export const attempts = pgTable(
	"attempts",
	{
		id: uuid("id").defaultRandom().primaryKey(),
		userId: text("user_id")
			.notNull()
			.references(() => users.id, { onDelete: "cascade" }),
		questionId: text("question_id")
			.notNull()
			.references(() => questions.id),
		/** Question version the answer was graded against. */
		questionVersion: integer("question_version").notNull(),
		answer: text("answer").notNull(),
		answerMode: text("answer_mode").$type<AnswerMode>().notNull(),
		status: text("status").$type<"pending" | "graded" | "failed">().notNull(),
		score: integer("score"),
		feedback: jsonb("feedback").$type<Feedback>(),
		gradingModel: text("grading_model"),
		/** True when the grading was billed to the user's own API key. */
		usedOwnKey: boolean("used_own_key").notNull().default(false),
		inputTokens: integer("input_tokens"),
		outputTokens: integer("output_tokens"),
		error: text("error"),
		createdAt: timestamp("created_at").defaultNow().notNull(),
		gradedAt: timestamp("graded_at"),
	},