Deprecated

Sunbird.action_group (PRIMARY KEY: id)

Column NameData TypeDescription

id

text

actionid

text

groupname

text

sunbird.user_action_role [PRIMARY KEY: id]

Column NameData TypeDescription

id

text

roleid

text

actiongroupid

list<text>

sunbird.user_skills [PRIMARY KEY: id]

Column NameData TypeDescription

id

text

createdby

text

createdon

timestamp

endorsementcount

int

endorserslist

frozen<list<frozen<map<text, text>>>>

lastupdatedby

text

lastupdatedon

timestamp

skillname

text

skillnametolowercase

text

userid

text

sunbird.user_org [PRIMARY KEY: id]

Column NameData TypeDescription

id

text

addedby

text

addedbyname

text

approvaldate

text

approvedby

text

hashtagid

text

isapproved

boolean

isdeleted

boolean

isrejected

boolean

organisationid

text

orgjoindate

text

orgleftdate

text

position

text

roles

list<text>

updatedby

text

updateddate

text

userid

text

sunbird.user_cert [PRIMARY KEY: id]

Column NameData TypeDescription

id

text

accesscode

text

createdat

timestamp

isdeleted

boolean

oldid

text

store

map<text, text>

updatedat

timestamp

userid

text

sunbird.user_feed [PRIMARY KEY: id]

Column NameData TypeDescription

id

text

category

text

createdby

text

createdon

timestamp

data

text

expireon

timestamp

priority

int

status

text

updatedby

text

updatedon

timestamp

userid

text

sunbird.tenant_preference [PRIMARY KEY: id]

Column NameData TypeDescription

id

text

data

text

key

text

orgid

text

role

text

tenantname

text

Sunbird.address (PRIMARY KEY: id)

Column NameData TypeDescription

id

text

addressline1

text

addressline2

text

addtype

text

city

text

country

text

createdby

text

createddate

text

isdeleted

boolean

state

text

updatedby

text

updateddate

text

userid

text

zipcode

text

sunbird.cert_registry (PRIMARY KEY: id)

Column NameData TypeDescription

id

text

accesscode

text

createdat

timestamp

createdby

text

data

text

isrevoked

boolean

jsonurl

text

pdfurl

text

reason

text

recipient

text

related

text

updatedat

timestamp

updatedby

text

sunbird.config_path_audit (PRIMARY KEY: ((id, cloud_store_type), created_date))

Column NameData TypeDescription

id

text

cloud_store_type

text

created_date

bigint

cloud_store_account

text

cloud_store_container

text

cloud_store_path

text

version

bigint

sunbird.geo_location (PRIMARY KEY: id)

Column NameData TypeDescription

id

text

createdby

text

createddate

text

location

text

rootorgid

text

topic

text

type

text

updatedby

text

updateddate

text

usercount

int

usercountttl

text

sunbird.master_action (PRIMARY KEY: id)

Column NameData TypeDescription

id

text

name

text

sunbird.media_type

Column NameData TypeDescription

id

text

name

text

sunbird.report_tracking [PRIMARY KEY: id]

Column NameData TypeDescription

id

text

createddate

text

data

text

email

text

fileurl

text

firstname

text

format

text

period

text

resourceid

text

resourcename

text

status

int

trycount

int

type

text

updateddate

text

uploadeddate

text

userid

text

sunbird.shadow_user [PRIMARY KEY (channel, userextid)]

Column NameData TypeDescription

channel

userextid

addedby

attemptedcount

int

claimedon

timestamp

claimstatus

int

createdon

timestamp

email

name

orgextid

phone

processid

updatedon

timestamp

userid

userids

list<text>

userstatus

int

Last updated