About 20 years ago, there was a leak of information
regarding a top military advisor who had served several US Presidents.
The information confirmed that this individual was indeed a double agent who
was privy to many
It was then that our finest counterintelligence
minds decided to come up with a database in order to keep track of all known
Special Agents. In order to avoid any reoccurrence of a double agent, the
Spy Database was created.
This database is only used by high-level officials
with high levels of security. Their discretion and need dictate how the
officials pull up vital information about the agent, who they are affiliated
with, and what their specialties may be. The tables below are used by the
officials to record and track each Secret Agent in the world, friend or foe.
A table named xrel, for some x, represents a
many-to-many relationship between the x table and the agent table.
agent: Each agent has a first,
middle and last name, an address, city and country, an annual salary, and a
security clearance.
team: Each team is a set of
agents, with a name and a meeting frequency.
teamrel: Which agents are
associated with which teams.
mission: Each mission has a name, a
security clearance level, a team that performed the mission, and a status.
securityclearance: This gives the clearance
of an agent. Examples: Unclassified < Classified < Secret < Top
Secret < Magellan < Majestic < Imperial < Presidential
affiliation: Organizations the agent
may be affiliated with. It contains the organization’s identification,
the name and the description of the organization.
affiliationrel: The extent to which each
agent is affiliated with each organization. The aff_id and agent_id
make up the key and the connection strength refers to the strength of the
affiliation between the agent and the organization.
language: A character string
describing a language, e.g. English, French, German.
Languagerel: Which agents are prolific in
which languages.
skill: This table pertains to the
proficiency of the agent. Is the agent a sniper, or can they assemble a
bomb, or does the agent have a blackbelt in Karate.
skillrel: This table
tells which agent has which skill.