db-lesson/【練習問題】 SQL/Question3/データ定義.files/sheet005.htm

<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=shift_jis">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 15">
<link id=Main-File rel=Main-File href="../データ定義.htm">
<link rel=File-List href=filelist.xml>
<link rel=Stylesheet href=stylesheet.css>
<style>
<!--table
	{mso-displayed-decimal-separator:"\.";
	mso-displayed-thousand-separator:"\,";}
@page
	{margin:.75in .7in .75in .7in;
	mso-header-margin:.3in;
	mso-footer-margin:.3in;}
ruby
	{ruby-align:left;}
rt
	{color:windowtext;
	font-size:6.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:"ＭＳ Ｐゴシック", monospace;
	mso-font-charset:128;
	mso-char-type:katakana;
	display:none;}
-->
</style>
<![if !supportTabStrip]><script language="JavaScript">
<!--
function fnUpdateTabs()
 {
  if (parent.window.g_iIEVer>=4) {
   if (parent.document.readyState=="complete"
    && parent.frames['frTabs'].document.readyState=="complete")
   parent.fnSetActiveSheet(4);
  else
   window.setTimeout("fnUpdateTabs();",150);
 }
}

if (window.name!="frSheet")
 window.location.replace("../データ定義.htm");
else
 fnUpdateTabs();
//-->
</script>
<![endif]>
</head>

<body link="#0563C1" vlink="#954F72" class=xl67>

<table border=0 cellpadding=0 cellspacing=0 width=456 style='border-collapse:
 collapse;table-layout:fixed;width:342pt'>
 <col class=xl66 width=21 style='mso-width-source:userset;mso-width-alt:672;
 width:16pt'>
 <col class=xl67 width=72 style='width:54pt'>
 <col class=xl67 width=91 style='mso-width-source:userset;mso-width-alt:2912;
 width:68pt'>
 <col class=xl67 width=87 style='mso-width-source:userset;mso-width-alt:2784;
 width:65pt'>
 <col class=xl67 width=85 style='mso-width-source:userset;mso-width-alt:2720;
 width:64pt'>
 <col class=xl67 width=100 style='mso-width-source:userset;mso-width-alt:3200;
 width:75pt'>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 colspan=2 width=93 style='height:12.0pt;mso-ignore:
  colspan;width:70pt'><ruby>在庫<span style='display:none'><rt class=font7>ザイコ</rt></span></ruby>マスタ</td>
  <td class=xl67 width=91 style='width:68pt'>stock_m</td>
  <td class=xl67 width=87 style='width:65pt'></td>
  <td class=xl67 width=85 style='width:64pt'></td>
  <td class=xl67 width=100 style='width:75pt'></td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl68><ruby>倉庫<span style='display:none'><rt class=font7>ソウコ</rt></span></ruby>ID</td>
  <td class=xl68 style='border-left:none'><ruby>商品<span style='display:none'><rt
  class=font6>ショウヒン</rt></span></ruby>ID</td>
  <td class=xl68 style='border-left:none'><ruby>入庫<span style='display:none'><rt
  class=font6>ニュウコ</rt></span></ruby><ruby>日<span style='display:none'><rt
  class=font6>ビ</rt></span></ruby></td>
  <td class=xl68 style='border-left:none'><ruby>入庫<span style='display:none'><rt
  class=font6>ニュウコ</rt></span></ruby><ruby>数<span style='display:none'><rt
  class=font6>スウ</rt></span></ruby></td>
  <td class=xl68 style='border-left:none'><ruby>引<span style='display:none'><rt
  class=font6>ヒ</rt></span></ruby><ruby>当<span style='display:none'><rt
  class=font6>ア</rt></span></ruby><ruby>数<span style='display:none'><rt
  class=font6>スウ</rt></span></ruby></td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl85>stock_id<ruby><font class="font7"><rt class=font7></rt></font></ruby></td>
  <td class=xl85 style='border-left:none'>goods_id<ruby><font class="font6"><rt
  class=font6></rt></font></ruby></td>
  <td class=xl85 style='border-left:none'>arrival_date<ruby><font class="font6"><rt
  class=font6></rt></font></ruby></td>
  <td class=xl85 style='border-left:none'>arrival_num<ruby><font class="font6"><rt
  class=font6></rt></font></ruby></td>
  <td class=xl85 style='border-left:none'>security_num<ruby><font class="font6"><rt
  class=font6></rt></font></ruby></td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl84>W0001</td>
  <td class=xl84 style='border-left:none'>ITM0000001</td>
  <td class=xl89 align=right style='border-left:none'>2012/8/24</td>
  <td class=xl91 style='border-left:none'>2</td>
  <td class=xl91 style='border-left:none'>2</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl69 style='border-top:none'>W0001</td>
  <td class=xl69 style='border-top:none;border-left:none'>ITM0000001</td>
  <td class=xl76 align=right style='border-top:none;border-left:none'>2012/12/25</td>
  <td class=xl92 style='border-top:none;border-left:none'>3</td>
  <td class=xl92 style='border-top:none;border-left:none'>3</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl69 style='border-top:none'>W0001</td>
  <td class=xl69 style='border-top:none;border-left:none'>ITM0000001</td>
  <td class=xl76 align=right style='border-top:none;border-left:none'>2013/6/1</td>
  <td class=xl92 style='border-top:none;border-left:none'>2</td>
  <td class=xl92 style='border-top:none;border-left:none'>2</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl69 style='border-top:none'>W0001</td>
  <td class=xl69 style='border-top:none;border-left:none'>ITM0000001</td>
  <td class=xl77 align=right style='border-top:none;border-left:none'>2013/11/20</td>
  <td class=xl94 style='border-top:none;border-left:none'>5</td>
  <td class=xl94 style='border-top:none;border-left:none'>4</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl69 style='border-top:none'>W0001</td>
  <td class=xl69 style='border-top:none;border-left:none'>ITM0000001</td>
  <td class=xl77 align=right style='border-left:none'>2014/8/8</td>
  <td class=xl94 style='border-left:none'>7</td>
  <td class=xl94 style='border-left:none'>0</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl69 style='border-top:none'>W0001</td>
  <td class=xl71 style='border-top:none;border-left:none'>ITM0000002</td>
  <td class=xl77 align=right style='border-left:none'>2014/3/4</td>
  <td class=xl94 style='border-left:none'>100</td>
  <td class=xl94 style='border-left:none'>100</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl69 style='border-top:none'>W0001</td>
  <td class=xl71 style='border-left:none'>ITM0000002</td>
  <td class=xl77 align=right style='border-left:none'>2014/9/5</td>
  <td class=xl94 style='border-left:none'>50</td>
  <td class=xl94 style='border-left:none'>45</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl69 style='border-top:none'>W0001</td>
  <td class=xl71 style='border-left:none'>ITM0000002</td>
  <td class=xl77 align=right style='border-left:none'>2014/9/10</td>
  <td class=xl94 style='border-left:none'>60</td>
  <td class=xl94 style='border-left:none'>0</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl69 style='border-top:none'>W0001</td>
  <td class=xl71 style='border-left:none'>ITM0000003</td>
  <td class=xl77 align=right style='border-left:none'>2013/9/17</td>
  <td class=xl94 style='border-left:none'>5</td>
  <td class=xl94 style='border-left:none'>2</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl69 style='border-top:none'>W0001</td>
  <td class=xl71 style='border-left:none'>ITM0000004</td>
  <td class=xl77 align=right style='border-left:none'>2010/3/3</td>
  <td class=xl94 style='border-left:none'>10</td>
  <td class=xl94 style='border-left:none'>10</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl69 style='border-top:none'>W0001</td>
  <td class=xl71 style='border-left:none'>ITM0000004</td>
  <td class=xl77 align=right style='border-left:none'>2012/10/5</td>
  <td class=xl94 style='border-left:none'>3</td>
  <td class=xl94 style='border-left:none'>3</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl69 style='border-top:none'>W0001</td>
  <td class=xl71 style='border-left:none'>ITM0000004</td>
  <td class=xl77 align=right style='border-left:none'>2013/9/10</td>
  <td class=xl94 style='border-left:none'>6</td>
  <td class=xl94 style='border-left:none'>5</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl69 style='border-top:none'>W0001</td>
  <td class=xl71 style='border-left:none'>ITM0000004</td>
  <td class=xl77 align=right style='border-left:none'>2014/4/3</td>
  <td class=xl94 style='border-left:none'>2</td>
  <td class=xl94 style='border-left:none'>0</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl69 style='border-top:none'>W0001</td>
  <td class=xl71 style='border-left:none'>ITM0000005</td>
  <td class=xl77 align=right style='border-left:none'>2014/4/28</td>
  <td class=xl94 style='border-left:none'>150</td>
  <td class=xl94 style='border-left:none'>150</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl70 style='border-top:none'>W0001</td>
  <td class=xl70 style='border-left:none'>ITM0000005</td>
  <td class=xl78 align=right style='border-left:none'>2014/5/20</td>
  <td class=xl93 style='border-left:none'>100</td>
  <td class=xl93 style='border-left:none'>86</td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl67></td>
  <td class=xl67></td>
  <td class=xl67></td>
  <td class=xl67></td>
  <td class=xl67></td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl67></td>
  <td class=xl67></td>
  <td class=xl67></td>
  <td class=xl67></td>
  <td class=xl67></td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl67 colspan=3 style='mso-ignore:colspan'>（<ruby>入庫数<span
  style='display:none'><rt>ニュウコスウ</rt></span></ruby>　－　<ruby>引当<span
  style='display:none'><rt>ヒキアテ</rt></span></ruby><ruby>数<span
  style='display:none'><rt>スウ</rt></span></ruby>）が<ruby>在庫数<span
  style='display:none'><rt>ザイコスウ</rt></span></ruby></td>
  <td class=xl67></td>
  <td class=xl67></td>
 </tr>
 <tr height=16 style='height:12.0pt'>
  <td height=16 class=xl66 style='height:12.0pt'></td>
  <td class=xl67 colspan=3 style='mso-ignore:colspan'><ruby>古<span
  style='display:none'><rt>フル</rt></span></ruby>い<ruby>在庫<span
  style='display:none'><rt>ザイコ</rt></span></ruby>から<ruby>引当<span
  style='display:none'><rt>ヒキアテ</rt></span></ruby>をしていくこと</td>
  <td class=xl67></td>
  <td class=xl67></td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=21 style='width:16pt'></td>
  <td width=72 style='width:54pt'></td>
  <td width=91 style='width:68pt'></td>
  <td width=87 style='width:65pt'></td>
  <td width=85 style='width:64pt'></td>
  <td width=100 style='width:75pt'></td>
 </tr>
 <![endif]>
</table>

</body>

</html>