report

62 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 LONGTEXT 2147483647 √ null
noHeader BIT 1 null
maxItemsCount VARCHAR 255 √ null
startOffset VARCHAR 255 √ null
exportType INT 10 null
gridReportForUser_id INT 10 √ null
users.id FK_C42F7784A258C4EBR
customRowTemplate LONGTEXT 2147483647 √ null
customHeaderTemplate LONGTEXT 2147483647 √ null
customFooterTemplate LONGTEXT 2147483647 √ null
fetchFromAllClients BIT 1 null
customConditionAfterGrouping VARCHAR 255 √ null
sortingField2 VARCHAR 255 √ null
sortingDirection2 VARCHAR 4 √ null
useCRLF BIT 1 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
IDX_C42F7784A258C4EB Performance Asc gridReportForUser_id

Relationships

Close relationships within degrees of separation