This shows you the differences between two versions of the page.
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: | ||
- | ====== | + | ====== |
- | 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# |
- | test | + | <code xml> |
+ | < | ||
+ | < | ||
+ | < | ||
+ | ... | ||
+ | </ | ||
+ | </ | ||
+ | < | ||
+ | < | ||
+ | ... | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | The above code is for the // | ||
+ | ===== Table Layouts | ||
+ | |||
+ | |||
+ | ==== amenities ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== cabins ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== cruiselines ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | <url> varchar (max 255) </ | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== cruises ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== cruisetypes ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== currencies ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== deckplans ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== destinations ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== dining ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== diningtimes ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== facilities ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== specialsailingdates ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== specials ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== companionpricing ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== latlong ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | <lat> float </ | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== leadpricing ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== specialsmultipricing ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== specialitineraries ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | <day> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== specialspricing ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== itineraries ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | <day> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== kidsschedules ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== kidsprograms ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== menus ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== months ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== ports ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== priceguide ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== sailingdates ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== seasons ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== shipphotos ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== ships ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== starratings ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== tipping ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== winelists ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | |||
+ | ==== amended_conditions ==== | ||
+ | <code xml> | ||
+ | <id> int </ | ||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ |