Document Database Model

Project Title: F1DB

Team Name: dr

Relational Mapping

The following 4 collections correspond to the 12 tables found in schema.png.

• Race Event
  • raceid
  • location
  • date
• Team
  • team
  • raceevent
• Person
  • room
  • room_feature
  • feature
• Kit
  • container_id
• Shipment
  • shipment_id
  • current_location
  • destination
  • method
  • created_by
  • status
• Container
  • ConID
  • ShipmentID
  • CriticalContainer
  • Status
  • UpdatedBy
• Kit
  • KitID
  • OwnerID
  • TypeOfKit
  • TeamID
  • TotalWeight
  • KitSize
• KitContents
  • KitID
  • PartID
  • PartName
  • PartDesc
  • PartWeight

The Race Event Collection

The location, date, and creator are stored in the Race Event Collection. Since race events are usually created in advance, the location and date are predetermined and don’t often change (except in rare circumstances). The Creator of the race does not change. A link (dbms specific) is stored to the person who created the event (race event organizer). This is linked with our Person collection.

{
    'raceid': '322',
    'location': 'Canada',
    'official_name': '2024 Canadian Grand Prix'
    'date': '03-24-2024',
    'creator': {
        'id': '10',              # DBMS-specific linking
        'name': 'Frances Baguette',
    }
}

The Shipment Collection

The Shipment Collection stores information about the transportation of containers for a race event. Each shipment includes its current location, destination, and method of transport, which may vary depending on logistical needs. Shipments are linked to the race they support and are created by an organizer, with a (DBMS specific) link to the Person Collection. Containers within the shipment, including critical status and their contents, are nested for easy tracking and management.

{
    "shipmentid": "5002",
    "raceid": "1100",
    "currentlocation": "Saudian Arabian Grand Prix",
    "destination": "Australian Grand Prix",
    "method": "Submarine",
    "createdby": {
        "id": "10",  # DBMS specific linking
        "name": "Dragan Scholl"
    },
    "status": "Arrived",
    "containers": [
        {
            "conid": "6020",
            "critical": True,
            "status": "Submarine",
            "updatedby": {
                "id": "14",  # DBMS specific linking
                "name": "Chloë Hemma van Allemanië"
            }
        }
    ]
}

The Container collection

The container collection contains information about the amount of kits in each container. These containers contain a id, the id of the shipment that the container is on, the status of the container, if it is loaded or not, and who it was updated by. The ContainerContents table connectes the Container to the specific kits that are in the container.

{
    "ConID": "6000",
    "ShipmentID": "5000",
    "CriticalContainer": "True",
    "Status": "Arrived",
    "method": "In-Transit",
    "UpdatedBy": 0,
    "ContainerContents": 
    [
        "ContainerContents": {
            "ConID": "6000",
            "KitID": "7000"
        }
    ]
}

Kit Collection

The kit collection contains information about the kits stored in the container. These kits contain an ID, the ID of the person who owns it, the ID of a team who owns the kit, the total weight of the parts in the kit, and the size of the kit based on the weight.

{
    "KitID": "7000"
    "OwnerID": "2",
    "TeamID": "1",
    "TotalWeight": "71",
    "KitSize": "large", 
    [
        "KitContents": {
        "KitID": "7000",
        "PartID": "10000",
        "PartName": "Transmission cover",
        "PartDesc": "Protects transmission componets",
        "PartWeight": "71"
        }
    ]
}

KitContents

The KitContents contains information about the specific part being stored in the Kit. The table contains a ID for the kit it is being stored in, the ID of the part in the kit, the name of the part, a short descripition, and the weight of the part(s).

{
    "KitID": "7000",
    "PartID": "1000",
    "PartName": "Transmission Cover",
    "PartDesc": "Protects transmission components",
    "PartWeight": "71"
}