// Copyright (c) 2004 Kurt M. Brown.
// This file is subject to the terms and conditions of the GNU General Public
// License. See the file COPYING for more details.

caLog
    caId       pk
    logId      pk
    when       created
    userId     who
    actionId   which kind of entry (action is why it was done)
    agentId    where did this action start?
    entry      semi-formated what

// boot should delete all rows
// crontask cleans as necessary
caProcessIndex // a row indicates pid is processing:
               // {caId, caTerminalId, (caTranId or caBatchId)}
    pid
    caId
    caTerminalId
        caTranId or
        caBatchId
    created

/////////////
// C O R E //
/////////////

encryptId (lookup code for real keys that are located elsewhere)
should be provided to daemon from ssh-agent
    public-key used to encrypt
    private-key used to decrypt
caEncrypt
    caEncryptId
    publicKey
    privateKey (encrypted) (use ssh-agent)

creditAccount // ca
    siteId      pk
    caId        pk
    created     tstz
    modified    tstz
    entry       xml

caTerminal
    siteId        pk
    caId          pk
    caTerminalId  pk
    nextTranSeq   int
    nextBatchSeq  int
    nextTranId    int
    nextBatchId   int
    created       tstz
    modified      tstz
    entry         xml

caBatch
    siteId        pk
    caId          pk
    caTerminalId  pk
    caBatchId     pk
    seq           int (mod 1000)
    created       tstz
    status        batchStatus
        processing
            failed
            passed
    entry         xml

caTran
    siteId        pk
    caId          pk
    caTerminalId  pk
    caTranId      pk
    seq           int (mod 10000)
    created       tstz
    modified      tstz
    encryptId     int (code for actual key)
    hold          bool (pre-auth) ?? merge with below state?
    encrypted:
        pan
        expdate
        holder
        ccv
        track
        address
    state         tranState
        settleReady
            ... (see below)
        processing
            cancelled
            declined
            settleReady (first state for (credit, offline)) or hold??
                hold
                    settleReady
                    void
                    settling
                void
                settling
                    settleReady (see above)
                    settled
                    settledFailed
    entry         xml

caBatchTran
    siteId        pk
    caId          pk
    caTerminalId  pk
    caBatchId     pk
    caTranId      pk
    status        batchTranStatus
    entry         xml