reporttemplates

41 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ReportTemplateID INT 10 √ null
ReportTemplateTitle VARCHAR 150 null
ReportTemplateTypeID INT 10 null
reporttemplatetypes.ReportTemplateTypeID Implied ConstraintR
ReportTemplateObject MEDIUMBLOB 16777215 null
Description TEXT 65535 √ null
ReportTemplateImage MEDIUMBLOB 16777215 √ null
DateAdded DATETIME 19 null
LastUpdate DATETIME 19 null
ReportTemplateGUID CHAR 36 null
Flags BIGINT 19 0
Version VARCHAR 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ReportTemplateID

Relationships

Close relationships within degrees of separation