User Tools

Site Tools


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:49]
cruisefactory [Table listing]
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.// 
 + 
 +===== XML Layout ===== 
 +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. 
 +<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 =====
  
-===== Table listing ===== 
-Please note that all date fields from Cruise Factory are date only and do not contain the time. 
  
 ==== amenities ==== ==== amenities ====
Line 175: Line 192:
 <price_balcony> double </price_balcony> <price_balcony> double </price_balcony>
 <price_suites> double </price_suites> <price_suites> double </price_suites>
 +</code>
 +
 +==== latlong ====
 +<code xml>
 +<id> int </id>
 +<port_id> int </port_id>
 +<lat> float </lat>
 +<long> float </long>
 </code> </code>
  
Line 367: Line 392:
 </code> </code>
  
-===== Table relationships ===== +==== amended_conditions ==== 
-test +<code xml> 
- +<id> int </id> 
-===== Download example schema ===== +<sailingdate_id> int </sailingdate_id> 
-test+<disclaimer> varchar (max 255) </disclaimer> 
 +<conditions> text </conditions> 
 +</code>
structure.1356763759.txt.gz · Last modified: 2012/12/29 17:49 by cruisefactory