Program Design Documentation

Owned by Kartheek Palla

Mar 25, 2021

2 min read

Types of Orgs

Sourcing
- Sourcing Org represents a tenant in Diksha.
- It is responsible for creating Projects and reviewing/approving the content so that it flows to Diksha
Contribution
- Can be created by any user
- Contribution Orgs can nominate for projects and make their contributions
- They can have multiple users in the orgs (added via invite link)
- The users can have Contributor org levels roles - Admin or User
- Contribution Org Admin manages the Project/Program level roles within the Contribution Org, users can have reviewer and/or contributor role per project.

Enum

Type	Values	Description

Type	Values	Description
status	[Draft, Live, Closed, Retired, Unlisted]	NOT NULL
programtype	[public, private]	NOT NULL
nominationstatus	[Initiated, Pending, Approved, Rejected]

Program

Field Name	Type	Description

Field Name	Type	Description
program_id	uuid	NOT NULL
name	varchar	NOT NULL
description	text
channel	varchar	NOT NULL
template_id	varchar
config	text
image	varchar
type	varchar	NOT NULL
slug	varchar
status	varchar
content_types	text[]
target_collection_category	text[]
startdate	time without time zone
enddate	time without time zone
nomination_enddate	time without time zone
shortlisting_enddate	time without time zone
content_submission_enddate	time without time zone
createdby	varchar
updatedby	varchar
updatedon	time without time zone
createdon	time without time zone
rootorg_id	varchar
roleMapping	json
collection_ids	[]
sourcing_org_name	character
targetprimarycategories	json[]
guidelines_url	Text

Nomination

Field Name	Type	Description

Field Name	Type	Description
id	uuid	NOT NULL
program_id	varchar	NOT NULL
user_id	varchar	NOT NULL
status	nominationstatus
content_types	text[]
collection_ids	text[]
feedback	text
rolemapping	json
createdby	varchar
updatedby	varchar
updatedon	time without time zone
createdon	time without time zone
targetprimarycategories	json[]

user_program_preference

Field Name	Type	Description

Field Name	Type	Description
id	uuid	NOT NULL
program_id	varchar	NOT NULL
user_id	varchar	NOT NULL
contributor_preference	json
sourcing_preference	json
createdby	varchar
updatedby	varchar
updatedon	time without time zone
createdon	time without time zone