Organisation

sunbird.organisation (PRIMARY KEY: id)

Table used for storing Tenants/Organisations and Sub-Organisations

Column Name	Data Type	Description	Sample Value
id	text	Id of the organisation	0126796199493140480
channel	text	Abbreviation of the Tenant Organisation name	TN , AP, CBSE etc if Tenant Org Name is Tamil Nadu, Andra Pradesh, Central Board of Secondary Education etc
contactdetail	text	Not Used
createdby	text	UUID of the created user	7c784c71-9034-4de7-aa38-5382fc673b14
createddate	text	Date on which Organisation detail as added to the table
description	text	Description on the Organisation
email	text	Email Id f the Organisation
externalid	text	Unique identifier or registered Organisation Code which is used for reference externally	3453456 or something unique to the org
hashtagid	text	Same as organisation id	0126796199493140480
isrootorg	boolean	Not Used
isssoenabled	boolean	If the login from tenant site is enabled to sunbird system.	True or False
istenant	boolean	To indicate whether Organisation is a Tenant ORg or Sub- Org under the Tenant Org	True or False
keys	map<text, frozen<list<text>>>	Public key shared by the Organisation
locationids	list<text>	Not used
organisationtype	int	Type of the Organisation	2, 5 etc
orglocation	text	Location details of the organisation. This is validated against the configuration of location types in properties file "sunbird_valid_location_types"	[ { "code": "32", "type": "state" }, { "code": "3210", "type": "district" }, {"code": "321001", "type": "block"} ,{"code": "32100123", "type": "cluster"]
orgname	text	Name of the Organisation	Kids of India
provider	text	Same as channel.
rootorgid	text	null in case of Tenant Orgs and Tenant Org id incase of sub-orgs.	null or 0126796199493140480
slug	text	Slug and channel are abbrevations of organisation name, where slug is URL compatable, while channel is not.	tn, ap etc
status	int	Active or not. '1' means active, '0' is inactive	1 or 0
updatedby	text	UUID of the user who updated the organisation detail.
updateddate	text	Date in which this table record is updated last.

sunbird.org_external_identity [PRIMARY KEY: (provider, externalid)]

Table used to store details of the organisation as stored in the third party system (SSO integrated system)

Column Name	Data Type	Description	Sample Data
provider	text	Tenant Organisation to which the sub-organisation belongs to	ekstep
externalid	text	External Id of the organisation as maintained in the third party system	28110100101
orgid	text	Identifier of the organisation maintained in the Sunbird	0127257746440601604