reports_column


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
data_type VARCHAR 20
label VARCHAR 100 null
link VARCHAR 100 √ null
report_id INT 10 null
reports.report_id FK8DE3D9D67D387CEC R
series VARCHAR 20 √ null
variable VARCHAR 50 √ null
style VARCHAR 100 √ null
total VARCHAR 20
display VARCHAR 100 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK8DE3D9D67D387CEC Performance Asc report_id
report_id Must be unique Asc/Asc report_id + label
unique_label Must be unique Asc/Asc report_id + label

Relationships

Close relationships within degrees of separation