using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using OTSModelSharp.DTLBase;

namespace OTSModelSharp
{
    class CIncADataTable : CSQLiteTable
    {
        public enum ColumnID : int
        {
            INVALID = -1,
            MIN = 0,
            N_FIELD_ID = 0,
            N_XRAY_ID = 1,
            N_AVE_GRAY = 2,
            N_RECT_LEFT = 3,
            N_RECT_TOP = 4,
            N_RECT_WIDTH = 5,
            N_RECT_HEIGHT = 6,
            F_AREA = 7,
            N_POS_X = 8,
            N_POS_Y = 9,
            F_DFERET = 10,           
            N_SEGMENT_NUM = 11,
            N_FldPosX = 12,
            N_FldPosY = 13,
            N_PARTICLE_ID = 14,
            F_DMAX = 15,
            F_DMIN = 16,
            F_DPERP = 17,
            F_PERIMETER = 18,
            F_ORIENTATION = 19,
            F_DINSCR = 20,
            F_DMEAN = 21,
            F_DELONG = 22,
            N_TYPE_ID = 23,
            S_NAME = 24,
            S_COLOR = 25,
            N_SEMPOS_X=26,
            N_SEMPOS_Y=27,
            N_GRPID=28,
            S_GRPNAME=29,
            S_GRPCOLOR=30,
            MAX = 30
        }





        public CIncADataTable()
        {
            AddColumn(new ColumnDefine() { ColumName = "FieldId", ColumType =new ColumnType(ColumnType.ID.INTEGER,false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "XrayId", ColumType =new ColumnType(ColumnType.ID.INTEGER,false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "AveGray", ColumType =new ColumnType(ColumnType.ID.INTEGER,false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "RectLeft", ColumType =new ColumnType(ColumnType.ID.INTEGER,false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "RectTop", ColumType =new ColumnType(ColumnType.ID.INTEGER,false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "RectWidth", ColumType =new ColumnType(ColumnType.ID.INTEGER,false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "RectHeight", ColumType =new ColumnType(ColumnType.ID.INTEGER,false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "Area", ColumType = new ColumnType(ColumnType.ID.FLOAT,false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "PosX", ColumType =new ColumnType(ColumnType.ID.INTEGER, false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "PosY", ColumType =new ColumnType(ColumnType.ID.INTEGER, false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "DFERET", ColumType = new ColumnType(ColumnType.ID.FLOAT, false, false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "SegmentNum", ColumType =new ColumnType(ColumnType.ID.INTEGER,false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "FieldPosX", ColumType =new ColumnType(ColumnType.ID.INTEGER, false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "FieldPosY", ColumType =new ColumnType(ColumnType.ID.INTEGER, false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "ParticleId", ColumType =new ColumnType(ColumnType.ID.INTEGER,false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "DMAX", ColumType =new ColumnType(ColumnType.ID.FLOAT, false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "DMIN", ColumType =new ColumnType(ColumnType.ID.FLOAT, false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "DPERP", ColumType =new ColumnType(ColumnType.ID.FLOAT, false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "PERIMETER", ColumType =new ColumnType(ColumnType.ID.FLOAT, false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "ORIENTATION", ColumType =new ColumnType(ColumnType.ID.FLOAT, false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "DINSCR", ColumType =new ColumnType(ColumnType.ID.FLOAT, false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "DMEAN", ColumType =new ColumnType(ColumnType.ID.FLOAT, false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "DELONG", ColumType =new ColumnType(ColumnType.ID.FLOAT, false,false), IsPrimarykey = false });
          
            AddColumn(new ColumnDefine() { ColumName = "TypeId", ColumType = new ColumnType(ColumnType.ID.INTEGER, false, false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "TypeName", ColumType =new ColumnType(ColumnType.ID.STRING,false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "TypeColor", ColumType =new ColumnType(ColumnType.ID.STRING,false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "SEMPosX", ColumType = new ColumnType(ColumnType.ID.INTEGER, false, false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "SEMPosY", ColumType = new ColumnType(ColumnType.ID.INTEGER, false, false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "GroupId", ColumType = new ColumnType(ColumnType.ID.INTEGER, false, false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "GroupName", ColumType = new ColumnType(ColumnType.ID.STRING, false, false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "GroupColor", ColumType = new ColumnType(ColumnType.ID.STRING, false, false), IsPrimarykey = false });
            SetTableName("IncAData");

        }
    }
}