Page Management (LMS Service)
sunbird.page_management [PRIMARY KEY: id]
Table used to store configurable page information
| Column Name | Data Type | Description | Sample Data |
|---|---|---|---|
id | text | Page Identifier | 01228382478150860822 |
appmap | text | Page configuration with section information for mobile application | |
created_date | timestamp | Not used | |
createdby | text | UUID of the user who created the page | 490ed1d2-c69d-4cf0-a50c-f37e658c128d |
createddate | text | Record creation date | 2017-07-08 05:03:29:679+0000 |
name | text | Name of the page | Course |
organisationid | text | organisation Identifier for which the page is configured for | |
portalmap | text | Page configuration with section information for web portal application | |
updated_date | timestamp | Not used | |
updatedby | text | Not used | |
updateddate | text | Not used |
sunbird.page_section [PRIMARY KEY: id]
Table used to store page section details
| Column Name | Data Type | Description | Sample Data |
|---|---|---|---|
id | text | Page Section Identifier | 0131191751772733441 |
alt | text | Not used | |
created_date | timestamp | Not used | |
createdby | text | UUID of user who created the section | 9bb884fc-8a56-4727-9522-25a7d5b8ea06 |
createddate | text | Record creation date | 2020-09-30 10:28:07:042+0000 |
datasource | text | Not used | |
description | text | Not used | |
display | text | Section display title in different languages | {"name":{"en":"Latest Courses"}} |
dynamicfilters | text | Not used | |
imgurl | text | Not used | |
name | text | Section Title | Latest Courses |
searchquery | text | Query to display the contents as part of section | {"request":{"filters":{"contentType":["Course"],"objectType":["Content"],"status":["Live"]},"sort_by":{"lastPublishedOn":"desc"},"limit":10}} |
sectiondatatype | text | Data type of the Section | ContentBrowser/Content |
status | int | Status of the record | 1 |
updated_date | timestamp | Not used | |
updatedby | text | Record updated By | 9bb884fc-8a56-4727-9522-25a7d5b8ea06 |
updateddate | text | Record last updated on | 2020-09-30 10:46:11:529+0000 |
Last updated