Introduction
This is an old revision of the document!
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-* | ||
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-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 | tipping.cruiseline_id = cruiselines.id |