# Design a database schema for a fitness app

Aced (formerly Exponent) publishes a public search API over its indexed pages; the guide is at https://www.aced.io/agents/agent-access.

Source: https://www.aced.io/questions/4843/fitness-app-data-schema-design
Source observed: 2026-11-04T21:34:34.044Z
Last checked: 2026-11-04T21:34:34.044+00:00
Indexed: 2026-11-05T01:56:43.997+00:00

---

# Design a database schema for a fitness app

We provide this interview question through Aced, formerly Exponent, as part of our community question library. It concerns data modeling for a fitness application.

## Interview metadata

- **Reported interviews:** 4
- **Category:** [Data Modeling](https://www.aced.io/questions?type=data-modeling)
- **Roles:** [Data Engineer](https://www.aced.io/questions?role=data-engineer), [Product Manager](https://www.aced.io/questions?role=pm)
- **Companies:** [DoorDash](https://www.aced.io/questions?company=doordash), [Databricks](https://www.aced.io/questions?company=databricks), [Microsoft](https://www.aced.io/questions?company=microsoft)
- **Reported last asked:** a year ago
- **Actions:** Users can mark that they were asked this question or save it. Detailed company statistics are available through [Upgrade](https://www.aced.io/upgrade?src=questions).

## Interview experience

One shared experience is associated with this question:

- [Microsoft interview experience](https://www.aced.io/experiences/microsoft-sr-staff-product-manager-interview-555cd1) — reported as 2 years ago for a **Product Manager, Sr. Staff / L7** role: “Straight forward, easy behavior, one system design. Overall similar to how Amazon interviews. HM was bit tough, I couldn't read if she is interested or if she is forced to interview me. But Skip, and everyone else were super nice.”

## Community answers

There are 2 community answers.

### Anonymous Anteater — May 13, 2025

[Anonymous Anteater](https://www.aced.io/users/e962597d-31c9-43c7-877f-f092853d0988) has 50 karma. The answer proposes these tables and fields:

- **User table:** `userid`, `username`, `email`, `phonenumber`, `account_created_date`
- **Exercises table:** exercise types such as indoor walk, outdoor walk, running, stairs, cycling, and swimming; fields `exercise_id` and `exercise_type`
- **Date table:** `date`, `day`, `month`, `year`, with `dateid`
- **Session table:** `userid`, `session_dateid` linked to `dateid` in the Date table, `exercise_id`, `distance covered`, `calories spent`, `start_time`, and `end_time`

The answer has 2 votes. The page provides a **Read more** control for the answer.

### Amlan B. — March 2, 2025

[Amlan B.](https://www.aced.io/users/28857784-97b0-4227-a35a-4c0713742216) has 1 karma. The answer says: “Took example of cultfit and explained.”

## Related questions

- [Design a database schema for a ride sharing app.](https://www.aced.io/questions/5545/design-data-schema-ride-sharing)
- [Design a fitness app.](https://www.aced.io/questions/3343/design-fitness-app)
- [Design a fitness app for Facebook.](https://www.aced.io/questions/1974/design-fitness-app-for-facebook)

## Related courses

### [Data Engineering Interview Prep](https://www.aced.io/courses/data-engineering)

![Data Engineering Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/5XoOCgXlGqN2fa1zaroNWd/9a2e23df48a212bc00d352873feb2d6a/Data_Engineer_Interview_Prep_Hero_Image.jpg?w=800&h=800&fm=webp&q=75)

We help candidates prepare for data engineering roles at Meta, Google, Amazon, Microsoft, Walmart, DoorDash, and other top companies. The course covers mock interviews, frameworks, advice from senior candidates, data modeling, pipeline design, SQL, coding, behavioral interviews, and more.

### [Product Management Interview Prep](https://www.aced.io/courses/pm)

![Product Management Interview Prep](https://images.ctfassets.net/x78yjrjc11pq/4PFBEhtIRyKwPm14eaBAFm/ad92a8c4dd1dc51108b3a855de64473b/product_management_track_compressed_063e6d4b35.jpeg?w=800&h=800&fm=webp&q=75)

We help candidates prepare for PM roles at Anthropic, OpenAI, Meta, Apple, Google, and more. The course covers AI product-sense rounds, vibe-coding prototypes, metrics questions, AI fluency, product strategy, product sense, analytical and execution skills, leadership and drive behavioral interviews, and technical PM interviews.

## Your answer

Signed-in users can submit their own answer using the editor, which supports bold, italic, bulleted-list, numbered-list, quote, inline-code, and code-block formatting. Submitting marks the question complete.

---

[Read this page’s summary](https://www.aced.io/agents/api/public/v1/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F4843%2Ffitness-app-data-schema-design&trace=t_679ff9ab98f3)

## Ask a follow-up about this page

Need a more specific answer? Ask the exact question you have. It returns a fresh, cited answer from Aced (formerly Exponent)’s knowledge base. No account or API key required.

Open this URL with your own question, URL-encoded. Include your question in q. All research inputs are optional; no account or setup.

`GET https://www.aced.io/agents/agent/faq?q={question}&trace=t_679ff9ab98f3`

[Tool guide and examples](https://www.aced.io/agents/agent-access) · [OpenAPI](https://www.aced.io/agents/api/public/v1/openapi.json) · [Page TLDR form](https://www.aced.io/agents/agent-tools/page-tldr?url=https%3A%2F%2Fwww.aced.io%2Fquestions%2F4843%2Ffitness-app-data-schema-design). Opening a form does not execute a tool.