CargoAdmin, Bureaucrats, Moderators (CommentStreams), fileuploaders, Interface administrators, newuser, Push subscription managers, Suppressors, Administrators
14,662
edits
Line 13: | Line 13: | ||
!Field Type | !Field Type | ||
!Description | !Description | ||
|- | |- | ||
|<code>Page</code> | |<code>Page</code> | ||
|Holds the name of a page in the wiki (default max size: 300 characters) | |Holds the name of a page in the wiki (default max size: 300 characters) | ||
|- | |- | ||
|<code>String</code> | |<code>String</code> | ||
|Holds standard, non-wikitext text (default max size: 300 characters) | |Holds standard, non-wikitext text (default max size: 300 characters) | ||
|- | |- | ||
|<code>Text</code> | |<code>Text</code> | ||
|Holds standard, non-wikitext text; intended for longer values | |Holds standard, non-wikitext text; intended for longer values; Unindexed | ||
|- | |- | ||
|<code>Integer</code> | |<code>Integer</code> | ||
|Holds an integer | |Holds an integer | ||
|- | |- | ||
|<code>Float</code> | |<code>Float</code> | ||
|Holds a real, i.e., non-integer, number | |Holds a real, i.e., non-integer, number | ||
|- | |- | ||
|<code>Date</code> | |<code>Date</code> | ||
|Holds a date without time | |Holds a date without time | ||
|- | |- | ||
|<code>Start date</code>, | |<code>Start date</code>, | ||
<code>End date</code> | <code>End date</code> | ||
|Similar to <code>Date</code>, but are meant to hold the beginning and end of some duration. A table can hold either no <code>Start date</code> and no <code>End date</code> field, or exactly one of both. | |Similar to <code>Date</code>, but are meant to hold the beginning and end of some duration. A table can hold either no <code>Start date</code> and no <code>End date</code> field, or exactly one of both. | ||
|- | |- | ||
|<code>Datetime</code> | |<code>Datetime</code> | ||
|Holds a date and time | |Holds a date and time | ||
|- | |- | ||
|<code>Start datetime</code>, | |<code>Start datetime</code>, | ||
<code>End datetime</code> | <code>End datetime</code> | ||
|Work like <code>Start date</code> or <code>End date</code>, but include a time. | |Work like <code>Start date</code> or <code>End date</code>, but include a time. | ||
|- | |- | ||
|<code>Boolean</code> | |<code>Boolean</code> | ||
|Holds a Boolean value, whose value should be 1 or 0, or 'yes' or 'no' (see [[Special:MyLanguage/Extension:Cargo/Querying data#Querying%20Boolean%20fields|this section]] for Cargo-specific information on querying Boolean values) | |Holds a Boolean value, whose value should be 1 or 0, or 'yes' or 'no' (see [[Special:MyLanguage/Extension:Cargo/Querying data#Querying%20Boolean%20fields|this section]] for Cargo-specific information on querying Boolean values) | ||
|- | |- | ||
|<code>Coordinates</code> | |<code>Coordinates</code> | ||
|Holds geographical coordinates | |Holds geographical coordinates | ||
|- | |- | ||
|<code>Wikitext string</code> | |<code>Wikitext string</code> | ||
|Holds a short text that is meant to be parsed by the MediaWiki parser (default max size: 300 characters) | |Holds a short text that is meant to be parsed by the MediaWiki parser (default max size: 300 characters) | ||
|- | |- | ||
|<code>Wikitext</code> | |<code>Wikitext</code> | ||
|Holds longer text that is meant to be parsed by the MediaWiki parser | |Holds longer text that is meant to be parsed by the MediaWiki parser; Unindexed | ||
|- | |- | ||
|<code>Searchtext</code> | |<code>Searchtext</code> | ||
|Holds text that can be searched on, using the [[Special:MyLanguage/Extension:Cargo/Querying data#The%20%22MATCHES%22%20command|MATCHES]] command (requires MySQL 5.6+ or MariaDB 5.6+) | |Holds text that can be searched on, using the [[Special:MyLanguage/Extension:Cargo/Querying data#The%20%22MATCHES%22%20command|MATCHES]] command (requires MySQL 5.6+ or MariaDB 5.6+) | ||
|- | |- | ||
|<code>File</code> | |<code>File</code> | ||
|Holds the name of an uploaded file or image in the wiki (similar to Page, but does not require specifying the "File:" namespace) (default max size: 300 characters) | |Holds the name of an uploaded file or image in the wiki (similar to Page, but does not require specifying the "File:" namespace) (default max size: 300 characters) | ||
|- | |- | ||
|<code>URL</code> | |<code>URL</code> | ||
|Holds a URL (default max size: 300 characters) | |Holds a URL (default max size: 300 characters) | ||
|- | |- | ||
|<code>Email</code> | |<code>Email</code> | ||
|Holds an email address (default max size: 300 characters) | |Holds an email address (default max size: 300 characters) | ||
|- | |- | ||
|<code>Rating</code> | |<code>Rating</code> |
edits