Table: ProductsVariants

• Name: ProductsVariants
• Comment:Lưu danh sách các biến thể của sản phẩm

Primary Key

• Columns: Id
• Cluster: false

Indexes[]

Columns	Cluster	Unique
id		true

Foreign Keys[]

Columns	Ref Table	Ref Columns	Options
createdBy	Users	id
updatedBy	Users	id
productId	Products	id
variantValueId	Variants	id

Relationships

Columns	Ref Table	Ref Columns	Options

Columns[]

Label	Name	Type	Nullable	Default	Comment
Id	id	int auto_increment	false
Product	productId	int	false
Variant	variantValueId	int	false
Price	price	float	true	null
Sale Price	salePrice	float	true	null
Stock	stock	int	true	null
SKU	sku	text	true	null
Discount Rate	discountRate	int	true	0
Sold Quantity	soldQuantity	int	true	0
Created By	createdBy	int	false
Updated By	updatedBy	int	true	null
Created At	createdAt	datetime	true
Updated At	updatedAt	datetime	true
Is Enabled	isEnabled	int(4)	false	1