Cruise Factory XML

User Tools

Site Tools

Trace:
structure

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
structure [2012/12/29 17:39]
cruisefactory [What it is not] 		structure [2018/05/24 09:51] (current)
cruisefactory
Line 1: Line 1:
-====== Overview ====== +====== XML Structure ====== 
-test +//Please note that all date fields from Cruise Factory are date only and do not contain the time.// 
-===== Table listing ===== + 
-test +===== XML Layout ===== 
-===== Table relationships ===== +The XML is layed out exactly as below, although this example is missing the table column elements (rows) which are [[structure#table_layouts|listed below]] for each table. 
-test+<code xml> 
 +<database> 
 +<table> 
 + <row> 
 + ... 
 + </row> 
 +</table> 
 +<delete> 
 + <ids> 
 + ... 
 + </ids> 
 +</delete> 
 +</database> 
 +</code> 
 +The above code is for the //increment// data service, although everything apart from the extra //**delete**// element is the same as the regular //full// service. Read up on the differences between the regular and incremental services [[importing#types_of_data_services|here]]. 
 +===== Table Layouts ===== 
 + 
 + 
 +==== amenities ==== 
 +<code xml> 
 +<id> int </id> 
 +<ship_id> int </ship_id> 
 +<name> varchar (max 150) </name> 
 +</code> 
 + 
 +==== cabins ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== cruiselines ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== cruises ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== cruisetypes ==== 
 +<code xml> 
 +<id> int </id> 
 +<name> varchar (max 100) </name> 
 +</code> 
 + 
 +==== currencies ==== 
 +<code xml> 
 +<id> int </id> 
 +<name> varchar (max 50) </name> 
 +<description> varchar (max 48) </description> 
 +<sign> varchar (max 11) </sign> 
 +</code> 
 + 
 +==== deckplans ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== destinations ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== dining ==== 
 +<code xml> 
 +<id> int </id> 
 +<cruiseline_id> int </cruiseline_id> 
 +<name> varchar (max 100) </name> 
 +<introduction> text </introduction> 
 +<photo> varchar (max 50) </photo> 
 +</code> 
 + 
 +==== diningtimes ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== facilities ==== 
 +<code xml> 
 +<id> int </id> 
 +<ship_id> int </ship_id> 
 +<name> varchar (max 150) </name> 
 +</code> 
 + 
 +==== specialsailingdates ==== 
 +<code xml> 
 +<id> int </id> 
 +<factory_id> int </factory_id> 
 +<special_id> int </special_id> 
 +<sailingdate_id> int </sailingdate_id> 
 +</code> 
 + 
 +==== specials ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== companionpricing ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== latlong ==== 
 +<code xml> 
 +<id> int </id> 
 +<port_id> int </port_id> 
 +<lat> float </lat> 
 +<long> float </long> 
 +</code> 
 + 
 +==== leadpricing ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== specialsmultipricing ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== specialitineraries ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== specialspricing ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== itineraries ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== kidsschedules ==== 
 +<code xml> 
 +<id> int </id> 
 +<cruiseline_id> int </cruiseline_id> 
 +<name> varchar (max 100) </name> 
 +<description> text </description> 
 +</code> 
 + 
 +==== kidsprograms ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== menus ==== 
 +<code xml> 
 +<id> int </id> 
 +<cruiseline_id> int </cruiseline_id> 
 +<name> varchar (max 100) </name> 
 +<description> text </description> 
 +</code> 
 + 
 +==== months ==== 
 +<code xml> 
 +<id> int </id> 
 +<name> varchar (max 100) </name> 
 +</code> 
 + 
 +==== ports ==== 
 +<code xml> 
 +<id> int </id> 
 +<destination_id> int </destination_id> 
 +<name> varchar (max 100) </name> 
 +<description> text </description> 
 +<photo> varchar (max 100) </photo> 
 +</code> 
 + 
 +==== priceguide ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== sailingdates ==== 
 +<code xml> 
 +<id> int </id> 
 +<cruise_id> int </cruise_id> 
 +<sailingdate> date </sailingdate> 
 +<embarkport_id> int </embarkport_id> 
 +</code> 
 + 
 +==== seasons ==== 
 +<code xml> 
 +<id> int </id> 
 +<destination_id> int </destination_id> 
 +<start_month> int </start_month> 
 +<end_month> int </end_month> 
 +<name> varchar (max 50) </name> 
 +</code> 
 + 
 +==== shipphotos ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== ships ==== 
 +<code xml> 
 +<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> 
 +</code> 
 + 
 +==== starratings ==== 
 +<code xml> 
 +<id> int </id> 
 +<rating> varchar (max 25) </rating> 
 +<order> int </order> 
 +</code> 
 + 
 +==== tipping ==== 
 +<code xml> 
 +<id> int </id> 
 +<cruiseline_id> int </cruiseline_id> 
 +<name> varchar (max 100) </name> 
 +<description> text </description> 
 +</code> 
 + 
 +==== winelists ==== 
 +<code xml> 
 +<id> int </id> 
 +<cruiseline_id> int </cruiseline_id> 
 +<name> varchar (max 100) </name> 
 +<description> text </description> 
 +</code> 
 + 
 +==== amended_conditions ==== 
 +<code xml> 
 +<id> int </id> 
 +<sailingdate_id> int </sailingdate_id> 
 +<disclaimer> varchar (max 255) </disclaimer> 
 +<conditions> text </conditions> 
 +</code>
structure.1356763180.txt.gz · Last modified: 2012/12/29 17:39 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