using System;

using System.Collections.Generic;

using SyncEngine.Configuration;



namespace SyncEngine.Access

{

    public sealed class AccessTableSchema

    {

        public string TableName { get; set; }

        public IList<AccessColumnSchema> Columns { get; set; } = new List<AccessColumnSchema>();

        public string PrimaryKeyColumn { get; set; }

        public IList<string> PrimaryKeyColumns { get; set; } = new List<string>();

        /// <summary>Access table-level ValidationRule (DAO), if any.</summary>

        public string TableValidationRule { get; set; }

    }



    public sealed class AccessColumnSchema

    {

        public string Name { get; set; }

        public Type ClrType { get; set; }

        public int ColumnSize { get; set; }

        public bool AllowNull { get; set; }

        public bool IsPrimaryKey { get; set; }

        public bool IsAutoIncrement { get; set; }

        /// <summary>Raw Access DefaultValue expression, if set.</summary>

        public string DefaultValue { get; set; }

        /// <summary>Raw Access ValidationRule expression, if set.</summary>

        public string ValidationRule { get; set; }

    }



    public sealed class AccessQuerySchema

    {

        public string Name { get; set; }

        public string SqlText { get; set; }

        public bool ShouldProvision { get; set; }

        public string SkipReason { get; set; }

    }



    public sealed class AccessSysMetadata

    {

        public IList<AccessQuerySchema> Queries { get; set; } = new List<AccessQuerySchema>();

        public IList<ForeignKeyInfo> ForeignKeys { get; set; } = new List<ForeignKeyInfo>();

        public IList<AccessIndexInfo> Indexes { get; set; } = new List<AccessIndexInfo>();

    }

}