GlobalSight database schema
Revision as of 03:57, 18 October 2010 by Techwriter (talk) (Protected "GlobalSight database schema" ([edit=autoconfirmed] (indefinite) [move=autoconfirmed] (indefinite)))
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)
