Difference between revisions of "GlobalSight database schema"
Jump to navigation
Jump to search
m (Protected "GlobalSight database schema" ([edit=autoconfirmed] (indefinite) [move=autoconfirmed] (indefinite))) |
Globalwiki (talk | contribs) m (1 revision) |
(No difference)
| |
Revision as of 03:39, 14 October 2014
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)
