<?xml version="1.0" encoding="UTF-8"?>
<architect-project version="1.0" appversion="1.0.8">
 <project-name>Tarefa-04-Normalizacao-Locadora-solucao</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">
   <property key="Logical" value="Modelo de Dados" />
  </data-source>
  <data-source id="DS2">
   <property key="Connection Type" value="PostgreSQL" />
   <property key="Logical" value="Conexao Locadora" />
   <property key="JDBC URL" value="jdbc:postgresql://localhost:5432/Locadora" />
   <property key="UID" value="postgres" />
   <property key="PWD" value="admin" />
   <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" UUID="1ba42b20-55b4-4480-ae0e-34e46762f4f2" dbcs-ref="DS2" name="Conexao Locadora" physicalName="Conexao Locadora" >
   <catalog id="CAT1" populated="true" UUID="a524b2f6-d2d3-4356-98ec-149f7d723935" name="Locadora" nativeTerm="database" physicalName="Locadora" >
    <schema id="SCH2" populated="false" UUID="ef050f90-4673-4b3d-a969-e2aae9369e46" name="information_schema" nativeTerm="schema" physicalName="information_schema" >
    </schema>
    <schema id="SCH3" populated="false" UUID="ffc1bbbe-eec2-4129-a446-b5baba4c1f11" name="pg_catalog" nativeTerm="schema" physicalName="pg_catalog" >
    </schema>
    <schema id="SCH4" populated="true" UUID="e0d02ea1-09e4-40a6-b600-ba8191ddbcf7" name="pg_toast_temp_1" nativeTerm="schema" physicalName="pg_toast_temp_1" >
    </schema>
    <schema id="SCH5" populated="true" UUID="4a4f2487-afb3-4a2f-b677-2dab16e54737" name="public" nativeTerm="schema" physicalName="public" >
    </schema>
   </catalog>
   <relationships>
   </relationships>
  </database>
 </source-databases>
 <target-database id="ppdb" dbcs-ref="DS0">
  <table id="TAB7" populated="true" UUID="b2d1c214-90e4-440f-a7a1-0e40caa1dd18" name="Reserva_locadora" objectType="TABLE" physicalName="Reserva_locadora" >
   <remarks></remarks>
   <folder id="FOLTAB71" populated="true" name="Columns" physicalName="Columns" type="1">
    <column id="COL8" populated="true" UUID="5592ce57-a59e-4050-b1a5-55541d69295b" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_codigo_seq" defaultValue="" name="codigo reserva" nullable="0" physicalName="codigo reserva" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    <column id="COL9" populated="true" UUID="972bb52f-58cb-4d25-b888-e24ed2883b6b" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_data retirada_seq" defaultValue="" name="data retirada" nullable="0" physicalName="data retirada" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="91" userDefinedTypeUUID="ee349be3-6af2-46e1-b305-975f5354b009" >
     <remarks></remarks>
    </column>
    <column id="COL10" populated="true" UUID="f15ea52a-c3cb-43b2-97f5-bee81f0199df" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_data devolucao_seq" defaultValue="" name="data devolucao" nullable="0" physicalName="data devolucao" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="91" userDefinedTypeUUID="ee349be3-6af2-46e1-b305-975f5354b009" >
     <remarks></remarks>
    </column>
    <column id="COL11" populated="true" UUID="6d7c5792-cbd3-43fc-ad1f-c9cf7a463420" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_Tipo de veiculo.codigo tipo_seq" defaultValue="" name="codigo tipo" nullable="0" physicalName="codigo tipo" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="5" userDefinedTypeUUID="69fb547f-e14c-4748-9746-4c0e9e94eb52" >
     <remarks></remarks>
    </column>
    <column id="COL12" populated="true" UUID="ab178d83-76bd-489d-9132-2f7ae9b768e0" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_Cliente.codigo cliente_seq" defaultValue="" name="codigo cliente" nullable="0" physicalName="codigo cliente" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    <column id="COL13" populated="true" UUID="f70009ee-35d5-42aa-a1b8-1d36138c2852" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_Reserva.filial retirada_seq" defaultValue="" name="id filial retirada" nullable="0" physicalName="id filial retirada" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    <column id="COL14" populated="true" UUID="c2092f87-ddc1-47a3-92e4-3c7e6f7ad1f6" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_Reserva.filial retirada_seq" defaultValue="" name="id filial devolucao" nullable="0" physicalName="id filial devolucao" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    </folder>
    <folder id="FOLTAB73" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    </folder>
    <folder id="FOLTAB72" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    </folder>
    <folder id="FOLTAB74" populated="true" name="Indices" physicalName="Indices" type="4">
    <index id="IDX15" populated="true" UUID="25a522ad-2219-4449-ad84-462ed7ae8030" clustered="false" name="Reserva_locadora_pk" physicalName="Reserva_pk" primaryKeyIndex="true" unique="false" >
     <index-column id="IDC16" populated="true" UUID="64a45db3-fcb4-4bdd-b23e-568f8d8b0c7a" ascendingOrDescending="UNSPECIFIED" column-ref="COL8" name="codigo reserva" physicalName="codigo reserva" />
    </index>
   </folder>
  </table>
  <table id="TAB17" populated="true" UUID="622b43bb-1df6-4a73-ba1a-f4cae6797ebc" name="Cliente" objectType="TABLE" physicalName="Cliente" >
   <remarks></remarks>
   <folder id="FOLTAB171" populated="true" name="Columns" physicalName="Columns" type="1">
    <column id="COL18" populated="true" UUID="6d30faec-436e-4fcf-9d60-16990ee64f6e" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_Cliente.codigo cliente_seq" defaultValue="" name="codigo cliente" nullable="0" physicalName="codigo cliente" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    <column id="COL19" populated="true" UUID="368ed236-765c-4841-83e4-1bae7a893855" autoIncrement="false" autoIncrementSequenceName="Cliente_nome_cliente_seq" defaultValue="" name="nome_cliente" nullable="0" physicalName="nome_cliente" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="12" userDefinedTypeUUID="831ac2d4-0e65-47ec-a0b7-62b7f6b8760a" >
     <remarks></remarks>
    </column>
    <column id="COL20" populated="true" UUID="61442be8-b7b1-4edd-a4e4-b433ab1e0f7e" autoIncrement="false" autoIncrementSequenceName="PJ_CNPJ_seq" defaultValue="" name="CNPJ" nullable="0" physicalName="CNPJ" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     <remarks></remarks>
    </column>
    <column id="COL21" populated="true" UUID="699ba762-d89e-46be-bfa4-95eaf923a213" autoIncrement="false" autoIncrementSequenceName="PJ_inscricao_seq" defaultValue="" name="inscricao" nullable="0" physicalName="inscricao" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     <remarks></remarks>
    </column>
    <column id="COL22" populated="true" UUID="320d4d7a-7a39-4a4f-bad1-e86b165cf827" autoIncrement="false" autoIncrementSequenceName="PF_CPF_seq" defaultValue="" name="CPF" nullable="0" physicalName="CPF" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     <remarks></remarks>
    </column>
    <column id="COL23" populated="true" UUID="bde8ef21-1471-4b5a-a156-2496aac52567" autoIncrement="false" autoIncrementSequenceName="PF_SEXO_seq" defaultValue="" name="Sexo" nullable="0" physicalName="Sexo" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     <remarks></remarks>
    </column>
    <column id="COL24" populated="true" UUID="fab3ab55-80df-479a-a2b9-2ec15f5ee1b8" autoIncrement="false" autoIncrementSequenceName="PF_data nascimento_seq" defaultValue="" name="data nascimento" nullable="0" physicalName="data nascimento" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="91" userDefinedTypeUUID="ee349be3-6af2-46e1-b305-975f5354b009" >
     <remarks></remarks>
    </column>
    </folder>
    <folder id="FOLTAB173" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    </folder>
    <folder id="FOLTAB172" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    </folder>
    <folder id="FOLTAB174" populated="true" name="Indices" physicalName="Indices" type="4">
    <index id="IDX25" populated="true" UUID="a3e1f0f5-f1cd-4beb-b69a-bf247b00f709" clustered="false" name="Cliente_pk" physicalName="Cliente_pk" primaryKeyIndex="true" unique="false" >
     <index-column id="IDC26" populated="true" UUID="52faaa94-1ea7-4bef-8dee-21bbbd12ee8c" ascendingOrDescending="UNSPECIFIED" column-ref="COL18" name="codigo cliente" physicalName="codigo cliente" />
    </index>
   </folder>
  </table>
  <table id="TAB27" populated="true" UUID="8970f163-c70f-4da6-9e68-63a23dd3eb3a" name="Filial" objectType="TABLE" physicalName="Filial" >
   <remarks></remarks>
   <folder id="FOLTAB271" populated="true" name="Columns" physicalName="Columns" type="1">
    <column id="COL28" populated="true" UUID="242d9071-c892-4531-83b8-d4176aa2285a" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_Reserva.filial retirada_seq" defaultValue="" name="id filial" nullable="0" physicalName="id filial" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    <column id="COL29" populated="true" UUID="ef9638c3-e061-4a32-9ba6-93481cafc6d9" autoIncrement="false" autoIncrementSequenceName="Filial_nome_seq" defaultValue="" name="nome_filial_retirada" nullable="0" physicalName="nome_filial_retirada" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="12" userDefinedTypeUUID="831ac2d4-0e65-47ec-a0b7-62b7f6b8760a" >
     <remarks></remarks>
    </column>
    </folder>
    <folder id="FOLTAB273" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    </folder>
    <folder id="FOLTAB272" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    </folder>
    <folder id="FOLTAB274" populated="true" name="Indices" physicalName="Indices" type="4">
    <index id="IDX30" populated="true" UUID="206b69cd-0b9f-4ffd-bb73-30c83f6f6368" clustered="false" name="Filial_pk" physicalName="Filial_pk" primaryKeyIndex="true" unique="false" >
     <index-column id="IDC31" populated="true" UUID="8d4c8ae1-568e-44ed-9260-7e29c6978c99" ascendingOrDescending="UNSPECIFIED" column-ref="COL28" name="id filial" physicalName="id filial" />
    </index>
   </folder>
  </table>
  <table id="TAB32" populated="true" UUID="6db8d4a9-b717-4389-a9ef-072308e24e0f" name="Tipo_Veiculo" objectType="TABLE" physicalName="Tipo_Veiculo" >
   <remarks></remarks>
   <folder id="FOLTAB321" populated="true" name="Columns" physicalName="Columns" type="1">
    <column id="COL33" populated="true" UUID="56cbb4df-f7c0-4e4f-ad15-8af038b3ae3f" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_Tipo de veiculo.codigo tipo_seq" defaultValue="" name="codigo tipo" nullable="0" physicalName="codigo tipo" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="5" userDefinedTypeUUID="69fb547f-e14c-4748-9746-4c0e9e94eb52" >
     <remarks></remarks>
    </column>
    <column id="COL34" populated="true" UUID="9e698e44-cb9a-4050-8ae9-e9eb57d7c7fc" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_descricao_tipo_seq" defaultValue="" name="descricao_tipo" nullable="0" physicalName="descricao_tipo" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="12" userDefinedTypeUUID="831ac2d4-0e65-47ec-a0b7-62b7f6b8760a" >
     <remarks></remarks>
    </column>
    <column id="COL35" populated="true" UUID="10cb7e6f-b452-4f65-ba49-d2810a34b6a4" autoIncrement="false" autoIncrementSequenceName="Tipo de veiculo_km revisao_seq" defaultValue="" name="km revisao" nullable="0" physicalName="km revisao" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    <column id="COL36" populated="true" UUID="c09b76fe-cc2c-41c3-8d4e-710e9d386312" autoIncrement="false" autoIncrementSequenceName="Tipo de veiculo_horas revisao_seq" defaultValue="" name="horas revisao" nullable="0" physicalName="horas revisao" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    </folder>
    <folder id="FOLTAB323" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    </folder>
    <folder id="FOLTAB322" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    </folder>
    <folder id="FOLTAB324" populated="true" name="Indices" physicalName="Indices" type="4">
    <index id="IDX37" populated="true" UUID="22e79df5-a098-477f-b9b7-71fdcd536842" clustered="false" name="Tipo_Veiculo_pk" physicalName="Tipo_Veiculo_pk" primaryKeyIndex="true" unique="false" >
     <index-column id="IDC38" populated="true" UUID="f5c81596-6b43-4d02-b576-b6edfff06a17" ascendingOrDescending="UNSPECIFIED" column-ref="COL33" name="codigo tipo" physicalName="codigo tipo" />
    </index>
   </folder>
  </table>
  <table id="TAB39" populated="true" UUID="5511b256-4121-4321-a4eb-cb48810afd11" name="Endereco_Clente" objectType="TABLE" physicalName="Endereco_Clente" >
   <remarks></remarks>
   <folder id="FOLTAB391" populated="true" name="Columns" physicalName="Columns" type="1">
    <column id="COL40" populated="true" UUID="5ba2c82a-3499-4eee-9a15-5e90305ca3e7" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_Cliente.codigo cliente_seq" defaultValue="" name="codigo cliente" nullable="0" physicalName="codigo cliente" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    <column id="COL41" populated="true" UUID="b3856e98-bd71-4395-9d74-3676dc015f3c" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_Rua_seq" defaultValue="" name="Rua" nullable="0" physicalName="Rua" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="12" userDefinedTypeUUID="831ac2d4-0e65-47ec-a0b7-62b7f6b8760a" >
     <remarks></remarks>
    </column>
    <column id="COL42" populated="true" UUID="6b93ead7-3969-450e-b317-9a294fa3141d" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_Numero_seq" defaultValue="" name="Numero" nullable="0" physicalName="Numero" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    <column id="COL43" populated="true" UUID="3d625b3e-fc22-467e-a3ca-22a6ec130209" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_Complemento_seq" defaultValue="" name="Complemento" nullable="0" physicalName="Complemento" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="12" userDefinedTypeUUID="831ac2d4-0e65-47ec-a0b7-62b7f6b8760a" >
     <remarks></remarks>
    </column>
    <column id="COL44" populated="true" UUID="a6ab93c0-0389-40dd-ac00-16bd09e79659" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_Bairro_seq" defaultValue="" name="Bairro" nullable="0" physicalName="Bairro" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="12" userDefinedTypeUUID="831ac2d4-0e65-47ec-a0b7-62b7f6b8760a" >
     <remarks></remarks>
    </column>
    <column id="COL45" populated="true" UUID="9087e379-a93f-4bd7-a006-b5b82eb09f74" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_CEP_seq" defaultValue="" name="CEP" nullable="0" physicalName="CEP" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     <remarks></remarks>
    </column>
    <column id="COL46" populated="true" UUID="28cbda2f-9a7c-4a85-a4b2-6e56bc031ba6" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_Cidade_seq" defaultValue="" name="Cidade" nullable="0" physicalName="Cidade" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="12" userDefinedTypeUUID="831ac2d4-0e65-47ec-a0b7-62b7f6b8760a" >
     <remarks></remarks>
    </column>
    <column id="COL47" populated="true" UUID="b7e64203-b88b-4cee-ab01-05e73ba8949b" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_UF_seq" defaultValue="" name="UF" nullable="0" physicalName="UF" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     <remarks></remarks>
    </column>
    </folder>
    <folder id="FOLTAB393" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    </folder>
    <folder id="FOLTAB392" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    </folder>
    <folder id="FOLTAB394" populated="true" name="Indices" physicalName="Indices" type="4">
    <index id="IDX48" populated="true" UUID="b1cdc808-ff19-47ff-8c0f-9270e9c2b487" clustered="false" name="Endereco_Clente_pk" physicalName="Endereco_Clente_pk" primaryKeyIndex="true" unique="false" >
     <index-column id="IDC49" populated="true" UUID="6a5616c6-895d-469a-94c3-9d102af89f4f" ascendingOrDescending="UNSPECIFIED" column-ref="COL40" name="codigo cliente" physicalName="codigo cliente" />
    </index>
   </folder>
  </table>
  <table id="TAB50" populated="true" UUID="d9c37065-8593-47bb-86cb-d67a901d3199" name="Telefone_Cliente" objectType="TABLE" physicalName="Telefone_Cliente" >
   <remarks></remarks>
   <folder id="FOLTAB501" populated="true" name="Columns" physicalName="Columns" type="1">
    <column id="COL51" populated="true" UUID="66a667a8-dc81-4343-8ff0-3402f214e875" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_Cliente.codigo cliente_seq" defaultValue="" name="codigo cliente" nullable="0" physicalName="codigo cliente" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    <column id="COL52" populated="true" UUID="4b708373-3c0a-4d4b-8868-bccdf2079b3b" autoIncrement="false" autoIncrementSequenceName="Telefone_Cliente_Telefone_seq" defaultValue="" name="Telefone" nullable="0" physicalName="Telefone" precision="0" primaryKeySeq="1" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     <remarks></remarks>
    </column>
    </folder>
    <folder id="FOLTAB503" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    </folder>
    <folder id="FOLTAB502" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    </folder>
    <folder id="FOLTAB504" populated="true" name="Indices" physicalName="Indices" type="4">
    <index id="IDX53" populated="true" UUID="548c82c0-5bb5-4add-be7e-5f3d4d5f4247" clustered="false" name="Telefone_Cliente_pk" physicalName="Telefone_Cliente_pk" primaryKeyIndex="true" unique="false" >
     <index-column id="IDC54" populated="true" UUID="3ed0e8b8-8f98-48ef-a7e8-5b39d0c3d71b" ascendingOrDescending="UNSPECIFIED" column-ref="COL51" name="codigo cliente" physicalName="codigo cliente" />
     <index-column id="IDC55" populated="true" UUID="e37912b8-73a3-41c0-8f06-e14c0c519677" ascendingOrDescending="UNSPECIFIED" column-ref="COL52" name="Telefone" physicalName="Telefone" />
    </index>
   </folder>
  </table>
  <table id="TAB56" populated="true" UUID="4459fbd5-9fe9-4d8e-a819-b2a9c6d5d1f4" name="Endereco_Filial" objectType="TABLE" physicalName="Endereco_Filial" >
   <remarks></remarks>
   <folder id="FOLTAB561" populated="true" name="Columns" physicalName="Columns" type="1">
    <column id="COL57" populated="true" UUID="e801a1e0-c20c-40e6-9088-04c317cc335c" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_Reserva.filial retirada_seq" defaultValue="" name="id filial" nullable="0" physicalName="id filial" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    <column id="COL58" populated="true" UUID="cc2cdb80-4a38-4ec6-b719-fb895e3c38a6" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_Rua_seq" defaultValue="" name="Rua" nullable="0" physicalName="Rua" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="12" userDefinedTypeUUID="831ac2d4-0e65-47ec-a0b7-62b7f6b8760a" >
     <remarks></remarks>
    </column>
    <column id="COL59" populated="true" UUID="7b792803-253a-40bf-a7a3-b7992f2cf8fc" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_Numero_seq" defaultValue="" name="Numero" nullable="0" physicalName="Numero" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    <column id="COL60" populated="true" UUID="ff2a60c0-70e0-4c19-96a1-55e0a122138d" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_Complemento_seq" defaultValue="" name="Complemento" nullable="0" physicalName="Complemento" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="12" userDefinedTypeUUID="831ac2d4-0e65-47ec-a0b7-62b7f6b8760a" >
     <remarks></remarks>
    </column>
    <column id="COL61" populated="true" UUID="b93884d4-3f16-4822-8f39-95018b2d16eb" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_Bairro_seq" defaultValue="" name="Bairro" nullable="0" physicalName="Bairro" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="12" userDefinedTypeUUID="831ac2d4-0e65-47ec-a0b7-62b7f6b8760a" >
     <remarks></remarks>
    </column>
    <column id="COL62" populated="true" UUID="5de8bbbf-e5bc-4be1-96ed-9285861637df" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_CEP_seq" defaultValue="" name="CEP" nullable="0" physicalName="CEP" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     <remarks></remarks>
    </column>
    <column id="COL63" populated="true" UUID="ccb24938-7796-4d58-9087-acf24ea93606" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_Cidade_seq" defaultValue="" name="Cidade" nullable="0" physicalName="Cidade" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="12" userDefinedTypeUUID="831ac2d4-0e65-47ec-a0b7-62b7f6b8760a" >
     <remarks></remarks>
    </column>
    <column id="COL64" populated="true" UUID="fce21710-a170-4d1e-87f9-be062c8d1feb" autoIncrement="false" autoIncrementSequenceName="Endereco_Clente_UF_seq" defaultValue="" name="UF" nullable="0" physicalName="UF" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     <remarks></remarks>
    </column>
    </folder>
    <folder id="FOLTAB563" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    </folder>
    <folder id="FOLTAB562" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    </folder>
    <folder id="FOLTAB564" populated="true" name="Indices" physicalName="Indices" type="4">
    <index id="IDX65" populated="true" UUID="69e6aebe-c417-4025-aa54-9d5d1a748426" clustered="false" name="Endereco_Filial_pk" physicalName="Endereco_Filial_pk" primaryKeyIndex="true" unique="false" >
     <index-column id="IDC66" populated="true" UUID="afb79bc7-599d-4f2a-ac07-327513866128" ascendingOrDescending="UNSPECIFIED" column-ref="COL57" name="id filial" physicalName="id filial" />
    </index>
   </folder>
  </table>
  <table id="TAB67" populated="true" UUID="70cee8b7-21cd-4503-a69f-9d69a1ac32ae" name="Telefone_Filial" objectType="TABLE" physicalName="Telefone_Filial" >
   <remarks></remarks>
   <folder id="FOLTAB671" populated="true" name="Columns" physicalName="Columns" type="1">
    <column id="COL68" populated="true" UUID="606a4397-92e4-470f-ae0b-522d7082e0d3" autoIncrement="false" autoIncrementSequenceName="Reserva_locadora_Reserva.filial retirada_seq" defaultValue="" name="id filial" nullable="0" physicalName="id filial" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     <remarks></remarks>
    </column>
    <column id="COL69" populated="true" UUID="d84a0240-5e7d-4aa3-a430-d4c533a74881" autoIncrement="false" autoIncrementSequenceName="Telefone_Filial_Telefone_seq" defaultValue="" name="Telefone" nullable="0" physicalName="Telefone" precision="0" primaryKeySeq="1" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     <remarks></remarks>
    </column>
    </folder>
    <folder id="FOLTAB673" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    </folder>
    <folder id="FOLTAB672" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    </folder>
    <folder id="FOLTAB674" populated="true" name="Indices" physicalName="Indices" type="4">
    <index id="IDX70" populated="true" UUID="6d8af4b2-9fd1-40e2-a492-2aadeda7ea42" clustered="false" name="Telefone_Filial_pk" physicalName="Telefone_Filial_pk" primaryKeyIndex="true" unique="false" >
     <index-column id="IDC71" populated="true" UUID="ec30aaef-d4cb-4846-9909-9f633cb9e05f" ascendingOrDescending="UNSPECIFIED" column-ref="COL68" name="id filial" physicalName="id filial" />
     <index-column id="IDC72" populated="true" UUID="de06f943-1394-431e-92e5-e94216a84a1d" ascendingOrDescending="UNSPECIFIED" column-ref="COL69" name="Telefone" physicalName="Telefone" />
    </index>
   </folder>
  </table>
  <relationships>
   <relationship id="REL73" populated="true" UUID="80e5b03f-5a33-4fcb-b7d8-18be6caa453b" deferrability="7" deleteRule="3" fk-table-ref="TAB7" fkCardinality="7" identifying="false" name="Cliente_Reserva_locadora_fk" physicalName="Cliente_Reserva_locadora_fk" pk-table-ref="TAB17" pkCardinality="2" updateRule="3" >
    <column-mapping id="CMP74" populated="true" UUID="85b6234e-6d8b-4106-8fe4-22f4dbde0058" fk-column-ref="COL12" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL18" />
   </relationship>
   <relationship id="REL75" populated="true" UUID="3df38d58-527a-4505-95c0-c863917ca631" deferrability="7" deleteRule="3" fk-table-ref="TAB39" fkCardinality="7" identifying="true" name="Cliente_Endereco_Clente_fk" physicalName="Cliente_Endereco_Clente_fk" pk-table-ref="TAB17" pkCardinality="2" updateRule="3" >
    <column-mapping id="CMP76" populated="true" UUID="4df91daa-8e29-485e-ae61-60228885555a" fk-column-ref="COL40" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL18" />
   </relationship>
   <relationship id="REL77" populated="true" UUID="bbc93eb4-7d63-470a-9c91-a77260f9a65c" deferrability="7" deleteRule="3" fk-table-ref="TAB50" fkCardinality="7" identifying="true" name="Cliente_Telefone_Cliente_fk" physicalName="Cliente_Telefone_Cliente_fk" pk-table-ref="TAB17" pkCardinality="2" updateRule="3" >
    <column-mapping id="CMP78" populated="true" UUID="82574342-641e-4600-b462-7970d13b092d" fk-column-ref="COL51" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL18" />
   </relationship>
   <relationship id="REL79" populated="true" UUID="d23e654c-0fc6-4e13-ba5a-fd522f94ecdf" deferrability="7" deleteRule="3" fk-table-ref="TAB7" fkCardinality="7" identifying="false" name="Filial_Reserva_locadora_fk" physicalName="Filial_Reserva_locadora_fk" pk-table-ref="TAB27" pkCardinality="2" updateRule="3" >
    <column-mapping id="CMP80" populated="true" UUID="84777880-01cb-4ec6-9362-c8c06a0f9e95" fk-column-ref="COL13" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL28" />
   </relationship>
   <relationship id="REL81" populated="true" UUID="43b3be88-4dc2-4057-b405-9f34e5f91832" deferrability="7" deleteRule="3" fk-table-ref="TAB7" fkCardinality="7" identifying="false" name="Filial_Reserva_locadora_fk1" physicalName="Filial_Reserva_locadora_fk1" pk-table-ref="TAB27" pkCardinality="2" updateRule="3" >
    <column-mapping id="CMP82" populated="true" UUID="83b3dc8f-ad39-4d51-b4ec-31322dc325e7" fk-column-ref="COL14" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL28" />
   </relationship>
   <relationship id="REL83" populated="true" UUID="19482502-7621-4a55-8635-c932d7c65ddd" deferrability="7" deleteRule="3" fk-table-ref="TAB56" fkCardinality="7" identifying="true" name="Filial_Endereco_Filial_fk" physicalName="Filial_Endereco_Filial_fk" pk-table-ref="TAB27" pkCardinality="2" updateRule="3" >
    <column-mapping id="CMP84" populated="true" UUID="83732708-0aa3-40b5-8f99-6653f0983510" fk-column-ref="COL57" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL28" />
   </relationship>
   <relationship id="REL85" populated="true" UUID="70398e0b-e616-49e5-80d0-147575efd4fd" deferrability="7" deleteRule="3" fk-table-ref="TAB67" fkCardinality="7" identifying="true" name="Filial_Telefone_Filial_fk" physicalName="Filial_Telefone_Filial_fk" pk-table-ref="TAB27" pkCardinality="2" updateRule="3" >
    <column-mapping id="CMP86" populated="true" UUID="43c5dabf-e0d5-4064-b92d-8b6f655aad15" fk-column-ref="COL68" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL28" />
   </relationship>
   <relationship id="REL87" populated="true" UUID="b9060bc9-570b-4911-b904-b7f48cc914a0" deferrability="7" deleteRule="3" fk-table-ref="TAB7" fkCardinality="7" identifying="false" name="Tipo_Veiculo_Reserva_locadora_fk" physicalName="Tipo_Veiculo_Reserva_locadora_fk" pk-table-ref="TAB32" pkCardinality="2" updateRule="3" >
    <column-mapping id="CMP88" populated="true" UUID="e090acce-a5ad-4c70-bc96-723f2fbcca7e" fk-column-ref="COL11" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL33" />
   </relationship>
  </relationships>
 </target-database>
 <ddl-generator type="ca.sqlpower.architect.ddl.GenericDDLGenerator" allow-connection="true"> </ddl-generator>
 <liquibase-settings useSeparateChangeSets="false" generateId="false" idStart="1"/>
 <create-kettle-job-settings filePath="" jobName="" schemaName="" kettleJoinType="0" savingToFile="true" />
 <play-pen zoom="1.189207115002721" viewportX="27" viewportY="0" relationship-style="rectilinear" names-displayLogicalNames="true" showPrimaryTag="true" showForeignTag="true" showAlternateTag="true" columnVisibility="ALL" relationshipLabelVisibility="true">
  <table-pane table-ref="TAB7" x="538" y="244" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
  <table-pane table-ref="TAB17" x="158" y="100" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
  <table-pane table-ref="TAB27" x="947" y="249" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
  <table-pane table-ref="TAB32" x="556" y="534" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
  <table-pane table-ref="TAB39" x="40" y="447" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
  <table-pane table-ref="TAB50" x="319" y="456" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
  <table-pane table-ref="TAB56" x="890" y="520" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
  <table-pane table-ref="TAB67" x="1178" y="538" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
  <table-link relationship-ref="REL87" pkConnection="0.48951048951048953" fkConnection="0.5031847133757962" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="72"/>
  <table-link relationship-ref="REL73" pkConnection="0.6516129032258065" fkConnection="0.24242424242424243" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="33"/>
  <table-link relationship-ref="REL79" pkConnection="0.7529411764705882" fkConnection="0.7244094488188977" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="18"/>
  <table-link relationship-ref="REL81" pkConnection="0.43529411764705883" fkConnection="0.2047244094488189" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="18"/>
  <table-link relationship-ref="REL75" pkConnection="0.1986754966887417" fkConnection="0.535031847133758" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
  <table-link relationship-ref="REL77" pkConnection="0.7748344370860927" fkConnection="0.42038216560509556" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
  <table-link relationship-ref="REL83" pkConnection="0.415" fkConnection="0.5619834710743802" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
  <table-link relationship-ref="REL85" pkConnection="0.65" fkConnection="0.371900826446281" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
 </play-pen>
 <critic-manager>
  <critic-grouping platformType="Generic" enabled="true">
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.PrimaryKeyCritic" severity="ERROR"/>
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.RelationshipMappingTypeCritic" severity="ERROR"/>
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.EmptyRelationshipCritic" severity="ERROR"/>
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.AlphaNumericNameCritic" severity="ERROR"/>
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.AlphaNumericSequenceNameCritic" severity="ERROR"/>
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.SetDefaultOnColumnWithNoDefaultCritic" severity="ERROR"/>
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.SetNullOnNonNullableColumnCritic" severity="ERROR"/>
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.DuplicateNameCritic" severity="ERROR"/>
  </critic-grouping>
  <critic-grouping platformType="DB2" enabled="true">
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.DB2UnsupportedFeaturesCritic" severity="ERROR"/>
  </critic-grouping>
  <critic-grouping platformType="H2" enabled="true">
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.H2UnsupportedFeaturesCritic" severity="ERROR"/>
  </critic-grouping>
  <critic-grouping platformType="HSQLDB" enabled="true">
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.HSQLDBUnsupportedFeaturesCritic" severity="ERROR"/>
  </critic-grouping>
  <critic-grouping platformType="MySQL" enabled="true">
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.MySQLCommentCritic" severity="ERROR"/>
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.MySQLReservedWordsCritic" severity="ERROR"/>
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.MySQLUnsupportedFeaturesCritic" severity="ERROR"/>
  </critic-grouping>
  <critic-grouping platformType="Oracle" enabled="true">
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.OraclePhysicalNameCritic" severity="ERROR"/>
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.OracleReservedWordsCritic" severity="ERROR"/>
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.OracleUnsupportedFeaturesCritic" severity="ERROR"/>
  </critic-grouping>
  <critic-grouping platformType="PostgreSQL" enabled="true">
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.PostgreSQLReservedWordsCritic" severity="ERROR"/>
  </critic-grouping>
  <critic-grouping platformType="SQL Server" enabled="true">
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.SQLServerUnsupportedFeaturesCritic" severity="ERROR"/>
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.SQLServerReservedWordsCritic" severity="ERROR"/>
  </critic-grouping>
  <critic-grouping platformType="SQL Server 2000" enabled="true">
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.SQLServer2000UnsupportedFeaturesCritic" severity="ERROR"/>
  </critic-grouping>
  <critic-grouping platformType="SQL Server 2005" enabled="true">
   <critic-settings class="ca.sqlpower.architect.ddl.critic.impl.SQLServer2005UnsupportedFeaturesCritic" severity="ERROR"/>
  </critic-grouping>
 </critic-manager>
 <profiles topNCount="10">
  </profiles>
  <olap>
  </olap>
  <olap-gui>
  </olap-gui>
</architect-project>
