Report for Alameen made in Moon Modeler

Yes

historyactions

requeststatuses-volunteers.status

Yes

createdAt

date

Yes

updatedAt

date

Yes

created_date

date

Yes

updated_date

date

Yes

Indexes

_id_

Create statement

db.volunteers.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

volunteers-eventactions.volunteer

volunteers-events.primary_volunteers

volunteers-object.volunteer

volunteers-volunteeractions.volunteer

Name

users

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

employee_id

string

Yes

phone_number

string

Yes

string

Yes

gender

string

Yes

password

string

Yes

department

objectId

Yes

is_admin

bool

Yes

is_active

bool

Yes

is_deleted

bool

Yes

is_agent

bool

Yes

is_manager

bool

Yes

is_sub_admin

bool

Yes

is_user

bool

Yes

role

string

Yes

profile_image

string

Yes

module

object

Yes

createdAt

date

Yes

updatedAt

date

Yes

last_name_en

string

Yes

first_name_en

string

Yes

first_name_ar

string

Yes

second_name_en

string

Yes

manage_lecture_request

bool

Yes

upload_instagram_feeds

bool

Yes

view_instagram_feeds

bool

Yes

approve_instagram_feeds

bool

Yes

manage_volunteer_with_us

bool

Yes

download_files

bool

Yes

create_incident_request

bool

Yes

is_english

bool

Yes

is_online

string

Yes

created_date

date

Yes

is_escalated_department

bool

Yes

updated_date

date

Yes

last_name_ar

string

Yes

default_department

objectId

Yes

Indexes

_id_

Create statement

db.users.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

departments-users.department

departments-users.default_department

users-sessionlogs.user

users-notifications.exclude_id

sessionlogs

users-notifications.user

users-requestactions.handled_by

users-requestactions.assigned_to

users-requestactions.involved_assigned_to

users-downloadlogs.user

users-eventactions.handled_by

users-bitvoicelogs.handled_by

bitvoicelogs

users-lecturerequests.handled_by

users-lecturerequestactions.handled_by

users-instagramfeeds.created_by

users-instagramfeeds.updated_by

users-instagramfeedshistories.updated_by

users-instagramfeedshistories.handled_by

users-instagramfeedshistories.created_by

users-requests.handled_by

users-requests.assigned_to

users-requests.created_by

users-requests.involved_assigned_to

users-errorlogs.updated_by

users-actionlogs.action_id

errorlogs

users-actionlogs.user

users-volunteeractions.handled_by

Name

sessionlogs

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

user

objectId

Yes

token

string

Yes

refreshToken

string

Yes

login_time

date

Yes

action

string

Yes

createdAt

date

Yes

updatedAt

date

Yes

duration

string

Yes

logout_time

date

Yes

Indexes

_id_

Create statement

db.sessionlogs.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

users-sessionlogs.user

incidenttypes-requestactions.incident_type

sessionlogs

Name

counters

Fields

Name

Data type

Array

Key

Required

_id

string

Yes

__v

double

Yes

ticket_number

double

Yes

Indexes

_id_

Create statement

db.counters.createIndex(
{
  "_id": 1
})

Name

incidenttypes

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

incident_type_en

string

Yes

incident_type_ar

string

Yes

handle_key

string

Yes

is_active

bool

Yes

is_deleted

bool

Yes

createdAt

date

Yes

updatedAt

date

Yes

Indexes

_id_

Create statement

db.incidenttypes.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

incidenttypes-requests.incident_type

departments-notifications.dept

Name

notifications

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

request_id

string

Yes

title_en

string

Yes

title_ar

string

Yes

type

string

Yes

action

string

Yes

exclude_id

objectId

Yes

main_access

object

Yes

role_type

string

Yes

dept

any

Any type restrictions

"objectId","null"

user

objectId

Yes

priority

bool

Yes

is_request

bool

Yes

createdAt

date

Yes

updatedAt

date

Yes

Indexes

_id_

Create statement

db.notifications.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

users-notifications.exclude_id

users-notifications.user

Name

departments

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

is_active

bool

Yes

is_deleted

bool

Yes

is_default

bool

Yes

handle_key

string

Yes

createdAt

date

Yes

updatedAt

date

Yes

department_name_en

string

Yes

department_name_ar

string

Yes

Indexes

_id_

Create statement

db.departments.createIndex(
{
  "_id": 1
})

Name

requestactions

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

request

objectId

Yes

comment

string

Yes

approvalRequired

bool

Yes

title_en

string

Yes

title_ar

string

Yes

attachments

string

Yes

incident_file

string

Yes

status_key

string

Yes

received_date

date

Yes

last_update

date

Yes

request_latest_status

any

Any type restrictions

"objectId","null"

assigned_to

objectId

Yes

involved_assigned_to

objectId

Yes

department

any

Any type restrictions

"objectId","null"

incident_type

any

Any type restrictions

"null","objectId"

is_anonymous

bool

Yes

involved_department

objectId

Yes

actions_taken

string

Yes

type

string

Yes

createdAt

date

Yes

updatedAt

date

Yes

created_date

date

Yes

updated_date

date

Yes

handled_by

any

Any type restrictions

"null","objectId"

forward_department

any

Any type restrictions

"null","objectId"

descripition

any

Any type restrictions

"string","null"

call_status

string

Yes

callDuration

string

Yes

buildCallDuration

string

Yes

callStartTime

string

Yes

callEndTime

string

Yes

voice_file

string

Yes

filename

string

Yes

updated_fields

Yes

updated_fields_verified

Yes

approvalAccpeted

bool

Yes

Indexes

_id_

Create statement

db.requestactions.createIndex(
{
  "_id": 1
})

Name

downloadlogs

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

user

objectId

Yes

request

objectId

Yes

type

string

Yes

fileUrl

string

Yes

download_time

date

Yes

createdAt

date

Yes

updatedAt

date

Yes

Indexes

_id_

Create statement

db.downloadlogs.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

users-downloadlogs.user

requests-downloadlogs.request

users-eventactions.handled_by

Name

eventactions

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

event

objectId

Yes

title_en

string

Yes

title_ar

string

Yes

attachments

object

Yes

handled_by

objectId

Yes

last_update

date

Yes

created_date

date

Yes

status

null

type

string

Yes

createdAt

date

Yes

updatedAt

date

Yes

volunteer

objectId

Yes

comment

string

Yes

voice_file

string

Yes

received_date

date

Yes

call_status

string

Yes

callDuration

string

Yes

buildCallDuration

string

Yes

callStartTime

string

Yes

callEndTime

string

Yes

Indexes

_id_

Create statement

db.eventactions.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

events-eventactions.event

volunteers-eventactions.volunteer

customerdetails-requests.customer_detail

Name

customerdetails

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

customer_email

string

Yes

device

string

Yes

device_id

string

Yes

apple_id

string

Yes

social_id

string

Yes

is_anonymous

bool

Yes

ip_addr

string

Yes

customer__alternate_contact

object

Yes

customer__alternate_email

object

Yes

alternate_device_id

object

Yes

customer_name_en

null

customer_name_ar

null

customer_contact_code

null

is_verified_phone_number

bool

Yes

is_verified_email

bool

Yes

customer_nationality

null

customer_gender

null

language

string

Yes

register_type

string

Yes

profile_image

string

Yes

is_deleted

bool

Yes

profileImage_updated

bool

Yes

createdAt

date

Yes

updatedAt

date

Yes

Indexes

_id_

Create statement

db.customerdetails.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

customerdetails

Name

requestdepartmentstatusviews

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

request_id

objectId

Yes

department_users

requests-requestdepartmentstatusviews.request_id

Yes

createdAt

date

Yes

updatedAt

date

Yes

Indexes

_id_

Create statement

db.requestdepartmentstatusviews.createIndex(
{
  "_id": 1
})

request_id_1

Create statement

db.requestdepartmentstatusviews.createIndex(
{
  "request_id": 1
},
 {
  "background": true
}
)

department_users.dept_id_1

Create statement

db.requestdepartmentstatusviews.createIndex(
{
  "department_users.dept_id": 1
},
 {
  "background": true
}
)

References

Name

Source

Target

requestdepartmentstatusviews

Name

requestactionaccesses

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

request_id

objectId

Yes

department_id

objectId

Yes

request_action_id

objectId

Yes

createdAt

date

Yes

updatedAt

date

Yes

created_date

date

Yes

updated_date

date

Yes

Indexes

_id_

Create statement

db.requestactionaccesses.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

departments-requestactionaccesses.department_id

requestactions-requestactionaccesses.request_action_id

requests-requestactionaccesses.request_id

Name

accessmodules

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

role

string

Yes

access

string

Yes

Indexes

_id_

Create statement

db.accessmodules.createIndex(
{
  "_id": 1
})

Name

events

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

title

string

Yes

handle_key

string

Yes

description

string

Yes

event_from

date

Yes

event_to

date

Yes

primary_volunteers

objectId

Yes

backup_volunteers

object

Yes

is_deleted

bool

Yes

historyactions

events-eventactions.event

Yes

createdAt

date

Yes

updatedAt

date

Yes

created_date

date

Yes

updated_date

date

Yes

Indexes

_id_

Create statement

db.events.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

volunteers-events.primary_volunteers

events-volunteeractions.event

users-bitvoicelogs.handled_by

Name

bitvoicelogs

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

handled_by

objectId

Yes

string

Yes

request_type

string

Yes

call_status

string

Yes

callDuration

string

Yes

buildCallDuration

string

Yes

callStartTime

string

Yes

callEndTime

string

Yes

incident_file

string

Yes

createdAt

date

Yes

updatedAt

date

Yes

Indexes

_id_

Create statement

db.bitvoicelogs.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

bitvoicelogs

Name

lecturerequests

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

request_no

string

Yes

contact_number

string

Yes

customer_contact_code

string

Yes

request_from

date

Yes

request_from_time

string

Yes

request_to

date

Yes

request_to_time

string

Yes

participant_no

double

Yes

emirates

Yes

string

Yes

coordinator_name

string

Yes

beneficiary

string

Yes

status

objectId

Yes

ip_addr

string

Yes

device

string

Yes

device_id

string

Yes

is_deleted

bool

Yes

request_type

string

Yes

udid

null

precise_location

string

Yes

historyactions

requeststatuses-lecturerequests.status

Yes

createdAt

date

Yes

updatedAt

date

Yes

created_date

date

Yes

updated_date

date

Yes

handled_by

objectId

Yes

Indexes

_id_

Create statement

db.lecturerequests.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

users-lecturerequests.handled_by

lecturerequests-lecturerequestactions.request

lecturerequests-lecturerequestactions.request

Name

lecturerequestactions

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

request

objectId

Yes

title_en

string

Yes

title_ar

string

Yes

attachments

object

Yes

last_update

date

Yes

created_date

date

Yes

actions_taken

object

Yes

type

string

Yes

status_key

string

Yes

status

objectId

Yes

createdAt

date

Yes

updatedAt

date

Yes

comment

string

Yes

voice_file

string

Yes

handled_by

objectId

Yes

received_date

date

Yes

call_status

string

Yes

callDuration

string

Yes

buildCallDuration

string

Yes

callStartTime

string

Yes

callEndTime

string

Yes

filename

string

Yes

Indexes

_id_

Create statement

db.lecturerequestactions.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

requeststatuses-lecturerequestactions.status

users-lecturerequestactions.handled_by

users-instagramfeeds.created_by

Name

instagramfeeds

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

created_by

objectId

Yes

instagram_post

string

Yes

descripition

string

Yes

status

objectId

Yes

is_approved

bool

Yes

is_canceled

bool

Yes

is_returned

bool

Yes

for_approval

bool

Yes

is_active

bool

Yes

is_deleted

bool

Yes

toBePosted

date

Yes

createdAt

date

Yes

updatedAt

date

Yes

created_date

date

Yes

updated_date

date

Yes

updated_by

objectId

Yes

Indexes

_id_

Create statement

db.instagramfeeds.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

requeststatuses-instagramfeeds.status

users-instagramfeeds.updated_by

instagramfeeds-instagramfeedshistories.instagram_feeds

countrylists-verifiedcustomerdetails.customer_nationality

Name

countrylists

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

name

string

Yes

dial_code

string

Yes

code

string

Yes

Indexes

_id_

Create statement

db.countrylists.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

countrylists-requests.customer_nationality

Name

verifiedcustomerdetails

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

customer_contact

string

Yes

customer_email

string

Yes

is_anonymous

bool

Yes

customer_alternate_contact

countrylists-verifiedcustomerdetails.customer_nationality

Yes

customer_alternate_email

string

Yes

alternate_device_id

object

Yes

customer_name_en

any

Any type restrictions

"string","null"

customer_name_ar

any

Any type restrictions

"string","null"

customer_contact_code

any

Any type restrictions

"string","null"

is_verified_phone_number

bool

Yes

is_verified_email

bool

Yes

customer_nationality

any

Any type restrictions

"null","objectId"

customer_gender

any

Any type restrictions

"string","null"

language

any

Any type restrictions

"null","string"

register_type

any

Any type restrictions

"null","string"

profile_image

any

Any type restrictions

"null","string"

is_deleted

bool

Yes

createdAt

date

Yes

updatedAt

date

Yes

customer_contact_number

string

Yes

device

string

Yes

device_id

string

Yes

Indexes

_id_

Create statement

db.verifiedcustomerdetails.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

verifiedcustomerdetails-requests.verified_customer_detail

users-instagramfeedshistories.updated_by

Name

instagramfeedshistories

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

instagram_feeds

objectId

Yes

handled_by

objectId

Yes

created_by

objectId

Yes

updated_by

objectId

Yes

instagram_post

string

Yes

descripition

string

Yes

status

objectId

Yes

comment

string

Yes

is_approved

bool

Yes

is_canceled

bool

Yes

is_returned

bool

Yes

for_approval

bool

Yes

is_active

bool

Yes

is_deleted

bool

Yes

toBePosted

date

Yes

updated_date

date

Yes

createdAt

date

Yes

updatedAt

date

Yes

created_date

date

Yes

Indexes

_id_

Create statement

db.instagramfeedshistories.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

users-instagramfeedshistories.handled_by

users-instagramfeedshistories.created_by

instagramfeeds-instagramfeedshistories.instagram_feeds

requeststatuses-instagramfeedshistories.status

Name

translates

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

title

string

Yes

english_text

string

Yes

arabic_text

string

Yes

is_verified

bool

Yes

createdAt

date

Yes

updatedAt

date

Yes

Indexes

_id_

Create statement

db.translates.createIndex(
{
  "_id": 1
})

Name

requests

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

ticket_no

string

Yes

request_type

string

Yes

verified_customer_detail

any

Any type restrictions

"null","objectId"

customer_detail

any

Any type restrictions

"null","objectId"

customer_contact

any

Any type restrictions

"string","null"

customer_nationality

any

Any type restrictions

"null","objectId"

customer_gender

any

Any type restrictions

"null","string"

customer_name_en

any

Any type restrictions

"null","string"

customer_name_ar

any

Any type restrictions

"null","string"

involved_department

objectId

Yes

department

objectId

Yes

incident_type

any

Any type restrictions

"objectId","null"

assigned_to

objectId

Yes

involved_assigned_to

objectId

Yes

request_latest_status

objectId

Yes

created_by

any

Any type restrictions

"null","objectId"

handled_by

any

Any type restrictions

"objectId","null"

incident_file

string

Yes

incident_date

any

Any type restrictions

"null","date"

approvalRequired

bool

Yes

last_update

date

Yes

is_active

bool

Yes

is_deleted

bool

Yes

is_closed

bool

Yes

is_processing

bool

Yes

is_escalated

bool

Yes

is_resolved

bool

Yes

is_rejected

bool

Yes

is_returned

bool

Yes

is_anonymous

bool

Yes

is_draft

bool

Yes

created_request

bool

Yes

is_reopened

bool

Yes

resolved_date

null

closed_date

null

responded_time

any

Any type restrictions

"string","null"

ivr_option

any

Any type restrictions

"string","null"

historyactions

requests-requestactions.request

Yes

createdAt

date

Yes

updatedAt

date

Yes

created_date

date

Yes

updated_date

date

Yes

customer_contact_code

string

Yes

customer_contact_number

any

Any type restrictions

"string","null"

customer_email

any

Any type restrictions

"null","string"

descripition

any

Any type restrictions

"string","null"

forward_department

any

Any type restrictions

"objectId","null"

responded_date

date

Yes

precise_location

string

Yes

latitude

string

Yes

longitude

string

Yes

incident_location

string

Yes

incident_latitude

string

Yes

incident_longitude

string

Yes

ip_addr

string

Yes

device

string

Yes

device_id

string

Yes

social_id

string

Yes

request_status

string

Yes

voice_file

string

Yes

Indexes

_id_

Create statement

db.requests.createIndex(
{
  "_id": 1
})

is_deleted_1

Create statement

db.requests.createIndex(
{
  "is_deleted": 1
},
 {
  "background": true
}
)

is_draft_1

Create statement

db.requests.createIndex(
{
  "is_draft": 1
},
 {
  "background": true
}
)

department_1

Create statement

db.requests.createIndex(
{
  "department": 1
},
 {
  "background": true
}
)

involved_department_1

Create statement

db.requests.createIndex(
{
  "involved_department": 1
},
 {
  "background": true
}
)

request_type_1

Create statement

db.requests.createIndex(
{
  "request_type": 1
},
 {
  "background": true
}
)

incident_type_1

Create statement

db.requests.createIndex(
{
  "incident_type": 1
},
 {
  "background": true
}
)

request_latest_status_1

Create statement

db.requests.createIndex(
{
  "request_latest_status": 1
},
 {
  "background": true
}
)

handled_by_1

Create statement

db.requests.createIndex(
{
  "handled_by": 1
},
 {
  "background": true
}
)

References

Name

Source

Target

requests-downloadlogs.request

requests-requestdepartmentstatusviews.request_id

requestdepartmentstatusviews

requests-requestactionaccesses.request_id

users-requests.handled_by

incidenttypes-requests.incident_type

departments-requests.involved_department

departments-requests.department

departments-requests.forward_department

requeststatuses-requests.request_latest_status

users-requests.assigned_to

verifiedcustomerdetails-requests.verified_customer_detail

customerdetails-requests.customer_detail

customerdetails

users-requests.created_by

countrylists-requests.customer_nationality

users-requests.involved_assigned_to

users-errorlogs.updated_by

Name

errorlogs

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

fileName

string

Yes

apiPath

string

Yes

lineNumber

string

Yes

message

string

Yes

level

string

Yes

service

string

Yes

updated_by

objectId

Yes

createdAt

date

Yes

updatedAt

date

Yes

created_date

date

Yes

updated_date

date

Yes

Indexes

_id_

Create statement

db.errorlogs.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

users-actionlogs.action_id

errorlogs

Name

countryflaglists

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

country

string

Yes

handle_key

string

Yes

code

string

Yes

flag_base64

string

Yes

flag

string

Yes

Indexes

_id_

Create statement

db.countryflaglists.createIndex(
{
  "_id": 1
})

Name

actionlogs

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

user

any

Any type restrictions

"objectId","null"

time

date

Yes

path

string

Yes

ip_address

string

Yes

ticket_no

any

Any type restrictions

"null","string"

action_id

objectId

Yes

action_type

string

Yes

action_module

string

Yes

createdAt

date

Yes

updatedAt

date

Yes

created_date

date

Yes

updated_date

date

Yes

Indexes

_id_

Create statement

db.actionlogs.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

users-actionlogs.user

volunteers-volunteeractions.volunteer

Name

volunteeractions

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

volunteer

objectId

Yes

title_en

string

Yes

title_ar

string

Yes

attachments

object

Yes

handled_by

any

Any type restrictions

"null","objectId"

last_update

date

Yes

created_date

date

Yes

status

objectId

Yes

type

string

Yes

createdAt

date

Yes

updatedAt

date

Yes

event

objectId

Yes

comment

string

Yes

voice_file

string

Yes

received_date

date

Yes

call_status

string

Yes

callDuration

string

Yes

buildCallDuration

string

Yes

callStartTime

string

Yes

callEndTime

string

Yes

Indexes

_id_

Create statement

db.volunteeractions.createIndex(
{
  "_id": 1
})

References

Name

Source

Target

requeststatuses-volunteeractions.status

users-volunteeractions.handled_by

events-volunteeractions.event

Name

requeststatuses

Fields

Name

Data type

Array

Key

Required

_id

objectId

Yes

is_active

string

Yes

handle_key

string

Yes

status_access

object

Yes

createdAt

date

Yes

updatedAt

date

Yes

request_status

string

Yes

action_status

string

Yes

Indexes

_id_

Create statement

db.requeststatuses.createIndex(
{
  "_id": 1
})

References

documents

Name

object

Fields

Name

Data type

Array

Key

Required

event

objectId

Yes

is_primary

bool

Yes

is_backup

bool

Yes

created_date

date

Yes

_id

objectId

Yes

References

Name

Source

Target

events-object.event

Name

object

Fields

Name

Data type

Array

Key

Required

event

objectId

Yes

call_status

string

Yes

callDuration

string

Yes

buildCallDuration

string

Yes

callStartTime

string

Yes

callEndTime

string

Yes

type

string

Yes

voice_file

string

Yes

received_date

date

Yes

last_update

date

Yes

handled_by

objectId

Yes

_id

objectId

Yes

References

Name

Source

Target

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

string

Yes

new_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

string

Yes

new_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

any

Any type restrictions

"string","null"

new_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

any

Any type restrictions

"date","null"

new_value

date

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

any

Any type restrictions

"null","string"

new_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

string

Yes

new_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

string

Yes

new_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

new_value

string

Yes

old_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

any

Any type restrictions

"string","null"

new_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

null

new_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

null

new_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

new_value

string

Yes

added_items

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

code

string

Yes

number

string

Yes

_id

objectId

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

code

string

Yes

number

string

Yes

_id

objectId

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

any

Any type restrictions

"null","string"

new_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

any

Any type restrictions

"null","string"

new_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

null

new_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

old_value

null

new_value

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

incident_type_en

Yes

incident_type_ar

Yes

descripition

Yes

incident_date

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

customer_contact_number

Yes

customer_email

Yes

customer_name_en

Yes

customer_nationality

Yes

customer_gender

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

new_value

Yes

added_items

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

incident_details

Yes

customer_detail

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

customer_email

Yes

customer_gender

Yes

customer_alternate_email

Yes

customer_alternate_contact

Yes

customer_contact_number

Yes

customer_name_en

Yes

customer_nationality

Yes

is_verified_phone_number

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

customer_detail

departments-object.dept_id

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

dept_id

objectId

Yes

user_status

objectId

Yes

manager_status

objectId

Yes

sub_admin_status

objectId

Yes

super_admin_status

objectId

Yes

_id

objectId

Yes

References

Name

Source

Target

requeststatuses-object.super_admin_status

requeststatuses-object.sub_admin_status

requeststatuses-object.manager_status

requeststatuses-object.user_status

volunteers-object.volunteer

Name

object

Fields

Name

Data type

Array

Key

Required

volunteer

objectId

Yes

call_status

string

Yes

callDuration

string

Yes

buildCallDuration

string

Yes

callStartTime

string

Yes

callEndTime

string

Yes

type

string

Yes

voice_file

string

Yes

received_date

date

Yes

last_update

date

Yes

handled_by

objectId

Yes

_id

objectId

Yes

References

Name

Source

Target

Name

object

Fields

Name

Data type

Array

Key

Required

english

string

Yes

arabic

string

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

call_status

string

Yes

callDuration

string

Yes

buildCallDuration

string

Yes

callStartTime

string

Yes

callEndTime

string

Yes

type

string

Yes

voice_file

string

Yes

received_date

date

Yes

last_update

date

Yes

handled_by

objectId

Yes

_id

objectId

Yes

References

Name

Source

Target

Name

object

Fields

Name

Data type

Array

Key

Required

code

string

Yes

number

string

Yes

_id

objectId

Yes

Name

object

Fields

Name

Data type

Array

Key

Required

call_status

string

Yes

callDuration

string

Yes

buildCallDuration

string

Yes

callStartTime

string

Yes

callEndTime

string

Yes

type

string

Yes

received_date

date

Yes

last_update

date

Yes

handled_by

objectId

Yes

incident_file

string

Yes

_id

objectId

Yes

References

Name

Source

Target

references

Name

users-object.handled_by

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Optional

Name

events-object.event

Name

Source

Target

events-object.event

Cardinality type:

One to

many

Ordinality:

Optional

Name

events-object.event

Name

Source

Target

events-object.event

requeststatuses-volunteers.status

Cardinality type:

One to

many

Ordinality:

Optional

Name

requeststatuses-volunteers.status

Name

Source

Target

departments-users.department

Cardinality type:

One to

many

Ordinality:

Optional

Name

departments-users.department

Name

Source

Target

departments-users.default_department

Cardinality type:

One to

many

Ordinality:

Optional

Name

departments-users.default_department

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-sessionlogs.user

Name

Source

Target

users-sessionlogs.user

departments-notifications.dept

sessionlogs

Cardinality type:

One to

many

Ordinality:

Optional

Name

departments-notifications.dept

Name

Source

Target

users-notifications.exclude_id

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-notifications.exclude_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-notifications.user

Name

Source

Target

users-notifications.user

departments-requestactions.involved_department

Cardinality type:

One to

many

Ordinality:

Optional

Name

departments-requestactions.involved_department

Name

Source

Target

departments-requestactions.department

Cardinality type:

One to

many

Ordinality:

Optional

Name

departments-requestactions.department

Name

Source

Target

requests-requestactions.request

Cardinality type:

One to

many

Ordinality:

Optional

Name

requests-requestactions.request

Name

Source

Target

requeststatuses-requestactions.request_latest_status

Cardinality type:

One to

many

Ordinality:

Optional

Name

requeststatuses-requestactions.request_latest_status

Name

Source

Target

incidenttypes-requestactions.incident_type

Cardinality type:

One to

many

Ordinality:

Optional

Name

incidenttypes-requestactions.incident_type

Name

Source

Target

users-requestactions.handled_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-requestactions.handled_by

Name

Source

Target

users-requestactions.assigned_to

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-requestactions.assigned_to

Name

Source

Target

departments-requestactions.forward_department

Cardinality type:

One to

many

Ordinality:

Optional

Name

departments-requestactions.forward_department

Name

Source

Target

users-requestactions.involved_assigned_to

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-requestactions.involved_assigned_to

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-downloadlogs.user

Name

Source

Target

users-downloadlogs.user

requests-downloadlogs.request

Cardinality type:

One to

many

Ordinality:

Optional

Name

requests-downloadlogs.request

Name

Source

Target

users-eventactions.handled_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-eventactions.handled_by

Name

Source

Target

events-eventactions.event

Cardinality type:

One to

many

Ordinality:

Optional

Name

events-eventactions.event

Name

Source

Target

volunteers-eventactions.volunteer

Cardinality type:

One to

many

Ordinality:

Optional

Name

volunteers-eventactions.volunteer

Name

Source

Target

departments-object.dept_id

Cardinality type:

One to

many

Ordinality:

Optional

Name

departments-object.dept_id

Name

Source

Target

requests-requestdepartmentstatusviews.request_id

Cardinality type:

One to

many

Ordinality:

Optional

Name

requests-requestdepartmentstatusviews.request_id

Name

Source

Target

requestdepartmentstatusviews

Cardinality type:

One to

many

Ordinality:

Optional

Name

requeststatuses-object.super_admin_status

Name

Source

Target

requeststatuses-object.super_admin_status

requeststatuses-object.sub_admin_status

Cardinality type:

One to

many

Ordinality:

Optional

Name

requeststatuses-object.sub_admin_status

Name

Source

Target

requeststatuses-object.manager_status

Cardinality type:

One to

many

Ordinality:

Optional

Name

requeststatuses-object.manager_status

Name

Source

Target

requeststatuses-object.user_status

Cardinality type:

One to

many

Ordinality:

Optional

Name

requeststatuses-object.user_status

Name

Source

Target

departments-requestactionaccesses.department_id

Cardinality type:

One to

many

Ordinality:

Optional

Name

departments-requestactionaccesses.department_id

Name

Source

Target

requestactions-requestactionaccesses.request_action_id

Cardinality type:

One to

many

Ordinality:

Optional

Name

requestactions-requestactionaccesses.request_action_id

Name

Source

Target

requests-requestactionaccesses.request_id

Cardinality type:

One to

many

Ordinality:

Optional

Name

requests-requestactionaccesses.request_id

Name

Source

Target

volunteers-events.primary_volunteers

Cardinality type:

One to

many

Ordinality:

Optional

Name

volunteers-events.primary_volunteers

Name

Source

Target

volunteers-object.volunteer

Cardinality type:

One to

many

Ordinality:

Optional

Name

volunteers-object.volunteer

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-object.handled_by

Name

Source

Target

users-bitvoicelogs.handled_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-bitvoicelogs.handled_by

Name

Source

Target

requeststatuses-lecturerequests.status

bitvoicelogs

Cardinality type:

One to

many

Ordinality:

Optional

Name

requeststatuses-lecturerequests.status

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-object.handled_by

Name

Source

Target

users-lecturerequests.handled_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-lecturerequests.handled_by

Name

Source

Target

lecturerequests-lecturerequestactions.request

Cardinality type:

One to

many

Ordinality:

Optional

Name

lecturerequests-lecturerequestactions.request

Name

Source

Target

requeststatuses-lecturerequestactions.status

Cardinality type:

One to

many

Ordinality:

Optional

Name

requeststatuses-lecturerequestactions.status

Name

Source

Target

users-lecturerequestactions.handled_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-lecturerequestactions.handled_by

Name

Source

Target

users-instagramfeeds.created_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-instagramfeeds.created_by

Name

Source

Target

requeststatuses-instagramfeeds.status

Cardinality type:

One to

many

Ordinality:

Optional

Name

requeststatuses-instagramfeeds.status

Name

Source

Target

users-instagramfeeds.updated_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-instagramfeeds.updated_by

Name

Source

Target

countrylists-verifiedcustomerdetails.customer_nationality

Cardinality type:

One to

many

Ordinality:

Optional

Name

countrylists-verifiedcustomerdetails.customer_nationality

Name

Source

Target

users-instagramfeedshistories.updated_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-instagramfeedshistories.updated_by

Name

Source

Target

users-instagramfeedshistories.handled_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-instagramfeedshistories.handled_by

Name

Source

Target

users-instagramfeedshistories.created_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-instagramfeedshistories.created_by

Name

Source

Target

instagramfeeds-instagramfeedshistories.instagram_feeds

Cardinality type:

One to

many

Ordinality:

Optional

Name

instagramfeeds-instagramfeedshistories.instagram_feeds

Name

Source

Target

requeststatuses-instagramfeedshistories.status

Cardinality type:

One to

many

Ordinality:

Optional

Name

requeststatuses-instagramfeedshistories.status

Name

Source

Target

users-requests.handled_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-requests.handled_by

Name

Source

Target

incidenttypes-requests.incident_type

Cardinality type:

One to

many

Ordinality:

Optional

Name

incidenttypes-requests.incident_type

Name

Source

Target

departments-requests.involved_department

Cardinality type:

One to

many

Ordinality:

Optional

Name

departments-requests.involved_department

Name

Source

Target

departments-requests.department

Cardinality type:

One to

many

Ordinality:

Optional

Name

departments-requests.department

Name

Source

Target

departments-requests.forward_department

Cardinality type:

One to

many

Ordinality:

Optional

Name

departments-requests.forward_department

Name

Source

Target

requeststatuses-requests.request_latest_status

Cardinality type:

One to

many

Ordinality:

Optional

Name

requeststatuses-requests.request_latest_status

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-object.handled_by

Name

Source

Target

users-requests.assigned_to

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-requests.assigned_to

Name

Source

Target

verifiedcustomerdetails-requests.verified_customer_detail

Cardinality type:

One to

many

Ordinality:

Optional

Name

verifiedcustomerdetails-requests.verified_customer_detail

Name

Source

Target

customerdetails-requests.customer_detail

Cardinality type:

One to

many

Ordinality:

Optional

Name

customerdetails-requests.customer_detail

Name

Source

Target

customerdetails

users-requests.created_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-requests.created_by

Name

Source

Target

countrylists-requests.customer_nationality

Cardinality type:

One to

many

Ordinality:

Optional

Name

countrylists-requests.customer_nationality

Name

Source

Target

users-requests.involved_assigned_to

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-requests.involved_assigned_to

Name

Source

Target

users-errorlogs.updated_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-errorlogs.updated_by

Name

Source

Target

users-actionlogs.action_id

errorlogs

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-actionlogs.action_id

Name

Source

Target

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-actionlogs.user

Name

Source

Target

users-actionlogs.user

volunteers-volunteeractions.volunteer

Cardinality type:

One to

many

Ordinality:

Optional

Name

volunteers-volunteeractions.volunteer

Name

Source

Target

requeststatuses-volunteeractions.status

Cardinality type:

One to

many

Ordinality:

Optional

Name

requeststatuses-volunteeractions.status

Name

Source

Target

users-volunteeractions.handled_by

Cardinality type:

One to

many

Ordinality:

Optional

Name

users-volunteeractions.handled_by

Name

Source

Target

events-volunteeractions.event

Cardinality type:

One to

many

Ordinality:

Optional

Name

events-volunteeractions.event

Name

Source

Target