I am working on setting up a sqlilte database for parts. the sample kicad_dbl has field names like: Symbols, Footprints, MPN, Value, Description, Keywords etc. These don’t always match the field names shown in “Symbol Fields Table”. Is there a correspondence table somewhere that maps the two? I would like to get this right before a lot of effort is put into building the database schema.
The mapping from DB columns names and parts field names is provided by the .kicad_dbl file (if i’ve understood correctly your question)
for example:
...
"column": "Code_ID",
"name": "IITCode",
...
the column Code_ID of my database is mapped to a field named IITCode in my schematic parts