vendorinformation

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
vendor.information_id FK_F52233F62EF03101R
country_id VARCHAR 36 null
country.id FK_D0473C9CF92F3E70R
salutation VARCHAR 30 null
company VARCHAR 255 null
contact VARCHAR 255 null
firstName VARCHAR 255 null
lastName VARCHAR 255 null
street VARCHAR 255 null
zip VARCHAR 10 null
city VARCHAR 255 null
phone VARCHAR 255 null
fax VARCHAR 255 null
email VARCHAR 255 null
url VARCHAR 255 null
vatId VARCHAR 50 null
status VARCHAR 255 null
creditorNumber VARCHAR 255 null
taxFree BIT 1 null
bankAccountHolder VARCHAR 255 null
bankName VARCHAR 255 null
bankCode VARCHAR 255 null
bankNumber VARCHAR 255 null
bicCode VARCHAR 255 null
ibanNumber VARCHAR 255 null
dropshipper BIT 1 null
notForBuyingList BIT 1 null
language_id VARCHAR 36 null
language.id FK_D0473C9C82F1BAF4R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_D0473C9C82F1BAF4 Performance Asc language_id
IDX_D0473C9CF92F3E70 Performance Asc country_id

Relationships