React Kanban

A digital Kanban board made with React

"The Kanban technique emerged in the late 1940s as Toyota’s reimagined approach to manufacturing and engineering. ... The system’s highly visual nature allowed teams to communicate more easily on what work needed to be done and when. It also standardized cues and refined processes, which helped to reduce waste and maximize value." - via LeanKit.com

Introduction

Build a Digital Kanban board using:

• React for building the front-end User-Interface (UI)
• HTML and CSS (via sass)
• Express as the Server
• Bookshelf.js as your ORM for the Postgresql Datastore.

Layout/Style Guide

Specifications

Card (component)

Cards contain information about a task.

Card Properties

A Card has 6 properties:

1. A unique identifier, e.g. "1", "2", "313".
2. A Title
3. A Body (task details)
4. A priority selection (Low, Medium, High, Blocker)
5. A status, the status of a card. Should match the column the card can be found in. Columns: "Queue", "In Progress", or "Done".
6. A "Created by" field. This should display name of the person who created the task.
7. An "Assigned to field". This should display the name of the person who is currently working on the task.

Creating a new Card

There should be a form which is used to create a new Card. When a card is first created we need minimal information, the information needed is:

• Title (String)
• Priority (Low, Medium, High, Blocker)
• Created By (Full Name)
• Assigned To (Full Name)

All other fields are not needed when creating a new Card. The other fields: "Unique Identifier", and "Status" fields will be automatically added by the application.

Cards in Columns

When a Card appears in a column there should be a way (something clickable?) to move that card to either the next or previous column.

Columns (component)

Columns contain Cards and each column is a collection of Cards that share the same status.

The board you will building will have 3 columns:

• Queue
  • A card will automatically appear in this column after creation.
• In Progress
  • When a card is being worked on it should be displayed in this column.
• Done
  • When work has finished on a card it should be displayed in this column.

caveat: do not try to implement click-and-drag just yet, save it as a stretch goal!

Kanban Board (Main Component)

A Kanban board contains multiple Columns (and Columns contain Cards). This is the main application component. It is responsible for retrieving data and passing it down to other child components.

Schemas

Cards

Property	Type	Options
id(Pk)	number	serial, not null, unique
title	string(255)	not null
body	string(1024)	not null
priority_id(Fk)	number	not null
status_id(Fk)	number	not null
created_by(Fk)	number	not null
assigned_to(Fk)	number	nullable
created_at	TS w/ TZ	not null
updated_at	TS w/ TZ	not null

Users

Property	Type	Options
id(Pk)	number	serial, not null, unique
first_name	string	not null
last_name	string	not null
email	string	not null, unique
created_at	TS w/ TZ	not null
updated_at	TS w/ TZ	not null

Priorities

Property	Type	Options
id(Pk)	number	serial, not null, unique
name	string	not null
rank	number	not null
created_at	TS w/ TZ	not null
updated_at	TS w/ TZ	not null

Statuses

Property	Type	Options
id(Pk)	number	serial, not null, unique
name	string	not null
rank	number	not null
created_at	TS w/ TZ	not null
updated_at	TS w/ TZ	not null

• Rank determines the position of the Priorities and Statutes when display in either a drop down input or when displaying columns by Statuses.

Server

Build an Express server which will serve your routes, index.html, and static assets.

Database

PostgreSQL and Bookshelf ORM. Create a UML Schema for your database, consider LucidChart. Add these diagrams to your project.

Styles

Make It Pretty!™

Routes

Your server will have these routes:

Backend

• RESTful API endpoints to create, read, update, and delete kanban cards for your application.
• RESTful API endpoint to retrieve and update users to be shown when choosing an assignee while creating a new kanban card.
• Remember to use MVC architecture: Models, Views, Controllers!

Frontend

• You will use react-router to add FE routes to the application.

route	action
/	Show the kanban board

Stretch Goals

• Figure out how to use react-router to add FE routes to the application.

route	action
/admin/users	Show a listing of users of the board
/admin/users/:id	User account page
/admin/users/:id/edit	Show form to let user update information
/admin/priorities/	Show list of current priorities
/admin/priorities/new	Show form to add new Priority
/admin/priorities/:id/edit	Show form to update selected Priority
/admin/statuses/	Show list of current statuses
/admin/statuses/new	Show form to add new Status
/admin/statuses/:id/edit	Show form to update selected Status

• Add drag and drop functionality

• Full Authentication System on Frontend and Backend

• Users creation using a register page and route.

• User can delete their account from their our user account page. Users can only delete their own account and deleting an account must update any cards assigned to them.

Responsive Layout

• create a desktop and mobile view. Tablet view is not needed (possible stretch goal).

References

Kanban Servies

Trello

Taiga

Asana