ItemModel {
  Id
  Name
}

Character {
  Id
  Name
}

Loadouts {
  Id
  CharacterId
  Data
}

Route[/api/characters/{id}]
GetCharacter(id) -> Character {
  Select().Where(id = id)
}

Route[/api/characters/{id}/loadouts]
GetCharacterLoadout(id) -> Json<List<Loadouts>> {
  CharacterModel model = new CharacterModel();
  return Json(model.GetCharacterLoadouts(id));
}

// This is inside of a CharacterModel file
Character.GetCharacterLoadouts(id) -> List<Loadouts>{
  String command = "SELECT * FROM loadouts WHERE characterId ="+id;
  List<Loadouts> loadouts = new List<Loadouts>();

  NpgsqlCommand cmd = new NpgsqlCommand(command, conn);
  NpgsqlDataReader result = cmd.ExecuteReader();

  while (result.Read())
  {
    Loadouts loadout = new Loadouts();
    loadout.Id = result.GetInt32(0);
    loadout.CharacterId = result.GetInt32(1);
    loadout.Data = result.GetArray(2);
    loadouts.Add(loadout);
   }
   conn.Close();
   return loadouts;
}