data_sets


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
deleted BIT 1 0
date_entered DATETIME 26 null
date_modified DATETIME 26 null
modified_user_id CHAR 36 null
created_by CHAR 36 null
parent_id CHAR 36 null
report_id CHAR 36 null
query_id CHAR 36 null
name VARCHAR 50 null
list_order_y INT 10 0
exportable VARCHAR 3 0
header VARCHAR 3 0
description TEXT 65535 null
table_width VARCHAR 3 0
font_size VARCHAR 8 0
output_default VARCHAR 100 null
prespace_y VARCHAR 3 0
use_prev_header VARCHAR 3 0
header_back_color VARCHAR 100 null
body_back_color VARCHAR 100 null
header_text_color VARCHAR 100 null
body_text_color VARCHAR 100 null
table_width_type VARCHAR 3 null
custom_layout VARCHAR 10 null
team_id CHAR 36 null
teams.id Defined in XMLR
team_set_id CHAR 36 null
team_sets.id Defined in XMLR
team_sets_teams.team_set_id Defined in XMLR
acl_team_set_id CHAR 36 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_data_sets_acl_tmst_id Performance Asc/Asc acl_team_set_id + deleted
idx_data_sets_tmst_id Performance Asc/Asc team_set_id + deleted
idx_dataset Performance Asc/Asc name + deleted

Relationships