Skip to main content

Definition

Brand

AttributeNameAttributeTypeColumnNameDataTypeNotNullComment
IDuint64idbigint(20) unsignedtrue
Keystringkeyvarchar(32)trueunique key
BrandNamestringbrand_namevarchar(127)true
Seqint8seqtinyint(3)truesequence
Statusintstatusint(10)true-1 deleted 0 pendding 1 valid
CreatedAt*time.Timecreated_attimestampfalse
UpdatedAt*time.Timeupdated_attimestampfalse

Category

AttributeNameAttributeTypeColumnNameDataTypeNotNullComment
IDuint64idbigint(20) unsignedtrue
Refuint64refbigint(20) unsignedtrueref to id
Keystringkeyvarchar(32)trueunique key
CategoryNamestringcategory_namevarchar(127)true
Seqint8seqtinyint(3)truesequence
Statusintstatusint(10)true-1 deleted 0 pendding 1 valid
CreatedAt*time.Timecreated_attimestampfalse
UpdatedAt*time.Timeupdated_attimestampfalse

Product

AttributeNameAttributeTypeColumnNameDataTypeNotNullComment
IDuint64idbigint(20) unsignedtrue
CategoryIDuint64category_idbigint(20) unsignedtrue
BrandIDuint64brand_idbigint(20) unsignedtrue
Keystringkeyvarchar(32)trueunique key
Titlestringtitlevarchar(127)true
SubTitle*stringsub_titlevarchar(255)false
Slug*stringslugvarchar(255)falsefriendly format url
Pricefloat64pricedecimal(10,2)truecurrent price
Discountfloat64discountdecimal(10,2)truediscount
Content*stringcontenttextfalse
Seqint8seqtinyint(3)truesequence
Statusintstatusint(10)true-1 deleted 0 pendding 1 valid
CreatedAt*time.Timecreated_attimestampfalse
UpdatedAt*time.Timeupdated_attimestampfalse

Tag

AttributeNameAttributeTypeColumnNameDataTypeNotNullComment
IDuint64idbigint(20) unsignedtrue
Refuint64refbigint(20) unsignedtrueref to id
Keystringkeyvarchar(32)trueunique key
TagNamestringtag_namevarchar(127)true
Statusintstatusint(10)true-1 deleted 0 pendding 1 valid
CreatedAt*time.Timecreated_attimestampfalse
UpdatedAt*time.Timeupdated_attimestampfalse

Version

AttributeNameAttributeTypeColumnNameDataTypeNotNullComment
IDuint64idbigint(20) unsignedtrue
ProductIDuint64product_idbigint(20) unsignedtrue
VersionNamestringversion_namevarchar(127)true
Seqint8seqtinyint(3)truesequence
Statusintstatusint(10)true-1 deleted 0 pendding 1 valid
CreatedAt*time.Timecreated_attimestampfalse
UpdatedAt*time.Timeupdated_attimestampfalse

Color

AttributeNameAttributeTypeColumnNameDataTypeNotNullComment
IDuint64idbigint(20) unsignedtrue
ProductIDuint64product_idbigint(20) unsignedtrue
ColorNamestringcolor_namevarchar(127)true
ColorCodestringcolor_codevarchar(127)truecolor code like #FFFFFF
Seqint8seqtinyint(3)truesequence
Statusintstatusint(10)true-1 deleted 0 pendding 1 valid
CreatedAt*time.Timecreated_attimestampfalse
UpdatedAt*time.Timeupdated_attimestampfalse

Image

AttributeNameAttributeTypeColumnNameDataTypeNotNullComment
IDuint64idbigint(20) unsignedtrue
ProductIDuint64product_idbigint(20) unsignedtrue
ImageSrc*stringimage_srcvarchar(255)false
Seqint8seqtinyint(3)truesequence
Statusintstatusint(10)true-1 deleted 0 pendding 1 valid
CreatedAt*time.Timecreated_attimestampfalse
UpdatedAt*time.Timeupdated_attimestampfalse

ProductTag

AttributeNameAttributeTypeColumnNameDataTypeNotNullComment
ProductIDuint64product_idbigint(20) unsignedtrue
TagIDuint64tag_idbigint(20) unsignedtrue

Sku

AttributeNameAttributeTypeColumnNameDataTypeNotNullComment
IDuint64idbigint(20) unsignedtrue
ProductIDuint64product_idbigint(20) unsignedtrue
VersionIDuint64version_idbigint(20) unsignedtrue
ColorIDuint64color_idbigint(20) unsignedtrue
SkuNamestringsku_namevarchar(127)true
Qtyintqtyint(10)truequantity
Pricefloat64pricedecimal(10,2)truecurrent price
Discountfloat64discountdecimal(10,2)truediscount
Seqint8seqtinyint(3)truesequence
Statusintstatusint(10)true-1 deleted 0 pendding 1 valid
CreatedAt*time.Timecreated_attimestampfalse
UpdatedAt*time.Timeupdated_attimestampfalse