AnsweredAssumed Answered

Clarification of public schema documentation

Question asked by Kevin Perkins on Jun 21, 2018

I've been building some reports using the public schema guide and have run into a number of places where the documentation leaves me with questions. In particular, I am interested in the following views and columns:

 

ViewColumnQuestion
USER_ACCOUNT_MAPPINGSTATEWhat, specifically, do each of the possible values mean?
REVIEW_COMPONENTIS_COMMITTEDWhat does "committed" mean?
REVIEW_COMPONENTIS_HIDDENWhen would this be true?
REVIEW_COMPONENTIS_LOCKEDWhen would this be true?
REVIEW_COMPONENTREVIEW_COMP_MAP_IDIs there something that this joins to in the public schema?
REVIEW_COMPONENTREVIEW_ITEM_IDIs there something that this joins to in the public schema?
REVIEW_COMPONENTUSER_ENT_IDIs there something that this joins to in the public schema?
REVIEW_COMPONENTIS_COMPONENT_DELETEDWhen would this be true?
REVIEW_COMPONENTIS_SUB_COMPONENT_DELETEDWhat is this?

 

Does anyone have answers to these?

 

Related: Update Public Database Schema Reference 

Outcomes