Hi Karen, all, I meant the following fields: in Work: other_titles and translated_titles. In over 15 million records, these fields are only used 5 times and similar fields are in Edition records.
in Edition: - full title; how does this relate to title? - name; are these 9 records that used to be Authors (which have name fields)? - work_title / work_titles; why would we use these when there is the title in Work? - title_prefix; is this being used? If so, why is there no corresponding title_prefix in Work? Ben On 18 August 2012 06:25, Karen Coyle <[email protected]> wrote: > > > On 8/17/12 12:31 PM, Ben Companjen wrote: > >> >> Works have these fields with corresponding number of appearances at >> the end of July 2012: >> title, 15560144 >> other_titles, 1 >> translated_titles, 4 >> subtitle, 578433 >> >> Editions: >> title, 24841618 >> subtitle, 9809990 >> other_titles, 2225897 >> full_title, 521383 >> name, 9 >> work_titles, 493101 >> work_title, 261511 >> translation_of, 2739 >> title_prefix, 2945495 >> >> title and subtitle speak for themselves, other_titles and >> translation_of are available in the edit form in librarian mode, but >> the others seem relics from previous system designs. Can anyone >> explain those? Are they used anywhere? Or can they safely be deleted? > > Ben, which are you thinking are left-overs? The only one that seems odd > to me is "name." > > kc > >> >> Thanks! >> >> Ben >> _______________________________________________ >> Ol-tech mailing list >> [email protected] >> http://mail.archive.org/cgi-bin/mailman/listinfo/ol-tech >> To unsubscribe from this mailing list, send email to >> [email protected] >> > > -- > Karen Coyle > [email protected] http://kcoyle.net > ph: 1-510-540-7596 > m: 1-510-435-8234 > skype: kcoylenet > _______________________________________________ > Ol-tech mailing list > [email protected] > http://mail.archive.org/cgi-bin/mailman/listinfo/ol-tech > To unsubscribe from this mailing list, send email to > [email protected] _______________________________________________ Ol-tech mailing list [email protected] http://mail.archive.org/cgi-bin/mailman/listinfo/ol-tech To unsubscribe from this mailing list, send email to [email protected]
