ÿþ<?xml version="1.0" encoding="UTF-16"?><html xmlns="http://www.w3.org/1999/xhtml"><head><title>Table/Columns Report</title><script type="text/javascript"> // function toggle(element, togimg) { if (element.style.display == 'none') { element.style.display = 'block'; togimg.src="images/collapse.gif"; } else { element.style.display = 'none'; togimg.src="images/expand.gif"; } } // </script></head><STYLE> BODY { font-family:Arial; background-image: url(images/background.gif); } TD { font-size: 80%; background-color: #EEEEEE; vertical-align: top; } H1 { border-bottom: #000099 thick solid; } img { border-width: 0px; } .sqlcode { font-family: system; font-size: 70%; } .CommonHeader { color: #666666; font-size: 130%; font-weight: bold; font-family: Tahoma, Arial, Helvetica; padding: 0px; margin: 0px; margin-top: 8px; } a:link, a:visited { color: #4444BF; text-decoration: none; } .header-table, .header-table TD, .header-table TH { background-color: #DDEEDD; color: black; border-width: 0px; font-family:sans-serif; font-weight:600; vertical-align:middle; } .TablesHeader { color: white; background-color: #000099; } .TableHeading { border-bottom: #000099 solid; } pre { border: solid 1px #666666; background-color: #f2f2f2; } .pre { border: solid 1px #666666; background-color: #f2f2f2; } pre2 { border: solid 1px #666666; background-color: #f2f2f2; } </STYLE><body><table cellpadding="10px" class="header-table" style="border-width: 5; border-color: #000099; border-style:solid;"><tr><td width="100px" /><td style="font-size:110%"> This report displays information about many different types of model objects. Click around and try the links. Notice the Diagram images at the bottom and how their tables are linked. The underlying stylesheet illustrates many ways to navigate the Model's XML data to produce a report. </td><td width="200px"><img src="images/ModelRight.gif" align="right" height="100px" /></td></tr></table><br /> <h1 class="TableHeading"><img src="images/model.gif" height="25" /> <a name="ID1">Sample OE/HR</a></h1><span class="CommonHeader">Author: </span>Val Patterson<br /><br /><span class="CommonHeader">Company: </span>ModelRight, Inc<br /><br /><span class="CommonHeader">Generated: </span>Fri Jun 06 07:32:33 2008<br /><br /><span class="CommonHeader">Table of Contents</span><h2><span onclick="toggle(TablesList,TableEC);"><img src="images/expand.gif" height="13" id="TableEC" /></span> <a href="#Tables"><img src="images/table.gif" /> Tables </a></h2><div id="TablesList" style="display: none;"><ul><li><a href="#ID798">CATEGORIES_TAB</a></li><li><a href="#ID510">COUNTRIES</a></li><li><a href="#ID858">CUSTOMERS</a></li><li><a href="#ID532">DEPARTMENTS</a></li><li><a href="#ID566">EMPLOYEES</a></li><li><a href="#ID969">INVENTORIES</a></li><li><a href="#ID676">JOB_HISTORY</a></li><li><a href="#ID649">JOBS</a></li><li><a href="#ID730">LOCATIONS</a></li><li><a href="#ID1062">ORDER_ITEMS</a></li><li><a href="#ID1004">ORDERS</a></li><li><a href="#ID1112">PRODUCT_DESCRIPTIONS</a></li><li><a href="#ID1150">PRODUCT_INFORMATION</a></li><li><a href="#ID1196">PROMOTIONS</a></li><li><a href="#ID1217">PURCHASEORDER</a></li><li><a href="#ID777">REGIONS</a></li><li><a href="#ID1259">WAREHOUSES</a></li></ul></div><h2><span onclick="toggle(ViewsList,ViewEC);"><img src="images/expand.gif" height="13" id="ViewEC" /></span> <a href="#Views"><img src="images/view.gif" /> Views </a></h2><div id="ViewsList" style="display: none;"><ul><li><a href="#ID1469">ACCOUNT_MANAGERS</a></li><li><a href="#ID1420">BOMBAY_INVENTORY</a></li><li><a href="#ID1491">CUSTOMERS_VIEW</a></li><li><a href="#ID1304">EMP_DETAILS_VIEW</a></li><li><a href="#ID1721">OC_CORPORATE_CUSTOMERS</a></li><li><a href="#ID1666">OC_CUSTOMERS</a></li><li><a href="#ID1600">OC_INVENTORIES</a></li><li><a href="#ID1779">OC_ORDERS</a></li><li><a href="#ID1618">OC_PRODUCT_INFORMATION</a></li><li><a href="#ID1572">ORDERS_VIEW</a></li><li><a href="#ID1452">PRODUCT_PRICES</a></li><li><a href="#ID1362">PRODUCTS</a></li><li><a href="#ID1404">SYDNEY_INVENTORY</a></li><li><a href="#ID1436">TORONTO_INVENTORY</a></li></ul></div><h2><span onclick="toggle(UDTypesList,UDTypeEC);"><img src="images/expand.gif" height="13" id="UDTypeEC" /></span> <a href="#UDTypes"><img src="images/type.gif" /> Types </a></h2><div id="UDTypesList" style="display: none;"><ul><li><a href="#ID401">ACTION_T</a></li><li><a href="#ID400">ACTION_V</a></li><li><a href="#ID395">ACTIONS_T</a></li><li><a href="#ID313">ANYDATA</a></li><li><a href="#ID314">ANYDATASET</a></li><li><a href="#ID312">ANYTYPE</a></li><li><a href="#ID272">BFILE</a></li><li><a href="#ID247">BIGINT</a></li><li><a href="#ID286">BINARY ROWID</a></li><li><a href="#ID277">BINARY_DOUBLE</a></li><li><a href="#ID278">BINARY_FLOAT</a></li><li><a href="#ID258">BLOB</a></li><li><a href="#ID287">CANONICAL</a></li><li><a href="#ID405">CATALOG_TYP</a></li><li><a href="#ID406">CATEGORY_TYP</a></li><li><a href="#ID288">CFILE</a></li><li><a href="#ID254">CHAR</a></li><li><a href="#ID253">CHARACTER</a></li><li><a href="#ID259">CLOB</a></li><li><a href="#ID411">COMPOSITE_CATEGORY_TYP</a></li><li><a href="#ID289">CONTIGUOUS ARRAY</a></li><li><a href="#ID414">CORPORATE_CUSTOMER_TYP</a></li><li><a href="#ID421">CUST_ADDRESS_TYP</a></li><li><a href="#ID416">CUSTOMER_TYP</a></li><li><a href="#ID267">DATALINK</a></li><li><a href="#ID240">DATE</a></li><li><a href="#ID261">DBCLOB</a></li><li><a href="#ID252">DECIMAL</a></li><li><a href="#ID250">DOUBLE</a></li><li><a href="#ID251">DOUBLE PRECISION</a></li><li><a href="#ID248">FLOAT</a></li><li><a href="#ID262">GRAPHIC</a></li><li><a href="#ID245">INT</a></li><li><a href="#ID246">INTEGER</a></li><li><a href="#ID269">INTERVAL DAY TO SECOND</a></li><li><a href="#ID268">INTERVAL YEAR TO MONTH</a></li><li><a href="#ID463">INVENTORY_LIST_TYP</a></li><li><a href="#ID464">INVENTORY_TYP</a></li><li><a href="#ID472">LEAF_CATEGORY_TYP</a></li><li><a href="#ID479">LINEITEM_T</a></li><li><a href="#ID478">LINEITEM_V</a></li><li><a href="#ID475">LINEITEMS_T</a></li><li><a href="#ID290">LOB POINTER</a></li><li><a href="#ID279">LONG</a></li><li><a href="#ID271">LONG RAW</a></li><li><a href="#ID257">LONG VARCHAR</a></li><li><a href="#ID264">LONG VARGRAPHIC</a></li><li><a href="#ID291">NAMED COLLECTION</a></li><li><a href="#ID292">NAMED OBJECT</a></li><li><a href="#ID255">NCHAR</a></li><li><a href="#ID260">NCLOB</a></li><li><a href="#ID239">NUMBER</a></li><li><a href="#ID238">NVARCHAR2</a></li><li><a href="#ID293">OCTET</a></li><li><a href="#ID294">OID</a></li><li><a href="#ID443">ORDER_ITEM_LIST_TYP</a></li><li><a href="#ID444">ORDER_ITEM_TYP</a></li><li><a href="#ID434">ORDER_LIST_TYP</a></li><li><a href="#ID435">ORDER_TYP</a></li><li><a href="#ID484">PART_T</a></li><li><a href="#ID428">PHONE_LIST_TYP</a></li><li><a href="#ID295">PL/SQL BINARY INTEGER</a></li><li><a href="#ID296">PL/SQL BOOLEAN</a></li><li><a href="#ID297">PL/SQL COLLECTION</a></li><li><a href="#ID298">PL/SQL LONG</a></li><li><a href="#ID299">PL/SQL LONG RAW</a></li><li><a href="#ID300">PL/SQL NATURAL</a></li><li><a href="#ID301">PL/SQL NATURALN</a></li><li><a href="#ID302">PL/SQL PLS INTEGER</a></li><li><a href="#ID303">PL/SQL POSITIVE</a></li><li><a href="#ID304">PL/SQL POSITIVEN</a></li><li><a href="#ID305">PL/SQL RECORD</a></li><li><a href="#ID306">PL/SQL REF CURSOR</a></li><li><a href="#ID307">PL/SQL ROWID</a></li><li><a href="#ID308">PL/SQL STRING</a></li><li><a href="#ID309">POINTER</a></li><li><a href="#ID450">PRODUCT_INFORMATION_TYP</a></li><li><a href="#ID474">PRODUCT_REF_LIST_TYP</a></li><li><a href="#ID489">PURCHASEORDER_T</a></li><li><a href="#ID270">RAW</a></li><li><a href="#ID249">REAL</a></li><li><a href="#ID273">REF</a></li><li><a href="#ID494">REJECTION_T</a></li><li><a href="#ID274">ROWID</a></li><li><a href="#ID908">SDO_ELEM_INFO_ARRAY</a></li><li><a href="#ID899">SDO_GEOMETRY</a></li><li><a href="#ID910">SDO_ORDINATE_ARRAY</a></li><li><a href="#ID903">SDO_POINT_TYPE</a></li><li><a href="#ID503">SHIPPING_INSTRUCTIONS_T</a></li><li><a href="#ID281">SIGNED BINARY INTEGER(16)</a></li><li><a href="#ID282">SIGNED BINARY INTEGER(32)</a></li><li><a href="#ID280">SIGNED BINARY INTEGER(8)</a></li><li><a href="#ID244">SMALLINT</a></li><li><a href="#ID413">SUBCATEGORY_REF_LIST_TYP</a></li><li><a href="#ID310">TABLE</a></li><li><a href="#ID265">TIME</a></li><li><a href="#ID266">TIME WITH TIME ZONE</a></li><li><a href="#ID241">TIMESTAMP</a></li><li><a href="#ID243">TIMESTAMP WITH LOCAL TIME ZONE</a></li><li><a href="#ID242">TIMESTAMP WITH TIME ZONE</a></li><li><a href="#ID284">UNSIGNED BINARY INTEGER(16)</a></li><li><a href="#ID285">UNSIGNED BINARY INTEGER(32)</a></li><li><a href="#ID283">UNSIGNED BINARY INTEGER(8)</a></li><li><a href="#ID275">UROWID</a></li><li><a href="#ID256">VARCHAR</a></li><li><a href="#ID237">VARCHAR2</a></li><li><a href="#ID263">VARGRAPHIC</a></li><li><a href="#ID311">VARYING ARRAY</a></li><li><a href="#ID467">WAREHOUSE_TYP</a></li><li><a href="#ID398">XDB$RAW_LIST_T</a></li><li><a href="#ID276">XMLTYPE</a></li></ul></div><h2><span onclick="toggle(TablespacesList,TablespacesEC);"><img src="images/expand.gif" height="13" id="TablespacesEC" /></span> <a href="#Tablespaces"><img src="images/tablespace.gif" /> Tablespaces </a></h2><div id="TablespacesList" style="display: none;"><ul><li><a href="#ID374">CONSTANT_GROW_INDEXES</a></li><li><a href="#ID377">CONSTANT_GROW_TABLES</a></li><li><a href="#ID380">DEPENDENCY_INDEXES</a></li><li><a href="#ID383">DEPENDENCY_TABLES</a></li><li><a href="#ID386">DIAGRAM_INDEXES</a></li><li><a href="#ID371">EXAMPLE</a></li><li><a href="#ID363">SYSAUX</a></li><li><a href="#ID357">SYSTEM</a></li><li><a href="#ID366">TEMP</a></li><li><a href="#ID360">UNDOTBS1</a></li><li><a href="#ID368">USERS</a></li></ul></div><h2><span onclick="toggle(ColumnDomainsList,ColumnDomainsEC);"><img src="images/expand.gif" height="13" id="ColumnDomainsEC" /></span> <a href="#ColumnDomains"><img src="images/column-domain.gif" /> Column Domains </a></h2><div id="ColumnDomainsList" style="display: none;"><ul><li><a href="#ID331">&lt;default&gt;</a></li></ul></div><h2><span onclick="toggle(DiagramsList,DiagramsEC);"><img src="images/expand.gif" height="13" id="DiagramsEC" /></span> <a href="#Diagrams"><img src="images/diagram.gif" /> Diagrams </a></h2><div id="DiagramsList" style="display: none;"><ul><li><a href="#ID319">OEHR.Diagram1</a></li><li><a href="#ID2069">OE.Diagram 1</a></li><li><a href="#ID2284">HR.Diagram 1</a></li></ul></div><h1><a id="Tables" name="Tables"><img src="images/table.gif" /> Tables</a></h1> <h4 class="TableHeading" xmlns=""><img src="images/table.gif" /> <a name="ID798">CATEGORIES_TAB</a></h4><table xmlns=""><tr><td width="200px"><span class="CommonHeader">ORGANIZATION: </span></td><td>HEAP</td></tr><tr><td width="200px"><span class="CommonHeader">Owner: </span></td><td><a href="#ID394"><img src="images/schema.gif" /> OE</a></td></tr><tr><td width="200px"><span class="CommonHeader">Generate: </span></td><td>True</td></tr><tr><td width="200px"><span class="CommonHeader">TABLESPACE: </span></td><td><a href="#ID368"><img src="images/tablespace.gif" /> USERS</a></td></tr></table><br xmlns="" /><img src="images/column.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Columns</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" align="center"> Is PK </th> <th class="TablesHeader" align="center"> Name </th><th class="TablesHeader"> Datatype </th><th class="TablesHeader" align="center"> Not Null </th><th class="TablesHeader" align="center"> FK Relations </th><th class="TablesHeader" align="center"> Parent Columns </th><th class="TablesHeader" align="center"> Child Columns </th><th class="TablesHeader" align="center"> In Keys </th><th class="TablesHeader" align="center"> Domain </th></tr> <tr> <td><img src="images/key-constraint.gif" height="15" />   </td><td valign="top"><a id="ID811" name="ID811">CATEGORY_ID</a></td> <td>NUMBER(2)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td>   </td> <td>   </td> <td>   </td> <td><a href="#ID853"><img src="images/key-constraint.gif" /> SYS_C005389</a><br /></td><td> </td></tr> <tr> <td>   </td><td valign="top"><a id="ID807" name="ID807">CATEGORY_NAME</a></td> <td>VARCHAR2(50)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td> </td></tr> <tr> <td>   </td><td valign="top"><a id="ID809" name="ID809">CATEGORY_DESCRIPTION</a></td> <td>VARCHAR2(1000)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td> </td></tr> <tr> <td>   </td><td valign="top"><a id="ID813" name="ID813">PARENT_CATEGORY_ID</a></td> <td>NUMBER(2)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td> </td></tr></table><br xmlns="" /><img src="images/index.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Indexes</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Tablespace </th><th class="TablesHeader" width="150px" align="center"> Associated Key </th><th class="TablesHeader" width="150px" align="center"> Members </th></tr> <tr> <td> <a name="ID817" id="ID817">SYS_C005389</a></td><td><a href="#ID368"><img src="images/tablespace.gif" /> USERS</a></td><td><a href="#ID853"><img src="images/key-constraint.gif" /> SYS_C005389</a></td><td><a href="#ID811"><img src="images/column.gif" /> CATEGORY_ID </a></td></tr></table><br xmlns="" /><img src="images/key-constraint.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Keys</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="50px" align="center"> Type </th><th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Associated Index </th><th class="TablesHeader" width="150px" align="center"> Members </th></tr> <tr> <td> <img src="images/key-constraint.gif" /> </td> <td valign="top"> <a id="ID853" name="ID853">SYS_C005389</a></td><td><a href="#ID817"><img src="images/index.gif" /> SYS_C005389</a></td><td><a href="#ID811"><img src="images/column.gif" /> CATEGORIES_TAB. CATEGORY_ID</a></td></tr></table><br xmlns="" /><img src="images/diagram.gif" height="15" xmlns="" /> <span class="CommonHeader" xmlns="">Appears in Diagrams</span><table border="2" xmlns=""> <tr> <th class="TablesHeader"> Diagram </th></tr> <tr> <td align="center"><a href="#ID319"><img src="images/802.jpg" border="0" /><br />OEHR.Diagram1</a></td></tr> <tr> <td align="center"><a href="#ID2069"><img src="images/2080.jpg" border="0" /><br />OE.Diagram 1</a></td></tr></table><br xmlns="" /><span class="CommonHeader" xmlns="">Create Script</span><TABLE BORDER="0" width="100%" xmlns=""><TD class="sqlcode" width="*"><pre>--- --- CREATE TABLE: CATEGORIES_TAB --- CREATE TABLE CATEGORIES_TAB OF CATEGORY_TYP ( CATEGORY_ID NOT NULL, PRIMARY KEY (CATEGORY_ID) ) OBJECT IDENTIFIER IS SYSTEM GENERATED TABLESPACE USERS ; </pre></TD></TABLE> <h4 class="TableHeading" xmlns=""><img src="images/table.gif" /> <a name="ID510">COUNTRIES</a></h4><p width="80%" xmlns=""><pre><h5>country table. Contains 25 rows. References with locations table.</h5></pre></p><table xmlns=""><tr><td width="200px"><span class="CommonHeader">ORGANIZATION: </span></td><td>INDEX</td></tr><tr><td width="200px"><span class="CommonHeader">Owner: </span></td><td><a href="#ID390"><img src="images/schema.gif" /> HR</a></td></tr><tr><td width="200px"><span class="CommonHeader">Generate: </span></td><td>True</td></tr></table><br xmlns="" /><img src="images/column.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Columns</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" align="center"> Is PK </th> <th class="TablesHeader" align="center"> Name </th><th class="TablesHeader"> Datatype </th><th class="TablesHeader" align="center"> Not Null </th><th class="TablesHeader" align="center"> FK Relations </th><th class="TablesHeader" align="center"> Parent Columns </th><th class="TablesHeader" align="center"> Child Columns </th><th class="TablesHeader" align="center"> In Keys </th><th class="TablesHeader" align="center"> Domain </th></tr> <tr> <td><img src="images/key-constraint.gif" height="15" />   </td><td valign="top"><a id="ID520" name="ID520">COUNTRY_ID</a></td> <td>CHAR(2)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td>   </td> <td>   </td> <td><a href="#ID749"><img src="images/column.gif" /> LOCATIONS . COUNTRY_ID</a></td> <td><a href="#ID515"><img src="images/key-constraint.gif" /> COUNTRY_C_ID_PK</a><br /></td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID524" name="ID524">COUNTRY_NAME</a></td> <td>VARCHAR2(40)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID526" name="ID526">REGION_ID</a></td> <td><a href="#ID239"><img src="images/type.gif" /> NUMBER</a></td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td><a href="#ID529"><img src="images/relation.gif" /> COUNTR_REG_FK</a></td> <td><a href="#ID782"><img src="images/column.gif" /> REGIONS.REGION_ID</a></td> <td>   </td> <td>   </td><td><a href="#ID782"><img src="images/column.gif" /> REGION_ID</a></td></tr></table><br xmlns="" /><img src="images/index.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Indexes</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Tablespace </th><th class="TablesHeader" width="150px" align="center"> Associated Key </th><th class="TablesHeader" width="150px" align="center"> Members </th></tr> <tr> <td> <a name="ID516" id="ID516">COUNTRY_C_ID_PK</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td><a href="#ID515"><img src="images/key-constraint.gif" /> COUNTRY_C_ID_PK</a></td><td><a href="#ID520"><img src="images/column.gif" /> COUNTRY_ID </a></td></tr></table><br xmlns="" /><img src="images/key-constraint.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Keys</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="50px" align="center"> Type </th><th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Associated Index </th><th class="TablesHeader" width="150px" align="center"> Members </th></tr> <tr> <td> <img src="images/key-constraint.gif" /> </td> <td valign="top"> <a id="ID515" name="ID515">COUNTRY_C_ID_PK</a></td><td><a href="#ID516"><img src="images/index.gif" /> COUNTRY_C_ID_PK</a></td><td><a href="#ID520"><img src="images/column.gif" /> COUNTRIES. COUNTRY_ID</a></td></tr></table><br xmlns="" /><img src="images/relation.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Relations</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Delete Rule </th><th class="TablesHeader" width="150px" align="center"> Parent Table </th><th class="TablesHeader" width="150px" align="center"> Parent Columns </th><th class="TablesHeader" width="150px" align="center"> Child Columns </th></tr> <tr> <td> <a name="ID529" id="ID529">COUNTR_REG_FK</a></td><td> No Action</td><td><a href="#ID777"><img src="images/table.gif" /> REGIONS</a></td><td><a href="#ID782"><img src="images/column.gif" /> REGIONS.REGION_ID</a><br /></td><td><a href="#ID526"><img src="images/column.gif" /> REGION_ID</a><br /></td></tr></table><br xmlns="" /><img src="images/diagram.gif" height="15" xmlns="" /> <span class="CommonHeader" xmlns="">Appears in Diagrams</span><table border="2" xmlns=""> <tr> <th class="TablesHeader"> Diagram </th></tr> <tr> <td align="center"><a href="#ID319"><img src="images/514.jpg" border="0" /><br />OEHR.Diagram1</a></td></tr> <tr> <td align="center"><a href="#ID2284"><img src="images/2285.jpg" border="0" /><br />HR.Diagram 1</a></td></tr></table><br xmlns="" /><span class="CommonHeader" xmlns="">Create Script</span><TABLE BORDER="0" width="100%" xmlns=""><TD class="sqlcode" width="*"><pre>--- --- CREATE TABLE: COUNTRIES --- CREATE TABLE COUNTRIES ( COUNTRY_ID CHAR(2) CONSTRAINT COUNTRY_ID_NN CHECK ("COUNTRY_ID" IS NOT NULL) NOT NULL, COUNTRY_NAME VARCHAR2(40), REGION_ID NUMBER NOT NULL, PRIMARY KEY (COUNTRY_ID) ) ORGANIZATION INDEX TABLESPACE EXAMPLE ; COMMENT ON TABLE COUNTRIES IS 'country table. Contains 25 rows. References with locations table.'; COMMENT ON COLUMN COUNTRIES.COUNTRY_ID IS 'Primary key of countries table.'; COMMENT ON COLUMN COUNTRIES.COUNTRY_NAME IS 'Country name'; COMMENT ON COLUMN COUNTRIES.REGION_ID IS 'Region ID for the country. Foreign key to region_id column in the departments table.'; --- --- CREATE FOREIGN KEY CONSTRAINT: COUNTR_REG_FK --- ALTER TABLE COUNTRIES ADD FOREIGN KEY (REGION_ID) REFERENCES REGIONS (REGION_ID) ; </pre></TD></TABLE> <h4 class="TableHeading" xmlns=""><img src="images/table.gif" /> <a name="ID858">CUSTOMERS</a></h4><p width="80%" xmlns=""><pre><h5>Contains customers data either entered by an employee or by the customer him/herself over the Web.</h5></pre></p><table xmlns=""><tr><td width="200px"><span class="CommonHeader">ORGANIZATION: </span></td><td>HEAP</td></tr><tr><td width="200px"><span class="CommonHeader">Owner: </span></td><td><a href="#ID394"><img src="images/schema.gif" /> OE</a></td></tr><tr><td width="200px"><span class="CommonHeader">Generate: </span></td><td>True</td></tr><tr><td width="200px"><span class="CommonHeader">TABLESPACE: </span></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td></tr></table><br xmlns="" /><img src="images/column.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Columns</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" align="center"> Is PK </th> <th class="TablesHeader" align="center"> Name </th><th class="TablesHeader"> Datatype </th><th class="TablesHeader" align="center"> Not Null </th><th class="TablesHeader" align="center"> FK Relations </th><th class="TablesHeader" align="center"> Parent Columns </th><th class="TablesHeader" align="center"> Child Columns </th><th class="TablesHeader" align="center"> In Keys </th><th class="TablesHeader" align="center"> Domain </th></tr> <tr> <td><img src="images/key-constraint.gif" height="15" />   </td><td valign="top"><a id="ID863" name="ID863">CUSTOMER_ID</a></td> <td>NUMBER(6)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td>   </td> <td>   </td> <td><a href="#ID1019"><img src="images/column.gif" /> ORDERS . CUSTOMER_ID</a></td> <td><a href="#ID964"><img src="images/key-constraint.gif" /> CUSTOMERS_PK</a><br /></td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID867" name="ID867">CUST_FIRST_NAME</a></td> <td>VARCHAR2(20)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID871" name="ID871">CUST_LAST_NAME</a></td> <td>VARCHAR2(20)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID875" name="ID875">CUST_ADDRESS</a></td> <td><a href="#ID421"><img src="images/type.gif" /> CUST_ADDRESS_TYP</a></td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID882" name="ID882">PHONE_NUMBERS</a></td> <td><a href="#ID428"><img src="images/type.gif" /> PHONE_LIST_TYP</a></td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID886" name="ID886">NLS_LANGUAGE</a></td> <td>VARCHAR2(3)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID888" name="ID888">NLS_TERRITORY</a></td> <td>VARCHAR2(30)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID890" name="ID890">CREDIT_LIMIT</a></td> <td>NUMBER(9,2)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID892" name="ID892">CUST_EMAIL</a></td> <td>VARCHAR2(30)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID894" name="ID894">ACCOUNT_MGR_ID</a></td> <td>NUMBER(6)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td><a href="#ID959"><img src="images/relation.gif" /> CUSTOMERS_ACCOUNT_MANAGER_FK</a></td> <td><a href="#ID571"><img src="images/column.gif" /> EMPLOYEES.EMPLOYEE_ID</a></td> <td>   </td> <td>   </td><td><a href="#ID571"><img src="images/column.gif" /> EMPLOYEE_ID</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID896" name="ID896">CUST_GEO_LOCATION</a></td> <td><a href="#ID899"><img src="images/type.gif" /> SDO_GEOMETRY</a></td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID923" name="ID923">DATE_OF_BIRTH</a></td> <td><a href="#ID240"><img src="images/type.gif" /> DATE</a></td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID925" name="ID925">MARITAL_STATUS</a></td> <td>VARCHAR2(20)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID927" name="ID927">GENDER</a></td> <td>VARCHAR2(1)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID929" name="ID929">INCOME_LEVEL</a></td> <td>VARCHAR2(20)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr></table><br xmlns="" /><img src="images/index.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Indexes</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Tablespace </th><th class="TablesHeader" width="150px" align="center"> Associated Key </th><th class="TablesHeader" width="150px" align="center"> Members </th></tr> <tr> <td> <a name="ID931" id="ID931">CUST_UPPER_NAME_IX</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td /><td><a href="#"> </a><br /><a href="#"> </a></td></tr> <tr> <td> <a name="ID939" id="ID939">CUSTOMERS_PK</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td><a href="#ID964"><img src="images/key-constraint.gif" /> CUSTOMERS_PK</a></td><td><a href="#ID863"><img src="images/column.gif" /> CUSTOMER_ID </a></td></tr> <tr> <td> <a name="ID944" id="ID944">CUST_ACCOUNT_MANAGER_IX</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td><a href="#ID959"><img src="images/relation.gif" /> CUSTOMERS_ACCOUNT_MANAGER_FK</a></td><td><a href="#ID894"><img src="images/column.gif" /> ACCOUNT_MGR_ID </a></td></tr> <tr> <td> <a name="ID949" id="ID949">CUST_LNAME_IX</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td /><td><a href="#ID871"><img src="images/column.gif" /> CUST_LAST_NAME </a></td></tr> <tr> <td> <a name="ID954" id="ID954">CUST_EMAIL_IX</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td /><td><a href="#ID892"><img src="images/column.gif" /> CUST_EMAIL </a></td></tr></table><br xmlns="" /><img src="images/key-constraint.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Keys</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="50px" align="center"> Type </th><th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Associated Index </th><th class="TablesHeader" width="150px" align="center"> Members </th></tr> <tr> <td> <img src="images/key-constraint.gif" /> </td> <td valign="top"> <a id="ID964" name="ID964">CUSTOMERS_PK</a></td><td><a href="#ID939"><img src="images/index.gif" /> CUSTOMERS_PK</a></td><td><a href="#ID863"><img src="images/column.gif" /> CUSTOMERS. CUSTOMER_ID</a></td></tr></table><br xmlns="" /><img src="images/relation.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Relations</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Delete Rule </th><th class="TablesHeader" width="150px" align="center"> Parent Table </th><th class="TablesHeader" width="150px" align="center"> Parent Columns </th><th class="TablesHeader" width="150px" align="center"> Child Columns </th></tr> <tr> <td> <a name="ID959" id="ID959">CUSTOMERS_ACCOUNT_MANAGER_FK</a></td><td> Set Null</td><td><a href="#ID566"><img src="images/table.gif" /> EMPLOYEES</a></td><td><a href="#ID571"><img src="images/column.gif" /> EMPLOYEES.EMPLOYEE_ID</a><br /></td><td><a href="#ID894"><img src="images/column.gif" /> ACCOUNT_MGR_ID</a><br /></td></tr></table><br xmlns="" /><img src="images/diagram.gif" height="15" xmlns="" /> <span class="CommonHeader" xmlns="">Appears in Diagrams</span><table border="2" xmlns=""> <tr> <th class="TablesHeader"> Diagram </th></tr> <tr> <td align="center"><a href="#ID319"><img src="images/862.jpg" border="0" /><br />OEHR.Diagram1</a></td></tr> <tr> <td align="center"><a href="#ID2069"><img src="images/2085.jpg" border="0" /><br />OE.Diagram 1</a></td></tr></table><br xmlns="" /><span class="CommonHeader" xmlns="">Create Script</span><TABLE BORDER="0" width="100%" xmlns=""><TD class="sqlcode" width="*"><pre>--- --- CREATE TABLE: CUSTOMERS --- CREATE TABLE CUSTOMERS ( CUSTOMER_ID NUMBER(6) NOT NULL, CUST_FIRST_NAME VARCHAR2(20) CONSTRAINT CUST_FNAME_NN NOT NULL, CUST_LAST_NAME VARCHAR2(20) CONSTRAINT CUST_LNAME_NN NOT NULL, CUST_ADDRESS CUST_ADDRESS_TYP, PHONE_NUMBERS PHONE_LIST_TYP, NLS_LANGUAGE VARCHAR2(3), NLS_TERRITORY VARCHAR2(30), CREDIT_LIMIT NUMBER(9,2), CUST_EMAIL VARCHAR2(30), ACCOUNT_MGR_ID NUMBER(6) NOT NULL, CUST_GEO_LOCATION SDO_GEOMETRY, DATE_OF_BIRTH DATE, MARITAL_STATUS VARCHAR2(20), GENDER VARCHAR2(1), INCOME_LEVEL VARCHAR2(20), PRIMARY KEY (CUSTOMER_ID), CONSTRAINT CUSTOMER_ID_MIN CHECK (customer_id &gt; 0), CONSTRAINT CUSTOMER_CREDIT_LIMIT_MAX CHECK (credit_limit &lt;= 5000) ) TABLESPACE EXAMPLE ; COMMENT ON TABLE CUSTOMERS IS 'Contains customers data either entered by an employee or by the customer him/herself over the Web.'; COMMENT ON COLUMN CUSTOMERS.CUSTOMER_ID IS 'Primary key column.'; COMMENT ON COLUMN CUSTOMERS.CUST_FIRST_NAME IS 'NOT NULL constraint.'; COMMENT ON COLUMN CUSTOMERS.CUST_LAST_NAME IS 'NOT NULL constraint.'; COMMENT ON COLUMN CUSTOMERS.CUST_ADDRESS IS 'Object column of type address_typ.'; COMMENT ON COLUMN CUSTOMERS.PHONE_NUMBERS IS 'Varray column of type phone_list_typ'; COMMENT ON COLUMN CUSTOMERS.CREDIT_LIMIT IS 'Check constraint.'; COMMENT ON COLUMN CUSTOMERS.ACCOUNT_MGR_ID IS 'References hr.employees.employee_id.'; COMMENT ON COLUMN CUSTOMERS.CUST_GEO_LOCATION IS 'SDO (spatial) column.'; --- --- CREATE INDEX: CUST_UPPER_NAME_IX --- CREATE INDEX CUST_UPPER_NAME_IX ON CUSTOMERS ( UPPER("CUST_LAST_NAME"), UPPER("CUST_FIRST_NAME") ) TABLESPACE EXAMPLE ; --- --- CREATE INDEX: CUST_ACCOUNT_MANAGER_IX --- CREATE INDEX CUST_ACCOUNT_MANAGER_IX ON CUSTOMERS ( ACCOUNT_MGR_ID ) TABLESPACE EXAMPLE ; --- --- CREATE INDEX: CUST_LNAME_IX --- CREATE INDEX CUST_LNAME_IX ON CUSTOMERS ( CUST_LAST_NAME ) TABLESPACE EXAMPLE ; --- --- CREATE INDEX: CUST_EMAIL_IX --- CREATE INDEX CUST_EMAIL_IX ON CUSTOMERS ( CUST_EMAIL ) TABLESPACE EXAMPLE ; --- --- CREATE FOREIGN KEY CONSTRAINT: CUSTOMERS_ACCOUNT_MANAGER_FK --- ALTER TABLE CUSTOMERS ADD FOREIGN KEY (ACCOUNT_MGR_ID) REFERENCES EMPLOYEES (EMPLOYEE_ID) ON DELETE SET NULL ; </pre></TD></TABLE> <h4 class="TableHeading" xmlns=""><img src="images/table.gif" /> <a name="ID532">DEPARTMENTS</a></h4><p width="80%" xmlns=""><pre><h5>Departments table that shows details of departments where employees work. Contains 27 rows; references with locations, employees, and job_history tables.</h5></pre></p><table xmlns=""><tr><td width="200px"><span class="CommonHeader">ORGANIZATION: </span></td><td>HEAP</td></tr><tr><td width="200px"><span class="CommonHeader">Owner: </span></td><td><a href="#ID390"><img src="images/schema.gif" /> HR</a></td></tr><tr><td width="200px"><span class="CommonHeader">Generate: </span></td><td>True</td></tr><tr><td width="200px"><span class="CommonHeader">TABLESPACE: </span></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td></tr></table><br xmlns="" /><img src="images/column.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Columns</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" align="center"> Is PK </th> <th class="TablesHeader" align="center"> Name </th><th class="TablesHeader"> Datatype </th><th class="TablesHeader" align="center"> Not Null </th><th class="TablesHeader" align="center"> FK Relations </th><th class="TablesHeader" align="center"> Parent Columns </th><th class="TablesHeader" align="center"> Child Columns </th><th class="TablesHeader" align="center"> In Keys </th><th class="TablesHeader" align="center"> Domain </th></tr> <tr> <td><img src="images/key-constraint.gif" height="15" />   </td><td valign="top"><a id="ID537" name="ID537">DEPARTMENT_ID</a></td> <td>NUMBER(4)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td>   </td> <td>   </td> <td><a href="#ID601"><img src="images/column.gif" /> EMPLOYEES . DEPARTMENT_ID</a><br /><a href="#ID697"><img src="images/column.gif" /> JOB_HISTORY . DEPARTMENT_ID</a></td> <td><a href="#ID561"><img src="images/key-constraint.gif" /> DEPT_ID_PK</a><br /></td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID541" name="ID541">DEPARTMENT_NAME</a></td> <td>VARCHAR2(30)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID545" name="ID545">MANAGER_ID</a></td> <td>NUMBER(6)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td><a href="#ID560"><img src="images/relation.gif" /> DEPT_MGR_FK</a></td> <td><a href="#ID571"><img src="images/column.gif" /> EMPLOYEES.EMPLOYEE_ID</a></td> <td>   </td> <td>   </td><td><a href="#ID571"><img src="images/column.gif" /> EMPLOYEE_ID</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID547" name="ID547">LOCATION_ID</a></td> <td>NUMBER(4)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td><a href="#ID559"><img src="images/relation.gif" /> DEPT_LOC_FK</a></td> <td><a href="#ID735"><img src="images/column.gif" /> LOCATIONS.LOCATION_ID</a></td> <td>   </td> <td>   </td><td><a href="#ID735"><img src="images/column.gif" /> LOCATION_ID</a></td></tr></table><br xmlns="" /><img src="images/index.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Indexes</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Tablespace </th><th class="TablesHeader" width="150px" align="center"> Associated Key </th><th class="TablesHeader" width="150px" align="center"> Members </th></tr> <tr> <td> <a name="ID549" id="ID549">DEPT_ID_PK</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td><a href="#ID561"><img src="images/key-constraint.gif" /> DEPT_ID_PK</a></td><td><a href="#ID537"><img src="images/column.gif" /> DEPARTMENT_ID </a></td></tr> <tr> <td> <a name="ID554" id="ID554">DEPT_LOCATION_IX</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td><a href="#ID559"><img src="images/relation.gif" /> DEPT_LOC_FK</a></td><td><a href="#ID547"><img src="images/column.gif" /> LOCATION_ID </a></td></tr></table><br xmlns="" /><img src="images/key-constraint.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Keys</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="50px" align="center"> Type </th><th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Associated Index </th><th class="TablesHeader" width="150px" align="center"> Members </th></tr> <tr> <td> <img src="images/key-constraint.gif" /> </td> <td valign="top"> <a id="ID561" name="ID561">DEPT_ID_PK</a></td><td><a href="#ID549"><img src="images/index.gif" /> DEPT_ID_PK</a></td><td><a href="#ID537"><img src="images/column.gif" /> DEPARTMENTS. DEPARTMENT_ID</a></td></tr></table><br xmlns="" /><img src="images/relation.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Relations</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Delete Rule </th><th class="TablesHeader" width="150px" align="center"> Parent Table </th><th class="TablesHeader" width="150px" align="center"> Parent Columns </th><th class="TablesHeader" width="150px" align="center"> Child Columns </th></tr> <tr> <td> <a name="ID559" id="ID559">DEPT_LOC_FK</a></td><td> No Action</td><td><a href="#ID730"><img src="images/table.gif" /> LOCATIONS</a></td><td><a href="#ID735"><img src="images/column.gif" /> LOCATIONS.LOCATION_ID</a><br /></td><td><a href="#ID547"><img src="images/column.gif" /> LOCATION_ID</a><br /></td></tr> <tr> <td> <a name="ID560" id="ID560">DEPT_MGR_FK</a></td><td> No Action</td><td><a href="#ID566"><img src="images/table.gif" /> EMPLOYEES</a></td><td><a href="#ID571"><img src="images/column.gif" /> EMPLOYEES.EMPLOYEE_ID</a><br /></td><td><a href="#ID545"><img src="images/column.gif" /> MANAGER_ID</a><br /></td></tr></table><br xmlns="" /><img src="images/diagram.gif" height="15" xmlns="" /> <span class="CommonHeader" xmlns="">Appears in Diagrams</span><table border="2" xmlns=""> <tr> <th class="TablesHeader"> Diagram </th></tr> <tr> <td align="center"><a href="#ID319"><img src="images/536.jpg" border="0" /><br />OEHR.Diagram1</a></td></tr> <tr> <td align="center"><a href="#ID2284"><img src="images/2289.jpg" border="0" /><br />HR.Diagram 1</a></td></tr></table><br xmlns="" /><span class="CommonHeader" xmlns="">Create Script</span><TABLE BORDER="0" width="100%" xmlns=""><TD class="sqlcode" width="*"><pre>--- --- CREATE TABLE: DEPARTMENTS --- CREATE TABLE DEPARTMENTS ( DEPARTMENT_ID NUMBER(4) NOT NULL, DEPARTMENT_NAME VARCHAR2(30) CONSTRAINT DEPT_NAME_NN NOT NULL, MANAGER_ID NUMBER(6) NOT NULL, LOCATION_ID NUMBER(4) NOT NULL, PRIMARY KEY (DEPARTMENT_ID) ) TABLESPACE EXAMPLE ; COMMENT ON TABLE DEPARTMENTS IS 'Departments table that shows details of departments where employees work. Contains 27 rows; references with locations, employees, and job_history tables.'; COMMENT ON COLUMN DEPARTMENTS.DEPARTMENT_ID IS 'Primary key column of departments table.'; COMMENT ON COLUMN DEPARTMENTS.DEPARTMENT_NAME IS 'A not null column that shows name of a department. Administration, Marketing, Purchasing, Human Resources, Shipping, IT, Executive, Public Relations, Sales, Finance, and Accounting. '; COMMENT ON COLUMN DEPARTMENTS.MANAGER_ID IS 'Manager_id of a department. Foreign key to employee_id column of employees table. The manager_id column of the employee table references this column.'; COMMENT ON COLUMN DEPARTMENTS.LOCATION_ID IS 'Location id where a department is located. Foreign key to location_id column of locations table.'; --- --- CREATE INDEX: DEPT_LOCATION_IX --- CREATE INDEX DEPT_LOCATION_IX ON DEPARTMENTS ( LOCATION_ID ) TABLESPACE EXAMPLE ; --- --- CREATE FOREIGN KEY CONSTRAINT: DEPT_LOC_FK --- ALTER TABLE DEPARTMENTS ADD FOREIGN KEY (LOCATION_ID) REFERENCES LOCATIONS (LOCATION_ID) ; --- --- CREATE FOREIGN KEY CONSTRAINT: DEPT_MGR_FK --- ALTER TABLE DEPARTMENTS ADD FOREIGN KEY (MANAGER_ID) REFERENCES EMPLOYEES (EMPLOYEE_ID) ; </pre></TD></TABLE> <h4 class="TableHeading" xmlns=""><img src="images/table.gif" /> <a name="ID566">EMPLOYEES</a></h4><p width="80%" xmlns=""><pre><h5>employees table. Contains 107 rows. References with departments, jobs, job_history tables. Contains a self reference.</h5></pre></p><table xmlns=""><tr><td width="200px"><span class="CommonHeader">ORGANIZATION: </span></td><td>HEAP</td></tr><tr><td width="200px"><span class="CommonHeader">Owner: </span></td><td><a href="#ID390"><img src="images/schema.gif" /> HR</a></td></tr><tr><td width="200px"><span class="CommonHeader">Generate: </span></td><td>True</td></tr><tr><td width="200px"><span class="CommonHeader">TABLESPACE: </span></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td></tr></table><br xmlns="" /><img src="images/column.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Columns</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" align="center"> Is PK </th> <th class="TablesHeader" align="center"> Name </th><th class="TablesHeader"> Datatype </th><th class="TablesHeader" align="center"> Not Null </th><th class="TablesHeader" align="center"> FK Relations </th><th class="TablesHeader" align="center"> Parent Columns </th><th class="TablesHeader" align="center"> Child Columns </th><th class="TablesHeader" align="center"> In Keys </th><th class="TablesHeader" align="center"> Domain </th></tr> <tr> <td><img src="images/key-constraint.gif" height="15" />   </td><td valign="top"><a id="ID571" name="ID571">EMPLOYEE_ID</a></td> <td>NUMBER(6)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td>   </td> <td>   </td> <td><a href="#ID545"><img src="images/column.gif" /> DEPARTMENTS . MANAGER_ID</a><br /><a href="#ID599"><img src="images/column.gif" /> EMPLOYEES . MANAGER_ID</a><br /><a href="#ID681"><img src="images/column.gif" /> JOB_HISTORY . EMPLOYEE_ID</a><br /><a href="#ID894"><img src="images/column.gif" /> CUSTOMERS . ACCOUNT_MGR_ID</a><br /><a href="#ID1027"><img src="images/column.gif" /> ORDERS . SALES_REP_ID</a></td> <td><a href="#ID639"><img src="images/key-constraint.gif" /> EMP_EMP_ID_PK</a><br /></td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID575" name="ID575">FIRST_NAME</a></td> <td>VARCHAR2(20)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID577" name="ID577">LAST_NAME</a></td> <td>VARCHAR2(25)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID581" name="ID581">EMAIL</a></td> <td>VARCHAR2(25)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td>   </td> <td>   </td> <td>   </td> <td><a href="#ID644"><img src="images/key-constraint.gif" /> EMP_EMAIL_UK</a><br /></td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID585" name="ID585">PHONE_NUMBER</a></td> <td>VARCHAR2(20)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID587" name="ID587">HIRE_DATE</a></td> <td><a href="#ID240"><img src="images/type.gif" /> DATE</a></td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID591" name="ID591">JOB_ID</a></td> <td>VARCHAR2(10)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td><a href="#ID635"><img src="images/relation.gif" /> EMP_JOB_FK</a></td> <td><a href="#ID654"><img src="images/column.gif" /> JOBS.JOB_ID</a></td> <td>   </td> <td>   </td><td><a href="#ID654"><img src="images/column.gif" /> JOB_ID</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID595" name="ID595">SALARY</a></td> <td>NUMBER(8,2)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID597" name="ID597">COMMISSION_PCT</a></td> <td>NUMBER(2,2)</td> <td align="center">   </td> <td>   </td> <td>   </td> <td>   </td> <td>   </td><td><a href="#ID331"><img src="images/column-domain.gif" /> &lt;default&gt;</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID599" name="ID599">MANAGER_ID</a></td> <td>NUMBER(6)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td><a href="#ID636"><img src="images/relation.gif" /> EMP_MANAGER_FK</a></td> <td><a href="#ID571"><img src="images/column.gif" /> EMPLOYEES.EMPLOYEE_ID</a></td> <td>   </td> <td>   </td><td><a href="#ID571"><img src="images/column.gif" /> EMPLOYEE_ID</a></td></tr> <tr> <td>   </td><td valign="top"><a id="ID601" name="ID601">DEPARTMENT_ID</a></td> <td>NUMBER(4)</td> <td align="center"> <img src="images/check.gif" height="15" />   </td> <td><a href="#ID634"><img src="images/relation.gif" /> EMP_DEPT_FK</a></td> <td><a href="#ID537"><img src="images/column.gif" /> DEPARTMENTS.DEPARTMENT_ID</a></td> <td>   </td> <td>   </td><td><a href="#ID537"><img src="images/column.gif" /> DEPARTMENT_ID</a></td></tr></table><br xmlns="" /><img src="images/index.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Indexes</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Tablespace </th><th class="TablesHeader" width="150px" align="center"> Associated Key </th><th class="TablesHeader" width="150px" align="center"> Members </th></tr> <tr> <td> <a name="ID603" id="ID603">EMP_EMAIL_UK</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td><a href="#ID644"><img src="images/key-constraint.gif" /> EMP_EMAIL_UK</a></td><td><a href="#ID581"><img src="images/column.gif" /> EMAIL </a></td></tr> <tr> <td> <a name="ID608" id="ID608">EMP_EMP_ID_PK</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td><a href="#ID639"><img src="images/key-constraint.gif" /> EMP_EMP_ID_PK</a></td><td><a href="#ID571"><img src="images/column.gif" /> EMPLOYEE_ID </a></td></tr> <tr> <td> <a name="ID613" id="ID613">EMP_DEPARTMENT_IX</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td><a href="#ID634"><img src="images/relation.gif" /> EMP_DEPT_FK</a></td><td><a href="#ID601"><img src="images/column.gif" /> DEPARTMENT_ID </a></td></tr> <tr> <td> <a name="ID618" id="ID618">EMP_JOB_IX</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td><a href="#ID635"><img src="images/relation.gif" /> EMP_JOB_FK</a></td><td><a href="#ID591"><img src="images/column.gif" /> JOB_ID </a></td></tr> <tr> <td> <a name="ID623" id="ID623">EMP_MANAGER_IX</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td><a href="#ID636"><img src="images/relation.gif" /> EMP_MANAGER_FK</a></td><td><a href="#ID599"><img src="images/column.gif" /> MANAGER_ID </a></td></tr> <tr> <td> <a name="ID628" id="ID628">EMP_NAME_IX</a></td><td><a href="#ID371"><img src="images/tablespace.gif" /> EXAMPLE</a></td><td /><td><a href="#ID577"><img src="images/column.gif" /> LAST_NAME </a><br /><a href="#ID575"><img src="images/column.gif" /> FIRST_NAME </a></td></tr></table><br xmlns="" /><img src="images/key-constraint.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Keys</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="50px" align="center"> Type </th><th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Associated Index </th><th class="TablesHeader" width="150px" align="center"> Members </th></tr> <tr> <td> <img src="images/key-constraint.gif" /> </td> <td valign="top"> <a id="ID639" name="ID639">EMP_EMP_ID_PK</a></td><td><a href="#ID608"><img src="images/index.gif" /> EMP_EMP_ID_PK</a></td><td><a href="#ID571"><img src="images/column.gif" /> EMPLOYEES. EMPLOYEE_ID</a></td></tr> <tr> <td> <img src="images/key-constraint.gif" /> </td> <td valign="top"> <a id="ID644" name="ID644">EMP_EMAIL_UK</a></td><td><a href="#ID603"><img src="images/index.gif" /> EMP_EMAIL_UK</a></td><td><a href="#ID581"><img src="images/column.gif" /> EMPLOYEES. EMAIL</a></td></tr></table><br xmlns="" /><img src="images/relation.gif" xmlns="" /> <span class="CommonHeader" xmlns="">Relations</span><table border="2" xmlns=""> <tr> <th class="TablesHeader" width="150px" align="center"> Name </th><th class="TablesHeader" width="150px" align="center"> Delete Rule </th><th class="TablesHeader" width="150px" align="center"> Parent Table </th><th class="TablesHeader" width="150px" align="center"> Parent Columns </th><th class="TablesHeader" width="150px" align="center"> Child Columns </th></tr> <tr> <td> <a name="ID634" id="ID634">EMP_DEPT_FK</a></td><td> No Action</td><td><a href="#ID532"><img src="images/table.gif" /> DEPARTMENTS</a></td><td><a href="#ID537"><img src="images/column.gif" /> DEPARTMENTS.DEPARTMENT_ID</a><br /></td><td><a href="#ID601"><img src="images/column.gif" /> DEPARTMENT_ID</a><br /></td></tr> <tr> <td> <a name="ID635" id="ID635">EMP_JOB_FK</a></td><td> No Action</td><td><a href="#ID649"><img src="images/table.gif" /> JOBS</a></td><td><a href="#ID654"><img src="images/column.gif" /> JOBS.JOB_ID</a><br /></td><td><a href="#ID591"><img src="images/column.gif" /> JOB_ID</a><br /></td></tr> <tr> <td> <a name="ID636" id="ID636">EMP_MANAGER_FK</a></td><td> No Action</td><td><a href="#ID566"><img src="images/table.gif" /> EMPLOYEES</a></td><td><a href="#ID571"><img src="images/column.gif" /> EMPLOYEES.EMPLOYEE_ID</a><br /></td><td><a href="#ID599"><img src="images/column.gif" /> MANAGER_ID</a><br /></td></tr></table><br xmlns="" /><img src="images/diagram.gif" height="15" xmlns="" /> <span class="CommonHeader" xmlns="">Appears in Diagrams</span><table border="2" xmlns=""> <tr> <th class="TablesHeader"> Diagram </th></tr> <tr> <td align="center"><a href="#ID319"><img src="images/570.jpg" border="0" /><br />OEHR.Diagram1</a></td></tr> <tr> <td align="center"><a href="#ID2284"><img src="images/2294.jpg" border="0" /><br />HR.Diagram 1</a></td></tr></table><br xmlns="" /><span class="CommonHeader" xmlns="">Create Script</span><TABLE BORDER="0" width="100%" xmlns=""><TD class="sqlcode" width="*"><pre>--- --- CREATE TABLE: EMPLOYEES --- CREATE TABLE EMPLOYEES ( EMPLOYEE_ID NUMBER(6) NOT NULL, FIRST_NAME VARCHAR2(20), LAST_NAME VARCHAR2(25) CONSTRAINT EMP_LAST_NAME_NN NOT NULL, EMAIL VARCHAR2(25) CONSTRAINT EMP_EMAIL_NN NOT NULL, PHONE_NUMBER VARCHAR2(20), HIRE_DATE DATE CONSTRAINT EMP_HIRE_DATE_NN NOT NULL, JOB_ID VARCHAR2(10) NOT NULL, SALARY NUMBER(8,2), COMMISSION_PCT NUMBER(2,2), MANAGER_ID NUMBER(6) NOT NULL, DEPARTMENT_ID NUMBER(4) NOT NULL, PRIMARY KEY (EMPLOYEE_ID), UNIQUE (EMAIL), CONSTRAINT EMP_SALARY_MIN CHECK (salary &gt; 0) ) TABLESPACE EXAMPLE ; COMMENT ON TABLE EMPLOYEES IS 'employees table. Contains 107 rows. References with departments, jobs, job_history tables. Contains a self reference.'; COMMENT ON COLUMN EMPLOYEES.EMPLOYEE_ID IS 'Primary key of employees table.'; COMMENT ON COLUMN EMPLOYEES.FIRST_NAME IS 'First name of the employee. A not null column.'; COMMENT ON COLUMN EMPLOYEES.LAST_NAME IS 'Last name of the employee. A not null column.'; COMMENT ON COLUMN EMPLOYEES.EMAIL IS 'Email id of the employee'; COMMENT ON COLUMN EMPLOYEES.PHONE_NUMBER IS 'Phone number of the employee; includes country code and area code'; COMMENT ON COLUMN EMPLOYEES.HIRE_DATE IS 'Date when the employee started on this job. A not null column.'; COMMENT ON COLUMN EMPLOYEES.JOB_ID IS 'Current job of the employee; foreign key to job_id column of the jobs table. A not null column.'; COMMENT ON COLUMN EMPLOYEES.SALARY IS 'Monthly salary of the employee. Must be greater than zero (enforced by constraint emp_salary_min)'; COMMENT ON COLUMN EMPLOYEES.COMMISSION_PCT IS 'Commission percentage of the employee; Only employees in sales department elgible for commission percentage'; COMMENT ON COLUMN EMPLOYEES.MANAGER_ID IS 'Manager id of the employee; has same domain as manager_id in departments table. Foreign key to employee_id column of employees table. (useful for reflexive joins and CONNECT BY query)'; COMMENT ON COLUMN EMPLOYEES.DEPARTMENT_ID IS 'Department id where employee works; foreign key to department_id column of the departments table'; --- --- CREATE INDEX: EMP_DEPARTMENT_IX --- CREATE INDEX EMP_DEPARTMENT_IX ON EMPLOYEES ( DEPARTMENT_ID ) TABLESPACE EXAMPLE ; --- --- CREATE INDEX: EMP_JOB_IX --- CREATE INDEX EMP_JOB_IX ON EMPLOYEES ( JOB_ID ) TABLESPACE EXAMPLE ; --- --- CREATE INDEX: EMP_MANAGER_IX --- CREATE INDEX EMP_MANAGER_IX ON EMPLOYEES ( MANAGER_ID ) TABLESPACE EXAMPLE ; --- --- CREATE INDEX: EMP_NAME_IX --- CREATE INDEX EMP_NAME_IX ON EMPLOYEES ( LAST_NAME, FIRST_NAME ) TABLESPACE EXAMPLE ; --- --- CREATE FOREIGN KEY CONSTRAINT: EMP_DEPT_FK --- ALTER TABLE EMPLOYEES ADD FOREIGN KEY (DEPARTMENT_ID) REFERENCES DEPARTMENTS (DEPARTMENT_ID) ; --- --- CREATE FOREIGN KEY CONSTRAINT: EMP_JOB_FK --- ALTER TABLE EMPLOYEES ADD FOREIGN KEY (JOB_ID) REFERENCES JOBS (JOB_ID) ; --- --- CREATE FOREIGN KEY CONSTRAINT: EMP_MANA