Notes for overhaul (SCRAPPED (FOR NOW?))

Main models

• job
  • user:references (this is the poster)
  • title:string
  • desc:text
  • exp_date
  • num_positions
  • department_id (defaults to first sponsor's department)
  • activation_code
  • active
• user
  • already done

Other models

• applic
• department
• document
• enrollment
  • grade
  • semester
  • course_id
  • user_id
• faculties
  • user_id
• sponsorship
  • job_id
  • faculty_id
• attrib: metadata about a job, such as category or proglang
  • name ("category", "proglang", etc. -- constants)
  • value ("signal processing", "ruby", "paid", "credit", etc.)
• user_attrib
• job_attrib

Design decisions

We're implementing our own tags, via the Attrib model. This lets us have flexibility by categorizing various tags, and implementing different tag-to-tagged relationships.