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