Skip to main content
summaryrefslogtreecommitdiffstats
path: root/jpa/plugins/org.eclipse.jpt.doc.user/getting_started007.htm
diff options
context:
space:
mode:
authornhauge2007-05-04 19:55:48 +0000
committernhauge2007-05-04 19:55:48 +0000
commitbc72d754f082fe30ef0d7aeff54f29c64553f02a (patch)
treed69c3c3f38ea93ee78ce6d4529f80d928ee88030 /jpa/plugins/org.eclipse.jpt.doc.user/getting_started007.htm
parentd8139fbb848c9509ae592b5477c85f5fd34b8ceb (diff)
downloadwebtools.dali-bc72d754f082fe30ef0d7aeff54f29c64553f02a.tar.gz
webtools.dali-bc72d754f082fe30ef0d7aeff54f29c64553f02a.tar.xz
webtools.dali-bc72d754f082fe30ef0d7aeff54f29c64553f02a.zip
178911 - Initial check-in for user.doc plugin for Dali 1.0.
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.htm215
1 files changed, 215 insertions, 0 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
new file mode 100644
index 0000000000..22888904ed
--- /dev/null
+++ b/jpa/plugins/org.eclipse.jpt.doc.user/getting_started007.htm
@@ -0,0 +1,215 @@
+<!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 3, 2007 9:19:07 -->
+<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>

Back to the top