<?xml version="1.0" encoding="euc-kr"?>
<!DOCTYPE document PUBLIC "-//APACHE//DTD Documentation V1.2//EN" "http://apache.org/forrest/dtd/document-v12.dtd">
<document>
  <header>
    <title>DB 설계</title>
    <authors>
      <person name="민진우" email="pu100@cjb.net"/>
    </authors>
    <notice>이 문서는 JPetStorePlus 프로젝트의 DB 설계서입니다.</notice>
    <abstract>JPetStorePlus의 DB는 JPetStore에서 account와
      orders 테이블에 마일리지관련 필드를 추가한다.</abstract>
  </header>
  <body>
    <section>
      <title>변경되는 테이블</title>
         <table>
           <caption>account 테이블</caption>
           <tr><th>필드명</th><th>타입</th><th>설명</th></tr>
           <tr><td>userid</td><td>varchar(80)</td><td>사용자 ID</td></tr>
           <tr><td>firstname</td><td>varchar(80)</td><td>이름(성)</td></tr>
           <tr><td>lastname</td><td>varchar(80)</td><td>이름</td></tr>
           <tr><td>...</td><td>...</td><td>...</td></tr>
           <tr><td>mileage</td><td>decimal(10,2)</td><td>마일리지</td></tr>
         </table>
         <table>
           <caption>orders 테이블</caption>
           <tr><th>필드명</th><th>타입</th><th>설명</th></tr>
           <tr><td>orderid</td><td>varchar(80)</td><td>주문 ID</td></tr>
           <tr><td>orderdate</td><td>date</td><td>주문 날짜</td></tr>
           <tr><td>...</td><td>...</td><td>...</td></tr>
           <tr><td>mileage</td><td>decimal(10,2)</td><td>마일리지</td></tr>
         </table>
    </section>
  </body>
</document>

