vendor

20 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
vendormetafield.vendor_id FK_66A50891F603EE73R
vendororder.vendor_id FK_82C1E65CF603EE73R
vendorordersubmissionitemdelivery.vendor_id FK_65DAAFCAF603EE73R
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
title_idx Performance Asc title
UNIQ_F52233F62EF03101 Must be unique Asc information_id
UNIQ_F52233F6C5FBDC0F Must be unique Asc conditions_id

Relationships

Close relationships within degrees of separation