Proposed server structure:
/server
/configs
serverConfig.js
/models
db.js -- this includes schema definition and model methods
/controllers
UserController.js
LocationController.js
/routes
UserRoutes.js
LocationRoutes.js
/public
/views
--view templates should be here
/specs
/server
/mobile

We expose the following REST endpoints:

• GET /api/users
• GET /api/users/:user_id
• POST /api/users/
• GET /api/locations
• GET /api/locations/:location_id
• POST /api/locations/

cc: @kmeurer, @rstellar, @jjmerino, @jamesongamble, @suprbh

Proposed DB schemas is here:
http://dbdsgnr.appspot.com/app#agdkYmRzZ25ycg8LEgZTY2hlbWEYvaewCgw

@kmeurer, @jjmerino, @rstellar, @jamesongamble, @suprbh

In PostgreSQL, if table names are not defined in all lowercase, you need to enclose the table names with quote when referencing the table name in SQL statements (ie., select * from "Users"). Otherwise, you'll get "ERROR: relation "xxx" does not exist" error.

Enclosing table name with quotes can be a real pain, especially when you're debugging in psql or pgAdmin. Please change the name of our tables in all lowercase.

@suprbh - the build is failing in my localhost, and the error is coming from the following line. Can you pls fix it asap?

/Users/rosawa/dev/HR/germTheoryWebApp/server/config/dbConfig.js:46
.inTable('users'));
^
SyntaxError: Unexpected token )
at Module._compile (module.js:439:25)
at Object.Module._extensions..js (module.js:474:10)
at Module.load (module.js:356:32)
at Function.Module._load (module.js:312:12)
at Module.require (module.js:364:17)
at require (module.js:380:17)
at Object. (/Users/rosawa/dev/HR/germTheoryWebApp/server/locations/locationModel.js:1:79)
at Module._compile (module.js:456:26)
at Object.Module._extensions..js (module.js:474:10)
at Module.load (module.js:356:32)

@kmeurer, @jjmerino, @jamesongamble

From Eric Ding

A special fever/home-quarantine tracker that you can use (if you returned from ebola-endemic areas for example) that you can prove to people that you had carefully self-quarantined yourself successfully.

Some companies I've spoken with would say they might ask their returning field workers to use it to show they stayed home.

Here is the stacktrace:

state changed from starting to crashed
2014-11-05T23:05:38.700780+00:00 heroku[api]: Deploy 8bc673f by [email protected]
2014-11-05T23:05:38.700780+00:00 heroku[api]: Release v11 created by [email protected]
2014-11-05T23:05:39.058165+00:00 heroku[web.1]: State changed from crashed to starting
2014-11-05T23:05:41.665660+00:00 heroku[web.1]: Starting process with command node app.js
2014-11-05T23:05:43.280214+00:00 app[web.1]: throw err;
2014-11-05T23:05:43.281840+00:00 app[web.1]: Error: Cannot find module './config/dbCreds.js'
2014-11-05T23:05:43.281850+00:00 app[web.1]: at Object. (/app/server/server.js:3:15)
2014-11-05T23:05:43.281855+00:00 app[web.1]: at Module.load (module.js:356:32)
2014-11-05T23:05:43.280216+00:00 app[web.1]: ^
2014-11-05T23:05:43.281844+00:00 app[web.1]: at Function.Module._load (module.js:280:25)
2014-11-05T23:05:43.281853+00:00 app[web.1]: at Object.Module._extensions..js (module.js:474:10)
2014-11-05T23:05:43.281846+00:00 app[web.1]: at Module.require (module.js:364:17)
2014-11-05T23:05:43.281858+00:00 app[web.1]: at Module.require (module.js:364:17)
2014-11-05T23:05:43.281849+00:00 app[web.1]: at require (module.js:380:17)
2014-11-05T23:05:43.281856+00:00 app[web.1]: at Function.Module._load (module.js:312:12)
2014-11-05T23:05:43.281843+00:00 app[web.1]: at Function.Module._resolveFilename (module.js:338:15)
2014-11-05T23:05:43.281852+00:00 app[web.1]: at Module._compile (module.js:456:26)
2014-11-05T23:05:43.279821+00:00 app[web.1]:
2014-11-05T23:05:43.279935+00:00 app[web.1]: module.js:340