rs_datatype

Stores attribute information for all user-defined datatypes (UDDs) in a replication definition.

Column	Datatype	Description
`prsid`	`int`	Can be: ID of primary Replication Server 0 for globally defined UDDs
`classid`	`rs_id`	ID of datatype class to which the datatype belongs
`dtname`	`varchar(30)`	Unique name of datatype
`dtid`	`rs_id`	Unique ID of datatype
`base_coltype`	`tinyint`	ID of base datatype for the datatype. Can be: 0 – `char` 1 – `binary` 2 – `longchar` (not used) 3 – `longbinary` (not used) 4 – `text` 5 – `image` 6 – `tinyint` 7 – `smallint` 8 – `int` 9 – `real` 10 – `float` 11 – `bit` 12 – `datetime` 13 – `smalldatetime` 14 – `money` 15 – `smallmoney` 16 – `numeric` 17 – `decimal` 18 – `varchar` 19 – `varbinary` 21 – `sensitivity` 25 – `unichar` 27 – `date` 28 – `time` 29 – `unitext`
		30 – `bigint` 31 – `usmallint` 32 – `uint` 33 – `ubigint` 35 – `bigdatetime` 36 – `bigtime` 101 – `numeric` (literal) 102 – `money` (literal) 103 – `real` (literal) 104 – `float` (literal) 105 – `identity` (literal) 106 – `timestamp` (literal) 107 – `sensitivity` (literal) 110 – `univarchar`
`length`	`int`	Maximum length of a value of the datatype. For UDDs with masks defined as `decimal` or `money`, the value is the maximum precision plus four.
`status`	`int`	Status. (See the `status` column in the `rs_columns` table.)
`length_err_act`	`tinyint`	Action to be taken if value exceeds length identified in `length`. Can be: 1 – error 2 – continue 3 – truncate left 4 – truncate right 5 – round up 6 – round up and continue on error 7 – round up and use default on error 8 – round up and use minimum on error 9 – round up and use maximum on error 10 – round down 11 – round down and continue on error 12 – round down and use default on error 13 – round down and use minimum on error 14 – round down and use maximum on error
`mask`	`varchar(255)`	Datatype mask. Datatype must have base datatype of `char` for non-null mask.
`scale`	`int`	Maximum number of digits to the right of decimal point. Valid only for masks of `money` or `decimal`.
`default_len`	`tinyint`	Length of value in `default_val` column.
`default_val`	`binary(255)`	Default value. Supplies missing components for target value during translation to this datatypes.
`delim_pre_len`	`tinyint`	Length of `delim_pre` value.
`delim_pre`	`binary(30)`	Postfixing character or character string used when mapping a non-Java value into a function string. An empty string if the delimiter prefix for the base datatype is used.
`delim_post_len`	`tinyint`	Length of `delim_post`.
`delim_post`	`binary(30)`	Postfixing character or character string used when mapping a non-Java value into a function string. An empty string if the delimiter prefix for the base datatype is used.
`min_boundary_ len`	`tinyint`	Length of value in `min_boundary` column. 1 – error 2 – use default 3 – use minimum 4 – use maximum
`min_boundary`	`binary(255)`	Minimum acceptable value for datatype.
`min_boundary_ err_act`	`tinyint`	Action to be taken if the value exceeds the minimum boundary set by min_boundary. Can be: 1 – error 2 – use default 3 – use minimum 4 – use maximum
`max_boundary_ len`	`tinyint`	Length of value in `max_boundary`.
`max_boundary`	`binary(255)`	Maximum acceptable value for datatype.
`maximum_ boundary_err_act`	`tinyint`	Action to be taken if a value exceeds the maximum boundary set by max_boundary. Can be: 1 – error 2 – use default 3 – use minimum 4 – use maximum
`rowtype`	`tinyint`	Indicates whether a row is local to Replication Server or distributed to all Replication Servers in the domain. Can be: 0 – local 1 – global
`canonic_type`	`tinyint`	DSI uses the value of `canonic_type` to convert the UDD to the correct data type when sending dynamic SQL execute commands. A value of 255 indicates that this datatype is incompatible with dynamic SQL.

Indexes

Unique index on (dtid)
Unique index on (name)
Non-unique index on (classid)
Non-unique index on (prsid)