✕

Firestore Physical Model

Schema for:

Model name: Zoftfino
Author:
Version:
File name: Zoftfino.json
File path: C:\Users\Pascal\Bitbucket\hackolade\schemas\Firestore\Zoftfino.json
Printed On: Sat May 19 2018 11:21:30 GMT+0200 (Romance Summer Time)
Created with: Hackolade - Visual data modeling for NoSQL and multimodel databases
1. Model
1.1 Model Zoftfino
1.1.1 Zoftfino Entity Relationship Diagram
zoftino
1.1.2 Zoftfino Properties
PropertyValue
Model name Zoftfino
Description http://www.zoftino.com/firebase-cloud-firestore-databse-tutorial-android-example
Author
Version
DB vendor Cloud Firestore
DB version
Project Name
Public-facing name
Comments
1.1.3 Zoftfino Model Definitions
2. Databases
2.1 Database zoftino
2.1.1 zoftino Properties
PropertyValue
Database namezoftino
Document id
Document ID^[a-zA-Z0-9_.-]*$
Data typeobject
Description
Project ID
Web API Key
Comments
2.1.2 zoftino Collections
2.1.2.1 Collection coupons
2.1.2.1.1 coupons Tree Diagram
{...}
coupons
type
{^$}
^[a-zA-Z0-9_.-]*$
type
{ABC}
name
type
{123}
expiry
type
{...}
coupons
type
{^$}
^[a-zA-Z0-9_.-]*$
type
{ABC}
name
type
{123}
expiry
type
2.1.2.1.2 coupons Properties
PropertyValue
Collectioncoupons
Id
Description
Databasezoftino
Parent collectionstore
Child collection
Additional propertiesfalse
Comments
2.1.2.1.3 coupons Fields
FieldTypeReqKeyDescriptionComments
^[a-zA-Z0-9_.-]*$objecttrue
namestringfalse
expirynumberfalse
2.1.2.1.3.1 Field ^[a-zA-Z0-9_.-]*$
2.1.2.1.3.1.1 ^[a-zA-Z0-9_.-]*$ Tree Diagram
{...}
^[a-zA-Z0-9_.-]*$
type
{ABC}
name
type
{123}
expiry
type
{...}
^[a-zA-Z0-9_.-]*$
type
{ABC}
name
type
{123}
expiry
type
2.1.2.1.3.1.2 ^[a-zA-Z0-9_.-]*$ Hierarchy
Parent field: coupons
Child field(s):
FieldTypeReqKeyDescriptionComments
namestringfalse
expirynumberfalse
^[a-zA-Z0-9_.-]*$ properties
PropertyValue
Name ^[a-zA-Z0-9_.-]*$
Type object
Required true
Primary key true
Additional properties false
2.1.2.1.3.2 Field name
name properties
PropertyValue
Name name
Type string
Required false
Primary key false
Sample up to 20% on fashion
2.1.2.1.3.3 Field expiry
expiry properties
PropertyValue
Name expiry
Type number
Required false
Primary key false
Unit days
Excl min false
Excl max false
Sample 15
2.1.2.1.4 coupons Definitions
2.1.2.2 Collection store
2.1.2.2.1 store Tree Diagram
{...}
store
type
{^$}
^[a-zA-Z0-9_.-]*$
type
{ABC}
category
type
{...}
cashback
type
{123}
noCoupons
type
{123}
percentage
type
{123}
max
type
{...}
store
type
{^$}
^[a-zA-Z0-9_.-]*$
type
{ABC}
category
type
{...}
cashback
type
{123}
noCoupons
type
{123}
percentage
type
{123}
max
type
2.1.2.2.2 store Properties
PropertyValue
Collectionstore
Id
Description
Databasezoftino
Parent collection
Child collection
Additional propertiesfalse
Comments
2.1.2.2.3 store Fields
FieldTypeReqKeyDescriptionComments
^[a-zA-Z0-9_.-]*$objecttrue
categorystringfalse
cashbackobjectfalse
percentagenumberfalse
maxnumberfalse
noCouponsnumberfalse
2.1.2.2.3.1 Field ^[a-zA-Z0-9_.-]*$
2.1.2.2.3.1.1 ^[a-zA-Z0-9_.-]*$ Tree Diagram
{...}
^[a-zA-Z0-9_.-]*$
type
{ABC}
category
type
{...}
cashback
type
{123}
noCoupons
type
{...}
^[a-zA-Z0-9_.-]*$
type
{ABC}
category
type
{...}
cashback
type
{123}
noCoupons
type
2.1.2.2.3.1.2 ^[a-zA-Z0-9_.-]*$ Hierarchy
Parent field: store
Child field(s):
FieldTypeReqKeyDescriptionComments
categorystringfalse
cashbackobjectfalse
noCouponsnumberfalse
^[a-zA-Z0-9_.-]*$ properties
PropertyValue
Name ^[a-zA-Z0-9_.-]*$
Type object
Required true
Primary key true
Additional properties false
2.1.2.2.3.2 Field category
category properties
PropertyValue
Name category
Type string
Required false
Primary key false
Sample all
2.1.2.2.3.3 Field cashback
2.1.2.2.3.3.1 cashback Tree Diagram
{...}
cashback
type
{123}
percentage
type
{123}
max
type
{...}
cashback
type
{123}
percentage
type
{123}
max
type
2.1.2.2.3.3.2 cashback Hierarchy
Parent field: ^[a-zA-Z0-9_.-]*$
Child field(s):
FieldTypeReqKeyDescriptionComments
percentagenumberfalse
maxnumberfalse
cashback properties
PropertyValue
Name cashback
Type object
Required false
Primary key false
Additional properties false
2.1.2.2.3.4 Field percentage
percentage properties
PropertyValue
Name percentage
Type number
Required false
Primary key false
Unit percentage
Excl min false
Excl max false
Sample 10
2.1.2.2.3.5 Field max
max properties
PropertyValue
Name max
Type number
Required false
Primary key false
Unit $
Excl min false
Excl max false
Sample 200
2.1.2.2.3.6 Field noCoupons
noCoupons properties
PropertyValue
Name noCoupons
Type number
Required false
Primary key false
Excl min false
Excl max false
Sample 24
2.1.2.2.4 store Definitions