# Table: Customer

# `Primary Key`

`Columns`	`Cluster`	`Unique`
id		true

`Columns`	`Ref Table`	`Ref Columns`
typeId	CustomerTypes	id
sizeId	CustomerSizes	id
industryId	CustomerIndustries	id
rankId	CustomerRanks	id
industrialParkId	CustomerIndustrialParks	id
channelId	CustomerChannels	id
userInchargeId	CustomerUsers	id

`Columns`	`Ref Table`	`Ref Columns`	`Options`
Id	Orders	customerId

`Label`	`Name`	`Type`	`Nullable`	`Default`	`Comment`	`Unique`
Id	id	int auto_increment	`false`			`false`
Customer Name	customerName	text	`false`			`false`
Email	email	text	`false`	`null`		`false`
Password	password	varchar(65)	`false`			`false`
Code	code	varchar	`false`			`true`
Avatar	avatar	varchar	`false`			`false`
Phone	phone	varchar	`true`	`null`		`false`
Address	address	text	`true`			`false`
Type	typeId	int	`true`	`null`	`loai khach hang`	`false`
Size	sizeId	int	`true`	`null`	`quy mo khach hang`	`false`
Industry	industryId	int	`true`	`null`	`nghanh cong nghiep`	`false`
Rank	rankId	int	`true`	`null`	`xep loai`	`false`
Industrial Park	industrialParkId	int	`true`	`null`	`khu cong nghiep`	`false`
Channel	channelId	int	`true`	`null`	`kenh tiep nhan`	`false`
User Incharge	userInchargeId	int	`true`	`null`	`nhan vien dam nhan`	`false`
Website	website	text	`true`	`null`		`false`
Tax Code	taxCode	text	`true`	`null`	`ma so thue`	`false`
Created By	createdBy	int	`false`			`false`
Updated By	updatedBy	int	`true`			`false`
Created At	createdAt	datetime	`false`			`false`
Updated At	updatedAt	datetime	`false`			`false`
Deleted	deleted	tinyint(1)	`false`	`false`		`false`