In app i’m working on I have to save Work History and Education History for users
For work history we have: company_name, position, job_description, eplooyed_from employed_to
For education history we have: school_name, degree_level, subject_studied, attended_from, attended_to
As I see it right now, the easies way to do it, is to have separate models/tables and use attribute names as described above, which would reflect real world model little more.
Also in this case STI could be applied, with more general model, like UserHistory with attributes similar to: name, title, description, started_on, ended_on
What would be better approach to do it? Separate models and two tables with model specific attributes or STI with more general attributes and one db table?
Also another way to do it, would be to have one model, and save name, title, description in hstore columns in hash + started_on, ended_on columns for data
P.S. i think i would need to search for university name and speciality in future