Table: Suppliers
Name: SuppliersComment:Lưu danh sách thông tin các nhà cung cấp ei-admin
Primary Key
Columns: IdCluster: false
Indexes[]
Foreign Keys[]
Columns | Ref Table | Ref Columns | Options |
|---|
Relationships[]
Columns | Ref Table | Ref Columns | Options |
|---|
| Id | SupplierCategories | supplierId | |
| Id | Products | supplierId | |
Columns[]
Label | Name | Type | Nullable | Default | Comment |
|---|
| Id | id | int auto_increment | false | | |
| Name | name | int | false | | |
| Email | email | varchar(255) | false | | |
| Company | company | varchar(255) | false | | |
| Address | address | varchar(255) | false | | |
| Phone | phone | int | false | | |
| Tax Code | taxCode | int | false | | |
| Company | company | varchar(255) | false | | |
| Code | code | varchar(3) | false | | |
| Short Description | shortDesc | varchar(255) | false | | |
| Description | desc | varchar(255) | false | | |
| Type | type | tinyint(1) | false | | |
| Status | status | tinyint(1) | false | | |
| Created By | createdBy | int | false | | |
| Updated By | updatedBy | int | false | | |
| Created At | createdAt | datetime | false | | |
| Updated At | updatedAt | datetime | false | | |
| Delete | delete | tinyint(1) | false | | |