How to design a database for a list of campaigns and missions?

Question

Database

How can I make a list of campaigns and missions in the database?
for example, there are tables of users, campaigns, missions.
The user has the fields current mission and campaign. Do they have to be keys to the corresponding records?
How can I number the missions one by one?

Answer 1

Until you have a complete understanding of what a "campaign" and "mission" are, you will not be able to design a database. For example, a mission can have a name, a mission has rules for accessing it, a mission consists of a sequence of events, a mission is associated with a rating system, an achievement system is associated with a mission, a mission can be included in a campaign, etc.
I mean that the mission and the campaign are such high abstractions that it is impossible to describe them correctly in the database without a specific technical specification.