<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 9">
<meta name=Originator content="Microsoft Word 9">
<link rel=File-List href="cid:filelist.xml@01C99074.31E38450">
<!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
</w:WordDocument>
</xml><![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Bookman Old Style";
panose-1:2 5 6 4 5 5 5 2 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:647 0 0 0 159 0;}
@font-face
{font-family:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;
mso-font-charset:0;
mso-generic-font-family:script;
mso-font-pitch:variable;
mso-font-signature:647 0 0 0 159 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Bookman Old Style";
mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";}
p.MsoMacroText, li.MsoMacroText, div.MsoMacroText
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
tab-stops:24.0pt 48.0pt 1.0in 96.0pt 120.0pt 2.0in 168.0pt 192.0pt 3.0in;
font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Times New Roman";
color:green;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Bookman Old Style";
mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";}
span.EmailStyle15
{mso-style-type:personal-compose;
mso-ansi-font-size:12.0pt;
mso-ascii-font-family:Arial;
mso-hansi-font-family:Arial;
mso-bidi-font-family:Arial;
color:black;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal><span class=EmailStyle15><font size=3 color=black
face=Arial><span style='font-size:12.0pt;font-family:Arial'>Okay, I know that
altering the structure of a core table is bad news. I do not want to do that.<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=3 color=black
face=Arial><span style='font-size:12.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=3 color=black
face=Arial><span style='font-size:12.0pt;font-family:Arial'>I have a module
that keeps a copy of a file path in its own table. This is de-normalizing the
db.<span style="mso-spacerun: yes"> </span>What I want to do is to change
my table to just carry the file ID and change the queries to JOINS. That’s no
biggie.<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=3 color=black
face=Arial><span style='font-size:12.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=3 color=black
face=Arial><span style='font-size:12.0pt;font-family:Arial'>However, someone
wants me to also be able to link to an external image. It would not be hard for
me to put that URL into the files table and get it back with my normal query.<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=3 color=black
face=Arial><span style='font-size:12.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=3 color=black
face=Arial><span style='font-size:12.0pt;font-family:Arial'>Would this be a
legitimate use of the files table?<o:p></o:p></span></font></span></p>
<p class=MsoNormal><span class=EmailStyle15><font size=3 color=black
face=Arial><span style='font-size:12.0pt;font-family:Arial'><![if !supportEmptyParas]> <![endif]><o:p></o:p></span></font></span></p>
<p class=MsoAutoSig><!--[if supportFields]><font color=black><span
style='color:black'><span style='mso-element:field-begin'></span><span
style="mso-spacerun: yes"> </span>AUTOTEXTLIST \s "E-mail
Signature" <span style='mso-element:field-separator'></span></span></font><![endif]--><font
color=fuchsia face="Comic Sans MS"><span style='font-family:"Comic Sans MS";
color:fuchsia'>Nancy E. Wichmann, PMP<o:p></o:p></span></font></p>
<p class=MsoAutoSig><font size=2 color=black face="Bookman Old Style"><span
style='font-size:10.0pt;mso-bidi-font-size:12.0pt;mso-bidi-font-family:Arial;
color:black'>Injustice anywhere is a threat to justice everywhere. - Martin L.
King, Jr.</span></font><font color=black><span style='color:black;mso-color-alt:
windowtext'><o:p></o:p></span></font></p>
<p class=MsoNormal><!--[if supportFields]><font color=black><span
style='color:black'><span style='mso-element:field-end'></span></span></font><![endif]--><font
color=black><span style='color:black'><![if !supportEmptyParas]> <![endif]></span></font><font
color=black><span style='color:black;mso-color-alt:windowtext'><o:p></o:p></span></font></p>
</div>
</body>
</html>