{
   # mandatory
   '_id'       : 'synthetic mongo ID',
   'dut'       : 'Name of test physical machine'
   'build'     : 'Name of build, e.g. cam-oeprod-122725-master',
   'time'      : 'Build time'
   'value'     : 'floating point boot time in secodns'
 }

 {
   # mandatory
   '_id'     : 'git tag name',
   'build_id': 'numeric build ID in tag',
   'build_type' : 'e.g. oedev or oetest',
   'branch'  : 'git branch',
   'tag_time': 'epoch timestamp when tag was created',
   'blame'   : 'list of people who contribute commits that triggered this build',
   'commits' : 'list of (short name:repo string, cgit url[, commit message]) for each commit that triggered this build. The commit message is present in newer results',
   # optional  
   'tests': {
 'passes': number of test passes,
 'failures': number of non-infrastructure test failures,
 'total_cases': number of test cases,
 'run_cases': number of test cases that have passed
   }
   'test_status':  ['epoch time', 'DUT', 'text']
   'platform': {
   'build_time'     : 'epoch timestamp when build was created, if that happened',
   'buildbot_number': 'buildbot sequence number',
   'buildbot_url'   : 'buildbot url to the build result summary',
   'eta_time'       : 'when the build system thinks the build will complete',
   'failure'        : 'english text describing reason for build failure',
   'status'         : 'english text describing build status',
   'failure_log_url': 'URL for failure stdio log on buildbot',
   } 
   'site': 'site of build e.g. cam',
   'synchronizer': ... similar subrecord to platform
   'tests':  {
  'passes': 'number of BVT passes', 
  'failures': 'number of BVT failures,
  'in_progress' : 'number of BVT tests running'},
   'failure_specimens': {
   'test case 1' : 'copy of result record',
   'test case 2' : 'copy of result record'
},
   'failure_email': 'set to a specific value when an email failure has been sent',
   'releases': 'if set, a list of release names for this build'
 }

 {
   # mandatory
   'whiteboard' : 'whiteboard text to set when classifier triggers',
   'owner': 'person who is current responsible for the accuracy of this classifier, e.g. "Dickon Reed <dickon.reed@example.com>"',

   # optional
   'result_id' : 'foreign key to results._id where this classifier specifically applies',
   'failure_regexp' : 'regular expression matching failure string',
   'test_case_regexp' : 'regular expression matching test description'
   'dut_regexp' : 'regular expression matching dut',
   'earliest_build': 'earliest build date that is appropriate'
 }

 {
  # mandatory
  'dut' : 'the dut that was changed',
  'epoch': 'epoch seconds when change happen',
  'hostname': 'machine where change made',
  'pid': 'process which made change',
  'uid': 'user ID which made change',
  'localtime': 'local time when change was made'
 }

{ 
  # mandatory
  '_id': 'ID of test machine (labelling system ID if there is one else muppet name)'

  # optional
  'branches' : 'list of branches to test',
  'tag_regexp' : 'if specified tag must match this regexp; overrides branches',
  'mem': 'megabytes of RAM in the machine',
  'run_bvt' : '1 if BVT should be run when machine is idle, has no relevant queued jobs, and has a null owner field. 0 if BVT should never be run automatically on this machine.',
  'owner' : 'name of person who owns machine; if set, do not use for automatic test launches',
  'source_tree' : 'source tree on server to be used for automation',
  'install_branch' : 'branch to test on this machine',
  'last_launch_time' : 'epoch timestamp when test last started',
  'last_kick_time' : 'last time monitor_builds restarted the test automation',
  'last_finish_time': 'epoch timestamp when test last finished'
  'name': 'short name of device under test'
  'control_machine': 'machine used for automated testing for this machine',
  'power_control' : 'AMT or franken3 or similar',
  'control_pid' : 'process currently running automated test for this machine',
  'owner': 'Name of person currently owning the machine',
  'experiments':'Instead of running BVT, run experiments.py with these options',
  'development_mode': 'If set, exclude results on this dut from all reports',
  'result_id':'ID of current test in progress', 
  'notes':'text field describing stuff about machine',
  'control_command_line':'command line controlling machine'
  'test_failed':'set to true when a test has failed; removed when a fresh installation is done',
  'reactivation_time':'if set, do not run tests until this epoch time has passed. Used to prevent busy looping on rapidly failing tests'
  'serial_port':'host:sympathy socket number e.g. igor:s1-1'
  'platform' : 'chipset generation, e.g. "calpella"'
}

{
 # mandatory
 '_id' : 'synthetic mongo ID',
 'user': 'email address of person who submitted job',
 'command': 'command to run, with -m added for dut name, e.g. ["experiments", "-n"],
 'timeout': 'maximum run time of test, in seconds (e.g. 600)',
 'status' : ' "queued" if waiting or "running on ladytwo" if running on a specific mahcine', 
 'control_pid' : 'process ID of launch process'
 'dut': 'dut ID to run on, or None',
 'submit_time': 'epoch seconds when job was submitted',
 # optional
 'launch_time': 'epoch seconds when job was launched',
 'finish_time' : 'epoch seconds since job finsihed'
}

{ 
 # mandatory
 _id: 'FQDN to use',
 site: 'site name, e.g. CAMBRIDGE',
 allocation_time: 'time name last used'
 release_time: 'time lease on name expires',
 access_time: 'time name last referenced',
 # optional
 purpose: 'purpose to use name for, e.g. synchronizer-cam-oeprod-123456-master',
}

{
 # mandatory
 'kind': 'english describing database access type',
 'start_time': 'epoch seconds when access started',
 'run_time': 'seconds taken to do access',

 # optional
 'constraints': 'constraint string'
}

{ 
  # mandatory
  '_id' : 'release name e.g Glenn-XT-3.0.1-RC4'
  'build': 'e.g. cam-oeprod-130270-release-glenn-sp1'
}

{ 
  # mandatory
  '_id' : 'synthetic mongo ID',
  'start_time' : 'epoch timestamp of test start',

  # optional
  'build' : 'build name, e.g. "cam-oeprod-123450-mater"',
  'end_time : 'epoch timestmap of test end'
  'dut' : 'dut _id for this test',
  'dut_name' : 'dut name for this test',
  'git_id' : 'git version ID of source code of automation used for test',
  'test_case' : 'descrption of test case, or the command line if that is not known'
  'failure' : 'failure desription; test is deemed failed if this exists. Do not set for tests that pass'
  'whiteboard': 'english text describing problem'
  'infrastructure_problem': 'this problem is with infrastructure rather than product'
  'development_mode': 'copied from the duts record if defined when the test happened. If this is set, exclude this result from reports'
  'exception': 'the name of an exception which created a failure'
}
db.results.ensureIndex({'end_time':1})
db.results.ensureIndex({'build':1})
db.results.ensureIndex({'infrastructure_problem':1}) # for bvt.git/count.py
db.results.ensureIndex({'failure':1}) # for bvt.git/count.py

{ 
  'highwater' : 'epoch timestamp of the latest record added to the coverage collection'
}

{
  '_id': 'non-negative sequential integer from 0'
  'description': 'english description of the test case'.
  'ignored_for_completion_count': '1 if the test case should be excluded from coverage analysis'
  'platform': True iff a platform (i.e. test device) is needed for this test
}

db.createCollection("logs", {capped:true, size:1000*1000*1000*10})
db.logs.ensureIndex({result_id:1})
db.logs.ensureIndex({dut_name:1}) 
{ 
  # mandatory
  '_id' : 'synthetic mongo ID',
  'message': 'test message in English',
  'kind': 'one english word describing message type, e.g. HEADLINE or PROBLEM',
  'time': 'epoch timestamp fo log entry'
  #optional
  'result_id' : '_id of results collection document associated with this log entry',
  'job_id' : '_id of jobs collection document associated with log entry',
  'dut_name': 'name of dut associated with log entry',
  'dut_id': '_id of dut associated with log entry'
 }

{ 
 # mandaotry
  'repository': 'repository path',
  'revision': 'full revision hash',
  'author': 'person who did commit',
  'commit_timestamp': 'epoch time of commit'
  'timestamp': 'epoch time of push',
 #optional
  'tag': 'tag name' 
}

{
 # manadtory
  '_id' : 'synthetic  mongo ID',
  'action' : 'english description of udpate',

  # optional
  'repository': 'repository path affected'
  'revision' :    'revision affected'
  'result_id' : 'result_id affected'
}