OpenAlex mapping from raw data to KB bibliometric database schema

This table contains the mapping from OpenAlex raw data in JSONL format to the bibliometric database schema (bdb schema) of the Kompetenznetzwerk Bibliometrie (KB) available here: https://zenodo.org/records/12206867

Description of columns: 

id: a serial for all rows in the table
bdb_table_name: name of the table in the bdb schema
bdb_column_name: name of the column in the bdb schema
source_element: url pointing to the OpenAlex documentation of the data element used to fill the respective table/column
examples: url pointing to the OpenAlex API for a work object that contains the data attribute/element used
method: detailed description on how the respective table/column is filled (containing calculations and data manipulations, cleaning, extraction, filtering)
heuristics: some more information about the motivation/intention for the method

For each bdb table, in addition to all its columns, a row with column name 'general' is available, containing general information on the table (not directly 
related to only one specific column).