✕

Firebase Physical Model

Schema for:

Model name: Firebase_example
Author:
Version:
File name: Firebase_example.json
File path: C:\Users\Pascal\Bitbucket\hackolade\schemas\Firebase\Firebase_example.json
Printed On: Sat May 19 2018 11:19:59 GMT+0200 (Romance Summer Time)
Created with: Hackolade - Visual data modeling for NoSQL and multimodel databases
1. Model
1.1 Model Firebase_example
1.1.1 Firebase_example Entity Relationship Diagram
ethereal-honor-135803
1.1.2 Firebase_example Properties
PropertyValue
Model name Firebase_example
Description
Author
Version
DB vendor Realtime Firebase
DB version
Project Name My First Project
Public-facing name project-383493253187
Comments
1.1.3 Firebase_example Model Definitions
2. Databases
2.1 Database ethereal-honor-135803
2.1.1 ethereal-honor-135803 Properties
PropertyValue
Database nameethereal-honor-135803
Document id
Document ID^[a-zA-Z0-9_.-]*$
Data typeobject
Description
Project IDethereal-honor-135803
Web API KeyAIzaSyCEICqg91IQ7PCixRzdE5OCTI3jTCMi
Comments
2.1.2 ethereal-honor-135803 Nodes
2.1.2.1 Node profiles
2.1.2.1.1 profiles Tree Diagram
{...}
profiles
type
{...}
^[a-zA-Z0-9_.-]{20,20}$
type
{ABC}
displayName
type
{...}
avatar
type
{...}
coverImage
type
{ABC}
key
type
{...}
original
type
{...}
original
type
{ABC}
downloadURL
type
{ABC}
name
type
{ABC}
downloadURL
type
{ABC}
name
type
{...}
profiles
type
{...}
^[a-zA-Z0-9_.-]{20,20}$
type
{ABC}
displayName
type
{...}
avatar
type
{...}
coverImage
type
{ABC}
key
type
{...}
original
type
{...}
original
type
{ABC}
downloadURL
type
{ABC}
name
type
{ABC}
downloadURL
type
{ABC}
name
type
2.1.2.1.2 profiles Properties
PropertyValue
Nodeprofiles
Id
Description
Databaseethereal-honor-135803
Additional propertiesfalse
Comments
2.1.2.1.3 profiles Fields
FieldTypeReqKeyDescriptionComments
^[a-zA-Z0-9_.-]{20,20}$objecttrue
displayNamestringtrue
avatarobjecttrue
originalobjecttrue
downloadURLstringtrue
namestringtrue
coverImageobjecttrue
originalobjecttrue
downloadURLstringtrue
namestringtrue
keystringtrue
2.1.2.1.3.1 Field ^[a-zA-Z0-9_.-]{20,20}$
2.1.2.1.3.1.1 ^[a-zA-Z0-9_.-]{20,20}$ Tree Diagram
{...}
^[a-zA-Z0-9_.-]{20,20}$
type
{ABC}
displayName
type
{...}
avatar
type
{...}
coverImage
type
{ABC}
key
type
{...}
^[a-zA-Z0-9_.-]{20,20}$
type
{ABC}
displayName
type
{...}
avatar
type
{...}
coverImage
type
{ABC}
key
type
2.1.2.1.3.1.2 ^[a-zA-Z0-9_.-]{20,20}$ Hierarchy
Parent field: profiles
Child field(s):
FieldTypeReqKeyDescriptionComments
displayNamestringtruefm
avatarobjecttruefm
coverImageobjecttruefm
keystringtrue
^[a-zA-Z0-9_.-]{20,20}$ properties
PropertyValue
Name ^[a-zA-Z0-9_.-]{20,20}$
Id aVFosmX29afSVqwYP8R34dNELXd2
Type object
Required true
Primary key true
Foreign node users
Foreign field ^[a-zA-Z0-9_.-]{20,20}$
Relationship type Foreign Key
Additional properties false
2.1.2.1.3.2 Field displayName
displayName properties
PropertyValue
Name displayName
Type string
Required true
Primary key false
Foreign collection users
Foreign field displayName
Relationship type Foreign Master
Sample Daniel1 Dimitrov
2.1.2.1.3.3 Field avatar
2.1.2.1.3.3.1 avatar Tree Diagram
{...}
avatar
type
{...}
original
type
{...}
avatar
type
{...}
original
type
2.1.2.1.3.3.2 avatar Hierarchy
Parent field: ^[a-zA-Z0-9_.-]{20,20}$
Child field(s):
FieldTypeReqKeyDescriptionComments
originalobjecttrue
avatar properties
PropertyValue
Name avatar
Type object
Required true
Primary key false
Foreign node users
Foreign field avatar
Relationship type Foreign Master
2.1.2.1.3.4 Field original
2.1.2.1.3.4.1 original Tree Diagram
{...}
original
type
{ABC}
downloadURL
type
{ABC}
name
type
{...}
original
type
{ABC}
downloadURL
type
{ABC}
name
type
2.1.2.1.3.4.2 original Hierarchy
Parent field: avatar
Child field(s):
FieldTypeReqKeyDescriptionComments
downloadURLstringtrue
namestringtrue
original properties
PropertyValue
Name original
Type object
Required true
Primary key false
2.1.2.1.3.5 Field downloadURL
downloadURL properties
PropertyValue
Name downloadURL
Type string
Required true
Primary key false
Sample https://firebasestorage.googleapis.com/v0/b/farmerjoe-dev.appspot.com/o/users%2FaVFosmX29afSVqwYP8R34dNELXd2%2Favatar%2FB9EFE8D9-332A-418D-A7C7-42E0E8601323.jpg?alt=media&token=62fce764-ad78-44f7-8769-737dbb01ffdb
2.1.2.1.3.6 Field name
name properties
PropertyValue
Name name
Type string
Required true
Primary key false
Sample users/aVFosmX29afSVqwYP8R34dNELXd2/avatar/B9EFE8D9-332A-418D-A7C7-42E0E8601323.jpg
2.1.2.1.3.7 Field coverImage
2.1.2.1.3.7.1 coverImage Tree Diagram
{...}
coverImage
type
{...}
original
type
{...}
coverImage
type
{...}
original
type
2.1.2.1.3.7.2 coverImage Hierarchy
Parent field: ^[a-zA-Z0-9_.-]{20,20}$
Child field(s):
FieldTypeReqKeyDescriptionComments
originalobjecttrue
coverImage properties
PropertyValue
Name coverImage
Type object
Required true
Primary key false
Foreign node users
Foreign field coverImage
Relationship type Foreign Master
2.1.2.1.3.8 Field original
2.1.2.1.3.8.1 original Tree Diagram
{...}
original
type
{ABC}
downloadURL
type
{ABC}
name
type
{...}
original
type
{ABC}
downloadURL
type
{ABC}
name
type
2.1.2.1.3.8.2 original Hierarchy
Parent field: coverImage
Child field(s):
FieldTypeReqKeyDescriptionComments
downloadURLstringtrue
namestringtrue
original properties
PropertyValue
Name original
Type object
Required true
Primary key false
2.1.2.1.3.9 Field downloadURL
downloadURL properties
PropertyValue
Name downloadURL
Type string
Required true
Primary key false
Sample https://firebasestorage.googleapis.com/v0/b/farmerjoe-dev.appspot.com/o/users%2FaVFosmX29afSVqwYP8R34dNELXd2%2Fprofile%2F1837839A-DCC1-4432-BDCB-41AC12CF2A68.jpg?alt=media&token=27ee872f-6f9e-4f08-94cd-50da9b0729ba
2.1.2.1.3.10 Field name
name properties
PropertyValue
Name name
Type string
Required true
Primary key false
Sample users/aVFosmX29afSVqwYP8R34dNELXd2/profile/1837839A-DCC1-4432-BDCB-41AC12CF2A68.jpg
2.1.2.1.3.11 Field key
key properties
PropertyValue
Name key
Type string
Required true
Primary key false
Sample aVFosmX29afSVqwYP8R34dNELXd2
2.1.2.1.4 profiles Definitions
2.1.2.2 Node users
2.1.2.2.1 users Tree Diagram
{...}
users
type
{...}
^[a-zA-Z0-9_.-]{20,20}$
type
{ABC}
firstname
type
{ABC}
lastname
type
{ABC}
displayName
type
{ABC}
email
type
{ABC}
phoneNumber
type
{ABC}
language
type
{...}
companies
type
{...}
avatar
type
{...}
coverImage
type
{ABC}
uid
type
{0/1}
$companyId
type
{...}
original
type
{...}
original
type
{ABC}
downloadURL
type
{ABC}
name
type
{ABC}
downloadURL
type
{ABC}
name
type
{...}
users
type
{...}
^[a-zA-Z0-9_.-]{20,20}$
type
{ABC}
firstname
type
{ABC}
lastname
type
{ABC}
displayName
type
{ABC}
email
type
{ABC}
phoneNumber
type
{ABC}
language
type
{...}
companies
type
{...}
avatar
type
{...}
coverImage
type
{ABC}
uid
type
{0/1}
$companyId
type
{...}
original
type
{...}
original
type
{ABC}
downloadURL
type
{ABC}
name
type
{ABC}
downloadURL
type
{ABC}
name
type
2.1.2.2.2 users Properties
PropertyValue
Nodeusers
Id
Description
Databaseethereal-honor-135803
Additional propertiesfalse
Comments
2.1.2.2.3 users Fields
FieldTypeReqKeyDescriptionComments
^[a-zA-Z0-9_.-]{20,20}$objecttrue
firstnamestringtrue
lastnamestringtrue
displayNamestringtrue
emailstringtrue
phoneNumberstringtrue
languagestringtrue
companiesobjecttrue
$companyIdbooleantrue
avatarobjecttrue
originalobjecttrue
downloadURLstringtrue
namestringtrue
coverImageobjecttrue
originalobjecttrue
downloadURLstringtrue
namestringtrue
uidstringtrue
2.1.2.2.3.1 Field ^[a-zA-Z0-9_.-]{20,20}$
2.1.2.2.3.1.1 ^[a-zA-Z0-9_.-]{20,20}$ Tree Diagram
{...}
^[a-zA-Z0-9_.-]{20,20}$
type
{ABC}
firstname
type
{ABC}
lastname
type
{ABC}
displayName
type
{ABC}
email
type
{ABC}
phoneNumber
type
{ABC}
language
type
{...}
companies
type
{...}
avatar
type
{...}
coverImage
type
{ABC}
uid
type
{...}
^[a-zA-Z0-9_.-]{20,20}$
type
{ABC}
firstname
type
{ABC}
lastname
type
{ABC}
displayName
type
{ABC}
email
type
{ABC}
phoneNumber
type
{ABC}
language
type
{...}
companies
type
{...}
avatar
type
{...}
coverImage
type
{ABC}
uid
type
2.1.2.2.3.1.2 ^[a-zA-Z0-9_.-]{20,20}$ Hierarchy
Parent field: users
Child field(s):
FieldTypeReqKeyDescriptionComments
firstnamestringtrue
lastnamestringtrue
displayNamestringtrue
emailstringtrue
phoneNumberstringtrue
languagestringtrue
companiesobjecttrue
avatarobjecttrue
coverImageobjecttrue
uidstringtrue
^[a-zA-Z0-9_.-]{20,20}$ properties
PropertyValue
Name ^[a-zA-Z0-9_.-]{20,20}$
Id aVFosmX29afSVqwYP8R34dNELXd2
Type object
Required true
Primary key true
Additional properties false
2.1.2.2.3.2 Field firstname
firstname properties
PropertyValue
Name firstname
Type string
Required true
Primary key false
Sample Daniel1
2.1.2.2.3.3 Field lastname
lastname properties
PropertyValue
Name lastname
Type string
Required true
Primary key false
Sample Dimitrov
2.1.2.2.3.4 Field displayName
displayName properties
PropertyValue
Name displayName
Type string
Required true
Primary key false
Sample Daniel1 Dimitrov
2.1.2.2.3.5 Field email
email properties
PropertyValue
Name email
Type string
Required true
Primary key false
Sample daniel@compojoom.com
2.1.2.2.3.6 Field phoneNumber
phoneNumber properties
PropertyValue
Name phoneNumber
Type string
Required true
Primary key false
Sample +4917663398762
2.1.2.2.3.7 Field language
language properties
PropertyValue
Name language
Type string
Required true
Primary key false
Sample de
2.1.2.2.3.8 Field companies
2.1.2.2.3.8.1 companies Tree Diagram
{...}
companies
type
{0/1}
$companyId
type
{...}
companies
type
{0/1}
$companyId
type
2.1.2.2.3.8.2 companies Hierarchy
Parent field: ^[a-zA-Z0-9_.-]{20,20}$
Child field(s):
FieldTypeReqKeyDescriptionComments
$companyIdbooleantrue
companies properties
PropertyValue
Name companies
Type object
Required true
Primary key false
2.1.2.2.3.9 Field $companyId
$companyId properties
PropertyValue
Name $companyId
Type boolean
Required true
Primary key false
Sample true
2.1.2.2.3.10 Field avatar
2.1.2.2.3.10.1 avatar Tree Diagram
{...}
avatar
type
{...}
original
type
{...}
avatar
type
{...}
original
type
2.1.2.2.3.10.2 avatar Hierarchy
Parent field: ^[a-zA-Z0-9_.-]{20,20}$
Child field(s):
FieldTypeReqKeyDescriptionComments
originalobjecttrue
avatar properties
PropertyValue
Name avatar
Type object
Required true
Primary key false
2.1.2.2.3.11 Field original
2.1.2.2.3.11.1 original Tree Diagram
{...}
original
type
{ABC}
downloadURL
type
{ABC}
name
type
{...}
original
type
{ABC}
downloadURL
type
{ABC}
name
type
2.1.2.2.3.11.2 original Hierarchy
Parent field: avatar
Child field(s):
FieldTypeReqKeyDescriptionComments
downloadURLstringtrue
namestringtrue
original properties
PropertyValue
Name original
Type object
Required true
Primary key false
2.1.2.2.3.12 Field downloadURL
downloadURL properties
PropertyValue
Name downloadURL
Type string
Required true
Primary key false
Sample https://firebasestorage.googleapis.com/v0/b/farmerjoe-dev.appspot.com/o/users%2FaVFosmX29afSVqwYP8R34dNELXd2%2Fprofile%2F1837839A-DCC1-4432-BDCB-41AC12CF2A68.jpg?alt=media&token=27ee872f-6f9e-4f08-94cd-50da9b0729ba
2.1.2.2.3.13 Field name
name properties
PropertyValue
Name name
Type string
Required true
Primary key false
Sample users/aVFosmX29afSVqwYP8R34dNELXd2/profile/1837839A-DCC1-4432-BDCB-41AC12CF2A68.jpg
2.1.2.2.3.14 Field coverImage
2.1.2.2.3.14.1 coverImage Tree Diagram
{...}
coverImage
type
{...}
original
type
{...}
coverImage
type
{...}
original
type
2.1.2.2.3.14.2 coverImage Hierarchy
Parent field: ^[a-zA-Z0-9_.-]{20,20}$
Child field(s):
FieldTypeReqKeyDescriptionComments
originalobjecttrue
coverImage properties
PropertyValue
Name coverImage
Type object
Required true
Primary key false
2.1.2.2.3.15 Field original
2.1.2.2.3.15.1 original Tree Diagram
{...}
original
type
{ABC}
downloadURL
type
{ABC}
name
type
{...}
original
type
{ABC}
downloadURL
type
{ABC}
name
type
2.1.2.2.3.15.2 original Hierarchy
Parent field: coverImage
Child field(s):
FieldTypeReqKeyDescriptionComments
downloadURLstringtrue
namestringtrue
original properties
PropertyValue
Name original
Type object
Required true
Primary key false
2.1.2.2.3.16 Field downloadURL
downloadURL properties
PropertyValue
Name downloadURL
Type string
Required true
Primary key false
Sample https://firebasestorage.googleapis.com/v0/b/farmerjoe-dev.appspot.com/o/users%2FaVFosmX29afSVqwYP8R34dNELXd2%2Fprofile%2F1837839A-DCC1-4432-BDCB-41AC12CF2A68.jpg?alt=media&token=27ee872f-6f9e-4f08-94cd-50da9b0729ba
2.1.2.2.3.17 Field name
name properties
PropertyValue
Name name
Type string
Required true
Primary key false
Sample users/aVFosmX29afSVqwYP8R34dNELXd2/profile/1837839A-DCC1-4432-BDCB-41AC12CF2A68.jpg
2.1.2.2.3.18 Field uid
uid properties
PropertyValue
Name uid
Type string
Required true
Primary key false
Sample aVFosmX29afSVqwYP8R34dNELXd2
2.1.2.2.4 users Definitions
3. Relationships
3.1 Relationship New Relationship(2)
3.1.1 New Relationship(2) Diagram
Parent TableParent field
users ^[a-zA-Z0-9_.-]{20,20}$
Child TableChild field
profiles ^[a-zA-Z0-9_.-]{20,20}$
3.1.2 New Relationship(2) Properties
PropertyValue
Name New Relationship(2)
Description
Parent Nodeusers
Parent field^[a-zA-Z0-9_.-]{20,20}$
Parent Cardinality 1
Child Nodeprofiles
Child field^[a-zA-Z0-9_.-]{20,20}$
Child Cardinality 1
Comments
3.2 Relationship fk users.^[a-zA-Z0-9_.-]*{20,20}$.avatar to profiles.^[a-zA-Z0-9_.-]*{20,20}$.avatar
3.2.1 fk users.^[a-zA-Z0-9_.-]*{20,20}$.avatar to profiles.^[a-zA-Z0-9_.-]*{20,20}$.avatar Diagram
Parent TableParent field
users ^[a-zA-Z0-9_.-]{20,20}$.avatar
Child TableChild field
profiles ^[a-zA-Z0-9_.-]{20,20}$.avatar
3.2.2 fk users.^[a-zA-Z0-9_.-]*{20,20}$.avatar to profiles.^[a-zA-Z0-9_.-]*{20,20}$.avatar Properties
PropertyValue
Name fk users.^[a-zA-Z0-9_.-]*{20,20}$.avatar to profiles.^[a-zA-Z0-9_.-]*{20,20}$.avatar
Description
Parent Nodeusers
Parent fieldavatar
Parent Cardinality 1
Child Nodeprofiles
Child fieldavatar
Child Cardinality 1
Comments
3.3 Relationship fk users.^[a-zA-Z0-9_.-]*{20,20}$.coverImage to profiles.^[a-zA-Z0-9_.-]*{20,20}$.coverImage
3.3.1 fk users.^[a-zA-Z0-9_.-]*{20,20}$.coverImage to profiles.^[a-zA-Z0-9_.-]*{20,20}$.coverImage Diagram
Parent TableParent field
users ^[a-zA-Z0-9_.-]{20,20}$.coverImage
Child TableChild field
profiles ^[a-zA-Z0-9_.-]{20,20}$.coverImage
3.3.2 fk users.^[a-zA-Z0-9_.-]*{20,20}$.coverImage to profiles.^[a-zA-Z0-9_.-]*{20,20}$.coverImage Properties
PropertyValue
Name fk users.^[a-zA-Z0-9_.-]*{20,20}$.coverImage to profiles.^[a-zA-Z0-9_.-]*{20,20}$.coverImage
Description
Parent Nodeusers
Parent fieldcoverImage
Parent Cardinality 1
Child Nodeprofiles
Child fieldcoverImage
Child Cardinality 1
Comments
3.4 Relationship fk users.^[a-zA-Z0-9_.-]*{20,20}$.displayName to profiles.^[a-zA-Z0-9_.-]*{20,20}$.displayName
3.4.1 fk users.^[a-zA-Z0-9_.-]*{20,20}$.displayName to profiles.^[a-zA-Z0-9_.-]*{20,20}$.displayName Diagram
Parent TableParent field
users ^[a-zA-Z0-9_.-]{20,20}$.displayName
Child TableChild field
profiles ^[a-zA-Z0-9_.-]{20,20}$.displayName
3.4.2 fk users.^[a-zA-Z0-9_.-]*{20,20}$.displayName to profiles.^[a-zA-Z0-9_.-]*{20,20}$.displayName Properties
PropertyValue
Name fk users.^[a-zA-Z0-9_.-]*{20,20}$.displayName to profiles.^[a-zA-Z0-9_.-]*{20,20}$.displayName
Description
Parent Nodeusers
Parent fielddisplayName
Parent Cardinality 1
Child Nodeprofiles
Child fielddisplayName
Child Cardinality 1
Comments