MMv4 KB
 
admin_attr DB Table
  Last Edited - 05/19/2010 9:26am PDT
  Category Path - Developer's Guide > Database Structure
 
This article outlines the database structure for the MMv4 admin_attr database table.

 

  • id
    Primary Key of the table.
    int(10) | unsigned | auto increment | primary key | indexed
  • display_order
    Determines the order in which the attribute is listed on-screen in the Admin Editor and other places.
    int(10) | unsigned | indexed
  • title
    Descriptive title of the attribute. This will be displayed with the
    attribute in any form in which the attribute is included.
    varchar(255)
  • description
    Description of the
    attribute. This will be displayed with the attribute in any form in which the attribute is included. It is a good place to include instructions.
    varchar(255)
  • input_type
    The type of
    attribute, typically: text_single, text_multi, text, dropdown, list_single, list_multi, radio. ("text_single" and "text_multi" will no longer need to be specified by the user. These are replaced by the "text" option. If a text field is set to have more than 1 line, the system will automatically change it to a "text_multi" field when it is displayed on a web page.)
    varchar(255)

  • active
    The
    attribute's active status. Inactive attributes are not displayed on any page that they otherwise would be.
    int(10) | unsigned | Values: 0/timestamp | Default: 1 | indexed
  • is_unique
    Whether or not the value of the
    attribute must be unique. If greater than zero, then no other entry for this same attribute will be allowed to have the same value.
    int(10) | unsigned | Values: 0/timestamp | Default: 0
  • num_lines
    The number of lines that a multi-line text field will contain. Only applicable if the type is a text field. If set to "1", then the text field will automatically display it as a single-line"text" input field instead of a multi-line "textarea" input field.
    int(10) | unsigned
  • required
    Whether or not the
    attribute may be left blank or be submitted with an empty value.
    int(10) | unsigned | Values: 0/timestamp | Default: 0
  • strict
    If the
    attribute's value is greater than zero, then only letters, numbers and underscores will be allowed in the value of the submitted attribute.
    int(10) | unsigned | Values: 0/timestamp | Default: 0
  • encrypt
    If set to a value greater than zero, then the value of the submitted
    attribute will be encrypted prior to being saved in the database. Note that encrypted attributes cannot be searched by the search tools in the administration or storefront areas.
    int(10) | unsigned | Values: 0/timestamp | Default: 0
  • internal_only
    If set to a value greater than zero, then the value of the submitted
    attribute will not be displayed outside of the store's Administration area.
    int(10) | unsigned | Values: 0/timestamp | Default: 0 | indexed
  • include_in_email
    If set to a value greater than zero, then the value of the submitted
    attribute will be included in any email correspondence generated by the software that includes information about the Admin account.
    int(10) | unsigned | Values: 0/timestamp | Default: 0 | indexed
  • maxlength
    Determines the maximum number of characters that may be entered into single-line text fields.
    int(10) | unsigned
  • default_value
    The default value of the attribute, if any.
    varchar(255)
Powered by ModularKB