0

Clarification regarding the model_name column

Hello PA Team!

While exploring the Pyramid repository database, I came across something I'd like to clarify.

I noticed that in the public.server_log_transaction table, the model_name column appears to store the model's unique ID (GUID) rather than its descriptive name. This was a bit confusing at first, especially since the adjacent database_name column in the same table does store the actual descriptive name of the database.

After some investigation, I've concluded that this is likely by design to ensure data integrity, since model names (as content items) can be changed by users, while their IDs remain static?

Could the Pyramid team or someone from the community confirm if this is the correct and intended approach?

Also, as a point of feedback, has there been any consideration for renaming this column to model_id in a future release to make the schema more intuitive? (if it's possible)

Thanks!

Reply

null

Content aside

  • 4 days agoLast active
  • 12Views
  • 1 Following