# 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[]

Columns Cluster Unique

# 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