Home

Welcome

Check in's

Task Workflow

Architecture

Database Schema

CREATE TABLE checkins(
   id varchar PRIMARY KEY,
   teamMemberId varchar,
   pdlId varchar,
   checkInDate date,
   targetQtr varchar,
   targetYear varchar
);

Guilds

drop table if exists guilds;
CREATE TABLE guilds(
   guildid varchar PRIMARY KEY,
   name varchar UNIQUE,
   description varchar
);

Guild Members

drop table if exists guildMembers;
CREATE TABLE guildMembers(
   id varchar PRIMARY KEY,
   guildid varchar REFERENCES guilds(guildid),
   memberid varchar REFERENCES member_profile(uuid),
   lead boolean default false,
   UNIQUE(guildid, memberid)
);

Action Items

drop table if exists action_items;
CREATE TABLE action_items(
   id varchar PRIMARY KEY,
   checkinId varchar REFERENCES checkins(id),
   createdById varchar REFERENCES member_profile(uuid),
   description varchar
);

Checkin Document

drop table if exists checkin_document;
CREATE TABLE checkin_document(
   id varchar PRIMARY KEY,
   checkinsId varchar REFERENCES checkins(id),
   uploadDocId varchar UNIQUE
);

REST Endpoints

Sample

• GET /sample/:brand -- See all samples
• GET /sample/:brand/:id -- See a single sample
• GET /sample/:brand/add -- See form to add a sample
• POST /sample/:brand -- Submit data to create a sample
• POST /sample/:brand/:id/save/ -- Submit data to save a sample
• GET /sample/:brand/:id/edit -- See a form to edit a sample
• PUT /sample/:brand/:id -- Submit data from edit form
• DELETE /sample/:brand/:id -- Delete a sample