Skip to content

stickers

Column NameTypeCommentDefaultNullRemark
idint UNSIGNEDPrimary Key IDNOAuto Increment
codevarchar(32)Sticker codeNOUnique Case-insensitive for alphabets and symbols
namejsonSticker nameYESMultilingual
image_file_idbigint UNSIGNEDSticker image IDYESRelated field files->id
image_file_urlvarchar(255)Sticker image URLYES
typetinyint UNSIGNEDIs it a sticker group1NO1.Sticker / 2.Sticker group
parent_idint UNSIGNEDParent sticker IDYES
sort_ordersmallint UNSIGNEDDisplay order99YESAscending order
is_enabledtinyint UNSIGNEDIs enabled1YES0.Disabled / 1.Enabled
created_attimestampCreate TimeuseCurrentYESFor example, MySQL defaults to CURRENT_TIMESTAMP
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License