User Tools

Site Tools


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