Table: BulkDiscounts
Name
: BulkDiscounts Comment
: Lưu thông tin giảm giá hàng loạt
Primary Key
Columns
: Id Cluster
: false
Indexes[]
Columns | Cluster | Unique |
id | | true |
Foreign Keys[]
Columns | Ref Table | Ref Columns | Options |
Relationships
Columns | Ref Table | Ref Columns | Options |
productId | Products | Id | |
Columns[]
Label | Name | Type | Nullable | Default | Comment | Unique |
Id | id | int auto_increment | false | | | false |
Product | productId | int | false | | | false |
Form | form | int | false | | | false |
To | to | int | false | | | false |
Discount Rate | discountRate | float | true | null | | true |
Discount Price | discountPrice | float | true | null | | false |
Created By | createdBy | int | false | | | false |
Created At | createdAt | datetime | true | | | false |
Updated At | updatedAt | datetime | true | | | false |
Deleted | deleted | tinyint(1) | false | 0 | | false |