We are currently working on the forum. For the short-term, all forum content will be in read-only format. We apologize for the interruption and look forward to collaborating with you shortly. All the best in your research!

update_id column in several tables (e.g. dataset)

Hi all,

I am trying to populate some tables with manual scripts, and could not find any details of a column called "update_id" from the data model or schema.

Couple of quick questions:

1) Is update_id a foreign key to user_account.user_id?
2) If so, any reason why the foreign key relationship is not defined?

Appreciate any responses.

Thank you in advance.



  • jskillings07jskillings07 Posts: 8
    Did some investigation and it definitely appears update_id is a FK to user_account.user_id.

    No sure why foreign key relationship is not defined.
  • lindsay.stevenslindsay.stevens Posts: 404 ✭✭✭
    via Email
    Yes, this pattern is in quite a lot of tables. This info also gets thrown
    into the audit log event table, I think by a trigger. There are a few
    counterintuitive structures and redundant tables in the database so if you
    find examples, that's normal.

    For what you are doing I'd recommend turning on logging of all statements
    in the postgres.conf, perform the action you want to do in the OC webapp,
    then use the statements that were logged to write your scripts so you don't
    miss anything.
Sign In or Register to comment.