diff options
Diffstat (limited to 'jpa/plugins/org.eclipse.jpt.doc.user/getting_started007.htm')
| -rw-r--r-- | jpa/plugins/org.eclipse.jpt.doc.user/getting_started007.htm | 215 |
1 files changed, 0 insertions, 215 deletions
diff --git a/jpa/plugins/org.eclipse.jpt.doc.user/getting_started007.htm b/jpa/plugins/org.eclipse.jpt.doc.user/getting_started007.htm deleted file mode 100644 index 654b0c9b83..0000000000 --- a/jpa/plugins/org.eclipse.jpt.doc.user/getting_started007.htm +++ /dev/null @@ -1,215 +0,0 @@ -<!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" /> -<meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> -<title>Generate the tutorial database schema</title> -<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> |