Organisation
sunbird.organisation (PRIMARY KEY: id)
Table used for storing Tenants/Organisations and Sub-Organisations
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
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)
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
Last updated