Table: Country | |||
ID | Country | Code | Continent_Code |
1 | Antigua | AN | 2 |
2 | Barbados | BB | 2 |
3 | Grenada | VC | 2 |
4 | USA | US | 4 |
5 | Canada | CA | 4 |
6 | Tobago | TT | 2 |
7 | Trinidad | TT | 2 |
8 | St Vincent | VC | 2 |
9 | St Thomas | VI | 2 |
10 | Dominican Republic | DO | 2 |
11 | Mexico | MX | 1 |
12 | Jamaica | JM | 2 |
13 | Spain | ES | 3 |
14 | United Kingdom | UK | 3 |
Notes |
Country names will be unique. |
Country Codes may not be unique. An example is Trinidad & Tobago which has the code TT. When going on holiday, users select Tobago opposed to Trinidad and Tobago so Trinidad will be listed in the Country Table as will Tobago and both will have the Code TT. |