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 |
| 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 |
| 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 | |
| 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 |
Last updated