mongo.md

MongoDB

• Has 1 database called chekchat

• Database's collections: users, friends, friend_requests, missions, notifications, rooms, messages, sessions, feedbacks

• Collections' schema:

  • users {
    username,
    email,
    password,
    avatarURL,
    notificationCount
    }

  • friends {
    userId: <ObjectID ref to users schema>,
    friendId: <ObjectID ref to users schema>
    }

  • friend_requests {
    fromuser: <_ObjectID ref to users schema>,
    touser: <_ObjectID ref to users schema>,
    status
    }

  • missions {
    subject,
    duedate,
    from_user: <_ObjectID ref to users schema>,
    touser: <_ObjectID ref to users schema>,
    description,
    status,
    completed,
    starred,
    visibility,
    sent_date
    }

  • notifications {
    fromuser: <_ObjectID ref to users schema>,
    touser: <_ObjectID ref to users schema>,
    type,
    text,
    clicked,
    time
    }

  • feedbacks {
    subject,
    from_user,
    submitted_date,
    comment
    }

  • sessions {
    store users' cookie sessions
    }

  • rooms {
    missionId: <ObjectID ref to missions schema>,
    fromuser: <_ObjectID ref to users schema>,
    touser: <_ObjectID ref to users schema>,
    notified: <Boolean>,
    last_updated,
    lastMessage
    }

  • messages {
    fromuser: <_ObjectID ref to users schema>,
    roomId: <ObjectID ref to rooms schema>,
    sentdatetime: <_Date>,
    message
    }