KindredPrime

Name: VolunteerUp

Screen Names:
- landing page:
  - live version: https://kindredprime.github.io/volunteerup/wireframes/landing.html
  - user flows: N/A
- login page:
  - live version: https://kindredprime.github.io/volunteerup/wireframes/login.html
  - user flows: https://drive.google.com/file/d/1roO4xVtdhHWVBcD3e9pVOqmkRP5JImEy/view?usp=sharing
- sign up page:

KindredPrime

1. As a user, I want to search for volunteer organizations and events
2. As a user, I want to search for organizations and events by location
3. As a user, I want to search for organizations and events by cause(s)
4. As a returning user, I want to add volunteer organizations and events
5. As a returning user, I want to edit the volunteer organizations and events I have created
6. As a returning user, I want to delete the volunteer organizations and events I have created
7. As a new user, I want to create an account
8. As a returning user, I want to log into my account
9. As an admin, I want to see all user accounts
10. As an admin, I want to delete organizations and events

KindredPrime

Statement
The app will help people find volunteer opportunities.  Users can search for events or 
organizations by name, cause, location, etc.  Users can also add volunteer 
organizations and events, and add tags to each.  The search functions will search for 
names, tags, and locations that match the search terms.  Each organization includes a 
location, contact info, a website, the cause(s) it’s involved with, and any other tags 
users add.  Each event includes the organization running the event, the location, the 
date, the cause(s) it’s involved with, and any other tags users add.

Name: Volunteerup

KindredPrime

[Function: knex] {
  with: [Function],
  withRecursive: [Function],
  select: [Function],
  as: [Function],
  columns: [Function],
  column: [Function],
  from: [Function],
  fromJS: [Function],
  into: [Function],

KindredPrime

How many people work in the Sales department?
SELECT COUNT(e.id)
  FROM employee e JOIN department d ON e.department = d.id
  WHERE d.dept_name = 'Sales';
  
List the names of all employees assigned to the 'Plan Christmas party' project.
SELECT e.emp_name as Name, p.project_name as Project
  FROM employee e JOIN employee_project ep ON e.id = ep.emp_id
    JOIN project p ON p.id = ep.project_id
  WHERE p.project_name = 'Plan Christmas party';

KindredPrime

drop table if exists bookmarks;

create table bookmarks (
  id integer primary key generated always as identity,
  title text not null unique,
  url text not null,
  description text,
  rating integer not null check ( rating > 0 and rating < 6 )
);

KindredPrime

22:13:23.506  	Retrieving list of deployment files...
22:13:24.675  	Downloading 44 deployment files...
22:13:25.691  	Analyzing source code...
22:13:26.222  	Installing build runtime...
22:13:26.617  	Build runtime installed: 394.444ms
22:13:27.002  	Looking up build cache...
22:13:27.101  	Build cache found. Downloading...
22:13:28.030  	Build cache downloaded [19.99 MB]: 929.067ms
22:13:28.421  	Installing dependencies...
22:13:28.635  	yarn install v1.22.4

KindredPrime

{
  "name": "bookmarks",
  "version": "0.1.0",
  "private": true,
  "dependencies": {
    "prop-types": "^15.7.2",
    "react": "^16.6.3",
    "react-dom": "^16.6.3",
    "react-router-dom": "^5.2.0",
    "react-scripts": "2.1.1"

KindredPrime

1. As a new user, I want to find out what wildlife have been seen around a location of my choice
  Priority: High
2. As a new user, I want to be able to add filters for which types of wildlife (e.g. mammals, birds, insects, plants) have been seen around a location of my choice
  Priority: High
3. As a new user, I want to see pictures of wildlife that have been seen around a location of my choice
  Priority: High
4. As a new user, I want to be shown information about the wildlife that have been seen around a location of my choice
  Priority: High
5. As a new user, I want to be given links to find out more information about the wildlife that have been seen around a location of my choice
  Priority: High

KindredPrime

The app will show users information about wildlife that have been seen around whatever city they want.

The app will use the iNaturalist API, LocationIQ API, and MediaWiki API.