supportcat

supportcat — Global. Stores Support system categories.

supportcat

Column name Type Null Default Description
spcatid int unsigned auto_increment    
catkey varchar(25)    
catname varchar(80) YES  
sortorder mediumint unsigned   0  
basepoints tinyint unsigned   1  
is_selectable enum('1','0')   1  
public_read enum('1','0')   1  
public_help enum('1','0')   1 Controls if you can use internal comments/actions as Reply Types.
allow_screened enum('1','0')   0  
hide_helpers enum('1','0')   0  
user_closeable enum('1','0')   1  
replyaddress varchar(50) YES  
no_autoreply enum('1','0')   0  
scope enum('general','local')   general  
Key name Type Column(s)
PRIMARY PRIMARY
catkey UNIQUE