Hackolade

Cosmos DB Physical Model

Schema for:

Model name: travel-sample

Author: pascal

Version: v1.0

File name: travel-sample.json

File path: C:\Users\Pascal\Bitbucket\hackolade\schemas\CosmosDB\travel-sample.json

Printed On: Sat May 19 2018 10:55:40 GMT+0200 (Romance Summer Time)

Created with: Hackolade - Visual data modeling for NoSQL and multimodel databases

1. Model

2. Collection

2.1 travel-sample
2.1.1 airline
2.1.2 airport
2.1.3 hotel
2.1.4 landmark
2.1.5 route

3. Relationships

1. Model

1.1 Model travel-sample

1.1.1 travel-sample Entity Relationship Diagram

Show all

travel-sample

1.1.2 travel-sample Properties

Property	Value
Model name	travel-sample
Description	Demo Cosmos DB
Author	pascal
Version	v1.0
DB vendor	CosmosDB
Tenant	****
Account ID	*****
Resource group	ResGrp
Subscription	****
Database ID	sample
Preferred location	North Europe
API Experience	DocumentDB SQL
Default consistency policy	Session
Comments	Thu Oct 05 2017 08:55:21 GMT+0200 (Romance Summer Time):

1.1.3 travel-sample DB Definitions

2. Collection

2.1 Collection travel-sample

2.1.1 travel-sample Properties

Property	Value
Collection name	travel-sample
Document key
Document key	id
Data type	string
Document type
Doc type field name	type
Data type	string
Description
Storage Capacity
Throughput (RU/s)	400
RU per minute	On
Time to live
TTL default seconds
Partition key
Comments

2.1.2 travel-sample Document types

2.1.2.1 Document type airline

2.1.2.1.1 airline Tree Diagram

{...}

airline

type

{ABC}

type

{ABC}

type

{ABC}

callsign

type

{ABC}

country

type

{ABC}

iata

type

{ABC}

icao

type

{ABC}

name

type

2.1.2.1.2 airline Properties

Property	Value
Document type	airline
Id
Description
Collection	travel-sample
Additional properties
Comments

2.1.2.1.3 airline Fields

Field	Type	Req	Key	Description	Comments
id	string	true
type	string	true
callsign	string	true
country	string	true
iata	string	true
icao	string	true
name	string	true

2.1.2.1.3.1 Field id

id properties

Property	Value
Name	id
Type	string
Required	true
Primary key	true
Sample	1eb93081-62b7-4574-a8b4-90764e3b0501

2.1.2.1.3.2 Field type

type properties

Property	Value
Name	type
Type	string
Required	true
Primary key	true
Sample	airline

2.1.2.1.3.3 Field callsign

callsign properties

Property	Value
Name	callsign
Type	string
Required	true
Primary key	false
Sample	Epic

2.1.2.1.3.4 Field country

country properties

Property	Value
Name	country
Type	string
Required	true
Primary key	false
Sample	United States

2.1.2.1.3.5 Field iata

iata properties

Property	Value
Name	iata
Type	string
Required	true
Primary key	false
Sample	FA

2.1.2.1.3.6 Field icao

icao properties

Property	Value
Name	icao
Type	string
Required	true
Primary key	false
Sample	4AA

2.1.2.1.3.7 Field name

name properties

Property	Value
Name	name
Type	string
Required	true
Primary key	false
Sample	Epic Holiday

2.1.2.1.4 airline Definitions

2.1.2.2 Document type airport

2.1.2.2.1 airport Tree Diagram

{...}

airport

type

{ABC}

type

{ABC}

type

{ABC}

airportname

type

{ABC}

city

type

{ABC}

country

type

{ABC}

faa

type

{...}

geo

type

{ABC}

icao

type

{ABC}

type

{ABC}

accuracy

type

{123}

alt

type

{123}

lat

type

{123}

lon

type

2.1.2.2.2 airport Properties

Property	Value
Document type	airport
Id
Description
Collection	travel-sample
Additional properties
Comments

2.1.2.2.3 airport Fields

Field	Type	Req	Key	Description	Comments
id	string	true
type	string	true
airportname	string	true
city	string	true
country	string	true
faa	string	true
geo	object	true
accuracy	string	true
alt	number	true
lat	number	true
lon	number	true
icao	string	true
tz	string	true

2.1.2.2.3.1 Field id

id properties

Property	Value
Name	id
Type	string
Required	true
Primary key	true
Sample	408cf88c-9543-4eba-9cdf-3d87a9b7b2ef

2.1.2.2.3.2 Field type

type properties

Property	Value
Name	type
Type	string
Required	true
Primary key	true
Sample	airport

2.1.2.2.3.3 Field airportname

airportname properties

Property	Value
Name	airportname
Type	string
Required	true
Primary key	false
Sample	La M√¥le Airport

2.1.2.2.3.4 Field city

city properties

Property	Value
Name	city
Type	string
Required	true
Primary key	false
Sample	La M√¥le

2.1.2.2.3.5 Field country

country properties

Property	Value
Name	country
Type	string
Required	true
Primary key	false
Sample	France

2.1.2.2.3.6 Field faa

faa properties

Property	Value
Name	faa
Type	string
Required	true
Primary key	false
Sample	LTT

2.1.2.2.3.7 Field geo

2.1.2.2.3.7.1 geo Tree Diagram

{...}

geo

type

{ABC}

accuracy

type

{123}

alt

type

{123}

lat

type

{123}

lon

type

2.1.2.2.3.7.2 geo Hierarchy

Parent field: airport

Child field(s):

Field	Type	Req	Key	Description	Comments
accuracy	string	true
alt	number	true
lat	number	true
lon	number	true

geo properties

Property	Value
Name	geo
Type	object
Required	true
Primary key	false

2.1.2.2.3.8 Field accuracy

accuracy properties

Property	Value
Name	accuracy
Type	string
Required	true
Primary key	false
Sample	ROOFTOP

2.1.2.2.3.9 Field alt

alt properties

Property	Value
Name	alt
Type	number
Required	true
Primary key	false
Sample	59

2.1.2.2.3.10 Field lat

lat properties

Property	Value
Name	lat
Type	number
Required	true
Primary key	false
Sample	43.2054

2.1.2.2.3.11 Field lon

lon properties

Property	Value
Name	lon
Type	number
Required	true
Primary key	false
Sample	6.482

2.1.2.2.3.12 Field icao

icao properties

Property	Value
Name	icao
Type	string
Required	true
Primary key	false
Sample	LFTZ

2.1.2.2.3.13 Field tz

tz properties

Property	Value
Name	tz
Type	string
Required	true
Primary key	false
Sample	Europe/Paris

2.1.2.2.4 airport Definitions

2.1.2.3 Document type hotel

2.1.2.3.1 hotel Tree Diagram

{...}

hotel

type

{ABC}

type

{ABC}

type

{ABC}

address

type

{ABC}

alias

type

{ABC}

checkin

type

{ABC}

checkout

type

{ABC}

city

type

{ABC}

country

type

{ABC}

description

type

{ABC}

directions

type

{ABC}

type

{ABC}

fax

type

{0/1}

free_breakfast

type

{0/1}

free_internet

type

{0/1}

free_parking

type

{...}

geo

type

{ABC}

name

type

{0/1}

pets_ok

type

{ABC}

phone

type

{ABC}

price

type

[...]

public_likes

type

[...]

reviews

type

{ABC}

state

type

{ABC}

title

type

{ABC}

tollfree

type

{ABC}

url

type

{0/1}

vacancy

type

{ABC}

accuracy

type

{123}

alt

type

{123}

lat

type

{123}

lon

type

{ABC}

[0]*

type

{...}

[0]*

type

{ABC}

author

type

{ABC}

content

type

{ABC}

date

type

{...}

ratings

type

{123}

, internet access)

type

{123}

Business service

type

{123}

Check in / front desk

type

{123}

Cleanliness

type

{123}

Location

type

{123}

Overall

type

{123}

Rooms

type

{123}

Service

type

{123}

Sleep Quality

type

{123}

Value

type

2.1.2.3.2 hotel Properties

Property	Value
Document type	hotel
Id
Description
Collection	travel-sample
Additional properties
Comments

2.1.2.3.3 hotel Fields

Field	Type	Req	Key	Description	Comments
id	string	true
type	string	true
address	string	true
alias	string	true
checkin	string	true
checkout	string	true
city	string	true
country	string	true
description	string	true
directions	string	true
email	string	true
fax	string	true
free_breakfast	boolean	true
free_internet	boolean	true
free_parking	boolean	true
geo	object	true
accuracy	string	true
alt	number	true
lat	number	true
lon	number	true
name	string	true
pets_ok	boolean	true
phone	string	true
price	string	true
public_likes	array	true
[0]	string	false
reviews	array	true
[0]	object	false
author	string	true
content	string	true
date	string	true
ratings	object	true
, internet access)	number	true
Business service	number	true
Check in / front desk	number	true
Cleanliness	number	true
Location	number	true
Overall	number	true
Rooms	number	true
Service	number	true
Sleep Quality	number	true
Value	number	true
state	string	true
title	string	true
tollfree	string	true
url	string	true
vacancy	boolean	true

2.1.2.3.3.1 Field id

id properties

Property	Value
Name	id
Type	string
Required	true
Primary key	true
Sample	e0ac0119-6cf7-4f56-9158-690aa34bc875

2.1.2.3.3.2 Field type

type properties

Property	Value
Name	type
Type	string
Required	true
Primary key	true
Sample	hotel

2.1.2.3.3.3 Field address

address properties

Property	Value
Name	address
Type	string
Required	true
Primary key	false
Sample	Route de Meyrin, 01210 Ferney Voltaire, France

2.1.2.3.3.4 Field alias

alias properties

Property	Value
Name	alias
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.3.3.5 Field checkin

checkin properties

Property	Value
Name	checkin
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.3.3.6 Field checkout

checkout properties

Property	Value
Name	checkout
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.3.3.7 Field city

city properties

Property	Value
Name	city
Type	string
Required	true
Primary key	false
Sample	Ferney-Voltaire

2.1.2.3.3.8 Field country

country properties

Property	Value
Name	country
Type	string
Required	true
Primary key	false
Sample	France

2.1.2.3.3.9 Field description

description properties

Property	Value
Name	description
Type	string
Required	true
Primary key	false
Sample	Right behind the airport on the French side. Inexpensive but still a good standard since it belongs to the Accor hotel chain.

2.1.2.3.3.10 Field directions

directions properties

Property	Value
Name	directions
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.3.3.11 Field email

email properties

Property	Value
Name	email
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.3.3.12 Field fax

fax properties

Property	Value
Name	fax
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.3.3.13 Field free_breakfast

free_breakfast properties

Property	Value
Name	free_breakfast
Type	boolean
Required	true
Primary key	false
Sample	false

2.1.2.3.3.14 Field free_internet

free_internet properties

Property	Value
Name	free_internet
Type	boolean
Required	true
Primary key	false
Sample	true

2.1.2.3.3.15 Field free_parking

free_parking properties

Property	Value
Name	free_parking
Type	boolean
Required	true
Primary key	false
Sample	false

2.1.2.3.3.16 Field geo

2.1.2.3.3.16.1 geo Tree Diagram

{...}

geo

type

{ABC}

accuracy

type

{123}

alt

type

{123}

lat

type

{123}

lon

type

2.1.2.3.3.16.2 geo Hierarchy

Parent field: hotel

Child field(s):

Field	Type	Req	Key	Description	Comments
accuracy	string	true
alt	number	true
lat	number	true
lon	number	true

geo properties

Property	Value
Name	geo
Type	object
Required	true
Primary key	false

2.1.2.3.3.17 Field accuracy

accuracy properties

Property	Value
Name	accuracy
Type	string
Required	true
Primary key	false
Sample	ROOFTOP

2.1.2.3.3.18 Field alt

alt properties

Property	Value
Name	alt
Type	number
Required	true
Primary key	false
Sample	59

2.1.2.3.3.19 Field lat

lat properties

Property	Value
Name	lat
Type	number
Required	true
Primary key	false
Sample	43.2054

2.1.2.3.3.20 Field lon

lon properties

Property	Value
Name	lon
Type	number
Required	true
Primary key	false
Sample	6.482

2.1.2.3.3.21 Field name

name properties

Property	Value
Name	name
Type	string
Required	true
Primary key	false
Sample	Hotel Formule 1

2.1.2.3.3.22 Field pets_ok

pets_ok properties

Property	Value
Name	pets_ok
Type	boolean
Required	true
Primary key	false
Sample	false

2.1.2.3.3.23 Field phone

phone properties

Property	Value
Name	phone
Type	string
Required	true
Primary key	false
Sample	+33 891 705 254

2.1.2.3.3.24 Field price

price properties

Property	Value
Name	price
Type	string
Required	true
Primary key	false
Sample	31€

2.1.2.3.3.25 Field public_likes

2.1.2.3.3.25.1 public_likes Tree Diagram

[...]

public_likes

type

{ABC}

[0]*

type

2.1.2.3.3.25.2 public_likes Hierarchy

Parent field: hotel

Child field(s):

Field	Type	Req	Key	Description	Comments
[0]	string	false

public_likes properties

Property	Value
Name	public_likes
Type	array
Required	true
Primary key	false
Additional items	true

2.1.2.3.3.26 Field [0]

[0] properties

Property	Value
Type	string
Primary key	false
Sample	Lorena Hansen

2.1.2.3.3.27 Field reviews

2.1.2.3.3.27.1 reviews Tree Diagram

[...]

reviews

type

{...}

[0]*

type

2.1.2.3.3.27.2 reviews Hierarchy

Parent field: hotel

Child field(s):

Field	Type	Req	Key	Description	Comments
[0]	object	false

reviews properties

Property	Value
Name	reviews
Type	array
Required	true
Primary key	false
Additional items	true

2.1.2.3.3.28 Field [0]

2.1.2.3.3.28.1 [0] Tree Diagram

{...}

[0]

type

{ABC}

author

type

{ABC}

content

type

{ABC}

date

type

{...}

ratings

type

2.1.2.3.3.28.2 [0] Hierarchy

Parent field: reviews

Child field(s):

Field	Type	Req	Key	Description	Comments
author	string	true
content	string	true
date	string	true
ratings	object	true

[0] properties

Property	Value
Type	object
Primary key	false

2.1.2.3.3.29 Field author

author properties

Property	Value
Name	author
Type	string
Required	true
Primary key	false
Sample	Aaron Schmidt II

2.1.2.3.3.30 Field content

content properties

Property	Value
Name	content
Type	string
Required	true
Primary key	false
Sample	As a newer hotel that's close to the corporate offices of a business I visit regularly, I was excited to stay here for the first time last month. The hotel gets very high marks for staff enthusiasm, courtesy, friendlieness, and helpfulness. Being a newer hotel, it was spotlessly clean. I liked the breakfast area, although it did get a bit noisy when the 'rush' hit about 8:00 a.m. on a Saturday morning. The room was similarly clean and comfortable. The wireless internet connection (free) was useful. I also liked their simply-put, straight-forward internet privacy policy ('You have no expectation of privacy...). No beating around the bush there--wish others would spare us the jibberish and just come out and say what is obvious: on an unsecured, free wireless internet network connection, you don't have any privacy! There was just one problem, and I discovered later that a colleague who has stayed here twice experienced both times on this visit. I did not get my wake-up call, which made me late for a meeting. That is unaccetable, especially when I asked the front desk about the reliability of their wake-up calls. My back-up system for awakening (the hotel's very cheap alarm clocks) proved equally inadequate. The alarm did go off, but was so quiet that it couldn't be heard and didn't do the job. I'm not that heavy of a sleeper, either! It may be a little problem to some, but it's enough to put them on my 'one more chance' list. I'd like to stay here again.

2.1.2.3.3.31 Field date

date properties

Property	Value
Name	date
Type	string
Required	true
Primary key	false
Sample	2015-03-19 03:17:18 +0300

2.1.2.3.3.32 Field ratings

2.1.2.3.3.32.1 ratings Tree Diagram

{...}

ratings

type

{123}

, internet access)

type

{123}

Business service

type

{123}

Check in / front desk

type

{123}

Cleanliness

type

{123}

Location

type

{123}

Overall

type

{123}

Rooms

type

{123}

Service

type

{123}

Sleep Quality

type

{123}

Value

type

2.1.2.3.3.32.2 ratings Hierarchy

Parent field:

Child field(s):

Field	Type	Req	Key	Description	Comments
, internet access)	number	true
Business service	number	true
Check in / front desk	number	true
Cleanliness	number	true
Location	number	true
Overall	number	true
Rooms	number	true
Service	number	true
Sleep Quality	number	true
Value	number	true

ratings properties

Property	Value
Name	ratings
Type	object
Required	true
Primary key	false

2.1.2.3.3.33 Field , internet access)

, internet access) properties

Property	Value
Name	, internet access)
Type	number
Required	true
Primary key	false
Sample	12

2.1.2.3.3.34 Field Business service

Business service properties

Property	Value
Name	Business service
Type	number
Required	true
Primary key	false
Sample	-26

2.1.2.3.3.35 Field Check in / front desk

Check in / front desk properties

Property	Value
Name	Check in / front desk
Type	number
Required	true
Primary key	false
Sample	-56

2.1.2.3.3.36 Field Cleanliness

Cleanliness properties

Property	Value
Name	Cleanliness
Type	number
Required	true
Primary key	false
Sample	5

2.1.2.3.3.37 Field Location

Location properties

Property	Value
Name	Location
Type	number
Required	true
Primary key	false
Sample	5

2.1.2.3.3.38 Field Overall

Overall properties

Property	Value
Name	Overall
Type	number
Required	true
Primary key	false
Sample	4

2.1.2.3.3.39 Field Rooms

Rooms properties

Property	Value
Name	Rooms
Type	number
Required	true
Primary key	false
Sample	5

2.1.2.3.3.40 Field Service

Service properties

Property	Value
Name	Service
Type	number
Required	true
Primary key	false
Sample	4

2.1.2.3.3.41 Field Sleep Quality

Sleep Quality properties

Property	Value
Name	Sleep Quality
Type	number
Required	true
Primary key	false
Sample	-28

2.1.2.3.3.42 Field Value

Value properties

Property	Value
Name	Value
Type	number
Required	true
Primary key	false
Sample	5

2.1.2.3.3.43 Field state

state properties

Property	Value
Name	state
Type	string
Required	true
Primary key	false
Sample	Rhône-Alpes

2.1.2.3.3.44 Field title

title properties

Property	Value
Name	title
Type	string
Required	true
Primary key	false
Sample	Geneva

2.1.2.3.3.45 Field tollfree

tollfree properties

Property	Value
Name	tollfree
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.3.3.46 Field url

url properties

Property	Value
Name	url
Type	string
Required	true
Primary key	false
Sample	http://www.accorhotels.com/gb/hotel-2257-formule-1-hotelf1-geneve-aeroport-ferney-voltaire/index.shtml

2.1.2.3.3.47 Field vacancy

vacancy properties

Property	Value
Name	vacancy
Type	boolean
Required	true
Primary key	false
Sample	false

2.1.2.3.4 hotel Definitions

2.1.2.4 Document type landmark

2.1.2.4.1 landmark Tree Diagram

{...}

landmark

type

{ABC}

type

{ABC}

type

{ABC}

activity

type

{ABC}

address

type

{ABC}

alt

type

{ABC}

city

type

{ABC}

content

type

{ABC}

country

type

{ABC}

directions

type

{ABC}

type

{...}

geo

type

{ABC}

hours

type

{ABC}

image

type

{ABC}

image_direct_url

type

{ABC}

name

type

{ABC}

phone

type

{ABC}

price

type

{ABC}

state

type

{ABC}

title

type

{ABC}

tollfree

type

{ABC}

url

type

{ABC}

accuracy

type

{123}

lat

type

{123}

lon

type

2.1.2.4.2 landmark Properties

Property	Value
Document type	landmark
Id
Description
Collection	travel-sample
Additional properties
Comments

2.1.2.4.3 landmark Fields

Field	Type	Req	Key	Description	Comments
id	string	true
type	string	true
activity	string	true
address	string	true
alt	string	true
city	string	true
content	string	true
country	string	true
directions	string	true
email	string	true
geo	object	true
accuracy	string	true
lat	number	true
lon	number	true
hours	string	true
image	string	true
image_direct_url	string	true
name	string	true
phone	string	true
price	string	true
state	string	true
title	string	true
tollfree	string	true
url	string	true

2.1.2.4.3.1 Field id

id properties

Property	Value
Name	id
Type	string
Required	true
Primary key	true
Sample	5bb63b6c-d56b-4a6f-9d0b-131cb8011cb4

2.1.2.4.3.2 Field type

type properties

Property	Value
Name	type
Type	string
Required	true
Primary key	true
Sample	landmark

2.1.2.4.3.3 Field activity

activity properties

Property	Value
Name	activity
Type	string
Required	true
Primary key	false
Sample	see

2.1.2.4.3.4 Field address

address properties

Property	Value
Name	address
Type	string
Required	true
Primary key	false
Sample	St. Ann's Square

2.1.2.4.3.5 Field alt

alt properties

Property	Value
Name	alt
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.4.3.6 Field city

city properties

Property	Value
Name	city
Type	string
Required	true
Primary key	false
Sample	Manchester

2.1.2.4.3.7 Field content

content properties

Property	Value
Name	content
Type	string
Required	true
Primary key	false
Sample	The neo-classical Royal Exchange was the commercial heart of Manchester's and therefore the world's cotton trade. The main trading hall, essentially a neo-Roman basilica, was at one time the largest commercial room in the world. It fell into disuse in the 1960s, but was rescued in the 1970s by the restoration of the building and the addition of an ultra-modern theatre in-the-round for Sir Robert D.H. Scott's '69 (now Royal Exchange) theatre Company. It stands in the centre of the main trading floor, squatting like an alien invader's spaceship, but is actually supported on the hall's load bearing columns. Ill-disposed members of the audience sitting in the theatre's surrounding on-stage banquette seats are well-placed to trip the actors up physically. Extensive wine merchant cellars have now been converted into a shopping centre and the wings surrounding the theatre hall contain offices and Barristers' chambers. Pop in during the day for a coffee or something stronger at the tranquil and elegant licensed cafe in the main hall: the entrance is up the stairs in St. Ann's Square or on Cross Street. As well as the wonderfully-restored interior and three dramatic coloured-glass domes, you can admire the trading board, which still shows the price of cotton around the world on the last day of trading in 1969. There is also a small, expensive craft shop inside.

2.1.2.4.3.8 Field country

country properties

Property	Value
Name	country
Type	string
Required	true
Primary key	false
Sample	United Kingdom

2.1.2.4.3.9 Field directions

directions properties

Property	Value
Name	directions
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.4.3.10 Field email

email properties

Property	Value
Name	email
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.4.3.11 Field geo

2.1.2.4.3.11.1 geo Tree Diagram

{...}

geo

type

{ABC}

accuracy

type

{123}

lat

type

{123}

lon

type

2.1.2.4.3.11.2 geo Hierarchy

Parent field: landmark

Child field(s):

Field	Type	Req	Key	Description	Comments
accuracy	string	true
lat	number	true
lon	number	true

geo properties

Property	Value
Name	geo
Type	object
Required	true
Primary key	false

2.1.2.4.3.12 Field accuracy

accuracy properties

Property	Value
Name	accuracy
Type	string
Required	true
Primary key	false
Sample	APPROXIMATE

2.1.2.4.3.13 Field lat

lat properties

Property	Value
Name	lat
Type	number
Required	true
Primary key	false
Sample	53.4825

2.1.2.4.3.14 Field lon

lon properties

Property	Value
Name	lon
Type	number
Required	true
Primary key	false
Sample	-2.24482

2.1.2.4.3.15 Field hours

hours properties

Property	Value
Name	hours
Type	string
Required	true
Primary key	false
Sample	Mon-Sat 9:30 AM - Late (depending on length of evening's performance)

2.1.2.4.3.16 Field image

image properties

Property	Value
Name	image
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.4.3.17 Field image_direct_url

image_direct_url properties

Property	Value
Name	image_direct_url
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.4.3.18 Field name

name properties

Property	Value
Name	name
Type	string
Required	true
Primary key	false
Sample	Royal Exchange

2.1.2.4.3.19 Field phone

phone properties

Property	Value
Name	phone
Type	string
Required	true
Primary key	false
Sample	+44 161 833-9833

2.1.2.4.3.20 Field price

price properties

Property	Value
Name	price
Type	string
Required	true
Primary key	false
Sample	Free entry to theatre building, theatre tickets vary

2.1.2.4.3.21 Field state

state properties

Property	Value
Name	state
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.4.3.22 Field title

title properties

Property	Value
Name	title
Type	string
Required	true
Primary key	false
Sample	Manchester/Victoria-Shopping District

2.1.2.4.3.23 Field tollfree

tollfree properties

Property	Value
Name	tollfree
Type	string
Required	true
Primary key	false
Sample	Lorem

2.1.2.4.3.24 Field url

url properties

Property	Value
Name	url
Type	string
Required	true
Primary key	false
Sample	http://www.royalexchange.co.uk

2.1.2.4.4 landmark Definitions

2.1.2.5 Document type route

2.1.2.5.1 route Tree Diagram

{...}

route

type

{ABC}

type

{ABC}

type

{ABC}

airline

type

{ABC}

airlineid

type

{ABC}

sourceairport

type

{ABC}

destinationairport

type

{123}

stops

type

{ABC}

equipment

type

[...]

schedule

type

{123}

distance

type

{...}

[0]*

type

{123}

day

type

{ABC}

flight

type

{ABC}

utc

type

2.1.2.5.2 route Properties

Property	Value
Document type	route
Id
Description
Collection	travel-sample
Additional properties
Comments

2.1.2.5.3 route Fields

Field	Type	Req	Key	Description	Comments
id	string	true
type	string	true
airline	string	true
airlineid	string	true
sourceairport	string	true
destinationairport	string	true
stops	number	true
equipment	string	true
schedule	array	true
[0]	object	false
day	number	true
flight	string	true
utc	string	true
distance	number	true

2.1.2.5.3.1 Field id

id properties

Property	Value
Name	id
Type	string
Required	true
Primary key	true
Sample	af1c7fd1-860b-4e11-8d25-6f7fd43dadf5

2.1.2.5.3.2 Field type

type properties

Property	Value
Name	type
Type	string
Required	true
Primary key	true
Sample	route

2.1.2.5.3.3 Field airline

airline properties

Property	Value
Name	airline
Type	string
Required	true
Primary key	false
Sample	AV

2.1.2.5.3.4 Field airlineid

airlineid properties

Property	Value
Name	airlineid
Type	string
Required	true
Primary key	false
Foreign collection	airline
Foreign field	id
Relationship type	Foreign Key
Sample	airline_515

2.1.2.5.3.5 Field sourceairport

sourceairport properties

Property	Value
Name	sourceairport
Type	string
Required	true
Primary key	false
Foreign collection	airport
Foreign field	id
Relationship type	Foreign Key
Sample	SAL

2.1.2.5.3.6 Field destinationairport

destinationairport properties

Property	Value
Name	destinationairport
Type	string
Required	true
Primary key	false
Foreign collection	airport
Foreign field	id
Relationship type	Foreign Key
Sample	EWR

2.1.2.5.3.7 Field stops

stops properties

Property	Value
Name	stops
Type	number
Required	true
Primary key	false
Sample	0

2.1.2.5.3.8 Field equipment

equipment properties

Property	Value
Name	equipment
Type	string
Required	true
Primary key	false
Sample	320 738

2.1.2.5.3.9 Field schedule

2.1.2.5.3.9.1 schedule Tree Diagram

[...]

schedule

type

{...}

[0]*

type

2.1.2.5.3.9.2 schedule Hierarchy

Parent field: route

Child field(s):

Field	Type	Req	Key	Description	Comments
[0]	object	false

schedule properties

Property	Value
Name	schedule
Type	array
Required	true
Primary key	false
Additional items	true

2.1.2.5.3.10 Field [0]

2.1.2.5.3.10.1 [0] Tree Diagram

{...}

[0]

type

{123}

day

type

{ABC}

flight

type

{ABC}

utc

type

2.1.2.5.3.10.2 [0] Hierarchy

Parent field: schedule

Child field(s):

Field	Type	Req	Key	Description	Comments
day	number	true
flight	string	true
utc	string	true

[0] properties

Property	Value
Type	object
Primary key	false

2.1.2.5.3.11 Field day

day properties

Property	Value
Name	day
Type	number
Required	true
Primary key	false
Sample	6

2.1.2.5.3.12 Field flight

flight properties

Property	Value
Name	flight
Type	string
Required	true
Primary key	false
Sample	AV502

2.1.2.5.3.13 Field utc

utc properties

Property	Value
Name	utc
Type	string
Required	true
Primary key	false
Sample	06:36:00

2.1.2.5.3.14 Field distance

distance properties

Property	Value
Name	distance
Type	number
Required	true
Primary key	false
Sample	3358.38183997838

2.1.2.5.4 route Definitions

2.1.3 travel-sample Indexes

2.1.3.1 Indexes New Index(1)

Property	New Index(1)
Name	New Index(1)
Description
Automatic
Mode	consistent
Included path	/*
Kind	Range
Data type	Number
Precision	-1
Excluded path
Comments

2.1.3.2 Indexes New Index(2)

Property	New Index(2)
Name	New Index(2)
Description
Automatic
Mode	consistent
Included path	/*
Kind	Range
Data type	String
Precision	-1
Excluded path
Comments

2.1.3.3 Indexes New Index(3)

Property	New Index(3)
Name	New Index(3)
Description
Automatic
Mode	consistent
Included path	/*
Kind	Spatial
Data type	Point
Precision
Excluded path
Comments

2.1.4 travel-sample Stored Procs

2.1.4.1 Stored Procs New Stored Procs

Property	New Stored Procs
Name	New Stored Procs
Id
Description	Blabla stored proc
Function
Comments

2.1.5 travel-sample Triggers

2.1.5.1 Triggers New Trigger

Property	New Trigger
Name	New Trigger
Id
Description	blabla trigger
Pre/Post	Pre-Trigger
Operation	All
Function
Comments

2.1.6 travel-sample UDFs

2.1.6.1 UDFs New UDF

Property	New UDF
Name	New UDF
Id
Description	Blabla UDF
Function
Comments

3. Relationships

3.1 Relationship fk airline.id to route.airlineid

3.1.1 fk airline.id to route.airlineid Diagram

Parent Table	Parent field
airline	id

Child Table	Child field
route	airlineid

3.1.2 fk airline.id to route.airlineid Properties

Property	Value
Name	fk airline.id to route.airlineid
Description
Parent Collection	airline
Parent field	id
Parent Cardinality	1
Child Collection	route
Child field	airlineid
Child Cardinality	0..n
Comments

3.2 Relationship fk airport.id to route.destinationairport

3.2.1 fk airport.id to route.destinationairport Diagram

Parent Table	Parent field
airport	id

Child Table	Child field
route	destinationairport

3.2.2 fk airport.id to route.destinationairport Properties

Property	Value
Name	fk airport.id to route.destinationairport
Description
Parent Collection	airport
Parent field	id
Parent Cardinality	1
Child Collection	route
Child field	destinationairport
Child Cardinality	0..n
Comments

3.3 Relationship fk airport.id to route.sourceairport

3.3.1 fk airport.id to route.sourceairport Diagram

Parent Table	Parent field
airport	id

Child Table	Child field
route	sourceairport

3.3.2 fk airport.id to route.sourceairport Properties

Property	Value
Name	fk airport.id to route.sourceairport
Description
Parent Collection	airport
Parent field	id
Parent Cardinality	1
Child Collection	route
Child field	sourceairport
Child Cardinality	0..n
Comments