productprice

45 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
product_id VARCHAR 36 null
product.id FK_1A0570634584665AR
client_id VARCHAR 36 null
client.id FK_1A05706319EB6921R
price DECIMAL 10,4 null
customerGroup_id VARCHAR 36 null
customergroup.id FK_1A0570636FB7FED2R
sort INT 10 null
salesChannel_id VARCHAR 36 null
saleschannel.id FK_1A0570634C7A5B2ER
priceMode INT 10 null
priceFormula LONGTEXT 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_1A05706319EB6921 Performance Asc client_id
IDX_1A0570634584665A Performance Asc product_id
IDX_1A0570634C7A5B2E Performance Asc salesChannel_id
IDX_1A0570636FB7FED2 Performance Asc customerGroup_id

Relationships