<th> (Meta information for one column)

The metadata for a single column in a table.

Attributes

Attribute Value
name The name by which the column is referenced in formulas and query operations
Note: This is generally not the same as the column's heading (see "Contents" below). E.g., street.
desc The description of the column
format The display format for the data in the column

Format specifications have the same form as is used in the XML Macro Language in the Edit Actions dialog of the 1010data web interface (e.g., type:num;width:15;dec:2)
type The type of data in the column
type must be one of:
  • i (integer)
  • j (big integer) (Available as of version 11.25)
  • f (float)
  • a (alphanumeric)
index Whether or not the column is indexed. Valid values are 1 (indexed) or 0 (not indexed).
fixed Indicates whether this is a fixed column or not. Valid values are 1 and 0.

When fixed is 1, this indicates that the column is a fixed column.

Note: Fixed columns, when they exist in a table, are always visible and are separated from the other columns by a vertical orange line.
total Indicates whether this is the result of a tabulation or not

When total is 1, this indicates that the values in the column are from the result of a tabulation.

name and type must be present; format is optional.

Contents

The column heading that appears above the column when the table is displayed in the 1010data web interface. Lines in the heading are separated by "&#10;" (the newline character).

Example

<th name="date" type="i" format="type:date;width:8;dec:0" fixed="1">Date</th>
<th name="t0" type="f" format="type:num;width:6;dec:2" fixed="0" total="1">Average&#10;Dry Bulb&#10;Temp&#10;(Celsius)</th>