From 228703d482aea0ac69210036b84bbfe5edfd473b Mon Sep 17 00:00:00 2001 From: "Nicole C. Engard" Date: Fri, 26 Aug 2011 19:30:45 -0400 Subject: [PATCH] Bug 6716 - Documentation for the fieldmapping table This patch documents the fieldmapping table which contains the data associated with the Keyword to Marc Mapping administration area. Signed-off-by: Chris Cormack --- installer/data/mysql/kohastructure.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql index 7d097febbc..922a0b147b 100644 --- a/installer/data/mysql/kohastructure.sql +++ b/installer/data/mysql/kohastructure.sql @@ -2643,12 +2643,12 @@ CREATE TABLE `aqorders_items` ( -- DROP TABLE IF EXISTS `fieldmapping`; -CREATE TABLE `fieldmapping` ( - `id` int(11) NOT NULL auto_increment, - `field` varchar(255) NOT NULL, - `frameworkcode` char(4) NOT NULL default '', - `fieldcode` char(3) NOT NULL, - `subfieldcode` char(1) NOT NULL, +CREATE TABLE `fieldmapping` ( -- koha to keyword mapping + `id` int(11) NOT NULL auto_increment, -- unique identifier assigned by Koha + `field` varchar(255) NOT NULL, -- keyword to be mapped to (ex. subtitle) + `frameworkcode` char(4) NOT NULL default '', -- foreign key from the biblio_framework table to link this mapping to a specific framework + `fieldcode` char(3) NOT NULL, -- marc field number to map to this keyword + `subfieldcode` char(1) NOT NULL, -- marc subfield associated with the fieldcode to map to this keyword PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2.20.1