emojis

Column NameTypeCommentsDefaultNullRemark
idint UNSIGNEDPrimary IDNOAUTO_INCREMENT
codechar(16)表情符号NOUnique Column 不区分中英文或符号
namevarchar(64)名称NO多语言
image_file_idbigint UNSIGNED表情图 IDYES关联字段 files > id
image_file_urlvarchar(255)图标文件完整 URLNO根据“images_bucket_domain”键值
拼接成的完整 URL 地址
typetinyint UNSIGNED是否表情小组1NO1.表情 / 2.表情小组
parent_idint UNSIGNED父级小组 IDYES
rank_numsmallint UNSIGNED排列顺序99YES升序排序
is_enabletinyint UNSIGNED是否启用1YES0=Disable(false) / 1=Enable(true)
created_attimestampCreated TimeCURRENT_TIMESTAMPYES
updated_attimestampUpdated TimeCURRENT_TIMESTAMPYES
deleted_attimestampDeleted TimeYES