Wikibooks

Openbravo POS/Developer guide/Database Diagram XML Source

< Openbravo POS | Developer guide

To edit the Database Diagram, open the following xml with DBDesigner. http://fabforce.net/dbdesigner4/ The xml is provided by Adrian Romero and he said it was slightly outdated as of December 27, 2005. https://sourceforge.net/forum/forum.php?thread_id=1402802&forum_id=434921 

<?xml version="1.0" standalone="yes" ?> 
<DBMODEL Version="4.0"> 
<SETTINGS> 
<GLOBALSETTINGS ModelName="tinaposdatabase" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="100.00" XPos="717" YPos="424" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="FinePrint" HPageCount="5.454061251664448" PageAspectRatio="1.462545610646061" PageOrientation="0" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="0;1" UsePositionGrid="1" PositionGridX="10" PositionGridY="10" TableNameInRefs="0" DefaultTableType="0" ActivateRefDefForNewRelations="1" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="0" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Tahoma" CanvasWidth="4096" CanvasHeight="2842" /> 
<DATATYPEGROUPS> 
<DATATYPEGROUP Name="Numeric Types" Icon="1" /> 
<DATATYPEGROUP Name="Date and Time Types" Icon="2" /> 
<DATATYPEGROUP Name="String Types" Icon="3" /> 
<DATATYPEGROUP Name="Blob and Text Types" Icon="4" /> 
<DATATYPEGROUP Name="User defined Types" Icon="5" /> 
<DATATYPEGROUP Name="Geographic Types" Icon="6" /> 
</DATATYPEGROUPS> 
<DATATYPES> 
<DATATYPE ID="1" IDGroup="0" TypeName="TINYINT" Description="A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="UNSIGNED" Default="1" /> 
<OPTION Name="ZEROFILL" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="2" IDGroup="0" TypeName="SMALLINT" Description="A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="UNSIGNED" Default="1" /> 
<OPTION Name="ZEROFILL" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="3" IDGroup="0" TypeName="MEDIUMINT" Description="A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="UNSIGNED" Default="1" /> 
<OPTION Name="ZEROFILL" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="4" IDGroup="0" TypeName="INT" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="UNSIGNED" Default="0" /> 
<OPTION Name="ZEROFILL" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="5" IDGroup="0" TypeName="INTEGER" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="UNSIGNED" Default="1" /> 
<OPTION Name="ZEROFILL" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="6" IDGroup="0" TypeName="BIGINT" Description="A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="UNSIGNED" Default="0" /> 
<OPTION Name="ZEROFILL" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="7" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="precision" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="ZEROFILL" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="8" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
<PARAM Name="decimals" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="ZEROFILL" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="9" IDGroup="0" TypeName="DOUBLE" Description="A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
<PARAM Name="decimals" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="ZEROFILL" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="10" IDGroup="0" TypeName="DOUBLE PRECISION" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
<PARAM Name="decimals" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="ZEROFILL" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="11" IDGroup="0" TypeName="REAL" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
<PARAM Name="decimals" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="ZEROFILL" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="12" IDGroup="0" TypeName="DECIMAL" Description="An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
<PARAM Name="decimals" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="ZEROFILL" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="13" IDGroup="0" TypeName="NUMERIC" Description="This is a synonym for DECIMAL." ParamCount="2" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
<PARAM Name="decimals" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="ZEROFILL" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="14" IDGroup="1" TypeName="DATE" Description="A date. The supported range is \a1000-01-01\a to \a9999-12-31\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="15" IDGroup="1" TypeName="DATETIME" Description="A date and time combination. The supported range is \a1000-01-01 00:00:00\a to \a9999-12-31 23:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="16" IDGroup="1" TypeName="TIMESTAMP" Description="A timestamp. The range is \a1970-01-01 00:00:00\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
</PARAMS> 
</DATATYPE> 
<DATATYPE ID="17" IDGroup="1" TypeName="TIME" Description="A time. The range is \a-838:59:59\a to \a838:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="18" IDGroup="1" TypeName="YEAR" Description="A year in 2- or 4-digit format (default is 4-digit)." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
</PARAMS> 
</DATATYPE> 
<DATATYPE ID="19" IDGroup="2" TypeName="CHAR" Description="A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="BINARY" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="20" IDGroup="2" TypeName="VARCHAR" Description="A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="length" /> 
</PARAMS> 
<OPTIONS> 
<OPTION Name="BINARY" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="21" IDGroup="2" TypeName="BIT" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="22" IDGroup="2" TypeName="BOOL" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="23" IDGroup="3" TypeName="TINYBLOB" Description="A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="24" IDGroup="3" TypeName="BLOB" Description="A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="25" IDGroup="3" TypeName="MEDIUMBLOB" Description="A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="26" IDGroup="3" TypeName="LONGBLOB" Description="A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="27" IDGroup="3" TypeName="TINYTEXT" Description="A column maximum length of 255 (2^8 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="28" IDGroup="3" TypeName="TEXT" Description="A column maximum length of 65535 (2^16 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="29" IDGroup="3" TypeName="MEDIUMTEXT" Description="A column maximum length of 16777215 (2^24 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="30" IDGroup="3" TypeName="LONGTEXT" Description="A column maximum length of 4294967295 (2^32 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="31" IDGroup="3" TypeName="ENUM" Description="An enumeration. A string object that can have only one value, chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="values" /> 
</PARAMS> 
</DATATYPE> 
<DATATYPE ID="32" IDGroup="3" TypeName="SET" Description="A set. A string object that can have zero or more values, each of which must be chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<PARAMS> 
<PARAM Name="values" /> 
</PARAMS> 
</DATATYPE> 
<DATATYPE ID="33" IDGroup="4" TypeName="Varchar(20)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<OPTIONS> 
<OPTION Name="BINARY" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="34" IDGroup="4" TypeName="Varchar(45)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<OPTIONS> 
<OPTION Name="BINARY" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="35" IDGroup="4" TypeName="Varchar(255)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
<OPTIONS> 
<OPTION Name="BINARY" Default="0" /> 
</OPTIONS> 
</DATATYPE> 
<DATATYPE ID="36" IDGroup="5" TypeName="GEOMETRY" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="38" IDGroup="5" TypeName="LINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="39" IDGroup="5" TypeName="POLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="40" IDGroup="5" TypeName="MULTIPOINT" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="41" IDGroup="5" TypeName="MULTILINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="42" IDGroup="5" TypeName="MULTIPOLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
<DATATYPE ID="43" IDGroup="5" TypeName="GEOMETRYCOLLECTION" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > 
</DATATYPE> 
</DATATYPES> 
<COMMON_DATATYPES> 
<COMMON_DATATYPE ID="5" /> 
<COMMON_DATATYPE ID="8" /> 
<COMMON_DATATYPE ID="20" /> 
<COMMON_DATATYPE ID="15" /> 
<COMMON_DATATYPE ID="22" /> 
<COMMON_DATATYPE ID="28" /> 
<COMMON_DATATYPE ID="26" /> 
<COMMON_DATATYPE ID="33" /> 
<COMMON_DATATYPE ID="34" /> 
<COMMON_DATATYPE ID="35" /> 
</COMMON_DATATYPES> 
<TABLEPREFIXES> 
<TABLEPREFIX Name="Default (no prefix)" /> 
</TABLEPREFIXES> 
<REGIONCOLORS> 
<REGIONCOLOR Color="Red=#FFEEEC" /> 
<REGIONCOLOR Color="Yellow=#FEFDED" /> 
<REGIONCOLOR Color="Green=#EAFFE5" /> 
<REGIONCOLOR Color="Cyan=#ECFDFF" /> 
<REGIONCOLOR Color="Blue=#F0F1FE" /> 
<REGIONCOLOR Color="Magenta=#FFEBFA" /> 
</REGIONCOLORS> 
<POSITIONMARKERS> 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> 
<POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> 
</POSITIONMARKERS> 
</SETTINGS> 
<METADATA> 
<REGIONS> 
<REGION ID="2249" RegionName="Region_04" XPos="770" YPos="540" Width="730" Height="530" RegionColor="3" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="34" /> 
<REGION ID="2243" RegionName="Region_01" XPos="10" YPos="10" Width="730" Height="520" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="31" /> 
<REGION ID="2244" RegionName="Region_02" XPos="770" YPos="10" Width="730" Height="520" RegionColor="1" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" /> 
<REGION ID="2245" RegionName="Region_03" XPos="10" YPos="540" Width="730" Height="520" RegionColor="2" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="33" /> 
</REGIONS> 
<TABLES> 
<TABLE ID="2042" Tablename="CATEGORIES" PrevTableName="categories" XPos="1160" YPos="170" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" > 
<COLUMNS> 
<COLUMN ID="2062" ColName="ID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2063" ColName="NAME" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2064" ColName="IMAGE" PrevColName="" Pos="3" idDatatype="24" DatatypeParams="" Width="-1" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<RELATIONS_START> 
<RELATION_START ID="2171" /> 
</RELATIONS_START> 
<INDICES> 
<INDEX ID="2065" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2062" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2043" Tablename="CLOSEDCASH" PrevTableName="closedcash" XPos="40" YPos="340" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" > 
<COLUMNS> 
<COLUMN ID="2066" ColName="MONEY" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2067" ColName="HOST" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2068" ColName="DATENEW" PrevColName="" Pos="3" idDatatype="15" DatatypeParams="" Width="19" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<RELATIONS_START> 
<RELATION_START ID="2205" /> 
</RELATIONS_START> 
<INDICES> 
<INDEX ID="2069" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2066" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
<INDEX ID="2070" IndexName="CLOSEDCASH_INX_1" IndexKind="1" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2068" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2044" Tablename="CLOSEDCASHNUM" PrevTableName="closedcashnum" XPos="200" YPos="340" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="4" > 
<COLUMNS> 
<COLUMN ID="2071" ColName="ID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
</TABLE> 
<TABLE ID="2045" Tablename="EDITTICKETS" PrevTableName="edittickets" XPos="1200" YPos="760" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="5" > 
<COLUMNS> 
<COLUMN ID="2072" ColName="TICKETID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2073" ColName="HOST" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2074" ColName="CONTENT" PrevColName="" Pos="3" idDatatype="24" DatatypeParams="" Width="-1" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<INDICES> 
<INDEX ID="2075" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2072" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
<INDEX ID="2076" IndexName="EDITTICKETS_INX_1" IndexKind="1" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2073" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2046" Tablename="FLOORS" PrevTableName="floors" XPos="990" YPos="570" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="6" > 
<COLUMNS> 
<COLUMN ID="2077" ColName="ID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2079" ColName="IMAGE" PrevColName="" Pos="3" idDatatype="24" DatatypeParams="" Width="-1" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<RELATIONS_START> 
<RELATION_START ID="2240" /> 
</RELATIONS_START> 
<INDICES> 
<INDEX ID="2080" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2077" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2047" Tablename="people" PrevTableName="" XPos="430" YPos="620" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="7" > 
<COLUMNS> 
<COLUMN ID="2081" ColName="NAME" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2082" ColName="APPPASSWORD" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2083" ColName="ROLE" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2084" ColName="VISIBLE" PrevColName="" Pos="4" idDatatype="1" DatatypeParams="" Width="1" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2085" ColName="IMAGE" PrevColName="" Pos="5" idDatatype="24" DatatypeParams="" Width="-1" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<INDICES> 
<INDEX ID="2086" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2081" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2048" Tablename="PLACES" PrevTableName="places" XPos="790" YPos="570" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" > 
<COLUMNS> 
<COLUMN ID="2087" ColName="NAME" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2088" ColName="X" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2089" ColName="Y" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2090" ColName="FLOOR" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<RELATIONS_END> 
<RELATION_END ID="2240" /> 
</RELATIONS_END> 
<INDICES> 
<INDEX ID="2091" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2087" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2049" Tablename="PRODUCTS" PrevTableName="products" XPos="860" YPos="50" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="9" > 
<COLUMNS> 
<COLUMN ID="2093" ColName="REFERENCE" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2094" ColName="CODE" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2095" ColName="NAME" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2096" ColName="PRICEBUY" PrevColName="" Pos="4" idDatatype="9" DatatypeParams="" Width="22" Prec="31" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2097" ColName="PRICESELL" PrevColName="" Pos="5" idDatatype="9" DatatypeParams="" Width="22" Prec="31" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2098" ColName="CATEGORY" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2099" ColName="TAX" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2100" ColName="STOCKSECURITY" PrevColName="" Pos="8" idDatatype="9" DatatypeParams="" Width="22" Prec="31" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2101" ColName="STOCKCOST" PrevColName="" Pos="9" idDatatype="9" DatatypeParams="" Width="22" Prec="31" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2102" ColName="STOCKVOLUME" PrevColName="" Pos="10" idDatatype="9" DatatypeParams="" Width="22" Prec="31" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2103" ColName="IMAGE" PrevColName="" Pos="11" idDatatype="24" DatatypeParams="" Width="-1" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<RELATIONS_START> 
<RELATION_START ID="2173" /> 
<RELATION_START ID="2202" /> 
<RELATION_START ID="2212" /> 
<RELATION_START ID="2221" /> 
</RELATIONS_START> 
<RELATIONS_END> 
<RELATION_END ID="2167" /> 
<RELATION_END ID="2171" /> 
</RELATIONS_END> 
<INDICES> 
<INDEX ID="2104" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2093" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
<INDEX ID="2107" IndexName="PRODUCTS_INX_1" IndexKind="1" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2094" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2050" Tablename="PRODUCTS_CAT" PrevTableName="products_cat" XPos="860" YPos="420" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="10" > 
<COLUMNS> 
<COLUMN ID="2108" ColName="REFERENCE" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<RELATIONS_END> 
<RELATION_END ID="2173" /> 
</RELATIONS_END> 
<INDICES> 
<INDEX ID="2109" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2108" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2051" Tablename="PRODUCTSOUT" PrevTableName="productsout" XPos="350" YPos="130" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="11" > 
<COLUMNS> 
<COLUMN ID="2110" ColName="TICKETID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2111" ColName="TICKETLINE" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2112" ColName="PRODUCT" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2113" ColName="UNITS" PrevColName="" Pos="4" idDatatype="9" DatatypeParams="" Width="22" Prec="31" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2114" ColName="PRICE" PrevColName="" Pos="5" idDatatype="9" DatatypeParams="" Width="22" Prec="31" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2115" ColName="TAXRATE" PrevColName="" Pos="6" idDatatype="9" DatatypeParams="" Width="22" Prec="31" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<RELATIONS_END> 
<RELATION_END ID="2206" /> 
<RELATION_END ID="2212" /> 
</RELATIONS_END> 
<INDICES> 
<INDEX ID="2116" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2110" LengthParam="0" /> 
<INDEXCOLUMN idColumn="2111" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2052" Tablename="RESERVATIONS" PrevTableName="reservations" XPos="790" YPos="760" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="12" > 
<COLUMNS> 
<COLUMN ID="2118" ColName="ID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2119" ColName="DATENEW" PrevColName="" Pos="2" idDatatype="15" DatatypeParams="" Width="19" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2120" ColName="TITLE" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2121" ColName="CHAIRS" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2122" ColName="ISDONE" PrevColName="" Pos="5" idDatatype="1" DatatypeParams="" Width="1" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2123" ColName="DESCRIPTION" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<INDICES> 
<INDEX ID="2124" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2118" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
<INDEX ID="2125" IndexName="RESERVATIONS_INX_1" IndexKind="1" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2119" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2053" Tablename="RESERVATIONSNUM" PrevTableName="reservationsnum" XPos="1000" YPos="760" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="13" > 
<COLUMNS> 
<COLUMN ID="2126" ColName="ID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
</TABLE> 
<TABLE ID="2054" Tablename="resources" PrevTableName="" XPos="230" YPos="620" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="" TableOptions="" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="14" > 
<COLUMNS> 
<COLUMN ID="2127" ColName="NAME" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2128" ColName="RESTYPE" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2129" ColName="CONTENT" PrevColName="" Pos="3" idDatatype="24" DatatypeParams="" Width="-1" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<INDICES> 
<INDEX ID="2130" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2127" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2055" Tablename="STOCKCURRENT" PrevTableName="stockcurrent" XPos="350" YPos="270" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="15" > 
<COLUMNS> 
<COLUMN ID="2131" ColName="PRODUCT" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2132" ColName="UNITS" PrevColName="" Pos="2" idDatatype="9" DatatypeParams="" Width="22" Prec="31" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<RELATIONS_END> 
<RELATION_END ID="2202" /> 
</RELATIONS_END> 
<INDICES> 
<INDEX ID="2133" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2131" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2056" Tablename="STOCKDIARY" PrevTableName="stockdiary" XPos="350" YPos="340" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="16" > 
<COLUMNS> 
<COLUMN ID="2134" ColName="ID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2135" ColName="DATENEW" PrevColName="" Pos="2" idDatatype="15" DatatypeParams="" Width="19" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2136" ColName="REASON" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2137" ColName="PRODUCT" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2138" ColName="UNITS" PrevColName="" Pos="5" idDatatype="9" DatatypeParams="" Width="22" Prec="31" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2139" ColName="PRICE" PrevColName="" Pos="6" idDatatype="9" DatatypeParams="" Width="22" Prec="31" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<RELATIONS_END> 
<RELATION_END ID="2221" /> 
</RELATIONS_END> 
<INDICES> 
<INDEX ID="2140" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2134" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
<INDEX ID="2142" IndexName="STOCKDIARY_INX_1" IndexKind="1" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2135" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2057" Tablename="STOCKDIARYNUM" PrevTableName="stockdiarynum" XPos="560" YPos="340" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="17" > 
<COLUMNS> 
<COLUMN ID="2143" ColName="ID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
</TABLE> 
<TABLE ID="2058" Tablename="TAXES" PrevTableName="taxes" XPos="1160" YPos="50" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="18" > 
<COLUMNS> 
<COLUMN ID="2144" ColName="ID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2145" ColName="NAME" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2146" ColName="RATE" PrevColName="" Pos="3" idDatatype="9" DatatypeParams="" Width="22" Prec="31" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<RELATIONS_START> 
<RELATION_START ID="2167" /> 
</RELATIONS_START> 
<INDICES> 
<INDEX ID="2147" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2144" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2059" Tablename="TICKETS" PrevTableName="tickets" XPos="30" YPos="70" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="19" > 
<COLUMNS> 
<COLUMN ID="2148" ColName="TICKETID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2149" ColName="DATENEW" PrevColName="" Pos="2" idDatatype="15" DatatypeParams="" Width="19" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2150" ColName="HOST" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2151" ColName="PERSON" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2152" ColName="PAYMENT" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
<COLUMN ID="2153" ColName="MONEY" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<RELATIONS_START> 
<RELATION_START ID="2206" /> 
</RELATIONS_START> 
<RELATIONS_END> 
<RELATION_END ID="2205" /> 
</RELATIONS_END> 
<INDICES> 
<INDEX ID="2154" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2148" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
<INDEX ID="2155" IndexName="TICKETS_INX_1" IndexKind="1" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2149" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
<TABLE ID="2060" Tablename="TICKETSNUM" PrevTableName="ticketsnum" XPos="210" YPos="70" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="20" > 
<COLUMNS> 
<COLUMN ID="2156" ColName="ID" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="11" Prec="0" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
</TABLE> 
<TABLE ID="2061" Tablename="TINAPOS" PrevTableName="tinapos" XPos="30" YPos="620" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="21" > 
<COLUMNS> 
<COLUMN ID="2157" ColName="VERSION" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(100)" Width="100" Prec="0" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments=""> 
<OPTIONSELECTED> 
<OPTIONSELECT Value="0" /> 
</OPTIONSELECTED> 
</COLUMN> 
</COLUMNS> 
<INDICES> 
<INDEX ID="2158" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> 
<INDEXCOLUMNS> 
<INDEXCOLUMN idColumn="2157" LengthParam="0" /> 
</INDEXCOLUMNS> 
</INDEX> 
</INDICES> 
</TABLE> 
</TABLES> 
<RELATIONS> 
<RELATION ID="2167" RelationName="PRODUCTS_FK_2" Kind="2" SrcTable="2058" DestTable="2049" FKFields="ID=TAX\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="22" /> 
<RELATION ID="2171" RelationName="PRODUCTS_FK_1" Kind="2" SrcTable="2042" DestTable="2049" FKFields="ID=CATEGORY\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="23" /> 
<RELATION ID="2173" RelationName="PRODUCTS_CAT_FK_1" Kind="5" SrcTable="2049" DestTable="2050" FKFields="REFERENCE=REFERENCE\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="24" /> 
<RELATION ID="2202" RelationName="STOCKCURRENT_FK_1" Kind="5" SrcTable="2049" DestTable="2055" FKFields="REFERENCE=PRODUCT\n" FKFieldsComments="\n" relDirection="4" MidOffset="-46" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="25" /> 
<RELATION ID="2205" RelationName="TICKETS_GK_1" Kind="2" SrcTable="2043" DestTable="2059" FKFields="MONEY=MONEY\n" FKFieldsComments="\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="26" /> 
<RELATION ID="2206" RelationName="PRODUCTSOUT_FK_1" Kind="1" SrcTable="2059" DestTable="2051" FKFields="TICKETID=TICKETID\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="27" /> 
<RELATION ID="2212" RelationName="PRODUCTSOUT_FK_2" Kind="2" SrcTable="2049" DestTable="2051" FKFields="REFERENCE=PRODUCT\n" FKFieldsComments="\n" relDirection="4" MidOffset="-67" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="28" /> 
<RELATION ID="2221" RelationName="STOCKDIARY_FK_1" Kind="2" SrcTable="2049" DestTable="2056" FKFields="REFERENCE=PRODUCT\n" FKFieldsComments="\n" relDirection="4" MidOffset="-24" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="29" /> 
<RELATION ID="2240" RelationName="Rel_19" Kind="2" SrcTable="2046" DestTable="2048" FKFields="ID=FLOOR\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="0" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="1" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="30" /> 
</RELATIONS> 
<NOTES> 
</NOTES> 
<IMAGES> 
</IMAGES> 
</METADATA> 
<PLUGINDATA> 
<PLUGINDATARECORDS> 
<PLUGINDATARECORD PluginName="HTMLReport" Obj_id="-1" DataValue="nil"> 
<PLUGINDATAPARAMS> 
<PLUGINDATAPARAM Value="SelectedTables=categories;closedcash;closedcashnum;edittickets;floors;people;places;PRODUCTS;PRODUCTS_CAT;productsout;reservations;reservationsnum;resources;stockcurrent;stockdiary;stockdiarynum;taxes;tickets;ticketsnum;tinapos;" /> 
</PLUGINDATAPARAMS> 
</PLUGINDATARECORD> 
</PLUGINDATARECORDS> 
</PLUGINDATA> 
<QUERYDATA> 
<QUERYRECORDS> 
</QUERYRECORDS> 
</QUERYDATA> 
<LINKEDMODELS> 
</LINKEDMODELS> 
</DBMODEL>
Retrieved from "https://en.wikibooks.org/w/index.php?title=Openbravo_POS/Developer_guide/Database_Diagram_XML_Source&oldid=3679144"