|
Name
|
Static
text
|
The name of the
column. This information is read from the database; you cannot change
it. Note that if the column name contains a slash (/), WorldServer
displays the characters << instead of the slash.
|
|
Data
type
|
Static
text
|
The type of data
in the column. This information is read from the database; you cannot
change it.
|
|
Treatment
|
Drop-down
list
|
Specify how WorldServer
uses the column.
-
Identifier – The column, in conjunction with other identifier columns,
uniquely identifies (or is the primary key for) the content in the
table. All identifiers combined must uniquely identify a row in the
table. If this is not the case, then the mount cannot be created.
For example, the ID and Language columns together could uniquely
identify the data in a table. You must choose at least one column
to be an identifier.
-
Translate – Specifies that content in this column is translatable.
-
Ignore – Specifies that content in this column should be ignored
by WorldServer.
-
Timestamp – (only available for date/time columns) Specifies that
this column should be used as the timestamp for the content in the
row. Only one column can be designated as the timestamp column. Although
WorldServer can detect changes in rows without a timestamp column,
creating and designating a timestamp column improves performance.
Make sure to create a trigger in your database that updates the timestamp
in a row when its content changes. Note that the Microsoft SQL Server
data type timestamp is not a valid
date/time format - use the date/time data type instead.
-
Copy – Copies the content in the column from the source to the target
when the target is created or on project creation. Use the copy treatment for columns that do
not need translation, but should be copied identically to the target
(for example, a company logo or graphic). Columns set to copy are included in determining whether
a source asset has been modified. Columns that are marked copy must include the constraint NOT NULL or WorldServer will leave
the target column empty.
|
|
MIME
Type
|
Text
field
|
The MIME type
for the column, which determines how WorldServer should treat translatable
content.
 |
Note: You do not need to change the
MIME type and encoding for columns set to ignore, because WorldServer does not deal with this content.
These values do not affect the MIME type and encoding of the actual
content in the table, but rather they inform WorldServer of the existing
settings in the table.
|
|
|
Encoding
|
Drop-down
list
|
The data encoding
for the column. The default selection should be correct, but certain
types of data may require a different setting.
|
|
Title
|
Radio
button
|
When you select
one of the columns to be the title column, the WorldServer Explorer
displays the contents of the title cell to assist users in locating
information quickly.
|
|
Order
|
Clickable
arrows
|
Use the arrows
to rearrange the order in which the columns appear. The order of the
columns determines the sequence in which a translator sees the content
of the fields.
|
|
Description
|
Static
text
|
If the column
has an associated comment in the database, it is displayed here. You
cannot change the value of this field.
|