1 -- koha to keyword mapping
2 -- id -- unique identifier assigned by Koha (auto_increment)
3 -- field -- keyword to be mapped to (ex. subtitle)
4 -- frameworkcode -- foreign key from the biblio_framework table to link this mapping to a specific framework (default '')
5 -- fieldcode -- marc field number to map to this keyword
6 -- subfieldcode -- marc subfield associated with the fieldcode to map to this keyword
7 INSERT INTO fieldmapping
8 ( field, frameworkcode, fieldcode, subfieldcode) VALUES
9 ('subtitle', 'CF', '245', 'p'),
10 ('subtitle', 'SER', '490', 'v');