text:
Using POSper/Developer guide/Stable/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>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


text:
Using POSper/Developer guide/Stable/SQL Queries

Postgres Total Sales Per Date: SELECT date(tickets.datenew), SUM(productsout.price*productsout.units) AS total FROM tickets LEFT OUTER JOIN productsout ON tickets.ticketid=productsout.ticketid GROUP BY date ORDER BY date Totals per product, per date, within a date range: SELECT date(datenew) AS theDate, name, SUM(units * price) AS price FROM productsout LEFT OUTER JOIN products ON productsout.product=products.reference LEFT OUTER JOIN tickets on productsout.ticketid=tickets.ticketid

WHERE datenew BETWEEN '2006/2/16' AND '2006/2/19:23:59'

GROUP BY date(datenew),name ORDER BY date(datenew),name Reset Database without removing products ?

MySQL: Reset database without removing products TRUNCATE `posper_ticketline`; TRUNCATE `posper_payment`; TRUNCATE `posper_ticket`;

TRUNCATE `posper_ticketcreationgenerator`; ALTER TABLE `posper_ticketcreationgenerator` AUTO_INCREMENT=1;

TRUNCATE `posper_ticketidgenerator`; ALTER TABLE `posper_ticketidgenerator` AUTO_INCREMENT=1;

TRUNCATE `posper_cashregister`;

license: Creative Commons - Attribution Share-Alike - https://creativecommons.org/licenses/by-sa/4.0/


text:
Using POSper/Developer guide/Unstable

Contents

 * Architectural description
 * How startup works
 * Build process

title: Using POSper/Developer guide/Unstable


text:
Using POSper/Developer guide/Unstable/Architectural description

POSper uses the Java Plugin Framework to modularize functionality. Use of this framework is an ongoing process, and there are still many parts able to be split out. At the moment there are three modules: Core, Reports , and Openbravosync


text:
Fundamentals of Transportation/Horizontal Curves

Horizontal Curves are one of the two important transition elements in geometric design for highways (along with Vertical Curves). A horizontal curve provides a transition between two tangent strips of roadway, allowing a vehicle to negotiate a turn at a gradual rate rather than a sharp cut. The design of the curve is dependent on the intended design speed for the roadway, as well as other factors including drainage and friction. These curves are semicircles as to provide the driver with a constant turning rate with radii determined by the laws of physics surrounding centripetal force.

Physics Properties

Aside from momentum, when a vehicle makes a turn, two forces are acting upon it. The first is gravity, which pulls the vehicle toward the ground. The second is centrifugal force, for which its opposite, centripetal acceleration is required to keep the vehicle on a curved path. For any given velocity, the centripetal force needs to be greater for a tighter turn (one with a smaller radius) than a broader one (one with a larger radius). On a level surface, side friction $$f_s$$ serves as a countering force to the centrifugal force, but it generally provides very little resistance/force. Thus, a vehicle has to make a very wide circle in order to make a turn on the level.

Given that road designs usually are limited by very narrow design areas, wide turns are generally discouraged. To deal with this issue, designers of horizontal curves incorporate roads that are tilted at a slight angle. This tilt is defined as superelevation, or $$e$$, which is the amount of rise seen on an angled cross-section of a road given a certain run, otherwise known as slope. The presence of superelevation on a curve allows some of the centripetal force to be countered by the ground, thus allowing the turn to be executed at a faster rate than would be allowed on a flat surface. Superelevation also plays another important role by aiding in drainage during precipitation events, as water runs off the road rather than collecting on it. Generally, superelevation is limited to being less than 14 percent, as engineers need to account for stopped vehicles on the curve, where centripetal force is not present.

The allowable radius $$R$$ for a horizontal curve can then be determined by knowing the intended design velocity $$V$$, the coefficient of friction, and the allowed superelevation on the curve.

$$R = \frac \,\!$$

With this radius, practitioners can determine the degree of curve to see if it falls within acceptable standards. Degree of curve, $$D_a$$, can be computed through the following formula, which is given in Metric.

$$\%R = \frac \%\,\!$$

Where:
 * $$D_a\,\!$$= Degree of curve [angle subtended by a 30.5-m (100 ft) arc along the horizontal curve

Application of Superelevation
One place you will see steep banking is at automobile racetracks. These tracks do not operate in winter, and so can avoid the problems of banking in winter weather. Drivers are also especially skilled, though crashes are not infrequent. For NASCAR fans, the following table may be of interest.

Table: Banking at US Racetracks

Source: Fantasy Racing Zone by FSN

Geometric Properties

Horizontal curves occur at locations where two roadways intersect, providing a gradual transition between the two. The intersection point of the two roads is defined as the Point of Tangent Intersection (PI). The location of the curve's start point is defined as the Point of Curve (PC) while the location of the curve's end point is defined as the Point of Tangent (PT). The PC is a distance $$T$$ from the PI, where $$T$$ is defined as Tangent Length. Tangent Length can be calculated by finding the central angle of the curve, in degrees. This angle is equal to the supplement of the interior angle between the two road tangents.

$$T = R\tan \left( {\frac{\Delta }{2}} \right) \,\!$$

Where:
 * $$T\,\!$$= tangent length (in length units)
 * $$\Delta\,\!$$= central angle of the curve, in degrees
 * $$R\,\!$$= curve radius (in length units)

The PT is a distance $$L$$ from the PC where $$L$$ is defined as Curve Length. Curve length can be determined using the formula for semicircle length:

$$L = \frac \,\!$$

The distance between the PI and the vertex of the curve can be easily calculated by using the property of right triangles with $$T$$ and $$R$$. Taking this distance and subtracting off the curve radius $$R$$, the external distance $$E$$, which is the smallest distance between the curve and PI, can be found.

$$E = R\left( {\frac{1} - 1} \right) \,\!$$

Where:
 * $$E\,\!$$= external distance (in length units)

Similarly, the middle ordinate $$M$$ can be found. The middle ordinate is the maximum distance between a line drawn between PC and PT and the curve. It falls along the line between the curve's vertex and the PI.

$$M = R\left( {1 - \cos \left( {\frac{\Delta }{2}} \right)} \right) \,\!$$

Where:
 * $$M\,\!$$= middle ordinate (in length units)

Similarly, the geometric formula for chord length can find $$C$$, which represents the chord length for this curve.

$$C = 2R\sin \left( {\frac{\Delta }{2}} \right) \,\!$$

Sight Distance Properties

Unlike straight, level roads that would have a clear line of sight for a great distance, horizontal curves pose a unique challenge. Natural terrain within the inside of the curve, such as trees, cliffs, or buildings, can potentially block a driver's view of the upcoming road if placed too close to the road. As a result, the acceptable design speed is often reduced to account for sight distance restrictions.

Two scenarios exist when computing the acceptable sight distance for a given curve. The first is where the sight distance is determined to be less than the curve length. The second is where the sight distance exceeds the curve length. Each scenario has a respective formula that produces sight distance based on geometric properties. Determining which scenario is the correct one often requires testing both to find out which is true.

Given a certain sight distance $$S$$ and a known curve length $$L$$ and inner lane centerline radius $$R_v$$, the distance a sight obstruction can be from the interior edge of the road, $$M_s$$ can be computed in the following formulas.

$$S < L: M_s = R_v\left( {1 - \cos \frac{R_v}} \right) \,\!$$

$$S> L: M_s = R_v\left( {1 - \cos \frac{R_v}} \right) + \left( {\frac{2}} \right)\sin \left( {\frac{R_v}} \right) \,\!$$

Demonstrations

 * Flash animation: Roadside Clear Zone (by Karen Dixon and Thomas Wall)
 * Flash animation: Superelevation (by Karen Dixon and Thomas Wall)

Sample Problem
Problem (Solution)

Demonstrations

 * Video: Horizontal alignment, horizontal transition and superelevation

Additional Questions

 * Homework
 * Additional Questions

Variables

 * $$R$$ - Centerline Curve Radius
 * $$D_a$$ - Degree of curve [angle subtended by a 30.5-m (100 ft) arc along the horizontal curve
 * $$T$$ - tangent length (in length units)
 * $$\Delta$$ - Deflection angle of curve tangents. Also central angle of the curve, in degrees.
 * $$E$$ - External. Smallest distance between the curve and PI
 * $$M$$ - Middle ordinate
 * $$L$$ - Curve Length
 * $$C$$ - Chord Length
 * $$S$$ - Sight Distance
 * $$M_s$$ - Acceptable distance from inner edge of road for a sight obstruction to be placed without impeding sight distance
 * $$R_v$$ - Radius of innermost lane centerline

Key Terms

 * PC: Point of Curve
 * PI: Point of Tangent Intersect
 * PT: Point of Tangent


text:
Fundamentals of Transportation/Grade

Road Vehicle Performance forms the basics that make up highway design guidelines and traffic analysis. Roads need to designed so that the vehicles traveling upon them are accommodated. For example, the Interstate Highway system in the United States has a maximum allowable grade that can be used, so that the semitrucks that frequently use these roads would be able to travel them without encountering grade problems. While this can pose quite a design challenge in mountainous regions like Colorado Rockies, without it those trucks would be forced to find better alternative routes, which costs time and money. The ability of a certain vehicle type to use a road is dependent on the power produced by its motor, as well as other road-based and environmental characteristics. When choosing a road design, these elements need to be considered.

Illustration

How steep is the grade in San Francisco? The famous Lombard Street, the curviest street in the world only has a grade of 14.3%. Sources vary on the steepest street in San Francisco. Filbert Street between Hyde and Leavenworth has a grade of 31.5%, Prentiss between Chapman and Powhattan reportedly has a grade of 37%.

Driving in San Francisco at times is like a roller coaster, you can’t see below the nose of your car sitting at the top of the hill, though you can usually see the base of the hill.

What is max grade allowed by law?

Maximum grade is not regulated so much by law as by engineering standards. Maximum grade varies by type of road, and expected speed. In practice, it depends on the alternatives: Is the alternative no road at all? Max grade in the relatively flat Minnesota might be lower than Max grade in mountainous Colorado where there are fewer alternatives. Some typical values for illustration:
 * An interstate is out of standard if it has a grade > 7%.
 * The National Road (built in 1806) had a maximum grade of 8.75%.
 * Local roads are much higher (12% or 15% are sometimes allowed)
 * Otter Tail MN County roads 6%, alleys 8%
 * Driveways can be as much as 30% for a short distance

Fundamental Characteristics
Tractive effort and resistance are the two main forces that oppose one another and determine the performance of roadway vehicles. Tractive effort is the force exerted against the roadway surface to allow a vehicle to move forward. Resistance encompasses all forces that push back and impede motion. Both of these are in units of force. The general formula for this is outlined below:

$$ F_t  = ma + R_a  + R_{rl}  + R_g  \,\!$$

Where:
 * $$F_t\,\!$$ = Tractive Effort
 * $$m\,\!$$ = Vehicle Mass
 * $$a\,\!$$ = Acceleration
 * $$R_a\,\!$$ = Aerodynamic Resistance
 * $$R_{rl}\,\!$$ = Rolling Resistance
 * $$R_g\,\!$$ = Grade Resistance

These components are discussed in greater detail in the following sections.

Aerodynamic Resistance
Aerodynamic resistance is a force that is produced by turbulent air flow around the vehicle body. This turbulence is dependent on the shape of the vehicle, as well as the friction of air passing over the vehicle's surface. A small portion of this resistance comes from air flow through vehicle components, such as interior ventilation. This resistance can be estimated through the following formula:

$$R_a = \frac{\rho }{2}AC_D V ^2 \,\!$$

Where:

 * $$\rho\,\!$$ = Air Density
 * $$A\,\!$$ = Frontal area of the vehicle
 * $$C_D\,\!$$ = Coefficient of Drag
 * $$V\,\!$$ = Speed of the vehicle

Air density is a function of elevation and temperature. Frontal area and coefficient of drag are generally unique to each vehicle or type of vehicle.

Rolling Resistance
Rolling resistance is caused by the interaction of tires with the roadway surface. Three main causes exist that create this resistance. The first is the rigidity of the tire and the roadway surface. The second is tire pressure and temperature. The third is vehicular operating speed. This value of rolling friction can be calculated from a very simplified formula, given here in metric. $$V$$ is in meters per second.

$$f_{rl} = 0.01(1+\frac)\,\!$$

The resistance caused by this friction will increase as weight is added to the vehicle. Therefore, rolling resistance can be calculated.

$$R_{rl} = f_{rl}W\,\!$$

Where:

 * $$W\,\!$$ = Vehicle Weight
 * $$f_{rl}\,\!$$ = Rolling Friction

Grade Resistance
Grade resistance is the simplest form of resistance. It is the gravitational force acting on the vehicle. This force may not be exactly perpendicular to the roadway surface, especially in situations when a grade is present. Thus, grade resistance can be calculated in the following formula:

$$R_g = WG\,\!$$

Where:

 * $$W\,\!$$ = Vehicle Weight
 * $$G\,\!$$ = Grade (length/length)

Tractive Effort
Tractive effort is the force that allows the vehicle to move forward, subject to the resistances of the previous three forces. The derivation of the formula comes from understanding the forces and moments that on around the various tires. It can be summarized into a simple concept, illustrated here.

For a rear-wheel drive car:

$$F_{max} = \frac\,\!$$

For a front-wheel drive car:

$$F_{max} = \frac\,\!$$

Where:

 * $$F_{max}\,\!$$ = Maximum Tractive Effort
 * $$\mu\,\!$$ = Coefficient of road adhesion
 * $$W\,\!$$ = Vehicle Weight
 * $$l_r\,\!$$ = Distance from rear axle to vehicle's center of gravity
 * $$l_f\,\!$$ = Distance from front axle to vehicle's center of gravity
 * $$f_{rl}\,\!$$ = Coefficient of rolling friction
 * $$h\,\!$$ = Height of the center of gravity above the roadway surface
 * $$L\,\!$$ = Length of wheelbase

Grade Computation
Most of the work surrounding tractive effort is geared toward determining the allowable grade of a given roadway. With a certain known vehicle type using this road, the grade can be easily calculated. Using the force balance equation for tractive effort, a value for grade can be separating, producing the formula below:

$$G = \frac{W} \,\!$$

This calculation produces the maximum grade allowed for a given vehicle type. It assumes that the vehicle is operating at optimal engine capacity and, thus, no acceleration can occur, dropping that element from the overall equation.

Thought Question
Problem

Why is it that, in mountainous country, trucks and cars have different speed limits?

Answer

Tractive effort is one of the leading reasons, as trucks have a harder time going up steep hills than typical passenger cars, but it is not the only one. Safety is another leading reason, surprisingly, as big rig trucks are obviously more difficult to control in a harsh environment, such as a mountain pass.

Sample Problem
Problem (Solution)

Additional Questions

 * Homework
 * Additional Questions

Variables

 * $$F_t$$ - Tractive Effort Force
 * $$F_a$$ - Aerodynamic resistance Force
 * $$F_{rl}$$ - Rolling Resistance Force
 * $$F_g$$ - Grade Resistance Force
 * $$W$$ - Vehicle Weight
 * $$m$$ - Vehicle Mass
 * $$a$$ - Acceleration
 * $$\rho$$ - Air Density
 * $$A$$ - Frontal area of the vehicle
 * $$C_D$$ - Coefficient of Drag
 * $$V$$ - Speed of the vehicle
 * $$f_{rl}$$ - Rolling Friction
 * $$G$$ - Grade
 * $$\mu$$ - Coefficient of road adhesion
 * $$l_r$$ - Distance from rear axle to vehicle's center of gravity
 * $$l_f$$ - Distance from front axle to vehicle's center of gravity
 * $$h$$ - Height of the center of gravity above the roadway surface
 * $$L$$ - Length of wheelbase

Key Terms

 * Tractive Effort
 * Aerodynamic Resistance
 * Rolling Resistance
 * Grade Resistance

title: Fundamentals of Transportation/Grade


text:
Fundamentals of Transportation/Vertical Curves

Vertical Curves are the second of the two important transition elements in geometric design for highways, the first being Horizontal Curves. A vertical curve provides a transition between two sloped roadways, allowing a vehicle to negotiate the elevation rate change at a gradual rate rather than a sharp cut. The design of the curve is dependent on the intended design speed for the roadway, as well as other factors including drainage, slope, acceptable rate of change, and friction. These curves are parabolic and are assigned stationing based on a horizontal axis.

Parabolic Formulation

Two types of vertical curves exist: (1) Sag Curves and (2) Crest Curves. Sag curves are used where the change in grade is positive, such as valleys, while crest curves are used when the change in grade is negative, such as hills. Both types of curves have three defined points: PVC (Point of Vertical Curve), PVI (Point of Vertical Intersection), and PVT (Point of Vertical Tangency). PVC is the start point of the curve while the PVT is the end point. The elevation at either of these points can be computed as $$e_{PVC}$$ and $$e_{PVT}$$ for PVC and PVT respectively. The roadway grade that approaches the PVC is defined as $$g_1$$ and the roadway grade that leaves the PVT is defined as $$g_2$$. These grades are generally described as being in units of (m/m) or (ft/ft), depending on unit type chosen.

Both types of curves are in parabolic form. Parabolic functions have been found suitable for this case because they provide a constant rate of change of slope and imply equal curve tangents, which will be discussed shortly. The general form of the parabolic equation is defined below, where $$y$$ is the elevation for the parabola.

$$y = ax^2 + bx + c\,\!$$

At x = 0, which refers to the position along the curve that corresponds to the PVC, the elevation equals the elevation of the PVC. Thus, the value of $$c$$ equals $$e_{PVC}$$. Similarly, the slope of the curve at x = 0 equals the incoming slope at the PVC, or $$g_1$$. Thus, the value of $$b$$ equals $$g_1$$. When looking at the second derivative, which equals the rate of slope change, a value for $$a$$ can be determined.

$$a = \frac\,\!$$

Thus, the parabolic formula for a vertical curve can be illustrated.

$$y = e_{PVC} + g_1x + \frac \,\!$$

Where:

 * $$e_{pvc}\,\!$$: elevation of the PVC
 * $$g_1\,\!$$: Initial Roadway Grade (m/m)
 * $$g_2\,\!$$: Final Roadway Grade (m/m)
 * $$L\,\!$$: Length of Curve (m)

Most vertical curves are designed to be Equal Tangent Curves. For an Equal Tangent Curve, the horizontal length between the PVC and PVI equals the horizontal length between the PVI and the PVT. These curves are generally easier to design.

Offset
Some additional properties of vertical curves exist. Offsets, which are vertical distances from the initial tangent to the curve, play a significant role in vertical curve design. The formula for determining offset is listed below.

$$Y = \frac\,\!$$

Where:

 * $$A\,\!$$: The absolute difference between $$g_2$$ and $$g_1$$, multiplied by 100 to translate to a percentage
 * $$L\,\!$$: Curve Length
 * $$x\,\!$$: Horizontal distance from PVC along curve

Stopping Sight Distance
Sight distance is dependent on the type of curve used and the design speed. For crest curves, sight distance is limited by the curve itself, as the curve is the obstruction. For sag curves, sight distance is generally only limited by headlight range. AASHTO has several tables for sag and crest curves that recommend rates of curvature, $$K$$, given a design speed or stopping sight distance. These rates of curvature can then be multiplied by the absolute slope change percentage, $$A$$ to find the recommended curve length, $$L_m$$.

$$L_m = KA\,\!$$

Without the aid of tables, curve length can still be calculated. Formulas have been derived to determine the minimum curve length for required sight distance for an equal tangent curve, depending on whether the curve is a sag or a crest. Sight distance can be computed from formulas in other sections (See Sight Distance).

Crest Vertical Curves
The correct equation is dependent on the design speed. If the sight distance is found to be less than the curve length, the first formula below is used, whereas the second is used for sight distances that are greater than the curve length. Generally, this requires computation of both to see which is true if curve length cannot be estimated beforehand.

$$SL: L_m = 2S - \frac{A} \,\!$$

Where:

 * $$L_m\,\!$$: Minimum Curve Length (m)
 * $$A\,\!$$: The absolute difference between $$g_2$$ and $$g_1$$, multiplied by 100 to translate to a percentage
 * $$S\,\!$$: Sight Distance (m)
 * $$h_1\,\!$$: Height of driver's eye above roadway surface (m)
 * $$h_2\,\!$$: Height of objective above roadway surface (m)

Sag Vertical Curves
Just like with crest curves, the correct equation is dependent on the design speed. If the sight distance is found to be less than the curve length, the first formula below is used, whereas the second is used for sight distances that are greater than the curve length. Generally, this requires computation of both to see which is true if curve length cannot be estimated beforehand.

$$SL: L_m = 2S - \frac{A} \,\!$$

Where:

 * $$A\,\!$$: The absolute difference between $$g_2$$ and $$g_1$$, multiplied by 100 to translate to a percentage
 * $$S\,\!$$: Sight Distance (m)
 * $$H\,\!$$: Height of headlight (m)
 * $$\beta\,\!$$: Inclined angle of headlight beam, in degrees

To find the position of the low point on a SAG vertical curve: x is the horizontal distance between the PVC and Low Point

$$x = \frac \,\!$$

 * $$G1\,\!$$: Grade Down (%)
 * $$G2\,\!$$: Grade Up (%)
 * $$L\,\!$$: Length of Vertical Curve (station) ei. 600 ft =6

Passing Sight Distance
In addition to stopping sight distance, there may be instances where passing may be allowed on vertical curves. For sag curves, this is not an issue, as even at night, a vehicle in the opposing can be seen from quite a distance (with the aid of the vehicle's headlights). For crest curves, however, it is still necessary to take into account. Like with the stopping sight distance, two formulas are available to answer the minimum length question, depending on whether the passing sight distance is greater than or less than the curve length. These formulas use units that are in metric.

$$SL: L_m = 2PSD - \frac{A} \,\!$$

Where:

 * $$A\,\!$$: The absolute difference between $$g_2$$ and $$g_1$$, multiplied by 100 to translate to a percentage
 * $$PSD\,\!$$: Passing Sight Distance (m)
 * $$L_m\,\!$$: Minimum curve length (m)

Demonstrations

 * Flash animation: Stopping Sight Distance on Crest Vertical Curve (contributed by Oregon State University faculty and students)
 * Flash animation: Stopping Sight Distance on Sag Vertical Curve (contributed by Oregon State University faculty and students)
 * Video: Vertical Alignment and Sight Distance

Thought Question
Problem

Sag curves have sight distance requirements because of nighttime sight distance constraints. The headlights on cars have a limited angle at which they can shine with bright enough intensity to see objects far off in the distance. If the government were to allow a wider angle of light to be cast out on standard car headlights, would this successfully provide more stopping sight distance?

Solution

Yes, of course. For a single car, which is traveling on a road with many sag curves, the design speed could be increased since more road could be seen. However, when additional cars were added to that same road, problems would begin to appear. With a greater angle of light being cast from headlights, drivers in opposing lanes would be severely blinded, forcing them to slow down to avoid causing an accident. Just think of the last time somebody drove by with their 'brights' on and blinded you. This problem could cause more accidents and force people to slow down, thus producing a net loss overall.

Sample Problem
Problem (Solution)

Additional Questions

 * Homework
 * Additional Questions

Variables

 * $$L$$ - Curve Length
 * $$e$$ - Elevation of designated point, such as PVC, PVT, etc.
 * $$g$$ - Grade
 * $$A$$ - Absolute difference of grade percentages for a certain curve, in percent
 * $$y$$ - Elevation of curve
 * $$Y$$ - Offset between grade tangent from PVC and curve elevation for a specific station
 * $$h_1$$ - Height of driver's eye above roadway surface
 * $$h_2$$ - Height of object above roadway surface
 * $$H$$ - Height of headlight
 * $$\beta$$ - Inclined angle of headlight beam, in degrees
 * $$S$$ - Sight Distance in question
 * $$K$$ - Rate of curvature
 * $$L_m$$ - Minimum Curve Length

Key Terms

 * PVC: Point of Vertical Curves
 * PVI: Point of Vertical Intersection
 * PVT: Point of Vertical Tangent
 * Crest Curve: A curve with a negative grade change (like on a hill)
 * Sag Curve: A curve with a positive grade change (like in a valley)


text:
Using POSper/Developer guide/Unstable/Build Process

This page details the POSper build process/layout/structure using maven.

1) The root directory pom file delegates all the interesting build stuff to the plugins directory.

2) the plugins directory pom file simply enumerates the existing modules, including but not limited to core, where the interesting build stuff happens

The pom files for the various plugins have their own artifact id and name, but they share dependency on the maven-compiler-plugin (to compile themselves), maven-jpf-plugin (because they're all plugins), and maven-surefire-plugin (for testing) in their build/plugins section.

They also all use repo.posper.org and telscenter.org as their repositories, and repo.posper.org as their plugin repository.

The modules other than core are currently limited to build dependencies on jpf and the core plugin. This means that all the stuff they need to get their jobs done (eg, jasper.reports for the reports plugin) they access from what core integrates.

The core module has a whole laundry list of dependencies, many of which are strictly for the other plugins. The one dependency that makes it stand out as the foundation of POSper is the jpf-boot dependency, indicating that the core is needed to boot.


text: User:Radoslav Danchev

title: User:Radoslav Danchev


text:
Using POSper/Developer guide/Unstable/Startup process

1) the startup command from the devel directory is java -jar lib/jpf-boot.jar --entry=JFrmTPV

2) jpf-boot checks for boot.properties, and sees that org.posper.core is the application plugin

3) looks in the plugins directory and finds the plugin.xml configuration for core, reports, and openbravosync and loads them all in

4) the core plugins AppCore is launched, which recognizes JFrmTPV was the entry point (JFrmConfig is the alternative) and JFrmTPV gets launched.


text:
Chess Opening Theory/1. e4/1...c5/2. d4

=Smith-Morra Gambit= The Smith-Morra Gambit is an aggressive pawn sacrifice in order to gain development, this variation of the Sicilian Defense can lead to a sharper - tactical game, but the opening is very rare nowadays.

Pros:

 * Gains development
 * Get white's king castled quicker

Cons:

 * Black is a pawn up
 * Black might have solutions to equalize the game or decline the gambit
 * Only one center pawn since Black took White's d pawn and c pawn

Theory table
.

 * 1. e4 c5 2. d4

title: Chess Opening Theory/1. e4/1...c5/2. d4


text:
Chess Opening Theory/1. e4/1...c5/2. c3

=Sicilian - Alapin Variation= White plays c3 with the aim of avoiding the classic Sicilian lines. As both the Closed Sicilian and Open Sicilian have been extensively studied, their use involves a lot of theory to become comfortable with them. This means low- and mid-rated players (up to Club level) would not be familiar with all the variations of the Sicilian lines, and are prone to traps and gambits.

The Alapin is known as an "anti-Sicilian" as it primarily stems Black’s initiative and helps White gain control of the d4 square.

Named after Semyon Alapin, the opening didn’t become popular until the latter 20th century. It was initially thought that the response 2 ...d5 was too strong a position for Black, but modern analysis has shown it to be more favourable for White.

Black’s response
Since White’s intention with 2.c3 is to then later play d4, Black’s response aims to disrupt this central control.

2 ...d5 used to be the default response, and is still very playable for Black. After 3.exd5 then 3 ...Qxd5, giving Black fast central control and quicker development. Notably, White is unable to bring their knight to c3 as the square is occupied by the c pawn.

2 ...Nf6 has gained popularity. Although not as aggressive for Black, it allows for a more solid structure going into the midgame. The main line follows with 3. e5 Nd5 (3 ...Ne4 is a mistake, as it allows 4. d3, leading to capture of the knight).

2 ...d6 and 2 ...e6 are less common openings, but still playable.

Theory table
.

 * 1. e4 c5 2. c3

title: Chess Opening Theory/1. e4/1...c5/2. c3


text:
Chess Opening Theory/1. e4/1...c5/2. b4

Sicilian Wing Gambit
2. b4 marks the Sicilian Wing Gambit. There are other wing gambits like this using the b-pawn (for instance, the Evans Gambit); however, this wing gambit is the most common one. The b-pawn push tries to undermine Black's c-pawn control of d4.

This gambit is unsound at the top level, and Black can safely accept it. However, it is common in amateur play.

Black's responses
2...cxb4. Black usually accepts the gambit. White is most likely to play 3. a3 to try to develop the knight by either recapturing on a3 or going to c3.

2...d5. Black can always decline the gambit and attack White's e-pawn.

Theory table
'''1. e4 c5 2. b4'''

title: Chess Opening Theory/1. e4/1...c5/2. b4