// 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.

site
    siteId  pk -- matches accountId
    name
    created

accessGroup
    siteId        pk
    accessGroupId pk

user agent accessor
    siteId   pk
    userId   pk
    name     ak
    password
    created

action
    actionId  pk
    name
    # description -- lookup into locale

agent
    # standard: command-line(id), terminal(terminalId), web(ipaddr)
    siteId    pk
    agentId   pk
    name
    key

log
    siteId     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

account
    accountId   pk
    entry       xml

terminal
    accountId   pk
    terminalId  pk
    entry       xml

batch
    accountId   pk
    terminalId  pk
    batchId     pk
    entry       xml

transaction
    accountId   pk
    terminalId  pk
    batchId     fk
    entry       xml

batch-transaction
    accountId   pk
    terminalId  pk
    batchId     fk