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. |
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 |