Fight Pandemics - Data Model

MongoDB Physical Model

Schema for:

Model name: FightPandemics

Author: Nícolas de Araujo

Version: 2

File name: data_model.json

File path: C:\Users\nicol\Dev\fight_pandemics\DataModel\v2\data_model.json

Printed On: Fri May 01 2020 13:38:40 GMT-0300 (Horário Padrão de Brasília)

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

1. Model

2. Databases

2.1 applicationDB
2.1.2. Collections
2.1.2.1 comments
2.1.2.2 feedbacks
2.1.2.3 posts
2.1.2.4 users

3. Relationships

1. Model

1.1 Model FightPandemics

1.1.1 FightPandemics Entity Relationship Diagram

Databases

Show all

applicationDB

1.1.2 FightPandemics Properties

Property	Value
Model name	FightPandemics
Technical name	FightPandemics
Description
Author	Nícolas de Araujo
Version	2
DB vendor	MongoDB
DB version	v4.2
Comments

1.1.3 FightPandemics DB Definitions

1.1.3.1 Field location

1.1.3.1.1 location Tree Diagram

{...}

location

[...]

coordinates

{ABC}

type

{ABC}

country

{ABC}

city

{ABC}

neighborhood

{ABC}

address

1.1.3.1.2 location Hierarchy

Parent field:

Child field(s):

Field	Type	Req	Key	Description	Comments
coordinates	array	true		Array with the coordinates, specifying longitude first and latitude second, as default in the GeoJSON definition.
type	string	true		Type of the GeoJSON Object. Please refer to the official documentation for more information. In our case, the value will always be of the type "Point".
country	string	false		String holding the country's name.
city	string	false		String holding the city's name.
neighborhood	string	false		String holding the neighborhood's name.
address	string	false		String holding the address (street, number and other details).

1.1.3.1.3 location properties

Property	Value
Name	location
Technical name
Id
Type	document
Description	Location document according to the norms of a GeoJSON Object. The fields address, neighborhood, city, state and country are added to store the result of the geoprocessing.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
DBRef
Min Properties
Max Properties
Additional properties	false
Comments

1.1.3.2 Field coordinates

1.1.3.2.1 coordinates Tree Diagram

[...]

coordinates

{123}

[0]

{123}

[1]+

1.1.3.2.2 coordinates Hierarchy

Parent field: location

Child field(s):

Field	Type	Req	Key	Description	Comments
[0]	numeric	false		Location longitude
[1]	numeric	false		Location latitude

1.1.3.2.3 coordinates properties

Property	Value
Name	coordinates
Technical name
Id
Type	array
Description	Array with the coordinates, specifying longitude first and latitude second, as default in the GeoJSON definition.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Min items	2
Max items	2
Unique items	false
Additional items	true
Comments

1.1.3.3 Field [0]

1.1.3.3.1 [0] Tree Diagram

{123}

[0]

1.1.3.3.2 [0] properties

Property	Value
Id	lng
Type	numeric
Subtype
Description	Location longitude
Dependencies
Primary key	false
Foreign collection
Foreign field
Relationship type
Default	0
Unit	degrees
Min value	-180
Excl min	false
Max value	180
Excl max	false
Multiple of
Divisible by
Enum
Sample	35.26
Comments

1.1.3.4 Field [1]

1.1.3.4.1 [1] Tree Diagram

{123}

[1]

1.1.3.4.2 [1] properties

Property	Value
Id	lat
Type	numeric
Subtype
Description	Location latitude
Dependencies
Primary key	false
Foreign collection
Foreign field
Relationship type
Default	0
Unit	degrees
Min value	-90
Excl min	false
Max value	90
Excl max	false
Multiple of
Divisible by
Enum
Sample	-32.83
Comments

1.1.3.5 Field type

1.1.3.5.1 type Tree Diagram

{ABC}

type

1.1.3.5.2 type properties

Property	Value
Name	type
Technical name
Id
Type	string
Description	Type of the GeoJSON Object. Please refer to the official documentation for more information. In our case, the value will always be of the type "Point".
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum	Point
Sample
Comments

1.1.3.6 Field country

1.1.3.6.1 country Tree Diagram

{ABC}

country

1.1.3.6.2 country properties

Property	Value
Name	country
Technical name
Id
Type	string
Description	String holding the country's name.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

1.1.3.7 Field city

1.1.3.7.1 city Tree Diagram

{ABC}

city

1.1.3.7.2 city properties

Property	Value
Name	city
Technical name
Id
Type	string
Description	String holding the city's name.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

1.1.3.8 Field neighborhood

1.1.3.8.1 neighborhood Tree Diagram

{ABC}

neighborhood

1.1.3.8.2 neighborhood properties

Property	Value
Name	neighborhood
Technical name
Id
Type	string
Description	String holding the neighborhood's name.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

1.1.3.9 Field address

1.1.3.9.1 address Tree Diagram

{ABC}

address

1.1.3.9.2 address properties

Property	Value
Name	address
Technical name
Id
Type	string
Description	String holding the address (street, number and other details).
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

1.1.3.10 Field author

1.1.3.10.1 author Tree Diagram

{...}

author

{_id}

{ABC}

name

{ABC}

type

location

ref:

location (m)

1.1.3.10.2 author Hierarchy

Parent field:

Child field(s):

Field	Type	Req	Key	Description	Comments
id	objectId	true	fk	Foreign key to the user who created the post.
name	string	true
type	string	true
location	reference	true

1.1.3.10.3 author properties

Property	Value
Name	author
Technical name
Id
Type	document
Description
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
DBRef
Min Properties
Max Properties
Additional properties	false
Comments

1.1.3.11 Field id

1.1.3.11.1 id Tree Diagram

{_id}

1.1.3.11.2 id properties

Property	Value
Name	id
Technical name
Id
Type	objectId
Description	Foreign key to the user who created the post.
Dependencies
Required	true
Primary key	false
Foreign collection	users
Foreign field	_id
Relationship type	Foreign Key
Default
Sample
Comments

1.1.3.12 Field name

1.1.3.12.1 name Tree Diagram

{ABC}

name

1.1.3.12.2 name properties

Property	Value
Name	name
Technical name
Id
Type	string
Description
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

1.1.3.13 Field type

1.1.3.13.1 type Tree Diagram

{ABC}

type

1.1.3.13.2 type properties

Property	Value
Name	type
Technical name
Id
Type	string
Description
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

1.1.3.14 Field location

1.1.3.14.1 location Tree Diagram

location

ref:

location (m)

1.1.3.14.2 location properties

Property	Value
Name	location
$ref	#model/definitions/location
Reference type	model

2. Databases

2.1 Database applicationDB

Databases

Show all

applicationDB

2.1.1 applicationDB Properties

Property	Value
Database name	applicationDB
Technical name
Enable sharding
Description
Comments

2.1.2 applicationDB Collections

2.1.2.1 Collection comments

2.1.2.1.1 comments Tree Diagram

comments

{_id}

_id

{dt}

createdAt

(I1.1)

{dt}

updatedAt

author

ref:

author (m)

{_id}

postId

(I1.3)

{_id}

parentId

(I1.2)

{ABC}

content

[...]

likes

{_id}

{ABC}

name

{ABC}

type

location

ref:

location (m)

{_id}

[0]*

[...]

coordinates

{ABC}

type

{ABC}

country

{ABC}

city

{ABC}

neighborhood

{ABC}

address

{123}

[0]

{123}

[1]+

2.1.2.1.2 comments Properties

Property	Value
Collection name	comments
Technical name
Id
Description
Database	applicationDB
Capped	false
Size
Max
Storage engine	WiredTiger
Config String
Validation level	Off
Validation action	Warn
Additional properties	false
Comments

2.1.2.1.3 comments Fields

Field	Type	Req	Key	Description	Comments
_id	objectId	true		Automatically generated object_id as primary key.
createdAt	date	true		Timestamp with the comment's creation date
updatedAt	date	true		Timestamp with the comment's last update date
author	document	true
id	objectId	true		Foreign key to the user who created the post.
name	string	true
type	string	true
location	document	true		Location document according to the norms of a GeoJSON Object. The fields address, neighborhood, city, state and country are added to store the result of the geoprocessing.
coordinates	array	true		Array with the coordinates, specifying longitude first and latitude second, as default in the GeoJSON definition.
[0]	numeric	false		Location longitude
[1]	numeric	false		Location latitude
type	string	true		Type of the GeoJSON Object. Please refer to the official documentation for more information. In our case, the value will always be of the type "Point".
country	string	false		String holding the country's name.
city	string	false		String holding the city's name.
neighborhood	string	false		String holding the neighborhood's name.
address	string	false		String holding the address (street, number and other details).
postId	objectId	true
parentId	objectId	false		If the comment is nested (in another comment), this field will hold the _id of the parent comment. Optional field, where being blank means it is a root comment.
content	string	true		Stirng holding the comment's content.
likes	array	false		Array holding the user_id of all the users who liked the comment.
[0]	objectId	false		_id of the user who liked the comment

2.1.2.1.3.1 Field _id

2.1.2.1.3.1.1 _id Tree Diagram

{_id}

_id

2.1.2.1.3.1.2 _id properties

Property	Value
Name	_id
Technical name
Id
Type	objectId
Description	Automatically generated object_id as primary key.
Dependencies
Required	true
Primary key	true
Foreign collection
Foreign field
Relationship type
Default
Sample
Comments

2.1.2.1.3.2 Field createdAt

2.1.2.1.3.2.1 createdAt Tree Diagram

{dt}

createdAt

(I1.1)

2.1.2.1.3.2.2 createdAt properties

Property	Value
Name	createdAt
Technical name
Id
Type	date
Description	Timestamp with the comment's creation date
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Sample
Comments

2.1.2.1.3.3 Field updatedAt

2.1.2.1.3.3.1 updatedAt Tree Diagram

{dt}

updatedAt

2.1.2.1.3.3.2 updatedAt properties

Property	Value
Name	updatedAt
Technical name
Id
Type	date
Description	Timestamp with the comment's last update date
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Sample
Comments

2.1.2.1.3.4 Field author

2.1.2.1.3.4.1 author Tree Diagram

author

ref:

author (m)

2.1.2.1.3.4.2 author properties

Property	Value
Name	author
$ref	#model/definitions/author
Reference type	model

2.1.2.1.3.5 Field postId

2.1.2.1.3.5.1 postId Tree Diagram

{_id}

postId

(I1.3)

2.1.2.1.3.5.2 postId properties

Property	Value
Name	postId
Technical name
Id
Type	objectId
Description
Dependencies
Required	true
Primary key	false
Foreign collection	posts
Foreign field
Relationship type
Default
Sample
Comments

2.1.2.1.3.6 Field parentId

2.1.2.1.3.6.1 parentId Tree Diagram

{_id}

parentId

(I1.2)

2.1.2.1.3.6.2 parentId properties

Property	Value
Name	parentId
Technical name
Id
Type	objectId
Description	If the comment is nested (in another comment), this field will hold the _id of the parent comment. Optional field, where being blank means it is a root comment.
Dependencies
Required	false
Primary key	false
Foreign collection	comments
Foreign field	_id
Relationship type	Foreign Key
Default
Sample
Comments

2.1.2.1.3.7 Field content

2.1.2.1.3.7.1 content Tree Diagram

{ABC}

content

2.1.2.1.3.7.2 content properties

Property	Value
Name	content
Technical name
Id
Type	string
Description	Stirng holding the comment's content.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.1.3.8 Field likes

2.1.2.1.3.8.1 likes Tree Diagram

[...]

likes

{_id}

[0]*

2.1.2.1.3.8.2 likes Hierarchy

Parent field: author

Child field(s):

Field	Type	Req	Key	Description	Comments
[0]	objectId	false	fk	_id of the user who liked the comment

2.1.2.1.3.8.3 likes properties

Property	Value
Name	likes
Technical name
Id
Type	array
Description	Array holding the user_id of all the users who liked the comment.
Dependencies
Required	false
Primary key	false
Foreign collection	users
Foreign field	_id
Relationship type	Foreign Key
Min items
Max items
Unique items	true
Additional items	true
Comments

2.1.2.1.3.9 Field coordinates

2.1.2.1.3.9.1 coordinates Tree Diagram

{_id}

coordinates

2.1.2.1.3.9.2 coordinates properties

Property	Value
Id
Type	objectId
Description	_id of the user who liked the comment
Dependencies
Primary key	false
Foreign collection
Foreign field
Relationship type	Foreign Key
Default
Sample
Comments

2.1.2.1.4 comments Indexes

Property	New Index
Name	New Index
Key	createdAt('ascending'), parentId('ascending'), postId('ascending')
Hashed
Unique
Drop duplicates
Sparse
Background indexing
Partial filter exp
Expire after (seconds)
Storage engine	WiredTiger
Comments

2.1.2.1.5 comments JSON Schema

{
    "$schema": "http://json-schema.org/draft-04/schema#",
    "type": "object",
    "title": "comments",
    "additionalProperties": false,
    "properties": {
        "_id": {
            "type": "string",
            "description": "Automatically generated object_id as primary key.",
            "pattern": "^[a-fA-F0-9]{24}$"
        },
        "createdAt": {
            "type": "string",
            "description": "Timestamp with the comment's creation date",
            "format": "date-time"
        },
        "updatedAt": {
            "type": "string",
            "description": "Timestamp with the comment's last update date",
            "format": "date-time"
        },
        "author": {
            "$ref": "#model/definitions/author"
        },
        "postId": {
            "type": "string",
            "pattern": "^[a-fA-F0-9]{24}$"
        },
        "parentId": {
            "type": "string",
            "description": "If the comment is nested (in another comment), this field will hold the _id of the parent comment. Optional field, where being blank means it is a root comment.",
            "pattern": "^[a-fA-F0-9]{24}$"
        },
        "content": {
            "type": "string",
            "description": "Stirng holding the comment's content."
        },
        "likes": {
            "type": "array",
            "description": "Array holding the user_id of all the users who liked the comment.",
            "additionalItems": true,
            "uniqueItems": true,
            "items": {
                "type": "string",
                "description": "_id of the user who liked the comment",
                "pattern": "^[a-fA-F0-9]{24}$"
            }
        }
    },
    "required": [
        "_id",
        "createdAt",
        "updatedAt",
        "author",
        "postId",
        "content"
    ]
}

2.1.2.1.6 comments JSON data

{
    "_id": ObjectId("507f1f77bcf86cd799439011"),
    "createdAt": ISODate("2016-04-08T15:06:21.595Z"),
    "updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
    "author": {
        "id": ObjectId("507f1f77bcf86cd799439011"),
        "name": "Lorem",
        "type": "Lorem",
        "location": {
            "coordinates": [
                35.26,
                -32.83
            ],
            "type": "Point",
            "country": "Lorem",
            "city": "Lorem",
            "neighborhood": "Lorem",
            "address": "Lorem"
        }
    },
    "postId": ObjectId("507f1f77bcf86cd799439011"),
    "parentId": ObjectId("507f1f77bcf86cd799439011"),
    "content": "Lorem",
    "likes": [
        ObjectId("507f1f77bcf86cd799439011")
    ]
}

2.1.2.1.7 comments Target Script

use applicationDB;

db.createCollection( "comments",{
    "storageEngine": {
        "wiredTiger": {}
    },
    "capped": false,
    "validator": {
        "$jsonSchema": {
            "bsonType": "object",
            "title": "comments",
            "additionalProperties": false,
            "properties": {
                "_id": {
                    "bsonType": "objectId",
                    "description": "Automatically generated object_id as primary key."
                },
                "createdAt": {
                    "bsonType": "date",
                    "description": "Timestamp with the comment's creation date"
                },
                "updatedAt": {
                    "bsonType": "date",
                    "description": "Timestamp with the comment's last update date"
                },
                "author": {
                    "bsonType": "object",
                    "properties": {
                        "id": {
                            "bsonType": "objectId",
                            "description": "Foreign key to the user who created the post."
                        },
                        "name": {
                            "bsonType": "string"
                        },
                        "type": {
                            "bsonType": "string"
                        },
                        "location": {
                            "bsonType": "object",
                            "description": "Location document according to the norms of a [GeoJSON Object](https://docs.mongodb.com/manual/reference/geojson/ ).\nThe fields address, neighborhood, city, state and country are added to store the result of the geoprocessing.",
                            "properties": {
                                "coordinates": {
                                    "bsonType": "array",
                                    "description": "Array with the coordinates, specifying **longitude first** and **latitude second**, as default in the [GeoJSON](https://docs.mongodb.com/manual/reference/geojson/) definition.",
                                    "additionalItems": true,
                                    "minItems": 2,
                                    "maxItems": 2,
                                    "uniqueItems": false,
                                    "items": [
                                        {
                                            "bsonType": "number",
                                            "description": "Location longitude\n",
                                            "minimum": -180,
                                            "maximum": 180
                                        },
                                        {
                                            "bsonType": "number",
                                            "description": "Location latitude\n",
                                            "minimum": -90,
                                            "maximum": 90
                                        }
                                    ]
                                },
                                "type": {
                                    "bsonType": "string",
                                    "description": "Type of the GeoJSON Object.\nPlease refer to the [official documentation](https://docs.mongodb.com/manual/reference/geojson/ ) for more information.\n\n**In our case, the value will always be of the type \"Point\".**",
                                    "enum": [
                                        "Point"
                                    ]
                                },
                                "country": {
                                    "bsonType": "string",
                                    "description": "String holding the country's name.\n"
                                },
                                "city": {
                                    "bsonType": "string",
                                    "description": "String holding the city's name."
                                },
                                "neighborhood": {
                                    "bsonType": "string",
                                    "description": "String holding the neighborhood's name."
                                },
                                "address": {
                                    "bsonType": "string",
                                    "description": "String holding the address (street, number and other details)."
                                }
                            },
                            "additionalProperties": false,
                            "required": [
                                "coordinates",
                                "type"
                            ]
                        }
                    },
                    "additionalProperties": false,
                    "required": [
                        "id",
                        "name",
                        "type"
                    ]
                },
                "postId": {
                    "bsonType": "objectId"
                },
                "parentId": {
                    "bsonType": "objectId",
                    "description": "If the comment is nested (in another comment), this field will hold the _id of the parent comment. Optional field, where being blank means it is a root comment."
                },
                "content": {
                    "bsonType": "string",
                    "description": "Stirng holding the comment's content."
                },
                "likes": {
                    "bsonType": "array",
                    "description": "Array holding the user_id of all the users who liked the comment.",
                    "additionalItems": true,
                    "uniqueItems": true,
                    "items": {
                        "bsonType": "objectId",
                        "description": "_id of the user who liked the comment"
                    }
                }
            },
            "required": [
                "_id",
                "createdAt",
                "updatedAt",
                "author",
                "postId",
                "content"
            ]
        }
    },
    "validationLevel": "off",
    "validationAction": "warn"
});
db.comments.createIndex(
{
    "createdAt": 1,
    "parentId": 1,
    "postId": 1
},
{
    "name": "New Index"
}
);

2.1.2.2 Collection feedbacks

2.1.2.2.1 feedbacks Tree Diagram

feedbacks

{_id}

_id

{dt}

createdAt

{dt}

updatedAt

{123}

rating

{ABC}

ipAddress

{123}

age

{ABC}

mostValuableFeature

{ABC}

whatWouldChange

{ABC}

generalFeedback

{ABC}

covidImpact

{_id}

userId

location

ref:

location (m)

[...]

coordinates

{ABC}

type

{ABC}

country

{ABC}

city

{ABC}

neighborhood

{ABC}

address

{123}

[0]

{123}

[1]+

2.1.2.2.2 feedbacks Properties

Property	Value
Collection name	feedbacks
Technical name
Id
Description	Collection to hold feedback on the application. This may be done with the user logged or not and, depending on that, we may or may not have a reference to the user in question at this model.
Database	applicationDB
Capped	false
Size
Max
Storage engine	WiredTiger
Config String
Validation level	Off
Validation action	Warn
Additional properties	false
Comments

2.1.2.2.3 feedbacks Fields

Field	Type	Req	Key	Description	Comments
_id	objectId	true		Automatically generated object_id as primary key.
createdAt	date	true		Timestamp with the feedback's creation date
updatedAt	date	true		Timestamp with the feedback's last update date
rating	numeric	true		A rating, in a scale of 1 to 5, of the application. Currently present as: "How well does FIghtPandemics meet your needs?". Present in the first part of the feedback and, therefore, is required.
ipAddress	ipv4	true		Caputred IP address in order to get user's location even if they are not logged. Captured at the first part of the feedback and, therefore, is required.
age	integer64	false		User's age. Currently present as: "What is your age?". Present in the third part of the feedback and, therefore, not required.
mostValuableFeature	string	false		User's feedback into what is the features most valuable for him/her. Currently present as: "Which features are the most valuable for you?". Present in the second part of the feedback and, therefore, not required.
whatWouldChange	string	false		User's feedback into what he/she would change about the application. Currently present as: "If you could change one thing about FightPandemics, what would it be?". Present in the second part of the feedback and, therefore, not required.
generalFeedback	string	false		User's general feedback section. Currently present as: "Any other feedback for us?". Present in the second part of the feedback and, therefore, not required.
covidImpact	string	false		User's feedback into how the COVID impacted him. Currently present as a multiple choice question. Question: "How has COVID-19 impacted you?" Options: I go to work/school normally I am healthy but in a stay-at-home quarentine I have mild symptoms but haven't been tested I am diagnosed with COVID-19 Present in the second part of the feedback and, therefore, not required.
userId	objectId	false		Reference to the user's _id. This will be present only if the user was logged in when completing the feedback.
location	document	false		Location document according to the norms of a GeoJSON Object. The fields address, neighborhood, city, state and country are added to store the result of the geoprocessing.
coordinates	array	true		Array with the coordinates, specifying longitude first and latitude second, as default in the GeoJSON definition.
[0]	numeric	false		Location longitude
[1]	numeric	false		Location latitude
type	string	true		Type of the GeoJSON Object. Please refer to the official documentation for more information. In our case, the value will always be of the type "Point".
country	string	false		String holding the country's name.
city	string	false		String holding the city's name.
neighborhood	string	false		String holding the neighborhood's name.
address	string	false		String holding the address (street, number and other details).

2.1.2.2.3.1 Field createdAt

2.1.2.2.3.1.1 createdAt Tree Diagram

{dt}

createdAt

2.1.2.2.3.1.2 createdAt properties

Property	Value
Name	createdAt
Technical name
Id
Type	date
Description	Timestamp with the feedback's creation date
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Sample
Comments

2.1.2.2.3.2 Field _id

2.1.2.2.3.2.1 _id Tree Diagram

{_id}

_id

2.1.2.2.3.2.2 _id properties

Property	Value
Name	_id
Technical name
Id
Type	objectId
Description	Automatically generated object_id as primary key.
Dependencies
Required	true
Primary key	true
Foreign collection
Foreign field
Relationship type
Default
Sample
Comments

2.1.2.2.3.3 Field updatedAt

2.1.2.2.3.3.1 updatedAt Tree Diagram

{dt}

updatedAt

2.1.2.2.3.3.2 updatedAt properties

Property	Value
Name	updatedAt
Technical name
Id
Type	date
Description	Timestamp with the feedback's last update date
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Sample
Comments

2.1.2.2.3.4 Field rating

2.1.2.2.3.4.1 rating Tree Diagram

{123}

rating

2.1.2.2.3.4.2 rating properties

Property	Value
Name	rating
Technical name
Id
Type	numeric
Subtype
Description	A rating, in a scale of 1 to 5, of the application. Currently present as: "How well does FIghtPandemics meet your needs?". Present in the first part of the feedback and, therefore, is required.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Unit
Min value	1
Excl min	false
Max value	5
Excl max	false
Multiple of
Divisible by
Enum
Sample
Comments

2.1.2.2.3.5 Field ipAddress

2.1.2.2.3.5.1 ipAddress Tree Diagram

{ABC}

ipAddress

2.1.2.2.3.5.2 ipAddress properties

Property	Value
Name	ipAddress
Technical name
Id
Type	string
Description	Caputred IP address in order to get user's location even if they are not logged. Captured at the first part of the feedback and, therefore, is required.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format	ipv4
Enum
Sample
Comments

2.1.2.2.3.6 Field age

2.1.2.2.3.6.1 age Tree Diagram

{123}

age

2.1.2.2.3.6.2 age properties

Property	Value
Name	age
Technical name
Id
Type	numeric
Subtype	integer64
Description	User's age. Currently present as: "What is your age?". Present in the third part of the feedback and, therefore, not required.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Unit
Min value	18
Excl min	false
Max value
Excl max	false
Multiple of
Divisible by
Enum
Sample
Comments

2.1.2.2.3.7 Field mostValuableFeature

2.1.2.2.3.7.1 mostValuableFeature Tree Diagram

{ABC}

mostValuableFeature

2.1.2.2.3.7.2 mostValuableFeature properties

Property	Value
Name	mostValuableFeature
Technical name
Id
Type	string
Description	User's feedback into what is the features most valuable for him/her. Currently present as: "Which features are the most valuable for you?". Present in the second part of the feedback and, therefore, not required.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.2.3.8 Field whatWouldChange

2.1.2.2.3.8.1 whatWouldChange Tree Diagram

{ABC}

whatWouldChange

2.1.2.2.3.8.2 whatWouldChange properties

Property	Value
Name	whatWouldChange
Technical name
Id
Type	string
Description	User's feedback into what he/she would change about the application. Currently present as: "If you could change one thing about FightPandemics, what would it be?". Present in the second part of the feedback and, therefore, not required.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.2.3.9 Field generalFeedback

2.1.2.2.3.9.1 generalFeedback Tree Diagram

{ABC}

generalFeedback

2.1.2.2.3.9.2 generalFeedback properties

Property	Value
Name	generalFeedback
Technical name
Id
Type	string
Description	User's general feedback section. Currently present as: "Any other feedback for us?". Present in the second part of the feedback and, therefore, not required.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.2.3.10 Field covidImpact

2.1.2.2.3.10.1 covidImpact Tree Diagram

{ABC}

covidImpact

2.1.2.2.3.10.2 covidImpact properties

Property	Value
Name	covidImpact
Technical name
Id
Type	string
Description	User's feedback into how the COVID impacted him. Currently present as a multiple choice question. Question: "How has COVID-19 impacted you?" Options: I go to work/school normally I am healthy but in a stay-at-home quarentine I have mild symptoms but haven't been tested I am diagnosed with COVID-19 Present in the second part of the feedback and, therefore, not required.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.2.3.11 Field userId

2.1.2.2.3.11.1 userId Tree Diagram

{_id}

userId

2.1.2.2.3.11.2 userId properties

Property	Value
Name	userId
Technical name
Id
Type	objectId
Description	Reference to the user's _id. This will be present only if the user was logged in when completing the feedback.
Dependencies
Required	false
Primary key	false
Foreign collection	users
Foreign field	_id
Relationship type	Foreign Key
Default
Sample
Comments

2.1.2.2.3.12 Field location

2.1.2.2.3.12.1 location Tree Diagram

location

ref:

location (m)

2.1.2.2.3.12.2 location properties

Property	Value
Name	location
$ref	#model/definitions/location
Reference type	model

2.1.2.2.4 feedbacks JSON Schema

{
    "$schema": "http://json-schema.org/draft-04/schema#",
    "type": "object",
    "title": "feedbacks",
    "description": "Collection to hold feedback on the application.\n\nThis may be done with the user logged or not and, depending on that, we may or may not have a reference to the user in question at this model.",
    "additionalProperties": false,
    "properties": {
        "createdAt": {
            "type": "string",
            "description": "Timestamp with the feedback's creation date",
            "format": "date-time"
        },
        "_id": {
            "type": "string",
            "description": "Automatically generated object_id as primary key.",
            "pattern": "^[a-fA-F0-9]{24}$"
        },
        "updatedAt": {
            "type": "string",
            "description": "Timestamp with the feedback's last update date",
            "format": "date-time"
        },
        "rating": {
            "type": "number",
            "description": "A rating, in a scale of 1 to 5, of the application.\n\nCurrently present as: \"How well does FIghtPandemics meet your needs?\".\n\nPresent in the first part of the feedback and, therefore, is required.",
            "minimum": 1,
            "maximum": 5
        },
        "ipAddress": {
            "type": "string",
            "description": "Caputred IP address in order to get user's location even if they are not logged.\n\nCaptured at the first part of the feedback and, therefore, is required.",
            "format": "ipv4"
        },
        "age": {
            "type": "long",
            "description": "User's age.\n\nCurrently present as: \"What is your age?\".\n\nPresent in the third part of the feedback and, therefore, not required.",
            "minimum": 18
        },
        "mostValuableFeature": {
            "type": "string",
            "description": "User's feedback into what is the features most valuable for him/her.\n\nCurrently present as: \"Which features are the most valuable for you?\".\n\nPresent in the second part of the feedback and, therefore, not required."
        },
        "whatWouldChange": {
            "type": "string",
            "description": "User's feedback into what he/she would change about the application.\n\nCurrently present as: \"If you could change one thing about FightPandemics, what would it be?\".\n\nPresent in the second part of the feedback and, therefore, not required."
        },
        "generalFeedback": {
            "type": "string",
            "description": "User's general feedback section.\n\nCurrently present as: \"Any other feedback for us?\".\n\nPresent in the second part of the feedback and, therefore, not required."
        },
        "covidImpact": {
            "type": "string",
            "description": "User's feedback into how the COVID impacted him.\n\nCurrently present as a multiple choice question.\n\n**Question:** \"How has COVID-19 impacted you?\"\n\n**Options:** \n\n1. I go to work/school normally\n2. I am healthy but in a stay-at-home quarentine\n3. I have mild symptoms but haven't been tested\n4. I am diagnosed with COVID-19\n\n\nPresent in the second part of the feedback and, therefore, not required."
        },
        "userId": {
            "type": "string",
            "description": "Reference to the user's _id.\n\nThis will be present only if the user was logged in when completing the feedback.",
            "pattern": "^[a-fA-F0-9]{24}$"
        },
        "location": {
            "$ref": "#model/definitions/location"
        }
    },
    "required": [
        "createdAt",
        "_id",
        "updatedAt",
        "rating",
        "ipAddress"
    ]
}

2.1.2.2.5 feedbacks JSON data

{
    "createdAt": ISODate("2016-04-08T15:06:21.595Z"),
    "_id": ObjectId("507f1f77bcf86cd799439011"),
    "updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
    "rating": 1,
    "ipAddress": "192.168.0.1",
    "age": 8528994625872795000,
    "mostValuableFeature": "Lorem",
    "whatWouldChange": "Lorem",
    "generalFeedback": "Lorem",
    "covidImpact": "Lorem",
    "userId": ObjectId("507f1f77bcf86cd799439011"),
    "location": {
        "coordinates": [
            35.26,
            -32.83
        ],
        "type": "Point",
        "country": "Lorem",
        "city": "Lorem",
        "neighborhood": "Lorem",
        "address": "Lorem"
    }
}

2.1.2.2.6 feedbacks Target Script

use applicationDB;

db.createCollection( "feedbacks",{
    "storageEngine": {
        "wiredTiger": {}
    },
    "capped": false,
    "validator": {
        "$jsonSchema": {
            "bsonType": "object",
            "title": "feedbacks",
            "description": "Collection to hold feedback on the application.\n\nThis may be done with the user logged or not and, depending on that, we may or may not have a reference to the user in question at this model.",
            "additionalProperties": false,
            "properties": {
                "_id": {
                    "bsonType": "objectId",
                    "description": "Automatically generated object_id as primary key."
                },
                "createdAt": {
                    "bsonType": "date",
                    "description": "Timestamp with the feedback's creation date"
                },
                "updatedAt": {
                    "bsonType": "date",
                    "description": "Timestamp with the feedback's last update date"
                },
                "rating": {
                    "bsonType": "number",
                    "description": "A rating, in a scale of 1 to 5, of the application.\n\nCurrently present as: \"How well does FIghtPandemics meet your needs?\".\n\nPresent in the first part of the feedback and, therefore, is required.",
                    "minimum": 1,
                    "maximum": 5
                },
                "ipAddress": {
                    "bsonType": "string",
                    "description": "Caputred IP address in order to get user's location even if they are not logged.\n\nCaptured at the first part of the feedback and, therefore, is required."
                },
                "age": {
                    "bsonType": "long",
                    "description": "User's age.\n\nCurrently present as: \"What is your age?\".\n\nPresent in the third part of the feedback and, therefore, not required.",
                    "minimum": 18
                },
                "mostValuableFeature": {
                    "bsonType": "string",
                    "description": "User's feedback into what is the features most valuable for him/her.\n\nCurrently present as: \"Which features are the most valuable for you?\".\n\nPresent in the second part of the feedback and, therefore, not required."
                },
                "whatWouldChange": {
                    "bsonType": "string",
                    "description": "User's feedback into what he/she would change about the application.\n\nCurrently present as: \"If you could change one thing about FightPandemics, what would it be?\".\n\nPresent in the second part of the feedback and, therefore, not required."
                },
                "generalFeedback": {
                    "bsonType": "string",
                    "description": "User's general feedback section.\n\nCurrently present as: \"Any other feedback for us?\".\n\nPresent in the second part of the feedback and, therefore, not required."
                },
                "covidImpact": {
                    "bsonType": "string",
                    "description": "User's feedback into how the COVID impacted him.\n\nCurrently present as a multiple choice question.\n\n**Question:** \"How has COVID-19 impacted you?\"\n\n**Options:** \n\n1. I go to work/school normally\n2. I am healthy but in a stay-at-home quarentine\n3. I have mild symptoms but haven't been tested\n4. I am diagnosed with COVID-19\n\n\nPresent in the second part of the feedback and, therefore, not required."
                },
                "userId": {
                    "bsonType": "objectId",
                    "description": "Reference to the user's _id.\n\nThis will be present only if the user was logged in when completing the feedback."
                },
                "location": {
                    "bsonType": "object",
                    "description": "Location document according to the norms of a [GeoJSON Object](https://docs.mongodb.com/manual/reference/geojson/ ).\nThe fields address, neighborhood, city, state and country are added to store the result of the geoprocessing.",
                    "properties": {
                        "coordinates": {
                            "bsonType": "array",
                            "description": "Array with the coordinates, specifying **longitude first** and **latitude second**, as default in the [GeoJSON](https://docs.mongodb.com/manual/reference/geojson/) definition.",
                            "additionalItems": true,
                            "minItems": 2,
                            "maxItems": 2,
                            "uniqueItems": false,
                            "items": [
                                {
                                    "bsonType": "number",
                                    "description": "Location longitude\n",
                                    "minimum": -180,
                                    "maximum": 180
                                },
                                {
                                    "bsonType": "number",
                                    "description": "Location latitude\n",
                                    "minimum": -90,
                                    "maximum": 90
                                }
                            ]
                        },
                        "type": {
                            "bsonType": "string",
                            "description": "Type of the GeoJSON Object.\nPlease refer to the [official documentation](https://docs.mongodb.com/manual/reference/geojson/ ) for more information.\n\n**In our case, the value will always be of the type \"Point\".**",
                            "enum": [
                                "Point"
                            ]
                        },
                        "country": {
                            "bsonType": "string",
                            "description": "String holding the country's name.\n"
                        },
                        "city": {
                            "bsonType": "string",
                            "description": "String holding the city's name."
                        },
                        "neighborhood": {
                            "bsonType": "string",
                            "description": "String holding the neighborhood's name."
                        },
                        "address": {
                            "bsonType": "string",
                            "description": "String holding the address (street, number and other details)."
                        }
                    },
                    "additionalProperties": false,
                    "required": [
                        "coordinates",
                        "type"
                    ]
                }
            },
            "required": [
                "createdAt",
                "_id",
                "updatedAt",
                "rating",
                "ipAddress"
            ]
        }
    },
    "validationLevel": "off",
    "validationAction": "warn"
});

2.1.2.3 Collection posts

2.1.2.3.1 posts Tree Diagram

posts

{_id}

_id

{dt}

createdAt

{dt}

updatedAt

{dt}

expireAt

author

ref:

author (m)

{ABC}

title

{ABC}

content

{ABC}

objective

{ABC}

visibility

[...]

likes

[...]

types

[...]

language

{...}

externalLinks

{_id}

{ABC}

name

{ABC}

type

location

ref:

location (m)

{_id}

[0]*

{ABC}

[0]*

{ABC}

[0]*

{ABC}

website

{ABC}

playStore

{ABC}

appStore

[...]

coordinates

{ABC}

type

{ABC}

country

{ABC}

city

{ABC}

neighborhood

{ABC}

address

{123}

[0]

{123}

[1]+

2.1.2.3.2 posts Properties

Property	Value
Collection name	posts
Technical name
Id
Description	Document to represent a post, asking or offering help to be displayed on the feed
Database	applicationDB
Capped	false
Size
Max
Storage engine	WiredTiger
Config String
Validation level	Off
Validation action	Warn
Additional properties	false
Comments

2.1.2.3.3 posts Fields

Field	Type	Req	Key	Description	Comments
_id	objectId	true
createdAt	date	true		Timestamp with the post's creation date
updatedAt	date	true		Timestamp with the post's last update date
expireAt	date	false		Timestamp with the date the post will expire. If no expiration date is present, the post does not expire.
author	document	true
id	objectId	true		Foreign key to the user who created the post.
name	string	true
type	string	true
location	document	true		Location document according to the norms of a GeoJSON Object. The fields address, neighborhood, city, state and country are added to store the result of the geoprocessing.
coordinates	array	true		Array with the coordinates, specifying longitude first and latitude second, as default in the GeoJSON definition.
[0]	numeric	false		Location longitude
[1]	numeric	false		Location latitude
type	string	true		Type of the GeoJSON Object. Please refer to the official documentation for more information. In our case, the value will always be of the type "Point".
country	string	false		String holding the country's name.
city	string	false		String holding the city's name.
neighborhood	string	false		String holding the neighborhood's name.
address	string	false		String holding the address (street, number and other details).
title	string	true		The post title.
content	string	true		String for the post content.
objective	string	true		Field to indicate the post's objective. Currently only two values allowed: "offering help" and "looking for help".
visibility	string	true		Field to specify the post's visibility. It can be: worldwide, country, state and zipcode.
likes	array	true		Array holding the user_id of all the users who liked the post.
[0]	objectId	false		_id of the user who liked the post
types	array	false		Array with the post's tags. Can be: Medical Supplies, Groceries/Food, Business, Education, Legal, Wellbeing/Mental, Entertainment, Information, Funding, R&D and Others
[0]	string	false
language	array	false
[0]	string	false
externalLinks	document	false
email	string	false		An email related to the post's content.
website	string	false		Link for a website related to the post's content.
playStore	string	false		Link for a Play Store application related to the post's content.
appStore	string	false		Link for a AppStore application related to the post's content.

2.1.2.3.3.1 Field _id

2.1.2.3.3.1.1 _id Tree Diagram

{_id}

_id

2.1.2.3.3.1.2 _id properties

Property	Value
Name	_id
Technical name
Id
Type	objectId
Description
Dependencies
Required	true
Primary key	true
Foreign collection
Foreign field
Relationship type
Default
Sample
Comments

2.1.2.3.3.2 Field createdAt

2.1.2.3.3.2.1 createdAt Tree Diagram

{dt}

createdAt

2.1.2.3.3.2.2 createdAt properties

Property	Value
Name	createdAt
Technical name
Id
Type	date
Description	Timestamp with the post's creation date
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Sample
Comments

2.1.2.3.3.3 Field updatedAt

2.1.2.3.3.3.1 updatedAt Tree Diagram

{dt}

updatedAt

2.1.2.3.3.3.2 updatedAt properties

Property	Value
Name	updatedAt
Technical name
Id
Type	date
Description	Timestamp with the post's last update date
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Sample
Comments

2.1.2.3.3.4 Field expireAt

2.1.2.3.3.4.1 expireAt Tree Diagram

{dt}

expireAt

2.1.2.3.3.4.2 expireAt properties

Property	Value
Name	expireAt
Technical name
Id
Type	date
Description	Timestamp with the date the post will expire. If no expiration date is present, the post does not expire.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Sample
Comments

2.1.2.3.3.5 Field author

2.1.2.3.3.5.1 author Tree Diagram

author

ref:

author (m)

2.1.2.3.3.5.2 author properties

Property	Value
Name	author
$ref	#model/definitions/author
Reference type	model

2.1.2.3.3.6 Field title

2.1.2.3.3.6.1 title Tree Diagram

{ABC}

title

2.1.2.3.3.6.2 title properties

Property	Value
Name	title
Technical name
Id
Type	string
Description	The post title.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.3.3.7 Field content

2.1.2.3.3.7.1 content Tree Diagram

{ABC}

content

2.1.2.3.3.7.2 content properties

Property	Value
Name	content
Technical name
Id
Type	string
Description	String for the post content.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.3.3.8 Field objective

2.1.2.3.3.8.1 objective Tree Diagram

{ABC}

objective

2.1.2.3.3.8.2 objective properties

Property	Value
Name	objective
Technical name
Id
Type	string
Description	Field to indicate the post's objective. Currently only two values allowed: "offering help" and "looking for help".
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum	request,offer
Sample	offer
Comments

2.1.2.3.3.9 Field visibility

2.1.2.3.3.9.1 visibility Tree Diagram

{ABC}

visibility

2.1.2.3.3.9.2 visibility properties

Property	Value
Name	visibility
Technical name
Id
Type	string
Description	Field to specify the post's visibility. It can be: worldwide, country, state and zipcode.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum	zipcode,state,country,worldwide
Sample
Comments

2.1.2.3.3.10 Field likes

2.1.2.3.3.10.1 likes Tree Diagram

[...]

likes

{_id}

[0]*

2.1.2.3.3.10.2 likes Hierarchy

Parent field: location

Child field(s):

Field	Type	Req	Key	Description	Comments
[0]	objectId	false	fk	_id of the user who liked the post

2.1.2.3.3.10.3 likes properties

Property	Value
Name	likes
Technical name
Id
Type	array
Description	Array holding the user_id of all the users who liked the post.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Min items
Max items
Unique items	true
Additional items	true
Comments

2.1.2.3.3.11 Field [0]

2.1.2.3.3.11.1 [0] Tree Diagram

{_id}

[0]

2.1.2.3.3.11.2 [0] properties

Property	Value
Id
Type	objectId
Description	_id of the user who liked the post
Dependencies
Primary key	false
Foreign collection	users
Foreign field	_id
Relationship type	Foreign Key
Default
Sample
Comments

2.1.2.3.3.12 Field types

2.1.2.3.3.12.1 types Tree Diagram

[...]

types

{ABC}

[0]*

2.1.2.3.3.12.2 types Hierarchy

Parent field: coordinates

Child field(s):

Field	Type	Req	Key	Description	Comments
[0]	string	false

2.1.2.3.3.12.3 types properties

Property	Value
Name	types
Technical name
Id
Type	array
Description	Array with the post's tags. Can be: Medical Supplies, Groceries/Food, Business, Education, Legal, Wellbeing/Mental, Entertainment, Information, Funding, R&D and Others
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Min items
Max items
Unique items	false
Additional items	true
Comments

2.1.2.3.3.13 Field type

2.1.2.3.3.13.1 type Tree Diagram

{ABC}

type

2.1.2.3.3.13.2 type properties

Property	Value
Id
Type	string
Description
Dependencies
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum	Medical Supplies,Groceries/Food,Business,Education,Legal,Wellbeing/Mental,Entertainment,Information,Funding,R&D,Others
Sample	Groceries/Food
Comments

2.1.2.3.3.14 Field language

2.1.2.3.3.14.1 language Tree Diagram

[...]

language

{ABC}

[0]*

2.1.2.3.3.14.2 language Hierarchy

Parent field: location

Child field(s):

Field	Type	Req	Key	Description	Comments
[0]	string	false

2.1.2.3.3.14.3 language properties

Property	Value
Name	language
Technical name
Id
Type	array
Description
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Min items
Max items
Unique items	false
Additional items	true
Comments

2.1.2.3.3.15 Field city

2.1.2.3.3.15.1 city Tree Diagram

{ABC}

city

2.1.2.3.3.15.2 city properties

Property	Value
Id
Type	string
Description
Dependencies
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.3.3.16 Field externalLinks

2.1.2.3.3.16.1 externalLinks Tree Diagram

{...}

externalLinks

{ABC}

website

{ABC}

playStore

{ABC}

appStore

2.1.2.3.3.16.2 externalLinks Hierarchy

Parent field: location

Child field(s):

Field	Type	Req	Key	Description	Comments
email	string	false		An email related to the post's content.
website	string	false		Link for a website related to the post's content.
playStore	string	false		Link for a Play Store application related to the post's content.
appStore	string	false		Link for a AppStore application related to the post's content.

2.1.2.3.3.16.3 externalLinks properties

Property	Value
Name	externalLinks
Technical name
Id
Type	document
Description
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
DBRef
Min Properties
Max Properties
Additional properties	false
Comments

2.1.2.3.3.17 Field email

2.1.2.3.3.17.1 email Tree Diagram

{ABC}

2.1.2.3.3.17.2 email properties

Property	Value
Name	email
Technical name
Id
Type	string
Description	An email related to the post's content.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.3.3.18 Field website

2.1.2.3.3.18.1 website Tree Diagram

{ABC}

website

2.1.2.3.3.18.2 website properties

Property	Value
Name	website
Technical name
Id
Type	string
Description	Link for a website related to the post's content.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.3.3.19 Field playStore

2.1.2.3.3.19.1 playStore Tree Diagram

{ABC}

playStore

2.1.2.3.3.19.2 playStore properties

Property	Value
Name	playStore
Technical name
Id
Type	string
Description	Link for a Play Store application related to the post's content.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.3.3.20 Field appStore

2.1.2.3.3.20.1 appStore Tree Diagram

{ABC}

appStore

2.1.2.3.3.20.2 appStore properties

Property	Value
Name	appStore
Technical name
Id
Type	string
Description	Link for a AppStore application related to the post's content.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.3.4 posts JSON Schema

{
    "$schema": "http://json-schema.org/draft-04/schema#",
    "type": "object",
    "title": "posts",
    "description": "Document to represent a post, asking or offering help to be displayed on the feed",
    "additionalProperties": false,
    "properties": {
        "_id": {
            "type": "string",
            "pattern": "^[a-fA-F0-9]{24}$"
        },
        "createdAt": {
            "type": "string",
            "description": "Timestamp with the post's creation date",
            "format": "date-time"
        },
        "updatedAt": {
            "type": "string",
            "description": "Timestamp with the post's last update date",
            "format": "date-time"
        },
        "expireAt": {
            "type": "string",
            "description": "Timestamp with the date the post will expire.\nIf no expiration date is present, the post does not expire.",
            "format": "date-time"
        },
        "author": {
            "$ref": "#model/definitions/author"
        },
        "title": {
            "type": "string",
            "description": "The post title."
        },
        "content": {
            "type": "string",
            "description": "String for the post content."
        },
        "objective": {
            "type": "string",
            "description": "Field to indicate the post's objective.\nCurrently only two values allowed: \"offering help\" and \"looking for help\".",
            "enum": [
                "request",
                "offer"
            ]
        },
        "visibility": {
            "type": "string",
            "description": "Field to specify the post's visibility. It can be: worldwide, country, state and zipcode.",
            "enum": [
                "zipcode",
                "state",
                "country",
                "worldwide"
            ]
        },
        "likes": {
            "type": "array",
            "description": "Array holding the user_id of all the users who liked the post.",
            "additionalItems": true,
            "uniqueItems": true,
            "items": {
                "type": "string",
                "description": "_id of the user who liked the post",
                "pattern": "^[a-fA-F0-9]{24}$"
            }
        },
        "types": {
            "type": "array",
            "description": "Array with the post's tags.\nCan be: Medical Supplies, Groceries/Food, Business, Education, Legal, Wellbeing/Mental, Entertainment, Information, Funding, R&D and Others",
            "additionalItems": true,
            "uniqueItems": false,
            "items": {
                "type": "string",
                "enum": [
                    "Medical Supplies",
                    "Groceries/Food",
                    "Business",
                    "Education",
                    "Legal",
                    "Wellbeing/Mental",
                    "Entertainment",
                    "Information",
                    "Funding",
                    "R&D",
                    "Others"
                ]
            }
        },
        "language": {
            "type": "array",
            "additionalItems": true,
            "uniqueItems": false,
            "items": {
                "type": "string"
            }
        },
        "externalLinks": {
            "type": "object",
            "properties": {
                "email": {
                    "type": "string",
                    "description": "An email related to the post's content."
                },
                "website": {
                    "type": "string",
                    "description": "Link for a website related to the post's content."
                },
                "playStore": {
                    "type": "string",
                    "description": "Link for a Play Store application related to the post's content."
                },
                "appStore": {
                    "type": "string",
                    "description": "Link for a AppStore application related to the post's content."
                }
            },
            "additionalProperties": false
        }
    },
    "required": [
        "_id",
        "createdAt",
        "updatedAt",
        "author",
        "title",
        "content",
        "objective",
        "visibility",
        "likes"
    ]
}

2.1.2.3.5 posts JSON data

{
    "_id": ObjectId("507f1f77bcf86cd799439011"),
    "createdAt": ISODate("2016-04-08T15:06:21.595Z"),
    "updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
    "expireAt": ISODate("2016-04-08T15:06:21.595Z"),
    "author": {
        "id": ObjectId("507f1f77bcf86cd799439011"),
        "name": "Lorem",
        "type": "Lorem",
        "location": {
            "coordinates": [
                35.26,
                -32.83
            ],
            "type": "Point",
            "country": "Lorem",
            "city": "Lorem",
            "neighborhood": "Lorem",
            "address": "Lorem"
        }
    },
    "title": "Lorem",
    "content": "Lorem",
    "objective": "offer",
    "visibility": "worldwide",
    "likes": [
        ObjectId("507f1f77bcf86cd799439011")
    ],
    "types": [
        "Groceries/Food"
    ],
    "language": [
        "Lorem"
    ],
    "externalLinks": {
        "email": "Lorem",
        "website": "Lorem",
        "playStore": "Lorem",
        "appStore": "Lorem"
    }
}

2.1.2.3.6 posts Target Script

use applicationDB;

db.createCollection( "posts",{
    "storageEngine": {
        "wiredTiger": {}
    },
    "capped": false,
    "validator": {
        "$jsonSchema": {
            "bsonType": "object",
            "title": "posts",
            "description": "Document to represent a post, asking or offering help to be displayed on the feed",
            "additionalProperties": false,
            "properties": {
                "_id": {
                    "bsonType": "objectId"
                },
                "createdAt": {
                    "bsonType": "date",
                    "description": "Timestamp with the post's creation date"
                },
                "updatedAt": {
                    "bsonType": "date",
                    "description": "Timestamp with the post's last update date"
                },
                "expireAt": {
                    "bsonType": "date",
                    "description": "Timestamp with the date the post will expire.\nIf no expiration date is present, the post does not expire."
                },
                "author": {
                    "bsonType": "object",
                    "properties": {
                        "id": {
                            "bsonType": "objectId",
                            "description": "Foreign key to the user who created the post."
                        },
                        "name": {
                            "bsonType": "string"
                        },
                        "type": {
                            "bsonType": "string"
                        },
                        "location": {
                            "bsonType": "object",
                            "description": "Location document according to the norms of a [GeoJSON Object](https://docs.mongodb.com/manual/reference/geojson/ ).\nThe fields address, neighborhood, city, state and country are added to store the result of the geoprocessing.",
                            "properties": {
                                "coordinates": {
                                    "bsonType": "array",
                                    "description": "Array with the coordinates, specifying **longitude first** and **latitude second**, as default in the [GeoJSON](https://docs.mongodb.com/manual/reference/geojson/) definition.",
                                    "additionalItems": true,
                                    "minItems": 2,
                                    "maxItems": 2,
                                    "uniqueItems": false,
                                    "items": [
                                        {
                                            "bsonType": "number",
                                            "description": "Location longitude\n",
                                            "minimum": -180,
                                            "maximum": 180
                                        },
                                        {
                                            "bsonType": "number",
                                            "description": "Location latitude\n",
                                            "minimum": -90,
                                            "maximum": 90
                                        }
                                    ]
                                },
                                "type": {
                                    "bsonType": "string",
                                    "description": "Type of the GeoJSON Object.\nPlease refer to the [official documentation](https://docs.mongodb.com/manual/reference/geojson/ ) for more information.\n\n**In our case, the value will always be of the type \"Point\".**",
                                    "enum": [
                                        "Point"
                                    ]
                                },
                                "country": {
                                    "bsonType": "string",
                                    "description": "String holding the country's name.\n"
                                },
                                "city": {
                                    "bsonType": "string",
                                    "description": "String holding the city's name."
                                },
                                "neighborhood": {
                                    "bsonType": "string",
                                    "description": "String holding the neighborhood's name."
                                },
                                "address": {
                                    "bsonType": "string",
                                    "description": "String holding the address (street, number and other details)."
                                }
                            },
                            "additionalProperties": false,
                            "required": [
                                "coordinates",
                                "type"
                            ]
                        }
                    },
                    "additionalProperties": false,
                    "required": [
                        "id",
                        "name",
                        "type"
                    ]
                },
                "title": {
                    "bsonType": "string",
                    "description": "The post title."
                },
                "content": {
                    "bsonType": "string",
                    "description": "String for the post content."
                },
                "objective": {
                    "bsonType": "string",
                    "description": "Field to indicate the post's objective.\nCurrently only two values allowed: \"offering help\" and \"looking for help\".",
                    "enum": [
                        "request",
                        "offer"
                    ]
                },
                "visibility": {
                    "bsonType": "string",
                    "description": "Field to specify the post's visibility. It can be: worldwide, country, state and zipcode.",
                    "enum": [
                        "zipcode",
                        "state",
                        "country",
                        "worldwide"
                    ]
                },
                "likes": {
                    "bsonType": "array",
                    "description": "Array holding the user_id of all the users who liked the post.",
                    "additionalItems": true,
                    "uniqueItems": true,
                    "items": {
                        "bsonType": "objectId",
                        "description": "_id of the user who liked the post"
                    }
                },
                "types": {
                    "bsonType": "array",
                    "description": "Array with the post's tags.\nCan be: Medical Supplies, Groceries/Food, Business, Education, Legal, Wellbeing/Mental, Entertainment, Information, Funding, R&D and Others",
                    "additionalItems": true,
                    "uniqueItems": false,
                    "items": {
                        "bsonType": "string",
                        "enum": [
                            "Medical Supplies",
                            "Groceries/Food",
                            "Business",
                            "Education",
                            "Legal",
                            "Wellbeing/Mental",
                            "Entertainment",
                            "Information",
                            "Funding",
                            "R&D",
                            "Others"
                        ]
                    }
                },
                "language": {
                    "bsonType": "array",
                    "additionalItems": true,
                    "uniqueItems": false,
                    "items": {
                        "bsonType": "string"
                    }
                },
                "externalLinks": {
                    "bsonType": "object",
                    "properties": {
                        "email": {
                            "bsonType": "string",
                            "description": "An email related to the post's content."
                        },
                        "website": {
                            "bsonType": "string",
                            "description": "Link for a website related to the post's content."
                        },
                        "playStore": {
                            "bsonType": "string",
                            "description": "Link for a Play Store application related to the post's content."
                        },
                        "appStore": {
                            "bsonType": "string",
                            "description": "Link for a AppStore application related to the post's content."
                        }
                    },
                    "additionalProperties": false
                }
            },
            "required": [
                "_id",
                "createdAt",
                "updatedAt",
                "author",
                "title",
                "content",
                "objective",
                "visibility",
                "likes"
            ]
        }
    },
    "validationLevel": "off",
    "validationAction": "warn"
});

2.1.2.4 Collection users

2.1.2.4.1 users Tree Diagram

users

{_id}

_id

{dt}

createdAt

{dt}

updatedAt

{ABC}

authId

location

ref:

location (m)

{ABC}

about

{ABC}

photo

[...]

coordinates

{ABC}

type

{ABC}

country

{ABC}

city

{ABC}

neighborhood

{ABC}

address

{Sub}

[0]

{Sub}

[1]

{Sub}

[0]

{Sub}

[1]

{123}

[0]

{123}

[1]+

{ABC}

type

{ABC}

firstName

{ABC}

lastName

{...}

needs

{...}

objectives

{...}

urls

{ABC}

type

{ABC}

industry

{_id}

ownerId

{ABC}

name

{...}

needs

{0/1}

global

{...}

urls

{ABC}

language

{ABC}

phone

{0/1}

medicalHelp

{0/1}

otherHelp

{0/1}

volunteer

{0/1}

donate

{0/1}

shareInformation

{ABC}

facebook

{ABC}

twitter

{ABC}

github

{ABC}

website

{0/1}

volunteers

{0/1}

donations

{0/1}

staff

{0/1}

other

{ABC}

twitter

{ABC}

website

{ABC}

playstore

{ABC}

appstore

2.1.2.4.2 users Properties

Property	Value
Collection name	users
Technical name
Id
Description	Collection that holds all the data on system's users. The users can be of two types: (1) Individual, representing a private user account; and (2) Organization, representing an organization of various types. The field 'type' is used to differentiate between the two subschemas, with 'individual' representing private user accounts and "Community", "Government", "Health care provider", "Non-profit", "Other", "R&D", "Startup", "Traditional Company" and "University".
Database	applicationDB
Capped	false
Size
Max
Storage engine	WiredTiger
Config String
Validation level	Off
Validation action	Warn
Additional properties	true
Comments

2.1.2.4.3 users Fields

Field	Type	Req	Key	Description	Comments
_id	objectId	true		Automatically generated _it as primary key.
createdAt	date	true		Timestamp with the user's creation date	Thu Apr 16 2020 04:59:24 GMT-0300 (Horário Padrão de Brasília): changed the name to registeredAt
updatedAt	date	true		Timestamp indicating last update on the database.
authId	string	true		String holding the authentication service id (Auth0). This field is a foreign key to the user in the Auth0 database, connecting through the user_id field.
location	document	false		Location document according to the norms of a GeoJSON Object. The fields address, neighborhood, city, state and country are added to store the result of the geoprocessing.
coordinates	array	true		Array with the coordinates, specifying longitude first and latitude second, as default in the GeoJSON definition.
[0]	numeric	false		Location longitude
[1]	numeric	false		Location latitude
type	string	true		Type of the GeoJSON Object. Please refer to the official documentation for more information. In our case, the value will always be of the type "Point".
country	string	false		String holding the country's name.
city	string	false		String holding the city's name.
neighborhood	string	false		String holding the neighborhood's name.
address	string	false		String holding the address (street, number and other details).
about	string	false		Small self-introduction, limited to 100 char
photo	uri	false		URI with the location of the profile's photo.
oneOf	choice	false
subschema	subschema	false		Subschema representing a individual account.
type	string	true
firstName	string	true		The first name of the user
lastName	string	false		The last name of the user. Optional field.
needs	document	true		User's need in the app, representing what kind of help he/she needs
medicalHelp	boolean	true		Flag to indicate wheter the user needs medical help. Marking this indicates he shows symptoms of COVID-19.
otherHelp	boolean	true		Flag to indicate wheter the user needs non-medical help, such as getting groceries, medice and etc..
objectives	document	false		Document with what are the objectives of the user through the application, such as donating, volunteering or sharing information.
volunteer	boolean	true		Flag to indicate wheter the user wants to volunteer for iniciatives through the app.
donate	boolean	true		Flag to indicate wheter the user wants to donate for iniciatives through the app.
shareInformation	boolean	true		Flag to indicate wheter the user wants to share information through the app.
urls	document	false		Document holding the user urls to external websites and social networks
facebook	uri	false		URL to user's Facebook page.
linkedin	uri	false		URL to user's Linkedin page.
twitter	uri	false		URL to user's Twitter page.
github	uri	false		URL to user's Github page.
website	uri	false		URL to user's personal website.
subschema	subschema	false		Subschema representing an organization (colective) account.
type	string	true		The type of the organization. Can be: Community, Government, Health care provider, Non-profit, Other, R&D, Startup, Traditional Company and University. All names are store in lowercase only.
industry	string	true		Industry from which the organization participates. Plan is for this values to be scraped from linkedin industries.
ownerId	objectId	true		_id of the user who owns the organization.
name	string	true		Organization's name.
needs	document	true		Document with what are the objectives of the organization through the application, such as finding volunteers, staff, investors and donors.
volunteers	boolean	true		Flag to indicate wheter the organization is seeking volunteers through the app.
donations	boolean	true		Flag to indicate wheter the organization is seeking donations through the app.
staff	boolean	true		Flag to indicate wheter the organization is seeking staff through the app.
other	boolean	true		Flag to indicate wheter the organization is seeking other needs through the app.
global	boolean	false		Flag to indicate wheter this organization is global.
urls	document	false		Document holding external urls and refs to the organization such as social media profiles.
linkedin	uri	false		URL to organization's Linkedin page.
twitter	uri	false		URL to organization's Twitter page.
website	uri	false		URL to organization's website.
playstore	uri	false		URL to organization's page at Google Play Store.
appstore	uri	false		URL to organization's page at Apple App Store
language	string	false		Field to inidicate the language used by the organization.
anyOf	choice	false
subschema	subschema	false		Case where the user comes from social networks with a registration that uses email. In this case, the email field is required. This case covers the great majority of currently supported social network authentications.
email	email	true		User's email validated by a regex pattern.
subschema	subschema	false		Case where the user comes from social networks with a registration that allows the use of only the phone. In this case, the phone field is required, and the email isn't. An example of ocial network that falls into this case is Twitter.
phone	string	true

2.1.2.4.3.1 Field createdAt

2.1.2.4.3.1.1 createdAt Tree Diagram

{dt}

createdAt

2.1.2.4.3.1.2 createdAt properties

Property	Value
Name	createdAt
Technical name
Id
Type	date
Description	Timestamp with the user's creation date
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Sample
Comments	Thu Apr 16 2020 04:59:24 GMT-0300 (Horário Padrão de Brasília): changed the name to registeredAt

2.1.2.4.3.2 Field _id

2.1.2.4.3.2.1 _id Tree Diagram

{_id}

_id

2.1.2.4.3.2.2 _id properties

Property	Value
Name	_id
Technical name
Id
Type	objectId
Description	Automatically generated _it as primary key.
Dependencies
Required	true
Primary key	true
Foreign collection
Foreign field
Relationship type
Default
Sample
Comments

2.1.2.4.3.3 Field updatedAt

2.1.2.4.3.3.1 updatedAt Tree Diagram

{dt}

updatedAt

2.1.2.4.3.3.2 updatedAt properties

Property	Value
Name	updatedAt
Technical name
Id
Type	date
Description	Timestamp indicating last update on the database.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Sample
Comments

2.1.2.4.3.4 Field authId

2.1.2.4.3.4.1 authId Tree Diagram

{ABC}

authId

2.1.2.4.3.4.2 authId properties

Property	Value
Name	authId
Technical name
Id
Type	string
Description	String holding the authentication service id (Auth0). This field is a foreign key to the user in the Auth0 database, connecting through the user_id field.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.4.3.5 Field location

2.1.2.4.3.5.1 location Tree Diagram

location

ref:

location (m)

2.1.2.4.3.5.2 location properties

Property	Value
Name	location
$ref	#model/definitions/location
Reference type	model

2.1.2.4.3.6 Field about

2.1.2.4.3.6.1 about Tree Diagram

{ABC}

about

2.1.2.4.3.6.2 about properties

Property	Value
Name	about
Technical name
Id
Type	string
Description	Small self-introduction, limited to 100 char
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.4.3.7 Field photo

2.1.2.4.3.7.1 photo Tree Diagram

{ABC}

photo

2.1.2.4.3.7.2 photo properties

Property	Value
Name	photo
Technical name
Id
Type	string
Description	URI with the location of the profile's photo.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format	uri
Enum
Sample
Comments

2.1.2.4.3.8 Field oneOf

2.1.2.4.3.8.1 oneOf Tree Diagram

{Sub}

[0]

{Sub}

[1]

2.1.2.4.3.8.2 oneOf Hierarchy

Parent field: coordinates

Child field(s):

Field	Type	Req	Key	Description	Comments
subschema	subschema	false		Subschema representing a individual account.
subschema	subschema	false		Subschema representing an organization (colective) account.

2.1.2.4.3.8.3 oneOf properties

Property	Value
Choice	oneOf

2.1.2.4.3.9 Field [1]

2.1.2.4.3.9.1 [1] Tree Diagram

{Sub}

[subschema]

{ABC}

type

{ABC}

firstName

{ABC}

lastName

{...}

needs

{...}

objectives

{...}

urls

2.1.2.4.3.9.2 [1] Hierarchy

Parent field: location

Child field(s):

Field	Type	Req	Key	Description	Comments
type	string	true
firstName	string	true		The first name of the user
lastName	string	false		The last name of the user. Optional field.
needs	document	true		User's need in the app, representing what kind of help he/she needs
objectives	document	false		Document with what are the objectives of the user through the application, such as donating, volunteering or sharing information.
urls	document	false		Document holding the user urls to external websites and social networks

2.1.2.4.3.9.3 [1] properties

Property	Value
Id	individual
Description	Subschema representing a individual account.
Required
Min Properties
Max Properties
Additional properties	true
Comments

2.1.2.4.3.10 Field type

2.1.2.4.3.10.1 type Tree Diagram

{ABC}

type

2.1.2.4.3.10.2 type properties

Property	Value
Name	type
Technical name
Id
Type	string
Description
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum	individual
Sample
Comments

2.1.2.4.3.11 Field firstName

2.1.2.4.3.11.1 firstName Tree Diagram

{ABC}

firstName

2.1.2.4.3.11.2 firstName properties

Property	Value
Name	firstName
Technical name
Id
Type	string
Description	The first name of the user
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.4.3.12 Field lastName

2.1.2.4.3.12.1 lastName Tree Diagram

{ABC}

lastName

2.1.2.4.3.12.2 lastName properties

Property	Value
Name	lastName
Technical name
Id
Type	string
Description	The last name of the user. Optional field.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.4.3.13 Field needs

2.1.2.4.3.13.1 needs Tree Diagram

{...}

needs

{0/1}

medicalHelp

{0/1}

otherHelp

2.1.2.4.3.13.2 needs Hierarchy

Parent field: location

Child field(s):

Field	Type	Req	Key	Description	Comments
medicalHelp	boolean	true		Flag to indicate wheter the user needs medical help. Marking this indicates he shows symptoms of COVID-19.
otherHelp	boolean	true		Flag to indicate wheter the user needs non-medical help, such as getting groceries, medice and etc..

2.1.2.4.3.13.3 needs properties

Property	Value
Name	needs
Technical name
Id
Type	document
Description	User's need in the app, representing what kind of help he/she needs
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
DBRef
Min Properties
Max Properties
Additional properties	false
Comments

2.1.2.4.3.14 Field medicalHelp

2.1.2.4.3.14.1 medicalHelp Tree Diagram

{0/1}

medicalHelp

2.1.2.4.3.14.2 medicalHelp properties

Property	Value
Name	medicalHelp
Technical name
Id
Type	boolean
Description	Flag to indicate wheter the user needs medical help. Marking this indicates he shows symptoms of COVID-19.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default	false
Sample	false
Comments

2.1.2.4.3.15 Field otherHelp

2.1.2.4.3.15.1 otherHelp Tree Diagram

{0/1}

otherHelp

2.1.2.4.3.15.2 otherHelp properties

Property	Value
Name	otherHelp
Technical name
Id
Type	boolean
Description	Flag to indicate wheter the user needs non-medical help, such as getting groceries, medice and etc..
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default	false
Sample	false
Comments

2.1.2.4.3.16 Field objectives

2.1.2.4.3.16.1 objectives Tree Diagram

{...}

objectives

{0/1}

volunteer

{0/1}

donate

{0/1}

shareInformation

2.1.2.4.3.16.2 objectives Hierarchy

Parent field: users

Child field(s):

Field	Type	Req	Key	Description	Comments
volunteer	boolean	true		Flag to indicate wheter the user wants to volunteer for iniciatives through the app.
donate	boolean	true		Flag to indicate wheter the user wants to donate for iniciatives through the app.
shareInformation	boolean	true		Flag to indicate wheter the user wants to share information through the app.

2.1.2.4.3.16.3 objectives properties

Property	Value
Name	objectives
Technical name
Id
Type	document
Description	Document with what are the objectives of the user through the application, such as donating, volunteering or sharing information.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
DBRef
Min Properties
Max Properties
Additional properties	false
Comments

2.1.2.4.3.17 Field volunteer

2.1.2.4.3.17.1 volunteer Tree Diagram

{0/1}

volunteer

2.1.2.4.3.17.2 volunteer properties

Property	Value
Name	volunteer
Technical name
Id
Type	boolean
Description	Flag to indicate wheter the user wants to volunteer for iniciatives through the app.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default	false
Sample	false
Comments

2.1.2.4.3.18 Field donate

2.1.2.4.3.18.1 donate Tree Diagram

{0/1}

donate

2.1.2.4.3.18.2 donate properties

Property	Value
Name	donate
Technical name
Id
Type	boolean
Description	Flag to indicate wheter the user wants to donate for iniciatives through the app.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default	false
Sample	false
Comments

2.1.2.4.3.19 Field shareInformation

2.1.2.4.3.19.1 shareInformation Tree Diagram

{0/1}

shareInformation

2.1.2.4.3.19.2 shareInformation properties

Property	Value
Name	shareInformation
Technical name
Id
Type	boolean
Description	Flag to indicate wheter the user wants to share information through the app.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default	true
Sample	true
Comments

2.1.2.4.3.20 Field urls

2.1.2.4.3.20.1 urls Tree Diagram

{...}

urls

{ABC}

facebook

{ABC}

twitter

{ABC}

github

{ABC}

website

2.1.2.4.3.20.2 urls Hierarchy

Parent field: subschema

Child field(s):

Field	Type	Req	Key	Description	Comments
facebook	string	false		URL to user's Facebook page.
linkedin	string	false		URL to user's Linkedin page.
twitter	string	false		URL to user's Twitter page.
github	string	false		URL to user's Github page.
website	string	false		URL to user's personal website.

2.1.2.4.3.20.3 urls properties

Property	Value
Name	urls
Technical name
Id
Type	document
Description	Document holding the user urls to external websites and social networks
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
DBRef
Min Properties
Max Properties
Additional properties	false
Comments

2.1.2.4.3.21 Field facebook

2.1.2.4.3.21.1 facebook Tree Diagram

{ABC}

facebook

2.1.2.4.3.21.2 facebook properties

Property	Value
Name	facebook
Technical name
Id
Type	string
Description	URL to user's Facebook page.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format	uri
Enum
Sample	http://facebook.com/myProfile
Comments

2.1.2.4.3.22 Field linkedin

2.1.2.4.3.22.1 linkedin Tree Diagram

{ABC}

2.1.2.4.3.22.2 linkedin properties

Property	Value
Name	linkedin
Technical name
Id
Type	string
Description	URL to user's Linkedin page.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format	uri
Enum
Sample	http://linkedin.com/in/myProfile
Comments

2.1.2.4.3.23 Field twitter

2.1.2.4.3.23.1 twitter Tree Diagram

{ABC}

twitter

2.1.2.4.3.23.2 twitter properties

Property	Value
Name	twitter
Technical name
Id
Type	string
Description	URL to user's Twitter page.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format	uri
Enum
Sample	http://twitter.com/myProfile
Comments

2.1.2.4.3.24 Field github

2.1.2.4.3.24.1 github Tree Diagram

{ABC}

github

2.1.2.4.3.24.2 github properties

Property	Value
Name	github
Technical name
Id
Type	string
Description	URL to user's Github page.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format	uri
Enum
Sample	http://github.com/myProfile
Comments

2.1.2.4.3.25 Field website

2.1.2.4.3.25.1 website Tree Diagram

{ABC}

website

2.1.2.4.3.25.2 website properties

Property	Value
Name	website
Technical name
Id
Type	string
Description	URL to user's personal website.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format	uri
Enum
Sample	http://mypersonalwebsite.com
Comments

2.1.2.4.3.26 Field [1]

2.1.2.4.3.26.1 [1] Tree Diagram

{Sub}

[subschema]

{ABC}

type

{ABC}

industry

{_id}

ownerId

{ABC}

name

{...}

needs

{0/1}

global

{...}

urls

{ABC}

language

2.1.2.4.3.26.2 [1] Hierarchy

Parent field: objectives

Child field(s):

Field	Type	Req	Key	Description	Comments
type	string	true		The type of the organization. Can be: Community, Government, Health care provider, Non-profit, Other, R&D, Startup, Traditional Company and University. All names are store in lowercase only.
industry	string	true		Industry from which the organization participates. Plan is for this values to be scraped from linkedin industries.
ownerId	objectId	true	fk	_id of the user who owns the organization.
name	string	true		Organization's name.
needs	document	true		Document with what are the objectives of the organization through the application, such as finding volunteers, staff, investors and donors.
global	boolean	false		Flag to indicate wheter this organization is global.
urls	document	false		Document holding external urls and refs to the organization such as social media profiles.
language	string	false		Field to inidicate the language used by the organization.

2.1.2.4.3.26.3 [1] properties

Property	Value
Id	organization
Description	Subschema representing an organization (colective) account.
Required
Min Properties
Max Properties
Additional properties	false
Comments

2.1.2.4.3.27 Field type

2.1.2.4.3.27.1 type Tree Diagram

{ABC}

type

2.1.2.4.3.27.2 type properties

Property	Value
Name	type
Technical name
Id
Type	string
Description	The type of the organization. Can be: Community, Government, Health care provider, Non-profit, Other, R&D, Startup, Traditional Company and University. All names are store in lowercase only.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum	startup,traditional company,community,government,r&d,non-profit,university,health care provider,other
Sample
Comments

2.1.2.4.3.28 Field industry

2.1.2.4.3.28.1 industry Tree Diagram

{ABC}

industry

2.1.2.4.3.28.2 industry properties

Property	Value
Name	industry
Technical name
Id
Type	string
Description	Industry from which the organization participates. Plan is for this values to be scraped from linkedin industries.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.4.3.29 Field ownerId

2.1.2.4.3.29.1 ownerId Tree Diagram

{_id}

ownerId

2.1.2.4.3.29.2 ownerId properties

Property	Value
Name	ownerId
Technical name
Id
Type	objectId
Description	_id of the user who owns the organization.
Dependencies
Required	true
Primary key	false
Foreign collection	users
Foreign field	_id
Relationship type	Foreign Key
Default
Sample
Comments

2.1.2.4.3.30 Field name

2.1.2.4.3.30.1 name Tree Diagram

{ABC}

name

2.1.2.4.3.30.2 name properties

Property	Value
Name	name
Technical name
Id
Type	string
Description	Organization's name.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.4.3.31 Field needs

2.1.2.4.3.31.1 needs Tree Diagram

{...}

needs

{0/1}

volunteers

{0/1}

donations

{0/1}

staff

{0/1}

other

2.1.2.4.3.31.2 needs Hierarchy

Parent field: urls

Child field(s):

Field	Type	Req	Key	Description	Comments
volunteers	boolean	true		Flag to indicate wheter the organization is seeking volunteers through the app.
donations	boolean	true		Flag to indicate wheter the organization is seeking donations through the app.
staff	boolean	true		Flag to indicate wheter the organization is seeking staff through the app.
other	boolean	true		Flag to indicate wheter the organization is seeking other needs through the app.

2.1.2.4.3.31.3 needs properties

Property	Value
Name	needs
Technical name
Id
Type	document
Description	Document with what are the objectives of the organization through the application, such as finding volunteers, staff, investors and donors.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
DBRef
Min Properties
Max Properties
Additional properties	false
Comments

2.1.2.4.3.32 Field volunteers

2.1.2.4.3.32.1 volunteers Tree Diagram

{0/1}

volunteers

2.1.2.4.3.32.2 volunteers properties

Property	Value
Name	volunteers
Technical name
Id
Type	boolean
Description	Flag to indicate wheter the organization is seeking volunteers through the app.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default	false
Sample	true
Comments

2.1.2.4.3.33 Field donations

2.1.2.4.3.33.1 donations Tree Diagram

{0/1}

donations

2.1.2.4.3.33.2 donations properties

Property	Value
Name	donations
Technical name
Id
Type	boolean
Description	Flag to indicate wheter the organization is seeking donations through the app.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default	false
Sample	false
Comments

2.1.2.4.3.34 Field staff

2.1.2.4.3.34.1 staff Tree Diagram

{0/1}

staff

2.1.2.4.3.34.2 staff properties

Property	Value
Name	staff
Technical name
Id
Type	boolean
Description	Flag to indicate wheter the organization is seeking staff through the app.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default	false
Sample	false
Comments

2.1.2.4.3.35 Field other

2.1.2.4.3.35.1 other Tree Diagram

{0/1}

other

2.1.2.4.3.35.2 other properties

Property	Value
Name	other
Technical name
Id
Type	boolean
Description	Flag to indicate wheter the organization is seeking other needs through the app.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default	false
Sample	false
Comments

2.1.2.4.3.36 Field global

2.1.2.4.3.36.1 global Tree Diagram

{0/1}

global

2.1.2.4.3.36.2 global properties

Property	Value
Name	global
Technical name
Id
Type	boolean
Description	Flag to indicate wheter this organization is global.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default	false
Sample
Comments

2.1.2.4.3.37 Field urls

2.1.2.4.3.37.1 urls Tree Diagram

{...}

urls

{ABC}

twitter

{ABC}

website

{ABC}

playstore

{ABC}

appstore

2.1.2.4.3.37.2 urls Hierarchy

Parent field: subschema

Child field(s):

Field	Type	Req	Key	Description	Comments
linkedin	string	false		URL to organization's Linkedin page.
twitter	string	false		URL to organization's Twitter page.
website	string	false		URL to organization's website.
playstore	string	false		URL to organization's page at Google Play Store.
appstore	string	false		URL to organization's page at Apple App Store

2.1.2.4.3.37.3 urls properties

Property	Value
Name	urls
Technical name
Id
Type	document
Description	Document holding external urls and refs to the organization such as social media profiles.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
DBRef
Min Properties
Max Properties
Additional properties	false
Comments

2.1.2.4.3.38 Field linkedin

2.1.2.4.3.38.1 linkedin Tree Diagram

{ABC}

2.1.2.4.3.38.2 linkedin properties

Property	Value
Name	linkedin
Technical name
Id
Type	string
Description	URL to organization's Linkedin page.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format	uri
Enum
Sample	http://linkedin.com/in/myProfile
Comments

2.1.2.4.3.39 Field twitter

2.1.2.4.3.39.1 twitter Tree Diagram

{ABC}

twitter

2.1.2.4.3.39.2 twitter properties

Property	Value
Name	twitter
Technical name
Id
Type	string
Description	URL to organization's Twitter page.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format	uri
Enum
Sample	http://twitter.com/myProfile
Comments

2.1.2.4.3.40 Field website

2.1.2.4.3.40.1 website Tree Diagram

{ABC}

website

2.1.2.4.3.40.2 website properties

Property	Value
Name	website
Technical name
Id
Type	string
Description	URL to organization's website.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format	uri
Enum
Sample	http://mypersonalwebsite.com
Comments

2.1.2.4.3.41 Field playstore

2.1.2.4.3.41.1 playstore Tree Diagram

{ABC}

playstore

2.1.2.4.3.41.2 playstore properties

Property	Value
Name	playstore
Technical name
Id
Type	string
Description	URL to organization's page at Google Play Store.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format	uri
Enum
Sample	http://playstore.com/myOrg
Comments

2.1.2.4.3.42 Field appstore

2.1.2.4.3.42.1 appstore Tree Diagram

{ABC}

appstore

2.1.2.4.3.42.2 appstore properties

Property	Value
Name	appstore
Technical name
Id
Type	string
Description	URL to organization's page at Apple App Store
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format	uri
Enum
Sample	http://appstore.com/myOrg
Comments

2.1.2.4.3.43 Field language

2.1.2.4.3.43.1 language Tree Diagram

{ABC}

language

2.1.2.4.3.43.2 language properties

Property	Value
Name	language
Technical name
Id
Type	string
Description	Field to inidicate the language used by the organization.
Dependencies
Required	false
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.4.3.44 Field anyOf

2.1.2.4.3.44.1 anyOf Tree Diagram

{Sub}

[0]

{Sub}

[1]

2.1.2.4.3.44.2 anyOf Hierarchy

Parent field: subschema

Child field(s):

Field	Type	Req	Key	Description	Comments
subschema	subschema	false		Case where the user comes from social networks with a registration that uses email. In this case, the email field is required. This case covers the great majority of currently supported social network authentications.
subschema	subschema	false		Case where the user comes from social networks with a registration that allows the use of only the phone. In this case, the phone field is required, and the email isn't. An example of ocial network that falls into this case is Twitter.

2.1.2.4.3.44.3 anyOf properties

Property	Value
Choice	anyOf

2.1.2.4.3.45 Field [6]

2.1.2.4.3.45.1 [6] Tree Diagram

{Sub}

[subschema]

{ABC}

2.1.2.4.3.45.2 [6] Hierarchy

Parent field: subschema

Child field(s):

Field	Type	Req	Key	Description	Comments
email	string	true		User's email validated by a regex pattern.

2.1.2.4.3.45.3 [6] properties

Property	Value
Id	emailPK
Description	Case where the user comes from social networks with a registration that uses email. In this case, the email field is required. This case covers the great majority of currently supported social network authentications.
Required
Min Properties
Max Properties
Additional properties	true
Comments

2.1.2.4.3.46 Field email

2.1.2.4.3.46.1 email Tree Diagram

{ABC}

2.1.2.4.3.46.2 email properties

Property	Value
Name	email
Technical name
Id
Type	string
Description	User's email validated by a regex pattern.
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format	email
Enum
Sample	test_user@fightpandemics.com
Comments

2.1.2.4.3.47 Field [1]

2.1.2.4.3.47.1 [1] Tree Diagram

{Sub}

[subschema]

{ABC}

phone

2.1.2.4.3.47.2 [1] Hierarchy

Parent field: urls

Child field(s):

Field	Type	Req	Key	Description	Comments
phone	string	true

2.1.2.4.3.47.3 [1] properties

Property	Value
Id	phonePK
Description	Case where the user comes from social networks with a registration that allows the use of only the phone. In this case, the phone field is required, and the email isn't. An example of ocial network that falls into this case is Twitter.
Required
Min Properties
Max Properties
Additional properties	false
Comments

2.1.2.4.3.48 Field phone

2.1.2.4.3.48.1 phone Tree Diagram

{ABC}

phone

2.1.2.4.3.48.2 phone properties

Property	Value
Name	phone
Technical name
Id
Type	string
Description
Dependencies
Required	true
Primary key	false
Foreign collection
Foreign field
Relationship type
Default
Min length
Max length
Pattern
Format
Enum
Sample
Comments

2.1.2.4.4 users JSON Schema

{
    "$schema": "http://json-schema.org/draft-04/schema#",
    "type": "object",
    "title": "users",
    "description": "Collection that holds all the data on system's users. \n\nThe users can be of **two types**: **(1) Individual**, representing a private user account; and **(2) Organization**, representing an organization of various types.\n\nThe field 'type' is used to differentiate between the two subschemas, with 'individual' representing private user accounts and \"Community\", \"Government\", \"Health care provider\", \"Non-profit\", \"Other\", \"R&D\", \"Startup\", \"Traditional Company\" and \"University\".",
    "additionalProperties": true,
    "properties": {
        "createdAt": {
            "type": "string",
            "description": "Timestamp with the user's creation date",
            "format": "date-time"
        },
        "_id": {
            "type": "string",
            "description": "Automatically generated _it as primary key.",
            "pattern": "^[a-fA-F0-9]{24}$"
        },
        "updatedAt": {
            "type": "string",
            "description": "Timestamp indicating last update on the database.",
            "format": "date-time"
        },
        "authId": {
            "type": "string",
            "description": "String holding the authentication service id (Auth0).\n\nThis field is a **foreign key to the user in the Auth0 database**, connecting through the user_id field."
        },
        "location": {
            "$ref": "#model/definitions/location"
        },
        "about": {
            "type": "string",
            "description": "Small self-introduction, limited to 100 char"
        },
        "photo": {
            "type": "string",
            "description": "URI with the location of the profile's photo.",
            "format": "uri"
        }
    },
    "oneOf": [
        {
            "id": "individual",
            "type": "object",
            "description": "Subschema representing a individual account.",
            "properties": {
                "type": {
                    "type": "string",
                    "enum": [
                        "individual"
                    ]
                },
                "firstName": {
                    "type": "string",
                    "description": "The first name of the user"
                },
                "lastName": {
                    "type": "string",
                    "description": "The last name of the user. Optional field."
                },
                "needs": {
                    "type": "object",
                    "description": "User's need in the app, representing what kind of help he/she needs",
                    "properties": {
                        "medicalHelp": {
                            "type": "boolean",
                            "description": "Flag to indicate wheter the user needs medical help. \nMarking this indicates he shows symptoms of COVID-19.",
                            "default": false
                        },
                        "otherHelp": {
                            "type": "boolean",
                            "description": "Flag to indicate wheter the user needs non-medical help, such as getting groceries, medice and etc..",
                            "default": false
                        }
                    },
                    "additionalProperties": false,
                    "required": [
                        "medicalHelp",
                        "otherHelp"
                    ]
                },
                "objectives": {
                    "type": "object",
                    "description": "Document with what are the objectives of the user through the application, such as donating, volunteering or sharing information.",
                    "properties": {
                        "volunteer": {
                            "type": "boolean",
                            "description": "Flag to indicate wheter the user wants to volunteer for iniciatives through the app.",
                            "default": false
                        },
                        "donate": {
                            "type": "boolean",
                            "description": "Flag to indicate wheter the user wants to donate for iniciatives through the app.",
                            "default": false
                        },
                        "shareInformation": {
                            "type": "boolean",
                            "description": "Flag to indicate wheter the user wants to share information through the app.",
                            "default": true
                        }
                    },
                    "additionalProperties": false,
                    "required": [
                        "volunteer",
                        "donate",
                        "shareInformation"
                    ]
                },
                "urls": {
                    "type": "object",
                    "description": "Document holding the user urls to external websites and social networks",
                    "properties": {
                        "facebook": {
                            "type": "string",
                            "description": "URL to user's Facebook page.",
                            "format": "uri"
                        },
                        "linkedin": {
                            "type": "string",
                            "description": "URL to user's Linkedin page.",
                            "format": "uri"
                        },
                        "twitter": {
                            "type": "string",
                            "description": "URL to user's Twitter page.",
                            "format": "uri"
                        },
                        "github": {
                            "type": "string",
                            "description": "URL to user's Github page.",
                            "format": "uri"
                        },
                        "website": {
                            "type": "string",
                            "description": "URL to user's personal website.",
                            "format": "uri"
                        }
                    },
                    "additionalProperties": false
                }
            },
            "additionalProperties": true,
            "required": [
                "type",
                "firstName",
                "needs"
            ]
        },
        {
            "id": "organization",
            "type": "object",
            "description": "Subschema representing an organization (colective) account.",
            "properties": {
                "type": {
                    "type": "string",
                    "description": "The type of the organization. Can be: Community, Government, Health care provider, Non-profit, Other, R&D, Startup, Traditional Company and University. All names are store in lowercase only.",
                    "enum": [
                        "startup",
                        "traditional company",
                        "community",
                        "government",
                        "r&d",
                        "non-profit",
                        "university",
                        "health care provider",
                        "other"
                    ]
                },
                "industry": {
                    "type": "string",
                    "description": "Industry from which the organization participates. Plan is for this values to be scraped from linkedin industries."
                },
                "ownerId": {
                    "type": "string",
                    "description": "_id of the user who owns the organization.",
                    "pattern": "^[a-fA-F0-9]{24}$"
                },
                "name": {
                    "type": "string",
                    "description": "Organization's name.\n"
                },
                "needs": {
                    "type": "object",
                    "description": "Document with what are the objectives of the organization through the application, such as finding volunteers, staff, investors and donors.",
                    "properties": {
                        "volunteers": {
                            "type": "boolean",
                            "description": "Flag to indicate wheter the organization is seeking volunteers through the app.",
                            "default": false
                        },
                        "donations": {
                            "type": "boolean",
                            "description": "Flag to indicate wheter the organization is seeking donations through the app.",
                            "default": false
                        },
                        "staff": {
                            "type": "boolean",
                            "description": "Flag to indicate wheter the organization is seeking staff through the app.",
                            "default": false
                        },
                        "other": {
                            "type": "boolean",
                            "description": "Flag to indicate wheter the organization is seeking other needs through the app.",
                            "default": false
                        }
                    },
                    "additionalProperties": false,
                    "required": [
                        "volunteers",
                        "donations",
                        "staff",
                        "other"
                    ]
                },
                "global": {
                    "type": "boolean",
                    "description": "Flag to indicate wheter this organization is global.",
                    "default": false
                },
                "urls": {
                    "type": "object",
                    "description": "Document holding external urls and refs to the organization such as social media profiles.",
                    "properties": {
                        "linkedin": {
                            "type": "string",
                            "description": "URL to organization's Linkedin page.",
                            "format": "uri"
                        },
                        "twitter": {
                            "type": "string",
                            "description": "URL to organization's Twitter page.",
                            "format": "uri"
                        },
                        "website": {
                            "type": "string",
                            "description": "URL to organization's website.",
                            "format": "uri"
                        },
                        "playstore": {
                            "type": "string",
                            "description": "URL to organization's page at Google Play Store.",
                            "format": "uri"
                        },
                        "appstore": {
                            "type": "string",
                            "description": "URL to organization's page at Apple App Store",
                            "format": "uri"
                        }
                    },
                    "additionalProperties": false
                },
                "language": {
                    "type": "string",
                    "description": "Field to inidicate the language used by the organization."
                }
            },
            "additionalProperties": false,
            "required": [
                "type",
                "industry",
                "ownerId",
                "name",
                "needs"
            ]
        }
    ],
    "anyOf": [
        {
            "id": "emailPK",
            "type": "object",
            "description": "Case where the user comes from social networks with a registration that uses email. In this case, the email field is required. This case covers the great majority of currently supported social network authentications.",
            "properties": {
                "email": {
                    "type": "string",
                    "description": "User's email validated by a regex pattern.",
                    "format": "email"
                }
            },
            "additionalProperties": true,
            "required": [
                "email"
            ]
        },
        {
            "id": "phonePK",
            "type": "object",
            "description": "Case where the user comes from social networks with a registration that allows the use of only the phone. In this case, the phone field is required, and the email isn't. \n\nAn example of ocial network that falls into this case is Twitter.",
            "properties": {
                "phone": {
                    "type": "string"
                }
            },
            "additionalProperties": false,
            "required": [
                "phone"
            ]
        }
    ],
    "required": [
        "createdAt",
        "_id",
        "updatedAt",
        "authId"
    ]
}

2.1.2.4.5 users JSON data

{
    "createdAt": ISODate("2016-04-08T15:06:21.595Z"),
    "_id": ObjectId("507f1f77bcf86cd799439011"),
    "updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
    "authId": "Lorem",
    "location": {
        "coordinates": [
            35.26,
            -32.83
        ],
        "type": "Point",
        "country": "Lorem",
        "city": "Lorem",
        "neighborhood": "Lorem",
        "address": "Lorem"
    },
    "about": "Lorem",
    "photo": "./resource.txt#frag01",
    "type": "other",
    "industry": "Lorem",
    "ownerId": ObjectId("507f1f77bcf86cd799439011"),
    "name": "Lorem",
    "needs": {
        "volunteers": true,
        "donations": false,
        "staff": false,
        "other": false
    },
    "global": false,
    "urls": {
        "linkedin": "http://linkedin.com/in/myProfile",
        "twitter": "http://twitter.com/myProfile",
        "website": "http://mypersonalwebsite.com",
        "playstore": "http://playstore.com/myOrg",
        "appstore": "http://appstore.com/myOrg"
    },
    "language": "Lorem",
    "email": "test_user@fightpandemics.com"
}

2.1.2.4.6 users Target Script

use applicationDB;

db.createCollection( "users",{
    "storageEngine": {
        "wiredTiger": {}
    },
    "capped": false,
    "validator": {
        "$jsonSchema": {
            "bsonType": "object",
            "title": "users",
            "description": "Collection that holds all the data on system's users. \n\nThe users can be of **two types**: **(1) Individual**, representing a private user account; and **(2) Organization**, representing an organization of various types.\n\nThe field 'type' is used to differentiate between the two subschemas, with 'individual' representing private user accounts and \"Community\", \"Government\", \"Health care provider\", \"Non-profit\", \"Other\", \"R&D\", \"Startup\", \"Traditional Company\" and \"University\".",
            "additionalProperties": true,
            "properties": {
                "_id": {
                    "bsonType": "objectId",
                    "description": "Automatically generated _it as primary key."
                },
                "createdAt": {
                    "bsonType": "date",
                    "description": "Timestamp with the user's creation date"
                },
                "updatedAt": {
                    "bsonType": "date",
                    "description": "Timestamp indicating last update on the database."
                },
                "authId": {
                    "bsonType": "string",
                    "description": "String holding the authentication service id (Auth0).\n\nThis field is a **foreign key to the user in the Auth0 database**, connecting through the user_id field."
                },
                "location": {
                    "bsonType": "object",
                    "description": "Location document according to the norms of a [GeoJSON Object](https://docs.mongodb.com/manual/reference/geojson/ ).\nThe fields address, neighborhood, city, state and country are added to store the result of the geoprocessing.",
                    "properties": {
                        "coordinates": {
                            "bsonType": "array",
                            "description": "Array with the coordinates, specifying **longitude first** and **latitude second**, as default in the [GeoJSON](https://docs.mongodb.com/manual/reference/geojson/) definition.",
                            "additionalItems": true,
                            "minItems": 2,
                            "maxItems": 2,
                            "uniqueItems": false,
                            "items": [
                                {
                                    "bsonType": "number",
                                    "description": "Location longitude\n",
                                    "minimum": -180,
                                    "maximum": 180
                                },
                                {
                                    "bsonType": "number",
                                    "description": "Location latitude\n",
                                    "minimum": -90,
                                    "maximum": 90
                                }
                            ]
                        },
                        "type": {
                            "bsonType": "string",
                            "description": "Type of the GeoJSON Object.\nPlease refer to the [official documentation](https://docs.mongodb.com/manual/reference/geojson/ ) for more information.\n\n**In our case, the value will always be of the type \"Point\".**",
                            "enum": [
                                "Point"
                            ]
                        },
                        "country": {
                            "bsonType": "string",
                            "description": "String holding the country's name.\n"
                        },
                        "city": {
                            "bsonType": "string",
                            "description": "String holding the city's name."
                        },
                        "neighborhood": {
                            "bsonType": "string",
                            "description": "String holding the neighborhood's name."
                        },
                        "address": {
                            "bsonType": "string",
                            "description": "String holding the address (street, number and other details)."
                        }
                    },
                    "additionalProperties": false,
                    "required": [
                        "coordinates",
                        "type"
                    ]
                },
                "about": {
                    "bsonType": "string",
                    "description": "Small self-introduction, limited to 100 char"
                },
                "photo": {
                    "bsonType": "string",
                    "description": "URI with the location of the profile's photo."
                }
            },
            "oneOf": [
                {
                    "bsonType": "object",
                    "description": "Subschema representing a individual account.",
                    "properties": {
                        "type": {
                            "bsonType": "string",
                            "enum": [
                                "individual"
                            ]
                        },
                        "firstName": {
                            "bsonType": "string",
                            "description": "The first name of the user"
                        },
                        "lastName": {
                            "bsonType": "string",
                            "description": "The last name of the user. Optional field."
                        },
                        "needs": {
                            "bsonType": "object",
                            "description": "User's need in the app, representing what kind of help he/she needs",
                            "properties": {
                                "medicalHelp": {
                                    "bsonType": "bool",
                                    "description": "Flag to indicate wheter the user needs medical help. \nMarking this indicates he shows symptoms of COVID-19."
                                },
                                "otherHelp": {
                                    "bsonType": "bool",
                                    "description": "Flag to indicate wheter the user needs non-medical help, such as getting groceries, medice and etc.."
                                }
                            },
                            "additionalProperties": false,
                            "required": [
                                "medicalHelp",
                                "otherHelp"
                            ]
                        },
                        "objectives": {
                            "bsonType": "object",
                            "description": "Document with what are the objectives of the user through the application, such as donating, volunteering or sharing information.",
                            "properties": {
                                "volunteer": {
                                    "bsonType": "bool",
                                    "description": "Flag to indicate wheter the user wants to volunteer for iniciatives through the app."
                                },
                                "donate": {
                                    "bsonType": "bool",
                                    "description": "Flag to indicate wheter the user wants to donate for iniciatives through the app."
                                },
                                "shareInformation": {
                                    "bsonType": "bool",
                                    "description": "Flag to indicate wheter the user wants to share information through the app."
                                }
                            },
                            "additionalProperties": false,
                            "required": [
                                "volunteer",
                                "donate",
                                "shareInformation"
                            ]
                        },
                        "urls": {
                            "bsonType": "object",
                            "description": "Document holding the user urls to external websites and social networks",
                            "properties": {
                                "facebook": {
                                    "bsonType": "string",
                                    "description": "URL to user's Facebook page."
                                },
                                "linkedin": {
                                    "bsonType": "string",
                                    "description": "URL to user's Linkedin page."
                                },
                                "twitter": {
                                    "bsonType": "string",
                                    "description": "URL to user's Twitter page."
                                },
                                "github": {
                                    "bsonType": "string",
                                    "description": "URL to user's Github page."
                                },
                                "website": {
                                    "bsonType": "string",
                                    "description": "URL to user's personal website."
                                }
                            },
                            "additionalProperties": false
                        }
                    },
                    "additionalProperties": true,
                    "required": [
                        "type",
                        "firstName",
                        "needs"
                    ]
                },
                {
                    "bsonType": "object",
                    "description": "Subschema representing an organization (colective) account.",
                    "properties": {
                        "type": {
                            "bsonType": "string",
                            "description": "The type of the organization. Can be: Community, Government, Health care provider, Non-profit, Other, R&D, Startup, Traditional Company and University. All names are store in lowercase only.",
                            "enum": [
                                "startup",
                                "traditional company",
                                "community",
                                "government",
                                "r&d",
                                "non-profit",
                                "university",
                                "health care provider",
                                "other"
                            ]
                        },
                        "industry": {
                            "bsonType": "string",
                            "description": "Industry from which the organization participates. Plan is for this values to be scraped from linkedin industries."
                        },
                        "ownerId": {
                            "bsonType": "objectId",
                            "description": "_id of the user who owns the organization."
                        },
                        "name": {
                            "bsonType": "string",
                            "description": "Organization's name.\n"
                        },
                        "needs": {
                            "bsonType": "object",
                            "description": "Document with what are the objectives of the organization through the application, such as finding volunteers, staff, investors and donors.",
                            "properties": {
                                "volunteers": {
                                    "bsonType": "bool",
                                    "description": "Flag to indicate wheter the organization is seeking volunteers through the app."
                                },
                                "donations": {
                                    "bsonType": "bool",
                                    "description": "Flag to indicate wheter the organization is seeking donations through the app."
                                },
                                "staff": {
                                    "bsonType": "bool",
                                    "description": "Flag to indicate wheter the organization is seeking staff through the app."
                                },
                                "other": {
                                    "bsonType": "bool",
                                    "description": "Flag to indicate wheter the organization is seeking other needs through the app."
                                }
                            },
                            "additionalProperties": false,
                            "required": [
                                "volunteers",
                                "donations",
                                "staff",
                                "other"
                            ]
                        },
                        "global": {
                            "bsonType": "bool",
                            "description": "Flag to indicate wheter this organization is global."
                        },
                        "urls": {
                            "bsonType": "object",
                            "description": "Document holding external urls and refs to the organization such as social media profiles.",
                            "properties": {
                                "linkedin": {
                                    "bsonType": "string",
                                    "description": "URL to organization's Linkedin page."
                                },
                                "twitter": {
                                    "bsonType": "string",
                                    "description": "URL to organization's Twitter page."
                                },
                                "website": {
                                    "bsonType": "string",
                                    "description": "URL to organization's website."
                                },
                                "playstore": {
                                    "bsonType": "string",
                                    "description": "URL to organization's page at Google Play Store."
                                },
                                "appstore": {
                                    "bsonType": "string",
                                    "description": "URL to organization's page at Apple App Store"
                                }
                            },
                            "additionalProperties": false
                        },
                        "language": {
                            "bsonType": "string",
                            "description": "Field to inidicate the language used by the organization."
                        }
                    },
                    "additionalProperties": false,
                    "required": [
                        "type",
                        "industry",
                        "ownerId",
                        "name",
                        "needs"
                    ]
                }
            ],
            "anyOf": [
                {
                    "bsonType": "object",
                    "description": "Case where the user comes from social networks with a registration that uses email. In this case, the email field is required. This case covers the great majority of currently supported social network authentications.",
                    "properties": {
                        "email": {
                            "bsonType": "string",
                            "description": "User's email validated by a regex pattern."
                        }
                    },
                    "additionalProperties": true,
                    "required": [
                        "email"
                    ]
                },
                {
                    "bsonType": "object",
                    "description": "Case where the user comes from social networks with a registration that allows the use of only the phone. In this case, the phone field is required, and the email isn't. \n\nAn example of ocial network that falls into this case is Twitter.",
                    "properties": {
                        "phone": {
                            "bsonType": "string"
                        }
                    },
                    "additionalProperties": false,
                    "required": [
                        "phone"
                    ]
                }
            ],
            "required": [
                "createdAt",
                "_id",
                "updatedAt",
                "authId"
            ]
        }
    },
    "validationLevel": "off",
    "validationAction": "warn"
});

3. Relationships

3.1 Relationship PostHasComments

3.1.1 PostHasComments Diagram

Parent Table	Parent field
posts	_id

Child Table	Child field
comments	postId

3.1.2 PostHasComments Properties

Property	Value
Name	PostHasComments
Description	Relationship between a Post and it's respective Comments made at it.
Parent Collection	posts
Parent field	_id
Parent Cardinality	1
Child Collection	comments
Child field	postId
Child Cardinality	n
Comments

3.2 Relationship UserLikesComment

3.2.1 UserLikesComment Diagram

Parent Table	Parent field
users	_id

Child Table	Child field
comments	likes.[0]

3.2.2 UserLikesComment Properties

Property	Value
Name	UserLikesComment
Description	Relation to represent the User's who liked a Comment. Even though this is a N-N relation, we opt to store the ids only at the Comment side as an array of _id (with the _id of the users who liked it).
Parent Collection	users
Parent field	_id
Parent Cardinality	n
Child Collection	comments
Child field
Child Cardinality	n
Comments

3.3 Relationship UserLikesPost

3.3.1 UserLikesPost Diagram

Parent Table	Parent field
users	_id

Child Table	Child field
posts	likes.[0]

3.3.2 UserLikesPost Properties

Property	Value
Name	UserLikesPost
Description	Relation to represent the User's who liked a Post. Even though this is a N-N relation, we opt to store the ids only at the Post side as an array of _id (with the _id of the users who liked it).
Parent Collection	users
Parent field	_id
Parent Cardinality	n
Child Collection	posts
Child field
Child Cardinality	n
Comments

3.4 Relationship fk comments._id to comments.parentId

3.4.1 fk comments._id to comments.parentId Diagram

Parent Table	Parent field
comments	_id

Child Table	Child field
comments	parentId

3.4.2 fk comments._id to comments.parentId Properties

Property	Value
Name	fk comments._id to comments.parentId
Description
Parent Collection	comments
Parent field	_id
Parent Cardinality	1
Child Collection	comments
Child field	parentId
Child Cardinality	1
Comments

3.5 Relationship fk users._id to comments.likes

3.5.1 fk users._id to comments.likes Diagram

Parent Table	Parent field
users	_id

Child Table	Child field
comments	likes

3.5.2 fk users._id to comments.likes Properties

Property	Value
Name	fk users._id to comments.likes
Description
Parent Collection	users
Parent field	_id
Parent Cardinality	1
Child Collection	comments
Child field	likes
Child Cardinality	1
Comments

3.6 Relationship fk users._id to feedbacks.userId

3.6.1 fk users._id to feedbacks.userId Diagram

Parent Table	Parent field
users	_id

Child Table	Child field
feedbacks	userId

3.6.2 fk users._id to feedbacks.userId Properties

Property	Value
Name	fk users._id to feedbacks.userId
Description
Parent Collection	users
Parent field	_id
Parent Cardinality	1
Child Collection	feedbacks
Child field	userId
Child Cardinality	1
Comments

3.7 Relationship fk users._id to organizations..organization.ownerId

3.7.1 fk users._id to organizations..organization.ownerId Diagram

Parent Table	Parent field
	_id

Child Table	Child field
	[-1].[-1].[-1]

3.7.2 fk users._id to organizations..organization.ownerId Properties

Property	Value
Name	fk users._id to organizations..organization.ownerId
Description	Relation between an User and an Organization created by him/her. Initially projected as 1-N, with only one User owning the Organization, it is though to later on be evolved into N-N, with many Users being able to manage the Organization with different roles.
Parent Collection
Parent field	_id
Parent Cardinality	1
Child Collection
Child field
Child Cardinality	n
Comments

3.8 Relationship fk users._id to posts..author.authorId

3.8.1 fk users._id to posts..author.authorId Diagram

Parent Table	Parent field
users	_id

Child Table	Child field
posts	author.author.id

3.8.2 fk users._id to posts..author.authorId Properties

Property	Value
Name	fk users._id to posts..author.authorId
Description	Relation between a User and the Post created by him/her.
Parent Collection	users
Parent field	_id
Parent Cardinality	1
Child Collection	posts
Child field	id
Child Cardinality	n
Comments