manufacturer

185 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
inventory.manufacturer_id FK_B12D4A36A23B42DR
manufacturer_client.manufacturer_id FK_DAF84AA5A23B42DC
manufacturer_objectgroup.manufacturer_id FK_AD271CF6A23B42DC
manufacturermetafield.manufacturer_id FK_3E6E93F6A23B42DR
manufacturerupload.manufacturer_id FK_96DB9E93A23B42DR
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

Close relationships within degrees of separation