Introduction
Sidebar
relationships
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-* | ||
| 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 |
relationships.txt · Last modified: 2018/05/24 09:54 by cruisefactory
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
