Cruise Factory XML

User Tools

Site Tools

Trace: • structure

Sidebar

Introduction


Technical

structure

This is an old revision of the document!

Table of Contents

Overview

test

Table listing

Please note that all date fields from Cruise Factory are date only and do not contain the time.

amenities

<id> int </id>
<ship_id> int </ship_id>
<name> varchar (max 150) </name>

cabins

<id> int </id>
<ship_id> int </ship_id>
<name> varchar (max 100) </name>
<description> text </description>
<image> varchar (max 150) </image>
<photo> varchar (max 150) </photo>
<cabin_order> int </cabin_order>

cruiselines

<id> int </id>
<name> varchar (max 200) </name>
<location> varchar (max 200) </location>
<booking_email> varchar (max 100) </booking_email>
<brief_desc> varchar (max 200) </brief_desc>
<company_bio> text </company_bio>
<logodata> base64 encoded binary </logodata>
<logosize> varchar (max 50) </logosize>
<logotype> varchar (max 50) </logotype>
<url> varchar (max 255) </url>
<video_url> varchar (max 255) </video_url>
<star_rating> int </star_rating>

cruises

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<destination_id> int </destination_id>
<ship_id> int </ship_id>
<cruisetype_id> int </cruisetype_id>
<length> int </length>
<name> varchar (max 80) </name>
<brief_description> varchar (max 250) </brief_description>
<description> text </description>
<photo> varchar (max 100) </photo>
<start_price> decimal </start_price>
<currency_id> int </currency_id>
<cruise_order> int </cruise_order>

cruisetypes

<id> int </id>
<name> varchar (max 100) </name>

currencies

<id> int </id>
<name> varchar (max 50) </name>
<description> varchar (max 48) </description>
<sign> varchar (max 11) </sign>

deckplans

<id> int </id>
<ship_id> int </ship_id>
<level> varchar (max 100) </level>
<name> varchar (max 100) </name>
<image> varchar (max 100) </image>
<colorcode> varchar (max 100) </colorcode>

destinations

<id> int </id>
<name> varchar (max 100) </name>
<description> text </description>
<image> varchar (max 100) </image>
<banner> varchar (max 100) </banner>
<map_thumb> varchar (max 100) </map_thumb>
<map_large> varchar (max 100) </map_large>
<featured> char </featured>
<featured_text> text </featured_text>

dining

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 100) </name>
<introduction> text </introduction>
<photo> varchar (max 50) </photo>

diningtimes

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<meal> varchar (max 50) </meal>
<normal_sitting> varchar (max 50) </normal_sitting>
<late_sitting> varchar (max 50) </late_sitting>

facilities

<id> int </id>
<ship_id> int </ship_id>
<name> varchar (max 150) </name>

specialsailingdates

<id> int </id>
<factory_id> int </factory_id>
<special_id> int </special_id>
<sailingdate_id> int </sailingdate_id>

specials

<id> int </id>
<cruise_id> int </cruise_id>
<factory_id> int </factory_id>
<priority_id> int </priority_id>
<special_header> varchar (max 100) </special_header>
<special_text> longtext </special_text>
<special_brief> longtext </special_brief>
<instructions> longtext </instructions>
<booking_email> varchar (max 100) </booking_email>
<start_price> decimal </start_price>
<currency_id> int </currency_id>
<cruise_order> int </cruise_order>
<main_special> char </main_special>
<dest_special> char </dest_special>
<special_order> int </special_order>
<validity_date_end> date </validity_date_end>
<validity_date_start> date </validity_date_start>
<checked> char </checked>
<internal_notes> text </internal_notes>
<advert_code> varchar (max 255) </advert_code>
<exchange_rate> double </exchange_rate>
<ex_rate_date> date </ex_rate_date>
<currency_id_ref> int </currency_id_ref>
<create_pdf> char </create_pdf>
<uploaded_pdf> varchar (max 255) </uploaded_pdf>
<withdrawn> char </withdrawn>
<quicksave> char </quicksave>
<status> tinyint </status>
<type> varchar (max 32) </type>
<escorted> char </escorted>
<wedding> char </wedding>
<agentonly> char </agentonly>
<special_conditions> text </special_conditions>
<specialpdf_filename> varchar (max 255) </specialpdf_filename>
<specialpdf_contents> text </specialpdf_contents>
<seniors> enum( 'Yes','No' ) </seniors>
<singles> enum( 'Yes','No' ) </singles>

companionpricing

<id> int </id>
<special_id> int </special_id>
<price_inside> double </price_inside>
<price_outside> double </price_outside>
<price_balcony> double </price_balcony>
<price_suites> double </price_suites>

leadpricing

<id> int </id>
<special_id> int </special_id>
<price_inside> double </price_inside>
<price_outside> double </price_outside>
<price_balcony> double </price_balcony>
<price_suites> double </price_suites>

specialsmultipricing

<id> int </id>
<special_id> int </special_id>
<sailingdate> date </sailingdate>
<inside> varchar (max 16) </inside>
<outside> varchar (max 16) </outside>
<balcony> varchar (max 16) </balcony>
<suite> varchar (max 16) </suite>

specialitineraries

<id> int </id>
<special_id> int </special_id>
<day> int </day>
<activity> varchar (max 60) </activity>
<starttime> varchar (max 20) </starttime>
<endtime> varchar (max 20) </endtime>
<type> enum('pre','post') </type>
<order> int </order>

specialspricing

<id> int </id>
<factory_id> int </factory_id>
<special_id> int </special_id>
<cruise_id> int </cruise_id>
<cabin_id> int </cabin_id>
<price> double </price>
<portcharges> char </portcharges>
<currency_id> int </currency_id>

itineraries

<id> int </id>
<cruise_id> int </cruise_id>
<day> int </day>
<port_id> int </port_id>
<arrive> varchar (max 50) </arrive>
<depart> varchar (max 50) </depart>
<portorder> int </portorder>

kidsschedules

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 100) </name>
<description> text </description>

kidsprograms

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 100) </name>
<description> text </description>
<photo> varchar (max 100) </photo>
<photo_order> int </photo_order>
<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 100) </name>
<description> text </description>

months

<id> int </id>
<name> varchar (max 100) </name>

ports

<id> int </id>
<destination_id> int </destination_id>
<name> varchar (max 100) </name>
<description> text </description>
<photo> varchar (max 100) </photo>

priceguide

<id> int </id>
<sailing_id> int </sailing_id>
<inside_cabin> float </inside_cabin>
<outside_cabin> float </outside_cabin>
<balcony> float </balcony>
<suite> float </suite>
<exchange_rate> float </exchange_rate>
<last_update> date </last_update>
<update_name> varchar (max 20) </update_name>
<currency> varchar (max 12) </currency>
<factory_id> int </factory_id>
<cruiseline_id> int </cruiseline_id>

sailingdates

<id> int </id>
<cruise_id> int </cruise_id>
<sailingdate> date </sailingdate>
<embarkport_id> int </embarkport_id>

seasons

<id> int </id>
<destination_id> int </destination_id>
<start_month> int </start_month>
<end_month> int </end_month>
<name> varchar (max 50) </name>

shipphotos

<id> int </id>
<ship_id> int </ship_id>
<name> varchar (max 100) </name>
<description> text </description>
<photo> varchar (max 100) </photo>
<photo_order> int </photo_order>

ships

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 250) </name>
<thumbnail> varchar (max 50) </thumbnail>
<mainimage> varchar (max 50) </mainimage>
<maidenvoyage> varchar (max 100) </maidenvoyage>
<refurbished> varchar (max 100) </refurbished>
<tonnage> varchar (max 50) </tonnage>
<length> varchar (max 50) </length>
<beam> varchar (max 50) </beam>
<draft> varchar (max 50) </draft>
<speed> varchar (max 50) </speed>
<ship_rego> varchar (max 150) </ship_rego>
<pass_capacity> varchar (max 50) </pass_capacity>
<pass_space> varchar (max 50) </pass_space>
<crew_size> varchar (max 50) </crew_size>
<nat_crew> varchar (max 100) </nat_crew>
<nat_officers> varchar (max 100) </nat_officers>
<nat_dining> varchar (max 100) </nat_dining>
<description> text </description>
<star_rating> int </star_rating>
<cruisetype_id> int </cruisetype_id>
<currency_id> int </currency_id>

starratings

<id> int </id>
<rating> varchar (max 25) </rating>
<order> int </order>

tipping

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 100) </name>
<description> text </description>

winelists

<id> int </id>
<cruiseline_id> int </cruiseline_id>
<name> varchar (max 100) </name>
<description> text </description>

Table relationships

test

Download example schema

test

structure.1356763875.txt.gz · Last modified: 2012/12/29 17:51 by cruisefactory

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
GNU Free Documentation License 1.3 Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki