/*
 * 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 comments for defaulted items
 * (add comments=true to URL)
 *    
 * 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;

table user

  (displayname = "User")
  (description = "A registered user of the database")
  (displayorder = 2010)
  (defaultcanwrite = _administer_)
  (defaultcandelete = _administer_)
  (cancreate = _administer_)
  (cachelimit = 100)
  (seqcached)
  (category = "User")
{
    Integer id
      (primary)
      (displayname = "Id")
      (description = "The Table Row Object ID")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 10)
      (uncreateable)
      (displaylevel = detail)
      (searchability = yes)
      (indexed)
      (unique)
      ;
    String name
      (displayname = "Full name")
      (description = "The user's real name")
      (size = 60)
      (width = 20)
      (height = 1)
      (displayorder = 20)
      (displaylevel = primary)
      (searchability = primary)
      (displayorderpriority = 0)
      (indexed)
      ;
    String login
      (displayname = "Login")
      (description = "The user's login name")
      (size = 255)
      (width = 20)
      (height = 1)
      (displayorder = 30)
      (displaylevel = summary)
      (searchability = yes)
      (unique)
      ;
    Password password
      (displayname = "Password")
      (description = "The user's password")
      (size = 20)
      (width = 10)
      (height = 1)
      (displayorder = 40)
      (displaylevel = record)
      (searchability = no)
      ;
 }

table group

  (displayname = "Group")
  (description = "A group to which registered users of the database can belong")
  (displayorder = 2020)
  (defaultcanwrite = _administer_)
  (defaultcandelete = _administer_)
  (cancreate = _administer_)
  (cachelimit = 100)
  (seqcached)
  (category = "User")
{
    Integer id
      (primary)
      (displayname = "Id")
      (description = "The Table Row Object ID")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 0)
      (uncreateable)
      (displaylevel = detail)
      (searchability = yes)
      (indexed)
      (unique)
      ;
    String name
      (displayname = "Name")
      (description = "A human-readable name for the group")
      (size = 60)
      (width = 20)
      (height = 1)
      (displayorder = 1)
      (displaylevel = primary)
      (searchability = primary)
      (displayorderpriority = 0)
      (unique)
      ;
 }

table capability

  (displayname = "Capability")
  (description = "A capability which users can be required to possess before accessing data")
  (displayorder = 2030)
  (defaultcanwrite = _administer_)
  (defaultcandelete = _administer_)
  (cancreate = _administer_)
  (cachelimit = 100)
  (seqcached)
  (category = "User")
{
    Integer id
      (primary)
      (displayname = "Id")
      (description = "The Table Row Object ID")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 0)
      (uncreateable)
      (displaylevel = detail)
      (searchability = yes)
      (indexed)
      (unique)
      ;
    String name
      (displayname = "Name")
      (description = "A human-readable name for the capability")
      (size = 60)
      (width = 20)
      (height = 1)
      (displayorder = 1)
      (displaylevel = primary)
      (searchability = primary)
      (displayorderpriority = 0)
      (unique)
      ;
 }

table groupMembership

  (displayname = "Group membership")
  (description = "A record that a given user is a member of a given group")
  (displayorder = 2040)
  (defaultcanwrite = _administer_)
  (defaultcandelete = _administer_)
  (cancreate = _administer_)
  (cachelimit = 100)
  (category = "User")
{
    Integer id
      (primary)
      (displayname = "Id")
      (description = "The Table Row Object ID")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 0)
      (uncreateable)
      (displaylevel = detail)
      (searchability = yes)
      (indexed)
      (unique)
      ;
    User user
      (displayname = "User")
      (description = "The user who belongs to the group")
      (width = 20)
      (height = 1)
      (renderinfo = "SelectionWindow")
      (displayorder = 1)
      (displaylevel = summary)
      (searchability = yes)
      (displayorderpriority = 0)
      (indexed)
      (integrityfix = delete)
      ;
    Group group
      (displayname = "Group")
      (description = "The group to which the user belongs")
      (width = 20)
      (height = 1)
      (displayorder = 2)
      (displaylevel = summary)
      (searchability = primary)
      (displayorderpriority = 1)
      (integrityfix = prevent)
      ;
 }

table groupCapability

  (displayname = "Group capability")
  (description = "A record that users belonging to a given group possess a given capability")
  (displayorder = 2050)
  (defaultcanwrite = _administer_)
  (defaultcandelete = _administer_)
  (cancreate = _administer_)
  (cachelimit = 100)
  (category = "User")
{
    Integer id
      (primary)
      (displayname = "Id")
      (description = "The Table Row Object ID")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 0)
      (uncreateable)
      (displaylevel = detail)
      (searchability = yes)
      (indexed)
      (unique)
      ;
    Group group
      (displayname = "Group")
      (description = "The user-group which has the capability")
      (width = 20)
      (height = 1)
      (displayorder = 1)
      (displaylevel = summary)
      (searchability = primary)
      (displayorderpriority = 0)
      (integrityfix = prevent)
      ;
    Capability capability
      (displayname = "Capability")
      (description = "The capability")
      (width = 20)
      (height = 1)
      (displayorder = 2)
      (displaylevel = summary)
      (searchability = yes)
      (displayorderpriority = 1)
      (integrityfix = prevent)
      ;
 }

table tableInfo

  (displayname = "Table")
  (description = "Configuration information about a table in the database")
  (displayorder = 3010)
  (defaultcanwrite = _administer_)
  (defaultcandelete = _administer_)
  (cancreate = _administer_)
  (cachelimit = 999999999)
  (seqcached)
  (category = "System")
{
    Integer id
      (primary)
      (displayname = "Id")
      (description = "The Table Row Object ID")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 0)
      (uncreateable)
      (displaylevel = detail)
      (searchability = yes)
      (indexed)
      (unique)
      ;
    String name
      (displayname = "Name")
      (description = "A code-name for the table")
      (uneditable)
      (size = 50)
      (width = 20)
      (height = 1)
      (displayorder = 1)
      (displaylevel = record)
      (searchability = no)
      (unique)
      ;
    String displayname
      (displayname = "Display name")
      (description = "A user-friendly name for the table")
      (size = 60)
      (width = 20)
      (height = 1)
      (displayorder = 2)
      (displaylevel = primary)
      (searchability = yes)
      (displayorderpriority = 1)
      ;
    String description
      (displayname = "Description")
      (description = "A brief description of the table's function")
      (nullable)
      (size = unlimited)
      (width = 20)
      (height = 1)
      (displayorder = 3)
      (displaylevel = record)
      (searchability = no)
      ;
    Integer displayorder
      (displayname = "Display order")
      (description = "A rank determining where the table appears in the list of all tables")
      (width = 20)
      (height = 1)
      (displayorder = 4)
      (displaylevel = summary)
      (searchability = yes)
      (displayorderpriority = 0)
      ;
    Capability defaultcanread
      (displayname = "Default `read' capability")
      (description = "The capability required, by default, for reading the table's records")
      (nullable)
      (width = 20)
      (height = 1)
      (displayorder = 5)
      (displaylevel = record)
      (searchability = no)
      (integrityfix = prevent)
      ;
    Capability defaultcanwrite
      (displayname = "Default `write' capability")
      (description = "The capability required, by default, for updating the table's records")
      (nullable)
      (width = 20)
      (height = 1)
      (displayorder = 6)
      (displaylevel = record)
      (searchability = no)
      (integrityfix = prevent)
      ;
    Capability defaultcandelete
      (displayname = "Default `delete' capability")
      (description = "The capability required, by default, for deleting the table's records")
      (nullable)
      (width = 20)
      (height = 1)
      (displayorder = 7)
      (displaylevel = record)
      (searchability = no)
      (integrityfix = prevent)
      ;
    Capability cancreate
      (displayname = "Default `create' capability")
      (description = "The capability required, by default, for creating records in the table")
      (nullable)
      (width = 20)
      (height = 1)
      (displayorder = 8)
      (displaylevel = record)
      (searchability = no)
      (integrityfix = prevent)
      ;
    Integer cachelimit
      (displayname = "Cache size limit")
      (description = "The maximum number of records from the table to keep in the cache")
      (nullable)
      (width = 20)
      (height = 1)
      (displayorder = 9)
      (displaylevel = record)
      (searchability = no)
      ;
    Boolean seqcached
      (displayname = "Record sequence cached")
      (description = "Whether the display sequence for the table's records is cached")
      (width = 20)
      (height = 1)
      (displayorder = 10)
      (displaylevel = record)
      (searchability = no)
      ;
    TableCategory category
      (displayname = "Category")
      (description = "Which category the table falls into")
      (width = 20)
      (height = 1)
      (displayorder = 11)
      (displaylevel = record)
      (searchability = primary)
      (integrityfix = prevent)
      ;
 }

table columnInfo

  (displayname = "Column")
  (description = "Configuration information about a column in the database")
  (displayorder = 3020)
  (defaultcanwrite = _administer_)
  (defaultcandelete = _administer_)
  (cancreate = _administer_)
  (cachelimit = 999999999)
  (seqcached)
  (category = "System")
{
    String displayname
      (displayname = "Display name")
      (description = "A user-friendly name for the field")
      (size = 60)
      (width = 20)
      (height = 1)
      (displayorder = 100)
      (displaylevel = primary)
      (searchability = yes)
      (displayorderpriority = 2)
      ;
    String description
      (displayname = "Description")
      (description = "A brief description of the field's function")
      (nullable)
      (size = unlimited)
      (width = 20)
      (height = 1)
      (displayorder = 101)
      (displaylevel = record)
      (searchability = no)
      ;
    Boolean usereditable
      (displayname = "User-editable")
      (description = "Whether it makes sense for the user to update the field's value")
      (width = 20)
      (height = 1)
      (displayorder = 200)
      (displaylevel = detail)
      (searchability = no)
      ;
    ColumnType typefactory
      (displayname = "Type")
      (description = "The field's Melati type")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 201)
      (displaylevel = detail)
      (searchability = no)
      ;
    Boolean nullable
      (displayname = "Nullable")
      (description = "Whether the field can be empty")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 202)
      (displaylevel = detail)
      (searchability = no)
      ;
    Integer size
      (displayname = "Size")
      (description = "For character fields, the maximum number of characters that can be stored, (-1 for unlimited)")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 203)
      (displaylevel = record)
      (searchability = no)
      ;
    Integer width
      (displayname = "Input-box width")
      (description = "A sensible width for text boxes used for entering the field, where appropriate")
      (width = 20)
      (height = 1)
      (displayorder = 204)
      (displaylevel = record)
      (searchability = no)
      ;
    Integer height
      (displayname = "Input-box height")
      (description = "A sensible height for text boxes used for entering the field, where appropriate")
      (width = 20)
      (height = 1)
      (displayorder = 205)
      (displaylevel = record)
      (searchability = no)
      ;
    Integer precision
      (displayname = "Precision")
      (description = "Precision (total number of digits) for fixed-point numbers")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 206)
      (displaylevel = record)
      (searchability = no)
      ;
    Integer scale
      (displayname = "Scale")
      (description = "Scale (number of digits after the decimal) for fixed-point numbers")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 207)
      (displaylevel = record)
      (searchability = no)
      ;
    String renderinfo
      (displayname = "Rendering information")
      (description = "The name of the Melati templet (if not the default) to use for input controls for the field")
      (nullable)
      (size = unlimited)
      (width = 20)
      (height = 1)
      (displayorder = 208)
      (displaylevel = record)
      (searchability = no)
      ;
    String rangelow_string
      (displayname = "Range: low")
      (description = "The low end of the range of permissible values for the field")
      (nullable)
      (size = unlimited)
      (width = 20)
      (height = 1)
      (displayorder = 209)
      (displaylevel = detail)
      (searchability = no)
      ;
    String rangelimit_string
      (displayname = "Range: limit")
      (description = "The (exclusive) limit of the range of permissible values for the field")
      (nullable)
      (size = unlimited)
      (width = 20)
      (height = 1)
      (displayorder = 210)
      (displaylevel = detail)
      (searchability = no)
      ;
    Integer id
      (primary)
      (displayname = "Id")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 0)
      (uncreateable)
      (displaylevel = summary)
      (searchability = yes)
      (indexed)
      (unique)
      ;
    TableInfo tableinfo
      (displayname = "Owning table")
      (description = "The table to which the field belongs")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 1)
      (displaylevel = summary)
      (searchability = primary)
      (displayorderpriority = 0)
      (integrityfix = prevent)
      ;
    String name
      (displayname = "Name")
      (description = "A code-name for the field")
      (uneditable)
      (size = 50)
      (width = 20)
      (height = 1)
      (displayorder = 300)
      (displaylevel = record)
      (searchability = no)
      (indexed)
      ;
    Integer displayorder
      (displayname = "Display order")
      (description = "A rank determining where the field appears in lists")
      (width = 20)
      (height = 1)
      (displayorder = 301)
      (displaylevel = record)
      (searchability = no)
      (displayorderpriority = 1)
      ;
    Boolean usercreateable
      (displayname = "User-createable")
      (description = "Whether it makes sense for the user to initialise the field's value")
      (width = 20)
      (height = 1)
      (displayorder = 302)
      (displaylevel = detail)
      (searchability = no)
      ;
    DisplayLevel displaylevel
      (displayname = "Display level")
      (description = "A category determining what granularity of report the field appears in")
      (width = 20)
      (height = 1)
      (displayorder = 303)
      (displaylevel = record)
      (searchability = no)
      ;
    Searchability searchability
      (displayname = "Searchability")
      (description = "A category determining what level of searching this field supports")
      (width = 20)
      (height = 1)
      (displayorder = 304)
      (displaylevel = record)
      (searchability = no)
      ;
    Integer displayorderpriority
      (displayname = "Display order priority")
      (description = "If present, the level at which lists of records are sorted by the field")
      (nullable)
      (width = 20)
      (height = 1)
      (displayorder = 305)
      (displaylevel = summary)
      (searchability = no)
      ;
    Boolean sortdescending
      (displayname = "Sort Descending")
      (description = "Whether when sorting by this column, the sort order should be reversed")
      (nullable)
      (width = 20)
      (height = 1)
      (displayorder = 306)
      (displaylevel = record)
      (searchability = no)
      ;
    Boolean indexed
      (displayname = "Indexed")
      (description = "Whether the field is indexed (ignored if the field is marked `unique')")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 307)
      (displaylevel = record)
      (searchability = no)
      ;
    Boolean unique
      (displayname = "Unique")
      (description = "Whether the field is unique (implies that it's `indexed')")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 308)
      (displaylevel = record)
      (searchability = no)
      ;
    IntegrityFix integrityfix
      (displayname = "Integrity fix")
      (description = "How referential integrity is maintained, what to do when the object referred to is deleted")
      (nullable)
      (width = 20)
      (height = 1)
      (displayorder = 309)
      (displaylevel = record)
      (searchability = no)
      ;
 }

table tableCategory

  (displayname = "Table type")
  (description = "A category under which a table can be classified")
  (displayorder = 3030)
  (defaultcanwrite = _administer_)
  (defaultcandelete = _administer_)
  (cancreate = _administer_)
  (cachelimit = 999999999)
  (seqcached)
  (category = "System")
{
    Integer id
      (primary)
      (displayname = "Id")
      (description = "The Table Row Object ID")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 0)
      (uncreateable)
      (displaylevel = summary)
      (searchability = yes)
      (indexed)
      (unique)
      ;
    String name
      (displayname = "Name")
      (description = "A human-readable name for the category")
      (size = 60)
      (width = 20)
      (height = 1)
      (displayorder = 1)
      (displaylevel = primary)
      (searchability = primary)
      (displayorderpriority = 0)
      (unique)
      ;
 }

table setting

  (displayname = "Setting")
  (description = "A configurable setting for the application")
  (displayorder = 3040)
  (defaultcanwrite = _administer_)
  (defaultcandelete = _administer_)
  (cancreate = _administer_)
  (cachelimit = 999999999)
  (seqcached)
  (category = "System")
{
    String displayname
      (displayname = "Display name")
      (description = "A user-friendly name for the field")
      (size = 60)
      (width = 20)
      (height = 1)
      (displayorder = 100)
      (displaylevel = primary)
      (searchability = yes)
      (displayorderpriority = 2)
      ;
    String description
      (displayname = "Description")
      (description = "A brief description of the field's function")
      (nullable)
      (size = unlimited)
      (width = 20)
      (height = 1)
      (displayorder = 101)
      (displaylevel = record)
      (searchability = no)
      ;
    Boolean usereditable
      (displayname = "User-editable")
      (description = "Whether it makes sense for the user to update the field's value")
      (width = 20)
      (height = 1)
      (displayorder = 200)
      (displaylevel = detail)
      (searchability = no)
      ;
    ColumnType typefactory
      (displayname = "Type")
      (description = "The field's Melati type")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 201)
      (displaylevel = detail)
      (searchability = no)
      ;
    Boolean nullable
      (displayname = "Nullable")
      (description = "Whether the field can be empty")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 202)
      (displaylevel = detail)
      (searchability = no)
      ;
    Integer size
      (displayname = "Size")
      (description = "For character fields, the maximum number of characters that can be stored, (-1 for unlimited)")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 203)
      (displaylevel = record)
      (searchability = no)
      ;
    Integer width
      (displayname = "Input-box width")
      (description = "A sensible width for text boxes used for entering the field, where appropriate")
      (width = 20)
      (height = 1)
      (displayorder = 204)
      (displaylevel = record)
      (searchability = no)
      ;
    Integer height
      (displayname = "Input-box height")
      (description = "A sensible height for text boxes used for entering the field, where appropriate")
      (width = 20)
      (height = 1)
      (displayorder = 205)
      (displaylevel = record)
      (searchability = no)
      ;
    Integer precision
      (displayname = "Precision")
      (description = "Precision (total number of digits) for fixed-point numbers")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 206)
      (displaylevel = record)
      (searchability = no)
      ;
    Integer scale
      (displayname = "Scale")
      (description = "Scale (number of digits after the decimal) for fixed-point numbers")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 207)
      (displaylevel = record)
      (searchability = no)
      ;
    String renderinfo
      (displayname = "Rendering information")
      (description = "The name of the Melati templet (if not the default) to use for input controls for the field")
      (nullable)
      (size = unlimited)
      (width = 20)
      (height = 1)
      (displayorder = 208)
      (displaylevel = record)
      (searchability = no)
      ;
    String rangelow_string
      (displayname = "Range: low")
      (description = "The low end of the range of permissible values for the field")
      (nullable)
      (size = unlimited)
      (width = 20)
      (height = 1)
      (displayorder = 209)
      (displaylevel = detail)
      (searchability = no)
      ;
    String rangelimit_string
      (displayname = "Range: limit")
      (description = "The (exclusive) limit of the range of permissible values for the field")
      (nullable)
      (size = unlimited)
      (width = 20)
      (height = 1)
      (displayorder = 210)
      (displaylevel = detail)
      (searchability = no)
      ;
    Integer id
      (primary)
      (displayname = "Id")
      (description = "The Table Row Object ID")
      (uneditable)
      (width = 20)
      (height = 1)
      (displayorder = 0)
      (uncreateable)
      (displaylevel = summary)
      (searchability = yes)
      (indexed)
      (unique)
      ;
    String name
      (displayname = "Name")
      (description = "A code name for this setting")
      (size = 200)
      (width = 20)
      (height = 1)
      (displayorder = 1)
      (displaylevel = summary)
      (searchability = primary)
      (unique)
      ;
    String value
      (displayname = "Value")
      (description = "The value of this setting")
      (nullable)
      (size = unlimited)
      (width = 20)
      (height = 1)
      (displayorder = 150)
      (displaylevel = summary)
      (searchability = yes)
      ;
 }