scaleprice

111 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
product_id VARCHAR 36 null
product.id FK_9F9E26154584665AR
foreign_id VARCHAR 36 null
amountFrom DOUBLE 22 null
amountTo DOUBLE 22 null
priceType INT 10 null
price DECIMAL 10,4 null
client_id VARCHAR 36 null
client.id FK_9F9E261519EB6921R
customerGroup_id VARCHAR 36 null
customergroup.id FK_9F9E26156FB7FED2R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_9F9E261519EB6921 Performance Asc client_id
IDX_9F9E26154584665A Performance Asc product_id
IDX_9F9E26156FB7FED2 Performance Asc customerGroup_id

Relationships