GlobalSight database schema
Jump to navigation Jump to search
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)