BuildForSDG/Team-203-TranSafe

[FEATURE] Designing the database structure in firebase firestore

Closed this issue · 0 comments

Is your feature request related to a problem? Please describe.
Design the database structure for app's data management
Describe the solution you'd like
Create database schema in firebase filestore to have the following documents

  1. User document:
    [ UserID (unique), Username,UserPhoneNo,UserRiskLevel,CreatedDate,CreatedTime,ModifiedDate,ModifiedTime]
  2. Speed Collection:[SpeedID,UserID,UserSpeed,SpeedLimit,Location, LocationType, IsOverspeed,Overspeed duration,VehicleNo,CreatedDate,CreatedTime,ModifiedDate,ModifiedTime]
  3. NotificationSetting document:[UserID,DurationBased, MarginBased, Duration, Margin,CreatedDate, CreatedTime, ModifiedDate, ModifiedTime]
  4. NotificationQueue document:[UserID,SpeedID,Subject, Message, PhoneNo, IsSent, CreatedDate,CreatedTime,ModifiedDate,ModifiedTime]
  5. VehicleRating document:[VehicleRateID,VehicleNo,Rate,CreatedDate,CreatedTime,ModifiedDate,ModifiedTime]
    6.UserRating document: [UserRateID,UserID,Rate,CreatedDate,CreatedTime,ModifiedDate,ModifiedTime]

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.