DEV Community

Cover image for SQL Tables for Marvel Rivals Characters + Team-Up Abilities
Michael Breshock
Michael Breshock

Posted on

SQL Tables for Marvel Rivals Characters + Team-Up Abilities

Happy New Year!✨

To start off the year strong, I'm learning SQL through a Khan Academy course. I was tasked with creating tables of 'famous' people for a project. I decided to make it more fun for myself by creating tables about Marvel Rivals, a video game released recently that has taken the world by storm, myself included. I know I'm not the only data nerd that likes to game in their downtime, so I thought I'd share the SQL code I wrote in case it could be of use.😊

I constructed two tables. The first has every playable character in the game listed in each row, along with their role, difficulty, HP, and affiliation. The second table represents all of the different team-up abilities possible by combining characters 2-3 from the first table. The tables consist of the following columns:

heroes

| hero_id | name | role | hp | difficulty | affiliation |

team_ups

| id | combo_name | activator_id | party1_id | party2_id |

The SQL code to generate these tables can be found on GitHub at github.com/mbreshock/MarvelRivalsDB/blob/main/rivals.sql. This repository also provides a script with example commands for querying these tables. All of the information in these tables was sourced from Marvel Rivals Wiki.

Happy coding and happy gaming!👾

Image of Datadog

Create and maintain end-to-end frontend tests

Learn best practices on creating frontend tests, testing on-premise apps, integrating tests into your CI/CD pipeline, and using Datadog’s testing tunnel.

Download The Guide

Top comments (0)

Image of Docusign

🛠️ Bring your solution into Docusign. Reach over 1.6M customers.

Docusign is now extensible. Overcome challenges with disconnected products and inaccessible data by bringing your solutions into Docusign and publishing to 1.6M customers in the App Center.

Learn more