/* * DSD for jdbc:hsqldb:/dist/melati/db/melatitest (org.melati.poem.PoemDatabase) * * Generated for _guest_ * * WARNING * This export is not necessarily information preserving. * 1) if you have used a capitalisation regime other than first * letter capital then the case will not be preserved. * 2) Abstract tables are not preserved; the tables are 'de-normalised'. * 3) Importing another DSD, such as messageboards, is * not preserved, all tables are in a single package namespace. * * NOTE * This template can include all system and inherited tables but then * should NOT be used to replace an existing DSD. * (add all=true to URL) * */ package org.melati.poem; // user (from the data structure definition) // org.melati.poem.UserTable table user (displayname = "User") (description = "A registered user of the database") (displayorder = 2010) // (defaultcanread = null) (defaultcanwrite = _administer_) (defaultcandelete = _administer_) (cancreate = _administer_) (cachelimit = 100) (seqcached) (category = "User") { //user.id: troid (INT (org.melati.poem.TroidPoemType)) (from the data structure definition) Integer id (primary) (displayname = "Id") (description = "The Table Row Object ID") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) (displayorder = 10) (uncreateable) (displaylevel = detail) (searchability = yes) // (displayorderpriority = null) // Not sortdescending (indexed) (unique) ; //user.name: String(60) (from the data structure definition) String name (displayname = "Full name") (description = "The user's real name") // usereditable // Not nullable (size = 60) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 20) // usercreateable (displaylevel = primary) (searchability = primary) (displayorderpriority = 0) // Not sortdescending (indexed) // Not unique ; //user.login: String(255) (from the data structure definition) String login (displayname = "Login") (description = "The user's login name") // usereditable // Not nullable (size = 255) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 30) // usercreateable (displaylevel = summary) (searchability = yes) // (displayorderpriority = null) // Not sortdescending // Not indexed (unique) ; //user.password: Password(20) (from the data structure definition) Password password (displayname = "Password") (description = "The user's password") // usereditable // Not nullable (size = 20) (width = 10) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 40) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; } // group (from the data structure definition) // org.melati.poem.GroupTable table group (displayname = "Group") (description = "A group to which registered users of the database can belong") (displayorder = 2020) // (defaultcanread = null) (defaultcanwrite = _administer_) (defaultcandelete = _administer_) (cancreate = _administer_) (cachelimit = 100) (seqcached) (category = "User") { //group.id: troid (INT (org.melati.poem.TroidPoemType)) (from the data structure definition) Integer id (primary) (displayname = "Id") (description = "The Table Row Object ID") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) (displayorder = 0) (uncreateable) (displaylevel = detail) (searchability = yes) // (displayorderpriority = null) // Not sortdescending (indexed) (unique) ; //group.name: String(60) (from the data structure definition) String name (displayname = "Name") (description = "A human-readable name for the group") // usereditable // Not nullable (size = 60) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 1) // usercreateable (displaylevel = primary) (searchability = primary) (displayorderpriority = 0) // Not sortdescending // Not indexed (unique) ; } // capability (from the data structure definition) // org.melati.poem.CapabilityTable table capability (displayname = "Capability") (description = "A capability which users can be required to possess before accessing data") (displayorder = 2030) // (defaultcanread = null) (defaultcanwrite = _administer_) (defaultcandelete = _administer_) (cancreate = _administer_) (cachelimit = 100) (seqcached) (category = "User") { //capability.id: troid (INT (org.melati.poem.TroidPoemType)) (from the data structure definition) Integer id (primary) (displayname = "Id") (description = "The Table Row Object ID") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) (displayorder = 0) (uncreateable) (displaylevel = detail) (searchability = yes) // (displayorderpriority = null) // Not sortdescending (indexed) (unique) ; //capability.name: String(60) (from the data structure definition) String name (displayname = "Name") (description = "A human-readable name for the capability") // usereditable // Not nullable (size = 60) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 1) // usercreateable (displaylevel = primary) (searchability = primary) (displayorderpriority = 0) // Not sortdescending // Not indexed (unique) ; } // groupMembership (from the data structure definition) // org.melati.poem.GroupMembershipTable table groupMembership (displayname = "Group membership") (description = "A record that a given user is a member of a given group") (displayorder = 2040) // (defaultcanread = null) (defaultcanwrite = _administer_) (defaultcandelete = _administer_) (cancreate = _administer_) (cachelimit = 100) // Not seqcached (category = "User") { //groupMembership.id: troid (INT (org.melati.poem.TroidPoemType)) (from the data structure definition) Integer id (primary) (displayname = "Id") (description = "The Table Row Object ID") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) (displayorder = 0) (uncreateable) (displaylevel = detail) (searchability = yes) // (displayorderpriority = null) // Not sortdescending (indexed) (unique) ; //groupMembership.user: reference to user (INT (org.melati.poem.ReferencePoemType)) (from the data structure definition) User user (displayname = "User") (description = "The user who belongs to the group") // usereditable // Not nullable (width = 20) (height = 1) (renderinfo = "SelectionWindow") // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 1) // usercreateable (displaylevel = summary) (searchability = yes) (displayorderpriority = 0) // Not sortdescending (indexed) // Not unique (integrityfix = delete) ; //groupMembership.group: reference to group (INT (org.melati.poem.ReferencePoemType)) (from the data structure definition) Group group (displayname = "Group") (description = "The group to which the user belongs") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 2) // usercreateable (displaylevel = summary) (searchability = primary) (displayorderpriority = 1) // Not sortdescending // Not indexed // Not unique (integrityfix = prevent) ; } // groupCapability (from the data structure definition) // org.melati.poem.GroupCapabilityTable table groupCapability (displayname = "Group capability") (description = "A record that users belonging to a given group possess a given capability") (displayorder = 2050) // (defaultcanread = null) (defaultcanwrite = _administer_) (defaultcandelete = _administer_) (cancreate = _administer_) (cachelimit = 100) // Not seqcached (category = "User") { //groupCapability.id: troid (INT (org.melati.poem.TroidPoemType)) (from the data structure definition) Integer id (primary) (displayname = "Id") (description = "The Table Row Object ID") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) (displayorder = 0) (uncreateable) (displaylevel = detail) (searchability = yes) // (displayorderpriority = null) // Not sortdescending (indexed) (unique) ; //groupCapability.group: reference to group (INT (org.melati.poem.ReferencePoemType)) (from the data structure definition) Group group (displayname = "Group") (description = "The user-group which has the capability") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 1) // usercreateable (displaylevel = summary) (searchability = primary) (displayorderpriority = 0) // Not sortdescending // Not indexed // Not unique (integrityfix = prevent) ; //groupCapability.capability: reference to capability (INT (org.melati.poem.ReferencePoemType)) (from the data structure definition) Capability capability (displayname = "Capability") (description = "The capability") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 2) // usercreateable (displaylevel = summary) (searchability = yes) (displayorderpriority = 1) // Not sortdescending // Not indexed // Not unique (integrityfix = prevent) ; } // tableInfo (from the data structure definition) // org.melati.poem.TableInfoTable table tableInfo (displayname = "Table") (description = "Configuration information about a table in the database") (displayorder = 3010) // (defaultcanread = null) (defaultcanwrite = _administer_) (defaultcandelete = _administer_) (cancreate = _administer_) (cachelimit = 999999999) (seqcached) (category = "System") { //tableInfo.id: troid (INT (org.melati.poem.TroidPoemType)) (from the data structure definition) Integer id (primary) (displayname = "Id") (description = "The Table Row Object ID") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) (displayorder = 0) (uncreateable) (displaylevel = detail) (searchability = yes) // (displayorderpriority = null) // Not sortdescending (indexed) (unique) ; //tableInfo.name: String(50) (from the data structure definition) String name (displayname = "Name") (description = "A code-name for the table") (uneditable) // Not nullable (size = 50) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 1) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed (unique) ; //tableInfo.displayname: String(60) (from the data structure definition) String displayname (displayname = "Display name") (description = "A user-friendly name for the table") // usereditable // Not nullable (size = 60) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 2) // usercreateable (displaylevel = primary) (searchability = yes) (displayorderpriority = 1) // Not sortdescending // Not indexed // Not unique ; //tableInfo.description: nullable String(-1) (from the data structure definition) String description (displayname = "Description") (description = "A brief description of the table's function") // usereditable (nullable) (size = unlimited) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 3) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //tableInfo.displayorder: INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer displayorder (displayname = "Display order") (description = "A rank determining where the table appears in the list of all tables") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 4) // usercreateable (displaylevel = summary) (searchability = yes) (displayorderpriority = 0) // Not sortdescending // Not indexed // Not unique ; //tableInfo.defaultcanread: reference to capability (nullable INT (org.melati.poem.ReferencePoemType)) (from the data structure definition) Capability defaultcanread (displayname = "Default `read' capability") (description = "The capability required, by default, for reading the table's records") // usereditable (nullable) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 5) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique (integrityfix = prevent) ; //tableInfo.defaultcanwrite: reference to capability (nullable INT (org.melati.poem.ReferencePoemType)) (from the data structure definition) Capability defaultcanwrite (displayname = "Default `write' capability") (description = "The capability required, by default, for updating the table's records") // usereditable (nullable) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 6) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique (integrityfix = prevent) ; //tableInfo.defaultcandelete: reference to capability (nullable INT (org.melati.poem.ReferencePoemType)) (from the data structure definition) Capability defaultcandelete (displayname = "Default `delete' capability") (description = "The capability required, by default, for deleting the table's records") // usereditable (nullable) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 7) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique (integrityfix = prevent) ; //tableInfo.cancreate: reference to capability (nullable INT (org.melati.poem.ReferencePoemType)) (from the data structure definition) Capability cancreate (displayname = "Default `create' capability") (description = "The capability required, by default, for creating records in the table") // usereditable (nullable) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 8) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique (integrityfix = prevent) ; //tableInfo.cachelimit: nullable INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer cachelimit (displayname = "Cache size limit") (description = "The maximum number of records from the table to keep in the cache") // usereditable (nullable) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 9) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //tableInfo.seqcached: BOOLEAN (org.melati.poem.BooleanPoemType) (from the data structure definition) Boolean seqcached (displayname = "Record sequence cached") (description = "Whether the display sequence for the table's records is cached") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 10) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //tableInfo.category: reference to tableCategory (INT (org.melati.poem.ReferencePoemType)) (from the data structure definition) TableCategory category (displayname = "Category") (description = "Which category the table falls into") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 11) // usercreateable (displaylevel = record) (searchability = primary) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique (integrityfix = prevent) ; } // columnInfo (from the data structure definition) // org.melati.poem.ColumnInfoTable table columnInfo (displayname = "Column") (description = "Configuration information about a column in the database") (displayorder = 3020) // (defaultcanread = null) (defaultcanwrite = _administer_) (defaultcandelete = _administer_) (cancreate = _administer_) (cachelimit = 999999999) (seqcached) (category = "System") { //columnInfo.displayname: String(60) (from the data structure definition) String displayname (displayname = "Display name") (description = "A user-friendly name for the field") // usereditable // Not nullable (size = 60) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 100) // usercreateable (displaylevel = primary) (searchability = yes) (displayorderpriority = 2) // Not sortdescending // Not indexed // Not unique ; //columnInfo.description: nullable String(-1) (from the data structure definition) String description (displayname = "Description") (description = "A brief description of the field's function") // usereditable (nullable) (size = unlimited) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 101) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.usereditable: BOOLEAN (org.melati.poem.BooleanPoemType) (from the data structure definition) Boolean usereditable (displayname = "User-editable") (description = "Whether it makes sense for the user to update the field's value") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 200) // usercreateable (displaylevel = detail) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.typefactory: type code (INT (org.melati.poem.ColumnTypePoemType)) (from the data structure definition) ColumnType typefactory (displayname = "Type") (description = "The field's Melati type") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 201) // usercreateable (displaylevel = detail) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.nullable: BOOLEAN (org.melati.poem.BooleanPoemType) (from the data structure definition) Boolean nullable (displayname = "Nullable") (description = "Whether the field can be empty") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 202) // usercreateable (displaylevel = detail) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.size: INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer size (displayname = "Size") (description = "For character fields, the maximum number of characters that can be stored, (-1 for unlimited)") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 203) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.width: INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer width (displayname = "Input-box width") (description = "A sensible width for text boxes used for entering the field, where appropriate") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 204) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.height: INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer height (displayname = "Input-box height") (description = "A sensible height for text boxes used for entering the field, where appropriate") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 205) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.precision: INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer precision (displayname = "Precision") (description = "Precision (total number of digits) for fixed-point numbers") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 206) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.scale: INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer scale (displayname = "Scale") (description = "Scale (number of digits after the decimal) for fixed-point numbers") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 207) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.renderinfo: nullable String(-1) (from the data structure definition) String renderinfo (displayname = "Rendering information") (description = "The name of the Melati templet (if not the default) to use for input controls for the field") // usereditable (nullable) (size = unlimited) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 208) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.rangelow_string: nullable String(-1) (from the data structure definition) String rangelow_string (displayname = "Range: low") (description = "The low end of the range of permissible values for the field") // usereditable (nullable) (size = unlimited) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 209) // usercreateable (displaylevel = detail) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.rangelimit_string: nullable String(-1) (from the data structure definition) String rangelimit_string (displayname = "Range: limit") (description = "The (exclusive) limit of the range of permissible values for the field") // usereditable (nullable) (size = unlimited) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 210) // usercreateable (displaylevel = detail) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.id: troid (INT (org.melati.poem.TroidPoemType)) (from the data structure definition) Integer id (primary) (displayname = "Id") // (description = null) (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) (displayorder = 0) (uncreateable) (displaylevel = summary) (searchability = yes) // (displayorderpriority = null) // Not sortdescending (indexed) (unique) ; //columnInfo.tableinfo: reference to tableInfo (INT (org.melati.poem.ReferencePoemType)) (from the data structure definition) TableInfo tableinfo (displayname = "Owning table") (description = "The table to which the field belongs") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 1) // usercreateable (displaylevel = summary) (searchability = primary) (displayorderpriority = 0) // Not sortdescending // Not indexed // Not unique (integrityfix = prevent) ; //columnInfo.name: String(50) (from the data structure definition) String name (displayname = "Name") (description = "A code-name for the field") (uneditable) // Not nullable (size = 50) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 300) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending (indexed) // Not unique ; //columnInfo.displayorder: INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer displayorder (displayname = "Display order") (description = "A rank determining where the field appears in lists") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 301) // usercreateable (displaylevel = record) (searchability = no) (displayorderpriority = 1) // Not sortdescending // Not indexed // Not unique ; //columnInfo.usercreateable: BOOLEAN (org.melati.poem.BooleanPoemType) (from the data structure definition) Boolean usercreateable (displayname = "User-createable") (description = "Whether it makes sense for the user to initialise the field's value") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 302) // usercreateable (displaylevel = detail) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.displaylevel: display level (INT (org.melati.poem.DisplayLevelPoemType)) (from the data structure definition) DisplayLevel displaylevel (displayname = "Display level") (description = "A category determining what granularity of report the field appears in") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 303) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.searchability: searchability (INT (org.melati.poem.SearchabilityPoemType)) (from the data structure definition) Searchability searchability (displayname = "Searchability") (description = "A category determining what level of searching this field supports") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 304) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.displayorderpriority: nullable INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer displayorderpriority (displayname = "Display order priority") (description = "If present, the level at which lists of records are sorted by the field") // usereditable (nullable) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 305) // usercreateable (displaylevel = summary) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.sortdescending: nullable BOOLEAN (org.melati.poem.BooleanPoemType) (from the data structure definition) Boolean sortdescending (displayname = "Sort Descending") (description = "Whether when sorting by this column, the sort order should be reversed") // usereditable (nullable) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 306) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.indexed: BOOLEAN (org.melati.poem.BooleanPoemType) (from the data structure definition) Boolean indexed (displayname = "Indexed") (description = "Whether the field is indexed (ignored if the field is marked `unique')") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 307) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.unique: BOOLEAN (org.melati.poem.BooleanPoemType) (from the data structure definition) Boolean unique (displayname = "Unique") (description = "Whether the field is unique (implies that it's `indexed')") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 308) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //columnInfo.integrityfix: integrity fix (nullable INT (org.melati.poem.IntegrityFixPoemType)) (from the data structure definition) IntegrityFix integrityfix (displayname = "Integrity fix") (description = "How referential integrity is maintained, what to do when the object referred to is deleted") // usereditable (nullable) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 309) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; } // tableCategory (from the data structure definition) // org.melati.poem.TableCategoryTable table tableCategory (displayname = "Table type") (description = "A category under which a table can be classified") (displayorder = 3030) // (defaultcanread = null) (defaultcanwrite = _administer_) (defaultcandelete = _administer_) (cancreate = _administer_) (cachelimit = 999999999) (seqcached) (category = "System") { //tableCategory.id: troid (INT (org.melati.poem.TroidPoemType)) (from the data structure definition) Integer id (primary) (displayname = "Id") (description = "The Table Row Object ID") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) (displayorder = 0) (uncreateable) (displaylevel = summary) (searchability = yes) // (displayorderpriority = null) // Not sortdescending (indexed) (unique) ; //tableCategory.name: String(60) (from the data structure definition) String name (displayname = "Name") (description = "A human-readable name for the category") // usereditable // Not nullable (size = 60) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 1) // usercreateable (displaylevel = primary) (searchability = primary) (displayorderpriority = 0) // Not sortdescending // Not indexed (unique) ; } // setting (from the data structure definition) // org.melati.poem.SettingTable table setting (displayname = "Setting") (description = "A configurable setting for the application") (displayorder = 3040) // (defaultcanread = null) (defaultcanwrite = _administer_) (defaultcandelete = _administer_) (cancreate = _administer_) (cachelimit = 999999999) (seqcached) (category = "System") { //setting.displayname: String(60) (from the data structure definition) String displayname (displayname = "Display name") (description = "A user-friendly name for the field") // usereditable // Not nullable (size = 60) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 100) // usercreateable (displaylevel = primary) (searchability = yes) (displayorderpriority = 2) // Not sortdescending // Not indexed // Not unique ; //setting.description: nullable String(-1) (from the data structure definition) String description (displayname = "Description") (description = "A brief description of the field's function") // usereditable (nullable) (size = unlimited) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 101) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //setting.usereditable: BOOLEAN (org.melati.poem.BooleanPoemType) (from the data structure definition) Boolean usereditable (displayname = "User-editable") (description = "Whether it makes sense for the user to update the field's value") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 200) // usercreateable (displaylevel = detail) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //setting.typefactory: type code (INT (org.melati.poem.ColumnTypePoemType)) (from the data structure definition) ColumnType typefactory (displayname = "Type") (description = "The field's Melati type") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 201) // usercreateable (displaylevel = detail) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //setting.nullable: BOOLEAN (org.melati.poem.BooleanPoemType) (from the data structure definition) Boolean nullable (displayname = "Nullable") (description = "Whether the field can be empty") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 202) // usercreateable (displaylevel = detail) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //setting.size: INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer size (displayname = "Size") (description = "For character fields, the maximum number of characters that can be stored, (-1 for unlimited)") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 203) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //setting.width: INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer width (displayname = "Input-box width") (description = "A sensible width for text boxes used for entering the field, where appropriate") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 204) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //setting.height: INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer height (displayname = "Input-box height") (description = "A sensible height for text boxes used for entering the field, where appropriate") // usereditable // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 205) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //setting.precision: INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer precision (displayname = "Precision") (description = "Precision (total number of digits) for fixed-point numbers") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 206) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //setting.scale: INT (org.melati.poem.IntegerPoemType) (from the data structure definition) Integer scale (displayname = "Scale") (description = "Scale (number of digits after the decimal) for fixed-point numbers") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 207) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //setting.renderinfo: nullable String(-1) (from the data structure definition) String renderinfo (displayname = "Rendering information") (description = "The name of the Melati templet (if not the default) to use for input controls for the field") // usereditable (nullable) (size = unlimited) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 208) // usercreateable (displaylevel = record) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //setting.rangelow_string: nullable String(-1) (from the data structure definition) String rangelow_string (displayname = "Range: low") (description = "The low end of the range of permissible values for the field") // usereditable (nullable) (size = unlimited) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 209) // usercreateable (displaylevel = detail) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //setting.rangelimit_string: nullable String(-1) (from the data structure definition) String rangelimit_string (displayname = "Range: limit") (description = "The (exclusive) limit of the range of permissible values for the field") // usereditable (nullable) (size = unlimited) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 210) // usercreateable (displaylevel = detail) (searchability = no) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; //setting.id: troid (INT (org.melati.poem.TroidPoemType)) (from the data structure definition) Integer id (primary) (displayname = "Id") (description = "The Table Row Object ID") (uneditable) // Not nullable (width = 20) (height = 1) // (renderinfo = null) (displayorder = 0) (uncreateable) (displaylevel = summary) (searchability = yes) // (displayorderpriority = null) // Not sortdescending (indexed) (unique) ; //setting.name: String(200) (from the data structure definition) String name (displayname = "Name") (description = "A code name for this setting") // usereditable // Not nullable (size = 200) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 1) // usercreateable (displaylevel = summary) (searchability = primary) // (displayorderpriority = null) // Not sortdescending // Not indexed (unique) ; //setting.value: nullable String(-1) (from the data structure definition) String value (displayname = "Value") (description = "The value of this setting") // usereditable (nullable) (size = unlimited) (width = 20) (height = 1) // (renderinfo = null) // (rangelow_string = null) // (rangelimit_string = null) (displayorder = 150) // usercreateable (displaylevel = summary) (searchability = yes) // (displayorderpriority = null) // Not sortdescending // Not indexed // Not unique ; }