jiveBan Table

Ban data table.

Column Name Type Length Nullable Unicode Description
adminID bigint N/A false   The ID of the admin making the ban decision.
banID bigint N/A false   The ID of the ban. Primary key.
banLevel int N/A false   The ban punishment (constants defined in application).
banType int N/A false   The type of ban (constants defined in the application).
bannedUserID bigint N/A true   The ID of the user being banned.
comments varchar 50 true true Any comments associated with the ban.
creationDate bigint N/A false   The date the ban was created.
expirationDate bigint N/A true   The date the ban expires.
ipAddress varchar 15 true true The IP address being banned.