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 tablebdb_table_name: name of the table in the bdb schemabdb_column_name: name of the column in the bdb schemasource_element: url pointing to the OpenAlex documentation of the data element used to fill the respective table/columnexamples: url pointing to the OpenAlex API for a work object that contains the data attribute/element usedmethod: 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).