Table: SupplierUsers

• Name: SupplierUsers
• Comment: Lưu thông tin đăng nhập của nhà cung cấp quản lý trang supplier-admin

Primary Key

• Columns: Id
• Cluster: false

Indexes[]

Columns	Cluster	Unique

Foreign Keys[]

Columns	Ref Table	Ref Columns	Options
roleId	Roles	id	---------
supplierId	Supplier	id	---------

Relationships[]

Columns	Ref Table	Ref Columns	Options
Id	UserRoles	userId

Columns[]

Label	Name	Type	Nullable	Default	Comment
Company	companyId	int	false
Id	id	int auto_increment	false
Role	roleId	int	false
Supplier	supplierId	int	true	null
Email	email	text	false
Username	username	text	false
Password	password	text	false
First Name	firstName	text	true	null
Last Name	lastName	text	true	null
Phone	phone	text	true	null
Avatar	avatar	text	true	null
Address	address	text	true	null
Username	username	text	false
Change Password	changePassword	tinyint(1)	false	0
Is Active	isActive	tinyint(1)	false	1
Created By	createdBy	int	false
Updated By	updatedBy	int	false
Created At	createdAt	datetime	false
Updated At	updatedAt	datetime	false
Delete	deleted	tinyint(1)	false	0