Openbravo POS/Developer guide/Database Diagram XML Source

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

                </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>