Difference between revisions of "GlobalSight database schema"
Jump to navigation
Jump to search
Globalwiki (talk | contribs) m (1 revision) |
Globalwiki (talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | + | {{Docset_side}} | |
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. | 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. | ||
Latest revision as of 09:44, 23 October 2014
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)
