Introduction
This is an old revision of the document!
Please note that all date fields from Cruise Factory are date only and do not contain the time.
<id> int </id> <ship_id> int </ship_id> <name> varchar (max 150) </name>
<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>
<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>
<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>
<id> int </id> <name> varchar (max 100) </name>
<id> int </id> <name> varchar (max 50) </name> <description> varchar (max 48) </description> <sign> varchar (max 11) </sign>
<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>
<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>
<id> int </id> <cruiseline_id> int </cruiseline_id> <name> varchar (max 100) </name> <introduction> text </introduction> <photo> varchar (max 50) </photo>
<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>
<id> int </id> <ship_id> int </ship_id> <name> varchar (max 150) </name>
<id> int </id> <factory_id> int </factory_id> <special_id> int </special_id> <sailingdate_id> int </sailingdate_id>
<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>
<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>
<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>
<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>
<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>
<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>
<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>
<id> int </id> <cruiseline_id> int </cruiseline_id> <name> varchar (max 100) </name> <description> text </description>
<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>
<id> int </id> <name> varchar (max 100) </name>
<id> int </id> <destination_id> int </destination_id> <name> varchar (max 100) </name> <description> text </description> <photo> varchar (max 100) </photo>
<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>
<id> int </id> <cruise_id> int </cruise_id> <sailingdate> date </sailingdate> <embarkport_id> int </embarkport_id>
<id> int </id> <destination_id> int </destination_id> <start_month> int </start_month> <end_month> int </end_month> <name> varchar (max 50) </name>
<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>
<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>
<id> int </id> <rating> varchar (max 25) </rating> <order> int </order>
<id> int </id> <cruiseline_id> int </cruiseline_id> <name> varchar (max 100) </name> <description> text </description>
<id> int </id> <cruiseline_id> int </cruiseline_id> <name> varchar (max 100) </name> <description> text </description>
test
test