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

namespace OTSModelSharp
{
    class CElementChemistryTable : CSQLiteTable
    {
      public   enum  ColumnID
        {
            INVALID = -1,
			MIN = 0,
			N_XRAY_INDEX = 0,			
			N_FIELD_ID = 1,
			N_ELEMENT_ID = 2,
			N_ELEMENT_TOTAL = 3,
			S_NAME = 4,
			F_PERCENTAGE = 5,
			MAX = 5
		};

      public   CElementChemistryTable()
	{
     

         AddColumn(new ColumnDefine() { ColumName = "XRayId", ColumType = new ColumnType(ColumnType.ID.INTEGER, false, false), IsPrimarykey = false });
         AddColumn(new ColumnDefine() { ColumName = "FieldId", ColumType =new ColumnType(ColumnType.ID.INTEGER,false,false), IsPrimarykey = false });
         AddColumn(new ColumnDefine() { ColumName = "ElementId", 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 = "Name", ColumType = new ColumnType(ColumnType.ID.STRING,false,false), IsPrimarykey = false });
         AddColumn(new ColumnDefine() { ColumName = "Percentage", ColumType = new ColumnType(ColumnType.ID.FLOAT,false,false), IsPrimarykey = false });

         SetTableName("ElementChemistry");
    }
}
}