gistfile1.txt

var schema = {
    'bankLogins': {
        dynamodbTable : 'loans',
        primaryKey    : ['loanId', 'recordId'],
        indexes: {
            loanId   : {
                column : 'loanId'
            },
            loanId   : {
                column : 'recordId'
            }
        },
        children: {
            bankAccounts: {
                foreignKeyReference : ['loanId', 'recordId'],
                foreignKey          : ['loanId', 'recordId'],
                docRoot             : '_documentData',
                recordType          : 'array'
            }
        },
        columns: {
            loanId: {
                mapField  : 'loanId',
                type      : 'VARCHAR(255)'
            },
            clientId: {
                mapField  : 'clientId',
                type      : 'VARCHAR(255)'
            },
            loginId: {
                mapField  : '_document.recordId',
                type      : 'VARCHAR(255)'
            }
        }
    },

    'bankAccounts': {
        primaryKey    : ['loanId', 'recordId', 'accountNumberFound'],
        indexes: {
            loanId   : {
                column : 'loanId'
            },
            loanId   : {
                column : 'recordId'
            }
        },
        children: {
            bankTransactions: {
                foreignKeyReference : ['loanId', 'recordId'],
                foreignKey          : ['loanId', 'recordId'],
                docRoot             : '_documentData.ficoScore',
                recordType          : 'array'
            }
        },
        columns: {
            loanId: {
                mapField  : 'loanId',
                type      : 'VARCHAR(255)'
            },
            clientId: {
                mapField  : 'clientId',
                type      : 'VARCHAR(255)'
            },
            loginId: {
                mapField  : '_document.recordId',
                type      : 'VARCHAR(255)'
            },
            accountNumberFound: {
                mapField  : '_documentData.AccountNumberFound',
                type      : 'VARCHAR(255)'
            },
            routingNumberFound: {
                mapField  : '_documentData.RoutingNumberFound',
                type      : 'VARCHAR(255)'
            }
        }
    },

    'bankTransactions': {
        dynamodbTable : 'loans',
        primaryKey    : ['loanId', 'recordId'],
        indexes: {
            loanId   : {
                column : 'loanId'
            },
            loanId   : {
                column : 'recordId'
            }
        },
        children: {
            bankAccounts: {
                foreignKeyReference : ['loanId', 'recordId'],
                foreignKey          : ['loanId', 'recordId'],
                docRoot             : 'transactions',
                recordType          : 'array'
            }
        },
        columns: {
            loanId: {
                mapField  : 'loanId',
                type      : 'VARCHAR(255)'
            },
            clientId: {
                mapField  : 'clientId',
                type      : 'VARCHAR(255)'
            },
            loginId: {
                mapField  : '_document.recordId',
                type      : 'VARCHAR(255)'
            }
        }
    }
};

module.exports = schema;