notes.txt

Users:  first_name, last_name, email, volunter_number, date_joined, active, has:roll

Issue:  Title, description, priority, reported_at, completed_at, issue_number
        has:state, has:comments, has:reporter, has:assignee, has:images,
        has:location, has:route, has:region, belongs_to:category
        > rails g scaffold Issue issue_number:integer:uniq:index title:string:index description:text priority:integer:index, reported_at:datetime:index, completed_at:datetime:index

Title: name

Label: name
        > rails g scaffold Label name:string
        t.string :name, null: false, default: '', unique: true, index: true
IssueLabelSelection
        > rails g model IssueLabelSelection issue:references label:references

Category: name has_many:category_problem_selections has_many:issues
        > rails g scaffold category name:string:uniq
        > rails g migration AddCategoryToIssues category:references

CategoryProblemSelection
        > rails g model CategoryProblemSelection category:references problem:references

Problem: name, belongs:category
        > rails g scaffold problem name:string:uniq
        > rails g migration AddProblemToIssues problem:references

Comment: belongs_to:issue:user:route:region
Image: src, title(o), description(o)
State: draft, submitted, acknowledged, in-progress, resolved, re-opened, archived, deleted
Location: name, coord, url

Route: Name, url to gpx track, has:comments
       > rails g scaffold Route name:string
       > rails g migration AddRouteRefToIssues route:references
Area: Name
       > rails g scaffold Area name:string
       > rails g migration AddAreaRefToIssues area:references

Roll: name

rails g scaffold Region name:string lat:float lng:float map_zoom:integer email:string email_ notifications_sent_at:datetime
maybe add 'key' instead of identifier or slug?

FEATURES
* Issue has many followers and User has many interests
* Updates on issues are posted to users home page
* User can express interest in region of route
* Emails sent to users when activity within interest occurs

VIEWS
* Home page shows newsfeed and stats
* Users: index, show, edit
* Issues: index (filters), show, edit, new
* Regions: index, edit, new, show (lists routes and most recent issues)
* Routes: index, edit, new, show




Segments

rails g model Segment name:string:index route:references administrative_area:references last_checked_by_id:integer:index last_checked_at:datetime:index track:text


sudo -u postgres psql
\c ncn_reporting_development
\d segments