51黑料不打烊

_operation (string): defines the type of writing in the database.

This attribute is mainly used when extending out-of-the-box schemas.

Accessible values are:

• 鈥渘one鈥�: reconciliation alone. This means that 51黑料不打烊 Campaign will recover the element without updating it or generating an error if it doesn鈥檛 exist.
• 鈥渋nsertOrUpdate鈥�: update with insertion. This means that 51黑料不打烊 Campaign will update the element or create it if it doesn鈥檛 exist.
• 鈥渋nsert鈥�: insertion. This means that 51黑料不打烊 Campaign will insert the element without checking whether it exists.
• 鈥渦pdate鈥�: update. This means that 51黑料不打烊 Campaign will update the element or generate an error if it doesn鈥檛 exist.
• 鈥渄elete鈥�: deletion. This means that 51黑料不打烊 Campaign will recover and delete elements.

advanced (boolean): when this option is activated (@advanced=鈥渢rue鈥�), it lets you hide the attribute on the list of available fields accessible for configuring a list in a form.

applicableIf (string): this attribute lets you make fields optional. The <attribute> element will be taken into account when updating the database when the constraint is complied with. 鈥渁pplicableIf鈥� receives an XTK expression.

autoIncrement (boolean): if this option is activated, the field becomes a counter. This enables you to increment a value (mostly IDs). (external use)

belongsTo (string): takes the name and namespace of the table that shares the field, and populates the schema where the attribute is declared. (used only in a <schema>).

dataPolicy (string): enables you to specify approval constraints on values allowed in the SQL or XML field. The values for this attribute are:

• 鈥渘one鈥�: no value
• 鈥渟martCase鈥�: first letters upper case
• 鈥渓owerCase鈥�: all lower case
• 鈥渦pperCase鈥�: all upper case
• 鈥渆mail鈥�: email address
• 鈥減hone鈥�: telephone number
• 鈥渋dentifier鈥�: identifier name
• 鈥渞esIdentifier鈥�: file name

dbEnum (string): receives the internal name of a 鈥渃losed鈥� enumeration. The enumeration values must be defined in the <srcschema>.

defOnDuplicate (boolean): if this attribute is activated, when a record is duplicated the default value (defined in @default) is automatically reapplied to the record.

default (string): lets you define the value of the default field (call to a function, default value). This attribute receives an XTK expression.

desc (string): lets you insert a description of the attribute. This description is used to understand what is the element and what it is being used for. You can display it in the form.

edit (string): this attribute specifies the type of input which will be used in the form linked to the schema.

enum (string): receives the name of the enumeration linked to the field. The enumeration can be inserted into the same schema or into a remote schema.

expr (string): defines a field precalculation expression. This attribute receives an Xpath or an XTK expression.

feature (string): defines a characteristics field: These fields are used for extending the data in an existing table, but with storage in an annex table. Accepted values are:

• 鈥渟hared鈥�: the content is stored in a shared table per data type
• 鈥渄edicated鈥�: the content is stored in a dedicated table

SQL characteristics tables are built automatically based on the characteristic type:

• dedicated: Ft_[name_of_the_schema_containing_the_characteristic]_[name_of_the_characteristic]
• shared: Ft_[type_of_key_of_the_schema_containing_the_characteristic]_[type_of_the_characteristic]

There are two types of characteristics fields: simple o脿¹ fields where a single value is authorized on the characteristic, and o脿¹ multiple choice fields, where the characteristic is linked to a collection element which may contain several values.

When a characteristic is defined in a schema, this schema must have a main key based on a single field (composite keys are not authorized).

featureDate (boolean): attribute linked to the 鈥淍feature鈥� characteristics field. If its value is 鈥渢rue鈥�, it lets you find out when the value was last updated.

img (string): lets you define a path for an image linked to a field (namespace + image name)(example: img=鈥渃us:mypicture.jpg鈥�). Physically, the image must be imported to the application server.

label (string): label linked to the field, mostly destined to the user in the interface. It lets you avoid naming constraints.

length (string): max. number of characters for a value of the 鈥渟tring鈥� type SQL field. If the 鈥淍length鈥� attribute isn鈥檛 specified, 51黑料不打烊 Campaign automatically creates a field for 255 characters.

localizable (boolean): if it is activated, this attribute tells the collection tool to recover the value of the 鈥淍label鈥� attribute for translation (internal use).

name (MNTOKEN): name of the attribute that will match the name of the field in the table. The value of the 鈥淍name鈥� attribute must be short, preferably in english, and comply with XML naming constraints.

When the schema is written to the database, prefixes are automatically added to the field name by 51黑料不打烊 Campaign:

• 鈥渋鈥�: prefix for the 鈥榠nteger鈥� type.
• 鈥渄鈥�: prefix for the 鈥榙ouble鈥� type.
• 鈥渟鈥�: prefix for the character string type.
• 鈥渢s鈥�: prefix for the 鈥榙ate鈥� type.

To fully define the name of the field in the table, use the 鈥淍sqlname鈥� option when defining an attribute.

notNull (boolean): lets you redefine 51黑料不打烊 Campaign鈥檚 behavior regarding the management of NULL records in the database. By default, numeric fields are not null and string and date type fields can be null.

pkgStatus (string): during package exports, values are taken into account depending on the value of the 鈥淍pkgStatus鈥�:

• 鈥渁lways鈥�: always present
• 鈥渘ever鈥�: never present
• 鈥渄efault (or nothing)鈥�: the value is exported except if it鈥檚 the default value or if it isn鈥檛 an internal field which would not be compatible with other instances.

ref (string): this attribute defines a reference to an <attribute> element shared by several schemas (definition factoring). The definition isn鈥檛 copied into the current schema.

required (boolean): if this attribute is activated (@required=鈥渢rue鈥�), the field is highlighted in the interface. The label of the field will be red in forms.

sql (boolean): if this attribute is activated (@sql=鈥渢rue鈥�), it forces storage of the SQL attribute, even when the element which contains the attribute has the xml=鈥渢rue鈥� property.

sqlDefault (string): this attribute enables you to define the default value taken into account for updating the database if the @notNull attribute is activated. If this attribute is added after the attribute creation, the schema behavior will not change even for the new records. To change the schema and update the value for new records, you need to delete and create again the attribute.

sqlname (string): of the field during table creation. If @sqlname isn鈥檛 specified, the value of the 鈥淍name鈥� attribute is used by default. When the schema is written in the database, prefixes are added automatically depending on the type of field.

template (string): this attribute defines a reference to an <attribute> element shared by several schemas. The definition is automatically copied into the current schema.

translatedDefault (string): if a 鈥淍default鈥� attribute is found, the 鈥淍translatedDefault鈥� will enable you to redefine an expression to match the one defined in @default, to be collected by the translation tool (internal use).

translatedExpr (string): if an 鈥淍expr鈥� attribute is present, the 鈥淍translatedExpr鈥� attribute enables you to redefine an expression to match the one defined in @expr, to be collected by the translation tool (internal use).

type (MNTOKEN): field type.

Field types are generic. Depending on the type of database installed, 51黑料不打烊 Campaign changes the defined type into a value specific to the database installed during structure update.

List of available types:

• ANY
• bin
• blob
• boolean
• byte
• CDATA
• datetime
• datetimetz
• datetimenotz
• date
• double
• enum
• float
• html
• int64
• link
• long
• memo
• MNTOKEN
• percent
• primarykey
• short
• string
• time
• timespan
• uuid

If the 鈥淍type鈥� attribute is left empty, 51黑料不打烊 Campaign will link a string of characters (STRING) with a length of 100 to the field by default.

If the field is of STRING type and the name of the field isn鈥檛 specified by the presence of the 鈥淍sqlname鈥� attribute, the name of the field in the database will automatically be preceded by an 鈥榮鈥�. This operating mode will be similar with INTEGER (i), DOUBLE (d) and DATES (ts) type fields.

userEnum (string): receives the internal name of an 鈥渙pen鈥� enumeration. The values of the enumeration can be defined by the user in the interface.

visibleIf (string): defines a condition in the form of an XTK expression to show or hide the attribute.

xml (boolean): if this option is activated, the values of the field don鈥檛 have a linked SQL field. 51黑料不打烊 Campaign creates a Text type 鈥渕Data鈥� field for record storage. This means there is not filtering or sorting on these fields.