These are copies of production tables that we’ve decided are worth replicating. We don’t copy everything - only tables that customers actually need for analysis. The selection process considers what’s business-critical, what customers ask for, and obviously what we’re allowed to share from a security standpoint. We maintain these as proper replicas, not just snapshots. All the foreign key relationships are preserved, so you can still do complex joins across multiple tables. The sync process is pretty smart - it only updates records that have actually changed, which keeps the overhead reasonable. We use the change tracking system to figure out what needs updating and then we update records at subscriber in desired frequency. Source Tables are the foundation for everything else in subscriber. If you need granular data for custom analysis or data science work, this is where you start. They give you direct access to the detailed records without having to go through any pre-built views that might not fit your use case. Please note, this documentation covers only the standard tables that are available to all subscriber customers. If you have custom tables built specifically for your organization, those won’t be included here. Similarly, any relationships between standard tables and your custom tables aren’t documented in this guide. For documentation of your custom tables please reach out to your Dawiso account manager.
Tables
| Table | Description |
|---|---|
| APP_Applied_Permission | This table contains information about user permissions - essentially who has access to what and with what level of pe… |
| APP_Operation_Type | This is a reference table that lists the different types of operations that can happen in Dawiso. |
| APP_Role | This is a reference table for access roles that users can have in Dawiso. It contains the list of available roles wit… |
| APP_User | This is the main repository of all users in Dawiso. It stores every information we keep about users - their basic att… |
| APP_User_In_Group | This table handles the assignment of users to groups. It works through User_Id and Group_Id references to the [User… |
| C_Application | This table defines all the applications that are available in the environment. Applications in this list need to be a… |
| C_Attribute_Type | This table defines all attribute types - each object type has attributes types that describe objects of that type usi… |
| C_Change_Log_Type | |
| C_Language | |
| C_Module | |
| C_Object_Creation_Type | |
| C_Object_State | |
| C_Object_Type | |
| C_Object_Type_Category | |
| C_Relation_Type | |
| C_Source_Type | |
| C_Translation | |
| C_Translation_Key | |
| C_User_Object_Relation_Type | |
| C_Workflow_State | |
| MR_Attribute | |
| MR_Comment | |
| MR_Change_Log | |
| MR_Object | |
| MR_Object_Data | |
| MR_Object_Relation | |
| MR_Space | |
| MR_Version | |
| R_Application_In_Space | |
| R_Object_Attribute | |
| R_Object_In_Application | |
| R_Object_Relation_Type | |
| R_User_Object | |
| R_User_Space | |
| UB_Fulltext_Search | |
| UB_Visited_MR_Object | |
| UB_Visited_Space_Application | |
| UB_Visited_Url |