countryconst


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
address.countryId FKs3f5hqoh7xwfocskewrm3o24k R
ship.shipToCountryId FKcountry R
stateconst.countryConstID FKqpre3xjcwq9ccrfhef5h4c2jq R
stateconst_aud.countryConstID Implied Constraint R
abbreviation VARCHAR 10 √ null
name VARCHAR 64 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
UK1jnos9l2sr9xp2sullh2qyby3 Must be unique Asc name
UKbht1sdld5wevqpr2ogptyca6v Must be unique Asc abbreviation

Relationships