![]() |
![]() |
| Table: Resort | ||||
| ID | Resort | Code | City_Code | Airport_Code |
| 1 | Playa De Las Americas | 001 | TFS | |
| 2 | Los Cristianos | 002 | TFS | |
| 3 | Alburfeira | 003 | FAO | |
| 4 | Figueretas | 004 | IBZ | |
| 5 | Costa Adeje | 005 | TFS | |
| 6 | Disney World | 006 | ORL | |
| Notes |
Resort Codes will be unique. There is no ISO coding system for Resorts. The system should auto generate a code if the user does not define one. If the code is changed at a later stage, the system should automatically reflect the change as everything should be tied to the ID. So if the system generated a code 123 and this was later changed to NEG then everything that was 123 would change to NEG automatically. Resorts can fall within city limits or outside a specific city so users need the ability to associate a Resort with a City Code or an Airport Code Using a Resort Code at accommodation level will enable results to be displayed in resort order or for searches on a specific resort. |