public CreateJobPostTable()
{
this._employmentTypeColumn = "EmploymentTypeId";
this._jobCategoryColumn = "CategoryId";
this._jobTitleColumn = "TitleId";
this._locationColumn = "LocationId";
this._viewsColumn = "Views";
this._createdAtColumn = "CreatedAt";
this._employmentTypeIndex = DbHelpers.GetIndexPrefixedName("EmploymentType");
this._jobCategoryIndex = DbHelpers.GetIndexPrefixedName("JobCategory");
this._jobTitleIndex = DbHelpers.GetIndexPrefixedName("JobTitle");
this._locationIndex = DbHelpers.GetIndexPrefixedName("Location");
this._employmentTypeTable = DbHelpers.GetTableNameWithSchema(DbHelpers.EmploymentTypeTableName);
this._jobCategoryTable = DbHelpers.GetTableNameWithSchema(DbHelpers.JobCategoryTableName);
this._jobTitleTable = DbHelpers.GetTableNameWithSchema(DbHelpers.JobTitleTableName);
this._locationTable = DbHelpers.GetTableNameWithSchema(DbHelpers.LocationTableName);
this._employmentTypeForeignKeyName = DbHelpers.GetForeignKeyName(this._tableName, this._employmentTypeTable);
this._jobCategoryForeignKeyName = DbHelpers.GetForeignKeyName(this._tableName, this._jobCategoryTable);
this._jobTitleForeignKeyName = DbHelpers.GetForeignKeyName(this._tableName, this._jobTitleTable);
this._locationForeignKeyName = DbHelpers.GetForeignKeyName(this._tableName, this._locationTable);
this._viewsIndexName = DbHelpers.GetIndexPrefixedName("Views");
this._createdAtIndexName = DbHelpers.GetIndexPrefixedName("CreatedAt");
}
