Core Deliverable

API & Database Specifications

Detailed technical specs for backend systems and data models.

REST API Specifications

Define your API endpoints before writing any backend code. This allows frontend and backend teams to work in parallel.

POST /api/v1/auth/reset-password

Request Body:{
  "email": "user@example.com"
}Response (200 OK):{
  "success": true,
  "message": "Password reset email sent."
}Response (404 Not Found):{
  "error": "User not found."
}

Database Schema (ERD)

Design the relational data model. Document the tables, columns, types, and the relationships (1:1, 1:N, M:N) between them.

Users Table

Column	Type
id (PK)	UUID
email	VARCHAR(255)
password_hash	VARCHAR(255)

Password_Resets Table

Column	Type
id (PK)	UUID
user_id (FK)	UUID
token	VARCHAR(64)
expires_at	TIMESTAMP

← Back GTM Plan