report

31 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
category_report.report_id FK_CBC7BDFF4BD2A4C0C
customer_report.report_id FK_75EAABD54BD2A4C0C
offer_report.report_id FK_1D7A00254BD2A4C0C
order_report.report_id FK_7A067514BD2A4C0C
product_report.report_id FK_A65336204BD2A4C0C
report_objectgroup.report_id FK_1CE8A3C54BD2A4C0C
reportcolumn.report_id FK_DD776C9B4BD2A4C0R
reportcondition.report_id FK_9376545E4BD2A4C0R
reportitem.report_id FK_A28B44634BD2A4C0R
reportjob.report_id FK_D64B81084BD2A4C0R
reportrow.report_id FK_A9A3972B4BD2A4C0R
vendororder_report.report_id FK_8A5154804BD2A4C0C
client_id VARCHAR 36 null
client.id FK_C42F778419EB6921R
title VARCHAR 255 null
entity VARCHAR 255 null
note LONGTEXT 2147483647 null
customCondition VARCHAR 255 null
active BIT 1 null
csvDelimiter VARCHAR 5 null
csvEnclosure VARCHAR 5 null
csvEncoding VARCHAR 32 null
token VARCHAR 36 null
fileName VARCHAR 255 null
itemsPerCall INT 10 null
lastLog LONGTEXT 2147483647 null
sortingField VARCHAR 255 null
sortingDirection VARCHAR 4 null
language_id VARCHAR 36 null
language.id FK_C42F778482F1BAF4R
dqlCondition VARCHAR 255 null
noHeader BIT 1 null
maxItemsCount VARCHAR 255 null
startOffset VARCHAR 255 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_C42F778419EB6921 Performance Asc client_id
IDX_C42F778482F1BAF4 Performance Asc language_id

Relationships