using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Castle.ActiveRecord;

namespace ProductModelActiveRecord
{
    [ActiveRecord(Table="ProductGroups")]
    public class ProductGroup
    {
        [PrimaryKey(Column="ProductGroupID", Generator=Castle.ActiveRecord.PrimaryKeyType.UuidHex)]
        public virtual string ProductGroupID { get; set; }
        
        [Property(NotNull=true, Length=50, Column="Title")]
        public virtual string Title { get; set; }

        [HasAndBelongsToMany(Table="ProductsProductGroupsLookup", ColumnKey="ProductGroupID", ColumnRef="ProductID")]
        public virtual IList<Product> Products { get; set; }
    }
}