Table: Promotions

• Name: Promotions
• Comment:Lưu các chương trình khuyến mãi

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
companyId	Companies	id

Relationships

Columns	Ref Table	Ref Columns	Options

Columns[]

Label	Name	Type	Nullable	Default	Comment
Id	id	int auto_increment	false
Company	companyId	int	false
Name	name	text	false
Description	description	text	false
Start Date	startDate	varchar	false
End Date	endDate	varchar	false
Created By	createdBy	int	false
Updated By	updatedBy	int	true	null
Created At	createdAt	datetime	true
Updated At	updatedAt	datetime	true
Deleted	deleted	tinyint(1)	false	0