Table: ProductsOptions
Name: ProductsOptionsComment:Lưu các tùy chọn sản phẩm
Primary Key
Columns: IdCluster: false
Indexes[]
Columns | Cluster | Unique |
|---|
| id | | true |
Foreign Keys[]
Columns | Ref Table | Ref Columns | Options |
|---|
| optionGroupId | OptionGroups | id | |
| optionId | Options | id | |
| productId | Products | id | |
| createdBy | Users | id | |
Relationships
Columns | Ref Table | Ref Columns | Options |
|---|
Columns[]
Label | Name | Type | Nullable | Default | Comment |
|---|
| Id | id | int auto_increment | false | | |
| Option Group | optionGroupId | int | false | 0 | |
| Option | optionId | int | false | 0 | |
| Product | productId | int | false | | |
| Is Enabled | isEnabled | int | false | 1 | |
| Created By | createdBy | int | false | | |
| Created At | createdAt | datetime | true | | |
| Updated At | updatedAt | datetime | true | | |