<?xml version="1.0" encoding="UTF-8"?>
<architect-project version="1.0" appversion="0.9.13">
 <project-name>Supermercado</project-name>
 <print-settings numCopies="1" zoom="1.0" pageNumbersPrinted="true" orientation="1" paperWidth="612.0" paperHeight="792.0" leftBorder="50.0" rightBorder="50.0" topBorder="50.0" bottomBorder="50.0" />
 <project-data-sources>
  <data-source id="DS0">
  </data-source>
  <data-source id="DS2">
   <property key="Connection Type" value="MySQL" />
   <property key="Logical" value="supermercado" />
   <property key="JDBC URL" value="jdbc:mysql://localhost:3306/SUPERMERCADO" />
   <property key="UID" value="root" />
   <property key="PWD" value="melisa" />
   <property key="ca.sqlpower.architect.etl.kettle.database" value="" />
   <property key="ca.sqlpower.architect.etl.kettle.port" value="" />
   <property key="ca.sqlpower.architect.etl.kettle.hostname" value="" />
   <property key="ca.sqlpower.architect.etl.kettle.repos.login" value="" />
   <property key="ca.sqlpower.architect.etl.kettle.repos.password" value="" />
  </data-source>
 </project-data-sources>
 <source-databases>
  <database id="DB0" populated="true" dbcs-ref="DS2" name="supermercado" physicalName="supermercado" >
   <catalog id="CAT1" populated="true" name="information_schema" nativeTerm="database" physicalName="information_schema" >
   </catalog>
   <catalog id="CAT2" populated="true" name="SUPERMERCADO" nativeTerm="database" physicalName="SUPERMERCADO" >
    <table id="TAB3" populated="true" name="GENERO" objectType="TABLE" physicalName="GENERO" remarks="" >
     <folder id="FOL4" populated="true" name="Columns" physicalName="Columns" type="1" >
      <column id="COL5" populated="true" autoIncrement="true" name="ID" nullable="0" physicalName="ID" precision="8" primaryKeySeq="0" referenceCount="1" remarks="" scale="0" sourceDataTypeName="INT" type="4" />
      <column id="COL6" populated="true" autoIncrement="false" name="DESCRICAO" nullable="0" physicalName="DESCRICAO" precision="64" referenceCount="1" remarks="" scale="0" sourceDataTypeName="VARCHAR" type="12" />
     </folder>
     <folder id="FOL7" populated="false" name="Exported Keys" physicalName="Exported Keys" type="3" />
     <folder id="FOL8" populated="false" name="Imported Keys" physicalName="Imported Keys" type="2" />
     <folder id="FOL9" populated="true" name="Indices" physicalName="Indices" type="4" >
      <index id="IDX10" populated="true" clustered="false" index-type="BTREE" name="PRIMARY" physicalName="PRIMARY" primaryKeyIndex="true" qualifier="" unique="true" >
       <index-column id="IDC11" populated="true" ascendingOrDescending="ASCENDING" column-ref="COL5" name="ID" physicalName="ID" />
      </index>
     </folder>
    </table>
    <table id="TAB12" populated="true" name="ITEM" objectType="TABLE" physicalName="ITEM" remarks="" >
     <folder id="FOL13" populated="false" name="Columns" physicalName="Columns" type="1" />
     <folder id="FOL14" populated="false" name="Exported Keys" physicalName="Exported Keys" type="3" />
     <folder id="FOL15" populated="false" name="Imported Keys" physicalName="Imported Keys" type="2" />
     <folder id="FOL16" populated="false" name="Indices" physicalName="Indices" type="4" />
    </table>
    <table id="TAB17" populated="true" name="OPERADOR" objectType="TABLE" physicalName="OPERADOR" remarks="" >
     <folder id="FOL18" populated="false" name="Columns" physicalName="Columns" type="1" />
     <folder id="FOL19" populated="false" name="Exported Keys" physicalName="Exported Keys" type="3" />
     <folder id="FOL20" populated="false" name="Imported Keys" physicalName="Imported Keys" type="2" />
     <folder id="FOL21" populated="false" name="Indices" physicalName="Indices" type="4" />
    </table>
    <table id="TAB22" populated="true" name="PRODUTO" objectType="TABLE" physicalName="PRODUTO" remarks="" >
     <folder id="FOL23" populated="false" name="Columns" physicalName="Columns" type="1" />
     <folder id="FOL24" populated="false" name="Exported Keys" physicalName="Exported Keys" type="3" />
     <folder id="FOL25" populated="false" name="Imported Keys" physicalName="Imported Keys" type="2" />
     <folder id="FOL26" populated="false" name="Indices" physicalName="Indices" type="4" />
    </table>
    <table id="TAB27" populated="true" name="VENDA" objectType="TABLE" physicalName="VENDA" remarks="" >
     <folder id="FOL28" populated="false" name="Columns" physicalName="Columns" type="1" />
     <folder id="FOL29" populated="false" name="Exported Keys" physicalName="Exported Keys" type="3" />
     <folder id="FOL30" populated="false" name="Imported Keys" physicalName="Imported Keys" type="2" />
     <folder id="FOL31" populated="false" name="Indices" physicalName="Indices" type="4" />
    </table>
   </catalog>
   <catalog id="CAT32" populated="false" name="aluguel" nativeTerm="database" physicalName="aluguel" />
   <catalog id="CAT33" populated="false" name="mysql" nativeTerm="database" physicalName="mysql" />
   <relationships>
   </relationships>
  </database>
 </source-databases>
 <target-database id="ppdb" dbcs-ref="DS0">
  <table id="TAB35" populated="true" name="OPERADOR" objectType="TABLE" physicalName="OPERADOR" remarks="" >
   <folder id="FOL36" populated="true" name="Columns" physicalName="Columns" type="1" >
    <column id="COL37" populated="true" autoIncrement="true" autoIncrementSequenceName="OPERADOR_ID_seq" defaultValue="" name="ID" nullable="0" physicalName="ID" precision="10" primaryKeySeq="0" referenceCount="1" remarks="" scale="0" type="4" />
    <column id="COL38" populated="true" autoIncrement="false" autoIncrementSequenceName="OPERADOR_NOME_seq" defaultValue="" name="NOME" nullable="0" physicalName="NOME" precision="100" referenceCount="1" remarks="" scale="0" type="12" />
   </folder>
   <folder id="FOL39" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3" >
   </folder>
   <folder id="FOL40" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2" >
   </folder>
   <folder id="FOL41" populated="true" name="Indices" physicalName="Indices" type="4" >
    <index id="IDX42" populated="true" clustered="false" name="OPERADOR_pk" physicalName="operador_pk" primaryKeyIndex="true" unique="true" >
     <index-column id="IDC43" populated="true" ascendingOrDescending="UNSPECIFIED" column-ref="COL37" name="ID" physicalName="ID" />
    </index>
   </folder>
  </table>
  <table id="TAB44" populated="true" name="VENDA" objectType="TABLE" physicalName="VENDA" remarks="" >
   <folder id="FOL45" populated="true" name="Columns" physicalName="Columns" type="1" >
    <column id="COL46" populated="true" autoIncrement="false" autoIncrementSequenceName="VENDA_ID_seq" defaultValue="" name="ID" nullable="0" physicalName="ID" precision="10" primaryKeySeq="0" referenceCount="2" remarks="" scale="0" type="4" />
    <column id="COL47" populated="true" autoIncrement="false" autoIncrementSequenceName="VENDA_DATA_seq" defaultValue="" name="DATA" nullable="0" physicalName="DATA" precision="10" referenceCount="1" remarks="" scale="0" type="93" />
    <column id="COL48" populated="true" autoIncrement="false" autoIncrementSequenceName="VENDA_CAIXA_seq" defaultValue="" name="CAIXA" nullable="0" physicalName="CAIXA" precision="10" referenceCount="1" remarks="" scale="0" type="4" />
    <column id="COL49" populated="true" autoIncrement="false" autoIncrementSequenceName="VENDA_OPERADOR_ID_seq" defaultValue="" name="OPERADOR_ID" nullable="0" physicalName="OPERADOR_ID" precision="10" referenceCount="1" remarks="" scale="0" type="4" />
   </folder>
   <folder id="FOL50" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3" >
   </folder>
   <folder id="FOL51" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2" >
   </folder>
   <folder id="FOL52" populated="true" name="Indices" physicalName="Indices" type="4" >
    <index id="IDX53" populated="true" clustered="false" name="VENDA_pk" physicalName="venda_pk" primaryKeyIndex="true" unique="true" >
     <index-column id="IDC54" populated="true" ascendingOrDescending="UNSPECIFIED" column-ref="COL46" name="ID" physicalName="ID" />
    </index>
   </folder>
  </table>
  <table id="TAB55" populated="true" name="ITEM" objectType="TABLE" physicalName="ITEM" remarks="" >
   <folder id="FOL56" populated="true" name="Columns" physicalName="Columns" type="1" >
    <column id="COL57" populated="true" autoIncrement="false" autoIncrementSequenceName="ITEM_ID_seq" defaultValue="" name="ID" nullable="0" physicalName="ID" precision="10" primaryKeySeq="0" referenceCount="3" remarks="" scale="0" type="4" />
    <column id="COL58" populated="true" autoIncrement="false" autoIncrementSequenceName="ITEM_VALOR_seq" defaultValue="" name="VALOR" nullable="0" physicalName="VALOR" precision="10" referenceCount="1" remarks="" scale="2" type="3" />
    <column id="COL59" populated="true" autoIncrement="false" autoIncrementSequenceName="ITEM_QUANTIDADE_seq" defaultValue="" name="QUANTIDADE" nullable="0" physicalName="QUANTIDADE" precision="10" referenceCount="1" remarks="" scale="2" type="3" />
    <column id="COL60" populated="true" autoIncrement="false" autoIncrementSequenceName="ITEM_PRODUTO_ID_seq" defaultValue="" name="PRODUTO_ID" nullable="0" physicalName="PRODUTO_ID" precision="10" referenceCount="1" remarks="" scale="0" type="4" />
    <column id="COL61" populated="true" autoIncrement="false" autoIncrementSequenceName="ITEM_VENDA_ID_seq" defaultValue="" name="VENDA_ID" nullable="0" physicalName="VENDA_ID" precision="10" referenceCount="1" remarks="" scale="0" type="4" />
   </folder>
   <folder id="FOL62" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3" >
   </folder>
   <folder id="FOL63" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2" >
   </folder>
   <folder id="FOL64" populated="true" name="Indices" physicalName="Indices" type="4" >
    <index id="IDX65" populated="true" clustered="false" name="ITEM_pk" physicalName="item_pk" primaryKeyIndex="true" unique="true" >
     <index-column id="IDC66" populated="true" ascendingOrDescending="UNSPECIFIED" column-ref="COL57" name="ID" physicalName="ID" />
    </index>
   </folder>
  </table>
  <table id="TAB67" populated="true" name="PRODUTO" objectType="TABLE" physicalName="PRODUTO" remarks="" >
   <folder id="FOL68" populated="true" name="Columns" physicalName="Columns" type="1" >
    <column id="COL69" populated="true" autoIncrement="false" autoIncrementSequenceName="PRODUTO_ID_seq" defaultValue="" name="ID" nullable="0" physicalName="ID" precision="10" primaryKeySeq="0" referenceCount="2" remarks="" scale="0" type="4" />
    <column id="COL70" populated="true" autoIncrement="false" autoIncrementSequenceName="PRODUTO_NOME_seq" defaultValue="" name="NOME" nullable="0" physicalName="NOME" precision="500" referenceCount="1" remarks="" scale="0" type="12" />
    <column id="COL71" populated="true" autoIncrement="false" autoIncrementSequenceName="PRODUTO_VALOR_seq" defaultValue="" name="VALOR" nullable="0" physicalName="VALOR" precision="10" referenceCount="1" remarks="" scale="2" type="3" />
    <column id="COL72" populated="true" autoIncrement="false" autoIncrementSequenceName="PRODUTO_GENERO_ID_seq" defaultValue="" name="GENERO_ID" nullable="0" physicalName="GENERO_ID" precision="10" referenceCount="1" remarks="" scale="0" type="4" />
   </folder>
   <folder id="FOL73" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3" >
   </folder>
   <folder id="FOL74" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2" >
   </folder>
   <folder id="FOL75" populated="true" name="Indices" physicalName="Indices" type="4" >
    <index id="IDX76" populated="true" clustered="false" name="PRODUTO_pk" physicalName="produto_pk" primaryKeyIndex="true" unique="true" >
     <index-column id="IDC77" populated="true" ascendingOrDescending="UNSPECIFIED" column-ref="COL69" name="ID" physicalName="ID" />
    </index>
   </folder>
  </table>
  <table id="TAB78" populated="true" name="GENERO" objectType="TABLE" physicalName="GENERO" remarks="" >
   <folder id="FOL79" populated="true" name="Columns" physicalName="Columns" type="1" >
    <column id="COL80" populated="true" autoIncrement="true" autoIncrementSequenceName="GENERO_ID_seq" defaultValue="" name="ID" nullable="0" physicalName="ID" precision="10" primaryKeySeq="0" referenceCount="1" remarks="" scale="0" type="4" />
    <column id="COL81" populated="true" autoIncrement="false" autoIncrementSequenceName="GENERO_DESCRICAO_seq" defaultValue="" name="DESCRICAO" nullable="0" physicalName="DESCRICAO" precision="100" referenceCount="1" remarks="" scale="0" type="12" />
   </folder>
   <folder id="FOL82" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3" >
   </folder>
   <folder id="FOL83" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2" >
   </folder>
   <folder id="FOL84" populated="true" name="Indices" physicalName="Indices" type="4" >
    <index id="IDX85" populated="true" clustered="false" name="GENERO_pk" physicalName="genero_pk" primaryKeyIndex="true" unique="true" >
     <index-column id="IDC86" populated="true" ascendingOrDescending="UNSPECIFIED" column-ref="COL80" name="ID" physicalName="ID" />
    </index>
   </folder>
  </table>
  <relationships>
   <relationship id="REL87" populated="true" deferrability="7" deleteRule="3" fk-table-ref="TAB44" fkCardinality="7" identifying="false" name="OPERADOR_VENDA_fk" physicalName="operador_venda_fk" pk-table-ref="TAB35" pkCardinality="2" updateRule="3" >
    <column-mapping id="CMP88" populated="true" fk-column-ref="COL49" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL37" />
   </relationship>
   <relationship id="REL89" populated="true" deferrability="7" deleteRule="3" fk-table-ref="TAB55" fkCardinality="7" identifying="false" name="VENDA_ITEM_fk" physicalName="venda_item_fk" pk-table-ref="TAB44" pkCardinality="2" updateRule="3" >
    <column-mapping id="CMP90" populated="true" fk-column-ref="COL61" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL46" />
   </relationship>
   <reference ref-id="REL87" />
   <reference ref-id="REL89" />
   <relationship id="REL91" populated="true" deferrability="7" deleteRule="3" fk-table-ref="TAB55" fkCardinality="7" identifying="false" name="PRODUTO_ITEM_fk" physicalName="produto_item_fk" pk-table-ref="TAB67" pkCardinality="2" updateRule="3" >
    <column-mapping id="CMP92" populated="true" fk-column-ref="COL60" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL69" />
   </relationship>
   <reference ref-id="REL91" />
   <relationship id="REL93" populated="true" deferrability="7" deleteRule="3" fk-table-ref="TAB67" fkCardinality="7" identifying="false" name="GENERO_PRODUTO_fk" physicalName="genero_produto_fk" pk-table-ref="TAB78" pkCardinality="2" updateRule="3" >
    <column-mapping id="CMP94" populated="true" fk-column-ref="COL72" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL80" />
   </relationship>
   <reference ref-id="REL93" />
  </relationships>
 </target-database>
 <ddl-generator type="ca.sqlpower.architect.ddl.MySqlDDLGenerator" allow-connection="false" target-catalog="SUPERMERCADO" target-schema=""> </ddl-generator>
 <create-kettle-job-settings filePath="" jobName="" schemaName="" kettleJoinType="0" savingToFile="true" />
 <play-pen zoom="1.414213562373095" viewportX="0" viewportY="0" relationship-style="rectilinear" names-displayLogicalNames="true" showPrimaryTag="true" showForeignTag="true" showAlternateTag="true" columnVisibility="ALL" relationshipLabelVisibility="true">
  <table-pane table-ref="TAB35" x="33" y="36" bgColor="0xf0f0f0" fgColor="0x000000" rounded="false" dashed="false"/>
  <table-pane table-ref="TAB44" x="15" y="170" bgColor="0xf0f0f0" fgColor="0x000000" rounded="false" dashed="false"/>
  <table-pane table-ref="TAB55" x="111" y="336" bgColor="0xf0f0f0" fgColor="0x000000" rounded="false" dashed="false"/>
  <table-pane table-ref="TAB67" x="243" y="174" bgColor="0xf0f0f0" fgColor="0x000000" rounded="false" dashed="false"/>
  <table-pane table-ref="TAB78" x="236" y="47" bgColor="0xf0f0f0" fgColor="0x000000" rounded="false" dashed="false"/>
  <table-link relationship-ref="REL93" pk-x="75" pk-y="60" fk-x="68" fk-y="0" rLineColor="0x333333" pkLabelText="" fkLabelText="" orientation="132"/>
  <table-link relationship-ref="REL87" pk-x="66" pk-y="60" fk-x="84" fk-y="0" rLineColor="0x333333" pkLabelText="" fkLabelText="" orientation="132"/>
  <table-link relationship-ref="REL89" pk-x="144" pk-y="90" fk-x="48" fk-y="0" rLineColor="0x333333" pkLabelText="" fkLabelText="" orientation="132"/>
  <table-link relationship-ref="REL91" pk-x="26" pk-y="90" fk-x="158" fk-y="0" rLineColor="0x333333" pkLabelText="" fkLabelText="" orientation="132"/>
 </play-pen>
 <profiles topNCount="10">
  </profiles>
  <olap>
  </olap>
  <olap-gui>
  </olap-gui>
</architect-project>

