Skip to content
This repository was archived by the owner on Nov 13, 2022. It is now read-only.

Current Intersection database schema structure

Andrew@TW edited this page Apr 7, 2019 · 1 revision
{
    refIns: {
        type: String,
        required: true
    },
    bottom: {
        left: {
            amount: {
                type: Number,
                default: 0,
                required: true,
                minimum: 0
            },
            queue: [{
                refCar: String,
                arriveTime: {
                    type: Date
                }
            }]
        },
        straight: {
            amount: {
                type: Number,
                default: 0,
                required: true,
                minimum: 0
            },
            queue: [{
                refCar: String,
                arriveTime: {
                    type: Date
                }
            }]
        },
        right: {
            amount: {
                type: Number,
                default: 0,
                required: true,
                minimum: 0
            },
            queue: [{
                refCar: String,
                arriveTime: {
                    type: Date
                }
            }]
        }
    },
    right: {
        left: {
            amount: {
                type: Number,
                default: 0,
                required: true,
                minimum: 0
            },
            queue: [{
                refCar: String,
                arriveTime: {
                    type: Date
                }
            }]
        },
        straight: {
            amount: {
                type: Number,
                default: 0,
                required: true,
                minimum: 0
            },
            queue: [{
                refCar: String,
                arriveTime: {
                    type: Date
                }
            }]
        },
        right: {
            amount: {
                type: Number,
                default: 0,
                required: true,
                minimum: 0
            },
            queue: [{
                refCar: String,
                arriveTime: {
                    type: Date
                }
            }]
        }
    },
    top: {
        left: {
            amount: {
                type: Number,
                default: 0,
                required: true,
                minimum: 0
            },
            queue: [{
                refCar: String,
                arriveTime: {
                    type: Date
                }
            }]
        },
        straight: {
            amount: {
                type: Number,
                default: 0,
                required: true,
                minimum: 0
            },
            queue: [{
                refCar: String,
                arriveTime: {
                    type: Date
                }
            }]
        },
        right: {
            amount: {
                type: Number,
                default: 0,
                required: true,
                minimum: 0
            },
            queue: [{
                refCar: String,
                arriveTime: {
                    type: Date
                }
            }]
        }
    },
    left: {
        left: {
            amount: {
                type: Number,
                default: 0,
                required: true,
                minimum: 0
            },
            queue: [{
                refCar: String,
                arriveTime: {
                    type: Date
                }
            }]
        },
        straight: {
            amount: {
                type: Number,
                default: 0,
                required: true,
                minimum: 0
            },
            queue: [{
                refCar: String,
                arriveTime: {
                    type: Date
                }
            }]
        },
        right: {
            amount: {
                type: Number,
                default: 0,
                required: true,
                minimum: 0
            },
            queue: [{
                refCar: String,
                arriveTime: {
                    type: Date
                }
            }]
        }
    }
}

Clone this wiki locally