Entities

To start with the initial few entities we expect to make are the following (these may increase and relationships can increase).

Fields marked ! are required

User

• id! (oneauth id, no separate primary key here)
• email! (copy from oneauth verified email)
• college!
• branch!
• degree! B.Tech, BE etc
• grad_year! (year of graduating, expected)
• superheroId : ref: Superhero
• shieldAgentId: ref: SHIELD Agent

Superhero

• id! superhero id (eg, superhero id 10 means CBCA010)
• ref_code!
• level enum(inductee, soldier, avenger)
• handlerId: ref: SHIELD Agent agent to whom to report

SHIELD Agent

• id! autogen pk
• official_email!
• contact_no!
• clearance_level enum(director, commander, agent)
• managerId: ref: SHIELD Agent agent to whom to report

Mission

• id pk
• name
• brief mission brief (markdown)
• min_level enum(inductee, soldier, avenger)
• points points earned by completing mission

Debrief

When mission is completed, file a debrief with your SHIELD Agent whom you report to

• id pk
• mission_id: which mission ?
• superhero_id: who is filing it ?
• status: enum(claimed, accepted, rejected)
• report: markdown supported report (to be filed by superhero)
• comment: markdown supported comment by agent