state

83 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
address.state_id FK_D4E6F815D83CC1R
customer.state_id FK_81398E095D83CC1R
liability.state_id FK_3B59ECCC5D83CC1R
offer.billingState_id FK_29D6873EE3C8343DR
offer.shippingState_id FK_29D6873E6EAEB92ER
statemetafield.state_id FK_844565C75D83CC1R
vendororder.billingState_id FK_82C1E65CE3C8343DR
vendororder.shippingState_id FK_82C1E65C6EAEB92ER
country_id VARCHAR 36 √ null
country.id FK_A393D2FBF92F3E70R
foreign_id VARCHAR 36 √ null
foreign_country_id VARCHAR 36 √ null
title VARCHAR 255 null
active BIT 1 null
isocode VARCHAR 3 null
sort INT 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_A393D2FBF92F3E70 Performance Asc country_id
search_idx Performance Asc isocode

Relationships

Close relationships within degrees of separation