Using POSper/Developer guide/Database Diagram XML Source

To edit the Database Diagram, open the following xml with DBDesigner. http://fabforce.net/dbdesigner4/ this is the xml describing the model for revision 423

   <GLOBALSETTINGS ModelName="posperDbdRev423" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="91.00" XPos="566" YPos="922" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="" HPageCount="4.0" PageAspectRatio="1.440892512336408" PageOrientation="1" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="" UsePositionGrid="0" PositionGridX="20" PositionGridY="20" TableNameInRefs="1" DefaultTableType="0" ActivateRefDefForNewRelations="1" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="1" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="nimbus sans l" CanvasWidth="4096" CanvasHeight="2842" />



























<COLUMN ID="1032" ColName="visibleId" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="\Ahuman-friendly\A id visible to the user and editable by the user">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1033" ColName="address" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="address of the location">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1034" ColName="name" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="user assigned location name">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1310" />

<RELATION_START ID="1327" />

</RELATIONS_START>

<INDICES>

<INDEX ID="1027" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1026" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1041" Tablename="posper_place" PrevTableName="Table_04" XPos="1513" YPos="1292" 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="1043" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="UUID instead of int">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1440" ColName="posper_floor_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1045" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="this is used by hibernate to track table version">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1046" ColName="name" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="user-assigned name">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1047" ColName="x" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="x coordinate">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1048" ColName="y" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="y coordinate">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1277" />

</RELATIONS_START>

<RELATIONS_END>

<RELATION_END ID="1439" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1044" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1043" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1441" IndexName="Place_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1439">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1440" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1064" Tablename="posper_reservation" PrevTableName="Table_06" XPos="193" YPos="623" 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="7" >

<COLUMNS>

<COLUMN ID="1066" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1068" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1069" ColName="customer" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1070" ColName="chairs" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1071" ColName="date" PrevColName="" Pos="4" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1072" ColName="done" PrevColName="" Pos="5" idDatatype="21" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1073" ColName="description" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<INDICES>

<INDEX ID="1067" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1066" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1085" Tablename="posper_ticketcreationgenerator" PrevTableName="Table_08" XPos="202" YPos="844" 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="1087" ColName="id" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<INDICES>

<INDEX ID="1088" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1087" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1089" Tablename="posper_cashregister" PrevTableName="Table_09" XPos="616" YPos="1434" 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="1091" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1093" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1095" ColName="dateOpen" PrevColName="" Pos="3" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1096" ColName="dateClose" PrevColName="" Pos="4" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1097" ColName="host" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1358" />

</RELATIONS_START>

<INDICES>

<INDEX ID="1092" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1091" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1098" Tablename="posper_category" PrevTableName="Table_10" XPos="1649" YPos="880" 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="1100" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1346" ColName="posper_category_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="this field doesn\at exist : the actual field name is parent_id">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1260" ColName="posper_image_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1102" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1103" ColName="visibleId" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1104" ColName="category_name" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1105" ColName="parent_id" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1270" />

<RELATION_START ID="1342" />

</RELATIONS_START>

<RELATIONS_END>

<RELATION_END ID="1259" />

<RELATION_END ID="1342" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1101" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1100" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1261" IndexName="category_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1259">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1260" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1344" IndexName="category_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1342">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1346" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1107" Tablename="posper_image" PrevTableName="Table_11" XPos="1649" YPos="1164" 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="1109" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1111" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1112" ColName="posper_imageBlob" PrevColName="" Pos="2" idDatatype="25" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1113" ColName="description" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1256" />

<RELATION_START ID="1259" />

<RELATION_START ID="1262" />

<RELATION_START ID="1265" />

<RELATION_START ID="1465" />

</RELATIONS_START>

<INDICES>

<INDEX ID="1110" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1109" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1126" Tablename="posper_payment" PrevTableName="Table_14" XPos="985" YPos="1198" 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="1128" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1511" ColName="posper_ticket_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1130" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1132" ColName="amount" PrevColName="" Pos="3" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1133" ColName="method" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1510" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1129" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1128" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1512" IndexName="posper_payment_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1510">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1511" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1134" Tablename="posper_product" PrevTableName="Table_15" XPos="1271" YPos="761" 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="1136" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1263" ColName="posper_image_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1138" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1139" ColName="reference" PrevColName="visibleId" Pos="2" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1140" ColName="inStock" PrevColName="" Pos="3" idDatatype="21" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1141" ColName="com" PrevColName="" Pos="4" idDatatype="21" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1142" ColName="scale" PrevColName="" Pos="5" idDatatype="21" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1143" ColName="priceBuy" PrevColName="" Pos="6" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1144" ColName="priceSell" PrevColName="" Pos="7" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1145" ColName="stockCost" PrevColName="" Pos="8" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1146" ColName="volume" PrevColName="" Pos="9" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1147" ColName="displayOrder" PrevColName="" Pos="10" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1148" ColName="description" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1149" ColName="code" PrevColName="" Pos="12" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1150" ColName="posper_tax_id" PrevColName="" Pos="13" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1152" ColName="posper_category_id" PrevColName="" Pos="15" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1309" />

<RELATION_START ID="1323" />

<RELATION_START ID="1326" />

</RELATIONS_START>

<RELATIONS_END>

<RELATION_END ID="1262" />

<RELATION_END ID="1268" />

<RELATION_END ID="1270" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1137" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1136" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1264" IndexName="product_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1262">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1263" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1269" IndexName="product_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1268">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1150" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1271" IndexName="product_FKIndex3" IndexKind="1" FKRefDef_Obj_id="1270">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1152" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1153" Tablename="posper_property" PrevTableName="Table_16" XPos="234" YPos="933" 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="1155" ColName="posper_property_key" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1157" ColName="value" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<INDICES>

<INDEX ID="1156" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1155" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1158" Tablename="posper_resource" PrevTableName="Table_17" XPos="36" YPos="993" 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="1160" ColName="posper_resource_key" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1162" ColName="text" PrevColName="resType" Pos="1" idDatatype="29" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1514" ColName="version" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<INDICES>

<INDEX ID="1161" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1160" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1165" Tablename="posper_role" PrevTableName="Table_18" XPos="1724" YPos="1769" 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="1167" ColName="name" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1284" />

<RELATION_START ID="1295" />

</RELATIONS_START>

<INDICES>

<INDEX ID="1168" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1167" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1174" Tablename="posper_tax" PrevTableName="Table_20" XPos="886" YPos="1026" 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="1176" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1178" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1179" ColName="visibleId" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1180" ColName="rate" PrevColName="" Pos="3" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1181" ColName="posper_tax_name" PrevColName="" Pos="4" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1268" />

<RELATION_START ID="1454" />

</RELATIONS_START>

<INDICES>

<INDEX ID="1177" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1176" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1182" Tablename="posper_ticket" PrevTableName="Table_21" XPos="1229" YPos="1425" TableType="1" 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="22" >

<COLUMNS>

<COLUMN ID="1184" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1492" ColName="posper_place_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1278" ColName="posper_user_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1186" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1187" ColName="visibleId" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1188" ColName="dateOpen" PrevColName="" Pos="3" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1189" ColName="dateClose" PrevColName="" Pos="4" idDatatype="15" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1447" ColName="synched" PrevColName="" Pos="10" idDatatype="21" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1190" ColName="number" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1191" ColName="host" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1194" ColName="parent_id" PrevColName="" Pos="9" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1359" />

<RELATION_START ID="1505" />

<RELATION_START ID="1510" />

</RELATIONS_START>

<RELATIONS_END>

<RELATION_END ID="1272" />

<RELATION_END ID="1277" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1185" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1184" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1274" IndexName="ticket_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1272">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1278" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1504" IndexName="posper_ticket_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1277">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1492" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1200" Tablename="posper_ticketidgenerator" PrevTableName="Table_23" XPos="54" YPos="913" 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="24" >

<COLUMNS>

<COLUMN ID="1202" ColName="id" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<INDICES>

<INDEX ID="1203" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1202" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1204" Tablename="posper_ticketline" PrevTableName="Table_24" XPos="952" YPos="603" 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="25" >

<COLUMNS>

<COLUMN ID="1206" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1506" ColName="posper_ticket_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1490" ColName="posper_tax_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1208" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1516" ColName="description" PrevColName="" Pos="11" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1451" ColName="visibleId" PrevColName="" Pos="10" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1209" ColName="amount" PrevColName="" Pos="2" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1210" ColName="priceSell" PrevColName="" Pos="3" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1457" ColName="posper_taxRate" PrevColName="" Pos="11" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1213" ColName="parentOrder_id" PrevColName="" Pos="6" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1214" ColName="posper_product_id" PrevColName="" Pos="7" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1216" ColName="line_index" PrevColName="" Pos="9" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1323" />

<RELATION_END ID="1454" />

<RELATION_END ID="1505" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1207" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1206" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1324" IndexName="ticket_line_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1323">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1214" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1455" IndexName="ticket_line_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1454">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1490" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1507" IndexName="posper_ticketline_FKIndex3" IndexKind="1" FKRefDef_Obj_id="1505">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1506" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1222" Tablename="posper_user" PrevTableName="Table_26" XPos="1743" YPos="1446" 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="27" >

<COLUMNS>

<COLUMN ID="1224" ColName="id" PrevColName="" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1266" ColName="posper_image_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1226" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1227" ColName="visible" PrevColName="" Pos="2" idDatatype="21" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1228" ColName="name" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1229" ColName="user_password" PrevColName="password_2" Pos="4" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1230" ColName="posper_role_name" PrevColName="" Pos="5" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1272" />

</RELATIONS_START>

<RELATIONS_END>

<RELATION_END ID="1265" />

<RELATION_END ID="1284" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1225" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1224" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1267" IndexName="user_2_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1265">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1266" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1285" IndexName="user_2_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1284">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1230" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1287" Tablename="posper_permission" PrevTableName="Table_27" XPos="1011" YPos="1714" 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="This table doesn\at actually exist but is here to allow representation of the associative table role_permission" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="37" >

<COLUMNS>

<COLUMN ID="1289" ColName="name" PrevColName="permission" Pos="0" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1476" ColName="posper_permission_name" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_START>

<RELATION_START ID="1294" />

<RELATION_START ID="1475" />

</RELATIONS_START>

<RELATIONS_END>

<RELATION_END ID="1475" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1290" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1289" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1477" IndexName="Permission_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1475">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1476" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1293" Tablename="posper_role_permission" PrevTableName="permission_has_role" XPos="1370" YPos="1756" TableType="0" TablePrefix="0" nmTable="1" 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="38" >

<COLUMNS>

<COLUMN ID="1298" ColName="posper_role_name" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1474" ColName="posper_permission_name" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1294" />

<RELATION_END ID="1295" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1300" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1298" LengthParam="0" />

<INDEXCOLUMN idColumn="1474" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1297" IndexName="permission_has_role_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1294">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1474" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1299" IndexName="permission_has_role_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1295">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1298" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1308" Tablename="posper_productlocation" PrevTableName="product_has_Location" XPos="1266" YPos="490" TableType="0" TablePrefix="0" nmTable="1" 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="40" >

<COLUMNS>

<COLUMN ID="1311" ColName="posper_product_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1313" ColName="posper_location_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1317" ColName="id" PrevColName="" Pos="2" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1318" ColName="version" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1319" ColName="stockMaximum" PrevColName="" Pos="4" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1320" ColName="stockSecurity" PrevColName="" Pos="5" idDatatype="9" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1309" />

<RELATION_END ID="1310" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1315" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1311" LengthParam="0" />

<INDEXCOLUMN idColumn="1313" LengthParam="0" />

<INDEXCOLUMN idColumn="1317" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1312" IndexName="product_has_Location_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1309">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1311" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1314" IndexName="product_has_Location_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1310">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1313" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1325" Tablename="posper_stockdiary" PrevTableName="product_has_Location" XPos="1581" YPos="620" TableType="0" TablePrefix="0" nmTable="1" 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="43" >

<COLUMNS>

<COLUMN ID="1339" ColName="id" PrevColName="" Pos="7" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1328" ColName="posper_product_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1330" ColName="posper_location_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1334" ColName="version" PrevColName="" Pos="2" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1335" ColName="price" PrevColName="" Pos="3" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1336" ColName="reason" PrevColName="" Pos="4" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1337" ColName="units" PrevColName="" Pos="5" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1338" ColName="date" PrevColName="" Pos="6" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1326" />

<RELATION_END ID="1327" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1332" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1339" LengthParam="0" />

<INDEXCOLUMN idColumn="1328" LengthParam="0" />

<INDEXCOLUMN idColumn="1330" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1329" IndexName="product_has_Location_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1326">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1328" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1331" IndexName="product_has_Location_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1327">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1330" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1357" Tablename="posper_cashregister_ticket" PrevTableName="cash_register_has_ticket" XPos="892" YPos="1447" TableType="0" TablePrefix="0" nmTable="1" 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="48" >

<COLUMNS>

<COLUMN ID="1360" ColName="posper_cashregister_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1362" ColName="posper_ticket_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1358" />

<RELATION_END ID="1359" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1364" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1360" LengthParam="0" />

<INDEXCOLUMN idColumn="1362" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1361" IndexName="cash_register_has_ticket_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1358">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1360" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1363" IndexName="cash_register_has_ticket_FKIndex2" IndexKind="1" FKRefDef_Obj_id="1359">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1362" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1459" Tablename="posper_ticketlineidgenerator" PrevTableName="Table_28" XPos="52" YPos="775" 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="56" >

<COLUMNS>

<COLUMN ID="1461" ColName="id" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<INDICES>

<INDEX ID="1462" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1461" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

<TABLE ID="1463" Tablename="posper_imageresource" PrevTableName="Table_29" XPos="1954" YPos="1037" 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="57" >

<COLUMNS>

<COLUMN ID="1469" ColName="posper_resource_key" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="1" />

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

<COLUMN ID="1466" ColName="posper_image_id" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">

<OPTIONSELECTED>

<OPTIONSELECT Value="0" />

</OPTIONSELECTED>

</COLUMN>

</COLUMNS>

<RELATIONS_END>

<RELATION_END ID="1465" />

</RELATIONS_END>

<INDICES>

<INDEX ID="1470" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1469" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

<INDEX ID="1467" IndexName="image_resource_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1465">

<INDEXCOLUMNS>

<INDEXCOLUMN idColumn="1466" LengthParam="0" />

</INDEXCOLUMNS>

</INDEX>

</INDICES>

</TABLE>

</TABLES> <RELATIONS> <RELATION ID="1256" RelationName="I\k-\gF" Kind="2" SrcTable="1107" DestTable="1014" FKFields="id=posper_image_id\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="1258" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="28" />

<RELATION ID="1259" RelationName="C\k-\gI" Kind="2" SrcTable="1107" DestTable="1098" FKFields="id=posper_image_id\n" FKFieldsComments="\n" relDirection="1" 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="1261" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="29" />

<RELATION ID="1262" RelationName="P\k-\gI" Kind="2" SrcTable="1107" DestTable="1134" FKFields="id=posper_image_id\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="1264" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="30" />

<RELATION ID="1265" RelationName="I\k-\gU" Kind="2" SrcTable="1107" DestTable="1222" FKFields="id=posper_image_id\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="1267" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="31" />

<RELATION ID="1268" RelationName="TX\k-\gP" Kind="2" SrcTable="1174" DestTable="1134" FKFields="id=posper_tax_id\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="1269" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />

<RELATION ID="1270" RelationName="P\k-\gC" Kind="2" SrcTable="1098" DestTable="1134" FKFields="id=posper_category_id\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="1271" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="33" />

<RELATION ID="1272" RelationName="T\k-\gU" Kind="2" SrcTable="1222" DestTable="1182" FKFields="id=posper_user_id\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="1274" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="34" />

<RELATION ID="1277" RelationName="T\k-\gP" Kind="2" SrcTable="1041" DestTable="1182" FKFields="id=posper_place_id\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="1504" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="35" />

<RELATION ID="1284" RelationName="U\k-\gR" Kind="2" SrcTable="1165" DestTable="1222" FKFields="name=posper_role_name\n" FKFieldsComments="\n" relDirection="1" 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="1285" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="36" />

<RELATION ID="1294" RelationName="P\k-\gRP" Kind="1" SrcTable="1287" DestTable="1293" FKFields="name=posper_permission_name\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="1297" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="39" />

<RELATION ID="1295" RelationName="RP\k-\gR" Kind="1" SrcTable="1165" DestTable="1293" FKFields="name=posper_role_name\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="1299" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="40" />

<RELATION ID="1309" RelationName="PL\k-\gP" Kind="1" SrcTable="1134" DestTable="1308" FKFields="id=posper_product_id\n" FKFieldsComments="\n" relDirection="1" 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="1312" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="41" />

<RELATION ID="1310" RelationName="PL\k-\gL" Kind="1" SrcTable="1024" DestTable="1308" FKFields="id=posper_location_id\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="1314" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="42" />

<RELATION ID="1323" RelationName="TL\k-\gP" Kind="2" SrcTable="1134" DestTable="1204" FKFields="id=posper_product_id\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="1324" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="42" />

<RELATION ID="1326" RelationName="P\k-\gSD" Kind="1" SrcTable="1134" DestTable="1325" FKFields="id=posper_product_id\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="1329" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="44" />

<RELATION ID="1327" RelationName="L\k-\gSD" Kind="1" SrcTable="1024" DestTable="1325" FKFields="id=posper_location_id\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="1331" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="45" />

<RELATION ID="1342" RelationName="C\k.-\gC" Kind="2" SrcTable="1098" DestTable="1098" FKFields="id=posper_category_id\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="1344" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="45" />

<RELATION ID="1358" RelationName="CR\k-\gTC" Kind="1" SrcTable="1089" DestTable="1357" FKFields="id=posper_cashregister_id\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="1361" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="49" />

<RELATION ID="1359" RelationName="TC\k-\gT" Kind="1" SrcTable="1182" DestTable="1357" FKFields="id=posper_ticket_id\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="1363" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="50" />

<RELATION ID="1439" RelationName="P\k-\gF" Kind="2" SrcTable="1014" DestTable="1041" FKFields="id=posper_floor_id\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="1441" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="54" />

<RELATION ID="1454" RelationName="TL\k-\gTX" Kind="2" SrcTable="1174" DestTable="1204" FKFields="id=posper_tax_id\n" FKFieldsComments="\n" relDirection="1" 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="1455" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="55" />

<RELATION ID="1465" RelationName="I\k-\gIR" Kind="2" SrcTable="1107" DestTable="1463" FKFields="id=posper_image_id\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="1467" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="58" />

<RELATION ID="1475" RelationName="P\k-\gP" Kind="2" SrcTable="1287" DestTable="1287" FKFields="name=posper_permission_name\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="1477" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="59" />

<RELATION ID="1505" RelationName="TL\k-\gT" Kind="2" SrcTable="1182" DestTable="1204" FKFields="id=posper_ticket_id\n" FKFieldsComments="\n" relDirection="1" 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="1507" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="53" />

<RELATION ID="1510" RelationName="P\k-\gT" Kind="2" SrcTable="1182" DestTable="1126" FKFields="id=posper_ticket_id\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="1512" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="54" />

</RELATIONS> <NOTES> </NOTES> <IMAGES> </IMAGES> </METADATA> <PLUGINDATA> <PLUGINDATARECORDS> </PLUGINDATARECORDS> </PLUGINDATA> <QUERYDATA> <QUERYRECORDS> </QUERYRECORDS> </QUERYDATA> <LINKEDMODELS> </LINKEDMODELS> </DBMODEL>