productstock

4747 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
product_id VARCHAR 36 null
product.id FK_9BFB04DA4584665AR
client_id VARCHAR 36 null
client.id FK_9BFB04DA19EB6921R
stock DECIMAL 10,3 null
reservedStock DECIMAL 10,3 null
stockForSale DECIMAL 10,3 null
customReservedStock DECIMAL 10,3 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_9BFB04DA19EB6921 Performance Asc client_id
IDX_9BFB04DA4584665A Performance Asc product_id

Relationships