productoption

50 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
product_option.option_id FK_38FA4114A7C41D6FR
productoption_client.productoption_id FK_53EB464042B43298C
productoption_objectgroup.productoption_id FK_F3E4D5CA42B43298C
productoptionfield.productoption_id FK_1EF230F342B43298R
productoptionmaterialquantity.productOption_id FK_9D01FE74C045B03BR
productoptionmetafield.productoption_id FK_14D1516742B43298R
foreign_id VARCHAR 36 √ null
title VARCHAR 255 null
ident VARCHAR 255 null
sort INT 10 null
mainClient_id VARCHAR 36 √ null
client.id FK_71E297706CF8BF97R
baseMaterial_id VARCHAR 36 √ null
product.id FK_71E29770956500CCR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_71E297706CF8BF97 Performance Asc mainClient_id
IDX_71E29770956500CC Performance Asc baseMaterial_id
search_idx Performance Asc foreign_id

Relationships

Close relationships within degrees of separation