Hi @ssciberras,
See e.g. "Assoc_Type" And Metrics Table OJS - #2 by asmecher and Migrating group settings from one journal to another - #2 by asmecher for information on the assoc_type / assoc_id pattern we use in the database.
Regards,
Alec Smecher
Public Knowledge Project Team