-
Notifications
You must be signed in to change notification settings - Fork 3
DB Schema
Kshitij Shah edited this page Sep 25, 2019
·
3 revisions
{
"chatRooms" : {
"addTrip" : {
"drivers" : {
"__unique_uder_id" : {
"__unique_id" : "__unique_message_id"
}
},
"riders" : {
"__unique_uder_id" : {
"__unique_id" : "-__unique_message_id"
},
"__unique_user_id" : {
"__unique_id" : "__unique_message_id",
"__unique_id" : "__unique_message_id"
}
}
},
"groupChatRoom" : {
"__unique_group_id" : {
"createdById" : "__unique_user_id",
"createdByName" : "Sahitya Chalamchalla",
"createdOn" : "09/25/2019 05:41:07",
"groupId" : "__unique_group_id",
"groupName" : "Charlotte Carpool",
"membersListWithOnlineStatus" : {
"__unique_user_id" : {
"displayName" : "John Williams",
"online" : true,
"profileLink" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=3f9b413c-5679-4db2-a9e4-2ea705b99dfb",
"userId" : "__unique_user_id"
},
"__unique_user_id" : {
"displayName" : "Sahitya Chalamchalla",
"online" : false,
"profileLink" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=dfbda8c5-addf-44cc-a6a2-f3054972a949",
"userId" : "__unique_user_id"
}
}
},
"__unique_group_id" : {
"createdById" : "__unique_user_id",
"createdByName" : "Sahitya Chalamchalla",
"createdOn" : "09/25/2019 05:41:28",
"groupId" : "__unique_group_id",
"groupName" : "Concord Carpool",
"membersListWithOnlineStatus" : {
"__unique_uder_id" : {
"displayName" : "Kevin Williams",
"online" : false,
"profileLink" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_uder_id.jpg?alt=media&token=f9df319c-abb5-43a0-8584-d283633b057b",
"userId" : "__unique_uder_id"
},
"__unique_user_id" : {
"displayName" : "abc abc",
"online" : false,
"profileLink" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=be4ffb2a-c69d-4b2f-8f76-c3a70ec84a02",
"userId" : "__unique_user_id"
},
"__unique_user_id" : {
"displayName" : "Sahitya Chalamchalla",
"online" : true,
"profileLink" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=dfbda8c5-addf-44cc-a6a2-f3054972a949",
"userId" : "__unique_user_id"
}
}
}
},
"messages" : {
"__unique_group_id" : {
"-__unique_message_id" : {
"createdBy" : "__unique_uder_id",
"createdByName" : "Kevin Williams",
"createdOn" : "09/25/2019 19:37:33",
"message" : "Trip has ended for the user",
"messageId" : "-__unique_message_id",
"messageType" : "tripEnd",
"notification" : false
}
},
"__unique_group_id" : {
"__unique_message_id" : {
"createdBy" : "__unique_uder_id",
"createdByName" : "Kevin Williams",
"createdOn" : "09/25/2019 19:30:38",
"likesUserId" : [ "__unique_user_id" ],
"message" : "Hey howdy?",
"messageId" : "__unique_message_id",
"messageType" : "textMessage",
"notification" : true
},
"__unique_message_id" : {
"createdBy" : "__unique_user_id",
"createdByName" : "Sahitya Chalamchalla",
"createdOn" : "09/25/2019 19:31:07",
"message" : "😁",
"messageId" : "__unique_message_id",
"messageType" : "textMessage",
"notification" : true
},
"__unique_message_id" : {
"createdBy" : "__unique_user_id",
"createdByName" : "Sahitya Chalamchalla",
"createdOn" : "09/25/2019 19:31:27",
"message" : "Trip has ended for the user",
"messageId" : "__unique_message_id",
"messageType" : "tripEnd",
"notification" : false
},
"__unique_message_id" : {
"createdBy" : "__unique_user_id",
"createdByName" : "Sahitya Chalamchalla",
"createdOn" : "09/25/2019 19:36:26",
"message" : "Trip Requested\nFrom: 9201 University City Blvd, Charlotte, NC 28223, USA\nTo:9201 University City Blvd, Charlotte, NC 28223, USA",
"messageId" : "__unique_message_id",
"messageType" : "tripRequest",
"notification" : false
}
}
},
"trips" : {
"__unique_message_id" : {
"driverAccepted" : {
"driverId" : "__unique_uder_id",
"driverLocation" : {
"latitude" : 35.3175997,
"longitude" : -80.7443819
},
"driverName" : "Kevin"
},
"endPoint" : {
"address" : "NoDa, Charlotte, NC, USA",
"id" : "__unique_id",
"latitude" : 35.2456474,
"longitude" : -80.80178769999999,
"name" : "NoDa"
},
"riderId" : "__unique_user_id",
"startPoint" : {
"address" : "430 Barton Creek Dr, Charlotte, NC 28262, USA",
"id" : "__unique_id",
"latitude" : 35.317734,
"longitude" : -80.74411900000001,
"name" : "430 Barton Creek Dr"
},
"tripStatus" : "COMPLETED"
},
"__unique_message_id" : {
"endPoint" : {
"address" : "800 S Mint St, Charlotte, NC 28202, USA",
"id" : "__unique_id",
"latitude" : 35.2258108,
"longitude" : -80.8528465,
"name" : "Bank of America Stadium"
},
"riderId" : "__unique_user_id",
"startPoint" : {
"address" : "9201 University City Blvd, Charlotte, NC 28223, USA",
"id" : "__unique_id",
"latitude" : 35.3070929,
"longitude" : -80.735164,
"name" : "UNC Charlotte"
},
"tripStatus" : "CREATED"
},
"-__unique_message_id" : {
"endPoint" : {
"address" : "800 S Mint St, Charlotte, NC 28202, USA",
"id" : "__unique_id",
"latitude" : 35.2258108,
"longitude" : -80.8528465,
"name" : "Bank of America Stadium"
},
"riderId" : "__unique_uder_id",
"startPoint" : {
"address" : "9201 University City Blvd, Charlotte, NC 28223, USA",
"id" : "__unique_id",
"latitude" : 35.3070929,
"longitude" : -80.735164,
"name" : "UNC Charlotte"
},
"tripStatus" : "COMPLETED"
}
},
"userProfiles" : {
"__unique_uder_id" : {
"city" : "Charlotte",
"emailId" : "[email protected]",
"firstName" : "Kevin",
"gender" : "MALE",
"id" : "__unique_uder_id",
"lastName" : "Williams",
"online" : false,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_uder_id.jpg?alt=media&token=f9df319c-abb5-43a0-8584-d283633b057b"
},
"__unique_user_id" : {
"city" : "vs",
"emailId" : "[email protected]",
"firstName" : "hsbz",
"gender" : "MALE",
"id" : "__unique_user_id",
"lastName" : "zbzg",
"online" : false,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=6f462153-a65b-4878-8aa4-b3901e5d8cb8"
},
"__unique_user_id" : {
"city" : "Charlotte",
"emailId" : "[email protected]",
"firstName" : "Dikshali",
"gender" : "FEMALE",
"id" : "__unique_user_id",
"lastName" : "Margaj",
"online" : true,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=570c74a6-f337-4244-934e-f4aff3b52d30"
},
"__unique_user_id" : {
"city" : "Charlotte",
"emailId" : "[email protected]",
"firstName" : "Kshitij",
"gender" : "MALE",
"id" : "__unique_user_id",
"lastName" : "Shah",
"online" : false,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=27441fb0-6ae4-4ce9-a9f1-7e855ce5d1d1"
},
"__unique_user_id" : {
"city" : "New York",
"emailId" : "[email protected]",
"firstName" : "Rachel",
"gender" : "FEMALE",
"id" : "__unique_user_id",
"lastName" : "Green",
"online" : false,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=5c4cd038-c541-4514-b5a9-102c0004402a"
},
"__unique_user_id" : {
"city" : "abc",
"emailId" : "[email protected]",
"firstName" : "abc",
"gender" : "MALE",
"id" : "__unique_user_id",
"lastName" : "abc",
"online" : false,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=be4ffb2a-c69d-4b2f-8f76-c3a70ec84a02"
},
"__unique_user_id" : {
"city" : "Charlotte",
"emailId" : "[email protected]",
"firstName" : "John",
"gender" : "MALE",
"id" : "__unique_user_id",
"lastName" : "doe",
"online" : false,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=e1880036-c8ca-4452-9469-6ff7df2ce916"
},
"__unique_user_id" : {
"city" : "Charlotte",
"emailId" : "[email protected]",
"firstName" : "Parth",
"gender" : "MALE",
"id" : "__unique_user_id",
"lastName" : "Mehta",
"online" : false,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=03a13217-9b80-440e-8729-e487c28c13b6"
},
"__unique_user_id" : {
"city" : "Herseys",
"emailId" : "[email protected]",
"firstName" : "Herseys",
"gender" : "FEMALE",
"id" : "__unique_user_id",
"lastName" : "Chocolate",
"online" : true,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=29920dc2-8256-409b-9cce-91887ff03de7"
},
"__unique_user_id" : {
"city" : "Charlotte",
"emailId" : "[email protected]",
"firstName" : "John",
"gender" : "MALE",
"id" : "__unique_user_id",
"lastName" : "Williams",
"online" : false,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=3f9b413c-5679-4db2-a9e4-2ea705b99dfb"
},
"__unique_user_id" : {
"city" : "Demo City",
"emailId" : "[email protected]",
"firstName" : "Demo",
"gender" : "FEMALE",
"id" : "__unique_user_id",
"lastName" : "User",
"online" : false,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=398400d7-6b5f-4a6f-9d0b-b55555e3c783"
},
"__unique_user_id" : {
"city" : "Hyderabad",
"emailId" : "[email protected]",
"firstName" : "Sahitya",
"gender" : "MALE",
"id" : "__unique_user_id",
"lastName" : "Chalamchalla",
"online" : true,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=dfbda8c5-addf-44cc-a6a2-f3054972a949"
},
"__unique_user_id" : {
"city" : "Charlotte",
"emailId" : "[email protected]",
"firstName" : "Pranay",
"gender" : "MALE",
"id" : "__unique_user_id",
"lastName" : "Jain",
"online" : false,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=bdcd34e2-d11e-4f66-a417-d0fffff19397"
},
"__unique_user_id" : {
"city" : "Boston",
"emailId" : "[email protected]",
"firstName" : "Kunal",
"gender" : "MALE",
"id" : "__unique_user_id",
"lastName" : "Bajpai",
"online" : true,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=1df44aa4-00ee-4b07-a8ce-47543f94bd1d"
},
"__unique_user_id" : {
"city" : "Thane",
"emailId" : "[email protected]",
"firstName" : "Dishank",
"gender" : "MALE",
"id" : "__unique_user_id",
"lastName" : "Patil",
"online" : false,
"userProfileImageUrl" : "https://firebasestorage.googleapis.com/v0/b/advance-mobile-app-dev.appspot.com/o/chatRooms%2FuserProfiles%2F__unique_user_id.jpg?alt=media&token=d06c8933-61e8-433d-be45-ea720571f01a"
}
}
}
}