Shopware 5.5.7 s_core_countries_states
States/provinces within countries (e.g. US states, German Bundesländer).
Columns
| Column | Type | Nullable | Additional |
|---|---|---|---|
| id | int(11) | NO | Primary Key, auto_increment |
| countryID | int(11) | YES | Index |
| name | varchar(255) | YES | |
| shortcode | varchar(255) | NO | |
| position | int(11) | YES | |
| active | int(11) | YES |
Indexes
| Index Name | Columns | Unique |
|---|---|---|
| countryID | countryID | No |
| PRIMARY | id | Yes |
Relations (to this table)
| Local Field | Foreign Table | Foreign Field |
|---|---|---|
| id | s_core_countries_states_attributes | stateID |
| id | s_user_addresses | state_id |