Couchbase Physical Model

Schema for:

Model name: travel
Author: Pascal
Version: 1
File name: travel.json
File path: C:\Users\Pascal\Bitbucket\hackolade\schemas\Couchbase\travel.json
Printed On: Sat Mar 11 2017 10:30:00 GMT+0100 (Romance Standard Time)
Created with: Hackolade - Visual data modeling for NoSQL and multimodel databases
1. Model
1.1 Model travel
1.1.1 travel Entity Relationship Diagram
1.1.2 travel Properties
PropertyValue
Name travel
Description Model for the travel-sample application described in https://developer.couchbase.com/documentation/server/4.6/sdk/sample-application.html
Author Pascal
Version 1
DB Vendor Couchbase
Db Version v4.6
Comments
1.1.3 travel Database Users
1.1.4 travel DB Definitions
2. Document kind
2.1 Bucket travel-sample
2.1.2 travel-sample Properties
PropertyValue
Bucket name travel-sample
Description
Comments
Bucket type Couchbase
Key
name KEY
type string
Document kind
name type
type string
Memory size
Per node RAM quota 100
Access Control Standart port
Password 123
Conflict resolution Sequence number
Replicas
Enable false
Number 1
View index replicas false
Disk I/O optimisation
Disk I/O priority Low (Default)
Auto-Compaction
Override default false
FLUSH
Enable
2.1. travel-sample Document kinds
2.1.3.1 Document kind airline
2.1.3.1.1 airline Tree Diagram
{ABC}
iata
type
{ABC}
name
type
{ABC}
icao
type
{ABC}
country
type
{123}
id
type
{ABC}
type
type
{ABC}
KEY
type
airline
type
{ABC}
iata
type
{ABC}
name
type
{ABC}
icao
type
{ABC}
country
type
{123}
id
type
{ABC}
type
type
{ABC}
KEY
type
airline
type
2.1.3.1.2 airline Properties
PropertyValue
Document kind name airline
Id
Description
Bucket ac31ce80-fac7-11e6-9f58-33155ddb31fb
Additional properties
Comments
2.1.3.1.3 airline Fields
FieldTypeReqKeyDescription
KEYstringtrue
typestringtrue
idnumerictrue
countrystringtrue
icaostringtrue
namestringtrue
iatastringtrue
2.1.3.1.3.1 Field KEY
2.1.3.1.3.1.1 KEY Tree Diagram
{ABC}
KEY
type
{ABC}
KEY
type
KEY properties
PropertyValue
Name KEY
Id
Type string
Description
Dependencies
Required true
Primary key true
Foreign document kind
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments
2.1.3.1.3.2 Field type
2.1.3.1.3.2.1 type Tree Diagram
{ABC}
type
type
{ABC}
type
type
type properties
PropertyValue
Name type
Id
Type string
Description
Dependencies
Required true
Primary key false
Foreign document kind
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample airline
Comments
2.1.3.1.3.3 Field id
2.1.3.1.3.3.1 id Tree Diagram
id
type
id
type
id properties
PropertyValue
Name id
Id
Type number
Description
Dependencies
Required true
Foreign document kind
Foreign field
Relationship type
Default
Unit
Min value
Excl min
Max value
Excl max
Multiple of
Divisible by
Enum
Sample 9833
Comments
2.1.3.1.3.4 Field country
2.1.3.1.3.4.1 country Tree Diagram
{ABC}
country
type
{ABC}
country
type
country properties
PropertyValue
Name country
Id
Type string
Description
Dependencies
Required true
Primary key false
Foreign document kind
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample United States
Comments
2.1.3.1.3.5 Field icao
2.1.3.1.3.5.1 icao Tree Diagram
{ABC}
icao
type
{ABC}
icao
type
icao properties
PropertyValue
Name icao
Id
Type string
Description
Dependencies
Required true
Primary key false
Foreign document kind
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample 4AA
Comments
2.1.3.1.3.6 Field name
2.1.3.1.3.6.1 name Tree Diagram
{ABC}
name
type
{ABC}
name
type
name properties
PropertyValue
Name name
Id
Type string
Description
Dependencies
Required true
Primary key false
Foreign document kind
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample Epic Holiday
Comments
2.1.3.1.3.7 Field iata
2.1.3.1.3.7.1 iata Tree Diagram
{ABC}
iata
type
{ABC}
iata
type
iata properties
PropertyValue
Name iata
Id
Type string
Description
Dependencies
Required true
Primary key false
Foreign document kind
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments
2.1.3.1.4 airline Users (TBD)
2.1.3.1.5 airline Indexes
2.1.3.1.6 airline Sharding (TBD)
2.1.3.1.7 airline Definitions
2.1.3.1.8 airline JSON Schema
{
    "$schema": "http://json-schema.org/draft-04/schema#",
    "properties": {
        "id": {
            "primaryKey": false,
            "type": "number",
            "GUID": "ac2105a4-fac7-11e6-9f58-33155ddb31fb",
            "sample": 9833,
            "mode": "integer32"
        },
        "KEY": {
            "key": true,
            "primaryKey": true,
            "type": "string",
            "GUID": "ac2105a7-fac7-11e6-9f58-33155ddb31fb"
        },
        "type": {
            "primaryKey": false,
            "type": "string",
            "GUID": "ac2105a6-fac7-11e6-9f58-33155ddb31fb",
            "documentKind": true,
            "sample": "airline"
        },
        "country": {
            "primaryKey": false,
            "type": "string",
            "GUID": "ac2105a2-fac7-11e6-9f58-33155ddb31fb",
            "sample": "United States"
        },
        "icao": {
            "primaryKey": false,
            "type": "string",
            "GUID": "ac2105a3-fac7-11e6-9f58-33155ddb31fb",
            "sample": "4AA"
        },
        "name": {
            "primaryKey": false,
            "type": "string",
            "GUID": "ac2105a5-fac7-11e6-9f58-33155ddb31fb",
            "sample": "Epic Holiday"
        },
        "iata": {
            "primaryKey": false,
            "type": "string",
            "GUID": "6b809190-fac8-11e6-9f58-33155ddb31fb"
        }
    },
    "type": "object",
    "required": [
        "KEY",
        "type",
        "id",
        "country",
        "icao",
        "name",
        "iata"
    ]
}
2.1.3.1.9 airline JSON data
{
    "KEY": "Lorem",
    "type": "airline",
    "id": 9833,
    "country": "United States",
    "icao": "4AA",
    "name": "Epic Holiday",
    "iata": "Lorem"
}
2.1.3.2 Document kind airport
2.1.3.2.1 airport Tree Diagram
{ABC}
icao
type
{ABC}
tz
type
{123}
id