GlobalSight database schema

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)