This article outlines the database structure for the MMv4 ban_list database table.

• id
  Primary Key of the table.
  int(10) | unsigned | auto increment | primary key | indexed
  
• banned_value
  The string the ban rule is checked against, e.g. the banned IP address, the banned email address, etc.  
  varchar(255) | indexed
• active
  Ban's active status.  An account with active banned status
  int(10) | unsigned | Values: 0/timestamp | Default: 1 | indexed
• rule_type
  The type of criteria that the ban rule is checked against, e.g. IP address, email address, etc.
  varchar(255) | indexed
• description
  Admin-only notes about the ban, normally used to record why the customer was banned.
  varchar(255)