<?xml version="1.0" encoding="utf-8"?>
<Database Name="Database" Class="DataClassesDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
  <Connection Mode="WebSettings" ConnectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True" SettingsObjectName="System.Configuration.ConfigurationManager.ConnectionStrings" SettingsPropertyName="DatabaseConnectionString" Provider="System.Data.SqlClient" />
  <Table Name="dbo.ADENDA" Member="ADENDAs">
    <Type Name="ADENDA">
      <Column Name="ID_ADENDA" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="ID_PROCESSO" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="ID_UTILIZADOR" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="TITULO" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="OBSERVACOES" Type="System.String" DbType="VarChar(2000) NOT NULL" CanBeNull="false" />
      <Column Name="ULTIMA_ACTUALIZACAO" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Association Name="UTILIZADOR_ADENDA" Member="UTILIZADOR" ThisKey="ID_UTILIZADOR" Type="UTILIZADOR" IsForeignKey="true" />
      <Association Name="PROCESSO_ADENDA" Member="PROCESSO" ThisKey="ID_PROCESSO" Type="PROCESSO" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.UTILIZADOR" Member="UTILIZADORs">
    <Type Name="UTILIZADOR">
      <Column Name="ID_UTILIZADOR" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="NOME" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="PASSWORD" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="CARGO" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
      <Column Name="NUMERO_TELEFONE" Type="System.String" DbType="VarChar(15)" CanBeNull="true" />
      <Column Name="NUMERO_TELEMOVEL" Type="System.String" DbType="VarChar(15)" CanBeNull="true" />
      <Column Name="EMAIL" Type="System.String" DbType="VarChar(40)" CanBeNull="true" />
      <Column Name="IS_ADMIN" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Association Name="UTILIZADOR_ADENDA" Member="ADENDAs" OtherKey="ID_UTILIZADOR" Type="ADENDA" />
      <Association Name="UTILIZADOR_DOCUMENTO" Member="DOCUMENTOs" OtherKey="ID_UTILIZADOR" Type="DOCUMENTO" />
      <Association Name="UTILIZADOR_IMAGEM" Member="IMAGEMs" OtherKey="ID_UTILIZADOR" Type="IMAGEM" />
      <Association Name="UTILIZADOR_PROCESSO" Member="PROCESSOs" OtherKey="ID_UTILIZADOR" Type="PROCESSO" />
      <Association Name="UTILIZADOR_SECCAO" Member="SECCAOs" OtherKey="ID_UTILIZADOR" Type="SECCAO" />
    </Type>
  </Table>
  <Table Name="dbo.CONTACTO" Member="CONTACTOs">
    <Type Name="CONTACTO">
      <Column Name="ID_CONTACTO" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="NOME" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="TIPO" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="MORADA" Type="System.String" DbType="VarChar(80)" CanBeNull="true" />
      <Column Name="NUMERO_TELEFONE_PRI" Type="System.String" DbType="VarChar(15)" CanBeNull="true" />
      <Column Name="NUMERO_TELEFONE_SEC" Type="System.String" DbType="VarChar(15)" CanBeNull="true" />
      <Column Name="NUMERO_FAX" Type="System.String" DbType="VarChar(15)" CanBeNull="true" />
      <Column Name="EMAIL" Type="System.String" DbType="VarChar(40)" CanBeNull="true" />
      <Column Name="OBSERVACOES" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
    </Type>
  </Table>
  <Table Name="dbo.DOCUMENTO" Member="DOCUMENTOs">
    <Type Name="DOCUMENTO">
      <Column Name="ID_DOCUMENTO" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="ID_UTILIZADOR" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="TITULO" Type="System.String" DbType="VarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="NOME_FICHEIRO" Type="System.String" DbType="VarChar(40) NOT NULL" CanBeNull="false" />
      <Column Name="DATA_ENTRADA" Type="System.String" DbType="VarChar(10) NOT NULL" CanBeNull="false" />
      <Column Name="DESCRICAO" Type="System.String" DbType="VarChar(500)" CanBeNull="true" />
      <Association Name="UTILIZADOR_DOCUMENTO" Member="UTILIZADOR" ThisKey="ID_UTILIZADOR" Type="UTILIZADOR" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.IMAGEM" Member="IMAGEMs">
    <Type Name="IMAGEM">
      <Column Name="ID_IMAGEM" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="ID_PROCESSO" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="ID_UTILIZADOR" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="NOME_FICHEIRO" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="LEGENDA" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="ORDEM" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="ULTIMA_ACTUALIZACAO" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Association Name="UTILIZADOR_IMAGEM" Member="UTILIZADOR" ThisKey="ID_UTILIZADOR" Type="UTILIZADOR" IsForeignKey="true" />
      <Association Name="PROCESSO_IMAGEM" Member="PROCESSO" ThisKey="ID_PROCESSO" Type="PROCESSO" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.PROCESSO" Member="PROCESSOs">
    <Type Name="PROCESSO">
      <Column Name="ID_PROCESSO" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="ID_UTILIZADOR" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="NUMERO_PROCESSO" Type="System.String" DbType="VarChar(20) NOT NULL" CanBeNull="false" />
      <Column Name="FICHEIRO_REQUERIMENTO" Type="System.String" DbType="VarChar(50)" CanBeNull="true" />
      <Column Name="DATA_ENTRADA" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Column Name="DATA_CONCLUSAO" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="DATA_FINALIZACAO" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
      <Column Name="IS_FINISHED" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
      <Column Name="OBSERVACOES" Type="System.String" DbType="VarChar(2000)" CanBeNull="true" />
      <Column Name="ULTIMA_ACTUALIZACAO" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Association Name="PROCESSO_ADENDA" Member="ADENDAs" OtherKey="ID_PROCESSO" Type="ADENDA" />
      <Association Name="PROCESSO_IMAGEM" Member="IMAGEMs" OtherKey="ID_PROCESSO" Type="IMAGEM" />
      <Association Name="PROCESSO_SECCAO" Member="SECCAOs" OtherKey="ID_PROCESSO" Type="SECCAO" />
      <Association Name="UTILIZADOR_PROCESSO" Member="UTILIZADOR" ThisKey="ID_UTILIZADOR" Type="UTILIZADOR" IsForeignKey="true" />
    </Type>
  </Table>
  <Table Name="dbo.SECCAO" Member="SECCAOs">
    <Type Name="SECCAO">
      <Column Name="ID_SECCAO" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
      <Column Name="ID_SECCAO_PAI" Type="System.Decimal" DbType="Decimal(18,0)" CanBeNull="true" />
      <Column Name="ID_PROCESSO" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="ID_UTILIZADOR" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="ORDEM" Type="System.Decimal" DbType="Decimal(18,0) NOT NULL" CanBeNull="false" />
      <Column Name="TITULO" Type="System.String" DbType="VarChar(50) NOT NULL" CanBeNull="false" />
      <Column Name="DESCRICAO" Type="System.String" DbType="VarChar(2000)" CanBeNull="true" />
      <Column Name="NOTAS" Type="System.String" DbType="VarChar(1000)" CanBeNull="true" />
      <Column Name="ULTIMA_ACTUALIZACAO" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
      <Association Name="SECCAO_SECCAO" Member="SECCAOs" OtherKey="ID_SECCAO_PAI" Type="SECCAO" />
      <Association Name="PROCESSO_SECCAO" Member="PROCESSO" ThisKey="ID_PROCESSO" Type="PROCESSO" IsForeignKey="true" />
      <Association Name="SECCAO_SECCAO" Member="SECCAO1" ThisKey="ID_SECCAO_PAI" Type="SECCAO" IsForeignKey="true" />
      <Association Name="UTILIZADOR_SECCAO" Member="UTILIZADOR" ThisKey="ID_UTILIZADOR" Type="UTILIZADOR" IsForeignKey="true" />
    </Type>
  </Table>
</Database>