address

20 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
customer.defaultAddress_id FK_81398E096614251FR
customer_id VARCHAR 36 null
customer.id FK_D4E6F819395C3F3R
country_id VARCHAR 36 null
country.id FK_D4E6F81F92F3E70R
state_id VARCHAR 36 null
state.id FK_D4E6F815D83CC1R
foreign_id VARCHAR 36 null
foreign_country_id VARCHAR 36 null
foreign_customer_id VARCHAR 36 null
title VARCHAR 255 null
company VARCHAR 255 null
firstName VARCHAR 255 null
lastName VARCHAR 255 null
street VARCHAR 255 null
city VARCHAR 255 null
zip VARCHAR 16 null
phone VARCHAR 128 null
fax VARCHAR 128 null
vatId VARCHAR 50 null
salutation VARCHAR 128 null
additionalInfo VARCHAR 255 null
defaultShippingAddress BIT 1 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_D4E6F815D83CC1 Performance Asc state_id
IDX_D4E6F819395C3F3 Performance Asc customer_id
IDX_D4E6F81F92F3E70 Performance Asc country_id

Relationships