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 | | |