protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarFlagID = new TableSchema.TableColumn(this);
colvarFlagID.ColumnName = "FlagID";
colvarFlagID.DataType = DbType.Int32;
colvarFlagID.MaxLength = 0;
colvarFlagID.AutoIncrement = true;
colvarFlagID.IsNullable = false;
colvarFlagID.IsPrimaryKey = false;
colvarFlagID.IsForeignKey = false;
colvarFlagID.IsReadOnly = false;
colvarFlagID.DefaultSetting = @"";
colvarFlagID.ForeignKeyTableName = "";
colvarFlagID.ApplyExtendedProperties();
this.Columns.Add(colvarFlagID);
TableSchema.TableColumn colvarFlagName = new TableSchema.TableColumn(this);
colvarFlagName.ColumnName = "FlagName";
colvarFlagName.DataType = DbType.String;
colvarFlagName.MaxLength = 150;
colvarFlagName.AutoIncrement = false;
colvarFlagName.IsNullable = true;
colvarFlagName.IsPrimaryKey = false;
colvarFlagName.IsForeignKey = false;
colvarFlagName.IsReadOnly = false;
colvarFlagName.DefaultSetting = @"";
colvarFlagName.ForeignKeyTableName = "";
colvarFlagName.ApplyExtendedProperties();
this.Columns.Add(colvarFlagName);
TableSchema.TableColumn colvarFlagMemo = new TableSchema.TableColumn(this);
colvarFlagMemo.ColumnName = "FlagMemo";
colvarFlagMemo.DataType = DbType.String;
colvarFlagMemo.MaxLength = 250;
colvarFlagMemo.AutoIncrement = false;
colvarFlagMemo.IsNullable = true;
colvarFlagMemo.IsPrimaryKey = false;
colvarFlagMemo.IsForeignKey = false;
colvarFlagMemo.IsReadOnly = false;
colvarFlagMemo.DefaultSetting = @"";
colvarFlagMemo.ForeignKeyTableName = "";
colvarFlagMemo.ApplyExtendedProperties();
this.Columns.Add(colvarFlagMemo);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarCompanyID = new TableSchema.TableColumn(this);
colvarCompanyID.ColumnName = "CompanyID";
colvarCompanyID.DataType = DbType.Int32;
colvarCompanyID.MaxLength = 0;
colvarCompanyID.AutoIncrement = false;
colvarCompanyID.IsNullable = true;
colvarCompanyID.IsPrimaryKey = false;
colvarCompanyID.IsForeignKey = false;
colvarCompanyID.IsReadOnly = false;
colvarCompanyID.DefaultSetting = @"";
colvarCompanyID.ForeignKeyTableName = "";
colvarCompanyID.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyID);
TableSchema.TableColumn colvarMansionID = new TableSchema.TableColumn(this);
colvarMansionID.ColumnName = "MansionID";
colvarMansionID.DataType = DbType.Int32;
colvarMansionID.MaxLength = 0;
colvarMansionID.AutoIncrement = false;
colvarMansionID.IsNullable = true;
colvarMansionID.IsPrimaryKey = false;
colvarMansionID.IsForeignKey = false;
colvarMansionID.IsReadOnly = false;
colvarMansionID.DefaultSetting = @"";
colvarMansionID.ForeignKeyTableName = "";
colvarMansionID.ApplyExtendedProperties();
this.Columns.Add(colvarMansionID);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarOrderSumLimit = new TableSchema.TableColumn(this);
colvarOrderSumLimit.ColumnName = "OrderSumLimit";
colvarOrderSumLimit.DataType = DbType.Decimal;
colvarOrderSumLimit.MaxLength = 0;
colvarOrderSumLimit.AutoIncrement = false;
colvarOrderSumLimit.IsNullable = true;
colvarOrderSumLimit.IsPrimaryKey = false;
colvarOrderSumLimit.IsForeignKey = false;
colvarOrderSumLimit.IsReadOnly = false;
colvarOrderSumLimit.DefaultSetting = @"";
colvarOrderSumLimit.ForeignKeyTableName = "";
colvarOrderSumLimit.ApplyExtendedProperties();
this.Columns.Add(colvarOrderSumLimit);
TableSchema.TableColumn colvarClickCountLimit = new TableSchema.TableColumn(this);
colvarClickCountLimit.ColumnName = "ClickCountLimit";
colvarClickCountLimit.DataType = DbType.Int32;
colvarClickCountLimit.MaxLength = 0;
colvarClickCountLimit.AutoIncrement = false;
colvarClickCountLimit.IsNullable = true;
colvarClickCountLimit.IsPrimaryKey = false;
colvarClickCountLimit.IsForeignKey = false;
colvarClickCountLimit.IsReadOnly = false;
colvarClickCountLimit.DefaultSetting = @"";
colvarClickCountLimit.ForeignKeyTableName = "";
colvarClickCountLimit.ApplyExtendedProperties();
this.Columns.Add(colvarClickCountLimit);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarOrderdate = new TableSchema.TableColumn(this);
colvarOrderdate.ColumnName = "Orderdate";
colvarOrderdate.DataType = DbType.DateTime;
colvarOrderdate.MaxLength = 0;
colvarOrderdate.AutoIncrement = false;
colvarOrderdate.IsNullable = true;
colvarOrderdate.IsPrimaryKey = false;
colvarOrderdate.IsForeignKey = false;
colvarOrderdate.IsReadOnly = false;
colvarOrderdate.DefaultSetting = @"";
colvarOrderdate.ForeignKeyTableName = "";
colvarOrderdate.ApplyExtendedProperties();
this.Columns.Add(colvarOrderdate);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = false;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = false;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarMemberEmail = new TableSchema.TableColumn(this);
colvarMemberEmail.ColumnName = "MemberEmail";
colvarMemberEmail.DataType = DbType.String;
colvarMemberEmail.MaxLength = 50;
colvarMemberEmail.AutoIncrement = false;
colvarMemberEmail.IsNullable = true;
colvarMemberEmail.IsPrimaryKey = false;
colvarMemberEmail.IsForeignKey = false;
colvarMemberEmail.IsReadOnly = false;
colvarMemberEmail.DefaultSetting = @"";
colvarMemberEmail.ForeignKeyTableName = "";
colvarMemberEmail.ApplyExtendedProperties();
this.Columns.Add(colvarMemberEmail);
TableSchema.TableColumn colvarMemberFullname = new TableSchema.TableColumn(this);
colvarMemberFullname.ColumnName = "MemberFullname";
colvarMemberFullname.DataType = DbType.String;
colvarMemberFullname.MaxLength = 50;
colvarMemberFullname.AutoIncrement = false;
colvarMemberFullname.IsNullable = true;
colvarMemberFullname.IsPrimaryKey = false;
colvarMemberFullname.IsForeignKey = false;
colvarMemberFullname.IsReadOnly = false;
colvarMemberFullname.DefaultSetting = @"";
colvarMemberFullname.ForeignKeyTableName = "";
colvarMemberFullname.ApplyExtendedProperties();
this.Columns.Add(colvarMemberFullname);
TableSchema.TableColumn colvarMemberPwd = new TableSchema.TableColumn(this);
colvarMemberPwd.ColumnName = "MemberPwd";
colvarMemberPwd.DataType = DbType.String;
colvarMemberPwd.MaxLength = 50;
colvarMemberPwd.AutoIncrement = false;
colvarMemberPwd.IsNullable = false;
colvarMemberPwd.IsPrimaryKey = false;
colvarMemberPwd.IsForeignKey = false;
colvarMemberPwd.IsReadOnly = false;
colvarMemberPwd.DefaultSetting = @"";
colvarMemberPwd.ForeignKeyTableName = "";
colvarMemberPwd.ApplyExtendedProperties();
this.Columns.Add(colvarMemberPwd);
TableSchema.TableColumn colvarMemberFinger = new TableSchema.TableColumn(this);
colvarMemberFinger.ColumnName = "MemberFinger";
colvarMemberFinger.DataType = DbType.AnsiString;
colvarMemberFinger.MaxLength = 600;
colvarMemberFinger.AutoIncrement = false;
colvarMemberFinger.IsNullable = true;
colvarMemberFinger.IsPrimaryKey = false;
colvarMemberFinger.IsForeignKey = false;
colvarMemberFinger.IsReadOnly = false;
colvarMemberFinger.DefaultSetting = @"";
colvarMemberFinger.ForeignKeyTableName = "";
colvarMemberFinger.ApplyExtendedProperties();
this.Columns.Add(colvarMemberFinger);
TableSchema.TableColumn colvarMemberPhoneNumber = new TableSchema.TableColumn(this);
colvarMemberPhoneNumber.ColumnName = "MemberPhoneNumber";
colvarMemberPhoneNumber.DataType = DbType.String;
colvarMemberPhoneNumber.MaxLength = 50;
colvarMemberPhoneNumber.AutoIncrement = false;
colvarMemberPhoneNumber.IsNullable = false;
colvarMemberPhoneNumber.IsPrimaryKey = false;
colvarMemberPhoneNumber.IsForeignKey = false;
colvarMemberPhoneNumber.IsReadOnly = false;
colvarMemberPhoneNumber.DefaultSetting = @"";
colvarMemberPhoneNumber.ForeignKeyTableName = "";
colvarMemberPhoneNumber.ApplyExtendedProperties();
this.Columns.Add(colvarMemberPhoneNumber);
TableSchema.TableColumn colvarMemberGrade = new TableSchema.TableColumn(this);
colvarMemberGrade.ColumnName = "MemberGrade";
colvarMemberGrade.DataType = DbType.Int32;
colvarMemberGrade.MaxLength = 0;
colvarMemberGrade.AutoIncrement = false;
colvarMemberGrade.IsNullable = true;
colvarMemberGrade.IsPrimaryKey = false;
colvarMemberGrade.IsForeignKey = false;
colvarMemberGrade.IsReadOnly = false;
colvarMemberGrade.DefaultSetting = @"";
colvarMemberGrade.ForeignKeyTableName = "";
colvarMemberGrade.ApplyExtendedProperties();
this.Columns.Add(colvarMemberGrade);
TableSchema.TableColumn colvarMemberAddress1 = new TableSchema.TableColumn(this);
colvarMemberAddress1.ColumnName = "MemberAddress1";
colvarMemberAddress1.DataType = DbType.String;
colvarMemberAddress1.MaxLength = 200;
colvarMemberAddress1.AutoIncrement = false;
colvarMemberAddress1.IsNullable = true;
colvarMemberAddress1.IsPrimaryKey = false;
colvarMemberAddress1.IsForeignKey = false;
colvarMemberAddress1.IsReadOnly = false;
colvarMemberAddress1.DefaultSetting = @"";
colvarMemberAddress1.ForeignKeyTableName = "";
colvarMemberAddress1.ApplyExtendedProperties();
this.Columns.Add(colvarMemberAddress1);
TableSchema.TableColumn colvarMemberAddress2 = new TableSchema.TableColumn(this);
colvarMemberAddress2.ColumnName = "MemberAddress2";
colvarMemberAddress2.DataType = DbType.String;
colvarMemberAddress2.MaxLength = 200;
colvarMemberAddress2.AutoIncrement = false;
colvarMemberAddress2.IsNullable = true;
colvarMemberAddress2.IsPrimaryKey = false;
colvarMemberAddress2.IsForeignKey = false;
colvarMemberAddress2.IsReadOnly = false;
colvarMemberAddress2.DefaultSetting = @"";
colvarMemberAddress2.ForeignKeyTableName = "";
colvarMemberAddress2.ApplyExtendedProperties();
this.Columns.Add(colvarMemberAddress2);
TableSchema.TableColumn colvarMemberCountry = new TableSchema.TableColumn(this);
colvarMemberCountry.ColumnName = "MemberCountry";
colvarMemberCountry.DataType = DbType.String;
colvarMemberCountry.MaxLength = 50;
colvarMemberCountry.AutoIncrement = false;
colvarMemberCountry.IsNullable = true;
colvarMemberCountry.IsPrimaryKey = false;
colvarMemberCountry.IsForeignKey = false;
colvarMemberCountry.IsReadOnly = false;
colvarMemberCountry.DefaultSetting = @"";
colvarMemberCountry.ForeignKeyTableName = "";
colvarMemberCountry.ApplyExtendedProperties();
this.Columns.Add(colvarMemberCountry);
TableSchema.TableColumn colvarMemberState = new TableSchema.TableColumn(this);
colvarMemberState.ColumnName = "MemberState";
colvarMemberState.DataType = DbType.String;
colvarMemberState.MaxLength = 50;
colvarMemberState.AutoIncrement = false;
colvarMemberState.IsNullable = true;
colvarMemberState.IsPrimaryKey = false;
colvarMemberState.IsForeignKey = false;
colvarMemberState.IsReadOnly = false;
colvarMemberState.DefaultSetting = @"";
colvarMemberState.ForeignKeyTableName = "";
colvarMemberState.ApplyExtendedProperties();
this.Columns.Add(colvarMemberState);
TableSchema.TableColumn colvarMemberCity = new TableSchema.TableColumn(this);
colvarMemberCity.ColumnName = "MemberCity";
colvarMemberCity.DataType = DbType.Int32;
colvarMemberCity.MaxLength = 0;
colvarMemberCity.AutoIncrement = false;
colvarMemberCity.IsNullable = true;
colvarMemberCity.IsPrimaryKey = false;
colvarMemberCity.IsForeignKey = false;
colvarMemberCity.IsReadOnly = false;
colvarMemberCity.DefaultSetting = @"";
colvarMemberCity.ForeignKeyTableName = "";
colvarMemberCity.ApplyExtendedProperties();
this.Columns.Add(colvarMemberCity);
TableSchema.TableColumn colvarMemberZip = new TableSchema.TableColumn(this);
colvarMemberZip.ColumnName = "MemberZip";
colvarMemberZip.DataType = DbType.String;
colvarMemberZip.MaxLength = 50;
colvarMemberZip.AutoIncrement = false;
colvarMemberZip.IsNullable = true;
colvarMemberZip.IsPrimaryKey = false;
colvarMemberZip.IsForeignKey = false;
colvarMemberZip.IsReadOnly = false;
colvarMemberZip.DefaultSetting = @"";
colvarMemberZip.ForeignKeyTableName = "";
colvarMemberZip.ApplyExtendedProperties();
this.Columns.Add(colvarMemberZip);
TableSchema.TableColumn colvarMemberDate = new TableSchema.TableColumn(this);
colvarMemberDate.ColumnName = "MemberDate";
colvarMemberDate.DataType = DbType.DateTime;
colvarMemberDate.MaxLength = 0;
colvarMemberDate.AutoIncrement = false;
colvarMemberDate.IsNullable = true;
colvarMemberDate.IsPrimaryKey = false;
colvarMemberDate.IsForeignKey = false;
colvarMemberDate.IsReadOnly = false;
colvarMemberDate.DefaultSetting = @"";
colvarMemberDate.ForeignKeyTableName = "";
colvarMemberDate.ApplyExtendedProperties();
this.Columns.Add(colvarMemberDate);
TableSchema.TableColumn colvarMemberSum = new TableSchema.TableColumn(this);
colvarMemberSum.ColumnName = "MemberSum";
colvarMemberSum.DataType = DbType.Decimal;
colvarMemberSum.MaxLength = 0;
colvarMemberSum.AutoIncrement = false;
colvarMemberSum.IsNullable = true;
colvarMemberSum.IsPrimaryKey = false;
colvarMemberSum.IsForeignKey = false;
colvarMemberSum.IsReadOnly = false;
colvarMemberSum.DefaultSetting = @"";
colvarMemberSum.ForeignKeyTableName = "";
colvarMemberSum.ApplyExtendedProperties();
this.Columns.Add(colvarMemberSum);
TableSchema.TableColumn colvarMemberBalance = new TableSchema.TableColumn(this);
colvarMemberBalance.ColumnName = "MemberBalance";
colvarMemberBalance.DataType = DbType.Decimal;
colvarMemberBalance.MaxLength = 0;
colvarMemberBalance.AutoIncrement = false;
colvarMemberBalance.IsNullable = true;
colvarMemberBalance.IsPrimaryKey = false;
colvarMemberBalance.IsForeignKey = false;
colvarMemberBalance.IsReadOnly = false;
colvarMemberBalance.DefaultSetting = @"";
colvarMemberBalance.ForeignKeyTableName = "";
colvarMemberBalance.ApplyExtendedProperties();
this.Columns.Add(colvarMemberBalance);
TableSchema.TableColumn colvarMemberBalanceCash = new TableSchema.TableColumn(this);
colvarMemberBalanceCash.ColumnName = "MemberBalanceCash";
colvarMemberBalanceCash.DataType = DbType.Decimal;
colvarMemberBalanceCash.MaxLength = 0;
colvarMemberBalanceCash.AutoIncrement = false;
colvarMemberBalanceCash.IsNullable = true;
colvarMemberBalanceCash.IsPrimaryKey = false;
colvarMemberBalanceCash.IsForeignKey = false;
colvarMemberBalanceCash.IsReadOnly = false;
colvarMemberBalanceCash.DefaultSetting = @"";
colvarMemberBalanceCash.ForeignKeyTableName = "";
colvarMemberBalanceCash.ApplyExtendedProperties();
this.Columns.Add(colvarMemberBalanceCash);
TableSchema.TableColumn colvarMemberStatus = new TableSchema.TableColumn(this);
colvarMemberStatus.ColumnName = "MemberStatus";
colvarMemberStatus.DataType = DbType.Int32;
colvarMemberStatus.MaxLength = 0;
colvarMemberStatus.AutoIncrement = false;
colvarMemberStatus.IsNullable = true;
colvarMemberStatus.IsPrimaryKey = false;
colvarMemberStatus.IsForeignKey = false;
colvarMemberStatus.IsReadOnly = false;
colvarMemberStatus.DefaultSetting = @"";
colvarMemberStatus.ForeignKeyTableName = "";
colvarMemberStatus.ApplyExtendedProperties();
this.Columns.Add(colvarMemberStatus);
TableSchema.TableColumn colvarMemberMemo = new TableSchema.TableColumn(this);
colvarMemberMemo.ColumnName = "MemberMemo";
colvarMemberMemo.DataType = DbType.String;
colvarMemberMemo.MaxLength = 50;
colvarMemberMemo.AutoIncrement = false;
colvarMemberMemo.IsNullable = true;
colvarMemberMemo.IsPrimaryKey = false;
colvarMemberMemo.IsForeignKey = false;
colvarMemberMemo.IsReadOnly = false;
colvarMemberMemo.DefaultSetting = @"";
colvarMemberMemo.ForeignKeyTableName = "";
colvarMemberMemo.ApplyExtendedProperties();
this.Columns.Add(colvarMemberMemo);
TableSchema.TableColumn colvarMemberPid = new TableSchema.TableColumn(this);
colvarMemberPid.ColumnName = "MemberPid";
colvarMemberPid.DataType = DbType.Int32;
colvarMemberPid.MaxLength = 0;
colvarMemberPid.AutoIncrement = false;
colvarMemberPid.IsNullable = true;
colvarMemberPid.IsPrimaryKey = false;
colvarMemberPid.IsForeignKey = false;
colvarMemberPid.IsReadOnly = false;
colvarMemberPid.DefaultSetting = @"";
colvarMemberPid.ForeignKeyTableName = "";
colvarMemberPid.ApplyExtendedProperties();
this.Columns.Add(colvarMemberPid);
TableSchema.TableColumn colvarMemberCompanyID = new TableSchema.TableColumn(this);
colvarMemberCompanyID.ColumnName = "MemberCompanyID";
colvarMemberCompanyID.DataType = DbType.Int32;
colvarMemberCompanyID.MaxLength = 0;
colvarMemberCompanyID.AutoIncrement = false;
colvarMemberCompanyID.IsNullable = true;
colvarMemberCompanyID.IsPrimaryKey = false;
colvarMemberCompanyID.IsForeignKey = false;
colvarMemberCompanyID.IsReadOnly = false;
colvarMemberCompanyID.DefaultSetting = @"";
colvarMemberCompanyID.ForeignKeyTableName = "";
colvarMemberCompanyID.ApplyExtendedProperties();
this.Columns.Add(colvarMemberCompanyID);
TableSchema.TableColumn colvarMemberSex = new TableSchema.TableColumn(this);
colvarMemberSex.ColumnName = "MemberSex";
colvarMemberSex.DataType = DbType.Boolean;
colvarMemberSex.MaxLength = 0;
colvarMemberSex.AutoIncrement = false;
colvarMemberSex.IsNullable = true;
colvarMemberSex.IsPrimaryKey = false;
colvarMemberSex.IsForeignKey = false;
colvarMemberSex.IsReadOnly = false;
colvarMemberSex.DefaultSetting = @"";
colvarMemberSex.ForeignKeyTableName = "";
colvarMemberSex.ApplyExtendedProperties();
this.Columns.Add(colvarMemberSex);
TableSchema.TableColumn colvarMemberBirthday = new TableSchema.TableColumn(this);
colvarMemberBirthday.ColumnName = "MemberBirthday";
colvarMemberBirthday.DataType = DbType.DateTime;
colvarMemberBirthday.MaxLength = 0;
colvarMemberBirthday.AutoIncrement = false;
colvarMemberBirthday.IsNullable = true;
colvarMemberBirthday.IsPrimaryKey = false;
colvarMemberBirthday.IsForeignKey = false;
colvarMemberBirthday.IsReadOnly = false;
colvarMemberBirthday.DefaultSetting = @"";
colvarMemberBirthday.ForeignKeyTableName = "";
colvarMemberBirthday.ApplyExtendedProperties();
this.Columns.Add(colvarMemberBirthday);
TableSchema.TableColumn colvarMemberRoleId = new TableSchema.TableColumn(this);
colvarMemberRoleId.ColumnName = "MemberRole_ID";
colvarMemberRoleId.DataType = DbType.Int32;
colvarMemberRoleId.MaxLength = 0;
colvarMemberRoleId.AutoIncrement = false;
colvarMemberRoleId.IsNullable = true;
colvarMemberRoleId.IsPrimaryKey = false;
colvarMemberRoleId.IsForeignKey = false;
colvarMemberRoleId.IsReadOnly = false;
colvarMemberRoleId.DefaultSetting = @"";
colvarMemberRoleId.ForeignKeyTableName = "";
colvarMemberRoleId.ApplyExtendedProperties();
this.Columns.Add(colvarMemberRoleId);
TableSchema.TableColumn colvarCompanyRoleId = new TableSchema.TableColumn(this);
colvarCompanyRoleId.ColumnName = "CompanyRole_ID";
colvarCompanyRoleId.DataType = DbType.Int32;
colvarCompanyRoleId.MaxLength = 0;
colvarCompanyRoleId.AutoIncrement = false;
colvarCompanyRoleId.IsNullable = true;
colvarCompanyRoleId.IsPrimaryKey = false;
colvarCompanyRoleId.IsForeignKey = false;
colvarCompanyRoleId.IsReadOnly = false;
colvarCompanyRoleId.DefaultSetting = @"";
colvarCompanyRoleId.ForeignKeyTableName = "";
colvarCompanyRoleId.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyRoleId);
TableSchema.TableColumn colvarAdminRoleId = new TableSchema.TableColumn(this);
colvarAdminRoleId.ColumnName = "AdminRole_ID";
colvarAdminRoleId.DataType = DbType.Int32;
colvarAdminRoleId.MaxLength = 0;
colvarAdminRoleId.AutoIncrement = false;
colvarAdminRoleId.IsNullable = true;
colvarAdminRoleId.IsPrimaryKey = false;
colvarAdminRoleId.IsForeignKey = false;
colvarAdminRoleId.IsReadOnly = false;
colvarAdminRoleId.DefaultSetting = @"";
colvarAdminRoleId.ForeignKeyTableName = "";
colvarAdminRoleId.ApplyExtendedProperties();
this.Columns.Add(colvarAdminRoleId);
TableSchema.TableColumn colvarLastLoginDate = new TableSchema.TableColumn(this);
colvarLastLoginDate.ColumnName = "LastLoginDate";
colvarLastLoginDate.DataType = DbType.DateTime;
colvarLastLoginDate.MaxLength = 0;
colvarLastLoginDate.AutoIncrement = false;
colvarLastLoginDate.IsNullable = true;
colvarLastLoginDate.IsPrimaryKey = false;
colvarLastLoginDate.IsForeignKey = false;
colvarLastLoginDate.IsReadOnly = false;
colvarLastLoginDate.DefaultSetting = @"";
colvarLastLoginDate.ForeignKeyTableName = "";
colvarLastLoginDate.ApplyExtendedProperties();
this.Columns.Add(colvarLastLoginDate);
TableSchema.TableColumn colvarLastLoginSubSys = new TableSchema.TableColumn(this);
colvarLastLoginSubSys.ColumnName = "LastLoginSubSys";
colvarLastLoginSubSys.DataType = DbType.Int32;
colvarLastLoginSubSys.MaxLength = 0;
colvarLastLoginSubSys.AutoIncrement = false;
colvarLastLoginSubSys.IsNullable = true;
colvarLastLoginSubSys.IsPrimaryKey = false;
colvarLastLoginSubSys.IsForeignKey = false;
colvarLastLoginSubSys.IsReadOnly = false;
colvarLastLoginSubSys.DefaultSetting = @"";
colvarLastLoginSubSys.ForeignKeyTableName = "";
colvarLastLoginSubSys.ApplyExtendedProperties();
this.Columns.Add(colvarLastLoginSubSys);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
TableSchema.TableColumn colvarCompanyId = new TableSchema.TableColumn(this);
colvarCompanyId.ColumnName = "Company_ID";
colvarCompanyId.DataType = DbType.Int32;
colvarCompanyId.MaxLength = 0;
colvarCompanyId.AutoIncrement = false;
colvarCompanyId.IsNullable = true;
colvarCompanyId.IsPrimaryKey = false;
colvarCompanyId.IsForeignKey = false;
colvarCompanyId.IsReadOnly = false;
colvarCompanyId.DefaultSetting = @"";
colvarCompanyId.ForeignKeyTableName = "";
colvarCompanyId.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyId);
TableSchema.TableColumn colvarMemberArea = new TableSchema.TableColumn(this);
colvarMemberArea.ColumnName = "MemberArea";
colvarMemberArea.DataType = DbType.String;
colvarMemberArea.MaxLength = 50;
colvarMemberArea.AutoIncrement = false;
colvarMemberArea.IsNullable = true;
colvarMemberArea.IsPrimaryKey = false;
colvarMemberArea.IsForeignKey = false;
colvarMemberArea.IsReadOnly = false;
colvarMemberArea.DefaultSetting = @"";
colvarMemberArea.ForeignKeyTableName = "";
colvarMemberArea.ApplyExtendedProperties();
this.Columns.Add(colvarMemberArea);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarMemberCompanyMemberID = new TableSchema.TableColumn(this);
colvarMemberCompanyMemberID.ColumnName = "MemberCompany_MemberID";
colvarMemberCompanyMemberID.DataType = DbType.Int32;
colvarMemberCompanyMemberID.MaxLength = 0;
colvarMemberCompanyMemberID.AutoIncrement = false;
colvarMemberCompanyMemberID.IsNullable = true;
colvarMemberCompanyMemberID.IsPrimaryKey = false;
colvarMemberCompanyMemberID.IsForeignKey = false;
colvarMemberCompanyMemberID.IsReadOnly = false;
colvarMemberCompanyMemberID.DefaultSetting = @"";
colvarMemberCompanyMemberID.ForeignKeyTableName = "";
colvarMemberCompanyMemberID.ApplyExtendedProperties();
this.Columns.Add(colvarMemberCompanyMemberID);
TableSchema.TableColumn colvarMemberCompanyCompanyID = new TableSchema.TableColumn(this);
colvarMemberCompanyCompanyID.ColumnName = "MemberCompany_CompanyID";
colvarMemberCompanyCompanyID.DataType = DbType.Int32;
colvarMemberCompanyCompanyID.MaxLength = 0;
colvarMemberCompanyCompanyID.AutoIncrement = false;
colvarMemberCompanyCompanyID.IsNullable = true;
colvarMemberCompanyCompanyID.IsPrimaryKey = false;
colvarMemberCompanyCompanyID.IsForeignKey = false;
colvarMemberCompanyCompanyID.IsReadOnly = false;
colvarMemberCompanyCompanyID.DefaultSetting = @"";
colvarMemberCompanyCompanyID.ForeignKeyTableName = "";
colvarMemberCompanyCompanyID.ApplyExtendedProperties();
this.Columns.Add(colvarMemberCompanyCompanyID);
TableSchema.TableColumn colvarMemberCompanyDate = new TableSchema.TableColumn(this);
colvarMemberCompanyDate.ColumnName = "MemberCompany_Date";
colvarMemberCompanyDate.DataType = DbType.DateTime;
colvarMemberCompanyDate.MaxLength = 0;
colvarMemberCompanyDate.AutoIncrement = false;
colvarMemberCompanyDate.IsNullable = true;
colvarMemberCompanyDate.IsPrimaryKey = false;
colvarMemberCompanyDate.IsForeignKey = false;
colvarMemberCompanyDate.IsReadOnly = false;
colvarMemberCompanyDate.DefaultSetting = @"";
colvarMemberCompanyDate.ForeignKeyTableName = "";
colvarMemberCompanyDate.ApplyExtendedProperties();
this.Columns.Add(colvarMemberCompanyDate);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
TableSchema.TableColumn colvarMemberGrade = new TableSchema.TableColumn(this);
colvarMemberGrade.ColumnName = "MemberGrade";
colvarMemberGrade.DataType = DbType.Int32;
colvarMemberGrade.MaxLength = 0;
colvarMemberGrade.AutoIncrement = false;
colvarMemberGrade.IsNullable = true;
colvarMemberGrade.IsPrimaryKey = false;
colvarMemberGrade.IsForeignKey = false;
colvarMemberGrade.IsReadOnly = false;
colvarMemberGrade.DefaultSetting = @"";
colvarMemberGrade.ForeignKeyTableName = "";
colvarMemberGrade.ApplyExtendedProperties();
this.Columns.Add(colvarMemberGrade);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarItemID = new TableSchema.TableColumn(this);
colvarItemID.ColumnName = "ItemID";
colvarItemID.DataType = DbType.Int32;
colvarItemID.MaxLength = 0;
colvarItemID.AutoIncrement = false;
colvarItemID.IsNullable = false;
colvarItemID.IsPrimaryKey = false;
colvarItemID.IsForeignKey = false;
colvarItemID.IsReadOnly = false;
colvarItemID.DefaultSetting = @"";
colvarItemID.ForeignKeyTableName = "";
colvarItemID.ApplyExtendedProperties();
this.Columns.Add(colvarItemID);
TableSchema.TableColumn colvarCompanyItemID = new TableSchema.TableColumn(this);
colvarCompanyItemID.ColumnName = "CompanyItemID";
colvarCompanyItemID.DataType = DbType.Int32;
colvarCompanyItemID.MaxLength = 0;
colvarCompanyItemID.AutoIncrement = false;
colvarCompanyItemID.IsNullable = false;
colvarCompanyItemID.IsPrimaryKey = false;
colvarCompanyItemID.IsForeignKey = false;
colvarCompanyItemID.IsReadOnly = false;
colvarCompanyItemID.DefaultSetting = @"";
colvarCompanyItemID.ForeignKeyTableName = "";
colvarCompanyItemID.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyItemID);
TableSchema.TableColumn colvarMemberID = new TableSchema.TableColumn(this);
colvarMemberID.ColumnName = "MemberID";
colvarMemberID.DataType = DbType.Int32;
colvarMemberID.MaxLength = 0;
colvarMemberID.AutoIncrement = false;
colvarMemberID.IsNullable = false;
colvarMemberID.IsPrimaryKey = false;
colvarMemberID.IsForeignKey = false;
colvarMemberID.IsReadOnly = false;
colvarMemberID.DefaultSetting = @"";
colvarMemberID.ForeignKeyTableName = "";
colvarMemberID.ApplyExtendedProperties();
this.Columns.Add(colvarMemberID);
TableSchema.TableColumn colvarItemDate = new TableSchema.TableColumn(this);
colvarItemDate.ColumnName = "ItemDate";
colvarItemDate.DataType = DbType.DateTime;
colvarItemDate.MaxLength = 0;
colvarItemDate.AutoIncrement = false;
colvarItemDate.IsNullable = false;
colvarItemDate.IsPrimaryKey = false;
colvarItemDate.IsForeignKey = false;
colvarItemDate.IsReadOnly = false;
colvarItemDate.DefaultSetting = @"";
colvarItemDate.ForeignKeyTableName = "";
colvarItemDate.ApplyExtendedProperties();
this.Columns.Add(colvarItemDate);
TableSchema.TableColumn colvarItemStatus = new TableSchema.TableColumn(this);
colvarItemStatus.ColumnName = "ItemStatus";
colvarItemStatus.DataType = DbType.Int32;
colvarItemStatus.MaxLength = 0;
colvarItemStatus.AutoIncrement = false;
colvarItemStatus.IsNullable = false;
colvarItemStatus.IsPrimaryKey = false;
colvarItemStatus.IsForeignKey = false;
colvarItemStatus.IsReadOnly = false;
colvarItemStatus.DefaultSetting = @"";
colvarItemStatus.ForeignKeyTableName = "";
colvarItemStatus.ApplyExtendedProperties();
this.Columns.Add(colvarItemStatus);
TableSchema.TableColumn colvarSetDate = new TableSchema.TableColumn(this);
colvarSetDate.ColumnName = "SetDate";
colvarSetDate.DataType = DbType.DateTime;
colvarSetDate.MaxLength = 0;
colvarSetDate.AutoIncrement = false;
colvarSetDate.IsNullable = true;
colvarSetDate.IsPrimaryKey = false;
colvarSetDate.IsForeignKey = false;
colvarSetDate.IsReadOnly = false;
colvarSetDate.DefaultSetting = @"";
colvarSetDate.ForeignKeyTableName = "";
colvarSetDate.ApplyExtendedProperties();
this.Columns.Add(colvarSetDate);
TableSchema.TableColumn colvarOrderSum = new TableSchema.TableColumn(this);
colvarOrderSum.ColumnName = "OrderSum";
colvarOrderSum.DataType = DbType.Decimal;
colvarOrderSum.MaxLength = 0;
colvarOrderSum.AutoIncrement = false;
colvarOrderSum.IsNullable = true;
colvarOrderSum.IsPrimaryKey = false;
colvarOrderSum.IsForeignKey = false;
colvarOrderSum.IsReadOnly = false;
colvarOrderSum.DefaultSetting = @"";
colvarOrderSum.ForeignKeyTableName = "";
colvarOrderSum.ApplyExtendedProperties();
this.Columns.Add(colvarOrderSum);
TableSchema.TableColumn colvarCompanyID = new TableSchema.TableColumn(this);
colvarCompanyID.ColumnName = "CompanyID";
colvarCompanyID.DataType = DbType.Int32;
colvarCompanyID.MaxLength = 0;
colvarCompanyID.AutoIncrement = false;
colvarCompanyID.IsNullable = true;
colvarCompanyID.IsPrimaryKey = false;
colvarCompanyID.IsForeignKey = false;
colvarCompanyID.IsReadOnly = false;
colvarCompanyID.DefaultSetting = @"";
colvarCompanyID.ForeignKeyTableName = "";
colvarCompanyID.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyID);
TableSchema.TableColumn colvarItemPoint = new TableSchema.TableColumn(this);
colvarItemPoint.ColumnName = "ItemPoint";
colvarItemPoint.DataType = DbType.Decimal;
colvarItemPoint.MaxLength = 0;
colvarItemPoint.AutoIncrement = false;
colvarItemPoint.IsNullable = true;
colvarItemPoint.IsPrimaryKey = false;
colvarItemPoint.IsForeignKey = false;
colvarItemPoint.IsReadOnly = false;
colvarItemPoint.DefaultSetting = @"";
colvarItemPoint.ForeignKeyTableName = "";
colvarItemPoint.ApplyExtendedProperties();
this.Columns.Add(colvarItemPoint);
TableSchema.TableColumn colvarPaymentID = new TableSchema.TableColumn(this);
colvarPaymentID.ColumnName = "PaymentID";
colvarPaymentID.DataType = DbType.Int32;
colvarPaymentID.MaxLength = 0;
colvarPaymentID.AutoIncrement = false;
colvarPaymentID.IsNullable = true;
colvarPaymentID.IsPrimaryKey = false;
colvarPaymentID.IsForeignKey = false;
colvarPaymentID.IsReadOnly = false;
colvarPaymentID.DefaultSetting = @"";
colvarPaymentID.ForeignKeyTableName = "";
colvarPaymentID.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentID);
TableSchema.TableColumn colvarIsCanModifiedDate = new TableSchema.TableColumn(this);
colvarIsCanModifiedDate.ColumnName = "IsCanModifiedDate";
colvarIsCanModifiedDate.DataType = DbType.Boolean;
colvarIsCanModifiedDate.MaxLength = 0;
colvarIsCanModifiedDate.AutoIncrement = false;
colvarIsCanModifiedDate.IsNullable = true;
colvarIsCanModifiedDate.IsPrimaryKey = false;
colvarIsCanModifiedDate.IsForeignKey = false;
colvarIsCanModifiedDate.IsReadOnly = false;
colvarIsCanModifiedDate.DefaultSetting = @"";
colvarIsCanModifiedDate.ForeignKeyTableName = "";
colvarIsCanModifiedDate.ApplyExtendedProperties();
this.Columns.Add(colvarIsCanModifiedDate);
TableSchema.TableColumn colvarOrderDate = new TableSchema.TableColumn(this);
colvarOrderDate.ColumnName = "OrderDate";
colvarOrderDate.DataType = DbType.DateTime;
colvarOrderDate.MaxLength = 0;
colvarOrderDate.AutoIncrement = false;
colvarOrderDate.IsNullable = true;
colvarOrderDate.IsPrimaryKey = false;
colvarOrderDate.IsForeignKey = false;
colvarOrderDate.IsReadOnly = false;
colvarOrderDate.DefaultSetting = @"";
colvarOrderDate.ForeignKeyTableName = "";
colvarOrderDate.ApplyExtendedProperties();
this.Columns.Add(colvarOrderDate);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarDateX = new TableSchema.TableColumn(this);
colvarDateX.ColumnName = "Date";
colvarDateX.DataType = DbType.DateTime;
colvarDateX.MaxLength = 0;
colvarDateX.AutoIncrement = false;
colvarDateX.IsNullable = true;
colvarDateX.IsPrimaryKey = false;
colvarDateX.IsForeignKey = false;
colvarDateX.IsReadOnly = false;
colvarDateX.DefaultSetting = @"";
colvarDateX.ForeignKeyTableName = "";
colvarDateX.ApplyExtendedProperties();
this.Columns.Add(colvarDateX);
TableSchema.TableColumn colvarDesc = new TableSchema.TableColumn(this);
colvarDesc.ColumnName = "Desc";
colvarDesc.DataType = DbType.String;
colvarDesc.MaxLength = 2000;
colvarDesc.AutoIncrement = false;
colvarDesc.IsNullable = true;
colvarDesc.IsPrimaryKey = false;
colvarDesc.IsForeignKey = false;
colvarDesc.IsReadOnly = false;
colvarDesc.DefaultSetting = @"";
colvarDesc.ForeignKeyTableName = "";
colvarDesc.ApplyExtendedProperties();
this.Columns.Add(colvarDesc);
TableSchema.TableColumn colvarIsCurrent = new TableSchema.TableColumn(this);
colvarIsCurrent.ColumnName = "IsCurrent";
colvarIsCurrent.DataType = DbType.Int32;
colvarIsCurrent.MaxLength = 0;
colvarIsCurrent.AutoIncrement = false;
colvarIsCurrent.IsNullable = true;
colvarIsCurrent.IsPrimaryKey = false;
colvarIsCurrent.IsForeignKey = false;
colvarIsCurrent.IsReadOnly = false;
colvarIsCurrent.DefaultSetting = @"";
colvarIsCurrent.ForeignKeyTableName = "";
colvarIsCurrent.ApplyExtendedProperties();
this.Columns.Add(colvarIsCurrent);
TableSchema.TableColumn colvarOrderId = new TableSchema.TableColumn(this);
colvarOrderId.ColumnName = "OrderId";
colvarOrderId.DataType = DbType.Int32;
colvarOrderId.MaxLength = 0;
colvarOrderId.AutoIncrement = false;
colvarOrderId.IsNullable = true;
colvarOrderId.IsPrimaryKey = false;
colvarOrderId.IsForeignKey = false;
colvarOrderId.IsReadOnly = false;
colvarOrderId.DefaultSetting = @"";
colvarOrderId.ForeignKeyTableName = "";
colvarOrderId.ApplyExtendedProperties();
this.Columns.Add(colvarOrderId);
TableSchema.TableColumn colvarVoice = new TableSchema.TableColumn(this);
colvarVoice.ColumnName = "Voice";
colvarVoice.DataType = DbType.String;
colvarVoice.MaxLength = 500;
colvarVoice.AutoIncrement = false;
colvarVoice.IsNullable = true;
colvarVoice.IsPrimaryKey = false;
colvarVoice.IsForeignKey = false;
colvarVoice.IsReadOnly = false;
colvarVoice.DefaultSetting = @"";
colvarVoice.ForeignKeyTableName = "";
colvarVoice.ApplyExtendedProperties();
this.Columns.Add(colvarVoice);
TableSchema.TableColumn colvarIsPlay = new TableSchema.TableColumn(this);
colvarIsPlay.ColumnName = "IsPlay";
colvarIsPlay.DataType = DbType.Boolean;
colvarIsPlay.MaxLength = 0;
colvarIsPlay.AutoIncrement = false;
colvarIsPlay.IsNullable = true;
colvarIsPlay.IsPrimaryKey = false;
colvarIsPlay.IsForeignKey = false;
colvarIsPlay.IsReadOnly = false;
colvarIsPlay.DefaultSetting = @"";
colvarIsPlay.ForeignKeyTableName = "";
colvarIsPlay.ApplyExtendedProperties();
this.Columns.Add(colvarIsPlay);
TableSchema.TableColumn colvarFromUser = new TableSchema.TableColumn(this);
colvarFromUser.ColumnName = "FromUser";
colvarFromUser.DataType = DbType.Int32;
colvarFromUser.MaxLength = 0;
colvarFromUser.AutoIncrement = false;
colvarFromUser.IsNullable = true;
colvarFromUser.IsPrimaryKey = false;
colvarFromUser.IsForeignKey = false;
colvarFromUser.IsReadOnly = false;
colvarFromUser.DefaultSetting = @"";
colvarFromUser.ForeignKeyTableName = "";
colvarFromUser.ApplyExtendedProperties();
this.Columns.Add(colvarFromUser);
TableSchema.TableColumn colvarToUser = new TableSchema.TableColumn(this);
colvarToUser.ColumnName = "ToUser";
colvarToUser.DataType = DbType.Int32;
colvarToUser.MaxLength = 0;
colvarToUser.AutoIncrement = false;
colvarToUser.IsNullable = true;
colvarToUser.IsPrimaryKey = false;
colvarToUser.IsForeignKey = false;
colvarToUser.IsReadOnly = false;
colvarToUser.DefaultSetting = @"";
colvarToUser.ForeignKeyTableName = "";
colvarToUser.ApplyExtendedProperties();
this.Columns.Add(colvarToUser);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = false;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = false;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarFaceBookDate = new TableSchema.TableColumn(this);
colvarFaceBookDate.ColumnName = "FaceBookDate";
colvarFaceBookDate.DataType = DbType.DateTime;
colvarFaceBookDate.MaxLength = 0;
colvarFaceBookDate.AutoIncrement = false;
colvarFaceBookDate.IsNullable = true;
colvarFaceBookDate.IsPrimaryKey = false;
colvarFaceBookDate.IsForeignKey = false;
colvarFaceBookDate.IsReadOnly = false;
colvarFaceBookDate.DefaultSetting = @"";
colvarFaceBookDate.ForeignKeyTableName = "";
colvarFaceBookDate.ApplyExtendedProperties();
this.Columns.Add(colvarFaceBookDate);
TableSchema.TableColumn colvarFaceBookMemo = new TableSchema.TableColumn(this);
colvarFaceBookMemo.ColumnName = "FaceBookMemo";
colvarFaceBookMemo.DataType = DbType.String;
colvarFaceBookMemo.MaxLength = 300;
colvarFaceBookMemo.AutoIncrement = false;
colvarFaceBookMemo.IsNullable = true;
colvarFaceBookMemo.IsPrimaryKey = false;
colvarFaceBookMemo.IsForeignKey = false;
colvarFaceBookMemo.IsReadOnly = false;
colvarFaceBookMemo.DefaultSetting = @"";
colvarFaceBookMemo.ForeignKeyTableName = "";
colvarFaceBookMemo.ApplyExtendedProperties();
this.Columns.Add(colvarFaceBookMemo);
TableSchema.TableColumn colvarFaceBookBizID = new TableSchema.TableColumn(this);
colvarFaceBookBizID.ColumnName = "FaceBookBizID";
colvarFaceBookBizID.DataType = DbType.Int32;
colvarFaceBookBizID.MaxLength = 0;
colvarFaceBookBizID.AutoIncrement = false;
colvarFaceBookBizID.IsNullable = true;
colvarFaceBookBizID.IsPrimaryKey = false;
colvarFaceBookBizID.IsForeignKey = false;
colvarFaceBookBizID.IsReadOnly = false;
colvarFaceBookBizID.DefaultSetting = @"";
colvarFaceBookBizID.ForeignKeyTableName = "";
colvarFaceBookBizID.ApplyExtendedProperties();
this.Columns.Add(colvarFaceBookBizID);
TableSchema.TableColumn colvarFaceBookMemberID = new TableSchema.TableColumn(this);
colvarFaceBookMemberID.ColumnName = "FaceBookMemberID";
colvarFaceBookMemberID.DataType = DbType.Int32;
colvarFaceBookMemberID.MaxLength = 0;
colvarFaceBookMemberID.AutoIncrement = false;
colvarFaceBookMemberID.IsNullable = true;
colvarFaceBookMemberID.IsPrimaryKey = false;
colvarFaceBookMemberID.IsForeignKey = false;
colvarFaceBookMemberID.IsReadOnly = false;
colvarFaceBookMemberID.DefaultSetting = @"";
colvarFaceBookMemberID.ForeignKeyTableName = "";
colvarFaceBookMemberID.ApplyExtendedProperties();
this.Columns.Add(colvarFaceBookMemberID);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
TableSchema.TableColumn colvarFaceBookBizType = new TableSchema.TableColumn(this);
colvarFaceBookBizType.ColumnName = "FaceBookBizType";
colvarFaceBookBizType.DataType = DbType.Int32;
colvarFaceBookBizType.MaxLength = 0;
colvarFaceBookBizType.AutoIncrement = false;
colvarFaceBookBizType.IsNullable = true;
colvarFaceBookBizType.IsPrimaryKey = false;
colvarFaceBookBizType.IsForeignKey = false;
colvarFaceBookBizType.IsReadOnly = false;
colvarFaceBookBizType.DefaultSetting = @"";
colvarFaceBookBizType.ForeignKeyTableName = "";
colvarFaceBookBizType.ApplyExtendedProperties();
this.Columns.Add(colvarFaceBookBizType);
TableSchema.TableColumn colvarReplyMemberID = new TableSchema.TableColumn(this);
colvarReplyMemberID.ColumnName = "ReplyMemberID";
colvarReplyMemberID.DataType = DbType.Int32;
colvarReplyMemberID.MaxLength = 0;
colvarReplyMemberID.AutoIncrement = false;
colvarReplyMemberID.IsNullable = true;
colvarReplyMemberID.IsPrimaryKey = false;
colvarReplyMemberID.IsForeignKey = false;
colvarReplyMemberID.IsReadOnly = false;
colvarReplyMemberID.DefaultSetting = @"";
colvarReplyMemberID.ForeignKeyTableName = "";
colvarReplyMemberID.ApplyExtendedProperties();
this.Columns.Add(colvarReplyMemberID);
TableSchema.TableColumn colvarReplyMemo = new TableSchema.TableColumn(this);
colvarReplyMemo.ColumnName = "ReplyMemo";
colvarReplyMemo.DataType = DbType.String;
colvarReplyMemo.MaxLength = 300;
colvarReplyMemo.AutoIncrement = false;
colvarReplyMemo.IsNullable = true;
colvarReplyMemo.IsPrimaryKey = false;
colvarReplyMemo.IsForeignKey = false;
colvarReplyMemo.IsReadOnly = false;
colvarReplyMemo.DefaultSetting = @"";
colvarReplyMemo.ForeignKeyTableName = "";
colvarReplyMemo.ApplyExtendedProperties();
this.Columns.Add(colvarReplyMemo);
TableSchema.TableColumn colvarReplyDate = new TableSchema.TableColumn(this);
colvarReplyDate.ColumnName = "ReplyDate";
colvarReplyDate.DataType = DbType.DateTime;
colvarReplyDate.MaxLength = 0;
colvarReplyDate.AutoIncrement = false;
colvarReplyDate.IsNullable = true;
colvarReplyDate.IsPrimaryKey = false;
colvarReplyDate.IsForeignKey = false;
colvarReplyDate.IsReadOnly = false;
colvarReplyDate.DefaultSetting = @"";
colvarReplyDate.ForeignKeyTableName = "";
colvarReplyDate.ApplyExtendedProperties();
this.Columns.Add(colvarReplyDate);
TableSchema.TableColumn colvarFaceBookRate = new TableSchema.TableColumn(this);
colvarFaceBookRate.ColumnName = "FaceBookRate";
colvarFaceBookRate.DataType = DbType.Int32;
colvarFaceBookRate.MaxLength = 0;
colvarFaceBookRate.AutoIncrement = false;
colvarFaceBookRate.IsNullable = true;
colvarFaceBookRate.IsPrimaryKey = false;
colvarFaceBookRate.IsForeignKey = false;
colvarFaceBookRate.IsReadOnly = false;
colvarFaceBookRate.DefaultSetting = @"";
colvarFaceBookRate.ForeignKeyTableName = "";
colvarFaceBookRate.ApplyExtendedProperties();
this.Columns.Add(colvarFaceBookRate);
TableSchema.TableColumn colvarLatestOrderDate = new TableSchema.TableColumn(this);
colvarLatestOrderDate.ColumnName = "LatestOrderDate";
colvarLatestOrderDate.DataType = DbType.DateTime;
colvarLatestOrderDate.MaxLength = 0;
colvarLatestOrderDate.AutoIncrement = false;
colvarLatestOrderDate.IsNullable = true;
colvarLatestOrderDate.IsPrimaryKey = false;
colvarLatestOrderDate.IsForeignKey = false;
colvarLatestOrderDate.IsReadOnly = false;
colvarLatestOrderDate.DefaultSetting = @"";
colvarLatestOrderDate.ForeignKeyTableName = "";
colvarLatestOrderDate.ApplyExtendedProperties();
this.Columns.Add(colvarLatestOrderDate);
TableSchema.TableColumn colvarPBizID = new TableSchema.TableColumn(this);
colvarPBizID.ColumnName = "PBizID";
colvarPBizID.DataType = DbType.Int32;
colvarPBizID.MaxLength = 0;
colvarPBizID.AutoIncrement = false;
colvarPBizID.IsNullable = true;
colvarPBizID.IsPrimaryKey = false;
colvarPBizID.IsForeignKey = false;
colvarPBizID.IsReadOnly = false;
colvarPBizID.DefaultSetting = @"";
colvarPBizID.ForeignKeyTableName = "";
colvarPBizID.ApplyExtendedProperties();
this.Columns.Add(colvarPBizID);
TableSchema.TableColumn colvarIsRead = new TableSchema.TableColumn(this);
colvarIsRead.ColumnName = "IsRead";
colvarIsRead.DataType = DbType.Boolean;
colvarIsRead.MaxLength = 0;
colvarIsRead.AutoIncrement = false;
colvarIsRead.IsNullable = true;
colvarIsRead.IsPrimaryKey = false;
colvarIsRead.IsForeignKey = false;
colvarIsRead.IsReadOnly = false;
colvarIsRead.DefaultSetting = @"";
colvarIsRead.ForeignKeyTableName = "";
colvarIsRead.ApplyExtendedProperties();
this.Columns.Add(colvarIsRead);
TableSchema.TableColumn colvarTopDate = new TableSchema.TableColumn(this);
colvarTopDate.ColumnName = "TopDate";
colvarTopDate.DataType = DbType.DateTime;
colvarTopDate.MaxLength = 0;
colvarTopDate.AutoIncrement = false;
colvarTopDate.IsNullable = true;
colvarTopDate.IsPrimaryKey = false;
colvarTopDate.IsForeignKey = false;
colvarTopDate.IsReadOnly = false;
colvarTopDate.DefaultSetting = @"";
colvarTopDate.ForeignKeyTableName = "";
colvarTopDate.ApplyExtendedProperties();
this.Columns.Add(colvarTopDate);
TableSchema.TableColumn colvarPFaceBookMemberID = new TableSchema.TableColumn(this);
colvarPFaceBookMemberID.ColumnName = "PFaceBookMemberID";
colvarPFaceBookMemberID.DataType = DbType.Int32;
colvarPFaceBookMemberID.MaxLength = 0;
colvarPFaceBookMemberID.AutoIncrement = false;
colvarPFaceBookMemberID.IsNullable = true;
colvarPFaceBookMemberID.IsPrimaryKey = false;
colvarPFaceBookMemberID.IsForeignKey = false;
colvarPFaceBookMemberID.IsReadOnly = false;
colvarPFaceBookMemberID.DefaultSetting = @"";
colvarPFaceBookMemberID.ForeignKeyTableName = "";
colvarPFaceBookMemberID.ApplyExtendedProperties();
this.Columns.Add(colvarPFaceBookMemberID);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarCompanyCode = new TableSchema.TableColumn(this);
colvarCompanyCode.ColumnName = "CompanyCode";
colvarCompanyCode.DataType = DbType.String;
colvarCompanyCode.MaxLength = 10;
colvarCompanyCode.AutoIncrement = false;
colvarCompanyCode.IsNullable = true;
colvarCompanyCode.IsPrimaryKey = false;
colvarCompanyCode.IsForeignKey = false;
colvarCompanyCode.IsReadOnly = false;
colvarCompanyCode.DefaultSetting = @"";
colvarCompanyCode.ForeignKeyTableName = "";
colvarCompanyCode.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyCode);
TableSchema.TableColumn colvarCompanyName = new TableSchema.TableColumn(this);
colvarCompanyName.ColumnName = "CompanyName";
colvarCompanyName.DataType = DbType.String;
colvarCompanyName.MaxLength = 50;
colvarCompanyName.AutoIncrement = false;
colvarCompanyName.IsNullable = false;
colvarCompanyName.IsPrimaryKey = false;
colvarCompanyName.IsForeignKey = false;
colvarCompanyName.IsReadOnly = false;
colvarCompanyName.DefaultSetting = @"";
colvarCompanyName.ForeignKeyTableName = "";
colvarCompanyName.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyName);
TableSchema.TableColumn colvarCompanyPwd = new TableSchema.TableColumn(this);
colvarCompanyPwd.ColumnName = "CompanyPwd";
colvarCompanyPwd.DataType = DbType.String;
colvarCompanyPwd.MaxLength = 50;
colvarCompanyPwd.AutoIncrement = false;
colvarCompanyPwd.IsNullable = false;
colvarCompanyPwd.IsPrimaryKey = false;
colvarCompanyPwd.IsForeignKey = false;
colvarCompanyPwd.IsReadOnly = false;
colvarCompanyPwd.DefaultSetting = @"";
colvarCompanyPwd.ForeignKeyTableName = "";
colvarCompanyPwd.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyPwd);
TableSchema.TableColumn colvarCompanyEmail = new TableSchema.TableColumn(this);
colvarCompanyEmail.ColumnName = "CompanyEmail";
colvarCompanyEmail.DataType = DbType.String;
colvarCompanyEmail.MaxLength = 50;
colvarCompanyEmail.AutoIncrement = false;
colvarCompanyEmail.IsNullable = true;
colvarCompanyEmail.IsPrimaryKey = false;
colvarCompanyEmail.IsForeignKey = false;
colvarCompanyEmail.IsReadOnly = false;
colvarCompanyEmail.DefaultSetting = @"";
colvarCompanyEmail.ForeignKeyTableName = "";
colvarCompanyEmail.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyEmail);
TableSchema.TableColumn colvarCompanyProvince = new TableSchema.TableColumn(this);
colvarCompanyProvince.ColumnName = "CompanyProvince";
colvarCompanyProvince.DataType = DbType.String;
colvarCompanyProvince.MaxLength = 50;
colvarCompanyProvince.AutoIncrement = false;
colvarCompanyProvince.IsNullable = true;
colvarCompanyProvince.IsPrimaryKey = false;
colvarCompanyProvince.IsForeignKey = false;
colvarCompanyProvince.IsReadOnly = false;
colvarCompanyProvince.DefaultSetting = @"";
colvarCompanyProvince.ForeignKeyTableName = "";
colvarCompanyProvince.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyProvince);
TableSchema.TableColumn colvarCompanyCity = new TableSchema.TableColumn(this);
colvarCompanyCity.ColumnName = "CompanyCity";
colvarCompanyCity.DataType = DbType.Int32;
colvarCompanyCity.MaxLength = 0;
colvarCompanyCity.AutoIncrement = false;
colvarCompanyCity.IsNullable = true;
colvarCompanyCity.IsPrimaryKey = false;
colvarCompanyCity.IsForeignKey = false;
colvarCompanyCity.IsReadOnly = false;
colvarCompanyCity.DefaultSetting = @"";
colvarCompanyCity.ForeignKeyTableName = "";
colvarCompanyCity.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyCity);
TableSchema.TableColumn colvarCompanyArea = new TableSchema.TableColumn(this);
colvarCompanyArea.ColumnName = "CompanyArea";
colvarCompanyArea.DataType = DbType.String;
colvarCompanyArea.MaxLength = 50;
colvarCompanyArea.AutoIncrement = false;
colvarCompanyArea.IsNullable = true;
colvarCompanyArea.IsPrimaryKey = false;
colvarCompanyArea.IsForeignKey = false;
colvarCompanyArea.IsReadOnly = false;
colvarCompanyArea.DefaultSetting = @"";
colvarCompanyArea.ForeignKeyTableName = "";
colvarCompanyArea.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyArea);
TableSchema.TableColumn colvarCompanyLocation = new TableSchema.TableColumn(this);
colvarCompanyLocation.ColumnName = "CompanyLocation";
colvarCompanyLocation.DataType = DbType.String;
colvarCompanyLocation.MaxLength = 50;
colvarCompanyLocation.AutoIncrement = false;
colvarCompanyLocation.IsNullable = true;
colvarCompanyLocation.IsPrimaryKey = false;
colvarCompanyLocation.IsForeignKey = false;
colvarCompanyLocation.IsReadOnly = false;
colvarCompanyLocation.DefaultSetting = @"";
colvarCompanyLocation.ForeignKeyTableName = "";
colvarCompanyLocation.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyLocation);
TableSchema.TableColumn colvarAreaDepth = new TableSchema.TableColumn(this);
colvarAreaDepth.ColumnName = "AreaDepth";
colvarAreaDepth.DataType = DbType.String;
colvarAreaDepth.MaxLength = 50;
colvarAreaDepth.AutoIncrement = false;
colvarAreaDepth.IsNullable = true;
colvarAreaDepth.IsPrimaryKey = false;
colvarAreaDepth.IsForeignKey = false;
colvarAreaDepth.IsReadOnly = false;
colvarAreaDepth.DefaultSetting = @"";
colvarAreaDepth.ForeignKeyTableName = "";
colvarAreaDepth.ApplyExtendedProperties();
this.Columns.Add(colvarAreaDepth);
TableSchema.TableColumn colvarCompanyAddress = new TableSchema.TableColumn(this);
colvarCompanyAddress.ColumnName = "CompanyAddress";
colvarCompanyAddress.DataType = DbType.String;
colvarCompanyAddress.MaxLength = 250;
colvarCompanyAddress.AutoIncrement = false;
colvarCompanyAddress.IsNullable = true;
colvarCompanyAddress.IsPrimaryKey = false;
colvarCompanyAddress.IsForeignKey = false;
colvarCompanyAddress.IsReadOnly = false;
colvarCompanyAddress.DefaultSetting = @"";
colvarCompanyAddress.ForeignKeyTableName = "";
colvarCompanyAddress.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyAddress);
TableSchema.TableColumn colvarCompanyTel = new TableSchema.TableColumn(this);
colvarCompanyTel.ColumnName = "CompanyTel";
colvarCompanyTel.DataType = DbType.String;
colvarCompanyTel.MaxLength = 50;
colvarCompanyTel.AutoIncrement = false;
colvarCompanyTel.IsNullable = true;
colvarCompanyTel.IsPrimaryKey = false;
colvarCompanyTel.IsForeignKey = false;
colvarCompanyTel.IsReadOnly = false;
colvarCompanyTel.DefaultSetting = @"";
colvarCompanyTel.ForeignKeyTableName = "";
colvarCompanyTel.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyTel);
TableSchema.TableColumn colvarCompanyPhone = new TableSchema.TableColumn(this);
colvarCompanyPhone.ColumnName = "CompanyPhone";
colvarCompanyPhone.DataType = DbType.String;
colvarCompanyPhone.MaxLength = 50;
colvarCompanyPhone.AutoIncrement = false;
colvarCompanyPhone.IsNullable = true;
colvarCompanyPhone.IsPrimaryKey = false;
colvarCompanyPhone.IsForeignKey = false;
colvarCompanyPhone.IsReadOnly = false;
colvarCompanyPhone.DefaultSetting = @"";
colvarCompanyPhone.ForeignKeyTableName = "";
colvarCompanyPhone.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyPhone);
TableSchema.TableColumn colvarCompanyMsn = new TableSchema.TableColumn(this);
colvarCompanyMsn.ColumnName = "CompanyMsn";
colvarCompanyMsn.DataType = DbType.String;
colvarCompanyMsn.MaxLength = 50;
colvarCompanyMsn.AutoIncrement = false;
colvarCompanyMsn.IsNullable = true;
colvarCompanyMsn.IsPrimaryKey = false;
colvarCompanyMsn.IsForeignKey = false;
colvarCompanyMsn.IsReadOnly = false;
colvarCompanyMsn.DefaultSetting = @"";
colvarCompanyMsn.ForeignKeyTableName = "";
colvarCompanyMsn.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyMsn);
TableSchema.TableColumn colvarCompanySkype = new TableSchema.TableColumn(this);
colvarCompanySkype.ColumnName = "CompanySkype";
colvarCompanySkype.DataType = DbType.String;
colvarCompanySkype.MaxLength = 50;
colvarCompanySkype.AutoIncrement = false;
colvarCompanySkype.IsNullable = true;
colvarCompanySkype.IsPrimaryKey = false;
colvarCompanySkype.IsForeignKey = false;
colvarCompanySkype.IsReadOnly = false;
colvarCompanySkype.DefaultSetting = @"";
colvarCompanySkype.ForeignKeyTableName = "";
colvarCompanySkype.ApplyExtendedProperties();
this.Columns.Add(colvarCompanySkype);
TableSchema.TableColumn colvarCompanyPhoto = new TableSchema.TableColumn(this);
colvarCompanyPhoto.ColumnName = "CompanyPhoto";
colvarCompanyPhoto.DataType = DbType.String;
colvarCompanyPhoto.MaxLength = 50;
colvarCompanyPhoto.AutoIncrement = false;
colvarCompanyPhoto.IsNullable = true;
colvarCompanyPhoto.IsPrimaryKey = false;
colvarCompanyPhoto.IsForeignKey = false;
colvarCompanyPhoto.IsReadOnly = false;
colvarCompanyPhoto.DefaultSetting = @"";
colvarCompanyPhoto.ForeignKeyTableName = "";
colvarCompanyPhoto.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyPhoto);
TableSchema.TableColumn colvarCompanyIntro = new TableSchema.TableColumn(this);
colvarCompanyIntro.ColumnName = "CompanyIntro";
colvarCompanyIntro.DataType = DbType.String;
colvarCompanyIntro.MaxLength = 250;
colvarCompanyIntro.AutoIncrement = false;
colvarCompanyIntro.IsNullable = true;
colvarCompanyIntro.IsPrimaryKey = false;
colvarCompanyIntro.IsForeignKey = false;
colvarCompanyIntro.IsReadOnly = false;
colvarCompanyIntro.DefaultSetting = @"";
colvarCompanyIntro.ForeignKeyTableName = "";
colvarCompanyIntro.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyIntro);
TableSchema.TableColumn colvarCompanyContent = new TableSchema.TableColumn(this);
colvarCompanyContent.ColumnName = "CompanyContent";
colvarCompanyContent.DataType = DbType.String;
colvarCompanyContent.MaxLength = 1073741823;
colvarCompanyContent.AutoIncrement = false;
colvarCompanyContent.IsNullable = true;
colvarCompanyContent.IsPrimaryKey = false;
colvarCompanyContent.IsForeignKey = false;
colvarCompanyContent.IsReadOnly = false;
colvarCompanyContent.DefaultSetting = @"";
colvarCompanyContent.ForeignKeyTableName = "";
colvarCompanyContent.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyContent);
TableSchema.TableColumn colvarIsUseFinger = new TableSchema.TableColumn(this);
colvarIsUseFinger.ColumnName = "IsUseFinger";
colvarIsUseFinger.DataType = DbType.Boolean;
colvarIsUseFinger.MaxLength = 0;
colvarIsUseFinger.AutoIncrement = false;
colvarIsUseFinger.IsNullable = true;
colvarIsUseFinger.IsPrimaryKey = false;
colvarIsUseFinger.IsForeignKey = false;
colvarIsUseFinger.IsReadOnly = false;
colvarIsUseFinger.DefaultSetting = @"((0))";
colvarIsUseFinger.ForeignKeyTableName = "";
colvarIsUseFinger.ApplyExtendedProperties();
this.Columns.Add(colvarIsUseFinger);
TableSchema.TableColumn colvarCompanyDate = new TableSchema.TableColumn(this);
colvarCompanyDate.ColumnName = "CompanyDate";
colvarCompanyDate.DataType = DbType.DateTime;
colvarCompanyDate.MaxLength = 0;
colvarCompanyDate.AutoIncrement = false;
colvarCompanyDate.IsNullable = true;
colvarCompanyDate.IsPrimaryKey = false;
colvarCompanyDate.IsForeignKey = false;
colvarCompanyDate.IsReadOnly = false;
colvarCompanyDate.DefaultSetting = @"";
colvarCompanyDate.ForeignKeyTableName = "";
colvarCompanyDate.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyDate);
TableSchema.TableColumn colvarCompanyDateView = new TableSchema.TableColumn(this);
colvarCompanyDateView.ColumnName = "CompanyDateView";
colvarCompanyDateView.DataType = DbType.DateTime;
colvarCompanyDateView.MaxLength = 0;
colvarCompanyDateView.AutoIncrement = false;
colvarCompanyDateView.IsNullable = true;
colvarCompanyDateView.IsPrimaryKey = false;
colvarCompanyDateView.IsForeignKey = false;
colvarCompanyDateView.IsReadOnly = false;
colvarCompanyDateView.DefaultSetting = @"";
colvarCompanyDateView.ForeignKeyTableName = "";
colvarCompanyDateView.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyDateView);
TableSchema.TableColumn colvarCompanyStatus = new TableSchema.TableColumn(this);
colvarCompanyStatus.ColumnName = "CompanyStatus";
colvarCompanyStatus.DataType = DbType.Int32;
colvarCompanyStatus.MaxLength = 0;
colvarCompanyStatus.AutoIncrement = false;
colvarCompanyStatus.IsNullable = true;
colvarCompanyStatus.IsPrimaryKey = false;
colvarCompanyStatus.IsForeignKey = false;
colvarCompanyStatus.IsReadOnly = false;
colvarCompanyStatus.DefaultSetting = @"";
colvarCompanyStatus.ForeignKeyTableName = "";
colvarCompanyStatus.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyStatus);
TableSchema.TableColumn colvarCompanyMemo = new TableSchema.TableColumn(this);
colvarCompanyMemo.ColumnName = "CompanyMemo";
colvarCompanyMemo.DataType = DbType.String;
colvarCompanyMemo.MaxLength = 50;
colvarCompanyMemo.AutoIncrement = false;
colvarCompanyMemo.IsNullable = true;
colvarCompanyMemo.IsPrimaryKey = false;
colvarCompanyMemo.IsForeignKey = false;
colvarCompanyMemo.IsReadOnly = false;
colvarCompanyMemo.DefaultSetting = @"";
colvarCompanyMemo.ForeignKeyTableName = "";
colvarCompanyMemo.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyMemo);
TableSchema.TableColumn colvarCompanyRate = new TableSchema.TableColumn(this);
colvarCompanyRate.ColumnName = "CompanyRate";
colvarCompanyRate.DataType = DbType.String;
colvarCompanyRate.MaxLength = 50;
colvarCompanyRate.AutoIncrement = false;
colvarCompanyRate.IsNullable = true;
colvarCompanyRate.IsPrimaryKey = false;
colvarCompanyRate.IsForeignKey = false;
colvarCompanyRate.IsReadOnly = false;
colvarCompanyRate.DefaultSetting = @"";
colvarCompanyRate.ForeignKeyTableName = "";
colvarCompanyRate.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyRate);
TableSchema.TableColumn colvarCompanyRateSale = new TableSchema.TableColumn(this);
colvarCompanyRateSale.ColumnName = "CompanyRateSale";
colvarCompanyRateSale.DataType = DbType.String;
colvarCompanyRateSale.MaxLength = 50;
colvarCompanyRateSale.AutoIncrement = false;
colvarCompanyRateSale.IsNullable = true;
colvarCompanyRateSale.IsPrimaryKey = false;
colvarCompanyRateSale.IsForeignKey = false;
colvarCompanyRateSale.IsReadOnly = false;
colvarCompanyRateSale.DefaultSetting = @"";
colvarCompanyRateSale.ForeignKeyTableName = "";
colvarCompanyRateSale.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyRateSale);
TableSchema.TableColumn colvarCompanyRateMaster = new TableSchema.TableColumn(this);
colvarCompanyRateMaster.ColumnName = "CompanyRateMaster";
colvarCompanyRateMaster.DataType = DbType.Decimal;
colvarCompanyRateMaster.MaxLength = 0;
colvarCompanyRateMaster.AutoIncrement = false;
colvarCompanyRateMaster.IsNullable = true;
colvarCompanyRateMaster.IsPrimaryKey = false;
colvarCompanyRateMaster.IsForeignKey = false;
colvarCompanyRateMaster.IsReadOnly = false;
colvarCompanyRateMaster.ExtendedProperties.Add(new TableSchema.ExtendedProperty("SSX_COLUMN_DISPLAY_NAME","佣金比例"));
colvarCompanyRateMaster.DefaultSetting = @"";
colvarCompanyRateMaster.ForeignKeyTableName = "";
colvarCompanyRateMaster.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyRateMaster);
TableSchema.TableColumn colvarCompanySaleCount = new TableSchema.TableColumn(this);
colvarCompanySaleCount.ColumnName = "CompanySaleCount";
colvarCompanySaleCount.DataType = DbType.Int32;
colvarCompanySaleCount.MaxLength = 0;
colvarCompanySaleCount.AutoIncrement = false;
colvarCompanySaleCount.IsNullable = true;
colvarCompanySaleCount.IsPrimaryKey = false;
colvarCompanySaleCount.IsForeignKey = false;
colvarCompanySaleCount.IsReadOnly = false;
colvarCompanySaleCount.DefaultSetting = @"";
colvarCompanySaleCount.ForeignKeyTableName = "";
colvarCompanySaleCount.ApplyExtendedProperties();
this.Columns.Add(colvarCompanySaleCount);
TableSchema.TableColumn colvarCompanySaleSum = new TableSchema.TableColumn(this);
colvarCompanySaleSum.ColumnName = "CompanySaleSum";
colvarCompanySaleSum.DataType = DbType.Decimal;
colvarCompanySaleSum.MaxLength = 0;
colvarCompanySaleSum.AutoIncrement = false;
colvarCompanySaleSum.IsNullable = true;
colvarCompanySaleSum.IsPrimaryKey = false;
colvarCompanySaleSum.IsForeignKey = false;
colvarCompanySaleSum.IsReadOnly = false;
colvarCompanySaleSum.DefaultSetting = @"";
colvarCompanySaleSum.ForeignKeyTableName = "";
colvarCompanySaleSum.ApplyExtendedProperties();
this.Columns.Add(colvarCompanySaleSum);
TableSchema.TableColumn colvarCompanyBalance = new TableSchema.TableColumn(this);
colvarCompanyBalance.ColumnName = "CompanyBalance";
colvarCompanyBalance.DataType = DbType.Decimal;
colvarCompanyBalance.MaxLength = 0;
colvarCompanyBalance.AutoIncrement = false;
colvarCompanyBalance.IsNullable = true;
colvarCompanyBalance.IsPrimaryKey = false;
colvarCompanyBalance.IsForeignKey = false;
colvarCompanyBalance.IsReadOnly = false;
colvarCompanyBalance.DefaultSetting = @"";
colvarCompanyBalance.ForeignKeyTableName = "";
colvarCompanyBalance.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyBalance);
TableSchema.TableColumn colvarCompanyBalanceCash = new TableSchema.TableColumn(this);
colvarCompanyBalanceCash.ColumnName = "CompanyBalanceCash";
colvarCompanyBalanceCash.DataType = DbType.Decimal;
colvarCompanyBalanceCash.MaxLength = 0;
colvarCompanyBalanceCash.AutoIncrement = false;
colvarCompanyBalanceCash.IsNullable = true;
colvarCompanyBalanceCash.IsPrimaryKey = false;
colvarCompanyBalanceCash.IsForeignKey = false;
colvarCompanyBalanceCash.IsReadOnly = false;
colvarCompanyBalanceCash.DefaultSetting = @"";
colvarCompanyBalanceCash.ForeignKeyTableName = "";
colvarCompanyBalanceCash.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyBalanceCash);
TableSchema.TableColumn colvarCompanyFacebookCount = new TableSchema.TableColumn(this);
colvarCompanyFacebookCount.ColumnName = "CompanyFacebookCount";
colvarCompanyFacebookCount.DataType = DbType.Int32;
colvarCompanyFacebookCount.MaxLength = 0;
colvarCompanyFacebookCount.AutoIncrement = false;
colvarCompanyFacebookCount.IsNullable = true;
colvarCompanyFacebookCount.IsPrimaryKey = false;
colvarCompanyFacebookCount.IsForeignKey = false;
colvarCompanyFacebookCount.IsReadOnly = false;
colvarCompanyFacebookCount.DefaultSetting = @"";
colvarCompanyFacebookCount.ForeignKeyTableName = "";
colvarCompanyFacebookCount.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyFacebookCount);
TableSchema.TableColumn colvarCompanyToken = new TableSchema.TableColumn(this);
colvarCompanyToken.ColumnName = "CompanyToken";
colvarCompanyToken.DataType = DbType.AnsiString;
colvarCompanyToken.MaxLength = 1000;
colvarCompanyToken.AutoIncrement = false;
colvarCompanyToken.IsNullable = true;
colvarCompanyToken.IsPrimaryKey = false;
colvarCompanyToken.IsForeignKey = false;
colvarCompanyToken.IsReadOnly = false;
colvarCompanyToken.DefaultSetting = @"";
colvarCompanyToken.ForeignKeyTableName = "";
colvarCompanyToken.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyToken);
TableSchema.TableColumn colvarCompanyType = new TableSchema.TableColumn(this);
colvarCompanyType.ColumnName = "CompanyType";
colvarCompanyType.DataType = DbType.Int32;
colvarCompanyType.MaxLength = 0;
colvarCompanyType.AutoIncrement = false;
colvarCompanyType.IsNullable = true;
colvarCompanyType.IsPrimaryKey = false;
colvarCompanyType.IsForeignKey = false;
colvarCompanyType.IsReadOnly = false;
colvarCompanyType.DefaultSetting = @"";
colvarCompanyType.ForeignKeyTableName = "";
colvarCompanyType.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyType);
TableSchema.TableColumn colvarCompanyItem = new TableSchema.TableColumn(this);
colvarCompanyItem.ColumnName = "CompanyItem";
colvarCompanyItem.DataType = DbType.String;
colvarCompanyItem.MaxLength = 1000;
colvarCompanyItem.AutoIncrement = false;
colvarCompanyItem.IsNullable = true;
colvarCompanyItem.IsPrimaryKey = false;
colvarCompanyItem.IsForeignKey = false;
colvarCompanyItem.IsReadOnly = false;
colvarCompanyItem.DefaultSetting = @"";
colvarCompanyItem.ForeignKeyTableName = "";
colvarCompanyItem.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyItem);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
TableSchema.TableColumn colvarCompanyWorkTime = new TableSchema.TableColumn(this);
colvarCompanyWorkTime.ColumnName = "CompanyWorkTime";
colvarCompanyWorkTime.DataType = DbType.String;
colvarCompanyWorkTime.MaxLength = 500;
colvarCompanyWorkTime.AutoIncrement = false;
colvarCompanyWorkTime.IsNullable = true;
colvarCompanyWorkTime.IsPrimaryKey = false;
colvarCompanyWorkTime.IsForeignKey = false;
colvarCompanyWorkTime.IsReadOnly = false;
colvarCompanyWorkTime.DefaultSetting = @"";
colvarCompanyWorkTime.ForeignKeyTableName = "";
colvarCompanyWorkTime.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyWorkTime);
TableSchema.TableColumn colvarCompanyServices = new TableSchema.TableColumn(this);
colvarCompanyServices.ColumnName = "CompanyServices";
colvarCompanyServices.DataType = DbType.String;
colvarCompanyServices.MaxLength = 500;
colvarCompanyServices.AutoIncrement = false;
colvarCompanyServices.IsNullable = true;
colvarCompanyServices.IsPrimaryKey = false;
colvarCompanyServices.IsForeignKey = false;
colvarCompanyServices.IsReadOnly = false;
colvarCompanyServices.DefaultSetting = @"";
colvarCompanyServices.ForeignKeyTableName = "";
colvarCompanyServices.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyServices);
TableSchema.TableColumn colvarMsnPhoneNum = new TableSchema.TableColumn(this);
colvarMsnPhoneNum.ColumnName = "MsnPhoneNum";
colvarMsnPhoneNum.DataType = DbType.String;
colvarMsnPhoneNum.MaxLength = 15;
colvarMsnPhoneNum.AutoIncrement = false;
colvarMsnPhoneNum.IsNullable = true;
colvarMsnPhoneNum.IsPrimaryKey = false;
colvarMsnPhoneNum.IsForeignKey = false;
colvarMsnPhoneNum.IsReadOnly = false;
colvarMsnPhoneNum.DefaultSetting = @"";
colvarMsnPhoneNum.ForeignKeyTableName = "";
colvarMsnPhoneNum.ApplyExtendedProperties();
this.Columns.Add(colvarMsnPhoneNum);
TableSchema.TableColumn colvarOrderElapsed = new TableSchema.TableColumn(this);
colvarOrderElapsed.ColumnName = "OrderElapsed";
colvarOrderElapsed.DataType = DbType.String;
colvarOrderElapsed.MaxLength = 10;
colvarOrderElapsed.AutoIncrement = false;
colvarOrderElapsed.IsNullable = true;
colvarOrderElapsed.IsPrimaryKey = false;
colvarOrderElapsed.IsForeignKey = false;
colvarOrderElapsed.IsReadOnly = false;
colvarOrderElapsed.DefaultSetting = @"";
colvarOrderElapsed.ForeignKeyTableName = "";
colvarOrderElapsed.ApplyExtendedProperties();
this.Columns.Add(colvarOrderElapsed);
TableSchema.TableColumn colvarOrderMaxAmount = new TableSchema.TableColumn(this);
colvarOrderMaxAmount.ColumnName = "OrderMaxAmount";
colvarOrderMaxAmount.DataType = DbType.Int32;
colvarOrderMaxAmount.MaxLength = 0;
colvarOrderMaxAmount.AutoIncrement = false;
colvarOrderMaxAmount.IsNullable = true;
colvarOrderMaxAmount.IsPrimaryKey = false;
colvarOrderMaxAmount.IsForeignKey = false;
colvarOrderMaxAmount.IsReadOnly = false;
colvarOrderMaxAmount.DefaultSetting = @"";
colvarOrderMaxAmount.ForeignKeyTableName = "";
colvarOrderMaxAmount.ApplyExtendedProperties();
this.Columns.Add(colvarOrderMaxAmount);
TableSchema.TableColumn colvarIsUseMsg = new TableSchema.TableColumn(this);
colvarIsUseMsg.ColumnName = "IsUseMsg";
colvarIsUseMsg.DataType = DbType.Boolean;
colvarIsUseMsg.MaxLength = 0;
colvarIsUseMsg.AutoIncrement = false;
colvarIsUseMsg.IsNullable = true;
colvarIsUseMsg.IsPrimaryKey = false;
colvarIsUseMsg.IsForeignKey = false;
colvarIsUseMsg.IsReadOnly = false;
colvarIsUseMsg.DefaultSetting = @"";
colvarIsUseMsg.ForeignKeyTableName = "";
colvarIsUseMsg.ApplyExtendedProperties();
this.Columns.Add(colvarIsUseMsg);
TableSchema.TableColumn colvarOnSetSum = new TableSchema.TableColumn(this);
colvarOnSetSum.ColumnName = "OnSetSum";
colvarOnSetSum.DataType = DbType.Decimal;
colvarOnSetSum.MaxLength = 0;
colvarOnSetSum.AutoIncrement = false;
colvarOnSetSum.IsNullable = true;
colvarOnSetSum.IsPrimaryKey = false;
colvarOnSetSum.IsForeignKey = false;
colvarOnSetSum.IsReadOnly = false;
colvarOnSetSum.DefaultSetting = @"";
colvarOnSetSum.ForeignKeyTableName = "";
colvarOnSetSum.ApplyExtendedProperties();
this.Columns.Add(colvarOnSetSum);
TableSchema.TableColumn colvarServiceSum = new TableSchema.TableColumn(this);
colvarServiceSum.ColumnName = "ServiceSum";
colvarServiceSum.DataType = DbType.Decimal;
colvarServiceSum.MaxLength = 0;
colvarServiceSum.AutoIncrement = false;
colvarServiceSum.IsNullable = true;
colvarServiceSum.IsPrimaryKey = false;
colvarServiceSum.IsForeignKey = false;
colvarServiceSum.IsReadOnly = false;
colvarServiceSum.DefaultSetting = @"";
colvarServiceSum.ForeignKeyTableName = "";
colvarServiceSum.ApplyExtendedProperties();
this.Columns.Add(colvarServiceSum);
TableSchema.TableColumn colvarMenuDate = new TableSchema.TableColumn(this);
colvarMenuDate.ColumnName = "MenuDate";
colvarMenuDate.DataType = DbType.DateTime;
colvarMenuDate.MaxLength = 0;
colvarMenuDate.AutoIncrement = false;
colvarMenuDate.IsNullable = true;
colvarMenuDate.IsPrimaryKey = false;
colvarMenuDate.IsForeignKey = false;
colvarMenuDate.IsReadOnly = false;
colvarMenuDate.DefaultSetting = @"";
colvarMenuDate.ForeignKeyTableName = "";
colvarMenuDate.ApplyExtendedProperties();
this.Columns.Add(colvarMenuDate);
TableSchema.TableColumn colvarSetTopDate = new TableSchema.TableColumn(this);
colvarSetTopDate.ColumnName = "SetTopDate";
colvarSetTopDate.DataType = DbType.DateTime;
colvarSetTopDate.MaxLength = 0;
colvarSetTopDate.AutoIncrement = false;
colvarSetTopDate.IsNullable = true;
colvarSetTopDate.IsPrimaryKey = false;
colvarSetTopDate.IsForeignKey = false;
colvarSetTopDate.IsReadOnly = false;
colvarSetTopDate.DefaultSetting = @"";
colvarSetTopDate.ForeignKeyTableName = "";
colvarSetTopDate.ApplyExtendedProperties();
this.Columns.Add(colvarSetTopDate);
TableSchema.TableColumn colvarIsPoint = new TableSchema.TableColumn(this);
colvarIsPoint.ColumnName = "IsPoint";
colvarIsPoint.DataType = DbType.Boolean;
colvarIsPoint.MaxLength = 0;
colvarIsPoint.AutoIncrement = false;
colvarIsPoint.IsNullable = true;
colvarIsPoint.IsPrimaryKey = false;
colvarIsPoint.IsForeignKey = false;
colvarIsPoint.IsReadOnly = false;
colvarIsPoint.DefaultSetting = @"";
colvarIsPoint.ForeignKeyTableName = "";
colvarIsPoint.ApplyExtendedProperties();
this.Columns.Add(colvarIsPoint);
TableSchema.TableColumn colvarIsOnSale = new TableSchema.TableColumn(this);
colvarIsOnSale.ColumnName = "IsOnSale";
colvarIsOnSale.DataType = DbType.Boolean;
colvarIsOnSale.MaxLength = 0;
colvarIsOnSale.AutoIncrement = false;
colvarIsOnSale.IsNullable = true;
colvarIsOnSale.IsPrimaryKey = false;
colvarIsOnSale.IsForeignKey = false;
colvarIsOnSale.IsReadOnly = false;
colvarIsOnSale.DefaultSetting = @"";
colvarIsOnSale.ForeignKeyTableName = "";
colvarIsOnSale.ApplyExtendedProperties();
this.Columns.Add(colvarIsOnSale);
TableSchema.TableColumn colvarIsSuspend = new TableSchema.TableColumn(this);
colvarIsSuspend.ColumnName = "IsSuspend";
colvarIsSuspend.DataType = DbType.Boolean;
colvarIsSuspend.MaxLength = 0;
colvarIsSuspend.AutoIncrement = false;
colvarIsSuspend.IsNullable = true;
colvarIsSuspend.IsPrimaryKey = false;
colvarIsSuspend.IsForeignKey = false;
colvarIsSuspend.IsReadOnly = false;
colvarIsSuspend.DefaultSetting = @"";
colvarIsSuspend.ForeignKeyTableName = "";
colvarIsSuspend.ApplyExtendedProperties();
this.Columns.Add(colvarIsSuspend);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.ExtendedProperties.Add(new TableSchema.ExtendedProperty("SSX_COLUMN_DISPLAY_NAME","导航ID"));
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarNavName = new TableSchema.TableColumn(this);
colvarNavName.ColumnName = "NavName";
colvarNavName.DataType = DbType.String;
colvarNavName.MaxLength = 50;
colvarNavName.AutoIncrement = false;
colvarNavName.IsNullable = true;
colvarNavName.IsPrimaryKey = false;
colvarNavName.IsForeignKey = false;
colvarNavName.IsReadOnly = false;
colvarNavName.ExtendedProperties.Add(new TableSchema.ExtendedProperty("SSX_COLUMN_DISPLAY_NAME","导航名称"));
colvarNavName.DefaultSetting = @"";
colvarNavName.ForeignKeyTableName = "";
colvarNavName.ApplyExtendedProperties();
this.Columns.Add(colvarNavName);
TableSchema.TableColumn colvarSecName = new TableSchema.TableColumn(this);
colvarSecName.ColumnName = "SecName";
colvarSecName.DataType = DbType.String;
colvarSecName.MaxLength = 50;
colvarSecName.AutoIncrement = false;
colvarSecName.IsNullable = true;
colvarSecName.IsPrimaryKey = false;
colvarSecName.IsForeignKey = false;
colvarSecName.IsReadOnly = false;
colvarSecName.ExtendedProperties.Add(new TableSchema.ExtendedProperty("SSX_COLUMN_DISPLAY_NAME","显示区块"));
colvarSecName.DefaultSetting = @"";
colvarSecName.ForeignKeyTableName = "";
colvarSecName.ApplyExtendedProperties();
this.Columns.Add(colvarSecName);
TableSchema.TableColumn colvarOthName = new TableSchema.TableColumn(this);
colvarOthName.ColumnName = "OthName";
colvarOthName.DataType = DbType.String;
colvarOthName.MaxLength = 50;
colvarOthName.AutoIncrement = false;
colvarOthName.IsNullable = true;
colvarOthName.IsPrimaryKey = false;
colvarOthName.IsForeignKey = false;
colvarOthName.IsReadOnly = false;
colvarOthName.DefaultSetting = @"";
colvarOthName.ForeignKeyTableName = "";
colvarOthName.ApplyExtendedProperties();
this.Columns.Add(colvarOthName);
TableSchema.TableColumn colvarNavUrl = new TableSchema.TableColumn(this);
colvarNavUrl.ColumnName = "NavUrl";
colvarNavUrl.DataType = DbType.String;
colvarNavUrl.MaxLength = 250;
colvarNavUrl.AutoIncrement = false;
colvarNavUrl.IsNullable = true;
colvarNavUrl.IsPrimaryKey = false;
colvarNavUrl.IsForeignKey = false;
colvarNavUrl.IsReadOnly = false;
colvarNavUrl.ExtendedProperties.Add(new TableSchema.ExtendedProperty("SSX_COLUMN_DISPLAY_NAME","导航URL"));
colvarNavUrl.DefaultSetting = @"";
colvarNavUrl.ForeignKeyTableName = "";
colvarNavUrl.ApplyExtendedProperties();
this.Columns.Add(colvarNavUrl);
TableSchema.TableColumn colvarNavIcon = new TableSchema.TableColumn(this);
colvarNavIcon.ColumnName = "NavIcon";
colvarNavIcon.DataType = DbType.String;
colvarNavIcon.MaxLength = 50;
colvarNavIcon.AutoIncrement = false;
colvarNavIcon.IsNullable = true;
colvarNavIcon.IsPrimaryKey = false;
colvarNavIcon.IsForeignKey = false;
colvarNavIcon.IsReadOnly = false;
colvarNavIcon.DefaultSetting = @"";
colvarNavIcon.ForeignKeyTableName = "";
colvarNavIcon.ApplyExtendedProperties();
this.Columns.Add(colvarNavIcon);
TableSchema.TableColumn colvarSubSysId = new TableSchema.TableColumn(this);
colvarSubSysId.ColumnName = "SubSys_ID";
colvarSubSysId.DataType = DbType.Int32;
colvarSubSysId.MaxLength = 0;
colvarSubSysId.AutoIncrement = false;
colvarSubSysId.IsNullable = true;
colvarSubSysId.IsPrimaryKey = false;
colvarSubSysId.IsForeignKey = false;
colvarSubSysId.IsReadOnly = false;
colvarSubSysId.ExtendedProperties.Add(new TableSchema.ExtendedProperty("SSX_COLUMN_DISPLAY_NAME","系统ID"));
colvarSubSysId.DefaultSetting = @"";
colvarSubSysId.ForeignKeyTableName = "";
colvarSubSysId.ApplyExtendedProperties();
this.Columns.Add(colvarSubSysId);
TableSchema.TableColumn colvarPId = new TableSchema.TableColumn(this);
colvarPId.ColumnName = "P_ID";
colvarPId.DataType = DbType.Int32;
colvarPId.MaxLength = 0;
colvarPId.AutoIncrement = false;
colvarPId.IsNullable = true;
colvarPId.IsPrimaryKey = false;
colvarPId.IsForeignKey = false;
colvarPId.IsReadOnly = false;
colvarPId.ExtendedProperties.Add(new TableSchema.ExtendedProperty("SSX_COLUMN_DISPLAY_NAME","父导航ID"));
colvarPId.DefaultSetting = @"((0))";
colvarPId.ForeignKeyTableName = "";
colvarPId.ApplyExtendedProperties();
this.Columns.Add(colvarPId);
TableSchema.TableColumn colvarIsMainNav = new TableSchema.TableColumn(this);
colvarIsMainNav.ColumnName = "IsMainNav";
colvarIsMainNav.DataType = DbType.Boolean;
colvarIsMainNav.MaxLength = 0;
colvarIsMainNav.AutoIncrement = false;
colvarIsMainNav.IsNullable = false;
colvarIsMainNav.IsPrimaryKey = false;
colvarIsMainNav.IsForeignKey = false;
colvarIsMainNav.IsReadOnly = false;
colvarIsMainNav.DefaultSetting = @"((0))";
colvarIsMainNav.ForeignKeyTableName = "";
colvarIsMainNav.ApplyExtendedProperties();
this.Columns.Add(colvarIsMainNav);
TableSchema.TableColumn colvarIsHeader = new TableSchema.TableColumn(this);
colvarIsHeader.ColumnName = "IsHeader";
colvarIsHeader.DataType = DbType.Boolean;
colvarIsHeader.MaxLength = 0;
colvarIsHeader.AutoIncrement = false;
colvarIsHeader.IsNullable = false;
colvarIsHeader.IsPrimaryKey = false;
colvarIsHeader.IsForeignKey = false;
colvarIsHeader.IsReadOnly = false;
colvarIsHeader.DefaultSetting = @"((0))";
colvarIsHeader.ForeignKeyTableName = "";
colvarIsHeader.ApplyExtendedProperties();
this.Columns.Add(colvarIsHeader);
TableSchema.TableColumn colvarIsFooter = new TableSchema.TableColumn(this);
colvarIsFooter.ColumnName = "IsFooter";
colvarIsFooter.DataType = DbType.Boolean;
colvarIsFooter.MaxLength = 0;
colvarIsFooter.AutoIncrement = false;
colvarIsFooter.IsNullable = false;
colvarIsFooter.IsPrimaryKey = false;
colvarIsFooter.IsForeignKey = false;
colvarIsFooter.IsReadOnly = false;
colvarIsFooter.DefaultSetting = @"((0))";
colvarIsFooter.ForeignKeyTableName = "";
colvarIsFooter.ApplyExtendedProperties();
this.Columns.Add(colvarIsFooter);
TableSchema.TableColumn colvarPermissionRequired = new TableSchema.TableColumn(this);
colvarPermissionRequired.ColumnName = "PermissionRequired";
colvarPermissionRequired.DataType = DbType.Boolean;
colvarPermissionRequired.MaxLength = 0;
colvarPermissionRequired.AutoIncrement = false;
colvarPermissionRequired.IsNullable = false;
colvarPermissionRequired.IsPrimaryKey = false;
colvarPermissionRequired.IsForeignKey = false;
colvarPermissionRequired.IsReadOnly = false;
colvarPermissionRequired.ExtendedProperties.Add(new TableSchema.ExtendedProperty("SSX_COLUMN_DISPLAY_NAME","匿名可见"));
colvarPermissionRequired.DefaultSetting = @"((1))";
colvarPermissionRequired.ForeignKeyTableName = "";
colvarPermissionRequired.ApplyExtendedProperties();
this.Columns.Add(colvarPermissionRequired);
TableSchema.TableColumn colvarSort = new TableSchema.TableColumn(this);
colvarSort.ColumnName = "Sort";
colvarSort.DataType = DbType.Int32;
colvarSort.MaxLength = 0;
colvarSort.AutoIncrement = false;
colvarSort.IsNullable = false;
colvarSort.IsPrimaryKey = false;
colvarSort.IsForeignKey = false;
colvarSort.IsReadOnly = false;
colvarSort.DefaultSetting = @"((0))";
colvarSort.ForeignKeyTableName = "";
colvarSort.ApplyExtendedProperties();
this.Columns.Add(colvarSort);
TableSchema.TableColumn colvarVisible = new TableSchema.TableColumn(this);
colvarVisible.ColumnName = "Visible";
colvarVisible.DataType = DbType.Boolean;
colvarVisible.MaxLength = 0;
colvarVisible.AutoIncrement = false;
colvarVisible.IsNullable = false;
colvarVisible.IsPrimaryKey = false;
colvarVisible.IsForeignKey = false;
colvarVisible.IsReadOnly = false;
colvarVisible.DefaultSetting = @"((1))";
colvarVisible.ForeignKeyTableName = "";
colvarVisible.ApplyExtendedProperties();
this.Columns.Add(colvarVisible);
TableSchema.TableColumn colvarDepth = new TableSchema.TableColumn(this);
colvarDepth.ColumnName = "Depth";
colvarDepth.DataType = DbType.String;
colvarDepth.MaxLength = 250;
colvarDepth.AutoIncrement = false;
colvarDepth.IsNullable = true;
colvarDepth.IsPrimaryKey = false;
colvarDepth.IsForeignKey = false;
colvarDepth.IsReadOnly = false;
colvarDepth.DefaultSetting = @"";
colvarDepth.ForeignKeyTableName = "";
colvarDepth.ApplyExtendedProperties();
this.Columns.Add(colvarDepth);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarMoveID = new TableSchema.TableColumn(this);
colvarMoveID.ColumnName = "MoveID";
colvarMoveID.DataType = DbType.Int32;
colvarMoveID.MaxLength = 0;
colvarMoveID.AutoIncrement = false;
colvarMoveID.IsNullable = false;
colvarMoveID.IsPrimaryKey = false;
colvarMoveID.IsForeignKey = false;
colvarMoveID.IsReadOnly = false;
colvarMoveID.DefaultSetting = @"";
colvarMoveID.ForeignKeyTableName = "";
colvarMoveID.ApplyExtendedProperties();
this.Columns.Add(colvarMoveID);
TableSchema.TableColumn colvarMoverDate = new TableSchema.TableColumn(this);
colvarMoverDate.ColumnName = "MoverDate";
colvarMoverDate.DataType = DbType.DateTime;
colvarMoverDate.MaxLength = 0;
colvarMoverDate.AutoIncrement = false;
colvarMoverDate.IsNullable = true;
colvarMoverDate.IsPrimaryKey = false;
colvarMoverDate.IsForeignKey = false;
colvarMoverDate.IsReadOnly = false;
colvarMoverDate.DefaultSetting = @"";
colvarMoverDate.ForeignKeyTableName = "";
colvarMoverDate.ApplyExtendedProperties();
this.Columns.Add(colvarMoverDate);
TableSchema.TableColumn colvarMoverMemberIDOld = new TableSchema.TableColumn(this);
colvarMoverMemberIDOld.ColumnName = "MoverMemberIDOld";
colvarMoverMemberIDOld.DataType = DbType.Int32;
colvarMoverMemberIDOld.MaxLength = 0;
colvarMoverMemberIDOld.AutoIncrement = false;
colvarMoverMemberIDOld.IsNullable = true;
colvarMoverMemberIDOld.IsPrimaryKey = false;
colvarMoverMemberIDOld.IsForeignKey = false;
colvarMoverMemberIDOld.IsReadOnly = false;
colvarMoverMemberIDOld.DefaultSetting = @"";
colvarMoverMemberIDOld.ForeignKeyTableName = "";
colvarMoverMemberIDOld.ApplyExtendedProperties();
this.Columns.Add(colvarMoverMemberIDOld);
TableSchema.TableColumn colvarMoverMemberIDNew = new TableSchema.TableColumn(this);
colvarMoverMemberIDNew.ColumnName = "MoverMemberIDNew";
colvarMoverMemberIDNew.DataType = DbType.Int32;
colvarMoverMemberIDNew.MaxLength = 0;
colvarMoverMemberIDNew.AutoIncrement = false;
colvarMoverMemberIDNew.IsNullable = true;
colvarMoverMemberIDNew.IsPrimaryKey = false;
colvarMoverMemberIDNew.IsForeignKey = false;
colvarMoverMemberIDNew.IsReadOnly = false;
colvarMoverMemberIDNew.DefaultSetting = @"";
colvarMoverMemberIDNew.ForeignKeyTableName = "";
colvarMoverMemberIDNew.ApplyExtendedProperties();
this.Columns.Add(colvarMoverMemberIDNew);
TableSchema.TableColumn colvarMoverMemberIDPoint = new TableSchema.TableColumn(this);
colvarMoverMemberIDPoint.ColumnName = "MoverMemberIDPoint";
colvarMoverMemberIDPoint.DataType = DbType.Int32;
colvarMoverMemberIDPoint.MaxLength = 0;
colvarMoverMemberIDPoint.AutoIncrement = false;
colvarMoverMemberIDPoint.IsNullable = true;
colvarMoverMemberIDPoint.IsPrimaryKey = false;
colvarMoverMemberIDPoint.IsForeignKey = false;
colvarMoverMemberIDPoint.IsReadOnly = false;
colvarMoverMemberIDPoint.DefaultSetting = @"";
colvarMoverMemberIDPoint.ForeignKeyTableName = "";
colvarMoverMemberIDPoint.ApplyExtendedProperties();
this.Columns.Add(colvarMoverMemberIDPoint);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
TableSchema.TableColumn colvarOldName = new TableSchema.TableColumn(this);
colvarOldName.ColumnName = "OldName";
colvarOldName.DataType = DbType.String;
colvarOldName.MaxLength = 50;
colvarOldName.AutoIncrement = false;
colvarOldName.IsNullable = true;
colvarOldName.IsPrimaryKey = false;
colvarOldName.IsForeignKey = false;
colvarOldName.IsReadOnly = false;
colvarOldName.DefaultSetting = @"";
colvarOldName.ForeignKeyTableName = "";
colvarOldName.ApplyExtendedProperties();
this.Columns.Add(colvarOldName);
TableSchema.TableColumn colvarNewName = new TableSchema.TableColumn(this);
colvarNewName.ColumnName = "NewName";
colvarNewName.DataType = DbType.String;
colvarNewName.MaxLength = 50;
colvarNewName.AutoIncrement = false;
colvarNewName.IsNullable = true;
colvarNewName.IsPrimaryKey = false;
colvarNewName.IsForeignKey = false;
colvarNewName.IsReadOnly = false;
colvarNewName.DefaultSetting = @"";
colvarNewName.ForeignKeyTableName = "";
colvarNewName.ApplyExtendedProperties();
this.Columns.Add(colvarNewName);
TableSchema.TableColumn colvarOldPhoneNumber = new TableSchema.TableColumn(this);
colvarOldPhoneNumber.ColumnName = "OldPhoneNumber";
colvarOldPhoneNumber.DataType = DbType.String;
colvarOldPhoneNumber.MaxLength = 50;
colvarOldPhoneNumber.AutoIncrement = false;
colvarOldPhoneNumber.IsNullable = false;
colvarOldPhoneNumber.IsPrimaryKey = false;
colvarOldPhoneNumber.IsForeignKey = false;
colvarOldPhoneNumber.IsReadOnly = false;
colvarOldPhoneNumber.DefaultSetting = @"";
colvarOldPhoneNumber.ForeignKeyTableName = "";
colvarOldPhoneNumber.ApplyExtendedProperties();
this.Columns.Add(colvarOldPhoneNumber);
TableSchema.TableColumn colvarNewPhoneNumber = new TableSchema.TableColumn(this);
colvarNewPhoneNumber.ColumnName = "NewPhoneNumber";
colvarNewPhoneNumber.DataType = DbType.String;
colvarNewPhoneNumber.MaxLength = 50;
colvarNewPhoneNumber.AutoIncrement = false;
colvarNewPhoneNumber.IsNullable = false;
colvarNewPhoneNumber.IsPrimaryKey = false;
colvarNewPhoneNumber.IsForeignKey = false;
colvarNewPhoneNumber.IsReadOnly = false;
colvarNewPhoneNumber.DefaultSetting = @"";
colvarNewPhoneNumber.ForeignKeyTableName = "";
colvarNewPhoneNumber.ApplyExtendedProperties();
this.Columns.Add(colvarNewPhoneNumber);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarAdsCount = new TableSchema.TableColumn(this);
colvarAdsCount.ColumnName = "AdsCount";
colvarAdsCount.DataType = DbType.Int32;
colvarAdsCount.MaxLength = 0;
colvarAdsCount.AutoIncrement = false;
colvarAdsCount.IsNullable = true;
colvarAdsCount.IsPrimaryKey = false;
colvarAdsCount.IsForeignKey = false;
colvarAdsCount.IsReadOnly = false;
colvarAdsCount.DefaultSetting = @"";
colvarAdsCount.ForeignKeyTableName = "";
colvarAdsCount.ApplyExtendedProperties();
this.Columns.Add(colvarAdsCount);
TableSchema.TableColumn colvarAdsPointSum = new TableSchema.TableColumn(this);
colvarAdsPointSum.ColumnName = "AdsPointSum";
colvarAdsPointSum.DataType = DbType.Decimal;
colvarAdsPointSum.MaxLength = 0;
colvarAdsPointSum.AutoIncrement = false;
colvarAdsPointSum.IsNullable = true;
colvarAdsPointSum.IsPrimaryKey = false;
colvarAdsPointSum.IsForeignKey = false;
colvarAdsPointSum.IsReadOnly = false;
colvarAdsPointSum.DefaultSetting = @"";
colvarAdsPointSum.ForeignKeyTableName = "";
colvarAdsPointSum.ApplyExtendedProperties();
this.Columns.Add(colvarAdsPointSum);
TableSchema.TableColumn colvarAdsMemberID = new TableSchema.TableColumn(this);
colvarAdsMemberID.ColumnName = "AdsMemberID";
colvarAdsMemberID.DataType = DbType.Int32;
colvarAdsMemberID.MaxLength = 0;
colvarAdsMemberID.AutoIncrement = false;
colvarAdsMemberID.IsNullable = true;
colvarAdsMemberID.IsPrimaryKey = false;
colvarAdsMemberID.IsForeignKey = false;
colvarAdsMemberID.IsReadOnly = false;
colvarAdsMemberID.DefaultSetting = @"";
colvarAdsMemberID.ForeignKeyTableName = "";
colvarAdsMemberID.ApplyExtendedProperties();
this.Columns.Add(colvarAdsMemberID);
TableSchema.TableColumn colvarCompanyAdsID = new TableSchema.TableColumn(this);
colvarCompanyAdsID.ColumnName = "CompanyAdsID";
colvarCompanyAdsID.DataType = DbType.Int32;
colvarCompanyAdsID.MaxLength = 0;
colvarCompanyAdsID.AutoIncrement = false;
colvarCompanyAdsID.IsNullable = true;
colvarCompanyAdsID.IsPrimaryKey = false;
colvarCompanyAdsID.IsForeignKey = false;
colvarCompanyAdsID.IsReadOnly = false;
colvarCompanyAdsID.DefaultSetting = @"";
colvarCompanyAdsID.ForeignKeyTableName = "";
colvarCompanyAdsID.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyAdsID);
TableSchema.TableColumn colvarCompanyID = new TableSchema.TableColumn(this);
colvarCompanyID.ColumnName = "CompanyID";
colvarCompanyID.DataType = DbType.Int32;
colvarCompanyID.MaxLength = 0;
colvarCompanyID.AutoIncrement = false;
colvarCompanyID.IsNullable = true;
colvarCompanyID.IsPrimaryKey = false;
colvarCompanyID.IsForeignKey = false;
colvarCompanyID.IsReadOnly = false;
colvarCompanyID.DefaultSetting = @"";
colvarCompanyID.ForeignKeyTableName = "";
colvarCompanyID.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyID);
TableSchema.TableColumn colvarAdsClickDate = new TableSchema.TableColumn(this);
colvarAdsClickDate.ColumnName = "AdsClickDate";
colvarAdsClickDate.DataType = DbType.DateTime;
colvarAdsClickDate.MaxLength = 0;
colvarAdsClickDate.AutoIncrement = false;
colvarAdsClickDate.IsNullable = true;
colvarAdsClickDate.IsPrimaryKey = false;
colvarAdsClickDate.IsForeignKey = false;
colvarAdsClickDate.IsReadOnly = false;
colvarAdsClickDate.DefaultSetting = @"";
colvarAdsClickDate.ForeignKeyTableName = "";
colvarAdsClickDate.ApplyExtendedProperties();
this.Columns.Add(colvarAdsClickDate);
TableSchema.TableColumn colvarAdsTitle = new TableSchema.TableColumn(this);
colvarAdsTitle.ColumnName = "AdsTitle";
colvarAdsTitle.DataType = DbType.String;
colvarAdsTitle.MaxLength = 500;
colvarAdsTitle.AutoIncrement = false;
colvarAdsTitle.IsNullable = true;
colvarAdsTitle.IsPrimaryKey = false;
colvarAdsTitle.IsForeignKey = false;
colvarAdsTitle.IsReadOnly = false;
colvarAdsTitle.DefaultSetting = @"";
colvarAdsTitle.ForeignKeyTableName = "";
colvarAdsTitle.ApplyExtendedProperties();
this.Columns.Add(colvarAdsTitle);
TableSchema.TableColumn colvarOrderSum = new TableSchema.TableColumn(this);
colvarOrderSum.ColumnName = "OrderSum";
colvarOrderSum.DataType = DbType.Decimal;
colvarOrderSum.MaxLength = 0;
colvarOrderSum.AutoIncrement = false;
colvarOrderSum.IsNullable = true;
colvarOrderSum.IsPrimaryKey = false;
colvarOrderSum.IsForeignKey = false;
colvarOrderSum.IsReadOnly = false;
colvarOrderSum.DefaultSetting = @"";
colvarOrderSum.ForeignKeyTableName = "";
colvarOrderSum.ApplyExtendedProperties();
this.Columns.Add(colvarOrderSum);
TableSchema.TableColumn colvarMemberPhoneNumber = new TableSchema.TableColumn(this);
colvarMemberPhoneNumber.ColumnName = "MemberPhoneNumber";
colvarMemberPhoneNumber.DataType = DbType.String;
colvarMemberPhoneNumber.MaxLength = 50;
colvarMemberPhoneNumber.AutoIncrement = false;
colvarMemberPhoneNumber.IsNullable = false;
colvarMemberPhoneNumber.IsPrimaryKey = false;
colvarMemberPhoneNumber.IsForeignKey = false;
colvarMemberPhoneNumber.IsReadOnly = false;
colvarMemberPhoneNumber.DefaultSetting = @"";
colvarMemberPhoneNumber.ForeignKeyTableName = "";
colvarMemberPhoneNumber.ApplyExtendedProperties();
this.Columns.Add(colvarMemberPhoneNumber);
TableSchema.TableColumn colvarMemberFullname = new TableSchema.TableColumn(this);
colvarMemberFullname.ColumnName = "MemberFullname";
colvarMemberFullname.DataType = DbType.String;
colvarMemberFullname.MaxLength = 50;
colvarMemberFullname.AutoIncrement = false;
colvarMemberFullname.IsNullable = true;
colvarMemberFullname.IsPrimaryKey = false;
colvarMemberFullname.IsForeignKey = false;
colvarMemberFullname.IsReadOnly = false;
colvarMemberFullname.DefaultSetting = @"";
colvarMemberFullname.ForeignKeyTableName = "";
colvarMemberFullname.ApplyExtendedProperties();
this.Columns.Add(colvarMemberFullname);
TableSchema.TableColumn colvarCompanyName = new TableSchema.TableColumn(this);
colvarCompanyName.ColumnName = "CompanyName";
colvarCompanyName.DataType = DbType.String;
colvarCompanyName.MaxLength = 50;
colvarCompanyName.AutoIncrement = false;
colvarCompanyName.IsNullable = true;
colvarCompanyName.IsPrimaryKey = false;
colvarCompanyName.IsForeignKey = false;
colvarCompanyName.IsReadOnly = false;
colvarCompanyName.DefaultSetting = @"";
colvarCompanyName.ForeignKeyTableName = "";
colvarCompanyName.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyName);
TableSchema.TableColumn colvarMemberCompanyID = new TableSchema.TableColumn(this);
colvarMemberCompanyID.ColumnName = "MemberCompanyID";
colvarMemberCompanyID.DataType = DbType.Int32;
colvarMemberCompanyID.MaxLength = 0;
colvarMemberCompanyID.AutoIncrement = false;
colvarMemberCompanyID.IsNullable = true;
colvarMemberCompanyID.IsPrimaryKey = false;
colvarMemberCompanyID.IsForeignKey = false;
colvarMemberCompanyID.IsReadOnly = false;
colvarMemberCompanyID.DefaultSetting = @"";
colvarMemberCompanyID.ForeignKeyTableName = "";
colvarMemberCompanyID.ApplyExtendedProperties();
this.Columns.Add(colvarMemberCompanyID);
TableSchema.TableColumn colvarAdsDate = new TableSchema.TableColumn(this);
colvarAdsDate.ColumnName = "AdsDate";
colvarAdsDate.DataType = DbType.DateTime;
colvarAdsDate.MaxLength = 0;
colvarAdsDate.AutoIncrement = false;
colvarAdsDate.IsNullable = true;
colvarAdsDate.IsPrimaryKey = false;
colvarAdsDate.IsForeignKey = false;
colvarAdsDate.IsReadOnly = false;
colvarAdsDate.DefaultSetting = @"";
colvarAdsDate.ForeignKeyTableName = "";
colvarAdsDate.ApplyExtendedProperties();
this.Columns.Add(colvarAdsDate);
TableSchema.TableColumn colvarAdsEndDate = new TableSchema.TableColumn(this);
colvarAdsEndDate.ColumnName = "AdsEndDate";
colvarAdsEndDate.DataType = DbType.DateTime;
colvarAdsEndDate.MaxLength = 0;
colvarAdsEndDate.AutoIncrement = false;
colvarAdsEndDate.IsNullable = true;
colvarAdsEndDate.IsPrimaryKey = false;
colvarAdsEndDate.IsForeignKey = false;
colvarAdsEndDate.IsReadOnly = false;
colvarAdsEndDate.DefaultSetting = @"";
colvarAdsEndDate.ForeignKeyTableName = "";
colvarAdsEndDate.ApplyExtendedProperties();
this.Columns.Add(colvarAdsEndDate);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarCashOrderID = new TableSchema.TableColumn(this);
colvarCashOrderID.ColumnName = "CashOrderID";
colvarCashOrderID.DataType = DbType.Int32;
colvarCashOrderID.MaxLength = 0;
colvarCashOrderID.AutoIncrement = false;
colvarCashOrderID.IsNullable = true;
colvarCashOrderID.IsPrimaryKey = false;
colvarCashOrderID.IsForeignKey = false;
colvarCashOrderID.IsReadOnly = false;
colvarCashOrderID.DefaultSetting = @"";
colvarCashOrderID.ForeignKeyTableName = "";
colvarCashOrderID.ApplyExtendedProperties();
this.Columns.Add(colvarCashOrderID);
TableSchema.TableColumn colvarCashCompanyID = new TableSchema.TableColumn(this);
colvarCashCompanyID.ColumnName = "CashCompanyID";
colvarCashCompanyID.DataType = DbType.Int32;
colvarCashCompanyID.MaxLength = 0;
colvarCashCompanyID.AutoIncrement = false;
colvarCashCompanyID.IsNullable = true;
colvarCashCompanyID.IsPrimaryKey = false;
colvarCashCompanyID.IsForeignKey = false;
colvarCashCompanyID.IsReadOnly = false;
colvarCashCompanyID.ExtendedProperties.Add(new TableSchema.ExtendedProperty("SSX_COLUMN_DISPLAY_NAME","储值商家ID"));
colvarCashCompanyID.DefaultSetting = @"";
colvarCashCompanyID.ForeignKeyTableName = "";
colvarCashCompanyID.ApplyExtendedProperties();
this.Columns.Add(colvarCashCompanyID);
TableSchema.TableColumn colvarCashSum = new TableSchema.TableColumn(this);
colvarCashSum.ColumnName = "CashSum";
colvarCashSum.DataType = DbType.Int32;
colvarCashSum.MaxLength = 0;
colvarCashSum.AutoIncrement = false;
colvarCashSum.IsNullable = false;
colvarCashSum.IsPrimaryKey = false;
colvarCashSum.IsForeignKey = false;
colvarCashSum.IsReadOnly = false;
colvarCashSum.DefaultSetting = @"";
colvarCashSum.ForeignKeyTableName = "";
colvarCashSum.ApplyExtendedProperties();
this.Columns.Add(colvarCashSum);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarSupportTypeId = new TableSchema.TableColumn(this);
colvarSupportTypeId.ColumnName = "SupportType_ID";
colvarSupportTypeId.DataType = DbType.Int32;
colvarSupportTypeId.MaxLength = 0;
colvarSupportTypeId.AutoIncrement = true;
colvarSupportTypeId.IsNullable = false;
colvarSupportTypeId.IsPrimaryKey = true;
colvarSupportTypeId.IsForeignKey = false;
colvarSupportTypeId.IsReadOnly = false;
colvarSupportTypeId.DefaultSetting = @"";
colvarSupportTypeId.ForeignKeyTableName = "";
colvarSupportTypeId.ApplyExtendedProperties();
this.Columns.Add(colvarSupportTypeId);
TableSchema.TableColumn colvarSupportTypeName = new TableSchema.TableColumn(this);
colvarSupportTypeName.ColumnName = "SupportType_Name";
colvarSupportTypeName.DataType = DbType.String;
colvarSupportTypeName.MaxLength = 50;
colvarSupportTypeName.AutoIncrement = false;
colvarSupportTypeName.IsNullable = false;
colvarSupportTypeName.IsPrimaryKey = false;
colvarSupportTypeName.IsForeignKey = false;
colvarSupportTypeName.IsReadOnly = false;
colvarSupportTypeName.DefaultSetting = @"";
colvarSupportTypeName.ForeignKeyTableName = "";
colvarSupportTypeName.ApplyExtendedProperties();
this.Columns.Add(colvarSupportTypeName);
TableSchema.TableColumn colvarSupportTypeDesc = new TableSchema.TableColumn(this);
colvarSupportTypeDesc.ColumnName = "SupportType_Desc";
colvarSupportTypeDesc.DataType = DbType.String;
colvarSupportTypeDesc.MaxLength = 255;
colvarSupportTypeDesc.AutoIncrement = false;
colvarSupportTypeDesc.IsNullable = false;
colvarSupportTypeDesc.IsPrimaryKey = false;
colvarSupportTypeDesc.IsForeignKey = false;
colvarSupportTypeDesc.IsReadOnly = false;
colvarSupportTypeDesc.DefaultSetting = @"";
colvarSupportTypeDesc.ForeignKeyTableName = "";
colvarSupportTypeDesc.ApplyExtendedProperties();
this.Columns.Add(colvarSupportTypeDesc);
TableSchema.TableColumn colvarSupportTypePhoto = new TableSchema.TableColumn(this);
colvarSupportTypePhoto.ColumnName = "SupportType_Photo";
colvarSupportTypePhoto.DataType = DbType.String;
colvarSupportTypePhoto.MaxLength = 50;
colvarSupportTypePhoto.AutoIncrement = false;
colvarSupportTypePhoto.IsNullable = false;
colvarSupportTypePhoto.IsPrimaryKey = false;
colvarSupportTypePhoto.IsForeignKey = false;
colvarSupportTypePhoto.IsReadOnly = false;
colvarSupportTypePhoto.DefaultSetting = @"";
colvarSupportTypePhoto.ForeignKeyTableName = "";
colvarSupportTypePhoto.ApplyExtendedProperties();
this.Columns.Add(colvarSupportTypePhoto);
TableSchema.TableColumn colvarSupportTypePid = new TableSchema.TableColumn(this);
colvarSupportTypePid.ColumnName = "SupportType_PID";
colvarSupportTypePid.DataType = DbType.Int32;
colvarSupportTypePid.MaxLength = 0;
colvarSupportTypePid.AutoIncrement = false;
colvarSupportTypePid.IsNullable = false;
colvarSupportTypePid.IsPrimaryKey = false;
colvarSupportTypePid.IsForeignKey = false;
colvarSupportTypePid.IsReadOnly = false;
colvarSupportTypePid.DefaultSetting = @"";
colvarSupportTypePid.ForeignKeyTableName = "";
colvarSupportTypePid.ApplyExtendedProperties();
this.Columns.Add(colvarSupportTypePid);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarAdsID = new TableSchema.TableColumn(this);
colvarAdsID.ColumnName = "AdsID";
colvarAdsID.DataType = DbType.Int32;
colvarAdsID.MaxLength = 0;
colvarAdsID.AutoIncrement = true;
colvarAdsID.IsNullable = false;
colvarAdsID.IsPrimaryKey = true;
colvarAdsID.IsForeignKey = false;
colvarAdsID.IsReadOnly = false;
colvarAdsID.DefaultSetting = @"";
colvarAdsID.ForeignKeyTableName = "";
colvarAdsID.ApplyExtendedProperties();
this.Columns.Add(colvarAdsID);
TableSchema.TableColumn colvarAdsTitle = new TableSchema.TableColumn(this);
colvarAdsTitle.ColumnName = "AdsTitle";
colvarAdsTitle.DataType = DbType.String;
colvarAdsTitle.MaxLength = 500;
colvarAdsTitle.AutoIncrement = false;
colvarAdsTitle.IsNullable = true;
colvarAdsTitle.IsPrimaryKey = false;
colvarAdsTitle.IsForeignKey = false;
colvarAdsTitle.IsReadOnly = false;
colvarAdsTitle.DefaultSetting = @"";
colvarAdsTitle.ForeignKeyTableName = "";
colvarAdsTitle.ApplyExtendedProperties();
this.Columns.Add(colvarAdsTitle);
TableSchema.TableColumn colvarAdsCompanyID = new TableSchema.TableColumn(this);
colvarAdsCompanyID.ColumnName = "AdsCompanyID";
colvarAdsCompanyID.DataType = DbType.Int32;
colvarAdsCompanyID.MaxLength = 0;
colvarAdsCompanyID.AutoIncrement = false;
colvarAdsCompanyID.IsNullable = true;
colvarAdsCompanyID.IsPrimaryKey = false;
colvarAdsCompanyID.IsForeignKey = false;
colvarAdsCompanyID.IsReadOnly = false;
colvarAdsCompanyID.DefaultSetting = @"";
colvarAdsCompanyID.ForeignKeyTableName = "";
colvarAdsCompanyID.ApplyExtendedProperties();
this.Columns.Add(colvarAdsCompanyID);
TableSchema.TableColumn colvarAdsDate = new TableSchema.TableColumn(this);
colvarAdsDate.ColumnName = "AdsDate";
colvarAdsDate.DataType = DbType.DateTime;
colvarAdsDate.MaxLength = 0;
colvarAdsDate.AutoIncrement = false;
colvarAdsDate.IsNullable = true;
colvarAdsDate.IsPrimaryKey = false;
colvarAdsDate.IsForeignKey = false;
colvarAdsDate.IsReadOnly = false;
colvarAdsDate.DefaultSetting = @"";
colvarAdsDate.ForeignKeyTableName = "";
colvarAdsDate.ApplyExtendedProperties();
this.Columns.Add(colvarAdsDate);
TableSchema.TableColumn colvarAdsEndDate = new TableSchema.TableColumn(this);
colvarAdsEndDate.ColumnName = "AdsEndDate";
colvarAdsEndDate.DataType = DbType.DateTime;
colvarAdsEndDate.MaxLength = 0;
colvarAdsEndDate.AutoIncrement = false;
colvarAdsEndDate.IsNullable = true;
colvarAdsEndDate.IsPrimaryKey = false;
colvarAdsEndDate.IsForeignKey = false;
colvarAdsEndDate.IsReadOnly = false;
colvarAdsEndDate.DefaultSetting = @"";
colvarAdsEndDate.ForeignKeyTableName = "";
colvarAdsEndDate.ApplyExtendedProperties();
this.Columns.Add(colvarAdsEndDate);
TableSchema.TableColumn colvarAreaDepth = new TableSchema.TableColumn(this);
colvarAreaDepth.ColumnName = "AreaDepth";
colvarAreaDepth.DataType = DbType.String;
colvarAreaDepth.MaxLength = 500;
colvarAreaDepth.AutoIncrement = false;
colvarAreaDepth.IsNullable = true;
colvarAreaDepth.IsPrimaryKey = false;
colvarAreaDepth.IsForeignKey = false;
colvarAreaDepth.IsReadOnly = false;
colvarAreaDepth.ExtendedProperties.Add(new TableSchema.ExtendedProperty("SSX_COLUMN_DISPLAY_NAME","投放商圈"));
colvarAreaDepth.DefaultSetting = @"";
colvarAreaDepth.ForeignKeyTableName = "";
colvarAreaDepth.ApplyExtendedProperties();
this.Columns.Add(colvarAreaDepth);
TableSchema.TableColumn colvarSexLimit = new TableSchema.TableColumn(this);
colvarSexLimit.ColumnName = "SexLimit";
colvarSexLimit.DataType = DbType.Int32;
colvarSexLimit.MaxLength = 0;
colvarSexLimit.AutoIncrement = false;
colvarSexLimit.IsNullable = true;
colvarSexLimit.IsPrimaryKey = false;
colvarSexLimit.IsForeignKey = false;
colvarSexLimit.IsReadOnly = false;
colvarSexLimit.ExtendedProperties.Add(new TableSchema.ExtendedProperty("SSX_COLUMN_DISPLAY_NAME","性别限制 0 无限制 1 限男 2 限女"));
colvarSexLimit.DefaultSetting = @"";
colvarSexLimit.ForeignKeyTableName = "";
colvarSexLimit.ApplyExtendedProperties();
this.Columns.Add(colvarSexLimit);
TableSchema.TableColumn colvarIsDeleted = new TableSchema.TableColumn(this);
colvarIsDeleted.ColumnName = "IsDeleted";
colvarIsDeleted.DataType = DbType.Boolean;
colvarIsDeleted.MaxLength = 0;
colvarIsDeleted.AutoIncrement = false;
colvarIsDeleted.IsNullable = true;
colvarIsDeleted.IsPrimaryKey = false;
colvarIsDeleted.IsForeignKey = false;
colvarIsDeleted.IsReadOnly = false;
colvarIsDeleted.DefaultSetting = @"";
colvarIsDeleted.ForeignKeyTableName = "";
colvarIsDeleted.ApplyExtendedProperties();
this.Columns.Add(colvarIsDeleted);
TableSchema.TableColumn colvarAdsClicked = new TableSchema.TableColumn(this);
colvarAdsClicked.ColumnName = "AdsClicked";
colvarAdsClicked.DataType = DbType.Int32;
colvarAdsClicked.MaxLength = 0;
colvarAdsClicked.AutoIncrement = false;
colvarAdsClicked.IsNullable = true;
colvarAdsClicked.IsPrimaryKey = false;
colvarAdsClicked.IsForeignKey = false;
colvarAdsClicked.IsReadOnly = false;
colvarAdsClicked.DefaultSetting = @"";
colvarAdsClicked.ForeignKeyTableName = "";
colvarAdsClicked.ApplyExtendedProperties();
this.Columns.Add(colvarAdsClicked);
TableSchema.TableColumn colvarAdsPic = new TableSchema.TableColumn(this);
colvarAdsPic.ColumnName = "AdsPic";
colvarAdsPic.DataType = DbType.String;
colvarAdsPic.MaxLength = 150;
colvarAdsPic.AutoIncrement = false;
colvarAdsPic.IsNullable = true;
colvarAdsPic.IsPrimaryKey = false;
colvarAdsPic.IsForeignKey = false;
colvarAdsPic.IsReadOnly = false;
colvarAdsPic.DefaultSetting = @"";
colvarAdsPic.ForeignKeyTableName = "";
colvarAdsPic.ApplyExtendedProperties();
this.Columns.Add(colvarAdsPic);
TableSchema.TableColumn colvarIsPass = new TableSchema.TableColumn(this);
colvarIsPass.ColumnName = "IsPass";
colvarIsPass.DataType = DbType.Boolean;
colvarIsPass.MaxLength = 0;
colvarIsPass.AutoIncrement = false;
colvarIsPass.IsNullable = true;
colvarIsPass.IsPrimaryKey = false;
colvarIsPass.IsForeignKey = false;
colvarIsPass.IsReadOnly = false;
colvarIsPass.DefaultSetting = @"";
colvarIsPass.ForeignKeyTableName = "";
colvarIsPass.ApplyExtendedProperties();
this.Columns.Add(colvarIsPass);
TableSchema.TableColumn colvarAdsClickLimit = new TableSchema.TableColumn(this);
colvarAdsClickLimit.ColumnName = "AdsClickLimit";
colvarAdsClickLimit.DataType = DbType.Int32;
colvarAdsClickLimit.MaxLength = 0;
colvarAdsClickLimit.AutoIncrement = false;
colvarAdsClickLimit.IsNullable = true;
colvarAdsClickLimit.IsPrimaryKey = false;
colvarAdsClickLimit.IsForeignKey = false;
colvarAdsClickLimit.IsReadOnly = false;
colvarAdsClickLimit.DefaultSetting = @"";
colvarAdsClickLimit.ForeignKeyTableName = "";
colvarAdsClickLimit.ApplyExtendedProperties();
this.Columns.Add(colvarAdsClickLimit);
TableSchema.TableColumn colvarAdsMemberLimit = new TableSchema.TableColumn(this);
colvarAdsMemberLimit.ColumnName = "AdsMemberLimit";
colvarAdsMemberLimit.DataType = DbType.Int32;
colvarAdsMemberLimit.MaxLength = 0;
colvarAdsMemberLimit.AutoIncrement = false;
colvarAdsMemberLimit.IsNullable = true;
colvarAdsMemberLimit.IsPrimaryKey = false;
colvarAdsMemberLimit.IsForeignKey = false;
colvarAdsMemberLimit.IsReadOnly = false;
colvarAdsMemberLimit.DefaultSetting = @"";
colvarAdsMemberLimit.ForeignKeyTableName = "";
colvarAdsMemberLimit.ApplyExtendedProperties();
this.Columns.Add(colvarAdsMemberLimit);
TableSchema.TableColumn colvarAdsDayLimitAmount = new TableSchema.TableColumn(this);
colvarAdsDayLimitAmount.ColumnName = "AdsDayLimitAmount";
colvarAdsDayLimitAmount.DataType = DbType.Int32;
colvarAdsDayLimitAmount.MaxLength = 0;
colvarAdsDayLimitAmount.AutoIncrement = false;
colvarAdsDayLimitAmount.IsNullable = true;
colvarAdsDayLimitAmount.IsPrimaryKey = false;
colvarAdsDayLimitAmount.IsForeignKey = false;
colvarAdsDayLimitAmount.IsReadOnly = false;
colvarAdsDayLimitAmount.DefaultSetting = @"";
colvarAdsDayLimitAmount.ForeignKeyTableName = "";
colvarAdsDayLimitAmount.ApplyExtendedProperties();
this.Columns.Add(colvarAdsDayLimitAmount);
TableSchema.TableColumn colvarAdsDayLimitSum = new TableSchema.TableColumn(this);
colvarAdsDayLimitSum.ColumnName = "AdsDayLimitSum";
colvarAdsDayLimitSum.DataType = DbType.Decimal;
colvarAdsDayLimitSum.MaxLength = 0;
colvarAdsDayLimitSum.AutoIncrement = false;
colvarAdsDayLimitSum.IsNullable = true;
colvarAdsDayLimitSum.IsPrimaryKey = false;
colvarAdsDayLimitSum.IsForeignKey = false;
colvarAdsDayLimitSum.IsReadOnly = false;
colvarAdsDayLimitSum.DefaultSetting = @"";
colvarAdsDayLimitSum.ForeignKeyTableName = "";
colvarAdsDayLimitSum.ApplyExtendedProperties();
this.Columns.Add(colvarAdsDayLimitSum);
TableSchema.TableColumn colvarAdsQuestion = new TableSchema.TableColumn(this);
colvarAdsQuestion.ColumnName = "AdsQuestion";
colvarAdsQuestion.DataType = DbType.String;
colvarAdsQuestion.MaxLength = 500;
colvarAdsQuestion.AutoIncrement = false;
colvarAdsQuestion.IsNullable = true;
colvarAdsQuestion.IsPrimaryKey = false;
colvarAdsQuestion.IsForeignKey = false;
colvarAdsQuestion.IsReadOnly = false;
colvarAdsQuestion.DefaultSetting = @"";
colvarAdsQuestion.ForeignKeyTableName = "";
colvarAdsQuestion.ApplyExtendedProperties();
this.Columns.Add(colvarAdsQuestion);
TableSchema.TableColumn colvarAdsAnswer1 = new TableSchema.TableColumn(this);
colvarAdsAnswer1.ColumnName = "AdsAnswer1";
colvarAdsAnswer1.DataType = DbType.String;
colvarAdsAnswer1.MaxLength = 500;
colvarAdsAnswer1.AutoIncrement = false;
colvarAdsAnswer1.IsNullable = true;
colvarAdsAnswer1.IsPrimaryKey = false;
colvarAdsAnswer1.IsForeignKey = false;
colvarAdsAnswer1.IsReadOnly = false;
colvarAdsAnswer1.DefaultSetting = @"";
colvarAdsAnswer1.ForeignKeyTableName = "";
colvarAdsAnswer1.ApplyExtendedProperties();
this.Columns.Add(colvarAdsAnswer1);
TableSchema.TableColumn colvarAdsAnswer2 = new TableSchema.TableColumn(this);
colvarAdsAnswer2.ColumnName = "AdsAnswer2";
colvarAdsAnswer2.DataType = DbType.String;
colvarAdsAnswer2.MaxLength = 500;
colvarAdsAnswer2.AutoIncrement = false;
colvarAdsAnswer2.IsNullable = true;
colvarAdsAnswer2.IsPrimaryKey = false;
colvarAdsAnswer2.IsForeignKey = false;
colvarAdsAnswer2.IsReadOnly = false;
colvarAdsAnswer2.DefaultSetting = @"";
colvarAdsAnswer2.ForeignKeyTableName = "";
colvarAdsAnswer2.ApplyExtendedProperties();
this.Columns.Add(colvarAdsAnswer2);
TableSchema.TableColumn colvarAdsAnswer3 = new TableSchema.TableColumn(this);
colvarAdsAnswer3.ColumnName = "AdsAnswer3";
colvarAdsAnswer3.DataType = DbType.String;
colvarAdsAnswer3.MaxLength = 500;
colvarAdsAnswer3.AutoIncrement = false;
colvarAdsAnswer3.IsNullable = true;
colvarAdsAnswer3.IsPrimaryKey = false;
colvarAdsAnswer3.IsForeignKey = false;
colvarAdsAnswer3.IsReadOnly = false;
colvarAdsAnswer3.DefaultSetting = @"";
colvarAdsAnswer3.ForeignKeyTableName = "";
colvarAdsAnswer3.ApplyExtendedProperties();
this.Columns.Add(colvarAdsAnswer3);
TableSchema.TableColumn colvarAdsAnswer4 = new TableSchema.TableColumn(this);
colvarAdsAnswer4.ColumnName = "AdsAnswer4";
colvarAdsAnswer4.DataType = DbType.String;
colvarAdsAnswer4.MaxLength = 500;
colvarAdsAnswer4.AutoIncrement = false;
colvarAdsAnswer4.IsNullable = true;
colvarAdsAnswer4.IsPrimaryKey = false;
colvarAdsAnswer4.IsForeignKey = false;
colvarAdsAnswer4.IsReadOnly = false;
colvarAdsAnswer4.DefaultSetting = @"";
colvarAdsAnswer4.ForeignKeyTableName = "";
colvarAdsAnswer4.ApplyExtendedProperties();
this.Columns.Add(colvarAdsAnswer4);
TableSchema.TableColumn colvarAdsRightAnswer = new TableSchema.TableColumn(this);
colvarAdsRightAnswer.ColumnName = "AdsRightAnswer";
colvarAdsRightAnswer.DataType = DbType.Int32;
colvarAdsRightAnswer.MaxLength = 0;
colvarAdsRightAnswer.AutoIncrement = false;
colvarAdsRightAnswer.IsNullable = true;
colvarAdsRightAnswer.IsPrimaryKey = false;
colvarAdsRightAnswer.IsForeignKey = false;
colvarAdsRightAnswer.IsReadOnly = false;
colvarAdsRightAnswer.DefaultSetting = @"";
colvarAdsRightAnswer.ForeignKeyTableName = "";
colvarAdsRightAnswer.ApplyExtendedProperties();
this.Columns.Add(colvarAdsRightAnswer);
TableSchema.TableColumn colvarAdsPointSum = new TableSchema.TableColumn(this);
colvarAdsPointSum.ColumnName = "AdsPointSum";
colvarAdsPointSum.DataType = DbType.Decimal;
colvarAdsPointSum.MaxLength = 0;
colvarAdsPointSum.AutoIncrement = false;
colvarAdsPointSum.IsNullable = true;
colvarAdsPointSum.IsPrimaryKey = false;
colvarAdsPointSum.IsForeignKey = false;
colvarAdsPointSum.IsReadOnly = false;
colvarAdsPointSum.DefaultSetting = @"";
colvarAdsPointSum.ForeignKeyTableName = "";
colvarAdsPointSum.ApplyExtendedProperties();
this.Columns.Add(colvarAdsPointSum);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarNoteSubject = new TableSchema.TableColumn(this);
colvarNoteSubject.ColumnName = "NoteSubject";
colvarNoteSubject.DataType = DbType.String;
colvarNoteSubject.MaxLength = 250;
colvarNoteSubject.AutoIncrement = false;
colvarNoteSubject.IsNullable = false;
colvarNoteSubject.IsPrimaryKey = false;
colvarNoteSubject.IsForeignKey = false;
colvarNoteSubject.IsReadOnly = false;
colvarNoteSubject.DefaultSetting = @"";
colvarNoteSubject.ForeignKeyTableName = "";
colvarNoteSubject.ApplyExtendedProperties();
this.Columns.Add(colvarNoteSubject);
TableSchema.TableColumn colvarNoteContent = new TableSchema.TableColumn(this);
colvarNoteContent.ColumnName = "NoteContent";
colvarNoteContent.DataType = DbType.String;
colvarNoteContent.MaxLength = 1073741823;
colvarNoteContent.AutoIncrement = false;
colvarNoteContent.IsNullable = true;
colvarNoteContent.IsPrimaryKey = false;
colvarNoteContent.IsForeignKey = false;
colvarNoteContent.IsReadOnly = false;
colvarNoteContent.DefaultSetting = @"";
colvarNoteContent.ForeignKeyTableName = "";
colvarNoteContent.ApplyExtendedProperties();
this.Columns.Add(colvarNoteContent);
TableSchema.TableColumn colvarNoteDate = new TableSchema.TableColumn(this);
colvarNoteDate.ColumnName = "NoteDate";
colvarNoteDate.DataType = DbType.DateTime;
colvarNoteDate.MaxLength = 0;
colvarNoteDate.AutoIncrement = false;
colvarNoteDate.IsNullable = true;
colvarNoteDate.IsPrimaryKey = false;
colvarNoteDate.IsForeignKey = false;
colvarNoteDate.IsReadOnly = false;
colvarNoteDate.DefaultSetting = @"";
colvarNoteDate.ForeignKeyTableName = "";
colvarNoteDate.ApplyExtendedProperties();
this.Columns.Add(colvarNoteDate);
TableSchema.TableColumn colvarNoteStatus = new TableSchema.TableColumn(this);
colvarNoteStatus.ColumnName = "NoteStatus";
colvarNoteStatus.DataType = DbType.Int32;
colvarNoteStatus.MaxLength = 0;
colvarNoteStatus.AutoIncrement = false;
colvarNoteStatus.IsNullable = false;
colvarNoteStatus.IsPrimaryKey = false;
colvarNoteStatus.IsForeignKey = false;
colvarNoteStatus.IsReadOnly = false;
colvarNoteStatus.DefaultSetting = @"";
colvarNoteStatus.ForeignKeyTableName = "";
colvarNoteStatus.ApplyExtendedProperties();
this.Columns.Add(colvarNoteStatus);
TableSchema.TableColumn colvarNoteHots = new TableSchema.TableColumn(this);
colvarNoteHots.ColumnName = "NoteHots";
colvarNoteHots.DataType = DbType.Int32;
colvarNoteHots.MaxLength = 0;
colvarNoteHots.AutoIncrement = false;
colvarNoteHots.IsNullable = false;
colvarNoteHots.IsPrimaryKey = false;
colvarNoteHots.IsForeignKey = false;
colvarNoteHots.IsReadOnly = false;
colvarNoteHots.DefaultSetting = @"";
colvarNoteHots.ForeignKeyTableName = "";
colvarNoteHots.ApplyExtendedProperties();
this.Columns.Add(colvarNoteHots);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarAreaID = new TableSchema.TableColumn(this);
colvarAreaID.ColumnName = "AreaID";
colvarAreaID.DataType = DbType.Int32;
colvarAreaID.MaxLength = 0;
colvarAreaID.AutoIncrement = false;
colvarAreaID.IsNullable = true;
colvarAreaID.IsPrimaryKey = false;
colvarAreaID.IsForeignKey = false;
colvarAreaID.IsReadOnly = false;
colvarAreaID.DefaultSetting = @"";
colvarAreaID.ForeignKeyTableName = "";
colvarAreaID.ApplyExtendedProperties();
this.Columns.Add(colvarAreaID);
TableSchema.TableColumn colvarName = new TableSchema.TableColumn(this);
colvarName.ColumnName = "Name";
colvarName.DataType = DbType.String;
colvarName.MaxLength = 250;
colvarName.AutoIncrement = false;
colvarName.IsNullable = true;
colvarName.IsPrimaryKey = false;
colvarName.IsForeignKey = false;
colvarName.IsReadOnly = false;
colvarName.DefaultSetting = @"";
colvarName.ForeignKeyTableName = "";
colvarName.ApplyExtendedProperties();
this.Columns.Add(colvarName);
TableSchema.TableColumn colvarAreaDepth = new TableSchema.TableColumn(this);
colvarAreaDepth.ColumnName = "AreaDepth";
colvarAreaDepth.DataType = DbType.String;
colvarAreaDepth.MaxLength = 50;
colvarAreaDepth.AutoIncrement = false;
colvarAreaDepth.IsNullable = true;
colvarAreaDepth.IsPrimaryKey = false;
colvarAreaDepth.IsForeignKey = false;
colvarAreaDepth.IsReadOnly = false;
colvarAreaDepth.DefaultSetting = @"";
colvarAreaDepth.ForeignKeyTableName = "";
colvarAreaDepth.ApplyExtendedProperties();
this.Columns.Add(colvarAreaDepth);
TableSchema.TableColumn colvarCode = new TableSchema.TableColumn(this);
colvarCode.ColumnName = "Code";
colvarCode.DataType = DbType.String;
colvarCode.MaxLength = 50;
colvarCode.AutoIncrement = false;
colvarCode.IsNullable = true;
colvarCode.IsPrimaryKey = false;
colvarCode.IsForeignKey = false;
colvarCode.IsReadOnly = false;
colvarCode.DefaultSetting = @"";
colvarCode.ForeignKeyTableName = "";
colvarCode.ApplyExtendedProperties();
this.Columns.Add(colvarCode);
TableSchema.TableColumn colvarAddress = new TableSchema.TableColumn(this);
colvarAddress.ColumnName = "Address";
colvarAddress.DataType = DbType.String;
colvarAddress.MaxLength = 250;
colvarAddress.AutoIncrement = false;
colvarAddress.IsNullable = true;
colvarAddress.IsPrimaryKey = false;
colvarAddress.IsForeignKey = false;
colvarAddress.IsReadOnly = false;
colvarAddress.DefaultSetting = @"";
colvarAddress.ForeignKeyTableName = "";
colvarAddress.ApplyExtendedProperties();
this.Columns.Add(colvarAddress);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarPaymentCode = new TableSchema.TableColumn(this);
colvarPaymentCode.ColumnName = "PaymentCode";
colvarPaymentCode.DataType = DbType.String;
colvarPaymentCode.MaxLength = 50;
colvarPaymentCode.AutoIncrement = false;
colvarPaymentCode.IsNullable = false;
colvarPaymentCode.IsPrimaryKey = false;
colvarPaymentCode.IsForeignKey = false;
colvarPaymentCode.IsReadOnly = false;
colvarPaymentCode.DefaultSetting = @"";
colvarPaymentCode.ForeignKeyTableName = "";
colvarPaymentCode.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentCode);
TableSchema.TableColumn colvarPaymentDate = new TableSchema.TableColumn(this);
colvarPaymentDate.ColumnName = "PaymentDate";
colvarPaymentDate.DataType = DbType.DateTime;
colvarPaymentDate.MaxLength = 0;
colvarPaymentDate.AutoIncrement = false;
colvarPaymentDate.IsNullable = false;
colvarPaymentDate.IsPrimaryKey = false;
colvarPaymentDate.IsForeignKey = false;
colvarPaymentDate.IsReadOnly = false;
colvarPaymentDate.DefaultSetting = @"";
colvarPaymentDate.ForeignKeyTableName = "";
colvarPaymentDate.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentDate);
TableSchema.TableColumn colvarPaymentMemberID = new TableSchema.TableColumn(this);
colvarPaymentMemberID.ColumnName = "PaymentMemberID";
colvarPaymentMemberID.DataType = DbType.Int32;
colvarPaymentMemberID.MaxLength = 0;
colvarPaymentMemberID.AutoIncrement = false;
colvarPaymentMemberID.IsNullable = true;
colvarPaymentMemberID.IsPrimaryKey = false;
colvarPaymentMemberID.IsForeignKey = false;
colvarPaymentMemberID.IsReadOnly = false;
colvarPaymentMemberID.DefaultSetting = @"";
colvarPaymentMemberID.ForeignKeyTableName = "";
colvarPaymentMemberID.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentMemberID);
TableSchema.TableColumn colvarPaymentCompanyID = new TableSchema.TableColumn(this);
colvarPaymentCompanyID.ColumnName = "PaymentCompanyID";
colvarPaymentCompanyID.DataType = DbType.Int32;
colvarPaymentCompanyID.MaxLength = 0;
colvarPaymentCompanyID.AutoIncrement = false;
colvarPaymentCompanyID.IsNullable = true;
colvarPaymentCompanyID.IsPrimaryKey = false;
colvarPaymentCompanyID.IsForeignKey = false;
colvarPaymentCompanyID.IsReadOnly = false;
colvarPaymentCompanyID.DefaultSetting = @"";
colvarPaymentCompanyID.ForeignKeyTableName = "";
colvarPaymentCompanyID.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentCompanyID);
TableSchema.TableColumn colvarPaymentEmail = new TableSchema.TableColumn(this);
colvarPaymentEmail.ColumnName = "PaymentEmail";
colvarPaymentEmail.DataType = DbType.String;
colvarPaymentEmail.MaxLength = 50;
colvarPaymentEmail.AutoIncrement = false;
colvarPaymentEmail.IsNullable = false;
colvarPaymentEmail.IsPrimaryKey = false;
colvarPaymentEmail.IsForeignKey = false;
colvarPaymentEmail.IsReadOnly = false;
colvarPaymentEmail.DefaultSetting = @"";
colvarPaymentEmail.ForeignKeyTableName = "";
colvarPaymentEmail.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentEmail);
TableSchema.TableColumn colvarPaymentSum = new TableSchema.TableColumn(this);
colvarPaymentSum.ColumnName = "PaymentSum";
colvarPaymentSum.DataType = DbType.Decimal;
colvarPaymentSum.MaxLength = 0;
colvarPaymentSum.AutoIncrement = false;
colvarPaymentSum.IsNullable = false;
colvarPaymentSum.IsPrimaryKey = false;
colvarPaymentSum.IsForeignKey = false;
colvarPaymentSum.IsReadOnly = false;
colvarPaymentSum.DefaultSetting = @"";
colvarPaymentSum.ForeignKeyTableName = "";
colvarPaymentSum.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentSum);
TableSchema.TableColumn colvarPaymentMemo = new TableSchema.TableColumn(this);
colvarPaymentMemo.ColumnName = "PaymentMemo";
colvarPaymentMemo.DataType = DbType.String;
colvarPaymentMemo.MaxLength = 50;
colvarPaymentMemo.AutoIncrement = false;
colvarPaymentMemo.IsNullable = false;
colvarPaymentMemo.IsPrimaryKey = false;
colvarPaymentMemo.IsForeignKey = false;
colvarPaymentMemo.IsReadOnly = false;
colvarPaymentMemo.DefaultSetting = @"";
colvarPaymentMemo.ForeignKeyTableName = "";
colvarPaymentMemo.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentMemo);
TableSchema.TableColumn colvarPaymentStatus = new TableSchema.TableColumn(this);
colvarPaymentStatus.ColumnName = "PaymentStatus";
colvarPaymentStatus.DataType = DbType.Int32;
colvarPaymentStatus.MaxLength = 0;
colvarPaymentStatus.AutoIncrement = false;
colvarPaymentStatus.IsNullable = false;
colvarPaymentStatus.IsPrimaryKey = false;
colvarPaymentStatus.IsForeignKey = false;
colvarPaymentStatus.IsReadOnly = false;
colvarPaymentStatus.DefaultSetting = @"";
colvarPaymentStatus.ForeignKeyTableName = "";
colvarPaymentStatus.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentStatus);
TableSchema.TableColumn colvarPaymentType = new TableSchema.TableColumn(this);
colvarPaymentType.ColumnName = "PaymentType";
colvarPaymentType.DataType = DbType.Int32;
colvarPaymentType.MaxLength = 0;
colvarPaymentType.AutoIncrement = false;
colvarPaymentType.IsNullable = true;
colvarPaymentType.IsPrimaryKey = false;
colvarPaymentType.IsForeignKey = false;
colvarPaymentType.IsReadOnly = false;
colvarPaymentType.DefaultSetting = @"";
colvarPaymentType.ForeignKeyTableName = "";
colvarPaymentType.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentType);
TableSchema.TableColumn colvarPaymentOrderID = new TableSchema.TableColumn(this);
colvarPaymentOrderID.ColumnName = "PaymentOrderID";
colvarPaymentOrderID.DataType = DbType.Int32;
colvarPaymentOrderID.MaxLength = 0;
colvarPaymentOrderID.AutoIncrement = false;
colvarPaymentOrderID.IsNullable = true;
colvarPaymentOrderID.IsPrimaryKey = false;
colvarPaymentOrderID.IsForeignKey = false;
colvarPaymentOrderID.IsReadOnly = false;
colvarPaymentOrderID.DefaultSetting = @"";
colvarPaymentOrderID.ForeignKeyTableName = "";
colvarPaymentOrderID.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentOrderID);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarSupportMsgId = new TableSchema.TableColumn(this);
colvarSupportMsgId.ColumnName = "SupportMsg_ID";
colvarSupportMsgId.DataType = DbType.Int32;
colvarSupportMsgId.MaxLength = 0;
colvarSupportMsgId.AutoIncrement = true;
colvarSupportMsgId.IsNullable = false;
colvarSupportMsgId.IsPrimaryKey = true;
colvarSupportMsgId.IsForeignKey = false;
colvarSupportMsgId.IsReadOnly = false;
colvarSupportMsgId.DefaultSetting = @"";
colvarSupportMsgId.ForeignKeyTableName = "";
colvarSupportMsgId.ApplyExtendedProperties();
this.Columns.Add(colvarSupportMsgId);
TableSchema.TableColumn colvarSupportMsgSid = new TableSchema.TableColumn(this);
colvarSupportMsgSid.ColumnName = "SupportMsg_SID";
colvarSupportMsgSid.DataType = DbType.Int32;
colvarSupportMsgSid.MaxLength = 0;
colvarSupportMsgSid.AutoIncrement = false;
colvarSupportMsgSid.IsNullable = false;
colvarSupportMsgSid.IsPrimaryKey = false;
colvarSupportMsgSid.IsForeignKey = false;
colvarSupportMsgSid.IsReadOnly = false;
colvarSupportMsgSid.DefaultSetting = @"";
colvarSupportMsgSid.ForeignKeyTableName = "";
colvarSupportMsgSid.ApplyExtendedProperties();
this.Columns.Add(colvarSupportMsgSid);
TableSchema.TableColumn colvarSupportMsgFid = new TableSchema.TableColumn(this);
colvarSupportMsgFid.ColumnName = "SupportMsg_FID";
colvarSupportMsgFid.DataType = DbType.Int32;
colvarSupportMsgFid.MaxLength = 0;
colvarSupportMsgFid.AutoIncrement = false;
colvarSupportMsgFid.IsNullable = false;
colvarSupportMsgFid.IsPrimaryKey = false;
colvarSupportMsgFid.IsForeignKey = false;
colvarSupportMsgFid.IsReadOnly = false;
colvarSupportMsgFid.DefaultSetting = @"";
colvarSupportMsgFid.ForeignKeyTableName = "";
colvarSupportMsgFid.ApplyExtendedProperties();
this.Columns.Add(colvarSupportMsgFid);
TableSchema.TableColumn colvarSupportMsgTid = new TableSchema.TableColumn(this);
colvarSupportMsgTid.ColumnName = "SupportMsg_TID";
colvarSupportMsgTid.DataType = DbType.Int32;
colvarSupportMsgTid.MaxLength = 0;
colvarSupportMsgTid.AutoIncrement = false;
colvarSupportMsgTid.IsNullable = false;
colvarSupportMsgTid.IsPrimaryKey = false;
colvarSupportMsgTid.IsForeignKey = false;
colvarSupportMsgTid.IsReadOnly = false;
colvarSupportMsgTid.DefaultSetting = @"";
colvarSupportMsgTid.ForeignKeyTableName = "";
colvarSupportMsgTid.ApplyExtendedProperties();
this.Columns.Add(colvarSupportMsgTid);
TableSchema.TableColumn colvarSupportMsgMemo = new TableSchema.TableColumn(this);
colvarSupportMsgMemo.ColumnName = "SupportMsg_Memo";
colvarSupportMsgMemo.DataType = DbType.String;
colvarSupportMsgMemo.MaxLength = 2000;
colvarSupportMsgMemo.AutoIncrement = false;
colvarSupportMsgMemo.IsNullable = false;
colvarSupportMsgMemo.IsPrimaryKey = false;
colvarSupportMsgMemo.IsForeignKey = false;
colvarSupportMsgMemo.IsReadOnly = false;
colvarSupportMsgMemo.DefaultSetting = @"";
colvarSupportMsgMemo.ForeignKeyTableName = "";
colvarSupportMsgMemo.ApplyExtendedProperties();
this.Columns.Add(colvarSupportMsgMemo);
TableSchema.TableColumn colvarSupportMsgPhoto = new TableSchema.TableColumn(this);
colvarSupportMsgPhoto.ColumnName = "SupportMsg_Photo";
colvarSupportMsgPhoto.DataType = DbType.String;
colvarSupportMsgPhoto.MaxLength = 50;
colvarSupportMsgPhoto.AutoIncrement = false;
colvarSupportMsgPhoto.IsNullable = false;
colvarSupportMsgPhoto.IsPrimaryKey = false;
colvarSupportMsgPhoto.IsForeignKey = false;
colvarSupportMsgPhoto.IsReadOnly = false;
colvarSupportMsgPhoto.DefaultSetting = @"";
colvarSupportMsgPhoto.ForeignKeyTableName = "";
colvarSupportMsgPhoto.ApplyExtendedProperties();
this.Columns.Add(colvarSupportMsgPhoto);
TableSchema.TableColumn colvarSupportMsgIsRead = new TableSchema.TableColumn(this);
colvarSupportMsgIsRead.ColumnName = "SupportMsg_IsRead";
colvarSupportMsgIsRead.DataType = DbType.Boolean;
colvarSupportMsgIsRead.MaxLength = 0;
colvarSupportMsgIsRead.AutoIncrement = false;
colvarSupportMsgIsRead.IsNullable = false;
colvarSupportMsgIsRead.IsPrimaryKey = false;
colvarSupportMsgIsRead.IsForeignKey = false;
colvarSupportMsgIsRead.IsReadOnly = false;
colvarSupportMsgIsRead.DefaultSetting = @"";
colvarSupportMsgIsRead.ForeignKeyTableName = "";
colvarSupportMsgIsRead.ApplyExtendedProperties();
this.Columns.Add(colvarSupportMsgIsRead);
TableSchema.TableColumn colvarSupportMsgIsAsk = new TableSchema.TableColumn(this);
colvarSupportMsgIsAsk.ColumnName = "SupportMsg_IsAsk";
colvarSupportMsgIsAsk.DataType = DbType.Boolean;
colvarSupportMsgIsAsk.MaxLength = 0;
colvarSupportMsgIsAsk.AutoIncrement = false;
colvarSupportMsgIsAsk.IsNullable = false;
colvarSupportMsgIsAsk.IsPrimaryKey = false;
colvarSupportMsgIsAsk.IsForeignKey = false;
colvarSupportMsgIsAsk.IsReadOnly = false;
colvarSupportMsgIsAsk.DefaultSetting = @"";
colvarSupportMsgIsAsk.ForeignKeyTableName = "";
colvarSupportMsgIsAsk.ApplyExtendedProperties();
this.Columns.Add(colvarSupportMsgIsAsk);
TableSchema.TableColumn colvarSupportMsgDate = new TableSchema.TableColumn(this);
colvarSupportMsgDate.ColumnName = "SupportMsg_Date";
colvarSupportMsgDate.DataType = DbType.DateTime;
colvarSupportMsgDate.MaxLength = 0;
colvarSupportMsgDate.AutoIncrement = false;
colvarSupportMsgDate.IsNullable = false;
colvarSupportMsgDate.IsPrimaryKey = false;
colvarSupportMsgDate.IsForeignKey = false;
colvarSupportMsgDate.IsReadOnly = false;
colvarSupportMsgDate.DefaultSetting = @"";
colvarSupportMsgDate.ForeignKeyTableName = "";
colvarSupportMsgDate.ApplyExtendedProperties();
this.Columns.Add(colvarSupportMsgDate);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarRewardID = new TableSchema.TableColumn(this);
colvarRewardID.ColumnName = "RewardID";
colvarRewardID.DataType = DbType.Int32;
colvarRewardID.MaxLength = 0;
colvarRewardID.AutoIncrement = true;
colvarRewardID.IsNullable = false;
colvarRewardID.IsPrimaryKey = true;
colvarRewardID.IsForeignKey = false;
colvarRewardID.IsReadOnly = false;
colvarRewardID.DefaultSetting = @"";
colvarRewardID.ForeignKeyTableName = "";
colvarRewardID.ApplyExtendedProperties();
this.Columns.Add(colvarRewardID);
TableSchema.TableColumn colvarRewardDate = new TableSchema.TableColumn(this);
colvarRewardDate.ColumnName = "RewardDate";
colvarRewardDate.DataType = DbType.DateTime;
colvarRewardDate.MaxLength = 0;
colvarRewardDate.AutoIncrement = false;
colvarRewardDate.IsNullable = true;
colvarRewardDate.IsPrimaryKey = false;
colvarRewardDate.IsForeignKey = false;
colvarRewardDate.IsReadOnly = false;
colvarRewardDate.DefaultSetting = @"";
colvarRewardDate.ForeignKeyTableName = "";
colvarRewardDate.ApplyExtendedProperties();
this.Columns.Add(colvarRewardDate);
TableSchema.TableColumn colvarRewardEndDate = new TableSchema.TableColumn(this);
colvarRewardEndDate.ColumnName = "RewardEndDate";
colvarRewardEndDate.DataType = DbType.DateTime;
colvarRewardEndDate.MaxLength = 0;
colvarRewardEndDate.AutoIncrement = false;
colvarRewardEndDate.IsNullable = true;
colvarRewardEndDate.IsPrimaryKey = false;
colvarRewardEndDate.IsForeignKey = false;
colvarRewardEndDate.IsReadOnly = false;
colvarRewardEndDate.DefaultSetting = @"";
colvarRewardEndDate.ForeignKeyTableName = "";
colvarRewardEndDate.ApplyExtendedProperties();
this.Columns.Add(colvarRewardEndDate);
TableSchema.TableColumn colvarRewardRate = new TableSchema.TableColumn(this);
colvarRewardRate.ColumnName = "RewardRate";
colvarRewardRate.DataType = DbType.Decimal;
colvarRewardRate.MaxLength = 0;
colvarRewardRate.AutoIncrement = false;
colvarRewardRate.IsNullable = true;
colvarRewardRate.IsPrimaryKey = false;
colvarRewardRate.IsForeignKey = false;
colvarRewardRate.IsReadOnly = false;
colvarRewardRate.DefaultSetting = @"";
colvarRewardRate.ForeignKeyTableName = "";
colvarRewardRate.ApplyExtendedProperties();
this.Columns.Add(colvarRewardRate);
TableSchema.TableColumn colvarRewardFlag = new TableSchema.TableColumn(this);
colvarRewardFlag.ColumnName = "RewardFlag";
colvarRewardFlag.DataType = DbType.Int32;
colvarRewardFlag.MaxLength = 0;
colvarRewardFlag.AutoIncrement = false;
colvarRewardFlag.IsNullable = true;
colvarRewardFlag.IsPrimaryKey = false;
colvarRewardFlag.IsForeignKey = false;
colvarRewardFlag.IsReadOnly = false;
colvarRewardFlag.DefaultSetting = @"";
colvarRewardFlag.ForeignKeyTableName = "";
colvarRewardFlag.ApplyExtendedProperties();
this.Columns.Add(colvarRewardFlag);
TableSchema.TableColumn colvarRewardMemo = new TableSchema.TableColumn(this);
colvarRewardMemo.ColumnName = "RewardMemo";
colvarRewardMemo.DataType = DbType.AnsiString;
colvarRewardMemo.MaxLength = 2147483647;
colvarRewardMemo.AutoIncrement = false;
colvarRewardMemo.IsNullable = true;
colvarRewardMemo.IsPrimaryKey = false;
colvarRewardMemo.IsForeignKey = false;
colvarRewardMemo.IsReadOnly = false;
colvarRewardMemo.DefaultSetting = @"";
colvarRewardMemo.ForeignKeyTableName = "";
colvarRewardMemo.ApplyExtendedProperties();
this.Columns.Add(colvarRewardMemo);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarTitle = new TableSchema.TableColumn(this);
colvarTitle.ColumnName = "Title";
colvarTitle.DataType = DbType.String;
colvarTitle.MaxLength = 250;
colvarTitle.AutoIncrement = false;
colvarTitle.IsNullable = true;
colvarTitle.IsPrimaryKey = false;
colvarTitle.IsForeignKey = false;
colvarTitle.IsReadOnly = false;
colvarTitle.DefaultSetting = @"";
colvarTitle.ForeignKeyTableName = "";
colvarTitle.ApplyExtendedProperties();
this.Columns.Add(colvarTitle);
TableSchema.TableColumn colvarContent = new TableSchema.TableColumn(this);
colvarContent.ColumnName = "Content";
colvarContent.DataType = DbType.String;
colvarContent.MaxLength = 1073741823;
colvarContent.AutoIncrement = false;
colvarContent.IsNullable = true;
colvarContent.IsPrimaryKey = false;
colvarContent.IsForeignKey = false;
colvarContent.IsReadOnly = false;
colvarContent.DefaultSetting = @"";
colvarContent.ForeignKeyTableName = "";
colvarContent.ApplyExtendedProperties();
this.Columns.Add(colvarContent);
TableSchema.TableColumn colvarKeyWord = new TableSchema.TableColumn(this);
colvarKeyWord.ColumnName = "KeyWord";
colvarKeyWord.DataType = DbType.String;
colvarKeyWord.MaxLength = 250;
colvarKeyWord.AutoIncrement = false;
colvarKeyWord.IsNullable = true;
colvarKeyWord.IsPrimaryKey = false;
colvarKeyWord.IsForeignKey = false;
colvarKeyWord.IsReadOnly = false;
colvarKeyWord.DefaultSetting = @"";
colvarKeyWord.ForeignKeyTableName = "";
colvarKeyWord.ApplyExtendedProperties();
this.Columns.Add(colvarKeyWord);
TableSchema.TableColumn colvarHits = new TableSchema.TableColumn(this);
colvarHits.ColumnName = "Hits";
colvarHits.DataType = DbType.Int32;
colvarHits.MaxLength = 0;
colvarHits.AutoIncrement = false;
colvarHits.IsNullable = true;
colvarHits.IsPrimaryKey = false;
colvarHits.IsForeignKey = false;
colvarHits.IsReadOnly = false;
colvarHits.DefaultSetting = @"";
colvarHits.ForeignKeyTableName = "";
colvarHits.ApplyExtendedProperties();
this.Columns.Add(colvarHits);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarAuditedBy = new TableSchema.TableColumn(this);
colvarAuditedBy.ColumnName = "AuditedBy";
colvarAuditedBy.DataType = DbType.Int32;
colvarAuditedBy.MaxLength = 0;
colvarAuditedBy.AutoIncrement = false;
colvarAuditedBy.IsNullable = true;
colvarAuditedBy.IsPrimaryKey = false;
colvarAuditedBy.IsForeignKey = false;
colvarAuditedBy.IsReadOnly = false;
colvarAuditedBy.DefaultSetting = @"";
colvarAuditedBy.ForeignKeyTableName = "";
colvarAuditedBy.ApplyExtendedProperties();
this.Columns.Add(colvarAuditedBy);
TableSchema.TableColumn colvarAuditedOn = new TableSchema.TableColumn(this);
colvarAuditedOn.ColumnName = "AuditedOn";
colvarAuditedOn.DataType = DbType.DateTime;
colvarAuditedOn.MaxLength = 0;
colvarAuditedOn.AutoIncrement = false;
colvarAuditedOn.IsNullable = true;
colvarAuditedOn.IsPrimaryKey = false;
colvarAuditedOn.IsForeignKey = false;
colvarAuditedOn.IsReadOnly = false;
colvarAuditedOn.DefaultSetting = @"";
colvarAuditedOn.ForeignKeyTableName = "";
colvarAuditedOn.ApplyExtendedProperties();
this.Columns.Add(colvarAuditedOn);
TableSchema.TableColumn colvarUId = new TableSchema.TableColumn(this);
colvarUId.ColumnName = "U_ID";
colvarUId.DataType = DbType.Int32;
colvarUId.MaxLength = 0;
colvarUId.AutoIncrement = false;
colvarUId.IsNullable = true;
colvarUId.IsPrimaryKey = false;
colvarUId.IsForeignKey = false;
colvarUId.IsReadOnly = false;
colvarUId.DefaultSetting = @"";
colvarUId.ForeignKeyTableName = "";
colvarUId.ApplyExtendedProperties();
this.Columns.Add(colvarUId);
TableSchema.TableColumn colvarCId = new TableSchema.TableColumn(this);
colvarCId.ColumnName = "C_ID";
colvarCId.DataType = DbType.Int32;
colvarCId.MaxLength = 0;
colvarCId.AutoIncrement = false;
colvarCId.IsNullable = true;
colvarCId.IsPrimaryKey = false;
colvarCId.IsForeignKey = false;
colvarCId.IsReadOnly = false;
colvarCId.DefaultSetting = @"";
colvarCId.ForeignKeyTableName = "";
colvarCId.ApplyExtendedProperties();
this.Columns.Add(colvarCId);
TableSchema.TableColumn colvarPic = new TableSchema.TableColumn(this);
colvarPic.ColumnName = "Pic";
colvarPic.DataType = DbType.String;
colvarPic.MaxLength = 150;
colvarPic.AutoIncrement = false;
colvarPic.IsNullable = true;
colvarPic.IsPrimaryKey = false;
colvarPic.IsForeignKey = false;
colvarPic.IsReadOnly = false;
colvarPic.DefaultSetting = @"";
colvarPic.ForeignKeyTableName = "";
colvarPic.ApplyExtendedProperties();
this.Columns.Add(colvarPic);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarName = new TableSchema.TableColumn(this);
colvarName.ColumnName = "Name";
colvarName.DataType = DbType.String;
colvarName.MaxLength = 250;
colvarName.AutoIncrement = false;
colvarName.IsNullable = true;
colvarName.IsPrimaryKey = false;
colvarName.IsForeignKey = false;
colvarName.IsReadOnly = false;
colvarName.DefaultSetting = @"";
colvarName.ForeignKeyTableName = "";
colvarName.ApplyExtendedProperties();
this.Columns.Add(colvarName);
TableSchema.TableColumn colvarPrice = new TableSchema.TableColumn(this);
colvarPrice.ColumnName = "Price";
colvarPrice.DataType = DbType.Decimal;
colvarPrice.MaxLength = 0;
colvarPrice.AutoIncrement = false;
colvarPrice.IsNullable = true;
colvarPrice.IsPrimaryKey = false;
colvarPrice.IsForeignKey = false;
colvarPrice.IsReadOnly = false;
colvarPrice.DefaultSetting = @"";
colvarPrice.ForeignKeyTableName = "";
colvarPrice.ApplyExtendedProperties();
this.Columns.Add(colvarPrice);
TableSchema.TableColumn colvarDirID = new TableSchema.TableColumn(this);
colvarDirID.ColumnName = "DirID";
colvarDirID.DataType = DbType.Int32;
colvarDirID.MaxLength = 0;
colvarDirID.AutoIncrement = false;
colvarDirID.IsNullable = true;
colvarDirID.IsPrimaryKey = false;
colvarDirID.IsForeignKey = false;
colvarDirID.IsReadOnly = false;
colvarDirID.DefaultSetting = @"";
colvarDirID.ForeignKeyTableName = "";
colvarDirID.ApplyExtendedProperties();
this.Columns.Add(colvarDirID);
TableSchema.TableColumn colvarCode = new TableSchema.TableColumn(this);
colvarCode.ColumnName = "Code";
colvarCode.DataType = DbType.String;
colvarCode.MaxLength = 20;
colvarCode.AutoIncrement = false;
colvarCode.IsNullable = true;
colvarCode.IsPrimaryKey = false;
colvarCode.IsForeignKey = false;
colvarCode.IsReadOnly = false;
colvarCode.DefaultSetting = @"";
colvarCode.ForeignKeyTableName = "";
colvarCode.ApplyExtendedProperties();
this.Columns.Add(colvarCode);
TableSchema.TableColumn colvarCompanyID = new TableSchema.TableColumn(this);
colvarCompanyID.ColumnName = "CompanyID";
colvarCompanyID.DataType = DbType.Int32;
colvarCompanyID.MaxLength = 0;
colvarCompanyID.AutoIncrement = false;
colvarCompanyID.IsNullable = true;
colvarCompanyID.IsPrimaryKey = false;
colvarCompanyID.IsForeignKey = false;
colvarCompanyID.IsReadOnly = false;
colvarCompanyID.DefaultSetting = @"";
colvarCompanyID.ForeignKeyTableName = "";
colvarCompanyID.ApplyExtendedProperties();
this.Columns.Add(colvarCompanyID);
TableSchema.TableColumn colvarIsDeleted = new TableSchema.TableColumn(this);
colvarIsDeleted.ColumnName = "IsDeleted";
colvarIsDeleted.DataType = DbType.Boolean;
colvarIsDeleted.MaxLength = 0;
colvarIsDeleted.AutoIncrement = false;
colvarIsDeleted.IsNullable = true;
colvarIsDeleted.IsPrimaryKey = false;
colvarIsDeleted.IsForeignKey = false;
colvarIsDeleted.IsReadOnly = false;
colvarIsDeleted.DefaultSetting = @"";
colvarIsDeleted.ForeignKeyTableName = "";
colvarIsDeleted.ApplyExtendedProperties();
this.Columns.Add(colvarIsDeleted);
TableSchema.TableColumn colvarIsOutOfStock = new TableSchema.TableColumn(this);
colvarIsOutOfStock.ColumnName = "IsOutOfStock";
colvarIsOutOfStock.DataType = DbType.Boolean;
colvarIsOutOfStock.MaxLength = 0;
colvarIsOutOfStock.AutoIncrement = false;
colvarIsOutOfStock.IsNullable = true;
colvarIsOutOfStock.IsPrimaryKey = false;
colvarIsOutOfStock.IsForeignKey = false;
colvarIsOutOfStock.IsReadOnly = false;
colvarIsOutOfStock.DefaultSetting = @"";
colvarIsOutOfStock.ForeignKeyTableName = "";
colvarIsOutOfStock.ApplyExtendedProperties();
this.Columns.Add(colvarIsOutOfStock);
TableSchema.TableColumn colvarOutOfStockDate = new TableSchema.TableColumn(this);
colvarOutOfStockDate.ColumnName = "OutOfStockDate";
colvarOutOfStockDate.DataType = DbType.DateTime;
colvarOutOfStockDate.MaxLength = 0;
colvarOutOfStockDate.AutoIncrement = false;
colvarOutOfStockDate.IsNullable = true;
colvarOutOfStockDate.IsPrimaryKey = false;
colvarOutOfStockDate.IsForeignKey = false;
colvarOutOfStockDate.IsReadOnly = false;
colvarOutOfStockDate.DefaultSetting = @"";
colvarOutOfStockDate.ForeignKeyTableName = "";
colvarOutOfStockDate.ApplyExtendedProperties();
this.Columns.Add(colvarOutOfStockDate);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarMessageType = new TableSchema.TableColumn(this);
colvarMessageType.ColumnName = "MessageType";
colvarMessageType.DataType = DbType.Int32;
colvarMessageType.MaxLength = 0;
colvarMessageType.AutoIncrement = false;
colvarMessageType.IsNullable = false;
colvarMessageType.IsPrimaryKey = false;
colvarMessageType.IsForeignKey = false;
colvarMessageType.IsReadOnly = false;
colvarMessageType.DefaultSetting = @"";
colvarMessageType.ForeignKeyTableName = "";
colvarMessageType.ApplyExtendedProperties();
this.Columns.Add(colvarMessageType);
TableSchema.TableColumn colvarMessageSellerID = new TableSchema.TableColumn(this);
colvarMessageSellerID.ColumnName = "MessageSellerID";
colvarMessageSellerID.DataType = DbType.Int32;
colvarMessageSellerID.MaxLength = 0;
colvarMessageSellerID.AutoIncrement = false;
colvarMessageSellerID.IsNullable = false;
colvarMessageSellerID.IsPrimaryKey = false;
colvarMessageSellerID.IsForeignKey = false;
colvarMessageSellerID.IsReadOnly = false;
colvarMessageSellerID.DefaultSetting = @"";
colvarMessageSellerID.ForeignKeyTableName = "";
colvarMessageSellerID.ApplyExtendedProperties();
this.Columns.Add(colvarMessageSellerID);
TableSchema.TableColumn colvarMessageSubject = new TableSchema.TableColumn(this);
colvarMessageSubject.ColumnName = "MessageSubject";
colvarMessageSubject.DataType = DbType.AnsiString;
colvarMessageSubject.MaxLength = 3000;
colvarMessageSubject.AutoIncrement = false;
colvarMessageSubject.IsNullable = false;
colvarMessageSubject.IsPrimaryKey = false;
colvarMessageSubject.IsForeignKey = false;
colvarMessageSubject.IsReadOnly = false;
colvarMessageSubject.DefaultSetting = @"";
colvarMessageSubject.ForeignKeyTableName = "";
colvarMessageSubject.ApplyExtendedProperties();
this.Columns.Add(colvarMessageSubject);
TableSchema.TableColumn colvarMessageReply = new TableSchema.TableColumn(this);
colvarMessageReply.ColumnName = "MessageReply";
colvarMessageReply.DataType = DbType.AnsiString;
colvarMessageReply.MaxLength = 3000;
colvarMessageReply.AutoIncrement = false;
colvarMessageReply.IsNullable = false;
colvarMessageReply.IsPrimaryKey = false;
colvarMessageReply.IsForeignKey = false;
colvarMessageReply.IsReadOnly = false;
colvarMessageReply.DefaultSetting = @"";
colvarMessageReply.ForeignKeyTableName = "";
colvarMessageReply.ApplyExtendedProperties();
this.Columns.Add(colvarMessageReply);
TableSchema.TableColumn colvarMessageSalerID = new TableSchema.TableColumn(this);
colvarMessageSalerID.ColumnName = "MessageSalerID";
colvarMessageSalerID.DataType = DbType.Int32;
colvarMessageSalerID.MaxLength = 0;
colvarMessageSalerID.AutoIncrement = false;
colvarMessageSalerID.IsNullable = false;
colvarMessageSalerID.IsPrimaryKey = false;
colvarMessageSalerID.IsForeignKey = false;
colvarMessageSalerID.IsReadOnly = false;
colvarMessageSalerID.DefaultSetting = @"";
colvarMessageSalerID.ForeignKeyTableName = "";
colvarMessageSalerID.ApplyExtendedProperties();
this.Columns.Add(colvarMessageSalerID);
TableSchema.TableColumn colvarMessageDateSubject = new TableSchema.TableColumn(this);
colvarMessageDateSubject.ColumnName = "MessageDateSubject";
colvarMessageDateSubject.DataType = DbType.DateTime;
colvarMessageDateSubject.MaxLength = 0;
colvarMessageDateSubject.AutoIncrement = false;
colvarMessageDateSubject.IsNullable = false;
colvarMessageDateSubject.IsPrimaryKey = false;
colvarMessageDateSubject.IsForeignKey = false;
colvarMessageDateSubject.IsReadOnly = false;
colvarMessageDateSubject.DefaultSetting = @"";
colvarMessageDateSubject.ForeignKeyTableName = "";
colvarMessageDateSubject.ApplyExtendedProperties();
this.Columns.Add(colvarMessageDateSubject);
TableSchema.TableColumn colvarMessageDateReply = new TableSchema.TableColumn(this);
colvarMessageDateReply.ColumnName = "MessageDateReply";
colvarMessageDateReply.DataType = DbType.Decimal;
colvarMessageDateReply.MaxLength = 0;
colvarMessageDateReply.AutoIncrement = false;
colvarMessageDateReply.IsNullable = false;
colvarMessageDateReply.IsPrimaryKey = false;
colvarMessageDateReply.IsForeignKey = false;
colvarMessageDateReply.IsReadOnly = false;
colvarMessageDateReply.DefaultSetting = @"";
colvarMessageDateReply.ForeignKeyTableName = "";
colvarMessageDateReply.ApplyExtendedProperties();
this.Columns.Add(colvarMessageDateReply);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = false;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarOrderCode = new TableSchema.TableColumn(this);
colvarOrderCode.ColumnName = "OrderCode";
colvarOrderCode.DataType = DbType.String;
colvarOrderCode.MaxLength = 50;
colvarOrderCode.AutoIncrement = false;
colvarOrderCode.IsNullable = false;
colvarOrderCode.IsPrimaryKey = false;
colvarOrderCode.IsForeignKey = false;
colvarOrderCode.IsReadOnly = false;
colvarOrderCode.DefaultSetting = @"";
colvarOrderCode.ForeignKeyTableName = "";
colvarOrderCode.ApplyExtendedProperties();
this.Columns.Add(colvarOrderCode);
TableSchema.TableColumn colvarOrderDate = new TableSchema.TableColumn(this);
colvarOrderDate.ColumnName = "OrderDate";
colvarOrderDate.DataType = DbType.DateTime;
colvarOrderDate.MaxLength = 0;
colvarOrderDate.AutoIncrement = false;
colvarOrderDate.IsNullable = false;
colvarOrderDate.IsPrimaryKey = false;
colvarOrderDate.IsForeignKey = false;
colvarOrderDate.IsReadOnly = false;
colvarOrderDate.DefaultSetting = @"";
colvarOrderDate.ForeignKeyTableName = "";
colvarOrderDate.ApplyExtendedProperties();
this.Columns.Add(colvarOrderDate);
TableSchema.TableColumn colvarOrderCard = new TableSchema.TableColumn(this);
colvarOrderCard.ColumnName = "OrderCard";
colvarOrderCard.DataType = DbType.String;
colvarOrderCard.MaxLength = 50;
colvarOrderCard.AutoIncrement = false;
colvarOrderCard.IsNullable = false;
colvarOrderCard.IsPrimaryKey = false;
colvarOrderCard.IsForeignKey = false;
colvarOrderCard.IsReadOnly = false;
colvarOrderCard.DefaultSetting = @"";
colvarOrderCard.ForeignKeyTableName = "";
colvarOrderCard.ApplyExtendedProperties();
this.Columns.Add(colvarOrderCard);
TableSchema.TableColumn colvarOrderMemberID = new TableSchema.TableColumn(this);
colvarOrderMemberID.ColumnName = "OrderMemberID";
colvarOrderMemberID.DataType = DbType.Int32;
colvarOrderMemberID.MaxLength = 0;
colvarOrderMemberID.AutoIncrement = false;
colvarOrderMemberID.IsNullable = false;
colvarOrderMemberID.IsPrimaryKey = false;
colvarOrderMemberID.IsForeignKey = false;
colvarOrderMemberID.IsReadOnly = false;
colvarOrderMemberID.DefaultSetting = @"";
colvarOrderMemberID.ForeignKeyTableName = "";
colvarOrderMemberID.ApplyExtendedProperties();
this.Columns.Add(colvarOrderMemberID);
TableSchema.TableColumn colvarOrderSellerID = new TableSchema.TableColumn(this);
colvarOrderSellerID.ColumnName = "OrderSellerID";
colvarOrderSellerID.DataType = DbType.Int32;
colvarOrderSellerID.MaxLength = 0;
colvarOrderSellerID.AutoIncrement = false;
colvarOrderSellerID.IsNullable = false;
colvarOrderSellerID.IsPrimaryKey = false;
colvarOrderSellerID.IsForeignKey = false;
colvarOrderSellerID.IsReadOnly = false;
colvarOrderSellerID.DefaultSetting = @"";
colvarOrderSellerID.ForeignKeyTableName = "";
colvarOrderSellerID.ApplyExtendedProperties();
this.Columns.Add(colvarOrderSellerID);
TableSchema.TableColumn colvarOrderProduct = new TableSchema.TableColumn(this);
colvarOrderProduct.ColumnName = "OrderProduct";
colvarOrderProduct.DataType = DbType.String;
colvarOrderProduct.MaxLength = 800;
colvarOrderProduct.AutoIncrement = false;
colvarOrderProduct.IsNullable = true;
colvarOrderProduct.IsPrimaryKey = false;
colvarOrderProduct.IsForeignKey = false;
colvarOrderProduct.IsReadOnly = false;
colvarOrderProduct.DefaultSetting = @"";
colvarOrderProduct.ForeignKeyTableName = "";
colvarOrderProduct.ApplyExtendedProperties();
this.Columns.Add(colvarOrderProduct);
TableSchema.TableColumn colvarOrderQty = new TableSchema.TableColumn(this);
colvarOrderQty.ColumnName = "OrderQty";
colvarOrderQty.DataType = DbType.Int32;
colvarOrderQty.MaxLength = 0;
colvarOrderQty.AutoIncrement = false;
colvarOrderQty.IsNullable = true;
colvarOrderQty.IsPrimaryKey = false;
colvarOrderQty.IsForeignKey = false;
colvarOrderQty.IsReadOnly = false;
colvarOrderQty.DefaultSetting = @"";
colvarOrderQty.ForeignKeyTableName = "";
colvarOrderQty.ApplyExtendedProperties();
this.Columns.Add(colvarOrderQty);
TableSchema.TableColumn colvarOrderSum = new TableSchema.TableColumn(this);
colvarOrderSum.ColumnName = "OrderSum";
colvarOrderSum.DataType = DbType.Decimal;
colvarOrderSum.MaxLength = 0;
colvarOrderSum.AutoIncrement = false;
colvarOrderSum.IsNullable = true;
colvarOrderSum.IsPrimaryKey = false;
colvarOrderSum.IsForeignKey = false;
colvarOrderSum.IsReadOnly = false;
colvarOrderSum.DefaultSetting = @"";
colvarOrderSum.ForeignKeyTableName = "";
colvarOrderSum.ApplyExtendedProperties();
this.Columns.Add(colvarOrderSum);
TableSchema.TableColumn colvarOrderSumOk = new TableSchema.TableColumn(this);
colvarOrderSumOk.ColumnName = "OrderSumOk";
colvarOrderSumOk.DataType = DbType.Decimal;
colvarOrderSumOk.MaxLength = 0;
colvarOrderSumOk.AutoIncrement = false;
colvarOrderSumOk.IsNullable = true;
colvarOrderSumOk.IsPrimaryKey = false;
colvarOrderSumOk.IsForeignKey = false;
colvarOrderSumOk.IsReadOnly = false;
colvarOrderSumOk.DefaultSetting = @"";
colvarOrderSumOk.ForeignKeyTableName = "";
colvarOrderSumOk.ApplyExtendedProperties();
this.Columns.Add(colvarOrderSumOk);
TableSchema.TableColumn colvarOrderRateSale = new TableSchema.TableColumn(this);
colvarOrderRateSale.ColumnName = "OrderRateSale";
colvarOrderRateSale.DataType = DbType.Decimal;
colvarOrderRateSale.MaxLength = 0;
colvarOrderRateSale.AutoIncrement = false;
colvarOrderRateSale.IsNullable = true;
colvarOrderRateSale.IsPrimaryKey = false;
colvarOrderRateSale.IsForeignKey = false;
colvarOrderRateSale.IsReadOnly = false;
colvarOrderRateSale.DefaultSetting = @"";
colvarOrderRateSale.ForeignKeyTableName = "";
colvarOrderRateSale.ApplyExtendedProperties();
this.Columns.Add(colvarOrderRateSale);
TableSchema.TableColumn colvarOrderRate = new TableSchema.TableColumn(this);
colvarOrderRate.ColumnName = "OrderRate";
colvarOrderRate.DataType = DbType.Decimal;
colvarOrderRate.MaxLength = 0;
colvarOrderRate.AutoIncrement = false;
colvarOrderRate.IsNullable = true;
colvarOrderRate.IsPrimaryKey = false;
colvarOrderRate.IsForeignKey = false;
colvarOrderRate.IsReadOnly = false;
colvarOrderRate.DefaultSetting = @"";
colvarOrderRate.ForeignKeyTableName = "";
colvarOrderRate.ApplyExtendedProperties();
this.Columns.Add(colvarOrderRate);
TableSchema.TableColumn colvarOrderPoint = new TableSchema.TableColumn(this);
colvarOrderPoint.ColumnName = "OrderPoint";
colvarOrderPoint.DataType = DbType.Decimal;
colvarOrderPoint.MaxLength = 0;
colvarOrderPoint.AutoIncrement = false;
colvarOrderPoint.IsNullable = true;
colvarOrderPoint.IsPrimaryKey = false;
colvarOrderPoint.IsForeignKey = false;
colvarOrderPoint.IsReadOnly = false;
colvarOrderPoint.DefaultSetting = @"";
colvarOrderPoint.ForeignKeyTableName = "";
colvarOrderPoint.ApplyExtendedProperties();
this.Columns.Add(colvarOrderPoint);
TableSchema.TableColumn colvarOrderPay = new TableSchema.TableColumn(this);
colvarOrderPay.ColumnName = "OrderPay";
colvarOrderPay.DataType = DbType.Decimal;
colvarOrderPay.MaxLength = 0;
colvarOrderPay.AutoIncrement = false;
colvarOrderPay.IsNullable = true;
colvarOrderPay.IsPrimaryKey = false;
colvarOrderPay.IsForeignKey = false;
colvarOrderPay.IsReadOnly = false;
colvarOrderPay.DefaultSetting = @"";
colvarOrderPay.ForeignKeyTableName = "";
colvarOrderPay.ApplyExtendedProperties();
this.Columns.Add(colvarOrderPay);
TableSchema.TableColumn colvarOrderPayCash = new TableSchema.TableColumn(this);
colvarOrderPayCash.ColumnName = "OrderPayCash";
colvarOrderPayCash.DataType = DbType.Decimal;
colvarOrderPayCash.MaxLength = 0;
colvarOrderPayCash.AutoIncrement = false;
colvarOrderPayCash.IsNullable = true;
colvarOrderPayCash.IsPrimaryKey = false;
colvarOrderPayCash.IsForeignKey = false;
colvarOrderPayCash.IsReadOnly = false;
colvarOrderPayCash.DefaultSetting = @"";
colvarOrderPayCash.ForeignKeyTableName = "";
colvarOrderPayCash.ApplyExtendedProperties();
this.Columns.Add(colvarOrderPayCash);
TableSchema.TableColumn colvarOrderPayPoint = new TableSchema.TableColumn(this);
colvarOrderPayPoint.ColumnName = "OrderPayPoint";
colvarOrderPayPoint.DataType = DbType.Decimal;
colvarOrderPayPoint.MaxLength = 0;
colvarOrderPayPoint.AutoIncrement = false;
colvarOrderPayPoint.IsNullable = true;
colvarOrderPayPoint.IsPrimaryKey = false;
colvarOrderPayPoint.IsForeignKey = false;
colvarOrderPayPoint.IsReadOnly = false;
colvarOrderPayPoint.DefaultSetting = @"";
colvarOrderPayPoint.ForeignKeyTableName = "";
colvarOrderPayPoint.ApplyExtendedProperties();
this.Columns.Add(colvarOrderPayPoint);
TableSchema.TableColumn colvarOrderDateUpload = new TableSchema.TableColumn(this);
colvarOrderDateUpload.ColumnName = "OrderDateUpload";
colvarOrderDateUpload.DataType = DbType.DateTime;
colvarOrderDateUpload.MaxLength = 0;
colvarOrderDateUpload.AutoIncrement = false;
colvarOrderDateUpload.IsNullable = false;
colvarOrderDateUpload.IsPrimaryKey = false;
colvarOrderDateUpload.IsForeignKey = false;
colvarOrderDateUpload.IsReadOnly = false;
colvarOrderDateUpload.DefaultSetting = @"";
colvarOrderDateUpload.ForeignKeyTableName = "";
colvarOrderDateUpload.ApplyExtendedProperties();
this.Columns.Add(colvarOrderDateUpload);
TableSchema.TableColumn colvarOrderDateDeliver = new TableSchema.TableColumn(this);
colvarOrderDateDeliver.ColumnName = "OrderDateDeliver";
colvarOrderDateDeliver.DataType = DbType.DateTime;
colvarOrderDateDeliver.MaxLength = 0;
colvarOrderDateDeliver.AutoIncrement = false;
colvarOrderDateDeliver.IsNullable = false;
colvarOrderDateDeliver.IsPrimaryKey = false;
colvarOrderDateDeliver.IsForeignKey = false;
colvarOrderDateDeliver.IsReadOnly = false;
colvarOrderDateDeliver.DefaultSetting = @"";
colvarOrderDateDeliver.ForeignKeyTableName = "";
colvarOrderDateDeliver.ApplyExtendedProperties();
this.Columns.Add(colvarOrderDateDeliver);
TableSchema.TableColumn colvarOrderStatus = new TableSchema.TableColumn(this);
colvarOrderStatus.ColumnName = "OrderStatus";
colvarOrderStatus.DataType = DbType.Int32;
colvarOrderStatus.MaxLength = 0;
colvarOrderStatus.AutoIncrement = false;
colvarOrderStatus.IsNullable = false;
colvarOrderStatus.IsPrimaryKey = false;
colvarOrderStatus.IsForeignKey = false;
colvarOrderStatus.IsReadOnly = false;
colvarOrderStatus.DefaultSetting = @"";
colvarOrderStatus.ForeignKeyTableName = "";
colvarOrderStatus.ApplyExtendedProperties();
this.Columns.Add(colvarOrderStatus);
TableSchema.TableColumn colvarOrderMemo = new TableSchema.TableColumn(this);
colvarOrderMemo.ColumnName = "OrderMemo";
colvarOrderMemo.DataType = DbType.String;
colvarOrderMemo.MaxLength = 200;
colvarOrderMemo.AutoIncrement = false;
colvarOrderMemo.IsNullable = false;
colvarOrderMemo.IsPrimaryKey = false;
colvarOrderMemo.IsForeignKey = false;
colvarOrderMemo.IsReadOnly = false;
colvarOrderMemo.DefaultSetting = @"";
colvarOrderMemo.ForeignKeyTableName = "";
colvarOrderMemo.ApplyExtendedProperties();
this.Columns.Add(colvarOrderMemo);
TableSchema.TableColumn colvarOrderType = new TableSchema.TableColumn(this);
colvarOrderType.ColumnName = "OrderType";
colvarOrderType.DataType = DbType.Int32;
colvarOrderType.MaxLength = 0;
colvarOrderType.AutoIncrement = false;
colvarOrderType.IsNullable = true;
colvarOrderType.IsPrimaryKey = false;
colvarOrderType.IsForeignKey = false;
colvarOrderType.IsReadOnly = false;
colvarOrderType.DefaultSetting = @"";
colvarOrderType.ForeignKeyTableName = "";
colvarOrderType.ApplyExtendedProperties();
this.Columns.Add(colvarOrderType);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarCashID = new TableSchema.TableColumn(this);
colvarCashID.ColumnName = "CashID";
colvarCashID.DataType = DbType.Int32;
colvarCashID.MaxLength = 0;
colvarCashID.AutoIncrement = false;
colvarCashID.IsNullable = false;
colvarCashID.IsPrimaryKey = false;
colvarCashID.IsForeignKey = false;
colvarCashID.IsReadOnly = false;
colvarCashID.DefaultSetting = @"";
colvarCashID.ForeignKeyTableName = "";
colvarCashID.ApplyExtendedProperties();
this.Columns.Add(colvarCashID);
TableSchema.TableColumn colvarCashDate = new TableSchema.TableColumn(this);
colvarCashDate.ColumnName = "CashDate";
colvarCashDate.DataType = DbType.DateTime;
colvarCashDate.MaxLength = 0;
colvarCashDate.AutoIncrement = false;
colvarCashDate.IsNullable = true;
colvarCashDate.IsPrimaryKey = false;
colvarCashDate.IsForeignKey = false;
colvarCashDate.IsReadOnly = false;
colvarCashDate.DefaultSetting = @"";
colvarCashDate.ForeignKeyTableName = "";
colvarCashDate.ApplyExtendedProperties();
this.Columns.Add(colvarCashDate);
TableSchema.TableColumn colvarCashMemberID = new TableSchema.TableColumn(this);
colvarCashMemberID.ColumnName = "CashMemberID";
colvarCashMemberID.DataType = DbType.Int32;
colvarCashMemberID.MaxLength = 0;
colvarCashMemberID.AutoIncrement = false;
colvarCashMemberID.IsNullable = true;
colvarCashMemberID.IsPrimaryKey = false;
colvarCashMemberID.IsForeignKey = false;
colvarCashMemberID.IsReadOnly = false;
colvarCashMemberID.DefaultSetting = @"";
colvarCashMemberID.ForeignKeyTableName = "";
colvarCashMemberID.ApplyExtendedProperties();
this.Columns.Add(colvarCashMemberID);
TableSchema.TableColumn colvarCashCompanyID = new TableSchema.TableColumn(this);
colvarCashCompanyID.ColumnName = "CashCompanyID";
colvarCashCompanyID.DataType = DbType.Int32;
colvarCashCompanyID.MaxLength = 0;
colvarCashCompanyID.AutoIncrement = false;
colvarCashCompanyID.IsNullable = true;
colvarCashCompanyID.IsPrimaryKey = false;
colvarCashCompanyID.IsForeignKey = false;
colvarCashCompanyID.IsReadOnly = false;
colvarCashCompanyID.DefaultSetting = @"";
colvarCashCompanyID.ForeignKeyTableName = "";
colvarCashCompanyID.ApplyExtendedProperties();
this.Columns.Add(colvarCashCompanyID);
TableSchema.TableColumn colvarCashOrderID = new TableSchema.TableColumn(this);
colvarCashOrderID.ColumnName = "CashOrderID";
colvarCashOrderID.DataType = DbType.Int32;
colvarCashOrderID.MaxLength = 0;
colvarCashOrderID.AutoIncrement = false;
colvarCashOrderID.IsNullable = true;
colvarCashOrderID.IsPrimaryKey = false;
colvarCashOrderID.IsForeignKey = false;
colvarCashOrderID.IsReadOnly = false;
colvarCashOrderID.DefaultSetting = @"";
colvarCashOrderID.ForeignKeyTableName = "";
colvarCashOrderID.ApplyExtendedProperties();
this.Columns.Add(colvarCashOrderID);
TableSchema.TableColumn colvarCashSum = new TableSchema.TableColumn(this);
colvarCashSum.ColumnName = "CashSum";
colvarCashSum.DataType = DbType.Decimal;
colvarCashSum.MaxLength = 0;
colvarCashSum.AutoIncrement = false;
colvarCashSum.IsNullable = true;
colvarCashSum.IsPrimaryKey = false;
colvarCashSum.IsForeignKey = false;
colvarCashSum.IsReadOnly = false;
colvarCashSum.DefaultSetting = @"";
colvarCashSum.ForeignKeyTableName = "";
colvarCashSum.ApplyExtendedProperties();
this.Columns.Add(colvarCashSum);
TableSchema.TableColumn colvarCashRate = new TableSchema.TableColumn(this);
colvarCashRate.ColumnName = "CashRate";
colvarCashRate.DataType = DbType.Decimal;
colvarCashRate.MaxLength = 0;
colvarCashRate.AutoIncrement = false;
colvarCashRate.IsNullable = true;
colvarCashRate.IsPrimaryKey = false;
colvarCashRate.IsForeignKey = false;
colvarCashRate.IsReadOnly = false;
colvarCashRate.DefaultSetting = @"";
colvarCashRate.ForeignKeyTableName = "";
colvarCashRate.ApplyExtendedProperties();
this.Columns.Add(colvarCashRate);
TableSchema.TableColumn colvarCashPoint = new TableSchema.TableColumn(this);
colvarCashPoint.ColumnName = "CashPoint";
colvarCashPoint.DataType = DbType.Decimal;
colvarCashPoint.MaxLength = 0;
colvarCashPoint.AutoIncrement = false;
colvarCashPoint.IsNullable = true;
colvarCashPoint.IsPrimaryKey = false;
colvarCashPoint.IsForeignKey = false;
colvarCashPoint.IsReadOnly = false;
colvarCashPoint.DefaultSetting = @"";
colvarCashPoint.ForeignKeyTableName = "";
colvarCashPoint.ApplyExtendedProperties();
this.Columns.Add(colvarCashPoint);
TableSchema.TableColumn colvarCashMemo = new TableSchema.TableColumn(this);
colvarCashMemo.ColumnName = "CashMemo";
colvarCashMemo.DataType = DbType.String;
colvarCashMemo.MaxLength = 50;
colvarCashMemo.AutoIncrement = false;
colvarCashMemo.IsNullable = true;
colvarCashMemo.IsPrimaryKey = false;
colvarCashMemo.IsForeignKey = false;
colvarCashMemo.IsReadOnly = false;
colvarCashMemo.DefaultSetting = @"";
colvarCashMemo.ForeignKeyTableName = "";
colvarCashMemo.ApplyExtendedProperties();
this.Columns.Add(colvarCashMemo);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarKey = new TableSchema.TableColumn(this);
colvarKey.ColumnName = "Key";
colvarKey.DataType = DbType.String;
colvarKey.MaxLength = 100;
colvarKey.AutoIncrement = false;
colvarKey.IsNullable = false;
colvarKey.IsPrimaryKey = false;
colvarKey.IsForeignKey = false;
colvarKey.IsReadOnly = false;
colvarKey.DefaultSetting = @"";
colvarKey.ForeignKeyTableName = "";
colvarKey.ApplyExtendedProperties();
this.Columns.Add(colvarKey);
TableSchema.TableColumn colvarValueX = new TableSchema.TableColumn(this);
colvarValueX.ColumnName = "Value";
colvarValueX.DataType = DbType.String;
colvarValueX.MaxLength = 500;
colvarValueX.AutoIncrement = false;
colvarValueX.IsNullable = true;
colvarValueX.IsPrimaryKey = false;
colvarValueX.IsForeignKey = false;
colvarValueX.IsReadOnly = false;
colvarValueX.DefaultSetting = @"";
colvarValueX.ForeignKeyTableName = "";
colvarValueX.ApplyExtendedProperties();
this.Columns.Add(colvarValueX);
TableSchema.TableColumn colvarDescribe = new TableSchema.TableColumn(this);
colvarDescribe.ColumnName = "Describe";
colvarDescribe.DataType = DbType.String;
colvarDescribe.MaxLength = 500;
colvarDescribe.AutoIncrement = false;
colvarDescribe.IsNullable = true;
colvarDescribe.IsPrimaryKey = false;
colvarDescribe.IsForeignKey = false;
colvarDescribe.IsReadOnly = false;
colvarDescribe.DefaultSetting = @"";
colvarDescribe.ForeignKeyTableName = "";
colvarDescribe.ApplyExtendedProperties();
this.Columns.Add(colvarDescribe);
TableSchema.TableColumn colvarLan = new TableSchema.TableColumn(this);
colvarLan.ColumnName = "Lan";
colvarLan.DataType = DbType.String;
colvarLan.MaxLength = 8;
colvarLan.AutoIncrement = false;
colvarLan.IsNullable = false;
colvarLan.IsPrimaryKey = false;
colvarLan.IsForeignKey = false;
colvarLan.IsReadOnly = false;
colvarLan.DefaultSetting = @"(N'zh')";
colvarLan.ForeignKeyTableName = "";
colvarLan.ApplyExtendedProperties();
this.Columns.Add(colvarLan);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarPaymentRateID = new TableSchema.TableColumn(this);
colvarPaymentRateID.ColumnName = "PaymentRateID";
colvarPaymentRateID.DataType = DbType.Int32;
colvarPaymentRateID.MaxLength = 0;
colvarPaymentRateID.AutoIncrement = true;
colvarPaymentRateID.IsNullable = false;
colvarPaymentRateID.IsPrimaryKey = true;
colvarPaymentRateID.IsForeignKey = false;
colvarPaymentRateID.IsReadOnly = false;
colvarPaymentRateID.DefaultSetting = @"";
colvarPaymentRateID.ForeignKeyTableName = "";
colvarPaymentRateID.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentRateID);
TableSchema.TableColumn colvarPaymentRateDate = new TableSchema.TableColumn(this);
colvarPaymentRateDate.ColumnName = "PaymentRateDate";
colvarPaymentRateDate.DataType = DbType.DateTime;
colvarPaymentRateDate.MaxLength = 0;
colvarPaymentRateDate.AutoIncrement = false;
colvarPaymentRateDate.IsNullable = true;
colvarPaymentRateDate.IsPrimaryKey = false;
colvarPaymentRateDate.IsForeignKey = false;
colvarPaymentRateDate.IsReadOnly = false;
colvarPaymentRateDate.DefaultSetting = @"";
colvarPaymentRateDate.ForeignKeyTableName = "";
colvarPaymentRateDate.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentRateDate);
TableSchema.TableColumn colvarPaymentRateCompanyID = new TableSchema.TableColumn(this);
colvarPaymentRateCompanyID.ColumnName = "PaymentRateCompanyID";
colvarPaymentRateCompanyID.DataType = DbType.Int32;
colvarPaymentRateCompanyID.MaxLength = 0;
colvarPaymentRateCompanyID.AutoIncrement = false;
colvarPaymentRateCompanyID.IsNullable = true;
colvarPaymentRateCompanyID.IsPrimaryKey = false;
colvarPaymentRateCompanyID.IsForeignKey = false;
colvarPaymentRateCompanyID.IsReadOnly = false;
colvarPaymentRateCompanyID.DefaultSetting = @"";
colvarPaymentRateCompanyID.ForeignKeyTableName = "";
colvarPaymentRateCompanyID.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentRateCompanyID);
TableSchema.TableColumn colvarPaymentRateSale = new TableSchema.TableColumn(this);
colvarPaymentRateSale.ColumnName = "PaymentRateSale";
colvarPaymentRateSale.DataType = DbType.Decimal;
colvarPaymentRateSale.MaxLength = 0;
colvarPaymentRateSale.AutoIncrement = false;
colvarPaymentRateSale.IsNullable = true;
colvarPaymentRateSale.IsPrimaryKey = false;
colvarPaymentRateSale.IsForeignKey = false;
colvarPaymentRateSale.IsReadOnly = false;
colvarPaymentRateSale.DefaultSetting = @"";
colvarPaymentRateSale.ForeignKeyTableName = "";
colvarPaymentRateSale.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentRateSale);
TableSchema.TableColumn colvarPaymentRateSum = new TableSchema.TableColumn(this);
colvarPaymentRateSum.ColumnName = "PaymentRateSum";
colvarPaymentRateSum.DataType = DbType.Decimal;
colvarPaymentRateSum.MaxLength = 0;
colvarPaymentRateSum.AutoIncrement = false;
colvarPaymentRateSum.IsNullable = true;
colvarPaymentRateSum.IsPrimaryKey = false;
colvarPaymentRateSum.IsForeignKey = false;
colvarPaymentRateSum.IsReadOnly = false;
colvarPaymentRateSum.DefaultSetting = @"";
colvarPaymentRateSum.ForeignKeyTableName = "";
colvarPaymentRateSum.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentRateSum);
TableSchema.TableColumn colvarPaymentRateMemo = new TableSchema.TableColumn(this);
colvarPaymentRateMemo.ColumnName = "PaymentRateMemo";
colvarPaymentRateMemo.DataType = DbType.String;
colvarPaymentRateMemo.MaxLength = 50;
colvarPaymentRateMemo.AutoIncrement = false;
colvarPaymentRateMemo.IsNullable = true;
colvarPaymentRateMemo.IsPrimaryKey = false;
colvarPaymentRateMemo.IsForeignKey = false;
colvarPaymentRateMemo.IsReadOnly = false;
colvarPaymentRateMemo.DefaultSetting = @"";
colvarPaymentRateMemo.ForeignKeyTableName = "";
colvarPaymentRateMemo.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentRateMemo);
TableSchema.TableColumn colvarPaymentRateStatus = new TableSchema.TableColumn(this);
colvarPaymentRateStatus.ColumnName = "PaymentRateStatus";
colvarPaymentRateStatus.DataType = DbType.Int32;
colvarPaymentRateStatus.MaxLength = 0;
colvarPaymentRateStatus.AutoIncrement = false;
colvarPaymentRateStatus.IsNullable = true;
colvarPaymentRateStatus.IsPrimaryKey = false;
colvarPaymentRateStatus.IsForeignKey = false;
colvarPaymentRateStatus.IsReadOnly = false;
colvarPaymentRateStatus.DefaultSetting = @"";
colvarPaymentRateStatus.ForeignKeyTableName = "";
colvarPaymentRateStatus.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentRateStatus);
TableSchema.TableColumn colvarPaymentRateDateStart = new TableSchema.TableColumn(this);
colvarPaymentRateDateStart.ColumnName = "PaymentRateDateStart";
colvarPaymentRateDateStart.DataType = DbType.DateTime;
colvarPaymentRateDateStart.MaxLength = 0;
colvarPaymentRateDateStart.AutoIncrement = false;
colvarPaymentRateDateStart.IsNullable = true;
colvarPaymentRateDateStart.IsPrimaryKey = false;
colvarPaymentRateDateStart.IsForeignKey = false;
colvarPaymentRateDateStart.IsReadOnly = false;
colvarPaymentRateDateStart.DefaultSetting = @"";
colvarPaymentRateDateStart.ForeignKeyTableName = "";
colvarPaymentRateDateStart.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentRateDateStart);
TableSchema.TableColumn colvarPaymentRateDateEnd = new TableSchema.TableColumn(this);
colvarPaymentRateDateEnd.ColumnName = "PaymentRateDateEnd";
colvarPaymentRateDateEnd.DataType = DbType.DateTime;
colvarPaymentRateDateEnd.MaxLength = 0;
colvarPaymentRateDateEnd.AutoIncrement = false;
colvarPaymentRateDateEnd.IsNullable = true;
colvarPaymentRateDateEnd.IsPrimaryKey = false;
colvarPaymentRateDateEnd.IsForeignKey = false;
colvarPaymentRateDateEnd.IsReadOnly = false;
colvarPaymentRateDateEnd.DefaultSetting = @"";
colvarPaymentRateDateEnd.ForeignKeyTableName = "";
colvarPaymentRateDateEnd.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentRateDateEnd);
TableSchema.TableColumn colvarPaymentRateCash = new TableSchema.TableColumn(this);
colvarPaymentRateCash.ColumnName = "PaymentRateCash";
colvarPaymentRateCash.DataType = DbType.Decimal;
colvarPaymentRateCash.MaxLength = 0;
colvarPaymentRateCash.AutoIncrement = false;
colvarPaymentRateCash.IsNullable = true;
colvarPaymentRateCash.IsPrimaryKey = false;
colvarPaymentRateCash.IsForeignKey = false;
colvarPaymentRateCash.IsReadOnly = false;
colvarPaymentRateCash.DefaultSetting = @"";
colvarPaymentRateCash.ForeignKeyTableName = "";
colvarPaymentRateCash.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentRateCash);
TableSchema.TableColumn colvarPaymentRateRate = new TableSchema.TableColumn(this);
colvarPaymentRateRate.ColumnName = "PaymentRateRate";
colvarPaymentRateRate.DataType = DbType.Decimal;
colvarPaymentRateRate.MaxLength = 0;
colvarPaymentRateRate.AutoIncrement = false;
colvarPaymentRateRate.IsNullable = true;
colvarPaymentRateRate.IsPrimaryKey = false;
colvarPaymentRateRate.IsForeignKey = false;
colvarPaymentRateRate.IsReadOnly = false;
colvarPaymentRateRate.DefaultSetting = @"";
colvarPaymentRateRate.ForeignKeyTableName = "";
colvarPaymentRateRate.ApplyExtendedProperties();
this.Columns.Add(colvarPaymentRateRate);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarName = new TableSchema.TableColumn(this);
colvarName.ColumnName = "Name";
colvarName.DataType = DbType.String;
colvarName.MaxLength = 50;
colvarName.AutoIncrement = false;
colvarName.IsNullable = true;
colvarName.IsPrimaryKey = false;
colvarName.IsForeignKey = false;
colvarName.IsReadOnly = false;
colvarName.DefaultSetting = @"";
colvarName.ForeignKeyTableName = "";
colvarName.ApplyExtendedProperties();
this.Columns.Add(colvarName);
TableSchema.TableColumn colvarPId = new TableSchema.TableColumn(this);
colvarPId.ColumnName = "P_ID";
colvarPId.DataType = DbType.Int32;
colvarPId.MaxLength = 0;
colvarPId.AutoIncrement = false;
colvarPId.IsNullable = true;
colvarPId.IsPrimaryKey = false;
colvarPId.IsForeignKey = false;
colvarPId.IsReadOnly = false;
colvarPId.DefaultSetting = @"";
colvarPId.ForeignKeyTableName = "";
colvarPId.ApplyExtendedProperties();
this.Columns.Add(colvarPId);
TableSchema.TableColumn colvarSubSysId = new TableSchema.TableColumn(this);
colvarSubSysId.ColumnName = "SubSys_ID";
colvarSubSysId.DataType = DbType.Int32;
colvarSubSysId.MaxLength = 0;
colvarSubSysId.AutoIncrement = false;
colvarSubSysId.IsNullable = true;
colvarSubSysId.IsPrimaryKey = false;
colvarSubSysId.IsForeignKey = false;
colvarSubSysId.IsReadOnly = false;
colvarSubSysId.DefaultSetting = @"";
colvarSubSysId.ForeignKeyTableName = "";
colvarSubSysId.ApplyExtendedProperties();
this.Columns.Add(colvarSubSysId);
TableSchema.TableColumn colvarUId = new TableSchema.TableColumn(this);
colvarUId.ColumnName = "U_ID";
colvarUId.DataType = DbType.Int32;
colvarUId.MaxLength = 0;
colvarUId.AutoIncrement = false;
colvarUId.IsNullable = true;
colvarUId.IsPrimaryKey = false;
colvarUId.IsForeignKey = false;
colvarUId.IsReadOnly = false;
colvarUId.DefaultSetting = @"";
colvarUId.ForeignKeyTableName = "";
colvarUId.ApplyExtendedProperties();
this.Columns.Add(colvarUId);
TableSchema.TableColumn colvarPath = new TableSchema.TableColumn(this);
colvarPath.ColumnName = "Path";
colvarPath.DataType = DbType.String;
colvarPath.MaxLength = 250;
colvarPath.AutoIncrement = false;
colvarPath.IsNullable = true;
colvarPath.IsPrimaryKey = false;
colvarPath.IsForeignKey = false;
colvarPath.IsReadOnly = false;
colvarPath.DefaultSetting = @"";
colvarPath.ForeignKeyTableName = "";
colvarPath.ApplyExtendedProperties();
this.Columns.Add(colvarPath);
TableSchema.TableColumn colvarSort = new TableSchema.TableColumn(this);
colvarSort.ColumnName = "Sort";
colvarSort.DataType = DbType.Int32;
colvarSort.MaxLength = 0;
colvarSort.AutoIncrement = false;
colvarSort.IsNullable = true;
colvarSort.IsPrimaryKey = false;
colvarSort.IsForeignKey = false;
colvarSort.IsReadOnly = false;
colvarSort.DefaultSetting = @"";
colvarSort.ForeignKeyTableName = "";
colvarSort.ApplyExtendedProperties();
this.Columns.Add(colvarSort);
TableSchema.TableColumn colvarKeyWord = new TableSchema.TableColumn(this);
colvarKeyWord.ColumnName = "KeyWord";
colvarKeyWord.DataType = DbType.String;
colvarKeyWord.MaxLength = 250;
colvarKeyWord.AutoIncrement = false;
colvarKeyWord.IsNullable = true;
colvarKeyWord.IsPrimaryKey = false;
colvarKeyWord.IsForeignKey = false;
colvarKeyWord.IsReadOnly = false;
colvarKeyWord.DefaultSetting = @"";
colvarKeyWord.ForeignKeyTableName = "";
colvarKeyWord.ApplyExtendedProperties();
this.Columns.Add(colvarKeyWord);
TableSchema.TableColumn colvarCreatedBy = new TableSchema.TableColumn(this);
colvarCreatedBy.ColumnName = "CreatedBy";
colvarCreatedBy.DataType = DbType.Int32;
colvarCreatedBy.MaxLength = 0;
colvarCreatedBy.AutoIncrement = false;
colvarCreatedBy.IsNullable = true;
colvarCreatedBy.IsPrimaryKey = false;
colvarCreatedBy.IsForeignKey = false;
colvarCreatedBy.IsReadOnly = false;
colvarCreatedBy.DefaultSetting = @"";
colvarCreatedBy.ForeignKeyTableName = "";
colvarCreatedBy.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedBy);
TableSchema.TableColumn colvarCreatedOn = new TableSchema.TableColumn(this);
colvarCreatedOn.ColumnName = "CreatedOn";
colvarCreatedOn.DataType = DbType.DateTime;
colvarCreatedOn.MaxLength = 0;
colvarCreatedOn.AutoIncrement = false;
colvarCreatedOn.IsNullable = true;
colvarCreatedOn.IsPrimaryKey = false;
colvarCreatedOn.IsForeignKey = false;
colvarCreatedOn.IsReadOnly = false;
colvarCreatedOn.DefaultSetting = @"";
colvarCreatedOn.ForeignKeyTableName = "";
colvarCreatedOn.ApplyExtendedProperties();
this.Columns.Add(colvarCreatedOn);
TableSchema.TableColumn colvarModifiedBy = new TableSchema.TableColumn(this);
colvarModifiedBy.ColumnName = "ModifiedBy";
colvarModifiedBy.DataType = DbType.Int32;
colvarModifiedBy.MaxLength = 0;
colvarModifiedBy.AutoIncrement = false;
colvarModifiedBy.IsNullable = true;
colvarModifiedBy.IsPrimaryKey = false;
colvarModifiedBy.IsForeignKey = false;
colvarModifiedBy.IsReadOnly = false;
colvarModifiedBy.DefaultSetting = @"";
colvarModifiedBy.ForeignKeyTableName = "";
colvarModifiedBy.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedBy);
TableSchema.TableColumn colvarModifiedOn = new TableSchema.TableColumn(this);
colvarModifiedOn.ColumnName = "ModifiedOn";
colvarModifiedOn.DataType = DbType.DateTime;
colvarModifiedOn.MaxLength = 0;
colvarModifiedOn.AutoIncrement = false;
colvarModifiedOn.IsNullable = true;
colvarModifiedOn.IsPrimaryKey = false;
colvarModifiedOn.IsForeignKey = false;
colvarModifiedOn.IsReadOnly = false;
colvarModifiedOn.DefaultSetting = @"";
colvarModifiedOn.ForeignKeyTableName = "";
colvarModifiedOn.ApplyExtendedProperties();
this.Columns.Add(colvarModifiedOn);
}
protected override void Initital()
{
//Schema define
this.Columns = new TableSchema.TableColumnCollection();
this.SchemaName = @"dbo";
this.TableType = TableType.Table;
//columns
TableSchema.TableColumn colvarId = new TableSchema.TableColumn(this);
colvarId.ColumnName = "ID";
colvarId.DataType = DbType.Int32;
colvarId.MaxLength = 0;
colvarId.AutoIncrement = true;
colvarId.IsNullable = false;
colvarId.IsPrimaryKey = true;
colvarId.IsForeignKey = false;
colvarId.IsReadOnly = false;
colvarId.DefaultSetting = @"";
colvarId.ForeignKeyTableName = "";
colvarId.ApplyExtendedProperties();
this.Columns.Add(colvarId);
TableSchema.TableColumn colvarMenuId = new TableSchema.TableColumn(this);
colvarMenuId.ColumnName = "MenuId";
colvarMenuId.DataType = DbType.Int32;
colvarMenuId.MaxLength = 0;
colvarMenuId.AutoIncrement = false;
colvarMenuId.IsNullable = true;
colvarMenuId.IsPrimaryKey = false;
colvarMenuId.IsForeignKey = false;
colvarMenuId.IsReadOnly = false;
colvarMenuId.DefaultSetting = @"";
colvarMenuId.ForeignKeyTableName = "";
colvarMenuId.ApplyExtendedProperties();
this.Columns.Add(colvarMenuId);
TableSchema.TableColumn colvarMenuName = new TableSchema.TableColumn(this);
colvarMenuName.ColumnName = "MenuName";
colvarMenuName.DataType = DbType.String;
colvarMenuName.MaxLength = -1;
colvarMenuName.AutoIncrement = false;
colvarMenuName.IsNullable = true;
colvarMenuName.IsPrimaryKey = false;
colvarMenuName.IsForeignKey = false;
colvarMenuName.IsReadOnly = false;
colvarMenuName.DefaultSetting = @"";
colvarMenuName.ForeignKeyTableName = "";
colvarMenuName.ApplyExtendedProperties();
this.Columns.Add(colvarMenuName);
TableSchema.TableColumn colvarOrderId = new TableSchema.TableColumn(this);
colvarOrderId.ColumnName = "OrderId";
colvarOrderId.DataType = DbType.Int32;
colvarOrderId.MaxLength = 0;
colvarOrderId.AutoIncrement = false;
colvarOrderId.IsNullable = true;
colvarOrderId.IsPrimaryKey = false;
colvarOrderId.IsForeignKey = false;
colvarOrderId.IsReadOnly = false;
colvarOrderId.DefaultSetting = @"";
colvarOrderId.ForeignKeyTableName = "";
colvarOrderId.ApplyExtendedProperties();
this.Columns.Add(colvarOrderId);
TableSchema.TableColumn colvarOrderQty = new TableSchema.TableColumn(this);
colvarOrderQty.ColumnName = "OrderQty";
colvarOrderQty.DataType = DbType.Int32;
colvarOrderQty.MaxLength = 0;
colvarOrderQty.AutoIncrement = false;
colvarOrderQty.IsNullable = true;
colvarOrderQty.IsPrimaryKey = false;
colvarOrderQty.IsForeignKey = false;
colvarOrderQty.IsReadOnly = false;
colvarOrderQty.DefaultSetting = @"";
colvarOrderQty.ForeignKeyTableName = "";
colvarOrderQty.ApplyExtendedProperties();
this.Columns.Add(colvarOrderQty);
TableSchema.TableColumn colvarOrderPrice = new TableSchema.TableColumn(this);
colvarOrderPrice.ColumnName = "OrderPrice";
colvarOrderPrice.DataType = DbType.Decimal;
colvarOrderPrice.MaxLength = 0;
colvarOrderPrice.AutoIncrement = false;
colvarOrderPrice.IsNullable = true;
colvarOrderPrice.IsPrimaryKey = false;
colvarOrderPrice.IsForeignKey = false;
colvarOrderPrice.IsReadOnly = false;
colvarOrderPrice.DefaultSetting = @"";
colvarOrderPrice.ForeignKeyTableName = "";
colvarOrderPrice.ApplyExtendedProperties();
this.Columns.Add(colvarOrderPrice);
TableSchema.TableColumn colvarIsChgPrice = new TableSchema.TableColumn(this);
colvarIsChgPrice.ColumnName = "IsChgPrice";
colvarIsChgPrice.DataType = DbType.Boolean;
colvarIsChgPrice.MaxLength = 0;
colvarIsChgPrice.AutoIncrement = false;
colvarIsChgPrice.IsNullable = true;
colvarIsChgPrice.IsPrimaryKey = false;
colvarIsChgPrice.IsForeignKey = false;
colvarIsChgPrice.IsReadOnly = false;
colvarIsChgPrice.DefaultSetting = @"";
colvarIsChgPrice.ForeignKeyTableName = "";
colvarIsChgPrice.ApplyExtendedProperties();
this.Columns.Add(colvarIsChgPrice);
TableSchema.TableColumn colvarIsOutOfStock = new TableSchema.TableColumn(this);
colvarIsOutOfStock.ColumnName = "IsOutOfStock";
colvarIsOutOfStock.DataType = DbType.Boolean;
colvarIsOutOfStock.MaxLength = 0;
colvarIsOutOfStock.AutoIncrement = false;
colvarIsOutOfStock.IsNullable = true;
colvarIsOutOfStock.IsPrimaryKey = false;
colvarIsOutOfStock.IsForeignKey = false;
colvarIsOutOfStock.IsReadOnly = false;
colvarIsOutOfStock.DefaultSetting = @"";
colvarIsOutOfStock.ForeignKeyTableName = "";
colvarIsOutOfStock.ApplyExtendedProperties();
this.Columns.Add(colvarIsOutOfStock);
TableSchema.TableColumn colvarItemInfo = new TableSchema.TableColumn(this);
colvarItemInfo.ColumnName = "ItemInfo";
colvarItemInfo.DataType = DbType.String;
colvarItemInfo.MaxLength = -1;
colvarItemInfo.AutoIncrement = false;
colvarItemInfo.IsNullable = true;
colvarItemInfo.IsPrimaryKey = false;
colvarItemInfo.IsForeignKey = false;
colvarItemInfo.IsReadOnly = false;
colvarItemInfo.DefaultSetting = @"";
colvarItemInfo.ForeignKeyTableName = "";
colvarItemInfo.ApplyExtendedProperties();
this.Columns.Add(colvarItemInfo);
}