database setup

files for:
1. table creation
2. sample data
3. query 'api'
Merge remote-tracking branch 'origin/dev-mhang'