supportcat

supportcat — Categories for support system

supportcat

Column nameTypeNullDefaultDescription
spcatidint unsigned auto_increment
catkeyvarchar(25)
catnamevarchar(80)YES
sortordermediumint unsigned0
basepointstinyint unsigned1
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