<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><div class=WordSection1><p class=MsoNormal>Does anyone have or know where I can find some documentation on the different tables and their function and, more importantly, the relationships of the different tables (i.e. which fields are the linking fields between tables) in the backend MySql database for ASpace? I want to review our test import of several thousand records from AT into ASpace to see that there are no major problems. From experience, I’ve found that reviewing the data through an interface like Access allows me a quick and easy way to locate anomalies as well as isolate problems.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I would greatly appreciate any thoughts or suggestions people can offer.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Jim Duffin<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>J.M. Duffin<o:p></o:p></p><p class=MsoNormal>Senior Archives and Office Manager<o:p></o:p></p><p class=MsoNormal>University Archives and Records Center<o:p></o:p></p><p class=MsoNormal>University of Pennsylvania<o:p></o:p></p><p class=MsoNormal>3401 Market Street, Suite 210<o:p></o:p></p><p class=MsoNormal>Philadelphia, PA 19104<o:p></o:p></p><p class=MsoNormal>T: 215.898.2002<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>