<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head> <title>Hibernate Mappings - Table Info</title> <link rel="stylesheet" type="text/css" href="../../assets/doc-style.css" title="Style"/> </head> <body> <div id="header"> <div id="logo"> <a href="http://www.hibernate.org/" target="_blank"> <img src="../../assets/hibernate_logo.gif" alt="Hibernate"/> </a> </div> <ul><li><a href="../index.html" target="_top">Tables</a></li><li><a href="../../entities/index.html" target="_top">Entities</a></li></ul> <hr/> </div> <h4>Schema packeis2.default</h4> <h2>Table tree_entry</h2> <p></p> <table id="column_summary"> <thead> <tr> <th class="MainTableHeading" colspan="7"> Column Summary </th> </tr> <tr> <th style="width: 14%"> Name </th> <th style="width: 14%"> SqlType </th> <th style="width: 14%"> Length </th> <th style="width: 14%"> Precision </th> <th style="width: 14%"> Scale </th> <th style="width: 14%"> Nullable </th> <th style="width: 14%"> Unique </th> </tr> </thead> <tbody> <tr> <td> <a href="#column_detail_id"> id </a> </td> <td> integer </td> <td> 255 </td> <td> 19 </td> <td> 2 </td> <td> false </td> <td> true </td> </tr> <tr> <td> <a href="#column_detail_version"> version </a> </td> <td> integer </td> <td> 255 </td> <td> 19 </td> <td> 2 </td> <td> true </td> <td> false </td> </tr> <tr> <td> <a href="#column_detail_position"> position </a> </td> <td> integer </td> <td> 255 </td> <td> 19 </td> <td> 2 </td> <td> false </td> <td> false </td> </tr> <tr> <td> <a href="#column_detail_name"> name </a> </td> <td> varchar(55) </td> <td> 55 </td> <td> 19 </td> <td> 2 </td> <td> false </td> <td> false </td> </tr> <tr> <td> <a href="#column_detail_description"> description </a> </td> <td> varchar(255) </td> <td> 255 </td> <td> 19 </td> <td> 2 </td> <td> false </td> <td> false </td> </tr> <tr> <td> <a href="#column_detail_enabled"> enabled </a> </td> <td> bit </td> <td> 255 </td> <td> 19 </td> <td> 2 </td> <td> false </td> <td> false </td> </tr> <tr> <td> <a href="#column_detail_parameter"> parameter </a> </td> <td> varchar(255) </td> <td> 255 </td> <td> 19 </td> <td> 2 </td> <td> true </td> <td> false </td> </tr> <tr> <td> <a href="#column_detail_tree_entry_idfk"> tree_entry_idfk </a> </td> <td> integer </td> <td> 255 </td> <td> 19 </td> <td> 2 </td> <td> true </td> <td> false </td> </tr> <tr> <td> <a href="#column_detail_tree_entry_type_idfk"> tree_entry_type_idfk </a> </td> <td> integer </td> <td> 255 </td> <td> 19 </td> <td> 2 </td> <td> false </td> <td> false </td> </tr> </tbody> </table> <table id="primary_key"> <thead> <tr> <th class="MainTableHeading" colspan="2"> Primary Key </th> </tr> <tr> <th style="width: 50%"> Name </th> <th style="width: 50%"> Columns </th> </tr> </thead> <tbody> <tr> <td> PRIMARY </td> <td> <a href="#column_detail_id"> id </a> </td> </tr> </tbody> </table> <table id="foreign_keys"> <thead> <tr> <th class="MainTableHeading" colspan="3"> Foreign Keys </th> </tr> <tr> <th style="width: 33%"> Name </th> <th style="width: 33%"> Referenced Table </th> <th style="width: 33%"> Columns </th> </tr> </thead> <tbody> <tr> <td> FK3A4C3091D9BE694C </td> <td> <a href="tree_entry.html" target="generalFrame"> tree_entry </a> </td> <td> <a href="#column_detail_tree_entry_idfk"> tree_entry_idfk </a> </td> </tr> <tr> <td> FK3A4C3091A29E6A6F </td> <td> <a href="tree_entry_type.html" target="generalFrame"> tree_entry_type </a> </td> <td> <a href="#column_detail_tree_entry_type_idfk"> tree_entry_type_idfk </a> </td> </tr> <tr> <td> tree_entryFKtree_entry </td> <td> <a href="tree_entry.html" target="generalFrame"> tree_entry </a> </td> <td> <a href="#column_detail_tree_entry_idfk"> tree_entry_idfk </a> </td> </tr> <tr> <td> tree_entryFKtree_entry_type </td> <td> <a href="tree_entry_type.html" target="generalFrame"> tree_entry_type </a> </td> <td> <a href="#column_detail_tree_entry_type_idfk"> tree_entry_type_idfk </a> </td> </tr> </tbody> </table> <table id="unique_keys"> <thead> <tr> <th class="MainTableHeading" colspan="2"> Unique Keys </th> </tr> <tr> <th style="width: 50%"> Name </th> <th style="width: 50%"> Columns </th> </tr> </thead> <tbody> <tr> <td> PRIMARY </td> <td> <a href="#column_detail_id"> id </a> </td> </tr> </tbody> </table> <table id="indexes"> <thead> <tr> <th class="MainTableHeading" colspan="2"> Indexes </th> </tr> <tr> <th style="width: 50%"> Name </th> <th style="width: 50%"> Columns </th> </tr> </thead> <tbody> <tr> <td> tree_entryFKtree_entry_type </td> <td> <a href="#column_detail_tree_entry_type_idfk"> tree_entry_type_idfk </a> </td> </tr> <tr> <td> tree_entryFKtree_entry </td> <td> <a href="#column_detail_tree_entry_idfk"> tree_entry_idfk </a> </td> </tr> </tbody> </table> <p id="column_detail" class="MainTableHeading"> Column Detail </p> <h3 id="column_detail_id">id</h3> <ul> <li> <strong>Type:</strong> integer </li> <li> <strong>Length:</strong> 255 </li> <li> <strong>Precision:</strong> 19 </li> <li> <strong>Scale:</strong> 2 </li> <li> <strong>Nullable:</strong> false </li> <li> <strong>Unique:</strong> true </li> <li> <strong>Comment:</strong> </li> </ul> <hr/> <h3 id="column_detail_version">version</h3> <ul> <li> <strong>Type:</strong> integer </li> <li> <strong>Length:</strong> 255 </li> <li> <strong>Precision:</strong> 19 </li> <li> <strong>Scale:</strong> 2 </li> <li> <strong>Nullable:</strong> true </li> <li> <strong>Unique:</strong> false </li> <li> <strong>Comment:</strong> For hibernate optimistic lock mechanics </li> </ul> <hr/> <h3 id="column_detail_position">position</h3> <ul> <li> <strong>Type:</strong> integer </li> <li> <strong>Length:</strong> 255 </li> <li> <strong>Precision:</strong> 19 </li> <li> <strong>Scale:</strong> 2 </li> <li> <strong>Nullable:</strong> false </li> <li> <strong>Unique:</strong> false </li> <li> <strong>Comment:</strong> </li> </ul> <hr/> <h3 id="column_detail_name">name</h3> <ul> <li> <strong>Type:</strong> varchar(55) </li> <li> <strong>Length:</strong> 55 </li> <li> <strong>Precision:</strong> 19 </li> <li> <strong>Scale:</strong> 2 </li> <li> <strong>Nullable:</strong> false </li> <li> <strong>Unique:</strong> false </li> <li> <strong>Comment:</strong> has lucene index </li> </ul> <hr/> <h3 id="column_detail_description">description</h3> <ul> <li> <strong>Type:</strong> varchar(255) </li> <li> <strong>Length:</strong> 255 </li> <li> <strong>Precision:</strong> 19 </li> <li> <strong>Scale:</strong> 2 </li> <li> <strong>Nullable:</strong> false </li> <li> <strong>Unique:</strong> false </li> <li> <strong>Comment:</strong> has lucene index </li> </ul> <hr/> <h3 id="column_detail_enabled">enabled</h3> <ul> <li> <strong>Type:</strong> bit </li> <li> <strong>Length:</strong> 255 </li> <li> <strong>Precision:</strong> 19 </li> <li> <strong>Scale:</strong> 2 </li> <li> <strong>Nullable:</strong> false </li> <li> <strong>Unique:</strong> false </li> <li> <strong>Comment:</strong> </li> </ul> <hr/> <h3 id="column_detail_parameter">parameter</h3> <ul> <li> <strong>Type:</strong> varchar(255) </li> <li> <strong>Length:</strong> 255 </li> <li> <strong>Precision:</strong> 19 </li> <li> <strong>Scale:</strong> 2 </li> <li> <strong>Nullable:</strong> true </li> <li> <strong>Unique:</strong> false </li> <li> <strong>Comment:</strong> </li> </ul> <hr/> <h3 id="column_detail_tree_entry_idfk">tree_entry_idfk</h3> <ul> <li> <strong>Type:</strong> integer </li> <li> <strong>Length:</strong> 255 </li> <li> <strong>Precision:</strong> 19 </li> <li> <strong>Scale:</strong> 2 </li> <li> <strong>Nullable:</strong> true </li> <li> <strong>Unique:</strong> false </li> <li> <strong>Comment:</strong> </li> </ul> <hr/> <h3 id="column_detail_tree_entry_type_idfk">tree_entry_type_idfk</h3> <ul> <li> <strong>Type:</strong> integer </li> <li> <strong>Length:</strong> 255 </li> <li> <strong>Precision:</strong> 19 </li> <li> <strong>Scale:</strong> 2 </li> <li> <strong>Nullable:</strong> false </li> <li> <strong>Unique:</strong> false </li> <li> <strong>Comment:</strong> </li> </ul> <hr/> </body> </html>