dataviews

110 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DataViewID INT 10 √ null
Name VARCHAR 100 null
FieldList TEXT 65535 null
ColumnList VARCHAR 2048 null
HiddenList VARCHAR 2048 null
SQLBody VARCHAR 2048 null
IDColumn VARCHAR 255 null
SQLWhere VARCHAR 2048 null
FolderID INT 10 null
ClientLink VARCHAR 100 null
ComputerLink VARCHAR 100 null
SortField VARCHAR 100 null
GroupField VARCHAR 100 null
SortOrder INT 10 null
FilterControl TEXT 65535 null
FormatControl TEXT 65535 null
LocationLink VARCHAR 100 null
IconControl TEXT 65535 null
SystemPermission BIGINT 19 null
SystemPermissionHigh BIGINT 19 0
UserClassName VARCHAR 255 null
GUID VARCHAR 36 √ null
scripttime.Guid Implied ConstraintR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc DataViewID
FolderID Performance Asc FolderID
Name_idx Performance Asc Name

Relationships

Close relationships within degrees of separation