Workgroups Database

Introduction

The following "data dictionary" provides information about the tables and views in the "workgroup" PostgreSQL database of the Tableau Server repository. This database provides persistent storage for Tableau Server and is primarily intended to support that application.

The purpose of most tables is described, along with the type and purpose of columns in the tables. Foreign key relations are noted in orange rows with links that take you from the table containing the foreign key to the primary key table. This is not an exhaustive description of all tables and fields in the database, but is provided here for those customers who want to query it for information about their Tableau Server usage. This information is provided with a caution that because the purpose of these tables and views is primarily to support Tableau Server, their structure and contents may change without warning and as a result, any custom views built from them may break.

Note: All timestamps are in UTC time.

Tables (these are available to the "readonly" user)

Table Name	Description
container_service.container_contents	Table which stores the container contents for container service
container_service.containers	Table which stores the containers for container service
content_model_service.backfill_status	Table which stores the state of backfills run by the Content Model Service
content_model_service.content_model_metadata	Table which stores metadata that is internal to the Content Model Service
content_model_service.content_updates	Table which stores the updates to content (e.g. datasources) which need to be processed by the Content Model Service.
content_model_service.datasource_group_members	Table which stores members of a datasource group.
content_model_service.datasource_model	Table which stores objects of the datasource model as json encoded blobs. These objects are fields, sets, groups, etc.
extensions.extensions_events	Missing description
extensions.extensions_instances	Missing description
extensions.extensions_metadata	Missing description
extensions.safe_list	Missing description
extensions.site_settings	Missing description
file_system_backup.items	Missing description
file_system_backup.lot_info	Missing description
file_system_backup.lot_shard	Missing description
file_system_backup.service_ids	Missing description
file_system_backup.sos_files	Missing description
file_system_backup.sos_items	Missing description
file_system_backup.sos_types	Missing description
file_system_backup.status	Missing description
hyper_service.hyper_service_locks	The database entities currently locked in the Hyper Service
hyper_service.hyper_service_nodes	The Hyper nodes currently running in the Hyper Service
messagebus.subscriptions	The table to hold the subscription request details to handle service recovery
nlp.datasource_usage_stats	Usage stats stored for recommendation
nlp.datasources	The table to hold semantic model datasource in nlp service
nlp.es_historical_configurations	Elastic Search Configuration History for Tableau Server
nlp.events	Store the last event processed by nlp service
nlp.expressions	Versioned expressions created by user interactions
nlp.fields	The table to hold fields of semantic model datasource in nlp service
nlp.jobs	Store the enqueued jobs to be processed by nlp service
nlp.links	User created links, each points to a specific LOD expression
nlp.queries	Queries stored for datasource analytics
nlp.recommendation_stats	Recommendation stats extracted from nlp usage data
nlp.visualizations	visualizations stored for datasource analytics
public.api_tokens	Records for the api tokens
public.asset_key_marker	Records are used to flag a particular record in the asset_key_meta_data table.
public.asset_key_meta_data	Each record holds meta data for an asset encryption key.
public.asset_list_items	Contains the individual list entries that correspond to the lists defined in the asset_lists table.
public.asset_lists	This table supports the creation of various types of per-user lists. The actual list contents are listed in the asset_list_items table.
public.async_jobs	Records information about background tasks that are run in response to some user action (as opposed to being run on some schedule).
public.authorizable_permission_sets	Many-to-many mapping table between authorizables and permission sets. An authorizable may have a permission set for every permission_set_class.
public.background_jobs	Records information about background tasks that are run by a Backgrounder process. These tasks are almost always run according to some schedule, but in a few cases they may also be triggered by some user actions.
public.background_jobs_cancel	BG jobs for which cancellation has been requested
public.big_texts	This table serves as a convenient place to store a big text object, if necessary. It's kind of a utility table. This table is really just used for internal purposes.
public.capabilities	Holds a relatively short list of capabilities. A user can be allowed certain capabilities either through being some sort of admin, or through owning something like a workbook or a project, or via entries in the next_gen_permissions table. Capabilities are things like read, write, export_data, publish, web_authoring, etc.
public.capability_roles	This table serves primarily to associate roles with capabilities. A given role can have many capabilities, and a given capability can be associated with several roles.
public.collection_metrics_aggregations	Each record represents a partial aggregation of analytics for a given collection in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.
public.column_assets	Each record represents a column asset that exists on Tableau Server.
public.command_job_mappings	Each record represents a mapping between an extract command and a background job.
public.comment_attachments	Attachments for comments.
public.comments	Comments users made on views.
public.content_sync_token	Each record stores the checksum associated to a piece of content
public.content_usage	Information about operations performed on Server content.
public.custom_views_metrics_aggregations	Each record represents a partial aggregation of analytics for a given custom view in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.
public.customized_views	When a user creates a customized view, the data that supports that goes in this table.
public.data_alerts	Each record represents an alert. An alert is a predefined data conditions on a view, and if conditions are met all alert recipients get notified.
public.data_alerts_recipients	Each record represents the intent of recipient to be notified if an event is triggered.
public.data_connections	Describes various data sources that are included in either workbooks or datasources.
public.data_quality_indicators	Table to store data quality indicators.
public.data_quality_triggers	Table to store data quality triggers.
public.data_role_contents_association	Represents the association between the data_role and other content types.
public.data_role_datasource_field_association	Represents the association between the data_role and the field on a datasource
public.data_roles	Each record represents an entry of Semantics Service data role metadata.
public.database_asset_events	Used to store database_asset events stream.
public.database_assets	Each record represents a database that exists on Tableau Server.
public.datasource_events	Used to store datasource events stream.
public.datasource_fields	Describes datasource fields.
public.datasource_metrics_aggregations	Each record represents a partial aggregation of analytics for a given datasource in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.
public.datasource_refresh_properties	Extension of datasources table for refresh properties (Online). This is 1-0/1 relationship to datasources table. It is a separate table since it contains Online-specific properties.
public.datasource_versions	Datasource versions saved on server.
public.datasources	Records all Published datasources on server.
public.desktop_reporting	Each record represents a Tableau Desktop usage report.
public.domains	Records represent either an Active Directory domain or an authenticate system.
public.draft_metadata	Each record represents a workbook draft per site, per project per user.
public.extensions_block_list	Table which stores the block list of extensions on this server
public.extensions_events	Table which stores the events of referenced extensions calculation service
public.extensions_instances	Table which stores referenced extensions information calculated from across the workbooks.
public.extensions_metadata	Table which stores Metadata of Extensions.
public.extensions_safe_list	Table which stores safe list of extensions that are configured for a given site.
public.extensions_site_settings	Table which stores the site specific settings for extensions
public.external_service_connections	Table which stores the site specific settings for external service connections
public.external_service_site_settings	Table which stores the site level settings for external services
public.extract_operations	Each record represents an extract create operation on a Tableau workbook.
public.extract_service_commands	Table which stores the extract commands for extract service
public.extract_service_extracts	Table which stores the extracts for extract service
public.extract_service_results	Table which stores the extract results for extract service
public.extract_sessions	Extracts that have active vizql sessions.
public.extracts	Each record corresponds to a directory that contains one or more extract files associated with either a workbook or datasource.
public.field_indexability	The user-defined NLP indexability rules for fields in datasources
public.flow_drafts	Each record represents a draft for a Tableau Prep flow that exists on Tableau Server.
public.flow_events	Each row represents an event affecting a flow
public.flow_input_steps	Each record represents an individual input step from a published Tableau Prep flow.
public.flow_models	Each row contains model metadata for a flow
public.flow_output_step_runs	Each record represents a run of an output step of a flow. See flow_runs for per-flow run history.
public.flow_output_steps	Each record represents an individual output step from a published Maestro flow.
public.flow_run_errors	Each record represents an individual flow run error which has detailed information about the error
public.flow_run_spec_output_steps	Each record represents an individual output step in a flow run specification.
public.flow_run_specs	Each record represents an individual specification about how a Tableau Prep flow should be run
public.flow_runs	Each record represents a run of a flow. See flow_output_step_runs for per-output-step run history.
public.flow_runtime_owners	Table to keep track of flow/flow output step owner at flow run time. Used to calculate derived permission on flow outputs.
public.flow_user_settings	Each record represents a users selected settings for a Prep flow.
public.flow_versions	flow versions saved on server.
public.flows	Each record represents a Tableau Prep flow that exists on Tableau Server.
public.geocoding	Information about geocoding databases.
public.global_geocoding	Information about global geocoding databases.
public.group_users	Serves as a many to many linking mechanism between users and groups. A user can belong to multiple groups, and a group can contain multiple users.
public.groups	A grouping of users. Can be locally created or imported from Active Directory.
public.hist_capabilities	Records the most useful information about a capability that was relevant at the time of the event (see capabilities table).
public.hist_collections	Records the most useful information about a collection that was relevant at the time of the event.
public.hist_column_assets	Records the most useful information about a column that was relevant at the time of the event (see column_assets table).
public.hist_comments	Records the most useful information about a comment that was relevant at the time of the event (see comments table).
public.hist_configs	Can be used to record information about configuration that was in effect at the time of the historical event.
public.hist_data_connections	Records the most useful information about a data connection that was relevant at the time of the event (see data_connections table).
public.hist_data_quality_indicators	Records the most useful information about a data quality indicator that was relevant at the time of the event (see data_quality_indicators table).
public.hist_data_roles	Records the most useful information about a data role that was relevant at the time of the event (see data_roles table).
public.hist_database_assets	Records the most useful information about a database that was relevant at the time of the event (see database_assets table).
public.hist_datasources	Records the most useful information about a data source that was relevant at the time of the event (see datasources table).
public.hist_flow_drafts	Records the most useful information about a flow draft that was relevant at the time of the event (see flow_drafts table).
public.hist_flows	Records the most useful information about a flow that was relevant at the time of the event (see flows table).
public.hist_groups	Records the most useful information about a group that was relevant at the time of the event (see groups table).
public.hist_licensing_roles	Records the most useful information about a licensing role that was relevant at the time of the event (see licensing_roles table).
public.hist_metrics	Records the most useful information about a metric that was relevant at the time of the event (see metrics table).
public.hist_projects	Records the most useful information about a project that was relevant at the time of the event (see projects table).
public.hist_published_connections	Records the most useful information about a published connection that was relevant at the time of the event (see published_connections table).
public.hist_remote_agents	Records the most useful information about a remote agent that was relevant at the time of the event.
public.hist_schedules	Records the most useful information about a schedule that was relevant at the time of the event (see schedules table).
public.hist_sites	Records the most useful information about a site that was relevant at the time of the event (see sites table).
public.hist_table_assets	Records the most useful information about a table that was relevant at the time of the event (see table_assets table).
public.hist_tags	Records the most useful information about a tag that was relevant at the time of the event (see tags table).
public.hist_tasks	Records the most useful information about a task that was relevant at the time of the event (see tasks table).
public.hist_users	Records the most useful information about a user and corresponding system_user that was relevant at the time of the event (see users and system_users tables).
public.hist_views	Records the most useful information about a view that was relevant at the time of the event (see views table).
public.hist_workbooks	Records the most useful information about a workbook that was relevant at the time of the event (see workbooks table).
public.historical_disk_usage	Records historical disk utilization by Tableau Server for storage monitoring.
public.historical_event_types	The types of historical events which can be recorded.
public.historical_events	This table is the heart of the cluster of tables devoted to historical event auditing. For each event, a record is created on this table. The type of event is indicated through historical_event_type_id, which links to the historical_event_types table. Other information relevant to the event is linked through some of the other id fields in this table. Note these links go to other hist* tables, which allows the event to refer to things that might have since been deleted from the regular tables.
public.http_requests	Each record represents a request received by Tableau Server.
public.hyper_data_update_jobs	Each record represents a data update job for a live-to-Hyper connection.
public.hyper_databases	Information about Hyper databases.
public.id__ad_identity_stores	Identities for Active Directory identity stores.
public.id__identity_store_instances	Instances of identity stores.
public.id__identity_store_types	Types of identity stores.
public.id__ldap_identity_stores	Identities for LDAP identity stores.
public.id__local_identity_stores	Identities for Local identity stores.
public.identity_based_activation_reporting	Login-based License Management (LBLM) - NOTE: For any custom vizzes or reporting, it is recommended instead to use the View identity_based_activation_admin_view. In this table each row contains important dates with regard to ATR Issuing and Login-based License Usage for a given User, Site, Device and Product combination.
public.identity_based_activation_user_role_change	Login-based License Management (LBLM) - NOTE: For any custom vizzes or reporting, it is recommended instead to use the View identity_based_activation_admin_view. This table tracks site role creator changes for each given user on a given site.
public.language_prefs	Contains a listing of information about languages for which Tableau Server has been localized.
public.last_seen_user_notifications	This table stores the last seen notification time for each user.
public.lens_content_relationships	Represents the relationship between the lens and other content types.
public.lens_datasource_associations	Represents the association between the lens and the source datasources for a lens.
public.lens_fields	Table to store fields associated with lenses
public.lenses	Represents the table for storing lenses.
public.licensing_roles	Lists the various possible licensing scenarios. (Unlicensed, Guest, Viewer, or Interactor).
public.local_names	Contains translations of certain words or phrases that are relevant to some Tableau Server database constructs.
public.materialize_views_job_sos_directory	Each row in the table is a mapping of a workbook id and revision in a materialize views job to the sos directories that the job requires.
public.materialized_views	This table stores the materialized views for queries in workbooks.
public.materialized_views_bloom_filters	This table stores the bloom filters indicating materialized sites/workbooks.
public.materialized_views_connections	This table stores the information required to fetch materialized views files from the server where they are stored.
public.materialized_views_metadata	This table stores the metadata for the materialized view service.
public.materialized_views_object_status	This table stores the materialized views state configuration for objects for which the feature is enabled.
public.materialized_views_sheet_status	This table stores the materialized views state configuration for worksheets for which the feature is enabled.
public.mentions	Mentions for comments.
public.metric_metrics_aggregations	Each record represents a partial aggregation of analytics for a given metric in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.
public.metrics	Each record represents a Metric.
public.metrics_definition	Each record represents a metrics definition.
public.metrics_snapshot	Each record represents a metrics snapshot.
public.metrics_snapshot_delta	Each record represents a metrics snapshot delta.
public.metrics_view	Each record represents a metrics view.
public.most_recent_refreshes	most recent refresh data for alerts
public.most_recent_subscription_runs	most recent subscription runs data for suspend subscriptions
public.mru_list_entries	Holds most recently used list entries. The records here are linked to the lists to which they belong. Those lists are defined in the mru_lists table.
public.mru_lists	Most recently used lists by user. The actual list contents are in the mru_list_entries table.
public.next_gen_permissions	This table provides a flexible means of describing which users and groups have been granted which capabilities, on which things. Be aware that permissions is a complex topic and that this table does not contain all relevant information about permissions. For example, some permissions are given, automatically, to owners of workbooks or projects.
public.nlp_suggested_questions	Suggested questions
public.nlp_suggestion_groups	Suggested question groups
public.oauth_clients	A map that register oauth CI/CS/redierctUri per site per dbclass.
public.oauth_request_tokens	Table of tokens used for OAuth authorization requests.
public.oauth_service_code_verifiers	Short lived storage for the code verifier used in PKCE requests.
public.password_tokens	Tokens issued to client through link in email which can be redeemed to change their password
public.pdf_subscription_options	Used to store different PDF layout options.
public.pending_search_update_items	This table represents an item that is associated with a pending_search_update.
public.permission_reasons	When calculating effective permissions in the perm_users_*_capabilities functions, this table maps the integer precedence of the effective permission rule to the varchar effective permission reason. The integer precedence is internal to the stored procedures. The effective permission reason is returned to callers.
public.permission_set_classes	Represents a class of permission sets. Generally 1-to-1 with capabilities.
public.permission_set_items	Represents a single next_gen_permission in a permission_set. The columns mirror the next_gen_permissions table.
public.permission_sets	Represents a common set of permissions used by multiple authorizables.
public.permissions_templates	This table provides a flexible means of describing which users and groups will be granted which capabilities by default, on non-overwrite publishes of workbooks and datasources. Be aware that permissions is a complex topic and that this table does not contain all relevant information about permissions. For example, some permissions are given, automatically, to owners of workbooks or projects.
public.pkce_tokens	Proof Key for Credential Exchange (RFC 7636) short-lived storage.
public.projects	Each row of the table corresponds to a project on Tableau Server.
public.projects_contents	Table which stores the contents of projects
public.published_connection_extract_infos	Table contains user created extract info
public.published_connection_inflight_revision_tables	A table associated with a published connection revision. It can represent changes to an existing table or a new table.
public.published_connection_inflight_revisions	Each record represents a Published Connection in-flight revision.
public.published_connection_tables	Table contains metadata info for tables and fields from the user created published_connection_database
public.published_connections	Each record represents a Published Connection.
public.querypolicycollection	Table to store query policy collections.
public.recommendations_dismissed_views	Views dismissed by user in context of viz recommendations
public.recycle_bin_content_types	Content Type lookup table for Recycle Bin.
public.refresh_token_devices	Devices that have been issued at least one refresh token
public.refresh_tokens	Tokens issued to clients which can be redeemed by the client for access to the server
public.remote_agents	Registry of remote agents (Online). Remote agents are programs installed on customer PC and executing tasks on a behalf of a customer. The first example of agent is Tableau Data Sync. It is running in background on customer desktop and performing automatic data source refreshes based on schedules defined by customers.
public.repository_data	This table forms the link between other tables that need to store "large object" data, and the large object storage, itself.
public.resource_holder_types	Information about entities which can hold on to resources. For instance workbook is such an entity, it can reference a geocoding database and keep it alive.
public.resource_types	Information about resources which are used by some server entities. For instance geocoding databases are such resources, a workbook can reference a geocoding database and keep it alive.
public.resource_usage	Information about resources by tableau server entities, for example which geocoding databases are used by which workbooks.
public.roles	This table contains records corresponding to various classifications of users. It should really be viewed in conjuction with the capabilities and capability_roles tables. Taken together, these tables associate different roles with different sets of capabilities. The capabilities sets serve as templates when creating content.
public.saml_assertions_metadata	Records for the saml assertions
public.schedules	Records in this table define a schedule according to which certain regular tasks may be performed (see tasks table). They also indicate the next time at which the schedule will be triggered.
public.schema_migrations	This table tracks which database migrations have been applied to this database.
public.semantics_service_data_source_events	Stores the last data source event processed by semantics service
public.serial_collections	Records in this table represent groups of background jobs that should not be run simultaneously.
public.server_scoped_metadata_node_properties	Table to store properties of a node.
public.sessions	Settings associated with a user's browser session.
public.share_actions	Table storing share actions.
public.share_contents	Table storing shared content (view/workboook/etc).
public.share_deleted_sharers	Table storing deleted sharers backed up details (e.g. name). Needed because we do not cascade delete sharing action after sharer was deleted.
public.share_recipients	Table storing share recipients (users/groups/etc).
public.share_single_user_options	Table storing single user options on shared content (does not change the content itself).
public.sheet_images	Serves as a cache for all the sheet images generated by server.
public.site_logos	custom logo image metadata for sites
public.site_oidc_configurations	Defines the OpenID Connect IdP associated with a site.
public.site_roles	Lists the various possible user site roles.
public.site_saml_configurations	Defines the SAML IdP associated with a site.
public.site_saml_events	Log table for all SAML actions.
public.site_saml_sessions	Records the user sessions authenticated by the SiteSAML service.
public.site_saml_users	Users that are allowed to use Per Site SAML authentication.
public.site_scoped_metadata_node_properties	Table to store properties of a node.
public.site_user_prefs	Site user preferences.
public.sites	Each record represents a site. Each site holds its own workbooks, datasources, users, etc. Strict isolation between the contents of each site is maintained.
public.sos_blob_data	table to store sos file types as binary data
public.sos_virtual_folder_entries	Each record represents a file in a virtual folder currently tracked in Simple Object Storage.
public.sos_virtual_folders	Each record represents a virtual folder currently tracked in Simple Object Storage.
public.ss_custom_value_concepts	The table to hold value concepts used by semantics service
public.ss_field_concepts	The table to hold field concepts used by semantics service
public.ss_object_concepts	The table to hold object concepts used by semantics service
public.ss_ontologies	The table to hold ontologies used by semantics service
public.subscription_messages	This table represent a subscription email message.
public.subscriptions	Each record represents a subscription.
public.subscriptions_customized_views	This table is used to link various customized views to the subscriptions in which those customized views must be generated and emailed.
public.subscriptions_views	This table is used to link various views to the subscriptions in which those views must be generated and emailed.
public.subscriptions_workbooks	This table is used to link various workbooks to the subscriptions in which those workbooks must have views generated and emailed.
public.synonyms	The table to hold the synonyms for fields of datasources
public.system_user_identities	Identity to SystemUser mappings.
public.system_user_migration_conflicts	Conflicts when migrating system_user identities.
public.system_user_migration_conflicts_identity_data	Identity information related to ambiguous results when migrating system_user identities.
public.system_users	Each record represents a user of the server. These records correspond to login identity. A single system_user may potentially be able to login to multiple sites. The linkage between a system_user and their allowed sites is defined through the "users" table.
public.table_asset_events	Used to store table_asset events stream.
public.table_asset_sources	Used to store mappings between tables and their source.
public.table_assets	Each record represents a table asset that exists on Tableau Server.
public.taggings	Associates tags with taggable items.
public.tags	Each tag is a string value. A given tag can be associated with many taggable items in a site.
public.tasks	Serves to connect schedules with background tasks that should be run on that schedule. The schedule is defined in the schedules table, while the task is defined by type.
public.tde_files	Information about TDE files.
public.tds_datasource_files	The TDS files.
public.tds_datasource_model_fields	Fields of datasource models.
public.tds_datasource_models	Model of the datasource.
public.trusted_tickets	This table lists trusted tickets that have been created. Tickets that are redeemed are deleted once used, hence can only be used once. Tickets that are never redeemed become invalid after the time given by "expires_at" and are eventually deleted from the table automatically.
public.user_default_customized_views	Defines what customized view a user should see for a given view, by default.
public.user_images	Represents images for each associated system user.
public.user_notification_content_reference_list_items	Lists of references to other DB records in user notification content.
public.user_notification_content_references	References to other DB records in user notification content.
public.user_notification_recipients	Holds metadata for all user notification recipients on the server.
public.user_notifications	Holds metadata for all user notifications on the server.
public.user_notifications_server_settings	A key-value store for user notifications server settings.
public.user_notifications_site_settings	A key-value store for user notifications site settings.
public.user_notifications_user_settings	A key-value store for user notifications user settings.
public.user_onboardings	This table stores onboarding information for tableau features based on system user ids
public.user_prefs	Contains a variety of preferences for the various system users.
public.users	Each record links a system_users record to a site. The user's site specific settings are captured here.
public.value_synonyms	The user defined synonyms associated with values of fields in datasources
public.view_metrics_aggregations	Each record represents a partial aggregation of analytics for a given view in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.
public.views	Each records represents a view in a workbook.
public.views_stats	This table is used to track how many times each user has accessed different views.
public.viz_snapshots	This table represents a snapshots of viz.
public.viz_states	This table represents a snapshot of the state of a viz.
public.webhooks	Holds metadata for all registered webhooks on the server.
public.workbook_checksums	This table provides a set of checksums associated with a workbook which can be used to validate existence of a workbook based on its checksum.
public.workbook_events	Used to store workbook events stream.
public.workbook_exports	Each row in the table corresponds to a cached pdf file.
public.workbook_versions	Workbook versions saved on server.
public.workbooks	Each record represents a workbook that exists on the server.
recommendations.connection_fields	Missing description
recommendations.connection_tables	Missing description
recommendations.connections	Missing description
recommendations.datasources	Missing description
recommendations.fields	Missing description
recommendations.join_expressions	Missing description
recommendations.joins	Missing description
recommendations.ml_association_rules	Missing description
recommendations.ml_factorization_models	Missing description
recommendations.ml_last_trained	Track model loading and training on a per-site basis so it can be resumed if interrupted
recommendations.ml_ranked_datasource_fields	Selected top fields per datasource and their usage statistics (for published datasources)
recommendations.ml_related_view_predictions	view predictions generated by the trainer
recommendations.ml_viz_recommendations_models	Viz recommendations models. Stores a model per user, site pair.
recommendations.views_json	Views info stored as json
recommendations.workbooks	Missing description
recommendations.worksheet_fields	Missing description
recommendations.worksheets	Missing description
semantics.indexing_status	This table holds indexing status of field concepts.
webhooks.webhooks	Holds metadata for all registered webhooks on the server.

Views (these are available to both the "tableau" and the "readonly" users)

View Name	Description
public._background_tasks	This view combines the important contents of both the background_jobs table and the async_jobs table to give an overall picture of jobs that were given to a backgrounder process.
public._comments	Comments users made on views.
public._customized_views	When a user creates a customized view, the data that supports that goes in the customized_views table, and is reflected in this view.
public._datasources	Shows all Published datasources on server, along with some associated information.
public._datasources_stats	Some historical useage information about datasources. Based on the records that exist in the historical events tables.
public._groups	A grouping of users. Can be locally created or imported from Active Directory. Reflects the contents of the groups table and associated tables.
public._http_requests	Each record represents a request received by Tableau Server. Reflects data in the http_requests table.
public._projects	Each row of the table corresponds to a project on Tableau Server.
public._schedules	Records define a schedule according to which certain regular tasks may be performed (see tasks table). They also indicate the next time at which the schedule will be triggered.
public._sessions	Settings associated with a user's browser session.
public._sites	Each record represents a site. Each site holds its own workbooks, datasources, users, etc. Strict isolation between the contents of each site is maintained.
public._subscriptions	Each record provides information about subscriptions that are scheduled. Subscriptions are a mechanism for receiving specified content by email on some schedule.
public._system_users	Each record represents a user of the server. These records correspond to login identity. A single system_user may potentially be able to login to multiple sites. The linkage between a system_user and their allowed sites is defined through the "users" table.
public._tags	Each tag is a string value. A given tag can be associated with many taggable items in a site.
public._users	Information relating to users.
public._views	Each records represents a view in a workbook.
public._views_stats	Used to track how many times each user has accessed different views.
public._workbooks	Each record represents a workbook that exists on the server.
public.identity_based_activation_admin_view	Login-based License Management (LBLM) - Database view to faciliate Admin Server and Site Views for Login-based License Usage Reporting.
public.users_view	Each record corresponds to a user on the system. The data presented is a combination of user data and data from the linked system_user.

container_service.container_contents: Table which stores the container contents for container service
Name	Type	Description
Foreign key/Primary key relation from container_luid on this table to luid on table, container_service.containers
id	integer	The id which uniquely identifies row in the table
content_luid	uuid	The content_luid identifies the content from a monolith that the row is indirecty associated with
content_type	character varying	The type of content being represented by the given row
container_luid	uuid	The LUID of the container
site_luid	uuid	The LUID of the site
name	character varying	The name of the content

container_service.containers: Table which stores the containers for container service
Name	Type	Description
id	integer	The id which uniquely identifies row in the table
luid	uuid	An immutable identifier for the record.
name	character varying	The name of the container.
site_luid	uuid	The site_luid identifies the site that the row is indirecty associated with
owner_luid	uuid	The owner_luid identifies the user owner that the row is indirecty associated with
container_type	character varying	The type of container being represented by the given row
created_at	timestamp without time zone	The time at which this record was created.
updated_at	timestamp without time zone	The last time any changes were made to this record.

content_model_service.backfill_status: Table which stores the state of backfills run by the Content Model Service
Name	Type	Description
id	uuid	The id which uniquely identifies a backfill.
state	text	The current state of the backfill, e.g. PENDING, RUNNING, COMPLETE
content_type	text	The content type to which this backfill applies, e.g. datasource
created_at	timestamp without time zone	The time this row was created.
updated_at	timestamp without time zone	The time this row was last changed

content_model_service.content_model_metadata: Table which stores metadata that is internal to the Content Model Service
Name	Type	Description
key	character varying	The key used to look up a piece of metadata.
value	text	The metadata value.
created_at	timestamp without time zone	The time this row was created.
updated_at	timestamp without time zone	The time this row was last changed.

content_model_service.content_updates: Table which stores the updates to content (e.g. datasources) which need to be processed by the Content Model Service.
Name	Type	Description
Foreign key/Primary key relation from ticket_id on this table to id on table, content_model_service.backfill_status
id	uuid	The id which uniquely identifies an individual update.
content_type	text	The type of content which needs to be updated, e.g. datasource.
event_type	text	The type of change to the content, e.g. CREATE, UPDATE, DELETE.
uri	text	The uri which can be used to query of the content item which has changed.
ticket_id	uuid	The id of the backfill ticket which created this update (if it was created by a backfill).
created_at	timestamp without time zone	The time this row was created.
updated_at	timestamp without time zone	The time this row was last changed
priority	smallint	The priority number used to influence the order in which updates are processed.
processing_started_at	timestamp without time zone	The time at which a content-model-update-service instance started processing this content update

content_model_service.datasource_group_members: Table which stores members of a datasource group.
Name	Type	Description
Foreign key/Primary key relation from group_id on this table to id on table, content_model_service.datasource_model
id	uuid	The id for uniquely identifying this group member.
group_id	uuid	Foreign key to the id of the group to which this member belongs.
value	text	The name of the group member.

content_model_service.datasource_model: Table which stores objects of the datasource model as json encoded blobs. These objects are fields, sets, groups, etc.
Name	Type	Description
id	uuid	The id which uniquely identifies a single piece of the model.
site_id	integer	The site id to which the datasource belongs.
datasource_id	integer	The datasource id.
created_at	timestamp without time zone	The time this row was created.
updated_at	timestamp without time zone	The time this row was last changed.
object_encoding	smallint	An id indicating how the object data is encoded, e.g. JSON encoding.
object_type	smallint	An id indicating the type which is encoded in the data, e.g. a CalculatedField, Group, Set.
object_data	bytea	The data containing properties specific to the object_type.
is_hidden	boolean	Whether this object in the model is marked as hidden in the document.

extensions.extensions_events: Missing description
Name	Type	Description
luid	uuid	Missing description
workbook_luid	uuid	Missing description
site_luid	uuid	Missing description
status	integer	Missing description
created_at	timestamp without time zone	Missing description
updated_at	timestamp without time zone	Missing description

extensions.extensions_instances: Missing description
Name	Type	Description
Foreign key/Primary key relation from extension_luid on this table to luid on table, extensions.extensions_metadata
luid	uuid	Missing description
extension_luid	uuid	Missing description
workbook_luid	uuid	Missing description
view_luid	uuid	Missing description
site_luid	uuid	Missing description
active	boolean	Missing description
count	integer	Missing description
created_at	timestamp without time zone	Missing description
updated_at	timestamp without time zone	Missing description

extensions.extensions_metadata: Missing description
Name	Type	Description
luid	uuid	Missing description
site_luid	uuid	Missing description
id	text	Missing description
type	text	Missing description
version	text	Missing description
manifest_version	text	Missing description
min_api_version	text	Missing description
default_locale	text	Missing description
name_locale_value	text	Missing description
name_locale_resourceid	text	Missing description
desc_locale_value	text	Missing description
dec_locale_resourceid	text	Missing description
author_name	text	Missing description
author_email	text	Missing description
author_org	text	Missing description
author_website	text	Missing description
url	text	Missing description
icon	text	Missing description
installed	boolean	Missing description
created_at	timestamp without time zone	Missing description
updated_at	timestamp without time zone	Missing description
permissions	text	Missing description
resources	text	Missing description

extensions.safe_list: Missing description
Name	Type	Description
site_luid	uuid	Missing description
luid	uuid	Missing description
url	text	Missing description
allow_full_data	boolean	Missing description
prompt_needed	boolean	Missing description
active	boolean	Missing description
created_at	timestamp without time zone	Missing description
updated_at	timestamp without time zone	Missing description

extensions.site_settings: Missing description
Name	Type	Description
site_luid	uuid	Missing description
luid	uuid	Missing description
extensions_enabled	boolean	Missing description
default_setting	boolean	Missing description
active	boolean	Missing description
updated_at	timestamp without time zone	Missing description

file_system_backup.items: Missing description
Name	Type	Description
Foreign key/Primary key relation from service_id on this table to id on table, file_system_backup.service_ids
Foreign key/Primary key relation from sos_id, file_id on this table to sos_id, file_id on table, file_system_backup.sos_files
sos_id	bigint	Missing description
file_id	integer	Missing description
service_id	integer	Missing description
timeout	timestamp without time zone	Missing description
uploaded	boolean	Missing description
failed	boolean	Missing description

file_system_backup.lot_info: Missing description
Name	Type	Description
id	uuid	Missing description
shard_size	integer	Missing description
shard_count	integer	Missing description
deleted	integer	Missing description

file_system_backup.lot_shard: Missing description
Name	Type	Description
Foreign key/Primary key relation from lot_id on this table to id on table, file_system_backup.lot_info
lot_id	uuid	Missing description
shard_id	integer	Missing description
remaining	integer	Missing description

file_system_backup.service_ids: Missing description
Name	Type	Description
id	integer	Missing description
name	character varying	Missing description
version	integer	Missing description

file_system_backup.sos_files: Missing description
Name	Type	Description
Foreign key/Primary key relation from lot_id on this table to id on table, file_system_backup.lot_info
Foreign key/Primary key relation from sos_id on this table to id on table, file_system_backup.sos_items
sos_id	bigint	Missing description
file_id	integer	Missing description
lot_id	uuid	Missing description
sub_id	text	Missing description
link_id	uuid	Missing description
size	bigint	Missing description

file_system_backup.sos_items: Missing description
Name	Type	Description
Foreign key/Primary key relation from sos_type on this table to id on table, file_system_backup.sos_types
id	bigint	Missing description
sos_type	integer	Missing description
sos_path	character varying	Missing description
sos_id	text	Missing description
start_time	timestamp without time zone	Missing description
end_time	timestamp without time zone	Missing description

file_system_backup.sos_types: Missing description
Name	Type	Description
id	integer	Missing description
name	character varying	Missing description

file_system_backup.status: Missing description
Name	Type	Description
Foreign key/Primary key relation from service_id on this table to id on table, file_system_backup.service_ids
Foreign key/Primary key relation from sos_type on this table to id on table, file_system_backup.sos_types
service_id	integer	Missing description
link_id	uuid	Missing description
lock_key	bigint	Missing description
retries	integer	Missing description
complete	boolean	Missing description
failed	boolean	Missing description
timeout	timestamp without time zone	Missing description
timeout_ms	integer	Missing description
custom_data	text	Missing description
start_time	timestamp without time zone	Missing description
sos_type	integer	Missing description
sos_item_id	bigint	Missing description
sos_path	character varying	Missing description
sos_id	text	Missing description
file_id	integer	Missing description
sub_id	text	Missing description
lot_id	uuid	Missing description

hyper_service.hyper_service_locks: The database entities currently locked in the Hyper Service
Name	Type	Description
Foreign key/Primary key relation from node_id on this table to id on table, hyper_service.hyper_service_nodes
node_id	bigint	The id of the node in hyper_service_nodes holding the lock
entity_type	integer	The entity type of the locked entity. Can be (0=Database, 1=Workspace)
entity_name	character varying	The name of the locked entity
access_mode	integer	The access mode of the locked entity. Can be (0=Shared, 1=Exclusive)

hyper_service.hyper_service_nodes: The Hyper nodes currently running in the Hyper Service
Name	Type	Description
id	bigint	The auto-generated identifier for a node in the Hyper Service
resource_pool	character varying	The resource_pool which a node is assigned to
address	character varying	The address of the host running the Hyper process
port	integer	The port on which Hyper is listening
load	double precision	The load reported by Hyper
last_heartbeat	timestamp without time zone	The last heartbeart from this node
status	integer	The status of this node. Can be (0=Startup,1=Running, 2=DrainConnections, 3=Shutdown)
version	character varying	The Hyper version running on the node
lease_timeout	integer	The timeout value until leases get invalidated in ms

messagebus.subscriptions: The table to hold the subscription request details to handle service recovery
Name	Type	Description
id	uuid	The unique identifier for this row that is automatically generated on insert
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
topic_name	text	The topic name for which subscriber will receive message
scaling_group_name	text	The scaling group name to which subscriber belongs
destination_service_name	text	The service name for which the response will be delivered
instance_count	integer	The instance count of the listeners for the subscription

nlp.datasource_usage_stats: Usage stats stored for recommendation
Name	Type	Description
Foreign key/Primary key relation from datasource_uri on this table to uri on table, nlp.datasources
Foreign key/Primary key relation from lens_id on this table to id on table, nlp.lenses
id	bigint	The unique identifier for this row that is automatically generated on insert
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
datasource_uri	text	URI of data source the usage stats belongs to
usage_stats	json	Aggregated data source usage stats
lens_id	integer	lens id

nlp.datasources: The table to hold semantic model datasource in nlp service
Name	Type	Description
id	bigint	The unique identifier for this row that is automatically generated on insert
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
uri	text	URI of a semantic model datasource
data	json	Serialized json struct of semantic model datasource
initialize_datasource_version_number	character varying	Version number of InitializeDatasource stage
enrich_datasource_version_number	character varying	Version number of EnrichDatasource stage
index_values_version_number	character varying	Version number of IndexValue stage
outdated	boolean	Indicates if semantic model datasource in database is outdated
analyze_datasource_version_number	character varying	Version number of AnalyzeDatasource stage

nlp.es_historical_configurations: Elastic Search Configuration History for Tableau Server
Name	Type	Description
id	integer	The unique identifier for this row that is automatically generated on insert
vmopts	text	Initial and Maximum heap size allocated to Elastic Search e.g. -Xmx4g -Xms4g
initial_heap_size	double precision	Initial Heap Size allocated to Elastic Search normalized to gb e.g. 4
max_heap_size	double precision	Maximum Heap Size allocated to Elastic Search normalized to gb e.g. 4
value_shard_count	integer	Number of data shards for the Elastic Search Concepts index for Ask Data e.g. 1
concept_shard_count	integer	Number of data shards for the Elastic Search Values index for Ask Data e.g. 1
system_status	text	Represents current system status, e.g. "Warning" (heap size < recommended), "info" (heap_size = recommended), "ok" (heap size > recommended)
created_at	timestamp with time zone	The timestamp for when this row entry was created

nlp.events: Store the last event processed by nlp service
Name	Type	Description
id	integer	The unique identifier for this row that is automatically generated on insert
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
last_enqueued_id	bigint	The ID of the event that is last processed by nlp service
processing_node	text	The ID of the nlp service node that is currently processing the events. If the field is empty, no nlp node is currently processing events.

nlp.expressions: Versioned expressions created by user interactions
Name	Type	Description
Foreign key/Primary key relation from datasource_uri on this table to uri on table, nlp.datasources
Foreign key/Primary key relation from lens_id on this table to id on table, nlp.lenses
id	bigint	The unique identifier for this row that is automatically generated on insert
exp_id	text	The unique identifier for an expression
datasource_uri	text	URI of datasource the expression belongs to
version	text	Version of the expression, e.g. 20171212
expression	text	Serialized and versioned expression
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
lens_id	integer	lens id

nlp.fields: The table to hold fields of semantic model datasource in nlp service
Name	Type	Description
id	bigint	The unique identifier for this row that is automatically generated on insert
datasource_uri	text	URI of the semantic model datasource that this field belongs to
graph_id	text	The unique identifier of the field in the context of a datasource
label	text	Display name of the field
description	text	Description of the field
parent_name	text	Name of the sheet or table that the field came from if a datasource is comprised of multiple sheets or tables
data_type	text	DataType of the field
field_type	text	FieldType of the field
value_concept	text	Semantic role of the field
field_role	text	FieldRole describes whether a field is a dimension or a measure
data_range_type	text	DataRangeType describes whether the values of the field are quantitative or discrete
bin_type	text	BinType describes type of bin that is used for group fields
default_aggregation	json	Aggregation type used to aggregate a measure when one is not explicitly defined
formula	text	Formula of a calculation field
invalid	boolean	Field marked as Invalid means a field cannot be used to produce valid queries against a data source
error	text	Error describes why the field is invalid, and should be nil for valid fields
hidden	boolean	Hidden fields may be used in command generation but should not appear in interpretations
popularity_score	integer	PopularityScore is the number of workbooks in which the field is used
parent_field_graph_id	text	ParentFieldGraphID is used for expressing field hierarchy
values_metadata	json	ValuesMetadata provides metadata about the values of a field
value_aliases	json	ValueAliases is a map of datasource values to user-defined value aliases
is_auto_generated	boolean	IsAutoGenerated boolean flag is used to identify if the field is auto-generated field
has_user_reference	boolean	HasUserReference indicates if a calculated field has formula that refers to a user
combined_field_list	ARRAY	CombinedFieldList contains the list of field names which form a combined field
user_aggregation	text	User defined aggregation type used to aggregate a measure
unsupported	boolean	Unsupported indicates if the field is not supported for NLP query
computation_in_progress	boolean	ComputationInProgress boolean flag indicates whether the field has completed all 3 stages of InitializeSemanticModel.
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
formula_interpretation	character varying	FormulaInterpretation is result interpreted by ANTLR parser for the formula.
friendly_name	text	FriendlyName is the alias for this field. DEPRECATED
friendly_formula	text	FriendlyFormula describes the formula with friendly-name
group_field_parent_model	text	GroupFieldParentModel identifies whether a group field is cluster or not
default_aggregation_is_explicit	boolean	If true, the default aggregation for the field is set by user, otherwise it is inferred
matched_field_concept_uri	text	URI of a field concept that is matched to the field through semantics service matching endpoint
object_id	text	Object id of the field obtained from TDS
authoring_name_components	ARRAY	The Name Components that can be used to author a viz.
lod_exp_type	text	Identifies the lod exp type
formula_has_parameter	boolean	Identifies if a formula has reference to a parameter or not.
is_constant_formula	boolean	Identifies if the formula for the field is constant formula or not.

nlp.jobs: Store the enqueued jobs to be processed by nlp service
Name	Type	Description
id	bigint	The unique identifier for this row that is automatically generated on insert
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
datasource_uri	text	URI of a semantic model datasource the job belongs to
type	text	Type of job
priority	integer	Priority of job
status	text	Status of job
stages	ARRAY	Stages of job
current_stage_index	integer	Current index of stages
should_reset	boolean	If current job needs to be reset
retry_count	integer	Number of retries that the job has attempted
next_run_after	timestamp with time zone	Job is eligible to run after this timestamp
processing_node	text	The ID of the nlp service node that is currently processing the job. If the field is empty, no nlp node is currently processing jobs.

nlp.links: User created links, each points to a specific LOD expression
Name	Type	Description
Foreign key/Primary key relation from datasource_uri on this table to uri on table, nlp.datasources
Foreign key/Primary key relation from exp_id on this table to exp_id on table, nlp.expressions
Foreign key/Primary key relation from lens_id on this table to id on table, nlp.lenses
id	bigint	The unique identifier for this row that is automatically generated on insert
short_id	text	A 6-digit alphanumeric token that serves as unique identifier for a link
datasource_uri	text	URI of datasource the link belongs to
exp_id	text	The unique identifier of the referenced lod expression
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
lens_id	integer	lens id

nlp.queries: Queries stored for datasource analytics
Name	Type	Description
Foreign key/Primary key relation from datasource_uri on this table to uri on table, nlp.datasources
Foreign key/Primary key relation from lens_id on this table to id on table, nlp.lenses
id	bigint	The unique identifier for this row that is automatically generated on insert
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
query	text	Raw query typed in by user
datasource_uri	text	URI of datasource the query belongs to
session_id	text	ID of session the query belongs to
guid	text	GUID is used to join nlp.queries with nlp.visualizations
interpretation_nlgs	ARRAY	List of generated interpretations(nlgs) to the raw query
selected_interpretation_index	integer	Index of the selected interpretation. -1 if query is unselected
user_id	integer	ID of user who creates the query
lens_id	integer	lens id

nlp.recommendation_stats: Recommendation stats extracted from nlp usage data
Name	Type	Description
Foreign key/Primary key relation from datasource_uri on this table to uri on table, nlp.datasources
Foreign key/Primary key relation from lens_id on this table to id on table, nlp.lenses
id	bigint	The unique identifier for this row that is automatically generated on insert
created_month	date	The start date of month for when this row entry was created
datasource_uri	text	URI of data source the record belongs to
stat_type	text	Type of recommendation stat
keys	ARRAY	Array of keys for aggregation
data	text	Serialized stat data
count	integer	Number of occurrences within the month
data_hash	text	MD5 hash of data column
lens_id	integer	lens id

nlp.visualizations: visualizations stored for datasource analytics
Name	Type	Description
Foreign key/Primary key relation from datasource_uri on this table to uri on table, nlp.datasources
Foreign key/Primary key relation from lens_id on this table to id on table, nlp.lenses
id	bigint	The unique identifier for this row that is automatically generated on insert
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
expression	text	Corresponding Arklang expression
datasource_uri	text	URI of datasource the visualization belongs to
session_id	text	ID of session the visualization belongs to
guid	text	GUID is used to join nlp.queries with nlp.visualizations
interpretation_nlg	text	Interpretation(nlg) that describes Visualization content
user_id	integer	ID of user who creates the visualization
referenced_field_graph_ids	ARRAY	List of field graph IDs referenced by visualization expression
viz_type	text	ShowMe viz type
lens_id	integer	lens id

public.api_tokens: Records for the api tokens
Name	Type	Description
Foreign key/Primary key relation from user_id on this table to id on table, public.users
id	bigint	Primary key for the record.
token_id	character varying	A unique identifier for the record.
client_name	character varying	The client name for this api token.
hashed_secret	text	The hashed_secret for this api token.
user_id	integer	A foreign key refrence to the user.
created_timestamp	timestamp with time zone	The time this token was created.
revoked_timestamp	timestamp with time zone	The time this token was revoked.
scope	character varying	String containing the scope name

public.asset_key_marker: Records are used to flag a particular record in the asset_key_meta_data table.
Name	Type	Description
id	integer	Artificial auto-incrementing integer that serves as the primary key
asset_key_id	integer	The id of the asset_key_meta_data record being marked.
marker_name	character varying	The type of marker.
created_at	timestamp without time zone	When this record was created.
updated_at	timestamp without time zone	When this records was last updated.

public.asset_key_meta_data: Each record holds meta data for an asset encryption key.
Name	Type	Description
id	integer	Artificial auto-incrementing integer that serves as the primary key.
algorithm_name	character varying	The algorithm used in conjunction with this key.
salt	character varying	The salt used in the test string.
test_string	character varying	An encrypted version of a well-known test string
created_at	timestamp without time zone	When this record was created.
updated_at	timestamp without time zone	When this record was last updated.

public.asset_list_items: Contains the individual list entries that correspond to the lists defined in the asset_lists table.
Name	Type	Description
Foreign key/Primary key relation from asset_list_id on this table to id on table, public.asset_lists
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record
asset_list_id	integer	A foreign key reference to the asset list to which this item belongs.
useable_type	character varying	One of "View" or "Workbook". The type of object that this item corresponds to.
useable_id	integer	Kind of an informal "polymorphic" foreign key reference to either the corresponding view or workbook as determined by the useable_type field. Dead links might exist, where the corresponding item has been deleted.
position	integer	Controls the order in which the items are displayed.
added_timestamp	timestamp without time zone	Timestamp of when the row was added to the table. For rows that already existed, use the timestamp of the migration.
useable_luid	uuid	The luid of the useable item. Not used for favorites, but used for other list types.
site_id	integer	The ID of the site the asset list item belong to.
site_luid	uuid	site luid that asset list item belongs to
suspected_as_deleted	boolean	Boolean to indicate if the content is suspected as deleted because it is missing from the content cache
timestamp_of_first_cache_absence	timestamp without time zone	Timestamp of first occurence of content not returned from content cache. Null = No absences from cache

public.asset_lists: This table supports the creation of various types of per-user lists. The actual list contents are listed in the asset_list_items table.
Name	Type	Description
Foreign key/Primary key relation from owner_id on this table to id on table, public.users
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record
name	character varying	This is what the type of list is called.
owner_id	integer	Foreign key to the user for whom this list was defined.
site_id	integer	Foreign key to the site to which the user belongs.
description	character varying	Description of an asset list.
visibility	character varying	Visibility of asset list, valid values are public or private.
list_type	character varying	Type of asset list, valid values are collection or favorites.
created_timestamp	timestamp without time zone	Time that asset list was created for favorites lists prior to 20.3 it will be time of this update
updated_at	timestamp without time zone	When this asset list was last updated.
luid	uuid	An identifier that is unique in combination with the site_id.
sync_token	character varying	the sync token for content exploration to make sure it has up to date collections
site_luid	uuid	site luid that asset list belongs to

public.async_jobs: Records information about background tasks that are run in response to some user action (as opposed to being run on some schedule).
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record
job_type	character varying	The type of job being run
success	boolean	Whether or not the job succeeded. Will be true for success, and false for failure.
worker	character varying	Identifies the machine on which the job is run
user_id	integer	Links to the user who triggered the running of the job.
site_id	integer	Links to the relevant site.
notes	text	Can be used to store additional information about the running of the job.
progress	integer	Can be used to indicate percent complete for the job, but in most cases simply gets set to 100 when the job is completed
created_at	timestamp without time zone	When this record was created.
updated_at	timestamp without time zone	When this record was last updated.
completed_at	timestamp without time zone	When the job finished execution. When set, this should generally agree with the updated_at field.
detailed_status	text	Stores information about current progress details of the async job.
luid	uuid	An identifier that is unique in combination with the site_id.

public.authorizable_permission_sets: Many-to-many mapping table between authorizables and permission sets. An authorizable may have a permission set for every permission_set_class.
Name	Type	Description
Foreign key/Primary key relation from permission_set_id on this table to id on table, public.permission_sets
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
authorizable_id	integer	Refers to the id of the authorizable (e.g. workbook) depending on the value of authorizable_type.
authorizable_type	character varying	Refers to the type of the authorizable (e.g. workbook).
permission_set_id	integer	The permission set this item uses.
site_id	integer	The site id.

public.background_jobs: Records information about background tasks that are run by a Backgrounder process. These tasks are almost always run according to some schedule, but in a few cases they may also be triggered by some user actions.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
job_type	character varying	The type of job being run. This looks a bit odd because it comes from a serialized symbol.
progress	integer	Can be used to indicate percent complete for the job, but in most cases simply gets set to 100 when the job is completed.
args	text	Used as a means of passing parameters about the background job. This information is stored in a special serialized format, and thus is not easily readable.
notes	text	Can be used to store additional information about the running of the job.
updated_at	timestamp without time zone	When this record was last updated
created_at	timestamp without time zone	When this record was created.
completed_at	timestamp without time zone	When the job finished execution. When set, this should generally agree with the updated_at field.
started_at	timestamp without time zone	When the execution of the job was started. This is not generally the same as created_at, because it may take some time before a backgrounder "notices" the newly created record and begins to process it.
job_name	character varying	A nice readable name for this type of job.
finish_code	integer	Completion status for the job. Will be 0 for success, 1 for failure, and 2 for cancelled.
priority	integer	Controls which background_jobs records are processed first. The highest priority is 0, and the lowest is 100. Integer values in between are also valid.
title	character varying	Can be used to provide some additional information about the job.
created_on_worker	character varying	Identifies the machine that created this background_jobs record.
processed_on_worker	character varying	Identifies the machine on which the job is run.
link	text	Used, for certain types of jobs, to record a relevant URL.
lock_version	integer	Used to implement "optimistic locking." Don't set this or mess with it, it's all handled automatically.
backgrounder_id	character varying	Indicates which backgrounder process ran the job.
serial_collection_id	integer	It is possible to designate a job as part of a "serial collection," by setting its serial_collection_id. Two jobs with the same serial_collection_id cannot be processed simultaneously. Note that serial_collection_id is actually a foreign key to the serial_collections table. This is not a capability that sees much use.
site_id	integer	Links to a site, if one is relevant, otherwise it is left NULL.
subtitle	character varying	Can be used to provide some additional information about the job.
language	character varying	The language for the job is listed here.
locale	character varying	The locale for the job is listed here.
correlation_id	integer	The ID to correlate occurrences of the same job, which is the foreign key reference to the record in the respective definition table for subscriptions (subscriptions table) and extract-refresh jobs (tasks table).
attempts_remaining	integer	Used track amount of execution attempts remaining for the job. Usually NULL for job that are attempted only once. Number greater than 0 for jobs that will be retried.
luid	uuid	An identifier that is unique in combination with the site_id.
job_rank	bigint	Stores the calculated ranking of the job, determines the order it will be run on
queue_id	integer	Identifier representing which virtual queue this job belongs to
overflow	boolean	Represents if the job is in overflow queue or not
promoted_at	timestamp without time zone	When the job is promoted to primary queue from overflow queue. Null for non overflow jobs
task_id	integer	Id of the task associated with the job. Explicitly not a foreign key to allow for tasks to be deleted without deleting related job records.
run_now	boolean	Indicates if the job was triggered by run now
creator_id	integer	Indicates what user id is the creator of the job

public.background_jobs_cancel: BG jobs for which cancellation has been requested
Name	Type	Description
Foreign key/Primary key relation from background_job_id on this table to id on table, public.background_jobs
id	integer	Primary key for the cancellation request
background_job_id	integer	The id of the job to be cancelled
created_at	timestamp without time zone	When the cancellation was requested
updated_at	timestamp without time zone	When the cancellation was last updated
user_id	integer	The user who requested cancellation
users_to_notify	text	CSV encoded list of IDs representing users to notify about job cancellation
cancellation_reason	character varying	User provided reason for the cancellation of the job

public.big_texts: This table serves as a convenient place to store a big text object, if necessary. It's kind of a utility table. This table is really just used for internal purposes.
Name	Type	Description
id	integer	Primary key for this record.
txt	text	Holds whatever text object is desired. There is no specific designated use for this field. Any code can store a text object here for whatever purpose it wishes.
updated_at	timestamp without time zone	The time at which this record was last changed.

public.capabilities: Holds a relatively short list of capabilities. A user can be allowed certain capabilities either through being some sort of admin, or through owning something like a workbook or a project, or via entries in the next_gen_permissions table. Capabilities are things like read, write, export_data, publish, web_authoring, etc.
Name	Type	Description
id	integer	Primary key for the record.
name	character varying	This (or the id) is how the capability is referred to by code.
display_name	character varying	This is the name that may be displayed to a user.
display_order	integer	Ascending order of this value is the order in which capabilities are listed, when displayed.

public.capability_roles: This table serves primarily to associate roles with capabilities. A given role can have many capabilities, and a given capability can be associated with several roles.
Name	Type	Description
Foreign key/Primary key relation from capability_id on this table to id on table, public.capabilities
Foreign key/Primary key relation from role_id on this table to id on table, public.roles
id	integer	Primary key for this record.
capability_id	integer	Foreign key reference to the capabilities table.
role_id	integer	Foreign key reference to the roles table.

public.collection_metrics_aggregations: Each record represents a partial aggregation of analytics for a given collection in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.
Name	Type	Description
Foreign key/Primary key relation from collection_id on this table to id on table, public.asset_lists
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
collection_id	integer	A foreign key reference to the collection (in asset_lists table).
day_index	integer	Records what day of the month the analytics are aggregated over. When 0, the aggregation is for the month and year as designated by month_index and year_index.
month_index	integer	Records what month of the year the analytics are aggregated over. When 0, the aggregation is for the year as designated by year_index.
year_index	integer	Records what year the analytics are aggregated over
view_count	integer	Records the number of times a collection was viewed in the given time interval.
site_id	integer	The ID of the site the collection metrics aggregation belong to.

public.column_assets: Each record represents a column asset that exists on Tableau Server.
Name	Type	Description
Foreign key/Primary key relation from table_id on this table to id on table, public.table_assets
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the column asset record.
name	character varying	The name of the column asset.
luid	uuid	A unique, immutable identifier for the column asset.
site_id	integer	The id of the site that this column asset is associated with.
created_at	timestamp without time zone	The time the record was created.
updated_at	timestamp without time zone	The time the record was updated.
description	text	The description of the column asset.
table_id	integer	The table this column belongs to.
remote_type	character varying	The data type of the column.
is_tombstoned	boolean	Tombstoned columns are "soft deleted" because they have been grouped with other columns. They can be ungrouped to remove this

public.command_job_mappings: Each record represents a mapping between an extract command and a background job.
Name	Type	Description
Foreign key/Primary key relation from background_job_id on this table to id on table, public.background_jobs
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	Primary key for the record.
extract_command_luid	uuid	LUID of an extract command created by Extract Service.
background_job_id	integer	A foreign key reference to the background job that runs the extract command.
site_id	integer	A foreign key reference to the site where the extract command exists.
created_at	timestamp without time zone	Command-job mapping creation timestamp.
updated_at	timestamp without time zone	Command-job mapping modified timestamp.

public.comment_attachments: Attachments for comments.
Name	Type	Description
Foreign key/Primary key relation from comment_id on this table to id on table, public.comments
id	integer	Primary key for the record.
comment_id	integer	A foreign key reference to the comment that the attachments is attached to.
attachment_type	character varying	The type of the attachment.
attachment_id	integer	The id of the attachment.
site_id	integer	The ID of the site the comment attachments belong to.

public.comments: Comments users made on views.
Name	Type	Description
Foreign key/Primary key relation from user_id on this table to id on table, public.users
id	integer	Primary key for this record.
title	text	Not used.
comment	text	Comment text.
created_at	timestamp without time zone	Date when comment was created.
commentable_id	integer	Corresponding view id.
commentable_type	character varying	View.
user_id	integer	Id of the user who made the comment.
drawing	text	Not used.
updated_at	timestamp without time zone	Date when comment was last updated.
site_id	integer	The ID of the site the comments belong to.

public.content_sync_token: Each record stores the checksum associated to a piece of content
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Id associated to that piece of content.
content_type	character varying	The type of the content.
site_id	integer	The associated site.
sync_token	character varying	A unique identifier for this version of the associated content.

public.content_usage: Information about operations performed on Server content.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Auto-generated id from postgres. Primary key for table.
content_type	smallint	Integer relating to the type of content. 1 - workbooks, 2 - datasources, 3 - flows.
content_id	integer	Maps to the id of the workbook/datasource/flow in their respective tables.
operation_type	text	The operation performed on the content. This can be a server operation like extract refresh or a type of REST API call.
last_recorded_at	timestamp without time zone	Timestamp of when the operation was performed. It is updated no more than once a day, so the time part may be older than the actual latest usage.
site_id	integer	ID of the site to which this content belongs.

public.custom_views_metrics_aggregations: Each record represents a partial aggregation of analytics for a given custom view in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.
Name	Type	Description
Foreign key/Primary key relation from custom_view_id on this table to id on table, public.customized_views
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
site_id	integer	Site where custom view exists.
custom_view_id	integer	A foreign key reference to the custom view.
day_index	integer	Records what day of the month the analytics are aggregated over. When 0, the aggregation is for the month and year as designated by month_index and year_index.
month_index	integer	Records what month of the year the analytics are aggregated over. When 0, the aggregation is for the year as designated by year_index.
year_index	integer	Records what year the analytics are aggregated over
view_count	integer	Records the number of times a custom view was viewed in a given day.

public.customized_views: When a user creates a customized view, the data that supports that goes in this table.
Name	Type	Description
Foreign key/Primary key relation from creator_id on this table to id on table, public.users
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from start_view_id on this table to id on table, public.views
Foreign key/Primary key relation from view_id on this table to id on table, public.views
id	integer	Primary key for the record.
name	character varying	The name of the customized view.
description	text	A description of the customized view. Seems not to be used commonly.
view_id	integer	A foreign key reference to the views table. Refers specifically to the view that this customized view is based on.
created_at	timestamp without time zone	When this record was created.
updated_at	timestamp without time zone	When this record was last updated.
creator_id	integer	Foreign key reference to the user who created this customized view.
public	boolean	Indicates if the user elected to share his customized view.
size	integer	The number of bytes it took to describe the changes from the base view to the customized view.
site_id	integer	A foreign key to the site that this customized view is associated with (the site of the user who created it).
repository_thumbnail_data_id	bigint	A reference to an entry in the repository_data table, which, in turn references the PostgreSQL large object that contains the thumbnail image for this customized view.
url_id	character varying	A URL compatible string derived from the name of the customized view. This must be unique when taken together with the customized view creator and the view.
start_view_id	integer	A foreign key reference to the view from which this customized view was derived.
luid	uuid	A "locally unique" id used to identify this record for certain uses. It is generated automatically, and is nothing that a customer needs to worry about.
data_id	character varying	Unique ID used to identify the view data.
thumbnail_id	character varying	Unique ID used to identify the thumbnail.
hidden	boolean	Indicates if the custom view is hidden.
created_by_feature	integer	Feature which created customized view.
accessed_at	timestamp without time zone	Last accessed datetime for customized view. NULL: never accessed
modified_at	timestamp without time zone	Indicates the last time at which this customized view was updated.

public.data_alerts: Each record represents an alert. An alert is a predefined data conditions on a view, and if conditions are met all alert recipients get notified.
Name	Type	Description
Foreign key/Primary key relation from creator_id on this table to id on table, public.users
Foreign key/Primary key relation from customized_view_id on this table to id on table, public.customized_views
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from view_id on this table to id on table, public.views
Foreign key/Primary key relation from workbook_id on this table to id on table, public.workbooks
id	integer	Primary key for the record.
title	character varying	A string that describes the alert.
creator_id	integer	User id for user who created the alert. FK reference to users.id.
site_id	integer	Site ID for alert. FK reference to sites.id.
workbook_id	integer	A foreign key reference to the workbook.id.
view_id	integer	A foreign key reference to the view.id.
customized_view_id	integer	A foreign key reference to the customized.view.id.
luid	uuid	UUID for alert used in REST APIs.
data_specification	character varying	Platform-parsable blob that describes which data to track.
last_checked	timestamp without time zone	The last time at which the the alert was checked.
notification_interval_in_minutes	integer	The interval in minutes in which to send no more than one alert.
created_at	timestamp without time zone	The time when this row was created.
updated_at	timestamp without time zone	The time when this row was last updated.
last_edited	timestamp without time zone	The time a user last edited this data alert.
suspend_state	integer	0: alert is not suspended, 1: alert was auto-suspended, 2: alert was manually suspended.
failure_count	integer	The number of consecutive times evaluating this alert failed.
device_type	integer	0: device type is default, 1: device type is desktop, 2: device type is tablet, 3: device type is phone.
public	boolean	Determines whether the alert is shared with other users

public.data_alerts_recipients: Each record represents the intent of recipient to be notified if an event is triggered.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from data_alert_id on this table to id on table, public.data_alerts
id	integer	Primary key for the record.
recipient_id	integer	It references a user or group id.
data_alert_id	integer	A reference to data alert id.
recipient_type	character varying	A string that describes the recipient type, currently single user or group.
last_sent	timestamp without time zone	The last time at which the the alert was sent to the user.
last_state	boolean	Whether the condition evaluated to true or false for the user the last time it was checked.
created_at	timestamp without time zone	The time when this row was created.
updated_at	timestamp without time zone	The time when this row was last updated.
site_id	integer	The ID of the site the data alert recipient belongs to.

public.data_connections: Describes various data sources that are included in either workbooks or datasources.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from datasource_id on this table to id on table, public.datasources
id	integer	Primary key for the record.
server	text	DNS server name to connect to.
dbclass	character varying	Type of data connection (ie mysql, postgres, sqlproxy etc).
port	integer	TCP port number of the connection (eg. 5432 for postgres).
username	text	Username to use when connecting.
password	boolean	True means password is embedded in owner (see owner_type and owner_id fields).
name	character varying	Unique identifier for this data_connection.
dbname	character varying	The database name to which the particular connection is linked.
tablename	character varying	The name of the table in the database that this connection connects to.
owner_type	character varying	One of "Datasource" or "Workbook". It is the type of object making the data connection.
owner_id	integer	The ID of the workbook or datasource that is creating the data connection.
created_at	timestamp without time zone	When this record was created.
updated_at	timestamp without time zone	When this record was last updated.
caption	character varying	Friendly name of this connection as seen in the Desktop data pane.
site_id	integer	A foreign key reference to the site in which this data connection is contained.
keychain	text	Encode string in yaml format. An attribute bag that will match the embedded keychain connection this connection is associated with.
luid	uuid	The locally unique ID, which is intended for exposing externally by the server API. This is automatically generated.
has_extract	boolean	Indicates if the data connection is an extract.
datasource_id	integer	Reference to the Datasource that owns this data connection.
db_subclass	character varying	Subclass of the dbclass, for example, dbclass is webdata-direct, db_subclass is intuit-quickbook
authentication	character varying	When present, can be used to identify what authentication method is being used for the data connection
using_remote_query_agent	boolean	Whether the data connection needs to be proxied via a remote query agent (AKA Bridge Client)
query_tagging_enabled	boolean	Whether queries for this data connection should be tagged with information about their origin in Tableau.

public.data_quality_indicators: Table to store data quality indicators.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from user_id on this table to id on table, public.users
id	bigint	Auto increment primary key.
luid	uuid	Autogenerated luid for data quality indicator.
site_id	integer	Id of the site where data quality indicator belongs.
user_id	integer	Id of user who created/updated data quality indicator.
user_display_name	character varying	Display name of user who created/updated data quality indicator.
content_id	integer	Id of content for which data quality indicator stored.
content_type	character varying	Type of content for which data quality indicator stored.
message	text	Message of data quality indicator.
data_quality_type	character varying	Type of data quality indicator.
is_active	boolean	Represents state of data quality indicator as true or false.
created_at	timestamp without time zone	Timestamp when record is created.
updated_at	timestamp without time zone	Timestamp when record is updated.
is_severe	boolean	indicates the if a data_quality_indicator is severe or not. True means severe otherwise not.
metadata	text	Metadata related to the data quality indicator

public.data_quality_triggers: Table to store data quality triggers.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from user_id on this table to id on table, public.users
id	bigint	Auto increment primary key.
luid	uuid	Autogenerated luid for data quality trigger.
site_id	integer	Id of the site where data quality trigger belongs.
user_id	integer	Id of user who created/updated data quality trigger.
user_display_name	character varying	Display name of user who created/updated data quality trigger.
content_id	integer	Id of content to which data quality trigger applies.
content_type	character varying	Type of content to which data quality trigger applies.
message	text	Message of data quality trigger.
trigger_type	character varying	Type of data quality trigger.
is_active	boolean	Indicates whether or not data quality trigger is active.
is_severe	boolean	Indicates whether or not data quality trigger is severe.
created_at	timestamp without time zone	Timestamp when record is created.
updated_at	timestamp without time zone	Timestamp when record is updated.

public.data_role_contents_association: Represents the association between the data_role and other content types.
Name	Type	Description
Foreign key/Primary key relation from data_role_id on this table to id on table, public.data_roles
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	Primary key for the record.
data_role_id	integer	The data_role_id for the data_role entity.
content_type	text	Identifies the content-type which is associated with the data_role.
content_id	integer	content_id is the unique identifier for the corresponding content-type.
site_id	integer	The id of the site that the content belongs to

public.data_role_datasource_field_association: Represents the association between the data_role and the field on a datasource
Name	Type	Description
Foreign key/Primary key relation from published_datasource_id on this table to id on table, public.datasources
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from associator_user_id on this table to id on table, public.users
id	bigint	Primary key for the record.
site_id	integer	The id of the site on which the datasource is published
published_datasource_id	integer	The id of the published datasource on the site
field_graph_id	text	The graph id of the field in the datasource
field_concept_key	text	field_concept_key is the unique identifier for the dataRole
associator_user_id	integer	associator_user_id is the unique identifier for the user who created the association
link_status	integer	link_status tells the current state of the association between the field and the dataRole

public.data_roles: Each record represents an entry of Semantics Service data role metadata.
Name	Type	Description
Foreign key/Primary key relation from owner_id on this table to id on table, public.users
Foreign key/Primary key relation from project_id on this table to id on table, public.projects
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the data role metadata record.
name	text	The name of the data role.
owner_id	integer	The user id of the owner/publisher of the data role.
project_id	integer	The id of the project that this data role lives under.
site_id	integer	The id of the site that this data role is associated with.
created_at	timestamp without time zone	The timestamp when the record was created.
updated_at	timestamp without time zone	The timestamp when the record was last updated.
description	text	The description of the data role.
luid	uuid	An identifier that is unique in combination with the site_id.

public.database_asset_events: Used to store database_asset events stream.
Name	Type	Description
id	bigint	Primary key for this record.
database_asset_id	integer	database_asset ID.
site_id	integer	Site ID.
event_created_at	timestamp without time zone	Timestamp indicating when the record was inserted.
event_type	smallint	Event type to differentiate between insert, update, delete.

public.database_assets: Each record represents a database that exists on Tableau Server.
Name	Type	Description
Foreign key/Primary key relation from certifier_user_id on this table to id on table, public.users
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from grouped_parent_id on this table to id on table, public.database_assets
id	integer	Primary key for the database record.
connection_type	character varying	Connection type for the database record.
name	character varying	The name of the database.
port	integer	The name of the database port.
luid	uuid	A unique, immutable identifier for the database.
site_id	integer	The id of the site that this database is associated with.
created_at	timestamp without time zone	The time the record was created.
updated_at	timestamp without time zone	The time the record was updated.
description	text	The description of the database.
controlled_permissions_enabled	boolean	Whether controlled permissions are enabled for the database
contact_id	integer	The contact for this database.
contact_type	character varying	The contact type (user or group) for this database.
type	character varying	Type (Database, File, WebDataConnector) for the database record.
file_path	text	Path to file.
is_embedded	boolean	Whether file is embedded (e.g., packaged in a twbx/tflx) or not.
connector_url	text	The connector url for a web data connector.
host_name	text	The database server host name.
provider	character varying	Provider for a Cloud File.
file_extension	character varying	File Extension for a Cloud File.
mime_type	character varying	mime type for a Cloud File.
file_id	character varying	File Id for a Cloud File.
request_url	text	Request URL for a Cloud File.
is_certified	boolean	Whether this database is certified.
certification_note	text	Certification note for this database.
certifier_user_id	integer	Certifier user_id for this database.
certifier_details	text	Certifier details for this database.
source_type	character varying	Type of the database source, if this database is embedded.
source_id	integer	ID of the database source, if this database is embedded.
internal_identifier	text	A unique identifier for an embedded database internal to its parent content item.
extended_connection_type	character varying	optional - type of connection - some dbs require it - for example SingleNode or MultiNode for SAP HANA
service	character varying	optional - some dbs optionally have it - for example Snowflake has option roles which we store in this field
duplicate_id	integer	If not null, id of database that is a duplicate of this one.
is_tombstoned	boolean	Tombstoned databases are "soft deleted" because they have been grouped with other databases. They can be ungrouped to remove this soft deletion.
grouped_parent_id	integer	ID in database_assets table of database this tombstoned database was grouped into.
is_grouped_parent	boolean	True if this database is the result of grouping other databases.

public.datasource_events: Used to store datasource events stream.
Name	Type	Description
id	bigint	Primary key for this record.
datasource_id	integer	Datasource ID.
site_id	integer	Site ID.
event_time	timestamp without time zone	Timestamp indicating when the record was inserted.
event_type	integer	Event type to differentiate between insert, update, delete.

public.datasource_fields: Describes datasource fields.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from datasource_id on this table to id on table, public.datasources
id	integer	Primary key for the datasource field record.
name	text	The name of the datasource field.
description	text	The description of the datasource field.
datasource_id	integer	The id of the datasource that this field is associated with.
site_id	integer	The site id.
created_at	timestamp without time zone	The time the record was created.
updated_at	timestamp without time zone	The time the record was updated.

public.datasource_metrics_aggregations: Each record represents a partial aggregation of analytics for a given datasource in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.
Name	Type	Description
Foreign key/Primary key relation from datasource_id on this table to id on table, public.datasources
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
datasource_id	integer	A foreign key reference to the datasource.
day_index	integer	Records what day of the month the analytics are aggregated over. When 0, the aggregation is for the month and year as designated by month_index and year_index.
month_index	integer	Records what month of the year the analytics are aggregated over. When 0, the aggregation is for the year as designated by year_index.
year_index	integer	Records what year the analytics are aggregated over
view_count	integer	Records the number of times a datasource was viewed in the given time interval.
site_id	integer	The ID of the site the datasource metrics aggregation belong to.

public.datasource_refresh_properties: Extension of datasources table for refresh properties (Online). This is 1-0/1 relationship to datasources table. It is a separate table since it contains Online-specific properties.
Name	Type	Description
Foreign key/Primary key relation from id on this table to id on table, public.datasources
Foreign key/Primary key relation from remote_agent_id on this table to id on table, public.remote_agents
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Datasource ID from datasources table. it is 1-0/1 relationship to datasources table.
refresh_mode	character varying	Specifies the mode of datasource refresh
remote_agent_id	integer	The associated remote agent ID responsible for data source refresh.
schedules	json	Array of DatasourceRefreshSchedule objects in JSON format.
last_refresh_error_client_data	character varying	Information about the last refresh error for the purpose of reconstructing the client view of the errors.
remote_agent_reservation_id	character varying	Unique string, e.g. GUID, that represents a reservation that a remote agent has yet to claim.
expected_refresh_time	timestamp with time zone	Time at which the schedule is expected to refresh in UTC
expected_refresh_duration	integer	Time duration in seconds after which a scheduled extract refresh is expected to complete
next_check_time	timestamp with time zone	The next check time in UTC when the server checks if the linked bridge client is actively running or other interesting scenarios that might arise in the future
site_id	integer	The id of the site that the datasource belongs to

public.datasource_versions: Datasource versions saved on server.
Name	Type	Description
Foreign key/Primary key relation from datasource_id on this table to id on table, public.datasources
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	The id of a version. Primary key.
site_id	integer	Reference to entury in sites table. Indicates the site to which this datasource version belongs to.
datasource_id	integer	A foreign key to the datasources table. Reference to Datasource.
publisher_id	integer	Reference to user in site users table. User who published this version. Can point to deleted user.
version_number	integer	The version number.
published_at	timestamp without time zone	The time when this version was initially published. Copied from datasource record last_updated field at the time of being overwritten.
size	bigint	The size, in bytes, of this version of datasource.
content_key	character varying	Key of the datasource as string
sos_type	character varying	The SOS data type under which this version document is stored, or null if it is not stored in SOS.

public.datasources: Records all Published datasources on server.
Name	Type	Description
Foreign key/Primary key relation from modified_by_user_id on this table to id on table, public.users
Foreign key/Primary key relation from owner_id on this table to id on table, public.users
Foreign key/Primary key relation from project_id on this table to id on table, public.projects
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
name	character varying	The name of the published datasource.
repository_url	text	Uniquely identifies a datasource. More or less consists of a slightly modified name, but not totally obviously, especially in the presence of non-ASCII characters. Used in URLs meant to access this datasource.
owner_id	integer	The user ID of the owner/uploader of the datasource.
created_at	timestamp without time zone	When this record was created.
updated_at	timestamp without time zone	When this record was last updated.
project_id	integer	The associated project ID where the datasource was published.
size	bigint	The size in bytes of the datasource.
lock_version	integer	Used to implement "optimistic locking". Don't set this or mess with it, it's all handled automatically.
state	character varying	One of "active" or NULL.
db_class	text	The origin of the data. It's often a database, but the concept is a bit more general than that. For example, "oracle" and "db2" are possibilities, but so are "excel" and "dataengine" (and many more).
db_name	text	The name of the database associated with the published datasource. But because data sources are more general than databases, in some instances, this might actually be a file path, or blank.
table_name	text	The name of the table associated with the published datasource. But, because data sources are more general than databases, this might, for example, actually refer to an Excel worksheet, or be blank.
site_id	integer	A foreign key reference to the site with which this datasource is associated.
revision	character varying	Increments each time a new version of the datasource is published.
embedded	text	An encrypted keychain holding any credentials stored with the datasource.
incrementable_extracts	boolean	True or false as to whether incrementable extracts are allowed for the published datasource.
refreshable_extracts	boolean	True or false as to whether refreshable extracts are avaliable for the published datasource.
data_engine_extracts	boolean	True means the data was supplied in the form of a Tableau data extract, though the original source of the data may be known to reside elsewhere.
extracts_refreshed_at	timestamp without time zone	Records the time of the last full extract refresh.
first_published_at	timestamp without time zone	When the first publication of this datasource occurred.
connectable	boolean	If this datasource was published using a release of the software where connecting to datasources through the Data Server was supported (post 7.0).
is_hierarchical	boolean	Set to true if the source is a hierarchical (cube) database.
extracts_incremented_at	timestamp without time zone	Records the time of the last incremental extract refresh.
luid	uuid	Unique identifier.
document_version	character varying	The internal version of the .tds file associated with this record.
description	text	A textual description of the datasource.
content_version	integer	$Version number of the datasource. updated on each publish
parent_workbook_id	integer	Is set to null for published datasources or else references the workbook id that contains this datasource.
hidden_name	character varying	Auto-generated name for the datasource extracted from the twb/tds file.
last_published_at	timestamp without time zone	Time that the user last published this datasource to server. For datasources that were last published before this column existed, the value will be null.
data_id	character varying	Unique ID used to identify the datasource data.
reduced_data_id	character varying	Unique ID used to identify the reduced datasource data.
remote_query_agent_id	integer	If present, the agent to remote queries to.
using_remote_query_agent	boolean	Whether the queries to this data source may be proxied via a remote agent.
is_certified	boolean	Whether or not this datasource is certified.
certification_note	text	Explanation for the certification status of this datasource.
certifier_user_id	integer	The user id of the user that certified this datasource, or null if it is not certified.
certifier_details	text	A snapshot of user information that we want to retain even when the user is deleted.
extract_encryption_state	smallint	If not null, encryption state of the extracts. null or 0 - unencrypted, 1 - encrypted, 2 - pending encryption, 3 - pending decryption, 5 - pending rekey
nlp_setting	text	Setting to enable/disable nlp feature on this datasource
extract_creation_pending	smallint	null or 0 - there is not extract creation in progress, 1 - there is an extract creation in progress
parent_type	text	Indicates the parent_type of the datasource (datarole, workbook, null)
nlp_setting_new	text	Setting to specify whether a datasource should have Ask Data enabled, disabled, or set to the site default. The site default value was added in 2019.4. This column is kept in sync with the old nlp_setting column until we can deprecate nlp_setting in 2020.3
modified_by_user_id	integer	The user who last modified and published this datasource to server or saved the datasource during web edit. For datasource that were last published before this column existed, the value will be same as owner_id.
separated_data_id	character varying	Unique ID used to identify the datasource data without the tds file.
tds_luid	text	Unique ID to reference the tds file in the TDS Service.
ask_data_setting	character varying	Setting to enable/disable Ask Data feature
ask_data_indexing	character varying	Data source indexing setting for Ask Data
ask_data_curator_feedback	character varying	Setting to enable/disable Ask Data feedback to curator
separated_reduced_data_id	character varying	Unused column, should be removed next deployment
extract_storage_format	smallint	How extracts for this data source are stored. NULL means no extracts or old-style extract folder. 0 means no extracts. 1 means old-style extract folder. 2 means new-style individual Hyper and TDE files in file store.

public.desktop_reporting: Each record represents a Tableau Desktop usage report.
Name	Type	Description
id	integer	The id of the report. Primary key.
app_version	character varying	Tableau product version.
email	character varying	Registered email address.
expiration_date	date	Expiration date of active key. NULL means permanent.
first_name	character varying	First Name.
last_name	character varying	Last Name.
computer_user_id	character varying	Computer user or login id.
host_name	character varying	Computer host name.
department	character varying	Department.
company	character varying	Company or organization.
os_version	character varying	OS version.
os_architecture	character varying	OS architecture.
registration_date	timestamp without time zone	Date active key was registered.
last_report_date	timestamp without time zone	Last report for this Desktop.
maintenance_expiration	date	Maintenance expiration of in use product key.
product_name	character varying	Product name.
edition	character varying	Tableau Desktop Edition. E.g Professional or Standard.
type	character varying	Type of key. Trial or Perpetual.
product_keys	character varying	Semicolon delimited product keys. Characters beyond 9 replaced with X.
serial_number	character varying	Computer serial number.
mac_address	character varying	Network card MAC address.
domain	character varying	Computer Active Directory domain.
unique_machine_number	character varying	Unique Machine Number. A string uniquely identifying a computer.
action	character varying	Action: Activate, Use or Return.
action_key	character varying	Key being used activated or returned.

public.domains: Records represent either an Active Directory domain or an authenticate system.
Name	Type	Description
id	integer	Primary key for the record
name	character varying	The name is either "local" or the name of some Active Directory group.
short_name	character varying	An alternate shorter form of the name
active	boolean	Indicates if the domain is active or not.
family	character varying	Either local or ActiveDirectory.

public.draft_metadata: Each record represents a workbook draft per site, per project per user.
Name	Type	Description
draft_luid	uuid	Primary key for the record.
site_luid	uuid	Unique identifier of the site
name	character varying	User friendly name for the draft
user_luid	uuid	User luid of the owner of the workbook draft
project_luid	uuid	Unique identifier of the project where draft is saved
parent_luid	uuid	Unique identifier of the content from which the draft is created. For new draft this value will be null
parent_revision_id	character varying	Revision id for the content from which the draft is created. For new draft this value will be null
thumbnail_url	character varying	Thumbnail url for the draft
snapshot_timeline_id	character varying	Timeline id of vizqlserver snapshot
created_at	timestamp without time zone	Draft creation timestamp
updated_at	timestamp without time zone	Draft modified timestamp

public.extensions_block_list: Table which stores the block list of extensions on this server
Name	Type	Description
luid	uuid	The luid which uniquely identifies the extensions blocklist row.
url	text	The url of extension which is blocked.
active	boolean	The check to see if the current entry is active or archived.
created_at	timestamp without time zone	Created date for this record.
updated_at	timestamp without time zone	Modified date for this record.

public.extensions_events: Table which stores the events of referenced extensions calculation service
Name	Type	Description
luid	uuid	The luid which uniquely identifies the extensions events row.
workbook_luid	uuid	The luid which uniquely identifies the workbook.
site_luid	uuid	The luid which uniquely identifies the site.
site_id	integer	The id which uniquely identifies the site.
status	integer	The status of the current task.
created_at	timestamp without time zone	Created date for this record.
updated_at	timestamp without time zone	Modified date for this record.

public.extensions_instances: Table which stores referenced extensions information calculated from across the workbooks.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
luid	uuid	The luid which uniquely identifies the extensions instance row.
extension_luid	uuid	The luid which uniquely identifies the extension.
workbook_luid	uuid	The luid which uniquely identifies the workbook.
view_luid	uuid	The luid which uniquely identifies the view.
site_luid	uuid	The luid which uniquely identifies the site.
site_id	integer	The id which uniquely identifies the site.
active	boolean	The check to determine if the current entry is active or archived.
count	integer	The count of extensions in views of a given workbook
created_at	timestamp without time zone	Created date for this record.
updated_at	timestamp without time zone	Modified date for this record.
id	bigint	The unique identifier for this entry.

public.extensions_metadata: Table which stores Metadata of Extensions.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
luid	uuid	The luid which uniquely identifies the extensions metadata row.
site_luid	uuid	The luid which identifies the site.
site_id	integer	The id which identifies the site.
extension_id	text	The extension id defined in the manifest.
type	text	The type of extension.
version	text	The version of extension.
manifest_version	text	The version of the manifest of the extension.
min_api_version	text	The minimum api version needed for the extension.
default_locale	text	The default locale of the extension.
name_locale_value	text	The name of the extension.
name_locale_resourceid	text	The resource id for the name of the extension.
desc_locale_value	text	The description of the extension.
dec_locale_resourceid	text	The resource id for the description of the extension.
resources	text	The localization resources for the extension.
permissions	text	The permissions defined in the manifest of the extension.
author_name	text	The name of the author of extension.
author_email	text	The email of the author of extension.
author_org	text	The organization of the author of extension.
author_website	text	The website of the author of extension.
url	text	The url of extension.
icon	text	The icon of extension.
installed	boolean	The check to see if the extension is installed.
created_at	timestamp without time zone	Created date for this record.
updated_at	timestamp without time zone	Modified date for this record.
id	bigint	The id of the extension from the manifest.

public.extensions_safe_list: Table which stores safe list of extensions that are configured for a given site.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
site_luid	uuid	The luid which uniquely identifies the site.
site_id	integer	The id which uniquely identifies the site.
luid	uuid	The luid which uniquely identifies the extensions safe list row.
url	text	The url of the safe list extension.
allow_full_data	boolean	The full data access permission of an extension.
prompt_needed	boolean	The prompt needed setting of an extension.
active	boolean	The check to determine if the current entry is active or archived.
created_at	timestamp without time zone	Created date for this record.
updated_at	timestamp without time zone	Modified date for this record.
id	bigint	The unique identifier for this entry.

public.extensions_site_settings: Table which stores the site specific settings for extensions
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
site_luid	uuid	The luid which uniquely identifies the site.
site_id	integer	The id which uniquely identifies the site.
luid	uuid	The luid which uniquely identifies the extensions settings row.
extensions_enabled	boolean	The check to see if the extensions are enabled on the site.
default_setting	boolean	The check to see if the default settings are enable for extensions
active	boolean	The check to determine if the current entry is active or archived.
updated_at	timestamp without time zone	Modified date for this record.
id	bigint	The unique identifier for this entry.
allow_sandboxed	boolean	Whether sandboxed extensions are allowed to run

public.external_service_connections: Table which stores the site specific settings for external service connections
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	The id which uniquely identifies the connection.
luid	uuid	The luid which uniquely identifies the connection, for security purpose.
site_id	integer	The site_id which uniquely identifies the site.
connection_type	text	The connection_type identifies the external service type.
host	text	The host identifies host name or ip address of the external server
port	integer	The port identifies port of the external service.
is_auth_enabled	boolean	The is_auth_enabled identifies whether authentication is enabled.
username	text	The username for authentication of the external service, if is_auth_enabled.
pwd	text	The encrypted password for authentication of the external service, if is_auth_enabled.
is_ssl_enabled	boolean	The is_ssl_enabled identifies whether SSL is enabled for the external service.
asset_key_id	integer	The asset_key_id which uniquely identifies the asset key with which secrets in this row are encrypted
connection_name	character varying	unique name for the connection

public.external_service_site_settings: Table which stores the site level settings for external services
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	The id which uniquely identifies the site setting.
site_id	integer	The site_id which uniquely identifies the site.
extsvc_enabled	boolean	The extsvc_enabled identifies whether external service is enabled on certain site.
time_out	integer	The time_out identifies the time out value when connect to external service.

public.extract_operations: Each record represents an extract create operation on a Tableau workbook.
Name	Type	Description
Foreign key/Primary key relation from owner_id on this table to id on table, public.users
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the extract operation record.
job_id	integer	The background job id for this opeartion.
session_id	character varying	The session identifier.
workbook_id	integer	The ID of the workbook associated with this operation. It is null when this operation is for a new workbook.
operation_data	json	The data sources to create extracts with json format.
document_data_id	character varying	The identifier for the workbook file data associated with this operation.
owner_id	integer	The user ID of the owner of the operation.
site_id	integer	The ID of the site associated with this operation.
embedded	text	An encrypted keychain holding any credentials stored with the workbook.
asset_key_id	integer	The asset encryption key used to encrypt the keychain in the embedded column.
status	integer	The status of the operation.
error_message	text	Store the error message of the operation.
updated_at	timestamp without time zone	When this record was last updated.
created_at	timestamp without time zone	When this record was created.
extract_id	integer	ID of the extract record used by this operation.
lock_version	integer	Version of the database record.
luid	uuid	A unique identifier of the extract operation.

public.extract_service_commands: Table which stores the extract commands for extract service
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	The id which uniquely identifies row in the table
luid	uuid	The luid of record in the table
created_at	timestamp without time zone	The timestamp for creating the extract command
updated_at	timestamp without time zone	The timestamp for updating the extract command
site_id	integer	A foreign key reference to the site to where the extract command exists.
site_luid	uuid	Extract command site luid
owner_luid	uuid	Extract command owner luid
duration	bigint	Duration of extract command execution time
status	character varying	Status of extract command
message	text	Message of extract command
execute_node	uuid	Which node execute the extract command
resource_type	character varying	Extract command for what extractable resource type
resource_luid	uuid	Extract command for which extractable resource luid
operation	character varying	Extract command operation
starting_items	text	Extract command starting items

public.extract_service_extracts: Table which stores the extracts for extract service
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	The id which uniquely identifies row in the table
luid	uuid	The luid of record in the table
created_at	timestamp without time zone	The timestamp for creating the extract
updated_at	timestamp without time zone	The timestamp for updating the extract
site_id	integer	A foreign key reference to the site to where the extracts exists.
site_luid	uuid	Extract site luid.
owner_luid	uuid	Extract owner luid
latest_version	integer	Latest version of extract result for the extract

public.extract_service_results: Table which stores the extract results for extract service
Name	Type	Description
Foreign key/Primary key relation from command_id on this table to id on table, public.extract_service_commands
Foreign key/Primary key relation from extract_id on this table to id on table, public.extract_service_extracts
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	The id which uniquely identifies row in the table
created_at	timestamp without time zone	The timestamp for creating the extract command
extract_id	bigint	A foreign key reference to the extract
command_id	bigint	A foreign key reference to the extract command
site_id	integer	A foreign key reference to the site to where the extract command exists.
site_luid	uuid	Extract result site luid
sos_data_id	character varying	SOS data id of extract result
version	integer	Result version of extract

public.extract_sessions: Extracts that have active vizql sessions.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for this record.
extract_id	integer	Foreign key reference to the extracts table.
session_guid	character varying	Vizql session identifier.
session_type	character varying	One of "Workbook" or "Datasource"
created_at	timestamp without time zone	Date when extract session was created.
worker_name	character varying	Worker on which extract session was created.
site_id	integer	Site ID of the extract session.

public.extracts: Each record corresponds to a directory that contains one or more extract files associated with either a workbook or datasource.
Name	Type	Description
Foreign key/Primary key relation from datasource_id on this table to id on table, public.datasources
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from workbook_id on this table to id on table, public.workbooks
id	integer	Primary key for this record.
workbook_id	integer	If the extracts are associated with a workbook, then this is a foreign key link to that workbook, otherwise it is NULL.
descriptor	character varying	The UUID that is the name of the directory where the extracts are saved.
created_at	timestamp without time zone	When this record was created.
updated_at	timestamp without time zone	When this record was last updated.
datasource_id	integer	If the extracts are associated with a datasource, then this is a foreign key link to that datasource, otherwise it is NULL.
encryption_key_id	character varying	If not null, id of the extract encryption key (KEK) with which these extracts are encrypted.
site_id	integer	Site ID of the extract.
size	bigint	Size of the extract(s) in bytes.

public.field_indexability: The user-defined NLP indexability rules for fields in datasources
Name	Type	Description
Foreign key/Primary key relation from published_datasource_id on this table to id on table, public.datasources
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	The unique identifier for this row that is automatically generated on insert
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
site_id	integer	The id of the site on which the datasource is published
published_datasource_id	integer	The id of the published datasource on the site
field_graph_id	text	The graph id of the field in the datasource
indexing_mode	text	The user-specified behavior for NLP to index the field

public.flow_drafts: Each record represents a draft for a Tableau Prep flow that exists on Tableau Server.
Name	Type	Description
Foreign key/Primary key relation from flow_id on this table to id on table, public.flows
Foreign key/Primary key relation from owner_id on this table to id on table, public.users
Foreign key/Primary key relation from project_id on this table to id on table, public.projects
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the flow draft record.
luid	uuid	An immutable identifier for the flow draft, unique within a site.
owner_id	integer	The user ID of the owner of the flow draft. The owner of the draft may differ from the owner of the flow.
flow_id	integer	The ID of the flow associated with this draft. If null, this draft is for a new flow.
site_id	integer	The ID of the site containing this flow draft.
project_id	integer	The ID of the project containing this flow draft. Present if and only if flow ID is null. Otherwise, shares project of flow.
name	character varying	The name of the flow draft. Present if and only if flow ID is null. Otherwise, shares name of flow.
document_data_id	character varying	The identifier for the .TFL(X) file data associated with this flow draft.
packaged_files_data_id	character varying	The identifier for the packaged file data associated with this flow draft.
content_version	integer	Version of the flow draft. Incremented on each update.
created_at	timestamp without time zone	The time the record was created.
last_force_updated_at	timestamp without time zone	The time the record was last forcibly updated, bypassing certain time-based update throttling.
updated_at	timestamp without time zone	The time the record was last updated.
document_file_size	bigint	The size of the flow draft document file in bytes.
packaged_files_size	bigint	The size of the flow draft packaged files in bytes.
flow_content_version	integer	The version of the flow to which this draft corresponds. If not associated with a flow, this value will be null.
is_virtual_draft	boolean	True if this draft is virtual, meaning no changes have been saved to it. False otherwise.
lock_version	integer	Optimistic lock version intended for internal usage only. Should not be manually set or retrieved.
encryption_key	character varying	The ID of the encryption key (KEK) with which data in this flow draft is encrypted. If the flow draft has no encryption key, this value will be null.
data_engine_extracts	boolean	True if the flow draft contains data was supplied in the form of a Tableau data extract. False otherwise.
extract_encryption_state	smallint	Encryption state of the extracts for this flow draft. null or 0 - unencrypted, 1 - encrypted, 2 - pending encryption, 3 - pending decryption, 5 - pending rekey
published_at	timestamp without time zone	The time the flow draft was last published into a flow.
last_session_id	character varying	The id of the most recent flow edit session that was created for this draft. Null indicates there are no active sesions for the draft.

public.flow_events: Each row represents an event affecting a flow
Name	Type	Description
id	integer	Primary key of the event
flow_id	integer	Foreign key to the corresponding flow
event_type	integer	Event type integer value
event_created_at	timestamp without time zone	Time of event creation
site_id	integer	Site ID of flow event

public.flow_input_steps: Each record represents an individual input step from a published Tableau Prep flow.
Name	Type	Description
Foreign key/Primary key relation from data_connection_id on this table to id on table, public.data_connections
Foreign key/Primary key relation from flow_id on this table to id on table, public.flows
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record of the input step.
step_id	character varying	Unique id for the input step, pulled from the TFL file.
name	character varying	The name of the input step, pulled from TFL.
flow_id	integer	The FK to flows for the flow where this input step exists.
data_connection_id	integer	The FK to data_connections.
site_id	integer	The id of the site associated with the flow where this input step exists.
luid	uuid	A unique, immutable identifier for the input step.

public.flow_models: Each row contains model metadata for a flow
Name	Type	Description
Foreign key/Primary key relation from flow_id on this table to id on table, public.flows
id	integer	Primary key of the model metadata
flow_id	integer	Foreign key to the corresponding flow
data_id	character varying	Data store ID of model
generated_at	timestamp without time zone	Time of model generation
stale_at	timestamp without time zone	Model expiration time
site_id	integer	Site ID of the flow_models.

public.flow_output_step_runs: Each record represents a run of an output step of a flow. See flow_runs for per-flow run history.
Name	Type	Description
Foreign key/Primary key relation from flow_id on this table to id on table, public.flows
Foreign key/Primary key relation from flow_output_step_id on this table to id on table, public.flow_output_steps
Foreign key/Primary key relation from flow_run_id on this table to id on table, public.flow_runs
id	integer	Primary key for the record.
flow_id	integer	Foreign key to the flow that was run.
flow_run_id	integer	Foreign key to the flow_runs table which gives the flow-level run history.
flow_output_step_id	integer	Foreign key to the flow_output_steps table.
started_at	timestamp without time zone	When the flow processing system began executing the execution plan associated with this output step.
completed_at	timestamp without time zone	When the flow processing system completed publishing the output of this output step.
progress	integer	Can be used to indicate percent complete for the job, but in most cases simply gets set to 100 when the job is completed. -1 means pending.
finish_code	integer	Whether or not the job succeeded. 0 for success; 1 for failure; 2 for cancelled.
rows_produced	bigint	The count of rows produced.
notes	character varying	Can be used to store additional information about the running of the job. Often errors.
is_incremental	boolean	Whether the run was incremental in run history
site_id	integer	Site ID of the flow_output_step_runs.

public.flow_output_steps: Each record represents an individual output step from a published Maestro flow.
Name	Type	Description
Foreign key/Primary key relation from data_connection_id on this table to id on table, public.data_connections
Foreign key/Primary key relation from datarole_id on this table to id on table, public.data_roles
Foreign key/Primary key relation from datasource_id on this table to id on table, public.datasources
Foreign key/Primary key relation from flow_id on this table to id on table, public.flows
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record of the output step.
step_id	character varying	Unique id for the output step, pulled from the TFL file.
name	character varying	The name of the output step from TFL.
flow_id	integer	The FK to flows for the flow where this output step exists.
data_connection_id	integer	The FK to data_connections.
site_id	integer	The id of the site associated with the flow where this output step exists.
luid	uuid	A unique, immutable identifier for the output step.
is_deleted	boolean	Whether this flow output step is deleted or not.
datasource_id	integer	id of associated datasource
datarole_id	integer	id of associated datarole
is_incremental_enabled	boolean	Whether to give user the option to run this output incrementally
is_incremental_default	boolean	Whether running this output incrementally is the default option.
output_operation_type	integer	Whether to create-1, append-2 or truncate-3 the output when run type is full refresh.
incremental_output_operation_type	integer	Whether to create-1, append-2 or truncate-3 the output when run type is incremental refresh.
output_name	character varying	The name of the output that the flow creates.

public.flow_run_errors: Each record represents an individual flow run error which has detailed information about the error
Name	Type	Description
Foreign key/Primary key relation from flow_id on this table to id on table, public.flows
Foreign key/Primary key relation from flow_output_step_id on this table to id on table, public.flow_output_steps
Foreign key/Primary key relation from flow_output_step_run_id on this table to id on table, public.flow_output_step_runs
Foreign key/Primary key relation from flow_run_id on this table to id on table, public.flow_runs
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record of the flow run error.
flow_id	integer	The FK to flows for the flow which this run error is about.
flow_output_step_id	integer	The FK to flow output steps for the output step which this run error is about.
flow_run_id	integer	The FK to flow runs for the flow run where this error got reported from.
flow_output_step_run_id	integer	The FK to flow output step runs for the flow output step run where this error got reported from.
error_type	character varying	The type of this error
object_id	character varying	The object id this error is about, could be null if the error is not about specific object but the entire flow.
object_type	character varying	The type of the object, like node or connection in the maestro doc
object_name	character varying	The name of the object according to the maestro doc, used to display name in clients
error_message_params	text	string params for the flow run error messages, formatted as yaml.
exception_class	text	the class name of the original exception of the flow run error
exception_stacktrace	text	the stacktrace of the original exception of the flow run error
flowprocessor_raw_error_message	text	the raw error message in English from flow processor, if the flow run error is originated from flow processor
site_id	integer	Site ID of the flow_run_errors.

public.flow_run_spec_output_steps: Each record represents an individual output step in a flow run specification.
Name	Type	Description
Foreign key/Primary key relation from flow_output_step_id on this table to id on table, public.flow_output_steps
Foreign key/Primary key relation from flow_run_spec_id on this table to id on table, public.flow_run_specs
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record of the flow run spec output step.
flow_run_spec_id	integer	The FK to flow_run_spec for the flow run spec which this output step belongs to.
flow_output_step_id	integer	The FK to flow_output_steps table for the flow output step which this Id refers to .
site_id	integer	The id of the site associated with the flow which the entire flow run spec is about.
luid	uuid	A unique, immutable identifier for the flow run spec output step.
is_incremental	boolean	Whether user chooses incremental run in scheduler

public.flow_run_specs: Each record represents an individual specification about how a Tableau Prep flow should be run
Name	Type	Description
Foreign key/Primary key relation from flow_id on this table to id on table, public.flows
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record of the flow run spec.
flow_id	integer	The FK to flows for the flow which this run spec is about.
trigger_type	character varying	The trigger type of this flow run, currently 0 for scheduled run, 1 for ad-hoc run
site_id	integer	The id of the site associated with the flow which this run spec is about.
luid	uuid	A unique, immutable identifier for the flow run spec.
run_all_outputs	boolean	Whether to run flow with all outputs, future outputs included
is_incremental	boolean	Whether to force all output nodes run incrementally (true) or full refresh (false) or unspecified (null).

public.flow_runs: Each record represents a run of a flow. See flow_output_step_runs for per-output-step run history.
Name	Type	Description
Foreign key/Primary key relation from flow_id on this table to id on table, public.flows
Foreign key/Primary key relation from flow_run_spec_id on this table to id on table, public.flow_run_specs
Foreign key/Primary key relation from task_id on this table to id on table, public.tasks
Foreign key/Primary key relation from user_id on this table to id on table, public.users
id	integer	Primary key for the record.
flow_id	integer	Foreign key to the flow that was run.
flow_processor_run_id	character varying	Identifier for a given run from the flow processing system.
flow_run_spec_id	integer	Identifier for the specification of a given run.
started_at	timestamp without time zone	When the flow processing system began execution.
completed_at	timestamp without time zone	When the flow processing system completed execution.
task_id	integer	Foreign key to the task that triggered this flow run (if one exists).
trigger_type	character varying	Specifies what caused this flow run to occur. Currently 0 for scheduled run (task), 1 for ad-hoc run.
progress	integer	Can be used to indicate percent complete for the job, but in most cases simply gets set to 100 when the job is completed. -1 means pending.
finish_code	integer	Whether or not the job succeeded. 0 for success; 1 for failure; 2 for cancelled.
notes	character varying	Can be used to store additional information about the running of the job. Often errors.
background_job_id	integer	ID of the background job associated with this flow run
luid	uuid	An immutable identifier for the flow run.
user_id	integer	User ID of the user who started the flow run.
site_id	integer	Site ID of the flow_runs.

public.flow_runtime_owners: Table to keep track of flow/flow output step owner at flow run time. Used to calculate derived permission on flow outputs.
Name	Type	Description
Foreign key/Primary key relation from flow_id on this table to id on table, public.flows
Foreign key/Primary key relation from flow_output_step_id on this table to id on table, public.flow_output_steps
Foreign key/Primary key relation from owner_id on this table to id on table, public.users
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from table_id on this table to id on table, public.table_assets
id	integer	Primary key.
flow_id	integer	Flow id.
flow_output_step_id	integer	Flow output step id for this flow runtime owner.
created_at	timestamp without time zone	When this flow runtime owner record was created.
updated_at	timestamp without time zone	When this flow runtime owner record was updated.
table_id	integer	Table related to this flow runtime owner.
owner_id	integer	Owner for this flow/table/output step.
site_id	integer	Site this flow runtime owner belongs to.

public.flow_user_settings: Each record represents a users selected settings for a Prep flow.
Name	Type	Description
Foreign key/Primary key relation from flow_id on this table to id on table, public.flows
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from user_id on this table to id on table, public.users
id	integer	Primary key for the flow users settings.
user_id	integer	The user ID of the user with the settings record for this flow.
flow_id	integer	The ID of the flow that this user has made these settings selection.
site_id	integer	The ID of the site containing this flow and user.
embed_mode	boolean	True if the user selected to embed credentials in the flow, false if they selected to not embed credentials.

public.flow_versions: flow versions saved on server.
Name	Type	Description
Foreign key/Primary key relation from flow_id on this table to id on table, public.flows
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	The id of a version. Primary key.
site_id	integer	Reference to entry in sites table. Indicates the site to which this flow version belongs to.
flow_id	integer	A foreign key to the flows table. Reference to flow.
publisher_id	integer	Reference to user in site users table. User who published this version. Can point to deleted user.
version_number	integer	The version number.
published_at	timestamp without time zone	The time when this version was initially published. Copied from flow record last_updated field at the time of being overwritten.
size	bigint	The size, in bytes, of this version of flow.
content_key	character varying	Key of the flow as string
sos_type	character varying	The SOS data type under which this version document is stored, or null if it is not stored in SOS.
encryption_key_id	character varying	If not null, id of the flow version encryption key (KEK) with which data in this flow is encrypted.
data_engine_extracts	boolean	True means the data was supplied in the form of a Tableau data extract, though the original source of the data may be known to reside elsewhere.
extract_encryption_state	smallint	If not null, encryption state of the extracts. null or 0 - unencrypted, 1 - encrypted, 2 - pending encryption, 3 - pending decryption, 5 - pending rekey

public.flows: Each record represents a Tableau Prep flow that exists on Tableau Server.
Name	Type	Description
Foreign key/Primary key relation from owner_id on this table to id on table, public.users
Foreign key/Primary key relation from project_id on this table to id on table, public.projects
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the flow record.
name	character varying	The name of the published flow.
luid	uuid	A unique, immutable identifier for the flow.
owner_id	integer	The user id of the owner/publisher of the flow.
project_id	integer	The id of the project that this flow is associated with.
site_id	integer	The id of the site that this flow is associated with.
data_id	character varying	The identifier for the data of the .tfl file associated with this flow.
reduced_data_id	character varying	Unique ID used to identify the flow's packaged files (removed from the .TFLX and stored separately).
created_at	timestamp without time zone	The time the record was created.
updated_at	timestamp without time zone	The time the record was updated.
description	text	The description of the flow.
lock_version	integer	Used to implement "optimistic locking." Do not set this or mess with it, its all handled automatically.
size	bigint	The size of the flow file in bytes
embedded	text	The encrypted keychain with credentials stored with the flow.
asset_key_id	integer	The asset encryption key used to encrypt the keychain in the embedded column.
thumbnail_id	character varying	The identifier for the thumbnail data.
last_published_at	timestamp without time zone	The last time the flow file was published.
content_version	integer	Version of the flow file, increments on each publish.
document_version	character varying	The internal version of the .tfl file associated with this record.
file_type	character varying	Whether this flow file is a tfl or tflx.
graph_image_id	character varying	Locator id for the graph image of the flow in SOS
encryption_key_id	character varying	If not null, id of the flow encryption key (KEK) with which data in this flow is encrypted.
data_engine_extracts	boolean	True means the data was supplied in the form of a Tableau data extract, though the original source of the data may be known to reside elsewhere.
extract_encryption_state	smallint	If not null, encryption state of the extracts. null or 0 - unencrypted, 1 - encrypted, 2 - pending encryption, 3 - pending decryption, 5 - pending rekey
is_deleted	boolean	When is_deleted is true then flow is deleted, no active job or user request can see it. It is considered to reside in Recycle Bin until either restored or permanently deleted.

public.geocoding: Information about geocoding databases.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Auto-generated id from postgres; also the primary key for the table.
sos_id	text	Storage ID of this database.
version	text	Version of the database.
created_at	timestamp without time zone	Timestamp when this record was created.
updated_at	timestamp without time zone	Same as created_at.
size	bigint	Size of the geocoding database.
site_id	integer	The ID of the site the geocoding database belong to.

public.global_geocoding: Information about global geocoding databases.
Name	Type	Description
id	integer	Auto-generated id from postgres; also the primary key for the table.
sos_id	text	Storage ID of this database.
version	text	Version of the database.
size	bigint	Size of the geocoding database.
active	boolean	Whether the database is used by the server.
created_at	timestamp without time zone	Timestamp when this record was created.
updated_at	timestamp without time zone	Same as created_at.

public.group_users: Serves as a many to many linking mechanism between users and groups. A user can belong to multiple groups, and a group can contain multiple users.
Name	Type	Description
Foreign key/Primary key relation from group_id on this table to id on table, public.groups
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from user_id on this table to id on table, public.users
id	integer	Primary key for this record.
group_id	integer	A foreign key reference to an entry in the groups table.
user_id	integer	A foreign key reference to an entry in the users table.
site_id	integer	Site ID of the group_users.

public.groups: A grouping of users. Can be locally created or imported from Active Directory.
Name	Type	Description
Foreign key/Primary key relation from domain_id on this table to id on table, public.domains
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for this record.
name	character varying	The name that was given to the group.
created_at	timestamp without time zone	When this record was created.
updated_at	timestamp without time zone	When this record was last updated.
system	boolean	Indicates if this group was created by Tableau itself, or if it was created by user action.
owner_id	integer	A foreign key link to the user who owns this group.
domain_id	integer	A foreign key link to the domain that corresponds to this group.
site_id	integer	A foreign key link to the site to which this group belongs.
luid	uuid	An identifier that is unique in combination with the site_id.
minimum_site_role	character varying	The minimum site role given to members of the AD group
last_synchronized	timestamp without time zone	Last time that synchronization for an AD group was completed
minimum_site_role_id	integer	the id of the minimum site role of the group
grant_license_mode	character varying	When to grant a license to the users in the group. Can either by ON_SYNC or ON_LOGIN

public.hist_capabilities: Records the most useful information about a capability that was relevant at the time of the event (see capabilities table).
Name	Type	Description
id	integer	Primary key for the record.
capability_id	integer	A foreign key reference to an entry in the capabilities table. This could be NULL if the matching record in the capabilities table was deleted since this record was created.
name	text	This (or the id) is how the capability is referred to by code.
allow	boolean	Whether or not the capability is allowed.

public.hist_collections: Records the most useful information about a collection that was relevant at the time of the event.
Name	Type	Description
id	integer	Primary key for this record.
collection_luid	character varying	luid of the collection
name	character varying	The human readable name of the collection.

public.hist_column_assets: Records the most useful information about a column that was relevant at the time of the event (see column_assets table).
Name	Type	Description
id	integer	Primary key for this record.
column_id	integer	A foreign key reference to an entry in the columns table. This could be NULL if the matching record in the column_assets table was deleted since this record was created.
name	character varying	The name of the column.

public.hist_comments: Records the most useful information about a comment that was relevant at the time of the event (see comments table).
Name	Type	Description
id	integer	Primary key for this record.
comment_id	integer	A foreign key link to the primary key for the comments record. This could be NULL if the matching record in the comments table was deleted since this record was created.
comment	text	Comment text.

public.hist_configs: Can be used to record information about configuration that was in effect at the time of the historical event.
Name	Type	Description
id	integer	Primary key for this record.
key	text	A unique name for the specific configuration.
value	text	The value of the configuration.

public.hist_data_connections: Records the most useful information about a data connection that was relevant at the time of the event (see data_connections table).
Name	Type	Description
id	integer	Primary key for this record.
data_connection_id	integer	A foreign key reference to an entry in the data_connections table. This could be NULL if the matching record in the data_connections table was deleted since this record was created.
server	text	DNS server name to connect to.
name	text	Unique identifier for this data_connection.
dbname	text	The database name to which the particular connection is linked.
table_name	text	The name of the table in the database that this connection connects to.

public.hist_data_quality_indicators: Records the most useful information about a data quality indicator that was relevant at the time of the event (see data_quality_indicators table).
Name	Type	Description
id	integer	Primary key for this record.
data_quality_indicator_id	bigint	A foreign key reference to an entry in the data quality indicators table. This could be NULL if the matching record in the data_quality_indicators table was deleted since this record was created.
data_quality_type	character varying	Type of data quality indicator.
is_active	boolean	Represents state of data quality indicator as true or false.
is_severe	boolean	Indicates whether a data quality indicator is severe or not. True means severe, otherwise false.
message	text	Message of data quality indicator.
user_id	integer	Id of user who created/updated data quality indicator.
user_display_name	character varying	Display name of user who created/updated data quality indicator.

public.hist_data_roles: Records the most useful information about a data role that was relevant at the time of the event (see data_roles table).
Name	Type	Description
id	integer	Primary key for this record.
data_role_id	integer	A foreign key reference to an entry in the data_roles table. This could be NULL if the matching record in the data_roles table was deleted since this record was created.
name	character varying	The name of the data_role.

public.hist_database_assets: Records the most useful information about a database that was relevant at the time of the event (see database_assets table).
Name	Type	Description
id	integer	Primary key for this record.
database_id	integer	A foreign key reference to an entry in the databases table. This could be NULL if the matching record in the database_assets table was deleted since this record was created.
name	character varying	The name of the database.

public.hist_datasources: Records the most useful information about a data source that was relevant at the time of the event (see datasources table).
Name	Type	Description
id	integer	Primary key for this record.
datasource_id	integer	A foreign key reference to an entry in the datasources table. This could be NULL if the matching record in the datasources table was deleted since this record was created.
name	text	The name of the published datasource.
repository_url	text	Uniquely identifies a datasource. More or less consists of a slightly modified name, but not totally obviously, especially in the presence of non-ASCII characters. Used in URLs meant to access this datasource.
size	bigint	The size in bytes of the datasource.
revision	text	Increments each time a new version of the datasource is published.
using_remote_query_agent	boolean	Whether this datasource is using remote query agent.
remote_query_agent_name	text	The remote query agent name used by the data source.
is_certified	boolean	Whether or not this datasource is certified.
certification_note	text	Explanation for the certification status of this datasource.

public.hist_flow_drafts: Records the most useful information about a flow draft that was relevant at the time of the event (see flow_drafts table).
Name	Type	Description
id	integer	Primary key for this record.
flow_draft_id	integer	The ID of the flow draft.
flow_id	integer	The ID of the flow if the flow draft is associated with a flow, NULL otherwise.
name	character varying	The name of the flow draft.
size	bigint	The number of bytes used in storing the flow draft information.

public.hist_flows: Records the most useful information about a flow that was relevant at the time of the event (see flows table).
Name	Type	Description
id	integer	Primary key for this record.
flow_id	integer	A foreign key reference to an entry in the flows table. This could be NULL if the matching record in the flows table was deleted since this record was created.
name	character varying	The name of the flow.
size	bigint	The number of bytes used in storing the flow information.
content_version	character varying	Version of the flow file, increments by 1 on each publish.

public.hist_groups: Records the most useful information about a group that was relevant at the time of the event (see groups table).
Name	Type	Description
id	integer	Primary key for this record.
group_id	integer	A foreign key reference to an entry in the groups table. This could be NULL if the matching record in the groups table was deleted since this record was created.
name	text	The name that was given to the group.
domain_name	text	The name is either "local" or the name of some Active Directory group.

public.hist_licensing_roles: Records the most useful information about a licensing role that was relevant at the time of the event (see licensing_roles table).
Name	Type	Description
id	integer	Primary key for this record.
licensing_role_id	integer	A foreign key reference to an entry in the licensing_roles table. This could be NULL if the matching record in the licensing_roles table was deleted since this record was created.
name	text	The name of the licensing role.

public.hist_metrics: Records the most useful information about a metric that was relevant at the time of the event (see metrics table).
Name	Type	Description
id	integer	Primary key for this record.
metric_id	integer	A foreign key reference to an entry in the metrics table. This could be NULL if the matching record in the metrics table was deleted since this record was created.
name	character varying	The name of the metric.

public.hist_projects: Records the most useful information about a project that was relevant at the time of the event (see projects table).
Name	Type	Description
id	integer	Primary key for this record.
project_id	integer	A foreign key reference to an entry in the projects table. This could be NULL if the matching record in the projects table was deleted since this record was created.
name	text	The name of the project.

public.hist_published_connections: Records the most useful information about a published connection that was relevant at the time of the event (see published_connections table).
Name	Type	Description
id	integer	Primary key for this record.
published_connection_id	integer	A foreign key reference to an entry in the published_connections table. This could be NULL if the matching record in the published_connections table was deleted since this record was created.
name	text	The name of the published connection.

public.hist_remote_agents: Records the most useful information about a remote agent that was relevant at the time of the event.
Name	Type	Description
id	integer	Primary key for the record.
remote_agent_id	integer	A reference to an entry in the remote_agents table. This could be NULL if the matching record in the datasources table was deleted since this record was created.
name	text	The value of remote_agents.name at the time of the event.

public.hist_schedules: Records the most useful information about a schedule that was relevant at the time of the event (see schedules table).
Name	Type	Description
Foreign key/Primary key relation from schedule_id on this table to id on table, public.schedules
id	integer	Primary key for this record.
schedule_id	integer	A foreign key reference to an entry in the schedules table. This could be NULL if the matching record in the schedules table was deleted since this record was created.
name	text	A schedule can be given a name, which is stored here.
schedule_type	integer	One of 0 (Hourly), 1 (Daily), 2 (Weekly), 3 (Monthly).
priority	integer	Priority can range from 1 to 100, with lower values corresponding to higher priority.
scheduled_action	integer	Used to classify schedules into one of two categories: 0 (Extract related) 1 (Subscription related)
is_serial	boolean	Set to true if the schedule must be run serially with other jobs in the same serial collection.
day_of_week_mask	integer	Indicates which day of the week this schedule will run. The information is encoded in the given integer. To interpret it, convert the integer to binary. The days of the week correspond to Sunday : 1, Monday : 10, Tuesday : 100, Wednesday : 1000, Thursday : 10000, Friday : 100000, Saturday : 1000000.
day_of_month_mask	integer	Indicates which day of the month this schedule will run. The information is encoded in the given integer. To interpret it, convert the integer to binary. The days of the month correspond to 1st : 1, 2nd: 10, 3rd: 100, 4th: 1000, 5th: 10000, etc.
start_at_minute	integer	The minute following the start of the designated time period implied by the schedule_type. For example, for a daily schedule, this would be number of minutes past midnight at the start of the day. For hourly, it would be the number of minutes past the beginning of the hour.
minute_interval	integer	Once the schedule triggers, it will retrigger at this interval during the time period implied by the schedule_type or until end_at_minute, or end_schedule_at.
end_at_minute	integer	The minute following the start of the designated time period implied schedule_type, at which the schedule should stop triggering.
end_schedule_at	timestamp without time zone	Used to indicate a point in time, after which the schedule should never trigger.

public.hist_sites: Records the most useful information about a site that was relevant at the time of the event (see sites table).
Name	Type	Description
id	integer	Primary key for this record.
site_id	integer	A foreign key reference to an entry in the sites table. This could be NULL if the matching record in the sites table was deleted since this record was created.
name	text	The name of the site.
url_namespace	text	String used in the construction of URLs that target this site.

public.hist_table_assets: Records the most useful information about a table that was relevant at the time of the event (see table_assets table).
Name	Type	Description
id	integer	Primary key for this record.
table_id	integer	A foreign key reference to an entry in the tables table. This could be NULL if the matching record in the table_assets table was deleted since this record was created.
name	character varying	The name of the table.

public.hist_tags: Records the most useful information about a tag that was relevant at the time of the event (see tags table).
Name	Type	Description
id	integer	Primary key for this record.
tag_id	integer	A foreign key reference to an entry in the tags table. This could be NULL if the matching record in the tags table was deleted since this record was created.
name	text	The value of the tag.

public.hist_tasks: Records the most useful information about a task that was relevant at the time of the event (see tasks table).
Name	Type	Description
id	integer	Primary key for this record.
task_id	integer	A foreign key reference to an entry in the tasks table. This could be NULL if the matching record in the tasks table was deleted since this record was created.
type	text	Identifies the specific type of task that this is. This is how the system identifies what code to execute when this task is to be run.
priority	integer	An integer where 0 is the highest priority and 10 is the default priority. Other values can be set if desired). Higher priority jobs should be processed earlier.
state	integer	State of the task. 0 - active, 1 - suspended, 2 - disabled.

public.hist_users: Records the most useful information about a user and corresponding system_user that was relevant at the time of the event (see users and system_users tables).
Name	Type	Description
Foreign key/Primary key relation from hist_licensing_role_id on this table to id on table, public.hist_licensing_roles
id	integer	Primary key for this record.
user_id	integer	A foreign key reference to an entry in the users table. This could be NULL if the matching record in the users table was deleted since this record was created.
name	text	The username of the user.
domain_name	text	The name is either "local" or the name of some Active Directory group.
email	text	The email of the user.
system_user_id	integer	A foreign key reference to the system user that this user is identified with. This could be NULL if the matching record in the system_users table was deleted since this record was created.
system_admin_level	integer	Indicates if the user is a system administrator. 10 : system admin, 0 : not a system admin
hist_licensing_role_id	integer	A foreign key reference to the licensing_role_id column for a record in the hist_licensing_roles table.
site_admin_level	integer	Indicates if this user is a site admin. 5 : site admin, 0 : not site admin.
publisher_tristate	integer	Deprecated. Column will be removed in a future release.
site_role_id	integer	The ID of the site role for this user. The mapping is described in the comment for the column users.site_role_id.

public.hist_views: Records the most useful information about a view that was relevant at the time of the event (see views table).
Name	Type	Description
id	integer	Primary key for this record.
view_id	integer	A foreign key reference to an entry in the views table. This could be NULL if the matching record in the views table was deleted since this record was created.
name	text	The name of the view.
repository_url	text	Uniquely identifies a view. More or less composed of workbook and sheet names, but not totally obviously, especially in the presence of non-ASCII characters. Used in URLs meant to access this view.
revision	text	Starts with 1.0 and increments by 0.1 with each republication.

public.hist_workbooks: Records the most useful information about a workbook that was relevant at the time of the event (see workbooks table).
Name	Type	Description
id	integer	Primary key for this record.
workbook_id	integer	A foreign key reference to an entry in the workbooks table. This could be NULL if the matching record in the workbooks table was deleted since this record was created.
name	text	The name of the workbook.
repository_url	text	A unique name for the workbook, derived from the ASCII characters in the name, which can be used in URLs to refer to this workbook.
size	bigint	The number of bytes used in storing the workbook information.
revision	text	Starts with 1.0 and increments by 0.1 with each republication.

public.historical_disk_usage: Records historical disk utilization by Tableau Server for storage monitoring.
Name	Type	Description
id	integer	Primary key for this record.
worker_id	character varying	Hostname of the worker the resource exists on.
resource_type	integer	Type of resource being monitored. 0 (Entire disk).
path	character varying	Disk path of the monitored resource.
total_space_bytes	bigint	Total disk size in bytes.
used_space_bytes	bigint	Disk space used by the resource in bytes.
state	integer	Free space state of the disk. One of 1 (Normal), 2 (Warning), 3 (Critical).
record_timestamp	timestamp without time zone	The time at which this record was created.

public.historical_event_types: The types of historical events which can be recorded.
Name	Type	Description
type_id	integer	Primary key for this record.
name	text	The name of the specific event that occurred.
action_type	text	Events are grouped together into action types, such as Create, Access, Update and Delete.

public.historical_events: This table is the heart of the cluster of tables devoted to historical event auditing. For each event, a record is created on this table. The type of event is indicated through historical_event_type_id, which links to the historical_event_types table. Other information relevant to the event is linked through some of the other id fields in this table. Note these links go to other hist* tables, which allows the event to refer to things that might have since been deleted from the regular tables.
Name	Type	Description
Foreign key/Primary key relation from historical_event_type_id on this table to type_id on table, public.historical_event_types
id	integer	Primary key for this record.
historical_event_type_id	integer	A foreign key reference to an entry in the historical_event_types table.
worker	text	The name or IP address of the worker where the event occurred.
is_failure	boolean	Indicates if the event was an attempted action that failed. May not be implemented across all events.
details	text	Detail text about the event.
created_at	timestamp without time zone	Datetime that the event was recorded.
hist_actor_user_id	integer	A reference to the primary key id column for the record in the hist_users table of the user who initiated the event.
hist_target_user_id	integer	A reference to the primary key id column for the record in the hist_users table of the user who was the target of the event.
hist_actor_site_id	integer	A reference to the primary key id column for the record in the hist_sites table where the event was initiated.
hist_target_site_id	integer	A reference to the primary key id column for the record in the hist_sites table which was the target of the event.
hist_project_id	integer	A reference to the primary key id column for a record in the hist_projects table.
hist_workbook_id	integer	A reference to the primary key id column for a record in the hist_workbooks table.
hist_view_id	integer	A reference to the primary key id column for a record in the hist_views table.
hist_datasource_id	integer	A reference to the primary key id column for a record in the hist_datasources table.
hist_comment_id	integer	A reference to the primary key id column for a record in the hist_comments table.
hist_tag_id	integer	A reference to the primary key id column for a record in the hist_tags table.
hist_group_id	integer	A reference to the primary key id column for a record in the hist_groups table.
hist_licensing_role_id	integer	A reference to the primary key id column for a record in the hist_licensing_roles table.
hist_schedule_id	integer	A reference to the primary key id column for a record in the hist_schedules table.
hist_task_id	integer	A reference to the primary key id column for a record in the hist_tasks table.
hist_data_connection_id	integer	A reference to the primary key id column for a record in the hist_data_connections table.
hist_config_id	integer	A foreign key reference to the config_id column for a record in the hist_configs table.
hist_capability_id	integer	A reference to the primary key id column for a record in the hist_capabilities table.
hist_remote_agent_id	integer	A reference to the primary key id column for a record in the hist_remote_agents table.
hist_flow_id	integer	A reference to the primary key id column for a record in the hist_flows table.
hist_data_role_id	integer	A reference to the primary key id column for a record in the hist_data_roles table.
hist_database_id	integer	A reference to the primary key id column for a record in the hist_database_assets table.
hist_table_id	integer	A reference to the primary key id column for a record in the hist_table_assets table.
hist_column_id	integer	A reference to the primary key id column for a record in the hist_column_assets table.
hist_metric_id	integer	A reference to the primary key id column for a record in the hist_metrics table.
hist_published_connection_id	integer	A reference to the primary key id column for a record in the hist_published_connections table.
hist_collection_id	integer	A reference to the primary key id column for a record in the hist_collections table.
hist_flow_draft_id	integer	A reference to the primary key id column for a record in the hist_flow_drafts table.
hist_data_quality_indicator_id	integer	A reference to the primary key id column for a record in the hist_data_quality_indicators table.

public.http_requests: Each record represents a request received by Tableau Server.
Name	Type	Description
id	integer	Primary key for this table.
controller	character varying	The part of the application that received the request.
action	character varying	The action requested.
http_referer	character varying	The referrer.
http_user_agent	character varying	The agent string supplied by the client.
http_request_uri	text	The requested URI.
remote_ip	character varying	The client's IP address (from the perspective of the server).
created_at	timestamp without time zone	When this record was created.
session_id	character varying	The session with which the request is associated.
completed_at	timestamp without time zone	When the request was completed.
port	integer	The port on which the request was received.
user_id	integer	The user associated with the request.
worker	character varying	Which worker machine received the request.
status	integer	The status returned to the client.
user_cookie	character varying	The user cookie provided in the request.
user_ip	character varying	The IP address of the originator of the request.
vizql_session	text	The vizql session associated with this request.
site_id	integer	The site associated with the request.
currentsheet	character varying	Which sheet was being viewed.
flags_used	bigint	Integer representing the bitmap of feature flags used in the request.

public.hyper_data_update_jobs: Each record represents a data update job for a live-to-Hyper connection.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the data update job record.
job_id	integer	The background job id for the job.
object_id	integer	The ID of the parent workbook/datasource of the Hyper connection.
object_type	text	A string representing the type of object.
site_id	integer	The ID of the site associated with the job.
status	integer	The status of the operation.
sos_data_id	text	The identifier for the job data associated with the update.
job_data	json	Data needed to perform the update stored in a json format.
error_message	text	The error message associated with the job to be returned to the user.
created_at	timestamp without time zone	The time the record was created.
updated_at	timestamp without time zone	The time the record was last updated.

public.hyper_databases: Information about Hyper databases.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Auto-generated id from postgres; also the primary key for the table.
site_id	integer	Id of the site to which the database belongs.
name	text	Unique name of the database.
size	bigint	Size of the database in bytes.
created_at	timestamp without time zone	Timestamp when this record was created.
updated_at	timestamp without time zone	Same as created_at.

public.id__ad_identity_stores: Identities for Active Directory identity stores.
Name	Type	Description
Foreign key/Primary key relation from instance_id on this table to id on table, public.id__identity_store_instances
identity_uuid	uuid	Uuid of identity.
instance_id	integer	Instance identifier for identity store.
security_id	character varying	SID of identity in Active Directory.
sam_account_name	character varying	sAMAccountName of identity in Active Directory.
fqdn	character varying	Fully qualified domain name of Active Directory domain.
upn	character varying	userPrincipalName of identity in Active Directory.
external_id	character varying	Optional external identifier for identity.
created_at	timestamp without time zone	Creation time of record.
updated_at	timestamp without time zone	Last updated time of record.
guid	uuid	GUID of identity in Active Directory.

public.id__identity_store_instances: Instances of identity stores.
Name	Type	Description
Foreign key/Primary key relation from type_id on this table to id on table, public.id__identity_store_types
id	integer	Primary key for identity store instance.
type_id	smallint	Foreign key for type of identity store instance.
name	character varying	Machine consumable name for identity store instance.
display_name	character varying	Human consumable name for identity store instance.
created_at	timestamp without time zone	Creation time of record.
updated_at	timestamp without time zone	Last updated time of record.

public.id__identity_store_types: Types of identity stores.
Name	Type	Description
id	smallint	Primary key for identity store type.
name	character varying	Machine consumable name for identity store type.
display_name	character varying	Human consumable name for identity store type.
created_at	timestamp without time zone	Creation time of record.
updated_at	timestamp without time zone	Last updated time of record.

public.id__ldap_identity_stores: Identities for LDAP identity stores.
Name	Type	Description
Foreign key/Primary key relation from instance_id on this table to id on table, public.id__identity_store_instances
identity_uuid	uuid	Uuid of identity.
instance_id	integer	Instance identifier for identity store.
entry_uuid	uuid	EntryUUID of identity in LDAP.
distinguished_name	character varying	Normalized distinguished name of identity in LDAP.
external_id	character varying	Optional external identifier for identity.
created_at	timestamp without time zone	Creation time of record.
updated_at	timestamp without time zone	Last updated time of record.

public.id__local_identity_stores: Identities for Local identity stores.
Name	Type	Description
Foreign key/Primary key relation from instance_id on this table to id on table, public.id__identity_store_instances
identity_uuid	uuid	Uuid of identity.
instance_id	integer	Instance identifier for identity store.
username	character varying	Username for identity.
protected_password	character varying	Protected password for identity.
protected_password_bad_format	boolean	Set to true if protected password format unrecognized.
failed_login_attempts	integer	Integer that represents the number of failed attempts since the last successful login.
last_failed_login	timestamp without time zone	Date that represents the last time the user had an unsuccessful login.
force_password_update	boolean	Boolean that represents if we want to force a password reset on the user the next time it tries to log in.
last_password_update	timestamp without time zone	Date that represents the last time the user updated the password to the current value.
external_id	character varying	Optional external identifier for identity.
created_at	timestamp without time zone	Creation time of record.
updated_at	timestamp without time zone	Last updated time of record.

public.identity_based_activation_reporting: Login-based License Management (LBLM) - NOTE: For any custom vizzes or reporting, it is recommended instead to use the View identity_based_activation_admin_view. In this table each row contains important dates with regard to ATR Issuing and Login-based License Usage for a given User, Site, Device and Product combination.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	Primary Key generated by PostgreSQL.
iba_user_id	character varying	Generated Id for user for IBA Reporting
site_id	integer	(foreign key) Holds the primary key of the sites table. Allows site filtering to work on Admin Views.
device_fingerprint	character varying	Uniquely identifies device. Built/generated from umn.
product_type	character varying	Product being used at the client level.
host_name	character varying	Computer host name.
product_version	character varying	application/product version being used at the client level.
registration_first_name	character varying	Registered user first name
registration_last_name	character varying	Registered user last name
registration_email	character varying	Registered user email address
registration_date	timestamp without time zone	Date active key was registered.
client_user_name	character varying	Login/User name from the client level.
atr_expiration_date	timestamp without time zone	Expiration date of active key. NULL means permanent.
hardware_serial_number	character varying	Uniquely identifies company's hardware asset.
registration_custom_field	character varying	custom field from registration
machine_os	character varying	os_architecture
virtual_machine	boolean	is the machine virtual
atr_chain_id	character varying	ATR Chain Id
domain_information	character varying	Computer Active Directory domain.
date_atr_issued	timestamp without time zone	date-time the last time an ATR request returned from from the ATR Service SUCCESSFULLY for this user, device, product and site.
date_atr_failed	timestamp without time zone	date-time the last time an ATR request returned from from the ATR Service UNSUCCESSFULLY-(FAILED) for this user, device, product and site.
date_activated	timestamp without time zone	date-time the first time the user activated this product from this device for this site.
date_last_used	timestamp without time zone	date-time the last time the user used this product from this device for this site.
date_last_updated	timestamp without time zone	date-time the last time any of the event dates (date_...) were updated for a given user, productType, device and site.
server_user_name	character varying	Full user friendly name on the server level.
server_email	character varying	Email for user on the server level.
site_luid	character varying	Holds the site luid from the sites table.
user_role	character varying	DEPRECATED - Please use user_role in the VIEW identity_based_activation_admin_view instead. This column is no longer updated and will be deleted.

public.identity_based_activation_user_role_change: Login-based License Management (LBLM) - NOTE: For any custom vizzes or reporting, it is recommended instead to use the View identity_based_activation_admin_view. This table tracks site role creator changes for each given user on a given site.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
site_id	integer	The site ID of the User represented in this row.
user_luid	character varying	Unique ID for user from users table.
system_user_id	integer	Foreign Key to System User table.
system_user_name	character varying	Name of the user across all sites. Populated from system_users table.
date_creator_role_assigned	timestamp without time zone	Datetime user was assigned from a non-creator role to a creator role -- triggered from the users table.
date_creator_role_unassigned	timestamp without time zone	Datetime user was unassigned from a creator role to a non-creator role -- triggered from the users table.
site_role_id	integer	Foreign key to site_roles table to allow access to site_roles display_name.

public.language_prefs: Contains a listing of information about languages for which Tableau Server has been localized.
Name	Type	Description
language_id	character varying	A unique ASCII string identifier for the language.
display_name	character varying	The name of the language (in the language, itself).
display_order	integer	Governs the order in which these languages will appear when listed in the user interface.
help_link	text	Used in constructing help links, so that help can be presented in the appropriate language.
locale_id	character varying	A unique identifying string that corresponds to a locale with this language.

public.last_seen_user_notifications: This table stores the last seen notification time for each user.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the last seen notification entry.
user_id	integer	Identifier for the user.
last_seen_notification_time	timestamp without time zone	The latest created_at timestamp of the notifications that have already been seen by the user.
site_id	integer	Identifier for the site that the user belongs to.

public.lens_content_relationships: Represents the relationship between the lens and other content types.
Name	Type	Description
Foreign key/Primary key relation from lens_id on this table to id on table, public.lenses
id	bigint	Primary key for the record.
lens_id	integer	The id for identifying the lens entity.
content_type	text	Content types that are associated with the lens.
content_id	integer	content_id is the unique identifier for the corresponding content-type.

public.lens_datasource_associations: Represents the association between the lens and the source datasources for a lens.
Name	Type	Description
Foreign key/Primary key relation from lens_id on this table to id on table, public.lenses
Foreign key/Primary key relation from published_datasource_id on this table to id on table, public.datasources
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	Primary key for the record.
lens_id	integer	The luid for identifying the lens.
site_id	integer	The id of the site on which the lens is created
published_datasource_id	integer	The id of the published datasource on the site

public.lens_fields: Table to store fields associated with lenses
Name	Type	Description
Foreign key/Primary key relation from lens_id on this table to id on table, public.lenses
Foreign key/Primary key relation from published_datasource_id on this table to id on table, public.datasources
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	Primary key for the record.
lens_id	integer	The id for identifying the lens.
site_id	integer	The id of the site on which the lens is created
published_datasource_id	integer	The id of the datasource to which the field belong
graph_id	text	The unique graph id of the field
status	text	Status indicator of the field. For example Displayed, Hidden etc
created_at	timestamp with time zone	Timestamp at which the record was created
updated_at	timestamp with time zone	Timestamp at which the record was updated

public.lenses: Represents the table for storing lenses.
Name	Type	Description
Foreign key/Primary key relation from owner_id on this table to id on table, public.users
Foreign key/Primary key relation from project_id on this table to id on table, public.projects
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	Id is the primary key for the record.
luid	uuid	luid for uniquely identifying a record within a site.
site_id	integer	The site id this lens is created in.
owner_id	integer	The owner id identifies the current owner of the lens.
created_at	timestamp with time zone	Timestamp at which the record was created
updated_at	timestamp with time zone	Timestamp when the record was last updated at.
index_version_number	text	Index version number at which the lens is indexed to.
name	text	name of the lens
description	text	description of the lens
project_id	integer	project to which the lens belong
repository_url	text	The repository url for lens.

public.licensing_roles: Lists the various possible licensing scenarios. (Unlicensed, Guest, Viewer, or Interactor).
Name	Type	Description
id	integer	Primary key for the record.
name	character varying	The name of the licensing role.
rank	integer	Used to provide an order of increasing rights.
licensing_roles_count	integer	Count of used licensing roles.

public.local_names: Contains translations of certain words or phrases that are relevant to some Tableau Server database constructs.
Name	Type	Description
id	integer	Primary key for the record.
language_id	character varying	Abbreviation for a particular language.
obj_name	character varying	A string that uniquly represents the object to be translated. This name, by convention, is very similar, if not identical to the name field for English.
obj_type	character varying	The type of the object. For example, "Project" or "Site".
name	character varying	How to call this object in the specified language, as given by language_id.

public.materialize_views_job_sos_directory: Each row in the table is a mapping of a workbook id and revision in a materialize views job to the sos directories that the job requires.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
workbook_id	integer	ID of the workbook whose query results in this materialized view. This id is same as the id (primary key) of the public.workbooks table in the database.
workbook_revision	text	Revision of the workbook whose id is the workbook_id column.
materialized_query_directory_sos_id	text	id of the directory in sos that contains the queries that are materialized.
site_id	integer	Site ID of the materialize_views_job_sos_directory.

public.materialized_views: This table stores the materialized views for queries in workbooks.
Name	Type	Description
Foreign key/Primary key relation from materialized_view_connection_id on this table to id on table, public.materialized_views_connections
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Auto-generated id from postgres; also the primary key for the table.
workbook_id	integer	ID of the workbook whose query results in this materialized view. This id is same as the id (primary key) of the public.workbooks table in the database.
workbook_revision	text	Revision of the workbook whose id is the workbook_id column.
materialized_query_file_name	text	Name of the file that stores the materialized query in sos.
table_name	text	Name of the table storing the materialized view of the query.
materialized_query_directory_sos_id	text	id of the directory in sos that contains the queries that are materialized.
materialized_view_connection_id	integer	ID (foreign key from materialized view connection table) of the connection that stores the materialized view
materialized_view_expiration_time	timestamp without time zone	Timestamp at which the view is considered obsolete and becomes a candidate for removal by MaterializedViewService.garbageCollector.
elapsed_query_seconds	real	Total elapsed time (in seconds) for the query.
materialized_query_result_size_lower_bound_bytes	bigint	materialized query result size without indrect referenced values(such as string).
materialized_query_result_size_upper_bound_bytes	bigint	materialized query result size with indrect referened values (such as string).
materialization_job_created_at	timestamp without time zone	Stores the timestamp at which the materialization job was created
query_view_bitmap	bytea	Bitmap to store a mapping of all the views that use the query
query_hash	numeric	unsigned 64 bit hash of the materialized logical query.
query_hash_string	character varying	string representation of hash of the materialized logical query.
query_execution_timestamp	timestamp without time zone	Timestamp when query is executed in a materialization job.
site_id	integer	Site ID of the materialized_views.

public.materialized_views_bloom_filters: This table stores the bloom filters indicating materialized sites/workbooks.
Name	Type	Description
bloom_filter_type	smallint	Type of this bloom filter
update_timestamp	timestamp without time zone	Timestamp when the bloomfilter is updated.
serialized_bloom_filter	bytea	Serialized bloom filters.
stale	boolean	Flag to indicate whether or not we need to rebuild the bloom filter.

public.materialized_views_connections: This table stores the information required to fetch materialized views files from the server where they are stored.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the table.
materialized_views_directory_sos_id	text	Id of the sos directory in which the materialized views are contained.
datasource_name	text	Name of the data source against which we run the query to generate the materialized view.
serialized_source_connection_attributes	text	Serialized connection attributes for the source datasource connection from which the materialized views are created.
serialized_materialized_view_connection_attributes	text	Serialized connection attributes to connect to the datasource storing the materialized views.
logical_query_cache_key_xml	text	XML containing the datasource columns that is used for generating the cache key for logical query cache. This is known as relationXML in parts of the code.
encryption_key_id	character varying	If not null, the ID of materialized views encryption key (KEK).
site_id	integer	If not null, ID of the site, is same as (not fkey of) the id (primary key) of the public.sites table.

public.materialized_views_metadata: This table stores the metadata for the materialized view service.
Name	Type	Description
key	character varying	The key name of the metadata
value	character varying	The value of the metadata

public.materialized_views_object_status: This table stores the materialized views state configuration for objects for which the feature is enabled.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from object_id on this table to id on table, public.workbooks
site_id	integer	ID of the site. This id is same as the id (primary key) of the public.sites table.
object_id	integer	ID of the object (workbook or flow).
state	smallint	A small int representing the current state of the materialized views for the site (and workbook if it is not null).
change_timestamp	timestamp without time zone	Timestamp of the last change made to the record.
id	integer	auto generated integer primary key.
sheet_stats	character varying	the stats of materialized views for worksheets.

public.materialized_views_sheet_status: This table stores the materialized views state configuration for worksheets for which the feature is enabled.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from view_id on this table to id on table, public.views
Foreign key/Primary key relation from workbook_id on this table to id on table, public.workbooks
id	integer	Auto-generated id from postgres; also the primary key for the table.
site_id	integer	ID of the site. This id is same as the id (primary key) of the public.sites table.
workbook_id	integer	ID of the workbook. This id is same as the id (primary key) of the public.workbooks table.
view_id	integer	ID of the worksheet. This id is same as the id (primary key) of the public.views table.
state	smallint	A small int representing the current state of the materialized views for the worksheet.
change_timestamp	timestamp without time zone	Timestamp of the last change made to the record.
sheet_stats	text	the stats of materialized views for the worksheet.

public.mentions: Mentions for comments.
Name	Type	Description
Foreign key/Primary key relation from comment_id on this table to id on table, public.comments
id	integer	Primary key for the record.
comment_id	integer	A foreign key reference to the comment that the mention is attached to.
target_type	character varying	The type of the mention target.
target_id	integer	The id of the target.
site_id	integer	The ID of the site the mentions belong to.

public.metric_metrics_aggregations: Each record represents a partial aggregation of analytics for a given metric in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.
Name	Type	Description
Foreign key/Primary key relation from metric_id on this table to id on table, public.metrics
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
metric_id	integer	A foreign key reference to the metric.
day_index	integer	Records what day of the month the analytics are aggregated over. When 0, the aggregation is for the month and year as designated by month_index and year_index.
month_index	integer	Records what month of the year the analytics are aggregated over. When 0, the aggregation is for the year as designated by year_index.
year_index	integer	Records what year the analytics are aggregated over
view_count	integer	Records the number of times a metric was viewed in the given time interval.
site_id	integer	The ID of the site the metric metrics aggregation belong to.

public.metrics: Each record represents a Metric.
Name	Type	Description
Foreign key/Primary key relation from customized_view_id on this table to id on table, public.customized_views
Foreign key/Primary key relation from dataalert_id on this table to id on table, public.data_alerts
Foreign key/Primary key relation from datasource_id on this table to id on table, public.datasources
Foreign key/Primary key relation from owner_id on this table to id on table, public.users
Foreign key/Primary key relation from project_id on this table to id on table, public.projects
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from view_id on this table to id on table, public.views
Foreign key/Primary key relation from workbook_id on this table to id on table, public.workbooks
id	integer	Primary key.
name	character varying	A descriptive name.
luid	uuid	A unique, immutable identifier within a site.
owner_id	integer	The last publisher.
project_id	integer	The associated project.
site_id	integer	The associated site.
created_at	timestamp without time zone	The time the record was created, in UTC.
description	text	A user-supplied description.
embedded	text	The encrypted keychain with credentials.
asset_key_id	integer	The asset encryption key used to encrypt the keychain in the embedded column.
updated_at	timestamp without time zone	The time the record was updated.
datasource_id	integer	The datasource from which the metric queries its data.
dataalert_id	integer	The data alert from which the metric queries its data.
workbook_id	integer	The workbook from which the metric queries its data.
view_id	integer	The view within the workbook specified by workbook_id.
last_scheduled_at	timestamp without time zone	The last time a refresh for this Metric was scheduled
last_refreshed_at	timestamp without time zone	The last time a Metric's data was refreshed successfully
incomplete_refresh_attempts	integer	The amount of incomplete attempts to refresh this Metric
customized_view_id	integer	The ID of the customized view the metric was created on.
suspend_state	integer	0: metric is not suspended, 1: metric was auto-suspended, 2: metric was manually suspended.
connected_view_path	character varying	The connected view path for the metric
connected_view_name	character varying	The connected view name for the metric

public.metrics_definition: Each record represents a metrics definition.
Name	Type	Description
id	uuid	Primary key for the record.
metric_luid	uuid	Metric unique identifier
site_luid	uuid	An identifier which is unique to the site
created_at	timestamp without time zone	Timestamp when this metric definition is created
metric_definition	bytea	Definition of the metric

public.metrics_snapshot: Each record represents a metrics snapshot.
Name	Type	Description
Foreign key/Primary key relation from metric_view_id on this table to id on table, public.metrics_view
id	uuid	Primary key for the record.
metric_view_id	uuid	An identifier for metric view
client_timestamp	timestamp without time zone	Timestamp when this metric snapshot is created on client
server_timestamp	timestamp without time zone	Timestamp when this metric snapshot is created on server
site_luid	uuid	An identifier which is unique to the site

public.metrics_snapshot_delta: Each record represents a metrics snapshot delta.
Name	Type	Description
Foreign key/Primary key relation from metric_view_id on this table to id on table, public.metrics_view
id	uuid	Primary key for the record.
metric_view_id	uuid	An identifier for metric snapshot
delta_timestamp	timestamp without time zone	Timestamp when this metric snapshot delta is created
process_key	character varying	Process Key for this metric snapshot delta
data	bytea	Data for metric snapshot delta
site_luid	uuid	An identifier which is unique to the site

public.metrics_view: Each record represents a metrics view.
Name	Type	Description
id	uuid	Primary key for the record.
metric_luid	uuid	An identifier which is unique to the metric definition
site_luid	uuid	An identifier which is unique to the site
name	character varying	Name of the metric view
created_at	timestamp without time zone	Timestamp when this metric view is created
columns	bytea	Metrics columns blob

public.most_recent_refreshes: most recent refresh data for alerts
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
historical_event_type_id	integer	historical event type of the refresh
worker	text	worker executing refresh
duration_in_ms	integer	duration of refresh
details	text	details of refresh
task_id	integer	task id
site_id	integer	site id
data_connection_id	integer	data connection id
is_failure	boolean	whether or not refresh failed
created_at	timestamp without time zone	when refresh occurred
workbook_id	integer	workbook being refreshed
datasource_id	integer	datasource being refreshed
has_retry_job	boolean	Indicator for refresh job in background job table, if there is pending/running refresh job, the value is true.

public.most_recent_subscription_runs: most recent subscription runs data for suspend subscriptions
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from subscription_id on this table to id on table, public.subscriptions
subscription_id	integer	subscription id
details	text	details of subscription run in plain text
completed_at	timestamp without time zone	The time at which the subscription job was last completed and this record was last updated or created
site_id	integer	The ID of the site the subscription belongs to.

public.mru_list_entries: Holds most recently used list entries. The records here are linked to the lists to which they belong. Those lists are defined in the mru_lists table.
Name	Type	Description
Foreign key/Primary key relation from mru_list_id on this table to id on table, public.mru_lists
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
mru_list_id	integer	A foreign key reference to the mru_list record to which this item belongs.
useable_id	integer	A kind of "polymorphic" foreign key reference. It contains the id of the item to which this entry refers. Look for it in the table indicated by the useable_type field.
useable_type	character varying	One of "User" "View" "Project" "Workbook" or "Tag". Indicates the type of item that this is.
position	integer	When the items are shown in order, this field defines that order.
used_at	timestamp without time zone	The last time at which the item referred to by this entry was accessed.
usedobj_name	text	The name of the item referred to by this entry.
usedobj_url	text	A URL-like identifier for the item referred to by this entry.
site_id	integer	The ID of the site the MRU list entry belong to.

public.mru_lists: Most recently used lists by user. The actual list contents are in the mru_list_entries table.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from user_id on this table to id on table, public.users
id	integer	Primary key for the record.
user_id	integer	A foreign key reference to the user who is associated with this list.
list_type	character varying	One of "users" "views" "projects" "workbooks" or "tags".
site_id	integer	The ID of the site the MRU list belong to.

public.next_gen_permissions: This table provides a flexible means of describing which users and groups have been granted which capabilities, on which things. Be aware that permissions is a complex topic and that this table does not contain all relevant information about permissions. For example, some permissions are given, automatically, to owners of workbooks or projects.
Name	Type	Description
Foreign key/Primary key relation from capability_id on this table to id on table, public.capabilities
id	integer	Primary key for the record.
authorizable_type	character varying	Describes the type of thing for which permissions are being specified. Must be one of "Project" "Workbook" "Datasource" "View" or "NamedResource".
authorizable_id	integer	The id value of the thing for which permissions are being specified. So, for example, if authorizable_type were "Workbook" then authorizable_id would correspond to the id value of the workbook in question.
grantee_id	integer	Refers to either the id of the "users" table or the id of the "groups" table depending on the value of grantee_type.
grantee_type	character varying	Permissions can be assigned to either users or groups, and this tells you which. Entry must be one of "User" or "Group".
capability_id	integer	Indicates which capability is to be granted or denied by this record. It is a foreign key link to the capabilities table where the corresponding record describes the nature of the capability in question.
permission	integer	An integer from 1 to 4 that combines whether the permission is applied to a user or to a group (which can also be seen from grantee_type) as well as whether this is granting or denying the capability. The meaning of the values is: 1: grant to group, 2: deny to group, 3: grant to user, 4: deny to user. Ascending order corresponds to increasing precedence. For example, a capability denied to a group (2) can be overriden by the same capability granted specifically to a user in that group (3).
site_id	integer	The ID of the site the permissions belong to.

public.nlp_suggested_questions: Suggested questions
Name	Type	Description
Foreign key/Primary key relation from lens_id on this table to id on table, public.lenses
Foreign key/Primary key relation from parent_group_id on this table to id on table, public.nlp_suggestion_groups
Foreign key/Primary key relation from published_datasource_id on this table to id on table, public.datasources
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	The unique identifier for this row that is automatically generated on insert
expression	text	Serialized and versioned expression
parent_group_luid	text	LUID of the question's parent group
sort_order	integer	The position at which the question should be displayed within its parent group
luid	text	The unique identifier for this row to be referenced by application code
site_id	integer	Site ID of datasource the question belongs to
published_datasource_id	integer	Datasource ID of datasource the question belongs to
interpretation_nlg	text	Human readable text of the suggested question
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
colloquial_alias	text	User-defined colloquial alias of a suggested question
parent_group_id	integer	ID of the parent suggestion group a question belongs to
lens_id	integer	id of the lens for which the suggestion is applicable

public.nlp_suggestion_groups: Suggested question groups
Name	Type	Description
Foreign key/Primary key relation from lens_id on this table to id on table, public.lenses
Foreign key/Primary key relation from published_datasource_id on this table to id on table, public.datasources
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	The unique identifier for this row that is automatically generated on insert
group_name	text	Name of the group of suggested questions
description	text	Description of the group of suggested questions
sort_order	integer	The position at which the group should be displayed relative to other groups
luid	text	The unique identifier for this row to be referenced by application code
site_id	integer	Site ID of datasource the suggestion group belongs to
published_datasource_id	integer	Datasource ID of datasource the suggestion group belongs to
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
lens_id	integer	id of the lens for which the suggestion group is applicable

public.oauth_clients: A map that register oauth CI/CS/redierctUri per site per dbclass.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
site_id	integer	Site where the oauth client applies to
db_class	character varying	The database class name this oauth client is used for.
instance_url	character varying	The instanceUrl for this oauth client, only used for oauth class supports multiple domain such as Snowflake. Can be null.
client_id	character varying	The clientId for this oauth client.
client_secret	text	The clientSecret for this oauth client.
asset_key_id	integer	The asset_key_id which cleintSecret is encrypted with.
redirect_uri	character varying	The redirectUri for this oauth client.
created_at	timestamp without time zone	The time when this oauthClient was created.
updated_at	timestamp without time zone	The time when this oauthClient was updated at.

public.oauth_request_tokens: Table of tokens used for OAuth authorization requests.
Name	Type	Description
id	integer	Primary key for the record.
entry_db_class	character varying	The connection class of the connection to which the token will belong.
entry_db_subclass	character varying	The connection subclass of the connection to which the token will belong
request_token	text	The request token which can be exchanged for an access token along with the request token secret.
request_token_secret_encrypted	text	The encrypted request token secret which can be exchanged for an access token along with the request token
is_used	boolean	Whether or not the request token/request token secret were exchanged for an access token or not.
created_at	timestamp without time zone	The time the record was created.
updated_at	timestamp without time zone	The time the record was last updated.
asset_key_id	integer	ID of key used to encrypt the token secret.

public.oauth_service_code_verifiers: Short lived storage for the code verifier used in PKCE requests.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	Primary key for the record.
luid	uuid	A unique, immutable identifier for the code verifier.
site_id	integer	Site where the code_verifier was created at
user_id	integer	User on the site requesting to authenticate with the code verifier.
db_class	character varying	The database class name this code_verifier is used for.
code_verifier	character varying	The authorization code verifier.
created_at	timestamp without time zone	The time when this code_verifier was created.
expires_at	timestamp without time zone	The time when this code_verifier expires, defalt per spec 1 min.
updated_at	timestamp without time zone	The time when this code_verifier was updated at.

public.password_tokens: Tokens issued to client through link in email which can be redeemed to change their password
Name	Type	Description
Foreign key/Primary key relation from system_user_id on this table to id on table, public.system_users
id	integer	Primary key identifier for row
guid	uuid	Unique identifier for token
salt	character varying	The salt is used to hash the password
hashed_secret	character varying	Secret portion of token thats been hashed
expires_at	timestamp without time zone	When the token becomes expired
system_user_id	integer	Reference to system user that requested the token

public.pdf_subscription_options: Used to store different PDF layout options.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from subscription_id on this table to id on table, public.subscriptions
id	integer	Primary key for this record.
pdf_page_size_option	character varying	Type of page size such as A4, letter etc
pdf_page_orientation	character varying	Orientation in which page should be rendered.
subscription_id	integer	ID of the subscription with these attachments options.
site_id	integer	The ID of the site to which this entry belongs.

public.pending_search_update_items: This table represents an item that is associated with a pending_search_update.
Name	Type	Description
Foreign key/Primary key relation from pending_search_update_id on this table to id on table, public.pending_search_updates
id	integer	Primary key for the pending search update item.
pending_search_update_id	integer	Primary key id for pending search update associated with the item.
item_id	integer	Primary key for the item. The type of the item is determined by the pending search update.

public.permission_reasons: When calculating effective permissions in the perm_users_*_capabilities functions, this table maps the integer precedence of the effective permission rule to the varchar effective permission reason. The integer precedence is internal to the stored procedures. The effective permission reason is returned to callers.
Name	Type	Description
precedence	integer	The integer precedence of an effective permission rule. Higher value means higher precedence. Used in the perm_users_*_capabilities functions.
reason	character varying	The external identifier for an effective permission rule. Returned by the perm_users_*_capabilities functions.

public.permission_set_classes: Represents a class of permission sets. Generally 1-to-1 with capabilities.
Name	Type	Description
id	integer	Primary key for the permission set class record.
name	character varying	The name of the permission set class.

public.permission_set_items: Represents a single next_gen_permission in a permission_set. The columns mirror the next_gen_permissions table.
Name	Type	Description
Foreign key/Primary key relation from capability_id on this table to id on table, public.capabilities
Foreign key/Primary key relation from permission_set_id on this table to id on table, public.permission_sets
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
grantee_id	integer	Refers to either the id of the "users" table or the id of the "groups" table depending on the value of grantee_type.
grantee_type	character varying	Permissions can be assigned to either users or groups, and this tells you which. Entry must be one of "User" or "Group".
capability_id	integer	Indicates which capability is to be granted or denied by this record. It is a foreign key link to the capabilities table where the corresponding record describes the nature of the capability in question.
permission	integer	An integer from 1 to 4 that combines whether the permission is applied to a user or to a group (which can also be seen from grantee_type) as well as whether this is granting or denying the capability. The meaning of the values is: 1: grant to group, 2: deny to group, 3: grant to user, 4: deny to user. Ascending order corresponds to increasing precedence. For example, a capability denied to a group (2) can be overriden by the same capability granted specifically to a user in that group (3).
permission_set_id	integer	The permission set this item is a part of.
site_id	integer	The site.

public.permission_sets: Represents a common set of permissions used by multiple authorizables.
Name	Type	Description
Foreign key/Primary key relation from permission_set_class_id on this table to id on table, public.permission_set_classes
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the permission set record.
permission_set_class_id	integer	The permission set class.
site_id	integer	The site id.
delete_if_unreferenced_after	timestamp without time zone	The earliest time it is safe to delete this permission_set if it is unreferenced by authorizable_permission_sets
permission_set_key	character varying	Hashcode representation of permission set class and grantees list capabilities.

public.permissions_templates: This table provides a flexible means of describing which users and groups will be granted which capabilities by default, on non-overwrite publishes of workbooks and datasources. Be aware that permissions is a complex topic and that this table does not contain all relevant information about permissions. For example, some permissions are given, automatically, to owners of workbooks or projects.
Name	Type	Description
Foreign key/Primary key relation from capability_id on this table to id on table, public.capabilities
id	integer	Primary key for the record.
template_type	character varying	Determines whether the permission template applies to workbooks or datasource. Value must be "Workbook" or "Datasource".
grantee_id	integer	Refers to either the id of the "users" table or the id of the "groups" table depending on the value of grantee_type.
grantee_type	character varying	Permissions can be assigned to either users or groups, and this tells you which. Entry must be one of "User" or "Group".
capability_id	integer	Indicates which capability is to be granted or denied by this record. It is a foreign key link to the capabilities table where the corresponding record describes the nature of the capability in question.
permission	integer	An integer from 1 to 4 that combines whether the permission is applied to a user or to a group (which can also be seen from grantee_type) as well as whether this is granting or denying the capability. The meaning of the values is: 1: grant to group, 2: deny to group, 3: grant to user, 4: deny to user. Ascending order corresponds to increasing precedence. For example, a capability denied to a group (2) can be overridden by the same capability granted specifically to a user in that group (3).
container_type	text	Type of container for which this permission template applies, possbile value are Database and Project.
container_id	integer	Identifies the container for which this permission template applies.
site_id	integer	The ID of the site the permission templates belong to.

public.pkce_tokens: Proof Key for Credential Exchange (RFC 7636) short-lived storage.
Name	Type	Description
Foreign key/Primary key relation from user_id on this table to id on table, public.users
id	bigint	Primary key for the record.
user_id	integer	A foreign key reference to the user.
authorization_code	bytea	The authorization code (RFC 7636).
code_challenge	bytea	The code challenge (RFC 7636).
code_challenge_method	character varying	The code challenge method (RFC 7636).
expires_at	timestamp with time zone	The time when this token expires.
redeemed_at	timestamp with time zone	The time when this token was redeemed.

public.projects: Each row of the table corresponds to a project on Tableau Server.
Name	Type	Description
Foreign key/Primary key relation from controlling_permissions_project_id on this table to id on table, public.projects
Foreign key/Primary key relation from owner_id on this table to id on table, public.users
Foreign key/Primary key relation from parent_project_id on this table to id on table, public.projects
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
name	character varying	The name of the project.
owner_id	integer	The id of the user who owns this project.
created_at	timestamp without time zone	The time at which this record was created.
updated_at	timestamp without time zone	The time at which this record was last changed.
state	character varying	If this is anything other than "active" then the project is inactive.
description	text	A textual description of the project.
site_id	integer	The site which contains this project.
special	integer	Has a value of 1 if this is a special system-created project (like the default project). Otherwise it is NULL.
luid	uuid	The locally unique ID, which is intended for exposing externally by the server API. This is automatically generated.
controlled_permissions_enabled	boolean	Indicates whether permissions on workbooks, views, and data sources are controlled at the project level.
parent_project_id	integer	Id of the parent project. NULL for top-level projects.
admin_insights_enabled	boolean	Indicates if project is a Admin Insights project
nested_projects_permissions_included	boolean	Indicates whether nested projects should be included when permissions are controlled or not controlled at the project level. Associated with controlled_permissions_enabled column
controlling_permissions_project_id	integer	The id of the ancestor project that is controlling the permissions for this project.

public.projects_contents: Table which stores the contents of projects
Name	Type	Description
Foreign key/Primary key relation from project_id on this table to id on table, public.projects
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	The id which uniquely identifies row in the table
project_id	integer	The project_id which identifies the project that the row is associated with
site_id	integer	The site_id which identifies the site that the row is associated with
content_id	integer	The id of the content being stored in the project denoted by project_id. With content_type uniquely identifies a piece of content.
content_type	character varying	The type of content being represented by the given row. Together with content_id uniquely identifies a piece of content

public.published_connection_extract_infos: Table contains user created extract info
Name	Type	Description
Foreign key/Primary key relation from published_connection_id on this table to id on table, public.published_connections
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Generated Id for published_connection_extract_infos table primary key
site_id	integer	Site where published connection revision created at
published_connection_id	integer	Foreign key to published_connection.id
extract_status_code	text	Status code of an extract info table. For example, completed, in progress or failed
active	boolean	Extract is active or not
status_updated_at	timestamp without time zone	when extract status got updated at
lock_version	integer	Latest version in record, used for optimistic locking
created_at	timestamp without time zone	First time created
updated_at	timestamp without time zone	Last time updated

public.published_connection_inflight_revision_tables: A table associated with a published connection revision. It can represent changes to an existing table or a new table.
Name	Type	Description
Foreign key/Primary key relation from published_connection_inflight_revision_id on this table to id on table, public.published_connection_inflight_revisions
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key.
luid	uuid	A unique, immutable identifier within a site.
site_id	integer	The associated site.
created_at	timestamp without time zone	First time created
updated_at	timestamp without time zone	Last time updated
lock_version	integer	Latest version in record, used for optimistic locking
published_connection_inflight_revision_id	integer	The associated revision.
original_table_luid	uuid	Unique UUID for the table this revised table originated from, if this represents an existing table.
database_name	text	Database name from physical database
schema_name	text	Schema name from physical database
alias	text	Table alias name (human descriptor)
qualified_name	text	Identifies the source physical table, used when querying it.
caption	text	Display name for the source physical table.

public.published_connection_inflight_revisions: Each record represents a Published Connection in-flight revision.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from published_connection_id on this table to id on table, public.published_connections
id	integer	Primary key.
luid	uuid	A unique, immutable identifier within a site.
site_id	integer	The associated site.
owner_id	integer	The user who created the published connection in-flight revision.
project_id	integer	The project to be associated when this in-flight revision is activated.
created_at	timestamp without time zone	The time the record was created, in UTC.
updated_at	timestamp without time zone	The time the record was updated, in UTC.
lock_version	integer	Latest version in record, used for optimistic locking
published_connection_id	integer	The associated published connection.
published_connection_luid	uuid	If this revision is based on a existing published connection: its luid, otherwise, the luid that will be saved as the new published connection's luid.
name	character varying	A descriptive name.
description	text	A user-supplied description.
connection_attributes	text	Blob of connection attributes: connection_type(mysql, postgres..), hostname, port, username, password, etc.
secured_values	text	encrypted message associated with the asset key
asset_key_id	integer	asset key id as in EncryptedAttribute

public.published_connection_tables: Table contains metadata info for tables and fields from the user created published_connection_database
Name	Type	Description
Foreign key/Primary key relation from published_connection_id on this table to id on table, public.published_connections
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Generated Id for published_connection_tables table primary key
site_id	integer	Site where published connection tables created at
luid	uuid	Generated unique UUID for published connection tables
database_name	text	Database name from physical database
schema_name	text	Schema name from physical database
alias	text	Table alias name (human descriptor)
lock_version	integer	Latest version in record, used for optimistic locking
created_at	timestamp without time zone	First time created
updated_at	timestamp without time zone	Last time updated
published_connection_id	integer	Foreign key to published_connection.id
qualified_name	text	Identifies the source physical table, used when querying it.
caption	text	Display name for the source physical table.

public.published_connections: Each record represents a Published Connection.
Name	Type	Description
Foreign key/Primary key relation from project_id on this table to id on table, public.projects
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key.
name	character varying	A descriptive name.
luid	uuid	A unique, immutable identifier within a site.
owner_id	integer	The user who creates the published connection.
project_id	integer	The associated project.
site_id	integer	The associated site.
created_at	timestamp without time zone	The time the record was created, in UTC.
updated_at	timestamp without time zone	The time the record was updated, in UTC.
description	text	A user-supplied description.
lock_version	integer	Latest version in record, used for optimistic locking
connection_attributes	text	Blob of connection attributes: connection_type(mysql, postgres..), hostname, port, username, password, etc.
secured_values	text	encrypted message associated with the asset key
asset_key_id	integer	asset key id as in EncryptedAttribute
revision_luid	uuid	LUID for revision record

public.querypolicycollection: Table to store query policy collections.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	Auto increment primary key.
luid	uuid	UUID of the policy collection.
site_luid	uuid	UUID of the site.
site_id	integer	Site Id to link to public.sites.
parent_resource	uuid	ID of the parent (e.g. a pconn revision).
parent_resource_type	character varying	Type of the parent.
payload	text	JSON blob representing the policy collection
update_version	integer	Field to facilitate optimistic concurrency check
created_at	timestamp without time zone	UTC time of record creation.
created_by	character varying	Identity of record creator.
updated_at	timestamp without time zone	UTC time that the record was updated last.
updated_by	character varying	Identity of a user who updated the record last.

public.recommendations_dismissed_views: Views dismissed by user in context of viz recommendations
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from user_id on this table to id on table, public.users
Foreign key/Primary key relation from view_id on this table to id on table, public.views
id	integer	Primary key for the record.
site_id	integer	Site Id associated with this dismissed view
user_id	integer	User Id of user that dismissed the view
view_id	integer	View Id that was dismissed by user
dismissed_at	timestamp without time zone	Time in Utc when the view was dismissed by user

public.recycle_bin_content_types: Content Type lookup table for Recycle Bin.
Name	Type	Description
id	integer	Auto incremented primary key.
content_type	character varying	Content type of the object in Recycle Bin.
sos_type	character varying	SOS Type for thumbnails of this content type

public.refresh_token_devices: Devices that have been issued at least one refresh token
Name	Type	Description
id	integer	Primary key identifier
device_id	character varying	Unique identifier of the device. Must be unique across all instances of the same installations of client applications. This is expected to stay the same through the lifetime of the application.
device_name	character varying	Friendly name of the device to be displayed
system_user_id	integer	Reference to the system user the token is issued to
last_used_at	timestamp without time zone	The last time the device redeemed the refresh token.

public.refresh_tokens: Tokens issued to clients which can be redeemed by the client for access to the server
Name	Type	Description
Foreign key/Primary key relation from refresh_token_device_id on this table to id on table, public.refresh_token_devices
id	integer	Primary key identifier
guid	uuid	Unique identifer of the refresh token
client_id	character varying	Unique identifier with which to associate to the refresh token series.
client_name	character varying	This column is no longer used and will be deleted once it will no longer be breaking an upgrade scenario
system_user_id	integer	Reference to the system user the token is issued to
expires_at	timestamp without time zone	When this token becomes expired. null means that it does not have absolute expiration time
last_used_at	timestamp without time zone	When the token was last redeemed for an access token
issued_at	timestamp without time zone	When this token was issued to the client
salt	character varying	The salt used when hashing the secret
hashed_secret	character varying	Secret portion of the token thats been hashed
session_id	character varying	The most current session that has been redeemed using this refresh token. Null if no sessions have been redeemed
refresh_token_device_id	integer	Reference to the device the token is issued to
next_hashed_secret	character varying	Secret portion of the token thats been hashed for the next refresh token
next_salt	character varying	The salt used when hashing the secret for the next refresh_token

public.remote_agents: Registry of remote agents (Online). Remote agents are programs installed on customer PC and executing tasks on a behalf of a customer. The first example of agent is Tableau Data Sync. It is running in background on customer desktop and performing automatic data source refreshes based on schedules defined by customers.
Name	Type	Description
Foreign key/Primary key relation from owner_id on this table to id on table, public.users
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
owner_id	integer	Foreign key reference to the user who owns this project.
site_id	integer	Foreign key reference to the site which contains this remote agent.
name	character varying	Name of the remote agent. Usually agent computer name. This name must be unique for a specific site/user. Different users can have same agent (for example of shared computer).
time_zone_id	character varying	String identifier of agent's time zone. Time zone is specified during registration and can be changed later. Time zone ID is full name such as "America/Los_Angeles". It should be accepted by Java method java.util.TimeZone.getTimeZone(java.lang.String).
schedules_synced_at	timestamp without time zone	UTC time of last agent synchronization of schedules with the server. Time is the recorded server time.
device_id	character varying	ID generated by client and also given to the Refresh Token Service. Otherwise, one is randomly generated.
concurrent_live_operations_allowed	integer	Number of concurrent live operations allowed on a remote agent.
capacities	text	The capacities that this remote agent exhibits, e.g. LiveQueryAlpha, LiveQueryBeta, LiveQueryV1
pooled	boolean	If part of the site pool to handle shared work.
version	character varying	The version of the remote agent.

public.repository_data: This table forms the link between other tables that need to store "large object" data, and the large object storage, itself.
Name	Type	Description
Foreign key/Primary key relation from sos_blob_data_id on this table to id on table, public.sos_blob_data
id	bigint	Primary key for the record.
name	text	A possibly useful string that is mostly here to make it easier to debug.
content	oid	An oid field that references the corresponding data stored in the pg_largeobject system table. Be aware pg_largeobject is not accessible by the "tableau" or "readonly" users.
created_at	timestamp without time zone	The time at which this record was created.
tracking_id	character varying	Unique ID used to track the repository data.
type	character varying	Simple Object Storage type.
kind	character varying	Kind of data in content; file or folder.
sos_blob_data_id	bigint	foreign key referencing sos_blob_data.id

public.resource_holder_types: Information about entities which can hold on to resources. For instance workbook is such an entity, it can reference a geocoding database and keep it alive.
Name	Type	Description
id	smallint	Unique numeric id of the type. This value is used as the value of resource_usage.resource_holder_type column.
name	text	Unique name of the type, used in the code to identify the particular resource holder type.
description	text	Description of the type.

public.resource_types: Information about resources which are used by some server entities. For instance geocoding databases are such resources, a workbook can reference a geocoding database and keep it alive.
Name	Type	Description
id	smallint	Unique numeric id of the type. This value is used as the value of resource_usage.resource_type column.
name	text	Unique name of the type, used in the code to identify the particular resource type.
description	text	Description of the type.

public.resource_usage: Information about resources by tableau server entities, for example which geocoding databases are used by which workbooks.
Name	Type	Description
Foreign key/Primary key relation from resource_holder_type on this table to id on table, public.resource_holder_types
Foreign key/Primary key relation from resource_type on this table to id on table, public.resource_types
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Auto-generated id from postgres; also the primary key for the table.
resource_holder_type	smallint	Type of the entity which references the resource. Values correspond to the values in the resource_holder_type.id column.
resource_holder_id	integer	ID of the entity for which this entry was created. The meaning of the ID depends on the resource_holder_type value. For instance, for workbooks it is the workbook ID
resource_type	smallint	Type of the resource, e.g. geocoding database. Values correspond to the values in the resource_type.id column.
resource_id	integer	ID of the resource. The meaning of the ID depends on the resource_type value. For instance, for geocoding databases it is the id from the geocoding table.
created_at	timestamp without time zone	Timestamp when this record was created.
updated_at	timestamp without time zone	Same as created_at.
site_id	integer	Site ID of the resource.
resource_name	text	Optional resource name, for debugging and logging.

public.roles: This table contains records corresponding to various classifications of users. It should really be viewed in conjuction with the capabilities and capability_roles tables. Taken together, these tables associate different roles with different sets of capabilities. The capabilities sets serve as templates when creating content.
Name	Type	Description
id	integer	Primary key for the record.
name	character varying	Each role has a name by which it is known to program code. Examples include, viewer, editor, interactor, ds_editor, etc.
created_at	timestamp without time zone	The time at which this record was created.
updated_at	timestamp without time zone	The time at which this record was last changed.
creator_id	integer	Links to the user who created this record, or is NULL. Not a significant value.
displayable	boolean	Used to distinguish between records that can be displayed in the GUI and those that cannot.
administrative	boolean	Roles are categorized as administrative in nature, or not. This field is used for filtering.
display_order	integer	Ascending order of this value is the order in which roles are listed, when displayed.
display_name	character varying	This is the name for the role, which will be displayed to the user.

public.saml_assertions_metadata: Records for the saml assertions
Name	Type	Description
id	bigint	Primary key for the record.
assertion_id	character varying	Saml assertion id.
idp_entity_id	character varying	IdP entity id URI.
expires_at	timestamp without time zone	The time saml assertion expires. Null indicates no expiration time

public.schedules: Records in this table define a schedule according to which certain regular tasks may be performed (see tasks table). They also indicate the next time at which the schedule will be triggered.
Name	Type	Description
id	integer	Primary key for the record.
name	character varying	A schedule can be given a name, which is stored here.
active	boolean	If set to false, this means that the schedule is inactive, meaning that no tasks will be performed when the schedules triggers.
priority	integer	Priority can range from 1 to 100, with lower values corresponding to higher priority.
schedule_type	integer	One of 0 (Hourly), 1 (Daily), 2 (Weekly), 3 (Monthly).
day_of_week_mask	integer	Indicates which day of the week this schedule will run. The information is encoded in the given integer. To interpret it, convert the integer to binary. The days of the week correspond to Sunday : 1, Monday : 10, Tuesday : 100, Wednesday : 1000, Thursday : 10000, Friday : 100000, Saturday : 1000000.
day_of_month_mask	integer	Indicates which day of the month this schedule will run. The information is encoded in the given integer. To interpret it, convert the integer to binary. The days of the month correspond to 1st : 1, 2nd: 10, 3rd: 100, 4th: 1000, 5th: 10000, etc.
start_at_minute	integer	The minute following the start of the designated time period implied by the schedule_type. For example, for a daily schedule, this would be number of minutes past midnight at the start of the day. For hourly, it would be the number of minutes past the beginning of the hour.
minute_interval	integer	Once the schedule triggers, it will retrigger at this interval during the time period implied by the schedule_type or until end_at_minute, or end_schedule_at.
end_at_minute	integer	The minute following the start of the designated time period implied schedule_type, at which the schedule should stop triggering.
end_schedule_at	timestamp without time zone	Used to indicate a point in time, after which the schedule should never trigger.
run_next_at	timestamp without time zone	When the schedule will next trigger.
created_at	timestamp without time zone	The time at which this record was created.
updated_at	timestamp without time zone	The last time any changes were made to this record.
hidden	boolean	If set to true, then this schedule will not be listed in the GUI, otherwise it will be.
serial_collection_id	integer	A foreign key to the serial_collections table. Two jobs with the same serial_collection_id cannot be processed simultaneously. When the job record for a task linked to this schedule is created, it is assigned this serial_collection_id.
lock_version	integer	Used to implement "optimistic locking" by JPA/Hibernate. The counter increases each time the record is changed. Not useful for customers.
scheduled_action	integer	Used to classify schedules into categories: 0 (Extracts), 1 (Subscriptions), 2 (Sync AD users and groups), 3 (Auto Refresh Extracts), 4 (Flows)
luid	uuid	uuid for schedules used in the REST API
defined_by	integer	The mechanism type of how the schedule is created, e.g. 0 for system_admin, 1 for self_service.
timezoneid	text	The IANA timezoneid for the schedule when it is created i.e. America/Los_angeles

public.schema_migrations: This table tracks which database migrations have been applied to this database.
Name	Type	Description
version	character varying	A string, derived from the name of the migration file, which serves to identify a particular migration that has been applied.

public.semantics_service_data_source_events: Stores the last data source event processed by semantics service
Name	Type	Description
id	integer	The unique identifier for this row that is automatically generated on insert
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
last_enqueued_id	bigint	The ID of the event that is last processed by semantics service
processing_node	text	The ID of the semantics service node that is currently processing the events. If the field is empty, no semantics service node is currently processing events.

public.serial_collections: Records in this table represent groups of background jobs that should not be run simultaneously.
Name	Type	Description
id	integer	The primary key for the record.
description	character varying	Whoever creates the serial collection can decide what they want this description to say.
created_at	timestamp without time zone	The time at which this record was created
updated_at	timestamp without time zone	The last time any changes were made to this record.

public.server_scoped_metadata_node_properties: Table to store properties of a node.
Name	Type	Description
id	integer	Auto increment primary Key.
node_id	character varying	Id of a node present in graph.
content_type	character varying	Content type of a node present in graph.
property_name	character varying	Name of a property for a node present in graph.
property_value	text	Value of a property for a node present in graph.
created_at	timestamp without time zone	Timestamp when property is created.
updated_at	timestamp without time zone	Timestamp when property is updated.

public.sessions: Settings associated with a user's browser session.
Name	Type	Description
Foreign key/Primary key relation from initiating_user_id on this table to id on table, public.users
id	integer	The primary key for the record.
session_id	character varying	Session identifier.
data	text	Serialized session data.
updated_at	timestamp without time zone	Time when session was last updated, used to expire inactive sessions.
user_id	integer	Foreign key to users table
shared_wg_write	text	Settings used by wgserver (language/country preference etc).
shared_vizql_write	text	Settings used by vizql server.
site_id	integer	A foreign key to the sites table. Indicates the site to which this session belongs.
created_at	timestamp without time zone	A timestamp without timezone indicating how long ago the session was created
lock_version	integer	Used to implement "optimistic locking." Don't set this or mess with it, it's all handled automatically.
salt	character varying	The salt used when hashing the secret.
hashed_secret	character varying	Secret portion of the token thats been hashed.
oauth_state	text	The OAuth request state, will be verified later to prevent CSRF attack.
initiating_user_id	integer	the id of site user initiating logging in. Can be an admin impersonating (acting on behalf of) the other user. Or the site user self in case or regular log in

public.share_actions: Table storing share actions.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
sharer_id	integer	UserId of the sharer (if not deleted). Backed up id (if deleted). Product spec: sharing action is not cascade deleted with sharer.
was_sharer_deleted	boolean	If sharer was deleted. False (regular user). True (name backed up for historical reason)
site_id	integer	The ID of the site where content was shared.
message	character varying	Sharers message to recipients. Max char count by PM spec is 500.
created_at	timestamp without time zone	Share action creation timestamp.

public.share_contents: Table storing shared content (view/workboook/etc).
Name	Type	Description
Foreign key/Primary key relation from share_action_id on this table to id on table, public.share_actions
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
share_action_id	integer	Share action ID which was used to share this content.
content_id	integer	Shared content ID. Note: depending on "content_type" can be ID of different content.
content_type	character varying	Shared content type.
site_id	integer	The ID of the site where content was shared.

public.share_deleted_sharers: Table storing deleted sharers backed up details (e.g. name). Needed because we do not cascade delete sharing action after sharer was deleted.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
name	character varying	Name for deleted sharer. Backed up from system_users.name.
friendly_name	character varying	Friendly name for deleted sharer. Backed up from system_users.friendly_name.
site_id	integer	The ID of the site where content was shared by sharer.

public.share_recipients: Table storing share recipients (users/groups/etc).
Name	Type	Description
Foreign key/Primary key relation from share_action_id on this table to id on table, public.share_actions
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
share_action_id	integer	Share action ID which was used to share this content.
site_id	integer	The ID of the site where content was shared.
recipient_id	integer	Recipient ID whom this content was shared with. Note: depending on "recipient_type" can be ID of different recipients.
recipient_type	integer	Recipient type (e.g. "USER", "GROUP").

public.share_single_user_options: Table storing single user options on shared content (does not change the content itself).
Name	Type	Description
Foreign key/Primary key relation from single_user_id on this table to id on table, public.users
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
content_id	integer	Content ID on which user set a custom option.
content_type	character varying	Content type on which user set a custom option.
site_id	integer	The ID of the site where content was shared.
single_user_id	integer	User ID who set a custom option.
single_user_option_value	integer	Value of some certain option a user has set.
single_user_option_type	integer	Option type a user has set on a shared content.

public.sheet_images: Serves as a cache for all the sheet images generated by server.
Name	Type	Description
Foreign key/Primary key relation from customized_view_id on this table to id on table, public.customized_views
Foreign key/Primary key relation from generated_as_user_id on this table to id on table, public.users
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from view_id on this table to id on table, public.views
id	integer	Primary key for the record.
width	integer	The port size (width) used to generate the image.
height	integer	The port size (height) used to generate the image.
pixel_ratio	real	The pixel ratio used to generate the image.
view_id	integer	A foreign key reference to the view used to generate the image.
language_id	character varying	A code indicating the language used to generate the image.
locale_id	character varying	A code indicating the locale used to generate the image.
generated_at	timestamp without time zone	A timestamp indicating when the image was generated.
data_storage_id	bigint	A reference to an entry in the repository_data table, which, in turn references the PostgreSQL large object that contains the sheet image for this entry.
generated_as_user_id	integer	A foreign key reference to the user the image was generated as. Can be null if the image was not generated as any user in particular.
customized_view_id	integer	A foreign key reference to the customized view that the image was generated as. Can be null if the image was not generated with a customized view.
cropped_height	integer	Indicates how many pixels were vertically cropped off of the generated image.
cropped_width	integer	Indicates how many pixels were horizontally cropped off of the generated image.
freshness_verified_at	timestamp without time zone	This date represents a point in time at which this sheet image is considered to be fresh.
data_id	character varying	Unique ID used to identify the image.
show_commands_query_str	text	Represents hash of the possible show commands to be applied to the viz in the native api code.
file_type	integer	The file type. 0 for Image, 1 for Pdf
page_orientation	integer	PDF page orientation
page_size_option	integer	PDF page size option
site_id	integer	The ID of the site to which this entry belongs.

public.site_logos: custom logo image metadata for sites
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the record.
site_id	bigint	the site the logo belongs to
width	integer	the image width in px
height	integer	the image height in px
storage_id	character varying	identifies the logo image on the storage back_end
url	text	the public URL of the logo
mime_type	character varying	the MIME type of the logo
created_at	timestamp without time zone	The time when this row was created.
updated_at	timestamp without time zone	The time when this row was last updated.
logo_type	character varying	type of logo (header or compact)

public.site_oidc_configurations: Defines the OpenID Connect IdP associated with a site.
Name	Type	Description
site_luid	uuid	Primary key for this table, matches the site.site_luid column.
is_enabled	boolean	Defines if the configration is active.
known_provider_alias	text	Name of the preconfigured provider, which must be defined in SiteSAML application.yml file.
client_id	text	OAuth2 client ID if using a custom provider.
client_secret	text	OAuth2 client secret if using a custom provider.
user_authorization_uri	text	OAuth2 user authorization URI if using a custom provider.
access_token_uri	text	OAuth2 access token URI if using a custom provider.
user_info_uri	text	OAuth2 user info URI if using a custom provider.

public.site_roles: Lists the various possible user site roles.
Name	Type	Description
id	integer	User site role ID is unique key correspondent to site_role_id from users table.
name	character varying	User site role name.
licensing_rank	integer	User license role rank for the purpose of licensing users with the correct priority when the number of available licenses is less that users. 1000-600 Tier Interactor users, down to 500 - Basic Tier users, 300 - Support users, 200 - guest users, 100 and below - Unlicensed.
display_name	character varying	User Friendly value to display on the IBA License Usage Admin View.

public.site_saml_configurations: Defines the SAML IdP associated with a site.
Name	Type	Description
Foreign key/Primary key relation from site_luid on this table to luid on table, public.sites
site_luid	uuid	Primary key for this table, matches the site.site_luid column.
idp_entity_descriptor	text	XML block of the EntityDescriptor for the Identity Provider.
attribute_mapping	text	Defines mapping for the saml response fields.
sp_certificate	text	PEM encoded certificate.
sp_private_key	text	PEM encoded private key.
is_enabled	boolean	Defines if the configration is active.
entity_descriptor_validation_result	text	JSON Serialized validation result.
authentication_domain_id	character varying	Authentication Domain.
authentication_type_for_embedded	character varying	Authentication type: DEFAULT or SAML.
allow_embedded_authentication	boolean	Flag if the site permits the authentication flow to be hosted in an iframe.
generation	character varying	Describes level of support and/or blocklisting of certain features in the SAML implementation.

public.site_saml_events: Log table for all SAML actions.
Name	Type	Description
Foreign key/Primary key relation from site_luid on this table to luid on table, public.sites
id	uuid	Primary key for this table.
timestamp	timestamp without time zone	Timestamp for the event.
log_level	character varying	String value of the logging level.
message	text	Text of the logged message.
site_luid	uuid	Matches the site.site_luid column and site_saml_configurations.site_luid.

public.site_saml_sessions: Records the user sessions authenticated by the SiteSAML service.
Name	Type	Description
id	character varying	Primary key for this table.
site_luid	uuid	Matches the site.site_luid column and site_saml_configurations.site_luid.
last_accessed_at	timestamp without time zone	Timestamp for the last_accessed_at time of the seesion.
http_session	bytea	HTTP Session representation.
version	bigint	Version value if set.

public.site_saml_users: Users that are allowed to use Per Site SAML authentication.
Name	Type	Description
Foreign key/Primary key relation from site_luid on this table to luid on table, public.sites
id	uuid	Primary key for this table.
site_luid	uuid	Matches the site.site_luid column and site_saml_configurations.site_luid.
user_name	character varying	User name field.
auth_user_id	character varying	Matches the auth_user_id of the user stored in the system_users table.
authentication_type	character varying	Which type of authentication to use, e.g. SAML or OIDC.

public.site_scoped_metadata_node_properties: Table to store properties of a node.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Auto increment primary Key.
node_id	character varying	Id of a node present in graph.
content_type	character varying	Content type of a node present in graph.
site_id	integer	Id of the site a node is scoped for
property_name	character varying	Name of a property for a node present in graph.
property_value	text	Value of a property for a node present in graph.
created_at	timestamp without time zone	Timestamp when property is created.
updated_at	timestamp without time zone	Timestamp when property is updated.

public.site_user_prefs: Site user preferences.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from user_id on this table to id on table, public.users
id	integer	The id of a site user preference. Primary key.
user_id	integer	A foreign key to users table. Indicates the site user to which this preference belongs.
refresh_failure_notification_enabled	boolean	Whether to send notification on failed extracts for this site user.
notification_enabled	boolean	Setting for enabling system notifications
show_welcome_screen	boolean	Shows the Welcome Screen on the Home space in Vizportalclient
show_metrics_banner	boolean	Shows the metrics banner on the metric detail screen in Vizportalclient
site_id	integer	Site ID of the site_user_prefs.

public.sites: Each record represents a site. Each site holds its own workbooks, datasources, users, etc. Strict isolation between the contents of each site is maintained.
Name	Type	Description
id	integer	Primary key for the record.
name	character varying	The name of the site.
url_namespace	character varying	String used in the construction of URLs that target this site.
status	character varying	One of "active" "suspended" or "locked".
created_at	timestamp without time zone	The time at which this record was created.
updated_at	timestamp without time zone	The last time any changes were made to this record.
content_admin_mode	integer	One of 1 (content only) or 2 (content and users).
storage_quota	bigint	Maximum storage for the site in megabytes.
status_reason	character varying	Holds an explanation for why a site is in a "suspended" status.
subscriptions_enabled	boolean	True if subscriptions are allowed for this site, otherwise false.
custom_subscription_footer	text	Content to be placed as the footer in each subscription email sent.
custom_subscription_email	text	The email from which to send subscriptions.
luid	uuid	An identifier which is unique to this site.
authoring_disabled	boolean	If true, then web authoring is disabled.
sheet_image_enabled	boolean	True if sheet image API is enabled for this site, otherwise false.
refresh_token_setting	integer	If true, oauth is enabled on server, allowing connected clients.
version_history_enabled	boolean	Setting for enabling/disabling version history on a site
notification_enabled	boolean	Setting for enabling/disabling system notification such as email notification on a site
content_version_limit	integer	Maximum number of versions to retain for each content type : workbooks ,datasources
subscribe_others_enabled	boolean	Setting for enabling/disabling the subscribe others functionality on a site
lock_version	integer	Used to implement "optimistic locking." Don't set this or mess with it, it's all handled automatically.
guest_access_enabled	boolean	Setting for enabling/disabling guest account per site
support_access_enabled	boolean	Setting for enabling/disabling access to a Tableau Online site by a Tableau support user
cache_warmup_enabled	boolean	True if cache warmup is enabled for this site.
cache_warmup_threshold	smallint	How recently a view must have been viewed to run warmup for it in days, defaulting to 30.
data_alerts_enabled	boolean	Setting for enabling/disabling data driven alerts on a site
allow_live_query_sync	boolean	Setting for allowing live query sync on a site
commenting_enabled	boolean	Setting for enabling/disabling commenting on a site
self_service_schedules_enabled	boolean	Setting for enabling/disabling self service schedules on a site
tier_interactor_capacity	integer	Max site-wide tier interactor license capacity limit.
tier_basic_user_capacity	integer	Max site-wide tier basic user license capacity limit.
tier_author_capacity	integer	Max site-wide tier author license capacity limit.
viz_in_tooltip_enabled	boolean	Setting for enabling/disabling Viz in Tooltip on a site
protocol_cache_lifetime	integer	Lifetime for native connections, in minutes
protocol_group_size_limit	integer	Limit on connection parallelism
commenting_mentions_enabled	boolean	Setting for enabling/disabling commenting mentions on a site
mixed_content_enabled	boolean	Setting for enabling/disabling mixed content on a site
site_invite_notification_enabled	boolean	Setting for enabling/disabling site invite notification on a site
extract_encryption_mode	smallint	Extract encryption mode: whether it is disabled (null or 0), enabled (1), or enforced (2).
flows_enabled	boolean	Setting for enabling/disabling Tableau Prep flows on a site
materialized_views_enabled	boolean	a flag to indicate whether the feature of materialized views is enabled for this site or not, enabled if true.
allow_subscriptions_attach_pdf	boolean	Whether to allow users to attach PDFs to subscription emails.
materialized_views_mode	smallint	Code representing the materialized views mode for the site.
start_page_uri	text	if not set the value from global_settings.start_page_uri is used
afe_enabled	boolean	Alternative Federation Engine (afe) is enabled or not
sandbox_enabled	boolean	Whether to enable sandbox for the site or not
viz_recs_enabled	boolean	Setting for enabling/disabling Viz Recommendations on a site
biometrics_mobile_enabled	boolean	Setting for enabling/disabling biometrics for mobile clients for a site
iba_enabled	boolean	Setting for enabling/disabling Identity Based Activation on a site. Only applicable for Online
named_sharing_enabled	boolean	Whether Named Sharing is enabled on the site
sandbox_storage_quota	bigint	the per user storage quota for sandboxes on a site in bytes. If null is unlimited
sandbox_datasources_enabled	boolean	Whether to enable datasources on sandboxes for the site or not
sandbox_flows_enabled	boolean	Whether to enable flows on sandboxes for the site or not
cataloging_enabled	boolean	Setting for enabling/disabling data cataloging features on a site
derived_permissions_enabled	boolean	Setting for enabling/disabling derived metadata permissions on a site
viz_recs_username_enabled	boolean	Setting for enabling/disabling the display of usernames along with viz recommendations
user_visibility	integer	Whether to user visibility is set to 0 - FULL or 1 - LIMITED
request_access	integer	One of 3 options for request access: on, off, custom_note
ask_data_mode	text	Setting the ask data mode for each site
run_now_enabled	boolean	Setting for allowing run now background jobs.
web_extraction_enabled	smallint	Enable or disable extract creation/live 1: enable, 0: disable the default is 1
metrics_enabled	boolean	Setting for enabling the metrics feature
web_editing_enabled	boolean	One of two options for web editing enabled: on, off
notify_site_admins_on_throttle	boolean	Setting for allowing site admins to opt in on receiving an email when background jobs are throttled.
obfuscation_enabled	boolean	Setting to enable or disable the obfuscation feature for Data Catalog
flow_auto_save_enabled	boolean	Setting to enable or disable auto save feature for flows
time_zone	text	IANA time zone name to be used with Hyper connections on this site. If not set or is empty then the server time zone is used.
public_collections_enabled	boolean	Setting for enabling public collections
self_service_schedule_for_refresh_enabled	boolean	Setting for allowing self service schedule for refresh.
self_service_schedule_for_flow_enabled	boolean	Setting for allowing self service schedule for flow.
auto_suspend_refresh_enabled	boolean	Setting for enabling/disabling Extract Refresh Auto Suspend feature on a site
auto_suspend_refresh_inactivity_window	integer	Number of days after which extract refresh will be suspended for inactive workbooks.
web_zone_content_enabled	boolean	Setting for enabling the Web Page Objects
personal_space_enabled	boolean	Whether to enable personal space for the site or not
personal_space_storage_quota	bigint	the per user storage quota for personal spaces on a site in bytes. If null is unlimited

public.sos_blob_data: table to store sos file types as binary data
Name	Type	Description
id	bigint	id referenced by repository_data sos_blob_data_id foreign key
data	bytea	SOS content stored as binary data

public.sos_virtual_folder_entries: Each record represents a file in a virtual folder currently tracked in Simple Object Storage.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from virtual_folder_id on this table to id on table, public.sos_virtual_folders
id	bigint	Primary key for the virtual folder entry record.
site_id	integer	ID of the site containing the virtual folder containing this entry.
virtual_folder_id	integer	ID of the virtual folder containing this entry.
sos_type	character varying	The SOS type name of this virtual folder entry.
sos_id	character varying	The SOS LUID corresponding to this virtual folder entry.
relative_path	text	Relative path to this entry starting from the root of the virtual folder.
created_at	timestamp without time zone	The time the virtual folder entry was created.

public.sos_virtual_folders: Each record represents a virtual folder currently tracked in Simple Object Storage.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	Primary key for the virtual folder record.
site_id	integer	ID of the site containing this virtual folder.
sos_id	character varying	The SOS LUID corresponding to this virtual folder.
sos_type	character varying	The SOS type name of this virtual folder.
created_at	timestamp without time zone	The time the virtual folder was created.
last_updated_at	timestamp without time zone	The time the virtual folder was last updated.

public.ss_custom_value_concepts: The table to hold value concepts used by semantics service
Name	Type	Description
Foreign key/Primary key relation from ontology_id, field_concept_key on this table to ontology_id, key on table, public.ss_field_concepts
id	bigint	The unique identifier for this row that is automatically generated on insert
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
key	text	Key of a value concept which is unique within one ontology
value	text	The value of the value concept in string format
value_type	text	The enum that represents the value type
field_concept_key	text	Key of the field concept that this value concept belongs to
ontology_id	bigint	ID of the ontology that this value concept belongs to
synonyms	jsonb	A list of synonyms of this value concept

public.ss_field_concepts: The table to hold field concepts used by semantics service
Name	Type	Description
Foreign key/Primary key relation from ontology_id, object_concept_key on this table to ontology_id, key on table, public.ss_object_concepts
Foreign key/Primary key relation from vs_datasource_id on this table to id on table, public.datasources
id	bigint	The unique identifier for this row that is automatically generated on insert
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
key	text	Key of a field concept which is unique within one ontology
names	jsonb	A list of synonyms of this field concept
description	text	Description of this field concept
name_characteristics	jsonb	A json blob that contains name characteristics of this field concept
data_types	ARRAY	A list of possible data types of this field concept
field_roles	ARRAY	A list of possible field roles of this field concept
default_formats	ARRAY	A list of possible default formats of this field concept
value_characteristics	jsonb	A json blob that contains value characteristics of this field concept
ontology_id	bigint	ID of ontology that this field concept belongs to
owner_id	text	User that creates this field concept, empty for built-in ones
object_concept_key	text	Key of object concept that this field concept belongs to
parent_field_concept_key	text	Key of field concept that is parent of this field concept
vs_field_name	text	Field in a published datasource that we sync value concepts of this field concept from
vs_datasource_id	bigint	Id of published datasource that we sync value concepts of this field concept from
user_id	bigint	ID of user who creates this field concept, empty for built-in ones
data_role_id	bigint	The ID of the data role that corresponds to the field concept. Data roles are stored in table `data_roles`.
value_source_kind	text	Contains a serialization of the kind of the value source (ie. datasource, builtin, valuelist, etc.)

public.ss_object_concepts: The table to hold object concepts used by semantics service
Name	Type	Description
Foreign key/Primary key relation from ontology_id on this table to id on table, public.ss_ontologies
id	bigint	The unique identifier for this row that is automatically generated on insert
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
key	text	Key of an object concept which is unique within one ontology
names	jsonb	A list of synonyms of this object concept
description	text	Description of this object concept
ontology_id	bigint	ID of ontology that this object concept belongs to
source_version	text	Source data version of built-in object concepts

public.ss_ontologies: The table to hold ontologies used by semantics service
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	The unique identifier for this row that is automatically generated on insert
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
site_id	integer	ID of the site that this ontology belongs to, empty for built-in ontology
description	text	Description of this ontology

public.subscription_messages: This table represent a subscription email message.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the subscription message.
message_text	text	The text of the message.
site_id	integer	The ID of the site the subscription belongs to.

public.subscriptions: Each record represents a subscription.
Name	Type	Description
Foreign key/Primary key relation from subscription_message_id on this table to id on table, public.subscription_messages
Foreign key/Primary key relation from creator_id on this table to id on table, public.users
Foreign key/Primary key relation from schedule_id on this table to id on table, public.schedules
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from user_id on this table to id on table, public.users
id	integer	Primary key for the record.
subject	character varying	A string that describes the nature of the subscription.
user_id	integer	A foreign key reference to the user who will receive the subscription.
schedule_id	integer	A foreign key reference to the record in the schedules table that describes exactly when the subscription will be triggered.
last_sent	timestamp without time zone	The last time at which the the subscription was sent.
site_id	integer	Site ID for Subscriptions. FK reference to sites.id
luid	uuid	UUID for subscriptions used in REST APIs
creator_id	integer	User id for user who created the subscription. FK reference to users.id
data_condition_type	character varying	The type of data condition that will cause this subscription to be sent out. Defaults to "Always", but can also be "DataPresent", "Constant", "Band", etc.
is_refresh_extract_triggered	boolean	Whether or not subscription is triggered by refresh extract
created_at	timestamp without time zone	The time at which this record was created.
subscription_message_id	integer	Locator for the subscription message.
content_has_user_references	boolean	Boolean that represents whether the content of the subscription has user references. NULL means subscription has not run yet
attach_pdf	boolean	Boolean that represents whether to attach a PDF to the subscription
attach_image	boolean	Boolean that represents whether to attach images to the subscription
target_type	character varying	String that represents the type of object being subscribed to. Either View or Workbook
target_id	integer	Integer that represents the id of the object being subscribed to.

public.subscriptions_customized_views: This table is used to link various customized views to the subscriptions in which those customized views must be generated and emailed.
Name	Type	Description
Foreign key/Primary key relation from customized_view_id on this table to id on table, public.customized_views
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from subscription_id on this table to id on table, public.subscriptions
id	integer	Primary key for the record.
subscription_id	integer	A foreign key reference to a record in the subscriptions table. Emailing the customized view referenced by the customized_view_id is one of the activities of the linked subscription.
customized_view_id	integer	A foreign key reference to a particular customized view.
site_id	integer	The ID of the site the subscription belongs to.

public.subscriptions_views: This table is used to link various views to the subscriptions in which those views must be generated and emailed.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from subscription_id on this table to id on table, public.subscriptions
id	integer	Primary key for the record.
subscription_id	integer	A foreign key reference to a record in the subscriptions table. Emailing the view referenced by the repository_url is one of the activities of the linked subscription.
repository_url	text	Used as a means to reference the particular view that is to be included in the subscription.
site_id	integer	The ID of the site the subscription belongs to.

public.subscriptions_workbooks: This table is used to link various workbooks to the subscriptions in which those workbooks must have views generated and emailed.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from subscription_id on this table to id on table, public.subscriptions
id	integer	Primary key for the record.
subscription_id	integer	A foreign key reference to a record in the subscriptions table. Emailing the views of the workbook referenced by the repository_url is one of the activities of the linked subscription.
repository_url	text	Used as a means to reference the particular workbook that is to be included in the subscription.
site_id	integer	A foreign key reference to the site that the workbooked referred to by repository_url belongs.

public.synonyms: The table to hold the synonyms for fields of datasources
Name	Type	Description
Foreign key/Primary key relation from lens_id on this table to id on table, public.lenses
Foreign key/Primary key relation from published_datasource_id on this table to id on table, public.datasources
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
site_id	integer	The site id of the datasource
published_datasource_id	integer	The published datasource id of the datasource
field_graph_id	text	The graph id corresponding to the field of a datasource
synonyms	ARRAY	The synonyms corresponding to a particular field of a datasource
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
id	bigint	The unique identifier for this row that is automatically generated on insert
lens_id	integer	id of the lens for which the synonym is applicable

public.system_user_identities: Identity to SystemUser mappings.
Name	Type	Description
Foreign key/Primary key relation from system_user_id on this table to id on table, public.system_users
identity_uuid	uuid	Primary key for identity mapping.
system_user_id	integer	SystemUser for identity mapping.
created_at	timestamp without time zone	Creation time of record.
updated_at	timestamp without time zone	Last updated time of record.

public.system_user_migration_conflicts: Conflicts when migrating system_user identities.
Name	Type	Description
Foreign key/Primary key relation from duplicate_system_user_id on this table to id on table, public.system_users
Foreign key/Primary key relation from system_user_id on this table to id on table, public.system_users
id	integer	The autoincremental id for this record.
system_user_id	integer	SystemUser for which the migration failed.
failure_type	character varying	The type of failure that was registered when migrating this system_user.
created_at	timestamp without time zone	Creation time of this record.
discard_identity	boolean	If the admin acknowledge they will not create an identity for this system_user.
error_message	character varying	Information on the exception raised during the migration of this system_user.
duplicate_system_user_id	integer	The id of the system_user for which the original system_user is a duplicate of.

public.system_user_migration_conflicts_identity_data: Identity information related to ambiguous results when migrating system_user identities.
Name	Type	Description
Foreign key/Primary key relation from migration_conflict_id on this table to id on table, public.system_user_migration_conflicts
id	integer	The autoincremental id for this record.
migration_conflict_id	integer	The id of the ambiguous migration conflict to which this identity information corresponds.
domain_fqdn	character varying	The fqdn from the domain of the active directory user.
sam_account_name	character varying	The sAMAccountName of the active directory user from the query result.
user_principal_name	character varying	The Full-UPN of the active directory user attributes.
distinguished_name	character varying	The DN of the ldap user from the query result.
display_name	character varying	The display name attribute from the query result.

public.system_users: Each record represents a user of the server. These records correspond to login identity. A single system_user may potentially be able to login to multiple sites. The linkage between a system_user and their allowed sites is defined through the "users" table.
Name	Type	Description
Foreign key/Primary key relation from domain_id on this table to id on table, public.domains
id	integer	Primary key for the record.
name	character varying	The username of the user.
email	character varying	The email of the user.
hashed_password	character varying	Hashed password - only used for local authentication.
salt	character varying	The salt used when hashing the password - only used for local authentication.
keychain	text	The encyrpted keychain for the user.
domain_id	integer	The domain for this user.
friendly_name	character varying	A friendly name that might be used in the GUI to refer to the user.
custom_display_name	boolean	If set to true, this prevents the friendly_name from potentially being overwritten by Active Airectory information when the user is read in from Active Directory. Seldom done.
admin_level	integer	Indicates if the user is a system administrator. 10 : system admin, 0 : not a system admin
created_at	timestamp without time zone	The time at which this record was created.
updated_at	timestamp without time zone	The last time any changes were made to this record.
auth_user_id	character varying	An external, immutable identifier for the user provided by an external authorization system.
asset_key_id	integer	The id for the asset encryption key used to encrypt the keychain for this user.
lock_version	integer	Used to implement "optimistic locking." Don't set this or mess with it, it's all handled automatically.
last_password_update	timestamp without time zone	Date that represents the last time the user updated the password to the current value.
force_password_update	boolean	Boolean that represents if we want to force a password reset on the user the next time it tries to log in.
protected_password	character varying	Protected form of the user password - only used for local authentication.
last_failed_login	timestamp without time zone	Date that represents the last time the user had an unsuccessful login.
failed_login_attempts	integer	Integer that represents the number of failed attempts since the last successful login.
protected_password_bad_format	boolean	Set to true if protected password format unrecognized

public.table_asset_events: Used to store table_asset events stream.
Name	Type	Description
id	bigint	Primary key for this record.
table_asset_id	integer	table_asset ID.
site_id	integer	Site ID.
event_created_at	timestamp without time zone	Timestamp indicating when the record was inserted.
event_type	smallint	Event type to differentiate between insert, update, delete.

public.table_asset_sources: Used to store mappings between tables and their source.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from table_asset_id on this table to id on table, public.table_assets
id	integer	Primary key.
site_id	integer	Site id.
table_asset_id	integer	Table Asset ID.
source_id	integer	Source ID.
source_type	character varying	Source type, e.g. Workbook, Datasource, Flow.
created_at	timestamp without time zone	Created at.
updated_at	timestamp without time zone	Updated at.

public.table_assets: Each record represents a table asset that exists on Tableau Server.
Name	Type	Description
Foreign key/Primary key relation from grouped_parent_id on this table to id on table, public.table_assets
Foreign key/Primary key relation from database_id on this table to id on table, public.database_assets
Foreign key/Primary key relation from certifier_user_id on this table to id on table, public.users
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the table asset record.
name	character varying	The name of the table asset.
luid	uuid	A unique, immutable identifier for the table asset.
site_id	integer	The id of the site that this table asset is associated with.
created_at	timestamp without time zone	The time the record was created.
updated_at	timestamp without time zone	The time the record was updated.
description	text	The description of the table asset.
database_id	integer	The database this table belongs to.
table_schema	text	Schema for this table.
contact_id	integer	The contact for this table.
contact_type	character varying	The contact type (user or group) for this table.
is_certified	boolean	Whether this table is certified.
certification_note	text	Certification note for this table.
certifier_user_id	integer	Certifier user_id for this table.
certifier_details	text	Certifier details for this table.
full_name	character varying	The fully qualified name of the table.
duplicate_id	integer	If not null, id of table that is a duplicate of this one.
is_tombstoned	boolean	Tombstoned tables are "soft deleted" because they are associated with databases that have been grouped with other databases.
grouped_parent_id	integer	ID in table_assets table of table this tombstoned database was grouped into.

public.taggings: Associates tags with taggable items.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from tag_id on this table to id on table, public.tags
Foreign key/Primary key relation from user_id on this table to id on table, public.users
id	integer	The primary key for the table.
tag_id	integer	The ID of the tag.
taggable_id	integer	The ID of the taggable item.
taggable_type	character varying	The type of the taggable item - this is used to identify which table to join to.
user_id	integer	The ID of the owning user.
site_id	integer	The ID of the site the tagging belong to.

public.tags: Each tag is a string value. A given tag can be associated with many taggable items in a site.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	The primary key for the table.
name	character varying	The value of the tag.
created_at	timestamp without time zone	The time at which this record was created.
updated_at	timestamp without time zone	The last time any changes were made to this record.
site_id	integer	The ID of the site to which the tag belongs.

public.tasks: Serves to connect schedules with background tasks that should be run on that schedule. The schedule is defined in the schedules table, while the task is defined by type.
Name	Type	Description
Foreign key/Primary key relation from schedule_id on this table to id on table, public.schedules
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	The primary key for the table.
schedule_id	integer	Links to a schedule. When the schedule's "run_next_at" time arrives, any tasks linked to that schedule will run.
type	character varying	Identifies the specific type of task that this is. This is how the system identifies what code to execute when this task is to be run.
priority	integer	An integer where 0 is the highest priority and 10 is the default priority. Other values can be set if desired). Higher priority jobs should be processed earlier.
obj_id	integer	Some tasks are specific to a particular workbook or datasource. In such cases, the object_id is the primary key of the relevant item, in either the workbooks or datasources tables, as indicated by obj_type.
created_at	timestamp without time zone	When this record was created.
updated_at	timestamp without time zone	The last time this record was updated.
site_id	integer	Some tasks are specific to a particular site. In such cases, this field links to the relevant site in the sites table.
obj_type	character varying	One of either "Workbook" or "Datasource". Used in conjuction with obj_id, as described there.
luid	uuid	uuid for tasks used in the REST API
consecutive_failure_count	integer	The number of times this task has failed.
active	boolean	If set to false, this means that the task is inactive, implying it won't be run when the schedule triggers
args	text	Used to pass parameters for the task, formatted as yaml.
title	text	Can be used to provide some additional information about the task
subtitle	text	Can be used to provide some additional information about the task
historical_run_time	integer	Stored as the historical run time in seconds for the task, used for sorting background jobs and comparing current run time to the past
historical_queue_time	integer	Stored as the historical queue time in seconds for the task, used for comparing the current queue time to the past
run_count	integer	Number of times this task has run since we created this column. Do not use this value as gospel, as it is will not be accurate for tasks created before this column.
state	integer	One of 3 options for task state: 0 - active, 1 - suspended, 2 - disabled
last_success_completed_at	timestamp without time zone	The last time the task successfully completed.
creator_id	integer	Indicates what user id is the creator of the task

public.tde_files: Information about TDE files.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Auto-generated id from postgres; also the primary key for the table.
site_id	integer	Id of the site to which the TDE file belongs.
name	text	Unique name of the TDE file.
size	bigint	Size of the file in bytes.
created_at	timestamp without time zone	Timestamp when this record was created.
updated_at	timestamp without time zone	Same as created_at.

public.tds_datasource_files: The TDS files.
Name	Type	Description
id	bigint	Primary key for the record.
created_at	timestamp with time zone	The timestamp for creating the file.
updated_at	timestamp with time zone	The timestamp for updating the file.
site_id	integer	Reference to the site to where the datasource exists.
luid	uuid	The unique ID of the datasource.
tds_xml_sos_id	text	The ID of the xml within SOS.
site_luid	text	The luid which uniquely identifies the site.

public.tds_datasource_model_fields: Fields of datasource models.
Name	Type	Description
Foreign key/Primary key relation from datasource_model_id on this table to id on table, public.tds_datasource_models
id	bigint	Primary key for the record.
created_at	timestamp with time zone	The timestamp for creating the model.
updated_at	timestamp with time zone	The timestamp for updating the model.
luid	text	Internally used LUID for the record.
content_site_id	integer	A foreign key reference to the site to where the datasource exisits.
qualified_name	text	The qualified name of the field, the qualified name is represented in JSON style.
datasource_model_id	integer	A foreign key reference to the tds datasource model to where the field exisits.
caption	text	Friendly name for the data source field that is seen in Tableau.
is_hidden	boolean	Determines if the field is hidden or not.
is_auto_hidden	boolean	The visibility of Autohidden fields are not under user control.
is_layered	boolean	The field is layered on top of a field from a remote data source.
field_type	integer	The type of the field.
field_role	integer	The role of the field.
folder_name	text	The optional folder name if this field is in a folder.
user_caption	text	The optional user generated name for the field.
server_caption	text	The optional caption provided by the server.
user_description	text	The optional user description defined by user, the representation type is JSON.
site_luid	text	The luid which uniquely identifies the site.

public.tds_datasource_models: Model of the datasource.
Name	Type	Description
Foreign key/Primary key relation from tds_file_id on this table to id on table, public.tds_datasource_files
id	bigint	Primary key for the record.
created_at	timestamp with time zone	The timestamp for creating the model.
updated_at	timestamp with time zone	The timestamp for updating the model.
name	text	The name of the datasource.
caption	text	The caption of the datasource.
schema_version	integer	The schema version number of this data source model
tds_file_id	bigint	Reference to tds file associated with this model

public.trusted_tickets: This table lists trusted tickets that have been created. Tickets that are redeemed are deleted once used, hence can only be used once. Tickets that are never redeemed become invalid after the time given by "expires_at" and are eventually deleted from the table automatically.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from user_id on this table to id on table, public.users
id	integer	Primary key for the record.
username	character varying	The name of the user, under whose authority, the ticket is created. Access to content is provided as if the ticket redeemer were this user.
ticket	character varying	The unique ticket string, i.e. the "value" of the trusted ticket.
client_ip	character varying	If you have configured wgserver.extended_trusted_ip_checking to true, then the IP address of the client that is authorized to redeem the ticket will be recorded here.
created_at	timestamp without time zone	When this record was created, i.e. the time of creation of the ticket.
user_id	integer	Links to the user that has the given username, and is associated with the current site.
expires_at	timestamp without time zone	Tickets can be redeemed no more than one time, but if it gets any later than this time, then the ticket cannot be redeemed at all. Unless configured differently, this time will be 3 minutes after the ticket is created.
site_id	integer	The site of the user.
originating_session_id	character varying	The user session which created the ticket. Null if the ticket was not created by an authenticated user.
guid	character varying	Uniquely identifies a trusted ticket when ticket hashing is enabled.
salt	character varying	Combined with ticket to form the hash.
hashed_ticket	character varying	The hash of the salt and the ticket.

public.user_default_customized_views: Defines what customized view a user should see for a given view, by default.
Name	Type	Description
Foreign key/Primary key relation from customized_view_id on this table to id on table, public.customized_views
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from user_id on this table to id on table, public.users
Foreign key/Primary key relation from view_id on this table to id on table, public.views
id	integer	Primary key for the record.
user_id	integer	A foreign key reference to the user.
view_id	integer	A foreign key reference to the view.
customized_view_id	integer	A foreign key reference to the customized view.
created_at	timestamp without time zone	When this record was created.
updated_at	timestamp without time zone	When this record was last updated.
site_id	integer	The ID of the site to which this entry belongs.

public.user_images: Represents images for each associated system user.
Name	Type	Description
Foreign key/Primary key relation from system_user_id on this table to id on table, public.system_users
id	integer	Primary key for the record.
repository_data_id	bigint	A reference to an entry in the repository_data table.
image_id	character varying	The id of the image in storage.
image_type	character varying	A string representing the size of the image.
system_user_id	integer	The id of the user this image is associated with.

public.user_notification_content_reference_list_items: Lists of references to other DB records in user notification content.
Name	Type	Description
Foreign key/Primary key relation from notification_id on this table to id on table, public.user_notifications
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	The identifier of the record.
notification_id	integer	The identifier of the notification this record belongs to.
field_name	text	The name of the content field.
list_index	integer	The 0-based index of the item in the list.
reference_type	integer	The type of the referenced object.
reference_id	integer	The identifier of the referenced object.
site_id	integer	The identifier of the site the record belongs to.

public.user_notification_content_references: References to other DB records in user notification content.
Name	Type	Description
Foreign key/Primary key relation from notification_id on this table to id on table, public.user_notifications
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	The identifier of the record.
notification_id	integer	The identifier of the notification this record belongs to.
field_name	text	The name of the content field.
reference_type	integer	The type of the referenced object.
reference_id	integer	The identifier of the referenced object.
site_id	integer	The identifier of the site the record belongs to.

public.user_notification_recipients: Holds metadata for all user notification recipients on the server.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from notification_id on this table to id on table, public.user_notifications
id	integer	Primary key for the user notification recipient.
recipient_user_id	integer	The identifier for the recipient of the user notification.
notification_id	integer	The identifier of the notification for the recipient.
read_state	boolean	True if the notification has been read, false if it is unread.
site_id	integer	The identifier of the site the recipient belongs to.

public.user_notifications: Holds metadata for all user notifications on the server.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the user notification.
luid	uuid	The identifier for the user notification.
notification_type	text	The type of the user notification.
event_time	timestamp without time zone	The time at which the event that triggered this notification occurred.
subject_type	integer	The subject type of the user notification.
subject_id	integer	The identifier for the subject of the user notification.
site_id	integer	The identifier for the site that the user notification belongs to.
content	text	The text content of the user notification.
sender_user_id	integer	The identifier for the (optional) sender of the user notification.
created_at	timestamp without time zone	The time at which the user notification was persisted.

public.user_notifications_server_settings: A key-value store for user notifications server settings.
Name	Type	Description
id	integer	Primary key.
key	text	String key for the setting.
value	text	String value for the setting. Can be parsed into other formats by clients.

public.user_notifications_site_settings: A key-value store for user notifications site settings.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key.
site_id	integer	Site id that setting applies to.
key	text	String key for the setting.
value	text	String value for the setting. Can be parsed into other formats by clients.

public.user_notifications_user_settings: A key-value store for user notifications user settings.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key.
user_id	integer	User id that setting applies to.
site_id	integer	Site id that user belongs to.
key	text	String key for the setting.
value	text	String value for the setting. Can be parsed into other formats by clients.

public.user_onboardings: This table stores onboarding information for tableau features based on system user ids
Name	Type	Description
Foreign key/Primary key relation from system_user_id on this table to id on table, public.system_users
id	integer	Primary key for the record.
system_user_id	integer	The id of the user this onboarding info is associated with.
nlp_onboarding_stage	character varying	The nlp onboarding stage of this user.
nlp_help_center_stage	character varying	Ask data help center onboarding stage

public.user_prefs: Contains a variety of preferences for the various system users.
Name	Type	Description
Foreign key/Primary key relation from system_user_id on this table to id on table, public.system_users
id	integer	Primary key for the record.
system_user_id	integer	Foreign key reference to the system_users table. This tells us which system user these preferences apply to.
version	integer	Used to indicate how to interpret the prefs information.
prefs	bytea	A serialized object containing the various preferences.
language_id	character varying	A code indicating the desired language for this system_user
locale_id	character varying	A code indicating the locale (country and language) for this system_user.
start_page	text	A relative url of the start page saved by the user.
suppress_getting_started_notifications	boolean	Flag which indicates if user has selected to suppress getting started notifications (used in online case only so far).
display_mode	character varying	A display mode "thumbnail" or "list" that the user last selected for viewing contents.
local_timezone_offset	integer	local user timezone offset (in minutes) from utc from last login location
local_timezone_name	character varying	best guess of local user timezone name from last login location
lock_version	integer	Used to implement "optimistic locking." Don't set this or mess with it, it's all handled automatically.
is_user_set_timezone	boolean	Indicating whether user explicitly set the timezone or inferred by system
suspended_subscription_notification	boolean	Site and System admins only. When true admins receive notification about suspended subscriptions
suspended_data_alert_notification	boolean	Site and System admins only. When true admins receive notification about suspended alerts
mark_animation_enabled	boolean	When true, users will see mark animations on sheets

public.users: Each record links a system_users record to a site. The user's site specific settings are captured here.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from system_user_id on this table to id on table, public.system_users
id	integer	Primary key for the record.
login_at	timestamp without time zone	The time of the most recent login for this user.
created_at	timestamp without time zone	When the record was created.
updated_at	timestamp without time zone	When the record was last updated.
site_id	integer	A foreign key reference to the site that the user belongs to.
system_user_id	integer	A foreign key reference to the system user that this user is identified with.
system_admin_auto	boolean	A flag indicating if the user is a system_admin that is not explicitly a member of the site.
luid	uuid	An immutable identifier for the record.
lock_version	integer	Used to implement "optimistic locking." Don't set this or mess with it, it's all handled automatically.
site_role_id	integer	The ID of the site role for this user. The mapping is below. 0 = SiteAdministrator 1 = SupportUser 2 = Publisher 3 = Interactor 4 = ViewerWithPublish 5 = Viewer 6 = UnlicensedWithPublish 7 = Guest 8 = Unlicensed 9 = BasicUser

public.value_synonyms: The user defined synonyms associated with values of fields in datasources
Name	Type	Description
Foreign key/Primary key relation from lens_id on this table to id on table, public.lenses
Foreign key/Primary key relation from published_datasource_id on this table to id on table, public.datasources
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	bigint	The unique identifier for this row that is automatically generated on insert
created_at	timestamp with time zone	The timestamp for when this row entry was created
updated_at	timestamp with time zone	The timestamp for when this row entry was updated
site_id	integer	The id of the site on which the datasource is published
published_datasource_id	integer	The id of the published datasource on the site
field_graph_id	text	The graph id of the field in the datasource
field_value	text	The name of the value in the field
user_defined_synonyms	ARRAY	The user defined synonyms associated with the value
lens_id	integer	id of the lens for which the value synonym is applicable

public.view_metrics_aggregations: Each record represents a partial aggregation of analytics for a given view in a given time interval. It is often necessary to sum across multiple rows to find a total for a given time interval.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from view_id on this table to id on table, public.views
id	integer	Primary key for the record.
view_id	integer	A foreign key reference to the view.
day_index	integer	Records what day of the month the analytics are aggregated over. When 0, the aggregation is for the month and year as designated by month_index and year_index.
month_index	integer	Records what month of the year the analytics are aggregated over. When 0, the aggregation is for the year as designated by year_index.
year_index	integer	Records what year the analytics are aggregated over
view_count	integer	Records the number of time a view was viewed in the given time interval.
device_type	text	DSD device type detected (non-null only if view is dashboard in non-authoring mode)
site_id	integer	The ID of the site the view metrics aggregation belong to.

public.views: Each records represents a view in a workbook.
Name	Type	Description
Foreign key/Primary key relation from owner_id on this table to id on table, public.users
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from workbook_id on this table to id on table, public.workbooks
id	integer	Primary key for the record.
name	character varying	The name of the view.
repository_url	text	Uniquely identifies a view. More or less composed of workbook and sheet names, but not totally obviously, especially in the presence of non-ASCII characters. Used in URLs meant to access this view.
description	text	Can hold a description of the view, but not normally populated.
created_at	timestamp without time zone	The time at which this record was created.
workbook_id	integer	A foreign key reference to the workbook the view is part of.
index	integer	Each view has an index that is unique among views belonging to that workbook.
updated_at	timestamp without time zone	The last time any changes were made to this record
owner_id	integer	A foreign key reference to the user who owns this view.
fields	text	A list of fields extracted from the workbook's twb file.
title	text	A title for the worksheet extracted from the workbook's twb file.
caption	text	A descriptive phrase constructed for the worksheet, based on the workbook definition.
sheet_id	character varying	An identifier for the sheet. Based on the name of the sheet.
state	character varying	One of either "active" or "disabled".
sheettype	character varying	One of "story" "dashboard" and "view".
site_id	integer	A foreign key link to the site to which this view belongs.
first_published_at	timestamp without time zone	Records the timestamp for the first time this view was published. This value will not change is the workbook containing this view is later republished.
revision	character varying	Starts with 1.0 and increments by 0.1 with each republication.
luid	uuid	An immutable identifier for the record.
thumbnail_id	character varying	Unique ID used to identify the thumbnail data.
is_deleted	boolean	Whether a view has been soft deleted and is now in the recycle bin

public.views_stats: This table is used to track how many times each user has accessed different views.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from view_id on this table to id on table, public.views
id	integer	Primary key for the record.
user_id	integer	A foreign key reference to a particular user.
view_id	integer	A foreign key reference to the view that was accessed. This field must be populated.
nviews	integer	Keeps a cumulative count of the number of times the view was accessed by this user.
time	timestamp without time zone	The time of the most recent access of the specified view by the specified user.
site_id	integer	The site to which the view and the user belong.
device_type	text	Device type detected for Device Designer (non-null only if view is dashboard in non-authoring mode)

public.viz_snapshots: This table represents a snapshots of viz.
Name	Type	Description
Foreign key/Primary key relation from view_id on this table to id on table, public.views
id	integer	Primary key for the viz snapshot.
view_id	integer	Primary key id for view associated with the viz snapshot.
image_id	character varying	Locator for the full image of the viz snapshot.
thumbnail_id	character varying	Locator for the thumbnail image of the viz snapshot.
data_id	character varying	Locator for the data of the viz snapshot.
created_at	timestamp without time zone	The time at which this record was created.
reference_count	integer	The number of objects that reference a viz snapshot.
site_id	integer	The ID of the site the viz_snapshots belong to.

public.viz_states: This table represents a snapshot of the state of a viz.
Name	Type	Description
Foreign key/Primary key relation from view_id on this table to id on table, public.views
id	integer	Primary key for the viz state entity.
view_id	integer	Foreign key reference to the view associated with this viz state.
image_id	character varying	Locator for the full image of the viz state.
thumbnail_id	character varying	Locator for the thumbnail image of the viz state.
data_id	character varying	A reference to an entry in SOS which references a tcv file of the viz state.
created_at	timestamp without time zone	When this recorded was created

public.webhooks: Holds metadata for all registered webhooks on the server.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	Primary key for the webhook.
luid	uuid	Identifier for webhook.
site_luid	uuid	The site that the webhook belongs to.
site_id	integer	The id of the site that the webhook belongs to.
version	integer	The version of this webhook. 1 on create, monotonically increasing with each update of the webhook.
owner_luid	uuid	The user who is the current owner of the webhook.
url	text	The fully specified URL for the webhook to POST to when triggered.
body_template	text	JSON template for the body of the request to send when the webhook is triggered.
name	text	Human readable name for the webhook, defaults to the value Unnamed Webhook.
event_type	text	The type of event on the server that will trigger this webhook e.g datasource refresh.
isenabled	boolean	Whether the webhook is currently run on trigger events
statuschangereason	text	Record the reason for any automated disabling/enabling of a webhook
failedattempts	integer	Number of consecutive failed delivery attempts

public.workbook_checksums: This table provides a set of checksums associated with a workbook which can be used to validate existence of a workbook based on its checksum.
Name	Type	Description
Foreign key/Primary key relation from workbook_id on this table to id on table, public.workbooks
id	integer	Primary key for the record.
workbook_id	integer	Identifies the workbook for which this checksum applies.
checksum	character varying	The computed checksum of the workbook during download.
created_at	timestamp without time zone	When this checksum entry was created and will be valid only if associated workbook update timestamp is earlier than this.
expires_at	timestamp without time zone	When this checksum entry expires and became eligible for cleanup by background task.

public.workbook_events: Used to store workbook events stream.
Name	Type	Description
id	bigint	Primary key for this record.
workbook_id	integer	Workbook ID.
site_id	integer	Site ID.
event_time	timestamp without time zone	Timestamp indicating when the record was inserted.
event_type	integer	Event type to differentiate between insert, update, delete.

public.workbook_exports: Each row in the table corresponds to a cached pdf file.
Name	Type	Description
Foreign key/Primary key relation from generated_as_user_id on this table to id on table, public.users
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from workbook_id on this table to id on table, public.workbooks
id	integer	Primary key for the record.
language_id	character varying	The language ID the pdf was generated with.
locale_id	character varying	The locale ID the pdf was generated with.
generated_as_user_id	integer	The user ID iff the pdf was generated with user references. Otherwise NULL.
workbook_id	integer	The workbook id this pdf is generated from.
generated_at	timestamp without time zone	The timestamp at which the pdf was generated.
freshness_verified_at	timestamp without time zone	The timestamp at which the cached file was last verified as fresh.
data_storage_id	bigint	A reference to an entry in the repository_data table, which, in turn references the PostgreSQL large object that contains the sheet image for this entry.
data_id	character varying	Unique ID used to identify the pdf.
show_commands_query_str	text	Represents hash of the possible show commands to be applied to the viz in the native api code.
page_orientation	character varying	PDF page orientation
page_size_option	character varying	PDF page size option
file_type	integer	The file type (PDF = 0, PPT = 1). Enum to be defined in WorkbookExportOptions
customized_views	character varying	Comma separated list of custom view IDs associated with the workbook export, sorted in ascending order. NULL if not applicable
site_id	integer	The ID of the site to which this entry belongs.

public.workbook_versions: Workbook versions saved on server.
Name	Type	Description
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
Foreign key/Primary key relation from workbook_id on this table to id on table, public.workbooks
id	integer	The id of a version. Primary key.
site_id	integer	Reference to entry in sites table. Indicates the site to which this workbook version belongs to.
workbook_id	integer	A foreign key to the workbooks table. Reference to workbook.
publisher_id	integer	Reference to user in site users table. User who published this version. Can point to deleted user.
version_number	integer	The version number.
published_at	timestamp without time zone	The time when this version was initially published. Copied from workbook record last_updated field at the time of being overwritten.
size	bigint	The size, in bytes, of this version of workbook.
content_key	character varying	Key of the workbook as string
publish_metadata	text	Metadata about how this version was published on server, such as visiblity of views. Metadata is stored as a serialized JSON object.
sos_type	character varying	The SOS data type under which this version document is stored, or null if it is not stored in SOS.
is_revision_file_reduced	boolean	Boolean flag indicating if the stored workbook version has an extract that is not stored in the workbook document, since extracts are not versioned.

public.workbooks: Each record represents a workbook that exists on the server.
Name	Type	Description
Foreign key/Primary key relation from modified_by_user_id on this table to id on table, public.users
Foreign key/Primary key relation from owner_id on this table to id on table, public.users
Foreign key/Primary key relation from project_id on this table to id on table, public.projects
Foreign key/Primary key relation from site_id on this table to id on table, public.sites
id	integer	The primary key for the record.
name	character varying	The name of the workbook.
repository_url	text	A unique name for the workbook, derived from the ASCII characters in the name, which can be used in URLs to refer to this workbook.
created_at	timestamp without time zone	The time at which this record was created.
updated_at	timestamp without time zone	The last time any changes were made to this record.
owner_id	integer	A foreign key reference to the user that owns this workbook.
project_id	integer	A foreign key reference to the project in which this workbook exists.
view_count	integer	Keeps count of the number of views that are associated with this workbook.
size	bigint	The number of bytes used in storing the workbook information.
embedded	text	An encrypted keychain holding any credentials stored with the workbook.
thumb_user	integer	The user to be used when generating the thumbnail image. Null unless specified.
refreshable_extracts	boolean	Whether the extracts in the workbook can be refreshed.
extracts_refreshed_at	timestamp without time zone	The time at which the last extract refresh occurred.
lock_version	integer	Used to implement "optimistic locking." Don't set this or mess with it, it's all handled automatically.
display_tabs	boolean	If true, then the sheets of the workbook are displayed on tabs.
data_engine_extracts	boolean	Indicates if this workbook has associated data engine extracts.
incrementable_extracts	boolean	Indicates if it is possible to perform an incrementable extract refresh for this workbook.
site_id	integer	The site to which the workbook was published.
revision	character varying	Starts with 1.0 and increments by 0.1 with each republication.
first_published_at	timestamp without time zone	Records the timestamp for the first time this view was published. This value will not change is the workbook containing this view is later republished.
extracts_incremented_at	timestamp without time zone	The time of the last incremental extract refresh for extracts in this workbook.
default_view_index	integer	Indicates which view will be shown by default.
luid	uuid	An immutable identifier for the record.
asset_key_id	integer	The asset encryption key used to encrypt the keychain in the embedded column.
document_version	character varying	A string that indicates the version of the document description that was used when saving this workbook.
content_version	integer	Version number of the workbook. updated on each publish
last_published_at	timestamp without time zone	Time that the user last published this workbook to server or saved the workbook during web edit. For workbooks that were last published before this column existed, the value will be null.
data_id	character varying	Unique ID used to identify the workbook data.
reduced_data_id	character varying	Unique ID used to identify the reduced workbook data.
published_all_sheets	boolean	True if user previously published all sheets in the workbook, false if they chose to not publish a sheet
extract_encryption_state	smallint	If not null, encryption state of the extracts. null or 0 - unencrypted, 1 - encrypted, 2 - pending encryption, 3 - pending decryption, 5 - pending rekey
extract_creation_pending	smallint	null or 0 - there is not extract creation in progress, 1 - there is an extract creation in progress
is_deleted	boolean	When is_deleted is true then workbook is deleted, no active job or user request can see it. It is considered to reside in Recycle Bin until either restored or permanently deleted.
parent_workbook_id	integer	null - there is no parenet workbook; if not null, it stores the id of the original workbook from which this private workbook is derived
is_private	boolean	null or false - this is not a private workbook, true - this is a private workbook
modified_by_user_id	integer	The user who last modified and published this workbook to server or saved the workbook during web edit. For workbooks that were last published before this column existed, the value will be same as owner_id.
extract_storage_format	smallint	How extracts for this data source are stored. NULL means no extracts or old-style extract folder. 0 means no extracts. 1 means old-style extract folder. 2 means new-style individual Hyper and TDE files in file store.

recommendations.connection_fields: Missing description
Name	Type	Description
Foreign key/Primary key relation from rec_connection_tables_id on this table to id on table, recommendations.connection_tables
id	integer	The primary key for the table
column_name	character varying	Missing description
rec_connection_tables_id	integer	Missing description

recommendations.connection_tables: Missing description
Name	Type	Description
Foreign key/Primary key relation from rec_connections_id on this table to id on table, recommendations.connections
id	integer	The primary key for the table
name	character varying	Missing description
custom_sql	bytea	Stores the custom sql used to generate this table if it exists
table_value	character varying	Missing description
type	character varying	Missing description
rec_connections_id	integer	Missing description

recommendations.connections: Missing description
Name	Type	Description
Foreign key/Primary key relation from rec_datasources_id on this table to id on table, recommendations.datasources
id	integer	The primary key for the table
class	character varying	Missing description
data_connection_id	integer	Missing description
database	character varying	Missing description
port	integer	Missing description
raw_server	character varying	Missing description
server	character varying	Missing description
rec_datasources_id	integer	Missing description
schema	character varying	Stores the value the schema for the connection if applicable to this driver
catalog	character varying	Stores the value the catalog for the connection if applicable to this driver (eg. Google BigQuery)
exec_catalog	character varying	Stores the value the schema for the connection if applicable to this driver (eg. Google BigQuery where it is also known as Billing Project)
project	character varying	Stores the value the project for the connection if applicable to this driver (eg. Google BigQuery)
service	character varying	Stores the value the service for the connection if applicable to this driver (eg. Snowflake)
warehouse	character varying	Stores the value the warehouse for the connection if applicable to this driver (eg. Snowflake)

recommendations.datasources: Missing description
Name	Type	Description
Foreign key/Primary key relation from rec_workbooks_id on this table to id on table, recommendations.workbooks
id	integer	The primary key for the table
name	character varying	Missing description
name_in_twb	character varying	Missing description
datasources_id	integer	Missing description
repository_url	text	Missing description
site_id	integer	Missing description
rec_workbooks_id	integer	Missing description
last_published_at	timestamp without time zone	Missing description
is_certified	boolean	Flag that indicates whether or not this datasource is certified

recommendations.fields: Missing description
Name	Type	Description
Foreign key/Primary key relation from rec_datasources_id on this table to id on table, recommendations.datasources
id	integer	The primary key for the table
caption	text	Missing description
name	text	Missing description
rec_datasources_id	integer	Missing description

recommendations.join_expressions: Missing description
Name	Type	Description
Foreign key/Primary key relation from rec_joins_id on this table to id on table, recommendations.joins
Foreign key/Primary key relation from left_rec_connection_fields_id on this table to id on table, recommendations.connection_fields
Foreign key/Primary key relation from right_rec_connection_fields_id on this table to id on table, recommendations.connection_fields
id	integer	The primary key for the table
operation	character varying	Missing description
rec_joins_id	integer	Missing description
left_rec_connection_fields_id	integer	Missing description
right_rec_connection_fields_id	integer	Missing description

recommendations.joins: Missing description
Name	Type	Description
Foreign key/Primary key relation from rec_connections_id on this table to id on table, recommendations.connections
id	integer	The primary key for the table
join_type	character varying	Missing description
rec_connections_id	integer	Missing description

recommendations.ml_association_rules: Missing description
Name	Type	Description
id	integer	The primary key for the table
group_name	text	Missing description
json_indexer	text	In combination, the indexer, item_sets, and joins represent the trained model for datasource recommendations
json_item_sets	text	In combination, the indexer, item_sets, and joins represent the trained model for datasource recommendations
json_joins	text	In combination, the indexer, item_sets, and joins represent the trained model for datasource recommendations
created_at	timestamp without time zone	Missing description
site_id	integer	Stores the site ID the model was trained on

recommendations.ml_factorization_models: Missing description
Name	Type	Description
id	integer	The primary key for the table
contents	bytea	Store a factorization model used in table recommendations
site_id	integer	Stores the site ID the model was trained on
created_at	timestamp without time zone	The time at which this model was created.

recommendations.ml_last_trained: Track model loading and training on a per-site basis so it can be resumed if interrupted
Name	Type	Description
id	integer	Missing description
site_id	integer	ID for the site the model is trained on
started_at	timestamp without time zone	Time at which loading and training began
completed_at	timestamp without time zone	Time at which loading and training successfully completed
training_result	integer	Result code for training on site (1: In progress, 2: Failed, 3: Interrupted, 4: Crashed, 5: Success )
trainer_type	integer	Type of trainer that was used to produce this result: 1=datasource, 2=viz

recommendations.ml_ranked_datasource_fields: Selected top fields per datasource and their usage statistics (for published datasources)
Name	Type	Description
id	integer	The primary key for the table
datasource_remote_id	integer	Corresponds to the field datasources.datasources_id (in recommendations schema), and the primary key field datasources.id (in public schema)
field_name	text	Corresponds to the field fields.caption (in recommendations schema)
usage	integer	Stores the count of the workbooks referencing the field name
site_id	integer	Stores the site ID the model was trained on

recommendations.ml_related_view_predictions: view predictions generated by the trainer
Name	Type	Description
id	integer	primary key
site_id	integer	reference to the site id in public schema
view_remote_id	integer	reference to the view id in public schema
view_remote_luid	uuid	reference to the view luid in public schema
predictions_json	json	view predictions info stored as json

recommendations.ml_viz_recommendations_models: Viz recommendations models. Stores a model per user, site pair.
Name	Type	Description
id	integer	primary key
contents	bytea	binarized json string containing the viz recommendations model
site_id	integer	reference to the site which the recommendations belong to
user_id	integer	reference to the user which the recommendations belong to. This id refers back to the table users in the public schema

recommendations.views_json: Views info stored as json
Name	Type	Description
id	integer	primary key
luid	uuid	reference to the view luid in public schema
site_id	integer	reference to the site id in public schema
content	json	content of the view info stored as json
last_published_at	timestamp without time zone	The UTC time at which the content was published.
query_version	smallint	Missing description

recommendations.workbooks: Missing description
Name	Type	Description
id	integer	The primary key for the table
name	character varying	The name of the workbook as extracted from workgroup.workbooks.name
workbooks_id	integer	The id of the workbook as extracted from workgroup.workbooks.id
site_id	integer	The id of the workbook as extracted from workgroup.workbooks.id
last_published_at	timestamp without time zone	Used to determine if this extracted record is out of date

recommendations.worksheet_fields: Missing description
Name	Type	Description
Foreign key/Primary key relation from rec_fields_id on this table to id on table, recommendations.fields
Foreign key/Primary key relation from rec_worksheets_id on this table to id on table, recommendations.worksheets
id	integer	The primary key for the table
rec_worksheets_id	integer	Missing description
rec_fields_id	integer	Missing description

recommendations.worksheets: Missing description
Name	Type	Description
Foreign key/Primary key relation from rec_workbooks_id on this table to id on table, recommendations.workbooks
id	integer	The primary key for the table
name	character varying	Missing description
rec_workbooks_id	integer	Missing description

semantics.indexing_status: This table holds indexing status of field concepts.
Name	Type	Description
Foreign key/Primary key relation from field_concept_key, ontology_id on this table to key, ontology_id on table, semantics.ss_field_concepts
id	bigint	Unique id for each row of indexing_status.
created_at	timestamp with time zone	The timestamp for when this row entry was created.
updated_at	timestamp with time zone	The timestamp for when this row entry was updated.
field_concept_key	text	field_concept_key referencing to ss_field_concepts.
ontology_id	bigint	Ontology id referencing to ontology_id in ss_field_concepts.
indexing_status	integer	References to current indexing status for a field_concept.
error_code	integer	References to error_code for error occurred while indexing.
indexed_value_concept_version	text	Version of the field concept index.

webhooks.webhooks: Holds metadata for all registered webhooks on the server.
Name	Type	Description
luid	uuid	Primary key for the webhook.
site_luid	uuid	The site that the webhook belongs to.
version	integer	The version of this webhook. 1 on create, monotonically increasing with each update of the webhook.
owner_luid	uuid	The user who is the current owner of the webhook.
url	text	The fully specified URL for the webhook to POST to when triggered.
body_template	text	JSON template for the body of the request to send when the webhook is triggered.
event_type	text	The type of event on the server that will trigger this webhook e.g datasource refresh.
name	text	Human readable name for the webhook, defaults to the value Unnamed Webhook.
isenabled	boolean	Whether the webhook is currently run on trigger events
statuschangereason	text	Record the reason for any automated disabling/enabling of a webhook
failedattempts	integer	Number of consecutive failed delivery attempts

public._background_tasks: This view combines the important contents of both the background_jobs table and the async_jobs table to give an overall picture of jobs that were given to a backgrounder process.
Name	Type	Description
backgrounder_id	character varying	The id of the backgrounder process that did the work.
id	integer	The primary key of either the background_jobs record or the async_jobs record, depending on where this record is coming from.
created_at	timestamp without time zone	When this record was created.
completed_at	timestamp without time zone	When the job finished execution. When set, this should generally agree with the updated_at field.
finish_code	integer	Completion status for the job. Will be 0 for success, 1 for failure, and 2 for cancelled.
job_type	character varying	The type of job being run. This looks a bit odd because it comes from a serialized symbol.
progress	integer	Can be used to indicate percent complete for the job, but in most cases simply gets set to 100 when the job is completed.
args	text	Used as a means of passing parameters about the background job. This information is stored in a special serialized format, and thus is not easily readable.
notes	text	Can be used to store additional information about the running of the job.
started_at	timestamp without time zone	When the execution of the job was started. This is not generally the same as created_at, because it may take some time before a backgrounder "notices" the newly created record and begins to process it.
job_name	character varying	A nice readable name for this type of job.
priority	integer	Controls which background_jobs records are processed first. The highest priority is 0, and the lowest is 100. Integer values in between are also valid.
title	character varying	Can be used to provide some additional information about the job.
processed_on_worker	character varying	Identifies the machine on which the job is run.
subtitle	character varying	Can be used to provide some additional information about the job.
language	character varying	The language for the job is listed here.
site_id	integer	Links to a site, if one is relevant, otherwise it is left NULL.
locale	character varying	The locale for the job is listed here.
subscriptions_attach_image	boolean	Boolean that represents whether to attach images to a subscription background_job. Will be NULL if the background_job is not a subscription.
subscriptions_attach_pdf	boolean	Boolean that represents whether to attach a PDF to a subscription background_job. Will be NULL if the background_job is not a subscription.

public._comments: Comments users made on views.
Name	Type	Description
id	integer	Primary key for the underlying comments record.
title	text	Not used.
comment	text	Comment text.
commentable_type	character varying	View.
created_at	timestamp without time zone	Date when comment was created.
drawing	text	Not used.
commentable_id	integer	Corresponding view id.
user_id	integer	Id of the user who made the comment.
site_id	integer	Links to the site that the user and this comment belong to.

public._customized_views: When a user creates a customized view, the data that supports that goes in the customized_views table, and is reflected in this view.
Name	Type	Description
name	character varying	A combination of the site name and the customized_view name.
repository_url	character varying	URL text created from workbook, sheet domain, and url_id.
id	integer	Primary key for the underlying customized_views record.
size	integer	The number of bytes it took to describe the changes from the base view to the customized view.
view_name	character varying	The name of the view that this customized view is based on.
sheet_id	character varying	An identifier for the sheet. Based on the name of the sheet.
workbook_url	text	A unique name for the workbook, that contains the base view, derived from the ASCII characters in the name, which can be used in URLs to refer to this workbook.
workbook_name	character varying	The actual name of the workbook, that contains the base view, derived from the ASCII characters in the name, which can be used in URLs to refer to this workbook.
email	character varying	The email of the system_user associated with this customized view.
user_name	character varying	The name of the system_user associated with this customized view.
site_id	integer	A foreign key to the site that this customized view is associated with (the site of the user who created it).

public._datasources: Shows all Published datasources on server, along with some associated information.
Name	Type	Description
id	integer	Primary key for the underlying datasources record.
name	character varying	The name of the published datasource.
datasource_url	text	Uniquely identifies a datasource. More or less consists of a slightly modified name, but not totally obviously, especially in the presence of non-ASCII characters. Used in URLs meant to access this datasource.
owner_id	integer	The user ID of the owner/uploader of the datasource.
owner_name	character varying	The name of the system_user linked to owner_id
created_at	timestamp without time zone	When this record was created.
updated_at	timestamp without time zone	When this record was last updated.
size	bigint	The size in bytes of the datasource.
project_id	integer	The associated project ID where the datasource was published.
project_name	character varying	The name of the project linked via project_id.
server	text	DNS server name to connect to (for the associated data_connection record).
dbclass	character varying	Type of data connection (ie mysql, postgres, sqlproxy etc) (for the associated data_connection record).
port	integer	TCP port number of the connect (eg. 5432 for postgres) (for the associated data_connection record).
username	text	Username to use when connecting.
dbname	character varying	The database name associated with the linked data_connection record.
owner_type	character varying	"Datasource"
system_user_id	integer	The system_user linked to the user whose id is owner_id.
site_id	integer	The site that contains this datasource.
domain_id	integer	A foreign key reference to the domain of the owner.
domain_name	character varying	The name is either "local" or the name of some Active Directory group.

public._datasources_stats: Some historical useage information about datasources. Based on the records that exist in the historical events tables.
Name	Type	Description
nviews	bigint	The number of times that the datasource has been accessed.
last_access_time	timestamp without time zone	The most recent access of the datasource
datasource_id	integer	Links to the datasource whose usage is being described.
site_id	integer	The site in which this datasource exists.

public._groups: A grouping of users. Can be locally created or imported from Active Directory. Reflects the contents of the groups table and associated tables.
Name	Type	Description
id	integer	The primary key of the underlying groups record.
name	character varying	The name that was given to the group.
site_name	character varying	The name of the site that this group belongs in.
domain_name	character varying	The name of the domain that this group is linked to.
domain_short_name	character varying	A short version of the domain that this group is linked to.
domain_family	character varying	Either local or ActiveDirectory.

public._http_requests: Each record represents a request received by Tableau Server. Reflects data in the http_requests table.
Name	Type	Description
controller	character varying	The part of the application that received the request.
action	character varying	The action requested.
http_referer	character varying	The referrer.
http_user_agent	character varying	The agent string supplied by the client.
http_request_uri	text	The requested URI.
remote_ip	character varying	The client's IP address (from the perspective of the server).
created_at	timestamp without time zone	When this record was created.
session_id	character varying	The session with which the request is associated.
completed_at	timestamp without time zone	When the request was completed.
port	integer	The port on which the request was received.
user_id	integer	The user associated with the request.
worker	character varying	Which worker machine received the request.
vizql_session	text	The vizql session associated with this request.
user_ip	character varying	The IP address of the originator of the request.
currentsheet	character varying	Which sheet was being viewed.
site_id	integer	The site associated with the request.

public._projects: Each row of the table corresponds to a project on Tableau Server.
Name	Type	Description
id	integer	Primary key for the underlying record in the projects table.
name	character varying	The name of the project.
created_at	timestamp without time zone	The time at which this record was created.
owner_id	integer	The id of the user who owns this project.
owner_name	character varying	The name of the system_user who owns this project.
system_user_id	integer	The id of the system_user who owns this project.
site_id	integer	Refers to the site which contains this project.

public._schedules: Records define a schedule according to which certain regular tasks may be performed (see tasks table). They also indicate the next time at which the schedule will be triggered.
Name	Type	Description
id	integer	Primary key for the record in the underlying schedules table.
name	character varying	A schedule can be given a name, which is stored here.
active	boolean	If set to false, this means that the schedule is inactive, meaning that no tasks will be performed when the schedules triggers.
priority	integer	Priority can range from 1 to 100, with lower values corresponding to higher priority.
schedule_type	integer	One of 0 (Hourly), 1 (Daily), 2 (Weekly), 3 (Monthly).
day_of_week_mask	integer	Indicates which day of the week this schedule will run. The information is encoded in the given integer. To interpret it, convert the integer to binary. The days of the week correspond to Sunday : 1, Monday : 10, Tuesday : 100, Wednesday : 1000, Thursday : 10000, Friday : 100000, Saturday : 1000000.
day_of_month_mask	integer	Indicates which day of the month this schedule will run. The information is encoded in the given integer. To interpret it, convert the integer to binary. The days of the month correspond to 1st : 1, 2nd: 10, 3rd: 100, 4th: 1000, 5th: 10000, etc.
start_at_minute	integer	The minute following the start of the designated time period implied by the schedule_type. For example, for a daily schedule, this would be number of minutes past midnight at the start of the day. For hourly, it would be the number of minutes past the beginning of the hour.
minute_interval	integer	Once the schedule triggers, it will retrigger at this interval during the time period implied by the schedule_type or until end_at_minute, or end_schedule_at.
end_at_minute	integer	The minute following the start of the designated time period implied schedule_type, at which the schedule should stop triggering.
end_schedule_at	timestamp without time zone	Used to indicate a point in time, after which the schedule should never trigger.
run_next_at	timestamp without time zone	When the schedule will next trigger.
created_at	timestamp without time zone	The time at which this record was created.
updated_at	timestamp without time zone	The last time any changes were made to this record.
hidden	boolean	If set to true, then this schedule will not be listed in the GUI, otherwise it will be.
serial_collection_id	integer	A foreign key to the serial_collections table. Two jobs with the same serial_collection_id cannot be processed simultaneously. When the job record for a task linked to this schedule is created, it is assigned this serial_collection_id.
lock_version	integer	Used to implement "optimistic locking" by JPA/Hibernate. The counter increases each time the record is changed. Not useful for customers.
scheduled_action	integer	Used to classify schedules into one of two categories: 0 (Extract related) 1 (Subscription related)
scheduled_action_type	text	A friendly string representation of the type of scheduled action.
defined_by	integer	The mechanism type of how the schedule is created, e.g. 0 for system_admin, 1 for self_service.

public._sessions: Settings associated with a user's browser session.
Name	Type	Description
session_id	character varying	Session identifier.
updated_at	timestamp without time zone	Time when session was last updated, used to expire inactive sessions.
user_id	integer	Foreign key to users table. Tells the user whose session this is.
user_name	character varying	The name of the system_user linked to the user whose session this is.
system_user_id	integer	The id of the system_user linked to the user whose session this is.
site_id	integer	The site that this session belongs to.

public._sites: Each record represents a site. Each site holds its own workbooks, datasources, users, etc. Strict isolation between the contents of each site is maintained.
Name	Type	Description
id	integer	Primary key for the underlying sites record.
name	character varying	The name of the site.
url_namespace	character varying	String used in the construction of URLs that target this site.
status	character varying	One of "active" "suspended" or "locked".

public._subscriptions: Each record provides information about subscriptions that are scheduled. Subscriptions are a mechanism for receiving specified content by email on some schedule.
Name	Type	Description
id	integer	Primary key for the underlying subscriptions record.
subject	character varying	A string that describes the nature of the subscription.
content_type	text	Describes what type of content is being delivered by this subscription. One of: "Customized View - Single View", "Workbook", "Single View", or "Customized View - Workbook".
view_url	text	A URL string that describes the view to be delivered, when the subscription is for a view.
workbook_url	text	A URL string that describes the workbook to be delivered, when the subscription is for a workbook.
customized_view_id	integer	A foreign key reference to the customized view, if the subscription is for a customized view.
last_sent	timestamp without time zone	The last time at which the the subscription was sent.
user_id	integer	A foreign key reference to the user who will receive the subscription.
user_name	character varying	The name of the system_user who will receive the subscription.
site_id	integer	The site that the subscription (and the user) belongs to.
site_name	character varying	The name of the site that the subscription (and the user) belongs to.
schedule_name	character varying	The name of the schedule that this subscription runs under.
schedule_active	boolean	If set to false, this means that the subscription is inactive.
schedule_run_next_at	timestamp without time zone	The next time the subscription should be sent.
schedule_priority	integer	Priority can range from 1 to 100, with lower values corresponding to higher priority.

public._system_users: Each record represents a user of the server. These records correspond to login identity. A single system_user may potentially be able to login to multiple sites. The linkage between a system_user and their allowed sites is defined through the "users" table.
Name	Type	Description
id	integer	Primary key for the underlying system_user record.
name	character varying	The username of the user.
email	character varying	The email of the user.
friendly_name	character varying	A friendly name that might be used in the GUI to refer to the user.
custom_display_name	boolean	If set to true, this prevents the friendly_name from potentially being overwritten by Active Airectory information when the user is read in from Active Directory. Seldom done.
admin_level	integer	Indicates if the user is a system administrator. 10 : system admin, 0 : not a system admin
domain_name	character varying	The name of the domain that the user belongs to. The name is either "local" or the name of some Active Directory group.
domain_short_name	character varying	An alternate shorter form of the name
domain_family	character varying	Either local or ActiveDirectory.

public._tags: Each tag is a string value. A given tag can be associated with many taggable items in a site.
Name	Type	Description
tag_id	integer	The primary key for the underlying tags table.
tag_name	character varying	The value of the tag.
object_type	character varying	The type of the taggable item - this is used to identify which table to join to.
taggable_id	integer	The ID of the taggable item.
object_id	integer	The same as taggable_id.
object_name	character varying	The name of the view, workbook, or datasource that is being tagged.
user_id	integer	The ID of the user that owns the tagging.
user_name	character varying	The name of the system_user that owns the tagging.
system_user_id	integer	The id of the system_user that owns the tagging.
site_id	integer	The site in which the tagged object exists (likewise the user, etc.).

public._users: Information relating to users.
Name	Type	Description
id	integer	Primary key for the underlying user record.
name	character varying	The name of the system_user linked to the user record.
login_at	timestamp without time zone	The time of the most recent login for this user.
friendly_name	character varying	The friendly name of the system_user linked to the user record.
licensing_role_id	integer	Foreign key reference to the licensing_roles table. Indicates the licensing role that is assigned to this user.
licensing_role_name	character varying	The name of the licensing role that is assigned to this user.
domain_id	integer	The domain_id of the system_user linked to the user record.
system_user_id	integer	The id of the system_user linked to the user record.
domain_name	character varying	The domain_name of the system_user linked to the user record.
domain_short_name	character varying	The a shorter version of the domain_name of the system_user linked to the user record.
site_id	integer	The id of the site that the user belongs to.

public._views: Each records represents a view in a workbook.
Name	Type	Description
id	integer	Primary key for the underlying views record.
name	character varying	The name of the view.
view_url	text	Uniquely identifies a view. More or less composed of workbook and sheet names, but not totally obviously, especially in the presence of non-ASCII characters. Used in URLs meant to access this view.
created_at	timestamp without time zone	The time at which the underlying views record was created.
owner_id	integer	A foreign key reference to the user who owns this view.
owner_name	character varying	The name of the user who owns this view.
workbook_id	integer	A foreign key reference to the workbook the view is part of.
index	integer	Each view has an index that is unique among views belonging to that workbook.
title	text	A title for the worksheet extracted from the workbook's twb file.
caption	text	A descriptive phrase constructed for the worksheet, based on the workbook definition.
site_id	integer	A foreign key link to the site to which this view belongs.

public._views_stats: Used to track how many times each user has accessed different views.
Name	Type	Description
users_id	integer	A foreign key reference to a particular user.
system_users_name	character varying	The name of the system_user that corresponds to the user.
users_login_at	timestamp without time zone	The time of the most recent login for this user.
system_users_friendly_name	character varying	The friendly_name of the system_user that corresponds to the user.
views_id	integer	A foreign key reference to the view that was accessed. This field must be populated.
system_users_id	integer	The id of the system_user that corresponds to the user.
views_name	character varying	The name of the view that was accessed.
views_url	text	Uniquely identifies a view. More or less composed of workbook and sheet names, but not totally obviously, especially in the presence of non-ASCII characters. Used in URLs meant to access this view.
views_workbook_id	integer	A foreign key reference to the workbook the view is part of.
views_created_at	timestamp without time zone	The time at which the view was created.
views_owner_id	integer	A foreign key reference to the user who owns the view.
views_index	integer	Each view has an index that is unique among views belonging to that workbook.
views_title	text	A title for the worksheet extracted from the workbook's twb file.
views_caption	text	A descriptive phrase constructed for the worksheet, based on the workbook definition.
device_type	text	DSD device type detected (non-null only if view is dashboard in non-authoring mode)
nviews	integer	Keeps a cumulative count of the number of times the view was accessed by this user.
last_view_time	timestamp without time zone	The time of the most recent access of the specified view by the specified user.
site_id	integer	Links to the site that contains the view.

public._workbooks: Each record represents a workbook that exists on the server.
Name	Type	Description
id	integer	The primary key for the underlying workbook record.
name	character varying	The name of the workbook.
workbook_url	text	A unique name for the workbook, derived from the ASCII characters in the name, which can be used in URLs to refer to this workbook.
created_at	timestamp without time zone	The time at which the workbook record was created.
updated_at	timestamp without time zone	The last time any changes were made to this workbook record.
owner_id	integer	A foreign key reference to the user that owns this workbook.
project_id	integer	A foreign key reference to the project in which this workbook exists.
size	bigint	The number of bytes used in storing the workbook information.
view_count	integer	Keeps count of the number of views that are associated with this workbook.
owner_name	character varying	The name of the system_user who is the owner.
project_name	character varying	The name of the project that this workbook is part of.
system_user_id	integer	The id of the system_user who is the owner.
site_id	integer	Links to the site that contains this workbook.
domain_id	integer	A foreign key reference to the domain of the owner.
domain_name	character varying	The name is either "local" or the name of some Active Directory group.

public.identity_based_activation_admin_view: Login-based License Management (LBLM) - Database view to faciliate Admin Server and Site Views for Login-based License Usage Reporting.
Name	Type	Description
iba_user_id	character varying	Generated Id for user for IBA Reporting
site_id	integer	Site being used.
device_fingerprint	character varying	Uniquely identifies device. Built/generated from umn.
product_type	character varying	Product being used at the client level.
user_role	character varying	Values: CREATOR, SITE_ADMINISTRATOR, SERVER_ADMINISTRATOR
host_name	character varying	Computer host name.
product_version	character varying	application/product version being used at the client level.
registration_first_name	character varying	Registered user first name
registration_last_name	character varying	Registered user last name
registration_email	character varying	Registered user email address
registration_date	timestamp without time zone	Date active key was registered.
client_user_name	character varying	Login/User name from the client level.
atr_expiration_date	timestamp without time zone	Expiration date of active key. NULL means permanent.
hardware_serial_number	character varying	Uniquely identifies company's hardware asset.
registration_custom_field	character varying	custom field from registration
machine_os	character varying	os_architecture
virtual_machine	boolean	is the machine virtual
atr_chain_id	character varying	ATR Chain Id
domain_information	character varying	Computer Active Directory domain.
date_atr_issued	timestamp without time zone	date-time when the ATR successfully returned from the server for this user, device, product and site.
date_atr_failed	timestamp without time zone	date-time when the ATR successfully returned from the server for this user, device, product and site.
date_last_updated	timestamp without time zone	date-time the last time this row was updated in any way for a given user, productType, device and site.
server_user_name	character varying	User friendly name on the server level.
server_email	character varying	Email for user on the server level.
site_luid	character varying	LUID from sites table.
date_activated	timestamp without time zone	date-time when the user activated this product from this device for this site for the first time.
date_last_used	timestamp without time zone	date-time the last time the user used this product from this device for this site.
date_creator_role_assigned	timestamp without time zone	Datetime user was assigned a creator role. Triggered by site role change in the users table.
date_creator_role_unassigned	timestamp without time zone	Datetime user was unassigned a creator role. Triggered by site role change in the users table.
site_name	character varying	The name of the site sourced from the name column in the sites table.

public.users_view: Each record corresponds to a user on the system. The data presented is a combination of user data and data from the linked system_user.
Name	Type	Description
email	character varying	The email of the system_user.
login_at	timestamp without time zone	The last time the system_user logged in.
name	character varying	The name of the system_user.
id	integer	The id of the underlying users record.
system_user_id	integer	The id of the linked system_users record.

Workgroups Database

Introduction

Contents

Tables (these are available to the "readonly" user)

Views (these are available to both the "tableau" and the "readonly" users)