manufacturer

185 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
manufacturer_client.manufacturer_id FK_DAF84AA5A23B42DC
manufacturer_objectgroup.manufacturer_id FK_AD271CF6A23B42DC
manufacturermetafield.manufacturer_id FK_3E6E93F6A23B42DR
product.manufacturer_id FK_D34A04ADA23B42DR
foreign_id VARCHAR 36 null
title VARCHAR 255 null
description VARCHAR 255 null
active BIT 1 null
icon VARCHAR 255 null
lastupdated INT 10 null
mainClient_id VARCHAR 36 null
client.id FK_3D0AE6DC6CF8BF97R

Indexes

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

Relationships