Database schema: jcr

DBMS: postgres8

Schema for the Java Code Review tool (JCR)

Tables
filecomment Review comments made against lines in a file
fileset Represents a set of files that can be used by one or more review projects.
Each set can be either uploaded as a tarball, or extracted from source control
project Represents a code review project
projectcomment Review comments made against a project thread
projectfile Represents a file within a project that has been selected for review
projectstatus Records the history of status changes to each project
projectthread Groups together project-level comments with a common title, like an email thread
systemuser Records details of a user authorised to use JCR

Sequences
tableids Sequence used to generate system IDs (primary keys) for all tables