Table: Order Details
Name: Order Details Comment:Lưu thông tin chi tiết đơn hàng
Primary Key
Columns: Id Cluster: false
Indexes[]
Foreign Keys[]
Columns | Ref Table | Ref Columns | Options |
| orderId | Orders | id | |
| productId | Products | id | |
| supId | Suppliers | id | |
Relationships[]
Columns | Ref Table | Ref Columns | Options |
| orderId | Orders | id | |
| productId | Products | id | |
| supId | Suppliers | id | |
Columns[]
Label | Name | Type | Nullable | Default | Comment |
| Id | id | bigint(20) auto_increment | false | | |
| Quantity | quantity | int | false | | |
| Price | price | double | false | | |
| Total Price | totalPrice | dounble | false | | |
| Supplier Id | supId | int | false | | |
| Delivery Date | deliveryDate | datetime | true | | |
| Order ID | orderId | int | false | | |
| Product ID | productId | varchar(255) | false | | |
| Product Name | productName | varchar(255) | false | | |
| Product Model | productModel | varchar(255) | false | | |
| Product Image | productImg | varchar(255) | false | | |
| Deleted | deleted | tinyint(1) | false | | |
| Created By | createdBy | int | false | | |
| Updated By | updatedBy | int | false | | |
| Created At | createdAt | datetime | false | | |
| Updated At | updatedAt | datetime | false | | |