====== Relationships ======
Below is a listing of all available tables, their related tables and their matching columns.

^ Table ^ Related table(s) ^ Relationship ^ Linking ^
| amenities | ships |  *-1  | amenities.ship_id = ships.id |
^ ^ ^ ^ ^
| cabins | ships |  *-1  | cabins.ship_id = ships.id |
| | specialspricing |  1-*  | cabins.id = specialspricing.cabin_id |
^ ^ ^ ^ ^
| cruiselines | dining |  1-1  | cruiselines.id = dining.cruiseline_id |
| | cruises |  1-*  | cruiselines.id = cruises.cruiseline_id |
| | menus |  1-*  | cruiselines.id = menus.cruiseline_id |
| | kidsschedules |  1-*  | cruiselines.id = kidsschedules.cruiseline_id |
| | kidsprograms |  1-*  | cruiselines.id = kidsprograms.cruiseline_id |
| | priceguide |  1-*  | cruiselines.id = priceguide.cruiseline_id |
| | winelists |  1-*  | cruiselines.id = winelists.cruiseline_id |
| | diningtimes |  1-*  | cruiselines.id = diningtimes.cruiseline_id |
| | ships |  1-*  | cruiselines.id = ships.cruiseline_id |
| | starratings |  1-1  | cruiselines.star_rating = starratings.id |
^ ^ ^ ^ ^
| cruises | itineraries |  1-*  | cruises.id = itineraries.cruise_id |
| | sailingdates |  1-*  | cruises.id = sailingdates.cruise_id |
| | specials |  1-*  | cruises.id = specials.cruise_id |
| | ships |  *-1  | cruises.ship_id = ships.id |
| | destinations |  1-1  | cruises.destination_id = destinations.id |
| | currencies |  1-1  | cruises.currency_id = currencies.id |
| | cruisetypes |  1-1  | cruises.cruisetype_id = cruisetype.id |
| | cruiselines |  1-1  | cruises.cruiseline_id = cruiseline.id |
^ ^ ^ ^ ^
| cruisetypes | cruises |  1-*  | cruisetypes.id = cruises.cruisetype_id |
| | ships |  1-*  | cruisetypes.id = ships.cruisetype_id |
^ ^ ^ ^ ^
| currencies | cruises |  1-*  | currencies.id = cruises.cruisetype_id |
| | ships |  1-*  | currencies.id = ships.currency_id |
| | specialspricing |  1-*  | currencies.id = specialspricing.currency_id |
^ ^ ^ ^ ^
| deckplans | ships |  *-1  | deckplans.ship_id = ship.id |
^ ^ ^ ^ ^
| destinations | seasons |  *-1  | destinations.id = seasons.destination_id |
| | ports |  1-*  | destinations.id = ports.destination_id |
^ ^ ^ ^ ^
| dining | cruiselines |  1-1  | dining.cruiseline_id = cruiselines.id |
^ ^ ^ ^ ^
| diningtimes | cruiselines |  *-1  | diningtimes.cruiseline_id = cruiselines.id |
^ ^ ^ ^ ^
| facilities | ships |  *-1  | facilities.ship_id = ships.id |
^ ^ ^ ^ ^
| specialsailingdates | specials |  *-1  | specialsailingdates.special_id = special.id |
| | sailingdates|  1-1  | specialsailingdates.sailingdate_id = sailingdate.id |
^ ^ ^ ^ ^
| specials | leadpricing |  1-*  | specials.id = leadpricing.special_id |
| | companionpricing |  1-*  | specials.id = companionpricing.special_id |
| | specialspricing |  1-*  | specials.id = specialspricing.special_id |
| | specialsmultipricing |  1-*  | specials.id = specialsmultipricing.special_id 
| | specialitineraries |  1-*  | specials.id = specialitineraries.special_id |
| | currencies |  1-*  | specials.currency_id = currencies.id |
| | cruises |  1-*  | specials.cruise_id = cruises.id |
^ ^ ^ ^ ^
| companionpricing | specials |  *-1  | companionpricing.special_id = special.id |
^ ^ ^ ^ ^
| leadpricing | specials |  *-1  | leadpricing.special_id = special.id |
^ ^ ^ ^ ^
| specialsmultipricing | specials |  *-1  | specialsmultipricing.special_id = special.id |
^ ^ ^ ^ ^
| specialitineraries | specials |  *-1  | specialsitineraries.special_id = special.id |
^ ^ ^ ^ ^
| specialspricing | cabins |  *-1  | specialspricing.cabin_id = cabins.id |
| | currencies |  *-1  | specialspricing.currency_id = currencies.id |
| | specials |  *-1  | specialspricing.special_id = specials.id |
^ ^ ^ ^ ^
| itineraries | cruises |  *-1  | itineraries.cruise_id = cruises.id |
| | ports |  *-1  | itineraries.port_id = ports.id |
^ ^ ^ ^ ^
| kidsschedules | cruiselines |  *-1  | kidsschedules.cruiseline_id = cruiselines.id |
^ ^ ^ ^ ^
| kidsprograms | cruiselines |  *-1  | kidsprograms.cruiseline_id = cruiselines.id |
^ ^ ^ ^ ^
| menus | cruiselines |  *-1  | menus.cruiseline_id = cruiselines.id |
^ ^ ^ ^ ^
| months | seasons |  *-1  | months.id = seasons.start_month |
| | seasons |  *-1  | months.id = seasons.end_month |
^ ^ ^ ^ ^
| ports | destinations |  *-1  | ports.destination_id = ports.id |
| | sailingdates |  *-1  | ports.id = sailingdates.embarkport_id |
| | itineraries |  1-*  | ports.id = itineraries.port_id |
^ ^ ^ ^ ^
| priceguide | cruiselines |  *-1  | priceguide.cruiseline_id = cruiselines.id |
| | sailingdates |  1-*  | priceguide.id = sailingdates.id |
^ ^ ^ ^ ^
| sailingdates | cruises |  *-1  | sailingdates.cruise_id = cruises.id |
| | ports |  1-1  | sailingdates.embarkport_id = ports.id |
| | priceguide |  1-*  | sailingdates.id = priceguide.sailing_id |
^ ^ ^ ^ ^
| seasons | destinations |  1-*  | seasons.destination_id = destinations.id |
| | months |  1-1  | seasons.start_month = months.id |
| | months|  1-1  | seasons.end_month = months.id |
^ ^ ^ ^ ^
| shipphotos | ships |  *-1  | shipphotos.ship_id = ships.id |
^ ^ ^ ^ ^
| ships | cruiseline |  1-*  | ships.cruiseline_id = cruiselines.id |
| | cruisetypes |  1-1  | ships.cruisetype_id = cruisetype.id |
| | facilities |  1-*  | ships.id = facilities.ship_id |
| | amenities |  1-*  | ships.ship_id = amenities.id |
| | shipphotos |  1-*  | ships.id = shipphotos.ship_id |
| | deckplans |  1-*  | ships.id = deckplans.ship_id |
| | starratings |  1-1  | ships.star_rating = starratings.id |
^ ^ ^ ^ ^
| starratings | cruiselines |  1-*  | starrating.id = cruiselines.star_rating |
| | ships |  1-*  | starrating.id = cruiselines.star_rating |
^ ^ ^ ^ ^
| tipping | cruiselines |  1-1  | tipping.cruiseline_id = cruiselines.id |
^ ^ ^ ^ ^
| winelists | cruiselines |  1-1  | winelists.cruiseline_id = cruiselines.id |
^ ^ ^ ^ ^
| amended_conditions | sailingdates |  *-1  | amended_conditions.sailingdate_id = sailingdates.id |
^ ^ ^ ^ ^