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. |