# Table: SuppliersCategories

  • Name: SuppliersCategories
  • Comment:Lưu danh sách các loại danh mục nhà cung cấp

# 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
categoryId Categories id
supplierId Suppliers id

# Relationships

Columns Ref Table Ref Columns Options

# Columns[]

Label Name Type Nullable Default Comment
Id id int auto_increment false
Category categoryId int false
Supplier supplierId int 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
Is Use isUse tinyint(1) false 1