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
<?xml version="1.0" standalone="yes" ?> <DBMODEL Version="4.0"> <SETTINGS> <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" /> <DATATYPEGROUPS> <DATATYPEGROUP Name="Numeric Types" Icon="1" /> <DATATYPEGROUP Name="Date and Time Types" Icon="2" /> <DATATYPEGROUP Name="String Types" Icon="3" /> <DATATYPEGROUP Name="Blob and Text Types" Icon="4" /> <DATATYPEGROUP Name="User defined Types" Icon="5" /> <DATATYPEGROUP Name="Geographic Types" Icon="6" /> </DATATYPEGROUPS> <DATATYPES> <DATATYPE ID="1" IDGroup="0" TypeName="TINYINT" Description="A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> </PARAMS> <OPTIONS> <OPTION Name="UNSIGNED" Default="1" /> <OPTION Name="ZEROFILL" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="2" IDGroup="0" TypeName="SMALLINT" Description="A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> </PARAMS> <OPTIONS> <OPTION Name="UNSIGNED" Default="1" /> <OPTION Name="ZEROFILL" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="3" IDGroup="0" TypeName="MEDIUMINT" Description="A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> </PARAMS> <OPTIONS> <OPTION Name="UNSIGNED" Default="1" /> <OPTION Name="ZEROFILL" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="4" IDGroup="0" TypeName="INT" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> </PARAMS> <OPTIONS> <OPTION Name="UNSIGNED" Default="0" /> <OPTION Name="ZEROFILL" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="5" IDGroup="0" TypeName="INTEGER" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> </PARAMS> <OPTIONS> <OPTION Name="UNSIGNED" Default="1" /> <OPTION Name="ZEROFILL" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="6" IDGroup="0" TypeName="BIGINT" Description="A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> </PARAMS> <OPTIONS> <OPTION Name="UNSIGNED" Default="0" /> <OPTION Name="ZEROFILL" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="7" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="precision" /> </PARAMS> <OPTIONS> <OPTION Name="ZEROFILL" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="8" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> <PARAM Name="decimals" /> </PARAMS> <OPTIONS> <OPTION Name="ZEROFILL" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="9" IDGroup="0" TypeName="DOUBLE" Description="A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> <PARAM Name="decimals" /> </PARAMS> <OPTIONS> <OPTION Name="ZEROFILL" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="10" IDGroup="0" TypeName="DOUBLE PRECISION" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> <PARAM Name="decimals" /> </PARAMS> <OPTIONS> <OPTION Name="ZEROFILL" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="11" IDGroup="0" TypeName="REAL" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> <PARAM Name="decimals" /> </PARAMS> <OPTIONS> <OPTION Name="ZEROFILL" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="12" IDGroup="0" TypeName="DECIMAL" Description="An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> <PARAM Name="decimals" /> </PARAMS> <OPTIONS> <OPTION Name="ZEROFILL" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="13" IDGroup="0" TypeName="NUMERIC" Description="This is a synonym for DECIMAL." ParamCount="2" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> <PARAM Name="decimals" /> </PARAMS> <OPTIONS> <OPTION Name="ZEROFILL" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="14" IDGroup="1" TypeName="DATE" Description="A date. The supported range is \a1000-01-01\a to \a9999-12-31\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="15" IDGroup="1" TypeName="DATETIME" Description="A date and time combination. The supported range is \a1000-01-01 00:00:00\a to \a9999-12-31 23:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="16" IDGroup="1" TypeName="TIMESTAMP" Description="A timestamp. The range is \a1970-01-01 00:00:00\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> </PARAMS> </DATATYPE> <DATATYPE ID="17" IDGroup="1" TypeName="TIME" Description="A time. The range is \a-838:59:59\a to \a838:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="18" IDGroup="1" TypeName="YEAR" Description="A year in 2- or 4-digit format (default is 4-digit)." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> </PARAMS> </DATATYPE> <DATATYPE ID="19" IDGroup="2" TypeName="CHAR" Description="A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> </PARAMS> <OPTIONS> <OPTION Name="BINARY" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="20" IDGroup="2" TypeName="VARCHAR" Description="A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="length" /> </PARAMS> <OPTIONS> <OPTION Name="BINARY" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="21" IDGroup="2" TypeName="BIT" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="22" IDGroup="2" TypeName="BOOL" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="23" IDGroup="3" TypeName="TINYBLOB" Description="A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="24" IDGroup="3" TypeName="BLOB" Description="A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="25" IDGroup="3" TypeName="MEDIUMBLOB" Description="A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="26" IDGroup="3" TypeName="LONGBLOB" Description="A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="27" IDGroup="3" TypeName="TINYTEXT" Description="A column maximum length of 255 (2^8 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="28" IDGroup="3" TypeName="TEXT" Description="A column maximum length of 65535 (2^16 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="29" IDGroup="3" TypeName="MEDIUMTEXT" Description="A column maximum length of 16777215 (2^24 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="30" IDGroup="3" TypeName="LONGTEXT" Description="A column maximum length of 4294967295 (2^32 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="31" IDGroup="3" TypeName="ENUM" Description="An enumeration. A string object that can have only one value, chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="values" /> </PARAMS> </DATATYPE> <DATATYPE ID="32" IDGroup="3" TypeName="SET" Description="A set. A string object that can have zero or more values, each of which must be chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <PARAMS> <PARAM Name="values" /> </PARAMS> </DATATYPE> <DATATYPE ID="33" IDGroup="4" TypeName="Varchar(20)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <OPTIONS> <OPTION Name="BINARY" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="34" IDGroup="4" TypeName="Varchar(45)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <OPTIONS> <OPTION Name="BINARY" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="35" IDGroup="4" TypeName="Varchar(255)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > <OPTIONS> <OPTION Name="BINARY" Default="0" /> </OPTIONS> </DATATYPE> <DATATYPE ID="36" IDGroup="5" TypeName="GEOMETRY" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="38" IDGroup="5" TypeName="LINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="39" IDGroup="5" TypeName="POLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="40" IDGroup="5" TypeName="MULTIPOINT" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="41" IDGroup="5" TypeName="MULTILINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="42" IDGroup="5" TypeName="MULTIPOLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> <DATATYPE ID="43" IDGroup="5" TypeName="GEOMETRYCOLLECTION" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" > </DATATYPE> </DATATYPES> <COMMON_DATATYPES> <COMMON_DATATYPE ID="5" /> <COMMON_DATATYPE ID="8" /> <COMMON_DATATYPE ID="20" /> <COMMON_DATATYPE ID="15" /> <COMMON_DATATYPE ID="22" /> <COMMON_DATATYPE ID="28" /> <COMMON_DATATYPE ID="26" /> <COMMON_DATATYPE ID="33" /> <COMMON_DATATYPE ID="34" /> <COMMON_DATATYPE ID="35" /> </COMMON_DATATYPES> <TABLEPREFIXES> <TABLEPREFIX Name="Default (no prefix)" /> </TABLEPREFIXES> <REGIONCOLORS> <REGIONCOLOR Color="Red=#FFEEEC" /> <REGIONCOLOR Color="Yellow=#FEFDED" /> <REGIONCOLOR Color="Green=#EAFFE5" /> <REGIONCOLOR Color="Cyan=#ECFDFF" /> <REGIONCOLOR Color="Blue=#F0F1FE" /> <REGIONCOLOR Color="Magenta=#FFEBFA" /> </REGIONCOLORS> <POSITIONMARKERS> <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" /> </POSITIONMARKERS> </SETTINGS> <METADATA> <REGIONS> <REGION ID="1502" RegionName="Region_02" XPos="542" YPos="409" Width="1670" Height="1487" RegionColor="3" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="52" /> <REGION ID="1380" RegionName="Region_01" XPos="30" YPos="592" Width="441" Height="545" RegionColor="0" TablePrefix="0" TableType="0" OverwriteTablePrefix="0" OverwriteTableType="0" Comments="" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="52" /> </REGIONS> <TABLES> <TABLE ID="1014" Tablename="posper_floor" PrevTableName="Table_02" XPos="1951" YPos="1196" 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="This is the table for a restaurant \Afloor\A. A floor represents a physical space in a restaurant that typically has a bunch of tables where customers sit and eat..." Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="3" > <COLUMNS> <COLUMN ID="1016" 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="1257" 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="1019" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" 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="1020" 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="1021" ColName="name" PrevColName="" Pos="3" idDatatype="20" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="user assigned floor name"> <OPTIONSELECTED> <OPTIONSELECT Value="0" /> </OPTIONSELECTED> </COLUMN> </COLUMNS> <RELATIONS_START> <RELATION_START ID="1439" /> </RELATIONS_START> <RELATIONS_END> <RELATION_END ID="1256" /> </RELATIONS_END> <INDICES> <INDEX ID="1017" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1"> <INDEXCOLUMNS> <INDEXCOLUMN idColumn="1016" LengthParam="0" /> </INDEXCOLUMNS> </INDEX> <INDEX ID="1258" IndexName="Floor_FKIndex1" IndexKind="1" FKRefDef_Obj_id="1256"> <INDEXCOLUMNS> <INDEXCOLUMN idColumn="1257" LengthParam="0" /> </INDEXCOLUMNS> </INDEX> </INDICES> </TABLE> <TABLE ID="1024" Tablename="posper_location" PrevTableName="Table_03" XPos="1612" YPos="438" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="4" > <COLUMNS> <COLUMN ID="1026" 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="1031" ColName="version" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" 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="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>