GlobalSight database schema

From Globalsight
Revision as of 04:39, 14 October 2014 by Globalwiki (talk | contribs) (1 revision)
Jump to navigation Jump to search

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)