jiveField Table

Field data table.

Column Name Type Length Nullable Unicode Description
alterable smallint N/A false   Whether or not the field is alterable.
defValue varchar 255 true true The default value for the field.
description varchar 1000 true true The field's description.
displayName varchar 100 false true The display name of the field.
fRowVersion bigint N/A true   A sequence for the field row version.
fieldID bigint N/A false   The ID of the field. Primary key.
fieldTypeID bigint N/A false   The ID of the field type for this field.
filterable smallint N/A false   Whether or not the field is filterable.
maxSize int N/A false   The maximum size of the field.
name varchar 100 false true The name of the field.
required smallint N/A false   Whether or not the field is required.
searchable smallint N/A false   Whether or not the field is searchable.
visible smallint N/A false   Whether or not the field is visible to end users.