GlobalSight database schema

The following section is meant to document the database schema and the table contents. Tables are listed alphabetically, comments are listed after the column names.

COST_BY_WORD_COUNT
   COST_ID -> FK; points to the COST table

COST
  COSTABLE_OBJECT_TYPE: "J", "W", and "T" are Job, Workflow, and Task. (This part is actually controlled by Hibernate, so this info is in the HBM file envoy/src/java/com/globalsight/persistence/hibernate/xml/Cost.hbm.xml)
  RATE_TYPE: "E" and "R" are "Expense" and "Revenue", respectively. (cf. -- envoy/src/java/com/globalsight/everest/costing/Cost.java)