data_tables
ab_permission
id: int(11)
name: varchar(100)
ab_permission_view
id: int(11)
permission_id: int(11)
view_menu_id: int(11)
ab_permission_view_role
id: int(11)
permission_view_id: int(11)
role_id: int(11)
ab_register_user
id: int(11)
first_name: varchar(64)
last_name: varchar(64)
username: varchar(64)
password: varchar(256)
email: varchar(64)
registration_date: datetime(0)
registration_hash: varchar(256)
ab_role
id: int(11)
name: varchar(64)
ab_user
id: int(11)
first_name: varchar(64)
last_name: varchar(64)
username: varchar(64)
password: varchar(256)
active: tinyint(1)
email: varchar(64)
last_login: datetime(0)
login_count: int(11)
fail_login_count: int(11)
created_on: datetime(0)
changed_on: datetime(0)
created_by_fk: int(11)
changed_by_fk: int(11)
ab_user_role
id: int(11)
user_id: int(11)
role_id: int(11)
ab_view_menu
id: int(11)
name: varchar(100)
access_request
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
datasource_type: varchar(200)
datasource_id: int(11)
changed_by_fk: int(11)
created_by_fk: int(11)
alembic_version
version_num: varchar(32)
annotation
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
start_dttm: datetime(0)
end_dttm: datetime(0)
layer_id: int(11)
short_descr: varchar(500)
long_descr: text
changed_by_fk: int(11)
created_by_fk: int(11)
annotation_layer
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
name: varchar(250)
descr: text
changed_by_fk: int(11)
created_by_fk: int(11)
bart_lines
color: varchar(255)
name: varchar(255)
path_json: text
polyline: text
birth_france_by_region
DEPT_ID: varchar(10)
2003: bigint(20)
2004: bigint(20)
2005: bigint(20)
2006: bigint(20)
2007: bigint(20)
更多 (8 列)...
birth_names
ds: datetime(0)
gender: varchar(16)
name: varchar(255)
num: bigint(20)
state: varchar(10)
sum_boys: bigint(20)
sum_girls: bigint(20)
clusters
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
cluster_name: varchar(250)
coordinator_host: varchar(255)
coordinator_port: int(11)
coordinator_endpoint: varchar(255)
broker_host: varchar(255)
broker_port: int(11)
broker_endpoint: varchar(255)
metadata_last_refreshed: datetime(0)
created_by_fk: int(11)
changed_by_fk: int(11)
cache_timeout: int(11)
verbose_name: varchar(250)
columns
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
column_name: varchar(255)
is_active: tinyint(1)
type: varchar(32)
groupby: tinyint(1)
count_distinct: tinyint(1)
sum: tinyint(1)
max: tinyint(1)
min: tinyint(1)
filterable: tinyint(1)
description: text
created_by_fk: int(11)
changed_by_fk: int(11)
avg: tinyint(1)
dimension_spec_json: text
verbose_name: varchar(1024)
datasource_id: int(11)
css_templates
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
template_name: varchar(250)
css: text
changed_by_fk: int(11)
created_by_fk: int(11)
dashboard_slices
id: int(11)
dashboard_id: int(11)
slice_id: int(11)
dashboard_user
id: int(11)
user_id: int(11)
dashboard_id: int(11)
dashboards
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
dashboard_title: varchar(500)
position_json: text
created_by_fk: int(11)
changed_by_fk: int(11)
css: text
description: text
slug: varchar(255)
json_metadata: text
datasources
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
datasource_name: varchar(255)
is_featured: tinyint(1)
is_hidden: tinyint(1)
description: text
default_endpoint: text
user_id: int(11)
cluster_name: varchar(250)
created_by_fk: int(11)
changed_by_fk: int(11)
offset: int(11)
cache_timeout: int(11)
perm: varchar(1000)
filter_select_enabled: tinyint(1)
params: varchar(1000)
fetch_values_from: varchar(100)
dbs
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
database_name: varchar(250)
sqlalchemy_uri: varchar(1024)
created_by_fk: int(11)
changed_by_fk: int(11)
password: blob
cache_timeout: int(11)
extra: text
select_as_create_table_as: tinyint(1)
allow_ctas: tinyint(1)
expose_in_sqllab: tinyint(1)
force_ctas_schema: varchar(250)
allow_run_async: tinyint(1)
allow_run_sync: tinyint(1)
allow_dml: tinyint(1)
perm: varchar(1000)
verbose_name: varchar(250)
impersonate_user: tinyint(1)
allow_multi_schema_metadata_fetch: tinyint(1)
energy_usage
source: varchar(255)
target: varchar(255)
value: float(0, 0)
favstar
id: int(11)
user_id: int(11)
class_name: varchar(50)
obj_id: int(11)
dttm: datetime(0)
flights
DAY_OF_WEEK: bigint(20)
AIRLINE: text
FLIGHT_NUMBER: bigint(20)
TAIL_NUMBER: text
ORIGIN_AIRPORT: text
DESTINATION_AIRPORT: text
更多 (35 列)...
hdfs
id: int(11)
cost_name: varchar(64)
cost_value: int(11)
last_update: timestamp(0)
comment: varchar(1024)
keyvalue
id: int(11)
value: text
logs
id: int(11)
action: varchar(512)
user_id: int(11)
json: text
dttm: datetime(0)
dashboard_id: int(11)
slice_id: int(11)
duration_ms: int(11)
referrer: varchar(1024)
long_lat
LON: double(0, 0)
LAT: double(0, 0)
NUMBER: text
STREET: text
UNIT: text
CITY: double(0, 0)
更多 (9 列)...
metrics
id: int(11)
metric_name: varchar(255)
verbose_name: varchar(1024)
metric_type: varchar(32)
json: text
description: text
changed_by_fk: int(11)
changed_on: datetime(0)
created_by_fk: int(11)
created_on: datetime(0)
is_restricted: tinyint(1)
d3format: varchar(128)
warning_text: text
datasource_id: int(11)
multiformat_time_series
ds: date
ds2: datetime(0)
epoch_ms: bigint(20)
epoch_s: bigint(20)
string0: varchar(100)
string1: varchar(100)
string2: varchar(100)
string3: varchar(100)
paris_iris_mapping
type: text
features: text
query
id: int(11)
client_id: varchar(11)
database_id: int(11)
tmp_table_name: varchar(256)
tab_name: varchar(256)
sql_editor_id: varchar(256)
user_id: int(11)
status: varchar(16)
schema: varchar(256)
sql: text
select_sql: text
executed_sql: text
limit: int(11)
limit_used: tinyint(1)
select_as_cta: tinyint(1)
select_as_cta_used: tinyint(1)
progress: int(11)
rows: int(11)
error_message: text
start_time: decimal(20, 6)
changed_on: datetime(0)
end_time: decimal(20, 6)
results_key: varchar(64)
start_running_time: decimal(20, 6)
end_result_backend_time: decimal(20, 6)
tracking_url: text
random_time_series
ds: datetime(0)
saved_query
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
user_id: int(11)
db_id: int(11)
label: varchar(256)
schema: varchar(128)
sql: text
description: text
changed_by_fk: int(11)
created_by_fk: int(11)
sf_population_polygons
area: bigint(20)
contour: text
population: bigint(20)
zipcode: bigint(20)
slice_user
id: int(11)
user_id: int(11)
slice_id: int(11)
slices
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
slice_name: varchar(250)
datasource_type: varchar(200)
datasource_name: varchar(2000)
viz_type: varchar(250)
params: text
created_by_fk: int(11)
changed_by_fk: int(11)
description: text
cache_timeout: int(11)
perm: varchar(2000)
datasource_id: int(11)
sql_metrics
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
metric_name: varchar(512)
verbose_name: varchar(1024)
metric_type: varchar(32)
table_id: int(11)
expression: text
description: text
created_by_fk: int(11)
changed_by_fk: int(11)
is_restricted: tinyint(1)
d3format: varchar(128)
warning_text: text
table_columns
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
table_id: int(11)
column_name: varchar(255)
is_dttm: tinyint(1)
is_active: tinyint(1)
type: varchar(255)
groupby: tinyint(1)
count_distinct: tinyint(1)
sum: tinyint(1)
max: tinyint(1)
min: tinyint(1)
filterable: tinyint(1)
description: text
created_by_fk: int(11)
changed_by_fk: int(11)
expression: text
verbose_name: varchar(1024)
python_date_format: varchar(255)
database_expression: varchar(255)
avg: tinyint(1)
tables
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
table_name: varchar(250)
main_dttm_col: varchar(250)
default_endpoint: text
database_id: int(11)
created_by_fk: int(11)
changed_by_fk: int(11)
offset: int(11)
description: text
is_featured: tinyint(1)
user_id: int(11)
cache_timeout: int(11)
schema: varchar(255)
sql: text
params: text
perm: varchar(1000)
filter_select_enabled: tinyint(1)
fetch_values_predicate: varchar(1000)
is_sqllab_view: tinyint(1)
url
created_on: datetime(0)
changed_on: datetime(0)
id: int(11)
url: text
created_by_fk: int(11)
changed_by_fk: int(11)
wb_health_population
NY_GNP_PCAP_CD: double(0, 0)
SE_ADT_1524_LT_FM_ZS: double(0, 0)
SE_ADT_1524_LT_MA_ZS: double(0, 0)
SE_ADT_1524_LT_ZS: double(0, 0)
SE_ADT_LITR_FE_ZS: double(0, 0)
SE_ADT_LITR_MA_ZS: double(0, 0)
SE_ADT_LITR_ZS: double(0, 0)
SE_ENR_ORPH: double(0, 0)
SE_PRM_CMPT_FE_ZS: double(0, 0)
更多 (319 列)...
剩余23页未读，继续阅读
- 1
- 2
前往页