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

[{"id":"01228382278062080019","index":1,"group":1},{"id":"01228382243946496017","index":1,"group":2}]

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

[{"id":"01228382278062080019","index":1,"group":1},{"id":"01228382243946496017","index":1,"group":2}]

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