using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using OTSModelSharp.DTLBase;
namespace OTSModelSharp
{
    class CMergeParticleTable : CSQLiteTable
    {
       public enum  ColumnID
        {
            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,
			N_INCA_ID = 10,
			N_ELEMENT_NUM = 11,
			N_SEGMENT_NUM = 12,
			N_FldPosX = 13,
			N_FldPosY = 14,
			N_PARTICLE_ID = 15,
			F_DMAX = 16,
			F_DMIN = 17,
			F_DPERP = 18,
			F_PERIMETER = 19,
			F_ORIENTATION = 20,
			F_DINSCR = 21,
			F_DMEAN = 22,
			F_DELONG = 23,
			F_DFERET = 24,
			S_NAME = 25,
			S_COLOR = 26,
			S_SubParticles=27,
			MAX = 27
		};

      public   CMergeParticleTable()
	{
          

            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 = "TypeId", ColumType =new ColumnType(ColumnType.ID.INTEGER,false,false), IsPrimarykey = false });
            AddColumn(new ColumnDefine() { ColumName = "ElementNum", ColumType =new ColumnType(ColumnType.ID.INTEGER,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 = true });
            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 = "DFERET", ColumType = new ColumnType(ColumnType.ID.FLOAT,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 = "SubParticles", ColumType = new ColumnType(ColumnType.ID.STRING,false,false), IsPrimarykey = false });


            SetTableName("MergedParticleInfo");

    }
}
}