using System;
using System.Collections.Generic;
using System.Text;

namespace sharpcomparer
{
    public class IndexColumn
    {
        public enum DataType
        {
            image = 34,
            text = 35,
            tinyint = 48,
            smallint = 52,
            int1 = 56,
            smalldatetime = 58,
            real = 59,
            money = 60,
            datetime = 61,
            float1 = 62,
            sql_variant = 98,
            ntext = 99,
            bit = 104,
            decimal1 = 106,
            numeric = 108,
            smallmoney = 122,
            bigint = 127,
            varbinary = 165,
            varchar = 167,
            binary = 173,
            char1 = 175,
            timestamp = 189,
            nvarchar = 231,
            nchar = 239
        }

        //System.Data.SqlDbType

        private string constraintCatalog;
        private string constraintSchema;
        private string constraintName;
        private string tableCatalog;
        private string tableSchema;
        private string tableName;
        private string columnName;
        private int ordinalPosition;
        private byte keyType;
        private string indexName;

        public string ConstraintCatalog
        {
            get { return constraintCatalog; }
            set { constraintCatalog = value; }
        }

        public string ConstraintSchema
        {
            get { return constraintSchema; }
            set { constraintSchema = value; }
        }

        public string ConstraintName
        {
            get { return constraintName; }
            set { constraintName = value; }
        }

        public string TableCatalog
        {
            get { return tableCatalog; }
            set { tableCatalog = value; }
        }

        public string TableSchema
        {
            get { return tableSchema; }
            set { tableSchema = value; }
        }

        public string TableName
        {
            get { return tableName; }
            set { tableName = value; }
        }

        public string ColumnName
        {
            get { return columnName; }
            set { columnName = value; }
        }

        public int OrdinalPosition
        {
            get { return ordinalPosition; }
            set { ordinalPosition = value; }
        }

        public byte KeyType
        {
            get { return keyType; }
            set { keyType = value; }
        }

        public string IndexName
        {
            get { return indexName; }
            set { indexName = value; }
        }

        public IndexColumn(
            string constraintCatalog,
            string constraintSchema,
            string constraintName,
            string tableCatalog,
            string tableSchema,
            string tableName,
            string columnName,
            int ordinalPosition,
            byte keyType,
            string indexName)
        {
            this.constraintCatalog = constraintCatalog;
            this.constraintSchema = constraintSchema;
            this.constraintName = constraintName;
            this.tableCatalog = tableCatalog;
            this.tableSchema = tableSchema;
            this.tableName = tableName;
            this.columnName = columnName;
            this.ordinalPosition = ordinalPosition;
            this.keyType = keyType;
            this.indexName = indexName;
        }
    }
}