vendor

12 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
liability.vendor_id FK_3B59ECCCF603EE73R
offeritem.vendor_id FK_7E455D7CF603EE73R
product.vendor_id FK_D34A04ADF603EE73R
vendor_client.vendor_id FK_B18E03C7F603EE73C
vendor_objectgroup.vendor_id FK_7EBC89E2F603EE73C
vendorcontact.vendor_id FK_C39B0629F603EE73R
vendororder.vendor_id FK_82C1E65CF603EE73R
vendorproduct.vendor_id FK_5CB3E4BCF603EE73R
information_id VARCHAR 36 null
vendorinformation.id FK_F52233F62EF03101R
conditions_id VARCHAR 36 null
vendorconditions.id FK_F52233F6C5FBDC0FR
foreign_id VARCHAR 36 null
title VARCHAR 255 null
active BIT 1 null
description VARCHAR 255 null
customerNumber VARCHAR 255 null
vendorNumber VARCHAR 255 null
icon VARCHAR 255 null
lastupdated INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UNIQ_F52233F62EF03101 Must be unique Asc information_id
UNIQ_F52233F6C5FBDC0F Must be unique Asc conditions_id

Relationships