Skip to main content
summaryrefslogblamecommitdiffstats
blob: 7ea0a10ce94ce211a2abb0c576cb4b082f47ffb6 (plain) (tree)
1
2
3
4
5
6
7
8
9
10



                                                                   
                                            
                                                  
                                                    
                                                                        

                                                                   
                                                                                              
                                                        
                                          
                                                                        
                                                   








                                                                                               
                                              
















































































































































































                                                                                                                                                                                                                                               
                                                                                                                                                                                                





                             
<!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 = January 22, 2008 9:11:14 -->
<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 (Mode = ohj/ohw) - Version 5.0" />
<meta name="date" content="2005-07-10T12:57:20+08:00" />
<meta name="robots" content="noarchive" />
<meta name="doctitle" content="Generate the tutorial database schema" />
<meta name="relnum" content="M5 - Release 2.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" -->
<h1>Generate the tutorial database schema</h1>
<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, 2008,&nbsp;Oracle.&nbsp;All&nbsp;rights&nbsp;reserved.</span></a></td>
</tr>
</table>
</div>
<!-- class="footer" --></div>
</body>
</html>

Back to the top