»

supportcat

supportcat — Categories for support system

supportcat

Column nameTypeNullDefaultDescription
spcatidint unsigned auto_increment  
catkeyvarchar(25)  
catnamevarchar(80)YES 
sortordermediumint unsigned 0 
basepointstinyint unsigned 1 
is_selectableenum('1','0') 1 
public_readenum('1','0') 1 
public_helpenum('1','0') 1 
allow_screenedenum('1','0') 0 
hide_helpersenum('1','0') 0 
replyaddressvarchar(50)YES 
no_autoreplyenum('1','0') 0 
scopeenum('general','local') general 
Key nameTypeColumn(s)
PRIMARYPRIMARY
catkeyUNIQUE