jpa/plugins/org.eclipse.jpt.doc.user/getting_started007.htm - dali/webtools.dali - Git at Google

 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
 <head>
 <!-- Run date = May 21, 2007 6:35:52 -->
 <meta name="OAC_IGNORE_SKIP_NAV" content="true" />
 <title>Generate the tutorial database schema</title>
 <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" />
 <meta http-equiv="Content-Style-Type" content="text/css" />
 <meta http-equiv="Content-Script-Type" content="text/javascript" />
 <meta name="generator" content="Oracle DARB XHTML Converter - Version 4.5.3 Build 02" />
 <meta name="date" content="2005-07-10T12:57:20+08:00" />
 <meta name="robots" content="all" scheme="http://www.robotstxt.org/" />
 <meta name="doctitle" content="Generate the tutorial database schema" />
 <meta name="relnum" content="Release 1.0.0" />
 <meta name="partnum" content="" />
 <link rel="copyright" href="dcommon/html/cpyr.htm" title="Copyright" type="text/html" />
 <link rel="stylesheet" href="dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" />
 <link rel="start" href="../../index.htm" title="Home" type="text/html" />
 <link rel="contents" href="toc.htm" title="Contents" type="text/html" />
 </head>
 <body>
 <p><a id="BABBBBID" name="BABBBBID"></a></p>
 <div class="sect2"><!-- infolevel="all" infotype="General" -->
 <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
 <tr valign="bottom">
 <td align="left" width="86%">
 <h1>Generate the tutorial database schema</h1>
 </td>
 </tr>
 </table>
 <p>The tutorial application uses three database tables to store each employee's information: EMPLOYEE, ADDRESS and PHONE. <a href="#BABDEFDF">Table: Tutorial Database Schema</a> describes the columns for each table.</p>
 <p>You can download SQL scripts to build and populate the database tables with sample data from <code><a href="http://www.eclipse.org/webtools/dali/docs/dbscripts.zip">http://www.eclipse.org/webtools/dali/docs/dbscripts.zip</a></code>.</p>
 <div class="tblhruleformal"><a id="sthref22" name="sthref22"></a><a id="BABDEFDF" name="BABDEFDF"></a>
 <p class="titleintable">Tutorial Database Schema</p>
 <table class="HRuleFormal" title="Tutorial Database Schema" summary="This table lists the database schema." dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0">
 <thead>
 <tr align="left" valign="top">
 <th align="left" valign="bottom" id="r1c1-t5">Table</th>
 <th align="left" valign="bottom" id="r1c2-t5">Column</th>
 <th align="left" valign="bottom" id="r1c3-t5">Type</th>
 <th align="left" valign="bottom" id="r1c4-t5">Details</th>
 </tr>
 </thead>
 <tbody>
 <tr align="left" valign="top">
 <td align="left" id="r2c1-t5" headers="r1c1-t5" rowspan="5">
 <p>EMPLOYEE</p>
 </td>
 <td align="left" headers="r2c1-t5 r1c2-t5">
 <p>EMP_ID</p>
 </td>
 <td align="left" headers="r2c1-t5 r1c3-t5">
 <p>NUMBER(15)</p>
 </td>
 <td align="left" headers="r2c1-t5 r1c4-t5">
 <p>Primary Key</p>
 </td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r3c1-t5" headers="r2c1-t5 r1c1-t5">
 <p>F_NAME</p>
 </td>
 <td align="left" headers="r2c1-t5 r3c1-t5 r1c2-t5">
 <p>VARCHAR(40)</p>
 </td>
 <td align="left" headers="r2c1-t5 r3c1-t5 r1c3-t5"><br /></td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r4c1-t5" headers="r2c1-t5 r1c1-t5">
 <p>L_NAME</p>
 </td>
 <td align="left" headers="r2c1-t5 r4c1-t5 r1c2-t5">
 <p>VARCHAR(40)</p>
 </td>
 <td align="left" headers="r2c1-t5 r4c1-t5 r1c3-t5"><br /></td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r5c1-t5" headers="r2c1-t5 r1c1-t5">
 <p>ADDR_ID</p>
 </td>
 <td align="left" headers="r2c1-t5 r5c1-t5 r1c2-t5">
 <p>NUMBER(15)</p>
 </td>
 <td align="left" headers="r2c1-t5 r5c1-t5 r1c3-t5">
 <p>Foreign Key, references ADDRESS.ADDRES_ID</p>
 </td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r6c1-t5" headers="r2c1-t5 r1c1-t5">
 <p>VERSION</p>
 </td>
 <td align="left" headers="r2c1-t5 r6c1-t5 r1c2-t5">
 <p>NUMBER(15)</p>
 </td>
 <td align="left" headers="r2c1-t5 r6c1-t5 r1c3-t5"><br /></td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r7c1-t5" headers="r1c1-t5" rowspan="6">
 <p>ADDRESS</p>
 </td>
 <td align="left" headers="r7c1-t5 r1c2-t5">
 <p>ADDRESS_ID</p>
 </td>
 <td align="left" headers="r7c1-t5 r1c3-t5">
 <p>NUMBER(15)</p>
 </td>
 <td align="left" headers="r7c1-t5 r1c4-t5">
 <p>Primary Key</p>
 </td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r8c1-t5" headers="r7c1-t5 r1c1-t5">
 <p>PROVINCE</p>
 </td>
 <td align="left" headers="r7c1-t5 r8c1-t5 r1c2-t5">
 <p>VARCHAR(80)</p>
 </td>
 <td align="left" headers="r7c1-t5 r8c1-t5 r1c3-t5"><br /></td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r9c1-t5" headers="r7c1-t5 r1c1-t5">
 <p>COUNTRY</p>
 </td>
 <td align="left" headers="r7c1-t5 r9c1-t5 r1c2-t5">
 <p>VARCHAR(80)</p>
 </td>
 <td align="left" headers="r7c1-t5 r9c1-t5 r1c3-t5"><br /></td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r10c1-t5" headers="r7c1-t5 r1c1-t5">
 <p>STREET</p>
 </td>
 <td align="left" headers="r7c1-t5 r10c1-t5 r1c2-t5">
 <p>VARCHAR(80)</p>
 </td>
 <td align="left" headers="r7c1-t5 r10c1-t5 r1c3-t5"><br /></td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r11c1-t5" headers="r7c1-t5 r1c1-t5">
 <p>P_CODE</p>
 </td>
 <td align="left" headers="r7c1-t5 r11c1-t5 r1c2-t5">
 <p>VARCHAR(20)</p>
 </td>
 <td align="left" headers="r7c1-t5 r11c1-t5 r1c3-t5"><br /></td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r12c1-t5" headers="r7c1-t5 r1c1-t5">
 <p>CITY</p>
 </td>
 <td align="left" headers="r7c1-t5 r12c1-t5 r1c2-t5">
 <p>VARCHAR(80)</p>
 </td>
 <td align="left" headers="r7c1-t5 r12c1-t5 r1c3-t5"><br /></td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r13c1-t5" headers="r1c1-t5" rowspan="4">
 <p>PHONE</p>
 </td>
 <td align="left" headers="r13c1-t5 r1c2-t5">
 <p>EMP_ID</p>
 </td>
 <td align="left" headers="r13c1-t5 r1c3-t5">
 <p>NUMBER(15)</p>
 </td>
 <td align="left" headers="r13c1-t5 r1c4-t5">
 <p>Foreign Key, reference to EMPLOYEE.EMP_ID</p>
 </td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r14c1-t5" headers="r13c1-t5 r1c1-t5">
 <p>AREA_CODE</p>
 </td>
 <td align="left" headers="r13c1-t5 r14c1-t5 r1c2-t5">
 <p>VARCHAR(3)</p>
 </td>
 <td align="left" headers="r13c1-t5 r14c1-t5 r1c3-t5"><br /></td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r15c1-t5" headers="r13c1-t5 r1c1-t5">
 <p>P_NUMBER</p>
 </td>
 <td align="left" headers="r13c1-t5 r15c1-t5 r1c2-t5">
 <p>VARCHAR(7)</p>
 </td>
 <td align="left" headers="r13c1-t5 r15c1-t5 r1c3-t5">
 <p>Primary key</p>
 </td>
 </tr>
 <tr align="left" valign="top">
 <td align="left" id="r16c1-t5" headers="r13c1-t5 r1c1-t5">
 <p>TYPE</p>
 </td>
 <td align="left" headers="r13c1-t5 r16c1-t5 r1c2-t5">
 <p>VARCHAR(15)</p>
 </td>
 <td align="left" headers="r13c1-t5 r16c1-t5 r1c3-t5"><br /></td>
 </tr>
 </tbody>
 </table>
 <br /></div>
 <!-- class="tblhruleformal" -->
 <p>Next, you will <a href="getting_started008.htm#BABDHFCD">Create a database connection</a>.</p>
 <!-- Start Footer -->
 <div class="footer">
 <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
 <tr>
 <td align="left" width="86%"><a href="dcommon/html/cpyr.htm"><span class="copyrightlogo">Copyright&nbsp;&copy;&nbsp;2006, 2007,&nbsp;Oracle.&nbsp;All&nbsp;rights&nbsp;reserved.</span></a></td>
 </tr>
 </table>
 </div>
 <!-- class="footer" --></div>
 </body>
 </html>
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
	<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
	<head>
	<!-- Run date = May 21, 2007 6:35:52 -->
	<meta name="OAC_IGNORE_SKIP_NAV" content="true" />
	<title>Generate the tutorial database schema</title>
	<meta http-equiv="Content-Type" content="text/html; charset=us-ascii" />
	<meta http-equiv="Content-Style-Type" content="text/css" />
	<meta http-equiv="Content-Script-Type" content="text/javascript" />
	<meta name="generator" content="Oracle DARB XHTML Converter - Version 4.5.3 Build 02" />
	<meta name="date" content="2005-07-10T12:57:20+08:00" />
	<meta name="robots" content="all" scheme="http://www.robotstxt.org/" />
	<meta name="doctitle" content="Generate the tutorial database schema" />
	<meta name="relnum" content="Release 1.0.0" />
	<meta name="partnum" content="" />
	<link rel="copyright" href="dcommon/html/cpyr.htm" title="Copyright" type="text/html" />
	<link rel="stylesheet" href="dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" />
	<link rel="start" href="../../index.htm" title="Home" type="text/html" />
	<link rel="contents" href="toc.htm" title="Contents" type="text/html" />
	</head>
	<body>
	<p><a id="BABBBBID" name="BABBBBID"></a></p>
	<div class="sect2"><!-- infolevel="all" infotype="General" -->
	<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
	<tr valign="bottom">
	<td align="left" width="86%">
	<h1>Generate the tutorial database schema</h1>
	</td>
	</tr>
	</table>
	<p>The tutorial application uses three database tables to store each employee's information: EMPLOYEE, ADDRESS and PHONE. <a href="#BABDEFDF">Table: Tutorial Database Schema</a> describes the columns for each table.</p>
	<p>You can download SQL scripts to build and populate the database tables with sample data from <code><a href="http://www.eclipse.org/webtools/dali/docs/dbscripts.zip">http://www.eclipse.org/webtools/dali/docs/dbscripts.zip</a></code>.</p>
	<div class="tblhruleformal"><a id="sthref22" name="sthref22"></a><a id="BABDEFDF" name="BABDEFDF"></a>
	<p class="titleintable">Tutorial Database Schema</p>
	<table class="HRuleFormal" title="Tutorial Database Schema" summary="This table lists the database schema." dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0">
	<thead>
	<tr align="left" valign="top">
	<th align="left" valign="bottom" id="r1c1-t5">Table</th>
	<th align="left" valign="bottom" id="r1c2-t5">Column</th>
	<th align="left" valign="bottom" id="r1c3-t5">Type</th>
	<th align="left" valign="bottom" id="r1c4-t5">Details</th>
	</tr>
	</thead>
	<tbody>
	<tr align="left" valign="top">
	<td align="left" id="r2c1-t5" headers="r1c1-t5" rowspan="5">
	<p>EMPLOYEE</p>
	</td>
	<td align="left" headers="r2c1-t5 r1c2-t5">
	<p>EMP_ID</p>
	</td>
	<td align="left" headers="r2c1-t5 r1c3-t5">
	<p>NUMBER(15)</p>
	</td>
	<td align="left" headers="r2c1-t5 r1c4-t5">
	<p>Primary Key</p>
	</td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r3c1-t5" headers="r2c1-t5 r1c1-t5">
	<p>F_NAME</p>
	</td>
	<td align="left" headers="r2c1-t5 r3c1-t5 r1c2-t5">
	<p>VARCHAR(40)</p>
	</td>
	<td align="left" headers="r2c1-t5 r3c1-t5 r1c3-t5"><br /></td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r4c1-t5" headers="r2c1-t5 r1c1-t5">
	<p>L_NAME</p>
	</td>
	<td align="left" headers="r2c1-t5 r4c1-t5 r1c2-t5">
	<p>VARCHAR(40)</p>
	</td>
	<td align="left" headers="r2c1-t5 r4c1-t5 r1c3-t5"><br /></td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r5c1-t5" headers="r2c1-t5 r1c1-t5">
	<p>ADDR_ID</p>
	</td>
	<td align="left" headers="r2c1-t5 r5c1-t5 r1c2-t5">
	<p>NUMBER(15)</p>
	</td>
	<td align="left" headers="r2c1-t5 r5c1-t5 r1c3-t5">
	<p>Foreign Key, references ADDRESS.ADDRES_ID</p>
	</td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r6c1-t5" headers="r2c1-t5 r1c1-t5">
	<p>VERSION</p>
	</td>
	<td align="left" headers="r2c1-t5 r6c1-t5 r1c2-t5">
	<p>NUMBER(15)</p>
	</td>
	<td align="left" headers="r2c1-t5 r6c1-t5 r1c3-t5"><br /></td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r7c1-t5" headers="r1c1-t5" rowspan="6">
	<p>ADDRESS</p>
	</td>
	<td align="left" headers="r7c1-t5 r1c2-t5">
	<p>ADDRESS_ID</p>
	</td>
	<td align="left" headers="r7c1-t5 r1c3-t5">
	<p>NUMBER(15)</p>
	</td>
	<td align="left" headers="r7c1-t5 r1c4-t5">
	<p>Primary Key</p>
	</td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r8c1-t5" headers="r7c1-t5 r1c1-t5">
	<p>PROVINCE</p>
	</td>
	<td align="left" headers="r7c1-t5 r8c1-t5 r1c2-t5">
	<p>VARCHAR(80)</p>
	</td>
	<td align="left" headers="r7c1-t5 r8c1-t5 r1c3-t5"><br /></td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r9c1-t5" headers="r7c1-t5 r1c1-t5">
	<p>COUNTRY</p>
	</td>
	<td align="left" headers="r7c1-t5 r9c1-t5 r1c2-t5">
	<p>VARCHAR(80)</p>
	</td>
	<td align="left" headers="r7c1-t5 r9c1-t5 r1c3-t5"><br /></td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r10c1-t5" headers="r7c1-t5 r1c1-t5">
	<p>STREET</p>
	</td>
	<td align="left" headers="r7c1-t5 r10c1-t5 r1c2-t5">
	<p>VARCHAR(80)</p>
	</td>
	<td align="left" headers="r7c1-t5 r10c1-t5 r1c3-t5"><br /></td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r11c1-t5" headers="r7c1-t5 r1c1-t5">
	<p>P_CODE</p>
	</td>
	<td align="left" headers="r7c1-t5 r11c1-t5 r1c2-t5">
	<p>VARCHAR(20)</p>
	</td>
	<td align="left" headers="r7c1-t5 r11c1-t5 r1c3-t5"><br /></td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r12c1-t5" headers="r7c1-t5 r1c1-t5">
	<p>CITY</p>
	</td>
	<td align="left" headers="r7c1-t5 r12c1-t5 r1c2-t5">
	<p>VARCHAR(80)</p>
	</td>
	<td align="left" headers="r7c1-t5 r12c1-t5 r1c3-t5"><br /></td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r13c1-t5" headers="r1c1-t5" rowspan="4">
	<p>PHONE</p>
	</td>
	<td align="left" headers="r13c1-t5 r1c2-t5">
	<p>EMP_ID</p>
	</td>
	<td align="left" headers="r13c1-t5 r1c3-t5">
	<p>NUMBER(15)</p>
	</td>
	<td align="left" headers="r13c1-t5 r1c4-t5">
	<p>Foreign Key, reference to EMPLOYEE.EMP_ID</p>
	</td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r14c1-t5" headers="r13c1-t5 r1c1-t5">
	<p>AREA_CODE</p>
	</td>
	<td align="left" headers="r13c1-t5 r14c1-t5 r1c2-t5">
	<p>VARCHAR(3)</p>
	</td>
	<td align="left" headers="r13c1-t5 r14c1-t5 r1c3-t5"><br /></td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r15c1-t5" headers="r13c1-t5 r1c1-t5">
	<p>P_NUMBER</p>
	</td>
	<td align="left" headers="r13c1-t5 r15c1-t5 r1c2-t5">
	<p>VARCHAR(7)</p>
	</td>
	<td align="left" headers="r13c1-t5 r15c1-t5 r1c3-t5">
	<p>Primary key</p>
	</td>
	</tr>
	<tr align="left" valign="top">
	<td align="left" id="r16c1-t5" headers="r13c1-t5 r1c1-t5">
	<p>TYPE</p>
	</td>
	<td align="left" headers="r13c1-t5 r16c1-t5 r1c2-t5">
	<p>VARCHAR(15)</p>
	</td>
	<td align="left" headers="r13c1-t5 r16c1-t5 r1c3-t5"><br /></td>
	</tr>
	</tbody>
	</table>
	<br /></div>
	<!-- class="tblhruleformal" -->
	<p>Next, you will <a href="getting_started008.htm#BABDHFCD">Create a database connection</a>.</p>
	<!-- Start Footer -->
	<div class="footer">
	<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
	<tr>
	<td align="left" width="86%"><a href="dcommon/html/cpyr.htm"><span class="copyrightlogo">Copyright © 2006, 2007, Oracle. All rights reserved.</span></a></td>
	</tr>
	</table>
	</div>
	<!-- class="footer" --></div>
	</body>
	</html>