Exemplo n.º 1
0
 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");
 }