Can't access related object (1 to * relationship)

15 posts, 1 answers
  1. Carlos
    Carlos avatar
    50 posts
    Member since:
    Feb 2011

    Posted 27 May 2011 Link to this post

    I'm using Telerik's ORM against an Oracle Database.

    I'm starting to program some Silverlight Views where I must relate several objects to anothers.

    I will let an example of what I need/or don't understand how to do/get:

    I have two Entities, one is Entidade, and the other is Titulo as defined in the attached file called EntidadeTituloRelashionship.png
    The definition of that relationship can be seen in the attached file EntidadeTituloRelashionshipConfig.png

    In my ORM Diagram I get my Entidade class, and his Property Titulo defined like shown in the attached file called Diagram_EntidadeClass_TituloProperty.png

    Supposedly, from my Silverlight application, In an Entidade object, I should be able to access the object Titulo instead of Titulo's ID Property.. right? Or not quite? Please check attached file named: Accessible Entidade Class Property's in Silverlight Application.png

    But I can't.. it isn't there.. and I need it. Can you please tell me how get it? What should I implement?

    PS: I can get the Titulo Object as an Entidade Property in the DomainContext... check attached file ClassEntidades_ObjectTitulo_as_Property.png

    Without this my development is stuck..

    Thanks for any help given.
  2. Nelson
    Nelson avatar
    62 posts
    Member since:
    Apr 2011

    Posted 30 May 2011 Link to this post

    Hi,

    I have the same problem and i´m very interested in the solution.
  3. DevCraft banner
  4. Carlos
    Carlos avatar
    50 posts
    Member since:
    Feb 2011

    Posted 31 May 2011 Link to this post

    Does anyone else have this problem? I wonder that so many people uses the ORM and no one has this problem... I'm stuck on this since Friday.

    Any help would be much appreciated.
  5. Carlos
    Carlos avatar
    50 posts
    Member since:
    Feb 2011

    Posted 01 Jun 2011 Link to this post

    In the class definition, at the model where I can access the class related Objects, I've created some transient string proprieties and have given the values of the related objects in order to get them in the Silverlight side.. worked as a workarround.

    But now in the (* to * relationships I need to relate Lists of objects and the problem remains..)

    I've tried to tag the classes as Serializable.. but had no success..
    What it's the problem here? I can only access basic types? is that it? Or am I missing some tags in the Entity classes definitions?

    Someone please help. This is a fulcral point in order to read data from database. This is killing me!
  6. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 01 Jun 2011 Link to this post

    Hi Carlos,

     This is not exactly a problem but it is implemented by design in the RIA services themselves. In order to make the RIA generator generate your associations along with the other code you will need to add an additional attribute over your reference properties. Here is an example:

    public class Order
    {
        [Key]
        public int OrderID { get; set; }
     
        [Association("Order_OrderRows", "OrderID", "OrderID")]
        public IEnumerable<OrderRow> Rows { get; set; }
    }
     
     
    public class OrderRow
    {
        public int OrderID { get; set; }
     
        [Key]
        public int OrderRowID { get; set; }
     
        public string Name { get; set; }
    }

    Best wishes,
    Petar
    the Telerik team
    Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
  7. Carlos
    Carlos avatar
    50 posts
    Member since:
    Feb 2011

    Posted 01 Jun 2011 Link to this post

    *Edited: The code you posted is not relative to the model, right?



    Thanks for the answer. I was going to use the example you left, but I just couldn't adapt it to my case:

    Lets take in consideration 2 objects (entities): [FormasContacto] and [Entidades]

    - where an [Entidades] can have only one [FormasContacto];
    - where one [FormasContacto] can be used (referenced) in several [Entidades];

    Definition of [FormasContacto]
    namespace SGA.Web  
    {
        [Table("FORMAS_CONTACTO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class FormasContacto
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 50, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            
            private IList<Entidades> _entidades = new List<Entidades>();
            [Collection(InverseProperty = "FormasContactoProp")]
            [Storage("_entidades")]
            public virtual IList<Entidades> Entidades
            {
                get
                {
                    return this._entidades;
                }
            }
             
        }
    }

    Definition of [FormasContacto]
    namespace SGA.Web  
    {
        [Table("ENTIDADES")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        [Persistent]
        public partial class Entidades
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _tipoEntidadeId;
            [Column("TIPO_ENTIDADE_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_tipoEntidadeId")]
            public virtual long TipoEntidadeIdProp
            {
                get
                {
                    return this._tipoEntidadeId;
                }
                set
                {
                    this._tipoEntidadeId = value;
                }
            }
             
            private long _defaultFormaContactoId;
            [Column("DEFAULT_FORMA_CONTACTO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_defaultFormaContactoId")]
            public virtual long DefaultFormaContactoIdProp
            {
                get
                {
                    return this._defaultFormaContactoId;
                }
                set
                {
                    this._defaultFormaContactoId = value;
                }
            }
             
            private long _tituloId;
            [Column("TITULO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_tituloId")]
            public virtual long TituloIdProp
            {
                get
                {
                    return this._tituloId;
                }
                set
                {
                    this._tituloId = value;
                }
            }
             
            private string _nomeCompleto;
            [Column("NOME_COMPLETO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_nomeCompleto")]
            public virtual string NomeCompletoProp
            {
                get
                {
                    return this._nomeCompleto;
                }
                set
                {
                    this._nomeCompleto = value;
                }
            }
             
            private string _nomeTratamento;
            [Column("NOME_TRATAMENTO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_nomeTratamento")]
            public virtual string NomeTratamentoProp
            {
                get
                {
                    return this._nomeTratamento;
                }
                set
                {
                    this._nomeTratamento = value;
                }
            }
             
            private string _login;
            [Column("LOGIN", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_login")]
            public virtual string LoginProp
            {
                get
                {
                    return this._login;
                }
                set
                {
                    this._login = value;
                }
            }
             
            private string _password;
            [Column("PASSWORD", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 16, SqlType = "NVARCHAR2")]
            [Storage("_password")]
            public virtual string PasswordProp
            {
                get
                {
                    return this._password;
                }
                set
                {
                    this._password = value;
                }
            }
             
            private string _email;
            [Column("EMAIL", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 150, SqlType = "NVARCHAR2")]
            [Storage("_email")]
            public virtual string EmailProp
            {
                get
                {
                    return this._email;
                }
                set
                {
                    this._email = value;
                }
            }
             
            private string _telefone;
            [Column("TELEFONE", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 15, SqlType = "NVARCHAR2")]
            [Storage("_telefone")]
            public virtual string TelefoneProp
            {
                get
                {
                    return this._telefone;
                }
                set
                {
                    this._telefone = value;
                }
            }
             
            private string _telemovel;
            [Column("TELEMOVEL", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 15, SqlType = "NVARCHAR2")]
            [Storage("_telemovel")]
            public virtual string TelemovelProp
            {
                get
                {
                    return this._telemovel;
                }
                set
                {
                    this._telemovel = value;
                }
            }
             
            private string _fax;
            [Column("FAX", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 15, SqlType = "NVARCHAR2")]
            [Storage("_fax")]
            public virtual string FaxProp
            {
                get
                {
                    return this._fax;
                }
                set
                {
                    this._fax = value;
                }
            }
             
            private string _morada;
            [Column("MORADA", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_morada")]
            public virtual string MoradaProp
            {
                get
                {
                    return this._morada;
                }
                set
                {
                    this._morada = value;
                }
            }
             
            private short? _acesso;
            [Column("ACESSO", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 1, SqlType = "NUMBER")]
            [Storage("_acesso")]
            public virtual short? AcessoProp
            {
                get
                {
                    return this._acesso;
                }
                set
                {
                    this._acesso = value;
                }
            }
             
            private string _nrMecanografico;
            [Column("NR_MECANOGRAFICO", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 15, SqlType = "NVARCHAR2")]
            [Storage("_nrMecanografico")]
            public virtual string NrMecanograficoProp
            {
                get
                {
                    return this._nrMecanografico;
                }
                set
                {
                    this._nrMecanografico = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private FormasContacto _formasContacto;
            [ForeignKeyAssociation(ConstraintName = "E_FC_FK", SharedFields = "DefaultFormaContactoIdProp", TargetFields = "IdProp")]
            [Storage("_formasContacto")]
            public virtual FormasContacto FormasContactoProp
            {
                get
                {
                    return this._formasContacto;
                }
                set
                {
                    this._formasContacto = value;
                }
            }
        }
    }

    what would you do in this situation?
  8. Carlos
    Carlos avatar
    50 posts
    Member since:
    Feb 2011

    Posted 02 Jun 2011 Link to this post

    I mean, I don't know where to put the code you gave me.

    Should I create some metadata classes in the server project? Can you help me with my example (adapting), and where should I implement what is needed for this to work. At this point I'm stranded with my project :(

    Thanks in advance

    Edited*:

    I've created two metaclasses:

    [EntidadesMetadata]
    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.ComponentModel.DataAnnotations;
    using System.ServiceModel.DomainServices.Server;

    namespace SGA.Web
    {
        [MetadataTypeAttribute(typeof(Entidades.EntidadesMetadata))]
        public partial class Entidades
        {
            internal sealed class EntidadesMetadata
            {
                [Key]
                public long IdProp { get; set; }

                [Association("FormaContacto_Entidades", "DefaultFormaContactoIdProp", "IdProp")]
                public FormasContacto FormasContactoProp { get; set; }
            }
        }
    }

    and

    [FormasContactoMetadata]
    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.ComponentModel.DataAnnotations;
    using System.ServiceModel.DomainServices.Server;

    namespace SGA.Web
    {
        [MetadataTypeAttribute(typeof(FormasContacto.FormasContactoMetadata))]
        public partial class FormasContacto
        {
            internal sealed class FormasContactoMetadata
            {
                [Key]
                public long IdProp { get; set; }

                [Association("Entidades_FormaContacto", "IdProp", "DefaultFormaContactoIdProp")]
                public IList<Entidades> Entidades { get; set; }
            }
        }
    }

    but when I Load an [Entidades] or an [FormasContacto] the object FormasContactoProp in [Entidades] and the IList<Entidades> Entidades in [FormasContacto] are null...

    Am I very far of getting this done?
  9. Carlos
    Carlos avatar
    50 posts
    Member since:
    Feb 2011

    Posted 06 Jun 2011 Link to this post

    Hi again..
    I don't know what else to do. When I load the values on the server side, I can see the data when debugging, but on my Silverlight Application the related object is received as null.

    And now, what would I do?
  10. Carlos
    Carlos avatar
    50 posts
    Member since:
    Feb 2011

    Posted 07 Jun 2011 Link to this post

    I have this problem since 26th May, this is a major need for my project. I don't know what else to try. Oracle's Entity Framework is out and I really want to stick to telerik's ORM, but I won't be able to continue without further help from you in this topic.

    I don't know if the post is ignored or if you guys are trying to understand something.. can someone please give me a feedback.

    Thanks in advance
  11. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 07 Jun 2011 Link to this post

    Hi Carlos,

     Basically we employ the Eager loading approach so the collection should be populated the moment the its master is retrieved. Can you please share with me the complete code you are using? In addition if this those not work you can always fire a load query for the children as well. When they are retrieved they should correctly find their parent automatically.

    Greetings,
    Petar
    the Telerik team
    Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
  12. Carlos
    Carlos avatar
    50 posts
    Member since:
    Feb 2011

    Posted 08 Jun 2011 Link to this post

    (0) - Hi there, I can try to post all the info I find usefull for you. If you prefer I can send it to some e-mail.

    (1) - BTW I think I've managed to pull out what I needed. I've used the Tag [Include] along with [Association] definitions in the metadata classes. Still, I have some doubts.
    I'll post here an example of metadaclasses: [Entidades] and [FormasContacto] (you can check those classes model definition in the end of this post).


    [Entidades] Metadataclass
    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.ComponentModel.DataAnnotations;
    using System.ServiceModel.DomainServices.Server;
      
    namespace SGA.Web
    {
        [MetadataTypeAttribute(typeof(Entidades.EntidadesMetadata))]
        public partial class Entidades
        {
            internal sealed class EntidadesMetadata
            {
                [Key]
                public long IdProp { get; set; }
      
      
                //FORMAS DE CONTACTO
                [Association("FormaContacto_Entidade", "DefaultFormaContactoIdProp", "IdProp")]
                [Include]
                public FormasContacto FormasContactoProp { get; set; }
      
                //TITULOS
                [Association("Titulo_Entidade", "TituloIdProp", "IdProp")]
                [Include]
                public Titulos TitulosProp { get; set; }
      
                //TIPOS ENTIDADE
                [Association("TipoEntidade_Entidade", "TipoEntidadeIdProp", "IdProp")]
                [Include]
                public Titulos TiposEntidadeProp { get; set; }
      
                //yet to do
                [Association("EntidadesCargo_Entidade", "IdProp", "EntidadeIdProp")]
                [Include]
                public IList<Entidades> EntidadesCargos { get; set; }
      
            }
        }
    }



    [FormasContacto] Metadataclass
    using System;
    using System.Collections.Generic;
    using System.Linq;
    using System.Web;
    using System.ComponentModel.DataAnnotations;
    using System.ServiceModel.DomainServices.Server;
       
    namespace SGA.Web
    {
        [MetadataTypeAttribute(typeof(FormasContacto.FormasContactoMetadata))]
        public partial class FormasContacto
        {
            internal sealed class FormasContactoMetadata
            {
                [Key]
                public long IdProp { get; set; }
                   
                [Association("Entidades_FormaContacto", "IdProp", "DefaultFormaContactoIdProp")]
                [Include]
                public IList<Entidades> Entidades { get; set; }
            }
        }
    }

    Like this, I'm able to get that Entidades List from any [FormasContacto] object, and the FormasContactoProp on any [Entidades] object..

  13. Carlos
    Carlos avatar
    50 posts
    Member since:
    Feb 2011

    Posted 08 Jun 2011 Link to this post

    (2) - You have written: "addition if this those not work you can always fire a load query for the children as well. When they are retrieved they should correctly find their parent automatically." Well.. that turned me curious... how is that? In a single "one call too much" I could fill every objects relative to the parent objects in a List?

    (3) - The solution I describe in (1) allows me to work confortably with the 1-n relationships... but when n-n relationships, transform in two 1-n relationships with the help of one "join table". Is there a way to access direclty the [CARGOS] entities from [ENTIDADES]? Without having to access the entity that corresponds to the join table. Example bellow

    [ENTIDADES] - [CARGOS] ... n-n relationship
    [ENTIDADES] - [ENTIDADES_CARGOS] - [CARGOS]  2x 1-n relationships

    What would you do on their both metadaclasses in order to achieve what I'm looking for? can you use an aproach like I did in point (1)?

    My Full Entity Model (from the diagram)
    #pragma warning disable 1591
    //------------------------------------------------------------------------------
    // <auto-generated>
    //     This code was generated by a tool.
    //
    //     Changes to this file may cause incorrect behavior and will be lost if
    //     the code is regenerated.
    // </auto-generated>
    //------------------------------------------------------------------------------
    using System;
    using System.Data;
    using System.Linq;
    using System.Linq.Expressions;
    using System.Data.Common;
    using System.Collections.Generic;
    using Telerik.OpenAccess;
    using Telerik.OpenAccess.Metadata;
    using Telerik.OpenAccess.FetchOptimization;
     
     
    namespace SGA.Web  
    {  
        public partial class ModeloSGA : OpenAccessContext
        {
            private static string connectionStringName = @"ConexaoBDSGA";
                 
            private static BackendConfiguration backend = GetBackendConfiguration();
             
                 
            private static MetadataSource metadataSource = AttributesMetadataSource.FromContext(typeof(ModeloSGA));
         
            public ModeloSGA()
                :base(connectionStringName, backend, metadataSource)
            { }
             
            public ModeloSGA(string connection)
                :base(connection, backend, metadataSource)
            { }
         
            public ModeloSGA(BackendConfiguration backendConfiguration)
                :base(connectionStringName, backendConfiguration, metadataSource)
            { }
                 
            public ModeloSGA(string connection, MetadataSource metadataSource)
                :base(connection, backend, metadataSource)
            { }
             
            public ModeloSGA(string connection, BackendConfiguration backendConfiguration, MetadataSource metadataSource)
                :base(connection, backendConfiguration, metadataSource)
            { }
                 
            public IQueryable<VersaoBd> VersaoBds
            {
                get
                {
                    return this.GetAll<VersaoBd>();
                }
            }
             
            public IQueryable<UtilizadoresPerfis> UtilizadoresPerfis
            {
                get
                {
                    return this.GetAll<UtilizadoresPerfis>();
                }
            }
             
            public IQueryable<Titulos> Titulos
            {
                get
                {
                    return this.GetAll<Titulos>();
                }
            }
             
            public IQueryable<TiposReuniao> TiposReuniaos
            {
                get
                {
                    return this.GetAll<TiposReuniao>();
                }
            }
             
            public IQueryable<TiposNotificacao> TiposNotificacaos
            {
                get
                {
                    return this.GetAll<TiposNotificacao>();
                }
            }
             
            public IQueryable<TiposEntidade> TiposEntidades
            {
                get
                {
                    return this.GetAll<TiposEntidade>();
                }
            }
             
            public IQueryable<TiposDocumento> TiposDocumentos
            {
                get
                {
                    return this.GetAll<TiposDocumento>();
                }
            }
             
            public IQueryable<TemplatesNotificacoes> TemplatesNotificacoes
            {
                get
                {
                    return this.GetAll<TemplatesNotificacoes>();
                }
            }
             
            public IQueryable<Templates> Templates
            {
                get
                {
                    return this.GetAll<Templates>();
                }
            }
             
            public IQueryable<Reunioes> Reunioes
            {
                get
                {
                    return this.GetAll<Reunioes>();
                }
            }
             
            public IQueryable<ProgramasModulo> ProgramasModulos
            {
                get
                {
                    return this.GetAll<ProgramasModulo>();
                }
            }
             
            public IQueryable<Periodos> Periodos
            {
                get
                {
                    return this.GetAll<Periodos>();
                }
            }
             
            public IQueryable<Perfis> Perfis
            {
                get
                {
                    return this.GetAll<Perfis>();
                }
            }
             
            public IQueryable<ParticipantesReuniao> ParticipantesReuniaos
            {
                get
                {
                    return this.GetAll<ParticipantesReuniao>();
                }
            }
             
            public IQueryable<Organizacoes> Organizacoes
            {
                get
                {
                    return this.GetAll<Organizacoes>();
                }
            }
             
            public IQueryable<Notificacoes> Notificacoes
            {
                get
                {
                    return this.GetAll<Notificacoes>();
                }
            }
             
            public IQueryable<NotasReuniao> NotasReuniaos
            {
                get
                {
                    return this.GetAll<NotasReuniao>();
                }
            }
             
            public IQueryable<Modulos> Modulos
            {
                get
                {
                    return this.GetAll<Modulos>();
                }
            }
             
            public IQueryable<MensagensReuniao> MensagensReuniaos
            {
                get
                {
                    return this.GetAll<MensagensReuniao>();
                }
            }
             
            public IQueryable<Listas> Listas
            {
                get
                {
                    return this.GetAll<Listas>();
                }
            }
             
            public IQueryable<ItemsOrganizacao> ItemsOrganizacaos
            {
                get
                {
                    return this.GetAll<ItemsOrganizacao>();
                }
            }
             
            public IQueryable<GruposConvocadosEntidades> GruposConvocadosEntidades
            {
                get
                {
                    return this.GetAll<GruposConvocadosEntidades>();
                }
            }
             
            public IQueryable<GruposConvocados> GruposConvocados
            {
                get
                {
                    return this.GetAll<GruposConvocados>();
                }
            }
             
            public IQueryable<FuncoesReuniao> FuncoesReuniaos
            {
                get
                {
                    return this.GetAll<FuncoesReuniao>();
                }
            }
             
            public IQueryable<FuncoesPrograma> FuncoesProgramas
            {
                get
                {
                    return this.GetAll<FuncoesPrograma>();
                }
            }
             
            public IQueryable<FuncoesPerfil> FuncoesPerfils
            {
                get
                {
                    return this.GetAll<FuncoesPerfil>();
                }
            }
             
            public IQueryable<FormasContacto> FormasContactos
            {
                get
                {
                    return this.GetAll<FormasContacto>();
                }
            }
             
            public IQueryable<EstadosReuniao> EstadosReuniaos
            {
                get
                {
                    return this.GetAll<EstadosReuniao>();
                }
            }
             
            public IQueryable<EntidadesLista> EntidadesListas
            {
                get
                {
                    return this.GetAll<EntidadesLista>();
                }
            }
             
            public IQueryable<EntidadesCargo> EntidadesCargos
            {
                get
                {
                    return this.GetAll<EntidadesCargo>();
                }
            }
             
            public IQueryable<Entidades> Entidades
            {
                get
                {
                    return this.GetAll<Entidades>();
                }
            }
             
            public IQueryable<DocumentosReuniao> DocumentosReuniaos
            {
                get
                {
                    return this.GetAll<DocumentosReuniao>();
                }
            }
             
            public IQueryable<DocumentosBaseSga> DocumentosBaseSgas
            {
                get
                {
                    return this.GetAll<DocumentosBaseSga>();
                }
            }
             
            public IQueryable<ConfiguracaoUtilizador> ConfiguracaoUtilizadors
            {
                get
                {
                    return this.GetAll<ConfiguracaoUtilizador>();
                }
            }
             
            public IQueryable<ConfiguracaoAplicacao> ConfiguracaoAplicacaos
            {
                get
                {
                    return this.GetAll<ConfiguracaoAplicacao>();
                }
            }
             
            public IQueryable<Cargos> Cargos
            {
                get
                {
                    return this.GetAll<Cargos>();
                }
            }
             
            public IQueryable<BackupBd> BackupBds
            {
                get
                {
                    return this.GetAll<BackupBd>();
                }
            }
             
            public IQueryable<AnexosNotificacao> AnexosNotificacaos
            {
                get
                {
                    return this.GetAll<AnexosNotificacao>();
                }
            }
             
            public IQueryable<Anexos> Anexos
            {
                get
                {
                    return this.GetAll<Anexos>();
                }
            }
             
            public IQueryable<ActasVotacao> ActasVotacaos
            {
                get
                {
                    return this.GetAll<ActasVotacao>();
                }
            }
             
            public static BackendConfiguration GetBackendConfiguration()
            {
                BackendConfiguration backend = new BackendConfiguration();
                backend.Backend = "oracle";
                return backend;
            }
        }
    }
     
    namespace SGA.Web  
    {
        [Table("VERSAO_BD")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class VersaoBd
        {
            private short _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 4, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual short IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _responsavel;
            [Column("RESPONSAVEL", OpenAccessType = OpenAccessType.Varchar, Length = 100, SqlType = "NVARCHAR2")]
            [Storage("_responsavel")]
            public virtual string ResponsavelProp
            {
                get
                {
                    return this._responsavel;
                }
                set
                {
                    this._responsavel = value;
                }
            }
             
            private DateTime _data;
            [Column("DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_data")]
            public virtual DateTime DataProp
            {
                get
                {
                    return this._data;
                }
                set
                {
                    this._data = value;
                }
            }
             
            private string _obsVersao;
            [Column("OBS_VERSAO", OpenAccessType = OpenAccessType.Varchar, Length = 2000, SqlType = "NVARCHAR2")]
            [Storage("_obsVersao")]
            public virtual string ObsVersaoProp
            {
                get
                {
                    return this._obsVersao;
                }
                set
                {
                    this._obsVersao = value;
                }
            }
             
            private string _versaoMaxApl;
            [Column("VERSAO_MAX_APL", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 30, SqlType = "NVARCHAR2")]
            [Storage("_versaoMaxApl")]
            public virtual string VersaoMaxAplProp
            {
                get
                {
                    return this._versaoMaxApl;
                }
                set
                {
                    this._versaoMaxApl = value;
                }
            }
             
            private string _versaoMinApl;
            [Column("VERSAO_MIN_APL", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 30, SqlType = "NVARCHAR2")]
            [Storage("_versaoMinApl")]
            public virtual string VersaoMinAplProp
            {
                get
                {
                    return this._versaoMinApl;
                }
                set
                {
                    this._versaoMinApl = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("UTILIZADORES_PERFIS")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class UtilizadoresPerfis
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _entidadeId;
            [Column("ENTIDADE_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_entidadeId")]
            public virtual long EntidadeIdProp
            {
                get
                {
                    return this._entidadeId;
                }
                set
                {
                    this._entidadeId = value;
                }
            }
             
            private long _perfilId;
            [Column("PERFIL_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_perfilId")]
            public virtual long PerfilIdProp
            {
                get
                {
                    return this._perfilId;
                }
                set
                {
                    this._perfilId = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private Entidades _entidades;
            [ForeignKeyAssociation(ConstraintName = "UP_E_FK", SharedFields = "EntidadeIdProp", TargetFields = "IdProp")]
            [Storage("_entidades")]
            public virtual Entidades EntidadesProp
            {
                get
                {
                    return this._entidades;
                }
                set
                {
                    this._entidades = value;
                }
            }
             
            private Perfis _perfis;
            [ForeignKeyAssociation(ConstraintName = "UP_P_FK", SharedFields = "PerfilIdProp", TargetFields = "IdProp")]
            [Storage("_perfis")]
            public virtual Perfis PerfisProp
            {
                get
                {
                    return this._perfis;
                }
                set
                {
                    this._perfis = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("TITULOS")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class Titulos
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private string _abreviatura;
            [Column("ABREVIATURA", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 20, SqlType = "NVARCHAR2")]
            [Storage("_abreviatura")]
            public virtual string AbreviaturaProp
            {
                get
                {
                    return this._abreviatura;
                }
                set
                {
                    this._abreviatura = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<Entidades> _entidades = new List<Entidades>();
            [Collection(InverseProperty = "TitulosProp")]
            [Storage("_entidades")]
            public virtual IList<Entidades> Entidades
            {
                get
                {
                    return this._entidades;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("TIPOS_REUNIAO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class TiposReuniao
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 100, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<Reunioes> _reunioes = new List<Reunioes>();
            [Collection(InverseProperty = "TiposreuniaoProp")]
            [Storage("_reunioes")]
            public virtual IList<Reunioes> Reunioes
            {
                get
                {
                    return this._reunioes;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("TIPOS_NOTIFICACAO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class TiposNotificacao
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private string _observacoes;
            [Column("OBSERVACOES", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 500, SqlType = "NVARCHAR2")]
            [Storage("_observacoes")]
            public virtual string ObservacoesProp
            {
                get
                {
                    return this._observacoes;
                }
                set
                {
                    this._observacoes = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<TemplatesNotificacoes> _templatesNotificacoes = new List<TemplatesNotificacoes>();
            [Collection(InverseProperty = "TiposnotificacaoProp")]
            [Storage("_templatesNotificacoes")]
            public virtual IList<TemplatesNotificacoes> TemplatesNotificacoes
            {
                get
                {
                    return this._templatesNotificacoes;
                }
            }
             
            private IList<Notificacoes> _notificacoes = new List<Notificacoes>();
            [Collection(InverseProperty = "TiposnotificacaoProp")]
            [Storage("_notificacoes")]
            public virtual IList<Notificacoes> Notificacoes
            {
                get
                {
                    return this._notificacoes;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("TIPOS_ENTIDADE")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class TiposEntidade
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 100, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short? _singular;
            [Column("SINGULAR", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 1, SqlType = "NUMBER")]
            [Storage("_singular")]
            public virtual short? SingularProp
            {
                get
                {
                    return this._singular;
                }
                set
                {
                    this._singular = value;
                }
            }
             
            private short? _colectivo;
            [Column("COLECTIVO", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 1, SqlType = "NUMBER")]
            [Storage("_colectivo")]
            public virtual short? ColectivoProp
            {
                get
                {
                    return this._colectivo;
                }
                set
                {
                    this._colectivo = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<Entidades> _entidades = new List<Entidades>();
            [Collection(InverseProperty = "TiposentidadeProp")]
            [Storage("_entidades")]
            public virtual IList<Entidades> Entidades
            {
                get
                {
                    return this._entidades;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("TIPOS_DOCUMENTO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class TiposDocumento
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "VARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private string _extensaoFisica;
            [Column("EXTENSAO_FISICA", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 200, SqlType = "VARCHAR2")]
            [Storage("_extensaoFisica")]
            public virtual string ExtensaoFisicaProp
            {
                get
                {
                    return this._extensaoFisica;
                }
                set
                {
                    this._extensaoFisica = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "VARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "VARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<Templates> _templates = new List<Templates>();
            [Collection(InverseProperty = "TiposdocumentoProp")]
            [Storage("_templates")]
            public virtual IList<Templates> Templates
            {
                get
                {
                    return this._templates;
                }
            }
             
            private IList<DocumentosReuniao> _documentosReuniaos = new List<DocumentosReuniao>();
            [Collection(InverseProperty = "TiposdocumentoProp")]
            [Storage("_documentosReuniaos")]
            public virtual IList<DocumentosReuniao> DocumentosReuniaos
            {
                get
                {
                    return this._documentosReuniaos;
                }
            }
             
            private IList<Anexos> _anexos = new List<Anexos>();
            [Collection(InverseProperty = "TiposdocumentoProp")]
            [Storage("_anexos")]
            public virtual IList<Anexos> Anexos
            {
                get
                {
                    return this._anexos;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("TEMPLATES_NOTIFICACOES")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class TemplatesNotificacoes
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long? _tipoNotificacaoId;
            [Column("TIPO_NOTIFICACAO_ID", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_tipoNotificacaoId")]
            public virtual long? TipoNotificacaoIdProp
            {
                get
                {
                    return this._tipoNotificacaoId;
                }
                set
                {
                    this._tipoNotificacaoId = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private string _conteudo;
            [Column("CONTEUDO", OpenAccessType = OpenAccessType.Clob, IsNullable = true, SqlType = "CLOB")]
            [Storage("_conteudo")]
            public virtual string ConteudoProp
            {
                get
                {
                    return this._conteudo;
                }
                set
                {
                    this._conteudo = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private TiposNotificacao _tiposnotificacao;
            [ForeignKeyAssociation(ConstraintName = "TMPLTN_TN_FK", SharedFields = "TipoNotificacaoIdProp", TargetFields = "IdProp")]
            [Storage("_tiposnotificacao")]
            public virtual TiposNotificacao TiposnotificacaoProp
            {
                get
                {
                    return this._tiposnotificacao;
                }
                set
                {
                    this._tiposnotificacao = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("TEMPLATES")]
        public partial class Templates
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _tipoDocumentoId;
            [Column("TIPO_DOCUMENTO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_tipoDocumentoId")]
            public virtual long TipoDocumentoIdProp
            {
                get
                {
                    return this._tipoDocumentoId;
                }
                set
                {
                    this._tipoDocumentoId = value;
                }
            }
             
            private short? _periodosId;
            [Column("PERIODOS_ID", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 2, SqlType = "NUMBER")]
            [Storage("_periodosId")]
            public virtual short? PeriodosIdProp
            {
                get
                {
                    return this._periodosId;
                }
                set
                {
                    this._periodosId = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short _ficheiro;
            [Column("FICHEIRO", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_ficheiro")]
            public virtual short FicheiroProp
            {
                get
                {
                    return this._ficheiro;
                }
                set
                {
                    this._ficheiro = value;
                }
            }
             
            private string _urlFicheiro;
            [Column("URL_FICHEIRO", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 1000, SqlType = "NVARCHAR2")]
            [Storage("_urlFicheiro")]
            public virtual string UrlFicheiroProp
            {
                get
                {
                    return this._urlFicheiro;
                }
                set
                {
                    this._urlFicheiro = value;
                }
            }
             
            private byte[] _conteudo;
            [Column("CONTEUDO", OpenAccessType = OpenAccessType.Blob, IsNullable = true, SqlType = "BLOB")]
            [Storage("_conteudo")]
            public virtual byte[] ConteudoProp
            {
                get
                {
                    return this._conteudo;
                }
                set
                {
                    this._conteudo = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private Periodos _periodos;
            [ForeignKeyAssociation(ConstraintName = "T_PRDS_FK", SharedFields = "PeriodosIdProp", TargetFields = "IdProp")]
            [Storage("_periodos")]
            public virtual Periodos PeriodosProp
            {
                get
                {
                    return this._periodos;
                }
                set
                {
                    this._periodos = value;
                }
            }
             
            private TiposDocumento _tiposdocumento;
            [ForeignKeyAssociation(ConstraintName = "T_TD_FK", SharedFields = "TipoDocumentoIdProp", TargetFields = "IdProp")]
            [Storage("_tiposdocumento")]
            public virtual TiposDocumento TiposdocumentoProp
            {
                get
                {
                    return this._tiposdocumento;
                }
                set
                {
                    this._tiposdocumento = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("REUNIOES")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class Reunioes
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _organizacaoId;
            [Column("ORGANIZACAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_organizacaoId")]
            public virtual long OrganizacaoIdProp
            {
                get
                {
                    return this._organizacaoId;
                }
                set
                {
                    this._organizacaoId = value;
                }
            }
             
            private long _tipoReuniaoId;
            [Column("TIPO_REUNIAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_tipoReuniaoId")]
            public virtual long TipoReuniaoIdProp
            {
                get
                {
                    return this._tipoReuniaoId;
                }
                set
                {
                    this._tipoReuniaoId = value;
                }
            }
             
            private long _estadoReuniaoId;
            [Column("ESTADO_REUNIAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_estadoReuniaoId")]
            public virtual long EstadoReuniaoIdProp
            {
                get
                {
                    return this._estadoReuniaoId;
                }
                set
                {
                    this._estadoReuniaoId = value;
                }
            }
             
            private short _ano;
            [Column("ANO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_ano")]
            public virtual short AnoProp
            {
                get
                {
                    return this._ano;
                }
                set
                {
                    this._ano = value;
                }
            }
             
            private short _numero;
            [Column("NUMERO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_numero")]
            public virtual short NumeroProp
            {
                get
                {
                    return this._numero;
                }
                set
                {
                    this._numero = value;
                }
            }
             
            private string _localReuniao;
            [Column("LOCAL_REUNIAO", OpenAccessType = OpenAccessType.Varchar, Length = 400, SqlType = "NVARCHAR2")]
            [Storage("_localReuniao")]
            public virtual string LocalReuniaoProp
            {
                get
                {
                    return this._localReuniao;
                }
                set
                {
                    this._localReuniao = value;
                }
            }
             
            private DateTime _dataHoraPrevistaInicio;
            [Column("DATA_HORA_PREVISTA_INICIO", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_dataHoraPrevistaInicio")]
            public virtual DateTime DataHoraPrevistaInicioProp
            {
                get
                {
                    return this._dataHoraPrevistaInicio;
                }
                set
                {
                    this._dataHoraPrevistaInicio = value;
                }
            }
             
            private DateTime? _dataHoraInicio;
            [Column("DATA_HORA_INICIO", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_dataHoraInicio")]
            public virtual DateTime? DataHoraInicioProp
            {
                get
                {
                    return this._dataHoraInicio;
                }
                set
                {
                    this._dataHoraInicio = value;
                }
            }
             
            private short? _duracaoPrevista;
            [Column("DURACAO_PREVISTA", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 4, SqlType = "NUMBER")]
            [Storage("_duracaoPrevista")]
            public virtual short? DuracaoPrevistaProp
            {
                get
                {
                    return this._duracaoPrevista;
                }
                set
                {
                    this._duracaoPrevista = value;
                }
            }
             
            private short? _duracao;
            [Column("DURACAO", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 4, SqlType = "NUMBER")]
            [Storage("_duracao")]
            public virtual short? DuracaoProp
            {
                get
                {
                    return this._duracao;
                }
                set
                {
                    this._duracao = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private EstadosReuniao _estadosreuniao;
            [ForeignKeyAssociation(ConstraintName = "R_ER_FK", SharedFields = "EstadoReuniaoIdProp", TargetFields = "IdProp")]
            [Storage("_estadosreuniao")]
            public virtual EstadosReuniao EstadosreuniaoProp
            {
                get
                {
                    return this._estadosreuniao;
                }
                set
                {
                    this._estadosreuniao = value;
                }
            }
             
            private Organizacoes _organizacoes;
            [ForeignKeyAssociation(ConstraintName = "R_O_FK", SharedFields = "OrganizacaoIdProp", TargetFields = "IdProp")]
            [Storage("_organizacoes")]
            public virtual Organizacoes OrganizacoesProp
            {
                get
                {
                    return this._organizacoes;
                }
                set
                {
                    this._organizacoes = value;
                }
            }
             
            private TiposReuniao _tiposreuniao;
            [ForeignKeyAssociation(ConstraintName = "R_TR_FK", SharedFields = "TipoReuniaoIdProp", TargetFields = "IdProp")]
            [Storage("_tiposreuniao")]
            public virtual TiposReuniao TiposreuniaoProp
            {
                get
                {
                    return this._tiposreuniao;
                }
                set
                {
                    this._tiposreuniao = value;
                }
            }
             
            private IList<ParticipantesReuniao> _participantesReuniaos = new List<ParticipantesReuniao>();
            [Collection(InverseProperty = "ReunioesProp")]
            [Storage("_participantesReuniaos")]
            public virtual IList<ParticipantesReuniao> ParticipantesReuniaos
            {
                get
                {
                    return this._participantesReuniaos;
                }
            }
             
            private IList<DocumentosReuniao> _documentosReuniaos = new List<DocumentosReuniao>();
            [Collection(InverseProperty = "ReunioesProp")]
            [Storage("_documentosReuniaos")]
            public virtual IList<DocumentosReuniao> DocumentosReuniaos
            {
                get
                {
                    return this._documentosReuniaos;
                }
            }
             
            private IList<Anexos> _anexos = new List<Anexos>();
            [Collection(InverseProperty = "ReunioesProp")]
            [Storage("_anexos")]
            public virtual IList<Anexos> Anexos
            {
                get
                {
                    return this._anexos;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("PROGRAMAS_MODULO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class ProgramasModulo
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _moduloId;
            [Column("MODULO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_moduloId")]
            public virtual long ModuloIdProp
            {
                get
                {
                    return this._moduloId;
                }
                set
                {
                    this._moduloId = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private string _nomeFisico;
            [Column("NOME_FISICO", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 100, SqlType = "NVARCHAR2")]
            [Storage("_nomeFisico")]
            public virtual string NomeFisicoProp
            {
                get
                {
                    return this._nomeFisico;
                }
                set
                {
                    this._nomeFisico = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private Modulos _modulos;
            [ForeignKeyAssociation(ConstraintName = "PM_M_FK", SharedFields = "ModuloIdProp", TargetFields = "IdProp")]
            [Storage("_modulos")]
            public virtual Modulos ModulosProp
            {
                get
                {
                    return this._modulos;
                }
                set
                {
                    this._modulos = value;
                }
            }
             
            private IList<FuncoesPrograma> _funcoesProgramas = new List<FuncoesPrograma>();
            [Collection(InverseProperty = "ProgramasmoduloProp")]
            [Storage("_funcoesProgramas")]
            public virtual IList<FuncoesPrograma> FuncoesProgramas
            {
                get
                {
                    return this._funcoesProgramas;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("PERIODOS")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class Periodos
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<Templates> _templates = new List<Templates>();
            [Collection(InverseProperty = "PeriodosProp")]
            [Storage("_templates")]
            public virtual IList<Templates> Templates
            {
                get
                {
                    return this._templates;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("PERFIS")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class Perfis
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<UtilizadoresPerfis> _utilizadoresPerfis = new List<UtilizadoresPerfis>();
            [Collection(InverseProperty = "PerfisProp")]
            [Storage("_utilizadoresPerfis")]
            public virtual IList<UtilizadoresPerfis> UtilizadoresPerfis
            {
                get
                {
                    return this._utilizadoresPerfis;
                }
            }
             
            private IList<FuncoesPerfil> _funcoesPerfils = new List<FuncoesPerfil>();
            [Collection(InverseProperty = "PerfisProp")]
            [Storage("_funcoesPerfils")]
            public virtual IList<FuncoesPerfil> FuncoesPerfils
            {
                get
                {
                    return this._funcoesPerfils;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("PARTICIPANTES_REUNIAO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class ParticipantesReuniao
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _entidadeId;
            [Column("ENTIDADE_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_entidadeId")]
            public virtual long EntidadeIdProp
            {
                get
                {
                    return this._entidadeId;
                }
                set
                {
                    this._entidadeId = value;
                }
            }
             
            private long _reuniaoId;
            [Column("REUNIAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_reuniaoId")]
            public virtual long ReuniaoIdProp
            {
                get
                {
                    return this._reuniaoId;
                }
                set
                {
                    this._reuniaoId = value;
                }
            }
             
            private long _funcaoReuniaoId;
            [Column("FUNCAO_REUNIAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_funcaoReuniaoId")]
            public virtual long FuncaoReuniaoIdProp
            {
                get
                {
                    return this._funcaoReuniaoId;
                }
                set
                {
                    this._funcaoReuniaoId = value;
                }
            }
             
            private DateTime? _dataNotificacao;
            [Column("DATA_NOTIFICACAO", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_dataNotificacao")]
            public virtual DateTime? DataNotificacaoProp
            {
                get
                {
                    return this._dataNotificacao;
                }
                set
                {
                    this._dataNotificacao = value;
                }
            }
             
            private short? _confirmouRecepcao;
            [Column("CONFIRMOU_RECEPCAO", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 1, SqlType = "NUMBER")]
            [Storage("_confirmouRecepcao")]
            public virtual short? ConfirmouRecepcaoProp
            {
                get
                {
                    return this._confirmouRecepcao;
                }
                set
                {
                    this._confirmouRecepcao = value;
                }
            }
             
            private DateTime? _dataConfirmacaoRecepcao;
            [Column("DATA_CONFIRMACAO_RECEPCAO", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_dataConfirmacaoRecepcao")]
            public virtual DateTime? DataConfirmacaoRecepcaoProp
            {
                get
                {
                    return this._dataConfirmacaoRecepcao;
                }
                set
                {
                    this._dataConfirmacaoRecepcao = value;
                }
            }
             
            private short? _presencaPrevista;
            [Column("PRESENCA_PREVISTA", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 1, SqlType = "NUMBER")]
            [Storage("_presencaPrevista")]
            public virtual short? PresencaPrevistaProp
            {
                get
                {
                    return this._presencaPrevista;
                }
                set
                {
                    this._presencaPrevista = value;
                }
            }
             
            private short? _primeiraChamada;
            [Column("PRIMEIRA_CHAMADA", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 1, SqlType = "NUMBER")]
            [Storage("_primeiraChamada")]
            public virtual short? PrimeiraChamadaProp
            {
                get
                {
                    return this._primeiraChamada;
                }
                set
                {
                    this._primeiraChamada = value;
                }
            }
             
            private short? _segundaChamada;
            [Column("SEGUNDA_CHAMADA", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 1, SqlType = "NUMBER")]
            [Storage("_segundaChamada")]
            public virtual short? SegundaChamadaProp
            {
                get
                {
                    return this._segundaChamada;
                }
                set
                {
                    this._segundaChamada = value;
                }
            }
             
            private short? _terceiraChamada;
            [Column("TERCEIRA_CHAMADA", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 1, SqlType = "NUMBER")]
            [Storage("_terceiraChamada")]
            public virtual short? TerceiraChamadaProp
            {
                get
                {
                    return this._terceiraChamada;
                }
                set
                {
                    this._terceiraChamada = value;
                }
            }
             
            private short? _quartaChamada;
            [Column("QUARTA_CHAMADA", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 1, SqlType = "NUMBER")]
            [Storage("_quartaChamada")]
            public virtual short? QuartaChamadaProp
            {
                get
                {
                    return this._quartaChamada;
                }
                set
                {
                    this._quartaChamada = value;
                }
            }
             
            private string _justificacaoFalta;
            [Column("JUSTIFICACAO_FALTA", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 2000, SqlType = "NVARCHAR2")]
            [Storage("_justificacaoFalta")]
            public virtual string JustificacaoFaltaProp
            {
                get
                {
                    return this._justificacaoFalta;
                }
                set
                {
                    this._justificacaoFalta = value;
                }
            }
             
            private decimal? _valorPagar;
            [Column("VALOR_PAGAR", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 6, Scale = 2, SqlType = "NUMBER")]
            [Storage("_valorPagar")]
            public virtual decimal? ValorPagarProp
            {
                get
                {
                    return this._valorPagar;
                }
                set
                {
                    this._valorPagar = value;
                }
            }
             
            private decimal? _valorPago;
            [Column("VALOR_PAGO", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 6, Scale = 2, SqlType = "NUMBER")]
            [Storage("_valorPago")]
            public virtual decimal? ValorPagoProp
            {
                get
                {
                    return this._valorPago;
                }
                set
                {
                    this._valorPago = value;
                }
            }
             
            private DateTime? _dataPagamento;
            [Column("DATA_PAGAMENTO", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_dataPagamento")]
            public virtual DateTime? DataPagamentoProp
            {
                get
                {
                    return this._dataPagamento;
                }
                set
                {
                    this._dataPagamento = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private Entidades _entidades;
            [ForeignKeyAssociation(ConstraintName = "PR_E_FK", SharedFields = "EntidadeIdProp", TargetFields = "IdProp")]
            [Storage("_entidades")]
            public virtual Entidades EntidadesProp
            {
                get
                {
                    return this._entidades;
                }
                set
                {
                    this._entidades = value;
                }
            }
             
            private FuncoesReuniao _funcoesreuniao;
            [ForeignKeyAssociation(ConstraintName = "PR_FR_FK", SharedFields = "FuncaoReuniaoIdProp", TargetFields = "IdProp")]
            [Storage("_funcoesreuniao")]
            public virtual FuncoesReuniao FuncoesreuniaoProp
            {
                get
                {
                    return this._funcoesreuniao;
                }
                set
                {
                    this._funcoesreuniao = value;
                }
            }
             
            private Reunioes _reunioes;
            [ForeignKeyAssociation(ConstraintName = "PR_R_FK", SharedFields = "ReuniaoIdProp", TargetFields = "IdProp")]
            [Storage("_reunioes")]
            public virtual Reunioes ReunioesProp
            {
                get
                {
                    return this._reunioes;
                }
                set
                {
                    this._reunioes = value;
                }
            }
             
            private IList<Notificacoes> _notificacoes = new List<Notificacoes>();
            [Collection(InverseProperty = "ParticipantesreuniaoProp")]
            [Storage("_notificacoes")]
            public virtual IList<Notificacoes> Notificacoes
            {
                get
                {
                    return this._notificacoes;
                }
            }
             
            private IList<NotasReuniao> _notasReuniaos = new List<NotasReuniao>();
            [Collection(InverseProperty = "ParticipantesreuniaoProp")]
            [Storage("_notasReuniaos")]
            public virtual IList<NotasReuniao> NotasReuniaos
            {
                get
                {
                    return this._notasReuniaos;
                }
            }
             
            private IList<MensagensReuniao> _mensagensReuniaos = new List<MensagensReuniao>();
            [Collection(InverseProperty = "ParticipantesreuniaoProp")]
            [Storage("_mensagensReuniaos")]
            public virtual IList<MensagensReuniao> MensagensReuniaos
            {
                get
                {
                    return this._mensagensReuniaos;
                }
            }
             
            private IList<ActasVotacao> _actasVotacaos = new List<ActasVotacao>();
            [Collection(InverseProperty = "ParticipantesreuniaoProp")]
            [Storage("_actasVotacaos")]
            public virtual IList<ActasVotacao> ActasVotacaos
            {
                get
                {
                    return this._actasVotacaos;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("ORGANIZACOES")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class Organizacoes
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 100, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private string _observacoes;
            [Column("OBSERVACOES", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 2000, SqlType = "NVARCHAR2")]
            [Storage("_observacoes")]
            public virtual string ObservacoesProp
            {
                get
                {
                    return this._observacoes;
                }
                set
                {
                    this._observacoes = value;
                }
            }
             
            private string _local;
            [Column("LOCAL", OpenAccessType = OpenAccessType.Varchar, Length = 400, SqlType = "NVARCHAR2")]
            [Storage("_local")]
            public virtual string LocalProp
            {
                get
                {
                    return this._local;
                }
                set
                {
                    this._local = value;
                }
            }
             
            private int _numeracao;
            [Column("NUMERACAO", OpenAccessType = OpenAccessType.Decimal, Length = 5, SqlType = "NUMBER")]
            [Storage("_numeracao")]
            public virtual int NumeracaoProp
            {
                get
                {
                    return this._numeracao;
                }
                set
                {
                    this._numeracao = value;
                }
            }
             
            private short _anoCorrente;
            [Column("ANO_CORRENTE", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_anoCorrente")]
            public virtual short AnoCorrenteProp
            {
                get
                {
                    return this._anoCorrente;
                }
                set
                {
                    this._anoCorrente = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<Reunioes> _reunioes = new List<Reunioes>();
            [Collection(InverseProperty = "OrganizacoesProp")]
            [Storage("_reunioes")]
            public virtual IList<Reunioes> Reunioes
            {
                get
                {
                    return this._reunioes;
                }
            }
             
            private IList<ItemsOrganizacao> _itemsOrganizacaos = new List<ItemsOrganizacao>();
            [Collection(InverseProperty = "OrganizacoesProp")]
            [Storage("_itemsOrganizacaos")]
            public virtual IList<ItemsOrganizacao> ItemsOrganizacaos
            {
                get
                {
                    return this._itemsOrganizacaos;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("NOTIFICACOES")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class Notificacoes
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _participanteReuniaoId;
            [Column("PARTICIPANTE_REUNIAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_participanteReuniaoId")]
            public virtual long ParticipanteReuniaoIdProp
            {
                get
                {
                    return this._participanteReuniaoId;
                }
                set
                {
                    this._participanteReuniaoId = value;
                }
            }
             
            private long _formaContactoId;
            [Column("FORMA_CONTACTO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_formaContactoId")]
            public virtual long FormaContactoIdProp
            {
                get
                {
                    return this._formaContactoId;
                }
                set
                {
                    this._formaContactoId = value;
                }
            }
             
            private long _tipoNotificacaoId;
            [Column("TIPO_NOTIFICACAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_tipoNotificacaoId")]
            public virtual long TipoNotificacaoIdProp
            {
                get
                {
                    return this._tipoNotificacaoId;
                }
                set
                {
                    this._tipoNotificacaoId = value;
                }
            }
             
            private string _textoNotificacao;
            [Column("TEXTO_NOTIFICACAO", OpenAccessType = OpenAccessType.Clob, SqlType = "CLOB")]
            [Storage("_textoNotificacao")]
            public virtual string TextoNotificacaoProp
            {
                get
                {
                    return this._textoNotificacao;
                }
                set
                {
                    this._textoNotificacao = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private FormasContacto _formascontacto;
            [ForeignKeyAssociation(ConstraintName = "N_FC_FK", SharedFields = "FormaContactoIdProp", TargetFields = "IdProp")]
            [Storage("_formascontacto")]
            public virtual FormasContacto FormascontactoProp
            {
                get
                {
                    return this._formascontacto;
                }
                set
                {
                    this._formascontacto = value;
                }
            }
             
            private ParticipantesReuniao _participantesreuniao;
            [ForeignKeyAssociation(ConstraintName = "N_PR_FK", SharedFields = "ParticipanteReuniaoIdProp", TargetFields = "IdProp")]
            [Storage("_participantesreuniao")]
            public virtual ParticipantesReuniao ParticipantesreuniaoProp
            {
                get
                {
                    return this._participantesreuniao;
                }
                set
                {
                    this._participantesreuniao = value;
                }
            }
             
            private TiposNotificacao _tiposnotificacao;
            [ForeignKeyAssociation(ConstraintName = "N_TN_FK", SharedFields = "TipoNotificacaoIdProp", TargetFields = "IdProp")]
            [Storage("_tiposnotificacao")]
            public virtual TiposNotificacao TiposnotificacaoProp
            {
                get
                {
                    return this._tiposnotificacao;
                }
                set
                {
                    this._tiposnotificacao = value;
                }
            }
             
            private IList<AnexosNotificacao> _anexosNotificacaos = new List<AnexosNotificacao>();
            [Collection(InverseProperty = "NotificacoesProp")]
            [Storage("_anexosNotificacaos")]
            public virtual IList<AnexosNotificacao> AnexosNotificacaos
            {
                get
                {
                    return this._anexosNotificacaos;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("NOTAS_REUNIAO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class NotasReuniao
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _participanteReuniaoId;
            [Column("PARTICIPANTE_REUNIAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_participanteReuniaoId")]
            public virtual long ParticipanteReuniaoIdProp
            {
                get
                {
                    return this._participanteReuniaoId;
                }
                set
                {
                    this._participanteReuniaoId = value;
                }
            }
             
            private string _textoNota;
            [Column("TEXTO_NOTA", OpenAccessType = OpenAccessType.Clob, SqlType = "CLOB")]
            [Storage("_textoNota")]
            public virtual string TextoNotaProp
            {
                get
                {
                    return this._textoNota;
                }
                set
                {
                    this._textoNota = value;
                }
            }
             
            private long _notaVerificada;
            [Column("NOTA_VERIFICADA", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_notaVerificada")]
            public virtual long NotaVerificadaProp
            {
                get
                {
                    return this._notaVerificada;
                }
                set
                {
                    this._notaVerificada = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private ParticipantesReuniao _participantesreuniao;
            [ForeignKeyAssociation(ConstraintName = "NR_PR_FK", SharedFields = "ParticipanteReuniaoIdProp", TargetFields = "IdProp")]
            [Storage("_participantesreuniao")]
            public virtual ParticipantesReuniao ParticipantesreuniaoProp
            {
                get
                {
                    return this._participantesreuniao;
                }
                set
                {
                    this._participantesreuniao = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("MODULOS")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class Modulos
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private string _nomeFisico;
            [Column("NOME_FISICO", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 100, SqlType = "NVARCHAR2")]
            [Storage("_nomeFisico")]
            public virtual string NomeFisicoProp
            {
                get
                {
                    return this._nomeFisico;
                }
                set
                {
                    this._nomeFisico = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<ProgramasModulo> _programasModulos = new List<ProgramasModulo>();
            [Collection(InverseProperty = "ModulosProp")]
            [Storage("_programasModulos")]
            public virtual IList<ProgramasModulo> ProgramasModulos
            {
                get
                {
                    return this._programasModulos;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("MENSAGENS_REUNIAO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class MensagensReuniao
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _participanteReuniaoId;
            [Column("PARTICIPANTE_REUNIAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_participanteReuniaoId")]
            public virtual long ParticipanteReuniaoIdProp
            {
                get
                {
                    return this._participanteReuniaoId;
                }
                set
                {
                    this._participanteReuniaoId = value;
                }
            }
             
            private string _texto;
            [Column("TEXTO", OpenAccessType = OpenAccessType.Varchar, Length = 2000, SqlType = "NVARCHAR2")]
            [Storage("_texto")]
            public virtual string TextoProp
            {
                get
                {
                    return this._texto;
                }
                set
                {
                    this._texto = value;
                }
            }
             
            private short _mostrar;
            [Column("MOSTRAR", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_mostrar")]
            public virtual short MostrarProp
            {
                get
                {
                    return this._mostrar;
                }
                set
                {
                    this._mostrar = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private ParticipantesReuniao _participantesreuniao;
            [ForeignKeyAssociation(ConstraintName = "MR_PR_FK", SharedFields = "ParticipanteReuniaoIdProp", TargetFields = "IdProp")]
            [Storage("_participantesreuniao")]
            public virtual ParticipantesReuniao ParticipantesreuniaoProp
            {
                get
                {
                    return this._participantesreuniao;
                }
                set
                {
                    this._participantesreuniao = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("LISTAS")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class Listas
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private string _sigla;
            [Column("SIGLA", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 30, SqlType = "NVARCHAR2")]
            [Storage("_sigla")]
            public virtual string SiglaProp
            {
                get
                {
                    return this._sigla;
                }
                set
                {
                    this._sigla = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<EntidadesLista> _entidadesListas = new List<EntidadesLista>();
            [Collection(InverseProperty = "ListasProp")]
            [Storage("_entidadesListas")]
            public virtual IList<EntidadesLista> EntidadesListas
            {
                get
                {
                    return this._entidadesListas;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("ITEMS_ORGANIZACAO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class ItemsOrganizacao
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _oId;
            [Column("O_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_oId")]
            public virtual long OIdProp
            {
                get
                {
                    return this._oId;
                }
                set
                {
                    this._oId = value;
                }
            }
             
            private string _nomeTabela;
            [Column("NOME_TABELA", OpenAccessType = OpenAccessType.Varchar, Length = 50, SqlType = "NVARCHAR2")]
            [Storage("_nomeTabela")]
            public virtual string NomeTabelaProp
            {
                get
                {
                    return this._nomeTabela;
                }
                set
                {
                    this._nomeTabela = value;
                }
            }
             
            private string _nomeColuna;
            [Column("NOME_COLUNA", OpenAccessType = OpenAccessType.Varchar, Length = 50, SqlType = "NVARCHAR2")]
            [Storage("_nomeColuna")]
            public virtual string NomeColunaProp
            {
                get
                {
                    return this._nomeColuna;
                }
                set
                {
                    this._nomeColuna = value;
                }
            }
             
            private long _valorColuna;
            [Column("VALOR_COLUNA", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_valorColuna")]
            public virtual long ValorColunaProp
            {
                get
                {
                    return this._valorColuna;
                }
                set
                {
                    this._valorColuna = value;
                }
            }
             
            private Organizacoes _organizacoes;
            [ForeignKeyAssociation(ConstraintName = "IO_O_FK", SharedFields = "OIdProp", TargetFields = "IdProp")]
            [Storage("_organizacoes")]
            public virtual Organizacoes OrganizacoesProp
            {
                get
                {
                    return this._organizacoes;
                }
                set
                {
                    this._organizacoes = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("GRUPOS_CONVOCADOS_ENTIDADES")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class GruposConvocadosEntidades
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _grupoConvocadosId;
            [Column("GRUPO_CONVOCADOS_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_grupoConvocadosId")]
            public virtual long GrupoConvocadosIdProp
            {
                get
                {
                    return this._grupoConvocadosId;
                }
                set
                {
                    this._grupoConvocadosId = value;
                }
            }
             
            private long _funcaoReuniaoId;
            [Column("FUNCAO_REUNIAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_funcaoReuniaoId")]
            public virtual long FuncaoReuniaoIdProp
            {
                get
                {
                    return this._funcaoReuniaoId;
                }
                set
                {
                    this._funcaoReuniaoId = value;
                }
            }
             
            private long _entidadeId;
            [Column("ENTIDADE_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_entidadeId")]
            public virtual long EntidadeIdProp
            {
                get
                {
                    return this._entidadeId;
                }
                set
                {
                    this._entidadeId = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private Entidades _entidades;
            [ForeignKeyAssociation(ConstraintName = "GCE_E_FK", SharedFields = "EntidadeIdProp", TargetFields = "IdProp")]
            [Storage("_entidades")]
            public virtual Entidades EntidadesProp
            {
                get
                {
                    return this._entidades;
                }
                set
                {
                    this._entidades = value;
                }
            }
             
            private FuncoesReuniao _funcoesreuniao;
            [ForeignKeyAssociation(ConstraintName = "GCE_FR_FK", SharedFields = "FuncaoReuniaoIdProp", TargetFields = "IdProp")]
            [Storage("_funcoesreuniao")]
            public virtual FuncoesReuniao FuncoesreuniaoProp
            {
                get
                {
                    return this._funcoesreuniao;
                }
                set
                {
                    this._funcoesreuniao = value;
                }
            }
             
            private GruposConvocados _gruposconvocados;
            [ForeignKeyAssociation(ConstraintName = "GCE_GC_FK", SharedFields = "GrupoConvocadosIdProp", TargetFields = "IdProp")]
            [Storage("_gruposconvocados")]
            public virtual GruposConvocados GruposconvocadosProp
            {
                get
                {
                    return this._gruposconvocados;
                }
                set
                {
                    this._gruposconvocados = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("GRUPOS_CONVOCADOS")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class GruposConvocados
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<GruposConvocadosEntidades> _gruposConvocadosEntidades = new List<GruposConvocadosEntidades>();
            [Collection(InverseProperty = "GruposconvocadosProp")]
            [Storage("_gruposConvocadosEntidades")]
            public virtual IList<GruposConvocadosEntidades> GruposConvocadosEntidades
            {
                get
                {
                    return this._gruposConvocadosEntidades;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("FUNCOES_REUNIAO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class FuncoesReuniao
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 100, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<ParticipantesReuniao> _participantesReuniaos = new List<ParticipantesReuniao>();
            [Collection(InverseProperty = "FuncoesreuniaoProp")]
            [Storage("_participantesReuniaos")]
            public virtual IList<ParticipantesReuniao> ParticipantesReuniaos
            {
                get
                {
                    return this._participantesReuniaos;
                }
            }
             
            private IList<GruposConvocadosEntidades> _gruposConvocadosEntidades = new List<GruposConvocadosEntidades>();
            [Collection(InverseProperty = "FuncoesreuniaoProp")]
            [Storage("_gruposConvocadosEntidades")]
            public virtual IList<GruposConvocadosEntidades> GruposConvocadosEntidades
            {
                get
                {
                    return this._gruposConvocadosEntidades;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("FUNCOES_PROGRAMA")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class FuncoesPrograma
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _programaModuloId;
            [Column("PROGRAMA_MODULO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_programaModuloId")]
            public virtual long ProgramaModuloIdProp
            {
                get
                {
                    return this._programaModuloId;
                }
                set
                {
                    this._programaModuloId = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private ProgramasModulo _programasmodulo;
            [ForeignKeyAssociation(ConstraintName = "FPROG_PM_FK", SharedFields = "ProgramaModuloIdProp", TargetFields = "IdProp")]
            [Storage("_programasmodulo")]
            public virtual ProgramasModulo ProgramasmoduloProp
            {
                get
                {
                    return this._programasmodulo;
                }
                set
                {
                    this._programasmodulo = value;
                }
            }
             
            private IList<FuncoesPerfil> _funcoesPerfils = new List<FuncoesPerfil>();
            [Collection(InverseProperty = "FuncoesprogramaProp")]
            [Storage("_funcoesPerfils")]
            public virtual IList<FuncoesPerfil> FuncoesPerfils
            {
                get
                {
                    return this._funcoesPerfils;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("FUNCOES_PERFIL")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class FuncoesPerfil
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _perfilId;
            [Column("PERFIL_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_perfilId")]
            public virtual long PerfilIdProp
            {
                get
                {
                    return this._perfilId;
                }
                set
                {
                    this._perfilId = value;
                }
            }
             
            private long _funcaoProgramaId;
            [Column("FUNCAO_PROGRAMA_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_funcaoProgramaId")]
            public virtual long FuncaoProgramaIdProp
            {
                get
                {
                    return this._funcaoProgramaId;
                }
                set
                {
                    this._funcaoProgramaId = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private FuncoesPrograma _funcoesprograma;
            [ForeignKeyAssociation(ConstraintName = "FP_FPROG_FK", SharedFields = "FuncaoProgramaIdProp", TargetFields = "IdProp")]
            [Storage("_funcoesprograma")]
            public virtual FuncoesPrograma FuncoesprogramaProp
            {
                get
                {
                    return this._funcoesprograma;
                }
                set
                {
                    this._funcoesprograma = value;
                }
            }
             
            private Perfis _perfis;
            [ForeignKeyAssociation(ConstraintName = "FP_P_FK", SharedFields = "PerfilIdProp", TargetFields = "IdProp")]
            [Storage("_perfis")]
            public virtual Perfis PerfisProp
            {
                get
                {
                    return this._perfis;
                }
                set
                {
                    this._perfis = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("FORMAS_CONTACTO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class FormasContacto
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 50, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<Notificacoes> _notificacoes = new List<Notificacoes>();
            [Collection(InverseProperty = "FormascontactoProp")]
            [Storage("_notificacoes")]
            public virtual IList<Notificacoes> Notificacoes
            {
                get
                {
                    return this._notificacoes;
                }
            }
             
            private IList<Entidades> _entidades = new List<Entidades>();
            [Collection(InverseProperty = "FormasContactoProp")]
            [Storage("_entidades")]
            public virtual IList<Entidades> Entidades
            {
                get
                {
                    return this._entidades;
                }
                set
                {
                    this._entidades = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("ESTADOS_REUNIAO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class EstadosReuniao
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 50, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short _valor;
            [Column("VALOR", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_valor")]
            public virtual short ValorProp
            {
                get
                {
                    return this._valor;
                }
                set
                {
                    this._valor = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<Reunioes> _reunioes = new List<Reunioes>();
            [Collection(InverseProperty = "EstadosreuniaoProp")]
            [Storage("_reunioes")]
            public virtual IList<Reunioes> Reunioes
            {
                get
                {
                    return this._reunioes;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("ENTIDADES_LISTA")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class EntidadesLista
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _listaId;
            [Column("LISTA_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_listaId")]
            public virtual long ListaIdProp
            {
                get
                {
                    return this._listaId;
                }
                set
                {
                    this._listaId = value;
                }
            }
             
            private long _entidadeId;
            [Column("ENTIDADE_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_entidadeId")]
            public virtual long EntidadeIdProp
            {
                get
                {
                    return this._entidadeId;
                }
                set
                {
                    this._entidadeId = value;
                }
            }
             
            private DateTime? _dataInicio;
            [Column("DATA_INICIO", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_dataInicio")]
            public virtual DateTime? DataInicioProp
            {
                get
                {
                    return this._dataInicio;
                }
                set
                {
                    this._dataInicio = value;
                }
            }
             
            private DateTime? _dataFim;
            [Column("DATA_FIM", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_dataFim")]
            public virtual DateTime? DataFimProp
            {
                get
                {
                    return this._dataFim;
                }
                set
                {
                    this._dataFim = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private Entidades _entidades;
            [ForeignKeyAssociation(ConstraintName = "EL_E_FK", SharedFields = "EntidadeIdProp", TargetFields = "IdProp")]
            [Storage("_entidades")]
            public virtual Entidades EntidadesProp
            {
                get
                {
                    return this._entidades;
                }
                set
                {
                    this._entidades = value;
                }
            }
             
            private Listas _listas;
            [ForeignKeyAssociation(ConstraintName = "EL_L_FK", SharedFields = "ListaIdProp", TargetFields = "IdProp")]
            [Storage("_listas")]
            public virtual Listas ListasProp
            {
                get
                {
                    return this._listas;
                }
                set
                {
                    this._listas = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("ENTIDADES_CARGO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class EntidadesCargo
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _cargosId;
            [Column("CARGOS_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_cargosId")]
            public virtual long CargosIdProp
            {
                get
                {
                    return this._cargosId;
                }
                set
                {
                    this._cargosId = value;
                }
            }
             
            private long _entidadeId;
            [Column("ENTIDADE_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_entidadeId")]
            public virtual long EntidadeIdProp
            {
                get
                {
                    return this._entidadeId;
                }
                set
                {
                    this._entidadeId = value;
                }
            }
             
            private DateTime? _dataInicio;
            [Column("DATA_INICIO", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_dataInicio")]
            public virtual DateTime? DataInicioProp
            {
                get
                {
                    return this._dataInicio;
                }
                set
                {
                    this._dataInicio = value;
                }
            }
             
            private DateTime? _dataFim;
            [Column("DATA_FIM", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_dataFim")]
            public virtual DateTime? DataFimProp
            {
                get
                {
                    return this._dataFim;
                }
                set
                {
                    this._dataFim = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private Cargos _cargos;
            [ForeignKeyAssociation(ConstraintName = "EC_C_FK", SharedFields = "CargosIdProp", TargetFields = "IdProp")]
            [Storage("_cargos")]
            public virtual Cargos CargosProp
            {
                get
                {
                    return this._cargos;
                }
                set
                {
                    this._cargos = value;
                }
            }
             
            private Entidades _entidades;
            [ForeignKeyAssociation(ConstraintName = "EC_E_FK", SharedFields = "EntidadeIdProp", TargetFields = "IdProp")]
            [Storage("_entidades")]
            public virtual Entidades EntidadesProp
            {
                get
                {
                    return this._entidades;
                }
                set
                {
                    this._entidades = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("ENTIDADES")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class Entidades
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _tipoEntidadeId;
            [Column("TIPO_ENTIDADE_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_tipoEntidadeId")]
            public virtual long TipoEntidadeIdProp
            {
                get
                {
                    return this._tipoEntidadeId;
                }
                set
                {
                    this._tipoEntidadeId = value;
                }
            }
             
            private long _defaultFormaContactoId;
            [Column("DEFAULT_FORMA_CONTACTO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_defaultFormaContactoId")]
            public virtual long DefaultFormaContactoIdProp
            {
                get
                {
                    return this._defaultFormaContactoId;
                }
                set
                {
                    this._defaultFormaContactoId = value;
                }
            }
             
            private long _tituloId;
            [Column("TITULO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_tituloId")]
            public virtual long TituloIdProp
            {
                get
                {
                    return this._tituloId;
                }
                set
                {
                    this._tituloId = value;
                }
            }
             
            private string _nomeCompleto;
            [Column("NOME_COMPLETO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_nomeCompleto")]
            public virtual string NomeCompletoProp
            {
                get
                {
                    return this._nomeCompleto;
                }
                set
                {
                    this._nomeCompleto = value;
                }
            }
             
            private string _nomeTratamento;
            [Column("NOME_TRATAMENTO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_nomeTratamento")]
            public virtual string NomeTratamentoProp
            {
                get
                {
                    return this._nomeTratamento;
                }
                set
                {
                    this._nomeTratamento = value;
                }
            }
             
            private string _login;
            [Column("LOGIN", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_login")]
            public virtual string LoginProp
            {
                get
                {
                    return this._login;
                }
                set
                {
                    this._login = value;
                }
            }
             
            private string _password;
            [Column("PASSWORD", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 16, SqlType = "NVARCHAR2")]
            [Storage("_password")]
            public virtual string PasswordProp
            {
                get
                {
                    return this._password;
                }
                set
                {
                    this._password = value;
                }
            }
             
            private string _email;
            [Column("EMAIL", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 150, SqlType = "NVARCHAR2")]
            [Storage("_email")]
            public virtual string EmailProp
            {
                get
                {
                    return this._email;
                }
                set
                {
                    this._email = value;
                }
            }
             
            private string _telefone;
            [Column("TELEFONE", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 15, SqlType = "NVARCHAR2")]
            [Storage("_telefone")]
            public virtual string TelefoneProp
            {
                get
                {
                    return this._telefone;
                }
                set
                {
                    this._telefone = value;
                }
            }
             
            private string _telemovel;
            [Column("TELEMOVEL", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 15, SqlType = "NVARCHAR2")]
            [Storage("_telemovel")]
            public virtual string TelemovelProp
            {
                get
                {
                    return this._telemovel;
                }
                set
                {
                    this._telemovel = value;
                }
            }
             
            private string _fax;
            [Column("FAX", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 15, SqlType = "NVARCHAR2")]
            [Storage("_fax")]
            public virtual string FaxProp
            {
                get
                {
                    return this._fax;
                }
                set
                {
                    this._fax = value;
                }
            }
             
            private string _morada;
            [Column("MORADA", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_morada")]
            public virtual string MoradaProp
            {
                get
                {
                    return this._morada;
                }
                set
                {
                    this._morada = value;
                }
            }
             
            private short? _acesso;
            [Column("ACESSO", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 1, SqlType = "NUMBER")]
            [Storage("_acesso")]
            public virtual short? AcessoProp
            {
                get
                {
                    return this._acesso;
                }
                set
                {
                    this._acesso = value;
                }
            }
             
            private string _nrMecanografico;
            [Column("NR_MECANOGRAFICO", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 15, SqlType = "NVARCHAR2")]
            [Storage("_nrMecanografico")]
            public virtual string NrMecanograficoProp
            {
                get
                {
                    return this._nrMecanografico;
                }
                set
                {
                    this._nrMecanografico = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private FormasContacto _formasContacto;
            [ForeignKeyAssociation(ConstraintName = "E_FC_FK", SharedFields = "DefaultFormaContactoIdProp", TargetFields = "IdProp")]
            [Storage("_formasContacto")]
            public virtual FormasContacto FormasContactoProp
            {
                get
                {
                    return this._formasContacto;
                }
                set
                {
                    this._formasContacto = value;
                }
            }
             
            private TiposEntidade _tiposEntidade;
            [ForeignKeyAssociation(ConstraintName = "E_TE_FK", SharedFields = "TipoEntidadeIdProp", TargetFields = "IdProp")]
            [Storage("_tiposEntidade")]
            public virtual TiposEntidade TiposEntidadeProp
            {
                get
                {
                    return this._tiposEntidade;
                }
                set
                {
                    this._tiposEntidade = value;
                }
            }
             
            private Titulos _titulos;
            [ForeignKeyAssociation(ConstraintName = "E_TIT_FK", SharedFields = "TituloIdProp", TargetFields = "IdProp")]
            [Storage("_titulos")]
            public virtual Titulos TitulosProp
            {
                get
                {
                    return this._titulos;
                }
                set
                {
                    this._titulos = value;
                }
            }
             
            private IList<UtilizadoresPerfis> _utilizadoresPerfis = new List<UtilizadoresPerfis>();
            [Collection(InverseProperty = "EntidadesProp")]
            [Storage("_utilizadoresPerfis")]
            public virtual IList<UtilizadoresPerfis> UtilizadoresPerfis
            {
                get
                {
                    return this._utilizadoresPerfis;
                }
            }
             
            private IList<ParticipantesReuniao> _participantesReuniaos = new List<ParticipantesReuniao>();
            [Collection(InverseProperty = "EntidadesProp")]
            [Storage("_participantesReuniaos")]
            public virtual IList<ParticipantesReuniao> ParticipantesReuniaos
            {
                get
                {
                    return this._participantesReuniaos;
                }
            }
             
            private IList<GruposConvocadosEntidades> _gruposConvocadosEntidades = new List<GruposConvocadosEntidades>();
            [Collection(InverseProperty = "EntidadesProp")]
            [Storage("_gruposConvocadosEntidades")]
            public virtual IList<GruposConvocadosEntidades> GruposConvocadosEntidades
            {
                get
                {
                    return this._gruposConvocadosEntidades;
                }
            }
             
            private IList<EntidadesLista> _entidadesListas = new List<EntidadesLista>();
            [Collection(InverseProperty = "EntidadesProp")]
            [Storage("_entidadesListas")]
            public virtual IList<EntidadesLista> EntidadesListas
            {
                get
                {
                    return this._entidadesListas;
                }
            }
             
            private IList<EntidadesCargo> _entidadesCargos = new List<EntidadesCargo>();
            [Collection(InverseProperty = "EntidadesProp")]
            [Storage("_entidadesCargos")]
            public virtual IList<EntidadesCargo> EntidadesCargos
            {
                get
                {
                    return this._entidadesCargos;
                }
            }
             
            private IList<ConfiguracaoUtilizador> _configuracaoUtilizadors = new List<ConfiguracaoUtilizador>();
            [Collection(InverseProperty = "EntidadesProp")]
            [Storage("_configuracaoUtilizadors")]
            public virtual IList<ConfiguracaoUtilizador> ConfiguracaoUtilizadors
            {
                get
                {
                    return this._configuracaoUtilizadors;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("DOCUMENTOS_REUNIAO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class DocumentosReuniao
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _documentoBaseSgaId;
            [Column("DOCUMENTO_BASE_SGA_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_documentoBaseSgaId")]
            public virtual long DocumentoBaseSgaIdProp
            {
                get
                {
                    return this._documentoBaseSgaId;
                }
                set
                {
                    this._documentoBaseSgaId = value;
                }
            }
             
            private long _reuniaoId;
            [Column("REUNIAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_reuniaoId")]
            public virtual long ReuniaoIdProp
            {
                get
                {
                    return this._reuniaoId;
                }
                set
                {
                    this._reuniaoId = value;
                }
            }
             
            private long _tipoDocumentoId;
            [Column("TIPO_DOCUMENTO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_tipoDocumentoId")]
            public virtual long TipoDocumentoIdProp
            {
                get
                {
                    return this._tipoDocumentoId;
                }
                set
                {
                    this._tipoDocumentoId = value;
                }
            }
             
            private short _numero;
            [Column("NUMERO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_numero")]
            public virtual short NumeroProp
            {
                get
                {
                    return this._numero;
                }
                set
                {
                    this._numero = value;
                }
            }
             
            private short _ano;
            [Column("ANO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_ano")]
            public virtual short AnoProp
            {
                get
                {
                    return this._ano;
                }
                set
                {
                    this._ano = value;
                }
            }
             
            private short _versaoActa;
            [Column("VERSAO_ACTA", OpenAccessType = OpenAccessType.Decimal, Length = 2, SqlType = "NUMBER")]
            [Storage("_versaoActa")]
            public virtual short VersaoActaProp
            {
                get
                {
                    return this._versaoActa;
                }
                set
                {
                    this._versaoActa = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private DocumentosBaseSga _documentosbasesga;
            [ForeignKeyAssociation(ConstraintName = "DR_DBS_FK", SharedFields = "DocumentoBaseSgaIdProp", TargetFields = "IdProp")]
            [Storage("_documentosbasesga")]
            public virtual DocumentosBaseSga DocumentosbasesgaProp
            {
                get
                {
                    return this._documentosbasesga;
                }
                set
                {
                    this._documentosbasesga = value;
                }
            }
             
            private Reunioes _reunioes;
            [ForeignKeyAssociation(ConstraintName = "DR_R_FK", SharedFields = "ReuniaoIdProp", TargetFields = "IdProp")]
            [Storage("_reunioes")]
            public virtual Reunioes ReunioesProp
            {
                get
                {
                    return this._reunioes;
                }
                set
                {
                    this._reunioes = value;
                }
            }
             
            private TiposDocumento _tiposdocumento;
            [ForeignKeyAssociation(ConstraintName = "DR_TD_FK", SharedFields = "TipoDocumentoIdProp", TargetFields = "IdProp")]
            [Storage("_tiposdocumento")]
            public virtual TiposDocumento TiposdocumentoProp
            {
                get
                {
                    return this._tiposdocumento;
                }
                set
                {
                    this._tiposdocumento = value;
                }
            }
             
            private IList<ActasVotacao> _actasVotacaos = new List<ActasVotacao>();
            [Collection(InverseProperty = "DocumentosreuniaoProp")]
            [Storage("_actasVotacaos")]
            public virtual IList<ActasVotacao> ActasVotacaos
            {
                get
                {
                    return this._actasVotacaos;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("DOCUMENTOS_BASE_SGA")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class DocumentosBaseSga
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 20, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short _ordem;
            [Column("ORDEM", OpenAccessType = OpenAccessType.Decimal, Length = 2, SqlType = "NUMBER")]
            [Storage("_ordem")]
            public virtual short OrdemProp
            {
                get
                {
                    return this._ordem;
                }
                set
                {
                    this._ordem = value;
                }
            }
             
            private short _possuiVotacao;
            [Column("POSSUI_VOTACAO", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_possuiVotacao")]
            public virtual short PossuiVotacaoProp
            {
                get
                {
                    return this._possuiVotacao;
                }
                set
                {
                    this._possuiVotacao = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<DocumentosReuniao> _documentosReuniaos = new List<DocumentosReuniao>();
            [Collection(InverseProperty = "DocumentosbasesgaProp")]
            [Storage("_documentosReuniaos")]
            public virtual IList<DocumentosReuniao> DocumentosReuniaos
            {
                get
                {
                    return this._documentosReuniaos;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("CONFIGURACAO_UTILIZADOR")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class ConfiguracaoUtilizador
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _entidadeId;
            [Column("ENTIDADE_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_entidadeId")]
            public virtual long EntidadeIdProp
            {
                get
                {
                    return this._entidadeId;
                }
                set
                {
                    this._entidadeId = value;
                }
            }
             
            private string _nomeItem;
            [Column("NOME_ITEM", OpenAccessType = OpenAccessType.Varchar, Length = 50, SqlType = "NVARCHAR2")]
            [Storage("_nomeItem")]
            public virtual string NomeItemProp
            {
                get
                {
                    return this._nomeItem;
                }
                set
                {
                    this._nomeItem = value;
                }
            }
             
            private string _valorItem;
            [Column("VALOR_ITEM", OpenAccessType = OpenAccessType.Varchar, Length = 100, SqlType = "NVARCHAR2")]
            [Storage("_valorItem")]
            public virtual string ValorItemProp
            {
                get
                {
                    return this._valorItem;
                }
                set
                {
                    this._valorItem = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private Entidades _entidades;
            [ForeignKeyAssociation(ConstraintName = "CU_E_FK", SharedFields = "EntidadeIdProp", TargetFields = "IdProp")]
            [Storage("_entidades")]
            public virtual Entidades EntidadesProp
            {
                get
                {
                    return this._entidades;
                }
                set
                {
                    this._entidades = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("CONFIGURACAO_APLICACAO")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class ConfiguracaoAplicacao
        {
            private short _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 4, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual short IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _nomeItem;
            [Column("NOME_ITEM", OpenAccessType = OpenAccessType.Varchar, Length = 50, SqlType = "NVARCHAR2")]
            [Storage("_nomeItem")]
            public virtual string NomeItemProp
            {
                get
                {
                    return this._nomeItem;
                }
                set
                {
                    this._nomeItem = value;
                }
            }
             
            private string _valorItem;
            [Column("VALOR_ITEM", OpenAccessType = OpenAccessType.Varchar, Length = 100, SqlType = "NVARCHAR2")]
            [Storage("_valorItem")]
            public virtual string ValorItemProp
            {
                get
                {
                    return this._valorItem;
                }
                set
                {
                    this._valorItem = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("CARGOS")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class Cargos
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private IList<EntidadesCargo> _entidadesCargos = new List<EntidadesCargo>();
            [Collection(InverseProperty = "CargosProp")]
            [Storage("_entidadesCargos")]
            public virtual IList<EntidadesCargo> EntidadesCargos
            {
                get
                {
                    return this._entidadesCargos;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("BACKUP_BD")]
        [KeyGenerator(KeyGenerator.Autoinc)]
        public partial class BackupBd
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsBackendCalculated = true, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private string _loginResponsavel;
            [Column("LOGIN_RESPONSAVEL", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_loginResponsavel")]
            public virtual string LoginResponsavelProp
            {
                get
                {
                    return this._loginResponsavel;
                }
                set
                {
                    this._loginResponsavel = value;
                }
            }
             
            private DateTime _dataBackup;
            [Column("DATA_BACKUP", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_dataBackup")]
            public virtual DateTime DataBackupProp
            {
                get
                {
                    return this._dataBackup;
                }
                set
                {
                    this._dataBackup = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 4, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("ANEXOS_NOTIFICACAO")]
        public partial class AnexosNotificacao
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _notificacaoId;
            [Column("NOTIFICACAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_notificacaoId")]
            public virtual long NotificacaoIdProp
            {
                get
                {
                    return this._notificacaoId;
                }
                set
                {
                    this._notificacaoId = value;
                }
            }
             
            private long _anexoId;
            [Column("ANEXO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_anexoId")]
            public virtual long AnexoIdProp
            {
                get
                {
                    return this._anexoId;
                }
                set
                {
                    this._anexoId = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private Anexos _anexos;
            [ForeignKeyAssociation(ConstraintName = "AN_A_FK", SharedFields = "AnexoIdProp", TargetFields = "IdProp")]
            [Storage("_anexos")]
            public virtual Anexos AnexosProp
            {
                get
                {
                    return this._anexos;
                }
                set
                {
                    this._anexos = value;
                }
            }
             
            private Notificacoes _notificacoes;
            [ForeignKeyAssociation(ConstraintName = "AN_N_FK", SharedFields = "NotificacaoIdProp", TargetFields = "IdProp")]
            [Storage("_notificacoes")]
            public virtual Notificacoes NotificacoesProp
            {
                get
                {
                    return this._notificacoes;
                }
                set
                {
                    this._notificacoes = value;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("ANEXOS")]
        public partial class Anexos
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _reuniaoId;
            [Column("REUNIAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_reuniaoId")]
            public virtual long ReuniaoIdProp
            {
                get
                {
                    return this._reuniaoId;
                }
                set
                {
                    this._reuniaoId = value;
                }
            }
             
            private long _tipoDocumentoId;
            [Column("TIPO_DOCUMENTO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_tipoDocumentoId")]
            public virtual long TipoDocumentoIdProp
            {
                get
                {
                    return this._tipoDocumentoId;
                }
                set
                {
                    this._tipoDocumentoId = value;
                }
            }
             
            private string _designacao;
            [Column("DESIGNACAO", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 200, SqlType = "NVARCHAR2")]
            [Storage("_designacao")]
            public virtual string DesignacaoProp
            {
                get
                {
                    return this._designacao;
                }
                set
                {
                    this._designacao = value;
                }
            }
             
            private short _ficheiro;
            [Column("FICHEIRO", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_ficheiro")]
            public virtual short FicheiroProp
            {
                get
                {
                    return this._ficheiro;
                }
                set
                {
                    this._ficheiro = value;
                }
            }
             
            private int? _tamanhoFicheiro;
            [Column("TAMANHO_FICHEIRO", OpenAccessType = OpenAccessType.Decimal, IsNullable = true, Length = 7, SqlType = "NUMBER")]
            [Storage("_tamanhoFicheiro")]
            public virtual int? TamanhoFicheiroProp
            {
                get
                {
                    return this._tamanhoFicheiro;
                }
                set
                {
                    this._tamanhoFicheiro = value;
                }
            }
             
            private string _urlFicheiro;
            [Column("URL_FICHEIRO", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 1000, SqlType = "NVARCHAR2")]
            [Storage("_urlFicheiro")]
            public virtual string UrlFicheiroProp
            {
                get
                {
                    return this._urlFicheiro;
                }
                set
                {
                    this._urlFicheiro = value;
                }
            }
             
            private byte[] _conteudo;
            [Column("CONTEUDO", OpenAccessType = OpenAccessType.Blob, IsNullable = true, SqlType = "BLOB")]
            [Storage("_conteudo")]
            public virtual byte[] ConteudoProp
            {
                get
                {
                    return this._conteudo;
                }
                set
                {
                    this._conteudo = value;
                }
            }
             
            private short _visivelReuniao;
            [Column("VISIVEL_REUNIAO", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_visivelReuniao")]
            public virtual short VisivelReuniaoProp
            {
                get
                {
                    return this._visivelReuniao;
                }
                set
                {
                    this._visivelReuniao = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "VARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private TiposDocumento _tiposdocumento;
            [ForeignKeyAssociation(ConstraintName = "A_TD_FK", SharedFields = "TipoDocumentoIdProp", TargetFields = "IdProp")]
            [Storage("_tiposdocumento")]
            public virtual TiposDocumento TiposdocumentoProp
            {
                get
                {
                    return this._tiposdocumento;
                }
                set
                {
                    this._tiposdocumento = value;
                }
            }
             
            private Reunioes _reunioes;
            [ForeignKeyAssociation(ConstraintName = "A_R_FK", SharedFields = "ReuniaoIdProp", TargetFields = "IdProp")]
            [Storage("_reunioes")]
            public virtual Reunioes ReunioesProp
            {
                get
                {
                    return this._reunioes;
                }
                set
                {
                    this._reunioes = value;
                }
            }
             
            private IList<AnexosNotificacao> _anexosNotificacaos = new List<AnexosNotificacao>();
            [Collection(InverseProperty = "AnexosProp")]
            [Storage("_anexosNotificacaos")]
            public virtual IList<AnexosNotificacao> AnexosNotificacaos
            {
                get
                {
                    return this._anexosNotificacaos;
                }
            }
             
        }
    }
     
    namespace SGA.Web  
    {
        [Table("ACTAS_VOTACAO")]
        public partial class ActasVotacao
        {
            private long _id;
            [Column("ID", OpenAccessType = OpenAccessType.Decimal, IsPrimaryKey = true, Length = 22, SqlType = "NUMBER")]
            [Storage("_id")]
            public virtual long IdProp
            {
                get
                {
                    return this._id;
                }
                set
                {
                    this._id = value;
                }
            }
             
            private long _participanteReuniaoId;
            [Column("PARTICIPANTE_REUNIAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_participanteReuniaoId")]
            public virtual long ParticipanteReuniaoIdProp
            {
                get
                {
                    return this._participanteReuniaoId;
                }
                set
                {
                    this._participanteReuniaoId = value;
                }
            }
             
            private long _documentoReuniaoId;
            [Column("DOCUMENTO_REUNIAO_ID", OpenAccessType = OpenAccessType.Decimal, Length = 22, SqlType = "NUMBER")]
            [Storage("_documentoReuniaoId")]
            public virtual long DocumentoReuniaoIdProp
            {
                get
                {
                    return this._documentoReuniaoId;
                }
                set
                {
                    this._documentoReuniaoId = value;
                }
            }
             
            private System.Nullable<System.Char> _resultadoVotacao;
            [Column("RESULTADO_VOTACAO", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 1, SqlType = "NVARCHAR2")]
            [Storage("_resultadoVotacao")]
            public virtual System.Nullable<System.Char> ResultadoVotacaoProp
            {
                get
                {
                    return this._resultadoVotacao;
                }
                set
                {
                    this._resultadoVotacao = value;
                }
            }
             
            private DateTime? _dataVotacao;
            [Column("DATA_VOTACAO", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_dataVotacao")]
            public virtual DateTime? DataVotacaoProp
            {
                get
                {
                    return this._dataVotacao;
                }
                set
                {
                    this._dataVotacao = value;
                }
            }
             
            private System.Nullable<System.Char> _votacaoAnterior;
            [Column("VOTACAO_ANTERIOR", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 1, SqlType = "NVARCHAR2")]
            [Storage("_votacaoAnterior")]
            public virtual System.Nullable<System.Char> VotacaoAnteriorProp
            {
                get
                {
                    return this._votacaoAnterior;
                }
                set
                {
                    this._votacaoAnterior = value;
                }
            }
             
            private DateTime? _dataVotacaoAnterior;
            [Column("DATA_VOTACAO_ANTERIOR", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_dataVotacaoAnterior")]
            public virtual DateTime? DataVotacaoAnteriorProp
            {
                get
                {
                    return this._dataVotacaoAnterior;
                }
                set
                {
                    this._dataVotacaoAnterior = value;
                }
            }
             
            private short _sit;
            [Column("SIT", OpenAccessType = OpenAccessType.Decimal, Length = 1, SqlType = "NUMBER")]
            [Storage("_sit")]
            public virtual short SitProp
            {
                get
                {
                    return this._sit;
                }
                set
                {
                    this._sit = value;
                }
            }
             
            private string _insUser;
            [Column("INS_USER", OpenAccessType = OpenAccessType.Varchar, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_insUser")]
            public virtual string InsUserProp
            {
                get
                {
                    return this._insUser;
                }
                set
                {
                    this._insUser = value;
                }
            }
             
            private DateTime _insData;
            [Column("INS_DATA", OpenAccessType = OpenAccessType.Date, SqlType = "DATE")]
            [Storage("_insData")]
            public virtual DateTime InsDataProp
            {
                get
                {
                    return this._insData;
                }
                set
                {
                    this._insData = value;
                }
            }
             
            private string _altUser;
            [Column("ALT_USER", OpenAccessType = OpenAccessType.Varchar, IsNullable = true, Length = 40, SqlType = "NVARCHAR2")]
            [Storage("_altUser")]
            public virtual string AltUserProp
            {
                get
                {
                    return this._altUser;
                }
                set
                {
                    this._altUser = value;
                }
            }
             
            private DateTime? _altData;
            [Column("ALT_DATA", OpenAccessType = OpenAccessType.Date, IsNullable = true, SqlType = "DATE")]
            [Storage("_altData")]
            public virtual DateTime? AltDataProp
            {
                get
                {
                    return this._altData;
                }
                set
                {
                    this._altData = value;
                }
            }
             
            private short _versao;
            [Column("VERSAO", OpenAccessType = OpenAccessType.Decimal, Length = 3, SqlType = "NUMBER")]
            [Storage("_versao")]
            public virtual short VersaoProp
            {
                get
                {
                    return this._versao;
                }
                set
                {
                    this._versao = value;
                }
            }
             
            private DocumentosReuniao _documentosReuniao;
            [ForeignKeyAssociation(ConstraintName = "AV_DR_FK", SharedFields = "DocumentoReuniaoIdProp", TargetFields = "IdProp")]
            [Storage("_documentosReuniao")]
            public virtual DocumentosReuniao DocumentosReuniaoProp
            {
                get
                {
                    return this._documentosReuniao;
                }
                set
                {
                    this._documentosReuniao = value;
                }
            }
             
            private ParticipantesReuniao _participantesReuniao;
            [ForeignKeyAssociation(ConstraintName = "AV_PR_FK", SharedFields = "ParticipanteReuniaoIdProp", TargetFields = "IdProp")]
            [Storage("_participantesReuniao")]
            public virtual ParticipantesReuniao ParticipantesReuniaoProp
            {
                get
                {
                    return this._participantesReuniao;
                }
                set
                {
                    this._participantesReuniao = value;
                }
            }
             
        }
    }
    #pragma warning restore 1591
  14. Carlos
    Carlos avatar
    50 posts
    Member since:
    Feb 2011

    Posted 09 Jun 2011 Link to this post

    Now I'm stuck again, and it's relative to what I asked in my last two posts.

    [Entidades] - [EntidadesCargos] - [Cargos]
    where [EntidadesCargos] is a join table, and from [Entidades] I need to have a direct list of the Cargos..

    I've tried several aproaches in the Model class and in the MetadataClasses, but with no luck..

    what should I had in the Model, in wich classes and in Metadata?


    I ask Please, when you see this post and think you have an answer for me, please try to be as assertive as possible. Because you guys have a lot to do and if your answer doesn't solve my problem it will take some more days to answer a new question done my me. My chief is almost killing me ATM.

    Keep in mind, your answer is absolutely precious for me ATM.

    Thank you
  15. Carlos
    Carlos avatar
    50 posts
    Member since:
    Feb 2011

    Posted 13 Jun 2011 Link to this post

    Waiting for you billion dollar answer :). This is really stucking me up.
  16. Answer
    PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 13 Jun 2011 Link to this post

    Hi Carlos,

     If you would like to represent a join table it will be best if you map it to a persistent type. This way you can expose it to the service and add the association attribute to point to that class.
    so in your case [Entidades] - [EntidadesCargos] - [Cargos] you will have 1-n from entidades to entidades cargos and 1-n from cargos to entidades cargos. This way you will be able to have collection on both sides.

    All the best,
    Petar
    the Telerik team
    Q1’11 SP1 of Telerik OpenAccess is available for download; also available is the Q2'11 Roadmap for Telerik OpenAccess ORM.
Back to Top
DevCraft banner