Table: QuotationDetails

• Name: QuotationDetails
• Comment:Lưu danh sách chi tiết báo giá

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
quotationId	Quotations	id
productId	Products	id

Relationships

Columns	Ref Table	Ref Columns	Options

Columns[]

Label	Name	Type	Nullable	Default	Comment
Id	id	int auto_increment	false
Quotation	quotationId	int	false
Product	productId	int	false
Quantity	quantity	int	true	0
Unit Price	unitPrice	float	true	0
Total	total	float	true	0
Note	note	text	true	null
Weight	weight	float	true	0
Tax	tax	int	true	null
Shipping Cost	shippingCost	float	true	0
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