Conjunto de mudanças 6443 no repositório publico


Ignorar:
Timestamp:
04/06/2012 21:26:09 (7 anos atrás)
Autor:
wagner
Mensagem:
 
Localização:
Legisbook/trunk
Arquivos:
1 adicionado
5 editados

Legenda:

Não Modificado
Adicionado
Removido
  • Legisbook/trunk/conectores/connsigilb/src

    • Propriedade svn:ignore modificada para
      connectparams.py
  • Legisbook/trunk/conectores/connsigilb/src/connsigilb.py

    r6363 r6443  
    55'''
    66
    7 import sys
     7import sys, psycopg2
     8import connectparams
     9
     10def main( ):
     11    # para proteger informacoes sensiveis de seguranca defina as rotinas:
     12    #
     13    #     connectparams.get_SIGI_Connect_Params( )
     14    # e
     15    #     connectparams.get_Legisbook_Connect_Params( )
     16    #
     17    # que retornem um dicionario contendo as variaveis de conexao aos bancos
     18    # de acordo com o driver de acesso utilizado, por exemplo:
     19    #
     20    # def get_SIGI_Connect_Params( )
     21    #     return( {
     22    #         'database' : "sigi",
     23    #         'host' : "localhost",
     24    #         'port' : "5432"
     25    #         'user' : "legisbook",
     26    #         'password' : "legisbook-sigi-password"
     27    #     } )
     28    #
     29    # o arquivo que contiver estas definicoes NAO DEVERA SER adicionado ao repositorio.
     30    #
     31
     32#    dbsigi = psycopg2.connect( **connectparams.get_SIGI_Connect_Params( ) )
     33    dblb = psycopg2.connect( **connectparams.get_Legisbook_Connect_Params( ) )
     34    c = dblb.cursor( )
     35    c.execute( "SELECT * FROM classeatributovertice" )
     36    print c.fetchall( )
     37   
     38# importar informacoes geograficas
    839
    940if __name__ != "__main__":
    10     sys.stderr.write( "Erro: utilize o modulo %r como aplicacao.\n" % __file__ )
     41    sys.stderr.write( "Erro: utilize o modulo %s como aplicacao.\n" % ( __file__ ) )
    1142    sys.exit( 1 )
    12 
    13 import psycopg2
    14 
    15 dbsigi = psycopg2.connect( database="sigi", user="legisbook", password="123456", \
    16                        host="sdsv116", port="5432" )
    17 
    18 dblb = psycopg2.connect( database="legisbook", user="legisbook", password="123456", \
    19                        host="localhost", port="5432" )
    20 
    21 # importar informacoes geograficas
     43else:
     44    main( )
  • Legisbook/trunk/docs/db/legisbook.architect

    r6419 r6443  
    55 <project-data-sources>
    66  <data-source id="DS0">
    7    <property key="Logical" value="Legisbook" />
    87   <property key="Connection Type" value="PostgreSQL" />
     8   <property key="Logical" value="Modelo de Dados" />
    99   <property key="JDBC URL" value="jdbc:postgresql://localhost:5432/legisbook" />
    1010   <property key="UID" value="legisbook" />
     
    1717  </data-source>
    1818  <data-source id="DS0">
    19    <property key="Logical" value="Legisbook" />
    2019   <property key="Connection Type" value="PostgreSQL" />
     20   <property key="Logical" value="Modelo de Dados" />
    2121   <property key="JDBC URL" value="jdbc:postgresql://localhost:5432/legisbook" />
    2222   <property key="UID" value="legisbook" />
     
    3030 </project-data-sources>
    3131 <source-databases>
    32   <database id="DB0" populated="true" UUID="1336d5e6-4eee-49b8-b371-36ded4287728" dbcs-ref="DS0" name="Legisbook" physicalName="Legisbook" >
     32  <database id="DB0" populated="true" UUID="1336d5e6-4eee-49b8-b371-36ded4287728" dbcs-ref="DS0" name="Modelo de Dados" physicalName="Legisbook" >
    3333   <catalog id="CAT1" populated="true" UUID="8274889e-d0a3-4b23-9c77-44fbc0475f85" name="legisbook" nativeTerm="database" physicalName="legisbook" >
    3434    <schema id="SCH2" populated="true" UUID="f6d679b7-3589-488d-9a59-4374ef1b10ce" name="information_schema" nativeTerm="schema" physicalName="information_schema" >
     
    164164     <remarks></remarks>
    165165    </column>
    166     <column id="COL43" populated="true" UUID="6927bbbc-6454-4c5c-8c9c-25b1339ad8bf" autoIncrement="false" autoIncrementSequenceName="classeatributovertice_classeatributovertice_desc_ch_seq" defaultValue="" name="Nome Atributo" nullable="0" physicalName="classeatributovertice_desc_ch" precision="64" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    167      <remarks></remarks>
    168     </column>
    169     <column id="COL44" populated="true" UUID="5cbe7bb6-b412-4474-af35-c9b22ee79025" autoIncrement="false" autoIncrementSequenceName="classeatributovertice_classeatributovertice_qtdminima_in_seq" defaultValue="" name="Quantidade Mínima" nullable="0" physicalName="classeatributovertice_qtdminima_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    170      <remarks></remarks>
    171     </column>
    172     <column id="COL45" populated="true" UUID="89aa3eac-9721-4bb0-b4b7-89c1b5d4edc2" autoIncrement="false" autoIncrementSequenceName="classeatributovertice_classeatributovertice_qtdmaxima_in_seq" defaultValue="" name="Permitir Multiplos" nullable="0" physicalName="classeatributovertice_qtdmaxima_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    173      <remarks></remarks>
     166    <column id="COL43" populated="true" UUID="6927bbbc-6454-4c5c-8c9c-25b1339ad8bf" autoIncrement="false" autoIncrementSequenceName="classeatributovertice_classeatributovertice_desc_ch_seq" defaultValue="" name="Descrição da Classe do Atributo de Vértice" nullable="0" physicalName="classeatributovertice_desc_ch" precision="64" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     167     <remarks></remarks>
     168    </column>
     169    <column id="COL44" populated="true" UUID="5cbe7bb6-b412-4474-af35-c9b22ee79025" autoIncrement="false" autoIncrementSequenceName="classeatributovertice_classeatributovertice_qtdminima_in_seq" defaultValue="" name="Quantidade Mínima de Ocorrências por Vértice (objeto)" nullable="0" physicalName="classeatributovertice_qtdminima_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     170     <remarks></remarks>
     171    </column>
     172    <column id="COL45" populated="true" UUID="89aa3eac-9721-4bb0-b4b7-89c1b5d4edc2" autoIncrement="false" autoIncrementSequenceName="classeatributovertice_classeatributovertice_qtdmaxima_in_seq" defaultValue="" name="Quantidade Máxima de Ocorrências por Vértice (objeto)" nullable="0" physicalName="classeatributovertice_qtdmaxima_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     173     <remarks></remarks>
     174    </column>
     175    <column id="COL46" populated="true" UUID="91a1d1b2-65b9-42c1-b289-ffa102036da9" autoIncrement="false" autoIncrementSequenceName="classeatributovertice_classeatributovertice_visible_bl_seq" defaultValue="" name="Descrição da Classe do Atributo de Vértice" nullable="0" physicalName="classeatributovertice_visible_bl" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="16" userDefinedTypeUUID="a26374aa-3026-4bb8-b564-eb2e186dfa5d" >
     176     <remarks>States if that attribute should be visible in user interfaces.</remarks>
     177    </column>
     178    <column id="COL47" populated="true" UUID="dc3602be-70a4-4d16-a5e3-83439d4e7c7a" autoIncrement="false" autoIncrementSequenceName="classeatributovertice_classeatributovertice_order_in_seq" defaultValue="" name="Prioridade de Ordenação do Atributo de Vértice" nullable="0" physicalName="classeatributovertice_order_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     179     <remarks>This value is used to order attributes list if a more specific method is not used by the application</remarks>
    174180    </column>
    175181    </folder>
     
    179185    </folder>
    180186    <folder id="FOLTAB394" populated="true" name="Indices" physicalName="Indices" type="4">
    181     <index id="IDX46" populated="true" UUID="fac63300-3ad3-43ac-aca7-ad1b7350c6cb" clustered="false" name="classeatributovertice_pk" physicalName="classeatributovertice_pk" primaryKeyIndex="true" unique="false" >
    182      <index-column id="IDC47" populated="true" UUID="2545fe34-3ad0-4e58-af70-9bf87899324e" ascendingOrDescending="UNSPECIFIED" column-ref="COL40" name="Identificador da Classe de Atributo de Vertice" physicalName="classeatributovertice_id_in" />
    183     </index>
    184     <index id="IDX48" populated="true" UUID="661d03c7-f90c-4464-b272-53521a237e89" clustered="false" name="classeatributo_codinome_idx" physicalName="classeatributo_codinome_idx" primaryKeyIndex="false" unique="true" >
    185      <index-column id="IDC49" populated="true" UUID="9ee4f081-4f6f-44df-a701-d094c9f61a67" ascendingOrDescending="ASCENDING" column-ref="COL41" name="Tipo Vértice" physicalName="tipovertice_id_in" />
    186      <index-column id="IDC50" populated="true" UUID="80eabeb9-2f32-485a-9699-138c45552a9b" ascendingOrDescending="ASCENDING" column-ref="COL42" name="Codinome do Atributo de Vértice" physicalName="classeatributovertice_codinome_ch" />
    187     </index>
    188    </folder>
    189   </table>
    190   <table id="TAB51" populated="true" UUID="8a0214b0-8a28-47dd-976d-c4dae9d45553" name="Atributo Vértice" objectType="TABLE" physicalName="atributovertice" >
    191    <remarks></remarks>
    192    <folder id="FOLTAB511" populated="true" name="Columns" physicalName="Columns" type="1">
    193     <column id="COL52" populated="true" UUID="2909d47f-68f5-490d-b5bc-a5f9e2c66cd5" autoIncrement="true" autoIncrementSequenceName="atributovertice_id_in_seq" defaultValue="" name="Sequencial Atributo" nullable="0" physicalName="atributovertice_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    194      <remarks></remarks>
    195     </column>
    196     <column id="COL53" populated="true" UUID="69066b0b-31fd-427e-92fb-dfd747fe9e2f" autoIncrement="false" autoIncrementSequenceName="vertice_id_in_seq_1" defaultValue="" name="Identificador Vértice" nullable="0" physicalName="vertice_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     187    <index id="IDX48" populated="true" UUID="fac63300-3ad3-43ac-aca7-ad1b7350c6cb" clustered="false" name="classeatributovertice_pk" physicalName="classeatributovertice_pk" primaryKeyIndex="true" unique="false" >
     188     <index-column id="IDC49" populated="true" UUID="2545fe34-3ad0-4e58-af70-9bf87899324e" ascendingOrDescending="UNSPECIFIED" column-ref="COL40" name="Identificador da Classe de Atributo de Vertice" physicalName="classeatributovertice_id_in" />
     189    </index>
     190    <index id="IDX50" populated="true" UUID="661d03c7-f90c-4464-b272-53521a237e89" clustered="false" name="classeatributo_codinome_idx" physicalName="classeatributo_codinome_idx" primaryKeyIndex="false" unique="true" >
     191     <index-column id="IDC51" populated="true" UUID="9ee4f081-4f6f-44df-a701-d094c9f61a67" ascendingOrDescending="ASCENDING" column-ref="COL41" name="Tipo Vértice" physicalName="tipovertice_id_in" />
     192     <index-column id="IDC52" populated="true" UUID="80eabeb9-2f32-485a-9699-138c45552a9b" ascendingOrDescending="ASCENDING" column-ref="COL42" name="Codinome do Atributo de Vértice" physicalName="classeatributovertice_codinome_ch" />
     193    </index>
     194   </folder>
     195  </table>
     196  <table id="TAB53" populated="true" UUID="8a0214b0-8a28-47dd-976d-c4dae9d45553" name="Atributo Vértice" objectType="TABLE" physicalName="atributovertice" >
     197   <remarks></remarks>
     198   <folder id="FOLTAB531" populated="true" name="Columns" physicalName="Columns" type="1">
     199    <column id="COL54" populated="true" UUID="2909d47f-68f5-490d-b5bc-a5f9e2c66cd5" autoIncrement="true" autoIncrementSequenceName="atributovertice_id_in_seq" defaultValue="" name="Sequencial Atributo" nullable="0" physicalName="atributovertice_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     200     <remarks></remarks>
     201    </column>
     202    <column id="COL55" populated="true" UUID="69066b0b-31fd-427e-92fb-dfd747fe9e2f" autoIncrement="false" autoIncrementSequenceName="vertice_id_in_seq_1" defaultValue="" name="Identificador Vértice" nullable="0" physicalName="vertice_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    197203     <remarks>Identificador do vértice no escopo do Legisbook</remarks>
    198204    </column>
    199     <column id="COL54" populated="true" UUID="02b0ef40-85d8-4c9e-9f45-e4c4faa3b9d2" autoIncrement="false" defaultValue="" name="Identificador da Classe de Atributo de Vertice" nullable="0" physicalName="classeatributovertice_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    200      <remarks></remarks>
    201     </column>
    202     <column id="COL55" populated="true" UUID="59cab7d7-df3d-46f8-b0d5-1a944eef95f4" autoIncrement="false" autoIncrementSequenceName="atributovertice_atributovertice_valor_ch_seq" defaultValue="" name="Valor Atributo" nullable="0" physicalName="atributovertice_valor_ch" precision="512" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    203      <remarks></remarks>
    204     </column>
    205     </folder>
    206     <folder id="FOLTAB513" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    207     </folder>
    208     <folder id="FOLTAB512" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    209     </folder>
    210     <folder id="FOLTAB514" populated="true" name="Indices" physicalName="Indices" type="4">
    211     <index id="IDX56" populated="true" UUID="35a478e5-1099-4ae4-9d14-55e684e4baab" clustered="false" name="atributovertice_pk" physicalName="atributovertice_pk" primaryKeyIndex="true" unique="false" >
    212      <index-column id="IDC57" populated="true" UUID="1a5d8cb8-a767-40b9-b942-862ba0eb21b4" ascendingOrDescending="UNSPECIFIED" column-ref="COL52" name="Sequencial Atributo" physicalName="atributovertice_id_in" />
    213     </index>
    214    </folder>
    215   </table>
    216   <table id="TAB58" populated="true" UUID="de69f557-2bfe-4052-8752-1193cd4b2197" name="Timeline" objectType="TABLE" physicalName="timeline" >
    217    <remarks></remarks>
    218    <folder id="FOLTAB581" populated="true" name="Columns" physicalName="Columns" type="1">
    219     <column id="COL59" populated="true" UUID="2e671e9a-f6ff-4a77-847c-26cee1dd7a9f" autoIncrement="true" autoIncrementSequenceName="timeline_seq_in_seq" defaultValue="" name="Sequencial Timeline" nullable="0" physicalName="timeline_seq_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    220      <remarks></remarks>
    221     </column>
    222     <column id="COL60" populated="true" UUID="1bd1990d-f4c1-4f66-9a61-5e3a2abf8dcf" autoIncrement="false" autoIncrementSequenceName="vertice_vertice_id_in_seq" defaultValue="" name="Identificador Vértice" nullable="0" physicalName="vertice_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     205    <column id="COL56" populated="true" UUID="02b0ef40-85d8-4c9e-9f45-e4c4faa3b9d2" autoIncrement="false" defaultValue="" name="Identificador da Classe de Atributo de Vertice" nullable="0" physicalName="classeatributovertice_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     206     <remarks></remarks>
     207    </column>
     208    <column id="COL57" populated="true" UUID="59cab7d7-df3d-46f8-b0d5-1a944eef95f4" autoIncrement="false" autoIncrementSequenceName="atributovertice_atributovertice_valor_ch_seq" defaultValue="" name="Valor Atributo" nullable="0" physicalName="atributovertice_valor_ch" precision="512" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     209     <remarks></remarks>
     210    </column>
     211    <column id="COL58" populated="true" UUID="a609335b-a4ad-4050-83f8-9797117dc916" autoIncrement="false" autoIncrementSequenceName="atributovertice_atributovertice_group_in_seq" defaultValue="" name="Vertice Attribute Group" nullable="0" physicalName="atributovertice_group_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     212     <remarks>Used to group attributes, specially useful to group composite data attributes (p.ex. addresses)</remarks>
     213    </column>
     214    </folder>
     215    <folder id="FOLTAB533" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
     216    </folder>
     217    <folder id="FOLTAB532" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
     218    </folder>
     219    <folder id="FOLTAB534" populated="true" name="Indices" physicalName="Indices" type="4">
     220    <index id="IDX59" populated="true" UUID="35a478e5-1099-4ae4-9d14-55e684e4baab" clustered="false" name="atributovertice_pk" physicalName="atributovertice_pk" primaryKeyIndex="true" unique="false" >
     221     <index-column id="IDC60" populated="true" UUID="1a5d8cb8-a767-40b9-b942-862ba0eb21b4" ascendingOrDescending="UNSPECIFIED" column-ref="COL54" name="Sequencial Atributo" physicalName="atributovertice_id_in" />
     222    </index>
     223   </folder>
     224  </table>
     225  <table id="TAB61" populated="true" UUID="de69f557-2bfe-4052-8752-1193cd4b2197" name="Timeline" objectType="TABLE" physicalName="timeline" >
     226   <remarks></remarks>
     227   <folder id="FOLTAB611" populated="true" name="Columns" physicalName="Columns" type="1">
     228    <column id="COL62" populated="true" UUID="2e671e9a-f6ff-4a77-847c-26cee1dd7a9f" autoIncrement="true" autoIncrementSequenceName="timeline_seq_in_seq" defaultValue="" name="Sequencial Timeline" nullable="0" physicalName="timeline_seq_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     229     <remarks></remarks>
     230    </column>
     231    <column id="COL63" populated="true" UUID="1bd1990d-f4c1-4f66-9a61-5e3a2abf8dcf" autoIncrement="false" autoIncrementSequenceName="vertice_vertice_id_in_seq" defaultValue="" name="Identificador Vértice" nullable="0" physicalName="vertice_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    223232     <remarks>Identificador do vértice no escopo do Legisbook</remarks>
    224233    </column>
    225     <column id="COL61" populated="true" UUID="494e630f-0b6d-400a-ba5d-cd4bde2b847f" autoIncrement="false" autoIncrementSequenceName="tipoevento_tipoevento_id_in_seq" defaultValue="" name="Tipo do Evento" nullable="0" physicalName="tipoevento_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    226      <remarks></remarks>
    227     </column>
    228     <column id="COL62" populated="true" UUID="33f598f2-7f1e-488c-bfc7-06653963cebe" autoIncrement="false" autoIncrementSequenceName="timeline_timeline_hora_ts_seq" defaultValue="" name="Hora do Evento" nullable="0" physicalName="timeline_hora_ts" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="93" userDefinedTypeUUID="6497d8de-0e00-40d6-a42e-e2adca83be64" >
    229      <remarks></remarks>
    230     </column>
    231     <column id="COL63" populated="true" UUID="11bed143-f0b9-4d1d-9f7d-6540f0a1e528" autoIncrement="false" autoIncrementSequenceName="timeline_timeline_nota_tx_seq" defaultValue="" name="Notas" nullable="0" physicalName="timeline_nota_tx" precision="512" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    232      <remarks></remarks>
    233     </column>
    234     </folder>
    235     <folder id="FOLTAB583" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    236     </folder>
    237     <folder id="FOLTAB582" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    238     </folder>
    239     <folder id="FOLTAB584" populated="true" name="Indices" physicalName="Indices" type="4">
    240     <index id="IDX64" populated="true" UUID="523769e9-e038-4fdf-ad64-8cdbf32bd24c" clustered="false" name="timeline_pk" physicalName="timeline_pk" primaryKeyIndex="true" unique="false" >
    241      <index-column id="IDC65" populated="true" UUID="dba237c4-aac6-4d2f-8440-2dbb29942d10" ascendingOrDescending="UNSPECIFIED" column-ref="COL59" name="Sequencial Timeline" physicalName="timeline_seq_in" />
    242     </index>
    243    </folder>
    244   </table>
    245   <table id="TAB66" populated="true" UUID="a8094040-5bf0-4ceb-afdf-1a08ea6728c1" name="Tipo do Evento" objectType="TABLE" physicalName="tipoevento" >
    246    <remarks></remarks>
    247    <folder id="FOLTAB661" populated="true" name="Columns" physicalName="Columns" type="1">
    248     <column id="COL67" populated="true" UUID="79acc189-0014-4177-a3e6-fab879e35fab" autoIncrement="true" autoIncrementSequenceName="tipoevento_id_in_seq" defaultValue="" name="Tipo do Evento" nullable="0" physicalName="tipoevento_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    249      <remarks></remarks>
    250     </column>
    251     <column id="COL68" populated="true" UUID="5a39e37b-4e76-4554-8df0-642584759562" autoIncrement="false" autoIncrementSequenceName="tipoevento_codinome_ch_seq" defaultValue="" name="Tipo Evento Codinome" nullable="0" physicalName="tipoevento_codinome_ch" precision="16" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    252      <remarks></remarks>
    253     </column>
    254     <column id="COL69" populated="true" UUID="d9e82de6-fa1e-45fb-896f-00c68135009e" autoIncrement="false" autoIncrementSequenceName="tipoevento_tipoevento_desc_ch_seq" defaultValue="" name="Descrição do Tipo do Evento" nullable="0" physicalName="tipoevento_desc_ch" precision="64" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    255      <remarks></remarks>
    256     </column>
    257     </folder>
    258     <folder id="FOLTAB663" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    259     </folder>
    260     <folder id="FOLTAB662" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    261     </folder>
    262     <folder id="FOLTAB664" populated="true" name="Indices" physicalName="Indices" type="4">
    263     <index id="IDX70" populated="true" UUID="11235fd2-8a8a-4ef4-8070-8cf495e22ca0" clustered="false" name="tipoevento_pk" physicalName="tipoevento_pk" primaryKeyIndex="true" unique="false" >
    264      <index-column id="IDC71" populated="true" UUID="d585d6fb-e473-4b98-8ef9-9d5d8f0ecd1c" ascendingOrDescending="UNSPECIFIED" column-ref="COL67" name="Tipo do Evento" physicalName="tipoevento_id_in" />
    265     </index>
    266     <index id="IDX72" populated="true" UUID="47415de8-02e9-4cda-a3cf-025e0244019a" clustered="false" name="tipoevento_codinome_ch_idx" physicalName="tipoevento_codinome_ch_idx" primaryKeyIndex="false" unique="true" >
    267      <index-column id="IDC73" populated="true" UUID="f32ca499-fca2-4e65-b107-a76d3160fb5f" ascendingOrDescending="ASCENDING" column-ref="COL68" name="Tipo Evento Codinome" physicalName="tipoevento_codinome_ch" />
    268     </index>
    269    </folder>
    270   </table>
    271   <table id="TAB74" populated="true" UUID="8d878bb2-1221-4257-bfc2-6d9092bab2dd" name="Grupo de Arestas" objectType="TABLE" physicalName="grupoarestas" >
    272    <remarks></remarks>
    273    <folder id="FOLTAB741" populated="true" name="Columns" physicalName="Columns" type="1">
    274     <column id="COL75" populated="true" UUID="ef3cf29a-d844-4dc7-86a3-9eff99c0e278" autoIncrement="true" autoIncrementSequenceName="grupoarestas_id_in_seq" defaultValue="" name="Identificador do Grupo" nullable="0" physicalName="grupoarestas_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    275      <remarks></remarks>
    276     </column>
    277     <column id="COL76" populated="true" UUID="c2b63710-8d28-44e7-ab49-bbe478ab1e62" autoIncrement="false" autoIncrementSequenceName="grupoarestas_grupoarestas_codinome_ch_seq" defaultValue="" name="Codinome para o Grupo de Arestas" nullable="0" physicalName="grupoarestas_codinome_ch" precision="16" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="12" userDefinedTypeUUID="831ac2d4-0e65-47ec-a0b7-62b7f6b8760a" >
    278      <remarks></remarks>
    279     </column>
    280     <column id="COL77" populated="true" UUID="099cc4a1-588f-4e95-ad0a-19f3da508c54" autoIncrement="false" autoIncrementSequenceName="grupoarestas_grupoarestas_desc_ch_seq" defaultValue="" name="Nome Grupo Arestas" nullable="0" physicalName="grupoarestas_desc_ch" precision="128" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    281      <remarks></remarks>
    282     </column>
    283     </folder>
    284     <folder id="FOLTAB743" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    285     </folder>
    286     <folder id="FOLTAB742" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    287     </folder>
    288     <folder id="FOLTAB744" populated="true" name="Indices" physicalName="Indices" type="4">
    289     <index id="IDX78" populated="true" UUID="e978e72e-1386-471c-bf0f-4629965a26d5" clustered="false" name="grupoarestas_pk" physicalName="grupoarestas_pk" primaryKeyIndex="true" unique="false" >
    290      <index-column id="IDC79" populated="true" UUID="529b25a9-398d-4284-9f88-4b4da8b56d68" ascendingOrDescending="UNSPECIFIED" column-ref="COL75" name="Identificador do Grupo" physicalName="grupoarestas_id_in" />
    291     </index>
    292     <index id="IDX80" populated="true" UUID="8deb07ea-e185-4367-bc77-50fa5842c619" clustered="false" name="grupodearestas_codinome_idx" physicalName="grupodearestas_codinome_idx" primaryKeyIndex="false" unique="true" >
    293      <index-column id="IDC81" populated="true" UUID="cd8fe165-b7e5-4f05-86b0-2f450d86137d" ascendingOrDescending="UNSPECIFIED" column-ref="COL76" name="Codinome para o Grupo de Arestas" physicalName="grupoarestas_codinome_ch" />
    294     </index>
    295    </folder>
    296   </table>
    297   <table id="TAB82" populated="true" UUID="8d62d6d7-32e0-41d5-a307-f23f124fa5e3" name="Grupo de Tipos de Arestas" objectType="TABLE" physicalName="tipogrupoarestas" >
    298    <remarks></remarks>
    299    <folder id="FOLTAB821" populated="true" name="Columns" physicalName="Columns" type="1">
    300     <column id="COL83" populated="true" UUID="99bf507b-b367-49f6-9bbe-08f415f5a9d2" autoIncrement="false" defaultValue="" name="Identificador do Grupo" nullable="0" physicalName="grupoarestas_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    301      <remarks></remarks>
    302     </column>
    303     <column id="COL84" populated="true" UUID="250f1ef6-6c69-4f5b-8857-faefbdb37ec3" autoIncrement="false" defaultValue="" name="Tipo Aresta" nullable="0" physicalName="tipoaresta_id_in" precision="0" primaryKeySeq="1" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    304      <remarks></remarks>
    305     </column>
    306     </folder>
    307     <folder id="FOLTAB823" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    308     </folder>
    309     <folder id="FOLTAB822" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    310     </folder>
    311     <folder id="FOLTAB824" populated="true" name="Indices" physicalName="Indices" type="4">
    312     <index id="IDX85" populated="true" UUID="433937fa-a3b6-42fe-b42e-15e6cde7821e" clustered="false" name="tipogrupoarestas_pk" physicalName="tipogrupoarestas_pk" primaryKeyIndex="true" unique="false" >
    313      <index-column id="IDC86" populated="true" UUID="70687687-97b8-4ec3-8b37-6d7b476797ab" ascendingOrDescending="UNSPECIFIED" column-ref="COL83" name="Identificador do Grupo" physicalName="grupoarestas_id_in" />
    314      <index-column id="IDC87" populated="true" UUID="cddef32d-db72-4962-8498-bfd13a68f0e4" ascendingOrDescending="UNSPECIFIED" column-ref="COL84" name="Tipo Aresta" physicalName="tipoaresta_id_in" />
    315     </index>
    316    </folder>
    317   </table>
    318   <table id="TAB88" populated="true" UUID="8810f06a-7465-4749-835a-09dc16d14f77" name="Galeria" objectType="TABLE" physicalName="galeria" >
    319    <remarks></remarks>
    320    <folder id="FOLTAB881" populated="true" name="Columns" physicalName="Columns" type="1">
    321     <column id="COL89" populated="true" UUID="68ce4ebb-9fb4-4bc9-9ab6-4b5f181bbff4" autoIncrement="true" autoIncrementSequenceName="galeria_id_in_seq" defaultValue="" name="Identificador da Galeria" nullable="0" physicalName="galeria_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    322      <remarks></remarks>
    323     </column>
    324     <column id="COL90" populated="true" UUID="7c5c52aa-40b1-4e16-85b5-3aa46027a481" autoIncrement="false" defaultValue="" name="Identificador Vértice" nullable="0" physicalName="vertice_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     234    <column id="COL64" populated="true" UUID="494e630f-0b6d-400a-ba5d-cd4bde2b847f" autoIncrement="false" autoIncrementSequenceName="tipoevento_tipoevento_id_in_seq" defaultValue="" name="Tipo do Evento" nullable="0" physicalName="tipoevento_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     235     <remarks></remarks>
     236    </column>
     237    <column id="COL65" populated="true" UUID="33f598f2-7f1e-488c-bfc7-06653963cebe" autoIncrement="false" autoIncrementSequenceName="timeline_timeline_hora_ts_seq" defaultValue="" name="Hora do Evento" nullable="0" physicalName="timeline_hora_ts" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="93" userDefinedTypeUUID="6497d8de-0e00-40d6-a42e-e2adca83be64" >
     238     <remarks></remarks>
     239    </column>
     240    <column id="COL66" populated="true" UUID="11bed143-f0b9-4d1d-9f7d-6540f0a1e528" autoIncrement="false" autoIncrementSequenceName="timeline_timeline_nota_tx_seq" defaultValue="" name="Notas" nullable="0" physicalName="timeline_nota_tx" precision="512" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     241     <remarks></remarks>
     242    </column>
     243    </folder>
     244    <folder id="FOLTAB613" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
     245    </folder>
     246    <folder id="FOLTAB612" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
     247    </folder>
     248    <folder id="FOLTAB614" populated="true" name="Indices" physicalName="Indices" type="4">
     249    <index id="IDX67" populated="true" UUID="523769e9-e038-4fdf-ad64-8cdbf32bd24c" clustered="false" name="timeline_pk" physicalName="timeline_pk" primaryKeyIndex="true" unique="false" >
     250     <index-column id="IDC68" populated="true" UUID="dba237c4-aac6-4d2f-8440-2dbb29942d10" ascendingOrDescending="UNSPECIFIED" column-ref="COL62" name="Sequencial Timeline" physicalName="timeline_seq_in" />
     251    </index>
     252   </folder>
     253  </table>
     254  <table id="TAB69" populated="true" UUID="a8094040-5bf0-4ceb-afdf-1a08ea6728c1" name="Tipo do Evento" objectType="TABLE" physicalName="tipoevento" >
     255   <remarks></remarks>
     256   <folder id="FOLTAB691" populated="true" name="Columns" physicalName="Columns" type="1">
     257    <column id="COL70" populated="true" UUID="79acc189-0014-4177-a3e6-fab879e35fab" autoIncrement="true" autoIncrementSequenceName="tipoevento_id_in_seq" defaultValue="" name="Tipo do Evento" nullable="0" physicalName="tipoevento_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     258     <remarks></remarks>
     259    </column>
     260    <column id="COL71" populated="true" UUID="5a39e37b-4e76-4554-8df0-642584759562" autoIncrement="false" autoIncrementSequenceName="tipoevento_codinome_ch_seq" defaultValue="" name="Tipo Evento Codinome" nullable="0" physicalName="tipoevento_codinome_ch" precision="16" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     261     <remarks></remarks>
     262    </column>
     263    <column id="COL72" populated="true" UUID="d9e82de6-fa1e-45fb-896f-00c68135009e" autoIncrement="false" autoIncrementSequenceName="tipoevento_tipoevento_desc_ch_seq" defaultValue="" name="Descrição do Tipo do Evento" nullable="0" physicalName="tipoevento_desc_ch" precision="64" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     264     <remarks></remarks>
     265    </column>
     266    </folder>
     267    <folder id="FOLTAB693" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
     268    </folder>
     269    <folder id="FOLTAB692" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
     270    </folder>
     271    <folder id="FOLTAB694" populated="true" name="Indices" physicalName="Indices" type="4">
     272    <index id="IDX73" populated="true" UUID="11235fd2-8a8a-4ef4-8070-8cf495e22ca0" clustered="false" name="tipoevento_pk" physicalName="tipoevento_pk" primaryKeyIndex="true" unique="false" >
     273     <index-column id="IDC74" populated="true" UUID="d585d6fb-e473-4b98-8ef9-9d5d8f0ecd1c" ascendingOrDescending="UNSPECIFIED" column-ref="COL70" name="Tipo do Evento" physicalName="tipoevento_id_in" />
     274    </index>
     275    <index id="IDX75" populated="true" UUID="47415de8-02e9-4cda-a3cf-025e0244019a" clustered="false" name="tipoevento_codinome_ch_idx" physicalName="tipoevento_codinome_ch_idx" primaryKeyIndex="false" unique="true" >
     276     <index-column id="IDC76" populated="true" UUID="f32ca499-fca2-4e65-b107-a76d3160fb5f" ascendingOrDescending="ASCENDING" column-ref="COL71" name="Tipo Evento Codinome" physicalName="tipoevento_codinome_ch" />
     277    </index>
     278   </folder>
     279  </table>
     280  <table id="TAB77" populated="true" UUID="8d878bb2-1221-4257-bfc2-6d9092bab2dd" name="Grupo de Arestas" objectType="TABLE" physicalName="grupoarestas" >
     281   <remarks></remarks>
     282   <folder id="FOLTAB771" populated="true" name="Columns" physicalName="Columns" type="1">
     283    <column id="COL78" populated="true" UUID="ef3cf29a-d844-4dc7-86a3-9eff99c0e278" autoIncrement="true" autoIncrementSequenceName="grupoarestas_id_in_seq" defaultValue="" name="Identificador do Grupo" nullable="0" physicalName="grupoarestas_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     284     <remarks></remarks>
     285    </column>
     286    <column id="COL79" populated="true" UUID="c2b63710-8d28-44e7-ab49-bbe478ab1e62" autoIncrement="false" autoIncrementSequenceName="grupoarestas_grupoarestas_codinome_ch_seq" defaultValue="" name="Codinome para o Grupo de Arestas" nullable="0" physicalName="grupoarestas_codinome_ch" precision="16" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="12" userDefinedTypeUUID="831ac2d4-0e65-47ec-a0b7-62b7f6b8760a" >
     287     <remarks></remarks>
     288    </column>
     289    <column id="COL80" populated="true" UUID="099cc4a1-588f-4e95-ad0a-19f3da508c54" autoIncrement="false" autoIncrementSequenceName="grupoarestas_grupoarestas_desc_ch_seq" defaultValue="" name="Nome Grupo Arestas" nullable="0" physicalName="grupoarestas_desc_ch" precision="128" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     290     <remarks></remarks>
     291    </column>
     292    </folder>
     293    <folder id="FOLTAB773" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
     294    </folder>
     295    <folder id="FOLTAB772" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
     296    </folder>
     297    <folder id="FOLTAB774" populated="true" name="Indices" physicalName="Indices" type="4">
     298    <index id="IDX81" populated="true" UUID="e978e72e-1386-471c-bf0f-4629965a26d5" clustered="false" name="grupoarestas_pk" physicalName="grupoarestas_pk" primaryKeyIndex="true" unique="false" >
     299     <index-column id="IDC82" populated="true" UUID="529b25a9-398d-4284-9f88-4b4da8b56d68" ascendingOrDescending="UNSPECIFIED" column-ref="COL78" name="Identificador do Grupo" physicalName="grupoarestas_id_in" />
     300    </index>
     301    <index id="IDX83" populated="true" UUID="8deb07ea-e185-4367-bc77-50fa5842c619" clustered="false" name="grupodearestas_codinome_idx" physicalName="grupodearestas_codinome_idx" primaryKeyIndex="false" unique="true" >
     302     <index-column id="IDC84" populated="true" UUID="cd8fe165-b7e5-4f05-86b0-2f450d86137d" ascendingOrDescending="UNSPECIFIED" column-ref="COL79" name="Codinome para o Grupo de Arestas" physicalName="grupoarestas_codinome_ch" />
     303    </index>
     304   </folder>
     305  </table>
     306  <table id="TAB85" populated="true" UUID="8d62d6d7-32e0-41d5-a307-f23f124fa5e3" name="Grupo de Tipos de Arestas" objectType="TABLE" physicalName="tipogrupoarestas" >
     307   <remarks></remarks>
     308   <folder id="FOLTAB851" populated="true" name="Columns" physicalName="Columns" type="1">
     309    <column id="COL86" populated="true" UUID="99bf507b-b367-49f6-9bbe-08f415f5a9d2" autoIncrement="false" defaultValue="" name="Identificador do Grupo" nullable="0" physicalName="grupoarestas_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     310     <remarks></remarks>
     311    </column>
     312    <column id="COL87" populated="true" UUID="250f1ef6-6c69-4f5b-8857-faefbdb37ec3" autoIncrement="false" defaultValue="" name="Tipo Aresta" nullable="0" physicalName="tipoaresta_id_in" precision="0" primaryKeySeq="1" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     313     <remarks></remarks>
     314    </column>
     315    </folder>
     316    <folder id="FOLTAB853" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
     317    </folder>
     318    <folder id="FOLTAB852" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
     319    </folder>
     320    <folder id="FOLTAB854" populated="true" name="Indices" physicalName="Indices" type="4">
     321    <index id="IDX88" populated="true" UUID="433937fa-a3b6-42fe-b42e-15e6cde7821e" clustered="false" name="tipogrupoarestas_pk" physicalName="tipogrupoarestas_pk" primaryKeyIndex="true" unique="false" >
     322     <index-column id="IDC89" populated="true" UUID="70687687-97b8-4ec3-8b37-6d7b476797ab" ascendingOrDescending="UNSPECIFIED" column-ref="COL86" name="Identificador do Grupo" physicalName="grupoarestas_id_in" />
     323     <index-column id="IDC90" populated="true" UUID="cddef32d-db72-4962-8498-bfd13a68f0e4" ascendingOrDescending="UNSPECIFIED" column-ref="COL87" name="Tipo Aresta" physicalName="tipoaresta_id_in" />
     324    </index>
     325   </folder>
     326  </table>
     327  <table id="TAB91" populated="true" UUID="8810f06a-7465-4749-835a-09dc16d14f77" name="Galeria" objectType="TABLE" physicalName="galeria" >
     328   <remarks></remarks>
     329   <folder id="FOLTAB911" populated="true" name="Columns" physicalName="Columns" type="1">
     330    <column id="COL92" populated="true" UUID="68ce4ebb-9fb4-4bc9-9ab6-4b5f181bbff4" autoIncrement="true" autoIncrementSequenceName="galeria_id_in_seq" defaultValue="" name="Identificador da Galeria" nullable="0" physicalName="galeria_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     331     <remarks></remarks>
     332    </column>
     333    <column id="COL93" populated="true" UUID="7c5c52aa-40b1-4e16-85b5-3aa46027a481" autoIncrement="false" defaultValue="" name="Identificador Vértice" nullable="0" physicalName="vertice_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    325334     <remarks>Identificador do vértice no escopo do Legisbook</remarks>
    326335    </column>
    327     <column id="COL91" populated="true" UUID="565a9e1a-80cf-40c7-bac2-5243e029320c" autoIncrement="false" autoIncrementSequenceName="galeria_galeria_nome_ch_seq" defaultValue="" name="Nome da Galeria" nullable="0" physicalName="galeria_nome_ch" precision="128" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    328      <remarks></remarks>
    329     </column>
    330     <column id="COL92" populated="true" UUID="79571ba6-ec20-4401-a559-32e35aacf0e4" autoIncrement="false" autoIncrementSequenceName="galeria_galeriafolder_id_in_seq" defaultValue="" name="Galeria Folder ID" nullable="0" physicalName="galeriafolder_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    331      <remarks></remarks>
    332     </column>
    333     </folder>
    334     <folder id="FOLTAB883" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    335     </folder>
    336     <folder id="FOLTAB882" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    337     </folder>
    338     <folder id="FOLTAB884" populated="true" name="Indices" physicalName="Indices" type="4">
    339     <index id="IDX93" populated="true" UUID="58c639f3-887c-4565-b8d8-a417e7833ba4" clustered="false" name="galeria_pk" physicalName="galeria_pk" primaryKeyIndex="true" unique="false" >
    340      <index-column id="IDC94" populated="true" UUID="abb2a2cd-f45d-4843-add2-24767cc25a87" ascendingOrDescending="UNSPECIFIED" column-ref="COL89" name="Identificador da Galeria" physicalName="galeria_id_in" />
    341     </index>
    342    </folder>
    343   </table>
    344   <table id="TAB95" populated="true" UUID="d0700f82-4688-46cb-ade4-ba58a8537105" name="Galeria Folder" objectType="TABLE" physicalName="galeriafolder" >
    345    <remarks></remarks>
    346    <folder id="FOLTAB951" populated="true" name="Columns" physicalName="Columns" type="1">
    347     <column id="COL96" populated="true" UUID="9ee77725-b3b9-48d5-85ec-5c81c26dda5e" autoIncrement="true" autoIncrementSequenceName="galeriafolder_galeriafolder_id_in_seq" defaultValue="" name="Galeria Folder ID" nullable="0" physicalName="galeriafolder_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    348      <remarks></remarks>
    349     </column>
    350     <column id="COL97" populated="true" UUID="e86ee0f3-fa88-4545-83d1-14129ac77bce" autoIncrement="false" autoIncrementSequenceName="galeriafolder_galeriafolder_parentid_in_seq" defaultValue="" name="Galeria Parent Folder ID" nullable="0" physicalName="galeriafolder_parentid_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    351      <remarks></remarks>
    352     </column>
    353     <column id="COL98" populated="true" UUID="a7d6da6d-3b36-49e3-9db2-f47e2cdd5bcc" autoIncrement="false" autoIncrementSequenceName="galeriafolder_galeriafolder_nome_ch_seq" defaultValue="" name="Galeria Folder Nome" nullable="0" physicalName="galeriafolder_nome_ch" precision="128" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    354      <remarks></remarks>
    355     </column>
    356     </folder>
    357     <folder id="FOLTAB953" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    358     </folder>
    359     <folder id="FOLTAB952" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    360     </folder>
    361     <folder id="FOLTAB954" populated="true" name="Indices" physicalName="Indices" type="4">
    362     <index id="IDX99" populated="true" UUID="0bdbf7a3-c23e-4146-94f9-5626ba839ca9" clustered="false" name="galeriafolder_pk" physicalName="galeriafolder_pk" primaryKeyIndex="true" unique="false" >
    363      <index-column id="IDC100" populated="true" UUID="5833f099-7854-4225-9a00-8b3a89f50249" ascendingOrDescending="UNSPECIFIED" column-ref="COL96" name="Galeria Folder ID" physicalName="galeriafolder_id_in" />
    364     </index>
    365    </folder>
    366   </table>
    367   <table id="TAB101" populated="true" UUID="85bdafb3-f2b6-4685-9df0-8ed401044888" name="Galeria Item" objectType="TABLE" physicalName="galeriaitem" >
    368    <remarks></remarks>
    369    <folder id="FOLTAB1011" populated="true" name="Columns" physicalName="Columns" type="1">
    370     <column id="COL102" populated="true" UUID="5f1b6adc-738f-44a0-a1b7-d8cf8a2e1eaa" autoIncrement="true" autoIncrementSequenceName="galeriaitem_galeriaitem_id_in_seq" defaultValue="" name="Galeria Item ID" nullable="0" physicalName="galeriaitem_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    371      <remarks></remarks>
    372     </column>
    373     <column id="COL103" populated="true" UUID="d3df20c6-7850-4cbe-8c23-7b55a9eeddff" autoIncrement="false" autoIncrementSequenceName="galeriaitem_galeriafolder_id_in_seq" defaultValue="" name="Galeria Folder ID" nullable="0" physicalName="galeriafolder_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    374      <remarks></remarks>
    375     </column>
    376     <column id="COL104" populated="true" UUID="c283a2a0-74e1-4ae1-a6a0-481b57e2e5da" autoIncrement="false" autoIncrementSequenceName="galeriaitem_galeriaitem_ref_ch_seq" defaultValue="" name="Galeria Item Ref" nullable="0" physicalName="galeriaitem_ref_ch" precision="512" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     336    <column id="COL94" populated="true" UUID="565a9e1a-80cf-40c7-bac2-5243e029320c" autoIncrement="false" autoIncrementSequenceName="galeria_galeria_nome_ch_seq" defaultValue="" name="Nome da Galeria" nullable="0" physicalName="galeria_nome_ch" precision="128" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     337     <remarks></remarks>
     338    </column>
     339    <column id="COL95" populated="true" UUID="79571ba6-ec20-4401-a559-32e35aacf0e4" autoIncrement="false" autoIncrementSequenceName="galeria_galeriafolder_id_in_seq" defaultValue="" name="Galeria Folder ID" nullable="0" physicalName="galeriafolder_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     340     <remarks></remarks>
     341    </column>
     342    </folder>
     343    <folder id="FOLTAB913" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
     344    </folder>
     345    <folder id="FOLTAB912" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
     346    </folder>
     347    <folder id="FOLTAB914" populated="true" name="Indices" physicalName="Indices" type="4">
     348    <index id="IDX96" populated="true" UUID="58c639f3-887c-4565-b8d8-a417e7833ba4" clustered="false" name="galeria_pk" physicalName="galeria_pk" primaryKeyIndex="true" unique="false" >
     349     <index-column id="IDC97" populated="true" UUID="abb2a2cd-f45d-4843-add2-24767cc25a87" ascendingOrDescending="UNSPECIFIED" column-ref="COL92" name="Identificador da Galeria" physicalName="galeria_id_in" />
     350    </index>
     351   </folder>
     352  </table>
     353  <table id="TAB98" populated="true" UUID="d0700f82-4688-46cb-ade4-ba58a8537105" name="Galeria Folder" objectType="TABLE" physicalName="galeriafolder" >
     354   <remarks></remarks>
     355   <folder id="FOLTAB981" populated="true" name="Columns" physicalName="Columns" type="1">
     356    <column id="COL99" populated="true" UUID="9ee77725-b3b9-48d5-85ec-5c81c26dda5e" autoIncrement="true" autoIncrementSequenceName="galeriafolder_galeriafolder_id_in_seq" defaultValue="" name="Galeria Folder ID" nullable="0" physicalName="galeriafolder_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     357     <remarks></remarks>
     358    </column>
     359    <column id="COL100" populated="true" UUID="e86ee0f3-fa88-4545-83d1-14129ac77bce" autoIncrement="false" autoIncrementSequenceName="galeriafolder_galeriafolder_parentid_in_seq" defaultValue="" name="Galeria Parent Folder ID" nullable="0" physicalName="galeriafolder_parentid_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     360     <remarks></remarks>
     361    </column>
     362    <column id="COL101" populated="true" UUID="a7d6da6d-3b36-49e3-9db2-f47e2cdd5bcc" autoIncrement="false" autoIncrementSequenceName="galeriafolder_galeriafolder_nome_ch_seq" defaultValue="" name="Galeria Folder Nome" nullable="0" physicalName="galeriafolder_nome_ch" precision="128" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     363     <remarks></remarks>
     364    </column>
     365    </folder>
     366    <folder id="FOLTAB983" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
     367    </folder>
     368    <folder id="FOLTAB982" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
     369    </folder>
     370    <folder id="FOLTAB984" populated="true" name="Indices" physicalName="Indices" type="4">
     371    <index id="IDX102" populated="true" UUID="0bdbf7a3-c23e-4146-94f9-5626ba839ca9" clustered="false" name="galeriafolder_pk" physicalName="galeriafolder_pk" primaryKeyIndex="true" unique="false" >
     372     <index-column id="IDC103" populated="true" UUID="5833f099-7854-4225-9a00-8b3a89f50249" ascendingOrDescending="UNSPECIFIED" column-ref="COL99" name="Galeria Folder ID" physicalName="galeriafolder_id_in" />
     373    </index>
     374   </folder>
     375  </table>
     376  <table id="TAB104" populated="true" UUID="85bdafb3-f2b6-4685-9df0-8ed401044888" name="Galeria Item" objectType="TABLE" physicalName="galeriaitem" >
     377   <remarks></remarks>
     378   <folder id="FOLTAB1041" populated="true" name="Columns" physicalName="Columns" type="1">
     379    <column id="COL105" populated="true" UUID="5f1b6adc-738f-44a0-a1b7-d8cf8a2e1eaa" autoIncrement="true" autoIncrementSequenceName="galeriaitem_galeriaitem_id_in_seq" defaultValue="" name="Galeria Item ID" nullable="0" physicalName="galeriaitem_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     380     <remarks></remarks>
     381    </column>
     382    <column id="COL106" populated="true" UUID="d3df20c6-7850-4cbe-8c23-7b55a9eeddff" autoIncrement="false" autoIncrementSequenceName="galeriaitem_galeriafolder_id_in_seq" defaultValue="" name="Galeria Folder ID" nullable="0" physicalName="galeriafolder_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     383     <remarks></remarks>
     384    </column>
     385    <column id="COL107" populated="true" UUID="c283a2a0-74e1-4ae1-a6a0-481b57e2e5da" autoIncrement="false" autoIncrementSequenceName="galeriaitem_galeriaitem_ref_ch_seq" defaultValue="" name="Galeria Item Ref" nullable="0" physicalName="galeriaitem_ref_ch" precision="512" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    377386     <remarks>URL completa do item.</remarks>
    378387    </column>
    379     <column id="COL105" populated="true" UUID="36be758d-9a20-4302-b5cc-a13e80de30da" autoIncrement="false" autoIncrementSequenceName="galeriaitem_galeriatipoitem_desc_tx_seq" defaultValue="" name="Descrição do Item da Galeria" nullable="0" physicalName="galeriatipoitem_desc_tx" precision="512" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    380      <remarks></remarks>
    381     </column>
    382     <column id="COL106" populated="true" UUID="74748fe6-3e6b-46f0-aba8-3582061de529" autoIncrement="false" autoIncrementSequenceName="galeriaitem_mimetype_id_in_seq" defaultValue="" name="MIME Type ID" nullable="0" physicalName="mimetype_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    383      <remarks></remarks>
    384     </column>
    385     <column id="COL107" populated="true" UUID="4e60581f-d984-4790-a65f-92458bab3da7" autoIncrement="false" autoIncrementSequenceName="galeriaitem_galeriatipoitem_id_in_seq" defaultValue="" name="Identificador do Tipo de Item da Galeria" nullable="0" physicalName="galeriatipoitem_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    386      <remarks></remarks>
    387     </column>
    388     </folder>
    389     <folder id="FOLTAB1013" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    390     </folder>
    391     <folder id="FOLTAB1012" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    392     </folder>
    393     <folder id="FOLTAB1014" populated="true" name="Indices" physicalName="Indices" type="4">
    394     <index id="IDX108" populated="true" UUID="f968283e-526d-476b-bbb9-b4d22001b8c3" clustered="false" name="galeriaitem_pk" physicalName="galeriaitem_pk" primaryKeyIndex="true" unique="false" >
    395      <index-column id="IDC109" populated="true" UUID="f1766f6e-ea1a-4e3c-a1c0-b89d28a453f6" ascendingOrDescending="UNSPECIFIED" column-ref="COL102" name="Galeria Item ID" physicalName="galeriaitem_id_in" />
    396     </index>
    397    </folder>
    398   </table>
    399   <table id="TAB110" populated="true" UUID="c421be80-e18c-46b1-bdf1-7b1504db79fd" name="Tipos MIME" objectType="TABLE" physicalName="mimetype" >
    400    <remarks></remarks>
    401    <folder id="FOLTAB1101" populated="true" name="Columns" physicalName="Columns" type="1">
    402     <column id="COL111" populated="true" UUID="acb5c3b2-2bc5-4a0a-9171-2213617ecf95" autoIncrement="true" autoIncrementSequenceName="mimetype_id_in_seq" defaultValue="" name="MIME Type ID" nullable="0" physicalName="mimetype_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    403      <remarks></remarks>
    404     </column>
    405     <column id="COL112" populated="true" UUID="b6610f59-4768-46b4-bfdf-313f15ad3c36" autoIncrement="false" autoIncrementSequenceName="mimetype_mimetype_contenttype_ch_seq" defaultValue="" name="MIME Type Content Type" nullable="0" physicalName="mimetype_contenttype_ch" precision="64" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    406      <remarks></remarks>
    407     </column>
    408     <column id="COL113" populated="true" UUID="db2bdee2-6466-45ec-a54b-052cb0b6973a" autoIncrement="false" autoIncrementSequenceName="mimetype_mimetype_desc_ch_seq" defaultValue="" name="MIME Type Description" nullable="0" physicalName="mimetype_desc_ch" precision="128" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    409      <remarks></remarks>
    410     </column>
    411     </folder>
    412     <folder id="FOLTAB1103" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    413     </folder>
    414     <folder id="FOLTAB1102" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    415     </folder>
    416     <folder id="FOLTAB1104" populated="true" name="Indices" physicalName="Indices" type="4">
    417     <index id="IDX114" populated="true" UUID="864455b1-8132-4a9e-aa68-4c5452d115c3" clustered="false" name="mimetype_pk" physicalName="mimetype_pk" primaryKeyIndex="true" unique="false" >
    418      <index-column id="IDC115" populated="true" UUID="44e97842-dc10-4937-9b5e-5cac05d47585" ascendingOrDescending="UNSPECIFIED" column-ref="COL111" name="MIME Type ID" physicalName="mimetype_id_in" />
    419     </index>
    420     <index id="IDX116" populated="true" UUID="46cff08a-9c4b-4600-970e-e9d8c3e9f4c6" clustered="false" name="mimetype_ak" physicalName="mimetype_ak" primaryKeyIndex="false" unique="true" >
    421      <index-column id="IDC117" populated="true" UUID="00b1d4f0-d631-445a-81ee-231c3db5554b" ascendingOrDescending="ASCENDING" column-ref="COL112" name="MIME Type Content Type" physicalName="mimetype_contenttype_ch" />
    422     </index>
    423    </folder>
    424   </table>
    425   <table id="TAB118" populated="true" UUID="bd6a6407-0716-42ea-abb1-c02d1774f18f" name="Tipo de Item de Galeria" objectType="TABLE" physicalName="galeriatipoitem" >
    426    <remarks></remarks>
    427    <folder id="FOLTAB1181" populated="true" name="Columns" physicalName="Columns" type="1">
    428     <column id="COL119" populated="true" UUID="b4ff05b3-e0dc-430d-bed2-e74dfaf469f8" autoIncrement="true" autoIncrementSequenceName="galeriatipoitem_id_in_seq" defaultValue="" name="Identificador do Tipo de Item da Galeria" nullable="0" physicalName="galeriatipoitem_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
    429      <remarks></remarks>
    430     </column>
    431     <column id="COL120" populated="true" UUID="2334c117-359b-42f4-b874-1b6ee1693194" autoIncrement="false" autoIncrementSequenceName="galeriatipoitem_codinome_ch_seq" defaultValue="" name="Codinome do Tipo de Item de Galeria" nullable="0" physicalName="galeriatipoitem_codinome_ch" precision="16" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    432      <remarks></remarks>
    433     </column>
    434     <column id="COL121" populated="true" UUID="f7ff22b9-6ea8-4e0a-bc7d-39f531b12168" autoIncrement="false" autoIncrementSequenceName="galeriatipoitem_galeriatipoitem_desc_ch_seq" defaultValue="" name="Nome do Tipo do Item da Galeria" nullable="0" physicalName="galeriatipoitem_desc_ch" precision="128" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
    435      <remarks></remarks>
    436     </column>
    437     </folder>
    438     <folder id="FOLTAB1183" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
    439     </folder>
    440     <folder id="FOLTAB1182" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
    441     </folder>
    442     <folder id="FOLTAB1184" populated="true" name="Indices" physicalName="Indices" type="4">
    443     <index id="IDX122" populated="true" UUID="bb5735d6-30ed-4d7d-aa44-5a3a266b82ea" clustered="false" name="galeriatipoitem_pk" physicalName="galeriatipoitem_pk" primaryKeyIndex="true" unique="false" >
    444      <index-column id="IDC123" populated="true" UUID="7c790964-4c93-4630-b030-5d439fc7846c" ascendingOrDescending="UNSPECIFIED" column-ref="COL119" name="Identificador do Tipo de Item da Galeria" physicalName="galeriatipoitem_id_in" />
    445     </index>
    446     <index id="IDX124" populated="true" UUID="e407d99b-8b36-4fe1-8a29-5447cccac41e" clustered="false" name="galeriatipoitem_codinome_ch_idx" physicalName="galeriatipoitem_codinome_ch_idx" primaryKeyIndex="false" unique="true" >
    447      <index-column id="IDC125" populated="true" UUID="b7d86e8d-653b-4e74-bcb9-ab1e235e317d" ascendingOrDescending="ASCENDING" column-ref="COL120" name="Codinome do Tipo de Item de Galeria" physicalName="galeriatipoitem_codinome_ch" />
     388    <column id="COL108" populated="true" UUID="36be758d-9a20-4302-b5cc-a13e80de30da" autoIncrement="false" autoIncrementSequenceName="galeriaitem_galeriatipoitem_desc_tx_seq" defaultValue="" name="Descrição do Item da Galeria" nullable="0" physicalName="galeriatipoitem_desc_tx" precision="512" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     389     <remarks></remarks>
     390    </column>
     391    <column id="COL109" populated="true" UUID="74748fe6-3e6b-46f0-aba8-3582061de529" autoIncrement="false" autoIncrementSequenceName="galeriaitem_mimetype_id_in_seq" defaultValue="" name="MIME Type ID" nullable="0" physicalName="mimetype_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     392     <remarks></remarks>
     393    </column>
     394    <column id="COL110" populated="true" UUID="4e60581f-d984-4790-a65f-92458bab3da7" autoIncrement="false" autoIncrementSequenceName="galeriaitem_galeriatipoitem_id_in_seq" defaultValue="" name="Identificador do Tipo de Item da Galeria" nullable="0" physicalName="galeriatipoitem_id_in" precision="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     395     <remarks></remarks>
     396    </column>
     397    </folder>
     398    <folder id="FOLTAB1043" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
     399    </folder>
     400    <folder id="FOLTAB1042" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
     401    </folder>
     402    <folder id="FOLTAB1044" populated="true" name="Indices" physicalName="Indices" type="4">
     403    <index id="IDX111" populated="true" UUID="f968283e-526d-476b-bbb9-b4d22001b8c3" clustered="false" name="galeriaitem_pk" physicalName="galeriaitem_pk" primaryKeyIndex="true" unique="false" >
     404     <index-column id="IDC112" populated="true" UUID="f1766f6e-ea1a-4e3c-a1c0-b89d28a453f6" ascendingOrDescending="UNSPECIFIED" column-ref="COL105" name="Galeria Item ID" physicalName="galeriaitem_id_in" />
     405    </index>
     406   </folder>
     407  </table>
     408  <table id="TAB113" populated="true" UUID="c421be80-e18c-46b1-bdf1-7b1504db79fd" name="Tipos MIME" objectType="TABLE" physicalName="mimetype" >
     409   <remarks></remarks>
     410   <folder id="FOLTAB1131" populated="true" name="Columns" physicalName="Columns" type="1">
     411    <column id="COL114" populated="true" UUID="acb5c3b2-2bc5-4a0a-9171-2213617ecf95" autoIncrement="true" autoIncrementSequenceName="mimetype_id_in_seq" defaultValue="" name="MIME Type ID" nullable="0" physicalName="mimetype_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     412     <remarks></remarks>
     413    </column>
     414    <column id="COL115" populated="true" UUID="b6610f59-4768-46b4-bfdf-313f15ad3c36" autoIncrement="false" autoIncrementSequenceName="mimetype_mimetype_contenttype_ch_seq" defaultValue="" name="MIME Type Content Type" nullable="0" physicalName="mimetype_contenttype_ch" precision="64" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     415     <remarks></remarks>
     416    </column>
     417    <column id="COL116" populated="true" UUID="db2bdee2-6466-45ec-a54b-052cb0b6973a" autoIncrement="false" autoIncrementSequenceName="mimetype_mimetype_desc_ch_seq" defaultValue="" name="MIME Type Description" nullable="0" physicalName="mimetype_desc_ch" precision="128" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     418     <remarks></remarks>
     419    </column>
     420    </folder>
     421    <folder id="FOLTAB1133" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
     422    </folder>
     423    <folder id="FOLTAB1132" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
     424    </folder>
     425    <folder id="FOLTAB1134" populated="true" name="Indices" physicalName="Indices" type="4">
     426    <index id="IDX117" populated="true" UUID="864455b1-8132-4a9e-aa68-4c5452d115c3" clustered="false" name="mimetype_pk" physicalName="mimetype_pk" primaryKeyIndex="true" unique="false" >
     427     <index-column id="IDC118" populated="true" UUID="44e97842-dc10-4937-9b5e-5cac05d47585" ascendingOrDescending="UNSPECIFIED" column-ref="COL114" name="MIME Type ID" physicalName="mimetype_id_in" />
     428    </index>
     429    <index id="IDX119" populated="true" UUID="46cff08a-9c4b-4600-970e-e9d8c3e9f4c6" clustered="false" name="mimetype_ak" physicalName="mimetype_ak" primaryKeyIndex="false" unique="true" >
     430     <index-column id="IDC120" populated="true" UUID="00b1d4f0-d631-445a-81ee-231c3db5554b" ascendingOrDescending="ASCENDING" column-ref="COL115" name="MIME Type Content Type" physicalName="mimetype_contenttype_ch" />
     431    </index>
     432   </folder>
     433  </table>
     434  <table id="TAB121" populated="true" UUID="bd6a6407-0716-42ea-abb1-c02d1774f18f" name="Tipo de Item de Galeria" objectType="TABLE" physicalName="galeriatipoitem" >
     435   <remarks></remarks>
     436   <folder id="FOLTAB1211" populated="true" name="Columns" physicalName="Columns" type="1">
     437    <column id="COL122" populated="true" UUID="b4ff05b3-e0dc-430d-bed2-e74dfaf469f8" autoIncrement="true" autoIncrementSequenceName="galeriatipoitem_id_in_seq" defaultValue="" name="Identificador do Tipo de Item da Galeria" nullable="0" physicalName="galeriatipoitem_id_in" precision="0" primaryKeySeq="0" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="4" userDefinedTypeUUID="63b011c7-c81f-4c75-8271-632b3c87f727" >
     438     <remarks></remarks>
     439    </column>
     440    <column id="COL123" populated="true" UUID="2334c117-359b-42f4-b874-1b6ee1693194" autoIncrement="false" autoIncrementSequenceName="galeriatipoitem_codinome_ch_seq" defaultValue="" name="Codinome do Tipo de Item de Galeria" nullable="0" physicalName="galeriatipoitem_codinome_ch" precision="16" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     441     <remarks></remarks>
     442    </column>
     443    <column id="COL124" populated="true" UUID="f7ff22b9-6ea8-4e0a-bc7d-39f531b12168" autoIncrement="false" autoIncrementSequenceName="galeriatipoitem_galeriatipoitem_desc_ch_seq" defaultValue="" name="Nome do Tipo do Item da Galeria" nullable="0" physicalName="galeriatipoitem_desc_ch" precision="128" referenceCount="1" scale="0" sourceDataTypeName="UserDefinedSQLType" type="1" userDefinedTypeUUID="67ddc63f-5541-4dd1-9236-632d9d155e80" >
     444     <remarks></remarks>
     445    </column>
     446    </folder>
     447    <folder id="FOLTAB1213" populated="true" name="Exported Keys" physicalName="Exported Keys" type="3">
     448    </folder>
     449    <folder id="FOLTAB1212" populated="true" name="Imported Keys" physicalName="Imported Keys" type="2">
     450    </folder>
     451    <folder id="FOLTAB1214" populated="true" name="Indices" physicalName="Indices" type="4">
     452    <index id="IDX125" populated="true" UUID="bb5735d6-30ed-4d7d-aa44-5a3a266b82ea" clustered="false" name="galeriatipoitem_pk" physicalName="galeriatipoitem_pk" primaryKeyIndex="true" unique="false" >
     453     <index-column id="IDC126" populated="true" UUID="7c790964-4c93-4630-b030-5d439fc7846c" ascendingOrDescending="UNSPECIFIED" column-ref="COL122" name="Identificador do Tipo de Item da Galeria" physicalName="galeriatipoitem_id_in" />
     454    </index>
     455    <index id="IDX127" populated="true" UUID="e407d99b-8b36-4fe1-8a29-5447cccac41e" clustered="false" name="galeriatipoitem_codinome_ch_idx" physicalName="galeriatipoitem_codinome_ch_idx" primaryKeyIndex="false" unique="true" >
     456     <index-column id="IDC128" populated="true" UUID="b7d86e8d-653b-4e74-bcb9-ab1e235e317d" ascendingOrDescending="ASCENDING" column-ref="COL123" name="Codinome do Tipo de Item de Galeria" physicalName="galeriatipoitem_codinome_ch" />
    448457    </index>
    449458   </folder>
    450459  </table>
    451460  <relationships>
    452    <relationship id="REL126" populated="true" UUID="9618374f-1c0f-487c-a469-4987c6638076" deferrability="7" deleteRule="3" fk-table-ref="TAB12" fkCardinality="7" identifying="true" name="vertice_origem_fk" physicalName="vertice_origem_fk" pk-table-ref="TAB7" pkCardinality="2" updateRule="3" >
    453     <column-mapping id="CMP127" populated="true" UUID="7f0e4845-bf84-4ba5-aa4c-623fcae11bfb" fk-column-ref="COL13" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL8" />
    454    </relationship>
    455    <relationship id="REL128" populated="true" UUID="807135ae-7fcc-43bf-9207-65d69e9af518" deferrability="7" deleteRule="3" fk-table-ref="TAB12" fkCardinality="7" identifying="true" name="vertice_aresta_fk" physicalName="vertice_aresta_fk" pk-table-ref="TAB7" pkCardinality="2" updateRule="3" >
    456     <column-mapping id="CMP129" populated="true" UUID="85a45d99-d318-4a73-92c7-4551b13b2aaf" fk-column-ref="COL14" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL8" />
    457    </relationship>
    458    <relationship id="REL130" populated="true" UUID="d157a6f2-327c-4bff-ad8a-3530b7e7f405" deferrability="7" deleteRule="3" fk-table-ref="TAB51" fkCardinality="7" identifying="false" name="vertice_atributovertice_fk" physicalName="vertice_atributovertice_fk" pk-table-ref="TAB7" pkCardinality="2" updateRule="3" >
    459     <column-mapping id="CMP131" populated="true" UUID="e0575dd1-ac43-4227-87dd-e8a74a33cba4" fk-column-ref="COL53" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL8" />
    460    </relationship>
    461    <relationship id="REL132" populated="true" UUID="f79d429e-d665-4b00-927f-dcee1382a717" deferrability="7" deleteRule="3" fk-table-ref="TAB58" fkCardinality="7" identifying="false" name="vertice_timeline_fk" physicalName="vertice_timeline_fk" pk-table-ref="TAB7" pkCardinality="2" updateRule="3" >
    462     <column-mapping id="CMP133" populated="true" UUID="7bfcbd96-7374-47ab-81df-cbc39df63567" fk-column-ref="COL60" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL8" />
    463    </relationship>
    464    <relationship id="REL134" populated="true" UUID="17b36c07-ee90-43f3-80a5-b474db584189" deferrability="7" deleteRule="3" fk-table-ref="TAB88" fkCardinality="7" identifying="false" name="vertice_galeria_fk" physicalName="vertice_galeria_fk" pk-table-ref="TAB7" pkCardinality="2" updateRule="3" >
    465     <column-mapping id="CMP135" populated="true" UUID="f50671a5-c884-4355-8cc2-b5d62cd86aa2" fk-column-ref="COL90" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL8" />
    466    </relationship>
    467    <relationship id="REL136" populated="true" UUID="676ba187-97e6-4abf-9021-6cec57e6382e" deferrability="7" deleteRule="3" fk-table-ref="TAB82" fkCardinality="7" identifying="true" name="tipoaresta_tipogrupoarestas_fk" physicalName="tipoaresta_tipogrupoarestas_fk" pk-table-ref="TAB22" pkCardinality="2" updateRule="3" >
    468     <column-mapping id="CMP137" populated="true" UUID="1cd0db57-c1e7-47d7-87a3-2ed251597bc5" fk-column-ref="COL84" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL23" />
    469    </relationship>
    470    <relationship id="REL138" populated="true" UUID="71029a99-11b6-427c-b54e-52d604a32f94" deferrability="7" deleteRule="3" fk-table-ref="TAB12" fkCardinality="7" identifying="true" name="tipoaresta_aresta_fk" physicalName="tipoaresta_aresta_fk" pk-table-ref="TAB22" pkCardinality="2" updateRule="3" >
    471     <column-mapping id="CMP139" populated="true" UUID="b96a5f92-e515-4584-ae54-76a542441a4c" fk-column-ref="COL15" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL23" />
    472    </relationship>
    473    <relationship id="REL140" populated="true" UUID="7a8f00e3-1b2c-4867-8740-6133d00ac7b4" deferrability="7" deleteRule="3" fk-table-ref="TAB7" fkCardinality="7" identifying="false" name="tipovertice_vertice_fk" physicalName="tipovertice_vertice_fk" pk-table-ref="TAB30" pkCardinality="2" updateRule="3" >
    474     <column-mapping id="CMP141" populated="true" UUID="33c72889-a6d2-48a0-9c00-fd733299977e" fk-column-ref="COL9" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL31" />
    475    </relationship>
    476    <relationship id="REL142" populated="true" UUID="ec27f7a4-c3ae-436a-a338-25670074cc4d" deferrability="7" deleteRule="3" fk-table-ref="TAB39" fkCardinality="7" identifying="false" name="tipovertice_classeatributovertice_fk" physicalName="tipovertice_classeatributovertice_fk" pk-table-ref="TAB30" pkCardinality="2" updateRule="3" >
    477     <column-mapping id="CMP143" populated="true" UUID="30f2b0e2-b8ab-4032-80ba-2ec8b3a5040a" fk-column-ref="COL41" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL31" />
    478    </relationship>
    479    <relationship id="REL144" populated="true" UUID="d401f7fd-d529-4590-a750-d74f06413b06" deferrability="7" deleteRule="3" fk-table-ref="TAB51" fkCardinality="7" identifying="false" name="classeatributovertice_atributovertice_fk" physicalName="classeatributovertice_atributovertice_fk" pk-table-ref="TAB39" pkCardinality="2" updateRule="3" >
    480     <column-mapping id="CMP145" populated="true" UUID="d75ff771-2dff-48e8-86f7-a5f136e9ae80" fk-column-ref="COL54" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL40" />
    481    </relationship>
    482    <relationship id="REL146" populated="true" UUID="39745691-cf48-481b-95c1-a6835f0d1036" deferrability="7" deleteRule="3" fk-table-ref="TAB58" fkCardinality="7" identifying="false" name="tipoevento_timeline_fk" physicalName="tipoevento_timeline_fk" pk-table-ref="TAB66" pkCardinality="2" updateRule="3" >
    483     <column-mapping id="CMP147" populated="true" UUID="14e05d01-9f4e-4943-9055-41831d00887c" fk-column-ref="COL61" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL67" />
    484    </relationship>
    485    <relationship id="REL148" populated="true" UUID="d0b8c628-3a5a-49ec-ac23-4be3fd64ac6d" deferrability="7" deleteRule="3" fk-table-ref="TAB82" fkCardinality="7" identifying="true" name="grupoarestas_tipogrupoarestas_fk" physicalName="grupoarestas_tipogrupoarestas_fk" pk-table-ref="TAB74" pkCardinality="2" updateRule="3" >
    486     <column-mapping id="CMP149" populated="true" UUID="96ce3e18-52df-44c5-91c4-b399a469850d" fk-column-ref="COL83" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL75" />
    487    </relationship>
    488    <relationship id="REL150" populated="true" UUID="bb348366-daba-457c-ae67-8f6f902c3f56" deferrability="7" deleteRule="0" fk-table-ref="TAB95" fkCardinality="7" identifying="false" name="galeriafolder_galeriafolder_fk" physicalName="galeriafolder_galeriafolder_fk" pk-table-ref="TAB95" pkCardinality="2" updateRule="3" >
    489     <column-mapping id="CMP151" populated="true" UUID="20d20bea-aad6-4b96-af7a-312de52bf4d0" fk-column-ref="COL97" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL96" />
    490    </relationship>
    491    <relationship id="REL152" populated="true" UUID="7fcde613-6a04-4440-9f42-9c16d6aa3925" deferrability="7" deleteRule="0" fk-table-ref="TAB88" fkCardinality="3" identifying="false" name="galeriafolder_galeria_fk" physicalName="galeriafolder_galeria_fk" pk-table-ref="TAB95" pkCardinality="2" updateRule="3" >
    492     <column-mapping id="CMP153" populated="true" UUID="79f29650-086b-4a73-b05a-e1437d6f1e3c" fk-column-ref="COL92" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL96" />
    493    </relationship>
    494    <relationship id="REL154" populated="true" UUID="3223b597-29d4-4bed-a442-8de440f32bc9" deferrability="7" deleteRule="3" fk-table-ref="TAB101" fkCardinality="7" identifying="false" name="galeriafolder_galeriaitem_fk" physicalName="galeriafolder_galeriaitem_fk" pk-table-ref="TAB95" pkCardinality="2" updateRule="3" >
    495     <column-mapping id="CMP155" populated="true" UUID="48766437-4478-46cf-95f9-b4c044570e88" fk-column-ref="COL103" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL96" />
    496    </relationship>
    497    <relationship id="REL156" populated="true" UUID="d28037cc-09ca-4aa1-bc09-fd42ae6c4d93" deferrability="7" deleteRule="3" fk-table-ref="TAB101" fkCardinality="7" identifying="false" name="mimetype_galeriaitem_fk" physicalName="mimetype_galeriaitem_fk" pk-table-ref="TAB110" pkCardinality="2" updateRule="3" >
    498     <column-mapping id="CMP157" populated="true" UUID="4de8c97e-2a80-4157-afd2-a6d13d94adab" fk-column-ref="COL106" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL111" />
    499    </relationship>
    500    <relationship id="REL158" populated="true" UUID="7bb8c66d-bdc0-4733-8c29-aa01132c7fc4" deferrability="7" deleteRule="3" fk-table-ref="TAB101" fkCardinality="7" identifying="false" name="galeriatipoitem_galeriaitem_fk" physicalName="galeriatipoitem_galeriaitem_fk" pk-table-ref="TAB118" pkCardinality="2" updateRule="3" >
    501     <column-mapping id="CMP159" populated="true" UUID="4f12d114-be9b-4963-aeaf-fdd71861060d" fk-column-ref="COL107" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL119" />
     461   <relationship id="REL129" populated="true" UUID="9618374f-1c0f-487c-a469-4987c6638076" deferrability="7" deleteRule="3" fk-table-ref="TAB12" fkCardinality="7" identifying="true" name="vertice_origem_fk" physicalName="vertice_origem_fk" pk-table-ref="TAB7" pkCardinality="2" updateRule="3" >
     462    <column-mapping id="CMP130" populated="true" UUID="7f0e4845-bf84-4ba5-aa4c-623fcae11bfb" fk-column-ref="COL13" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL8" />
     463   </relationship>
     464   <relationship id="REL131" populated="true" UUID="807135ae-7fcc-43bf-9207-65d69e9af518" deferrability="7" deleteRule="3" fk-table-ref="TAB12" fkCardinality="7" identifying="true" name="vertice_aresta_fk" physicalName="vertice_aresta_fk" pk-table-ref="TAB7" pkCardinality="2" updateRule="3" >
     465    <column-mapping id="CMP132" populated="true" UUID="85a45d99-d318-4a73-92c7-4551b13b2aaf" fk-column-ref="COL14" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL8" />
     466   </relationship>
     467   <relationship id="REL133" populated="true" UUID="d157a6f2-327c-4bff-ad8a-3530b7e7f405" deferrability="7" deleteRule="3" fk-table-ref="TAB53" fkCardinality="7" identifying="false" name="vertice_atributovertice_fk" physicalName="vertice_atributovertice_fk" pk-table-ref="TAB7" pkCardinality="2" updateRule="3" >
     468    <column-mapping id="CMP134" populated="true" UUID="e0575dd1-ac43-4227-87dd-e8a74a33cba4" fk-column-ref="COL55" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL8" />
     469   </relationship>
     470   <relationship id="REL135" populated="true" UUID="f79d429e-d665-4b00-927f-dcee1382a717" deferrability="7" deleteRule="3" fk-table-ref="TAB61" fkCardinality="7" identifying="false" name="vertice_timeline_fk" physicalName="vertice_timeline_fk" pk-table-ref="TAB7" pkCardinality="2" updateRule="3" >
     471    <column-mapping id="CMP136" populated="true" UUID="7bfcbd96-7374-47ab-81df-cbc39df63567" fk-column-ref="COL63" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL8" />
     472   </relationship>
     473   <relationship id="REL137" populated="true" UUID="17b36c07-ee90-43f3-80a5-b474db584189" deferrability="7" deleteRule="3" fk-table-ref="TAB91" fkCardinality="7" identifying="false" name="vertice_galeria_fk" physicalName="vertice_galeria_fk" pk-table-ref="TAB7" pkCardinality="2" updateRule="3" >
     474    <column-mapping id="CMP138" populated="true" UUID="f50671a5-c884-4355-8cc2-b5d62cd86aa2" fk-column-ref="COL93" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL8" />
     475   </relationship>
     476   <relationship id="REL139" populated="true" UUID="676ba187-97e6-4abf-9021-6cec57e6382e" deferrability="7" deleteRule="3" fk-table-ref="TAB85" fkCardinality="7" identifying="true" name="tipoaresta_tipogrupoarestas_fk" physicalName="tipoaresta_tipogrupoarestas_fk" pk-table-ref="TAB22" pkCardinality="2" updateRule="3" >
     477    <column-mapping id="CMP140" populated="true" UUID="1cd0db57-c1e7-47d7-87a3-2ed251597bc5" fk-column-ref="COL87" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL23" />
     478   </relationship>
     479   <relationship id="REL141" populated="true" UUID="71029a99-11b6-427c-b54e-52d604a32f94" deferrability="7" deleteRule="3" fk-table-ref="TAB12" fkCardinality="7" identifying="true" name="tipoaresta_aresta_fk" physicalName="tipoaresta_aresta_fk" pk-table-ref="TAB22" pkCardinality="2" updateRule="3" >
     480    <column-mapping id="CMP142" populated="true" UUID="b96a5f92-e515-4584-ae54-76a542441a4c" fk-column-ref="COL15" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL23" />
     481   </relationship>
     482   <relationship id="REL143" populated="true" UUID="7a8f00e3-1b2c-4867-8740-6133d00ac7b4" deferrability="7" deleteRule="3" fk-table-ref="TAB7" fkCardinality="7" identifying="false" name="tipovertice_vertice_fk" physicalName="tipovertice_vertice_fk" pk-table-ref="TAB30" pkCardinality="2" updateRule="3" >
     483    <column-mapping id="CMP144" populated="true" UUID="33c72889-a6d2-48a0-9c00-fd733299977e" fk-column-ref="COL9" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL31" />
     484   </relationship>
     485   <relationship id="REL145" populated="true" UUID="ec27f7a4-c3ae-436a-a338-25670074cc4d" deferrability="7" deleteRule="3" fk-table-ref="TAB39" fkCardinality="7" identifying="false" name="tipovertice_classeatributovertice_fk" physicalName="tipovertice_classeatributovertice_fk" pk-table-ref="TAB30" pkCardinality="2" updateRule="3" >
     486    <column-mapping id="CMP146" populated="true" UUID="30f2b0e2-b8ab-4032-80ba-2ec8b3a5040a" fk-column-ref="COL41" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL31" />
     487   </relationship>
     488   <relationship id="REL147" populated="true" UUID="d401f7fd-d529-4590-a750-d74f06413b06" deferrability="7" deleteRule="3" fk-table-ref="TAB53" fkCardinality="7" identifying="false" name="classeatributovertice_atributovertice_fk" physicalName="classeatributovertice_atributovertice_fk" pk-table-ref="TAB39" pkCardinality="2" updateRule="3" >
     489    <column-mapping id="CMP148" populated="true" UUID="d75ff771-2dff-48e8-86f7-a5f136e9ae80" fk-column-ref="COL56" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL40" />
     490   </relationship>
     491   <relationship id="REL149" populated="true" UUID="39745691-cf48-481b-95c1-a6835f0d1036" deferrability="7" deleteRule="3" fk-table-ref="TAB61" fkCardinality="7" identifying="false" name="tipoevento_timeline_fk" physicalName="tipoevento_timeline_fk" pk-table-ref="TAB69" pkCardinality="2" updateRule="3" >
     492    <column-mapping id="CMP150" populated="true" UUID="14e05d01-9f4e-4943-9055-41831d00887c" fk-column-ref="COL64" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL70" />
     493   </relationship>
     494   <relationship id="REL151" populated="true" UUID="d0b8c628-3a5a-49ec-ac23-4be3fd64ac6d" deferrability="7" deleteRule="3" fk-table-ref="TAB85" fkCardinality="7" identifying="true" name="grupoarestas_tipogrupoarestas_fk" physicalName="grupoarestas_tipogrupoarestas_fk" pk-table-ref="TAB77" pkCardinality="2" updateRule="3" >
     495    <column-mapping id="CMP152" populated="true" UUID="96ce3e18-52df-44c5-91c4-b399a469850d" fk-column-ref="COL86" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL78" />
     496   </relationship>
     497   <relationship id="REL153" populated="true" UUID="bb348366-daba-457c-ae67-8f6f902c3f56" deferrability="7" deleteRule="0" fk-table-ref="TAB98" fkCardinality="7" identifying="false" name="galeriafolder_galeriafolder_fk" physicalName="galeriafolder_galeriafolder_fk" pk-table-ref="TAB98" pkCardinality="2" updateRule="3" >
     498    <column-mapping id="CMP154" populated="true" UUID="20d20bea-aad6-4b96-af7a-312de52bf4d0" fk-column-ref="COL100" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL99" />
     499   </relationship>
     500   <relationship id="REL155" populated="true" UUID="7fcde613-6a04-4440-9f42-9c16d6aa3925" deferrability="7" deleteRule="0" fk-table-ref="TAB91" fkCardinality="3" identifying="false" name="galeriafolder_galeria_fk" physicalName="galeriafolder_galeria_fk" pk-table-ref="TAB98" pkCardinality="2" updateRule="3" >
     501    <column-mapping id="CMP156" populated="true" UUID="79f29650-086b-4a73-b05a-e1437d6f1e3c" fk-column-ref="COL95" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL99" />
     502   </relationship>
     503   <relationship id="REL157" populated="true" UUID="3223b597-29d4-4bed-a442-8de440f32bc9" deferrability="7" deleteRule="3" fk-table-ref="TAB104" fkCardinality="7" identifying="false" name="galeriafolder_galeriaitem_fk" physicalName="galeriafolder_galeriaitem_fk" pk-table-ref="TAB98" pkCardinality="2" updateRule="3" >
     504    <column-mapping id="CMP158" populated="true" UUID="48766437-4478-46cf-95f9-b4c044570e88" fk-column-ref="COL106" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL99" />
     505   </relationship>
     506   <relationship id="REL159" populated="true" UUID="d28037cc-09ca-4aa1-bc09-fd42ae6c4d93" deferrability="7" deleteRule="3" fk-table-ref="TAB104" fkCardinality="7" identifying="false" name="mimetype_galeriaitem_fk" physicalName="mimetype_galeriaitem_fk" pk-table-ref="TAB113" pkCardinality="2" updateRule="3" >
     507    <column-mapping id="CMP160" populated="true" UUID="4de8c97e-2a80-4157-afd2-a6d13d94adab" fk-column-ref="COL109" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL114" />
     508   </relationship>
     509   <relationship id="REL161" populated="true" UUID="7bb8c66d-bdc0-4733-8c29-aa01132c7fc4" deferrability="7" deleteRule="3" fk-table-ref="TAB104" fkCardinality="7" identifying="false" name="galeriatipoitem_galeriaitem_fk" physicalName="galeriatipoitem_galeriaitem_fk" pk-table-ref="TAB121" pkCardinality="2" updateRule="3" >
     510    <column-mapping id="CMP162" populated="true" UUID="4f12d114-be9b-4963-aeaf-fdd71861060d" fk-column-ref="COL110" name="Column Mapping" physicalName="Column Mapping" pk-column-ref="COL122" />
    502511   </relationship>
    503512  </relationships>
    504513 </target-database>
    505  <ddl-generator type="ca.sqlpower.architect.ddl.PostgresDDLGenerator" allow-connection="false" target-schema="public"> </ddl-generator>
     514 <ddl-generator type="ca.sqlpower.architect.ddl.PostgresDDLGenerator" allow-connection="true" target-schema="public"> </ddl-generator>
    506515 <liquibase-settings useSeparateChangeSets="false" generateId="false" idStart="1"/>
    507516 <compare-dm-settings  ddlGenerator="ca.sqlpower.architect.ddl.PostgresDDLGenerator"  outputFormatAsString="SQL"  saveFlag="true" >
     
    517526  <table-pane table-ref="TAB30" x="178" y="88" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
    518527  <table-pane table-ref="TAB39" x="31" y="211" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
    519   <table-pane table-ref="TAB51" x="57" y="389" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
    520   <table-pane table-ref="TAB58" x="610" y="211" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
    521   <table-pane table-ref="TAB66" x="756" y="74" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
    522   <table-pane table-ref="TAB74" x="85" y="865" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
    523   <table-pane table-ref="TAB82" x="82" y="723" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
    524   <table-pane table-ref="TAB88" x="655" y="451" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
    525   <table-pane table-ref="TAB95" x="704" y="600" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
    526   <table-pane table-ref="TAB101" x="725" y="751" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
    527   <table-pane table-ref="TAB110" x="434" y="842" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
    528   <table-pane table-ref="TAB118" x="659" y="980" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
    529   <table-link relationship-ref="REL126" pkConnection="0.6484848484848484" fkConnection="0.7872340425531915" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
    530   <table-link relationship-ref="REL128" pkConnection="0.1696969696969697" fkConnection="0.35638297872340424" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
    531   <table-link relationship-ref="REL140" pkConnection="0.5789473684210527" fkConnection="0.22404371584699453" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="129"/>
    532   <table-link relationship-ref="REL142" pkConnection="0.5789473684210527" fkConnection="0.3700787401574803" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="130"/>
    533   <table-link relationship-ref="REL130" pkConnection="0.6666666666666666" fkConnection="0.32323232323232326" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="18"/>
    534   <table-link relationship-ref="REL144" pkConnection="0.4576923076923077" fkConnection="0.44324324324324327" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
    535   <table-link relationship-ref="REL132" pkConnection="0.6010928961748634" fkConnection="0.5959595959595959" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="40"/>
    536   <table-link relationship-ref="REL146" pkConnection="0.647887323943662" fkConnection="0.3072289156626506" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="130"/>
    537   <table-link relationship-ref="REL148" pkConnection="0.7078651685393258" fkConnection="0.5" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="72"/>
    538   <table-link relationship-ref="REL136" pkConnection="0.36363636363636365" fkConnection="0.32608695652173914" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
    539   <table-link relationship-ref="REL134" pkConnection="0.6666666666666666" fkConnection="0.2875816993464052" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="129"/>
    540   <table-link relationship-ref="REL150" pkConnection="0.15048543689320387" fkConnection="0.43859649122807015" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="36"/>
    541   <table-link relationship-ref="REL152" pkConnection="0.46601941747572817" fkConnection="0.603448275862069" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="72"/>
    542   <table-link relationship-ref="REL154" pkConnection="0.41262135922330095" fkConnection="0.34782608695652173" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
    543   <table-link relationship-ref="REL156" pkConnection="0.5818181818181818" fkConnection="0.43529411764705883" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="40"/>
    544   <table-link relationship-ref="REL158" pkConnection="0.5" fkConnection="0.4945652173913043" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="72"/>
    545   <table-link relationship-ref="REL138" pkConnection="0.6338028169014085" fkConnection="0.696969696969697" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="33"/>
     528  <table-pane table-ref="TAB53" x="56" y="426" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
     529  <table-pane table-ref="TAB61" x="610" y="211" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
     530  <table-pane table-ref="TAB69" x="756" y="74" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
     531  <table-pane table-ref="TAB77" x="85" y="865" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
     532  <table-pane table-ref="TAB85" x="82" y="723" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
     533  <table-pane table-ref="TAB91" x="655" y="451" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
     534  <table-pane table-ref="TAB98" x="704" y="600" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
     535  <table-pane table-ref="TAB104" x="725" y="751" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
     536  <table-pane table-ref="TAB113" x="434" y="842" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
     537  <table-pane table-ref="TAB121" x="659" y="980" bgColor="0xeeeeee" fgColor="0x000000" rounded="false" dashed="false"/>
     538  <table-link relationship-ref="REL129" pkConnection="0.6484848484848484" fkConnection="0.7872340425531915" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
     539  <table-link relationship-ref="REL131" pkConnection="0.1696969696969697" fkConnection="0.35638297872340424" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
     540  <table-link relationship-ref="REL143" pkConnection="0.5789473684210527" fkConnection="0.22404371584699453" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="129"/>
     541  <table-link relationship-ref="REL145" pkConnection="0.5789473684210527" fkConnection="0.3700787401574803" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="130"/>
     542  <table-link relationship-ref="REL133" pkConnection="0.5614035087719298" fkConnection="0.32323232323232326" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="18"/>
     543  <table-link relationship-ref="REL147" pkConnection="0.4576923076923077" fkConnection="0.44324324324324327" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
     544  <table-link relationship-ref="REL135" pkConnection="0.6010928961748634" fkConnection="0.5959595959595959" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="40"/>
     545  <table-link relationship-ref="REL149" pkConnection="0.647887323943662" fkConnection="0.3072289156626506" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="130"/>
     546  <table-link relationship-ref="REL151" pkConnection="0.6516393442622951" fkConnection="0.5" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="72"/>
     547  <table-link relationship-ref="REL139" pkConnection="0.36363636363636365" fkConnection="0.32608695652173914" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
     548  <table-link relationship-ref="REL137" pkConnection="0.6666666666666666" fkConnection="0.2875816993464052" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="129"/>
     549  <table-link relationship-ref="REL153" pkConnection="0.15048543689320387" fkConnection="0.43859649122807015" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="36"/>
     550  <table-link relationship-ref="REL155" pkConnection="0.46601941747572817" fkConnection="0.603448275862069" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="72"/>
     551  <table-link relationship-ref="REL157" pkConnection="0.41262135922330095" fkConnection="0.34782608695652173" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="132"/>
     552  <table-link relationship-ref="REL159" pkConnection="0.5818181818181818" fkConnection="0.43529411764705883" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="40"/>
     553  <table-link relationship-ref="REL161" pkConnection="0.5" fkConnection="0.4945652173913043" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="72"/>
     554  <table-link relationship-ref="REL141" pkConnection="0.6338028169014085" fkConnection="0.696969696969697" rLineColor="0x000000" pkLabelText="" fkLabelText="" orientation="33"/>
    546555 </play-pen>
    547556 <critic-manager>
  • Legisbook/trunk/docs/db/sqls/varios.sql

    r6437 r6443  
    2525        AND cav2.classeatributovertice_codinome_ch = 'PK'
    2626
     27-- para listar todos os atributos do vertice
     28SELECT
     29        av1.vertice_id_in AS vertice_id,
     30        av1.atributovertice_valor_ch AS nome_atributo,
     31        av2.atributovertice_valor_ch AS PK
     32FROM
     33        atributovertice AS av1,
     34        atributovertice AS av2,
     35        classeatributovertice AS cav1,
     36        classeatributovertice AS cav2
     37WHERE
     38        av1.vertice_id_in = av2.vertice_id_in
     39        AND av1.classeatributovertice_id_in = cav1.classeatributovertice_id_in
     40        AND cav1.classeatributovertice_codinome_ch = 'NOME'
     41        AND av2.classeatributovertice_id_in = cav2.classeatributovertice_id_in
     42        AND cav2.classeatributovertice_codinome_ch = 'PK'
     43
     44
    2745-- para pegar o ID do vertice de determinado TIPO a partir de determinado atributo=valor
    2846-- basta um dos parametros para obter resultado correto porem mais abrangente
     47-- pode-se utilizar LIKE para av.atributovertice_valor_ch
    2948SELECT
    3049        v.vertice_id_in
     
    4968
    5069-- Para sumarizar os tipos e quantidades de arestas:
    51 
    5270WITH r AS (
    5371        SELECT
     
    7795                a.vertice_idorigem_in = 5000
    7896
    79 -- tipos de vertices destino por vertice de origem
    8097-- tipos de vertices destino por vertice de origem
    8198
  • Legisbook/trunk/legisbookpycore/src/legisbookpycore/__init__.py

    r6437 r6443  
    7474        return( self.getLB( ).getCursor( ).fetchone( ) )
    7575   
    76     def create( self, VerticeTypeID, Codename, Description, qtdminima, qtdmaxima ):
     76    def create( self, VerticeTypeID, Codename, Description, qtdminima, qtdmaxima, publicavel, order ):
    7777        cav = self.getByCodename( VerticeTypeID, Codename )
    7878        if cav != None:
     
    8585            "        classeatributovertice_desc_ch, " \
    8686            "        classeatributovertice_qtdminima_in, " \
    87             "        classeatributovertice_qtdmaxima_in " \
     87            "        classeatributovertice_qtdmaxima_in, " \
     88            "        classeatributovertice_qtdmaxima_in, " \
     89            "" \
    8890            "    ) " \
    8991            "VALUES " \
     
    185187        return( self.getLB( ).getCursor( ).fetchall( ) )
    186188
    187     def create( self, VerticeID, AttributeCodename, AttributeValue ):
     189    def create( self, VerticeID, AttributeCodename, AttributeValue, group ):
    188190        # first: get the verticeattributeclass ID (need the vertice type before)
    189191        v = Vertice( self.getLB( ) )
     
    196198            "        vertice_id_in, " \
    197199            "        classeatributovertice_id_in, " \
    198             "        atributovertice_valor_ch " \
    199             "    ) " \
    200             "VALUES " \
    201             "    (%s, %s, %s)", ( VerticeID, attr[ 0 ], AttributeValue ) )
     200            "        atributovertice_valor_ch, " \
     201            "        atributovertice_group_in " \
     202            "    ) " \
     203            "VALUES " \
     204            "    (%s, %s, %s, %s)", ( VerticeID, attr[ 0 ], AttributeValue, group ) )
    202205
    203206    def setValue( self, VerticeAttributeID, AttributeValue ):
Note: Veja TracChangeset para ajuda no uso do visualizador de conjunto de mudanças.
 

The contents and data of this website are published under license:
Creative Commons 4.0 Brasil - Atribuir Fonte - Compartilhar Igual.