Skip to main content
Edit this page on GitHub

Resources

Entity-Relationship Diagram​

Here is our interactive ERD:

Apache Superset ERDSQL LabData AssetsCoreSystemInherited from Flask App Builder (FAB)Alerts & ReportsTableSchema (table_schema)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERtab_state_id: INTEGERdatabase_id: INTEGERdescription: TEXTexpanded: BOOLEANcreated_by_fk: INTEGERchanged_by_fk: INTEGERschema: VARCHAR(256)catalog: VARCHAR(256)table: VARCHAR(256)Query (query)tracking_url: TEXTextra_json: TEXTid: INTEGERdatabase_id: INTEGERuser_id: INTEGERsql: TEXTselect_sql: TEXTexecuted_sql: TEXTlimit: INTEGERselect_as_cta: BOOLEANselect_as_cta_used: BOOLEANprogress: INTEGERrows: INTEGERerror_message: TEXTchanged_on: DATETIMEclient_id: VARCHAR(11)tmp_table_name: VARCHAR(256)tmp_schema_name: VARCHAR(256)status: VARCHAR(16)tab_name: VARCHAR(256)sql_editor_id: VARCHAR(256)schema: VARCHAR(256)catalog: VARCHAR(256)limiting_factor: VARCHAR(18)ctas_method: VARCHAR(16)results_key: VARCHAR(64)start_time: NUMERIC(20, 6)start_running_time: NUMERIC(20, 6)end_time: NUMERIC(20, 6)end_result_backend_time: NUMERIC(20, 6)TabState (tab_state)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERuser_id: INTEGERactive: BOOLEANdatabase_id: INTEGERsql: TEXTquery_limit: INTEGERlatest_query_id: INTEGERautorun: BOOLEANtemplate_params: TEXThide_left_bar: BOOLEANsaved_query_id: INTEGERcreated_by_fk: INTEGERchanged_by_fk: INTEGERlabel: VARCHAR(256)schema: VARCHAR(256)catalog: VARCHAR(256)SavedQuery (saved_query)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERuser_id: INTEGERdb_id: INTEGERdescription: TEXTsql: TEXTtemplate_parameters: TEXTrows: INTEGERlast_run: DATETIMEcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)schema: VARCHAR(128)catalog: VARCHAR(256)label: VARCHAR(256)RowLevelSecurityFilter (row_level_security_filters)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERdescription: TEXTclause: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERname: VARCHAR(255)filter_type: VARCHAR(7)group_key: VARCHAR(255)SqlaTable (tables)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERdescription: TEXTdefault_endpoint: TEXTis_featured: BOOLEANfilter_select_enabled: BOOLEANoffset: INTEGERcache_timeout: INTEGERis_managed_externally: BOOLEANexternal_url: TEXTdatabase_id: INTEGERfetch_values_predicate: TEXTsql: TEXTis_sqllab_view: BOOLEANtemplate_params: TEXTextra: TEXTnormalize_columns: BOOLEANalways_filter_main_dttm: BOOLEANcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)params: VARCHAR(1000)perm: VARCHAR(1000)schema_perm: VARCHAR(1000)catalog_perm: VARCHAR(1000)table_name: VARCHAR(250)main_dttm_col: VARCHAR(250)schema: VARCHAR(255)catalog: VARCHAR(256)Column (sl_columns)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERis_additive: BOOLEANis_aggregation: BOOLEANis_filterable: BOOLEANis_dimensional: BOOLEANis_increase_desired: BOOLEANis_managed_externally: BOOLEANis_partition: BOOLEANis_physical: BOOLEANis_spatial: BOOLEANis_temporal: BOOLEANname: TEXTtype: TEXTadvanced_data_type: TEXTexpression: TEXTunit: TEXTdescription: TEXTwarning_text: TEXTexternal_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)SqlMetric (sql_metrics)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERdescription: TEXTwarning_text: TEXTtable_id: INTEGERexpression: TEXTextra: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)metric_name: VARCHAR(255)verbose_name: VARCHAR(1024)metric_type: VARCHAR(32)d3format: VARCHAR(128)currency: VARCHAR(128)Database (dbs)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERpassword: BLOBcache_timeout: INTEGERselect_as_create_table_as: BOOLEANexpose_in_sqllab: BOOLEANallow_run_async: BOOLEANallow_file_upload: BOOLEANallow_ctas: BOOLEANallow_cvas: BOOLEANallow_dml: BOOLEANextra: TEXTencrypted_extra: BLOBimpersonate_user: BOOLEANserver_cert: BLOBis_managed_externally: BOOLEANexternal_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)verbose_name: VARCHAR(250)database_name: VARCHAR(250)sqlalchemy_uri: VARCHAR(1024)configuration_method: VARCHAR(255)force_ctas_schema: VARCHAR(250)Table (sl_tables)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERdatabase_id: INTEGERcatalog: TEXTschema: TEXTname: TEXTis_managed_externally: BOOLEANexternal_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)Dataset (sl_datasets)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERdatabase_id: INTEGERis_physical: BOOLEANis_managed_externally: BOOLEANname: TEXTexpression: TEXTexternal_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)TableColumn (table_columns)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERis_active: BOOLEANtype: TEXTgroupby: BOOLEANfilterable: BOOLEANdescription: TEXTtable_id: INTEGERis_dttm: BOOLEANexpression: TEXTextra: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)column_name: VARCHAR(255)verbose_name: VARCHAR(1024)advanced_data_type: VARCHAR(255)python_date_format: VARCHAR(255)DatabaseUserOAuth2Tokens (database_user_oauth2_tokens)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERuser_id: INTEGERdatabase_id: INTEGERaccess_token: BLOBaccess_token_expiration: DATETIMErefresh_token: BLOBcreated_by_fk: INTEGERchanged_by_fk: INTEGERDynamicPlugin (dynamic_plugin)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERname: TEXTkey: TEXTbundle_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERTag (tag)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERdescription: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERname: VARCHAR(250)type: VARCHAR(12)AnnotationLayer (annotation_layer)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERdescr: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERname: VARCHAR(250)UserAttribute (user_attribute)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERuser_id: INTEGERwelcome_dashboard_id: INTEGERcreated_by_fk: INTEGERchanged_by_fk: INTEGERavatar_url: VARCHAR(100)Dashboard (dashboards)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERposition_json: TEXTdescription: TEXTcss: TEXTcertified_by: TEXTcertification_details: TEXTjson_metadata: TEXTpublished: BOOLEANis_managed_externally: BOOLEANexternal_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)dashboard_title: VARCHAR(500)slug: VARCHAR(255)Annotation (annotation)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERstart_dttm: DATETIMEend_dttm: DATETIMElayer_id: INTEGERlong_descr: TEXTjson_metadata: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERshort_descr: VARCHAR(500)TaggedObject (tagged_object)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERtag_id: INTEGERobject_id: INTEGERcreated_by_fk: INTEGERchanged_by_fk: INTEGERobject_type: VARCHAR(9)CssTemplate (css_templates)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERcss: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERtemplate_name: VARCHAR(250)FavStar (favstar)id: INTEGERuser_id: INTEGERobj_id: INTEGERdttm: DATETIMEclass_name: VARCHAR(50)Slice (slices)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERdatasource_id: INTEGERparams: TEXTquery_context: TEXTdescription: TEXTcache_timeout: INTEGERlast_saved_at: DATETIMElast_saved_by_fk: INTEGERcertified_by: TEXTcertification_details: TEXTis_managed_externally: BOOLEANexternal_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)slice_name: VARCHAR(250)datasource_type: VARCHAR(200)datasource_name: VARCHAR(2000)viz_type: VARCHAR(250)perm: VARCHAR(1000)schema_perm: VARCHAR(1000)catalog_perm: VARCHAR(1000)EmbeddedDashboard (embedded_dashboards)created_on: DATETIMEchanged_on: DATETIMEallow_domain_list: TEXTdashboard_id: INTEGERcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)CacheKey (cache_keys)id: INTEGERcache_timeout: INTEGERcreated_on: DATETIMEcache_key: VARCHAR(256)datasource_uid: VARCHAR(64)SSHTunnel (ssh_tunnels)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERdatabase_id: INTEGERserver_address: TEXTserver_port: INTEGERusername: BLOBpassword: BLOBprivate_key: BLOBprivate_key_password: BLOBcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)KeyValueEntry (key_value)id: INTEGERvalue: BLOBcreated_on: DATETIMEcreated_by_fk: INTEGERchanged_on: DATETIMEexpires_on: DATETIMEchanged_by_fk: INTEGERuuid: BINARY(16)resource: VARCHAR(32)Log (logs)id: INTEGERuser_id: INTEGERdashboard_id: INTEGERslice_id: INTEGERjson: TEXTdttm: DATETIMEduration_ms: INTEGERaction: VARCHAR(512)referrer: VARCHAR(1024)KeyValue (keyvalue)id: INTEGERvalue: TEXTViewMenu (ab_view_menu)id: INTEGERname: VARCHAR(250)PermissionView (ab_permission_view)id: INTEGERpermission_id: INTEGERview_menu_id: INTEGERRegisterUser (ab_register_user)id: INTEGERregistration_date: DATETIMEfirst_name: VARCHAR(64)last_name: VARCHAR(64)username: VARCHAR(64)password: VARCHAR(256)email: VARCHAR(64)registration_hash: VARCHAR(256)Permission (ab_permission)id: INTEGERname: VARCHAR(100)User (ab_user)id: INTEGERactive: BOOLEANlast_login: DATETIMElogin_count: INTEGERfail_login_count: INTEGERcreated_on: DATETIMEchanged_on: DATETIMEcreated_by_fk: INTEGERchanged_by_fk: INTEGERfirst_name: VARCHAR(64)last_name: VARCHAR(64)username: VARCHAR(64)password: VARCHAR(256)email: VARCHAR(320)Role (ab_role)id: INTEGERname: VARCHAR(64)ReportRecipients (report_recipient)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERrecipient_config_json: TEXTreport_schedule_id: INTEGERcreated_by_fk: INTEGERchanged_by_fk: INTEGERtype: VARCHAR(50)ReportSchedule (report_schedule)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERdescription: TEXTcontext_markdown: TEXTactive: BOOLEANsql: TEXTchart_id: INTEGERdashboard_id: INTEGERdatabase_id: INTEGERlast_eval_dttm: DATETIMElast_value: FLOATlast_value_row_json: TEXTvalidator_config_json: TEXTlog_retention: INTEGERgrace_period: INTEGERworking_timeout: INTEGERforce_screenshot: BOOLEANcustom_width: INTEGERcustom_height: INTEGERcreated_by_fk: INTEGERchanged_by_fk: INTEGERtype: VARCHAR(50)name: VARCHAR(150)crontab: VARCHAR(1000)creation_method: VARCHAR(255)timezone: VARCHAR(100)report_format: VARCHAR(50)last_state: VARCHAR(50)validator_type: VARCHAR(100)ReportExecutionLog (report_execution_log)id: INTEGERscheduled_dttm: DATETIMEstart_dttm: DATETIMEend_dttm: DATETIMEvalue: FLOATvalue_row_json: TEXTerror_message: TEXTreport_schedule_id: INTEGERuuid: BINARY(16)state: VARCHAR(50)
Apache Superset ERDSQL LabData AssetsCoreSystemInherited from Flask App Builder (FAB)Alerts & ReportsTableSchema (table_schema)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERtab_state_id: INTEGERdatabase_id: INTEGERdescription: TEXTexpanded: BOOLEANcreated_by_fk: INTEGERchanged_by_fk: INTEGERschema: VARCHAR(256)catalog: VARCHAR(256)table: VARCHAR(256)Query (query)tracking_url: TEXTextra_json: TEXTid: INTEGERdatabase_id: INTEGERuser_id: INTEGERsql: TEXTselect_sql: TEXTexecuted_sql: TEXTlimit: INTEGERselect_as_cta: BOOLEANselect_as_cta_used: BOOLEANprogress: INTEGERrows: INTEGERerror_message: TEXTchanged_on: DATETIMEclient_id: VARCHAR(11)tmp_table_name: VARCHAR(256)tmp_schema_name: VARCHAR(256)status: VARCHAR(16)tab_name: VARCHAR(256)sql_editor_id: VARCHAR(256)schema: VARCHAR(256)catalog: VARCHAR(256)limiting_factor: VARCHAR(18)ctas_method: VARCHAR(16)results_key: VARCHAR(64)start_time: NUMERIC(20, 6)start_running_time: NUMERIC(20, 6)end_time: NUMERIC(20, 6)end_result_backend_time: NUMERIC(20, 6)TabState (tab_state)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERuser_id: INTEGERactive: BOOLEANdatabase_id: INTEGERsql: TEXTquery_limit: INTEGERlatest_query_id: INTEGERautorun: BOOLEANtemplate_params: TEXThide_left_bar: BOOLEANsaved_query_id: INTEGERcreated_by_fk: INTEGERchanged_by_fk: INTEGERlabel: VARCHAR(256)schema: VARCHAR(256)catalog: VARCHAR(256)SavedQuery (saved_query)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERuser_id: INTEGERdb_id: INTEGERdescription: TEXTsql: TEXTtemplate_parameters: TEXTrows: INTEGERlast_run: DATETIMEcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)schema: VARCHAR(128)catalog: VARCHAR(256)label: VARCHAR(256)RowLevelSecurityFilter (row_level_security_filters)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERdescription: TEXTclause: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERname: VARCHAR(255)filter_type: VARCHAR(7)group_key: VARCHAR(255)SqlaTable (tables)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERdescription: TEXTdefault_endpoint: TEXTis_featured: BOOLEANfilter_select_enabled: BOOLEANoffset: INTEGERcache_timeout: INTEGERis_managed_externally: BOOLEANexternal_url: TEXTdatabase_id: INTEGERfetch_values_predicate: TEXTsql: TEXTis_sqllab_view: BOOLEANtemplate_params: TEXTextra: TEXTnormalize_columns: BOOLEANalways_filter_main_dttm: BOOLEANcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)params: VARCHAR(1000)perm: VARCHAR(1000)schema_perm: VARCHAR(1000)catalog_perm: VARCHAR(1000)table_name: VARCHAR(250)main_dttm_col: VARCHAR(250)schema: VARCHAR(255)catalog: VARCHAR(256)Column (sl_columns)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERis_additive: BOOLEANis_aggregation: BOOLEANis_filterable: BOOLEANis_dimensional: BOOLEANis_increase_desired: BOOLEANis_managed_externally: BOOLEANis_partition: BOOLEANis_physical: BOOLEANis_spatial: BOOLEANis_temporal: BOOLEANname: TEXTtype: TEXTadvanced_data_type: TEXTexpression: TEXTunit: TEXTdescription: TEXTwarning_text: TEXTexternal_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)SqlMetric (sql_metrics)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERdescription: TEXTwarning_text: TEXTtable_id: INTEGERexpression: TEXTextra: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)metric_name: VARCHAR(255)verbose_name: VARCHAR(1024)metric_type: VARCHAR(32)d3format: VARCHAR(128)currency: VARCHAR(128)Database (dbs)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERpassword: BLOBcache_timeout: INTEGERselect_as_create_table_as: BOOLEANexpose_in_sqllab: BOOLEANallow_run_async: BOOLEANallow_file_upload: BOOLEANallow_ctas: BOOLEANallow_cvas: BOOLEANallow_dml: BOOLEANextra: TEXTencrypted_extra: BLOBimpersonate_user: BOOLEANserver_cert: BLOBis_managed_externally: BOOLEANexternal_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)verbose_name: VARCHAR(250)database_name: VARCHAR(250)sqlalchemy_uri: VARCHAR(1024)configuration_method: VARCHAR(255)force_ctas_schema: VARCHAR(250)Table (sl_tables)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERdatabase_id: INTEGERcatalog: TEXTschema: TEXTname: TEXTis_managed_externally: BOOLEANexternal_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)Dataset (sl_datasets)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERdatabase_id: INTEGERis_physical: BOOLEANis_managed_externally: BOOLEANname: TEXTexpression: TEXTexternal_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)TableColumn (table_columns)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERis_active: BOOLEANtype: TEXTgroupby: BOOLEANfilterable: BOOLEANdescription: TEXTtable_id: INTEGERis_dttm: BOOLEANexpression: TEXTextra: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)column_name: VARCHAR(255)verbose_name: VARCHAR(1024)advanced_data_type: VARCHAR(255)python_date_format: VARCHAR(255)DatabaseUserOAuth2Tokens (database_user_oauth2_tokens)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERuser_id: INTEGERdatabase_id: INTEGERaccess_token: BLOBaccess_token_expiration: DATETIMErefresh_token: BLOBcreated_by_fk: INTEGERchanged_by_fk: INTEGERDynamicPlugin (dynamic_plugin)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERname: TEXTkey: TEXTbundle_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERTag (tag)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERdescription: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERname: VARCHAR(250)type: VARCHAR(12)AnnotationLayer (annotation_layer)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERdescr: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERname: VARCHAR(250)UserAttribute (user_attribute)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERuser_id: INTEGERwelcome_dashboard_id: INTEGERcreated_by_fk: INTEGERchanged_by_fk: INTEGERavatar_url: VARCHAR(100)Dashboard (dashboards)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERposition_json: TEXTdescription: TEXTcss: TEXTcertified_by: TEXTcertification_details: TEXTjson_metadata: TEXTpublished: BOOLEANis_managed_externally: BOOLEANexternal_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)dashboard_title: VARCHAR(500)slug: VARCHAR(255)Annotation (annotation)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERstart_dttm: DATETIMEend_dttm: DATETIMElayer_id: INTEGERlong_descr: TEXTjson_metadata: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERshort_descr: VARCHAR(500)TaggedObject (tagged_object)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERtag_id: INTEGERobject_id: INTEGERcreated_by_fk: INTEGERchanged_by_fk: INTEGERobject_type: VARCHAR(9)CssTemplate (css_templates)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERcss: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERtemplate_name: VARCHAR(250)FavStar (favstar)id: INTEGERuser_id: INTEGERobj_id: INTEGERdttm: DATETIMEclass_name: VARCHAR(50)Slice (slices)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERdatasource_id: INTEGERparams: TEXTquery_context: TEXTdescription: TEXTcache_timeout: INTEGERlast_saved_at: DATETIMElast_saved_by_fk: INTEGERcertified_by: TEXTcertification_details: TEXTis_managed_externally: BOOLEANexternal_url: TEXTcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)slice_name: VARCHAR(250)datasource_type: VARCHAR(200)datasource_name: VARCHAR(2000)viz_type: VARCHAR(250)perm: VARCHAR(1000)schema_perm: VARCHAR(1000)catalog_perm: VARCHAR(1000)EmbeddedDashboard (embedded_dashboards)created_on: DATETIMEchanged_on: DATETIMEallow_domain_list: TEXTdashboard_id: INTEGERcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)CacheKey (cache_keys)id: INTEGERcache_timeout: INTEGERcreated_on: DATETIMEcache_key: VARCHAR(256)datasource_uid: VARCHAR(64)SSHTunnel (ssh_tunnels)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERdatabase_id: INTEGERserver_address: TEXTserver_port: INTEGERusername: BLOBpassword: BLOBprivate_key: BLOBprivate_key_password: BLOBcreated_by_fk: INTEGERchanged_by_fk: INTEGERuuid: BINARY(16)KeyValueEntry (key_value)id: INTEGERvalue: BLOBcreated_on: DATETIMEcreated_by_fk: INTEGERchanged_on: DATETIMEexpires_on: DATETIMEchanged_by_fk: INTEGERuuid: BINARY(16)resource: VARCHAR(32)Log (logs)id: INTEGERuser_id: INTEGERdashboard_id: INTEGERslice_id: INTEGERjson: TEXTdttm: DATETIMEduration_ms: INTEGERaction: VARCHAR(512)referrer: VARCHAR(1024)KeyValue (keyvalue)id: INTEGERvalue: TEXTViewMenu (ab_view_menu)id: INTEGERname: VARCHAR(250)PermissionView (ab_permission_view)id: INTEGERpermission_id: INTEGERview_menu_id: INTEGERRegisterUser (ab_register_user)id: INTEGERregistration_date: DATETIMEfirst_name: VARCHAR(64)last_name: VARCHAR(64)username: VARCHAR(64)password: VARCHAR(256)email: VARCHAR(64)registration_hash: VARCHAR(256)Permission (ab_permission)id: INTEGERname: VARCHAR(100)User (ab_user)id: INTEGERactive: BOOLEANlast_login: DATETIMElogin_count: INTEGERfail_login_count: INTEGERcreated_on: DATETIMEchanged_on: DATETIMEcreated_by_fk: INTEGERchanged_by_fk: INTEGERfirst_name: VARCHAR(64)last_name: VARCHAR(64)username: VARCHAR(64)password: VARCHAR(256)email: VARCHAR(320)Role (ab_role)id: INTEGERname: VARCHAR(64)ReportRecipients (report_recipient)created_on: DATETIMEchanged_on: DATETIMEid: INTEGERrecipient_config_json: TEXTreport_schedule_id: INTEGERcreated_by_fk: INTEGERchanged_by_fk: INTEGERtype: VARCHAR(50)ReportSchedule (report_schedule)created_on: DATETIMEchanged_on: DATETIMEextra_json: TEXTid: INTEGERdescription: TEXTcontext_markdown: TEXTactive: BOOLEANsql: TEXTchart_id: INTEGERdashboard_id: INTEGERdatabase_id: INTEGERlast_eval_dttm: DATETIMElast_value: FLOATlast_value_row_json: TEXTvalidator_config_json: TEXTlog_retention: INTEGERgrace_period: INTEGERworking_timeout: INTEGERforce_screenshot: BOOLEANcustom_width: INTEGERcustom_height: INTEGERcreated_by_fk: INTEGERchanged_by_fk: INTEGERtype: VARCHAR(50)name: VARCHAR(150)crontab: VARCHAR(1000)creation_method: VARCHAR(255)timezone: VARCHAR(100)report_format: VARCHAR(50)last_state: VARCHAR(50)validator_type: VARCHAR(100)ReportExecutionLog (report_execution_log)id: INTEGERscheduled_dttm: DATETIMEstart_dttm: DATETIMEend_dttm: DATETIMEvalue: FLOATvalue_row_json: TEXTerror_message: TEXTreport_schedule_id: INTEGERuuid: BINARY(16)state: VARCHAR(50)

Download the .svg