Table: Quotations

• Name: Quotations
• Comment:Lưu danh sách các yêu cầu 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
customerId	Customers	id
bdInChargeId	BulkDiscounts	id
representativeId	Representatives	id
quotationStatusId	QuotationStatuss	id
salesInChargeId	SalesInCharges	id
customerAddressId	CustomerAddress	id
personInChargeId	PersonInCharges	id

Relationships

Columns	Ref Table	Ref Columns	Options

Columns[]

Label	Name	Type	Nullable	Default	Comment
Id	id	int auto_increment	false
Customer	customerId	int	false
Code	code	int	false
Total	total	float	true	0
In Charge	bdInChargeId	int	true	null
Represent Ative	representativeId	int	true	null
Quotation Status	quotationStatusId	int	true	1
Cancel Reason	cancelReason	text	true	null
Note	note	text	true	null
Tax	tax	text	true	0
Sales In Charge	salesInChargeId	int	true	null
Is Important	isImportant	int	true	0
Customer Address	customerAddressId	int	true	null
Order	orderId	int	true	0
Person In Charge	personInChargeId	int	true	null
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