name |
![Attribute may stay unnamed in attribute list. Attribute may stay unnamed in attribute list.](/srs71m/images/unnamed.gif) ![Attribute value must be specified. Attribute value must be specified.](/srs71m/images/required.gif) |
|
The name of the column.
|
type |
![Attribute value must be specified. Attribute value must be specified.](/srs71m/images/required.gif) |
|
The data type of the column within the RDBMS, possible types are
VARCHAR2, NUMBER, DATE, CHAR, LONG, RAW, etc
|
size |
|
|
The width of this column, as it appears in the RDBMS.
|
nullable |
n |
|
y n |
|
Is this column nullable?
|
visible |
n |
|
y n |
|
Is this column visible in the SRS Web Interface?
|
orderBy |
n |
|
y n |
|
Is this column used to order the table uniquely by row?
|
defaultValue |
|
|
The default value of this column.
|
srsFieldType |
SrsField
|
|
Object that describes the data-field type. |
caseType |
Unknown |
|
UpperCase LowerCase MixedCase Unknown |
|
Determines whether characters are upperCase, lowerCase or Unknown.
|
mimeType |
UNDEFINED |
|
Required only for binary columns such as blob.
|
typeColumn |
|
|
Required only for binary columns such as blob.
The column name is for describing the mimeType for binary data
|
typeMap |
|
|
Required only for binary columns (or binary description columns),
to map SRS mimetype from description. The first element is a description which
is retrieved from description column and the second element is SRS mimetype.
This map needs to be predefined in the schema.i file.
|
maxSize |
0 |
|
Required only for binary columns such as blob.
When maxSize is set, the maxSize is for retrieval.
When the blob size is larger than maxSize, it will create
hyperlink. When the user clicks it, the blob can then be retrieved.
|
exactMatch |
n |
|
y n |
|
Specify the query match when query is on this column.
when srsTypeMatch is 1, it uses that srs type match for the query
otherwise, it uses the exact match in the query
|