Hello!

Currently crew credits include department and job names, as well as configuration/jobs endpoint contains only department and job names without IDs. Would it be possible to add respective IDs to movie credits and configuration jobs endpoints? Currently it's a problem to store data for caching purposes in normalised tables without job and department IDs.

My first option is to store job and department names inside credits table, but this is suboptimal and should be normalised into jobs and departments tables and storing their IDs in credits table.

Second option is to get jobs and departments from configuration/jobs endpoint, create them in jobs/departments tables storing IDs in credits, but without IDs there is no guarantee for consistency. At some point a job name would be renamed and on my side I would have no clue if it's a new job or an existing one was renamed.

Currently a crew credit object looks like this

{
  "adult": false,
  "gender": 2,
  "id": 90812,
  "known_for_department": "Directing",
  "name": "Scott Mann",
  "original_name": "Scott Mann",
  "popularity": 3.888,
  "profile_path": "/8WygpUzfdfztZQqxGE5zn3rCedJ.jpg",
  "credit_id": "62a21c922b531d0099cec261",
  "department": "Directing",
  "job": "Director"
}

What it should look like with minimal impact and no breaking changes to API

{
  "adult": false,
  "gender": 2,
  "id": 90812,
  "known_for_department": "Directing",
  "known_for_department_id": 10,
  "name": "Scott Mann",
  "original_name": "Scott Mann",
  "popularity": 3.888,
  "profile_path": "/8WygpUzfdfztZQqxGE5zn3rCedJ.jpg",
  "credit_id": "62a21c922b531d0099cec261",
  "department": "Directing",
  "department_id": 10,
  "job": "Director",
  "job_id": 5
}

The Configuration/jobs endpoint would ideally have IDs as well, but I don't think there is a way to add them without breaking changes to the current endpoint. But perhaps a new version might look like this

[
  {
    "id": 1,
    "name": "Department 1",
    "jobs": [
      {
        "id": 1,
        "name": "Job 1"
      },
      {
        "id": 2,
        "name": "Job 2"
      }
    ]
  },
  {
    "id": 2,
    "name": "Department 2",
    "jobs": [
      {
        "id": 3,
        "name": "Job 3"
      },
      {
        "id": 4,
        "name": "Job 4"
      }
    ]
  }
]

With regards, Artem