Table: CustomerWishLists
Name: CustomerWishLists Comment:Lưu yêu cầu của khách hàng
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 | |
| productId | Products | 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 | | |
| Product | productId | int | false | | |
| Quantity | quantity | int | false | | |
| Created By | createdBy | int | false | | |
| Updated By | updatedBy | int | true | null | |
| Created At | createdAt | datetime | false | | |
| Updated At | updatedAt | datetime | false | | |
| Deleted | deleted | tinyint(1) | true | 0 | |